Tool Search: Data Validation Report
The Data Validation Report allows users to generate a report containing data based on Validation Groups.
Prerequisites
Validation Rules and Validation Groups have been created for Ed-Fi resources.
See the Data Validation Tool Rights article to learn about the rights needed to use this and other Data Validation tools.
Generating the Data Validation Report for Ed-Fi Resources
The Data Validation Report can be generated using previously established Validation Groups for various Ed-Fi resources. The Validation Report can be used to help identify errors before a resync is run, thereby reducing errors when sending data to the state.
Note: The data validations are run for all active Ed-Fi configurations and all schools.
Validations ReportData Validation Report Editor
| Field | Description | |
|---|---|---|
| Data Validation Group | Allows the user to select the Ed-Fi Resource Data Validation Group that will be used for the report. | |
| Data Validation Group Description | The description of the Data Validation Group being used for the report. | |
| Output Options | Generate Now | Generates the report immediately after selecting the Generate button. |
| Submit to Batch Queue | Submits the report to the Batch Queue to generate at a later time. Users are able to select a date and time for the report to generate. For more information regarding Batch Queue, refer to the Batch Queue article. | |
| Format Options | Allows the user to select whether the report will generate in HTML, CSV, or Excel format. | |
| Batch Queue List | Displays a list of reports that have been submitted to the Batch Queue. | |
| Start Date | The date range for the list of reports displayed in the Batch Queue List. | |
| End Date | ||
| Report Title | Title of the submitted report. | |
| Queued Time | Time the report was generated. | |
| Status | Status of the report. When the report is completed, users can click on the 'Completed' link to view the report. | |
| Refresh | Refreshes the list of reports in the Queue list. | |
| Generate | Generates the report. | |
| Reset | Clears the fields in the Data Validation Report editor. | |
To generate the Data Validation Report:
- Select a Data Validation Group for the appropriate Ed-Fi resource. A description of the validation displays below the name of the group.
- Select an Output Option, either Generate Now or Submit to Batch Queue.
- Select a Format for the report.
- Select the Generate button. The Report will appear in a separate window in the designated format.
A list of validations for each resource can be found in the Data Validation Report section of the corresponding resource PDF, located on the main Tennessee Ed-Fi article.
The Validation Report can be used for the following resources:
- Bell Schedules
- Calendars and Calendar Dates
- Class Periods
- Discipline Actions
- Sections
- Sessions
- Staff Education Organization Assignment Associations
- Staff Section Associations
- Student Education Organization Associations
- Student Homeless Program Associations
- Student School Associations
- Student School Attendance Events
- Student Section Associations
