HZ_GEOGRAPHIES

The HZ_GEOGRPHIES table stores data representing physical geographies. For example, this table would be used to store United States as a geography with GEOGRAPHY_CODE as US and GEOGRAPHY_TYPE as COUNTRY

Details

Primary Key

Name Columns
HZ_GEOGRAPHIES_PK GEOGRAPHY_ID

Columns

Name Database Length Precision Not Null Comments Flexfield Mapping
GEOGRAPHY_ID NUMBER 18 Yes Unique identifier for a geography.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
GEOGRAPHY_TYPE VARCHAR2 30 Yes Type of geography.
GEOGRAPHY_NAME VARCHAR2 360 Yes Primary Name of the geography.
GEOGRAPHY_USE VARCHAR2 30 Yes Usage of geography data.
GEOGRAPHY_CODE VARCHAR2 30 User identifier for this geography.
START_DATE DATE Yes Start date from which this geography is valid for use.
END_DATE DATE Yes Date from which this geography is no longer valid.
MULTIPLE_PARENT_FLAG VARCHAR2 1 Yes Indicates whether this geography has multiple parents.
CREATED_BY_MODULE VARCHAR2 30 Yes Created by module
COUNTRY_CODE VARCHAR2 2 Code of the Country to which the Geography belongs.
GEOGRAPHY_ELEMENT1 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT1_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT1_CODE VARCHAR2 30 Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT2_CODE VARCHAR2 30 Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT3_CODE VARCHAR2 30 Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT4_CODE VARCHAR2 30 Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT5_CODE VARCHAR2 30 Code of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT6 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT6_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT7 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT7_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT8 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT8_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT9 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT9_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT10 VARCHAR2 360 Name of de-normalized parent of the geography.
GEOGRAPHY_ELEMENT10_ID NUMBER 18 Unique identifier of de-normalized parent of the geography.
TIMEZONE_CODE VARCHAR2 64 Foreign key to FND_TIMEZONES_B.TIMEZONE_CODE
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
GEOCODE_FLAG VARCHAR2 1 Indicates if Geocoding is enabled for a country. Y for enabled, N for disabled.
GEOGRAPHY_NUMBER VARCHAR2 240 Geography Number for zone records
HIDDEN_FLAG VARCHAR2 1 Indicates if geography is hidden under grouping Zone in the Territory UI. Y for hidden, null for default behaviour.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
DEFAULT_GEO_PROVIDER VARCHAR2 30 Default geography data provider associated with the geographies loaded for the country. Possible values are defined in the 'HZ_GEO_DATA_PROVIDER' lookup type. For example, LOQATE/NAVTEQ etc.
DEFAULT_GEO_VERSION VARCHAR2 240 Version number associated with the geographies loaded for the country. This number will be used for supporting incremental load .

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_GEOGRAPHIES HZ_GEOGRAPHY_TYPES_B GEOGRAPHY_TYPE
IRC_GEO_HIER_NODES_OPTI HZ_GEOGRAPHIES PARENT_GEOGRAPHY_ID
HZ_GEO_NAME_REFERENCES HZ_GEOGRAPHIES GEOGRAPHY_ID
XLE_HISTORY_COLUMNS_B HZ_GEOGRAPHIES GEOGRAPHY_ID
ZBS_COMPTTR_SWOT_GEOS HZ_GEOGRAPHIES GEOGRAPHY_ID
IRC_REQ_LOCATIONS HZ_GEOGRAPHIES GEOGRAPHY_ID
HZ_HIERARCHY_NODES HZ_GEOGRAPHIES CHILD_ID
HZ_HIERARCHY_NODES HZ_GEOGRAPHIES PARENT_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES BASE_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES TOP_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_01_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_02_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_03_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_04_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_05_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_06_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_07_GEO_ID
HZ_GEO_HIERARCHY_CF HZ_GEOGRAPHIES LEVEL_08_GEO_ID
ZBS_COMPTTR_INTXPRT_GEOS HZ_GEOGRAPHIES GEOGRAPHY_ID
HZ_GEOGRAPHY_IDENTIFIERS HZ_GEOGRAPHIES GEOGRAPHY_ID
IRC_REQUISITIONS_B HZ_GEOGRAPHIES GEOGRAPHY_ID
XLE_ETB_PROFILES HZ_GEOGRAPHIES GEOGRAPHY_ID
ZBS_COMPTTR_GEOS HZ_GEOGRAPHIES GEOGRAPHY_ID
HZ_GEOGRAPHY_RANGES HZ_GEOGRAPHIES GEOGRAPHY_ID
HZ_GEO_STRUCTURE_LEVELS HZ_GEOGRAPHIES GEOGRAPHY_ID
JL_BR_SPED_PRCPNT_CODES HZ_GEOGRAPHIES PARTCPNT_STATE_GEOGRAPHY_ID
JL_BR_SPED_PRCPNT_CODES HZ_GEOGRAPHIES PARTCPNT_CITY_GEOGRAPHY_ID
ZX_THREHLDS_SCHDL_CNTRLS_F HZ_GEOGRAPHIES TAX_THREHLDS_SCHDL_CNTRL_ID
XLE_ENTITY_PROFILES HZ_GEOGRAPHIES GEOGRAPHY_ID
XLE_JURISDICTIONS_B HZ_GEOGRAPHIES GEOGRAPHY_ID
IRC_GEO_HIER_NODES HZ_GEOGRAPHIES GEOGRAPHY_ID

