Pay Period
The Pay Period entity provides the data columns necessary to understand the start and end date for the previous, current, and next pay periods. The length of the pay period is defined by an employee’s assigned pay rule.
Note that the previous, current, and next pay periods are always based on the current date and not on a selected time frame (for example, you cannot look back three weeks in history and extract data for the current pay period at that time).

Employee Dataview | Business Structure Dataview |
---|---|
X |

Not applicable. Pay Period provides only dimensional data.

Label | Description | Key |
---|---|---|
Current Pay Period End Date |
The date when the current pay period ends. |
TK_CURR_PAYPERIOD_ENDDATE |
Current Pay Period Start Date |
The date when the current pay period starts. |
TK_CURR_PAYPERIOD_STARTDATE |
Next Pay Period End Date |
The date when the next pay period ends. |
TK_NEXT_PAYPERIOD_ENDDATE |
Next Pay Period Start Date |
The date when the next pay period starts. |
TK_NEXT_PAYPERIOD_STARTDATE |
Previous Pay Period End Date |
TK_PREV_PAYPERIOD_ENDDATE |
|
Previous Pay Period Sign Off Indicator | TK_PREV_PAYPERIOD_SIGNEDOFF | |
Previous Pay Period Start Date |
TK_PREV_PAYPERIOD_STARTDATE |

- Absence Exceptions
- Accrual Code
- Accrual Daily Balances
- Accrual Reporting Period Balances
- Accrual Transactions
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Actual Totals Corrections Only
- Actual Totals Exclude Corrections
- Actual Totals Include Corrections
- Analytics
- Approval Summary
- Approval Transactions
- Attendance Actions Summary
- Attendance Summary
- Attendance Transactions
- Audit
- Audit Attendance
- Audit Leave
- Audit Timekeeping
- Average Worked Hours
- Employee Details
- Exception Counter
- Exceptions
- Group Edit Results
- Leave Case
- Leave Case Document
- Leave Case Note
- Leave Case Notification
- Leave Edit
- Leave Profile
- Leave Taking
- License Assignment
- Paycode Edit
- Paycode Edit Comments
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Projected Totals Corrections Only
- Projected Totals Exclude Corrections
- Projected Totals Include Corrections
- Schedule Availability
- Schedule Day Lock
- Schedule Event Shift
- Schedule Events
- Schedule Events Pay Code Edit
- Schedule Group Assignment
- Schedule Group Totals
- Schedule Segment Availability
- Schedule Tag
- Schedule Tag Segment
- Scheduled Paycode Edit
- Scheduled Paycode Totals
- Scheduled Shift
- Scheduled Shift Segment
- Scheduled Totals
- Shift Segment Tag
- Sign Off
- Target Hours
- Timecard Transactions
- Totalization Status
- Worked Shift
- Worked Span
- Worked Span In Punch
- Worked Span Out Punch

Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
---|---|---|---|---|---|
X |

One-to-One | One-to-Many |
---|---|
X |