WFM_COMPARE_WRKR_SCHEDULE_TO_REPORTED_HOURS Fast Formula
This fast formula is associated with the delivered rule template Compare Schedule to Reported Hours Template. It compares the total reported time for the day or period with either the published workforce management schedule or the HR employment schedule.
The formula first checks whether the published schedule exists in the time repository. If the published schedule doesn't exist, the formula compares the reported hours with the HR employment schedule using a PL/SQL availability API. If the total reported hours aren't within the scheduled hours plus or minus the defined variance, the defined message appears. If no message is defined, the default message appears. The message severity is an output value associated with the displayed message.
Parameters
| Name | Data Type | Description |
|---|---|---|
| VARIANCE_THRESHOLD_IN_MIN | Fixed number | Allowable variance, in minutes, between scheduled and reported hours |
| MESSAGE_CODE | Message | Message overriding the default one that appears if time entries matching the time category conditions total to less or more than the scheduled hours, minus or plus the variance |
| WORKED_TIME_CONDITION | Time category | Time category that identifies the reported time entries to use to determine whether the total hours match the scheduled hours or within the allowed variance |
Output
| Name | Message Severity |
|---|---|
| OUT_MSG | Specify whether the output message is informational, warning, or error |
Example
You created a rule with your template that has a variance threshold of plus or minus 10 minutes. It also has the time category All Payroll Time Types. The person has an assigned 9-hour work schedule that includes a 1-hour break, Monday through Friday.
| Day | Payroll Time Type | Reported Time | Output |
|---|---|---|---|
| Mon | Regular | 7:55a to 4:55p | None |
| Tue | Regular | 8a to 5p | None |
| Wed | Regular | 8:05a to 5:05p | None |
| Thu | Regular | 7:49a to 5p | The rule message for the message severity appears because the total reported hours are less than the scheduled hours minus the variance. |
| Fri | Regular | 8a to 5:12p | The rule message for the message severity appears because the total reported hours are greater than the scheduled hours plus the variance. |