Aggregate Additional Employee Schema Attributes

Aggregate additional, predefined employee attributes from the UKG Pro Core HCM source. After aggregation, these attributes are added to the default employee schema attributes in the connector's account schema. The additional attributes you can aggregate are related to an employee's primary job configuration, organizational level, and location. The connector can aggregate properly configured attributes from the UKG Pro Core HCM schema.

Primary Job Functions

To aggregate an employee's primary job related details, create a primary job function attribute in the UKG Pro Core HCM schema by adding the attribute name with job. as the prefix. The syntax is as follows:

job.<attributeName>

The following primary job related functions are supported:

Note
The prefix and user-defined schema attribute name are case-sensitive.

Serial Number

Job Detail

Corresponding User-Defined Schema Attribute

Type

1

jobCode

job.jobCode

string

2

countryCode

job.countryCode

string

3

title

job.title

string

4

isActive

job.isActive

Boolean

5

jobFamilyCode

job.jobFamilyCode

string

6

longDescription

job.longDescription

string

7

jobEEOCategory

job.jobEEOCategory

string

8

jobGroup

job.jobGroup

string

9

flsaTypeCode

job.flsaTypeCode

string

Organization Level

To aggregate an employee's organization level (1/2/3/4) details, create an organization level attribute in the UKG Pro Core HCM schema by adding the attribute name with orgLevel<level>. as the prefix. Replace <level> with the employee's actual organizational level. The syntax is as follows:

orgLevel<level>.<attributeName>

For example:

orgLevel1.lastYearBudgetSalary

orgLevel3.longDescription

The following organization level related attributes are supported:

Note
The prefix and user-defined schema attribute name are case-sensitive.

Serial Number

Organization Level Detail

Corresponding User-Defined Schema Attribute

Type

1

budgetGroup

orgLevel<level>.budgetGroup

string

2

code

orgLevel<level>.code

string

3

currentYearBudgetFTE

orgLevel<level>.currentYearBudgetFTE

string

4

currentYearBudgetSalary

orgLevel<level>.currentYearBudgetSalary

string

5

description

 orgLevel<level>.description

string

6

glSegment

orgLevel<level>.glSegment

string

7

isActive

orgLevel<level>.isActive

Boolean

8

lastYearBudgetSalary

orgLevel<level>.lastYearBudgetSalary

string

9

level

orgLevel<level>.level

string

10

levelDescription

orgLevel<level>.levelDescription

string

11

reportingCategory

orgLevel<level>.reportingCategory

string

Work Location

To aggregate an employee's work location details, create work location attributes in the UKG Pro Core HCM schema by adding the attribute name with workLocation. as the prefix. The syntax is as follows:

workLocation.<attributeName>

The following work location related attributes are supported:

Note
The prefix and user-defined schema attribute name are case-sensitive.

Serial Number

Work Location Detail

Corresponding User-Defined Schema Attribute

Type

1

locationCode

workLocation.locationCode

string

2

description

workLocation.description

string

3

isActive

workLocation.isActive

Boolean

4

addressLine1

workLocation.addressLine1

string

5

addressLine2

workLocation.addressLine2

string

6

city

workLocation.city

string

7

state

workLocation.state

string

8

zipOrPostalCode

workLocation.zipOrPostalCode

string

9

countryCode

workLocation.countryCode

string

10

locationGLSegment

workLocation.locationGLSegment

string

Employment

To aggregate an employee's employment details, create employment related attributes in the UKG Pro Core HCM schema by adding the attribute name with employmentDetails. as the prefix. The syntax is as follows:

employmentDetails.<attributeName>

The following employment related attributes are supported:

Note
The prefix and employment schema attribute name are case-sensitive.

Serial Number

Work Location Detail

Corresponding User-Defined Schema Attribute

Type

1

leaveReasonCode

employmentDetails.leaveReasonCode

string

2

leaveReasonDescription

employmentDetails.leaveReasonDescription

string

3

companyCode

employmentDetails.companyCode

string

4

workPhoneExtension

employmentDetails.workPhoneExtension

string

5

workPhoneCountry

employmentDetails.workPhoneCountry

string

6

jobChangeReasonCode

employmentDetails.jobChangeReasonCode

string

7

supervisorFirstName

employmentDetails.supervisorFirstName

string

8

supervisorLastName

employmentDetails.supervisorLastName

string

9

isMultipleJob

employmentDetails.isMultipleJob

string

10

termReason

employmentDetails.termReason

string

11

terminationReasonDescription

employmentDetails.terminationReasonDescription

string