OCD_TSKSTAT_VW

(SQL View)
 Index Back

Status of a task

This is an order management dashboard view of the instance of a task.

SELECT A.BUS_PROC_INSTANCE , A.ACTIVITY_INSTANCE , A.RC_TSK_PROC_INST , A.RC_TASK_ID , A.NESTED_BP_IND , E.RC_ACTIVITY_ID , F.RC_BUS_PROCESS_ID , D.CAPTURE_ID , A.RC_TASK_STATUS , B.XLATSHORTNAME , A.RC_OUTCOME , C.XLATSHORTNAME , A.ROW_ADDED_DTTM , A.ROW_LASTMANT_DTTM FROM PS_RC_TASK_STATUS A LEFT OUTER JOIN PSXLATITEM C ON A.RC_OUTCOME = C.FIELDVALUE AND C.FIELDNAME='RC_OUTCOME' , PSXLATITEM B , PS_RO_ASSOCIATION D , PS_RC_ACTIV_STATUS E , PS_RC_BP_STATUS F WHERE B.FIELDNAME='RC_TASK_STATUS' AND B.FIELDVALUE = A.RC_TASK_STATUS AND D.BUS_PROC_INSTANCE = A.RC_MAIN_BP_INSTNCE AND E.ACTIVITY_INSTANCE = A.ACTIVITY_INSTANCE AND E.BUS_PROC_INSTANCE = A.BUS_PROC_INSTANCE AND D.TYPE = 'BP' AND F.BUS_PROC_INSTANCE = A.BUS_PROC_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.
2 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance
3 RC_TSK_PROC_INST Number(18,0) DECIMAL(18) NOT NULL RC_TSK_PROC_INST
4 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.
5 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes
6 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
7 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
8 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
9 RC_TASK_STATUS Character(1) VARCHAR2(1) NOT NULL Task Status used in Business Process tracking.
C=Complete
L=Cancelled
N=Not Started
P=In Process
10 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
11 RC_OUTCOME Character(1) VARCHAR2(1) NOT NULL Outcome of a Task for Business Process tracking. See translates for possible values.
F=Failure
S=Success
12 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
13 START_DTTM DateTime(26) TIMESTAMP start date time
14 END_DTTM DateTime(26) TIMESTAMP end date time