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.Documentation Index
Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
Use this file to discover all available pages before exploring further.
| 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). | |
| 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. ↩︎