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 Name Field Type Column Type Description
    BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
    ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
    INSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Worklist Instance Status
    INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
    INSTSELECTEDDTTM DateTime(26) TIMESTAMP Datetime user selected a worklist entry
    INSTWORKEDDTTM DateTime(26) TIMESTAMP Datetime worklist instance was worked by a user
    TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
    COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19