You can view the status of your upload, as well as any errors that were detected during the data inspection, by visiting the Data Upload tab.




If a batch passed all of the tests, its status will be listed as “Data Upload Complete.” No further action is required.




If the batch upload and inspection is still in progress, its status will be listed as “Data Validation Inspection in Progress.”



Data Integrity Failure (See Above): With the Data Integrity Test, it’s possible for some of your data to pass while other data fails. In this case, you will receive a “Partial Upload Success” status. In this case, the successful employees will be loaded to the database but the rejected employees will be separated for correction and resubmission. 


The ACA Track system will then create a new sub-batch, calling out the data that failed the inspection. The sub-batch appears directly below the main batch, and will have a status of “Partial Fail – Data Integrity Inspection”:




Correct a Failed Sub-Batch

If your file fails the Integrity test, you only need to correct and re-upload those employee records that failed the test. To do that:

1. Download and review the Data Integrity Error Report (blob1476716847549.png), by clicking the yellow folder located to the right of the Sub-Batch row.

2. Correct the employee data listed on the “Rejected Records” tab of the Error Report, and save the file. Make sure to update these records in your original batch file as well, so they will not cause an error when you load data next month.

3. Click the blob1476716937352.png icon to return to the Data Upload screen.

4. When choosing a file to upload, find the updated Data Integrity Report, and select the “Rejected Records” worksheet – this should contain just the records you needed to correct.

5. Upload the corrected data.

6. If the new sub-batch data passes inspection, its status will be updated to “Data Upload Complete”:




Note: If you prefer to re-upload the entire original batch file, you can do so. Any redundant data will overwrite the original data. Keep in mind, however, that resubmitting the entire file may significantly increase the time required to validate the corrected data.  

 

Delete Batch Files – You can delete a batch or sub-batch file by clicking the blob1476717066023.pngicon located to the right of that file’s row.


Review Batch Files – You can review a batch or sub-batch file by clicking the blob1476717099482.png icon located to the right of that file’s row.


Note: If you are working on an actual or corrective batch type, then it is important to work the batches to completion. Do not abandon failed Actual or Corrective batches. Either delete them, or correct them. A failed Actual/Corrective batch will prevent the processing of 1095-C reports.

 


Multiple sub-batches

As you revise and re-upload your failed sub-batches, it is possible that the new data files will also fail the inspection process. In this case, ACA Track will create a new sub-batch, which contains only those records that failed during the latest attempt.



In the example above, the original August Batch File was partially successful:

  1. Out of the 17 employee records uploaded, 14 passed inspection, while 3 failed. The system created Sub-Batch V1.
  2. When Sub-Batch V1 was updated and re-uploaded, it was again a Partial Upload Success. Of the 3 remaining records, 1 passed during this second attempt, while 2 still failed.
  3. The system then created Sub-Batch V2, which contains only the 2 remaining failures. These records will need to be reviewed again and either re-uploaded or deleted.
  4. Once all records pass inspection, the final sub-batch status will be updated to “Data Upload Complete.”



Next Step: Data Inspection 5 - Common Reasons for Upload Failures




Download the complete guide

See the video tutorial