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

Raw File

Brink mapping for `curated.pos_transactions`

Main staging sources

staging.brink_sales2_orders
staging.brink_settings2_get_destinations

Mapping groups

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
`"check"`	`N/A`	`N/A`	`NULL`	`Not mapped`	No matching check field is documented in Brink orders.
`amount`	`staging.brink_sales2_orders`	`total`	`NULL`	`Not mapped`	Direct total sales amount.
`openhour`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Derive hour from the order open timestamp.
`openmin`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Derive minute from the order open timestamp.
`orderhour`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Derive hour from the order open timestamp.
`ordermin`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Derive minute from the order open timestamp.
`closehour`	`staging.brink_sales2_orders`	`closed_time`	`NULL`	`Not mapped`	Derive hour from the order close timestamp.
`closemin`	`staging.brink_sales2_orders`	`closed_time`	`NULL`	`Not mapped`	Derive minute from the order close timestamp.
`"count"`	`staging.brink_sales2_orders`	`order_count`	`NULL`	`Not mapped`	Direct order header count.
`revenue`	`staging.brink_sales2_orders`	`section_id`	`NULL`	`Not mapped`	Best header-level revenue section identifier.
`unit`	`N/A`	`N/A`	`NULL`	`Not mapped`	No unit identifier is documented on Brink orders.
`dob`	`staging.brink_sales2_orders`	`business_date`	`NULL`	`Not mapped`	Direct business date.
`occasion`	`staging.brink_sales2_orders`	`destination_id`	`NULL`	`Not mapped`	Best available service-occasion style field.
`employee`	`staging.brink_sales2_orders`	`employee_id`	`NULL`	`Not mapped`	Direct employee identifier.
`period`	`N/A`	`N/A`	`NULL`	`Not mapped`	No matching business-period field is documented.
`"type"`	`N/A`	`N/A`	`NULL`	`Not mapped`	No transaction type classification code is documented.
`typeid`	`staging.brink_sales2_orders`	`destination_id`	`NULL`	`Not mapped`	Best available destination/channel identifier.
`shift`	`N/A`	`N/A`	`NULL`	`Not mapped`	No shift identifier is documented on orders.
`typeid2`	`N/A`	`N/A`	`NULL`	`Not mapped`	No secondary channel identifier is documented.
`revid2`	`N/A`	`N/A`	`NULL`	`Not mapped`	No secondary revenue grouping identifier is documented.
`store_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No store name is documented.
`revenue_center_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No revenue center name is documented at the order header level.
`occasion_name`	`staging.brink_settings2_get_destinations`	`name`	`NULL`	`Not mapped`	Resolve occasion name by joining `destination_id` to `staging.brink_settings2_get_destinations` on `destination_id`.
`transaction_type_name`	`staging.brink_settings2_get_destinations`	`name`	`NULL`	`Not mapped`	Resolve transaction type name by joining `destination_id` to `staging.brink_settings2_get_destinations` on `destination_id`.
`business_timestamp_utc`	`staging.brink_sales2_orders`	`opened_time`	`NULL`	`Not mapped`	Direct UTC timestamp.
`guest_count`	`staging.brink_sales2_orders`	`guest_count`	`NULL`	`Not mapped`	Direct guest count.
`net_amount`	`staging.brink_sales2_orders`	`net_sales`	`NULL`	`Not mapped`	Direct net sales amount.
`currency_code`	`N/A`	`N/A`	`NULL`	`Not mapped`	Currency is not documented in the available Brink staging model.
`transaction_status_code`	`staging.brink_sales2_orders`	`(is_closed, is_refund, is_future_order)`	`NULL`	`Not mapped`	Derive machine-friendly status code from status boolean fields.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`transaction_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_transaction_id`	`staging.brink_sales2_orders`	`order_id`	`NULL`	`Not mapped`	Direct Brink source order identifier kept for reconciliation.
`tenant_key`	N/A	N/A	`NULL`	`Not mapped`	Warehouse-generated 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
`occasion`	`Sales2.GetOrders -> Orders[].Entries[].OrderItem.DayPartId`	Sample payloads and Brink WSDL confirm `DayPartId`, which can be used as an additional meal-period signal.
`occasion_name`	`Settings.GetDayParts -> DayPart.Name`	Brink portal WSDL confirms a day-part lookup endpoint that can supplement destination-based occasion mapping.
`employee`	`Settings2.GetEmployees -> Employees[].DisplayName`	Portal WSDL and sample response confirm employee lookup fields that can enrich transaction-level employee context.
`source_transaction_id`	`Sales2.GetOrders -> Orders[].IdNoLocation`	Sample payloads confirm `IdNoLocation` exists as a useful extra source identifier beside `Id`.