RBF_EMP_PRCS(SQL View) |
Index Back |
|---|---|
My Processes InformationView to display the Processes for Agent Facing and Self Service - My Processes |
| SELECT B.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_INST_HDR B , PS_RBF_PRCS_TYPE C , PSOPERATION D , PS_RBB_TRNSTYP_DFN E WHERE B.RBB_TRNSTYPE_ID=C.RBB_TRNSTYPE_ID AND B.MARKET = C.MARKET 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 | RBB_BPEL_INST_ID | Character(100) | VARCHAR2(100) NOT NULL | Business Process Instance ID |
| 2 | RBB_TRNSTYPE_ID | Character(25) | VARCHAR2(25) NOT NULL | Field to store Transaction Type ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 5 | RBB_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Business Process Submit Date and Time |
| 6 | IB_SERVICENAME | Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | PRCS_TYPE_DESC | Character(50) | VARCHAR2(50) NOT NULL | The Field is used to store the Process type description |
| 9 | RBB_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description of BPEL related setup objects. |