4. "Bullhorn Core" Mapping

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", 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	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	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	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

Please Note:

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.