WF_TO_WL_VW

Platform	View Text
Default	SELECT BUSPROCNAME, ACTIVITYNAME, EVENTNAME, WORKLISTNAME, INSTANCEID, TRANSACTIONID, ACTIOND TTM, OPRID, ORIGINATORTYPE, ORIGINATORID, INSTSTATUS, INSTAVAILABLEDTTM, INSTSELECTEDDTTM, IN STWORKEDDTTM, INSTTIMEOUTDTTM, TIMEDOUT, PREVOPRID, COMMENTSHORT, WLDAYSTOSELECT, WLDAYSTOWORK FROM PSWORKLIST WHERE INSTTIMEOUTDTTM < %currentdatetimein

PeopleSoft Field Name	Description
TIMEOUT_BP	Business Process
TIMEOUT_ACT	Timeout Activity
TIMEOUT_EVENT	Timeout Event
TIMEOUT_WL	Timeout Worklist
TIMEOUT_INSTANCE	Instance ID
TRANSACTIONID	Transaction Identifier
ACTIONDTTM	Datetime action was taken on a worklist
OPRID	A user's ID Prompt Table: OPRDEFN2
ORIGINATORTYPE	Originator Type
ORIGINATORID	Originator Identifier
INSTSTATUS	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
INSTAVAILABLEDTTM	Datetime worklist instance was made available
INSTSELECTEDDTTM	Datetime user selected a worklist entry
INSTWORKEDDTTM	Datetime worklist instance was worked by a user
INSTTIMEOUTDTTM	Datetime that a worklist times out
TIMEDOUT	Timed Out
PREVOPRID	Previous User ID
COMMENTSHORT	Short Comment
WLDAYSTOSELECT	Number of days to select a worklist instance
WLDAYSTOWORK	Number of days to work a worklist instance

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010