A customisation is any data mapping or processing that is not applied as part of the default configuration. Customisations are only applied when processing a placement update event – they can not be applied when processing a Candidate, Contact or Company update event. They are processed at the end of the import after the default mappings have been applied..
Almost any field in Bullhorn can be mapped to any field in InTime including from the Candidate, Company and Contact but there are a few exceptions due to limitations of the Interface - see below. As well as straight data mapping, some processing can be performed as part of the import.
During your integration test phase InTime support will work with you to establish any customisations you require. After you have gone live, additional customisations should be requested via the customisation request form shown below. Implementing these mappings will be chargeable on a time and materials basis.
Common customisations:
The following data fields are frequently required in InTime that are not mapped from Bullhorn by default:
Worker:
Engagement type for HMRC intermediary reporting
Limited Company Name
Limited Company Invoice Address - Can be mapped to same as main address if required - 5 separate fields need mapping: Street Line 1, Street Line 2, Town, County, Postcode, Country
Limited Company Email Address (can be mapped to same as main email address if required)
Limited Company VAT Code (for VAT inclusion on invoices) (i.e. T0, T1 etc..)
Limited Company VAT Registration Number
Limited Company Registration Number
Limited Company Self Billing Status (Y/N)
Bank Details (If you intend to make payments from InTime)
National Insurance Number & Table letter - 2 separate fields require mapping: NI Number, NI Table Letter (can default to A if required)
Gender (Male / Female / M / F etc..)
Account Number (to link to the appropriate record in your accounts or payroll system)
Ltd Company Providers (Umbrellas)
Accounts reference – to link invoices the appropriate record in your accounts system
Bank details - Good idea to map if you intend to make payments from InTime. - 3 separate fields require mapping: Bank Account name, Bank Account Number, Bank Account Sort
VAT Code (i.e. T0, T1 etc..)
VAT registration number
Company registration number
Self Billing Status (Y/N)
Manager:
By default the InTime Manager is mapped to the Contact associated with the Job/Vacancy. In InTime the Manager is normally the Timesheet approver which is often a different person to who arranged the contract. Field Type must be Picker:Client. (NOT the same as Picker:Text:Client!) If you cannot set the field to this type you may need to ask Bullhorn support to complete this update or choose another field that is already this type.
Client:
VAT Code - If you have VAT registered clients and suppliers you will need to set the appropriate VAT code so the VAT is correctly applied to invoices.
VAT registration number
Company registration number
Accounts reference – to link invoices to the appropriate record in your accounts system.
Invoice payment terms e.g. 14 days from Invoice date. 2 separate fields require mapping: Terms Days (Number), Terms Type (Options: ).
Placement:
Pay and Charge currencies. 2 separate fields require mapping: Pay Currency, Charge Currency.
Rate names and periods - Standard mapping is applied otherwise as per this document. If you require changes to this add these requests to the customisation request form below.
Alternative managers.- Field Type must be Picker:Client. (NOT the same as Picker:Text:Client!) If you cannot set the field to this type you may need to ask Bullhorn support to complete this update or choose another field that is already this type.
Placement financial fields – These are normally used to indicate company structure such as Division, Location, Department and Cost Centre and can be used for grouping items in reports or as additional information on invoice export. Possible 14 separate fields that can be mapped: SalesSector, PurchaseSector, SalesBranch, PurchaseBranch, SalesLocation, PurchaseLocation, SalesDivision, PurchaseDivision, SalesDepartment, PurchaseDepartment, SalesProject, PurchaseProject, SalesCostcentre, PurchaseCostCentre. Please confirm which fields you require mapping in the customisation request form.
Expense template. - Must match the Expense Template name in InTIME, default name is "DEFAULT"
Approval routes.- 3 separate fields require mapping: Timesheet Approval Route, Chargeable Expensee Approval Route, Non-Chargeable Expenses Approval Route - The value of this field must match the name of the approval route in InTIME. By default these are “Client Approval Route”, “Auto Approval Route”, “Agency Consultant Approval Route”.
Invoicing contact – if you need to invoice a client at more than one contact or postal address you can set the charge contact details on each placement. - Field Type must be Picker:Client. (NOT the same as Picker:Text:Client!) If you cannot set the field to this type you may need to ask Bullhorn support to complete this update or choose another field that is already this type.
Purchase Order Numbers.
Mapping Exceptions
The following fields can not be mapped from Bullhorn to InTime:
customCompanent1-3 of any object
preferredHousing of any object
Any "Header" fields e.g. sectionHeader1, payRateInfoHeader
Placement.vendorClientCorporationID
Placement.projectCodeList
Placement.markupPercentage
Placement.overtimeMarkupPercentage
Placement Commissions for External Recipients
Candidate.blackListID
Candidate.eeocHeader
Candidate.recruiterUserID
Candidate.whiteListID
Company.blackListID
Company.whiteListID
Company.facebookProfileName
Company.linkedInProfileName
Company.twitterHandle
Contact.dateAvailable
Contact.dateAvailableEnd
Contact.dayRate
Contact.dayRateLow
Contact.employmentPreference
Contact.experience
Contact.hourlyRate
Contact.hourlyRateLow
Contact.recruiterUserID
Contact.salary
Contact.salaryLow
Contact.taxID
Contact.travelLimit
Contact.willRelocate
Contact.workAuthorized
Job.certificationID
Job.markupPercentage
Job.shiftID
Job.shifts
The following Associated objects can not be mapped to InTime:
Skills
Category
Certifications
BusinessSector
Appointment
HousingAmenity
Invoice
InvoiceGroup
RateCard
InvoiceItem
Sendout
Note
Survey
Task
TimeCard
TimecardExpense
TimecardTime
Customisation request form
In order to implement a custom mapping InTime support require the information in the following form. Please complete all the details for each mapping and submit to InTime support to request a custom mapping from Bullhorn to InTime. InTime support will then assess the feasibility of the mapping and provide you with a quotation for the effort required to implement it. A Microsoft Word version of this form is attached to this page which you can download and complete.
Bullhorn Object | Bullhorn API Field | InTime Object | InTime Field | Bullhorn Values | InTime Values | Conditions |
Some examples are shown below:
Bullhorn Object | Bullhorn API Field | InTime Object | InTime Field | Bullhorn Values | InTime Values | Conditions |
Candidate | customText1 | Placement | Purchase Location | London, Edinburgh | London Edinburgh | |
Placement | customText3 | Worker | Engagement Type | A, B, C, D, E, F, Z | A B C D E F Z | LTD workers only |
Company | customInt3 | Client | Payment Terms | 30, 60 | 30 Days from Invoice Date 60 Days from Invoice Date | |
Company | taxRate | Client | VAT Code | 0, 20 | T0 (0%) T1 (20%) | |
User | department | Placement | Sales Department | Finance, Accounts, Sales | FNN ACC SLS | Contract placements only |
Placement | customText21 | Placement | Charge Currency | GBP, USD, EUR | GBP USD EUR | |
Placement | customText22 | Placement | Timesheet and Expense Pay Currencies | GBP, USD, EUR | GBP USD EUR |