The ARF_GEO_COUNTRY table stores a list of countries for reference. It uses the ISO 3166 and FIPS codes. The provided countries are:
Australia
Canada
China
France
Germany
Italy
Japan
Mexico
Russian Federation
South Africa
Spain
Switzerland
United Kingdom
United States
Unspecified
Column Name
Type
Length
Null Allowed
Description
ID
smallint
No
Identifier; primary key.
COUNTRY_NAME
varchar
254
No
Name of country in the default language.
COUNTRY_NAME_EN
varchar
254
Yes
Name of country in English.
ISO3166_1_ALPHA2
char
2
Yes
ISO 3166 two-character alphabetic code for the country.
ISO3166_1_ALPHA3
char
3
Yes
ISO 3166 three-character alphabetic code for the country.
ISO3166_1_NUM3
smallint
Yes
ISO 3166 three-character numeric code for the country.
FIPS10_4_CODE
char
2
Yes
FIPS four-digit code for the country.
RECORD_START_DATE
timestamp
Yes
Date when the information in this warehouse record became effective
RECORD_END_DATE
timestamp
Yes
Date when the information in this warehouse record is no longer effective.