ORA_WFM_WCR_IN_OUT_DANGLERS_AP Fast Formula
This fast formula determines whether time entries are incomplete, meaning that either the start or end time is missing. If the formula finds an incomplete entry, it generates the corresponding defined message.
The message severity is an output associated with the generated message. This formula uses an array to process time card data. It isn't associated with any delivered workforce compliance rule templates.
Parameters
| Name | Data Type | Description |
|---|---|---|
| TAGS_COMMA_SEPARATOR | Fixed text | Comma-separated tags |
| MESSAGE_CODE_START | Message | Code of the message that overrides the code of the delivered default message for entries missing the start time, which is HWM_FF_WCR_MISSING_START_TIME |
| MESSAGE_CODE_END | Message | Code of the message that overrides the code of the delivered default message for entries missing the end time, which is HWM_FF_WCR_MISSING_STOP_TIME |
Output
| Name | Message Severity |
|---|---|
| OUT_MSG | Specify whether the output message is informational, warning, or error. |
Function
Because workforce compliance rules don't account for incomplete entries, the default logic sets missing start time entries to 12:00a and a duration of 0. It sets missing end time entries to 23.59.59 and a duration of 0.
- The formula generates a missing start message if the time entry start time is 12:00a and the duration is 0.
- The formula generates a missing end message if the time entry stop time is 23.59.59 and the duration is 0.
Example
The formula generates a missing start exception on Tuesday, March 6, 2018. It generates a missing end exception on Wednesday, March 8, 2018.
| Start and End Times | Mon 2 Mar 2020 | Tue 3 Mar 2020 | Wed 4 Mar 2020 | Thu 5 Mar 2020 | Fri 6 Mar 2020 |
|---|---|---|---|---|---|
| Start and End Times Imported from Time Collection Device | 8:00 to 16:00 | 0:00 to 17:00 | 9:00 to 23:59 | 8:00 to 16:00 | 21:59 to 23:59 |
| Start and End Times Shown in the Application | 8:00 to 16:00 | __ to 17:00 | NA | NA | NA |
| Duration Imported from Time Collection Device | 8 | 0 | 0 | NA | 2 |
| Duration Shown in the Application | 8 | -- | -- | NA | 2 |