CEDARS Data Validation Report

Introduction

This report is a student-level validation report based on OSPI Validation Messages used for CEDARS. A multi-selection "Select CEDARS reports" parameter is added to the report run page, allowing the user to generate only the errors associated with the selected CEDARS report(s).

For the parameter 'Select CEDARS reports' the current list is limited to student-level reports, with these exceptions:

Student Grade History (H) is excluded due to the quantity of records and due to the heavy use of custom fields.
Student Discipline File (P) is excluded due to the availability of the Incident Management Validation Extract File report.

The OSPI validation message wording is simplified to better relate to PowerSchool terminology. For example, the report returns 'NO DOB' instead of 'Required Field: DistrictStudent.BirthDate (element B09) must be a date in the format MM/DD/YYYY.'

The report output is comma separated with columns of error message, school name, school abbreviation, student number, student name and student entry date.

The report performance is relatively long, especially if the user includes the District Student File (B) report. This is due to the heavy use of custom fields in filters. Performance improvements can be expected when we switch to extended schema usage. It is recommended that users select a single school, and perhaps a selection of students, when first running the report and resolving data entry issues.

Special Note: A page is available under the students State/Province – WA page labeled CEDARS Data Validation. This page displays any validation errors that would be returned in the CEDARS Data Validations report for the current student. If no errors are found, the message "No Errors Found." is displayed. Using this page has the results of running the report for all CEDARS reports for the single student. When the report is invoked from the student CEDARS Data Validation page the return of data is impacted by the student's data quality. Please be patient an allow the page to complete its processing.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

School Selection

The report selects records from the [Schools] table that are not excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Note: The report performance can be relatively long, especially if the user includes the District Student File (B) report. This is due to the heavy use of custom fields in filters. Performance improvements can be expected when we switch to database extensions usage. It is recommended that users select a single school, and perhaps a selection of students, when first running the report and resolving data entry issues.

Field

Description

Select Schools

If run at the district level, choose one of the following:

Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

The Selected [number] Students Only – run the report for students in the current selection.
All Students (default) – run the report for all students in the current school or district that meet the selection criteria.
Note: If running the report for a single student, or group of students, select the students prior to running report.

Select CEDARS reports

Indicates which CEDARS validations to include in the report.
Allows the user to generate only the errors associated with the selected CEDARS report(s). Run the report using a single report or selection of multiple reports.
For this parameter the current list of CEDARS reports is limited to student-level reports, with these exceptions:

Student Grade History (H) is excluded due to the quantity of records and due to the heavy use of custom fields.
* Student Discipline File (P) is excluded due to the availability of the Incident Management Validation Extract File report.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item	Data Element	Description
1	Error Message	The validation error message associated with the student. The OSPI validation message wording is simplified to better relate to PowerSchool terminology. For example, the report returns 'NO DOB' instead of 'Required Field: DistrictStudent.BirthDate (element B09) must be a date in the format MM/DD/YYYY.'
2	School Name	[Schools]Name. Name of school where the student is enrolled.
3	School Abbr.	[Schools]Abbreviation. School abbreviation.
4	Student Number	[Students]Student_Number. Helpful for student search; enter the number from the report into the search box (eg 12345) or use 'student_number=12345'.
5	Student Last Name	[Students]Last_Name.
6	Student First Name	[Students]First_Name.
7	Student Entry Date	[Students]EntryDate.

Back to Top