SSR_BR_ARVW_LNG

(SQL View)
 Index Back

Setup Arrangement Codes lang


SELECT A.SSR_BR_ARR_CD_NLD ,B.LANGUAGE_CD , A.DESCRSHORT FROM PS_SSR_BR_ARCD_NLD A , PS_SSR_BR_ARCD_LNG B WHERE A.EFFDT <= ( SELECT MAX(A1.EFFDT) FROM PS_SSR_BR_ARCD_NLD A1 WHERE A1.EFF_STATUS = 'A' AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.SSR_BR_ARR_CD_NLD = B.SSR_BR_ARR_CD_NLD

  • Related Language Record for SSR_BR_ARVW_NLD

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