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).

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Not applicable. Pay Period provides only dimensional data.

Columns

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

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X