1. US Affordable Care Act Year-End Processing Guide
  2. Creating the Form 1094-C Workfile

Creating the Form 1094-C Workfile

To create the Build 1094-C HCIR Workfile (R08121A), access ACA Information Returns, Advanced & Technical Operations menu (G07BACAA), 1094-C Transmittal Workfile Build. In the Work With Batch Versions - Available Versions form, select the version to process and then click Select to build the report.

The R08121A-Build 1094-C Workfile process will:

  • automatically add Form 1094-C record in the F08121 workfile for AIR IDs to which you have manually not added the Form 1094-C record.

  • ensure that there is an Authoritative Transmittal Form 1094-C record for each taxpayer.

  • calculate Full-Time and Total Employee Counts by month for the reporting year for all Authoritative Transmittal 1094-C records.

  • create records for Other ALE Members in the F08123- 1094C Other Aggregated ALE Group Members table and populate with Average Full-Time Employee Count for the reporting year.

Note: If a Form 1094-C record already exists for an ALE Member when you run the R08121A process, the JD Edwards EnterpriseOne system updates the 1094C ALE Member Information - Monthly (F08122) and 1094C Other Aggregated ALE Group Members (F08123) tables but does not update the record for the ALE Member in the 1094C ALE Member Information (F08121) table. Therefore, ensure that you run the R08121A report in Proof mode and check the values before running the R08121A report in Final mode.