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:
- 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 combined SAT score
- a whole number between 400-1600 without commas or quotes
- Empty cell
|
sat_math |
- Student math SAT score
- a whole number or decimal between 200-800 without commas or quotes
- Empty cell
|
sat_verbal |
- Student verbal SAT score
- a whole number or decimal between 200-800 without commas or quotes
- Empty cell
|
sat_reading |
- Student reading SAT score
- a whole number or decimal between 200-800 without commas or quotes
- Empty cell
|
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 |
- Student's email address assigned by the college
|
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:
- Empty cell
|
english_2nd_language |
- English as a second language indicator
- One of:
- Empty cell
|
first_generation |
- Student first generation indicator
- One of:
- Empty cell
|