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 Results Validation

This query will allow for validation of assessment results from multiple sources.

 

Assessment Objective Results Validation

This query will allow for validation of assessment objective results from multiple sources.

 

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.

 

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.

 

Discipline action taken verification

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

 

EEM Population Status

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

 

Food Service Status by Student

Provides a list of students with applicable food service status.

 

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.

 

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.

 

Student Characteristic Verification

This query provides student characteristic information including things such as Homeless, Immigrant and Unaccompanied Youth information.

 

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 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 Schedule Verification

This query lists the schedules for students in all schools, sorted by school, student, term and class period.

 

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.

 

Food Service Status by Student

Provides a list of students with applicable food service status.