Invalid Formatting
If your dates, zip codes, and Social Security numbers are not formatted correctly, they will cause a Data Validation error. Review all of your columns and make sure you have formatted your information appropriately. For a complete guide to formatting your data columns, see the Employee Datasheet – Field Requirements.
It is also a good idea to make sure you select the correct column formatting within Excel. We’ve found you can reduce many errors by using their Special formatting options for zip codes and Social Security numbers:
Inconsistent Data Mapping
Many upload errors result from inconsistencies between the Company/Division and Plan codes listed in ACA Track and those used within your data file.
Before uploading your data file, it is highly recommended that you review our Data Mapping Guide, to ensure the codes used in your data file are properly mapped to our system. If not, the upload will fail.
Inconsistencies with Employment and Coverage Changes
Data Integrity Errors are most often caused by inconsistencies between dates and employment and/or insurance coverage changes.
When compiling your employee data, be sure to review the latest version of the Employee Datasheet Guide and Scenarios Spreadsheet.
Next Step: Data Inspection 6 - Best Practices for Loading Data