Affordable Care Act - 1095-C by Delivery Option

The Affordable Care Act - 1095-C by Delivery Option report is a variation of the Affordable Care Act - Year End Coverage report, and it uses the Affordable Care Act - Year End topic. This variation displays employees whose completed 1095-C forms are ready to send, and their selected delivery method (electronic only or print and electronic).

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Delivery Option	Yes	A to Z
Name Number		A to Z
Legal Entity Name		A to Z
EIN
Filing Year

Custom Fields

Delivery Option

The Delivery Option custom field displays the employee’s selected delivery option for the 1095-C form. It uses the following expression:

CASE
    WHEN (BenefitsACAYearEndEmployeeElectronicConsent.TaxFormCode = '1095C'
          AND BenefitsACAYearEndEmployeeElectronicConsent.IsConsented = 1) THEN 'Electronic Only'
    WHEN (BenefitsACAYearEndEmployeeElectronicConsent.TaxFormCode IS NULL
          AND BenefitsACAYearEndEmployeeElectronicConsent.IsConsented = 1) THEN 'No1095Consent'
    WHEN (BenefitsACAYearEndEmployeeElectronicConsent.TaxFormCode <> '1095C'
          AND BenefitsACAYearEndEmployeeElectronicConsent.IsConsented = 1) THEN 'No1095Consent'
    WHEN BenefitsACAYearEndEmployeeElectronicConsent.IsConsented = 0 THEN 'Printed and Electronic'
END

Filing Year

The Filing Year custom field displays the filing year that the record is associated with. It uses the following expression:

CAST(BenefitsACAYearEndEmployee1095.Year as VARCHAR)

Filters

This template includes the following filters: