WORKLISTNAMECS_CW_AUCWL_VW4(SQL View) |
Index Back |
|---|---|
Event Approval WLSCMT003 - Worklist for Event Approval |
| SELECT DISTINCT a.worklistname , a.eoawdescr , c.business_unit , c.auc_id , c.auc_round , c.auc_version , B.OPRID FROM PS_EOAW_WL A , PSWORKLIST B , PS_AUC_EVENT_APPR c WHERE A.EOAWPRCS_ID = 'Event Approval' AND b.busprocname = a.busprocname AND b.activityname = a.activityname AND b.eventname = a.eventname AND b.worklistname = a.worklistname AND b.instanceid = a.instanceid AND b.inststatus IN (0,1) AND c.eoawthread_id = a.eoawthread_id AND c.eoawprcs_id = a.eoawprcs_id AND c.eoawdefn_id = a.eoawdefn_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 2 | EOAWDESCR | Character(254) | VARCHAR2(254) NOT NULL | Descr |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 5 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 6 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |