USERIDWORKLISTNAMERB_WF_TRANS_VW(SQL View) |
Index Back |
|---|---|
CRM Worklist transaction typeView for CRM Worklist Transaction type |
| SELECT DISTINCT A.OPRID , A.WORKLISTNAME , B.WLRECNAME , B.DESCR FROM PSWORKLIST A , PS_RB_WL_GRID_DFN B WHERE B.WORKLISTNAME = A.WORKLISTNAME AND A.INSTSTATUS <=2 AND A.BUSPROCNAME <> 'Administer Workflow' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 3 | WLRECNAME | Character(15) | VARCHAR2(15) NOT NULL | WorkList Record Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |