Calculate Hours Worked from Run Results for the US

Calculation of worked hours is required for state unemployment insurance (SUI) reporting. You report this data in positions 423-426 of the W record for SUI_ER tax codes on the quarterly tax file.

Note: This method has been discontinued as of 2023.

The payroll process derives hours worked from run results, based on the Hourly Paid or Salaried field on the employee's assignment. This method doesn't use balances.

• For hourly employees, the process excludes classifications and hours related to premium overtime, shift, and retroactive earnings. Hours related to standard earnings are included.

• For salaried employees, the derivation excludes classifications and hours related to retroactive earnings and imputed earnings and looks for elements with input values of either Hours Worked or Hours Calculated. The process uses the maximum of either of these hours input values for the given effective dates in the quarter.

Note: Prior to Q1 2021, this was the only method available to you. You can now calculate hours worked through balances. For further info, see Calculate Hours Worked from Balances for the US in the Help Center.

To adjust the hours worked using run results, you perform a balance adjustment using an element that includes the correct input value for the hours. Perform this adjustment on a different effective date from any payroll runs. It creates a run result that the payroll process uses in the derivations.

For salaried employees requiring an adjustment to their worked hours, you can use a SQL query to assist with reconciliation prior to the adjustment. Depending on how you configured your elements, the hours could be calculated based on either the Hours Worked or Hours Calculated input values. You need to determine which before doing the adjustment. Use the SQL query to help you. For further info, see Cloud US Payroll: What Is the Logic of Reporting Hours Worked of a Salaried Employee in the Quarterly Extract (2727786.1) on My Oracle Support.