Skip to main content

How to map source data for the first time

This guide explains how to complete your first source mapping in Aragorn AI—linking HRIS columns to standardized fields before data is imported into a project.

T
Written by Tyrone Marhguy

What is source mapping?

Source mapping tells Aragorn AI what each column from your HRIS means and how it should be stored as a standardized field. Integrations read standardized fields—not raw HRIS column names.

Example: Your HRIS sends personal_mobile_phone. You map it to Aragorn AI’s standardized field mobile so every integration sees a consistent name.

Required standardized fields

Aragorn AI requires certain fields before employee records are valid—for example external_employee_id, first_name, last_name, and is_terminated. These appear at the top of the mapping view until mapped. Your HRIS may use different column names (for example, Employee Number for external_employee_id).

Prerequisites

  • A source connection created in your project

  • Valid HRIS credentials saved in Aragorn AI

Map source data for the first time

1. Begin mapping configuration

  1. Log in to your Aragorn AI account.

  2. Open Data Projects and select your project.

  3. Go to the source section.

  4. Click Begin mapping configuration.

  5. Choose Setup new mappings (first-time setup) or Copy from another source if a similar mapping already exists.

Required standardized fields are shown at the top; map those before optional fields.

2. Review source fields

You will see source fields—column names from your HRIS. Aragorn AI may also show sample values to help confirm field meaning when names are ambiguous (for example, contractor_type or division_code).

3. Map to standardized fields

For each source field:

  1. Select or create the matching standardized field name.

  2. Set the correct data type (text, date, money, boolean, etc.).

  3. Review sample values to confirm the mapping is correct.

Source field (HRIS)

Standardized field

F_name

first_name

personal_mobile_phone

mobile

organization_name

company_name

Tip: If salary is mapped to a money data type, blank values are treated as zero. Mapping a text field to money will cause validation errors.

4. Save your mapping

Save the configuration when required fields are mapped and previews look correct.

5. Run your first source sync

Mapping alone does not import all employee data. After configuration, run a source sync to load data into the project.

After first mapping

Your project pipeline shows:

Source → Filter → Enrichment → Final dataset

The final dataset contains the standardized columns you configured—the data integrations use.

Related articles

Did this answer your question?