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_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