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

Employment 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

12

hireSource

employmentDetails.hireSource

string

13

companyName

employmentDetails.companyName

string

14

employeeID

employmentDetails.employeeID

string

15

jobDescription

employmentDetails.jobDescription

string

16

primaryJobCode

employmentDetails.primaryJobCode

string

17

lastHireDate

employmentDetails.lastHireDate

string

18

fullTimeOrPartTimeCode

employmentDetails.fullTimeOrPartTimeCode

string

19

primaryWorkLocationCode

employmentDetails.primaryWorkLocationCode

string

20

languageCode

employmentDetails.languageCode

string

21

primaryProjectCode

employmentDetails.primaryProjectCode

string

22

workPhoneNumber

employmentDetails.workPhoneNumber

string

23

dateInJob

employmentDetails.dateInJob

string

24

dateLastWorked

employmentDetails.dateLastWorked

string

25

dateOfBenefitSeniority

employmentDetails.dateOfBenefitSeniority

string

26

dateOfSeniority

employmentDetails.dateOfSeniority

string

27

employeeTypeCode

employmentDetails.employeeTypeCode

string

28

employeeNumber

employmentDetails.employeeNumber

string

29

jobTitle

employmentDetails.jobTitle

string

30

supervisorID

employmentDetails.supervisorID

string

31

dateOfEarlyRetirement

employmentDetails.dateOfEarlyRetirement

string

32

dateOfRetirement

employmentDetails.dateOfRetirement

string

33

dateOfSuspension

employmentDetails.dateOfSuspension

string

34

dateOfTermination

employmentDetails.dateOfTermination

string

35

jobGroupCode

employmentDetails.jobGroupCode

string

36

okToRehire

employmentDetails.okToRehire

string

37

positionCode

employmentDetails.positionCode

string

38

termType

employmentDetails.termType

string

39

supervisorEmployeeNumber

employmentDetails.supervisorEmployeeNumber

string

40

supervisorCOID

employmentDetails.supervisorCOID

string

41

supervisorCompanyCode

employmentDetails.supervisorCompanyCode

string

Employment Job History

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

employmentJobHistoryDetails.<attributeName>

The following employment related attributes are supported:

Serial Number

Employment Job History Detail

Corresponding User-Defined Schema Attribute

Type

1

isJobChange

employmentJobHistoryDetails.isJobChange

Boolean

2

fullTimeOrPartTime

employmentJobHistoryDetails.fullTimeOrPartTime

string

3

isOrgchange

employmentJobHistoryDetails.isOrgchange

Boolean

4

isOutsideGuidelines

employmentJobHistoryDetails.isOutsideGuidelines

Boolean

5

isOutsideRange

employmentJobHistoryDetails.isOutsideRange

Boolean

6

isSystem

employmentJobHistoryDetails.isSystem

Boolean

7

isTransfer

employmentJobHistoryDetails.isTransfer

Boolean

8

jobDescription

employmentJobHistoryDetails.jobDescription

string

9

jobEffectiveDate

employmentJobHistoryDetails.jobEffectiveDate

string

10

jobGroupCode

employmentJobHistoryDetails.jobGroupCode

string

11

locationCode

employmentJobHistoryDetails.locationCode

string

12

orgLevel1Code

employmentJobHistoryDetails.orgLevel1Code

string

13

orgLevel2Code

employmentJobHistoryDetails.orgLevel2Code

string

14

orgLevel3Code

employmentJobHistoryDetails.orgLevel3Code

string

15

orgLevel4Code

employmentJobHistoryDetails.orgLevel4Code

string

16

piecePayRate

employmentJobHistoryDetails.piecePayRate

string

17

positionCode

employmentJobHistoryDetails.positionCode

string

18

reasonCode

employmentJobHistoryDetails.reasonCode

string

19

shiftCode

employmentJobHistoryDetails.shiftCode

string

20

shiftGroupCode

employmentJobHistoryDetails.shiftGroupCode

string

21

supervisorNameFirst

employmentJobHistoryDetails.supervisorNameFirst

string

22

supervisorNameLast

employmentJobHistoryDetails.supervisorNameLast

string

23

supervisorNameSuffix

employmentJobHistoryDetails.supervisorNameSuffix

string

24

supervisorNotInList

employmentJobHistoryDetails.supervisorNotInList

Boolean

25

systemId

employmentJobHistoryDetails.systemId

string

26

integrationEffectiveDate

employmentJobHistoryDetails.integrationEffectiveDate

string

27

projectCode

employmentJobHistoryDetails.projectCode

string

28

jobTitle

employmentJobHistoryDetails.jobTitle

string