Student Table 2 Documentation: Majors by Residency

Displays student enrollment of Majors by Residency status for the past five fall semesters, by campus. The table reflects the official counts, as reported to the state and federal government on the DHE 02 and IPEDS EF1. In order to report school and departmental data, the UIDS departmental structure, as found in the UIDS.UIDS_LINK table, is used 

SQL used to create Student Table 2:

( 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"."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' )