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