LegalEntityHierarchy

The LegalEntityHierarchy store contains the multi-level legal entity organizational structure. It is built from the LegalEntityParentChild store.

It is indexed by LegalEntity and AsOfDate and referenced from the TradeMapping store by these two fields.

Store Field Key CanBeNull Type (+Default Value - if applicable) Cube Field Description
AsOfDate Y LOCALDATE[yyyy-mm-dd] Timestamp (at close of business) for the data.
LegalEntity Y String [Legal Entities].[Legal Entity] Leaf node of the legal entity hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 5.
HierarchyLevel1 String("_DATAMEMBER_") See knowledgebase Level 1 Node at level 1 of the legal entity hierarchy.
HierarchyLevel2 String("_DATAMEMBER_") See knowledgebase Level 2 Node at level 2 of the legal entity hierarchy.
HierarchyLevel3 String("_DATAMEMBER_") See knowledgebase Level 3 Node at level 3 of the legal entity hierarchy.
HierarchyLevel4 String("_DATAMEMBER_") See knowledgebase Level 4 Node at level 4 of the legal entity hierarchy.
HierarchyLevel5 String("_DATAMEMBER_") See knowledgebase Level 5 Node at level 5 of the legal entity hierarchy.