WF_TO_WL_VW

index back

Timeout Worklist View


SELECT BUSPROCNAME, ACTIVITYNAME, EVENTNAME, WORKLISTNAME, INSTANCEID, TRANSACTIONID, ACTIONDTTM, OPRID, ORIGINATORTYPE, ORIGINATORID, INSTSTATUS, INSTAVAILABLEDTTM, INSTSELECTEDDTTM, IN STWORKEDDTTM, INSTTIMEOUTDTTM, TIMEDOUT, PREVOPRID, COMMENTSHORT, WLDAYSTOSELECT, WLDAYSTOWORK FROM PSWORKLIST WHERE 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