students.csv

students.csv

The students data file will provide demographics information and other characteristics for each student of the institution. This file should be provided each requested academic period to track new students as they enter the institution. It is acceptable to have the students file include all the same students that are included in the terms file for the same academic period. At minimum, the students file should include the students who are new to the school during the specified academic period based on the entry status: new enrollment, transfer, etc. Definitions for status are provided in the table below under 'entry_status'. This file should include one row per student ID and a distinct status.

Examples can be found for each column in the image above or here in the sample file.

Note that column names are case sensitive and must be listed exactly as shown below.

Column Name	Acceptable Values
id	Student ID provided by the institution
first_name	Student's first name No commas Use "NoFirstName" if student does not have an associated first name on file
last_name	Student's last name No commas Use "NoLastName" if student does not have an associated last name on file
date_of_birth	Student's day and year of birth dd/yyyy* (may use 00/0000 if student DOB has not been provided) *Please click here for instructions to format this column correctly.
ethnicity	Student's ethnicity One of (must be exact as shown below): American Indian or Alaska Native Asian Black or African American Hispanic Native Hawaiian or Other Pacific Islander White Two or more races Race/ethnicity unknown Nonresident alien
gender	Student's gender One of: M F Unknown Other Empty cell
status	Student entry status indicator where: FTFT (First-time full-time student) FT (First-time only student) (for first-time part time) FTGRAD (First-time graduate student) TRANSFER (Transfer student) OTHER (Other status)
entry_academic_period	Academic period of initial enrollment for this student under the specific status code One of Winter yyyy, Spring yyyy, Summer yyyy, Fall yyyy. Where yyyy is the 4-digit year format
exclusion_type	IPEDS cohort exclusion type This should only be provided if a student should be excluded from the graduating cohort. IPEDS states that an exclusion can only happen if one of the documented exclusion types occurs within 150% of normal time to completion for their program One of: Deceased Armed_Forces Foreign_Aid_Service Church_Mission Empty cell
exclusion_academic_period	Academic period in which an IPEDS cohort exclusion might have occurred One of Winter yyyy, Spring yyyy, Summer yyyy, Fall yyyy. Where yyyy is the 4-digit year format Empty cell
act_composite	Student composite ACT score a whole number between 1-36 without commas or quotes Empty cell
act_math	Student math ACT score a whole number between 1-36 without commas or quotes Empty cell
act_english	Student english ACT score a whole number between 1-36 without commas or quotes Empty cell
act_reading	Student reading ACT score a whole number between 1-36 without commas or quotes Empty cell
sat_combined	Student’s combined SAT score of math and reading/writing Acceptable values include scores between 400-1600 without decimals or commas or an empty cell where no score is available
sat_math	Student’s score from the math section of the SAT Acceptable values include scores between 200-800 without decimals or commas or an empty cell where no score is available
sat_verbal	Student’s score from the verbal section of the SAT Pre 2005 scores associated with the Verbal section Acceptable values include scores between 200-800 without decimals or commas or an empty cell where no score is available
sat_reading	Student’s score from the reading section of the SAT Pre 2005 scores associated with the reading section 2005-2015 scores for Critical Reading 2016-2024 scores for the Evidence-Based Reading and Writing Post 2024 scores for the Reading and Writing Acceptable values include scores between 200-800 without decimals or commas or an empty cell where no score is available
hs_gpa	Student high school GPA a decimal between 0.0-5.x without commas or quotes Empty cell
hs_city	City where student attended high school Empty cell
hs_state	State where student attended high school Empty cell
hs_zip	Zip Code where student attended high school Blank or empty
email	school provided email address assigned to the student when a student does not have a school assigned email, a student's personal email may be submitted if no email exists for a student, use "noemail@noemail.com"
entry_age	Student entry age in years a whole number between 1-110 without commas or quotes Empty cell
ged	Student received GED indicator One of: TRUE FALSE Empty cell
english_2nd_language	English as a second language indicator One of: TRUE FALSE Empty cell
first_generation	Student first generation indicator One of: TRUE FALSE Empty cell

Questions?

What file format does my file need to be in?
When is my file due?
Where do I drop my file?