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 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
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    INSTATUSDESCRCharacter(10)VARCHAR2(10) NOT NULLWorklist Instance Status
    COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19