BUSPROCNAMEWORKLISTNAMEINSTANCEIDPrompt Table: OPRDEFN2
0=Selected
1=Open
2=Worked
3=Cancelled
RA_WF_WRKLS_VW1(SQL View) |
Index Back |
|---|---|
Tools Work list ViewTools Work list View for marketing |
| SELECT BUSPROCNAME , WORKLISTNAME , INSTANCEID , ACTIONDTTM , OPRID , ORIGINATORTYPE , ORIGINATORID , INSTSTATUS , INSTAVAILABLEDTTM , INSTSELECTEDDTTM , INSTWORKEDDTTM , TIMEDOUT , COMMENTSHORT , TRANSACTIONID FROM PSWORKLIST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 2 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 3 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 4 | ACTIONDTTM | DateTime(26) | TIMESTAMP | Datetime action was taken on a worklist |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2 |
| 6 | ORIGINATORTYPE | Number(5,0) | INTEGER NOT NULL | Originator Type |
| 7 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 8 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
0=Selected 1=Open 2=Worked 3=Cancelled |
| 9 | INSTAVAILABLEDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was made available |
| 10 | INSTSELECTEDDTTM | DateTime(26) | TIMESTAMP | Datetime user selected a worklist entry |
| 11 | INSTWORKEDDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was worked by a user |
| 12 | TIMEDOUT | Number(5,0) | INTEGER NOT NULL | Timed Out |
| 13 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |
| 14 | TRANSACTIONID | Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |