> ## 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.

# SENSI_LADDERS

The SENSI\_LADDERS table contains the definition of sensitivity ladder shifts.

If you are using a database that does not [support native vector aggregation](https://docs.activeviam.com/products/atoti/server/6.1.11/docs/directquery/directquery-vectors/#native-support),
the SCALE field is omitted and the ladder vectors are present in the [SENSI\_LADDERS\_VECTOR](./sensi_ladders_vector) table.

| Column Name  | Type            | Not Null | Cube Field | Default Value[1](#fn:1) | 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](https://docs.activeviam.com/products/atoti/server/6.1.11/docs/directquery/directquery-vectors/#native-support). |

## Unique Key

<table><thead><tr><th>Columns</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td></tr><tr><td>RISK\_CLASS</td></tr></tbody></table>

## Incoming Joins

<table><thead><tr><th>Source Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./sensi_ladders_vector">SENSI\_LADDERS\_VECTOR</a></td><td>AS\_OF\_DATE<br />RISK\_CLASS</td><td>AS\_OF\_DATE<br />RISK\_CLASS</td></tr></tbody></table>

***

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.
    [↩︎](#fnref:1)