SENSI_LADDERS - Atoti Hub

The SENSI_LADDERS table contains the definition of sensitivity ladder shifts. If you are using a database that does not support native vector aggregation, the SCALE field is omitted and the ladder vectors are present in the SENSI_LADDERS_VECTOR table.

Column Name	Type	Not Null	Cube Field	Default Value¹	Description
AS_OF_DATE	DATE	Y			Timestamp (at close of business) for the data.
RISK_CLASS	STRING	Y		N/A	The risk class for which the ladder scale is defined.
SHIFT_TYPE	STRING	Y		R	The type of the scale (‘A’ for absolute, ‘R’ for relative).
SCALE	`ARRAY<DOUBLE>`	Y			The ladder shift vector. This field is omitted if the database does not support native vector aggregation.

Unique Key

Columns
AS_OF_DATE
RISK_CLASS

Incoming Joins

Source Table	Source Columns	Target Columns
SENSI_LADDERS_VECTOR	AS_OF_DATE RISK_CLASS	AS_OF_DATE RISK_CLASS

If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields. ↩