Repository Guide

Back Next

REP_TASK_INST_RUN

This view displays the run statistics and folder reference for tasks within a workflow or worklet.

The following table lists run statistics and folder reference information in the REP_TASK_INST_RUN view:

Column Name	Datatype	Description
SUBJECT_AREA	VARCHAR2 (240)	Folder name.
WORKFLOW_NAME	VARCHAR2 (240)	Workflow name.
VERSION_NUMBER*	NUMBER	Version number.
SUBJECT_ID*	NUMBER	Folder ID.
WORKFLOW_ID*	NUMBER	ID of the parent workflow.
WORKFLOW_RUN_ID*	NUMBER	Run ID of the parent workflow.
WORKLET_RUN_ID*	NUMBER	Run ID of a worklet in a workflow.
CHILD_RUN_ID*	NUMBER	Run ID of a child task in a worklet.
INSTANCE_ID*	NUMBER	ID of an instance within a workflow or a worklet.
INSTANCE_NAME	VARCHAR2 (240)	Name of the task instance.
TASK_ID*	NUMBER	Task ID.
TASK_TYPE_NAME	VARCHAR2 (240)	Object name.
TASK_TYPE	NUMBER	Task type.
START_TIME	DATE	Start time configured for task execution.
END_TIME	DATE	End time configured for task execution.
RUN_ERR_CODE	NUMBER	Task error code.
RUN_ERR_MSG	VARCHAR2 (2000)	Task error message.
RUN_STATUS_CODE	NUMBER	Status code of the task. 1 = Succeeded 2 = Disabled 3 = Failed 4 = Stopped 5 = Aborted 6 = Running 15 = Terminated MX views do not provide information about transient session and workflow status, such as suspending, stopping, scheduling, and aborting. You can view all statuses, including transient status, using pmcmd getservicedetails.
TASK_NAME	VARCHAR2 (240)	Task name.
TASK_VERSION_NUMBER*	NUMBER	Task version number.
SERVER_ID	NUMBER	ID of the Integration Service.
SERVER_NAME	VARCHAR2 (240)	Name of the server.
*Indicates that the column is a key column.