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