HZ_GEO_STAGING_INT
Staging table to store the impact analysis data of master geographies, zones. This data will be populated via Import process as part of it's review phase. Once the master geographies data and it's potential impacts are well understood, end user will proceed with data loading into base tables. Data from this table will be purged by import framework scheduled process, after successful loading of data into the system.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier for this interface record. | |
| BATCH_ID | NUMBER | 18 | Yes | Unique identifier for a geography import batch in MKT_CM_SYSTASKS. | |
| COUNTRY_CODE | VARCHAR2 | 2 | Code of the Country to which the Geography belongs. | ||
| PROVIDER_CODE | VARCHAR2 | 30 | Name of the data source provider. | ||
| PROVIDER_GEO_ID | VARCHAR2 | 64 | Unique identifier for a geography provided by the corresponding provider. | ||
| PARENT_PROVIDER_GEO_ID | VARCHAR2 | 64 | Provider Geo ID of parent geography provided by the corresponding provider. | ||
| RECORD_TYPE_CODE | NUMBER | 2 | Specifies what data needs to be created. | ||
| LEVEL_NUMBER | NUMBER | 2 | Country structure level number. | ||
| GEOGRAPHY_ID | NUMBER | 18 | Unique geography identifier used in TCA geography tables. | ||
| GEOGRAPHY_TYPE | VARCHAR2 | 30 | Type of geography. For e.g. STATE,CITY,POSTAL_CODE etc. | ||
| GEOGRAPHY_NAME | VARCHAR2 | 360 | Geography Name. | ||
| GEOGRAPHY_CODE | VARCHAR2 | 30 | Geography Code. | ||
| GEOGRAPHY_USE | VARCHAR2 | 30 | Geography usage - valid values are MASTER_REF, TAX, SHIPPING, ORA_COMPENSATION, ORA_SERVICE, TM. | ||
| PARENT_GEOGRAPHY_ID | NUMBER | 18 | Unique geography identifier of the parent used in TCA geography tables. | ||
| PARENT_GEOGRAPHY_TYPE | VARCHAR2 | 30 | Type of parent geography. | ||
| PREV_GEOGRAPHY_ID | NUMBER | 18 | Previous geography id of existing geography for move use case. | ||
| IMPACTED_MASTER_HIERARCHY | VARCHAR2 | 4000 | Impacted Master Hierarchy in case of move use case. | ||
| FUTURE_MASTER_HIERARCHY | VARCHAR2 | 4000 | Future Master Hierarchy in case of move use case. | ||
| IMPACTED_ZONE_HIERARCHY | VARCHAR2 | 4000 | Impacted zone hierarchies due to changes in master geographies. | ||
| GEOGRAPHY_ELEMENT1_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT2_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT3_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT4_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT5_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT6_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT7_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT8_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT9_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| GEOGRAPHY_ELEMENT10_ID | NUMBER | 18 | Unique identifier of de-normalized parent of the geography. | ||
| START_DATE | DATE | Start date from which this geography is valid for use. | |||
| END_DATE | DATE | Date from which this geography is no longer valid. | |||
| INSERT_UPDATE_FLAG | VARCHAR2 | 30 | Indicates if a record should be explicitly inserted,updated,moved or deleted. | ||
| FILE_RECORD_NUM | NUMBER | 10 | File import wizard uses this column to relate records in this interface table to rows in a file. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| 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. | |
| 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. | ||
| IMPACTED_ZONE_ID | NUMBER | 18 | Unique geography identifier for the Zone used in TCA geography tables. | ||
| IMPACTED_ZONE_NAME | VARCHAR2 | 360 | Zone Name. | ||
| IMPACTED_ZONE_TYPE | VARCHAR2 | 30 | Geography Type of Zone. Valid values would be stored in HZ_GEOGRAPHY_TYPES_VL.GEOGRAPHY_TYPE for specific geography use. | ||
| INSERT_UPDATE_FLAG_DESC | VARCHAR2 | 120 | Description for the Insert Update Flag Column. E.g., Insert, Update, Soft-Delete, Move (Insert), Move (Soft-Delete). | ||
| GEO_INTERFACE_ROW_ID | NUMBER | 18 | Unique identifier for the geography interface record. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_GEO_STAGING_INT_N1 | Non Unique | Default | BATCH_ID, GEOGRAPHY_USE, INSERT_UPDATE_FLAG |
| HZ_GEO_STAGING_INT_N2 | Non Unique | Default | BATCH_ID, GEOGRAPHY_ID, GEO_INTERFACE_ROW_ID |
| HZ_GEO_STAGING_INT_N3 | Non Unique | Default | BATCH_ID, PROVIDER_GEO_ID, LEVEL_NUMBER, PROVIDER_CODE, COUNTRY_CODE |
| HZ_GEO_STAGING_INT_N4 | Non Unique | Default | COUNTRY_CODE, GEOGRAPHY_USE, INSERT_UPDATE_FLAG, PROVIDER_CODE, BATCH_ID |
| HZ_GEO_STAGING_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |