SENSI_LADDERS_VECTOR - Atoti Hub

The SENSI_LADDERS_VECTOR table contains the values of the sensitivity ladder shift. This table is created when using a database that does not support native vector aggregation. If vector aggregation is supported, the ladder vector is stored as an array in the SENSI_LADDERS table.

Column Name	Type	Not Null	Cube Field	Default Value¹	Description
VECTOR_INDEX	INT	Y			Index in the ladder shift vector.
AS_OF_DATE	DATE	Y			Timestamp (at close of business) for the data.
RISK_CLASS	STRING	Y		N/A	The risk class that the ladder scale is defined for.
SCALE	DOUBLE	Y		0.0	The ladder shift.

Unique Key

Columns
VECTOR_INDEX
AS_OF_DATE
RISK_CLASS

Outgoing Joins

Target Table	Source Columns	Target Columns
SENSI_LADDERS	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. ↩