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 NameField TypeColumn TypeDescription
    TIMEOUT_BPCharacter(30)VARCHAR2(30) NOT NULLBusiness Process
    TIMEOUT_ACTCharacter(30)VARCHAR2(30) NOT NULLTimeout Activity
    TIMEOUT_EVENTCharacter(30)VARCHAR2(30) NOT NULLTimeout Event
    TIMEOUT_WLCharacter(30)VARCHAR2(30) NOT NULLTimeout Worklist
    TIMEOUT_INSTANCENumber(10,0)DECIMAL(10) NOT NULLInstance ID
    TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
    ACTIONDTTMDateTime(26)TIMESTAMPDatetime action was taken on a worklist
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    ORIGINATORTYPENumber(5,0)INTEGER NOT NULLOriginator Type
    ORIGINATORIDCharacter(30)VARCHAR2(30) NOT NULLOriginator Identifier
    INSTSTATUSNumber(5,0)INTEGER NOT NULLDetermines worklist status, available, selected, worked, cancelled
    INSTAVAILABLEDTTMDateTime(26)TIMESTAMP NOT NULLDatetime worklist instance was made available
    INSTSELECTEDDTTMDateTime(26)TIMESTAMPDatetime user selected a worklist entry
    INSTWORKEDDTTMDateTime(26)TIMESTAMPDatetime worklist instance was worked by a user
    INSTTIMEOUTDTTMDateTime(26)TIMESTAMPDatetime that a worklist times out
    TIMEDOUTNumber(5,0)INTEGER NOT NULLTimed Out
    PREVOPRIDCharacter(30)VARCHAR2(30) NOT NULLPrevious User ID
    COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
    WLDAYSTOSELECTNumber(16,7)DECIMAL(15,7) NOT NULLNumber of days to select a worklist instance
    WLDAYSTOWORKNumber(16,7)DECIMAL(15,7) NOT NULLNumber of days to work a worklist instance
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19