PowerCenter
- PowerCenter 10.5.1
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
SUBJECT_ID*
| NUMBER
| Folder ID.
|
WORKFLOW_ID*
| NUMBER
| Workflow ID.
|
WORFLOW_RUN_ID*
| NUMBER
| Workflow run ID.
|
WORKFLOW_NAME
| VARCHAR2 (240)
| Workflow name.
|
SERVER_ID*
| NUMBER
| Integration Service ID.
|
SERVER_NAME
| VARCHAR2 (240)
| Integration Service name.
|
START_TIME
| DATE
| Start time configured for the workflow.
|
END_TIME
| DATE
| End time configured for the workflow.
|
LOG_FILE
| VARCHAR2 (2000)
| Full path and name of the log file.
|
RUN_ERR_CODE
| NUMBER
| Error message code.
|
RUN_ERR_MSG
| VARCHAR2 (2000)
| 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.
|
USER_NAME
| VARCHAR2 (240)
| Name of the user who ran the workflow.
|
RUN_TYPE
| NUMBER
| Specifies how the workflow was run.
1 = Scheduler
2 = User request
3 = Debug session
4 = Server initialization
5 = Remote task
6 = Remote debug session
|
VERSION_NUMBER*
| NUMBER
| Workflow version number.
|
SUBJECT_AREA
| VARCHAR2 (240)
| Folder name.
|
*Indicates that the column is a key column.
|