ARF_GEO_COUNTRY

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.