SSR_BR_CTVW_LNG

(SQL View)
 Index Back

Setup Category Codes Lang rec


SELECT A.SSR_BR_CAT_CD_NLD , B.LANGUAGE_CD , A.DESCRSHORT FROM PS_SSR_BR_CTCD_NLD A , PS_SSR_BR_CTCD_LNG B WHERE A.EFFDT <= ( SELECT MAX(A1.EFFDT) FROM PS_SSR_BR_CTCD_NLD A1 WHERE A1.EFF_STATUS = 'A' AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.SSR_BR_CAT_CD_NLD = B.SSR_BR_CAT_CD_NLD

  • Related Language Record for SSR_BR_CTVW_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_BR_CAT_CD_NLD Character(10) VARCHAR2(10) NOT NULL Category Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description