COUNTERPARTIES - Atoti Hub

The COUNTERPARTIES table contains data for counterparties.

Column Name	Type	Not Null	Default Value¹	Cube Field	Description
AS_OF_DATE	DATE	Y			Timestamp (at close of business) for the data.
COUNTERPARTY_ID	STRING	Y	N/A	CounterpartyIds	Counterparty identifier. Used as a foreign key when counterparty is referenced.
COUNTERPARTY_NAME	STRING	Y	N/A	CounterpartyNames	Full counterparty name.
RATING	STRING	Y	N/A	CounterpartyRatings	Rating of the counterparty.
SECTOR	STRING	Y	N/A	CounterpartySectors	Sector of the counterparty.
COUNTRY_OF_ADDRESS	STRING	Y	N/A	CounterpartyCountriesOfAddress	Country where the counterparty is located, in the form of a unique three-letter country identifier code.
COUNTRY_OF_RISK	STRING	Y	N/A	CounterpartyCountriesOfRisk	Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identifier code.

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

Outgoing Joins

Target Table	Source Columns	Target Columns
COUNTRIES	AS_OF_DATE COUNTRY_OF_ADDRESS	AS_OF_DATE COUNTRY_CODE
COUNTRIES	AS_OF_DATE COUNTRY_OF_RISK	AS_OF_DATE COUNTRY_CODE

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