Learn about how the data mapping between bob and CloudPay works
Easily send over your payroll data from bob to CloudPay via bob's connector, found in bob's Integrations area. Learn more about how the data mapping works below. For instructions on how to set everything up to sync across the two systems, go here.
Integration type
One-way via SFTP
Direction of data flow
bob to partner app
Sync trigger
Manual sync
Support information
For support with CloudPay, email alliances@cloudpay.net. To learn more about the platform, go here.
For support with bob, reach out to your Customer Success or Account Manager.
What data syncs?
The data is transferred into the following separate reports:
-
New hires: people who joined your organization
-
Changes: updates to personal, employment, or payroll information
-
Terminations: people who are permanently leaving your organization, and need to be removed from the payroll system
Data mapping table
|
bob field |
CloudPay field |
New hires |
Changes |
Terminations |
|
|
Payroll ID |
✔️ |
✔️ |
✔️ |
|
Employee ID |
Employee Number |
✔️ |
✔️ |
✔️ |
|
Start Date |
Employee Start Date |
✔️ |
✔️ |
|
|
|
Effective Date of Personal Details |
✔️ |
✔️ |
|
|
Job Title |
Employee Title |
✔️ |
✔️ |
|
|
First Name |
Employee First Name |
✔️ |
✔️ |
|
|
Middle Name |
Employee Middle Name |
✔️ |
✔️ |
|
|
Last Name |
Employee Last Name |
✔️ |
✔️ |
|
|
|
Maiden or Previous Name |
✔️ |
✔️ |
|
|
Display Name |
Known As |
✔️ |
✔️ |
|
|
Legal Gender |
Gender |
✔️ |
✔️ |
|
|
Marital Status |
Marital Status |
✔️ |
✔️ |
|
|
Custom |
Nationality |
✔️ |
✔️ |
|
|
Custom |
Second Nationality |
✔️ |
✔️ |
|
|
Birth Date |
Date of Birth |
✔️ |
✔️ |
|
|
Address effective date |
Effective Date of Address |
✔️ |
✔️ |
|
|
Address Line 1 |
Address Line 1 |
✔️ |
✔️ |
|
|
Address Line 2 |
Address Line 2 |
✔️ |
✔️ |
|
|
City |
Town |
✔️ |
✔️ |
|
|
|
County |
✔️ |
✔️ |
|
|
State/Province/Region |
State |
✔️ |
✔️ |
|
|
Country |
Country |
✔️ |
✔️ |
|
|
Zipcode/ Postal |
Post Code / Zip Code |
✔️ |
✔️ |
|
|
Work Email |
Work Email Address |
✔️ |
✔️ |
|
|
Employement Effective Date |
Start Date of Contract |
✔️ |
✔️ |
|
|
Start Date |
Original Hire Date |
✔️ |
✔️ |
|
|
Probation End Date |
Probation End Date |
✔️ |
✔️ |
|
|
Employment Contract |
Full Time (F) / Part Time (P) |
✔️ |
✔️ |
|
|
Employment Type |
Permanent (P) / Temporary (T) |
✔️ |
✔️ |
|
|
Job Title |
Job Title / Description |
✔️ |
✔️ |
|
|
Salary Effective Date |
Start Date of Annual Salary |
✔️ |
✔️ |
|
|
Base Salary |
Annual Salary |
✔️ |
✔️ |
|
|
Custom |
Employee Grade |
✔️ |
✔️ |
|
|
Employemen Effective Date |
Working Pattern Effective Date |
✔️ |
✔️ |
|
|
Working pattern |
Working Pattern |
✔️ |
✔️ |
|
|
Working hours |
Contracted Weekly Hours |
✔️ |
✔️ |
|
|
|
Bank Effective Date |
✔️ |
✔️ |
|
|
BACS |
Pay Method |
✔️ |
✔️ |
|
|
Bank Name |
Bank Name |
✔️ |
✔️ |
|
|
Bank Number/Sort Code/ Routing number |
Bank/Sort/Routing Code |
✔️ |
✔️ |
|
|
IBAN |
IBAN Number |
✔️ |
✔️ |
|
|
Swift |
Swift Number |
✔️ |
✔️ |
|
|
Account Number |
Bank Account Number |
✔️ |
✔️ |
|
|
Account Holder Name |
Account Name |
✔️ |
✔️ |
|
|
|
Cost Centre Effective Date |
✔️ |
✔️ |
|
|
Custom |
Cost Centre |
✔️ |
✔️ |
|
|
|
Department Effective Date |
✔️ |
✔️ |
|
|
Department |
Department |
✔️ |
✔️ |
|
|
|
Location Effective Date |
✔️ |
✔️ |
|
|
Site |
Location |
✔️ |
✔️ |
|
|
|
Leave Date |
✔️ |
✔️ |
|
|
|
Leave Reason |
✔️ |
✔️ |
|
|
SSN/ National ID |
Social Security Number |
✔️ |
✔️ |
|
|
According to the country (SSN/ SIN/ NSS) |
Employee ID Number Type |
✔️ |
✔️ |
|
|
Termination Date |
Termination Date |
|
|
✔️ |
|
Termination Reason |
Termination Reason |
|
|
✔️ |
Need more help? If you’re unsure about anything please send us a message through the chat icon below.”