WORKLISTNAMECS_CW_AUCWL_VW1(SQL View) |
Index Back |
|---|---|
Event Analysis Collab WLSCMT003 - Worklist for Event Analysis Collaboration |
| SELECT DISTINCT a.worklistname , a.business_unit , a.auc_id , a.auc_round , a.auc_version , B.OPRID FROM PS_AUCANLYCOLLABWL A , PSWORKLIST B WHERE 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) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 4 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 5 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |