WF_TIMEOUT_SRCH

Platform

View Text

Default

SELECT PSWORKLIST.BUSPROCNAME , PSWORKLIST.ACTIVITYNAME , PSWORKLIST.EVENTNAME , PSWORKLIST.WORKLISTNAME , PSWORKLIST.INSTANCEID , PSWORKLIST.TRANSACTIONID , PSWORKLIST.ACTIONDTTM , PSWORKLIST.OPRID , PSWORKLIST.ORIGINATORTYPE , PSWORKLIST.ORIGINATORID , PSWORKLIST.INSTSTATUS , PSWORKLIST.INSTAVAILABLEDTTM , PSWORKLIST.INSTSELECTEDDTTM , PSWORKLIST.INSTWORKEDDTTM , PSWORKLIST.INSTTIMEOUTDTTM , PSWORKLIST.TIMEDOUT , PSWORKLIST.PREVOPRID , PSWORKLIST.COMMENTSHORT , PSWORKLIST.WLDAYSTOSELECT , PSWORKLIST.WLDAYSTOWORK FROM PSWORKLIST , PSEVENTROUTE WHERE PSWORKLIST.ACTIVITYNAME = PSEVENTROUTE.ACTIVITYNAME AND PSWORKLIST.WORKLISTNAME = PSEVENTROUTE.ROUTENAME AND PSWORKLIST.EVENTNAME = PSEVENTROUTE.EVENTNAME AND PSEVENTROUTE.ROUTETYPE = 3 AND PSEVENTROUTE.TIMEOUTACTIVE = 1 AND PSWORKLIST.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