Affordable Care Act - Year End Self Insured Individuals

The Affordable Care Act - Year End Self Insured Individuals report uses the Affordable Care Act - Year End topic to display Affordable Care Act year-end details for employees and covered individuals from the 1095-C Forms.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number		A to Z
Employee Name		Ascending
Year
Employee Social Security Number
Employee Birth Date
Dependent Name
Relationship Type
Dependent Social Security Number
Dependent Birth Date
Is Covered Jan-Is covered Dec

Custom Fields

Year

The Year custom field displays the ACA year. It uses the following expression:

REPLACE(CAST(BenACAYearEndFiling.Year AS NVARCHAR(4)),',','')

Dependent Name

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

EmployeeDependentBeneficiary.FirstName + ' ' +  EmployeeDependentBeneficiary.LastName

Is Covered Jan

The Is Covered Jan field indicates whether the individual is covered during the selected month. It uses the following expression:

CASE
    WHEN BenefitsACAYearEndEmployee1095CoveredIndividual.IsCovered1 = 0 THEN 'No'
    ELSE 'Yes'
END

Note: There are more custom fields like the Is Covered Jan field for each month of the year.

Filters

The template includes the following filters: