WFM_TSR_SUBMIT_OR_SAVE_ON_WORK_SCHEDULE_AP Fast Formula

This fast formula is associated with the delivered rule template Work Schedule Submission Template. It compares the imported Out device events that match the conditions of the time category with the submit range.

It calculates the submit range using the defined threshold, last scheduled work day, and time. If the Out event is in that range, it submits the time card. Otherwise, the formula compares the reported Out event with the save range. If the Out event is in that range, it saves the time card. If neither condition is met, it sets the time card status to Entered. This template uses an array processing formula.

Parameters

Name	Data Type	Description
WORKED_TIME_CONDITION	Time category	Time category that identifies the reported time entries to use to determine whether to save or submit the time card.
SUBMIT_THRESHOLD_IN_MINUTES	Fixed number	Minutes used with last scheduled work day and reported time entries to determine whether to submit the time card.
SAVE_THRESHOLD_IN_MINUTES	Fixed number	Minutes used with last schedule day and reported time entries to determine whether to save the time card.

Output

Name	Message Severity
OUT_MSG	Time card action automatically started

Examples

Scenario: Your people typically work 8 Regular hours per day and 5 days per week, which is the time card period. You create a rule with this formula that compares the total day and weekly hours to the scheduled total of 40 hours. The submit threshold is 4 and the save threshold is 9. If the formula can't find the schedule or the total hours equals 0, then submit the time card.

Example1: The total reported payroll hours equal 30 hours. This total is less than both the 36 submit and 31 save threshold hours so the formula sets the time card status to Entered.

Day	Payroll Time Type	Reported Time	Output
1	Regular	5h 3h	8h
2	Regular	8h	8h
3	Regular	2h 6h	8h
4	Regular	5h 1h	6h
Total reported payroll hours:			30h

Example 2: The total reported payroll hours equal 32 hours. Since this total is between the 36 submit and 31 save threshold hours, the formula saves the time card.

Day	Payroll Time Type	Reported Time	Output
1	Regular	5h 3h	8h
2	Regular	8h	8h
3	Regular	2h 6h	8h
4	Regular	5h 3h	8h
Total reported payroll hours:			32h

Example 3: The total reported payroll hours equal 38 hours, which is over the 36 submit threshold hours so the formula submits the time card.

Day	Payroll Time Type	Reported Time	Output
1	Regular	5h 3h	8h
2	Regular	8h	8h
3	Regular	2h 6h	8h
4	Regular	5h 3h	8h
5		6h	6h
Total reported payroll hours:			38h