RS_WORKLIST_VW

(SQL View)
 Index Back

Worklist Items


SELECT A.OPRID , A.INSTANCEID , A.ACTIVITYNAME , A.EVENTNAME , A.BUSPROCNAME , A.WORKLISTNAME , A.TRANSACTIONID , A.INSTAVAILABLEDTTM , A.INSTSTATUS , A.INSTTIMEOUTDTTM , A.COMMENTSHORT , A.ORIGINATORID , A.URL FROM PSWORKLIST A WHERE A.INSTSTATUS < 2

# 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 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
6 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
7 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
8 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
9 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled
10 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
11 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
12 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
13 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)