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

Raw File

Brink mapping for `curated.kitchen_orders`

Main staging sources

staging.brink_sales2_orders
staging.brink_kitchen_get_order_bump_times
staging.brink_settings2_get_destinations

Mapping groups

Business property mappings describe how Brink order 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`	`id_encoded`	`NULL`	`Not mapped`	Direct Brink order identifier.
`store_guid`	`N/A`	`N/A`	`NULL`	`Not mapped`	The documented Brink staging model does not expose a store GUID on orders.
`destination`	`staging.brink_settings2_get_destinations`	`name`	`NULL`	`Not mapped`	Join on `destination_id`.
`is_priority`	`N/A`	`N/A`	`NULL`	`Not mapped`	No documented Brink order priority flag exists.
`items_count`	`staging.brink_sales2_orders`	`order_count`	`NULL`	`Not mapped`	Brink already exposes a header count field; `order_entries` counts can be used as secondary validation.
`order_type`	`staging.brink_settings2_get_destinations`	`name`	`NULL`	`Not mapped`	Destination is the nearest documented service-channel field.
`pos_terminal`	`staging.brink_sales2_orders`	`terminal_id`	`NULL`	`Not mapped`	Direct terminal ID.
`preparation_time`	`staging.brink_kitchen_get_order_bump_times`	`(first_send_time, bump_time)`	`NULL`	`Not mapped`	Derived kitchen duration from first send to bump.
`done`	`staging.brink_sales2_orders`	`is_closed`	`NULL`	`Not mapped`	Direct completion flag.
`create_time`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Best available order-create/open timestamp.
`is_deleted`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink order staging does not expose a soft-delete flag.
`external_id`	`staging.brink_sales2_orders`	`id_encoded`	`NULL`	`Not mapped`	Best available external string identifier.
`guest_table`	`N/A`	`N/A`	`NULL`	`Not mapped`	No table label is documented on the Brink order payload.
`update_time`	`staging.brink_sales2_orders`	`modified_time`	`NULL`	`Not mapped`	Direct last-modified timestamp.
`phone`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer phone field is documented on the order payload.
`create_local_time`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink exposes UTC timestamps, not local integer time mirrors.
`customer_guid`	`staging.brink_sales2_orders`	`customer_id`	`NULL`	`Not mapped`	Direct customer GUID reference when present.
`smart_order_start_time`	`staging.brink_sales2_orders`	`pickup_time`	`NULL`	`Not mapped`	Best available scheduled/future-order start proxy.
`order_messages`	`staging.brink_sales2_orders`	`order_additional_details`	`NULL`	`Not mapped`	Best available order-level message/details field.
`customer_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No customer-name field is documented on the order payload.
`seat`	`N/A`	`N/A`	`NULL`	`Not mapped`	No seat number field is documented on the Brink order payload.
`order_status`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink exposes status via booleans such as `is_closed`, `is_future_order`, and `is_refund`, not one numeric status code.
`store_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No store name is documented in the Brink order payloads covered here.
`pos_terminal_name`	`staging.brink_settings_get_registers`	`name`	`NULL`	`Not mapped`	Resolve terminal name by joining `staging.brink_sales2_orders` on `terminal_id` to `staging.brink_settings_get_registers` on `register_id`.
`order_status_name`	`staging.brink_sales2_orders`	`(is_closed, is_future_order, is_refund)`	`NULL`	`Not mapped`	Derived readable status from the available order booleans.
`service_channel`	`staging.brink_settings2_get_destinations`	`name`	`NULL`	`Not mapped`	Join on `destination_id`.
`business_date`	`staging.brink_sales2_orders`	`business_date`	`NULL`	`Not mapped`	Direct business date.
`create_time_utc`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Direct UTC timestamp.
`timezone_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	The documented Brink staging model does not expose timezone metadata.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`kitchen_order_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_order_id`	`staging.brink_sales2_orders`	`order_id`	`NULL`	`Not mapped`	Direct Brink source ID.
`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.
`_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

Curated field	Additional validated source	How to use it
`destination`	`Settings2.GetDestinations -> Destinations[].(Name, Indicator, IsDelivery)`	Portal WSDL and sample response confirm extra destination metadata that can strengthen service-channel normalization without changing the current mapping.
`external_id`	`Sales2.GetOrders -> Orders[].IdNoLocation`	Sample orders confirm `IdNoLocation` exists and can be kept as an extra business-facing order identifier.
`customer_guid`	`temp/GetOrders_WithKnownBusinessDate_CallsRealBrinkEndpoint_2024-10-06.xml -> Orders[].CustomerId`	Sample payload confirms the field exists, although many rows are null in the example dataset.
`order_messages`	`Sales2.GetOrders -> Orders[].OrderAdditionalDetails`	Sample payload confirms the field exists even when null; keep it as an optional JSON/text details source.