WF_TIMEOUT_SRCH

index back

Timeout Worklist View


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

  • Parent record: PSBUSPROCDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    TIMEOUT_BP Character(30) VARCHAR2(30) NOT NULL Business Process
    TIMEOUT_ACT Character(30) VARCHAR2(30) NOT NULL Timeout Activity
    TIMEOUT_EVENT Character(30) VARCHAR2(30) NOT NULL Timeout Event
    TIMEOUT_WL Character(30) VARCHAR2(30) NOT NULL Timeout Worklist
    TIMEOUT_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Instance ID
    TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    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: OPRDEFN2

    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 NOT NULL 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
    INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
    TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
    PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
    COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    WLDAYSTOSELECT Number(16,7) DECIMAL(15,7) NOT NULL Number of days to select a worklist instance
    WLDAYSTOWORK Number(16,7) DECIMAL(15,7) NOT NULL Number of days to work a worklist instance
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19