Student Table 3 Documentation: FTF Majors - ACT Scores

Displays the academic preparation of First-Time Freshman for the past five fall semesters, by campus, 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. 

SQL used to create Student Table 3:

( SELECT "UIDS"."SIS_ENRL"."CMP_CD" as cmp_cd,

"UIDS"."SIS_ENRL"."TERM" as term,

"UIDS"."SIS_ENRL"."STU_FED_ID_NO" as ssn,

"UIDS"."SIS_ENRL"."HS_PCTL" as hsrank

"EMSAS"."STU_ENRL"."EXAM_SCORE_ACT_CMPST" as score,

"UIDS"."UIDS_LINK"."UIDS_LINK_CD" as uids_cd,

"UIDS"."UIDS_LINK"."UIDS_LINK_DESC" as depart,

"UIDS"."UIDS_LINK"."UIDS_DIV_CD" as div_cd,,

"UIDS"."UIDS_LINK"."UIDS_DIV_DESC" as division

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 = EMSAS.STU_ENRL.UIDS_TERM (+)) and

( UIDS.SIS_ENRL.CMP_CD = EMSAS.STU_ENRL.UIDS_CMP_CD (+)) and

( UIDS.SIS_ENRL.STU_FED_ID_NO = EMSAS.ST_ENRL.SSN_MOST_RCNT (+)) and

( "UIDS"."SIS_ENRL"."TERM" between 'FS1996' and 'FS1999' ) and

( "UIDS"."DEG_SGHT"."PGM_INDCTR_CD" = 'P' )and

( UIDS."SIS_ENRL"."DEG_SEEK_INDCTR" = 'Y' ) and

( UIDS."SIS_ENRL"."FT_INDCTR" = 'Y' ) and

( UIDS."SIS_ENRL"."IPEDS_FST_INDCTR" = 'Y' )and

( UIDS."SIS_ENRL"."STU_LVL" in ( 'FRESHMAN','SOPHOMORE','JUNIOR','SENIOR' ) ) ) );