OCD_BPSTAT_VW

(SQL View)
 Index Back

View of Business Process

This is an order management dashboard view of the status of a business process instance.

SELECT A.BUS_PROC_INSTANCE , A.RC_BUS_PROCESS_ID , A.BUS_PROCESS_STATUS , B.XLATSHORTNAME , A.RC_OUTCOME , C.XLATSHORTNAME , D.CAPTURE_ID FROM PS_RC_BP_STATUS A LEFT OUTER JOIN PSXLATITEM C ON A.RC_OUTCOME = C.FIELDVALUE AND C.FIELDNAME='RC_OUTCOME' , PSXLATITEM B , PS_RO_ASSOCIATION D WHERE B.FIELDNAME='BUS_PROCESS_STATUS' AND A.BUS_PROCESS_STATUS = B.FIELDVALUE AND A.BUS_PROC_INSTANCE=D.BUS_PROC_INSTANCE AND D.TYPE = 'BP'

# 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 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
3 BUS_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL This field is to store Business Process status.
C=Complete
L=Canceled
P=In Process
4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
5 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
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.