Purpose

How to view the ACA Data Detailed Report

Column Headers

1. Employee EIN - EIN 
2. Employee Status - Active/Terminated
3. Month - month of the year being viewed.
4. Year - year being viewed.
5. 1095-C Line 14 Codes (Series 1) -  Describes the coverage that employer offered to employee and their spouse and dependent(s), if any.
6. 1095-C Line 15 Amount - Reports the employee required contribution, which is the monthly cost the employee for the lowest cost self-only minimum essential coverage providing minimum value that the company offered.
7. 1095-C Line 16 Codes (Series 2) - reports information about the type of coverage an employee is enrolled in and if the employer has met the employer’s shared responsibility "Safe Harbor" provisions of Section 4980H.
1. 2A - Employee not employed during the month
2. 2B - Employee not a full-time employee
3. 2C - Employee enrolled in coverage offered. (This code usually supersedes all other codes.)
4. 2D - Employee in a section 4980H(b) Limited Non-Assessment Period.
5. 2E - Multiemployer interim rule relief. Applies only to multiemployer plans, not applicable to the State Health Plan (SHP). 
6. 2F - Section 4980H affordability Form W-2 safe harbor. 
7. 2G - Section 4980H affordability FPL safe harbor.
8. 2H - Section 4980H affordability rate of pay safe harbor. 
9. 2I - Non-calendar year transition relief applies to this employee. Not applicable to the SHP. 
8. Hours - Hours worked that month
9. Average Hours in Measurement Period - Average number of hours worked in the signified Measurement Period
10. Month Status - FT/PT
11. ACA Status - FT/PT
12. Waiting Period Month - Shows either month 1 or 2
13. Compliance Alert - Y/N (shows if an employee is in danger of moving from FT-PT or vice versa)
14. Approaching ACA FT - PT employee working enough to qualify as FT
15. Possible Downgrade - FT employee not working enough to qualify as FT
16. Error Code - Lists error code if one is present
17. Limited Non Assessment Period - Y/N. Period of time where an employer is not subject to certain ACA penalties (first three months of employment, change in full time status, etc).
18. Initial Measurement Month - First month of plan year = 1, month after that = 2, etc.
19. Initial Administrative Month - first month of employment for a new hire where an employer is determining if they qualify as a full-time employee
20. Initial Stability Month - the first month within a new employee's initial measurement period, typically considered to be the 13th month following their hire date
21. Standard Measurement Month - a calendar month where an employee is considered full-time if they work at least 130 hours of service
22. Standard Administrative Month - a single calendar month used to report whether an individual was covered by health insurance for that specific month
23. Standard Stability Month - the period of time during which an employee is considered full-time for health insurance purposes, even if their hours fluctuate, based on a previous measurement period where they averaged at least 130 hours per month
24. Affordable Plan Offered - Y/N 
25. Minimum Value Plan Offered - Y/N