Time

Calculation
Rule Fast
Formula
Reference
Guide
Oracle Fusion Time and Labor

WHITE PAPER / OCTOBER 30, 2019

DISCLAIMER
This document in any form, software or printed matter, contains proprietary information that is the
exclusive property of Oracle. Your access to and use of this confidential material is subject to the
terms and conditions of your Oracle software license and service agreement, which has been
executed and with which you agree to comply. This document and information contained herein may
not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written
consent of Oracle. This document isn’t part of your license agreement nor can it be incorporated into
any contractual agreement with Oracle or its subsidiaries or affiliates.

This document is for informational purposes only and is intended solely to assist you in planning for
the implementation and upgrade of the product features described. It isn’t a commitment to deliver
any material, code, or functionality, and shouldn’t be relied upon in making purchasing decisions.
The development, release, and timing of any features or functionality described in this document
remains at the sole discretion of Oracle.

Due to the nature of the product architecture, it may not be possible to safely include all features
described in this document without risking significant destabilization of the code.

2 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

TABLE OF CONTENTS

Disclaimer .................................................................................................... 2

Introduction .................................................................................................. 8

Formula Name:
ORA_WFM_TCR_ACCESS_ATTESTATION_ANSWERS_AP ................... 9

Description................................................................................................................................... 9

Parameters .................................................................................................................................. 9

Outputs ........................................................................................................................................ 9

Function ....................................................................................................................................... 9

Example .....................................................................................................................................10

Formula Name: ORA_WFM_TCR_ALLOCATION_TIME_AP ................... 11

Description..................................................................................................................................11

Parameters .................................................................................................................................11

Outputs .......................................................................................................................................11

Examples of Percentage Allocations ..........................................................................................12

Examples of Quantity Allocations ...............................................................................................14

Examples of Equally Distributed Allocations ...............................................................................19

Examples of Daily Overtime Calculations and Percentage Allocations ......................................21

Examples of Daily Overtime Calculations and Quantity Allocations ...........................................23

Formula Name:
ORA_WFM_TCR_FOR_ENTRIES_THAT_SPAN_DAYS_AP (deprecated)27

3 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Description..................................................................................................................................27

Parameters .................................................................................................................................27

Outputs .......................................................................................................................................27

Function ......................................................................................................................................28

Examples ....................................................................................................................................28

Formula Name:
ORA_WFM_TCR_OT_EARNED_DAYS_FOR_ENTRIES_THAT_SPAN_D
AYS ........................................................................................................... 31

Description..................................................................................................................................31

Parameters .................................................................................................................................31

Outputs .......................................................................................................................................32

Function ......................................................................................................................................32

Formula Name: ORA_WFM_TCR_UNIT_CALC_PAYTYPE_AP .............. 33

Description..................................................................................................................................33

Parameters .................................................................................................................................33

Outputs .......................................................................................................................................33

Function ......................................................................................................................................33

Example .....................................................................................................................................34

Formula Name: ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP........ 35

Description..................................................................................................................................35

Parameters .................................................................................................................................35

4 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Outputs .......................................................................................................................................35

Function ......................................................................................................................................35

Example .....................................................................................................................................36

Formula Name: ORA_WFM_TCR_UNIT_CALC_WEEKEND_AP ............. 37

Description..................................................................................................................................37

Parameters .................................................................................................................................37

Outputs .......................................................................................................................................38

Function ......................................................................................................................................38

Examples of WORK_ANY_WEEKEND_DAY is Yes ..................................................................38

Examples of WORK_ANY_WEEKEND_DAY is No ....................................................................39

Formula Name:
WFM_TCR_INSUFFICIENT_REST_PERIOD_PREMIUM_AP ................. 41

Description..................................................................................................................................41

Parameters .................................................................................................................................41

Outputs .......................................................................................................................................41

Examples ....................................................................................................................................42

Formula Name: WFM_SHIFT_PREMIUM_CALCULATION ...................... 43

Description..................................................................................................................................43

Parameters .................................................................................................................................43

Outputs .......................................................................................................................................43

5 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Function ......................................................................................................................................43

Examples ....................................................................................................................................44

Formula Name: WFM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP .... 45

Description..................................................................................................................................45

Parameters .................................................................................................................................45

Outputs .......................................................................................................................................45

Function ......................................................................................................................................45

Example .....................................................................................................................................46

Formula Name: WFM_TCR_THRESHOLD_TWO_TIER_SEVEN_DAY_AP47

Description..................................................................................................................................47

Parameters .................................................................................................................................47

Outputs .......................................................................................................................................47

Function ......................................................................................................................................47

Examples ....................................................................................................................................48

Formula Name: WFM_THRESHOLD_TIME_CALCULATION_RULE ....... 54

Description..................................................................................................................................54

Parameters .................................................................................................................................54

Outputs .......................................................................................................................................54

Function ......................................................................................................................................54

Examples ....................................................................................................................................55

6 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Formula Name: WFM_THRESHOLD_TIME_CALCULATION_RULE_AP . 58

Description..................................................................................................................................58

Parameters .................................................................................................................................58

Outputs .......................................................................................................................................58

Function ......................................................................................................................................58

Examples ....................................................................................................................................59

Formula Name:
WFM_THRESHOLD_W_ABS_TIME_CALCULATION_RULE_AP ............ 62

Description..................................................................................................................................62

Parameters .................................................................................................................................62

Outputs .......................................................................................................................................62

Function ......................................................................................................................................62

Examples ....................................................................................................................................63

Formula Name: WFM_VARIABLE_DAY_START_TIME_CALCULATION 64

Description..................................................................................................................................64

Parameters .................................................................................................................................64

Outputs .......................................................................................................................................64

Function ......................................................................................................................................64

Examples ....................................................................................................................................65

7 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

INTRODUCTION

Oracle Fusion Fast Formula Cloud Services is an easy way to configure the existing
functionality in Oracle Fusion Time and Labor Cloud Services. Formulas are pieces of code that
can receive information from calling program (packages), access database information, and
return values to the calling program. The calling program can use this information to modify the
process functionality. The formula language hides the complexity of accessing the tables and
columns.

A formula can return more than one value to the calling program. Different programs that call
the formula expect outputs to return differently. The formula type determines the number and
data type of the values to return.

• Some programs expect the defined names for outputs. In this case, if the formula doesn't use
these expected names, the process errors out at run time. The location of an expected name
in the return statement doesn’t matter.

• Some programs expect the output to return by location. In this case, if the formula doesn't find
the output in the expected location, the process errors out at run time. The name of the output
doesn’t matter.

Time calculation rule formulas create or update time card entries and use the data to create
calculated results based on formula logic. For example, you can handle overtime or premium
pay by updating reported time or creating additional calculated time.

8 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_ACCESS_A TTESTATION_ANSW ERS_AP

Description
This fast formula checks the specified attestation to see if the person submitted an answer that requires the formula to generate
an additional time entry. For example, generate a penalty when the person didn’t take a meal break for business reasons. This
formula uses an array to process time card data. It isn't associated with any delivered time calculation rule templates.

Initial release: 13.19.10

Parameters

ORA_WFM_TCR_ACCESS_ATTESTATION_ANSWERS_AP Parameter Info

NAME TYPE DESCRIPTION

QUESTION_CODE Fixed text Code of the question asked in the attestation.

ANSWER_CODE Fixed number Code of the answer that the worker submitted in the attestation.

GENERATED_QUANTITY Fixed number Quantity of the time entry that the formula generates.

Outputs

ORA_WFM_TCR_ACCESS_ATTESTATION_ANSWERS_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

GRP1_MEASURE 1 Measure Original quantity

GRP1_START_TIME 1 StartTime Original start time

GRP1_STOP_TIME 1 StopTime Original start time

GRP2_QUANTITY 2 Measure Quantity, in hours or units, of the time entry that the
formula generates according to the answer code.

Function
If the question code is equal to the specified value of the Question code parameter and the answer code is equal to the specified
value of the Answer code parameter, then generate a time entry with the specified quantity.

9 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example
The person has an attestation set that includes a meal break attestation. The attestation time category from this attestation set
helps identify a clock out more than 5 hours after the previous clock in. Because the elapsed duration is more than 5 hours, the
meal break attestation appears. When the worker confirms they didn’t take a meal break, they're asked why--personal or business
reasons? If it was for business reasons, the formula generates the specified payroll time entry.

From Web Clock Events to Attestations

DAY WEB CLOCK TIME ENTRY ELAPSED DURATION MEAL ATTESTATION GENERATED
EVENTS BETWEEN IN AND OUT BREAK TIME ENTRY

1 In: 8:02a 8:02a – 1:01p 4h 59m 0 None because the elapsed None
Out: 1:01p duration is less than 5h.

2 In: 8:03a 8:03a – 1:58p 5h 55m 0 A question about the meal 1 penalty
Out: 1:58p break appears because the
elapsed duration is more than The payroll
5h. The person answers that time type is
they didn't take their meal measure in
break for business reasons. Units.

3 In: 8:01a 8:01a -- 8:01a -- 0 None because the person

didn't clock out, and it's this
action that causes the
attestation to appear.

4 In: 8:03a 8:03a – 1:58p 8:03a – 1:58p 0 A question about the meal None
Out: 1:58p break appears because the
elapsed duration is more than
5h. The person answers that
they did take their meal break.
They need to report it or ask
their manager to do so.

5 In: 7:58a 7:58a – 1:58p 6h 00m 0 A question about the meal None
Out: 1:58p break appears because the
elapsed duration is more than
5h. The person answers that
they didn't take their meal
break for personal reasons.

10 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_ALLOCATION_TIME_AP

Description
This fast formula is associated with the delivered rule template Time Allocation Template. If the person has a time allocation
assigned by the Manage Allocation Assignments task, then the formula uses this allocation. Otherwise, it uses the allocation
selected in the rule configuration. In both cases, the allocation formula uses either reported or calculated time, depending on the
processing sequence of the allocation rule in the rule set. The formula allocates the time identified by the source time category
across the output time attributes. This formula uses an array to process time data.

If you want the review page of the time card to show the cost segment outputs configured in the time allocation, complete these
tasks:

1. Configure the time review layouts for workers and managers accordingly.

2. Associate the appropriate layout set with the worker time entry profiles.

Initial release: 13.17.05

Parameters

ORA_WFM_TCR_ALLOCATION_TIME_AP Parameter Info

NAME TYPE DESCRIPTION

ASSIGN_FRACTION_TO_LAST_ROW Yes or No Indicates whether to adjust the last row of the time allocation
output so that total allocated hours match the number of hours
identified by the allocation rule. The time allocations that use
this parameter have either the type Percent or Equally.

Outputs
This formula has no output variables. It uses the outputs configured for the time allocation assigned to the person when the rule
runs.

11 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples of Percentage Allocations
Allocation configuration: These next two allocation examples distribute 50 percent of reported regular time to Cardiac Care and
the other 50 percent to Intensive Care.

Example 1: The reported time doesn't include any conflicts with the person's assigned allocation.

No Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARMENT REPORTED CALCULATED

TIME TIME TIME

Mon -- Fri Regular 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily totals
Regular 8h
Regular | Cardiac Care 4h
Regular | Intensive Care 4h

Weekly Totals
Regular 40h
Regular | Cardiac Care 20h
Regular | Intensive Care 20h
40h

12 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: The reported time includes conflicts with the person's assigned allocation.

Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 2p

Cardiac Care 3h
Intensive Care 3h

On-Call Intensive Care 2p – 4p 2h

Daily Total: 8h 8h

Tue Regular N/A 8a – 12p

Cardiac Care 2h
Intensive Care 2h

Regular Emergency 1p – 5p 4h

Daily Total: 8h 8h

Wed Regular N/A 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily Total: 8h 8h

Thu Regular Emergency 8a – 4p 8h

Daily Total: 8h 8h

Fri Regular N/A 8a – 12p

Cardiac Care 2h
Intensive Care 2h

Daily Total: 4h 4h

Sat Regular Emergency 1p – 5p 4h

Daily Total: 4h 4h

Weekly Totals
Regular 22h
Regular | Cardiac Care 11h
Regular | Intensive Care 11h
On-Call | Intensive Care 2h 2h
Regular | Emergency 16h 16h
40h 40h

13 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples of Quantity Allocations
Allocation configuration: These next four allocation examples distribute the first 20 hours of reported regular time to Cardiac Care.
They distribute the next 20 hours to Intensive Care.

Example 1: The time card period total equals the defined allocation quantity.

Time Card Total Equals Allocation Quantity

DAY WORKED DEPARMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Tue Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Wed Regular N/A 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily Total: 8h 8h

Thu Regular N/A 8a – 4p

Intensive Care 8h

Daily Total: 8h 8h

Fri Regular N/A 8a – 4p

Intensive Care 8h

Daily Total: 8h 8h

Weekly Totals
Regular 40h
Regular | Cardiac Care 20h
Regular | Intensive Care 20h
40h

14 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: The time card period total is less than the defined allocation quantity.

Time Card Total Is Less Than Allocation Quantity

DAY WORKED DEPARMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 12p

Cardiac Care 4h

Daily Total: 4h 4h

Tue Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Wed Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Thu Regular N/A 8a – 4p

Intensive Care 8h

Daily Total: 8h 8h

Fri Regular N/A 1p – 5p

Intensive Care 4h

Daily Total: 4h 4h

Weekly Totals
Regular 32h
Regular | Cardiac Care 20h
Regular | Intensive Care 12h
32h

15 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 3: The time card period total is more than the defined allocation quantity.

Time Card Total Is More Than Allocation Quantity

DAY WORKED DEPARMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/a 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Tue Regular N/A 8a – 6p

Cardiac Care 10h

Daily Total: 10h 10h

Wed Regular N/A 8a – 4p

Cardiac Care 2h
Intensive Care 6h

Daily Total: 8h 8h

Thu Regular N/A 8a – 4p

Intensive Care 8h

Daily Total: 8h 8h

Fri Regular N/A 8a – 4p 2h

Intensive Care 6h

Daily Total: 8h 8h

Sat Regular 8a – 4p 8h

Daily Total: 8h 8h

Weekly Totals
Regular 50h 10h
Regular | Cardiac Care 20h
Regular | Intensive Care 20h
50h

16 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 4: The time card period total is more than the defined allocation quantity. Also, the reported time includes conflicts with
the person's assigned allocation.

Time Card Total Is More Than Allocation Quantity, Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 2p

Cardiac Care 6h

On-Call Intensive Care 2p – 4p 2h

Daily Total: 8h 8h

Tue Regular N/A 8a – 12p

Cardiac Care 4h

Regular Emergency 1p – 5p 4h

Daily Total: 8h 8h

Wed Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Thu Regular Emergency 8a – 4p 8h

Daily Total: 8h 8h

Fri Regular N/A 8a – 12p

Cardiac Care 2h
Intensive Care 2h

On-Call Intensive Care 1p – 5p 4h

Daily Total: 8h 8h

Sat Regular N/A 8a – 12p

Intensive Care 4h

Daily Total: 4h 4h

Sun Regular Emergency 8a – 12p 4h

Daily Total: 4h 4h

Weekly Totals
Regular 26h
Regular | Cardiac Care 20h
Regular | Intensive Care 6h
On-Call | Intensive Care 6h 6h
Regular | Emergency 16h 16h
48h 48h

17 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Allocation configuration: This allocation example distributes reported regular time as shown here. Also, the reported time includes
conflicts with the person's assigned allocation.

Distribution of Reported Regular Time

PRIORITY ALLOCATION TYPE: QUANTITY DEPARTMENT

5 20 Cardiac Care

10 20 Intensive Care

15 Balance Operation

Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 4p

Cardiac Care 8h

Daily Total: 8h 8h

Tue Regular N/A 8a – 4p

Cardiac Care 8h

Regular Emergency 1p – 5p 4h

Daily Total: 12h 12h

Wed Regular N/A 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily Total: 8h 8h

Thu Regular N/A 8a – 4p

Intensive Care 6h
Operation 2h

Regular Emergency 8a – 4p 8h

Daily Total: 16h 16h

Fri Regular N/A 8a – 12p

Operation 4h

Daily Total: 4h 4h

Sat On-Call Emergency 8a – 12p 4h

Daily Total: 4h 8h

Sun Regular Emergency 8a – 4p 8h

Daily Total: 8h 8h

18 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Weekly Totals
Regular 36h
Regular Cardiac Care 20h
Regular Intensive Care 10h
Regular Operation 6h
Regular Emergency 20h 20h
On-Call Emergency 4h 4h
60h 60h

Examples of Equally Distributed Allocations

Allocation configuration: These next two allocation examples distribute reported regular time equally across these departments:
Cardiac Care, Intensive Care, and Emergency.

Example 1: The reported time doesn't include any conflicts with the person's assigned allocation.

No Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon -- Fri Regular N/A 8a – 4p

Cardiac Care 2.66h
Intensive Care 2.66h
Emergency 2.66h

Daily Totals
Regular 8h
Regular Cardiac Care 2.66h
Regular Intensive Care 2.66h
Regular Emergency 2.66h

Weekly Totals
Regular 40h
Regular Cardiac Care 13.3h
Regular Intensive Care 13.3h
Regular Emergency 13.3h
39.9h

19 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: The reported time includes conflicts with the person's assigned allocation.

Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 2p

Cardiac Care 2h
Intensive Care 2h
Emergency 2h

On-Call Intensive Care 2p – 4p 2h

Daily Total: 8h 8h

Tue Regular N/A 8a – 12p

