Synced data from BambooHR
The table below lists the default data set that is synced from BambooHR 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.
Fields list
ChartHop field label | ChartHop field code | BambooHR field code |
|---|---|---|
Base | base | compensation.rate.value, compensation.type, compensation.paidPer, compensation.payPer |
Birth Date | birthdate | customReport.dateOfBirth |
City - Home Address | address.city | customReport.city |
Country - Home Address | address.country | customReport.country |
Currency | currency | compensation.rate.currency |
Date | date | employmentStatus.date, jobInfo.date, compensation.startDate, timeOff.start |
Depart | depart | employmentStatus.terminationTypeId |
Department | department | jobInfo.department |
Employment | employment | employmentStatus.employmentStatus |
Ethnicity | ethnicity | customReport.ethnicity |
First Name | name.first | customReport.firstName |
Gender | gender | customReport.gender |
Home Email | contact.homeemail | customReport.homeEmail |
Home Phone | contact.homephone | customReport.homePhone |
Hourly | hourly | compensation.rate.value, compensation.type, compensation.paidPer, compensation.payPer |
Last Name | name.last | customReport.lastName |
Location | location | jobInfo.location |
Manager | manager | customReport.supervisorEId, jobInfo.reportsTo |
Middle Name | name.middle | customReport.middleName |
Mobile | contact.mobilephone | customReport.mobilePhone |
Preferred First Name | name.pref | customReport.preferredName |
Promotion | promotion | compensation.reason |
State - Home Address | address.state | customReport.stateCode, customReport.state |
Street 1 - Home Address | address.street1 | customReport.address1 |
Street 2 - Home Address | address.street2 | customReport.address2 |
Title | title | customReport.jobTitle, jobInfo.jobTitle |
Work Email | contact.workemail | customReport.workEmail |
Work Phone | contact.workphone | customReport.workPhone |
Zip/Postal - Home Address | address.postal | customReport.zipcode |
Used to store compensation information | type | employmentStatus.employmentStatus |
Used to store profile photos | imageurl | customReport.id, customReport.isPhotoUploaded |
Used to store time off information | timeoff.approval | timeOff.status.status |
Used to store time off information | timeoff.days, timeoff.hours | timeOff.amount.unit, timeOff.amount.amount |
Used to store time off information | timeoff.enddate | timeOff.end |
Used to store time off information | timeoff.id | timeOff.id |
Used to store time off information | timeoff.note | timeOff.notes.employee |
Used to store time off information | timeoff.startdate | timeOff.start |
Used to store time off information | timeoff.type | timeOff.type.name |
Hourly compensation rate calculations
When calculating hourly compensation for Bamboo, ChartHop uses the following fields:
Field | Detail |
|---|---|
compensation.rate.value | The amount paid. |
Compensation.type | The compensation type. Can either be hourly or salary. |
compensation.paidPer | Where paidPer can be hourly, monthly, or yearly. |
compensation.payPer | Where payPer can be hourly, monthly, or yearly. |
The value of compensation.rate.value is calculated depending on the Compensation.type, and whether compensation.paidPer or compensation.payPer are calcuated hourly, monthly, or yearly.
Hourly calculation
In the case where the following fields are set to hourly:
- compensation.paidPer
- compensation.payPer
Hourly compensation is defined as compensation.rate.value where compensation.rate.value is the hourly rate.
Monthly calculation
In the case where the following fields are set to monthly:
- compensation.paidPer
- compensation.payPer
Hourly compensation is defined as compensation.rate.value * 12 / 2080, meaning that the value provided to in compensation.rate.value is the monthly pay for an employee and that employee is assumed to work 52 weeks a year at 40 hours a week.
Yearly salary calculation
In the case where the Compensation.type is salary and following are yearly:
- compensation.paidPer
- compensation.payPer
Salary is defined as compensation.rate.valuewhere compensation.rate.value is the yearly salary.