--- title: Synced data from BambooHR slug: synced-data-from-bamboohr docTags: createdAt: 2021-08-03T13:04:53.000Z --- 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. :::hint{type="info"} 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.value`where `compensation.rate.value` is the yearly salary.