Cardiac Care 1.33h
Intensive Care 1.33h
Emergency 1.33h

Regular Emergency 1p – 5p 4h

Daily Total: 8h 7.99h

Wed Regular N/A 8a – 4p

Cardiac Care 2.66h
Intensive Care 2.66h
Emergency 2.66h

Daily Total: 8h 7.98h

Thu Regular Emergency 8a – 4p 8h

Daily Total: 8h 8h

Fri Regular N/A 8a – 12p

Cardiac Care 1.33h
Intensive Care 1.33h
Emergency 1.33h

Daily Total: 4h 3.99h

Sat On-Call Intensive Care 1p – 5p 4h

Daily Total: 4h 8h

Weekly Totals
Regular 22h
Regular | Cardiac Care 7.32h
Regular | Intensive Care 7.32h
Regular | Emergency 12h 19.32h
On-Call | Intensive Care 6h 6.00h
40h 39.96h

20 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples of Daily Overtime Calculations and Percentage Allocations
Allocation configuration: These next two allocation examples distribute 50 percent of the reported and calculated time to Cardiac
Care and the other 50 percent to Intensive Care.

Example 1: The reported time doesn't include any conflicts with the person's assigned allocation.

No Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 8a – 6p

Cardiac Care 4h
Intensive Care 4h

Overtime Cardiac Care 1h

Intensive Care 1h

Daily Total: 10h 10h

Tue Regular N/A 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily Total: 8h 8h

Wed Regular N/A 8a – 4:30p

Cardiac Care 4h
Intensive Care 4h

Overtime Cardiac Care 0.25h

Intensive Care 0.25h

Daily Total: 8.5h 8.5h

Thu Regular N/A 8a – 4p

Cardiac Care 4h
Intensive Care 4h

Daily Total: 8h 8h

Fri Regular N/A 8a – 5p

Cardiac Care 4h
Intensive Care 4h

Overtime Cardiac Care 0.5h

Intensive Care 0.5h

Daily Total: 9h 9h

Weekly Totals
Regular 43.5h
Regular | Cardiac Care 20.00h
Regular | Intensive Care 20.00h
Overtime | Cardiac Care 1.75h
Overtime | Intensive Care 1.75h
43.5h

21 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: The reported time includes conflicts with the person's assigned allocation.

Conflicts Between Reported Time and Assigned Allocation

DAY WORKED DEPARTMENT REPORTED CALCULATED

TIME TIME TIME

Mon Regular N/A 7a – 12p

Cardiac Care 2.5h
Intensive Care 2.5h

Regular Emergency 1p – 4p 3h

On-Call Intensive Care 4p – 6p

Overtime Intensive Care 2h

Daily Total: 10h 10h

Tue Regular Emergency 8a – 5p 8h

Overtime Emergency 1h

Daily Total: 9h 9h

Wed On-Call Intensive Care 8a – 4:30p 8h

Overtime Intensive Care 0.5h

Daily Total: 8.5h 8.5h

Thu Regular N/A 8a – 5p

Cardiac Care 4h
Intensive Care 4h

Overtime Cardiac Care 0.5h

Intensive Care 0.5h

Daily Total: 9h 9h

Fri Regular N/A 8a – 5p

Cardiac Care 4h
Intensive Care 4h

Overtime Cardiac Care 0.5h

Intensive Care 0.5h

Daily Total: 9h 9h

Weekly Totals
Regular 23.0h
Regular | Cardiac Care 10.5h
Regular | Intensive Care 10.5h
Regular | Emergency 12.0h 11.0h
On-Call | Intensive Care 10.5h 8.0h
Overtime | Emergency 1.0h
Overtime | Cardiac Care 1.0h
Overtime | Intensive Care __ 3.5h
45.5h 45.5h

22 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples of Daily Overtime Calculations and Quantity Allocations
Allocation configuration: This allocation example distributes the first 20 hours of reported and calculated time to Cardiac Care.
They distributes the next 20 hours to Intensive care.

Example: The reported time includes conflicts with the person's assigned allocation. The time card period total is more than the
defined allocation quantity.

Conflicts Between Reported Time and Assigned Allocation, Time Card Total Is More Than Allocated Quantity

DAY WORKED DEPARTMENT REPORTED CALCULATED CALCULATED

TIME TIME TIME, NO DAILY OT TIME, DAILY OT

Mon Regular N/A 8a – 2p

Cardiac Care 6h 6h

On-Call Intensive Care 2p – 4p 2h 2h

Regular Emergency 4p – 6p 2h

Overtime Emergency 2h

Daily Total: 10h 10h 10h

Tue Regular N/A 8a – 12p

Cardiac Care 4h 4h

Regular Emergency 1p – 5p 4h 4h

Daily Total: 8h 8h 8h

Wed Regular N/A 7a – 12p

Cardiac Care 5h 5h

On-Call Intensive Care 1p – 4p 3h 3h

Regular Emergency 4p – 6p 2h

Overtime Emergency 2h

Daily Total: 10h 10h 10h

Thu Regular Emergency 8a – 4p 8h 8h

Daily Total: 8h 8h 8h

Fri Regular N/A 8a – 12p

Cardiac Care 4h 4h

On-Call Intensive Care 1p – 5p 4h 4h

Daily Total: 8h 8h 8h

Sat Regular N/A 8a – 12p

Cardiac Care 1h 1h
Intensive Care 3h 3h

Daily Total: 4h 4h 4h

23 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Sun Regular Emergency 8a – 12p 4h 4h

Daily Total: 4h 4h 4h

Weekly Total
Regular 23h
Regular | Cardiac Care 20h 20h
Regular | Intensive Care 3h 3h
Regular | Emergency 20h 20h 16h
On-Call | Intensive Care 9h 9h 9h
Overtime | Emergency __ __ 4h
52h 52h 52h

Allocation configuration: This allocation example distributes reported and calculated time as shown here:

Distribution of Reported and Calculated Time

PRIORITY ALLOCATION TYPE: QUANTITY DEPARTMENT

5 20 Cardiac Care

10 20 Intensive Care

15 Balance Operation

24 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example: The reported time includes conflicts with the person's assigned allocation.

Conflicts Between Reported Time and Assigned Allocation, Time Card Total Is Greater Than Allocated Quantity

DAY WORKED DEPARTMENT REPORTED CALCULATED CALCULATED

TIME TIME TIME, NO DAILY OT TIME, DAILY OT

Mon Regular N/A 8a – 6p

Cardiac Care 10h 8h

Overtime Cardiac Care 2h

Daily Total: 10h 10h 10h

Tue Regular N/A 7a – 4p

Cardiac Care 9h 8h

Overtime Cardiac Care 1h

Daily Total: 9h 9h 9h

Wed Regular N/A 8a – 4p

Cardiac Care 1h 1h
Intensive Care 7h 7h

Daily Total: 8h 8h 8h

Thu Regular N/A 8a – 4p

Intensive Care 3h 3h
Operation 5h 5h

On-Call Emergency 4p – 6p 2h

Overtime Emergency 2h

Daily Total: 10h 10h 10h

Fri Regular N/A 8a – 5p

Operation 9h 8h

Overtime Operation 1h

Daily Total: 9h 9h 9h

Sat On-Call Emergency 8a – 12p 4h 4h

Daily Total: 4h 4h 4h

Sun On-Call Emergency 8a – 4p 8h 8h

Daily Total: 8h 8h 8h

25 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

 Weekly Totals
Regular 44h
Regular | Cardiac Care 20h 17h
Regular | Intensive Care 10h 10h
Regular | Operation 14h 13h
On-Call | Emergency 14h 14h 12h
Overtime | Cardiac Care 3h
Overtime | Emergency 2h
Overtime | Operation __ __ 1h
58h 58h 58h

26 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_FOR_ENTRIES_THAT_SPAN_DAYS_AP (DEPRECATED)

Description
This fast formula is associated with the delivered rule template Time Entries That Span Days AP. It determines whether time
entries span days. If they do, the formula determines on what day to calculate time for those day-spanning entries. By default, the
formula uses rule parameter values. When the rule doesn't pass any values, the formula uses the values of the person's work day
definition. This formula uses an array to process time card data.

Initial release: 13.17.05

Deprecated release: 13.18.10

Parameters

ORA_WFM_TCR_FOR_ENTRIES_THAT_SPAN_DAYS_AP Parameter Info

NAME TYPE DESCRIPTION

RESOLVE_SPAN_RULE Fixed text Rule to use to determine on what day to calculate time for reported
time entries that span days. Valid values are:
 START_DAY: Time calculation rules should treat time entries as
being entirely on the start day.
 STOP_DAY: Time calculation rules should treat time entries as
being entirely on the stop day.
 DAY_WITH_MOST_TIME: Time calculation rules should treat
time entries as being entirely on the day with the longest time
duration.
 SPLIT_AT_DAY_START: Time calculation rules should split time
entries at the time where one day ends and the other starts.
 SCHEDULE_REF_DAY: Time calculation rules treat all time
entries as being on the reference day of the scheduled shift

HANDLING_TIES Fixed text Valid values are:

 START_DAY: When both days have the same duration, time
calculation rules should treat the time entries as being entirely on
the start day
 STOP_DAY: When both days have the same duration, time
calculation rules should treat the time entries as being entirely on
the stop day

DAY_START_TIME Time HH:MM Time, in hours and minutes, that marks the start of the day

GROUPING_THRESHOLD Fixed number Threshold, in minutes, used to group reported time entries on one or
another of the multiple days.

ORA_HWM_FF_DAY_SPLIT_FLAG Exclude Internal indicator to split the day. Doesn’t show on the rule pages.

Outputs
This formula has no output variables. It uses the outputs configured for the time allocation assigned to the worker when the rule
runs.

27 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Function
Specifies to resolve time entries that span days using the rule {RESOLVE_SPAN_RULE}. When the time entries span days
equally, use {HANDLING_TIES}. For this rule, the day start time is {DAY_START_TIME} and the threshold for grouping time
entries on one day or the other is {GROUPING_THRESHOLD} minutes.

Examples
Scenario: The work day starts at 4:00a.

Example 1: The spanning days rule is start day.

Spanning Rule: Start Day

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 8a – 12p 8a – 12p (today) 12h

12a – 8a (Day 2)

2 Regular 12a – 8a 12a – 8a (Day 3) 8h

3 Regular 12a – 8a 12p – 8p (today) 8h

12p – 8p

4 Regular 8a – 12p 8a – 12p (today) 12h

12a – 8a (Day 5)

5 Regular 12a – 8a 12a – 8a (Day 6) 8h

6 Regular 12a – 8a

Example 2: The spanning days rule is stop day.

Spanning Rule: Stop Day

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 8a – 12p 8a – 12p (today) 4h

2 Regular 12a – 8a 12a – 8a (today) 8h

3 Regular 12a – 8a 12a – 8a (today) 16h

12p – 8p 12p – 8p (today)

4 Regular 8a – 12p 8a – 12p (today) 4h

5 Regular 12a – 8a 12a – 8a (today) 8h

6 Regular 12a – 8a 12a – 8a (today) 8h

28 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 3: The spanning days rule is day with most time and the tie-handling rule is start day.

Spanning Rule: Day with Most Time, Tie-Handling: Start Day

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 8a – 12p 8a – 12p (today) 12h

12a – 8a (Day 2)

2 Regular 12a – 8a 12a – 8a (Day 3) 8h

3 Regular 12a – 8a 12p – 8p (today) 8h

12p – 8p

4 Regular 8a – 12p 8a – 12p (today) 12h

12a – 8a (Day 5)

5 Regular 12a – 8a 12a – 8a (Day 6) 8h

6 Regular 12a – 8a

Example 4: The spanning days rule is day with most time and the tie-handling rule is stop day.

Spanning Rule: Day with Most Time, Tie-Handling: Stop Day

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 8a – 12p 8a – 12p (today) 4h

2 Regular 12a – 8a 12a – 8a (today) 8h

3 Regular 12a – 8a 12a – 8a (today) 16h

12p – 8p 12p – 8p (today)

4 Regular 8a – 12p 8a – 12p (today) 4h

5 Regular 12a – 8a 12a – 8a (today) 8h

6 Regular 12a – 8a 12a – 8a (today) 8h

29 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 5: The spanning days rule splits at day start time.

Spanning Rule: Split at Day Start

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 8a – 12p 8a – 12p (today) 8h

12a – 4a (Day 2)

2 Regular 12a – 8a 4a – 8a (today) 7h

1a – 4a (Day 3)

3 Regular 1a – 9a 4a – 8a (today) 13h

12p – 8p 12p – 8p (today)

4 Regular 8a – 12p 8a – 12p (today) 8h

12a – 4a (Day 5)

5 Regular 12a – 8a 4a – 8a (today) 7.5h

12:30a – 4a (Day 6)

6 Regular 12:30a – 9a 4a – 9a (today) 5h

Example 6: The spanning days rule is the reference day of the scheduled shift.

Spanning Rule: Scheduled Shift Reference Day

SHIFT INFO DAY 1 DAY 2 DAY 3 DAY 4 DAY 5

Schedule 11p – 8a 11p – 8a 11p – 8a 11p – 8a 11p – 8a

Reference Day 2 3 4 5 6

DAY PAYROLL REPORTED CALCULATIONS CALCULATED

TIME TYPE TIME USE THIS TIME DAILY TOTAL

1 Regular 11p – 7a

2 Regular 11p – 6:30a 11p – 7a (Day 1) 8h

3 Regular 11:30p – 7:30a 11p – 6:30a (Day 2) 7.5h

4 Regular 11p – 7a 11:30p – 7:30a (Day 3) 8h

5 Regular 11:30p – 7a 11p – 7a (Day 4) 8h

6 Regular 11:30p – 7a (Day 5) 7.5h

30 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_OT_EARNED_DAYS_FOR_ENTRIES_THAT_SPAN_DAYS

Description
This fast formula is associated with the delivered rule template Time Entries That Span Overtime and Earned Days AP. It
determines whether time entries span days. If they do, the formula determines these days:

 The day to use in calculations that include reported time entries that span days

 The earned day for reported time entries that span days

By default, the formula uses rule parameter values. When the rule doesn't pass any values, the formula uses the values of the
person's work day definition. This formula uses an array to process time card data.

Initial release: 13.18.10

Parameters

ORA_WFM_TCR_OT_EARNED_DAYS_FOR_ENTRIES_THAT_SPAN_DAYS Parameter Info

NAME TYPE DESCRIPTION

OVERTIME_DAY_START_TIME Time HH:MM Time, in hours and minutes, that marks the start of the day to use in
time calculation rules that calculate overtime.

EARNED_RESOLVE_SPAN_RULE Fixed text Rule to use to determine the earned day for reported time entries
that span days. Valid values are:
 START_DAY: Time calculation rules should treat time entries as
being entirely on the start day.
 STOP_DAY: Time calculation rules should treat time entries as
being entirely on the stop day.
 DAY_WITH_MOST_TIME: Time calculation rules should treat
time entries as being entirely on the day with the longest time
duration.
 SPLIT_AT_DAY_START: Time calculation rules should split time
entries at the time where one day ends and the other starts.
 SCHEDULE_REF_DAY: Time calculation rules treat all time
entries as being on the reference day of the scheduled shift

EARNED_HANDLING_TIES Fixed text Valid values are:

 START_DAY: When both days have the same duration, time
calculation rules should treat the time entries as being entirely on
the start day
 STOP_DAY: When both days have the same duration, time
calculation rules should treat the time entries as being entirely on
the stop day

EARNED_GROUPING_THRESHOLD Fixed number Threshold, in minutes, used to group reported time entries on one or
another of the multiple days.

ORA_HWM_FF_DAY_BREAKER_FLAG Exclude Internal indicator to split the day. Doesn’t show on the rule pages.

31 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Outputs
This formula has no outputs shown on the rule template or rule.

Function
The function specifies to resolve time entries that span days using the rule {EARNED_RESOLVE_SPAN_RULE} for earned day.
It automatically uses the rule SPLIT_AT_DAY_START for overtime. When determining the earned day, when the time entries
span days equally, use {EARNED_HANDLING_TIES}. For this rule, the day start time is midnight and the threshold for grouping
time entries on one day or the other is {EARNED_GROUPING_THRESHOLD} minutes. When determining the overtime day, the
day start time is {OVERTIME_DAY_START_TIME}.

32 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_UNIT_CALC_PAYTYPE_AP

Description
This fast formula determines unit quantities for reported time based on specific time attributes. It generates a unit time attribute for
the day, if the reported time category hours on that day include the specified time attributes. This formula uses an array to
process time card data. It isn't associated with any delivered time calculation rule templates.

Initial release: 13.17.05

Parameters

ORA_WFM_TCR_UNIT_CALC_PAYTYPE_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category of reported hours that include the specified
time attributes used to determine whether to generate a units
time attribute.

NUMBER_OF_UNITS Fixed number Numeric value for the number of units with UN unit of
measure to allocate for each detail found.

Outputs

ORA_WFM_TCR_UNIT_CALC_PAYTYPE_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

CALC_START_TIME 1 StartTime Original start time

CALC_STOP_TIME 1 StopTime Original stop time

MEASURE_UNITS 2 Measure Number of units

UOM_UNITS 2 UnitOfMeasure UN unit of measure

RATE_AMOUNT 2 Rate_Amount Sets the rate amount to Null

PERIODICITY 2 Periodicity Sets the periodicity of the rate amount to Null

UNITS_PAYTYPE 2 PayrollTimeType Payroll time type to associate with the units

