Migrate from Mercu to BambooHR

Mercu Employee records map to BambooHR Employee. The primary challenge is Mercu's multi-field Indonesian name format (gelar/title, nama depan/given name, nama tengah/middle name, nama belakang/surname) which we split into BambooHR's First Name and Last Name fields, with the full original concatenated name preserved in a custom employee field (e.g., Full Name Original) for staff directory accuracy. Employee ID from Mercu maps to BambooHR's Employee Number field as the dedupe key. National ID (NIK) and NIDN (lecturer identification number) map to custom fields if the customer requires them post-migration.

Mercu's employment_type (dosen/lecturer, staff, kontrak), academic_rank (asisten ahli, lektor, lektor kepala, profesor), and functional position map to BambooHR's Employment History section as separate employment records. Each employment record in BambooHR captures job title, department, employment status, start date, and end date. We configure the employment history sequence in BambooHR so the most recent academic rank is the primary displayed title, with prior ranks preserved in the employment timeline.

Mercu's faculty and department structure (Fakultas Teknik, Fakultas Ekonomi, etc.) maps to BambooHR's Departments. We create the department hierarchy in BambooHR during the configuration phase, mapping Mercu's parent faculty relationship to BambooHR's department structure. Employees are assigned to their primary department via BambooHR's Department field, with secondary faculty affiliations recorded in a custom multi-select field.

Mercu's employment status values (aktif/active, cuti/leave of absence, kontrak/contract, selesai/terminated) map to BambooHR's Employment Status values. We configure BambooHR's status options during setup to match the source values, with Cuti (academic leave) mapped to a custom status category that BambooHR's standard statuses do not cover natively. Terminated employees from Mercu with an exit date migrate with their termination_date field populated and status set toInactive.

Mercu's historical leave balance records (annual leave, sick leave, cuti akademik, cuti melahirkan, cuti bersama) map to BambooHR's Time Off module. Each leave type in Mercu is matched to the closest BambooHR equivalent (Annual for cuti tahunan, Sick for cuti sakit, Personal for cuti pribadi, Bereavement for cuti duka). Any Mercu-specific leave types without a BambooHR equivalent are recorded in a custom leave type created during the configuration phase, with accrued balances entered as starting balances.

Mercu's supervisor relationship (dosen pembimbing/lecturer supervisor, kepala bagian/head of department) maps to BambooHR's supervisor field on the Employee record. We resolve the supervisor lookup by matching the supervisor's employee number or email from Mercu to the newly created BambooHR Employee record, in dependency order: supervisors are created first so that their BambooHR IDs are available when assigning to subordinates.

Mercu's compensation and payroll summary records (base salary, allowances, deductions by pay period) do not map directly to BambooHR Pay Runs because BambooHR Payroll is a separate paid add-on that many customers do not activate. We map the most recent compensation data to BambooHR's Compensation fields (pay rate, pay type, effective date) as a one-time snapshot, and flag the payroll data migration scope for the customer to decide whether to activate BambooHR Payroll or use an external Indonesian payroll provider.

Mercu's employment contracts and academic agreements migrate as file attachments to BambooHR's Employee Documents module. We extract contract documents from Mercu's document storage, associate each with the correct employee record in BambooHR, and organize by type (Kontrak Kerja, SK Pengangkatan, MoA Dosen). Document content is not parsed or indexed within BambooHR; the file itself is attached and visible in the employee's document tab.

If Mercu's attendance records are in scope, they map to BambooHR's Time Tracking add-on module. BambooHR's Time Tracking is a separate paid feature; if the customer does not activate it, attendance data is not migrated and is flagged for the customer's IT team to configure BambooHR Time Tracking or select an alternative attendance integration.

Mercu's academic credential records (S1, S2, S3 degrees, professional certifications, NIDN) are mapped to BambooHR custom employee fields created during the configuration phase. We create custom fields for highest degree, institution of highest degree, NIDN (for lecturers), professional certifications, and certification expiry date. The academic credential documents themselves are attached to the employee record under Employee Documents.