TRADE_MAPPING

The TRADE_MAPPING store maps trades to books, desks and legal entities.

Column Name Type Not Null Cube Field Description
AS_OF_DATE DATE Y Timestamp (at close of business) for the data.
TRADE_KEY STRING Y Unique Trade (or Position) ID.
BOOK STRING Y Books The book to map the trade to (must match the node in the Book Hierarchy).
LEGAL_ENTITY STRING Y Legal Entities Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).
TRADE_DATE DATE TradeDates The date on which the trade took place.

Unique Key

Columns
AS_OF_DATE
TRADE_KEY

Incoming Joins

Source Table Source Columns Target Columns Cube
SASENSITIVITIES AS_OF_DATE
TRADE_KEY
AS_OF_DATE
TRADE_KEY
StandardisedApproachCube
IMATRADES AS_OF_DATE
TRADE_KEY
AS_OF_DATE
TRADE_KEY
InternalModelApproachCube

Outgoing Joins

Target Table Source Columns Target Columns
BOOK_DESCRIPTON AS_OF_DATE
BOOK
AS_OF_DATE
BOOK
BOOK_HIERARCHY AS_OF_DATE
BOOK
AS_OF_DATE
BOOK
LEGAL_ENTITY_HIERARCHY AS_OF_DATE
LEGAL_ENTITY
AS_OF_DATE
LEGAL_ENTITY
LEGAL_ENTITY_ATTRIBUTES AS_OF_DATE
LEGAL_ENTITY
AS_OF_DATE
LEGAL_ENTITY