Note that for start and stop times, the formula resets the rate amount and periodicity values in the generated units time entry to
empty values.

Function
For each detail time card record found, depending on the time category, add the number of units specified in
NUMBER_OF_UNITS to the time card. The unit amount is 'UN' (Units).

33 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example
When the person breaks for a meal, they’re paid a meal allowance if the time category identifies the Meal payroll time type.

Meal Allowance Example

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 4 Regular 8a – 12p 4h
1p – 4p 3h

Meal 12p – 1p 1h

Meal Allowance 1 unit

5 Regular 8a – 12p 4

34 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP

Description
This fast formula determines unit quantities for reported time that spans a specific time range. It generates a unit time attribute for
the day, if the reported time category hours span the specified range. This formula uses an array to process time card data. It isn't
associated with any delivered time calculation rule templates.

Initial release: 13.17.05

Parameters

ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category of reported hours that include the
specified time attributes used to determine whether to
generate a units time attribute.

NUMBER_OF_UNITS Fixed number Numeric value for the number of units with UN unit of
measure to allocate for each detail found.

START_TIME_HHMM24 Time HH:MM Start of time range to allocate units for.

STOP_TIME_HHMM24 Time HH:MM End of time range to allocate units for.

Both start and stop time parameters must have a value in every rule associated with this formula. These parameters indicate to
generate the specified unit of measure, if reported time during that range included time entries identified by the specified time
category.

Outputs

ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

CALC_START_TIME 1 StartTime Original start time

CALC_STOP_TIME 1 StopTime Original stop time

MEASURE_UNITS 2 Measure Number of units

UOM_UNITS 2 UnitOfMeasure UN unit of measure

RATE_AMOUNT 2 Rate_Amount Sets the rate amount to Null

PERIODICITY 2 Periodicity Sets the periodicity of the rate amount to Null

UNITS_PAYTYPE 2 PayrollTimeType Payroll time type to associate with the units

Function
For each detail time card record found, depending on the time category, if the time card start time is between
START_TIME_HHMM24 and STOP_TIME_HHMM24, add the number of units specified in NUMBER_OF_UNITS to the time
card. The unit amount is 'UN' (Units).

35 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example
When the person works from 6:00 PM to midnight, they receive a night shift stipend.

Night Shift Stipend Example

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 Regular 10a – 5p 8h

2 Regular 8p –11p 3h

Night Shift Stipend 1 unit

3 Regular 10a – 5p 8h

4 Regular 8p – 11p 8h

Night Shift Stipend 1 unit

5 Regular 10a – 5p 8h

36 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: ORA_WFM_TCR_UNIT_CALC_W EEKEND_AP

Description
This fast formula determines unit quantity for reported weekend time. It generates a unit time attribute for the day if the reported
time category hours occur on a weekend day. This formula uses an array to process time card data. It isn't associated with any
delivered time calculation rule templates.

Initial release: 13.17.05

Parameters

ORA_WFM_TCR_UNIT_CALC_WEEKEND_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category of reported hours that include the
specified time attributes used to determine whether
to generate a units time attribute.

NUMBER_OF_UNITS Fixed number Numeric value for the number of units with UN unit
of measure to allocate for each detail found.

WORK_ANY_WEEKEND_DAY Yes or No If Yes, generate the number of units when the

person associated with a rule using this formula
works any day defined as weekend day.

If No, generate the number of units only when the

person associated with a rule using this formula
works all days defined as weekend days.

IS_MON_WEEKEND Yes or No Indicate if Monday is a weekend day.

IS_TUE_WEEKEND Yes or No Indicate if Tuesday is a weekend day.

IS_WED_WEEKEND Yes or No Indicate if Wednesday is a weekend day.

IS_THU_WEEKEND Yes or No Indicate if Thursday is a weekend day.

IS_FRI_WEEKEND Yes or No Indicate if Friday is a weekend day.

IS_SAT_WEEKEND Yes or No Indicate if Saturday is a weekend day.

IS_SUN_WEEKEND Yes or No Indicate if Sunday is a weekend day.

37 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Outputs

ORA_WFM_TCR_UNIT_CALC_WEEKEND_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

CALC_START_TIME 1 StartTime Original start time

CALC_STOP_TIME 1 StopTime Original stop time

MEASURE_UNITS 2 Measure Number of units

UOM_UNITS 2 UnitOfMeasure UN unit of measure

RATE_AMOUNT 2 Rate_Amount Sets the rate amount to Null

PERIODICITY 2 Periodicity Sets the periodicity of the rate amount to Null

UNITS_PAYTYPE 2 PayrollTimeType Payroll time type to associate with the units

Function
For each detail time card record found, depending on the time category, if the function finds any time entry for days specified as
weekend day (IS_MON_WEEKEND…), select WORK_ANY_WEEKEND_DAY.

WORK_ANY_WEEKEND_DAY WHAT HAPPENS

SETTING

Yes Add the number of units specified in NUMBER_OF_UNITS to the time card
with a unit amount of UN (Units). It doesn't matter if the person worked only
one or every day defined as a weekend day.

No Add the number of units specified in NUMBER_OF_UNITS to the time card

with a unit amount of UN (Units), only if the person worked every day defined
as weekend days.

Examples of WORK_ANY_WEEKEND_DAY is Yes

For these examples, the weekend days are Saturday and Sunday.

Example 1: WORK_ANY_WEEKEND_DAY Is Yes

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Wed Regular 8h 8h

Thu Regular 8h 8h

Fri Regular 8h 8h

Sat Regular 2h 2h

Sun Regular 9h 9h

Weekend Allowance 1 unit

38 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: WORK_ANY_WEEKEND_DAY Is Yes

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Wed Regular 8h 8h

Thu Regular 8h 8h

Fri Regular 8h 8h

Sat Regular 2h 2h

Weekend Allowance 1 unit

Example 3: WORK_ANY_WEEKEND_DAY Is Yes

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Wed Regular 8h 8h

Thu Regular 8h 8h

Fri Regular 8h 8h

Sun Regular 9h 9h

Weekend Allowance 1 unit

Examples of WORK_ANY_WEEKEND_DAY is No
For these examples, the weekend days are Saturday and Sunday.

Example 1: WORK_ANY_WEEKEND_DAY Is No

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Wed Regular 8h 8h

Thu Regular 8h 8h

Fri Regular 8h 8h

Sat Regular 2h 2h

39 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 2: WORK_ANY_WEEKEND_DAY Is No

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Wed Regular 8h 8h

Thu Regular 8h 8h

Fri Regular 8h 8h

Sun Regular 9h 9h

40 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_TCR_INSUFFICIENT_REST_PERIOD_PREMIUM_AP

Description
This fast formula is associated with the delivered rule template Insufficient Rest Premium Template. It compares the end and start
times of consecutive reported time entries identified by the time category of the rest period. If the interim time is less than the
defined rest period, it generates an additional, premium time entry. The premium entry is for either all of the reported hours for the
second shift or only the reported hours until the rest period is met. This formula uses an array processing formula.

Initial release: 11.1

Parameters

WFM_TCR_INSUFFICIENT_REST_PERIOD_PREMIUM_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category that identifies the time entries
to use to determine whether the minimum
rest period was met for the two shifts

REST_PERIOD_IN_MINUTES Fixed number Minimum nonworked time, in minutes,

required between consecutive time entries

IS_ENTIRE_SHIFT_PREMIUM Yes or No Specify whether to pay all of the reported

hours for the second shift at the premium
rate or only those hours reported in the
second shift before the rest period is met

Outputs

WFM_TCR_INSUFFICIENT_REST_PERIOD_PREMIUM_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

MEASURE_UNDER 1 Measure Calculated nonpremium hours,

which are outside the rest period

MEASURE_OVER 2 Measure Calculated premium hours, which

are within the rest period

41 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: The interim time between the end time on Monday with the start time on Tuesday (6 hours) is less than the minimum
rest period of 8 hours.

Example 1: You pay a premium for the entire shift.

Premium Pay for Entire Shift

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 11a – 10p 11h

Tue Regular 4a – 10a

Premium 6h

Example 2: You pay a premium for only the time worked in the second shift until the rest period is met.

Premium Pay in Second Shift Until Rest Period Met

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 11a – 10p 11h

Tue Regular 4a – 10a 4h

Premium 2h

42 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_SHIFT_PREMIUM_CALCULATION

Description
This fast formula is associated with the delivered rule template Shift Premium Template. It compares the total hours identified by
the time category for the day or period with the threshold value. It converts hours over the threshold to a single payroll time type. It
leaves hours under the threshold as the same payroll time type or converts them to a new, single payroll time type.

Initial release: 9.1

Parameters

WFM_SHIFT_PREMIUM_CALCULATION Parameter Info

NAME TYPE DESCRIPTION

PREM_START_TIME Time HH:MM Start time of the premium shift in a 24-hour format,
such as 18:00 instead of 6:00p

PREM_STOP_TIME Time HH:MM End time of the premium shift in a 24-hour format,
such as 23:30 instead of 11:30p

WORKED_TIME_CONDITION Time category Time category that identifies the time entries to use
to determine the hours that qualify for premium pay

Outputs

WFM_SHIFT_PREMIUM_CALCULATION Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

OUT_MEASURE_UNDER 1 Measure Calculated based hours

OUT_MEASURE_OVER 2 Measure Calculated premium hours

Function
Compares the start and end time for the detailed entries identified by the time category that are within the defined time range.
Time entries that fall within the defined time range get an additional time attribute. This formula requires start and end time
entries. The calculation splits hours entries that span midnight and the calculated hours appear separately on each day. The
summation level is set to Detailed.

43 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type. You create a rule with your template where
the premium shift starts at 6:00 PM, ends at 12:00 AM, with a time category of All Payroll Time Types.

Example1: The person doesn't work any evening hours, so doesn't qualify for the shift premium

No Evening Hours, No Shift Premium

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 8a – 4p 8h

Tue Regular 8a – 4p 8h

Wed Regular 8a – 4p 8h

Thu Regular 8a – 4p 8h

Fri Regular 8a – 4p 8h

Example 2: The person works evening hours that qualify for the shift premium.

Evening Hours and Shift Premium

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 4p – 12a 8h

Premium 6h

Tue Regular 2p – 10p 8h

Premium 4h

Wed Regular 10a – 6p 8h

Thu

Fri Regular 9p – 5a 8h

Premium 3h

44 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP

Description
This fast formula compares the reported time with a specific category of public holidays attached to the person's assigned
schedule. If the reported time is on a qualifying holiday, then the person gets a holiday premium payroll time type. This template
uses an array processing formula. It isn't associated with any delivered time calculation rule templates.

If the person should also receive a premium for hours worked over some defined threshold value, you must use a separate
threshold premium rule.

Initial release: 11.1

Parameters

WFM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category that identifies the time entries to compare
with the public holiday category of entries associated with
the person's schedule

OVRD_PUB_HOLIDAY_CATEGORY Value set Category of public holiday entries associated with the
person's schedule to compare with the time entries identified
by the specified time category

Outputs

WFM_TCR_HOLIDAY_THRESHOLD_PREMIUM_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

OUT_MEASURE_ARY_UNDER 1 Measure Calculated hours that aren't on a public holiday

OUT_MEASURE_ARY_OVER 2 Measure Calculated hours that are on a public holiday

Function
This formula gets a list of holidays for the given public holiday category and time card period. It assigns all time entries that don't
match a public holiday date to the OUT_MEASURE_ARY_UNDER measure. It assigns any time entries that do match to the
measure OUT_MEASURE_ARY_OVER measure.

45 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type.

Example: You create a rule with your template where the time category is All Pay Time Types. For calculated hours over the
threshold, the payroll time type is Overtime. Thursday and Friday are public holidays (PH).

Calculated Hours Over 8 Are Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 8h 8h

Tue Regular 8h 8h

Wed Regular 9h 8h

Overtime 1h

Thu (PH) Regular 8h

Overtime 8h

Fri (PH) Regular 8h

Overtime 8h

Sat Regular 8h 8h

46 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_TCR_THRESHOLD_TW O_TIER_SEVEN_DAY_AP

Description
This fast formula is associated with the delivered rule template Day Periods and Seventh Day Threshold Template. It compares
the total hours identified by the time category for the day, period, or seventh consecutive day with the threshold values for the
day, period, or seventh consecutive day. It converts hours over the threshold to a single payroll time type. It leaves hours under
the threshold as the same payroll time type or converts them to a new payroll time type. This formula uses an array processing
formula.

Initial release: 10.1

Parameters

WFM_TCR_THRESHOLD_TWO_TIER_SEVEN_DAY_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category that identifies the time entries to use to determine
the hours under and over the thresholds

DAILY_THRESHOLD_1 Fixed number Number of hours marking the threshold for the first day

DAILY_THRESHOLD_2 Fixed number Number of hours marking the second threshold for the first day

SEVENT_DAY_THRESHOLD Fixed number Number of hours marking the threshold for the seventh day

WEEKLY_THRESHOLD Fixed number Number of hours marking the threshold for the weekly time card

Outputs

WFM_TCR_THRESHOLD_TWO_TIER_SEVEN_DAY_AP Output Info

OUTPUT
NAME GROUP TIME ATTRIBUTE DESCRIPTION

OUT_MEASURE_ARY_UNDER 1 Measure Calculated hours under the first daily

threshold

OUT_MEASURE_OVER_1 2 Measure Calculated hours between the first and

second daily thresholds

OUT_MEASURE_OVER_2 3 Measure Calculated hours over the second daily

threshold

Function
The general overtime provision requirements are that people get 1.5 times their regular pay rate when they work more than X
hours a day or more than Y hours a week. People can work more than X hours a day or more than six days a week if they get
overtime pay according to these tiers.

 The first overtime tier includes all hours worked beyond X hours, up to and including X2 hours in a day. It also includes the first
X hours worked on the seventh consecutive day of the week.

 The second overtime tier includes all hours worked beyond X2 hours in a day. It also includes all hours worked in excess of X
on the seventh consecutive day of the week.

47 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Daily Rule:

 Overtime is based on 2 threshold values or parameters.

 Hours worked under the first threshold are paid at the regular rate.

 Hours worked over the first threshold and under the second threshold are paid at an overtime rate of 1.5 times the regular rate.

 Hours worked over the second threshold are paid at an overtime rate of 2 times the regular rate.

Weekly Rule:

 Overtime is based on 1 threshold value or parameter.

 Hours worked under the first threshold are paid at the regular rate.

 Hours worked over the first threshold are paid at an overtime rate of 1.5 times the regular rate.

Assumption in processing order:

1. The rule that checks for and processes any seventh day worked hours runs first. Typically, US rules use a threshold of 8 hours
and calculate hours under the threshold as overtime and over it as double time.

2. The daily rules that check thresholds and process any worked hours run next. Typically, US rules have these configurations:

– Daily double time rule (X2): The daily threshold is 12 hours with calculated hours under the threshold as regular and over it
as double time.

– Daily overtime rule (X): The daily threshold is 8 hours with calculated hours under the threshold as regular and over it as
overtime.

3. The weekly rule that checks the threshold and processes any worked hours runs last. Typically, US rules use a threshold of 40
hours and calculate hours under the threshold as regular and over it as overtime.

Examples
Scenario: The person's rule set includes the following four rules, created with this formula.

Time Calculation Rules

PROCESSING RULE PARAMETER CONFIGURATION OUTPUT CONFIGURATION

SEQUENCE

1 Seventh Day DT and OT SEVENT_DAY_THRESHOLD = 8 PAY _TYPE_UNDER = Overtime

PAY _TYPE_OVER_1 = Double Time

2 Daily Over 12 DT and RT DAILY_THRESHOLD_2 = 12 PAY _TYPE_UNDER = Regular

PAY _TYPE_OVER_2 = Double Time

3 Daily Over 8 OT and RT DAILY_THRESHOLD_1 = 8 PAY _TYPE_UNDER = Regular

PAY _TYPE_OVER_1 = Overtime

4 Weekly OT and RT WEEKLY_THRESHOLD = 40 PAY _TYPE_UNDER = Regular

PAY _TYPE_OVER_1 = Overtime

48 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 1: The seventh day and both daily rules don't run, but the weekly overtime rule does.

Weekly Overtime Rule Runs

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 5 Regular 8h 8h

6 Regular 8h

Overtime 8h

Example 2: The seventh day and daily double time rules don't run, but the daily and weekly overtime rules do.

Daily and Weekly Overtime Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 5 Regular 10h 8h

Overtime 2h

6 Regular 4h

Overtime 4h

Example 3 The seventh day and daily double time rules don't run, but the daily and weekly overtime rules do.

Daily and Weekly Overtime Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 3 Regular 6h 6h

4 -- 5 Regular 12h 8h

Overtime 4h

6 Regular 10h 6h

Overtime 4h

49 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 4: The seventh day rule doesn't run, but both daily rules and the weekly overtime rules do.

Both Daily Rules and Weekly Overtime Rule Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 Regular 13h 8h

Overtime 4h

Double Time 1h

2 Regular 6h 6h

3 -- 5 Regular 13h 8h

Overtime 4h

Double Time 1h

6 Regular 10h 2h

Overtime 8h

Example 5: The seventh day, both daily, and the weekly overtime rules all run.

All Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 Regular 4h 4h

2 Regular 8h 8h

3 Regular 12h 8h

Overtime 4h

4 -- 5 Regular 8h 8h

6 Regular 3h 3h

7 Regular 3h

Overtime 3h

50 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 6: The seventh day, both daily, and the weekly overtime rules all run.

All Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 3 Regular 4h 4h

4 Regular 13h 8h

Overtime 4h

Double Time 1h

5 Regular 8h 8h

6 Regular 4h 4h

7 Regular 9h

Overtime 8h

Double Time 1h

Example 7: The seventh day and weekly overtime rules run, but both daily rules don't.

Seventh Day and Weekly Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 5 Regular 8h 8h

6 Regular 8h

Overtime 8h

7 Regular 4h

Overtime 4h

51 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 8: The seventh day, daily double time, and weekly overtime rules run, but the daily overtime rule doesn't.

All Rules Run Except Daily Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 5 Regular 8h 8h

6 Regular 12h

Overtime 8h

Double Time 4h

7 Regular 13h

Overtime 8h

Double Time 5h

Example 9: The seventh day rule runs, but both daily rules and the weekly overtime rule don't.

Seventh Day Rule Runs

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 6 Regular 4h 4h

7 Regular 4h

Overtime 4h

Example 10: The seventh day and daily double time rules don't run, but the daily and weekly overtime rules do.

Daily and Weekly Overtime Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

2 -- 6 Regular 10h 8h

Overtime 2h

7 Regular 7h

Overtime 7h

52 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 11: The seventh day and weekly rules run, but both daily rules don't.

Seventh Day and Weekly Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 Regular 2h 2h

2 -- 5 Regular 8h 8h

6 Regular 8h 6h

Overtime 2h

7 Regular 5h

Overtime 5h

Example 12: The seventh day, both daily, and the weekly overtime rules all run.

All Rules Run

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

1 -- 5 Regular 15h 8h

Overtime 4h

Double Time 3h

6 Regular 15h

Overtime 12h

Double Time 3h

7 Regular 15h

Overtime 8h

Double Time 7h

53 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_THRESHOLD_TIME_CALCULATION_RULE

Description
This fast formula is associated with the delivered rule templates Daily Threshold Template and Weekly Threshold Template. It
compares the total hours identified by the time category for the day or period with the threshold value. It converts hours over the
threshold to a single payroll time type. It leaves hours under the threshold as the same payroll time type or converts them to a
new, single payroll time type.

Initial release: 11.1.8. The array processing version, WFM_THRESHOLD_TIME_CALCULATION_RULE_AP, is available as of

release 11.1.11 and is associated with the delivered rule templates Daily Threshold AP Template and Weekly Threshold AP
Template.

Parameters

WFM_THRESHOLD_TIME_CALCULATION_RULE Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category of reported hours that include the specified time
attributes to convert and copy to payroll cost segments.

DEFINED_LIMIT Fixed Number Number of hours marking the daily or weekly threshold

Outputs

WFM_THRESHOLD_TIME_CALCULATION_RULE Output Info

NAME OUTPUT TIME DESCRIPTION

GROUP ATTRIBUTE

OUT_MEASURE_ARY_UNDER 1 Measure Calculated hours under the daily or weekly threshold

OUT_MEASURE_ARY_OVER 2 Measure Calculated hours over the daily or weekly threshold

Function
This formula sums time entries for each day and the entire time card. It splits the totaled time between the measures
OUT_MEASURE_ARY_UNDER and OUT_MEASURE_ARY_OVER, if the total hours worked are more than the defined limit for
the selected summation level.

54 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type. Also, Sick and Jury Duty are pay time
attributes instead of absence time attributes.

Example 1: You create a rule with your template where the daily threshold is 8 hours. The time category is All Payroll Time Types
and the payroll time type for calculated hours over the threshold is Overtime.

Daily Threshold is 8 Hours, Pay Type Over is Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h 7h

Sick 1h 1h

Tue Regular 8h 8h

Wed Regular 9h 8h

Overtime 1h

Thu Regular 10h 8h

Overtime 2h

Fri Jury Duty 8h 8h

Regular 8h

Example 2: You create a rule with your template where the weekly threshold is 40 hours. The time category is All Payroll Time
Types, and the payroll time type for calculated hours over the threshold is Overtime.

Weekly Threshold is 40 Hours, Pay Type Over is Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h 7h

Sick 1h 1h

Tue Regular 8h 8h

Wed Regular 9h 9h

Thu Regular 10h 10h

Fri Jury Duty 8h 5h

Overtime 3h

55 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Scenario: You create a rule template with payroll time types for the calculated hours under and over the threshold because you
want to replace the ones associated with the reported time entries. Also, Sick and Jury Duty are pay time attributes instead of
absence time attributes.

Example 3: You create a rule with your template where the daily threshold is 8 hours and the time category is All Payroll Time
Types. The payroll time type for calculated hours under the threshold is Straight Time and over the threshold is Overtime.

Daily Threshold is 8 Hours, Pay Type Under is Straight Time and Over is Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h

Sick 1h

Straight Time 8h

Tue Regular 8h

Straight Time 8h

Wed Regular 9h

Straight Time 8h

Overtime 1

Thu Regular 10h

Straight Time 8h

Overtime 2h

Fri Jury Duty 8h

Straight Time 8h

56 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 4: You create a rule with your template where the weekly threshold is 40 hours and the time category is All Payroll Time
Types. The payroll time type for calculated hours under the threshold is Straight Time and over the threshold is Overtime.

Weekly Threshold is 40 Hours, Pay Type Under is Straight Time and Over is Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h

Sick 1h

Straight Time 8h

Tue Regular 8h

Straight Time 8h

Wed Regular 9h

Straight Time 9h

Thu Regular 10h

Straight Time 8h

Overtime 2h

Fri Jury Duty 8h

Straight Time 5h

Overtime 3h

57 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_THRESHOLD_TIME_CALCULATION_RULE_AP

Description
This fast formula is associated with the delivered rule templates Daily Threshold AP Template and Weekly Threshold AP
Template. It compares the total hours identified by the time category for the day or period with the threshold value. It converts
hours over the threshold to a single payroll time type. It leaves hours under the threshold as the same payroll time type or
converts them to a new payroll time type. This template uses an array processing formula.

Initial release: 11.1

Parameters

WFM_THRESHOLD_TIME_CALCULATION_RULE_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category that identifies the time entries to
use to determine the hours under and over the
thresholds

DEFINED_LIMIT Fixed number Number of hours marking the detail, daily or

weekly threshold

Outputs

WFM_THRESHOLD_TIME_CALCULATION_RULE_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

OUT_MEASURE_ARY_UNDER 1 Measure Calculated hours under the

daily or weekly threshold

OUT_MEASURE_ARY_OVER 2 Measure Calculated hours over the daily

or weekly threshold

Function
This formula sums time entries for each day and the entire time card. It splits the totaled time between the measures
OUT_MEASURE_ARY_UNDER and OUT_MEASURE_ARY_OVER, if the total hours worked exceed the defined limit for the
selected summation level.

58 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type. Also, Sick and Jury Duty are payroll time
attributes instead of absence time attributes.

Example 1: You create a rule with your template where the daily threshold is 8 hours and the time category is All Pay Time Types.
For calculated hours over the threshold, the payroll time type is Overtime.

Calculated Hours Over 8 Are Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h 7h

Sick 1h 1h

Tue Regular 8h 8h

Wed Regular 9h 8h

Overtime 1h

Thu Regular 10h 8h

Overtime 2h

Fri Jury Duty 8h 8h

Example 2: You create a rule with your template where the weekly threshold is 40 hours and the time category is All Pay Time
Types. For calculated hours over the threshold, the payroll time type is Overtime.

Calculated Hours Over 40 Are Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h 7h

Sick 1h 1h

Tue Regular 8h 8h

Wed Regular 9h 9h

Thu Regular 10h 10h

Fri Jury Duty 8h 5h

Overtime 3h

59 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Scenario: You create a rule template with payroll time types for the calculated hours under and over the threshold because you
want to replace the ones associated with the reported time entries. Also, Sick and Jury Duty are payroll time attributes instead of
absence time attributes.

Example 3: You create a rule with your template where the daily threshold is 8 hours and the time category is All Pay Time Types.
For calculated hours under the threshold, the payroll time type is Straight Time. For calculated hours over the threshold, it's
Overtime.

Calculated Hours Under 8 Are Straight Time, Over 8 Are Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h

Sick 1h

Straight Time 8h

Tue Regular 8h

Straight Time 8h

Wed Regular 9h

Straight Time 8h

Overtime 1h

Thu Regular 10h

Straight Time 8h

Overtime 2h

Fri Jury Duty 8h

Straight Time 8h

60 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 4: You create a rule with your template where the weekly threshold is 40 hours and the time category is All Pay Time
Types. For calculated hours under the threshold, the payroll time type is Straight Time. For calculated hours over the threshold,
it's Overtime.

Calculated Hours Under 40 Are Straight Time, Over 40 Are Overtime

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 7h

Sick 1h

Straight Time 8h

Tue Regular 8h

Straight Time 8h

Wed Regular 9h

