Skip to content

Page tree
Skip to end of metadata
Go to start of metadata

What is the Data Audit Report and what does it do?

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.

When and how do I run the Data Audit Report?

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.

What is in the Data Audit Report?

The Data Audit Report displays a list of errors (denoted by Regular Error Icon) that exist between the tables in the report and exceptions, or questionable data (denoted by Exception Icon), 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.

How do I clear data audit edits?

The Data Audit Report generates two types of edits: errors and exceptions.

Errors (denoted by Regular Error Icon) 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

Screenshot of Data Audit Report with annotated errors

Key to Figure 1

  1. For any edit, you can click the Expand button to display or hide the description. (The description is displayed by default.)
  2. The values you entered in the tables appear in parentheses in the description.
  3. Click the link under Options to go to the table and correct the data.
  4. Or click the down arrow under Options ...
  5. ... to display the Context menu and choose a table to correct the data.

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 Exception Icon) 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

Screenshot of Data Audit Report with annotated exceptions

Key to Figure 2

  1. For any edit, you can click the Expand button to display or hide the description. (The description is displayed by default.)
  2. The values you entered in the tables appear in parentheses in the description.
  3. Click the link under Options to go to the table and correct the data.
  4. Or click the down arrow under Options ...
  5. ... to display the Context menu and either choose a table to correct the data, or add an explanation.

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.

Remember! Fixing errors in your UDS report is a two-step process

Step 1: Resolve all the errors (denoted by Regular Error Icon or Critical Error Icon) that are local to a table and are generated during the data entry process.

Step 2: Resolve all the errors in the Data Audit Report (denoted by Regular Error Icon) that are across two tables and all the exceptions (denoted by Exception Icon).

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.

System Messages (for Reference)

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:

Exception Icon 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.

Information Icon 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.

Information Icon 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.

Success Icon 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.

Data Audit Report Page Statuses (for Reference)

The Data Audit Report page can be in any of the statuses in Table 1.
Table 1: Data Audit Report Page Status

 Symbol

Status

Denotes

Not Started Icon

Not Started

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.

In Progress Icon

In Progress

After it has been run, the Data Audit Report remains in this status so long as there are audit-level edits in the report.

Complete Icon

Complete

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.
You cannot submit your UDS report until all the tables are in "Validated" status and the Data Audit Report page is in "Complete" status.

  • No labels