☰
Navigation :

COUNTERPARTY_HIERARCHY

The COUNTERPARTY_HIERARCHY table contains the multi-level counterparty organizational structure.

note

Note: The content of this table is populated from the content of 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.
COUNTERPARTY_ID STRING Y [Counterparties].[CounterpartyIds] N/A Leaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.
COUNTERPARTY_HIERARCHY_LEVEL1 STRING Y Level 1 N/A Node at level 1 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL2 STRING Y Level 2 N/A Node at level 2 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL3 STRING Y Level 3 N/A Node at level 3 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL4 STRING Y Level 4 N/A Node at level 4 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL5 STRING Y Level 5 N/A Node at level 5 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL6 STRING Y Level 6 N/A Node at level 6 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL7 STRING Y Level 7 N/A Node at level 7 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL8 STRING Y Level 8 N/A Node at level 8 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL9 STRING Y Level 9 N/A Node at level 9 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL10 STRING Y Level 10 N/A Node at level 10 of the counterparty hierarchy.

Unique Key

Columns
AS_OF_DATE
COUNTERPARTY_ID

Incoming Joins

Source Table Source Columns Target Columns
TRADE_ATTRIBUTES AS_OF_DATE
COUNTERPARTY_ID		 AS_OF_DATE
COUNTERPARTY_ID

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