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 |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| smallint | No | Identifier of the country of which the region is a part (see the ARF_GEO_COUNTRY table). | |
| varchar | 254 | No | Name of region in the default language. |
| varchar | 254 | Yes | Name of region in English. |
| char | 6 | Yes | ISO 3166 two-character code for the region. |
| char | 4 | Yes | FIPS code for the region. |
| timestamp | Yes | Date when the information in this warehouse record became effective | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. |