Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-01-24
Concept: Hours Aggregation on Pay Results

Concept: Hours Aggregation on Pay Results

You can configure Workday to aggregate the hours from these sources into 1 line:
  • Pay inputs.
  • Workday Time Tracking time blocks.

Criteria for Aggregation

Workday aggregates hours from pay inputs or time blocks on which all of these attributes are the same:
  • Company
  • Costing company
  • Currency override
  • Pay component
  • Position
  • Rate
  • Workers compensation codes
  • Worktags
Pay inputs and time blocks that differ in any of these attributes aggregate separately.
Example
Robert worked 10 8-hour days this pay period. Daily pay inputs were identical, except for the costing company.
  • The 64 hours costed to company A aggregate into 1 result line.
  • The 16 hours costed to company B aggregate into another result line.
Example
Lindsey worked 10 8-hour days this pay period. She received a compensation increase from 20 to 22 on the sixth day. This proration event creates a separate subperiod and therefore separate result lines:
  • 40 hours at the 20 rate aggregate into 1 result line.
  • 40 hours at the 22 rate aggregate into another result line.

Hours That Don't Aggregate

Workday doesn't aggregate:
  • Ongoing pay inputs.
  • Inputs with more than 1 input line, such as hours and rate.
Adjustments aggregate only with other adjustments. Overrides aggregate only with other overrides.

Aggregation and Ongoing Multiple Work Jurisdictions (USA)

When you use ongoing multiple work jurisdictions (OMWJ), Workday aggregates input and time block hours according to the allocation percentages.
Example
Christopher's work jurisdiction allocations are as follows:
  • California: 40%
  • Oregon: 40%
  • Hawaii: 20%
In the current pay period, he has these inputs:
  • Input 1 (Monday): 10 hours
  • Input 2 (Tuesday): 5 hours
Without aggregation, Christopher has 6 pay result lines:
Pay Component
Worktag
Related Calculation
Amount
Input Amount
Hourly Pay [USA]
California
Hours (unprorated)
4 hours
10
Hourly Pay [USA]
Oregon
Hours (unprorated)
4 hours
10
Hourly Pay [USA]
Hawaii
Hours (unprorated)
2 hours
10
Hourly Pay [USA]
California
Hours (unprorated)
2 hours
5
Hourly Pay [USA]
Oregon
Hours (unprorated)
2 hours
5
Hourly Pay [USA]
Hawaii
Hours (unprorated)
1 hour
5
With aggregation, Christopher has 3 pay result lines:
Pay Component
Worktag
Related Calculation
Amount
Input Amount
Hourly Pay [USA]
California
Hours (unprorated)
6 hours
15
Hourly Pay [USA]
Oregon
Hours (unprorated)
6 hours
15
Hourly Pay [USA]
Hawaii
Hours (unprorated)
3 hours
15
When you enter an override State worktag on a pay input, Workday doesn't aggregate that input with inputs that it allocates according to OMWJ splits.
Example
You add another 8-hour pay input for Christopher, with a California override worktag so California tax rates apply to all 8 hours. Workday adds a pay result line for the input and doesn’t add it to the OMWJ-allocated California hours.
Pay Component
Worktag
Related Calculation
Amount
Input Amount
Hourly Pay [USA]
California (OMWJ split)
Hours (unprorated)
6 hours
15
Hourly Pay [USA]
Oregon
Hours (unprorated)
6 hours
15
Hourly Pay [USA]
Hawaii
Hours (unprorated)
3 hours
15
Hourly Pay [USA]
California (override worktag)
Hours (unprorated)
8 hours
8

Retro Calculations

Workday can aggregate hours for retroactive pay inputs. You can configure hours aggregation on the
Effective Dated
 tab of the pay component. Workday uses the snapshot in effect at the end of the pay period to determine whether to aggregate retroactive pay input for prior periods.
Example
The pay component Hourly Pay has 3 effective-dated snapshots:
  • 2019-01-01
  • 2019-03-15
  • 2019-04-01
You add retroactive pay inputs for the monthly pay period 2019-03-01 through 2019-03-31. Workday checks the status of the
Aggregate
 check box for the pay component related calculation in the 2019-03-15 snapshot. When selected, Workday aggregates the hours.
Because Workday aggregates hours when calculating payroll, you won't see aggregated hours on pay results that Workday calculated before you enabled aggregation.

Rounding in Payroll Calculations

You might see a nominal difference in pay results when you compare unaggregated result lines to result lines that Workday aggregates. Since rounding occurs after Workday completes the calculations, rounding the aggregated result line produces a more precise sum.
Example
Pay result lines without aggregation enabled:
Hours
Rate
Total
7.125
15.15000
107.94
7.125
15.15000
107.94
7.125
15.15000
107.94
Sum
323.82
Pay result line with aggregation enabled:
Hours
Rate
Total
21.375
15.15000
323.83
Sum
323.83