How to Run Data Integrity Checks and Resolve Errors

What is it? 

The Data Integrity Check is a tool that can be utilized year round to find/resolve any potential issues that exist in your database. From missing SSNs and incorrect zip codes to questionable tax set ups in administration. These are all common occurrences that can be found by utilizing this tool. The Data Integrity Check can be ran at any time – we highly suggest running it quarterly so to minimize the amount of items built up before year end.

Who can run it? 

Anyone with System Administrator security permissions. If you do not have access please contact your bridge admin.

How do I run it? 

To run your Data Integrity Check, navigate to pay/bill > other > year end. Please note that you should be at the highest level of your hierarchy to encompass all entities when running the check. Once the year end form is opened, you will see a list of years to select from. If you do not see the current year, select the plus icon in the upper right-hand corner to add.

If the current year is there, or if you’ve completed adding it, you can double click the row to bring you into the year end worksheet. For Data Integrity Check purposes, we will only be focusing on “Step 1”.

*Note* Anytime before running a Data Integrity Check, it is recommended that you first click on the Recalculate button to potentially resolve simple errors. 

Click the Run Check button to run the Data Integrity Check. Once the check is completed, click the Data Integrity Check Report on the right-hand side of the form to load the report and view any existing errors.

*Note* This may take a few seconds or a few minutes to load. 

The report is broken into three sections:

  • Blue – Correctable by User
  • Red – Correctable by TempWorks Support Assistance
  • Purple – Warnings – Not necessarily an error

To see a full list of possible errors broken out by type please view them here.

To see the error in detail, select the plus icon to expand the error.

At this stage you can begin to work through the correctable by user errors if applicable. To verify they are being appropriately addressed return to the year end worksheet and “Run Check” to refresh the report as often as you need to.

Related Articles

  • None