Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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


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 FieldPump Field/ValueDisplay NameEntity NameNotes
Worker.externalIdcolleagu_PersonReferencePerson ReferencePerson (Contact)
Worker.refCodeContactIdPersonPerson (Contact)
Worker.commsDisabledTRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE.N/AN/A
Worker.emailDisabledTRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE.N/AN/A
Worker.workerTypecolleagu_PaymentMethodPayment MethodPlacement (colleagu_placement)If Payment Method = Umbrella, value is 'umbrella', if Payment Method = PAYE, value is 'paye', otherwsie value is 'ltd'.
Worker.limitedCompanycolleagu_ContractorCompanyContractor CompanyPlacement (colleagu_placement)NO RESPECTIVE CLIENT RECORD IS CREATED IN INTIME
Worker.limitedCompanyProviderExternalIdcolleagu_CompanyReferenceCompany ReferenceCompany (Account)Linked Field: colleagu_placement.colleagu_ContratorCompany (Placement - Contractor Company).
Worker.limitedCompanyProviderIdInTime Limited Company Provider IDN/AN/AOutput ID from InTime.
Worker.ltdCompanyContact.firstnamecolleagu_CandidateFirstNameCandidate First NamePlacement (colleagu_placement)
Worker.ltdCompanyContact.lastnamecolleagu_CandidateLastNameCandidate Last NamePlacement (colleagu_placement)
Worker.ltdCompanyContact.emailEMailAddress1Email 1Person (Contact)Person Lookup: Placement - Candidate (colleagu_PlacedCandidate).
Worker.ltdCompanyContact.address.line1colleagu_ContractAddressStreet1Contractor Company Address Street 1Placement (colleagu_placement)
Worker.ltdCompanyContact.address.line2colleagu_ContractAddressStreet2Contractor Company Address Street 2Placement (colleagu_placement)
Worker.ltdCompanyContact.address.towncolleagu_ContractAddressCityContractor Company Address CityPlacement (colleagu_placement)
Worker.ltdCompanyContact.address.countycolleagu_ContractAddressCountyContractor Company Address CountyPlacement (colleagu_placement)
Worker.ltdCompanyContact.address.postcodecolleagu_ContractAddressZipPostalCodeContractor Company Address ZIP/Postal CodePlacement (colleagu_placement)
Worker.ltdCompanyContact.address.countrycolleagu_ContractAddressCountryContractor Company Address Country/RegionPlacement (colleagu_placement)
Worker.ltdCompanyContact.address.countryCodecolleagu_ContractAddressCountryContractor Company Address Country/RegionPlacement (colleagu_placement)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).
Worker.firstnamecolleagu_CandidateFirstNameCandidate First NamePlacement (colleagu_placement)
Worker.lastnamecolleagu_CandidateLastNameCandidate Last NamePlacement (colleagu_placement)
Worker.emailEMailAddress1Email 1Person (Contact)Person Lookup: Placement - Candidate (colleagu_PlacedCandidate).
Worker.phoneTelephone1Business PhonePerson (Contact)Person Lookup: Placement - Candidate (colleagu_PlacedCandidate).
Worker.mobileMobilePhoneMobile PhonePerson (Contact)Person Lookup: Placement - Candidate (colleagu_PlacedCandidate).
Worker.address.line1colleagu_CandidateAddressStreet1Candidate Personal Address Street 1Placement (colleagu_placement)
Worker.address.line2colleagu_CandidateAddressStreet2Candidate Personal Address Street 2Placement (colleagu_placement)
Worker.address.towncolleagu_CandidateAddressCityCandidate Personal Address CityPlacement (colleagu_placement)
Worker.address.countycolleagu_CandidateAddressCountyCandidate Personal Address CountyPlacement (colleagu_placement)
Worker.address.postcodecolleagu_CandidateAddressZIPPostalCodeCandidate Personal Address ZIP/Postal CodePlacement (colleagu_placement)
Worker.address.countrycolleagu_CandidateAddressCountryRegionCandidate Personal Address Country/RegionPlacement (colleagu_placement)
Worker.address.countryCodecolleagu_CandidateAddressCountryRegionCandidate Personal Address Country/RegionPlacement (colleagu_placement)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).
Worker.titlecolleagu_TitleTitlePerson (Contact)
Worker.dateOfJoiningCreatedOnCreated OnPerson (Contact)
Worker.timesheetsOnInvoicesValue is always set to checked.N/AN/A
Worker.gendercolleagu_GenderGenderPlacement (colleagu_placement)M or F.
Worker.dateOfBirthcolleagu_candidatedateofbirthCandidate Date of BirthPlacement (colleagu_placement)
Worker.paymentFrequencycolleagu_Payment_FrequencyPayment FrequencyPlacement (colleagu_placement)There has to be a equivalent index value in InTime.
Worker.accountsReferencecolleagu_CandidateAccountReferenceCandidate Account ReferencePlacement (colleagu_placement)
Worker.bankAccount.bankcolleagu_CandidateBankNameCandidate Bank NamePlacement (colleagu_placement)
Worker.bankAccount.bankaccountNamecolleagu_CandidateBankAccountNameCandidate Bank Account NamePlacement (colleagu_placement)
Worker.bankAccount.banksortCodecolleagu_CandidateBankAccountSortCodeCandidate Bank Account Sort CodePlacement (colleagu_placement)
Worker.bankAccount.bankaccountNumbercolleagu_CandidateBankAccountNumberCandidate Bank Account NumberPlacement (colleagu_placement)
Worker.nationalInsuranceNumbercolleagu_NationalInsuranceNumberNational Insurance NumberPlacement (colleagu_placement)
Worker.niTableLettercolleagu_NationalInsuranceNumberNational Insurance NumberPlacement (colleagu_placement)First letter of the NI Number.
Worker.defaultPaymentCurrencycolleagu_PayCurrencyPay CurrencyPlacement (colleagu_placement)Linked Record: TransactionCurrency.ISOCurrencyCode (Currency - ISO Code). An equivalent Exhange Rate containing this currency must exist in InTime.
Worker.vatCodecolleagu_CandidateTaxCodeCandidate Tax CodePlacement (colleagu_placement)There must be an eqivalent named option in InTime (code doesn't need to match).
Worker.selfBillingcolleagu_AllowSelfBillingAllow Candidate Self Billing?Placement (colleagu_placement)





USER/CONSULTANT FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Consultant.externalIdInternalEMailAddressPrimary EmailUser (SystemUser)Special characters removed (e.g. @), uppercase, limited to 30 characters.
Consultant.refCodeSystemUserIdUserUser (SystemUser)
Consultant.emailInternalEMailAddressPrimary EmailUser (SystemUser)
Consultant.refCodeSystemUserIdUserUser (SystemUser)
Consultant.firstnameFirstNameFirst NameUser (SystemUser)
Consultant.lastnameLastNameLast NameUser (SystemUser)
Consultant.phoneAddress1_Telephone1Main PhoneUser (SystemUser)
Consultant.mobileMobilePhoneMobile PhoneUser (SystemUser)
Consultant.address.line1Address1_Line1Street 1User (SystemUser)
Consultant.address.line2Address1_Line2Street 2User (SystemUser)
Consultant.address.townAddress1_CityCityUser (SystemUser)
Consultant.address.countyAddress1_CountyAddress 1: CountyUser (SystemUser)
Consultant.address.postcodeAddress1_PostalCodeZIP/Postal CodeUser (SystemUser)
Consultant.address.countryAddress1_CountyCountry/RegionUser (SystemUser)
Consultant.address.countryCodeAddress1_CountyCountry/RegionUser (SystemUser)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).





