UKG Pro Workforce Management

UKG Pro Workforce Management (WFM, formerly Kronos) is a timekeeping, scheduling and attendance platform. Replicating it into your data cloud lets analytics teams report on hours worked, schedules, time off, accruals and attendance alongside the rest of your workforce data.

Setup Instructions

Follow the setup steps guide for configuring your UKG Pro Workforce Management connection to enable data to flow into your destination via DLH.

Supported Features

Here are key features supported for this connector.

Sync Feature	Supported	Details
Custom Data and Development	✓	Ability to enhance connector upon request
Historical Re-Load/Load	✓
Incremental/Delta Load	✓	Recent timecards, schedules, time off and attendance are re-read
Column Selection	✓
Column Hashing	✓
Re-Sync Table/Entity	✓	Select at the table level to reload data history (on next Sync Bridge run)
Custom Queries		Utilizing SQL Data Query Connector
Custom Data
Captures Deleted Rows		Not captured automatically (use a historical re-sync)
API Sync Bridge Initiation	✓
Priority Scheduling	✓
Private VPC/Link	☂
DLH Data Model Available	-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

This connection is read only and never writes data back to UKG Pro Workforce Management. Be sure to also check the change log and notes page from time to time for any changes.

The first synchronization reads every table from the historical start date. Without a Historical Start Date, the first synchronization reads the last two years.
After that, timecards, schedules, time off and attendance are read again for the last 14 days on every run, because UKG allows edits until the pay period is signed off. To change the 14 day window, contact DLH.io support.
Schedules and time off are also read 30 days ahead.
People and setup tables are read in full on every run.
Employees terminated within the synchronized period are included.

Issue Handling

If any issues occur with the connection simply return to the sources page in DLH.io, edit the source details and click the Save & Test button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.

Replicated Entities

The following 52 entities are replicated by default to your Target Connection. These are the table names you will see in your Target Connection. If you believe any entities/tables are missing please open a ticket with Customer Support:

PERSONS
PERSON_EMPLOYMENT_STATUSES
PERSON_ACCOUNT_STATUSES
PERSON_PRIMARY_JOB_ACCOUNTS
PERSON_CUSTOM_DATA
PERSON_DATES
PERSON_TIMEKEEPING
PERSON_BASE_WAGES
PERSON_PAY_RULES
PERSON_SCHEDULING
PERSON_ACCRUAL_PROFILES
SUPERVISOR_ASSIGNMENTS
DEVICES
DEVICE_GROUPS
DEVICE_GROUP_DEVICES
DEVICE_STATUS
PAY_CODES
LABOR_CATEGORIES
COST_CENTERS
LOCATIONS
HYPERFIND_QUERIES
SCHEDULE_PATTERNS
SCHEDULE_PATTERN_ITEMS
ACCRUAL_CODES
ACCRUAL_PROFILES
EMPLOYMENT_TERMS
HOLIDAYS
WORK_RULES
TIMECARD_PUNCHES
TIMECARD_WORKED_SHIFTS
TIMECARD_PAYCODE_EDITS
TIMECARD_EXCEPTIONS
TIMECARD_SCHEDULE_SHIFTS
TIMECARD_PROCESSED_SEGMENTS
TIMECARD_HOLIDAY_CREDITS
TIMECARD_HISTORICAL_CORRECTIONS
TIMECARD_DAILY_TOTALS
TIMECARD_ACTUAL_TOTALS
TIMECARD_SCHEDULED_TOTALS
ACCRUAL_TRANSACTIONS
ACCRUAL_BALANCES
SCHEDULE_SHIFTS
SCHEDULE_PAYCODE_EDITS
SCHEDULE_LEAVE_EDITS
TIME_OFF_REQUESTS
TIME_OFF_REQUEST_PERIODS
TIME_OFF_REQUEST_STATUS_CHANGES
SCHEDULE_CHANGES
EMPLOYMENT_TERMS_SCHEDULE_CHANGES
ATTENDANCE_BALANCES
PERFECT_ATTENDANCE_TRANSACTIONS
ATTENDANCE_EVENTS

Schema Details (ER Diagram)

This entity relationship diagram (ERD) provides you with information about what entities/tables DLH provides for you out-of-the-box and how they are related to one another.