Navigation :
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 |
Outgoing Joins