ORA_WFM_TCR_OT_EARNED_DAYS_FOR_ENTRIES_THAT_SPAN_DAYS Fast Formula

This fast formula is associated with the delivered rule template Time Entries That Span Overtime and Earned Days AP. It determines whether time entries span days. If they do, the formula determines these days:

  • The day to use in calculations that include reported time entries that span days
  • The earned day for reported time entries that span days

By default, the formula uses rule parameter values. When the rule doesn't pass any values, the formula uses the values of the person's work day definition. This formula uses an array to process time card data.

Parameters

Name Type Description
OVERTIME_DAY_START_TIME Time HH:MM Time in hours and minutes that marks the start of the day to use in time calculation rules that calculate overtime.
EARNED_RESOLVE_SPAN_RULE Fixed text

Rule to use to determine the earned day for reported time entries that span days. Valid values are:

  • START_DAY: Time calculation rules should treat time entries as being entirely on the start day.
  • STOP_DAY: Time calculation rules should treat time entries as being entirely on the stop day.
  • SPLIT_AT_DAY_START: Time calculation rules should split time entries at the time where one day ends and the other starts.
EARNED_GROUPING_THRESHOLD Fixed number Threshold, in minutes, used to group reported time entries on one or another of the multiple days.
ORA_HWM_FF_DAY_BREAKER_FLAG Exclude Internal indicator to split the day. Doesn’t show on the rule pages.

Outputs

This formula has no outputs shown on the rule template or rule.

Function

The function specifies to resolve time entries that span days using the rule {EARNED_RESOLVE_SPAN_RULE} for earned day. It automatically uses the rule SPLIT_AT_DAY_START for overtime. For this rule, the day start time is midnight and the threshold for grouping time entries on one day or the other is {EARNED_GROUPING_THRESHOLD} minutes. When determining the overtime day, the day start time is {OVERTIME_DAY_START_TIME}.