WORKFORCE_MANAGEMENT_TIME_CALCULATION_RULES Formula Type

To create formulas that create or update time entries, use the time calculation rule formula type. The formulas also use relevant time data to create calculated time results.

You can select only formulas with this formula type when creating time calculation rule templates.

Header Indicator Description

Rule Classification Choice list with the values applicable to time calculation rules

Rule Execution Type

Header Indicator	Description
Rule Classification	Choice list with the values applicable to time calculation rules
Rule Execution Type	Specify whether rules must create additional hours or update existing hours. This indicator displays only for time calculation rule templates when the associated formula includes this indicator. Examples: Create: Rule processing creates total calculated time of 12 hours, which is 2 hours more than the reported time. This keeps the 10 hours of Regular time at the regular hourly rate. It also creates 2 hours of Premium time at .5 times the regular hourly rate. Calculation example: `(10 hours * 10 USD) + (2 hours * 5 USD) = 110 USD` Update: Rule processing creates total calculated time of 10 hours, which matches the reported time. Processing adjusts the pay rate for 2 of the 10 reported hours. It does this with 8 hours of Regular time at the regular hourly rate, and 2 hours of Overtime at 1.5 times the regular hourly rate Calculation example: `(8 hours * 10 USD) + (2 hours * 15 USD) = 110 USD`
Summation Level	Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator. Details: Process the rule against all time entries that match the time category condition. Day: Process the rule against hours entered for the entire day that match the time category conditions. Time Card: Process the rule against hours entered for the entire period that match the time category conditions.

Specify whether rules must create additional hours or update existing hours. This indicator displays only for time calculation rule templates when the associated formula includes this indicator.

Examples:

Create: Rule processing creates total calculated time of 12 hours, which is 2 hours more than the reported time. This keeps the 10 hours of Regular time at the regular hourly rate. It also creates 2 hours of Premium time at .5 times the regular hourly rate.
Calculation example: (10 hours * 10 USD) + (2 hours * 5 USD) = 110 USD
Update: Rule processing creates total calculated time of 10 hours, which matches the reported time. Processing adjusts the pay rate for 2 of the 10 reported hours. It does this with 8 hours of Regular time at the regular hourly rate, and 2 hours of Overtime at 1.5 times the regular hourly rate
Calculation example: (8 hours * 10 USD) + (2 hours * 15 USD) = 110 USD

Summation Level

Specify at what level the rule applies. This indicator displays only when the associated formula includes this indicator.

Details: Process the rule against all time entries that match the time category condition.
Day: Process the rule against hours entered for the entire day that match the time category conditions.
Time Card: Process the rule against hours entered for the entire period that match the time category conditions.