| Column Name | Type | Not Null | Cube Field | Description |
|---|---|---|---|---|
| BOOK | STRING | Y | Leaf node of the book hierarchy. | |
| DESK | STRING | Y | Desks | The desk to which the book belongs. |
| AS_OF_DATE | DATE | Y | See field in joined table (SASENSITIVITIES) | Timestamp (at close of business) for the data. |
Unique Key
| Columns |
|---|
| AS_OF_DATE |
| BOOK |
Incoming Joins
| Source Table | Source Columns | Target Columns |
|---|---|---|
| TRADE_MAPPING | AS_OF_DATE BOOK | AS_OF_DATE BOOK |