Average Worked Hours

The Average Worked Hours entity provides the data columns that are necessary to measure the average number of hours worked by employees per week. This data allows managers to understand if employees who are designated as full-time or part-time” are actually working the appropriate number of hours on average over a defined period of time.

The entity provides two calculations of Average Weekly Hours. For both calculations, the application determines the Total Hours worked based on a standard combined pay code. Clients must configure this combined pay code (FTPT Contributing Pay Codes) with the other pay codes that they want to count towards this calculation.

The Total Hours value is then used to calculate Average Weekly Hours (All Weeks) and Average Weekly Hours (Worked Only). The All Weeks version is calculated as Totals Hours / Worked Weeks (All Weeks) where the system calculates the number of weeks by determining the days in the defined time period and dividing that by 7. Only complete weeks are counted.

The Worked Weeks version is calculated as Totals Hours / Worked Weeks (Worked Weeks) where the system calculates the number of weeks by first determining the days in the defined time period and dividing that by 7. It then includes only those weeks in which the employee has had a transaction using one of the pay codes configured in the FTPT Contributing Pay Codes combined pay code. Here too, only complete weeks are counted.

Employee Dataview Business Structure Dataview
X  

One row per employee.

Label Description Key

Average Weekly Hours (All Weeks)

 The average number of hours worked per week using a count of all weeks in the defined time period.

TK_FTPTDATA_ALL_AVG_WEEKLY_HOURS

Average Weekly Hours (Worked Only)

 The calculated average number of hours, determined by dividing Total Hours by Worked Weeks.

TK_FTPTDATA_WORKED_AVG_WEEKLY_HOURS

Total Hours

 The number of hours worked during the Worked Weeks. The hours are derived using a Combined Pay Code.

TK_FTPTDATA_HOURSWORKED

Worked Weeks (All Weeks)

 The count of weeks for the user's defined time period used for the calculation of Average Weekly Hours.

TK_FTPTDATA_ALL_NO_OF_WEEKS

Worked Weeks (Worked Only)

 The number of weeks during which the employee had hours in any of the pay codes contributing to the combined pay code that determines Total Hours, or the total number of weeks in the period, based on the selected report option.

TK_FTPTDATA_WORKED_NO_OF_WEEKS
Employee Organization Day Organizational Job Paycode Labor Category
X          
One-to-One One-to-Many
X