BN - Affordable Care Act (ACA) Reports

GENERAL DESCRIPTION:

This document provides the steps for running the ACA reports, examples of output reports and a description of each report, as well as an explanation of the data elements.

Procedure At-A-Glance
Category: ACA Reports
Audience: HR, Payroll, and Benefits Administrators
Overarching Process: ACA
Navigation: UW HR Reports>ACA Hours Reports
Jump To:

 Process Inputs

  • Year = Calendar year being reviewed
  • Month = Numeric value for beginning month 
  • Process Thru Month = Numeric value for ending month
  • Campus (Optional) = Narrow search to specific campus
  • Pay Group Starts With (Optional) = Narrow search to specific Pay Group
  • Employee ID = Unique employee identifier allows you to run the report for an individual employee. Leave blank to pull data for all employees
  •  

Process Outputs

The ACA Hours Report Run Control Page allows you to create six possible outputs for reviewing hours and trending status.
  • Missing ACAHW Hours (UW_ACAHWREQ) - Lump sum payments with no ACAHW hours reported where Days-Worked Equivalency method is being used
  • Unmatched ACAHW Hours (UW_ACAHWNUSE) - Time that has been entered in Time & Labor using ACAHW time reporting code with no corresponding lump sum payment
  • ACA Hours Report (UW_ACAHRSRPT) - Summary report showing all hours (regular, work study, ACAHW, and Days-Worked Equivalency)
  • ACA Full-Time Trending Report (UW_ACA_TREND) - identify borderline full-time eligible and full-time eligible employees whose current total hours and their expected hours are equal to or greater than 120 hours
  • Measurement Period Report (UW_ACA_MPRPT) - run for specific employees to get measurement and stability periods
  • Not Affordable Full-Time Employees (UW_ACANAFTRP) - employees by month that were ACA full time and not offered coverage or the coverage was not affordable

Process Considerations

  • Data updates monthly after ACA File Process runs.

Procedure Steps

1. Navigate to: UW HR Reports>ACA Hours Reports

2. If you have never created a Run Control ID:

  • Click Add a New Value and enter a run control ID (this can be your initials, name, or any other identifier you choose) and click Add button.

ACA 1

3. If you have created a Run Control ID:

  • Either enter your Run Control ID and click Search OR
  • Click Search and select your Run Control ID

ACA 2

4. Enter parameters for the ACA Hours Reports

  • Year = Calendar year being reviewed (i.e. 2016)
  • Month = Numeric value for beginning month
    • Jan=1, Feb=2, Mar=3, etc
  • Process Thru Month = Numeric value for ending month
  • Campus (Optional) = Narrow search to specific campus
    • Green Bay = UWGBY, Madison = UWMSN, etc.
    • Optional field, wildcard not needed
  • Pay Group Starts With (Optional) = Narrow search to specific pay group
  • Empl ID = to run for an employee. If left blank, report processes for all employees

ACA 3

5. Click "Run"

6. Select the report(s) to be reviewed. Multiple reports may be checked at the same time, but only check Measurement Period Report if reviewing specific employees.

ACA Report

7. Click "OK"

8. Click on the Process Monitor to view the status.

ACA 5

9. On this screen, look for the process instance and click "Details" when Run Status reads "Success" and Distribution Status reads "Posted". Click the yellow refresh button until it is successfully posted.

ACA 6

10. On Process Details screen, click on the View Log/Trace hyperlink to check the output file.

ACA 7

11. Locate the File List and find the Excel file to view the report. If multiple reports have been selected, each report must be opened individually (refer to step 9).

ACA 8




ACA Hours Report Sample Outputs

1. Missing ACAHW Hours 

  • Lump sum payments with no ACAHW hours reported where Days-Worked Equivalency method is being used. Hours Data Element Table



2. Unmatched ACAHW Hours 

  • Time that has been entered in Time & Labor using ACAHW time reporting code with no corresponding lump sum payment. Hours Data Element Table



3. ACA Hours Report



4. ACA Full-Time Trending Report
  • Use to identify borderline full-time eligible and full-time eligible employees whose current total hours and their expected hours are equal to or greater than 120 hours. Trending Data Element Table  
Trending


5. Measurement Period Report

Measurement Report

6. Not Affordable Full-Time Employees Report

Not Affordable

DATA ELEMENTS:

Hours Report
Hours Report

Trending Report

Trending Report
Measurement Report
measurement table

Not Affordable Report
Not Afford Table


Related Policies, Job Aids and Forms

Related Policies

Related Job Aids




Keywords:ACA ACAHW Lump Sum 1095c   Doc ID:65060
Owner:Tina H.Group:Human Resource System (HRS)
Created:2016-07-12 00:00 CSTUpdated:2016-11-29 16:18 CST
Sites:Human Resource System (HRS)
Feedback:  0   0