Indexes

Index Uniqueness Tablespace Column
HZ_GEOGRAPHIES_N1 Non Unique Default GEOGRAPHY_CODE, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N10 Non Unique Default GEOGRAPHY_ELEMENT1_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N11 Non Unique Default UPPER("GEOGRAPHY_NAME"), GEOGRAPHY_TYPE, GEOGRAPHY_USE, START_DATE, END_DATE
HZ_GEOGRAPHIES_N12 Non Unique Default COUNTRY_CODE, GEOGRAPHY_TYPE, GEOGRAPHY_USE, START_DATE, END_DATE
HZ_GEOGRAPHIES_N13 Non Unique Default GEOGRAPHY_ELEMENT7_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N14 Non Unique Default GEOGRAPHY_NUMBER, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N15 Non Unique Default GEOGRAPHY_NAME, COUNTRY_CODE, START_DATE, END_DATE
HZ_GEOGRAPHIES_N2 Non Unique Default GEOGRAPHY_TYPE, GEOGRAPHY_USE, START_DATE, END_DATE
HZ_GEOGRAPHIES_N3 Non Unique Default GEOGRAPHY_ELEMENT1_ID, GEOGRAPHY_ELEMENT2_ID, GEOGRAPHY_ELEMENT3_ID, GEOGRAPHY_ELEMENT4_ID, GEOGRAPHY_ELEMENT5_ID, GEOGRAPHY_ELEMENT6_ID, GEOGRAPHY_ELEMENT7_ID, GEOGRAPHY_ELEMENT8_ID, GEOGRAPHY_ELEMENT9_ID, GEOGRAPHY_ELEMENT10_ID
HZ_GEOGRAPHIES_N4 Non Unique Default LAST_UPDATE_DATE
HZ_GEOGRAPHIES_N5 Non Unique Default GEOGRAPHY_ELEMENT2_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N6 Non Unique Default GEOGRAPHY_ELEMENT3_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N7 Non Unique Default GEOGRAPHY_ELEMENT4_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE, GEOGRAPHY_ELEMENT2_ID, START_DATE, END_DATE
HZ_GEOGRAPHIES_N8 Non Unique Default GEOGRAPHY_ELEMENT5_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_N9 Non Unique Default GEOGRAPHY_ELEMENT6_ID, GEOGRAPHY_TYPE, GEOGRAPHY_USE
HZ_GEOGRAPHIES_PK Unique Default GEOGRAPHY_ID