Page Comparison

If you have the "Core" version of RSM InTime Core and Bullhorn integration this page details the mappings provided for your systemmapping 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

* means mandatory


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

vendorClientCorporationID

Umbrella CompanyPlacement Provider

dateBegin *

Start Date

dateAdded

Date AddedPlaced Date

dateEnd	Scheduled End	End Date
billingFrequency	Timesheet Duration	Timesheet Duration
employmentType *	Employment	determines placement type e.g. Perm /contract

employeeTypeEmployee TypeWorker Type (PAYE/LTD/Umbrella) if match found. *If this field is blank the Candidate.employeeType field is used.

placementCommissions

	Consultant Commissions
Fee	Perm Placement Fee (%)	Used to determine fee for perm placements (salary x fee)
Salary	Perm Salary

High

	Used to determine fee for perm placements (salary x fee)
salaryUnit

Pay Unit

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

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

PostCodecustomText1Accounts RefAccounts RefcustomText2Company NumberCompany NumbercustomText3VAT Reg NoCompany Sales Tax NumbercustomText4VAT CodeVAT Code

Postcode
customText5	Invoice Email	Invoice Email Address (Invoices sent by email if populated)
customText10	Currency	Default Currency

customText11Invoice Consolidation

Invoice Consolidation

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

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

) if match found. *Only used if the Placement.employeeType field is blank.customEncryptedText1Bank Account NumberBank Account NumbercustomEncryptedText2Sort CodeBank Account Sort CodecustomEncryptedText3National Insurance NumberNational Insurance NumbercustomText10Bank Account NameBank Account Name

/UMBRELLA)
customText7	Engagement Type	Engagement Type

customText6Accounts RefAccounts RefcustomText9

Building Society RefBank Building Society Ref

customText13

Currency

customText8NI Table Letter

customText1

LTD Company Name

customText2Compay Reg No (LTD)LTD Company NocustomText3Compay VAT Reg No (LTD)customText4VAT CodeVAT Code

LTD Company VAT No

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

invioces

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

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

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

PostCodecustomText1Accounts RefAccounts RefcustomText2Company NumberCompany NumbercustomText3VAT Reg NoCompany Sales Tax NumbercustomText4VAT CodeVAT Code

Postcode
customText5	Invoice Email	Invoice Email Address (Invoices sent by email if populated)

customText6Umbrella Bank Account NameBank Account NamecustomText7Umbrella Bank Account NumberBank Account NumbercustomText8Umbrella Sort CodeBank Account Sort Code

customText9	Umbrella Self Billing	Provider is Self Billing
customText10	Currency	Default Currency

customText11Invoice ConsolidationInvoice Consolidation

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.

Versions Compared

Old Version 4

New Version Current

Key