ORA_WFM_TCR_ALLOCATION_TIME_AP Fast Formula

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.

Parameter

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.

Examples of Percentage Allocations

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

Day Worked Time Department Reported Time Calculated Time
Mon thru Fri Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Totals Regular: 8h 0h
Regular, Cardiac Care: 0h 4h
Regular, Intensive Care: 0h 4h
Total 8h 8h
Weekly Totals Regular: 40h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Total: 40h 40h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

On-Call Intensive Care 2p to 4p 2h
Daily Total: 8h 8h
Tue Regular

Cardiac Care

Intensive Care

8a to 12p

2h

2h

Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Total: 8h 8h
Thu Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Fri Regular

Cardiac Care

Intensive Care

8a to 12p

2h

2h

Daily Total: 4h 4h
Sat Regular Emergency 1p to 5p 4h
Daily Total: 4h 4h
Weekly Totals Regular: 22h 0h
Regular, Cardiac Care: 0h 11h
Regular, Intensive Care: 0h 11h
On-Call, Intensive Care: 2h 2h
Regular, Emergency: 16h 16h
Total: 40h 40h

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 total for the time card period equals the defined allocation quantity.

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Weekly Totals Regular: 40h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Total: 40h 40h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 12p

4h

Daily Total: 4h 4h
Tue Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Wed Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

1p to 5p

4p

Daily Total: 4h 4h
Weekly Totals Regular: 32h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 12h
Total: 32h 32h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 6p

10h

Daily Total: 10h 10h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

2h

6h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

8a to 4p

2h

6h

Daily Total: 8h 8h
Sat Regular 8a to 4p 8h
Daily Total: 8h 8h
Weekly Totals Regular: 50h 10h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Total: 50h 50h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 2p

6h

On-Call Intensive Care 2p to 4p 2h
Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 12p

4h

Regular Emergency 1p to 5p 4h
Daily Total: 10h 10h
Wed Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Thu Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Fri Regular

Cardiac Care

Intensive Care

8a to 12p

2h

2h

On-Call Intensive Care 1p to 5p 4h
Daily Total: 8h 8h
Sat Regular

Intensive Care

8a to 12p

4h

Daily Total: 4h 4h
Sun Regular Emergency 8a to 12p 4h
Daily Total: 4h 4h
Weekly Totals: Regular: 26h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 6h
On-Call, Intensive Care: 6h 6h
Regular, Emergency: 16h 16h
Total: 48h 48h

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

Priority Allocation Type Quantity Department
5 20 Cardiac Care
10 20 Intensive Care
15 Balance Operation
Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

1p to 5p 4h
Regular Emergency 1p to 5p 4h
Daily Total: 12h 12h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

6h

2h

Daily Total: 8h 8h
Thu Regular

Intensive Care

Operation

8a to 4p

6h

2h

Regular Emergency 8a to 4p 8h
Daily Total: 16h 16h
Fri Regular

Operation

8a to 12p

4h

Daily Total: 4h 4h
Sat On-Call Emergency 8a to 12p 4h
Daily Total: 4h 4h
Sun Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Weekly Totals Regular: 36h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 10h
Regular, Operation: 0h 6h
Regular, Emergency: 20h 20h
On-Call Emergency: 4h 4h
Totals: 60h 60h

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 total for the time card period equals the defined allocation quantity.

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Weekly Totals Regular: 40h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Total: 40h 40h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 12p

4h

Daily Total: 4h 4h
Tue Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Wed Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

1p to 5p

4h

Daily Total: 4h 4h
Weekly Totals Regular: 32h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 12h
Total 32h 32h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 6p

10h

Daily Total: 10h 10h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

2h

6h

Daily Total: 8h 8h
Thu Regular

Intensive Care

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Intensive Care

8a to 4p

2h

6h

Daily Total: 8h 8h
Sat Regular 8a to 4p 8h
Daily Total: 8h 8h
Weekly Totals Regular: 50h 10h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Total 50h 50h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 2p

6h

On-Call Intensive Care 2p to 4p 2h
Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 12p

4h

Regular Emergency 1p to 5p 4h
Daily Total: 10h 10h
Wed Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Thu Regular

Emergency

8a to 4p

8h

Daily Total: 8h 8h
Fri Regular

Cardiac Care

Intensive Care

8a to 12p

2h

2h

On-Call Intensive Care 1p to 5p 4h
Daily Total: 8h 8h
Sat Regular

Intensive Care

8a to 12p

4h

Daily Total: 4h 4h
Sun Regular Emergency 8a to 12p 4h
Daily Total: 4h 4h
Weekly Totals Regular: 26h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 6h
On-Call, Intensive Care: 6h 6h
Regular, Emergency: 16h 16h
Total 48h 48h

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

Priority Allocation Type Quantity Department
5 20 Cardiac Care
10 20 Intensive Care
15 Balance Operation
Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

8a to 4p

8h

Daily Total: 8h 8h
Tue Regular

Cardiac Care

8a to 4p

8h

Regular Emergency 1p to 5p 4h
Daily Total: 12h 12h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

6h

2h

Daily Total: 8h 8h
Thu Regular

Intensive Care

Operation

8a to 4p

6h

2h

Regular Emergency 8a to 4p 8h
Daily Total: 16h 16h
Fri Regular

Operation

8a to 12p

4h

Daily Total: 4h 4h
Sat On-Call Emergency 8a to 12p 4h
Daily Total: 4h 4h
Sun Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Weekly Totals Regular: 36h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 10h
Regular, Operation: 0h 6
Regular, Emergency: 20h 20h
On-Call, Emergency: 4h 4h
Total: 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.

Day Worked Time Department Reported Time Calculated Time
Mon thru Fri Regular

Cardiac Care

Intensive Care

Emergency

8a to 40

2.66h

2.66h

2.66h

Daily Totals Regular: 8h 0h
Regular, Cardiac Care: 0h 2.66h
Regular, Intensive Care: 0h 2.66h
Regular, Emergency: 0h 2.66h
Total: 8h 7.98h
Weekly Totals Regular: 40h 0h
Regular, Cardiac Care: 0h 13.3h
Regular, Intensive Care: 0h 13.3h
Regular, Emergency: 0h 13.3h
Total: 40h 39.9h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

Intensive Care

Emergency

8a to 2p

2h

2h

2h

On-Call Intensive Care 2p to 4p 2h
Daily Total: 8h 8h
Tue Regular

Cardiac Care

Intensive Care

Emergency

8a to 12p

1.33h

1.33h

1.33h

Regular Emergency 1p to 5p 4h
Daily Total: 8h 7.99h
Wed Regular

Cardiac Care

Intensive Care

Emergency

8a to 4p

2.66h

2.66h

2.66

Daily Total: 8h 7.98h
Thu Regular Emergency 8a to 4p 8h
Daily Total: 8h 8h
Fri Regular

Cardiac Care

Intensive Care

Emergency

8a to 12p

1.33h

1.33h

1.33h

Daily Total: 4h 3.99h
Sat On-Call Intensive Care 1p to 5p 4h
Daily Total: 4h 4h
Weekly Totals Regular: 22h 0h
Regular, Cardiac Care: 0h 7.32h
Regular, Intensive Care: 0h 7.32h
Regular, Emergency: 12h 12h
On-Call, Intensive Care: 6h 6h
Total: 40h 39.96h

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.

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

Intensive Care

8a to 6p

4h

4h

Overtime Cardiac Care

Intensive Care

1h

1h

Daily Total: 10h 10h
Tue Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Total: 8h 7.99h
Wed Regular

Cardiac Care

Intensive Care

8a to 4:30p

4h

4h

Overtime Cardiac Care

Intensive Care

.25h

.25h

Daily Total: 8.5h 8.5h
Thu Regular

Cardiac Care

Intensive Care

8a to 4p

4h

4h

Daily Total: 8h 8h
Fri Regular

Cardiac Care

Intensive Care

8a to 5p

4h

4h

Overtime Cardiac Care

Intensive Care

.5h

.5h

Daily Total: 9h 9h
Weekly Totals Regular: 43.5h 0h
Regular, Cardiac Care: 0h 20h
Regular, Intensive Care: 0h 20h
Overtime, Cardiac Care: 0h 1.75h
Overtime, Intensive Care: 0h 1.75h
Total: 43.5h 43.5h

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

Day Worked Time Department Reported Time Calculated Time
Mon Regular

Cardiac Care

Intensive Care

7a to 12p

2.5h

2.5h

Regular Emergency 1p to 4p 3h
On-Call Intensive Care 4p to 6p
Overtime Intensive Care 2h
Daily Total: 10h 10h
Tue Regular Emergency 8a to 5p 8h
Overtime Emergency 1h
Daily Total: 9h 9h
Wed On-Call Intensive Care 8a to 4:30p 8h
Overtime Intensive Care .5h
Daily Total: 8.5h 8.5h
Thu Regular

Cardiac Care

Intensive Care

8a to 5p

4h

4h

Overtime Cardiac Care

Intensive Care

.5h

.5h

Daily Total: 9h 9h
Fri Regular

Cardiac Care

Intensive Care

8a to 5p

4h

4h

Overtime Cardiac Care

Intensive Care

.5h

.5h

Daily Total: 9h 9h
Weekly Totals Regular: 23.5h 0h
Regular, Cardiac Care: 0h 10.5h
Regular, Intensive Care: 0h 10.5h
Regular, Emergency: 12h 11h
On-Call, Intensive Care: 10.5h 8h
Overtime, Emergency 0h 1h
Overtime, Cardiac Care: 0h 1h
Overtime, Intensive Care: 0h 3.5h
Total: 45.5h 45.5h

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 distribute the next 20 hours to Intensive care.

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

Day Worked Time Department Reported Time Calculated Time, No Daily OT Calculated Time, Daily OT
Mon Regular Cardiac Care 8a to 2p

6h

6h

On-Call Intensive Care 2p to 4p 2h 2h
Regular Emergency 4p to 6p 2h
Overtime Emergency 2h 2h
Daily Total: 10h 10h 10h
Tue Regular

Cardiac Care

8a to 12p

4h

4h

Regular Emergency 1p to 5p 4h 4h
Daily Total: 8h 8h 8h
Wed Regular

Cardiac Care

7a to 12p

5h

5h

On-Call Intensive Care 1p to 4p 3h 3h
Regular Emergency 4p to 6p 2h
Overtime Emergency 2h
Daily Total: 10h 10h 10h
Thu Regular Emergency 8a to 4p 8h 8h
Daily Total: 8h 8h 8h
Fri Regular

Cardiac Care

8a to 12p

4h

4h

On-Call

Intensive Care

1p to 5p 4h 4h
Daily Total: 8h 8h 8h
Sat Regular

Cardiac Care

Intensive Care

8a to 12p

1h

3h

1h

3h

Daily Total: 4h 4h 4h
Sun Regular Emergency 8a to 12p 4h 4h
Daily Total: 4h 4h 4h
Weekly Totals Regular: 23h 0h 0h
Regular, Cardiac Care: 0h 20h 20h
Regular, Intensive Care: 0h 3h 3h
Regular, Emergency: 20h 20h 16h
On-Call, Intensive Care: 9h 9h 9h
Overtime, Emergency 0h 0h 4h
Total: 52h 52h 52h

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

Priority Allocation Type Quantity Department
5 20 Cardiac Care
10 20 Intensive Care
15 Balance Operation

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

Day Worked Time Department Reported Time Calculated Time, No Daily OT Calculated Time, Daily OT
Mon Regular

Cardiac Care

8a to 6p

10h

8h

Overtime Cardiac Care 2h
Daily Total: 10h 10h 10h
Tue Regular

Cardiac Care

7a to 4p

9h

8h

Overtime Cardiac Care 1h
Daily Total: 9h 9h 9h
Wed Regular

Cardiac Care

Intensive Care

8a to 4p

1h

7h

1h

7h

Daily Total: 8h 8h 8h
Thu Regular

Intensive Care

Operation

8a to 4p

3h

5h

3h

5h

On-Call Emergency 4p to 6p 2h
Overtime Emergency 2h
Daily Total: 10h 10h 10h
Fri Regular

Operation

8a to 5p

9h

8h

Overtime Operation NA 0h 1h
Daily Total: 9h 9h 9h
Sat On-Call Emergency 8a to 12p 4h 4h
Daily Total: 4h 4h 4h
Sun On-Call Emergency 8a to 12p 4h 4h
Daily Total: 8h 8h 8h
Weekly Totals Regular: 44h 0h 0h
Regular, Cardiac Care: 20h 17h
Regular, Intensive Care: 0h 10h 10h
Regular, Operation: 0h 14h 13h
On-Call, Emergency: 14h 14h 12h
Overtime, Cardiac Care 0h 0h 3h
Overtime, Emergency 0h 0h 2h
Overtime, Operations 0h 0h 1h
Total: 58h 58h 58h