Sign Off

The Sign Off entity provides the data columns necessary to understand the status of, date of, and manager who performed the most recent sign-off action.

Data Granularity

Provides one row per employee per signed-off pay period.

Supported Dataview/RDO Type

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

Columns

Payroll Locked Through Date Time TK_PAYROLLLOCK_THRU_DATETIME DateTime No
Previous Period Signed Off Indicator TK_IS_PREVIOUS_PAYPERIOD_SIGNEDOFF Boolean No
Sign-Off Preparation Indicator TK_IS_IN_SIGN_OFF_PREPARATION Boolean No
Sign Off Date TK_SIGNOFF_PERFORMED_DATE Date No
Sign Off Hire Date TK_HIREDATE Date No
Sign Off Locked Through Date TK_SIGNOFFLOCK_THRU_DATETIME Date No
Sign Off Pending Indicator TK_IS_SIGNOFF_PENDING Boolean No
Signed Off By TK_SIGNOFF_BY String No
Signed Off Indicator TK_IS_VALID_SIGNOFF Boolean No
Signed Off Through Date TK_MANAGER_SIGNOFF_THRU_DATE Date No

Additional Info

  • The Sign Off Date column provides the date of the most recent sign-off that was applied to the employee's timecard
  • The Signed Off Indicator column and Previous Period Signed Off Indicator column are based on the selected time period or date range of the executed Dataview

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many