Navigation :
LEGAL_ENTITY_HIERARCHY
The LEGAL_ENTITY_HIERARCHY table contains the multi-level legal entity organizational structure.
| Column Name |
Type |
Not Null |
Cube Field |
Description |
| AS_OF_DATE |
DATE |
Y |
|
Timestamp (at close of business) for the data. |
| LEGAL_ENTITY |
STRING |
Y |
|
Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15. |
| HIERARCHY_LEVEL1 |
STRING |
|
Level 1 |
Node at level 1 of the book hierarchy. |
| HIERARCHY_LEVEL2 |
STRING |
|
Level 2 |
Node at level 2 of the book hierarchy. |
| HIERARCHY_LEVEL3 |
STRING |
|
Level 3 |
Node at level 3 of the book hierarchy. |
| HIERARCHY_LEVEL4 |
STRING |
|
Level 4 |
Node at level 4 of the book hierarchy. |
| HIERARCHY_LEVEL5 |
STRING |
|
Level 5 |
Node at level 5 of the book hierarchy. |
Unique Key
| Columns |
| AS_OF_DATE |
| LEGAL_ENTITY |
Incoming Joins
| Source Table |
Source Columns |
Target Columns |
| TRADE_MAPPING |
AS_OF_DATE
LEGAL_ENTITY |
AS_OF_DATE
LEGAL_ENTITY |