CSRBUCKET_DESC
The CSRBUCKET_DESC table provides canonical descriptions for the CSR buckets.
| Column Name | Type | Not Null | Cube Field | Description |
|---|---|---|---|---|
| AS_OF_DATE | DATE | Y | See field in joined table (UNDERLYING_DESCRIPTION) | Timestamp (at close of business) for the data. |
| RISK_CLASS | STRING | Y | See field in joined table (UNDERLYING_DESCRIPTION) | The risk-class (“CSR non-Sec”, “CSR Sec non-CTP”, “CSR Sec CTP”) |
| BUCKET | STRING | Y | See field in joined table (UNDERLYING_DESCRIPTION) | The Bucket the Underlying belongs to. |
| RATING_CATEGORY | STRING | - CSR non-Sec Rating Category - CSR Sec non-CTP Rating Category - CSR Sec CTP Rating Category |
The canonical name for the bucket rating. | |
| SECTOR_CATEGORY | STRING | - CSR non-Sec Sector Category - CSR Sec non-CTP Sector Category - CSR Sec CTP Sector Category |
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 |