PSWLWLIST_LVW

index back

Worklist Name Search Record

Worklist Name Search Record - Language View
SELECT DISTINCT(A.ROUTENAME) , C.LANGUAGE_CD , C.DESCR60 FROM PSEVENTROUTE A , PSBUSPROCITEM B , PSBUSPITEMLANG C WHERE ( B.COMPTYPE = 8 OR B.COMPTYPE = 9) AND A.ROUTENAME = B.COMPNAME AND B.COMPNAME = C.COMPNAME AND B.COMPTYPE = C.COMPTYPE

  • Related language record for PSWLWLIST_SRCH
  • PeopleSoft Field NameField TypeColumn TypeDescription
    WL_FEED_PARAMETERSCharacter(30)VARCHAR2(30) NOT NULLField to store worklist feed parameter name like priority, status, timed out and worklist name in worklist feed related search records.
    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