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
IsDual	Numeric	0 - Not a part of a dual-enrollment high school program (HS enrolled in a different way for credit, or not HS at all) 1 - Part of a dual-enrollment high school program If your institution does not offer any credit for HS students, use 0 for everyone
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.