Displays the student headcount and FTE by ethnicity for FS1995 - FS1999, by campus, school, department, and degree program. In order to report school and departmental data, the UIDS departmental structure, as found in the UIDS.UIDS_LINK table, is used. The table reflects the official counts, as reported to the state and federal government on the DHE 02 and IPEDS EF1.
SELECT "UIDS"."SIS_ENRL"."CMP_CD" as cmp_cd,
"UIDS"."SIS_ENRL"."TERM" as term,
"UIDS"."SIS_ENRL"."STU_LVL" as s_level,
"UIDS"."SIS_ENRL"."FT_INDCTR" as ft_ind,
"UIDS"."SIS_ENRL"."ENR_FTE" as fte,
"UIDS"."SIS_ENRL"."ETHNC_DESC" as ethnic,
"UIDS"."SIS_ENRL"."DEG_SEEK_INDCTR" as ds_ind,
"UIDS"."SIS_ENRL"."IPEDS_FST_INDCTR" as iped_ind,
"UIDS"."UIDS_LINK"."UIDS_LINK_CD" as uids_cd,
"UIDS"."UIDS_LINK"."UIDS_LINK_DESC" as depart,
"UIDS"."SIS_ENRL"."HRS_ERND_TOT" as tot_hrs,
"UIDS"."SIS_ENRL"."RES_STAT_DESC" as resid
FROM "UIDS"."SIS_ENRL",
"UIDS"."DEG_SGHT",
"UIDS"."UIDS_LINK"
WHERE ( "UIDS"."SIS_ENRL"."TERM" = "UIDS"."DEG_SGHT"."TERM" ) and
( "UIDS"."SIS_ENRL"."FISCAL_YR" = "UIDS"."DEG_SGHT"."FISCAL_YR" ) and
( "UIDS"."SIS_ENRL"."CMP_CD" = "UIDS"."DEG_SGHT"."CMP_CD" ) and
( "UIDS"."SIS_ENRL"."STU_FED_ID_NO"="UIDS"."DEG_SGHT"."STU_FED_ID_NO")and
( "UIDS"."DEG_SGHT"."CMP_CD" = "UIDS"."UIDS_LINK"."CMP_CD" ) and
( "UIDS"."DEG_SGHT"."PGM_DEPT_CD" = "UIDS"."UIDS_LINK"."SIS_DEPT_CD" ) and
( "UIDS"."DEG_SGHT"."FISCAL_YR" = "UIDS"."UIDS_LINK"."FISCAL_YR" ) and
( "UIDS"."SIS_ENRL"."TERM" between 'FS1995' and 'FS1999' ) AND
( "UIDS"."DEG_SGHT"."PGM_INDCTR_CD" = 'P' )