SAD_BR_VA_HGCAF(SQL View) |
Index Back |
|---|
| SELECT HGNL.HEGIS_CODE , HG.DESCR FROM PS_SSR_HEGISCD_NLD HGNL JOIN PS_HEGIS_CODE_TBL HG ON HGNL.HEGIS_CODE = HG.HEGIS_CODE WHERE HG.EFF_STATUS = 'A' AND HGNL.SCC_EDU_LEVEL_NLD IN ('HA', 'VWO', 'TL') AND HGNL.EFFDT = ( SELECT MAX(HGNL1.EFFDT) FROM PS_SSR_HEGISCD_NLD HGNL1 WHERE HGNL1.HEGIS_CODE = HG.HEGIS_CODE AND HGNL1.EFFDT <= %CurrentDateIn) AND HG.EFFDT = ( SELECT MAX(HG1.EFFDT) FROM PS_HEGIS_CODE_TBL HG1 WHERE HG1.HEGIS_CODE = HG.HEGIS_CODE AND HG1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL | HEGIS Code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |