
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.
Attendance Totals by Date
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.
Early 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
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 2022-2023
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.
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.
Staff Identification Codes
List of staff with identification codes.
Student Characteristic Verification
This query provides student characteristic information including things such as Homeless, Immigrant and Unaccompanied Youth information.
Student Credits and GPA Data
This query shows student credits and GPA information by school year and term.
Student Discipline Incident Validation
This query provides a list of all discipline incidents on file for the district. The list is sorted by school and then alphabetically by student for easy reference.
Student Enrollment Verification
This query provides detailed student enrollment and exit-withdraw information. (StudentSchoolAssociation).
Student Grade Data Verification
This query lists out all of the grades on file for the student for the current school year.
Student Identification Codes and Application User Names
List student identification codes, including application username values.
Student Intervention Assignment List
This query provides a list of students with interventions along with all of the intervention details.
Student Indicator Verification
This query provides student indicator information including things such as At-Risk information.
Student Language Usage Analysis
This query provides a breakdown of all of the languages indicated for students in the district, the usage type (home, spoken, dominant, etc.) and the total number of students with a given configuration.
Student Program Verification
This query provides student program information including things such as Early Childhood, LEP and Special Education.
Student Resident District Verification
Provides a list of students with their resident district information.
Student Racial/Ethnic Detail
This script provides information on how student racial/ethnic information is represented in the data hub. The list is sorted by school and then alpha by student.
Student Racial/Ethnic Detail
This script provides information on how student racial/ethnic information is represented in the data hub. The list is sorted by school and then alpha by student.
Student Schedule Verification
This query lists the schedules for students in all schools, sorted by school, student, term and class period.
Student Telephone Number Verification
Provides a list of all enrolled students and their telephone numbers on file.
Student Transcript Data Verification
This query lists out all of the transcript records on file for the student across school years.
Students Without Parents
This query indicates students who are enrolled in a school, but who do not have parent/contact records listed.
Students Without Schedules
This query indicates students who are enrolled in a school, but who do not have a schedule.
Students with Parents
This query indicates students enrolled in a school and their parent.
SWIS Referral Data QA
Use this query to view data in the same format that is sent from SWIS. It will also show discipline data from the SIS.