WORKLIST_VW2

index back

Worklist Entry View


SELECT A.INSTANCEID, B.BUSPROCNAME, B.ACTIVITYNAME, B.EVENTNAME, B.WORKLISTNAME, B.INSTANCEID, B.TRANSACTIONID, B.ACTIONDTTM, B.OPRID, B.ORIGINATORTYPE, B.ORIGINATORID, B.INSTSTATUS, B.IN STAVAILABLEDTTM, B.INSTSELECTEDDTTM, B.INSTWORKEDDTTM, B.INSTTIMEOUTDTTM, B.TIMEDOUT, B.PREVOPRID, B.COMMENTSHORT, B.WLDAYSTOSELECT, B.WLDAYSTOWORK FROM PSWORKLIST A, PSWORKLIST B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID <> B.INSTANCEID

  • Parent record: PSBUSPROCDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    INSTANCEID_ANumber(10,0)DECIMAL(10) NOT NULLWL Instance ID
    BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
    ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
    EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
    WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
    INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
    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).
    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