☰
Navigation :

LEGAL_ENTITY_PARENT_CHILD

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

note

The LEGAL_ENTITY_HIERARCHY table is populated from the LEGAL_ENTITY_PARENT_CHILD table.

Column Name Type Not Null Cube Field Default Value1 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

Joins

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

  1. 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.  ↩︎