PUMP SUPPORT
InTime-Pump Integration Setup (System Administrators)
Before you setup the Intime integration on your Pump instance, please contact Pump Support to ensure your RSM Intime integration sync has been setup and please ensure you have your Intime environment credentials to hand. Contact your RSM account manager / support team if you are unsure of these credentials.
Once the Pump-Intime sync has been setup you must populate the following fields in the Pay and Bill Integration Settings tab of Pump's Global Settings. Please note, this must be done separately on your Sandbox and then later on your Production instance if you are going through an implementation and user acceptance testing period.
- Integration Provider = "InTime"
- Username = InTime Username
- Password = InTime Password
- Agency Ref Code = InTime Agency Reference Code
If you only wish to integrate your Pump instance with a single RSM Intime environment, then you only need to configure the above fields. However if you wish to push data to multiple Intime environments due to your organisational structure you must toggle 'Use Owning Company Credentials?' to 'Yes.'
Doing so allows you to use the Placement's 'Sales Owning Company' record's Intime credentials linked to each Placement in Pump to push your data to more than one Intime environment.
You can create and populate your Owning Company records separately within each instance under the Pump Settings area in the bottom left of your screen.
If any credentials are missing when authorising a Placement and syncing it to InTime an error message will be displayed. This applies to both credential types, but if Sales Owning Company credentials are used and the Sales Owning Company is blank, an error will also be displayed saying that the field needs to be filled in.
The Pay and Bill Integration Password field in both Global Settings and Owning Companies is hidden unless users have the Security Role 'Pump - Pay and Bill Integration Admin' assigned.
Further configuration of your Intime integration
In addition to this, you will also need to do the following:
- Add any Users to the Field Security for the Bank Account fields in the Candidate and Placement Entities.
- Contact the Pump Team to setup your InTime background sync.
- Customise your Pump Unmanaged Solution in your Sandbox to meet any custom option sets you have setup within your Intime environment.
In InTime, it is possible to have custom options for the following field types (which also have an equivalent value in Pump).
- Currencies/Exchange Rates.
- Tax Codes.
- Pay Elements (for Overtime Rates).
- Invoice Frequencies.
- Payment Frequencies.
For the Currency, Tax Code, Pay Element and Payment Frequency options, values are matched using the following:
- Currency: ISO Currency Code (e.g. 'GBP').
- Tax Code: The Tax Code Option Set 'Label' matches with the Tax Rate 'Name' (NOT code) in InTime.
- Pay Element: Pay Element Name (e.g. 'Basic Pay').
- Payment Frequency: Payment Frequency Name (e.g. 'Weekly').
For the Invoice Frequency options, values are matched using their option value/index (both Pump and InTime must have the same options in the same order). Out-of-the-box options are:
- 0 - Weekly
- 1 - Two Weekly
- 2 - Four Weekly
- 3 - Calendar Monthly
- 4 - 4-4-5
- 5 - Other
Data Mapping and Business Process Flow Customisation
In order to most effectively utilise the integration the customer should incorporate mandatory fields into the Placement Business Process Flow before Level 2 Authorisation that you wish to be pushed up to Intime. Please be aware that in some cases RSM Intime requires these fields.
For a full overview of the Pump - RSM Intime data mapping sync please review the data map below below
InTime Integration (Users)
If the InTime Integration is enabled, the Placement and associated data will be created in InTime automatically on 2nd Level Authorisation.
If any validation errors occur in this process, an error, like the one in the screenshot below, will be displayed with the validation message from InTime. The Placement won't be able to progress to 2nd Level Authorisation until the validation error has been resolved.
It is also worth noting that the LATEST InTime error is stored in the Placement Field - Pay and Bill Integration Sync Error (colleagu_payandbillintegrationsyncerror). This field is cleared once the Placement is pushed through to Intime successfully on Level 2 Authorisation after a resolution of any data errors.
When Placements have Timesheets or Invoices associated with them in InTime, warning banners are displayed on the Placement form.
FIELD MAPPING
CANDIDATE/WORKER FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Worker.externalId | colleagu_PersonReference | Person Reference | Person (Contact) | |
Worker.refCode | ContactId | Person | Person (Contact) | |
Worker.commsDisabled | TRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE. | N/A | N/A | |
Worker.emailDisabled | TRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE. | N/A | N/A | |
Worker.workerType | colleagu_PaymentMethod | Payment Method | Placement (colleagu_placement) | If Payment Method = Umbrella, value is 'umbrella', if Payment Method = PAYE, value is 'paye', otherwsie value is 'ltd'. |
Worker.limitedCompany | colleagu_ContractorCompany | Contractor Company | Placement (colleagu_placement) | NO RESPECTIVE CLIENT RECORD IS CREATED IN INTIME |
Worker.limitedCompanyProviderExternalId | colleagu_CompanyReference | Company Reference | Company (Account) | Linked Field: colleagu_placement.colleagu_ContratorCompany (Placement - Contractor Company). |
Worker.limitedCompanyProviderId | InTime Limited Company Provider ID | N/A | N/A | Output ID from InTime. |
Worker.ltdCompanyContact.firstname | colleagu_CandidateFirstName | Candidate First Name | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.lastname | colleagu_CandidateLastName | Candidate Last Name | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.email | EMailAddress1 | Email 1 | Person (Contact) | Person Lookup: Placement - Candidate (colleagu_PlacedCandidate). |
Worker.ltdCompanyContact.address.line1 | colleagu_ContractAddressStreet1 | Contractor Company Address Street 1 | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.line2 | colleagu_ContractAddressStreet2 | Contractor Company Address Street 2 | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.town | colleagu_ContractAddressCity | Contractor Company Address City | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.county | colleagu_ContractAddressCounty | Contractor Company Address County | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.postcode | colleagu_ContractAddressZipPostalCode | Contractor Company Address ZIP/Postal Code | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.country | colleagu_ContractAddressCountry | Contractor Company Address Country/Region | Placement (colleagu_placement) | |
Worker.ltdCompanyContact.address.countryCode | colleagu_ContractAddressCountry | Contractor Company Address Country/Region | Placement (colleagu_placement) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
Worker.firstname | colleagu_CandidateFirstName | Candidate First Name | Placement (colleagu_placement) | |
Worker.lastname | colleagu_CandidateLastName | Candidate Last Name | Placement (colleagu_placement) | |
Worker.email | EMailAddress1 | Email 1 | Person (Contact) | Person Lookup: Placement - Candidate (colleagu_PlacedCandidate). |
Worker.phone | Telephone1 | Business Phone | Person (Contact) | Person Lookup: Placement - Candidate (colleagu_PlacedCandidate). |
Worker.mobile | MobilePhone | Mobile Phone | Person (Contact) | Person Lookup: Placement - Candidate (colleagu_PlacedCandidate). |
Worker.address.line1 | colleagu_CandidateAddressStreet1 | Candidate Personal Address Street 1 | Placement (colleagu_placement) | |
Worker.address.line2 | colleagu_CandidateAddressStreet2 | Candidate Personal Address Street 2 | Placement (colleagu_placement) | |
Worker.address.town | colleagu_CandidateAddressCity | Candidate Personal Address City | Placement (colleagu_placement) | |
Worker.address.county | colleagu_CandidateAddressCounty | Candidate Personal Address County | Placement (colleagu_placement) | |
Worker.address.postcode | colleagu_CandidateAddressZIPPostalCode | Candidate Personal Address ZIP/Postal Code | Placement (colleagu_placement) | |
Worker.address.country | colleagu_CandidateAddressCountryRegion | Candidate Personal Address Country/Region | Placement (colleagu_placement) | |
Worker.address.countryCode | colleagu_CandidateAddressCountryRegion | Candidate Personal Address Country/Region | Placement (colleagu_placement) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
Worker.title | colleagu_Title | Title | Person (Contact) | |
Worker.dateOfJoining | CreatedOn | Created On | Person (Contact) | |
Worker.timesheetsOnInvoices | Value is always set to checked. | N/A | N/A | |
Worker.gender | colleagu_Gender | Gender | Placement (colleagu_placement) | M or F. |
Worker.dateOfBirth | colleagu_candidatedateofbirth | Candidate Date of Birth | Placement (colleagu_placement) | |
Worker.paymentFrequency | colleagu_Payment_Frequency | Payment Frequency | Placement (colleagu_placement) | There has to be a equivalent index value in InTime. |
Worker.accountsReference | colleagu_CandidateAccountReference | Candidate Account Reference | Placement (colleagu_placement) | |
Worker.bankAccount.bank | colleagu_CandidateBankName | Candidate Bank Name | Placement (colleagu_placement) | |
Worker.bankAccount.bankaccountName | colleagu_CandidateBankAccountName | Candidate Bank Account Name | Placement (colleagu_placement) | |
Worker.bankAccount.banksortCode | colleagu_CandidateBankAccountSortCode | Candidate Bank Account Sort Code | Placement (colleagu_placement) | |
Worker.bankAccount.bankaccountNumber | colleagu_CandidateBankAccountNumber | Candidate Bank Account Number | Placement (colleagu_placement) | |
Worker.nationalInsuranceNumber | colleagu_NationalInsuranceNumber | National Insurance Number | Placement (colleagu_placement) | |
Worker.niTableLetter | colleagu_NationalInsuranceNumber | National Insurance Number | Placement (colleagu_placement) | First letter of the NI Number. |
Worker.defaultPaymentCurrency | colleagu_PayCurrency | Pay Currency | Placement (colleagu_placement) | Linked Record: TransactionCurrency.ISOCurrencyCode (Currency - ISO Code). An equivalent Exhange Rate containing this currency must exist in InTime. |
Worker.vatCode | colleagu_CandidateTaxCode | Candidate Tax Code | Placement (colleagu_placement) | There must be an eqivalent named option in InTime (code doesn't need to match). |
Worker.selfBilling | colleagu_AllowSelfBilling | Allow Candidate Self Billing? | Placement (colleagu_placement) | |
USER/CONSULTANT FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Consultant.externalId | InternalEMailAddress | Primary Email | User (SystemUser) | Special characters removed (e.g. @), uppercase, limited to 30 characters. |
Consultant.refCode | SystemUserId | User | User (SystemUser) | |
Consultant.email | InternalEMailAddress | Primary Email | User (SystemUser) | |
Consultant.refCode | SystemUserId | User | User (SystemUser) | |
Consultant.firstname | FirstName | First Name | User (SystemUser) | |
Consultant.lastname | LastName | Last Name | User (SystemUser) | |
Consultant.phone | Address1_Telephone1 | Main Phone | User (SystemUser) | |
Consultant.mobile | MobilePhone | Mobile Phone | User (SystemUser) | |
Consultant.address.line1 | Address1_Line1 | Street 1 | User (SystemUser) | |
Consultant.address.line2 | Address1_Line2 | Street 2 | User (SystemUser) | |
Consultant.address.town | Address1_City | City | User (SystemUser) | |
Consultant.address.county | Address1_County | Address 1: County | User (SystemUser) | |
Consultant.address.postcode | Address1_PostalCode | ZIP/Postal Code | User (SystemUser) | |
Consultant.address.country | Address1_County | Country/Region | User (SystemUser) | |
Consultant.address.countryCode | Address1_County | Country/Region | User (SystemUser) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
COMPANY/CLIENT FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Client.externalId | colleagu_CompanyReference | Company Reference | Company (Account) | |
Client.refCode | AccountId | Company | Company (Account) | |
Client.name | Name | Company Name | Company (Account) | |
Client.companyNo | colleagu_InvoiceCompanyRegistrationNumber OR colleagu_ContractorCompanyRegistrationNumber | Invoice Company Registration Number OR Cpntractor Company Registration Number | Placement (colleagu_placement) | Field used is based on whether the Company is an Invoice Company or not. |
Client.companyVatNo | colleagu_InvoiceCompanyVATNumber OR colleagu_ContractorCompanyVATNumber | Invoice Company VAT Number OR Contractor Company VAT Number | Placement (colleagu_placement) | Field used is based on whether the Company is an Invoice Company or not. |
Client.vatCode | colleagu_InvoiceCompany_TaxCode OR colleagu_ContractorCompany_TaxCode | Invoice Company Address Tax Code OR Contractor Company Address Tax Code | Placement (colleagu_placement) | Field used is based on whether the Company is an Invoice Company or not. There must be an eqivalent named option in InTime (code doesn't need to match). |
Client.accountsRef | colleagu_InvoiceCompanyAccountReference OR colleagu_ContractorCompanyAccountReference | Invoice Company Reference OR Contractor Company Reference | Placement (colleagu_placement) | Field used is based on whether the Company is an Invoice Company or not. |
Client.invoicePeriod | colleagu_InvoiceFrequency | Invoice Frequency | Placement (colleagu_placement) | There has to be a equivalent named value in InTime. |
Client.invoiceDeliveryMethod | Value is always set to 'Email'. | N/A | N/A | |
Client.currency | TransactionCurrencyId | Charge Currency (Primary) | Placement (colleagu_placement) | Linked Record: TransactionCurrency.ISOCurrencyCode (Currency - ISO Code). An equivalent Exhange Rate containing this currency must exist in InTime. |
Client.primaryContact.firstname | FirstName | First Name | Person (Contact) | Person Lookup: Hiring Company - Primary Contact (PrimaryContactId). |
Client.primaryContact.lastname | LastName | Last Name | Person (Contact) | Person Lookup: Hiring Company - Primary Contact (PrimaryContactId). |
Client.primaryContact.email | EMailAddress1 | Email 1 | Person (Contact) | Person Lookup: Hiring Company - Primary Contact (PrimaryContactId). |
Client.primaryContact.phone | Telephone1 | Business Phone | Person (Contact) | Person Lookup: Hiring Company - Primary Contact (PrimaryContactId). |
Client.primaryContact.mobile | MobilePhone | Mobile Phone | Person (Contact) | Person Lookup: Hiring Company - Primary Contact (PrimaryContactId). |
Client.primaryContact.address.line1 | colleagu_InvoiceAddressStreet1 | Invoice Company Address Street 1 | Placement (colleagu_placement) | |
Client.primaryContact.address.line2 | colleagu_InvoiceAddressStreet2 | Invoice Company Address Street 2 | Placement (colleagu_placement) | |
Client.primaryContact.address.town | colleagu_InvoiceAddressCity | Invoice Company Address City | Placement (colleagu_placement) | |
Client.primaryContact.address.county | colleagu_InvoiceAddressCounty | Invoice Company Address County | Placement (colleagu_placement) | |
Client.primaryContact.address.postcode | colleagu_InvoiceAddressZipPostalCode | Invoice Company Address ZIP/Postal Code | Placement (colleagu_placement) | |
Client.primaryContact.address.country | colleagu_InvoiceAddressCountry | Invoice Company Address Country/Region | Placement (colleagu_placement) | |
Client.primaryContact.address.countryCode | colleagu_InvoiceAddressCountry | Invoice Company Address Country/Region | Placement (colleagu_placement) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
Client.termsTemplateName | colleagu_PayTerms (for companies created as Clients (i.e. not Limited Companies).) | Pay Terms | Placement (colleagu_placement) | |
Client.termsType | colleagu_PayTermsType (for companies created as Clients (i.e. not Limited Companies).) | Pay Terms Type | Placement (colleagu_placement) | |
Client.termsDays | Value is always 30 for companies created as Clients (i.e. not Limited Companies). | N/A | N/A | |
Client.consolidation and Client.grouping | Value is always set to 'Each Worker Is Invoiced Separately'. | N/A | N/A | InTime field is name 'What Goes On Each Invoice?' but is set via the consolidation and grouping fields in the API. |
Client.timesheetsOnInvoices | Value is always set to 'Yes'. | N/A | N/A | |
Client.paperOnInvoices | Value is always no/un-ticked. | N/A | N/A | |
UMBRELLA COMPANY/PROVIDER FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Provider.name | colleagu_ContractorCompany.Name | Contractor Company | Placement (colleagu_placement) | |
Provider.companyNo | colleagu_ContractorCompanyVATNumber | Contractor Company VAT Number | Placement (colleagu_placement) | |
Provider.vatCode | colleagu_ContractorCompany_TaxCode | Contractor Company Tax Code | Placement (colleagu_placement) | There must be an eqivalent named option in InTime (code doesn't need to match). |
Provider.accountsRef | colleagu_ContractorCompanyAccountReference | Contractor Company Account Reference | Placement (colleagu_placement) | |
Provider.currency | colleagu_PayCurrency | Pay Currency | Placement (colleagu_placement) | |
Provider.invoicingContact.address.line1 | colleagu_ContractAddressStreet1 | Contractor Company Address Street 1 | Placement (colleagu_placement) | |
Provider.invoicingContact.address.line2 | colleagu_ContractAddressStreet2 | Contractor Company Address Street 2 | Placement (colleagu_placement) | |
Provider.invoicingContact.address.town | colleagu_ContractAddressCity | Contractor Company Address City | Placement (colleagu_placement) | |
Provider.invoicingContact.address.county | colleagu_ContractAddressCounty | Contractor Company Address County | Placement (colleagu_placement) | |
Provider.invoicingContact.address.postcode | colleagu_ContractAddressZipPostalCode | Contractor Company Address ZIP/Postal Code | Placement (colleagu_placement) | |
Provider.invoicingContact.address.country | colleagu_ContractAddressCountry | Contractor Company Address Country/Region | Placement (colleagu_placement) | |
Provider.invoicingContact.address.countryCode | colleagu_ContractAddressCountry | Contractor Company Address Country/Region | Placement (colleagu_placement) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
Provider.invoicePeriod | colleagu_CandidateInvoiceFrequency | Candidate Invoice Frequency | Placement (colleagu_placement) | |
Provider.invoiceDeliveryMethod | Always set to 'Email'. | N/A | N/A | |
Provider.selfBilling | colleagu_AllowSelfBilling | Allow Candidate Self Billing? | Placement (colleagu_placement) | |
Client.consolidation and Client.grouping | Value is always set to 'Each Worker Is Invoiced Separately'. | N/A | N/A | |
CONTACT/MANAGER FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Manager.externalId | colleagu_PersonReference | Person Reference | Person (Contact) | |
Manager.refCode | ContactId | Contact | Person (Contact) | |
Manager.firstname | colleagu_ContactFirstName | Contact First Name | Placement (colleagu_placement) | |
Manager.lastname | colleagu_ContactLastName | Contact Last Name | Placement (colleagu_placement) | |
Manager.email | EMailAddress1 (see note) | Email 1 | Person (Contact) (see note) | Limited Company Contact email is the Contractor Company Email Address (emailaddress1) |
Manager.phone | Telephone1 | Business Phone | Person (Contact) | |
Manager.mobile | MobilePhone | Mobile Phone | Person (Contact) | |
Manager.client | InTime Client | N/A | N/A | InTime Record is created before syncing/attaching to the Manager. |
Manager.address.line1 | colleagu_Street1 | Street 1 | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.line2 | colleagu_Street2 | Street 2 | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.town | colleagu_City | City | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.county | colleagu_County | County | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.postcode | colleagu_PostalCode | ZIP/Postal Code | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.country | colleagu_Country | Country/Region | Company Address (colleagu_colleagueaddress) | Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId). |
Manager.address.countryCode | colleagu_Country | Country/Region | Company Address (colleagu_colleagueaddress) | Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code). |
Manager.commsDisabled | TRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE. | N/A | N/A | |
OVERTIME RATE/RATE FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Rate.backendRef (Standard) | colleagu_placementId | Placement | Placement (colleagu_placement) | |
Rate.name (Standard) | If Placement -> Pay/Charge Unit is 'Hourly' then "STANDARD" else "STANDARDH". | N/A | N/A | |
Rate.payElementCode (Standard) | Pay Element Code fetched from InTime (matched by 'name'). | N/A | N/A | Uses the Global Setting Standard Rate Name value based on which Pay/Charge Unit is select (there has to be a equivalent named value in InTime). |
Rate.charge (Standard) | colleagu_chargerate | Charge Rate | Placement (colleagu_placement) | |
Rate.pay (Standard - Contract) | colleagu_PayRate | Pay Rate | Placement (colleagu_placement) | |
Rate.pay (Standard - Perm) | colleagu_salary | Annual Pay | Placement (colleagu_placement) | |
Rate.period (Standard) | If Placement -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'fixed'. | N/A | Placement (colleagu_placement) | |
Rate.backendRef (Overtime/Other) | colleagu_overtimerateId | Overtime Rate | Overtime Rate (colleagu_overtimerate) | |
Rate.name (Overtime/Other) | colleagu_payelement | Pay Element | Overtime Rate (colleagu_overtimerate) | Uses the Pay Element Name (Option Set Label) to match the Code in InTime (so there has to be a equivalent named value in InTime). |
Rate.payElementCode (Overtime/Other) | Pay Element Code fetched from InTime (matched by 'name'). | N/A | Overtime Rate (colleagu_overtimerate) | |
Rate.charge (Overtime/Other) | colleagu_ChargeRate | Charge Rate | Overtime Rate (colleagu_overtimerate) | |
Rate.pay (Overtime/Other) | colleagu_PayRate | Pay Rate | Overtime Rate (colleagu_overtimerate) | |
Rate.period (Overtime/Other) | If Overtime Rate -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'fixed'. | N/A | Overtime Rate (colleagu_overtimerate) | |
Rates.timesheetFields (All) | If Placement -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'decimal'. | N/A | Placement (colleagu_placement) | Based on Placement Pay/Charge Unit (colleagu_chargeunit). |
Rate.periodDuration (All) | If Placement -> Pay/Charge Unit is 'Hourly' value is 60, otherwise value is Placement -> Hours Per Day * 60. | N/A | Placement (colleagu_placement) | Based on Placement Pay/Charge Unit (colleagu_chargeunit) and Hours Per Day (colleagu_HoursPerDay) fields. |
Rate.selectableByWorkers (All) | TRUE/checked. | N/A | N/A | This value is always set to TRUE/checked. |
COMMISSION SPLIT/SPLIT COMMISSION FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
SplitCommission.userId | colleagu_User | User | User (SystemUser) | |
SplitCommission.weight | colleagu_Percentage | Percentage | Commission Split (colleagu_commissionsplit) | |
APPROVER (ALTERNATIVE MANAGER) FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Placement.manager (Single) | colleagu_Person | Person | Approver (colleagu_approver) | Set as the Primary Manager in InTime if the Primary Manager field is set to 'Yes', otherwise the Placement's Contact is set as the Primary Manager. |
Placement.alternativeManagers (Many) | colleagu_Person | Person | Approver (colleagu_approver) | Added to the Alternative Managers list in InTime if the Primary Manager field is set to 'No'. |
N/A | colleagu_PrimaryApprover | Primary Approver? | Approver (colleagu_approver) | Not mapped - Sets which Manager is the Primary Manager (there can only be one set in Pump/sent to InTime). |
PLACEMENT FIELDS | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
Placement.externalId | colleagu_name | Placement (colleagu_placement) | Placement Reference is formatted to fit the 20 character limit. | |
Placement.refCode | colleagu_placementId | Placement | Placement (colleagu_placement) | |
Placement.purchaseOrderNum | colleagu_name | Purchase Order Number | Purchase Order (colleagu_purchaseorder) | |
Placement.start | colleagu_startdate | Start Date | Placement (colleagu_placement) | |
Placement.end | colleagu_enddate | End Date | Placement (colleagu_placement) | |
Placement.placed | colleagu_Level2AuthorisedOn | Level 2 Authorised On | Placement (colleagu_placement) | |
Placement.jobTitle | colleagu_jobtitle | Job Title | Requirement (colleagu_requirement) | |
Placement.jobDescription | Not mapped | |||
Placement.perm | colleagu_Type | Job Type | Requirement (colleagu_requirement) | True if Job Type = Permanent, otherwise false. |
Placement.salesSector | colleagu_InTimeSalesSector | Sales Sector | Placement (colleagu_placement) | |
Placement.salesBranch | colleagu_InTimeSalesBranch | Sales Branch | Placement (colleagu_placement) | |
Placement.salesDepartment | colleagu_InTimeSalesDepartment | Sales Department | Placement (colleagu_placement) | |
Placement.salesLocation | colleagu_InTimeSalesLocation | Sales Location | Placement (colleagu_placement) | |
Placement.salesProject | colleagu_InTimeSalesProject | Sales Project | Placement (colleagu_placement) | |
Placement.salesCostCentre | colleagu_InTimeSalesCostCentre | Sales Cost Centre | Placement (colleagu_placement) | |
Placement.salesDivision | colleagu_InTimeSalesDivision | Sales Division | Placement (colleagu_placement) | |
Placement.purchaseSector | colleagu_InTimePurchaseSector | Purchase Sector | Placement (colleagu_placement) | |
Placement.purchaseBranch | colleagu_InTimePurchaseBranch | Purchase Branch | Placement (colleagu_placement) | |
Placement.purchaseDepartment | colleagu_InTimePurchaseDepartment | Purchase Department | Placement (colleagu_placement) | |
Placement.purchaseLocation | colleagu_InTimePurchaseLocation | Purchase Location | Placement (colleagu_placement) | |
Placement.purchaseProject | colleagu_InTimePurchaseProject | Purchase Project | Placement (colleagu_placement) | |
Placement.purchaseCostCentre | colleagu_InTimePurchaseCostCentre | Purchase Cost Centre | Placement (colleagu_placement) | |
Placement.purchaseDivision | colleagu_InTimePurchaseDivision | Purchase Division | Placement (colleagu_placement) | |
Placement.noCommunications | colleagu_DisablePlacementEmails | Disable Placement Emails | Placement (colleagu_placement) | Multi-Select Option Set is mapped in the following way from Pump to InTIme: Candidate = Worker, Contact = Manager, User = Consultant and Limited User = Ltd User. |
Placement.worker | colleagu_PlacedCandidate | Candidate | Placement (colleagu_placement) | InTime Record is created before syncing/attaching to the Placement. |
Placement.consultant | ownerid | Owner | Placement (colleagu_placement) | InTime Record is created before syncing/attaching to the Placement. |
Placement.client | colleagu_InvoiceCompany | Invoice Company | Placement (colleagu_placement) | InTime Record is created before syncing/attaching to the Placement. |
Placement.manager | colleagu_Contact | Contact | Placement (colleagu_placement) | InTime Record is created before syncing/attaching to the Placement. |
Placement.rates | Placements can be associated with multiple Overtime Rate Records. | N/A | Overtime Rate (colleagu_overtimerate) | InTime Records are created before syncing/attaching to the Placement. |
Placement.splits | Placements can be associated with multiple Commision Split Records. | N/A | Commission Split (colleagu_commissionsplit) | InTime Records are created before syncing/attaching to the Placement. |
Placement.timesheetApprovalRoute | colleagu_TimesheetApprovalRoute | Timesheet Approval Route | Placement (colleagu_placement) | |
Placement.chargeableExpenseApprovalRoute | colleagu_ChargeableExpenseApprovalRoute | Chargeable Expense Approval Route | Placement (colleagu_placement) | |
Placement.nonChargeableExpenseApprovalRoute | colleagu_NonChargeableExpenseApprovalRoute | Non-Chargeable Expense Approval Route | Placement (colleagu_placement) | |
Placement.clientSite | colleagu_WorkingComp.Name | Working At Company | Placement (colleagu_placement) | |
Placement.chargeTermsDaysOverride | 30 | N/A | N/A | Value is always set to 30. |
Placement.chargeTermsTypeOverride | 'Days From Invoice Date' | N/A | N/A | Value is always set to 'Days From Invoice Date'. |
Placement.chargeTermsOverride | colleagu_ChargeTerms | Charge Terms | Placement (colleagu_placement) | |
Placement.invoiceContactOverride | Various values (see Notes). | N/A | Placement (colleagu_placement) | The Invoice Contact is populated with the Placement -> Invoice Contact -> First Name, Last Name, Business Phone, Mobile Phone and Placement -> Invoice Company Address. Email 1 comes from the Invoice Company. |
SETTINGS FIELDS (NOT MAPPED) | ||||
InTime Field | Pump Field/Value | Display Name | Entity Name | Notes |
N/A | colleagu_BackOfficeIntegration | Pay and Bill Integration Provider | Global Settings (colleague_globalsettings) | Needs to be set to 'InTime' to enable InTime. |
N/A | colleagu_PayandBillIntegrationUsername | Pay and Bill Integration Username | Global Settings (colleague_globalsettings) | InTime Username. |
N/A | colleagu_PayandBillIntegrationPassword | Pay and Bill Integration Password | Global Settings (colleague_globalsettings) | InTime Password. |
N/A | colleagu_PayandBillIntegrationAgencyRefCode | Pay and Bill Integration Agency Ref Code | Global Settings (colleague_globalsettings) | InTime Agency Ref. |
N/A | colleagu_PayandBillIntegrationPushISOCountryCode | Pay and Bill Integration Sync Country ISO Code? | Global Settings (colleague_globalsettings) | Sets whether Country Codes are synced to InTime. |
N/A | colleagu_PayandBillIntegrationUseOwningCompCreds | Pay and Bill Integration Use Owning Comp Creds | Global Settings (colleague_globalsettings) | Sets whether Global Settings (single-login) or Owning Company (multiple-logins) credentials are used. |
N/A | colleagu_PayandBillIntegrationStandardDailyRateNam | Pay and Bill Integration Standard Daily Rate Name | Global Settings (colleague_globalsettings) | The Standard Rate Name used in InTime where Pay/Charge Unit is 'Daily'. |
N/A | colleagu_PayandBillIntegrationStandardHourlyRateNa | Pay and Bill Integration Standard Hourly Rate Name | Global Settings (colleague_globalsettings) | The Standard Rate Name used in InTime where Pay/Charge Unit is 'Hourly'. |
N/A | colleagu_PayandBillIntegrationStandardMonthRateNam | Pay and Bill Integration Standard Month Rate Name | Global Settings (colleague_globalsettings) | The Standard Rate Name used in InTime where Pay/Charge Unit is 'Monthly'. |
N/A | colleagu_PayandBillIntegrationStandardWeeklyRateNa | Pay and Bill Integration Standard Weekly Rate Name | Global Settings (colleague_globalsettings) | The Standard Rate Name used in InTime where Pay/Charge Unit is 'Weekly'. |
N/A | colleagu_PayandBillIntegrationUsername | Pay and Bill Integration Username | Owning Company (colleagu_owningcompany) | Used when an organisation needs to post to multiples logins/environments. Taken from the Sales Owing Company Lookup on the Placement. |
N/A | colleagu_PayandBillIntegrationPassword | Pay and Bill Integration Password | Owning Company (colleagu_owningcompany) | Used when an organisation needs to post to multiples logins/environments. Taken from the Sales Owing Company Lookup on the Placement. |
N/A | colleagu_PayandBillIntegrationAgencyRefCode | Pay and Bill Integration Agency Ref Code | Owning Company (colleagu_owningcompany) | Used when an organisation needs to post to multiples logins/environments. Taken from the Sales Owing Company Lookup on the Placement. |