The COUNTRIES table contains description data for countries.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.
| 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 |
- 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. ↩︎