The COUNTERPARTY_PARENT_CHILD table contains the parent/child relationships used to build the counterparty hierarchy.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 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.- 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. ↩︎