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.
SQL used to create Student Table 1:
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' )
Reviewed 2022-04-06