Set up your data for IPEDS Admissions processing

To use the produce_adm_report function, your student admissions data must be in the format described below

This population should meet IPEDS rules for inclusion on this report (those seeking to be admitted to undergraduate programs as first-time full-time degree/certificate seekers, including transfer students). This data file is not necessary if your institution has an open-admissions policy for entering first-time students.

Column Name Column Type Acceptable Value - Definition
Unitid Numeric (relevant unitid; xxxxxx)
StudentId Character or Numeric (any unique identifier for each student)
RaceEthnicity Numeric 1 - Nonresident alien
2 - Hispanic/Latino
3 - American Indian or Alaska Native
4 - Asian
5 - Black or African American
6 - Native Hawaiian or Other Pacific Islander
7 - White
8 - Two or more races
9 - Race and ethnicity unknown
Sex Numeric 1 - Men
2 - Women
GenderDetail Numeric 1 - Men
2 - Women
3 - Unknown sex
[following existing format of other student-related files]
IsApplicant Numeric 0 - Is not an applicant
1 - Is an applicant per IPEDS definition
IsAdmitted Numeric 0 - Not admitted
1 - Admitted
IsEnrolled Numeric 0 - Not enrolled
1 - Enrolled
IsFullTime Numeric 0 - Not full time (Part time)
1 - Full Time
IsFirstTime Numeric 0 - Not First Time
1 - First Time
IsTransfer Numeric 0 - Not a Transfer
1 - Transfer
SATUsed Numeric 0 - SAT not used in admission decision
1 - SAT used in admission decision (If BOTH SAT and ACT are used in the student’s admission decision, mark each one as 1)
ACTUsed Numeric 0 - ACT not used in admission decision
1 - ACT used in admission decision (If BOTH SAT and ACT are used in the student’s admission decision, mark each one as 1)
SAT_Evbrw Numeric 200 - 800 (leave blank or use 0 for “Not used” students)
SAT_Math Numeric 200 - 800 (leave blank or use 0 for “Not used” students)
ACT_Comp Numeric 1 - 36 (leave blank or use 0 for “Not used” students)
ACT_Eng Numeric 1 - 36 (leave blank or use 0 for “Not used” students)
ACT_Math Numeric 1 - 36 (leave blank or use 0 for “Not used” students)