If you have the "Core" version of RSM InTime and Bullhorn integration this page details the mapping that is provided. Please note that this includes all the Default Mappings and adds some customisations to cover the most common scenarios.
The table below shows the list of fields that are mapped for RSM InTime Core. Fields marked with * will be mandatory in Bullhorn.
Bullhorn API Field (Field Mappings) | Bullhorn Label | RSM InTime field |
|---|---|---|
| Placement | Placement | |
| ID * | Ref Code (prefixed with “BH-”) | |
| Job / Vacancy * | ||
| Candidate * | Candidate | Worker |
| reportTo * | Manager / Timesheet Authoriser | Manager |
| customText1 * | Company to Invoice | Client |
| billingUserID | Billing Contact | Sales Invoice Contact override |
| dateBegin * | Start Date | Start Date |
| dateEnd | Scheduled End | End Date |
| billingFrequency | Timesheet Duration | Timesheet Duration |
| employmentType * | Employment | determines placement type e.g. Perm /contract |
| placementCommissions | Consultant Commissions | |
| Fee | Perm Placement Fee (%) | Used to determine fee for perm placements (salary x fee) |
| Salary | Perm Salary | Used to determine fee for perm placements (salary x fee) |
| salaryUnit | Rate Type | Time period & duration for all rates Hourly/Fixed. If field value contains "day" or "daily", InTIME RSM InTime sets all rates to fixed else it sets them to hourly. |
| hoursPerDay | Hours Per Day | Duration of all rates in minutes if salaryUnit field value contains "day" or "daily". |
| clientBillRate | Bill Rate | Rate 1 charge |
| payRate | Pay Rate | Rate 1 pay |
| clientOvertimeRate | Overtime Bill Rate | Rate 2 charge |
| overtimeRate | Overtime Pay Rate | Rate 2 pay |
| customBillRateN | Rate N charge | |
| customPayRateN | Rate N pay | |
| comments | Comments | Comments |
| customText2 | Alternative Manager 1 | Alternative Manager |
| customText3 | Alternative Manager 2 | Alternative Manager |
| customText4 | Approval Route | Approval Routes for timesheets and chargeable expenses. (If employmentType = Perm auto approval is selected for timesheets) |
| customText5 | Email Approval | Email Approval enabled for timesheets and expenses |
| customText6 | QR Approval | QR Approval enabled |
| customText7 | Expenses Allowed | "Default" Expense Template Selected |
| Job (Vacancy) | Placement | |
| Title * | Title | Job Title |
| userID * | Owner | Consultant |
| hoursPerWeek | Contracted Hours Per Week | Contracted hours |
| PlacementCommissions | Placement Commission | |
| userID | Commissions Tab (internal Only) | Commission Consultant |
| commissionPercentage | Commission percentage | |
| ClientCorporation (Company) | Client | |
| name * | Company Name | Client Name |
| ID * | Ref Code (prefixed with “BH-”) | |
| Phone | Main Phone | Main Contact phone |
| address.address1 | Address | Main Address line 1 |
| address.address2 | Main Address line 2 | |
| address.city | City | Main Address Town |
| address.state | County | Main Address County |
| address.zip | Post Code | Main Address Postcode |
| address.Country | Country | Main Address.Country |
| billingPhone | Billing Phone | Invoice Contact phone |
| billingContact | Billing Contact | Invoice Contact First name |
| billingAddress.address1 | Billing Address | Invoice Address line 1 |
| billingAddress.address.address2 | Invoice Address.line 2 | |
| billingAddress.address.city | Billing City | Invoice Address Town |
| billingAddress.address.state | Billing County | Invoice Address County |
| billingAddress.address.zip | Billing Post Code | Invoice Address Postcode |
| customText5 | Invoice Email | Invoice Email Address (Invoices sent by email if populated) |
| customText10 | Currency | Default Currency |
| customText12 | Terms Type | Invoicing Terms Type |
| customFloat1 | Terms Days | Invoicing Terms Days |
| ClientContact (Contact) | Manager | |
| clientCorporationID * | Current Company | Client |
| ID * | Ref Code (prefixed with “BH-”) | |
| Email * | Primary Email | |
| firstName * | Contact Name | Firstname |
| lastName * | Contact Name | Lastname |
| namePrefix | Name Prefix | Title |
| phone | Primary Phone | Phone |
| address.address1 | Work Address | Street 1 |
| address.address2 | Street 2 | |
| address.city | Work City | Town |
| address.state | Work State | County |
| address.zip | Work Zip | Postcode |
| address.Country | Country | Country |
| division | Department | Department |
| Candidate | Worker | |
| ID * | Ref Code (prefixed with “BH-”) | |
| email * | Personal Email | |
| firstName * | Candidate Name | Firstname |
| lastName * | Candidate Name | Lastname |
| namePrefix | Candidate Name | Title |
| phone | Home Phone | Phone |
| mobile | Mobile Phone | Mobile |
| address.address1 | Address | Street 1 |
| address.address2 | Street 2 | |
| address.city | City | Town |
| address.state | County | County |
| address.zip | Post Code | Post Code |
| address.countryID | Country | Country |
| dateOfBirth | Date Of Birth | Date Of Birth |
| gender | Gender | Gender |
| employeeType | Employee Type | Worker Type (PAYE/LTD/UMBRELLA) |
| customText7 | Engagement Type | Engagement Type |
| customText13 | Currency | Currency |
| customText1 | LTD Company Name | LTD Company Name |
| customText5 | Self Billing (LTD) | Worker is Self Billing |
| customText11 | Umbrella Company | Ltd Company Provider / Umbrella |
| secondaryAddress1 | LTD Company Address | LTD Company Address 1 |
| secondaryAddress2 | LTD Company Address 2 | |
| secondaryCity | City | LTD Company Address Town |
| secondaryState | County | LTD Company Address County |
| secondaryZip | Post Code | LTD Company Address Post Code |
| secondaryCountryID | Country | LTD Company Address Country |
| LTD Company Email - defaults to Primary email | ||
| LTD Company Contact Firstname - defaults to Worker First Name | ||
| LTD Company Contact Lastname - defaults to Worker Last Name | ||
| Default to Deliver invoices by email | ||
| CorporateUser | Consultant | |
| ID * | Ref Code (prefixed with “BH-”) | |
| email * | Primary Email | |
| firstName * | First Name | Firstname |
| lastName * | First Name | Lastname |
| namePrefix | Title | Title |
| phone | Phone | Phone |
| address.address1 | Address | Street 1 |
| address.address2 | Street 2 | |
| address.city | City | Town |
| address.state | County | County |
| address.zip | Post Code | Postcode |
| address.countryID | Country | Country |
| primaryDepartment | Department | Department |
| ClientCorporation (Company) | Ltd Company Provider (Umbrella) | |
| name * | Company Name | Company Name |
| ID * | Ref Code (prefixed with “BH-”) | |
| Phone | Main Phone | Main Contact phone |
| address.address1 | Address | Main Address line 1 |
| address.address2 | Main Address line 2 | |
| address.city | City | Main Address Town |
| address.state | County | Main Address County |
| address.zip | Post Code | Main Address Postcode |
| address.Country | Country | Main Address.Country |
| billingPhone | Billing Phone | Invoice Contact phone |
| billingContact | Billing Contact | Invoice Contact First name |
| billingAddress.address1 | Billing Address | Invoice Address line 1 |
| billingAddress.address.address2 | Invoice Address.line 2 | |
| billingAddress.address.city | Billing City | Invoice Address Town |
| billingAddress.address.state | Billing County | Invoice Address County |
| billingAddress.address.zip | Billing Post Code | Invoice Address Postcode |
| customText5 | Invoice Email | Invoice Email Address (Invoices sent by email if populated) |
| customText9 | Umbrella Self Billing | Provider is Self Billing |
| customText10 | Currency | Default Currency |
| customText12 | Terms Type | Invoicing Terms Type |
| customFloat1 | Terms Days | Invoicing Terms Days |
...
- Providers are mapped to workers not placements.
- Accounts references, Company Numbers, VAT Reg numbers, VAT Codes, Bank Details, NI Numbers and Invoice consolidation are not mapped from Bullhorn and are expected to be entered directly into RSM InTime.