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	Default Value1	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. ↩︎

DYNAMIC_TENORS, DYNAMIC_MATURITIES, DYNAMIC_MONEYNESS

SENSI_LADDERS_VECTOR

⌘I

​Unique Key

​Incoming Joins

Unique Key

Incoming Joins