Highlights

Record Level: Student by school by year 
Record Count: approx. 1.7 million students per year 
Years Covered: 2004-Present 
Population Coverage: Public school students in Michigan

The K-12 student data contain commonly requested longitudinal student-level educational data from the K-12 environment. Available datasets reflect information about K-12 graduation, enrollment, demographics and program participation. Sources for these data include the Michigan Student Data System (MSDS) Fall, Spring, and End-of-Year General Collection Submissions, MSDS Teacher Student Data Link (TSDL) Collection, Educational Entity Master (EEM), and the Graduation and Dropout Application (GAD). While the panel extends back to 2004, availability of specific variables will vary for earlier years.

Only public school students are included in the data sets. In addition to K-12 students, these data include pre-K students and special education transition students over the age of 18. Students attending non-public schools and students using a non-public residency code at a public school (i.e., home school and private school students), as well as students enrolled only in Adult Education, are excluded.

Prior to school year 2017-18, a student was counted as absent by a district only if they missed a full day of school. Beginning with school year 2017-18, that criteria changed so that students are counted as absent if they miss more than 50 percent of the school day. This aligns with Every Student Succeeds Act requirements. For details on this reporting, exemptions and other information, please see the MSDS Collection Details Manual on the CEPI website. Specifically, the definition of what counts as attendance changed in the following way as described in the Michigan collection manual.

What counts as attendance prior to 2017-18?What counts as attendance starting in 2017-18?
Count attendance for any part of the school day as a day in attendance. Report participation in half-day kindergarten, special education for preprimary-aged students (3-5 years of age), or any other pupil program as a day in attendance.Count attendance for a student who is present at least 50% of the school day as a day in attendance. Report participation in half-day kindergarten, special education for preprimary-aged students (3-5 years of age), or any other pupil program as a day in attendance.

The geocoded student data contains census block information for each student enrolled in a K-12 school in Michigan, where one or more parent or guardian addresses have been geocoded successfully. The dataset covers PK-12 students (i.e., K12 students, those in Early On, Early Childhood Special Education, Early Childhood and Pre-Kindergarten programs) for 2010 - present. Data for 2003 - 2009 only includes K12 students. It does not have any post-secondary student, since CEPI does not provide any demographics for those students beyond what's in the post-secondary datasets. The data are on the Student x Year x Building Code x Census Block level for records preceding the 2010 school year. Starting in 2009-2010, the census block is also resolved at the collection level (Spring, Fall, End of Year) meaning the order of census blocks resided in is now knowable. New data are delivered on a yearly basis. Data from the 2002-2003 EOY collection forward are available. Due to the addition of ISD code and name variables in the 2016-2017 EOY delivery, previous years have null values for these variables.

The academic years covered by the K12 student data vary. Student demographic, enrollment and program data currently span from 2013 to present. MEDC has expanded the panel back to 2003 using archived data for certain demographic and enrollment variables. Audited graduation or cohort records begin in 2008. Census block data begin in 2003.

Note: There are variables under the Category of Program Participation that could be assumed to fall under the Category of Demographics, but they do not . Those variables indicate participation in programs designed to meet the needs of particular populations, but the variables do not specify fulfillment of any particular criteria to receive those services.

Codebook

