Synced data from ADP
Packages: Basic | Standard | Premium
The following table lists the default data set synced from ADP to ChartHop.
ChartHop Premium and ChartHop Standard 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 |
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.
