COUNTERPARTY_PARENT_CHILD

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

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