WF_TIMEOUT_SRCH

Return to Index

View: PS_WF_TIMEOUT_SRCH

Timeout Worklist View

PlatformView Text
DefaultSELECT 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 NameDescription
    TIMEOUT_BPBusiness Process
    TIMEOUT_ACTTimeout Activity
    TIMEOUT_EVENTTimeout Event
    TIMEOUT_WLTimeout Worklist
    TIMEOUT_INSTANCEInstance ID
    TRANSACTIONIDTransaction Identifier
    ACTIONDTTMDatetime action was taken on a worklist
    OPRIDA user's ID

    Prompt Table: OPRDEFN2

    ORIGINATORTYPEOriginator Type
    ORIGINATORIDOriginator Identifier
    INSTSTATUSDetermines worklist status, available, selected, worked, cancelled
    0=Selected
    1=Open
    2=Worked
    3=Cancelled
    INSTAVAILABLEDTTMDatetime worklist instance was made available
    INSTSELECTEDDTTMDatetime user selected a worklist entry
    INSTWORKEDDTTMDatetime worklist instance was worked by a user
    INSTTIMEOUTDTTMDatetime that a worklist times out
    TIMEDOUTTimed Out
    PREVOPRIDPrevious User ID
    COMMENTSHORTShort Comment
    WLDAYSTOSELECTNumber of days to select a worklist instance
    WLDAYSTOWORKNumber of days to work a worklist instance

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010