MPI_1403 ACA Large Employer Estimate Report

This topic contains specific information about the MPI_1403 ACAClosed Affordable Care Act Large Employer Estimate report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

The determination of “large employer” status (Applicable Large Employer, or ALE) is based on the employer having at least 50 full-time or FTE employees. The calculation uses the actual hours worked by each employee for each month. Millennium® 3 does not store the data needed to determine actual hours. Therefore, this report has been created to determine ALE based on each employee’s payroll periods for each month; it will provide the company with an estimate of whether they are considered to be a large employer.

Note: Employers that are estimated to be an ALE by this report, or are close to the 50 employee threshold, should ensure accuracy by carefully reviewing their own time keeping records to determine the actual hours worked by each employee for each month.

Date Selection

This report is based on the Report Year, Starting Month, and Ending Month additional formulas (explained below).

Data Selection

The Data Selection tab has no impact on the report. You may run the report on the current company or, if you are working with a parent/child enterprise, enter the parent company code in the Parent Company additional formula.

Subtotals/Breaks

The Subtotals/Breaks tab has no impact on the report. This report has no sorts or groups.

Additional Formulas

In the Report Properties dialog, click on the Additional Formulas tab. The system displays the Additional Formulas page:

Figure 2-443: Additional Formulas page

Explanations of the additional formulas are as follows:

Parent Company

To run the report for an enterprise (parent/child companies), enter the parent company code or ID for parent/child reporting.

Note: Do not enter a company code in this field unless you have access to the parent and child companies.

If you do not access to any other companies, leave this formula is left blank. The report will display the current company’s information only.

Group Code

Enter the code group that will be used to identify service hours.

Note: This field works in conjunction with the Parent Company field. If you are running this report for a parent/child enterprise, you must ensure that all companies in the enterprise have a code group of the same name with the same list of codes. They must all be identical in name and definition.

Report Year

Enter the year that the look back period will use. Entry must be in YYYY format.

Starting Month

Use this drop-down list to select the starting look back month. In other words, it is used with the Report Year formula to create the first month shown.

Ending Month

Use this drop-down list to select the ending look back month. In other words, it is used with the Report Year formula to create the last month shown.

Include Seasonal

Put a check in this check box to include the seasonal employee information columns.

Seasonal employees are always included in this report’s employee counts. This additional formula simply determines whether further information is included or not.