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.