RA_WF_WRKLST_VW

(SQL View)
 Index Back

Tools Work list View

Tools Work list View for Marketing

SELECT a.BUSPROCNAME , a.WORKLISTNAME , a.INSTANCEID , a.ACTIONDTTM , a.OPRID , a.ORIGINATORTYPE , a.ORIGINATORID , a.INSTSTATUS , b.instatusdescr , a.INSTAVAILABLEDTTM , a.INSTSELECTEDDTTM , a.INSTWORKEDDTTM , a.TIMEDOUT , a.COMMENTSHORT , a.TRANSACTIONID FROM PSWORKLIST a , ps_wf_inststatus b WHERE a.inststatus = b.inststatus

# 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 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
4 ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRDEFN2

6 ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
7 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
8 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled
9 INSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Worklist Instance Status
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