Keyboard

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.  

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.

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.

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 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.

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.

MSDS Statistics

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

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

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 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 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.