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.
Provides a list of assessments for the district and record counts for various aspects of the assessments.
Provides a combined list of objective performance level results.
Provides a combined list of all objective assessment scores for validation purposes.
Provides a list of students with their assessment performance levels.
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.).
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.
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.
Provides a list of all cohorts with any students and teachers that may be assigned to those cohorts.
This script provides detailed daily and section attendance for students combined into one result set. Credit to Bryan Smith from Ingham ISD.
This query will list daily attendance events for every student, by school, with details on grade level, absence type and calendar day type.
Use this SQL Script to see which tables are populated, when they were first populated, and when they were last updated.
This query identifies grade levels that are not properly mapped to CEDS for OneRoster.
Provides a list of staff who are missing one or more key fields.
This script diagnoses students who are missing their Education Organization Association records, which causes problems in other applications like OneRoster.
This query will list actions taken for students on discipline incidents.
Provides a list of district codes stored in the database with all identifiers.
Provides a list of K-8 students along with DRC assessment results for Return to Learn data verification.
Provides a list of all Early On Data for MSDS Reporting.
List all students with Early On Services for MSDS purposes.
This query produces a listing of all the Ed-Fi descriptors in alpha order by base descriptor name and then by descriptor Id.
This query will provide details on the schools, districts and education service centers included in the district database.
Contact information that was sent via the EEM Service.
This query will show if EEM data is flowing from the CEPI Educational Entity Master system.
Is used to validate the data published to your ODS providing total record counts of fields Eidex pulls from MiDataHub.
Provides a list of students with applicable food service status.
This script can be used to verify that the proper grade level descriptors are being used by SIS systems.
Provides a list of all students with initial IEP details for MSDS.
Provides a list of all students with initial IFSP details for MSDS.
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.
This query will show which of the MSDS views are populated for state reporting.
This query can be used to export data in the NWEA CRF CSV file format.
Verify the data loaded for students for Return to Learn benchmark assessment purposes.
Provides verification of NWEA RIT Scores by Month
Provides a file of demographics based on the OneRoster CSV specs.
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.
Provides a list of all schools in the database with identifiers.
Provides a breakdown of data loaded in several categories for each school building.
Use this query to verify that each school has sections, with both students and staff assigned.
This query provides a breakdown of all of the student absences by section.
This query shows all of the terms defined and the grading periods associated with them.
Lists all of the files populated for the MSDS Special Education Component.
Create a list of student special education programs and services.
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.
List of staff with identification codes.
This query provides student characteristic information including things such as Homeless, Immigrant and Unaccompanied Youth information.
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.
This query provides detailed student enrollment and exit-withdraw information. (StudentSchoolAssociation).
This query lists out all of the grades on file for the student for the current school year.
List student identification codes, including application username values.
This query provides a list of students with interventions along with all of the intervention details.
This query provides student indicator information including things such as At-Risk information.
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.
This query provides student program information including things such as Early Childhood, LEP and Special Education.
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.
This query lists the schedules for students in all schools, sorted by school, student, term and class period.
Provides a list of all enrolled students and their telephone numbers on file.
This query lists out all of the transcript records on file for the student across school years.
This query indicates students who are enrolled in a school, but who do not have parent/contact records listed.
This query indicates students who are enrolled in a school, but who do not have a schedule.
This query indicates students enrolled in a school and their parent.
Use this query to view data in the same format that is sent from SWIS. It will also show discipline data from the SIS.