COUNTERPARTIES

The COUNTERPARTIES table contains data for counterparties.

Column Name Type Not Null Default Value1 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 identi fier 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

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