☰
Navigation :

COUNTERPARTY_PARENT_CHILD

The COUNTERPARTY_PARENT_CHILD table contains the parent/child relationships used to build the counterparty hierarchy.

note

The COUNTERPARTY_HIERARCHY table is populated from the COUNTERPARTY_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 Counterparty 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 COUNTERPARTY_PARENT_CHILD 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.  ↩︎