☰
Navigation :

COUNTRIES

The COUNTRIES table contains description data for countries.

Column Name Type Not Null Cube Field Default Value1 Description
AS_OF_DATE DATE Y Timestamp (at close of business) for the data.
COUNTRY_CODE STRING Y N/A Unique three-letter country identifier code.
COUNTRY STRING Y N/A The name of the country.
LATITUDE DOUBLE Y N/A The latitude of the country in the decimal degrees format.
LONGITUDE DOUBLE Y N/A The longitude of the country in the decimal degrees format.
REGION STRING Y N/A The region in which the country is located.
SUB_REGION STRING Y N/A The sub-region in which the country is located.

Unique Key

Columns
AS_OF_DATE
COUNTRY_CODE

Incoming Joins

Source Table Source Columns Target Columns
COUNTERPARTIES AS_OF_DATE
COUNTRY_OF_ADDRESS		 AS_OF_DATE
COUNTRY_CODE
COUNTERPARTIES 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.  ↩︎