WF_WORKLIST_LVW

index back

Tools Worklist View


SELECT a.BUSPROCNAME , a.ACTIVITYNAME , a.EVENTNAME , a.WORKLISTNAME , a.INSTANCEID ,b.language_cd , b.instatusdescr , a.COMMENTSHORT FROM psworklist a , PS_WF_INSTSTATUSLG b WHERE a.inststatus = b.inststatus

  • Related language record for WF_WORKLIST_VW
  • 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
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    INSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Worklist Instance Status
    COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19