Synced data from ADP
ο»ΏPackages: Basic | Headcount Planning | ο»ΏCompensation Reviews | ο»ΏPerformance | ο»ΏEngagement ο»Ώ
The following table lists the default data set synced from ADP to ChartHop.
ChartHop customers can work with ChartHop implementation services to customize what is synced.
You must include the country code as a part of any international number for it to be recognized as such within ChartHop. When you are syncing phone numbers from an external system, such as a payroll system or ATS, be sure the country code is included in the phone number that is listed in the external system. This also applies when updating data through a spreadsheet.
ChartHop field label | ChartHop field code | ADP field code |
|---|---|---|
Base | base | workers.workAssignment.baseRemuneration.payPeriodRateAmount.amountValue, workers.workAssignment.baseRemuneration.payPeriodRateAmount.currencyCode, workers.workAssignment.baseRemuneration.hourlyRateAmount.amountValue, workers.workAssignment.baseRemuneration.hourlyRateAmount.currencyCode, workers.workAssignment.payCycleCode.codeValue |
Birth Date | birthdate | workers.person.birthDate |
City - Home Address | address.city | workers.person.legalAddress.cityName |
Company | company | workers.workAssignment |
Country - Home Address | address.country | workers.person.legalAddress.countryCode |
Currency | currency | workers.workAssignment.baseRemuneration.payPeriodRateAmount.amountValue, workers.workAssignment.baseRemuneration.payPeriodRateAmount.currencyCode, workers.workAssignment.baseRemuneration.hourlyRateAmount.amountValue, workers.workAssignment.baseRemuneration.hourlyRateAmount.currencyCode, workers.workAssignment.payCycleCode.codeValue |
Date | date | workers.workAssignment.actualStartDate, workers.workAssignment.terminationDate, workers.workAssignment.baseRemuneration.effectiveDate |
Depart | depart | workers.workAssignment.terminationDate, workers.workAssignment.assignmentStatus.reasonCode.codeValue, workers.workAssignment.voluntaryIndicator |
Department | department | workers.workAssignment |
Employment | employment | workers.workAssignment.workerTypeCode.codeValue |
Ethnicity | ethnicity | workers.person.raceCode.codeValue |
First Name | name.first | workers.person.legalName.givenName |
Gender | gender | workers.person.genderCode.codeValue |
Home Email | contact.homeemail | workers.person.communication.emails[0].emailUri |
Home Phone | contact.homephone | workers.person.communication.landlines[0].formattedNumber |
Hourly | hourly | workers.workAssignment.baseRemuneration.payPeriodRateAmount.amountValue, workers.workAssignment.baseRemuneration.payPeriodRateAmount.currencyCode, workers.workAssignment.baseRemuneration.hourlyRateAmount.amountValue, workers.workAssignment.baseRemuneration.hourlyRateAmount.currencyCode, workers.workAssignment.payCycleCode.codeValue |
Last Name | name.last | workers.person.legalName.familyName1 |
Location | location | workers.workAssignment.homeWorkLocation.nameCode.shortName |
Manager | manager | workers.workAssignment.reportsTo[0].workerID.idValue |
Middle Name | name.middle | workers.person.legalName.middleName |
Mobile | contact.mobilephone | workers.businessCommunication.mobiles[0].formattedNumber, workers.person.communication.mobiles[0].formattedNumber |
Preferred First Name | name.pref | workers.person.legalName.nickName |
Start Date | startdate | workers.workerDates.rehireDate, workers.workerDates.originalHireDate |
State - Home Address | address.state | workers.person.legalAddress.countrySubdivisionLevel1.codeValue |
Street 1 - Home Address | address.street1 | workers.person.legalAddress.lineOne |
Street 2 - Home Address | address.street2 | workers.person.legalAddress.lineTwo |
Street 3 - Home Address | address.street3 | workers.person.legalAddress.lineThree |
Title | title | workers.workAssignment.jobCode.longName, workers.workAssignment.jobCode.shortName |
Work Email | contact.workemail | workers.businessCommunication.emails[0].emailUri |
Work Fax | contact.workfax | workers.businessCommunication.faxes[0].formattedNumber |
Work Phone | contact.workphone | workers.businessCommunication.landlines[0].formattedNumber |
Zip/Postal - Home Address | address.postal | workers.person.legalAddress.postalCode |
Used to store profile photos | imageurl | workers.photos[0].links[0].href |
Hourly compensation rate calculations
To calculate hourly compensation, the following fields are used from ADP and are translated to ChartHop codenames:
ChartHop codename | ADP field code |
|---|---|
baseAmount | workers.workAssignment.baseRemuneration.payPeriodRateAmount.amountValue |
baseCurrency | workers.workAssignment.baseRemuneration.payPeriodRateAmount.currencyCode |
hourlyAmount | workers.workAssignment.baseRemuneration.hourlyRateAmount.amountValue |
hourlyCurrency | workers.workAssignment.baseRemuneration.hourlyRateAmount.currencyCode |
(As in ADP) | workers.workAssignment.payCycleCode.codeValue |
ChartHop uses a multiplier to correspond to the number of pay periods for a given employee.Β Below are the codes ChartHop receives from ADP and the multipliers it maps to them:
- M - 12 (monthly)
- S - 24 (semi-monthly)
- B - 26 (bi-weekly)
ChartHop first checks if baseAmount is provided.Β If so, it takes that value and times it by the given multiplier to determine a given employeeβs salary.Β
If baseAmount isnβt provided, ChartHop checks hourlyAmount and sets it to its hourly field.Β
ChartHop also grabs either baseCurrency or hourlyCurrency depending on whether baseAmount or hourlyAmount is provided and uses that value to set its currency field.