COMPANY/CLIENT FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Client.externalIdcolleagu_CompanyReferenceCompany ReferenceCompany (Account)
Client.refCodeAccountIdCompanyCompany (Account)
Client.nameNameCompany NameCompany (Account)
Client.companyNocolleagu_InvoiceCompanyRegistrationNumber OR colleagu_ContractorCompanyRegistrationNumberInvoice Company Registration Number OR Cpntractor Company Registration NumberPlacement (colleagu_placement)Field used is based on whether the Company is an Invoice Company or not.
Client.companyVatNocolleagu_InvoiceCompanyVATNumber OR colleagu_ContractorCompanyVATNumberInvoice Company VAT Number OR Contractor Company VAT NumberPlacement (colleagu_placement)Field used is based on whether the Company is an Invoice Company or not.
Client.vatCodecolleagu_InvoiceCompany_TaxCode OR colleagu_ContractorCompany_TaxCodeInvoice Company Address Tax Code OR Contractor Company Address Tax CodePlacement (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.accountsRefcolleagu_InvoiceCompanyAccountReference OR colleagu_ContractorCompanyAccountReferenceInvoice Company Reference OR Contractor Company ReferencePlacement (colleagu_placement)Field used is based on whether the Company is an Invoice Company or not.
Client.invoicePeriodcolleagu_InvoiceFrequencyInvoice FrequencyPlacement (colleagu_placement)There has to be a equivalent named value in InTime.
Client.invoiceDeliveryMethodValue is always set to 'Email'.N/AN/A
Client.currencyTransactionCurrencyIdCharge 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.firstnameFirstNameFirst NamePerson (Contact)Person Lookup: Hiring Company - Primary Contact (PrimaryContactId).
Client.primaryContact.lastnameLastNameLast NamePerson (Contact)Person Lookup: Hiring Company - Primary Contact (PrimaryContactId).
Client.primaryContact.emailEMailAddress1Email 1Person (Contact)Person Lookup: Hiring Company - Primary Contact (PrimaryContactId).
Client.primaryContact.phoneTelephone1Business PhonePerson (Contact)Person Lookup: Hiring Company - Primary Contact (PrimaryContactId).
Client.primaryContact.mobileMobilePhoneMobile PhonePerson (Contact)Person Lookup: Hiring Company - Primary Contact (PrimaryContactId).
Client.primaryContact.address.line1colleagu_InvoiceAddressStreet1Invoice Company Address Street 1Placement (colleagu_placement)
Client.primaryContact.address.line2colleagu_InvoiceAddressStreet2Invoice Company Address Street 2Placement (colleagu_placement)
Client.primaryContact.address.towncolleagu_InvoiceAddressCityInvoice Company Address CityPlacement (colleagu_placement)
Client.primaryContact.address.countycolleagu_InvoiceAddressCountyInvoice Company Address CountyPlacement (colleagu_placement)
Client.primaryContact.address.postcodecolleagu_InvoiceAddressZipPostalCodeInvoice Company Address ZIP/Postal CodePlacement (colleagu_placement)
Client.primaryContact.address.countrycolleagu_InvoiceAddressCountryInvoice Company Address Country/RegionPlacement (colleagu_placement)
Client.primaryContact.address.countryCodecolleagu_InvoiceAddressCountryInvoice Company Address Country/RegionPlacement (colleagu_placement)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).
Client.termsTemplateNamecolleagu_PayTerms (for companies created as Clients (i.e. not Limited Companies).)Pay TermsPlacement (colleagu_placement)
Client.termsTypecolleagu_PayTermsType (for companies created as Clients (i.e. not Limited Companies).)Pay Terms TypePlacement (colleagu_placement)
Client.termsDaysValue is always 30 for companies created as Clients (i.e. not Limited Companies).N/AN/A
Client.consolidation and Client.groupingValue is always set to 'Each Worker Is Invoiced Separately'.N/AN/AInTime field is name 'What Goes On Each Invoice?' but is set via the consolidation and grouping fields in the API.
Client.timesheetsOnInvoicesValue is always set to 'Yes'.N/AN/A
Client.paperOnInvoicesValue is always no/un-ticked.N/AN/A





