TSDS Data Verification Reports

The TSDS Data Verification Reports screen is used to view errors in data stored in Focus and to clean the data prior to submitting the extracts. The reports are based on edit rules and validations for each submission and extension.

Running TSDS Data Verification Reports

1. In the Texas Reports menu, click TSDS Data Verification Reports.

2. Select the Submission.

3. Select the Effective Date using the date pull-downs or calendar icon.

4. Select All Schools to generate the report for all schools.

5. Select Show Rules With 0 Errors to include rules that have 0 errors on the report.

6. Click Refresh Report.

7. Click the submission format to generate in the side menu.

8. To collapse the side menu and make the report larger, click the X.

9. To re-display the side menu, click the arrow.

10. To change the Effective Date for the report, select the date using the date pull-downs or calendar icon an click Refresh Report.

A graph is displayed indicating the percentage of records that are error-free.

Beneath the graph, each edit for the format is listed, including the number of errors, the percentage of records that are error-free in parentheses, and the description of the edit.

11. Click the question mark icon to view the query used to generate the error report.

12. Click the number of errors link to view the list of records that are in error.

The detailed information for each error is displayed in a table. The error description is displayed above the table.

13. If the student or user's name is a link, click the link to open the student or user's record in a pop-up window, where you can locate and correct the field in error.

14. To go back to the list of errors, click Go Back to Summary.