The Data Validation Report lists any errors that are detected during the Data Validation Inspection. The Data Validation Inspection reviews your data to ensure it meets all of our data requirements, such as using proper formatting (for dates, SSN, etc.) and that all of your internal codes (for Job Status, Division, Plan ID, etc.) are properly mapped to a recognized Standard Code. These errors must be corrected before you can continue uploading your employee or dependent data.


Your Data Validation Report includes 3 sections: The Results Summary, Validation Detail Report, and Records with Issues. All of these sections are available from the bottom tab within the Excel report file.


Results Summary

The Results Summary provides a broad overview of your Data Validation test results, including:

  • The number of employee records that passed the inspection.
  • The number of employee records that failed the inspection.
  • The number of errors that occurred within each data column.

 

Errror%20Report%20-%20Data%20Validation%20-%20Summary.PNG



Validation Detail Report

For specific information regarding the errors that occurred (and how to correct them), go to the Validation Detail Report tab.


This tab lists each error and provides the following information:

  • Problem Column: Lists the column in which the error occurred. This will tell you the type of data that is in error, such as an employee’s “Division.”
  • Error Message: Provides specific details about the error.
  • Row Number: Lists the row in your original data file where the error occurred.
  • Row Data: Lists the invalid response from your original data file.

 

Error%20Report%20-%20Data%20Validation.PNG

For additional information about these error messages and our data requirements, see the most recent Employee Datasheet Guide and Scenarios Spreadsheet.


Records with Issues

The Records with Issues tab provides a complete list of the employee or dependent records that contained errors.

 

Error%20Report%20-%20Data%20Validation%20-%20Records%20with%20Issues.PNG


When reviewing this tab, we recommend sorting the data by Employee SSN, as this will group all data regarding a specific employee. If the error is with the SSN, you can also sort your data by first and/or last name.


Note that the first column of this report (Original Row #) references the row number from your original data file. You can use this number to quickly locate the error in your employee datasheet and make any necessary changes, or to cross-reference with the Detail Tab on your Validation Report. 


 

Correcting Your Data

Using the results of your Data Validation Report, you should make changes to the information contained in the corresponding Employee or Dependent Data File.


To find the original data file, simply return to your Data Upload History and click the Excel icon next to the corresponding error report:


Data%20Validation%20Error%20-%20Report%20Icon.png


Once you have updated all of the invalid data items, return to the Data Upload History and click the Re-Upload icon:


Data%20Validation%20Error%20-%20Resubmit%20Icon.png


This will return you to the Data Upload screen. For more information about uploading your employee or dependent data, see the Loading Employee and Dependent Data Guide.



See Also:




Download the complete guide

See the video tutorial