The Consecutive Day operands are used to define Pay Rules that classify time based on the number of consecutive days that have been worked. For example, employees may be paid double-time if they work more than 48 hours in 7 consecutive days.
If you plan on using Consecutive Day rules, you need to define the rules using the Calc Rule form. You must then assign the rules to a Ruleset. You must also configure your Pay Policy and Recalculation Policy for the Consecutive Day rules.
See Also:
Consecutive Day Pay Rule Operands
Consecutive Day Settings in Pay Policy
Recalculation and Consecutive Day Rules
You must define your Consecutive Day rules in the Calc Rule form and assign the rules to a ruleset using the Rulesets form. The context for these rules/rulesets is PayRulesRuleset.
The following Pay Rule Operands are used for consecutive days.
Get Consecutive Gap Days Hours Over
Finds the hours that have posted on the employee's timecard on a specific consecutive gap day (gap day 1, 2, 3, and so on) after a specific amount of hours have posted across the indicated consecutive gap days since the start of pay week or pay period.
Get Over Dynamic Consecutive Day Threshold
Typically, this operand is used in a THEN clause with the Set Hours Classification operand when the Is Over Dynamic Consecutive Day Threshold operand is used in the IF clause. This operand will get the hours that need to be classified based on a number of consecutive days that have been worked. See Example 1.
Is Consecutive All Gap Days
Checks for a certain number of gap days in successive order in the pay week or pay period. The Gap Day Minimum and Gap Day Min Amt settings in the person’s Pay Policy define the minimum amount of time required to make a day count as a gap day for this operand.
Is Consecutive Days
Checks for a certain number of days (scheduled or gap) in successive order in the pay week or pay period. The Gap Day Minimum, Gap Day Min Amt, Sch Day Minimum, and Sch Day Min Amt settings in the person’s Pay Policy define the minimum amount of time required to make a day count as a gap day or a scheduled day for this operand.
Is Consecutive Days With Cycle
This operand checks for a specific day number in a range of consecutive days (scheduled or gap) in the person’s assigned Schedule Cycle. Because a Schedule Cycle can start and end outside a pay week or pay period, and have any number of days, this operand is needed to determine how the consecutive days should be counted based on a Schedule Cycle.
Is Consecutive Gap Days
Checks for a certain amount of unscheduled gap days in successive order in the pay week or pay period. The Gap Day Minimum and Gap Day Min Amt settings in the person’s Pay Policy define the minimum amount of time required to make a day count as a gap day for this operand.
Is Consecutive Gap Days Hours Over
Checks if there are additional consecutive gap day hours posted beyond the entered amount for a specific amount of consecutive gap days since the start of pay week or pay period. The Gap Day Minimum and Gap Day Min Amt settings in the person’s Pay Policy define the minimum amount of time required to make a day count as a gap day for this operand.
Is Consecutive Schedule Days
Checks for a certain amount of scheduled days (no gap) in successive order in the pay week or pay period. The Sch Day Minimum and Sch Day Min Amt settings in the person’s Pay Policy define the minimum amount of time required to make a day count as a scheduled day for this operand.
Is Dynamic Consecutive Day
This operand checks to see if a specified number of consecutive days have passed that meet the Consecutive Day requirements in the Pay Policy. The consecutive days do not have to be in the same pay week or pay period.
Is Over Dynamic Consecutive Day Threshold
This operand checks to see if a specified number of consecutive days have passed after a threshold number of hours have been worked. The consecutive days do not have to be in the same pay week or pay period. See Example 1.
Note that in addition to the consecutive day pay rules shown below, your Pay Policy has to be configured appropriately for consecutive days. See Consecutive Day Settings in Pay Policy.
Example 1
In the rule below, employees will be paid double-time when they work over 48 hours in 7 consecutive days. The consecutive days do not have to be in the same pay week or pay period.
IF
Is Over Dynamic Consecutive Day Threshold( Cyclic, 7, 7, Weekly Overtime
Bucket Threshold, 48, Aggregate )
THEN
Set Hours Classification( Get Over Dynamic Consecutive Day Threshold( Cyclic,
7, 7, Weekly Overtime Bucket Threshold, 48, Aggregate ), D, False, False,
False )
The illustration below shows how the timecard would look after the rule was applied. The employee has a bi-weekly pay period and works every day in the period. The pay rules also calculated Weekly overtime after 40 hours. Because the rule is Cyclic, the 7 consecutive days are repeated.
Example 2
As with Example 1, employees will be paid double-time when they work over 48 hours in 7 consecutive days. However, the 7 consecutive days are strict and do not repeat.
IF
Is Over Dynamic Consecutive Day Threshold( Strict, 0, 7, Weekly Overtime
Bucket Threshold, 48, Aggregate )
THEN
Set Hours Classification( Get Over Dynamic Consecutive Day Threshold( Strict,
0, 7, Weekly Overtime Bucket Threshold, 48, Aggregate ), D, False, False,
False )
The illustration below shows how the timecard would look after the rule was applied. The employee has a bi-weekly pay period and works every day in the period. The pay rules also calculated Weekly overtime after 40 hours. Because the rule is Strict, the 7 consecutive days are not repeated.
Example 3:
Employees will be paid double-time for the entire third day if they work 3 consecutive days in a row over a 5-day cycle.
IF
Is Dynamic Consecutive Day( Cyclic, 5, 3 )
THEN
Set Hours Classification( Get Remaining Duration( ), D, False, False, False
)
The illustration below shows how the timecard would look after the rule was applied. The employee has a bi-weekly pay period and works every day in the period. No hours were posted on 6/29. On 7/02, the employee has worked 3 consecutive days and therefore receives double-time for that day. The Cycle Size is 5 days, so the cycle ends on 7/04 and a new cycle begins on 7/05. On 7/07, the employee has worked 3 consecutive days in the new cycle, and so that entire day also receives double-time. Because the employee did not work on 7/08, the 5 day cycle is broken. A new cycle begins on 7/09 and on 7/11, the employee has again worked 3 consecutive days and receives double-time.
If you are using Consecutive Day pay rules, you need to configure some settings in your Pay Policy.
Gap Day Minimum, Gap Day Min Amt
The Gap Day Minimum and Gap Day Min Amt fields in the Pay Policy specify the minimum amount of time that must be posted (for the Events and/or Hours Classes with the Consecutive Days context) in order to make a day count as a gap day. These settings are used by the following Consecutive Day operands in your Pay Rules: Get Consecutive Gap Days Hours Over, Is Consecutive All Gap Days, Is Consecutive Days, Is Consecutive Gap Days, and Is Consecutive Gap Days Hours Over.
Sch Day Minimum, Sch Day Min Amt
The Sch Day Minimum and Sch Day Min Amt fields in the Pay Policy specify the minimum amount of time that must be posted (for the Events and/or Hours Classes with the Consecutive Days context) in order to make a day count as a scheduled day. These settings are used by the following Consecutive Day operands in your Pay Rules: Is Consecutive Days, Is Consecutive Schedule Days, and Is Consecutive Days With Schedule Cycle.
Events and Hours Class Settings in the Pay Policy
You will need to define which events and hours classifications can be included when determining consecutive days using the Events and Hours Class tabs on the Pay Policy form.
On the Events tab, add the events that should be counted when determining whether a day is a consecutive day. Use the Context Name Consecutive Days. By default, all LABOR events are counted toward Consecutive Days unless you exclude them. Also by default, all ATTENDANCE events are excluded (not counted) toward Consecutive Days unless you include them.
On the Hours Class tab, add the hours classifications that should be counted when determining whether a day is a consecutive day. Use the Context Name Consecutive Days.
The Posting Marking setting in the Recalculation Policy determines which days in the week or period will be marked as needing recalculation when an event posting (add, delete, modify, and so on) occurs.
If you are using Consecutive Day Rules, you may want to use the Day and Forward setting to ensure the consecutive days are processed correctly. When you set Posting Marking to Day and Forward, the day with the event posting and all days up to the current date will be marked as needing recalculation. If you set Posting Marking to Day Only (or leave the field blank), then only the day with the event posting will be marked as needing recalculation.