The ARF_GEO_REGION table stores a list of regions for reference. It uses the ISO 3166 and FIPS codes. The provided regions include all US states and Canadian provinces.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | smallint | No | Identifier; primary key. | |
COUNTRY_ID | smallint | No | Identifier of the country of which the region is a part (see the ARF_GEO_COUNTRY table). | |
REGION_NAME | varchar | 254 | No | Name of region in the default language. |
REGION_NAME_EN | varchar | 254 | Yes | Name of region in English. |
ISO_3166_2_CODE | char | 6 | Yes | ISO 3166 two-character code for the region. |
FIPS10_4_CODE | char | 4 | Yes | FIPS code for the region. |
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. |