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.
This query will allow for validation of assessment results from multiple sources.
This query will allow for validation of assessment objective results from multiple sources.
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.
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 will list actions taken for students on discipline incidents.
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 show if EEM data is flowing from the CEPI Educational Entity Master system.
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 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.
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 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 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.
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.
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.
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.