Additional updated content for expanded first-time and first-year definitions, including query language, may help improve the content of the page.

UMS Office of Internal Reporting Definitions for First-Time and First-Year Students
by Bill Gilfillan, 2014

Internal Reporting at the system office is frequently asked to produce numbers for first-time students and transfer students. The numbers are currently generated using the following categories:

  • First-Time First-Year Student
  • Other First-Time Undergraduate Student
  • Assoc to Bachelor Student
  • Post-Baccalaureate Student
  • Graduate Student
  • Law Student
  • Transfer Student
  • Readmit Student

It is incorrect to label all of these students as first-time students. However, the historical practice has been to include these various groups in a first-time student report. The following is a discussion of how the reporting group places students in the above groups. The relevant definitions from the Common Data Set and IPEDS are as follows.

COMMON DATA SET DEFINITIONS

First-time student: A student attending any institution for the first time at the level enrolled. Includes students enrolled in the fall term who attended a postsecondary institution for the first time at the same level in the prior summer term. Also includes students who entered with advanced standing (college credit earned before graduation from high school).

First-time, first-year (freshman) student: A student attending any institution for the first time at the undergraduate level. Includes students enrolled in the fall term who attended college for the first time in the prior summer term. Also includes students who entered with advanced standing (college credits earned before graduation from high school).

First-year student: A student who has completed less than the equivalent of 1 full year of undergraduate work; that is, less than 30 semester hours (in a 120-hour degree program) or less than 900 contact hours.

Transfer student: A student entering the institution for the first time but known to have previously attended a postsecondary institution at the same level (e.g., undergraduate). The student may transfer with or without credit.

IPEDS DEFINITIONS

First-time student (undergraduate): A student who has no prior postsecondary experience (except as noted below) attending any institution for the first time at the undergraduate level. This includes students enrolled in academic or occupational programs. It also includes students enrolled in the fall term who attended college for the first time in the prior summer term, and students who entered with advanced standing (college credits earned before graduation from high school).

First-year student: A student who has completed less than the equivalent of 1 full year of undergraduate work; that is, less than 30 semester hours (in a 120-hour degree program) or less than 900 contact hours .

Transfer-in student: A student entering the reporting institution for the first time but known to have previously attended a postsecondary institution at the same level (e.g., undergraduate, graduate). The student may transfer with or without credit.

Fall cohort: The group of students entering in the fall term established for tracking purposes. For the Graduation Rates component, this includes all students who enter an institution as full-time, first-time degree or certificate-seeking undergraduate students during the fall term of a given year.

Retention rate: A measure of the rate at which students persist in their educational program at an institution, expressed as a percentage. For four-year institutions , this is the percentage of first-time bachelors (or equivalent) degree-seeking undergraduates from the previous fall who are again enrolled in the current fall. For all other institutions this is the percentage of first-time degree/certificate-seeking students from the previous fall who either re-enrolled or successfully completed their program by the current fall.

UMS DEFINITIONS

The following are the definitions used for assigning students to first-time or transfer categories.

ADMIT_TERM_YEAR

CASE

WHEN SUBSTR(Admit Term,3,1) = '1'

THEN 20|| SUBSTR(Admit Term,1,2) - 1

ELSE 20 || SUBSTR(Admit Term,1,2)

END

This indicates the calendar year of the student’s admit term.

STRM_YEAR    

CASE

WHEN SUBSTR(Strm,3,1) = '1'

THEN 20|| SUBSTR(Strm,1,2) - 1

ELSE 20|| SUBSTR(Strm,1,2)

END

This indicates the calendar year of the student’s current enrollment term.

FIRST_TERM

CASE  

WHEN Admit Term = Strm         THEN 'Y'

WHEN SUBSTR(Strm,3,1) = '1'  AND SUBSTR(Admit Term,3,1) = '3'  AND          

STRM_YEAR - ADMIT_TERM_YEAR = 0 THEN 'Y'

ELSE 'N'

END

When the Admit Term is the same as the Strm then this indicates that this is the first term the student has attended an institution. This also applies to students who are enrolled in the fall term who attended the institution for the first time in the prior summer term.

DEGREE_NONDEG

8/3/20 NOTE: The code below is out of date and has been replaced with this Degree/Non-Degree Coding - Current.

CASE  

WHEN Acad Prog Primary LIKE '%UN'                           THEN 'Non-Degree'

WHEN Acad Prog Primary LIKE '%GN'                           THEN 'Non-Degree'

