Country Code Column Definitions
The following table describes the column definitions for the Country Code configuration.
| Column | Data Type | Description |
|---|---|---|
|
COUNTRY_CODE |
VARCHAR2(50) |
Source or application-specific country code used for identifying a country. |
|
ISO_COUNTRY_CODE |
VARCHAR2(2) |
Two-character ISO 3166-1 Alpha-2 country code (for example, US, IN, GB). |
|
COUNTRY_NAME |
VARCHAR2(255) |
Official country name corresponding to the country code. |
|
ISO_NUMERICAL_CODE |
VARCHAR2(3) |
Three-digit ISO 3166-1 numeric country code (for example, 840 for the United States, 356 for India). |
|
ISO_ALPHA3_CODE |
VARCHAR2(3) |
Three-character ISO 3166-1 Alpha-3 country code (for example, USA, IND, GBR). |
|
NLS_TERRITORY |
VARCHAR2(30) |
Oracle NLS territory value associated with the country, used for locale-specific formatting and regional settings. |
The FILE_GEO_COUNTRY inline dataset is delivered with pre-populated seeded country reference data. This seeded data includes standard country codes, ISO country codes, country names, ISO numeric and alpha-3 codes, and Oracle NLS territory mappings.
You can extend this dataset by adding additional country codes or updating existing entries, as required, to support organization-specific or regional business requirements. Any custom entries must adhere to the same data standards and formatting as the seeded records to ensure consistency across reporting and data processing.