ZCA_ES_BATCHES

Details

Name	Columns
ZCA_ES_BATCHES_PK	BATCH_ID

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER			Yes	Id of the batch, also the primary key
ROOT_JOB_ID	NUMBER				The request id of the root parent ESS job
PARENT_JOB_ID	NUMBER				The request id of the parent ESS job, if any
ENTITY_UUID	VARCHAR2	36			The Uuid of the entity belonging to the batch
JOB_DEFINITION	VARCHAR2	800			The ESS job definition of the batch
MAX_BUCKET	NUMBER		20		The maximum batches required to process the ESS job
BATCH_NUMBER	NUMBER		20		The bucket in which the batch job is to be processed
PROCESSING_JOB_ID	NUMBER				Ess job id if claimed for processing else null if unclaimed
STATUS	VARCHAR2	20			Null (not started), Success, SuccessOnRetry, Warning, Error
START_TIME	TIMESTAMP				Time when processing was started for this batch
END_TIME	TIMESTAMP				Time when processing was ended for this batch
ERROR_WARNING_MESSAGE	VARCHAR2	4000			Short summary of error or warning for this batch
ERROR_WARNING_DETAIL	CLOB				Error or warning detail including stack trace for bug diagnosis and triage for this batch
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.

Index	Uniqueness	Tablespace	Columns
ZCA_ES_BATCHES_PK	Unique	DEFAULT	BATCH_ID
ZCA_ES_BATCHES_U1	Unique	DEFAULT	PARENT_JOB_ID, BATCH_NUMBER, ENTITY_UUID, JOB_DEFINITION, STATUS