Navigation :
DESK_DESCRIPTION
The DESK_DESCRIPTION table contains the desk descriptions.
| Column Name |
Type |
Not Null |
Cube Field |
Description |
| AS_OF_DATE |
DATE |
Y |
See field in joined table (BOOK_DESK_MAPPING) |
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]. |
| IRT_DESK |
STRING |
|
IRT Desk |
Indicates whether the desk is an IRT desk. ACR is calculated separately for desks flagged as IRT. |
Unique Key
Incoming Joins
| Source Table |
Source Columns |
Target Columns |
| BOOK_DESK_MAPPING |
AS_OF_DATE
DESK |
AS_OF_DATE
DESK |