Determining the adjustment period based on the offset

To determine the start and end dates of the adjustment period, this logic is used:

  • Adjustment Start = min(Current pay period start date + Offset, Last pay period export time)
  • Adjustment End = min(Current pay period end date + 1 day + Offset, Current pay period export time)

To ensure that adjustments created on the day of the export are exported, the last pay period export time is considered while exporting adjustments.

Example: Using an adjustment offset of 2

Consider this scenario with weekly pay periods and an adjustment offset of 2:

  • Adjustment Offset: 2
  • Pay Period 1: May 9, 2021 - May 15, 2021
  • Pay Period 2: May 16, 2021 - May 22, 2021
  • Pay Period 3: May 23, 2021 - May 29, 2021

Usually, the payroll is exported on the Monday following the pay period. For the second pay period, the payroll was exported a day later:

  • Pay Period 1 Export Time: May 17, 2021 09:00
  • Pay Period 2 Export Time: May 25, 2021 09:00
  • Pay Period 3 Export Time: May 31, 2021 09:00

The adjustment period for the first pay period is as follows:

  • Adjustment Start = min(May 9, 2021 + 2, null) = May 11, 2021 00:00
  • Adjustment End = min(May 15, 2021 + 1 + 2, May 17, 2021 09:00) = May 17, 2021 09:00.

Any adjustments created before May 17, 2021 09:00 will be exported during the first payroll export.

The adjustment period for the second pay period is as follows:

  • Adjustment Start = min(May 16, 2021 + 2, May 17, 2021 09:00) = May 17, 2021 09:00
  • Adjustment End = min(May 22, 2021 + 1 + 2, May 25, 2021 09:00) = May 25, 2021 00:00

Any adjustments created during May 17, 2021 09:00 to May 25, 2021 00:00 will be exported during the second payroll export.

The adjustment period for the third pay period is as follows:

  • Adjustment Start = min(May 23, 2021 + 2, May 25, 2021 09:00) = May 25, 2021 00:00
  • Adjustment End = min(May 29, 2021 + 1 + 2, May 31, 2021 09:00) = May 31, 2021 09:00

Any adjustments created during May 25, 2021 00:00 to May 31, 2021 09:00 will be exported during the third payroll export.