Importing backfills and internal transfers
When importing people and jobs via spreadsheet, ChartHop gives you control over how backfills are created and linked. This page covers the two backfill import columns, ChartHop's data model for overlapping roles, and the recommended workflow.
ChartHop's data model for overlapping roles
ChartHop does not support two people in the same job simultaneously. When an employee is leaving and a replacement is onboarding, these are always two separate jobs — they may share a title, but they are distinct records.
If your source system uses a position ID, two jobs may temporarily share the same ID during an overlap. ChartHop cannot resolve which person belongs where based on position ID alone — use work email as the unique matching identifier instead.
The two backfill columns
backfillJob — suppress automatic backfill creation
Uploading a departure or termination automatically creates a backfill job by default. To prevent this, set backfillJob to No.
backfill — link a person as the backfill for a departing employee
Set backfill to the work email of the departing employee to link the incoming person's job as their backfill. This carries over work history and connects the two jobs.
The job must already exist before you assign someone to it. Create it first — manually or in a prior import row — then set backfill on the incoming person's row.
Recommended workflow
- Ensure the open job exists. Omit backfillJob (or set it to Yes) when uploading the departure to auto-create the backfill job.
- Import the incoming person with backfill set to the departing employee's work email.
workEmail | firstName | lastName | title | startDate | backfill |
|---|---|---|---|---|---|
Jane | New | Senior Engineer | 7/1/2025 |
Position ID matching
- Position ID alone cannot resolve job assignment during an overlap period.
- Work email is unique per person and is the recommended matching field.
- If both employees are already placed in their jobs, work email matching routes data correctly with no manual intervention.
- If neither is placed yet, manual setup will be needed.
Modules: HRIS | Engagement | Goals | Performance | Compensation Reviews | Headcount Planning
