Calculation formula templates are predefined calculation formulas. In order to run with the correct results the individual parameters need to be set after creating a calculation formula. Those parameters are marked in the Remarks column with '>>'. If necessary additional changes in the calculation formula can also be done. It is possible to create multiple calculation formulas from the same template.
The provided templates and required parameters are listed below.
WEEK: Weekly overtime calculation which considers provided wage codes as work hours and uses either an employee property field WEEKHRS or the scheduled hours as base for overtime calculation. The result will be written in periodic result. The calculation will be executed on the last day of the defined work week. If changes are made on the days before, the last day will be automatically recalculated.
| Description | Remarks | Predefined Value |
| Enter the ID of the wage code that shall be written as overtime | Wage code has to exist in company and wage class for which the calculation formula is used. | WCOT |
| Enter the ID of the wage code that shall be considered as work hours (1)/(2)/(3)/(4) | If the provided value does not exist as wage code, no work hours will be considered. At least one existing wage code should be provided. Wage code can be of any type, also absence wage codes can be considered as work hours. | WC01 WC02 WC03 WC04 |
| Enter the weekday which is considered the
first of the week (will be the first of the week period in periodic
result) 1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday 7 - Sunday |
The given week day defines the begin of the work week. The periodic result will be written with the work week starting on the given day, the calculation will always run on the last day of the work week. | 1 - Monday |
DAY_AND_WEEK: Combined daily and weekly overtime calculation. Work hours are calculated from provided wage codes. Overtime is calculated exceeding 8 work hours daily and 40 work hours weekly. The weekly overtime automatically deducts already provided daily overtime. In addition, work hours that exceed 12 hours per day will be considered as double time. On the 7th consecutive work day per week, the first 8 hours will be considered as overtime the exceeding hours will be also considered as double time. The calculated overtime will be written as result hours.
| Description | Remarks | Predefined Value |
| Enter the ID of the wage code that shall be written as overtime | Wage code has to exist in company and wage class for which the calculation formula is used. | WCOT |
| Enter the ID of the wage code that shall be written as doubletime | Wage code has to exist in company and wage class for which the calculation formula is used. | WCDT |
| Enter the ID of the wage code that shall be considered as work hours (1)/(2)/(3)/(4) | If the provided value does not exist as wage code, no work hours will be considered. At least one existing wage code should be provided. Wage code can be of any type, also absence wage codes can be considered as work hours. | WC01 WC02 WC03 WC04 |
| Enter the weekday which is considered the
first of the week 1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday 7 - Sunday |
The given week day defines the begin of the work week. Weekly calculation starts on this day and the value is also used to check for consecutive work days. | 1 - Monday |
| Enter the amount of hours required per day before overtime is paid | The daily hours can also be set indivdually per employee in the property field DAYWH | 8 |
| Enter the amount of hours required per week before overtime is paid | The weekly hours can als be set individually per employee in the property field WEEKWH | 40 |
MONTH: Monthly overtime calculation which considers provided wage codes as work hours and the scheduled hours as base for overtime calculation. The result will be written in periodic result. The calculation will be executed on the last day of the month. If changes are made on the days before, the last day will be automatically recalculated.
| Description | Remarks | Predefined Value |
| Enter the ID of the wage code that shall be written as overtime | Wage code has to exist in company and wage class for which the calculation formula is used. | WCOT |
| Enter the ID of the wage code that shall be considered as work hours (1)/(2)/(3)/(4) | If the provided value does not exist as wage code, no work hours will be considered. At least one existing wage code should be provided. Wage code can be of any type, also absence wage codes can be considered as work hours. | WC01 WC02 WC03 WC04 |