PV_WF_ESCLAT_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.TRANSACTIONID , A.BUSINESS_UNIT , A.REQ_ID , A.PV_RULEID , A.STEP , B.PV_ESCALATE , B.PV_NUMBER_DAYS , B.PV_NUMBER_HOURS , B.PV_EMAIL_USER , B.PV_EMAIL_SUPR , B.PV_ROUTE_NEXT_STEP , C.INSTSTATUS , C.INSTAVAILABLEDTTM , C.INSTSELECTEDDTTM , C.INSTWORKEDDTTM , C.INSTTIMEOUTDTTM , C.OPRID FROM PS_PV_REQ_APPR_WL A , PS_PV_WF_RULE B , PSWORKLIST C WHERE A.PV_RULEID = B.PV_RULEID AND A.WORKLISTNAME = C.WORKLISTNAME AND A.INSTANCEID = C.INSTANCEID AND A.BUSPROCNAME = C.BUSPROCNAME AND A.ACTIVITYNAME = C.ACTIVITYNAME AND A.EVENTNAME = C.EVENTNAME AND B.PV_ESCALATE = 'Y' AND C.INSTSTATUS <> 2 AND (%DateTimeDiff(C.INSTAVAILABLEDTTM, %CurrentDateTimeIn)) >= ((B.PV_NUMBER_DAYS*60*24)+(B.PV_NUMBER_HOURS*60 )) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 2 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 3 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 4 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 5 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 6 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 7 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 9 | PV_RULEID | Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 10 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 11 | PV_ESCALATE | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule Page.
Y/N Table Edit Default Value: N |
| 12 | PV_NUMBER_DAYS | Number(3,0) | SMALLINT NOT NULL | Number of Days |
| 13 | PV_NUMBER_HOURS | Number(2,0) | SMALLINT NOT NULL | Number of Hours |
| 14 | PV_EMAIL_USER | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule page.
Y/N Table Edit Default Value: N |
| 15 | PV_EMAIL_SUPR | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule page.
Y/N Table Edit Default Value: N |
| 16 | PV_ROUTE_NEXT_STEP | Character(1) | VARCHAR2(1) NOT NULL |
Route to Next Step
Y/N Table Edit Default Value: N |
| 17 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
0=Selected 1=Open 2=Worked 3=Cancelled |
| 18 | INSTAVAILABLEDTTM | DateTime(26) | TIMESTAMP NOT NULL | Datetime worklist instance was made available |
| 19 | INSTSELECTEDDTTM | DateTime(26) | TIMESTAMP | Datetime user selected a worklist entry |
| 20 | INSTWORKEDDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was worked by a user |
| 21 | INSTTIMEOUTDTTM | DateTime(26) | TIMESTAMP | Datetime that a worklist times out |
| 22 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |