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 defined as 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_UNITS |
Fixed number |
Minimum units required. |
MAX_UNITS |
Fixed number |
Maximum units allowed. |
WORK_ANY_WEEKEND_DAY |
Yes or No |
If Yes, generate the number of units when the worker associated
with a rule using this formula works any day defined as weekend
day.
If No, generate the number of units only when the worker
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. |
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 |
Examples of WORK_ANY_WEEKEND_DAY Is Yes
For these examples, the weekend days are Saturday and Sunday.
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
2 |
0 |
NA |
NA |
No error |
Sun |
7 |
1 |
1 |
1 |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
0 |
0 |
NA |
NA |
No error |
Sun |
7 |
1 |
1 |
1 |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
3 |
1 |
1 |
1 |
No error |
Sun |
0 |
0 |
NA |
NA |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
3 |
4 |
1 |
3 |
The quantity of {UNITS_TIME_ATTR} time attributes for the weekend
period exceeds the {MAX_UNITS} maximum limit defined for the time
card. |
Sun |
0 |
0 |
NA |
NA |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
3 |
1 |
2 |
3 |
The quantity of {UNITS_TIME_ATTR} time attributes for the weekend
period is less than the {MIN_UNITS} minimum limit defined for the
time card. |
Sun |
0 |
0 |
NA |
NA |
No error |
Examples of WORK_ANY_WEEKEND_DAY Is No
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
7 |
1 |
1 |
1 |
No error |
Sun |
7 |
1 |
1 |
1 |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
7 |
1 |
1 |
1 |
No error |
Sun |
7 |
0 |
1 |
1 |
The quantity of {UNITS_TIME_ATTR} time attributes for the weekend
period is less than the {MIN_UNITS} minimum limit defined for the
time card. |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
7 |
0 |
NA |
NA |
No error |
Sun |
7 |
3 |
1 |
1 |
The quantity of {UNITS_TIME_ATTR} time attributes for the weekend
period exceeds the {MAX_UNITS} maximum limit defined for the time
card. |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
7 |
0 |
NA |
NA |
No error |
Sun |
7 |
3 |
1 |
1 |
The quantity of {UNITS_TIME_ATTR} time attributes for the weekend
period exceeds the {MAX_UNITS} maximum limit defined for the time
card. |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
0 |
0 |
NA |
NA |
No error |
Sun |
7 |
1 |
1 |
1 |
The {UNITS_TIME_ATTR} time attributes were reported, although all
weekend days weren’t worked. |
|
|
|
Rule parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
2 |
0 |
NA |
NA |
No error |
Sun |
7 |
1 |
1 |
1 |
No error |
|
|
|
Rule Parameters |
|
Day |
Regular (hours) |
Weekend Allowance (units) |
MIN_UNITS |
MAX_UNITS |
Error Status |
Sat |
3 |
1 |
1 |
1 |
The {UNITS_TIME_ATTR} time attributes were reported, although all
weekend days weren’t worked. |
Sun |
0 |
0 |
NA |
NA |
No error |