OPRID0=Selected
1=Open
2=Worked
3=Cancelled
RB_SD_APPROV_VW(SQL View) |
Index Back |
|---|---|
Supervisor Desktop ApprovalSupervisor Desktop Approval View |
| SELECT W.OPRID , W.INSTSTATUS , W.INSTAVAILABLEDTTM , W.WORKLISTNAME ,W.INSTANCEID ,W.TRANSACTIONID , R.BO_NAME_CONTACT , R.ROW_ADDED_OPRID , R.CMF_INSTANCE_ID , 0 , R.EMAIL_ADDR , R.SUBJECT , R.INTERACTION_ID FROM PSWORKLIST W , PS_RB_WF_MSG_WL CW , PS_RBC_RECIPIENT R , PS_RBC_REQUEST RQ WHERE W.WORKLISTNAME='Action_Request' AND W.BUSPROCNAME = CW.BUSPROCNAME AND W.ACTIVITYNAME = CW.ACTIVITYNAME AND W.EVENTNAME = CW.EVENTNAME AND W.WORKLISTNAME = CW.WORKLISTNAME AND W.INSTANCEID = CW.INSTANCEID AND W.TRANSACTIONID = CW.TRANSACTIONID AND CW.CMF_INSTANCE_ID = R.CMF_INSTANCE_ID AND R.CMF_ID = RQ.CMF_ID AND RQ.CMF_REQST_STATUS = 'APPR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
0=Selected 1=Open 2=Worked 3=Cancelled |
| 3 | INSTAVAILABLEDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was made available |
| 4 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 5 | INSTANCEID | Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 6 | TRANSACTIONID | Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 7 | BO_NAME_CONTACT | Character(50) | VARCHAR2(50) NOT NULL | BO_NAME_CONTACT |
| 8 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 9 | CMF_INSTANCE_ID | Character(36) | VARCHAR2(36) NOT NULL | Correspondence Instance ID |
| 10 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 11 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 12 | SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 13 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |