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.

PROCESS CONSIDERATIONS:
You may click on the links below to navigate directly to a section:

PROCEDURE STEPS:

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

2. Click on Find an Existing Value to select a Run Control ID or create one by clicking on the Add a New Value tab.

3. Enter parameters for the ACA Hours Reports

Upd. Run Control Page

4. Click "Run"

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

9.2 Process Scheduler Page

6. Click "OK"

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

9.2 Process Monitor Hyperlink

8. 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.

Upd. Details Hyperlink

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

9.2 View Log Trace Hyperlink

10. 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.

9.2 Excel Output File




ACA HOURS REPORT SAMPLE OUTPUTS

1. Missing ACAHW Hours 



2. Unmatched ACAHW Hours 



3. ACA Hours Report



4. ACA Full-Time Trending Report
Trending


5. Measurement Period Report

Measurement Report

6. Not Affordable Full-Time Employees Report

Not Affordable


DATA ELEMENTS:


Hours Report
9.2 Hours Report

Trending Report

9.2 Trending Report
Measurement Report
measurement table

Not Affordable Report
9.2 Not Affordable table


ADDITIONAL RESOURCES:

Related KBs:

Related Links: