SENSI_LADDERS_VECTOR

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

SENSI_LADDERS

SPLIT_RATIO_MARKET_DATA

⌘I

​Unique Key

​Outgoing Joins

Unique Key

Outgoing Joins