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.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

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

Columns

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

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X