Schedule a demo

Delivering Data You Can Trust

3 min read

What is MSDS? Michigan State Reporting Made Easy

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!

Student Information Systems Supported

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.

PowerSchool

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: Invalid Age for Special Education Transition Student
  • MI: Invalid Middle Name
  • MI: Missing/Invalid Address Information
  • MI: Missing/Invalid Date of Birth (DOB)
  • MI: Missing/Invalid Ethnicity
  • MI: Missing/Invalid First Name
  • MI: Missing/Invalid Gender
  • MI: Missing/Invalid Last Name
  • MI: Missing/Invalid Student Resident County
  • MI: Missing/Invalid Unique Identification Code (UIC)

Special Education

  • MI: Invalid Age for Maximum Age Special Education Exits
  • MI: Invalid Age For Primary Educational Setting And Grade - Students Not 5+ Years of Age
  • MI: Invalid Age For Primary Educational Setting And Student Grade or Setting - Students Not 3-5 Years of Age
  • MI: Invalid Age For Primary Educational Setting And Student Grade or Setting - Students Not Less Than 3 Years of Age
  • MI: Invalid Grade For Primary Educational Setting - Students 3 through 5 Years of Age
  • MI: Invalid Grade For Primary Educational Setting - Students At Least 5 Years of Age
  • MI: Invalid Grade For Primary Educational Setting - Students Less Than 3 Years of Age
  • MI: Invalid Initial IFSP Date
  • MI: Invalid Initial IFSP Referral Date
  • MI: Invalid Parent Address Unknown Information
  • MI: Invalid Parent Phone Number Unknown Information
  • MI: Invalid Primary Educational Setting For Students 3 through 5 Years of Age
  • MI: Invalid Primary Educational Setting For Students At Least 5 Years of Age and In Kindergarten or Higher
  • MI: Invalid Primary Educational Setting For Students Less Than 3 Years of Age
  • MI: Invalid Special Education Exit Date
  • MI: Missing Parent Address Information
  • MI: Missing Parent Phone Number Information
  • MI: Missing Primary Disability for Placed by Another District IEP Status
  • MI: Missing Primary Disability for Special Education Completion Exit Code
  • MI: Missing Special Education Exit Date
  • MI: Missing Support Service or Program Service Code
  • MI: Missing/Invalid Date of Parental Consent
  • MI: Missing/Invalid Initial IEP Completion Date
  • MI: Missing/Invalid Plan Date
  • MI: Missing/Invalid Primary Disability
  • MI: Missing/Invalid Timeliness of Initial IEP
  • MI: Plan Date Out of Compliance
  • MI: Plan Date/Additional Plan Date Mismatch
  • MI: Primary Educational Setting/Primary Disability Mismatch
  • MI: Result of Initial IEP/Timeliness of Initial IEP Mismatch
  • MI: Section 52 FTE/Section 53 FTE Mismatch
  • MI: Section 53 FTE/Student Residency Mismatch
  • MI: Special Education Exit Date/Special Education Exit Reason Mismatch
  • MI: Timeliness of Initial IEP/Days Beyond Timeline Mismatch

Log Entries

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

TSDL

  • MI: Mentor Teacher/Virtual Method Mismatch
  • MI: Missing Course Identifier Code
  • MI: Missing Virtual Course Mentor PIC
  • MI: Missing/Invalid Course Type
  • MI: Missing/Invalid Staff PIC
  • MI: Missing/Invalid Subject Area Code

Reports/Lists

  • MI: Age Outside of Expected Range for Exit Code
  • MI: Age Outside of Expected Range for Grade Level
  • MI: Duplicate State Student Number (UIC)
  • MI: Kindergarten Students Younger Than Five Years Old
  • MI: Missing Include Special Education Data in MSDS Reporting Flag - Review Required
  • MI: Missing Original Contact Type
  • MI: Primary Disability/Secondary Disability Review
  • MI: Student In-School Suspension-INITIAL/Attendance Review
  • MI: Student In-School Suspension-OTHER/Attendance Review
  • MI: Student In-School Suspension-SECONDARY/Attendance Review
  • MI: Student Out-of-School Suspension-INITIAL/Attendance Review
  • MI: Student Out-of-School Suspension-OTHER/Attendance Review
  • MI: Student Out-of-School Suspension-SECONDARY/Attendance Review
  • MI: Students Enrolled at District Office
  • MI: Students Excluded from State Reporting
  • MI: Students with Missing Home Address Geocode
  • MI: Students with Missing Mailing Address Geocode
  • MI: Students with Seclusion and Restraint Records
  • MI: Zero FTE Report - Review Required

Enrollment

  • MI: Entry Date/Exit Date Mismatch
  • MI: Exit Code/FTE Mismatch
  • MI: Exit Date Prior District Enrollment/District Entry Date
  • MI: Invalid Educational Setting Code
  • MI: Invalid Exit Code for Early/Middle College Participant
  • MI: Invalid Exit Date for Graduated Exit Code
  • MI: Invalid Exit Date for Non-Graduated Exit Code
  • MI: Invalid General Education FTE
  • MI: Invalid General Education FTE for Early Childhood Students
  • MI: Invalid Grade for Early College Student
  • MI: Invalid Grade for Military Connected Student
  • MI: Invalid Grade Level for Assigned School
  • MI: Invalid Grade Level for Developmental Kindergarten
  • MI: Invalid Grade Level or Grade and Setting for Graduated Exit Code
  • MI: Invalid Resident LEA Number for Out-of-State Resident
  • MI: Invalid Section Enrollment Entry Date
  • MI: Invalid Section Enrollment Exit Date
  • MI: Invalid Total FTE
  • MI: K-12 Students with an Early Childhood Student Grade or Setting
  • MI: Missing Additional Graduation Award
  • MI: Missing District of Residence/Resident LEA Number
  • MI: Missing Early/Middle College Participant Flag
  • MI: Missing General Education FTE
  • MI: Missing/Invalid Entry Date
  • MI: Missing/Invalid Exit Code for Inactive Students
  • MI: Missing/Invalid Exit Date
  • MI: Missing/Invalid Full-Time Equivalency
  • MI: Missing/Invalid Lunch Status
  • MI: Missing/Invalid Next School Indicator
  • MI: Missing/Invalid School ID
  • MI: Missing/Invalid Student Residency

LEP and Immigrant

  • MI: Invalid Age for Immigrant Status
  • MI: Invalid LEP Entry Date
  • MI: Invalid LEP Exit Date
  • MI: Missing/Invalid Home Language
  • MI: Missing/Invalid LEP Instructional Program

Early Reading Deficiency

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

Adult Education

  • MI: Invalid Age for Adult Education Student
  • MI: Invalid General Education FTE for Adult Education Participants
  • MI: Invalid Grade Level or Student Grade or Setting for Participant Exiting Adult Education

Title I

  • MI: Missing Title I Instructional and/or Support Service
  • MI: Title I Eligibility and Title I Services Mismatch

Config

  • MI: In-Session Calendar Day Missing Bell Schedule
  • MI: In-Session Calendar Day Missing Cycle Day
  • MI: In-Session Calendar Day with No Membership Value
  • MI: No Bell Schedule Items Created for Bell Schedule
  • MI: No Final Grade/Reporting Terms Defined
  • MI: Term Date Overlap

Incident Management

  • MI: Invalid Incident Assigned Duration or Actual Duration
  • MI: Missing Incident Action
  • MI: Missing Incident Assigned Duration or Actual Duration
  • MI: Missing Incident Behavior
  • MI: Missing Incident Duration
  • MI: Missing Offender
 

Skyward

Connect Validation Rules

Demographics

  • Duplicate Unique Identification Code (UIC)
  • Invalid First Name
  • Invalid Home Email Address
  • Invalid Last Name
  • Invalid Legal First Name
  • Invalid Legal Last Name
  • Invalid Legal Middle Name
  • Invalid Middle Name
  • Legal Name Should Not Match Name on Student Profile
  • Missing/Invalid Address Information
  • Missing/Invalid Date of Birth
  • Missing/Invalid Gender
  • Missing/Invalid UIC

Enrollment

  • District Entry Date/School Entry Date Mismatch
  • Exit Date Prior to Entry Date
  • Full/Part Time-Percent Enrolled Mismatch
  • Invalid Entry Date
  • Invalid Exit Code for Early College
  • Invalid Grade for Early/Middle College Student
  • Invalid Grade Level for Assigned School
  • Invalid Home Address County
  • Invalid Lunch Status For Homeless Status
  • Invalid Resident County
  • Missing Status End Code
  • Missing/Invalid Additional Graduation Award
  • Missing/Invalid Exit Date
  • Missing/Invalid State Aid Code
  • Residency Code/Resident District Mismatch
  • Resident/State Aid Mismatch
  • Student Status and Entry/Withdrawal Record Mismatch
  • Students with Unknown Exit Status

Miscellaneous

  • Print Report Card Set to No

Reports/Lists

  • Advance set to Yes
  • Age Outside of Expected Range for Grade Level
  • Households with Lunch Code Mismatch
  • Kindergarten Students Younger Than Five Years Old

Scheduling

  • Dual Enrollment Course with College Credit of 0.00
  • Invalid State Course Code
  • Missing State Course Code
  • Missing/Invalid College Credit

Special Education

  • Invalid Age For Educational Setting And Grade - Students Not 2.5-6 Years of Age
  • Invalid Age For Educational Setting And Grade - Students Not 5+ Years of Age
  • Invalid Age For Educational Setting And Grade - Students Not Less Than 3 Years of Age
  • Invalid Educational Setting For State Aid Code (09)
  • Invalid Educational Setting For State Aid Codes (04, 07, 08 or 15)
  • Invalid Educational Setting for Students 2.5 through 3 Years of Age
  • Invalid Educational Setting For Students 3 through 5 Years of Age
  • Invalid Educational Setting For Students At Least 5 Years of Age and In Kindergarten or Higher
  • Invalid Educational Setting For Students Less Than 2.5 Years of Age
  • Invalid Grade For Educational Setting - Students 2.5 through 6 Years of Age
  • Invalid Grade For Educational Setting - Students At Least 5 Years of Age
  • Invalid Grade For Educational Setting - Students Less Than 3 Years of Age
  • Missing Primary Disability for Special Education Completion Exit Code
  • Missing Support Service or Program Service Code
  • Plan Date Out of Compliance

Special Programs

  • Early Childhood Program/Delivery Method Mismatch
  • Early Childhood Program/Delivery Schedule Mismatch
  • Invalid LEP Entry Date
  • Invalid LEP Exit Date
  • Missing/Invalid Mode of Instruction

Staff

  • Missing/Invalid Staff Gender

Connect Validation Rules (In Development)

Config

  • Calendar Days With a 'Count As' Value Other Than 0.00 or 1.00

Demographics

  • Guardians with Missing Relationship Code
  • Invalid Age for Immigrant Status

Discipline

  • Invalid Total Time for Action
  • Missing Follow Up for Expulsion
  • Missing Follow Up for Special Ed Student
  • Total Days for Susp/Exp

Enrollment

  • Concurrent Enrollment with Invalid Status End
  • Invalid FTE For Out-of-State Resident
  • Invalid Status End Code

Reports/Lists

  • Inactive Prior Year Senior Flagged As Current Year Member
  • Staff Flagged as Mentor Teacher
  • Students with Homeless Status

Scheduling

  • Class Meets Excluded from TSDL
  • Missing/Invalid PSN for Vocational Course
  • Virtual Delivery/Mentor Teacher Mismatch

Special Education

  • Initial IEPs not Marked as Submitted for MSDS
  • Missing/Invalid Date of Parental Consent
  • Missing/Invalid Initial IEP Completion Date
  • Special Education Students with Discipline
  • Timeliness of Initial IEP/Days Beyond Timeline Mismatch
  • Timeliness of Initial IEP/Result of Initial IEP Mismatch

Special Programs

  • Invalid Grade for Military Connected Student

Staff

  • Missing Staff Entity Building
  • Missing/Invalid Teacher PIC Number

Connect RealTime Rules

  • Student Management: Office: Curriculum & Assessment: Curriculum: Curriculum Master: State Course Code
  • Student Management: Staff: Staff Entity: Building
  • Student Management: Staff: Staff: Edit Staff Member: Teacher PIC Number
  • Student Management: Students: Students: Student Profile: Discipline: Offense: Action: Total Time
  • Student Management: Students: Students: Student Profile: Entity: Print Report Card
  • Student Management: Students: Students: Student Profile: Entry/With tab: Entry record: Entry Date
  • Student Management: Students: Students: Student Profile: Entry/With tab: Entry Record: State Aid
  • Student Management: Students: Students: Student Profile: Entry/With tab: Withdrawal Record: Status End
  • Student Management: Students: Students: Student Profile: Entry/Withdrawal: Withdraw: Additional Graduation Award
  • Student Management: Students: Students: Student Profile: Family: Edit Guardian: Relationship
  • Student Management: Students: Students: Student Profile: Family: Home Email
  • Student Management: Students: Students: Student Profile: General: Address: +4 Zip Code
  • Student Management: Students: Students: Student Profile: General: Address: Street Name
  • Student Management: Students: Students: Student Profile: General: Address: Street Number
  • Student Management: Students: Students: Student Profile: General: Address: Zip Code
  • Student Management: Students: Students: Student Profile: General: Gender
  • Student Management: Students: Students: Student Profile: General: Graduation Date
  • Student Management: Students: Students: Student Profile: General: Identity: Legal First Name
  • Student Management: Students: Students: Student Profile: General: Identity: Legal Last Name
  • Student Management: Students: Students: Student Profile: General: Identity: Legal Middle Name
  • Student Management: Students: Students: Student Profile: General: Last Name
  • Student Management: Students: Students: Student Profile: General: Middle Name
  • Student Management: Students: Students: Student Profile: General: Profile: Advance
  • Student Management: Students: Students: Student Profile: General: Profile: First Name
  • Student Management: Students: Students: Student Profile: General: Profile: Home Email Address
  • Student Management: Students: Students: Student Profile: General: Profile: School Email
  • Student Management: Students: Students: Student Profile: MI/NCLB: International Student
  • Student Management: Students: Students: Student Profile: MI/NCLB: Unique Identification Code (UIC)
  • Student Management: Students: Students: Student Profile: MI/NCLB:Resident County
  • Student Management: Students: Students: Student Profile: Special Programs: Early Childhood: Federal Poverty Level Quintile
  • Student Management: Students: Students: Student Profile: Special Programs: Homeless: Begin Sts: Primary Nighttime Residence

Connect RealTime Rules Currently In Development

  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: District Received Date
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Days Beyond Timeline
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Initial IEP Completion Date
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Part C Transition Timeliness
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Result
  • Student Management: Student Services: Special Education: Student Profile: Evaluation Info: Edit: Mark as Initial: Timeliness
  • Student Management: Students: Students: Student Profile: Discipline: Offense: Action: Total Time
  • Student Management: Students: Students: Student Profile: Entry/With: Alternative ED
  • Student Management: Students: Students: Student Profile: Entry/With: Developmental KG
  • Student Management: Students: Students: Student Profile: MI/NCLB: Student ID Nbr
  • Student Management: Students: Students: Student Profile: Special Programs: Early Childhood: Delivery Method
  • Student Management: Students: Students: Student Profile: Special Programs: Early Childhood: Delivery Schedule
  • Student Management: Students: Students: Student Profile: Special Programs: Early On: Referral Date
  • Student Management: Students: Students: Student Profile: Special Programs: Restraint: Date of Restraint Event
  • Student Management: Students: Students: Student Profile: Special Programs: Seclusion: Date of Seclusion Event
  • Student Management: Students: Students: Student Profile: Student Profile: Special Programs: Ltd Eng Prof: End Date
  • Student Management: Students: Students: Student Profile: Student Profile: Special Programs: Ltd Eng Prof: Start Date
 
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

Most districts struggle with data quality which influences learning and funding. At Level Data, we provide simple solutions that deliver data districts can trust so they can lead with confidence and focus on what really matters.

Contact Us

269-488-2050 | 866-511-3282

sales@leveldata.com

6850 Stadium Drive
Kalamazoo, MI 49009

Sign up for updates

© 2021 Level Data, Inc. All rights reserved.