The Data Audit Report is a report showing problems associated with the data entered in individual report tables and between tables. Before you may submit your UDS report, you must run the Data Audit Report and address any problems it identifies. Running the Data Audit Report causes the system to run checks on the data in each table and the consistency of data between tables. While it is assumed that you enter the data with great care, it is not unlikely that the Data Audit Report will find problems you will need to address.
You can run the Data Audit Report as soon as you complete data entry for at least one table, and the table is in "Validated" status.
Running the Data Audit Report will generate a list of errors and exceptions (these are collectively called "edits" and are described below) that pertain only to the tables that are already in "Validated" status. No edits will be generated for any tables not in "Validated" status.
Running the Data Audit Report is normally an iterative process, whereby you will run the report, clear the edits it identifies, and then run the report again to see what edits remain. Repeat until running the Data Audit Report displays no edits remaining.
The Data Audit Report displays a list of errors (denoted by ) that exist between the tables in the report and exceptions, or questionable data (denoted by ), that exist either in a particular table or between tables. These are collectively called "edits." To clear edits, you must correct errors and either correct or explain exceptions.
The Data Audit Report generates two types of edits: errors and exceptions.
Errors (denoted by ) are cleared by correcting the error. All errors must be corrected. Figure 1 shows how to correct an error.
Figure 1: Correcting a Data Audit Error
An edit that is produced by a discrepancy in the data between two tables can be corrected in either of the tables, as Figure 1 shows.
Each time you clear a data audit error by navigating to the related section from the data audit list, the edit will be automatically removed from the list. Otherwise, the edit will be removed the next time you execute the Data Audit Report.
Exceptions (denoted by ) are cleared by being corrected or explained, as appropriate. If the Data Audit Report generates an exception as a result of a data entry error, simply correct the error. If the exception is not the result of a data entry error, you must provide an explanation for the data you reported. Figure 2 shows how to clear an exception.
Figure 2: Clearing a Data Audit Exception
If at any time before the submission of the report you correct the data related to an edit for which you previously provided an explanation, the edit will be marked as fixed and will be removed from the list of explained edits.
Once you have cleared all the edits in the Data Audit Report, you will be asked to run the report once more to ensure that you have not generated any new errors. Once you have done this and the report does not generate any errors, the Data Audit page moves to "Complete" status and your UDS report is ready to be submitted.
The edits that are generated as a result of running the Data Audit Report are different from the errors that occur during the data entry process.
Based on the current status, you may see various messages that appear while working with the Data Audit Report. Following is an explanation of the messages:
At least one of your tables should be in the 'Validated' status to run your Data Audit Report.
The above message is displayed when none of the tables in the report has been validated. The option to run the Data Audit Report is not enabled at this time.
Please click on the 'Run Data Audit Report' button below to view the Edits. You will only see the Edits related to the tables that are in 'Validated' status.
The above message is displayed when at least one of the tables in the report has been validated. You may or may not have edits related to those tables. You have the option to run the Data Audit Report and generate any related edits.
You have no more Edits related to the tables that are in 'Validated' status. Please validate the remaining tables.
The above message is displayed when at least one of the tables in the report has been validated and clicking on the Run Data Audit Report button does not generate any related edits. Your next step at this point would be to validate the remaining tables.
Congratulations! All your tables are validated and there are no more Edits. You may now submit the report.
The above message is displayed after the Data Audit Report is marked as Complete. This will occur when there are no more edits in your report and all your tables have been validated. The button to submit the report is now enabled.
The Data Audit Report page can be in any of the statuses in Table 1.
Table 1: Data Audit Report Page Status
The Data Audit Report is in this status until at least one of the tables is in "Validated" status. This gives the grantee or FQHC-LAL the opportunity to enter all the data and resolve all the page-level and table-level errors before trying to resolve cross-table edits.
After it has been run, the Data Audit Report remains in this status so long as there are audit-level edits in the report.
This is the status of the Data Audit Report when there are no audit-level edits in your report and all your tables are in "Validated" status.