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

Raw File

Brink POS Curated Mapping

Purpose

This folder maps the current curated warehouse contract to the available Brink POS staging contract.

Each file documents one curated table and shows which Brink staging table and property path can populate each curated field. If Brink does not expose an equivalent field in the documented staging model, the mapping is marked as N/A.

Each mapping file can also include a Portal and sample validation section. That section keeps the current mapping unchanged and records extra lookup endpoints or sample-response fields confirmed in the Brink portal or in local temp responses.

Files

employees.md
labor_shifts.md
pos_destinations.md
pos_jobs.md
pos_menu_items.md
pos_order_items.md
pos_orders.md

Repository Docs & Knowledge Base

Categories

Warehouse Model (93)

Brink POS Curated Mapping

Purpose

Files