PSEVENTDEF_LVW

index back

Worklist Event Srch Record

Worklist Event Search Record - Language View
SELECT DISTINCT (A.EVENTNAME) , C.LANGUAGE_CD , C.DESCR60 FROM PSEVENTDEFN A , PSBUSPROCITEM B , PSBUSPITEMLANG C WHERE B.COMPTYPE = 7 AND A.EVENTNAME = B.COMPNAME AND B.COMPNAME = C.COMPNAME AND B.COMPTYPE = C.COMPTYPE

  • Related language record for PSEVENTDEF_SRCH
  • PeopleSoft Field NameField TypeColumn TypeDescription
    EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DESCR60Character(60)VARCHAR2(60) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19