Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)

Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)

Warehouse Model (93)

Analytical data warehouse schemas, curated tables, and Redshift/Athena data models.

warehouse-model/docs/features/ETL/warehouse-data/brinkPos-curated-model-mapps/employees.md 4,378 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

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.