Straight Time 9h

Thu Regular 10h

Straight Time 10h

Fri Jury Duty 8h

Straight Time 5h

Overtime 3h

61 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_THRESHOLD_W _ABS_TIME_CALCULATION_RULE_AP

Description
This time calculation rule fast formula is associated with the delivered rule templates Daily Threshold with Absences AP Template
and Weekly Threshold with Absences AP Template. It compares the total hours identified by the time category, which might
include absence time, for the day or period with the threshold value. It converts hours over the threshold to a single payroll time
type. It leaves hours under the threshold as the same payroll time type or converts them to a new, single payroll time type. This
formula uses an array to process time data.

Initial release: 11.1.10.

Parameters

WFM_THRESHOLD_W_ABS_TIME_CALCULATION_RULE_AP Parameter Info

NAME TYPE DESCRIPTION

WORKED_TIME_CONDITION Time category Time category that identifies the time

entries to use to determine the hours
under and over the thresholds

DEFINED_LIMIT Fixed number Number of hours marking the daily or

weekly threshold

RESTRICTED_ABSENCE_TYPE1 Fixed text First absence type attribute to identify

RESTRICTED_ABSENCE_TYPE2 Fixed text Optional second absence type

attribute to identify

RESTRICTED_ABSENCE_TYPE3 Fixed text Optional third absence type attribute

to identify

RESTRICTED_ALL_ABSENCE_Y Fixed text Maintain all absence entries

Outputs

WFM_THRESHOLD_W_ABS_TIME_CALCULATION_RULE_AP Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

MEASURE_ UNDER 1 Measure Calculated hours under the daily or

weekly threshold

MEASURE_ OVER 2 Measure Calculated hours over the daily or

weekly threshold

Function
Compares the total hours identified by the time category, which might include absence time, for the day or with the threshold
value. The function converts hours over the threshold to a single payroll time type attribute. For hours under the threshold, it either
keeps the attribute or converts the attribute to a new payroll time type attribute.

62 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type.

You create a rule with your template where the weekly threshold is 40 hours and the time category is All Payroll Time Types. The
vacation absence type is included in calculations, and the payroll time type for calculated hours over the threshold is Overtime.

Example 1: The person's hours total to 48 for the time card period when absence time is included.

 If your rule execution type is Update, then on Friday, the rule splits the calculated hours. It keeps the hours under the 40-hour
threshold associated with the reported payroll time type. It associates the calculated hours over the threshold with the Overtime
payroll time type.

 If your rule execution type is Create, the rule keeps all calculated hours associated with the existing payroll time types. It then
creates a new time entry for the hours over the threshold and associates it with the Overtime payroll time type

PAYROLL REPORTED CALCULATED CALCULATED

DAY TIM TYPE TIME (UPDATE) (CREATE)

Mon Vacation 8h 8h 8h

Tue – Thu Regular 10h 10h 10h

Fri Regular 10h 2h 10h

Overtime 8h

OT Differential 8h

Example 2: The person's hours total to 48 for the time card period when absence time is included.

 If your rule execution type is Update, the rule splits the calculated hours. It keeps the hours under the 40-hour threshold
associated with the reported payroll time type. It associates the calculated hours over the threshold with the Overtime payroll
time type. Because update calculation rules can only create additional overtime entries on nonabsence days, the rule enters
the calculated overtime on Thursday.

 If your rule execution type is Create, the rule keeps all calculated hours associated with the existing payroll time types. It then
creates a new time entry for the hours over the threshold and associates it with the Overtime payroll time type

PAYROLL REPORTED CALCULATED CALCULATED

DAY TIM TYPE TIME (UPDATE) (CREATE)

Mon – Wed Regular 10h 10h 10h

Thu Regular 10h 2h 10h

Overtime 8h

Fri Vacation 8h 8h 8h

OT Differential 8h

63 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

FORMULA NAME: W FM_VARIABLE_DAY_STA RT_TIME_CALCULATION

Description
This fast formula is associated with the delivered rule template Variable Day Threshold Template. It compares the total hours
identified by the time category for the variable day with the threshold value. It converts hours over the threshold to a single payroll
time type. It leaves hours under the threshold as the same payroll time type or converts them to a new, single payroll time type.

Initial release: 11.1.9

Parameters

WFM_VARIABLE_DAY_START_TIME_CALCULATION Parameter Info

NAME TYPE DESCRIPTION

SHIFT_START_TIME Time HH:MM Start time of the first shift of the

variable day in a 24-hour format

BREAK_LENGTH_MIN Fixed number Minimum nonworked time, in

minutes, between consecutive entries

DEFINED_LIMIT Fixed number Number of hours marking the

threshold for the variable day

WORKED_TIME_CONDITION Time category Time category that identifies the time

entries to total for the variable and
compare with the defined limit

Outputs

WFM_VARIABLE_DAY_START_TIME_CALCULATION Output Info

NAME OUTPUT TIME ATTRIBUTE DESCRIPTION

GROUP

OUT_MEASURE_UNDER 1 Measure Calculated based hours

OUT_MEASURE_OVER 2 Measure Calculated premium hours

Function
The function compares the total variable day hours identified by the time category with the threshold value. It coverts hours over
the threshold to a single payroll time type attribute. For hours under the threshold, it either keeps the attribute or converts the
attribute to a new payroll time type attribute. The function defines the variable day by the start time of the first entry after a
specified time. The day calculation considers all entries from the first time entry time until just before the same time on the next
day, unless the person got an insufficient break during the variable day. If the person did get an insufficient break, the function
includes entries after the same time on the next day, in the overtime calculation for the first day. This formula requires start and
end time entries. The calculation splits hours entries that span midnight and the calculated hours appear separately on each day.
The summation level is set to Detailed.

64 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Examples
Scenario: You create a rule template without a payroll time type for the calculated hours under the threshold because you want to
use the ones already associated with reported time entries. You add a payroll time type output for calculated hours over the
threshold because you want to use one that is different from the reported time type. You create a rule with your template with
these parameters:

 The new day starts with a time entry at or after 10:00p

 The break length minimum is 3 hours
 The threshold is 8 hours
 The time category is All Payroll Time Types

Example1: The time entries have more than 3 hours between them and no time entry starts before the shift start time.

More than 3 Hours Between Shifts and They Start on Time

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon -- Fri Regular 6a – 2p 8h

Example 2: The person works an extra shift that starts an hour before the usual shift start time. This start causes the entire shift to
count as part of the same variable day, thus qualifying the person for overtime.

Extra Shift Starts 1 Hour Before Usual Shift

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 6a – 2p 8h
9p – 11p

Overtime 2h

Tue -- Fri Regular 6a – 2p 8h

Example 3: The person works an extra shift on Tuesday. The rule considers the shift above the threshold even though it starts
after the shift start time because the reported start time is only 2.5 hours after the reported end time of the previous shift.

Less Than 3 Hours Between Shift End and Start Times

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 2p – 10p 8h

Overtime 3.5h

Tue Regular 12:30a – 4a 8h

12p – 8p

Wed -- Fri Regular 12p – 8p 8h

65 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

Example 4: The person works a second shift on Tuesday that starts earlier than the shift start time. The rule adds these extra 3
hours to the 6 hours reported earlier in the day and calculates 1 hour of over time. Then, on Wednesday, the person's shift starts
less than 3 hours after the end of the previous shift. So even though this is a new day, the rule calculates these hours on
Tuesday, as overtime.

Second Shift on Tuesday Starts Early, Wednesday Has Less Than 3 Hours Between Shift End and Start Times

DAY PAYROLL REPORTED CALCULATED

TIME TYPE TIME TIME

Mon Regular 12p – 8p 8h

Tue Regular 8a – 2p 8h
8p – 11p

Overtime 8h

Wed Regular 1a – 8a

Thu

Fri Regular 12p – 8p 8h

66 W HITE PAPER / Time Calculation Rule Fast Formula Reference Guide

ORACLE CORPORATION

Worldwide Headquarters
500 Oracle Parkway, Redwood Shores, CA 94065 USA

Worldwide Inquiries
TELE + 1.650.506.7000 + 1.800.ORACLE1
FAX + 1.650.506.7200
oracle.com

CONNECT W ITH US
Call +1.800.ORACLE1 or visit oracle.com. Outside North America, find your local office at oracle.com/contact.

blogs.oracle.com/oracle facebook.com/oracle twitter.com/oracle

Copyright © 2019, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are
subject to change without notice. This document isn’t warranted to be error-free, nor subject to any other warranties or conditions, whether expressed
orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any
liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be
reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or
registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks
of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 1019
White Paper Time Calculation Rule Fast Formula Reference GuideThis white paper describes the time calculation rule fast formulas delivered in
various releases of Oracle Fusion Time and Labor.
October 2019October 2019
Author: [OPTIONAL]
Contributing Authors: [OPTIONAL]