Example: Create Time Off Deductions Based on Worker Schedules (FRA)
This example illustrates how to:
- Set up time off deduction calculations based on worker schedules.
- Perform time off calculations, in hours, for time off entered in days.
Global Modern Services pays workers monthly salaries, and has its workers enter time off in days.
You want to calculate deductions for time off based on a daily rate for the month.
You want to calculate the daily rate based on:
- The monthly salary.
- The number of hours in a worker's schedule for a given month.
Set up for Global Modern Services:
- AFamily Leavetime off.
- Earnings for a worker's base salary.
- Worker schedule calendars with the work hours and schedule for all employees.
Security:
Set Up: Payroll (Calculations- Payroll Specific)
and Set Up: Payroll
(Calculations - Generic)
domains in the Core Payroll functional area.- Access theEdit Earningtask, and for each base salary earning:
- SelectNone of the abovein theCalculation Prorationsection on theEffective Datedtab.
- SelectFRA Base Salary Elements (for absence valuation)from theGroupsprompt on theNon-Effective Datedtab.
- Access theCreate Deductiontask and enter these settings:FieldSettingNameFamily Leave Time OffCodeFamily Leave TOEffective DateSelect today's date.
- In theCriteriasection of theEffective Datedtab, create an eligibility rule to prevent the deduction from resolving when the employee has noFamily Leavetime off.
- Add a row in theWorker Eligibilitygrid. From theWorker Eligibilityprompt, select .
- Name the value comparison Family Leave > 0.
- SelectPayrollas theCategory.
- Enter these settings:FieldSetting1st OperandFamily Leave - Time Off TotalOperatorgreater than2nd OperandSelect , and then select0.
- Define the deduction calculation in theCalculation Detailssection of theEffective Datedtab.
- SelectFRA Days * Rate rounded to the Nearest 0.01from theCalculationprompt.
- To retrieve the daily salary rate for the deduction, add a row in theRelated Calculationsgrid, and complete the fields with these settings:FieldSettingRelated CalculationRateOverride CalculationFRA Base Salary Elements Daily Rate for Full Period Non Rounded.
- To retrieve the total time off in days, add a second row:FieldSettingRelated CalculationFRA DaysOverride CalculationFamily Leave - Time Off Total
- To convert time off entered in days to hours, based on the worker's calendar schedule, add a third row.FieldSettingRelated CalculationFRA Unpaid HoursOverride CalculationTime Off Hours for Time Off in Days
- On theNon-Effective Datedtab, from theGroupsprompt, selectFRA Subtracts from Gross [FRA]to subtract the deduction from the gross pay.
Gloria is an employee who:
- Has a monthly salary of 4000 EUR.
- Works 7.5 hours per day and 5 days per week, based on her calendar schedule.
- 22 workable days in the January.
- 7.5 standard hours per day.
- 165 workable hours in January, based on the worker's calendar schedule definition.
- A monthly salary of 4000 EUR.
On Gloria's pay results, Workday subtracts this deduction from her gross
pay:
Description | Time Off Entries | Rate | Amount (EUR) |
|---|---|---|---|
Family Leave Time Off
| 3 | 181.81 | (545.45) |
To pay Gloria compensation for her family leave time off, create a
Family Leave
Compensation
earning based on these related calculations:- Family Leave Time Off - Rate
- Family Leave Time Off - FRA Days