MPI_1403 ACA Large Employer Estimate Report
This
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.