| Column Name | Type | Not Null | Cube Field | Description |
|---|---|---|---|---|
| AS_OF_DATE | DATE | Y | See field in joined table (BOOK_DESCRIPTION) | Timestamp (at close of business) for the data. |
| DESK | STRING | Y | Desks | The desk to which the book belongs. This will match one of the non-_DATAMEMBER_ nodes in levels 1 - 15. |
| FRTB_DESK_MODEL | STRING | FRTB Model | Specifies whether the desk should be treated as IMA or SA for the capital charge calculations. | |
| PLA_ZONE | STRING | PLA Zone | Indicates which zone the desk falls into according to the PLA test metrics MAR32.42. |
Unique Key
| Columns |
|---|
| AS_OF_DATE |
| DESK |
Incoming Joins
| Source Table | Source Columns | Target Columns |
|---|---|---|
| BOOK_DESCRIPTION | AS_OF_DATE DESK | AS_OF_DATE DESK |