COUNTRIES - Atoti Hub

The COUNTRIES table contains description data for countries.

Column Name	Type	Not Null	Cube Field	Default Value¹	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

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