Set up your data for IPEDS 12 Month Enrollment processing

To use the produce_e1d_report function, you must provide two (2) dataframes: one with student enrollment data and one with instructional activity data.

The student enrollment data must be in the format described below

  • One row per person
  • One IPEDS Unitid per file
  • Columns with values and types as described below (additional columns are allowed)

Note: Column names can use any capitalization method you like

Column Name Column Type Acceptable Value - Definition
Unitid Numeric (relevant unitid; xxxxxx)
StudentId Character or numeric (any unique identifier for your students)
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 gender
4 - Another gender
IsFullTime Numeric 0 - Part Time
1 - Full Time
IsFirstTime Numeric 0 - Not First Time Student
1 - First Time Student
IsTransfer Numeric 0 - Not Transfer Student
1 - Transfer Student
IsDegreeCertSeeking Numeric 0 - Is NOT seeking a degree or certificate
1 - Is seeking a degree or certificate
StudentLevel Character Undergraduate
Graduate
IsHighSchool Numeric 0 - Not high school student
1 - High school student enrolled for credit
*If your institution does not not offer this option, use 0 for all students
DistanceEdAll Numeric 0 - Student is NOT enrolled exclusively in distance ed classes
1 - Student is enrolled exclusively in distance ed classes
DistanceEdSome Numeric 0 - Student is enrolled in 100% or 0% distance ed classes
1 - Student is enrolled in some but not all distance ed classes

The instructional activity data must be in the format described below

  • One row total, with a column for each reportable fact
  • One IPEDS Unitid per file
  • Columns with values and types as described below (additional columns are allowed)
Column Name Column Type Acceptable Value - Definition
Unitid Numeric (relevant unitid; xxxxxx)
CreditHoursUG Numeric Number representing total UG credit hours (see IPEDS instructions for details). Use 0 if your school does not use the credit-hours method.
ClockHoursUG Numeric Number representing total UG clock hours (see IPEDS instructions for details). Use 0 if your school does not use the clock-hours method.
CreditHoursGR Numeric Whole number representing total Graduate Student credit hours, omitting doctoral/professional hours (see IPEDS instructions for details). Use 0 if your school does not have graduate student credit hours.
DocFTE Numeric Total FTE of doctoral/professional students (see IPEDS instructions for details. Use 0 if you do not have any.