Synced data from ADP
The following table lists the default data set synced from ADP to ChartHop.
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.
