HZ_STAGE_GEO_INT
HZ_STAGE_GEO_INT is a staging table to load hierarchy data to the interface table HZ_GEOGRAPHIES_INT.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
HZ_STAGE_GEO_INT_PK |
STAGE_GEOGRAPHY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STAGE_GEOGRAPHY_ID | NUMBER | 18 | Yes | Unique identifier for this interface record. (internal use only) | |
| PROVIDER_GEO_ID | VARCHAR2 | 360 | Identifier provided by the geography data provider. | ||
| PROVIDER_PARENT_GEO_ID | VARCHAR2 | 360 | Identifier of the parent provided by the geography data provider. | ||
| GEOGRAPHY_IDENTIFIER_ID | NUMBER | 18 | Unique identifier for a geography in HZ_GEOGRAPHY_IDENTIFIERS table (internal use only), used as primary key for master geography export | ||
| GEOGRAPHY_ID | NUMBER | 18 | Unique geography identifier used in TCA geography tables (internal use only). | ||
| GEO_LEVEL_NUM | NUMBER | 18 | Yes | Country structure level number. | |
| PRIMARY_GEOGRAPHY_NAME | VARCHAR2 | 360 | Yes | Primary name of the geography. | |
| ALT_GEOGRAPHY_NAME | VARCHAR2 | 4000 | Alternate name of the geography. | ||
| PARENT_GEOGRAPHY_ID | NUMBER | 18 | Unique geography identifier of the parent used in TCA geography tables (internal use only). | ||
| RECORD_TYPE_CODE | NUMBER | 2 | Specifies what data needs to be created. | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Code of the Country to which the Geography belongs. | ||
| PROVIDER_NAME | VARCHAR2 | 64 | Name of the data source provider. | ||
| DELTA_OPERATION | VARCHAR2 | 30 | Indicates the action of match, add, update or parent_change for internal use. | ||
| LANGUAGE_CODE | VARCHAR2 | 4 | Yes | Stores the language in which identifier_value is stored. (Foreign key to FND_ LANGUAGES.LANGUAGE_CODE) | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| PROVIDER_GEO_VERSION | VARCHAR2 | 240 | Version number associated with the geographies loaded for the country. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_STAGE_GEO_INT_PK | Unique | Default | STAGE_GEOGRAPHY_ID |