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/customers.md 4,331 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

Brink mapping for `curated.customers`

Main staging sources

staging.brink_sales2_orders

Mapping groups

Business property mappings describe how Brink customer content is mapped or could be 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
`guid`	`staging.brink_sales2_orders`	`customer_id`	`NULL`	`Not mapped`	Brink exposes a transactional customer GUID on orders, not a customer master row.
`external_id`	`staging.brink_sales2_orders`	`customer_id`	`NULL`	`Not mapped`	Same source as `customer_id`; there is no separate external customer ID in the documented Brink staging model.
`name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer-name field is documented in Brink staging.
`phone`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer phone field is documented in Brink staging.
`phone2`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer secondary phone field is documented in Brink staging.
`address`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer address field is documented in Brink staging.
`city`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer city field is documented in Brink staging.
`state`	N/A	N/A	`NULL`	`Not mapped`	No customer state field is documented in Brink staging.
`zip`	N/A	N/A	`NULL`	`Not mapped`	No customer ZIP field is documented in Brink staging.
`country`	N/A	N/A	`NULL`	`Not mapped`	No customer country field is documented in Brink staging.
`email`	N/A	N/A	`NULL`	`Not mapped`	No customer email field is documented in Brink staging.
`store_guid`	N/A	N/A	`NULL`	`Not mapped`	The documented Brink staging model does not expose a store GUID on customer data.
`create_time`	N/A	N/A	`NULL`	`Not mapped`	No customer-create timestamp is documented in Brink staging.
`is_deleted`	N/A	N/A	`NULL`	`Not mapped`	No customer soft-delete flag is documented in Brink staging.
`customer_status`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer lifecycle status is documented in Brink staging.
`home_store_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer home-store field is documented in Brink staging.
`created_at_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer-create timestamp is documented in Brink staging.
`updated_at_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer-update timestamp is documented in Brink staging.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`customer_key`	N/A	N/A	`NULL`	`Not mapped`	Warehouse-generated key.
`source_system`	N/A	N/A	`constant 'brink_pos'`	`Derived constant`	Warehouse constant, not a Brink API field.
`source_customer_id`	`staging.brink_sales2_orders`	`customer_id`	`NULL`	`Not mapped`	Best available source identifier.
`tenant_key`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse-generated tenant key.
`tenant_name`	`N/A`	`N/A`	`parameter @tenant_id`	`ETL context`	Tenant metadata is outside the documented Brink staging payloads.
`is_current`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse SCD field.
`effective_from_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse SCD field.
`effective_to_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse SCD field.
`_etl_batch_id`	staging.brink_sales2_orders	_etl_batch_id	`_etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	staging.brink_sales2_orders	_etl_source_type	`_etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	staging.brink_sales2_orders	_etl_ingested_at_utc	`_etl_ingested_at_utc AS _etl_ingested_at`	`Mapped`	ETL metadata propagated from staging.

Portal and sample validation

No additional customer master source was confirmed in the Brink portal WSDLs or in the available temp responses.