OPRIDINSTANCEIDWORKLISTNAME1=Priority1
2=Priority2
3=Priority3
4=Priority4
5=Priority5
Default Value: 1
Y/N Table Edit
Default Value: N
1=Pending
2=On Hold
3=In Process
4=Completed
PV_TO_DO_VW(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , A.INSTANCEID , A.TASK_DESC , A.WORKLISTNAME ,A.BUSPROCNAME ,A.DTTM_DUE ,A.PV_PRIORITY_LABEL ,A.DONE_FLAG ,A.PV_STATUS FROM PS_PV_WORKLIST_TBL A WHERE DONE_FLAG = 'N' |
| # | 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 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 3 | TASK_DESC | Character(80) | VARCHAR2(80) NOT NULL | Task Description |
| 4 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 5 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 6 | DTTM_DUE | DateTime(26) | TIMESTAMP | Date/Time Due |
| 7 | PV_PRIORITY_LABEL | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=Priority1 2=Priority2 3=Priority3 4=Priority4 5=Priority5 Default Value: 1 |
| 8 | DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Done Flag
Y/N Table Edit Default Value: N |
| 9 | PV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
1=Pending 2=On Hold 3=In Process 4=Completed |