Skip to main content

Pay rule calculation type - Consecutive days worked

Chris Knight
  • Updated

This article discusses the Consecutive days worked pay rule calculations as part of Deputy's Pay Rate Builder.

Before you begin, please read about adding and editing pay rule calculations

 

Description

The Consecutive days worked pay rule triggers for all time worked beyond a certain number of hours in a defined workday.

IMPORTANT: Deputy requires the business recalculation setting to be turned on for this calculation type to work correctly. Please read Recalculating approved timesheets.

 

Example use case

A team member has an agreement that they should be paid a higher rate if they work for 7 consecutive days in a work week. In addition, this rate should be even higher if they work more than 8 hours on that day.

In this example, the first rule would have a Rule Threshold of 0 and a Consecutive Days Worked Threshold of 7, while to facilitate the higher rate for more than 8 hours in a day the Rule Threshold should be set to 8.

 

Supported rule types

This rule is only available as a base rate. Each minute of a timesheet is assigned a base rate to fill it, depending on whether it meets the rules criteria and the priority of these rules.

 

Outputs

Base Rates are only available as hourly. It will return the number of hours of the shift that has exceeded the limit, minus any hours from the Rule Threshold.

 

Configurable parameters (standard)

These are the standard fields you can configure in the Consecutive days worked pay rule calculation

Name Defines the name of the pay rule
Consecutive days worked

The amount of consecutive days a team member must work for this to trigger.

For example, if you want this to trigger on the 7th consecutive day of work, enter 7.

This only applies to days in the same work week.
Rule Threshold

Defines the minimum amount of hours required in the shift for it to trigger.

For example, the shift must be greater than 4 hours long to trigger.
Pay rate

Can be configured as a multiple of the employee’s base rate or as a flat rate:

  • When configured as a multiplier, this pay rate will pay in hours at the employee’s base rate multiplied by the input value.

  • When configured as a flat rate, the user can choose if they would like Hourly or Unit Values:

    • An Hourly value will pay each calculated hour at the set value

    • A unit value will pay each unit at the set value (not available for base pay rules)
Export code Defines if this pay rule should be exported to payroll. If yes, they can also define a code for the rule.
Days of the week this calculation applies

Defines which days of the week this rule applies to.

For example, if Saturday and Sunday are selected, only parts of the timesheet overlapping Saturday and Sunday are calculated with this rule.
Time of the day this calculation applies

Defines which part of the day this rule is applicable to.

By default this is all day. However, it can be used to define a portion of a day (eg. a defined night shift, such as 6pm-6am). If this is done, only those parts of the timesheet overlapping this are calculated.
Public holiday

Select whether this pay rule applies:

  • Always applies (ie. applies whether the day is marked as a public holiday or not)
  • Applies only on days marked as public holiday
  • Does not apply on public holidays (ie. only applies on days not marked as public holidays)

 

Configurable parameters (advanced):

These are the advanced fields you can configure in the Consecutive days worked pay rule calculation

Apply pay rule to unscheduled shifts

Defines how the pay rule interacts with scheduled and unscheduled shifts:

  • If set to unscheduled, this rule will only trigger for unscheduled shifts.
  • If set to scheduled, this rule will only trigger on scheduled shifts.
  • If set to both, it will trigger on all shifts provided other conditions are met.
Pay portion rule

Generally, an hourly rate will be assigned according to the exact hours that are matched, however, it is possible to enforce an hourly rate for a full shift even if it only matches a minor or major portion of that shift.

Deputy recommends using the Exact Hours option in most cases.
Rate type

Categorises the pay rule as Overtime, Ordinary, Penalty or Non-Payable time.

These are used to define time worked for other calculation types (for example, Periodic Overtime counts Ordinary and some penalty hours towards it).
Rate tag

A custom value that can be applied to the timesheets.

Deputy recommends only using this if advised by your implementation consultant.
Areas

Will only apply this rule to areas selected in the drop down.

By default, all areas are selected.
Clock in and out requirements

For this rule to apply, the team member must clock in and clock out within the defined periods.

By default this is midnight to midnight (ie. any time is allowed.)
Custom Timesheet Fields

With this, the rule will only apply if particular values are selected in the custom timesheet field questions.

Note that only List and Boolean questions are available.

Read more at Creating custom timesheet fields for shift questions.
Custom Shift Fields:

This rule will only apply if particular values are selected in the custom shift fields in the schedule.

Note that only List and Boolean questions are available.

Read more at: Creating custom shift fields

Custom Employee Fields

(Enterprise Accounts Only)

This rule will only apply if particular values are selected in the employee’s custom fields (for example, job position).

Note that only List and Boolean fields are available. Read more about setting up employee fields.

This is an Enterprise plan only feature.

 

Related articles