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.

Employee Dataview Business Structure Dataview
X  

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

Label Key

Actual Hours

TK_AVG_ACTUAL_AMOUNT

Actual Through Selected Day

TK_AVG_ACTUAL_THROUGH_SELECTED_DAY_HOURS

Date Pattern Name

TK_AVG_DATEPATTERN_TYPE
Include In Averaging Dataview TK_AVG_INCLUDE_IN_DATAVIEW

Projected Hours

TK_AVG_PROJECTED_HOURS

Target Hours

TK_AVG_TARGET_AMOUNT

Target Hours Reporting Period

TK_AVG_AVG_REPORTING_PERIOD

Target Hours Source

TK_AVG_AMOUNT_FROM

Target Through Selected Day

TK_AVG_TARGET_THROUGH_SELECTED_DAY_HOURS

Variance (Actual - Target Through Selected Day)

TK_AVG_VAR_ACTUAL_HOURS_MINUS_TARGET_THROUGH_SELECTED_DAY_HOURS

Variance (Actual Through Selected Day - Target Hours)

TK_AVG_ACTUAL_THROUGH_SELECTED_DAY_HOURS_MINUS_AVG_TARGET_HOURS

Variance (Projected Hours - Target Hours)

TK_AVG_VAR_PROJECTED_HOURS_MINUS_TARGET_HOURS

Variance (Target Hours - Actual Hours)

TK_AVG_VARIANCE

Variance (Target Hours - Actual Through Selected Day)

TK_AVG_AVG_TARGET_HOURS_MINUS_ACTUAL_THROUGH_SELECTED_DAY_HOURS

Variance (Target Hours - Actual Through Selected Day)

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