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.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
| X |
Data granularity
One row per employee.
Columns
| 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 |
Related entities
- Absence Exceptions
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Approval Summary
- Employee Details
- Exception Counter
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Scheduled Paycode Totals
- Sign Off
- Totalization Status
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
|
One-to-One | One-to-Many |
|---|---|
| X |