Schedule a demo

Delivering Data You Can Trust

1 min read

Mastering State Reporting in Idaho: A Comprehensive Guide

July 25, 2023 at 7:56 AM

Student Information Systems Supported

Complete List of Data Validation Rules for Idaho

Listed below is the complete list of state reporting validation rules we provide for Idaho 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
  • Missing State Student ID
  • Missing/Invalid Date of Birth
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid First Name
  • Missing/Invalid Gender
  • Missing/Invalid Home City
  • Missing/Invalid Home State
  • Missing/Invalid Home Street
  • Missing/Invalid Home Zip/Postal Code
  • Missing/Invalid Last Name
  • Missing/Invalid Race Code
  • No Final Grade/Reporting Terms Defined

Enrollment

  • District Entry Date/School Entry Date Mismatch
  • Entry Date/Exit Date Mismatch
  • Incomplete School Transfer
  • Invalid Grade Level for Assigned School
  • Invalid Next Year Grade
  • Invalid Section Enrollment Entry Date
  • Invalid Section Enrollment Exit Date
  • Invalid Student Track
  • Missing/Invalid Entry Code
  • Missing/Invalid Entry Date
  • Missing/Invalid Exit Code
  • Missing/Invalid Exit Date
  • Missing/Invalid Full-Time Equivalency
  • Missing/Invalid Next School Indicator
  • Missing/Invalid School ID
  • Next School Indicator/Next Year Grade Mismatch
  • Overlapping School Enrollments
  • Section Enrollment Entry Date/Exit Date Mismatch
  • Section Enrollment Outside School Enrollment

Staff

  • Missing First Name
  • Missing Last Name
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid Federal Race
  • Missing/Invalid Gender

Incident Management

  • Misplaced Action
  • Missing Incident Action
  • Missing Incident Behavior
  • Missing Incident Duration
  • Missing Offender

Reports/Lists

  • Duplicate State Student ID
  • Students Excluded from State Reporting

Config

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

Contacts

  • Active Contacts Associated to Only Inactive Students
  • Contacts with No Associated Students
  • Contacts with Non-Recommended Characters in Name
  • Contacts Without a Name ("No Name" Contact Records)
  • Contacts Without a Phone Record
  • Contacts Without Contact Information (No Address, No Email, and No Phone)
  • Existing Address Record - Missing City
  • Existing Address Record - Missing Country
  • Existing Address Record - Missing Postal Code
  • Existing Address Record - Missing State/Province
  • Existing Address Record - Missing Street
  • Existing Address Record - Missing Type
  • Existing Email Record - Missing Type
  • Existing Phone Record - Missing Phone Number
  • Existing Phone Record - Missing Type
  • Inactive Contacts Associated with Active Students
  • Missing Contact First Name
  • Missing/Invalid Contact Relationship to Student
  • No Address Record - Contacts Marked to Receive Mail
  • No Name Contacts Not Associated to Any Students
  • Students with No Associated Contacts

Contacts Reports

  • Contacts with Matching Address (Street & Unit)
  • Contacts with Matching Address (Street & Unit)
  • Contacts with Matching Address (Street Only)
  • Contacts with Matching Address (Street Only)
  • Contacts with Matching Email Address
  • Contacts with Matching Email Address
  • Contacts with Matching Email Address and Web Access Account Email
  • Contacts with Matching Name
  • Contacts with Matching Name
  • Contacts with Matching Name & Address (Street & Unit)
  • Contacts with Matching Name & Address (Street & Unit)
  • Contacts with Matching Name & Address (Street Only)
  • Contacts with Matching Name & Address (Street Only)
  • Contacts with Matching Name & Email Address
  • Contacts with Matching Name & Email Address
  • Contacts with Matching Name & Phone Number
  • Contacts with Matching Name & Phone Number
  • Contacts with Matching Phone Number
  • Contacts with Matching Phone Number
  • No Address Record - Emergency
  • No Address Record - Emergency
  • No Address Record - Guardian
  • No Address Record - Guardian
  • No Address Record - Mother/Father/Parent
  • No Address Record - Mother/Father/Parent
  • No Email Record - Emergency
  • No Email Record - Emergency
  • No Email Record - Guardian
  • No Email Record - Guardian
  • No Email Record - Mother/Father/Parent
  • No Email Record - Mother/Father/Parent
  • Students with No Contacts Marked as Lives With or Has Custody

Grading

  • Blank Stored Grade
  • Duplicate Stored Grade
  • Invalid Stored Grade

Attendance

  • Non-Session Attendance Record
 
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