RBF_CUST_PRCS

(SQL View)
 Index Back

My Processes Information

View to display the Processes for Agent Facing and Self Service - My Processes

SELECT A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.RBB_BPEL_INST_ID , B.RBB_TRNSTYPE_ID , B.OPRID , B.MARKET , B.RBB_SUBMIT_DTTM , D.IB_SERVICENAME , D.DESCR , C.PRCS_TYPE_DESC , E.RBB_DESCR FROM PS_RBB_BO_ASSOCTN A , PS_RBB_INST_HDR B , PS_RBF_PRCS_TYPE C , PSOPERATION D , PS_RBB_TRNSTYP_DFN E WHERE A.RBB_BPEL_INST_ID=B.RBB_BPEL_INST_ID AND B.MARKET = C.MARKET AND B.RBB_TRNSTYPE_ID=C.RBB_TRNSTYPE_ID AND B.RBB_SERV_OPR_ID = D.IB_OPERATIONNAME AND B.RBB_TRNSTYPE_ID=E.RBB_TRNSTYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
2 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
5 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID
6 RBB_TRNSTYPE_ID Character(25) VARCHAR2(25) NOT NULL Field to store Transaction Type ID
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 MARKET Character(3) VARCHAR2(3) NOT NULL Market
9 RBB_SUBMIT_DTTM DateTime(26) TIMESTAMP Business Process Submit Date and Time
10 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 PRCS_TYPE_DESC Character(50) VARCHAR2(50) NOT NULL The Field is used to store the Process type description
13 RBB_DESCR Character(50) VARCHAR2(50) NOT NULL Description of BPEL related setup objects.