Target Hours

The Target Hours entity provides data related to the use of the target hours, or averaging, functionality. Target hours allow managers to see the variance between the target hours as defined in an employee's Employment Terms and the actual hours that the employee worked. The data columns in the Target Hours entity provide the same data that is available through the Target Hours add-on available in the timecard editor.

Data Granularity

Provides one row per employee per work hours definition in the employee's assigned Employment Terms.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Actual Hours TK_AVG_ACTUAL_AMOUNT Number No
Actual Through Selected Day TK_AVG_ACTUAL_THROUGH_SELECTED_DAY_HOURS Number No
Date Pattern Name TK_AVG_DATEPATTERN_TYPE String No
Include In Averaging Dataview TK_AVG_INCLUDE_IN_DATAVIEW Boolean No
Projected Hours TK_AVG_PROJECTED_HOURS Number No
Target Hours TK_AVG_TARGET_AMOUNT Number No
Target Hours Reporting Period TK_AVG_AVG_REPORTING_PERIOD Number No
Target Hours Source TK_AVG_AMOUNT_FROM String No
Target Through Selected Day TK_AVG_TARGET_THROUGH_SELECTED_DAY_HOURS Number No
Variance (Actual - Target Through Selected Day) TK_AVG_VAR_ACTUAL_HOURS_MINUS_TARGET_THROUGH_SELECTED_DAY_HOURS Number No
Variance (Actual Through Selected Day - Target Hours) TK_AVG_ACTUAL_THROUGH_SELECTED_DAY_HOURS_MINUS_AVG_TARGET_HOURS Number No
Variance (Projected Hours - Target Hours) TK_AVG_VAR_PROJECTED_HOURS_MINUS_TARGET_HOURS Number No
Variance (Target Hours - Actual Hours) TK_AVG_VARIANCE Number No
Variance (Target Hours - Actual Through Selected Day) TK_AVG_AVG_TARGET_HOURS_MINUS_ACTUAL_THROUGH_SELECTED_DAY_HOURS Number No
Variance (Target Hours - Actual Through Selected Day) TK_AVG_VAR_TARGET_HOURS_MINUS_ACTUAL_THROUGH_SELECTED_DAY_HOURS Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many