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 RSM 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 RSM InTime support will work with you to establish any customisations you require - the form below is the best way to document these. After you have gone live, any additional customisations should can 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 RSM InTime that are not mapped from Bullhorn by default:
Worker:
PAYE Reference - If you have use InPAY and have PAYE workers you MUST complete this customisation as RSM InTime needs the reference for InPAY to use in HMRC submissions. This field must hold this reference.
Engagement type for HMRC intermediary reporting
...
Bank Details (If you intend to make payments from RSM InTime)
National Insurance Number & Table letter - 2 separate fields require mapping: NI Number, NI Table Letter (can default if required, e.g. 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 RSM InTime. - 3 separate fields require mapping: Bank Account name, Bank Account Number, Bank Account Sort
...
Self Billing Status (Y/N)
Manager:
By default the RSM InTime Manager is mapped to the Contact associated with the Job/Vacancy. In RSM 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.
...
Invoice payment terms e.g. 14 days from Invoice date. 2 separate fields require mapping: Terms Days (Number), Terms Type (Allowed Options: As Per Agreed Terms and Conditions, Days From Invoice Date,Days from Month End, Days from End of Next Month, Days From End Of Month After Next).
Placement:
Pay and Charge currencies. 2 separate fields require mapping: Pay Currency, Charge Currency.
...
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 InTIMERSM 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”RSM InTime. The defaults set up are “Client Manager Approval”, “Auto Approval Route”, “Agency Consultant Approval Route”Approval”.
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 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 RSM InTime:
Encrypted fields can not be accessed through the SOAP API but can be accessed through REST
Placement: Any customText fields over customText40 - if using SOAP API
Other entities apart from Placement: customCompanent1Any customText fields over customText20 - if using SOAP API
customComponent1-3 of any object
preferredHousing of any object
Any "Header" fields e.g. sectionHeader1, payRateInfoHeader
Placement.vendorClientCorporationIDflatFee
Placement.projectCodeList
Placement.markupPercentage
Placement.overtimeMarkupPercentage
Placement Commissions for External Recipients
...
The following Associated objects can not be mapped to RSM 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 RSM InTime support require the information in the following form. Please complete all the details for each mapping and submit to RSM InTime support to request a the custom mapping from Bullhorn to InTime. InTime support . RSM will then assess the feasibility of the mapping and provide you with a quotation for the effort required to implement it. A Microsoft Word An Excel version of this form is attached to this page which you can download and complete.
...
The bullhorn Entity is the item in Bullhorn that the field belongs to e.g. the Placement, Candidate or Job. The API field is Bullhorns internal name for the field. This is different to the label that is shown when viewing the item in Bullhorn. The Bullhorn Entity and API Field information can be found in the Field Mappings section of bullhorn. Please see the examples below for further guidance on how to complete the form.
Bullhorn Entity | Bullhorn API Field | RSM InTime ObjectEntity | RSM InTime Field | Bullhorn Values | RSM InTime Values | Conditions |
Some examples are shown below:
Bullhorn ObjectEntity | Bullhorn API Field | RSM InTime ObjectEntity | RSM InTime Field | Bullhorn Values | RSM 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 |