Import ACA from HR and Payroll - PYACUTIP

The utility will prompt for the Tax Year and Entity. Employee Selection Criteria may also be entered. This process can be run as many times as needed if information is updated in HR/Payroll and needs to be updated in ACA. Common codes ACAR/GEN and ACAR/1095C need to be created before running the import process. 

The process initially selects employees who had any total pay in the tax year. Selection criteria from optional common code ACAR/SEL are applied, followed by runtime selection criteria. An employee will be skipped if they fail to pass any of the criteria.

Only those entries selected will be updated in the ACA database.  Information previously loaded for employees not included in the selection will remain unaffected. It is important to note that running the PYACUTIP (or PYACUTIF) process does not actually DELETE records, it just adds new records and overwrites existing records.

The job is modified to insert or update Employee Age and Zip Code fields to the Database. The zip codes are populated based on the six new Offer Codes, 1L thru 1Q that are set up as common codes.