UKG Employee Sync
Sync your employee roster from UKG and FastQuery keeps user accounts up to date automatically — new hires get invited, transfers move to the right facility, and departures are cleaned up. No more managing accounts by hand.
How It Works
Section titled “How It Works”You schedule an export in UKG that pushes your employee roster as a CSV file to FastQuery’s secure SFTP server. FastQuery processes each file as it arrives:
- New employees get a FastQuery account and an email invitation.
- Transfers are reassigned to the facility matching their store code.
- Departures — sync-managed employees missing from the file are marked for removal and deleted after a 7-day grace period. Users you created manually are never touched by the sync.
SFTP Connection Details
Section titled “SFTP Connection Details”Configure the scheduled export in UKG with these connection settings. FastQuery creates the Username and Password for you on the UKG integration page.
| Setting | Value |
|---|---|
| Protocol | SFTP |
| Host | ftp.fastquery.app |
| Port | 49152 |
| Username | (shown on the Integrations page) |
| Password | (created on the Integrations page) |
Your SFTP Password
Section titled “Your SFTP Password”FastQuery creates this password for you. You do not choose one.
- Log into FastQuery and go to Settings > Integrations.
- Find UKG in the list of providers and click it.
- Click Create SFTP credentials. FastQuery shows your username and password.
- Copy the password into your UKG scheduled export.
Come back to this page at any time and click Reveal password to read it again.
If your password was set before FastQuery issued them
Section titled “If your password was set before FastQuery issued them”FastQuery cannot show a password that you chose yourself in the past. We kept only a one-way check of it, never the password. Your export keeps working, so there is nothing to fix.
To get a password you can read back, click Create new password. The old password stops working immediately, so update your UKG export at the same time.
CSV Format
Section titled “CSV Format”Your export must include these exact column names (headers are case-insensitive):
| Column | Required | Description |
|---|---|---|
| Yes | Employee email | |
| name | Yes | First name |
| surname | Yes | Last name |
| store | Yes | FastQuery location ID |
| title | No | Job title |
A few things to know:
- The store value must match a FastQuery location ID exactly — that’s how each employee lands in the right facility.
- Export active employees only. The sync treats the file as the full roster, so anyone missing is considered departed.
- Employees without an email or a name are skipped.
- The job title is stored on the person’s profile. Every new account starts with the user role. When a new employee’s title looks managerial, a warning on the integration page names them, so you can give them a different role on the Manage Users page. Role changes you make in FastQuery are never overwritten while the person stays on the roster. Someone who leaves the roster and is removed, then returns later, starts again with the user role.
Headquarters Staff
Section titled “Headquarters Staff”If your roster includes corporate or office staff under a store code that has no matching FastQuery location, enter that code under Headquarters codes on the UKG integration page. FastQuery routes those people to your Headquarters facility instead of skipping them.
Monitoring
Section titled “Monitoring”The Integrations page shows a log of recent sync events — files received, accounts created, and any rows that were skipped and why. If a sync looks wrong, check the event log first: the most common cause is a store code that doesn’t match any FastQuery location ID.