Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

The COUNTERPARTY_HIERARCHY table contains the multi-level counterparty organizational structure.
Note: The content of this table is populated from the content of the COUNTERPARTY_PARENT_CHILD table.
Column NameTypeNot NullCube FieldDefault Value1Description
AS_OF_DATEDATEYTimestamp (at close of business) for the data.
COUNTERPARTY_IDSTRINGYCounterpartyIdsN/ALeaf node of the book hierarchy. This matches the last non-_DATAMEMBER_ node in levels 1 - 15.
COUNTERPARTY_HIERARCHY_LEVEL1STRINGYLevel 1N/ANode at level 1 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL2STRINGYLevel 2N/ANode at level 2 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL3STRINGYLevel 3N/ANode at level 3 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL4STRINGYLevel 4N/ANode at level 4 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL5STRINGYLevel 5N/ANode at level 5 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL6STRINGYLevel 6N/ANode at level 6 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL7STRINGYLevel 7N/ANode at level 7 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL8STRINGYLevel 8N/ANode at level 8 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL9STRINGYLevel 9N/ANode at level 9 of the counterparty hierarchy.
COUNTERPARTY_HIERARCHY_LEVEL10STRINGYLevel 10N/ANode at level 10 of the counterparty hierarchy.

​
Unique Key

Columns
AS_OF_DATE
COUNTERPARTY_ID

​
Incoming Joins

Source TableSource ColumnsTarget Columns
TRADE_ATTRIBUTESAS_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.  ↩︎