SSR_BR_LOBPELNG

(SQL View)
 Index Back

LOB CD view for CAF LOV

LOB CD Rel lang view for CAF LOV for Prior Ed

SELECT DISTINCT HN.SCC_LOB_CODE_NLD ,HCL.LANGUAGE_CD ,HCL.DESCR60 FROM PS_SSR_HEGISCD_NLD HN , PS_HEGIS_CODE_TBL HC ,PS_HEGIS_CODE_LANG HCL WHERE HN.HEGIS_CODE = HC.HEGIS_CODE AND HN.EFFDT = HC.EFFDT AND HC.EFF_STATUS = 'A' AND HN.SCC_EDU_LEVEL_NLD IN ('HA', 'VWO', 'TL', 'BB', 'KB', 'GL') AND (LENGTH(HN.SCC_LOB_CODE_NLD) = 4 ) AND HN.EFFDT = ( SELECT MAX(H.EFFDT) FROM PS_HEGIS_CODE_TBL H WHERE HN.HEGIS_CODE = H.HEGIS_CODE AND H.EFFDT <= %CurrentDateIn) AND HCL.HEGIS_CODE = HC.HEGIS_CODE AND HCL.EFFDT = HC.EFFDT ORDER BY 2

  • Related Language Record for SSR_BR_LOBPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_LOB_CODE_NLD Character(10) VARCHAR2(10) NOT NULL Lob Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description