ZCA_ES_BATCH_LOCKS

This table is used to store the ESS job ids that claim a batch for dynamic batch processing of ESS jobs.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: DEFAULT

Primary Key

Name	Columns
ZCA_ES_BATCH_LOCKS_PK	BATCH_ID

Columns

Name	Datatype	Length	Not-null	Comments
BATCH_ID	NUMBER		Yes	This value can either be Batch id of the batch for which the lock belongs or thread id of the thread for which the lock belongs
PROCESSING_JOB_ID	NUMBER		Yes	The ESS job id that claims the batch
LOCK_TYPE	VARCHAR2	20	Yes	The type of lock acquired on the batch - THREAD_LOCK or BATCH_LOCK
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
ZCA_ES_BATCH_LOCKS_PK	Unique	DEFAULT	BATCH_ID