Primary tabs

K-12 Student

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).

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.

The geocoded student data contains census block information for each student enrolled in a K-12 school in Michigan, with one or more addresses which have been geocoded successfully. Students in Early Childhood and Pre-Kindergarten programs are not included in this population. The data are on the Student by Year by Building Code or Census Block level. 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. New data are delivered on a yearly basis.

The academic years covered by the K12 student data vary. Student demographic, enrollment and program data currently span from 2013 to present. However, MEDC is working to expand this panel back to 2003 using archived data. Audited graduation or cohort records begin in 2008. Census block data begin in 2003.

Codebook

Category Variable Description
All OPERATIONAL_DISTRICT_CODE

The official state assigned five digit code denoting the district of the entity held accountable for the student's graduation status.

All OPERATIONAL_DISTRICT_NAME

The name, as recorded in the Educational Entity Master (EEM), which identifies the public school district responsible for providing education to the reported student. It is the district to which any applicable funds (state or

All OPERATIONAL_ISD_CODE

The state-assigned two-digit number, as recorded in the Educational Entity Master (EEM), that identifies the intermediate school district (ISD) or educational service agency (ESA) in which the district or program is located.

All OPERATIONAL_ISD_NAME

The name, as recorded in the Educational Entity Master (EEM), that identifies the intermediate school district (ISD) or educational service agency (ESA) in which the district or program is located.

All REPORTING_PERIOD

Description of the reporting period (school year, fall, spring) that the data represents.

All RIC

A unique student identifier for researchers.

All SCHOOL_CODE

The entity code assigned to the School or Facility (Building) held accountable for the student's graduation status.

All SCHOOL_NAME

The name as assigned to the building in the official Educational Entity Master for the Building Code.

All SCHOOL_YEAR

The start and end years of the schoolyear attended by the student during the collection used for this record.

Demographics DATE_OF_BIRTH_RAW

The date (month and year only for research data) on which the student was born as it appears on a birth certificate or other legal document presented at the time of enrollment.

Demographics GENDER_RAW

Indicates if the student is male or female. Code 'M' indicates the student is male. Code 'F' indicates the student is female.

Demographics GRADE_RAW

The grade level or the educational setting in which the student is enrolled.

Demographics GRADE_SY

The student's primary grade/setting as selected by CEPI reporting rules when multiple districts/schools report the student. (The grade level or the educational setting in which the student is enrolled.)

Demographics GRADUATION_COHORT_YEAR

The cohort year the student is grouped into for tracking graduation outcomes. Assigned to a student upon being reported in 9th grade for the first time. Usually four years after student is seen in 9th grade unless the student is enrolled at an Early/Middle College. Missing values are common and indicate a student is not advanced enough to be assigned a cohort year yet.

Demographics IS_COHORT_YEAR_CONFLICT

Indicates whether the student's graduation cohort year assignment has ever changed. Early Middle College participation or re-evaluation of a student's status may have resulted in the changes. Missing values are common and indicate the student is not advanced enough to be assigned a cohort year yet.

Demographics IS_ECONOMICALLY_DISADVANTAGED

Flag to identify students who have been determined to be eligible for free or reduced-price meals via locally gathered and approved family applications under the National School Lunch program, are in households receiving food (SNAP) or cash (TANF) assistance, are homeless, are migrant, or are in foster care. When any of these conditions are present, a student is considered Economically Disadvantaged.

Demographics IS_GRADUATED_SY

Indicates student graduated in this school year (SCHOOL_YEAR). This value defaults to No and is set to Yes when there is a graduation record for a given school year.

Demographics IS_MILITARY_CONNECTED

Flag indicating a student has a parent who is a member of the Armed Forces on active duty or serves on fulltime National Guard duty.

Demographics IS_STABLE_DATE_BIRTH_CONFLICT

Indicates whether conflicting date of birth values have ever been reported for the student.

Demographics IS_STABLE_GENDER_CONFLICT

Indicates whether conflicting gender values have ever been reported for the student.

Demographics IS_STABLE_RACE_ETHNIC_CONFLICT

Indicates whether conflicting racial/ethnic category values have ever been reported for the student.

Demographics PRIMARY_DISABILITY_CODE_RAW

The primary disability code identified on the student's Individual Education Plan (IEP) as defined by the Michigan Administrative Rules for Special Education (MARSE).

Demographics PRIMARY_DISABILITY_CODE_SY

The student's primary disability as selected by CEPI reporting rules when multiple districts/schools report the student. (Primary disability identified on the student's IEP as defined by the Michigan Administrative Rules for Special Education (MARSE).

Demographics PRIMARY_ED_SETTING_CODE_RAW

The name of the location or facility type where the student participates in special education programs or services. Codes are categorized by student age.

Demographics PRIMARY_ED_SETTING_SY

The student's primary educational setting for special education as selected by CEPI reporting rules when multiple districts/schools report the student. (The location or facility type where the student participates in special education programs or services.)

Demographics PRIMARY_LEP_LANGUAGE_SY

The student's native language selected by CEPI for federal reporting when multiple districts/schools report the student. See LEP_LANGUAGE_CODE_1, etc. for other languages.

Demographics RACIAL_ETHNIC_CODE_RAW

The ethnicity or race of the student.

Demographics READING_DEFICIENCY_CONTINUATION

Flag indicating the student had a reading deficiency continuing at end-of-year assessment.

Demographics READING_DEFICIENCY_IDENTIFIED

Flag indicating the student had a reading deficiency identified at the beginning of year (or after enrollment).

Demographics RESIDENCY_STATUS_CODE

The code that indicates the student’s residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual.

Demographics RESIDENT_DISTRICT_CODE

The five-digit code for the Local Education Agency (LEA) geographic district in which the student's custodial parent(s) or legal guardian resides.

Demographics STABLE_DATE_OF_BIRTH

The latest MSDS-recorded date of birth (month and year only for research data) for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset.

Demographics STABLE_GENDER

The latest MSDS-recorded gender for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset.

Demographics STABLE_GRAD_YEAR

The latest recorded graduation year for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset. Missing values are common and indicate student is not due to graduate yet or did not graduate.

Demographics STABLE_RACE_ETHNIC

The latest MSDS-recorded racial/ethnic category for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset.

Demographics ZIP_CODE

The five- or nine-digit ZIP code of the location where the student lives at the time of reporting or the last known code of residence.

English Learner and Immigrant LEP_INSTR_PROG_CODE_1

The code for the English language acquisition program in which the student is currently enrolled.

English Learner and Immigrant LEP_INSTR_PROG_CODE_2

The code for the English language acquisition program in which the student is currently enrolled.

English Learner and Immigrant LEP_INSTR_PROG_CODE_3

The code for the English language acquisition program in which the student is currently enrolled.

English Learner and Immigrant LEP_INSTR_PROG_CODE_4

The code for the English language acquisition program in which the student is currently enrolled.

English Learner and Immigrant LEP_INSTR_PROG_CODE_5

The code for the English language acquisition program in which the student is currently enrolled.

English Learner and Immigrant LEP_LANGUAGE_CODE_1

The code for the student's primary or home language if a home language survey indicates that the language of the home is not English or the student's primary language is not English.

English Learner and Immigrant LEP_LANGUAGE_CODE_2

The code for the student's primary or home language if a home language survey indicates that the language of the home is not English or the student's primary language is not English.

English Learner and Immigrant LEP_LANGUAGE_CODE_3

The code for the student's primary or home language if a home language survey indicates that the language of the home is not English or the student's primary language is not English.

English Learner and Immigrant LEP_LANGUAGE_CODE_4

The code for the student's primary or home language if a home language survey indicates that the language of the home is not English or the student's primary language is not English.

English Learner and Immigrant LEP_LANGUAGE_CODE_5

The code for the student's primary or home language if a home language survey indicates that the language of the home is not English or the student's primary language is not English.

Enrollment and Attendance DAYS_ATTENDED

The total number of days that the student actually attended or received educational services.

Enrollment and Attendance DAYS_POSSIBLE

The total number of days that education services were available to the student. This is a cumulative number, from the first day the student could have attended (i.e. the first day of the school year, the date of new enrollment, or the beginning of a program [e.g., summer school]) through the last day of attendance (last day of school year, enrollment or program). For additional information about enrollment refer to the characteristic Enrollment Date in the Enrollment component.

Enrollment and Attendance ENROLLMENT_DATE

The Enrollment Date from the CohortHistory record.

Enrollment and Attendance ENTITY_TYPE

Labels the entity by type (e.g., ISD School, LEA Unique Education Provider, Nonpublic School, College/University, etc.)

Enrollment and Attendance EXIT_DATE

The Exit Date from the CohortHistory record.

Enrollment and Attendance EXIT_STATUS

The student's current enrollment status description with the operating district or primary reason the student is no longer enrolled in the school district.

Enrollment and Attendance EXIT_STATUS_CODE

Code which correlates to the student's exit status.

Enrollment and Attendance FALL_SPECIAL_EDUCATION_FTE

Section52FTE + Section53FTE from Fall collection

Enrollment and Attendance FALL_TOTAL_FTE

GeneralEdFTE + Section52FTE + Section53FTE from Fall collection

Enrollment and Attendance IS_EOY_PRIMARY

Indicates the primary school record for the student for the end-of-year time period. Eligible records are those in which the student was actively enrolled for that time period as a public school student (residency code) OR was a graduating student--a deduplication process is then used to set this flag to Y for only one, most often the record with the most recent As Of Date.

Enrollment and Attendance IS_FALL_PRIMARY

Indicates the primary school record for the student for the fall time period. Eligible records are those in which the student was actively enrolled as a public school student (residency code)--a deduplication process is then used to set this flag to Y for only one record, most often the record from the PEPE (see Technical Notes). Missing values indicate the student was not reported in this entity in the Fall.

Enrollment and Attendance IS_FIRST_PRIMARY

Indicates the record from the first primary school seen for the student for the school year (IS_FALL_PRIMARY over IS_SPRING_PRIMARY over IS_EOY_PRIMARY).

Enrollment and Attendance IS_IEP_PLACED_ANOTHER_DISTRICT

Indicates when the student, as stipulated in his/her current IEP, participates in a center program, a cooperative-agreement program designed specifically for special education students or a cross-district special education program.

Enrollment and Attendance IS_MOST_PRIMARY

Indicates the primary record according to which school was the student's primary school for the most collection periods (fall, spring, end of year). If no school was the primary school for 2 or more periods, then this flag is assigned to the first primary school of the school year.

Enrollment and Attendance IS_NON_RESIDENT

Indicates the student was attending the school as a non-resident during at least one of the collection periods in the school year.

Enrollment and Attendance IS_SCHOOL_OF_CHOICE

Indicates the student was attending the school as a non-resident and using the Section 105 Schools of Choice option during at least one of the collection periods in the school year.

Enrollment and Attendance IS_SPRING_PRIMARY

Indicates the primary school record for the student for the spring time period. Eligible records are those in which the student was actively enrolled for that time period as a public school student (residency code)--a deduplication process is then used to set this flag to Y for only one, most often the record from the PEPE (see Technical Notes). Missing values indicate the student was not reported in this entity in the Spring.

Enrollment and Attendance LEP_EXIT_DATE

The date (month, day, and year) that the student was no longer engaged in either an LEP or an ESL program or service.

Enrollment and Attendance LEP_REENTRY_DATE

The date (month, day, and year) that the student was became re-engaged in either a Limited English Proficient (LEP) or an English as a Second Language (ESL) program or service.

Enrollment and Attendance SCHOOL_LOCALE

A measure of a school's geographic status on an urban continuum that ranges from 'large city' to 'rural' as determined by NCES.

Enrollment and Attendance SPECIAL_ED_EXIT_DATE

The month, day and year of the first day after the date a student last participated in special education programs or services because of the reason reported in Special Education Exit Reason.

Enrollment and Attendance SPECIAL_ED_EXIT_REASON

The reason the student is no longer participating in special education programs or services.

Enrollment and Attendance SPRING_SPECIAL_EDUCATION_FTE

Section52FTE + Section53FTE from Spring collection

Enrollment and Attendance SPRING_TOTAL_FTE

GeneralEdFTE + Section52FTE + Section53FTE from Spring collection

Personal Curriculum Modification ERD_ACTIVITY_CODE_1

The code to identify the type of additional instruction time related activities delivered to the student.

Personal Curriculum Modification ERD_ACTIVITY_CODE_2

The code to identify the type of additional instruction time related activities delivered to the student.

Personal Curriculum Modification ERD_ACTIVITY_CODE_3

The code to identify the type of additional instruction time related activities delivered to the student.

Personal Curriculum Modification ERD_ACTIVITY_CODE_4

The code to identify the type of additional instruction time related activities delivered to the student.

Personal Curriculum Modification ERD_ACTIVITY_CODE_5

The code to identify the type of additional instruction time related activities delivered to the student.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_7

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_1

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_2

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_3

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_4

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_5

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_MOD_6

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Personal Curriculum Modification PERSONAL_CURRICULUM_TYPE_1

The code to identify the reason a modification was made to the student’s curriculum.

Personal Curriculum Modification PERSONAL_CURRICULUM_TYPE_2

The code to identify the reason a modification was made to the student’s curriculum.

Personal Curriculum Modification PERSONAL_CURRICULUM_TYPE_3

The code to identify the reason a modification was made to the student’s curriculum.

Program Participation IS_21ST_CENT_COMM_LC_PROG

Indicates this student participated in at least 30 sessions of an after-school or summer program funded through a 21st Century Community Learning Center (CCLC) grant.

Program Participation IS_ALTERNATIVE_EDUCATION

Indicates this student is currently participating in an alternative education program (including seat-time waiver programs).

Program Participation IS_AT_RISK_PROGRAM

Flag indicating a student is eligible for at-risk (section 31a) funding.

Program Participation IS_DEVELOPMENTAL_KINDERGARTEN

Indicates this student participated in a Developmental Kindergarten program (a defined two-year Kindergarten program that precedes entry into first grade).

Program Participation IS_EARLY_MID_COLLEGE_PART_PROG

Indicates the student is enrolled in an early/middle college program. This program could reside at a public high school, community college or a state public university. Students may attend as early as ninth grade.

Program Participation IS_ENGLISH_LEARNER

Flag that indicates if the student was eligible to receive Limited English Proficient (LEP) services.

Program Participation IS_HOMELESS_PROG

Flag indicating that the homeless code field has a value greater than 0 for the student.

Program Participation IS_IMMIGRANT_PROGRAM

Indicates the student has immigrated to the United States from another country and is aged 3 through 21 years, was not born in any state in America and has not attended one or more schools in any one or more states for more than three full academic years. NOTE: The United States Department of Education (USED) includes foreign exchange students as eligible for Title III immigrant programs.

Program Participation IS_INTERNATIONAL_STUDENT_PROG

Indicates student is an international student participating in a foreign exchange program.

Program Participation IS_MIGRANT_ELIGIBLE

Flag indicating if the student was eligible for Migrant services.

Program Participation IS_OUT_OF_STATE_RES_PROGRAM

Indicates the student attends the district from a state or a province other than Michigan.

Program Participation IS_SEAT_TIME_WAIVER

Indicates this student is receiving his/her instruction for three or more courses through a virtual education program.

Program Participation IS_SECTION_504_PROGRAM

Indicates this student is considered disabled under Section 504 of the Rehabilitation Act of 1973.

Program Participation IS_SPECIAL_EDUCATION

Flag indicating the student is eligible for Special Ed services.

Program Participation IS_TITLE_I_TAS_PROGRAM

Student participated in a targeted assistance school (TAS) program.

Special Education SECONDARY_DISABILITY_CODE_1

Code used to describe additional disability characteristics as identified on the vision or audiological report.

Special Education SECONDARY_DISABILITY_CODE_2

Code used to describe additional disability characteristics as identified on the vision or audiological report.

Special Education SPECIAL_ED_PROGRAM_CODE_1

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Special Education SPECIAL_ED_PROGRAM_CODE_2

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Special Education SPECIAL_ED_PROGRAM_CODE_3

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Special Education SPECIAL_ED_PROGRAM_CODE_4

The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment.

Special Education SPECIAL_ED_SERVICE_CODE_1

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_10

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_2

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_3

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_4

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_5

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_6

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_7

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_8

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Special Education SPECIAL_ED_SERVICE_CODE_9

The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services)

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_1

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_2

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_3

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_4

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_5

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_6

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_INSTRUCT_SERVICE_7

The code for the Title I instructional service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_1

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_2

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_3

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_4

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_5

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_6

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_7

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.

Title I and Target Assistance Programs TAS_SUPPORT_SERVICE_8

The code for the Title I support service(s) received by the student in a Targeted Assistance Schools program.