Saved Report Specifications

Connect to AD uses the UKG Ready saved reports API to read data that will be synced to [target-system].

The saved report columns are then mapped to the corresponding attributes in [target-system] through the Field Mapping section of Connect to AD.

For a successful synchronization, please follow these two crucial steps when configuring the Saved Report:

Always include the Employee ID, Account ID, and Employee Status columns.
Include additional columns containing data you wish to synchronize. These columns must precisely match the naming conventions found in this article, which are case-sensitive.

The Employee Id and Account Id columns act as unique identifiers. They allow Connect to AD to match user records between UKG and [target-system] and must be on the saved report alongside the Employee Status column.

Person

These report fields will appear under the Person category in the field mapping selector.

Account Id (required)
Created
First Name
Last Name
Display Name (rename from Employee Name)
Cell Phone
Cell Phone Code
Home Phone
Home Phone Code
Work Phone
Work Phone Code
Primary Email
Secondary Email
Personal Email
SSN (rename from SS#)
Username
Preferred Pronoun
Primary Language
Address 1
Address 2
Address 3
Address City
Address Country
Address County
Address Line 1
Address Line 2
Address Line 3
Address State
Address Zip Code
City
State
County
Country
Zip Code
Locked
Nickname
Employee Suffix
Security Profile

Employment

These report fields will appear under the Employment category in the field mapping selector.

Employee Status
Manager Employee Id (rename from Manager 1 Employee Id)
Manager Name (rename from Manager 1 Name)
Office (rename from another field)
Job Title (rename from another field)
Department (rename from another field)
Company (rename from Company: Name or Company: DBA Name)
Pay Grade
Pay Type
Worker Type
Employee Type
Date Started
Date Hired
Date Re-Hired
Date Terminated

Company

These report fields will appear under the Company category in the field mapping selector.

Company Name
Company Address 1 (rename from Company: Address 1)
Company Address 2 (rename from Company: Address 2)
Company City (rename from Company: City)
Company State (rename from Company: State)
Company Zip (rename from Company: Zip)

Custom

These report fields will appear under the Custom category in the field mapping selector.

In addition to the standard columns, Connect to AD allows you to include up to 10 custom string fields and 5 custom date fields.

To use these, simply rename any report column to match the following values:

String Field 1
String Field 2
String Field 3
String Field 4
String Field 5
String Field 6
String Field 7
String Field 8
String Field 9
String Field 10
Date Field 1
Date Field 2
Date Field 3
Date Field 4
Date Field 5

This article is exclusively for UKG Ready.

Saved Report Specifications

Was this article helpful?

Comments