Worked Shift

The Worked Shift entity provides the start and end times of the actual shifts worked by employees. Data columns within the entity allow a user to determine if the shift is in progress and if the worked shift is from the employee's schedule. To view the Actual Totals (hours, wages, or days) related to a worked shift, along with the actual in-punch and out-punch times, use the Timecard Transactions entity.

Data Granularity

Provides one row per employee per worked shift.

Supported Dataview/RDO Type

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

Columns
Out Punch Comments TK_WSS_ENDPUNCH_COMMENTSNOTES_NAME String No
Worked Shift End Date Time TK_WSS_END_DATETIME DateTime No
Worked Shift End Date Time (Rounded) The rounded date and time of the employee's out punch TK_WSS_END_DATETIME_ROUNDED DateTime No
Worked Shift End Time Zone TK_WSS_END_TIMEZONE String No
Worked Shift From Schedule Indicator TK_WSS_ISFROMSCHEDULE Boolean No
Worked Shift In Progress Indicator TK_WSS_INPROGRESS Boolean No
Worked Shift Projected Indicator TK_WSS_ISPROJECTED Boolean No
Worked Shift Start Date Time TK_WSS_START_DATETIME DateTime No
Worked Shift Start Date Time (Rounded) The rounded date and time of the employee's in punch TK_WSS_START_DATETIME_ROUNDED DateTime No
Worked Shift Start Time Zone TK_WSS_START_TIMEZONE String No
Worked Span In Punch Comments TK_WSS_STARTPUNCH_COMMENTSNOTES_NAME String No
Worked Transaction Date Time TK_WSS_TRANSCATION_DATETIME DateTime No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many