# Brink mapping for `curated.employees`

## Main staging sources used today

- `staging.brink_settings2_employees`

## Mapping groups

- Business property mappings describe how Brink employee content is mapped into curated business fields.
- Technical and ETL property mappings describe lineage, source reconciliation, tenant scoping, and ingestion metadata.

## Business property mappings

| Curated Column | Brink Staging Table | Brink Property Path | Current mapping | Status | Notes |
|---|---|---|---|---|---|
| `employee_id` | `staging.brink_settings2_employees` | `employee_id` | `emp.employee_id` | `Mapped` | Direct Brink employee ID. |
| `display_name` | `staging.brink_settings2_employees` | `display_name` | `emp.display_name` | `Mapped` | Direct display name. |
| `first_name` | `staging.brink_settings2_employees` | `first_name` | `emp.first_name` | `Mapped` | Direct first name. |
| `last_name` | `staging.brink_settings2_employees` | `last_name` | `emp.last_name` | `Mapped` | Direct last name. |
| `email_address` | `staging.brink_settings2_employees` | `email_address` | `emp.email_address` | `Mapped` | Direct email address. |
| `cell_phone` | `staging.brink_settings2_employees` | `cell_phone` | `emp.cell_phone` | `Mapped` | Direct cell phone. |
| `home_location_id` | `staging.brink_settings2_employees` | `home_location_id` | `emp.home_location_id` | `Mapped` | Direct home location identifier. |
| `hire_date` | `staging.brink_settings2_employees` | `hire_date` | `CAST(emp.hire_date AS TIMESTAMP)` | `Mapped` | Cast to TIMESTAMP. |
| `termination_date` | `staging.brink_settings2_employees` | `termination_date` | `CAST(emp.termination_date AS TIMESTAMP)` | `Mapped` | Cast to TIMESTAMP. |
| `terminated` | `staging.brink_settings2_employees` | `terminated` | `emp.terminated` | `Mapped` | Direct terminated flag. |
| `is_salaried` | `staging.brink_settings2_employees` | `is_salaried` | `emp.is_salaried` | `Mapped` | Direct salaried flag. |
| `is_exempt` | `staging.brink_settings2_employees` | `is_exempt` | `emp.is_exempt` | `Mapped` | Direct exempt flag. |
| `payroll_id` | `staging.brink_settings2_employees` | `payroll_id` | `emp.payroll_id` | `Mapped` | Direct payroll identifier. |
| `employee_unique_id` | `staging.brink_settings2_employees` | `employee_unique_id` | `emp.employee_unique_id` | `Mapped` | Direct unique identifier. |
| `snapshot_date` | `staging.brink_settings2_employees` | `snapshot_date` | `CAST(emp.snapshot_date AS DATE)` | `Mapped` | Cast to DATE. |
| `is_active` | `staging.brink_settings2_employees` | `terminated` | `NOT COALESCE(emp.terminated, FALSE)` | `Derived` | Derived from terminated flag; NULL treated as active. |
| `currency_code` | `N/A` | `N/A` | `NULL` | `Not mapped` | No canonical currency source in Brink employee payload. |

## Technical and ETL property mappings

| Curated Column | Brink Staging Table | Brink Property Path | Current mapping | Status | Notes |
|---|---|---|---|---|---|
| `source_system` | `N/A` | `N/A` | constant `'brink_pos'` | `Derived constant` | Warehouse constant. |
| `source_employee_id` | `staging.brink_settings2_employees` | `employee_id` | `CAST(emp.employee_id AS VARCHAR(199))` | `Mapped` | Brink employee ID cast to string for reconciliation. |
| `employee_key` | `N/A` | `N/A` | `NULL` | `Not mapped` | Warehouse-generated key, not assigned by current insert. |
| `tenant_key` | `N/A` | `N/A` | `NULL` | `Not mapped` | Warehouse-generated tenant key, not assigned by current insert. |
| `tenant_name` | `N/A` | `N/A` | parameter `@tenant_id` | `ETL context` | Populated from ETL context, not from Brink payload. |
| `effective_from_utc` | `N/A` | `N/A` | `NULL` | `Not mapped` | SCD2 column deferred. |
| `effective_to_utc` | `N/A` | `N/A` | `NULL` | `Not mapped` | SCD2 column deferred. |
| `is_current` | `N/A` | `N/A` | `NULL` | `Not mapped` | SCD2 column deferred. |
| `_etl_batch_id` | `staging.brink_settings2_employees` | `_etl_batch_id` | `emp._etl_batch_id` | `Mapped` | ETL metadata propagated from staging. |
| `_etl_source_type` | `staging.brink_settings2_employees` | `_etl_source_type` | `emp._etl_source_type` | `Mapped` | ETL metadata propagated from staging. |
| `_etl_ingested_at` | `staging.brink_settings2_employees` | `_etl_ingested_at_utc` | `emp._etl_ingested_at_utc AS _etl_ingested_at` | `Mapped` | ETL metadata propagated from staging. |