LEGAL_ENTITY_PARENT_CHILD

The LEGAL_ENTITY_PARENT_CHILD table contains the parent/child relationships used to build the legal entity hierarchy.

The LEGAL_ENTITY_HIERARCHY table is populated from the LEGAL_ENTITY_PARENT_CHILD table.

Column Name	Type	Not Null	Description
AS_OF_DATE	DATE	Y	Timestamp (at close of business) for the data.
CHILD	STRING	Y	Identifier of the node in the Legal Entity hierarchy.
PARENT	STRING		Identifier of the parent node (or null if there is no parent).

Unique Key

Columns
AS_OF_DATE
CHILD

There is a self-join on the LEGAL_ENTITY_HIERARCHY table - see database creation script for details.

If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields. ↩︎

⌘I