SADBPVHEGSCTLNG

(SQL View)
 Index Back

View Security HEGIS code

FS 03052004

SELECT DISTINCT a.hegis_code ,b.oprid ,c.LANGUAGE_CD ,c.descr FROM PS_ACAD_PROG_TBL a ,ps_scrty_tbl_prog b ,PS_HEGIS_CODE_LANG C WHERE b.access_cd = 'Y' AND a.institution = b.institution AND a.acad_career = b.acad_career AND A.HEGIS_CODE = C.HEGIS_CODE AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ACAD_PROG_TBL A_ED WHERE A.INSTITUTION = A_ED.INSTITUTION AND A.ACAD_PROG = A_ED.ACAD_PROG AND A_ED.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_HEGIS_CODE_LANG C_ED WHERE C.HEGIS_CODE = C_ED.HEGIS_CODE AND c.LANGUAGE_CD = C_ED.LANGUAGE_CD AND C_ED.EFFDT <= A.EFFDT) AND (a.acad_prog = b.acad_prog OR b.acad_prog = 'ALL') AND NOT EXISTS ( SELECT 'X' FROM ps_scrty_tbl_prog c WHERE c.access_cd = 'N' AND c.oprid = b.oprid AND c.institution = b.institution AND c.acad_career = b.acad_career AND c.acad_prog = a.acad_prog) UNION SELECT DISTINCT C.HEGIS_CODE ,%OperatorId ,C.LANGUAGE_CD ,C.DESCR FROM PS_SSR_HEGISCD_NLD NL ,PS_HEGIS_CODE_LANG C WHERE C.HEGIS_CODE = NL.HEGIS_CODE AND NL.SCC_HEGIS_TYPE_NLD ='K' AND C.EFFDT = NL.EFFDT AND C.EFFDT = ( SELECT MAX(C_ED1.EFFDT) FROM PS_SSR_HEGISCD_NLD C_ED1 WHERE C_ED1.HEGIS_CODE = C.HEGIS_CODE AND C_ED1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SAD_BPV_HEG_SCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description