...
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)
...
| 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. |