HZ_TEMP_GEO_IMP_GT

HZ_TEMP_GEO_IMP_GT is a global temporary table used to store mappings between HZ_IMP_GEOGRAPHIES_T.interface_row_id and appropriate error_id. Every time an error is encountered for an interface record during validation, the interface_row_id for the record is stored, alongside an appropriate error_id in HZ_TEMP_GEO_IMP_GT. The ERROR_ID, if NULL, is generated using S_ROW_ID_SEQ.nextval. This same ERROR_ID is used to populate error details for the interface record in HZ_IMP_ERRORS. Data in the table is temporary. It has a data duration of SYS$SESSION.

Details

• Schema: FUSION

• Object owner: HZ

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Precision	Comments
INTERFACE_ROW_ID	NUMBER	18	Unique dentifier for geography interface record.
ERROR_ID	NUMBER	18	Indicates that an error has occurred for geo record. Used to join to the appropriate row in HZ_IMP_ERRORS

Indexes

Index	Uniqueness	Columns
HZ_TEMP_GEO_IMP_GT_N1	Non Unique	INTERFACE_ROW_ID