Affordable Care Act - Offered Coverage for Selected Employees

The Affordable Care Act - Offered Coverage for Selected Employees report is a variation of the Affordable Care Act - Employee Offered Coverage template, and it uses the Affordable Care Act - Employee Offered Coverage topic. It displays ACA-reportable coverage offer details for selected employees or options during a selected date range.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Name Number		A to Z
Benefit Option		Ascending
Hire Date
Month Offered Cov.
Offered Cov. Start

Custom Fields

Month Offered Cov.

The Month Offered Cov. custom field displays the month the coverage is offered. It uses the following expression:

CASE
    WHEN DATEPART(dd, (BenEmployeeOffering.PlanEffectiveStart)) = 1 THEN DATENAME(MONTH, BenEmployeeOffering.PlanEffectiveStart)
    ELSE DATENAME(MONTH,DATEADD(MM,1,BenEmployeeOffering.PlanEffectiveStart))
END

Filters

The template includes the following filters: