Schedule a demo

Delivering Data You Can Trust

1 min read

Ensuring the Accuracy of PSIS State Reporting in Connecticut

August 1, 2023 at 7:30 AM

The Connecticut State Department of Education utilizes the Public School Information System (PSIS) to gather information on student enrollment across the state of Connecticut. This data serves various purposes, including supporting federal and state grants. Additionally, the PSIS data is integrated with other data collection systems within the CSDE

That's where Level Data comes in!

Student Information Systems Supported

Complete List of PSIS Data Validation Rules

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

State Validation Rules

Demographics

  • Duplicate Race Code
  • Invalid Enrolled at No Local Expense Code
  • Invalid Facility Code 1
  • Invalid Facility Code 2
  • Invalid Generation Suffix
  • Invalid Homeless Code
  • Invalid Middle Name
  • Invalid Migrant Code
  • Invalid Mother's Maiden Name
  • Invalid Special Education Code
  • Invalid Special Program Status Code
  • Invalid Town of Birth
  • Missing/Invalid Address Information
  • Missing/Invalid Date of Birth
  • Missing/Invalid EL Program Code
  • Missing/Invalid English Learner (EL) Code
  • Missing/Invalid Fed Ethnicity
  • Missing/Invalid First Name
  • Missing/Invalid Gender
  • Missing/Invalid Gifted and Talented Code
  • Missing/Invalid Immigrant Status Code
  • Missing/Invalid Last Name
  • Missing/Invalid Military Family Code
  • Missing/Invalid Native Language Code
  • Missing/Invalid Race Code
  • Missing/Invalid Resident Town
  • Missing/Invalid State Student ID (SASID)
  • Missing/Invalid Student Designation Code
  • Special Program Status/Facility Code 2 Mismatch
  • Title I Student and Instructional and Support Services Mismatch

Enrollment

  • Duplicate State Student ID (SASID) for Students Enrolled During School Year
  • Exit Date/Entry Date Mismatch
  • Invalid Grade Level for Assigned School
  • Invalid Number of Days in Attendance
  • Invalid Number of Days of Membership
  • Invalid PreK/Kindergarten Grade Code
  • Invalid Section Enrollment Entry Date
  • Invalid Section Enrollment Exit Date
  • Missing Nexus District Entry Date
  • Missing/Invalid Entry Code
  • Missing/Invalid Entry Date
  • Missing/Invalid Exit Code
  • Missing/Invalid Exit Date
  • Missing/Invalid Exit Status
  • Missing/Invalid FTE ID
  • Missing/Invalid Length of PreK Program Day in Hours
  • Missing/Invalid Nexus District
  • Missing/Invalid Number of PreK Program Days per Year
  • Missing/Invalid PreK Program Status Code
  • Missing/Invalid School ID
  • Overlapping School Enrollments

Staff

  • Missing/Invalid Date of Birth
  • Missing/Invalid Educator ID Number (EIN)
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid Federal Race
  • Missing/Invalid FTE for Title I Teacher
  • Missing/Invalid Gender
  • Missing/Invalid Staff Employment Code for Title I Teacher
  • Missing/Invalid Teacher Type

TCS

  • Active Grade Scale is Not Mapped for TCS
  • Invalid Course SCED Sequence of Course
  • Invalid SCED Course Code
  • Missing/Invalid SCED Grade Span/Available Carnegie Credit Unit
  • Missing/Invalid State Completed Course Code
  • Reporting Store Codes Not Defined for Active Term

Log Entries

  • Days Sanctioned / Days Served / Days to Carryover (Part 1) Mismatch
  • Days Sanctioned / Days Served / Days to Carryover (Part 2) Mismatch
  • Invalid Bullying Flag
  • Invalid Characters in Memo Field
  • Invalid Incident Type - Part 2
  • Invalid Sanction Type - Part 2
  • Missing/Invalid # of Days Sanctioned - Part 1
  • Missing/Invalid # of Days Sanctioned - Part 2
  • Missing/Invalid # of Days Served - Part 1
  • Missing/Invalid # of Days Served - Part 2
  • Missing/Invalid # of Days to Carry Over - Part 1
  • Missing/Invalid # of Days to Carry Over - Part 2
  • Missing/Invalid Date of Offense
  • Missing/Invalid Education Provided Code - Part 1
  • Missing/Invalid Education Provided Code - Part 2
  • Missing/Invalid Incident Type - Part 1
  • Missing/Invalid Location of Offense Code
  • Missing/Invalid Party Taking Action Code
  • Missing/Invalid Referring Party Code
  • Missing/Invalid Sanction Type - Part 1
  • Missing/Invalid School Sponsored Activity Flag
  • Missing/Invalid Student Arrested Code
  • Missing/Invalid Substance Involvement Code
  • Missing/Invalid Victim Codes
  • Missing/Invalid Weapon Involvement Code

Reports/Lists

  • Active Sections Excluded from TCS Reporting
  • Duplicate State Assigned Student ID
  • Inactive Teachers Assigned to Active Sections
  • Missing/Invalid Referring Party Code
  • Students Excluded from NTC
  • Students Excluded from State Reporting
  • Students with Missing Pre-Kindergarten/Kindergarten Grade Code

Miscellaneous

  • Invalid Scheduled Next Year Grade
  • Missing/Invalid Next School Information
  • Next Year School/Next Year Grade Mismatch
 
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