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