WF_WORKLIST_VW2

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 Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: ROLEXLATOPR

ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
INSTSELECTEDDTTM DateTime(26) TIMESTAMP Datetime user selected a worklist entry
INSTWORKEDDTTM DateTime(26) TIMESTAMP Datetime worklist instance was worked by a user
TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
DO_REPLICATE_FLAG Character(1) VARCHAR2(1) NOT NULL Do Replicate Flag
URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19