Average Absence Calculation

Note: This integration is an extension that is developed outside the normal release schedule to meet specific client needs. To request one of these extensions, you must submit a Salesforce Service Request to ADP. After the extension is delivered to your tenant, you can edit it accordingly.

The Average Absence Calculation integration improves the calculation of the average lengths of absence​s in time-off rules by excluding absences from the averaging period. Managers no longer need to make corrections manually. Also, this integration supports multiple averaging rules so that you can automatically compare and select the appropriate average calculation.

The amount used for a paycode edit can be an average of recently worked, contracted, or scheduled time.​ Example: A vacation day calculation is based on the computed average time that was worked during the last 12 weeks.

Examples:

  • Excluded absences and extended averaging period: Absences such as for illness are excluded from the averaging period, however, to maintain accurate averaging, the ​calculation must be based on the same amount of data as the other hours. So, the excluded weeks are added to extend the averaging period.​

  • Multiple average rules: An organization has two average calculations: one looks back 12 weeks; another looks back 52 weeks.​ With this integration, you can calculate both, compare the amounts, and select whether to use the highest or lowest average.

The Average Absence Calculation integration offers the following options:​​

  • Configure the length of look-back periods, starting from the week before the week of the absence.​
  • Configure which absences to exclude from the averaging period.
  • Configure minimum and maximum time-off values to use in the average absence computation.​
  • Automatically extend the overall averaging period, run an additional calculation, and adjust if needed.​
  • Configure a secondary average calculation that uses a different look-back period.​ Compare both results and select the higher or lower average amount.​
  • Insert a paycode adjustment in case a different amount is detected; this can be positive or negative.