ZCQ_KEYGEN_CHG_IDS

The ZCQ_KEYGEN_CHG_IDS table stores the changes record Ids. It is for incremental key gen to process.

Details

• Schema: FUSION

• Object owner: ZCQ

• Object type: TABLE

• Tablespace: FUSION_TS_INTERFACE

Primary Key

Name	Columns
ZCQ_KEYGEN_CHG_IDS_PK	ZCQ_KEYGEN_CHG_ID, CONFIGURATION_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ZCQ_KEYGEN_CHG_ID	NUMBER		18	Yes	Primary key for this table.	Active
ENTITY_TYPE	VARCHAR2	50		Yes	Entity involved in key generation.	Active
ENTITY_ID	NUMBER		18		RecordId	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
BATCH_ID	NUMBER		18		Different calls to web service per child job.	Active
BATCH_REQUEST_ID	NUMBER		18		BATCH_REQUEST_ID	Active
CONFIGURATION_CODE	VARCHAR2	64		Yes	Configuration code

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZCQ_KEYGEN_CHG_IDS_N1	Non Unique	Default	CONFIGURATION_CODE, BATCH_ID
ZCQ_KEYGEN_CHG_IDS_U1	Unique	FUSION_TS_INTERFACE	ZCQ_KEYGEN_CHG_ID, CONFIGURATION_CODE	Active
ZCQ_KEYGEN_CHG_IDS_U2	Unique	FUSION_TS_INTERFACE	ENTITY_TYPE, ENTITY_ID, CONFIGURATION_CODE	Active