WF_WORKLIST_VW2

(SQL View)
 Index Back

Tools Worklist View


SELECT BUSPROCNAME , WORKLISTNAME ,ACTIVITYNAME , INSTANCEID , ACTIONDTTM , OPRID , ORIGINATORTYPE , ORIGINATORID , INSTSTATUS , INSTAVAILABLEDTTM , INSTSELECTEDDTTM , INSTWORKEDDTTM , TIMEDOUT , COMMENTSHORT , TRANSACTIONID , PREVOPRID , DO_REPLICATE_FLAG , URL FROM PSWORKLIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
5 ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: ROLEXLATOPR

7 ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
8 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
9 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
10 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
11 INSTSELECTEDDTTM DateTime(26) TIMESTAMP Datetime user selected a worklist entry
12 INSTWORKEDDTTM DateTime(26) TIMESTAMP Datetime worklist instance was worked by a user
13 TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
14 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
15 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
16 PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
17 DO_REPLICATE_FLAG Character(1) VARCHAR2(1) NOT NULL Do Replicate Flag
18 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)