Formulas setup

Absence Management formulas provide methods to accrue amounts used in rules tables. You can define three types of formulas:

  • Amount formulas
  • Ratio formulas
  • Date formulas

Amount formulas

Amount formulas accrue flat or calculated amounts that are based on the length of service. You can define cycle amount and hours amount formulas.

Amount formulas accrue flat or calculated amounts that are based on the length of service.

  • Cycle amount formulas are used with cycle-based rules tables to define an accrual value for different levels of hours within the cycle. They are based on the hours service class that is selected on the formula. You can use a flat amount, an amount that is multiplied by hours or earnings from a service class, or a calculation.
  • Hours amount formulas are used with hours-based rules tables. You can define an accrual value for levels of hours that are based on the hours service type that is selected on the formula. For example, life to date, year to date, prior year total. You can use a flat amount, an amount that is multiplied by hours or earnings from a service class, or a calculation.

    Example: 5 hours x FTE per semi-monthly pay cycle

Ratio Formulas

Ratio formulas are accrued based on the types of hours worked in a given cycle. Ratio formulas define an accrual value for different service classes that are selected on the formula. You can use an amount or a calculation, which is then multiplied by the hours from the service class.

Example: (70 regular hours x .075) + (10 on-call hours x .025)

Date Formulas

Date formulas accrue for specific dates. You define an accrual value for different calendar dates. These values can be either an amount or a calculation. Any lead time must be built into the date specified.

Example: 8 hours x the FTE for each of 10 specified holidays in a year