ADP Schema of Integration Data

The integration data schema defines the structure of the data imported by the ADP integration. The primary data model entity is the Account. Worker Demographic records are retrieved from the ADP system as the authoritative source during the integration data aggregation process. These worker records are then normalized and mapped to Account objects within the ADP integration data model. The schema of account additional properties is presented in the table below. Custom properties are not listed below can be added on an ad hoc basis.

Within the integration interface, aggregated accounts can be accessed at: ObserveID > Identity Automation > Integrations > {specific ADP integration} > Accounts

Account Property

Type

Description

AssociateOID

String

 

WorkerID

String

 

LegalName

String

 

FirstName

String

 

MiddleName

String

 

LastName

String

 

Salutation

String

 

PreferredName

String

 

City

String

 

Country

String

 

HomePhoneNumber

String

 

WorkPhoneNumber

String

 

PersonalEmail

String

 

WorkerStatus

String

 

WorkEmail

String

 

AssignmentId

String

 

AssignmentStatus

String

 

AssignmentType

String

 

AssignmentJobCode

String

 

AssignmentJobTitle

String

 

AssignmentPostitionId

String

 

AssignmentBusinessUnit

String

 

AssignmentDepartment

String

 

AssignedDepartment

String

 

AssignedBusinessUnit

String

 

ManagerId

String

 

ManagerName

String

 

EmployeeWorkingCategory

String

 

CompanyCode

String

 

HireDate

DateTime

 

TerminationDate

DateTime

 

AssignmentStartDate

DateTime

 

AssignmentEndDate

DateTime