UMBRELLA COMPANY/PROVIDER FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Provider.namecolleagu_ContractorCompany.NameContractor CompanyPlacement (colleagu_placement)
Provider.companyNocolleagu_ContractorCompanyVATNumberContractor Company VAT NumberPlacement (colleagu_placement)
Provider.vatCodecolleagu_ContractorCompany_TaxCodeContractor Company Tax CodePlacement (colleagu_placement)There must be an eqivalent named option in InTime (code doesn't need to match).
Provider.accountsRefcolleagu_ContractorCompanyAccountReferenceContractor Company Account ReferencePlacement (colleagu_placement)
Provider.currencycolleagu_PayCurrencyPay CurrencyPlacement (colleagu_placement)
Provider.invoicingContact.address.line1colleagu_ContractAddressStreet1Contractor Company Address Street 1Placement (colleagu_placement)
Provider.invoicingContact.address.line2colleagu_ContractAddressStreet2Contractor Company Address Street 2Placement (colleagu_placement)
Provider.invoicingContact.address.towncolleagu_ContractAddressCityContractor Company Address CityPlacement (colleagu_placement)
Provider.invoicingContact.address.countycolleagu_ContractAddressCountyContractor Company Address CountyPlacement (colleagu_placement)
Provider.invoicingContact.address.postcodecolleagu_ContractAddressZipPostalCodeContractor Company Address ZIP/Postal CodePlacement (colleagu_placement)
Provider.invoicingContact.address.countrycolleagu_ContractAddressCountryContractor Company Address Country/RegionPlacement (colleagu_placement)
Provider.invoicingContact.address.countryCodecolleagu_ContractAddressCountryContractor Company Address Country/RegionPlacement (colleagu_placement)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).
Provider.invoicePeriodcolleagu_CandidateInvoiceFrequencyCandidate Invoice FrequencyPlacement (colleagu_placement)
Provider.invoiceDeliveryMethodAlways set to 'Email'.N/AN/A
Provider.selfBillingcolleagu_AllowSelfBillingAllow Candidate Self Billing?Placement (colleagu_placement)
Client.consolidation and Client.groupingValue is always set to 'Each Worker Is Invoiced Separately'.N/AN/A





