Affordable Care Act - Employee Offered Coverage

The Affordable Care Act - Employee Offered Coverage report uses the Affordable Care Act - Employee Offered Coverage topic to display coverage details for the Affordable Care Act, such as benefit plan options, costs, plan effective start dates, and the month coverage was offered.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number		A to Z
Employee Name		A to Z
Original Hire Date
Employment Status
Job Assignment
Location
Dependent Name
Benefit Option
Event Date
Stability Period Start
Plan Effective Start Date
Month Coverage Offered
Annual Employee Cost
Annual Employer Cost

Custom Fields

Dependent Name

The Dependent Name custom field displays the name of the dependent. It uses the following expression:

BenDependentOffering.FirstName + ' ' + BenDependentOffering.LastName

Month Coverage Offered

The Month Coverage Offered custom field displays the month in which coverage was offered. It uses the following expression:

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

Filters

This template includes the following filters: