Actual & Schedule Shift Times

The Actual & Schedule Shift Times entity allows users to create a Dataview or report that lists the actual and scheduled punch times for all shifts for all employees returned as a single row for each shift assigned to an employee. The Actual Shift Start and Actual Shift End columns will include projected punches for Pay From Schedule employees.

Data Granularity

Provides one row for each punch time for each shift per employee.

Supported Dataview/RDO Type

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

Columns


Actual Shift End Date Time (Raw)	Actual end date and time of the employee's shift.	TKSHIFT_ACTUAL_END_DATETIME	DateTime	No
Actual Shift End Date Time (Rounded)	Actual end date and rounded end time of the employee's shift.	TKSHIFT_ACTUAL_END_DATETIME_ROUNDED	DateTime	No
Actual Shift Start Date Time (Raw)	Actual start date and time of the employee's shift.	TKSHIFT_ACTUAL_START_DATETIME	DateTime	No
Actual Shift Start Date Time (Rounded)	Actual start date and rounded start time of the employee's shift.	TKSHIFT_ACTUAL_START_DATETIME_ROUNDED	DateTime	No
Scheduled Shift End Date Time	Scheduled end date and time of the employee's shift.	TKSHIFT_SCHED_END_DATETIME	DateTime	No
Scheduled Shift Start Date Time	Scheduled start date and time of the employee's shift.	TKSHIFT_SCHED_START_DATETIME	DateTime	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many