WHEN Acad Prog Primary LIKE '%PN'                           THEN 'Non-Degree'

WHEN Acad Prog Primary LIKE '%EU'                           THEN 'Non-Degree'

WHEN Acad Prog Primary = 'NDUG'                              THEN 'Non-Degree'

WHEN Acad Prog Primary = 'NDGR'                              THEN 'Non-Degree'

WHEN Acad Prog Primary = 'NDPR'                              THEN 'Non-Degree'

WHEN Acad Prog Primary = 'DIST'                                THEN 'Non-Degree'

WHEN Acad Prog Primary = 'P-NON'                             THEN 'Non-Degree'

WHEN Acad Prog Primary = 'NONCR'                            THEN 'Non-Degree'

WHEN Acad Prog Primary = 'GRNON'                            THEN 'Non-Degree'

ELSE 'Degree'

END    

FIRST_TIME

CASE  

WHEN FIRST_TERM = 'Y'  AND Institution = 'UMS05'

AND Acad Plan = 'ONW'                                                            THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Institution = 'UMS05'

AND Prog Reason = 'RADM'

AND DEGREE_NONDEG = 'Degree'                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type IN ('FYR','EFY')      

 AND (Acad Level Bot = '01' OR Acad Level Bot = '10')

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type IN ('FYR','EFY')      

AND Um last sch type = 'SCD'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'GRD'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'GR6'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'ATB'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'PBA’

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'TRF'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'REA'

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

WHEN FIRST_TERM = 'Y'  AND Admit Type = 'LAW'     

AND Acad Level Bot = 'L1'                                                       

AND DEGREE_NONDEG = ‘Degree’                                          THEN 'Y'

ELSE 'N'

END

ADMIT_TYPE_DESCRIPTION

CASE

WHEN FIRST_TIME = 'Y'  AND Institution = 'UMS05' AND Prog Reason = 'RADM' THEN 'Readmit Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'EFY' AND (Acad Level Bot = '01' OR Acad Level Bot = '10')  THEN 'First-Time First-Year Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'FYR' AND (Acad Level Bot = '01' OR Acad Level Bot = '10')  THEN 'First-Time First-Year Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'EFY'     THEN 'Other First-Time Undergraduate Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'FYR'     THEN 'Other First-Time Undergraduate Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'GRD'    THEN 'Graduate Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'GR6'     THEN 'Graduate Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'LAW'     THEN 'Law Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'ATB'      THEN 'Assoc to Bachelor Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'PBA'      THEN 'Post-Baccalaureate Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'REA'      THEN 'Readmit Student'

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'TRF'      THEN 'Transfer Student'

WHEN FIRST_TIME = 'N'                                               THEN 'Continuing Student'

ELSE 'Other'

END                                                                                                                                                   

This places students into one of the identified categories.

The following is a discussion of each part of the above expression. In all cases, non-degree students are excluded.

WHEN FIRST_TERM = 'Y'  AND Institution = 'UMS05'

AND Acad Plan = 'ONW'

This excludes Onward program students at UM

WHEN FIRST_TERM = 'Y'  AND Institution = 'UMS05'

AND Prog Reason = 'RADM'

This identifies first-time readmitted students at UM.

WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR'  

AND (Acad Level Bot = '01' OR Acad Level Bot = '10')

This identifies first-time first-year students. The level of 01 or 10 indicates freshman.

WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY'  

AND (Acad Level Bot = '01' OR Acad Level Bot = '10')

This also identifies first-time first-year students.

WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR'

This identifies other first-time students who are not first-year.

 WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY'

This also identifies other first-time students who are not first-year.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'GRD'

This identifies first-time graduate students.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'GR6'

This identifies first-time graduate students.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'ATB'

This identifies students who are moving from the Associate to the Bachelors program.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'PBA'

This identifies first-time post-baccalaureate students.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'TRF'

This identifies first-time transfer students.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'REA'

This identifies readmitted students.

WHEN FIRST_TIME = 'Y'  AND Admit Type = 'LAW'

AND Acad Level Bot = 'L1'

This identifies first-time law students. The level of L1 indicates 1st year law.


DG-120 - First-Time, First-Year & FT-FY Other: Why some who were previously enrolled? Closed

Students who took courses while in high school are assigned the FYR admit type and this is based on IPEDS definition.  The number of credits earned does not matter.  If courses are taken after high school, the student would be considered a transfer student.