CST_CP_WORKER_STATUS

This table stores the statuses of sub-processors that were launched by a parent process.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: DEFAULT

Primary Key

Name	Columns
CST_CP_WORKER_STATUS_PK	PARENT_REQUEST_ID, REQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARENT_REQUEST_ID	NUMBER		18	Yes	ESS Request ID of the parent process that submitted this worker process.
PARENT_RETRY	NUMBER		9	Yes	Indicates the retry attempt of the parent which submitted this worker.
REQUEST_TYPE	VARCHAR2	30		Yes	Indicates the type of this worker request e.g. QPP, DPROC etc.
REQ_ID	NUMBER		18	Yes	ESS request ID of the worker process. Status column represents the status of this process.
WORKER_NUM	NUMBER		18		The worker number of this process as designated by the parent process at the time of submission.
STATUS	VARCHAR2	30		Yes	Indicates the status of the worker request e.g. A - Active, E - Error, C - Completed.
STATUS_DETAIL	VARCHAR2	1000			Details of error, if the worker request failed.
LOOP_FLAG	VARCHAR2	1			This flag indicates if another loop is required for the job to process the data. Possible values are 0/NULL - no loop required, 1 - loop required.
LOOP_NUM	NUMBER		9		Indicates the cost processor loop during which this worker was submitted.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_CP_WORKER_STATUS_U1	Unique	DEFAULT	PARENT_REQUEST_ID, REQ_ID