Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updated RSM InTime

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 your Core RSM InTime Core. Fields marked with * will be mandatory in Bullhorn.

Bullhorn API Field

(Field Mappings)

Bullhorn LabelRSM InTime field



Placement
Placement
ID *
Ref Code (prefixed with “BH-”)
Job / Vacancy *

Candidate *CandidateWorker
reportTo *Manager / Timesheet AuthoriserManager
customText1 *Company to InvoiceClient
billingUserIDBilling ContactSales Invoice Contact overridevendorClientCorporationID
Umbrella CompanyPlacement ProviderdateBegin *Start DateStart DatedateAddedDate AddedPlaced Date
dateEndScheduled EndEnd Date
billingFrequencyTimesheet DurationTimesheet Duration
employmentType *Employmentdetermines placement type e.g. Perm /contractemployeeTypeEmployee TypeWorker Type (PAYE/LTD/Umbrella) if match found. If this field is blank the Candidate.employeeType field is used.
placementCommissions
Consultant Commissions
FeePerm Placement Fee (%)Used to determine fee for perm placements (salary x fee)
SalaryPerm Salary HighUsed to determine fee for perm placements (salary x fee)
salaryUnitPay UnitRate TypeTime 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.
hoursPerDayHours Per DayDuration of all rates in minutes if salaryUnit field value contains "day" or "daily".
clientBillRate Bill RateRate 1 charge
payRate Pay RateRate 1 pay
clientOvertimeRateOvertime Bill RateRate 2 charge
overtimeRateOvertime Pay RateRate 2 pay
customBillRateN
Rate N charge
customPayRateN
Rate N pay
commentsCommentsComments
customText2Alternative Manager 1Alternative Manager
customText3Alternative Manager 2Alternative Manager
customText4Approval RouteApproval Routes for timesheets and chargeable expenses. (If employmentType = Perm auto approval is selected for timesheets)
customText5Email ApprovalEmail Approval enabled for timesheets and expenses
customText6QR ApprovalQR Approval enabled
customText7Expenses Allowed"Default" Expense Template Selected



Job (Vacancy)
Placement
Title *TitleJob Title
userID *OwnerConsultant
hoursPerWeekContracted Hours Per WeekContracted hours



PlacementCommissions
Placement Commission
userIDCommissions Tab (internal Only)Commission Consultant
commissionPercentage
Commission percentage



ClientCorporation (Company)
Client
name *Company NameClient Name
ID *
Ref Code (prefixed with “BH-”)
PhoneMain PhoneMain Contact phone
address.address1AddressMain Address line 1
address.address2
Main Address line 2
address.cityCityMain Address Town
address.stateCountyMain Address County
address.zipPost CodeMain Address PostCodePostcode
address.CountryCountryMain Address.Country
billingPhoneBilling PhoneInvoice Contact phone
billingContactBilling ContactInvoice Contact First name
billingAddress.address1Billing AddressInvoice Address line 1
billingAddress.address.address2
Invoice Address.line 2
billingAddress.address.cityBilling CityInvoice Address Town
billingAddress.address.stateBilling CountyInvoice Address County
billingAddress.address.zipBilling Post CodeInvoice Address PostCode
customText1Accounts RefAccounts Ref
customText2Company NumberCompany Number
customText3VAT Reg NoCompany Sales Tax Number
customText4VAT CodeVAT Code
Postcode
customText5Invoice EmailInvoice Email Address (Invoices sent by email if populated)
customText10CurrencyDefault CurrencycustomText11Invoice ConsolidationInvoice Consolidation
customText12Terms TypeInvoicing Terms Type
customFloat1Terms DaysInvoicing Terms Days



ClientContact (Contact)
Manager
clientCorporationID *Current CompanyClient
ID *
Ref Code (prefixed with “BH-”)
Email *Primary EmailEmail
firstName *Contact NameFirstname
lastName *Contact NameLastname
namePrefixName PrefixTitle
phonePrimary PhonePhone
address.address1Work AddressStreet 1
address.address2
Street 2
address.cityWork CityTown
address.stateWork StateCounty
address.zipWork ZipPostCodePostcode
address.CountryCountryCountry
divisionDepartmentDepartment



