ORA_WFM_TCR_UNIT_CALC_TIME_RANGE_AP Fast Formula
This fast formula determines unit quantities for reported time that spans a specific time range. It generates a unit time attribute for the day, if the reported time category hours span the specified range.
This formula uses an array to process time card data. It isn't associated with any delivered time calculation rule templates.
Parameters
| Name | Type | Description |
|---|---|---|
| WORKED_TIME_CONDITION | Time category | Time category of reported hours that include the specified time attributes used to determine whether to generate a units time attribute. |
| NUMBER_OF_UNITS | Fixed number | Numeric value for the number of units with UN unit of measure to allocate for each detail found. |
| START_TIME_HHMM24 | Time HH:MM | Start of time range to allocate units for. |
| STOP_TIME_HHMM24 | Time HH:MM | End of time range to allocate units for. |
Both start and stop time parameters must have a value in every rule associated with this formula. These parameters indicate to generate the specified unit of measure, if reported time during that range included time entries identified by the specified time category.
Outputs
| Name | Output Group | Time Attribute | Description |
|---|---|---|---|
| CALC_START_TIME | 1 | StartTime | Original start time |
| CALC_STOP_TIME | 1 | StopTime | Original stop time |
| MEASURE_UNITS | 2 | Measure | Number of units |
| UOM_UNITS | 2 | UnitOfMeasure | UN unit of measure |
| RATE_AMOUNT | 2 | Rate_Amount | Sets the rate amount to Null |
| PERIODICITY | 2 | Periodicity | Sets the periodicity of the rate amount to Null |
| UNITS_PAYTYPE | 2 | PayrollTimeType | Payroll time type to associate with the units |
Function
For each detail time card record found, depending on the time category, if the time card start time is between START_TIME_HHMM24 and STOP_TIME_HHMM24, add the number of units specified in NUMBER_OF_UNITS to the time card. The unit amount is 'UN' (Units).
Example
When the person works from 6:00 PM to midnight, they receive a night shift stipend.
| Day | Payroll Time Type | Reported Time | Calculated Time |
|---|---|---|---|
| 1 | Regular | 10a to 5p | 8h |
| 2 | Regular | 8p to11p | 3h |
| Night Shift Stipend | NA | 1 unit | |
| 3 | Regular | 10a to 5p | 8h |
| 4 | Regular | 8p to 11p | 8h |
| Night Shift Stipend | NA | 1 unit | |
| 5 | Regular | 10a to 5p | 8h |