CONTACT/MANAGER FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Manager.externalIdcolleagu_PersonReferencePerson ReferencePerson (Contact)
Manager.refCodeContactIdContactPerson (Contact)
Manager.firstnamecolleagu_ContactFirstNameContact First NamePlacement (colleagu_placement)
Manager.lastnamecolleagu_ContactLastNameContact Last NamePlacement (colleagu_placement)
Manager.emailEMailAddress1 (see note)Email 1Person (Contact) (see note)Limited Company Contact email is the Contractor Company Email Address (emailaddress1)
Manager.phoneTelephone1Business PhonePerson (Contact)
Manager.mobileMobilePhoneMobile PhonePerson (Contact)
Manager.clientInTime ClientN/AN/AInTime Record is created before syncing/attaching to the Manager.
Manager.address.line1colleagu_Street1Street 1Company Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.line2colleagu_Street2Street 2Company Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.towncolleagu_CityCityCompany Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.countycolleagu_CountyCountyCompany Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.postcodecolleagu_PostalCodeZIP/Postal CodeCompany Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.countrycolleagu_CountryCountry/RegionCompany Address (colleagu_colleagueaddress)Company Address Lookup: Person - Working At Address (colleagu_CompanyAddressId).
Manager.address.countryCodecolleagu_CountryCountry/RegionCompany Address (colleagu_colleagueaddress)Linked Record: colleagu_country.colleagu_ISOCode (Country - ISO Code).
Manager.commsDisabledTRUE if Job Type = 'Perm' OR Placement Contact = Primary Manager, otherwise FALSE.N/AN/A





