☰
Navigation :

SENSI_LADDERS

The SENSI_LADDERS table contains the definition of sensitivity ladder shifts. The ladder shift vectors are present in the SENSI_LADDERS_VECTOR table.

Column Name Type Not Null Cube Field 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).

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

  1. 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.  ↩︎