The Affordable Care Act - Year End Coverage report uses the Affordable Care Act - Year End topic to display employee ACA year end information, including monthly offered coverage, LCMP, and Safe Harbor details for the selected filing year from the 1095-C forms.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| EIN | A to Z | ||
| Employee Number | A to Z | ||
| Employee Name | Ascending | ||
| Year | |||
| Original Hire Date | |||
| Rehire Date | |||
| Termination Date | |||
| Completion Status | |||
| 1095 - C Status | |||
| Is Self Insured | |||
| Is Manual Override | |||
| Jan Coverage | |||
| Jan LCMP | |||
| Jan Safe Harbor |
Note: Each month of the year has Coverage, LCMP, and Safe Harbor fields.
Custom Fields
Year
The Year custom field displays the year. It uses the following expression:
REPLACE(CAST(BenACAYearEndFiling.Year AS NVARCHAR(4)),',','')
Is Self Insured
The Is Self Insured field indicates if the individual is self-insured. It uses the following expression:
CASE
WHEN BenefitsACAYearEndEmployee1095.IsSelfInsured = 0 THEN 'No'
ELSE 'Yes'
END
Is Manual Override
The Is Manual Override field displays manual override. It uses the following expression:
CASE
WHEN BenefitsACAYearEndEmployee1095.IsLegalEntityAssignmentOverride = 0 THEN 'No'
ELSE 'Yes'
END
Filters
The template includes the following filters:
