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.
...
- 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
...
When Placements have Timesheets or Invoices associated with them in InTime, warning banners are displayed on the Placement form.
...
| Anchor | ||||
|---|---|---|---|---|
|
| 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. |
...