Showing 1 - 100 of 149 results
Category Sort descending Variable Description
Category: All Variable: COLLECTION_SOURCE Description: NULL
Category: All Variable: BUILDING_CODE Description: NULL
Category: All Variable: SUBMITTING_SCHOOL_CODE Description: NULL
Category: All Variable: SUBMITTING_DISTRICT_CODE Description: NULL
Category: All Variable: SCHOOL_YEAR Description: Description of the school year that the data represents.
Category: All Variable: SCHOOL_NAME Description: The five-digit code assigned to the building in the Educational Entity Master
Category: All Variable: SCHOOL_CODE Description: 5-digit building code assigned to the building in EEM
Category: All Variable: RIC Description: The unique student identifier--Research Identification Code.
Category: All Variable: REPORTING_PERIOD Description: Reporting period (fall, spring, school year) the data represents
Category: All Variable: OPERATIONAL_ISD_NAME Description: District (ISD, ESA) name recorded by EEM in which program is located
Category: All Variable: OPERATIONAL_ISD_CODE Description: Number recorded by EEM to identify school district in which program is located
Category: All Variable: OPERATIONAL_DISTRICT_NAME Description: Public school district recorded by EEM for the reported student
Category: All Variable: OPERATIONAL_DISTRICT_CODE Description: state-assigned 5-digit number which identifies student's public school district
Category: All Variable: ISD_CODE Description: NULL
Category: All Variable: DISTRICT_CODE Description: NULL
Category: Census Block Variable: CENSUS_BLOCK_2020 Description: NULL
Category: Census Block Variable: COLLECTION Description: NULL
Category: Census Block Variable: CENSUS_BLOCK_2010 Description: NULL
Category: Demographics Variable: PRIMARY_DISABILITY_CODE_SY Description: Student's primary disability selected for federal reporting by CEPI
Category: Demographics Variable: ZIP_CODE Description: NULL
Category: Demographics Variable: STABLE_RACE_ETHNIC Description: The latest MSDS-recorded racial/ethnic category for the student for all time
Category: Demographics Variable: STABLE_GRAD_YEAR Description: The latest recorded graduation year for the student for all time
Category: Demographics Variable: STABLE_GENDER Description: The latest MSDS-recorded gender for the student for all time
Category: Demographics Variable: RESIDENT_DISTRICT_CODE Description: 5-digit code for geographic district in which student's guardian resides
Category: Demographics Variable: RESIDENCY_STATUS_CODE Description: Indicates students residency related to district boundaries
Category: Demographics Variable: READING_DEFICIENCY_IDENTIFIED Description: Indicates whether student had a reading deficiency at the start of the year
Category: Demographics Variable: READING_DEFICIENCY_CONTINUATION Description: Indicates whether student had reading deficiency at the end of the year
Category: Demographics Variable: RACIAL_ETHNIC_CODE_RAW Description: The ethnicity or race of the student.
Category: Demographics Variable: PRIMARY_LEP_LANGUAGE_SY Description: Student's native language selected for federal reporting by CEPI
Category: Demographics Variable: PRIMARY_ED_SETTING_SY Description: Student's primary special education setting selected for reporting by CEPI
Category: Demographics Variable: PRIMARY_ED_SETTING_CODE_RAW Description: Name of facility where student participates in special education programs
Category: Demographics Variable: PRIMARY_DISABILITY_CODE_RAW Description: Primary disability code identified on student's IEP defined by MARSE
Category: Demographics Variable: MONTH_YEAR_BIRTH_STABLE Description: The latest MSDS-recorded date of birth for the student for all time
Category: Demographics Variable: IS_UNACCOMPANIED_YOUTH Description: an individual who is not in the physical custody of a parent or guardian
Category: Demographics Variable: MONTH_YEAR_BIRTH_RAW Description: Date that student was born as on legal documents
Category: Demographics Variable: GENDER_RAW Description: Indicates if the student is male or female
Category: Demographics Variable: GRADE_RAW Description: The grade level or the educational setting in which the student is enrolled.
Category: Demographics Variable: GRADE_SY Description: Student's primary grade selected for reporting by CEPI
Category: Demographics Variable: GRADUATION_COHORT_YEAR Description: The cohort year the student is grouped into for tracking graduation outcomes
Category: Demographics Variable: HOMELESS_CODE Description: Primary nighttime residence of a student identified as homeless
Category: Demographics Variable: IS_COHORT_YEAR_CONFLICT Description: indicates whether students graduation cohort year has changed
Category: Demographics Variable: IS_ECONOMICALLY_DISADVANTAGED Description: Student eligible for free/reduced meal, SNAP/TANF, homeless, migrant or foster
Category: Demographics Variable: IS_GRADUATED_SY Description: Indicates student graduated in this school year (SCHOOL_YEAR)
Category: Demographics Variable: IS_MILITARY_CONNECTED Description: Indicates parent is a member of Armed Force on active duty
Category: Demographics Variable: IS_STABLE_DATE_BIRTH_CONFLICT Description: indicates if conflicting DOB values have ever been repoted for the student
Category: Demographics Variable: IS_STABLE_GENDER_CONFLICT Description: indicates if conflicting gender values have been reported for the student
Category: Demographics Variable: IS_STABLE_RACE_ETHNIC_CONFLICT Description: Indicates conflicting racial/ethnic category values reported for student
Category: Demographics Variable: ETHNICITY_CODE_RAW Description: A 6-digit field indicating race/ethnicity
Category: English Learner and Immigrant Variable: LEP_LANGUAGE_CODE_5 Description: Code for student's primary or home language if not English
Category: English Learner and Immigrant Variable: LEP_LANGUAGE_CODE_4 Description: Code for student's primary or home language if not English
Category: English Learner and Immigrant Variable: LEP_LANGUAGE_CODE_3 Description: Code for student's primary or home language if not English
Category: English Learner and Immigrant Variable: LEP_INSTR_PROG_CODE_4 Description: Code for English language program in which the student is enrolled
Category: English Learner and Immigrant Variable: LEP_LANGUAGE_CODE_2 Description: Code for student's primary or home language if not English
Category: English Learner and Immigrant Variable: LEP_INSTR_PROG_CODE_5 Description: Code for English language program in which the student is enrolled
Category: English Learner and Immigrant Variable: LEP_INSTR_PROG_CODE_3 Description: Code for English language program in which the student is enrolled
Category: English Learner and Immigrant Variable: LEP_INSTR_PROG_CODE_2 Description: Code for English language program in which the student is enrolled
Category: English Learner and Immigrant Variable: LEP_INSTR_PROG_CODE_1 Description: Code for English language program in which the student is enrolled
Category: English Learner and Immigrant Variable: LEP_LANGUAGE_CODE_1 Description: Code for student's primary or home language if not English
Category: Enrollment and Attendance Variable: IS_IEP_PLACED_ANOTHER_DISTRICT Description: Denotes enrollment in center, co-op, district special education program
Category: Enrollment and Attendance Variable: IS_MOST_PRIMARY Description: Denotes the records from a students primary school for most collection periods
Category: Enrollment and Attendance Variable: IS_NON_RESIDENT Description: Indicates non-resident student attendance for at least one collection period
Category: Enrollment and Attendance Variable: IS_SCHOOL_OF_CHOICE Description: Indicates non-resident student attendance using Section 105
Category: Enrollment and Attendance Variable: IS_SPRING_PRIMARY Description: Indicates the primary school record for the student for the spring time period
Category: Enrollment and Attendance Variable: LEP_EXIT_DATE Description: The date that the student was no longer engaged in LEP or ESL
Category: Enrollment and Attendance Variable: LEP_REENTRY_DATE Description: The date the student re-engaged in LEP or ESL programs
Category: Enrollment and Attendance Variable: SCHOOL_LOCALE Description: Measure of school's geographic status on a range from 'large city' to 'rural'
Category: Enrollment and Attendance Variable: SPECIAL_ED_EXIT_DATE Description: The date student last participated in special ed program w/ procided reason
Category: Enrollment and Attendance Variable: SPECIAL_ED_EXIT_REASON Description: Reason student is no longer in special education program
Category: Enrollment and Attendance Variable: SPRING_SPECIAL_EDUCATION_FTE Description: Section52FTE + Section53FTE from Spring collection
Category: Enrollment and Attendance Variable: SPRING_TOTAL_FTE Description: GeneralEdFTE + Section52FTE + Section53FTE from Spring collection
Category: Enrollment and Attendance Variable: IS_FALL_PRIMARY Description: NULL
Category: Enrollment and Attendance Variable: IS_FIRST_PRIMARY Description: record from the first primary school seen for the student for the school year .
Category: Enrollment and Attendance Variable: DAYS_ATTENDED Description: Total number of days student attended education services
Category: Enrollment and Attendance Variable: DAYS_POSSIBLE Description: The total number of days that education services were available to the student
Category: Enrollment and Attendance Variable: ENROLLMENT_DATE Description: The date of student's first attendance in education programs
Category: Enrollment and Attendance Variable: ENTITY_TYPE Description: Labels the entity by type
Category: Enrollment and Attendance Variable: EXIT_DATE Description: The date of the first day after a student left school
Category: Enrollment and Attendance Variable: EXIT_STATUS Description: Student's current enrollment status or reason for non-enrollment
Category: Enrollment and Attendance Variable: EXIT_STATUS_CODE Description: Code for student's enrollment status or reason for non-enrollment
Category: Enrollment and Attendance Variable: FALL_SPECIAL_EDUCATION_FTE Description: Section52FTE + Section53FTE from Fall collection
Category: Enrollment and Attendance Variable: FALL_TOTAL_FTE Description: GeneralEdFTE + Section52FTE + Section53FTE from Fall collection
Category: Enrollment and Attendance Variable: IS_EOY_PRIMARY Description: primary school record for the student for the end-of-year time period
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_6 Description: Code for type of additional instruction acitivites delivered to studen
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_3 Description: Code for reason modification was made to student's curriculum
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_2 Description: Code for reason modification was made to student's curriculum
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_1 Description: Code for reason modification was made to student's curriculum
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_7 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_6 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_5 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_4 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_3 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_2 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_1 Description: Code for academic area the student has Personal Curriculum Credit Modification
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_5 Description: Code for type of additional instruction acitivites delivered to studen
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_4 Description: Code for type of additional instruction acitivites delivered to studen
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_3 Description: Code for type of additional instruction acitivites delivered to studen
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_2 Description: Code for type of additional instruction acitivites delivered to studen
Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_1 Description: Code for type of additional instruction acitivites delivered to studen
Category: Program Participation Variable: IS_SEAT_TIME_WAIVER Description: Denotes student receiving virtual instruction for 3+ courses
Category: Program Participation Variable: IS_TITLE_I_TAS_PROGRAM Description: Student participated in a targeted assistance school (TAS) program.