ORA_WFM_TER_MIN_MAX_PAYTYPE_UNITS_AP Fast Formula
This fast formula determines whether reported units time entries for the units time category are under or over the defined minimum and maximum unit quantities. It compares the reported time category quantity to the defined minimum and maximum unit quantities.
If the reported unit quantities are under or over the defined limits, the corresponding defined message appears. If no message is defined, the default message appears. The message severity is an output associated with the displayed message. This formula uses an array to process time card data. It isn't associated with any delivered time entry rule templates.
Parameters
| Name | Data Type | Description |
|---|---|---|
| WORKED_TIME_CONDITION | Time category | Time category of reported units to sum and compare with the defined minimum and maximum unit quantities. |
| MIN_HOURS | Fixed number | Minimum hours required for the worker associated with the rule that uses this formula to qualify for units. |
| MIN_UNITS | Fixed number | Minimum units required. |
| MAX_UNITS | Fixed number | Maximum units allowed. |
| OVERRIDE_MSG_CD_MIN_QTY | Message | Message that overrides the default message that appears if the summed units value is less than the minimum units required. |
| OVERRIDE_MSG_CD_MAX_QTY | Message | Message that overrides the default message that appears if the summed units value exceeds the maximum units allowed. |
| OVERRIDE_MSG_CD_MIN_HRS | Message | Message that overrides the default message that appears if the minimum number of required reported hours wasn’t reached. |
Output
| Name | Message Severity |
|---|---|
| OUT_MSG | Specify whether the output message is informational, warning, or error |
Example Error Messages
The bolded items in each row identify where the reported hours or units don't match the applicable rule parameter.
| Rule Parameters | ||||||
|---|---|---|---|---|---|---|
| Regular (hours) | Meal (hours) | Meal Allowance (units) | MIN_HOURS | MIN_UNITS | MAX_UNITS | Error Status |
| 7 | 1 | 1 | 1 | 1 | 1 | No errors |
| 7 | 2 | 0 | 1 | 1 | 1 | The quantity of the {UNITS_TIME_ATTR} time attributes for the period is less than the {MIN_UNITS} minimum limit defined for the time card. |
| 7 | 3 | 2 | 1 | 1 | 1 | The quantity of the {UNITS_TIME_ATTR} time attributes for the period exceeds the {MIN_UNITS} maximum limit defined for the time card. |
| 7 | 3 | 1 | 4 | 1 | 1 | The {UNITS_TIME_ATTR} time attribute was reported, although the minimum number of reported hours wasn’t reached. |
| 7 | 4 | 1 | 3 | 2 | 4 | The quantity of the {UNITS_TIME_ATTR} time attribute for the period is less than the {MIN_UNITS} minimum limit defined for the time card. |
| 7 | 1 | 5 | 6 | 2 | 4 |
The quantity of the {UNITS_TIME_ATTR} time attribute for the period exceeds the {MAX_UNITS} maximum limit defined for the time card. The {UNITS_TIME_ATTR} time attributes were reported, although the minimum number of reported hours wasn’t reached. |