|
SELECT a.acad_load_appr , a.emplid , g.oprid , b.name , b.last_name_srch , b.first_name_srch , a.acad_career , a.stdnt_car_nbr , a.acad_prog , c.descrshort , d.descrshort , k.birthdate , i.sex , j.campus_id , a.institution , H.HEGIS_CODE FROM PS_ACAD_PROG a , ps_person_name b , PS_ACAD_PROG_tbl c , ps_institution_tbl d , ps_scrty_tbl_prog g , PS_HEGIS_CODE_TBL H , PS_PERS_DATA_EFFDT i , PS_PERSON_SA j , PS_PERSON k WHERE g.access_cd = 'Y' AND a.institution = g.institution AND a.acad_career = g.acad_career AND a.prog_status = 'AC' AND C.HEGIS_CODE = H.HEGIS_CODE AND j.emplid = b.emplid AND k.emplid = b.emplid AND i.emplid = b.emplid AND (a.acad_prog = g.acad_prog OR g.acad_prog = 'ALL') AND NOT EXISTS ( SELECT 'X' FROM ps_scrty_tbl_prog g1 WHERE g1.access_cd = 'N' AND g1.oprid = g.oprid AND g1.institution = g.institution AND g1.acad_career = g.acad_career AND g1.acad_prog = a.acad_prog) AND a.emplid = b.emplid AND a.acad_prog = c.acad_prog AND a.institution = c.institution AND c.effdt = ( SELECT MAX(e.effdt) FROM PS_ACAD_PROG_tbl e WHERE e.acad_prog = a.acad_prog AND e.institution = a.institution AND e.effdt <= a.effdt) AND a.institution = d.institution AND d.effdt = ( SELECT MAX(f.effdt) FROM ps_institution_tbl f WHERE f.institution = a.institution AND f.effdt <= a.effdt)
|
SAD_PLAN_SEL_NLD