Understanding the ACA Hours of Service Report Processing

After setting up the parameter record, you run the ACA Hours of Service Report (R081161) in proof or final mode to generate the hours of service report. You use this report to determine which employees meet the ACA hours of service threshold and should be considered full-time under ACA provisions. If you specify an override eligibility status while defining a parameter record, the report displays the new status for all employees as the override status.

When you run the ACA Hours of Service report in proof mode, the system displays employee information from the Employee Master and also the hours of service information, but it does not update any tables in the system.

When you run the report in final mode, the system displays a warning that indicates that the F081161, F081163 and F0811629 tables will be updated. When you accept the warning and process the report, the system updates these tables in the following way:

• F081163: The system retrieves all timecards for an employee having worked with various home companies between the measurement period that you define in the parameter record updates. The system writes a record for each home company in which the employee worked for the given measurement period.

• F0811629: Each time you run this report, the system creates a new ACA parameters history record in F0811629 and assigns it the Eligibility Status Effective Date value for the processed ACA ID. The system assigns a unique Parameter Control Number to this new record on the basis of next number logic.

• F081161: The system creates an employee eligibility record for each employee number that the report processes and assigns each record the Date and Time Last Submitted values and the Parameter Control Number derived for the ACA parameters history record in F0811629. These values make the records unique. The system links the F081161, F081163, and F0811629 tables on the unique Parameter Control Number.

An employee is considered eligible for ACA benefits if one of the following conditions is true:

• Average weekly hours >= 30: This means that on an average the employee worked greater than or equal to 30 hours in a week during the measurement period.

• Average monthly hours >= 130: This means that on an average the employee worked greater than or equal to 130 hours in a month during the measurement period.

  Note:

  You can override the threshold values for average weekly and monthly hours in the processing options of the ACA Hours of Service report (R081161).

• Eligibility Status (New): The system determines the eligibility status in this way:

  • If the employee meets the hours of service thresholds, the system updates the employee status to Y.

• If the employee does not meet either of the hours of service thresholds, the system updates the employee status to N.

• If an override is used, the system updates the eligibility status for all employees processed to the override value.