Candidate
Worker
ID *
Ref Code (prefixed with “BH-”)
email *Personal EmailEmail
firstName *Candidate NameFirstname
lastName *Candidate NameLastname
namePrefixCandidate NameTitle
phoneHome PhonePhone
mobileMobile PhoneMobile
address.address1AddressStreet 1
address.address2
Street 2
address.cityCityTown
address.stateCountyCounty
address.zipPost CodePost Code
address.countryIDCountryCountry
dateOfBirthDate Of BirthDate Of Birth
genderGenderGender
employeeTypeEmployee TypeWorker Type (PAYE/LTD) if match found. Only used if the Placement.employeeType field is blank.
customEncryptedText1Bank Account NumberBank Account Number
customEncryptedText2Sort CodeBank Account Sort Code
customEncryptedText3National Insurance NumberNational Insurance Number
customText10Bank Account NameBank Account Name/UMBRELLA)
customText7Engagement TypeEngagement Type
customText6Accounts RefAccounts Ref
customText9Building Society RefBank Building Society Ref
customText13CurrencyCurrencycustomText8NI Table Letter
customText1LTD Company NameLTD Company Name
customText2Compay Reg No (LTD)LTD Company No
customText3Compay VAT Reg No (LTD)LTD Company VAT No
customText4VAT CodeVAT Code
customText5Self Billing (LTD)Worker is Self Billing
customText11Umbrella CompanyLtd Company Provider / Umbrella
secondaryAddress1LTD Company AddressLTD Company Address 1
secondaryAddress2
LTD Company Address 2
secondaryCityCityLTD Company Address Town
secondaryStateCountyLTD Company Address County
secondaryZipPost CodeLTD Company Address Post Code
secondaryCountryIDCountryLTD 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 EmailEmail
firstName *First NameFirstname
lastName *First NameLastname
namePrefixTitleTitle
phonePhonePhone
address.address1AddressStreet 1
address.address2
Street 2
address.cityCityTown
address.stateCountyCounty
address.zipPost CodePostCodePostcode
address.countryIDCountryCountry
primaryDepartmentDepartmentDepartment



ClientCorporation (Company)
Ltd Company Provider (Umbrella)
name *Company NameCompany Name
ID *
Ref Code (prefixed with “BH-”)
PhoneMain PhoneMain Contact phone
address.address1AddressMain Address line 1
address.address2
Main Address line 2
address.cityCityMain Address Town
address.stateCountyMain Address County
address.zipPost CodeMain Address PostCodePostcode
address.CountryCountryMain Address.Country
billingPhoneBilling PhoneInvoice Contact phone
billingContactBilling ContactInvoice Contact First name
billingAddress.address1Billing AddressInvoice Address line 1
billingAddress.address.address2
Invoice Address.line 2
billingAddress.address.cityBilling CityInvoice Address Town
billingAddress.address.stateBilling CountyInvoice Address County
billingAddress.address.zipBilling Post CodeInvoice Address PostCode
customText1Accounts RefAccounts Ref
customText2Company NumberCompany Number
customText3VAT Reg NoCompany Sales Tax Number
customText4VAT CodeVAT Code
Postcode
customText5Invoice EmailInvoice Email Address (Invoices sent by email if populated)
customText6Umbrella Bank Account NameBank Account Name
customText7Umbrella Bank Account NumberBank Account Number
customText8Umbrella Sort CodeBank Account Sort Code
customText9Umbrella Self BillingProvider is Self Billing
customText10CurrencyDefault CurrencycustomText11Invoice ConsolidationInvoice Consolidation
customText12Terms TypeInvoicing Terms Type
customFloat1Terms DaysInvoicing 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.