Attendance, no-show absence
If scheduled but no worked hours or excused leave hours, generates an absence for the day
Details
Rule Type
Time
Execution
After day
Parameters
| Name | DataType | DefaultValue | Description |
|---|---|---|---|
HourType | lookup | The earnings code to use for the absence record |
Decision Tree
Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.
| Line# | Level1 | Level2 | Level3 | Comment |
|---|---|---|---|---|
| 1 | Start | |||
| 2 | IF(PayDate > TODAY(``)) → | ↓ | Only want past and present dates, ignore future | |
| 3 | ↓ | DONE | ||
| 4 | IF(FIND(employee, Exempt) = 1) → | ↓ | If exempt, don't enforce this rule | |
| 5 | ↓ | DONE | ||
| 6 | IF(CALC(scheduled.day) = 0) → | ↓ | If not scheduled (no scheduled hours), don't enforce this rule | |
| 7 | ↓ | DONE | ||
| 8 | IF(CALC(hours_worked.day) > 0) → | ↓ | Worked some hours, therefore not absent | |
| 9 | ↓ | DONE | ||
| 10 | SET( = INSERT_PUNCH(PayDate, HourType, CALC(scheduled.day), ABS)) | Absent; scheduled hours > 0 while workedhours = 0; ABS is an exception from the Exceptions app) | ||
| 11 | DONE |