SSR_BR_CTVW_NLD

(SQL View)
 Index Back

Setup Category Codes for BO


SELECT A.SSR_BR_CAT_CD_NLD , A.DESCRSHORT FROM PS_SSR_BR_CTCD_NLD A 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'

  • Related Language Record: SSR_BR_CTVW_LNG

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