WF_WORKLIST_VW

index back

Tools Worklist View


SELECT a.BUSPROCNAME , a.ACTIVITYNAME , a.EVENTNAME , a.WORKLISTNAME , a.INSTANCEID , a.ACTIONDTTM , a.OPRID , a.ORIGINATORTYPE , a.ORIGINATORID , a.INSTSTATUS , b.instatusdescr , a.INSTAVAILABLEDTTM , a.INSTSELECTEDDTTM , a.INSTWORKEDDTTM , a.TIMEDOUT , a.COMMENTSHORT , a.TRANSACTIONID , a.URL FROM psworklist a , ps_wf_inststatus b WHERE a.inststatus = b.inststatus

  • Related language record: WF_WORKLIST_LVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    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
    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
    INSTATUSDESCRCharacter(10)VARCHAR2(10) NOT NULLWorklist Instance Status
    INSTAVAILABLEDTTMDateTime(26)TIMESTAMPDatetime worklist instance was made available
    INSTSELECTEDDTTMDateTime(26)TIMESTAMPDatetime user selected a worklist entry
    INSTWORKEDDTTMDateTime(26)TIMESTAMPDatetime worklist instance was worked by a user
    TIMEDOUTNumber(5,0)INTEGER NOT NULLTimed Out
    COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
    TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19