SCC_LOB_CODE_NLDSSR_BR_LOBPE_VW(SQL View) |
Index Back |
|---|---|
LOB CD view for CAF LOVLOB CD view for CAF LOV for Prior Ed |
| SELECT DISTINCT HN.SCC_LOB_CODE_NLD ,HC.DESCR60 FROM PS_SSR_HEGISCD_NLD HN , PS_HEGIS_CODE_TBL HC 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) ORDER BY 2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_LOB_CODE_NLD |
Character(10) | VARCHAR2(10) NOT NULL | Lob Code |
| 2 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |