Task 2 – Run the MPI_1403 Report

This topic explains how to set up the report to help you determine your company’s large employer status. This is the second major task you must complete in working with the employer shared responsibility portion of the ACA Affordable Care Act.

The MPI_1403 ACA Large Employer Estimate report provides employers with a tool to estimate the company’s large employer status when they have a mix of full-time, part-time, and seasonal employees.

See MPI_1403 ACA Large Employer Estimate Report for complete information about that report.

Overview

When determining whether a company is an Applicable Large Employer (ALE), the Final regulations requires the employee’s full-time and part-time status should be calculated based on actual hours worked during the prior calendar year. The Final regulations do not allow the look back period measurement test to determine ALE.

To determine ALE, the company must determine the total number of full-time and full-time equivalent employees for each calendar month of the year. They must then determine the average full-time/FTEs per month for the calendar year.

Set Up the Additional Formulas

To determine whether a company is an ALE, run the ACA Large Employer Estimate report (MPI_1403). Use the steps that follow to configure the report to produce output specifically for this purpose:

1. Ensure a code group is set up for service hours. If not, create one.
2. Select the MPI_1403 ACA Large Employer Estimate Report in Millennium® 3 and open the Report Properties dialog.
3. Select the Additional Formulas tab:

4. If you are working with a parent/child enterprise, enter the parent company code in the Parent Company text box.
5. Enter the appropriate payroll code group in the Code Group text box.
6. Enter or select appropriate dates in the Report Year, Starting Month, and Ending Month drop-down lists.
7. Enter a check in the Include Seasonal box to display seasonal employee information.
8. Once you are done, click the OK button and run the report.