SAD_SBB_HEG_VW(SQL View) |
Index Back |
---|---|
SBB Hegis Code Selection View |
SELECT HGNL.HEGIS_CODE , HGNL.SCC_HEGIS_TYPE_NLD , 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.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 | SCC_HEGIS_TYPE_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Hegis Code Type
C=Course E=Elective K=Elective P=Program T=Testimony |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |