Schedule a demo

Delivering Data You Can Trust

2 min read

What is MSDS? Michigan State Reporting Made Easy in PowerSchool

July 6, 2022 at 2:15 PM

Michigan

The Michigan Student Data System (MSDS) is a collaborative effort between the Center for Educational Performance and Information (CEPI), the Michigan Department of Education (MDE), and local school districts. The MSDS is a repository that contains information regarding students receiving education in Michigan. Data collected in this system are vital to district success.

The following student identification information is updated on the OEAA Secure Site from the MSDS data, specifically based on the PEPE’s General Collection or SRM submission. If a student’s information is submitted by two different districts, the information that populates the OEAA Secure Site is based on PEPE’s submission.

  • name
  • birth date
  • UIC (Unique Identification Code)
  • ethnicity
  • gender
  • student number
  • address

Student demographic data are also updated in the OEAA Secure Site using information from the MSDS, but on a different basis. Demographic subgroup information that populates the OEAA Secure Site is based on the information designated by a student’s
UIC, regardless of whether a student’s demographic information is submitted by either the student’s PEPE or non-PEPE district, or both.

Student demographic data includes the following subgroups:

  • English Learner (EL)
  • Formerly English Learner (FEL)
  • Special Education (SE)
  • Home Schooled (HS)
  • Homeless (HL)
  • Migrant Status (MS)
  • Economically Disadvantaged (ED)
  • Foster Care
  • Military Connected Student

That's where Level Data come in!

Complete List of MSDS Data Validation Rules

Listed below is the complete list of state reporting validation rules we provide for Michigan districts using PowerSchool to make their MSDS submission as easy and timely as possible and to maximize both state and federal funding.

RealTime Validation Rules

Courses

  • MI: Courses: Course Type
  • MI: Courses: SCED 6 Course Identifier Code
  • MI: Courses: SCED 6 Subject Area Code

Demographics

  • MI: Demographics: First Name
  • MI: Demographics: Last Name
  • MI: Demographics: Middle Name

Modify Info

  • MI: Modify Info: District Entry Date
  • MI: Modify Info: School Entry Date

Sections

  • MI: Sections: Virtual Delivery

Transfer Info

  • MI: Transfer Info: Current Enrollment: District of Residence
  • MI: Transfer Info: Current Enrollment: Exit Code
  • MI: Transfer Info: Current Enrollment: Full-Time Equivalency
 

State Validation Rules

Demographics

  • MI: Demographics: Blank General Education FTE
  • MI: Demographics: Exit Code/FTE Mismatch
  • MI: Demographics: FTE Overallocation
  • MI: Demographics: Invalid Age for Adult Education Student
  • MI: Demographics: Invalid Age for Exit Code
  • MI: Demographics: Invalid Age for Maximum Age Special Education Exits
  • MI: Demographics: Invalid Age for Special Education Transition Student
  • MI: Demographics: Invalid Date of Birth
  • MI: Demographics: Invalid Educational Setting Code
  • MI: Demographics: Invalid Exit Code for Early College
  • MI: Demographics: Invalid FTE for Adult Education/Early Childhood Students
  • MI: Demographics: Invalid General Education FTE for Grade Level
  • MI: Demographics: Invalid Grade for DK
  • MI: Demographics: Invalid Grade for Early College Student
  • MI: Demographics: Invalid Grade for Student Exiting Adult Education
  • MI: Demographics: Invalid Grade Level for Assigned School
  • MI: Demographics: Invalid Grade Level for Graduated Exit Code
  • MI: Demographics: Invalid Grade Level for Student's Age
  • MI: Demographics: Invalid Lunch Status for Homeless or Migrant Students
  • MI: Demographics: Invalid Middle Name
  • MI: Demographics: Invalid Resident LEA Number for Out-of-State Resident
  • MI: Demographics: Invalid Student Resident County
  • MI: Demographics: Mismatch Title I Eligibility and Title I Component
  • MI: Demographics: Missing Date of Birth
  • MI: Demographics: Missing District of Residence/Resident LEA Number
  • MI: Demographics: Missing Early/Middle College Participant Flag
  • MI: Demographics: Missing State Information
  • MI: Demographics: Missing Street Information
  • MI: Demographics: Missing Title I Service
  • MI: Demographics: Missing/Invalid City Information
  • MI: Demographics: Missing/Invalid Ethnicity
  • MI: Demographics: Missing/Invalid First Name
  • MI: Demographics: Missing/Invalid Gender
  • MI: Demographics: Missing/Invalid Last Name
  • MI: Demographics: Missing/Invalid Lunch Status
  • MI: Demographics: Missing/Invalid Next School
  • MI: Demographics: Missing/Invalid Student Residency
  • MI: Demographics: Missing/Invalid Zip Code

Early Reading Deficiency

  • MI: Early Reading Deficiency: K-3 Students Not Set to Include Early Reading Deficiency Data in MSDS Reporting
  • MI: Early Reading Deficiency: Missing/Invalid Reading Deficiency Activities
  • MI: Early Reading Deficiency: Missing/Invalid Reading Deficiency Identified
  • MI: Early Reading Deficiency: Reading Deficiency Identified/Reading Deficiency Continuation Mismatch

Enrollment

  • MI: Enrollment: Exit Date Prior District Enrollment/District Entry Date
  • MI: Enrollment: Exit Date Prior to Entry Date
  • MI: Enrollment: Invalid Entry Date
  • MI: Enrollment: Invalid Exit Date
  • MI: Enrollment: Invalid Exit Date for Graduated Exit Code
  • MI: Enrollment: Missing Exit Date
  • MI: Enrollment: Missing/Invalid Exit Code for Inactive Students
  • MI: Enrollment: Missing/Invalid FTEID
  • MI: Enrollment: Students with a Future Exit Date

LEP and Immigrant

  • MI: LEP and Immigrant: Invalid Age for Immigrant Status
  • MI: LEP and Immigrant: Invalid Home Language
  • MI: LEP and Immigrant: Invalid LEP Entry Date
  • MI: LEP and Immigrant: Invalid LEP Exit Date

Log Entries

  • MI: Log Entries: Consequence Start Date Mismatch
  • MI: Log Entries: Incident Date/Consequence Start Date Mismatch
  • MI: Log Entries: Incident Type/Incident Caused Bodily Injury Mismatch
  • MI: Log Entries: Incident Type/Incident was a Sexual Assault Mismatch
  • MI: Log Entries: Missing Include in State Reporting
  • MI: Log Entries: Missing/Invalid Follow-Up for Expulsion
  • MI: Log Entries: Missing/Invalid Incident ID
  • MI: Log Entries: Missing/Invalid Incident Type
  • MI: Log Entries: Missing/Invalid Initial Consequence Information
  • MI: Log Entries: Missing/Invalid Other Consequence Information
  • MI: Log Entries: Missing/Invalid Secondary Consequence Information
  • MI: Log Entries: Primary Disability/Action Taken Mismatch

Reports/Lists

  • MI: Reports/Lists: Duplicate LoginID/Username
  • MI: Reports/Lists: Duplicate State Student Number
  • MI: Reports/Lists: Missing Include Special Education Data in MSDS Reporting Flag - Review Required
  • MI: Reports/Lists: Missing Original Contact Type
  • MI: Reports/Lists: Missing Student Resident County
  • MI: Reports/Lists: Students Enrolled at District Office
  • MI: Reports/Lists: Students Excluded from State Reporting
  • MI: Reports/Lists: Students with Missing Home Address Geocode
  • MI: Reports/Lists: Students with Missing Mailing Address Geocode
  • MI: Reports/Lists: Students with Seclusion and Restraint Records
  • MI: Reports/Lists: Zero FTE Report - Review Required

Special Education

  • MI: Special Education: Incorrect Special Education Exit Date
  • MI: Special Education: Invalid Date of Parental Consent
  • MI: Special Education: Invalid General Education FTE for Special Education Student's Age
  • MI: Special Education: Invalid Initial IEP Completion Date
  • MI: Special Education: Invalid Initial IFSP Date
  • MI: Special Education: Invalid Parent Address Unknown Information
  • MI: Special Education: Invalid Parent Phone Number Unknown Information
  • MI: Special Education: Invalid Primary Disability
  • MI: Special Education: Invalid Result of Initial IEP
  • MI: Special Education: Invalid Special Education Exit Date
  • MI: Special Education: Invalid Support Services
  • MI: Special Education: Missing Initial IFSP Referral Date
  • MI: Special Education: Missing Parent Address Information
  • MI: Special Education: Missing Parent Phone Number Information
  • MI: Special Education: Missing Primary Disability
  • MI: Special Education: Missing Primary Disability for Placed by Another District IEP Status
  • MI: Special Education: Missing Primary Disability for Special Education Completion Exit Code
  • MI: Special Education: Missing Primary Disability or Plan Date
  • MI: Special Education: Missing Special Education Exit Date
  • MI: Special Education: Missing Special Education Exit Information
  • MI: Special Education: Missing Support Service or Program Service Code
  • MI: Special Education: Missing Timeliness of Initial IEP
  • MI: Special Education: Plan Date After Exit Date
  • MI: Special Education: Plan Date After Special Education Exit Date
  • MI: Special Education: Plan Date Out of Compliance
  • MI: Special Education: Plan Date Prior to Date of Birth
  • MI: Special Education: Plan Date/Additional Plan Date Mismatch
  • MI: Special Education: Primary Disability/Secondary Disability Mismatch
  • MI: Special Education: Primary Educational Setting/Primary Disability Mismatch
  • MI: Special Education: Program Service Code Required
  • MI: Special Education: Section 52 FTE/Section 53 FTE Mismatch
  • MI: Special Education: Section 53 FTE/Student Residency Mismatch
  • MI: Special Education: Special Education Exit Date/Special Education Exit Reason Mismatch
  • MI: Special Education: Timeliness of Initial IEP/Date of Parental Consent Mismatch
  • MI: Special Education: Timeliness of Initial IEP/Days Beyond Timeline Mismatch

TSDL

  • MI: TSDL: Mentor Teacher/Virtual Method Mismatch
  • MI: TSDL: Missing Course Identifier Code
  • MI: TSDL: Missing Virtual Course Mentor PIC
  • MI: TSDL: Missing/Invalid Course Type
  • MI: TSDL: Missing/Invalid Staff PIC
  • MI: TSDL: Missing/Invalid Subject Area Code
If you have any questions or would like to request additional rules, please reach out to helpdesk@leveldata.com
Al Momrik
Written by Al Momrik

Al Momrik works at Level Data as a Data Quality Analyst, arriving in 2013. He works primarily with the State Data Validation Suite, a series of services which help PowerSchool users to find errors in their data and correct them in a shorter amount of time. Before coming to Level Data, Al worked in a school district in Michigan for 23 years. He was a Technology Director, a SysAdmin for PowerSchool, and was responsible for all State data submissions. He has worked with PowerSchool since 2007. Al also is a presenter at 6-8 PowerSchool conferences around the country annually.

Post a Comment

Featured Case Studies