Navigation :
CSRBUCKET_DESC
note
While this table is currently required in the DirectQuery database schema, it will be removed in a future version.
The CSRBUCKET_DESC table provides canonical descriptions for the CSR buckets.
| Column Name |
Type |
Not Null |
Description |
| AS_OF_DATE |
DATE |
Y |
Timestamp (at close of business) for the data. |
| RISK_CLASS |
STRING |
Y |
The risk-class (“CSR non-Sec”, “CSR Sec non-CTP”, “CSR Sec CTP”) |
| BUCKET |
STRING |
Y |
The Bucket the Underlying belongs to. |
| RATING_CATEGORY |
STRING |
|
The canonical name for the bucket rating. |
| SECTOR_CATEGORY |
STRING |
|
The canonical name for the bucket sector. |
Unique Key
| Columns |
| AS_OF_DATE |
| RISK_CLASS |
| BUCKET |
Incoming Joins
| Source Table |
Source Columns |
Target Columns |
| UNDERLYING_DESCRIPTION |
AS_OF_DATE
RISK_CLASS
BUCKET |
AS_OF_DATE
RISK_CLASS
BUCKET |