How average service hours are calculated using an as-of date

There are two main factors that contribute to an employee’s average service hours:

  • The amount of paid time the employee has recorded
  • The period of time over which the employee has recorded those hours

The Affordable Care Act determines full-time status exclusively on whether the employee has worked an average of 30 hours per week or 130 hours per month over a pre-defined measurement period. Organizations may also want to review average service hours before a measurement period has concluded. Interrogating an employee’s averages mid-period provides organizations with opportunities to alter an employee’s full time status before the conclusion of the official period. To facilitate mid-period measurement, the application provides users with the ability to specify an “as-of date”. The as-of date lets Workforce Management calculate and display employee average hours for a mid-period measurement.

For example, an employee is currently in the midst of a year-long measurement period spanning from 1/4/2015 to 1/3/2016. Calculating this employee’s average service hours over the entire measurement period means averaging the employee’s total service hours over 52 weeks. Instead, administrators, schedulers, and other power users may want to see an employee’s average service hours for today’s date, or as-of any other mid-period date.

The as-of date reduces the denominator that is used to calculate average service hours. Continuing the example, if a user specifies a date of 01/25/2015, the system considers only those service hours that are recorded between 01/04/2014 and 01/25/2015 and averages those hours over that period. In this example, over 3 weeks instead of 52.