HZ_GEOGRAPHY_RANGES

The table HZ_GEOGRAPHY_RANGES stores ranges associated with a given geography. For example, counties where postal codes can be represented as ranges, this table can be used to define zones by postal code ranges.

Details

• Schema: FUSION

• Object owner: HZ

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
HZ_GEOGRAPHY_RANGES_PK	GEOGRAPHY_RANGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
GEOGRAPHY_RANGE_ID	NUMBER		18	Yes	Unique geography range identifier.
GEOGRAPHY_ID	NUMBER		18	Yes	Foreign key to HZ_GEOGRAPHIES
GEOGRAPHY_FROM	VARCHAR2	360		Yes	Must be a valid geography in HZ_GEOGRAPHIES
START_DATE	DATE			Yes	Effective start date of the geographic range
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_TO	VARCHAR2	360		Yes	Must be a valid geography in HZ_GEOGRAPHIES
IDENTIFIER_TYPE	VARCHAR2	30		Yes	Specifies the type of identifier eg Code/ Name
END_DATE	DATE			Yes	Effective end date
GEOGRAPHY_TYPE	VARCHAR2	30		Yes	Denormalized from HZ_GEOGRAPHIES
GEOGRAPHY_USE	VARCHAR2	30		Yes	Denormalized from HZ_GEOGRAPHIES
MASTER_REF_GEOGRAPHY_ID	NUMBER		18	Yes	Identifies the master reference geography used in the ranges to create the zone
CREATED_BY_MODULE	VARCHAR2	30		Yes	Source application module that created this record.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_GEOGRAPHY_RANGES	hz_geographies	GEOGRAPHY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
HZ_GEOGRAPHY_RANGES_N1	Non Unique	Default	GEOGRAPHY_ID, MASTER_REF_GEOGRAPHY_ID, START_DATE, END_DATE
HZ_GEOGRAPHY_RANGES_PK	Unique	Default	GEOGRAPHY_RANGE_ID
HZ_GEOGRAPHY_RANGES_U1	Unique	Default	GEOGRAPHY_ID, GEOGRAPHY_FROM, GEOGRAPHY_TO, START_DATE