Repository Docs & Knowledge Base

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

Branch-specific documentation across extract-raw-xml, feature-fleet-import, kds_cdc_improvments, life-cycle, and tenat-admin.

branches/life-cycle/warehouse-model/docs/features/ETL/warehouse-data/index.md 1,429 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

Warehouse Data

This folder contains warehouse data model documentation for ETL-owned serving schemas.

It is meant to be the human-readable reference for what the tenant warehouse exposes after ETL publication, starting with the curated schema.

brinkPos-staging-model/ - Brink POS source-shaped staging tables, one document per raw API operation
curated-model/ - one document per curated table, with table purpose and column-level descriptions
logic-control-aloha-staging-model/ - source-shaped Aloha staging tables from the current SQL bootstrap
logic-control-kds-staging-model/ - source-shaped KDS staging tables from the current SQL bootstrap
logic-control-pos-staging-model/ - source-shaped Labpos and POS staging tables from the current SQL bootstrap

Validated in the current iteration:

Sales2.GetOrders
Kitchen.GetOrderItemBumpTimes
Settings2.GetLastModifiedTime
Settings2.GetItems
Settings2.GetModifierGroups - currently documented under brinkPos-staging-model/brink_settings_get_modifier_groups.md because the existing doc naming still reflects the older Settings.svc wording

Explicitly deferred to the next iteration: