Schedule a demo

Delivering Data You Can Trust

1 min read

Illinois State Reporting: Seamless Submissions and Increased Funding

July 24, 2023 at 3:22 PM

Student Information Systems Supported

Complete List of Data Validation Rules for Illinois

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

PowerSchool

State Validation Rules

Demographics

  • Duplicate Race Code
  • Invalid Birth Place Name
  • Invalid Legal First Name
  • Invalid Legal Last Name
  • Invalid Legal Middle Name
  • Invalid Middle Name
  • Invalid Mother's Maiden Name
  • Invalid Reading 1st Indicator
  • Invalid Reading Improvement Block Grant
  • Invalid Suffix (Lineage Code)
  • Invalid Title I
  • Migrant/FRL-Low Income Mismatch
  • Mismatched Private School Student (PSS) and Other Programs
  • Missing/Invalid Address Information
  • Missing/Invalid Date of Birth
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid First Name
  • Missing/Invalid Gender
  • Missing/Invalid Last Name
  • Missing/Invalid Race Code
  • Missing/Invalid State Student ID
  • SES Student/Grade Level Mismatch for Pre-K Students

LEP/ELL

  • Date EL Services Ended/Enrolled or Re-enrolled Date for EL Services Mismatch
  • Invalid Date Enrolled in District for EL Student
  • Invalid EL Screener Test Date
  • Invalid First Year in US for EL Student
  • Mismatch EL Services Provided and Dual Language
  • Missing Class Periods Provided per Week for EL Student
  • Missing/Invalid EL Entry Status for EL Student
  • Missing/Invalid EL Screener Required Fields
  • Missing/Invalid EL Services Provided Code for EL Student
  • Missing/Invalid Enrolled/Reenrolled EL Date for EL Student
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Parents Refused Entry Status mismatch with EL Fields
  • Reason and Date for Ending EL Mismatch

Special Education

  • Invalid Family Structure - Pre-K Student
  • Invalid Household Income Criteria for Pre-K Student
  • Invalid Made Progress Acquire Use and Knowledge Skills
  • Invalid Made Progress Positive Social Relationships
  • Invalid Made Progress Take Appropriate Action to Meet Own Needs
  • Mismatch Entry Rating Date and Entry Rating - Acquire Use and Knowledge Skills
  • Mismatch Entry Rating Date and Entry Rating - Did a Coordinator, LEA Representative or Administrator Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did a Psychologist or Social Worker Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did a Speech/Language Pathologist Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did an Early Childhood Teacher Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did Another Related Service Provider Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - How was Parent Involved in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Positive Social Relationships
  • Mismatch Entry Rating Date and Entry Rating - Take Appropriate Action to Meet Own Needs
  • Mismatch Progress Rating Date and Progress Rating - Did a Coordinator, LEA Representative or Administrator Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did a Psychologist or Social Worker Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did a Speech/Language Pathologist Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did another Related Service Provider (e.g. OT/PT) Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did the Child's Teacher Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - How was Parent Involved in Rating
  • Mismatch Progress Rating Date/Progress Rating - Acquire Use and Knowledge Skills/Progress Rating - Made Progress Acquire Use and Knowledge Skills
  • Mismatch Progress Rating Date/Progress Rating - Positive Social Relationships/Progress Rating - Made Progress Positive Social Relationships
  • Mismatch Progress Rating Date/Progress Rating - Take Appropriate Action to Meet Own Needs/Progress Rating - Made Progress Take Appropriate Action to Meet Own Needs
  • Missing/Invalid IEIN
  • Missing/Invalid Licensed Child Care for Pre-K Students
  • Missing/Invalid Program End Date
  • Missing/Invalid Program Start Date
  • Missing/Invalid Progress Rating Date or Entry Rating Date
  • Missing/Invalid Provider End Date
  • Missing/Invalid Provider Start Date
  • Missing/Invalid Provider Type
  • Missing/Invalid Reason for Ending Program
  • Missing/Invalid Reason for Ending Provider
  • Missing/Invalid Service Location
  • Missing/Invalid Service Type
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Missing/Invalid Timeline Compliance
  • Pre-K Age Mismatch for IDEA Student
  • Updated Progress Rating Date is Required

Enrollment

  • Entry Date/Exit Date Mismatch
  • Invalid Grade Level for Assigned School
  • Invalid Home RCDTS
  • Invalid Percent Day Attended
  • Invalid RCDTS Serving School Number
  • Mismatch Grade Level/Exit Code 05
  • Mismatch Grade Level/Exit Code 06
  • Mismatch Grade Level/IEP/Exit Code 14 or 15
  • Missing/Invalid Entry Code/Enrollment Type Code
  • Missing/Invalid Entry Date
  • Missing/Invalid Exit Date
  • Missing/Invalid Exit/Withdrawal Type Code for Transferred Out Students
  • Missing/Invalid FTE ID
  • Missing/Invalid School ID

Log Entries

  • Duplicate Incident Number
  • Mismatch Disciplinary Action 06, 07 and Disability Type
  • Missing Incident Date
  • Missing/Invalid Disciplinary Action
  • Missing/Invalid Disciplinary Duration
  • Missing/Invalid Incident Type
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Student Not Enrolled in School Where Incident Occurred
  • Student Not Enrolled on Incident Date in Any School

Staff

  • Invalid Legal First Name
  • Invalid Legal Last Name
  • Invalid Middle Name
  • Invalid Reason for Exit
  • Invalid Role of Professional
  • Missing/Invalid Date of Birth
  • Missing/Invalid First Name
  • Missing/Invalid Last Name
  • Missing/Invalid State IEIN
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students

Reports/Lists

  • Duplicate State Student Identifier
  • EL Fields contain a value but LEP Indicator is not selected
  • List of Students Excluded from State Reporting
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students

Homeless

  • Homeless/FRL-Low Income Mismatch
  • Missing/Invalid Services and Activities provided by McKinney-Vento Subgrant Programs and Barriers to the Education of Homeless Children and Youths
  • Missing/Invalid Unaccompanied Youth and Primary Nighttime Residence

Miscellaneous

  • Invalid Next Year Grade
  • Missing/Invalid Next School Information
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Next Year School/Next Year Grade Mismatch
 

Skyward

Demographics

  • Duplicate Race Code
  • Invalid Birth Place Name
  • Invalid Legal First Name
  • Invalid Legal Last Name
  • Invalid Legal Middle Name
  • Invalid Middle Name
  • Invalid Mother's Maiden Name
  • Invalid Reading 1st Indicator
  • Invalid Reading Improvement Block Grant
  • Invalid Suffix (Lineage Code)
  • Invalid Title I
  • Migrant/FRL-Low Income Mismatch
  • Mismatched Private School Student (PSS) and Other Programs
  • Missing/Invalid Address Information
  • Missing/Invalid Date of Birth
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid First Name
  • Missing/Invalid Gender
  • Missing/Invalid Last Name
  • Missing/Invalid Race Code
  • Missing/Invalid State Student ID
  • SES Student/Grade Level Mismatch for Pre-K Students

LEP/ELL

  • Date EL Services Ended/Enrolled or Re-enrolled Date for EL Services Mismatch
  • Invalid Date Enrolled in District for EL Student
  • Invalid EL Screener Test Date
  • Invalid First Year in US for EL Student
  • Mismatch EL Services Provided and Dual Language
  • Missing Class Periods Provided per Week for EL Student
  • Missing/Invalid EL Entry Status for EL Student
  • Missing/Invalid EL Screener Required Fields
  • Missing/Invalid EL Services Provided Code for EL Student
  • Missing/Invalid Enrolled/Reenrolled EL Date for EL Student
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Parents Refused Entry Status mismatch with EL Fields
  • Reason and Date for Ending EL Mismatch

Special Education

  • Invalid Family Structure - Pre-K Student
  • Invalid Household Income Criteria for Pre-K Student
  • Invalid Made Progress Acquire Use and Knowledge Skills
  • Invalid Made Progress Positive Social Relationships
  • Invalid Made Progress Take Appropriate Action to Meet Own Needs
  • Mismatch Entry Rating Date and Entry Rating - Acquire Use and Knowledge Skills
  • Mismatch Entry Rating Date and Entry Rating - Did a Coordinator, LEA Representative or Administrator Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did a Psychologist or Social Worker Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did a Speech/Language Pathologist Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did an Early Childhood Teacher Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Did Another Related Service Provider Participate in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - How was Parent Involved in the Ratings?
  • Mismatch Entry Rating Date and Entry Rating - Positive Social Relationships
  • Mismatch Entry Rating Date and Entry Rating - Take Appropriate Action to Meet Own Needs
  • Mismatch Progress Rating Date and Progress Rating - Did a Coordinator, LEA Representative or Administrator Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did a Psychologist or Social Worker Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did a Speech/Language Pathologist Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did another Related Service Provider (e.g. OT/PT) Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - Did the Child's Teacher Participate in the Ratings?
  • Mismatch Progress Rating Date and Progress Rating - How was Parent Involved in Rating
  • Mismatch Progress Rating Date/Progress Rating - Acquire Use and Knowledge Skills/Progress Rating - Made Progress Acquire Use and Knowledge Skills
  • Mismatch Progress Rating Date/Progress Rating - Positive Social Relationships/Progress Rating - Made Progress Positive Social Relationships
  • Mismatch Progress Rating Date/Progress Rating - Take Appropriate Action to Meet Own Needs/Progress Rating - Made Progress Take Appropriate Action to Meet Own Needs
  • Missing/Invalid IEIN
  • Missing/Invalid Licensed Child Care for Pre-K Students
  • Missing/Invalid Program End Date
  • Missing/Invalid Program Start Date
  • Missing/Invalid Progress Rating Date or Entry Rating Date
  • Missing/Invalid Provider End Date
  • Missing/Invalid Provider Start Date
  • Missing/Invalid Provider Type
  • Missing/Invalid Reason for Ending Program
  • Missing/Invalid Reason for Ending Provider
  • Missing/Invalid Service Location
  • Missing/Invalid Service Type
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Missing/Invalid Timeline Compliance
  • Pre-K Age Mismatch for IDEA Student
  • Updated Progress Rating Date is Required

Enrollment

  • Entry Date/Exit Date Mismatch
  • Invalid Grade Level for Assigned School
  • Invalid Home RCDTS
  • Invalid Percent Day Attended
  • Invalid RCDTS Serving School Number
  • Mismatch Grade Level/Exit Code 05
  • Mismatch Grade Level/Exit Code 06
  • Mismatch Grade Level/IEP/Exit Code 14 or 15
  • Missing/Invalid Entry Code/Enrollment Type Code
  • Missing/Invalid Entry Date
  • Missing/Invalid Exit Date
  • Missing/Invalid Exit/Withdrawal Type Code for Transferred Out Students
  • Missing/Invalid FTE ID
  • Missing/Invalid School ID

Log Entries

  • Duplicate Incident Number
  • Mismatch Disciplinary Action 06, 07 and Disability Type
  • Missing Incident Date
  • Missing/Invalid Disciplinary Action
  • Missing/Invalid Disciplinary Duration
  • Missing/Invalid Incident Type
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Student Not Enrolled in School Where Incident Occurred
  • Student Not Enrolled on Incident Date in Any School

Staff

  • Invalid Legal First Name
  • Invalid Legal Last Name
  • Invalid Middle Name
  • Invalid Reason for Exit
  • Invalid Role of Professional
  • Missing/Invalid Date of Birth
  • Missing/Invalid First Name
  • Missing/Invalid Last Name
  • Missing/Invalid State IEIN
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students

Reports/Lists

  • Duplicate State Student Identifier
  • EL Fields contain a value but LEP Indicator is not selected
  • List of Students Excluded from State Reporting
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students

Homeless

  • Homeless/FRL-Low Income Mismatch
  • Missing/Invalid Services and Activities provided by McKinney-Vento Subgrant Programs and Barriers to the Education of Homeless Children and Youths
  • Missing/Invalid Unaccompanied Youth and Primary Nighttime Residence

Miscellaneous

  • Invalid Next Year Grade
  • Missing/Invalid Next School Information
  • Missing/Invalid Student Receiving CCAP Subsidy for Pre-K Students
  • Next Year School/Next Year Grade Mismatch
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

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.