Data Validation Queries

The queries shown below can be used in the Custom Exports portion of the cockpit application to verify and validate parts information available in the district database.

For a complete list of available queries please check Query Bank in your Hub under Reports/Custom Exports

Assessment Inventory

Provides a list of assessments for the district and record counts for various aspects of the assessments.

Assessment Objective Performance Level Validation

Provides a combined list of objective performance level results.

Assessment Objective Score Validation

Provides a combined list of all objective assessment scores for validation purposes.

Assessment Performance Level Results

Provides a list of students with their assessment performance levels.

Assessment Score Results Validation

Provides a combined list of overall assessment scores.

Daily and Section attendance totals are provided by attendance date, broken down by school building. This includes day of the week and description of the type of day (Instructional, Holiday, etc.).

Calendar Date Event Validation

This query shows the school year calendar for all schools in the system, allowing the user to make sure the correct descriptions are provided for each school day. This is important for the MiExcel file creation.

Class List Verification

This query will list class list information for every school, broken down by teacher, section, term and student. It is useful in determining if all class roster information is correctly transferring to the data hub database.

Cohort Verification Script

Provides a list of all cohorts with any students and teachers that may be assigned to those cohorts.

Combined Daily and Section Attendance by Student

This script provides detailed daily and section attendance for students combined into one result set. Credit to Bryan Smith from Ingham ISD.

Combined Discipline Incident and Action Taken Summary

This query provides a summary of all student discipline incidents with any actions that were taken as a result of the behavior.

Daily Attendance Verification

This query will list daily attendance events for every student, by school, with details on grade level, absence type and calendar day type.

Data Freshness Script

Use this SQL Script to see which tables are populated, when they were first populated, and when they were last updated.

Diagnostic - Grade Levels not Mapped to CEDS for OneRoster

This query identifies grade levels that are not properly mapped to CEDS for OneRoster.

Diagnostic - Staff Student List

Provides a list of staff who are missing one or more key fields.

Diagnostic - Students missing Education Organization Associations

This script diagnoses students who are missing their Education Organization Association records, which causes problems in other applications like OneRoster.

Digital Equity Summary

Provides totals for the various digital equity data provided through SIS systems

Discipline Action Taken Verification

This query will list actions taken for students on discipline incidents.

District Code Listing

Provides a list of district codes stored in the database with all identifiers.

DRC - Return to Learn Verification

Provides a list of K-8 students along with DRC assessment results for Return to Learn data verification.

Ear ly Childhood Data Summary

This query provides a summary of Early Childhood Data available for students in the district.

Early On MSDS Validation

Provides a list of all Early On Data for MSDS Reporting.

Early On Services MSDS Validation

List all students with Early On Services for MSDS purposes.

Ed-Fi Descriptor Listing

This query produces a listing of all the Ed-Fi descriptors in alpha order by base descriptor name and then by descriptor Id.

Education Organizations with Code Types

This query will provide details on the schools, districts and education service centers included in the district database.

EEM Contact Information

Contact information that was sent via the EEM Service.

EEM Population Status

This query will show if EEM data is flowing from the CEPI Educational Entity Master system.

Eidex Readiness Script

Is used to validate the data published to your ODS providing total record counts of fields Eidex pulls from MiDataHub.

Food Service Status by Student

Provides a list of students with applicable food service status.

Grade Level Mapping Diagnosis Script

This script can be used to verify that the proper grade level descriptors are being used by SIS systems.

Initial IEP Validation Script

Provides a list of all students with initial IEP details for MSDS.

Initial IFSP MSDS Validation

Provides a list of all students with initial IFSP details for MSDS.

KRA Sample Selection

This report returns Kindergarten classroom rosters and identifies students within each class for testing based on the "Systematic Sampling" method (the first and last pupils on the list and pupils whose sequential numbers are multiples of three) outlined in Public Act 58 Section 104(4) and clarified in the Department of Ed Feb 20, 2020 memo. - Provided by Ryan Liskiewicz - Washtenaw ISD

MiRead Readiness Script

This script is used to validate the data published to your ODS providing total record counts of fields Eidex pulls from MiDataHub.

Provides information to determine if sufficient data is loaded for MiRead to function. Please see MiRead Readiness Script Instructions for instructions on how to view the results.

Mode of Instruction Verification Query

Provides a list of students and their Mode of Instruction cohort data

MSDS Racial/Ethnic Code Verification

Provides a list of students with their Racial/Ethnic Code Details

MSDS Statistics

This query will show which of the MSDS views are populated for state reporting.

NCES Code Mappings

This query shows any NCES district and building code mappings that came in via the EEM Integration.

NWEA Class Roster Export

This query can be used to export data in the NWEA CRF CSV file format.

NWEA - Return to Learn Verification

Verify the data loaded for students for Return to Learn benchmark assessment purposes.

NWEA - Return to Learn Verification by Month

Provides verification of NWEA RIT Scores by Month

OneRoster - Demographics

Provides a file of demographics based on the OneRoster CSV specs.

SAS EVAAS Readiness Script 2020-2021

The SAS EVAAS Readiness Script was designed to identify the readiness level for a district. It runs a series of checks against various criteria to provide feedback for the district to consider. Please check out the SAS EVAAS Readiness Script Documentation for information on how to interpret the query results.

SAS EVAAS Readiness Script 2021-2022

SAS EVAAS Readiness Script 2022-2023

School Code Listing

Provides a list of all schools in the database with identifiers.

School Data Load Analysis

Provides a breakdown of data loaded in several categories for each school building.

School Section Analysis

Use this query to verify that each school has sections, with both students and staff assigned.

Section Attendance Verification

This query provides a breakdown of all of the student absences by section.

Session/Term and Grading Period Dates

This query shows all of the terms defined and the grading periods associated with them.

Special Ed MSDS Fields

Lists all of the files populated for the MSDS Special Education Component.

Special Ed Programs and Services

Create a list of student special education programs and services.

Staff Detail Query

This query provides full details for all staff records associated with the district. It includes the variety of ID codes used, which school a staff is assigned to, their program assignment, employer, staffclassification, position title, begin and end dates for the position, and email addresses.