The ACA TRACK system allows you to either import a file that you already have the data in the exact required format or bring in your existing file(s) and link your datasets to the required column headers, job codes, coverage types, status codes, alpha, numeric that then our system will consolidate your file data into the required format.

• ACA TRACK formats data, column headers, job codes, status codes and coverage types that are unique to each employer.
• Convert null values into standardized Not Available/Not Provided value.
• Convert DOH, ZIP codes to a standardized form.
• Coverts months/days/year automatically into the correct format.
• Validate address fields, convert them into proper naming, e.g. Street/St/St./Str./Str
• Validate address fields against each other (State/Country, City/State, City/ZIP code, City/Street).

The transform step applies a set of rules to transform the data from the source (Employer File) to the ACA TRACK software. The transformation step automates data from several sources, deriving newly calculated values and applying advanced validation rules.

The transform step applies a set of rules to transform the data from the source (Employer File) to the ACA TRACK software. The transformation step automates data from several sources, deriving newly calculated values and applying advanced validation rules.

During the load step, it is necessary to ensure that the load is performed correctly and with as little resources as possible. Using a simple excel or CVR file our customers will upload files and start the automated process. ACA TRACK can provide audit reports within 5-10 minutes outlining any failed or missing data.

Don't spend weeks and months lining up rows and columns in a specific format--ACA TRACK has automated this process for you.

Clients can include our Variable Hour Tracking and/or State Individual Mandate Reporting with this service level.