OVERTIME RATE/RATE FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Rate.backendRef (Standard)colleagu_placementIdPlacementPlacement (colleagu_placement)
Rate.name (Standard)If Placement -> Pay/Charge Unit is 'Hourly' then "STANDARD" else "STANDARDH".N/AN/A
Rate.payElementCode (Standard)Pay Element Code fetched from InTime (matched  by 'name').N/AN/AUses 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_chargerateCharge RatePlacement (colleagu_placement)
Rate.pay (Standard - Contract)colleagu_PayRatePay RatePlacement (colleagu_placement)
Rate.pay (Standard - Perm)colleagu_salaryAnnual PayPlacement (colleagu_placement)
Rate.period (Standard)If Placement -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'fixed'.N/APlacement (colleagu_placement)
Rate.backendRef (Overtime/Other)colleagu_overtimerateIdOvertime RateOvertime Rate (colleagu_overtimerate)
Rate.name (Overtime/Other)colleagu_payelementPay ElementOvertime 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/AOvertime Rate (colleagu_overtimerate)
Rate.charge (Overtime/Other)colleagu_ChargeRateCharge RateOvertime Rate (colleagu_overtimerate)
Rate.pay (Overtime/Other)colleagu_PayRatePay RateOvertime Rate (colleagu_overtimerate)
Rate.period (Overtime/Other)If Overtime Rate -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'fixed'.N/AOvertime Rate (colleagu_overtimerate)
Rates.timesheetFields (All)If Placement -> Pay/Charge Unit is 'Hourly' value is 'hours', otherwise value is 'decimal'.N/APlacement (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/APlacement (colleagu_placement)Based on Placement Pay/Charge Unit (colleagu_chargeunit) and Hours Per Day (colleagu_HoursPerDay) fields.
Rate.selectableByWorkers (All)TRUE/checked.N/AN/AThis value is always set to TRUE/checked.





COMMISSION SPLIT/SPLIT COMMISSION FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
SplitCommission.userIdcolleagu_UserUserUser (SystemUser)
SplitCommission.weightcolleagu_PercentagePercentageCommission Split (colleagu_commissionsplit)





APPROVER (ALTERNATIVE MANAGER) FIELDS
InTime FieldPump Field/ValueDisplay NameEntity NameNotes
Placement.manager (Single)colleagu_PersonPersonApprover (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_PersonPersonApprover (colleagu_approver)Added to the Alternative Managers list in InTime if the Primary Manager field is set to 'No'.
N/Acolleagu_PrimaryApproverPrimary 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 FieldPump Field/ValueDisplay NameEntity NameNotes
Placement.externalIdcolleagu_name
Placement (colleagu_placement)Placement Reference is formatted to fit the 20 character limit.
Placement.refCodecolleagu_placementIdPlacementPlacement (colleagu_placement)
Placement.purchaseOrderNumcolleagu_namePurchase Order NumberPurchase Order (colleagu_purchaseorder)
Placement.startcolleagu_startdateStart DatePlacement (colleagu_placement)
Placement.endcolleagu_enddateEnd DatePlacement (colleagu_placement)
Placement.placedcolleagu_Level2AuthorisedOnLevel 2 Authorised OnPlacement (colleagu_placement)
Placement.jobTitlecolleagu_jobtitleJob TitleRequirement (colleagu_requirement)
Placement.jobDescription


Not mapped
Placement.permcolleagu_TypeJob TypeRequirement (colleagu_requirement)True if Job Type = Permanent, otherwise false.
Placement.salesSectorcolleagu_InTimeSalesSectorSales SectorPlacement (colleagu_placement)
Placement.salesBranchcolleagu_InTimeSalesBranchSales BranchPlacement (colleagu_placement)
Placement.salesDepartmentcolleagu_InTimeSalesDepartmentSales DepartmentPlacement (colleagu_placement)
Placement.salesLocationcolleagu_InTimeSalesLocationSales LocationPlacement (colleagu_placement)
Placement.salesProjectcolleagu_InTimeSalesProjectSales ProjectPlacement (colleagu_placement)
Placement.salesCostCentrecolleagu_InTimeSalesCostCentreSales Cost CentrePlacement (colleagu_placement)
Placement.salesDivisioncolleagu_InTimeSalesDivisionSales DivisionPlacement (colleagu_placement)
Placement.purchaseSectorcolleagu_InTimePurchaseSectorPurchase SectorPlacement (colleagu_placement)
Placement.purchaseBranchcolleagu_InTimePurchaseBranchPurchase BranchPlacement (colleagu_placement)
Placement.purchaseDepartmentcolleagu_InTimePurchaseDepartmentPurchase DepartmentPlacement (colleagu_placement)
Placement.purchaseLocationcolleagu_InTimePurchaseLocationPurchase LocationPlacement (colleagu_placement)
Placement.purchaseProjectcolleagu_InTimePurchaseProjectPurchase ProjectPlacement (colleagu_placement)
Placement.purchaseCostCentrecolleagu_InTimePurchaseCostCentrePurchase Cost CentrePlacement (colleagu_placement)
Placement.purchaseDivisioncolleagu_InTimePurchaseDivisionPurchase DivisionPlacement (colleagu_placement)
Placement.noCommunicationscolleagu_DisablePlacementEmailsDisable Placement EmailsPlacement (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.workercolleagu_PlacedCandidateCandidatePlacement (colleagu_placement)InTime Record is created before syncing/attaching to the Placement.
Placement.consultantowneridOwnerPlacement (colleagu_placement)InTime Record is created before syncing/attaching to the Placement.
Placement.clientcolleagu_InvoiceCompanyInvoice CompanyPlacement (colleagu_placement)InTime Record is created before syncing/attaching to the Placement.
Placement.managercolleagu_ContactContactPlacement (colleagu_placement)InTime Record is created before syncing/attaching to the Placement.
Placement.ratesPlacements can be associated with multiple Overtime Rate Records.N/AOvertime Rate (colleagu_overtimerate)InTime Records are created before syncing/attaching to the Placement.
Placement.splitsPlacements can be associated with multiple Commision Split Records.N/ACommission Split (colleagu_commissionsplit)InTime Records are created before syncing/attaching to the Placement.
Placement.timesheetApprovalRoutecolleagu_TimesheetApprovalRouteTimesheet Approval RoutePlacement (colleagu_placement)
Placement.chargeableExpenseApprovalRoutecolleagu_ChargeableExpenseApprovalRouteChargeable Expense Approval RoutePlacement (colleagu_placement)
Placement.nonChargeableExpenseApprovalRoutecolleagu_NonChargeableExpenseApprovalRouteNon-Chargeable Expense Approval RoutePlacement (colleagu_placement)
Placement.clientSitecolleagu_WorkingComp.NameWorking At CompanyPlacement (colleagu_placement)
Placement.chargeTermsDaysOverride30N/AN/AValue is always set to 30.
Placement.chargeTermsTypeOverride'Days From Invoice Date'N/AN/AValue is always set to 'Days From Invoice Date'.
Placement.chargeTermsOverridecolleagu_ChargeTermsCharge TermsPlacement (colleagu_placement)
Placement.invoiceContactOverrideVarious values (see Notes).N/APlacement (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 FieldPump Field/ValueDisplay NameEntity NameNotes
N/Acolleagu_BackOfficeIntegrationPay and Bill Integration ProviderGlobal Settings (colleague_globalsettings)Needs to be set to 'InTime' to enable InTime.
N/Acolleagu_PayandBillIntegrationUsernamePay and Bill Integration UsernameGlobal Settings (colleague_globalsettings)InTime Username.
N/Acolleagu_PayandBillIntegrationPasswordPay and Bill Integration PasswordGlobal Settings (colleague_globalsettings)InTime Password.
N/Acolleagu_PayandBillIntegrationAgencyRefCodePay and Bill Integration Agency Ref CodeGlobal Settings (colleague_globalsettings)InTime Agency Ref.
N/Acolleagu_PayandBillIntegrationPushISOCountryCodePay and Bill Integration Sync Country ISO Code?Global Settings (colleague_globalsettings)Sets whether Country Codes are synced to InTime.
N/Acolleagu_PayandBillIntegrationUseOwningCompCredsPay and Bill Integration Use Owning Comp CredsGlobal Settings (colleague_globalsettings)Sets whether Global Settings (single-login) or Owning Company (multiple-logins) credentials are used.
N/Acolleagu_PayandBillIntegrationStandardDailyRateNamPay and Bill Integration Standard Daily Rate NameGlobal Settings (colleague_globalsettings)The Standard Rate Name used in InTime where Pay/Charge Unit is 'Daily'.
N/Acolleagu_PayandBillIntegrationStandardHourlyRateNaPay and Bill Integration Standard Hourly Rate NameGlobal Settings (colleague_globalsettings)The Standard Rate Name used in InTime where Pay/Charge Unit is 'Hourly'.
N/Acolleagu_PayandBillIntegrationStandardMonthRateNamPay and Bill Integration Standard Month Rate NameGlobal Settings (colleague_globalsettings)The Standard Rate Name used in InTime where Pay/Charge Unit is 'Monthly'.
N/Acolleagu_PayandBillIntegrationStandardWeeklyRateNaPay and Bill Integration Standard Weekly Rate NameGlobal Settings (colleague_globalsettings)The Standard Rate Name used in InTime where Pay/Charge Unit is 'Weekly'.
N/Acolleagu_PayandBillIntegrationUsernamePay and Bill Integration UsernameOwning 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/Acolleagu_PayandBillIntegrationPasswordPay and Bill Integration PasswordOwning 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/Acolleagu_PayandBillIntegrationAgencyRefCodePay and Bill Integration Agency Ref CodeOwning Company (colleagu_owningcompany)Used when an organisation needs to post to multiples logins/environments. Taken from the Sales Owing Company Lookup on the Placement.



  • No labels