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 Transactionsentity.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
|
X |
Data granularity
Add text
Columns
|
Label |
Description |
Key |
|---|---|---|
|
Out Punch Comments | Comments added to out punches |
TK_WSS_ENDPUNCH_COMMENTSNOTES_NAME |
|
Worked Shift End Date Time | The date and time the Worked Shift ended. |
TK_WSS_END_DATETIME |
|
Worked Shift End Date Time (Rounded) |
The rounded date and time of the employee’s out punch. |
TK_WSS_END_DATETIME_ROUNDED |
|
Worked Shift End Time Zone | The time zone in which the Worked Shift ended. |
TK_WSS_END_TIMEZONE |
|
Worked Shift From Schedule Indicator | Indicates if the worked shift deviates from the original scheduled shift. |
TK_WSS_ISFROMSCHEDULE |
|
Worked Shift In Progress Indicator | Indicates if the shift is currently in progress. |
TK_WSS_INPROGRESS |
|
Worked Shift Projected Indicator | The projection of the expected worked hours for a shift based on historical data and scheduling patterns. |
TK_WSS_ISPROJECTED |
|
Worked Shift Start Date Time | The date and time the Worked Shift started. |
TK_WSS_START_DATETIME |
|
Worked Shift Start Date Time (Rounded) |
The rounded date and time of the employee’s in punch. |
TK_WSS_START_DATETIME_ROUNDED |
|
Worked Shift Start Time Zone | The time zone in which the Worked Shift started. |
TK_WSS_START_TIMEZONE |
|
Worked Span In Punch Comments | Comments added to a worked span within a shift. |
TK_WSS_STARTPUNCH_COMMENTSNOTES_NAME |
|
Worked Transaction Date Time | The exact date and time of each transaction for an employee's worked shift. |
TK_WSS_TRANSCATION_DATETIME |
Related entities
Core entity
|
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
|---|---|---|---|---|---|
|
X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
X |