SSR_BR_ARVW_NLD

(SQL View)
 Index Back

Setup Arrangement Codes for BO


SELECT A.SSR_BR_ARR_CD_NLD , A.DESCRSHORT FROM PS_SSR_BR_ARCD_NLD A 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'

  • Related Language Record: SSR_BR_ARVW_LNG

    • # 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description