ZCQ_IIR_SYNC_SUMMARIES

ZCQ_IIR_SYNC_SUMMARIES table stores the summary details of the sync job for each IDT table of the system

Details

Name	Columns
ZCQ_IIR_SYNC_SUMMARIES_PK	SYNC_SETUP_ID

Name	Datatype	Length	Precision	Not-null	Comments
SYNC_SETUP_ID	NUMBER		18	Yes	SYNC_SETUP_ID
SYNC_CONFIG_CODE	VARCHAR2	64		Yes	SYNC_CONFIG_CODE
SYSTEM_NAME	VARCHAR2	64			SYSTEM_NAME
IDT_NAME	VARCHAR2	64			IDT_NAME
ENABLED_FLAG	VARCHAR2	1			ENABLED_FLAG
COUNTRY_CODE	VARCHAR2	2			COUNTRY_CODE
SYSTEM_DB_ID	VARCHAR2	2			SYSTEM_DB_ID
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PARENT_REQUEST_ID	NUMBER		18		PARENT_REQUEST_ID
TCA_RECS	NUMBER		18		TCA_RECS
IIR_RECS	NUMBER		18		IIR_RECS
START_WINDOW_TIME	TIMESTAMP				START_WINDOW_TIME
END_WINDOW_TIME	TIMESTAMP				END_WINDOW_TIME
SYNC_PROCESS_STATUS	VARCHAR2	32			SYNC_PROCESS_STATUS
SYNC_ERROR_MSG	VARCHAR2	360			SYNC_ERROR_MSG
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_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated 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.
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.

Table	Foreign Table	Foreign Key Column
ZCQ_IIR_SYNC_SUMMARIES	zcq_configurations	SYNC_CONFIG_CODE

Index	Uniqueness	Tablespace	Columns
ZCQ_IIR_SYNC_SUMMARIES_PK	Unique	Default	SYNC_SETUP_ID
ZCQ_IIR_SYNC_SUMMARIES_U1	Unique	Default	SYNC_CONFIG_CODE, SYSTEM_NAME, IDT_NAME