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)

Branches (328)

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/curated-model/pos_modifiers.md 72,628 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

curated.pos_modifiers

Purpose

This table stores modifier-group definitions and their flattened item membership in the current POS-oriented curated contract. It is useful for understanding what options can be added to items, how many are allowed, and what pricing or weighting rules apply.

The table preserves a wide legacy column layout, so each numbered slot represents a source-positioned member, price, or rule rather than a normalized child table.

Warehouse design assessment

DW fit: Weak fit in its current wide-slot form. From a warehouse perspective this should preferably become one modifier-group table plus one modifier-group-item bridge at a normalized grain.
Cross-client contract: Different POS systems model modifiers differently, so keeping fifty-plus positional columns will make cross-client mapping brittle and low-value.
IDs vs business values: id and item01-style references are not enough for business analysis. Users need modifier names, option names, and pricing rules in readable form.
AI and business usability: AI agents will struggle to reason on slot-based structures because they need to infer semantics from column position rather than explicit row-level entities.
Recommended extensions: Prefer redesign over extension: introduce modifier_group_key, modifier_group_name, modifier_option_key, modifier_option_name, option_price, is_default, min_select, max_select, and source_system in a row-based model.

Detailed modeling guidance

Recommended role: Treat this table as a transitional curated reference layer until modifiers can be remodeled into a normalized row-based structure.
Key differences from a stronger curated model: A stronger warehouse model would separate modifier-group headers from modifier-group options instead of encoding options by slot number.
What is already useful: Group identity, human-readable group names, free-modifier allowance, and embedded price signals still provide analytical value.
What should move later to serving: Upsell suggestions, modifier attachment recommendations, and manager-friendly option summaries belong in serving.

Curated contract columns

Column	Type	Monitor status	Purpose	Monitor rationale
`id`	`INTEGER`	Used by monitors	Modifier group identifier.	Main lookup key for resolving modifier-group definitions used in profitability analysis. Monitors: menu-item-profitability.
`longname`	`VARCHAR(40)`	Used by monitors	Longer modifier-group name.	Human-readable modifier group label improves profitability and upsell recommendations. Monitors: menu-item-profitability.
`free`	`INTEGER`	Used by monitors	Number of modifiers included at no charge.	Free modifier allowance affects realized margin and upsell economics. Monitors: menu-item-profitability.
`item01`	`INTEGER`	Used by monitors	Modifier group member in slot 01.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item02`	`INTEGER`	Used by monitors	Modifier group member in slot 02.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item03`	`INTEGER`	Used by monitors	Modifier group member in slot 03.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item04`	`INTEGER`	Used by monitors	Modifier group member in slot 04.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item05`	`INTEGER`	Used by monitors	Modifier group member in slot 05.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item06`	`INTEGER`	Used by monitors	Modifier group member in slot 06.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item07`	`INTEGER`	Used by monitors	Modifier group member in slot 07.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item08`	`INTEGER`	Used by monitors	Modifier group member in slot 08.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item09`	`INTEGER`	Used by monitors	Modifier group member in slot 09.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item10`	`INTEGER`	Used by monitors	Modifier group member in slot 10.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item11`	`INTEGER`	Used by monitors	Modifier group member in slot 11.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item12`	`INTEGER`	Used by monitors	Modifier group member in slot 12.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item13`	`INTEGER`	Used by monitors	Modifier group member in slot 13.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item14`	`INTEGER`	Used by monitors	Modifier group member in slot 14.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item15`	`INTEGER`	Used by monitors	Modifier group member in slot 15.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item16`	`INTEGER`	Used by monitors	Modifier group member in slot 16.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item17`	`INTEGER`	Used by monitors	Modifier group member in slot 17.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item18`	`INTEGER`	Used by monitors	Modifier group member in slot 18.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item19`	`INTEGER`	Used by monitors	Modifier group member in slot 19.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item20`	`INTEGER`	Used by monitors	Modifier group member in slot 20.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item21`	`INTEGER`	Used by monitors	Modifier group member in slot 21.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item22`	`INTEGER`	Used by monitors	Modifier group member in slot 22.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item23`	`INTEGER`	Used by monitors	Modifier group member in slot 23.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item24`	`INTEGER`	Used by monitors	Modifier group member in slot 24.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item25`	`INTEGER`	Used by monitors	Modifier group member in slot 25.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item26`	`INTEGER`	Used by monitors	Modifier group member in slot 26.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item27`	`INTEGER`	Used by monitors	Modifier group member in slot 27.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item28`	`INTEGER`	Used by monitors	Modifier group member in slot 28.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item29`	`INTEGER`	Used by monitors	Modifier group member in slot 29.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item30`	`INTEGER`	Used by monitors	Modifier group member in slot 30.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item31`	`INTEGER`	Used by monitors	Modifier group member in slot 31.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item32`	`INTEGER`	Used by monitors	Modifier group member in slot 32.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item33`	`INTEGER`	Used by monitors	Modifier group member in slot 33.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item34`	`INTEGER`	Used by monitors	Modifier group member in slot 34.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item35`	`INTEGER`	Used by monitors	Modifier group member in slot 35.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item36`	`INTEGER`	Used by monitors	Modifier group member in slot 36.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item37`	`INTEGER`	Used by monitors	Modifier group member in slot 37.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item38`	`INTEGER`	Used by monitors	Modifier group member in slot 38.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item39`	`INTEGER`	Used by monitors	Modifier group member in slot 39.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item40`	`INTEGER`	Used by monitors	Modifier group member in slot 40.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item41`	`INTEGER`	Used by monitors	Modifier group member in slot 41.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item42`	`INTEGER`	Used by monitors	Modifier group member in slot 42.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item43`	`INTEGER`	Used by monitors	Modifier group member in slot 43.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item44`	`INTEGER`	Used by monitors	Modifier group member in slot 44.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item45`	`INTEGER`	Used by monitors	Modifier group member in slot 45.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item46`	`INTEGER`	Used by monitors	Modifier group member in slot 46.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item47`	`INTEGER`	Used by monitors	Modifier group member in slot 47.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item48`	`INTEGER`	Used by monitors	Modifier group member in slot 48.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item49`	`INTEGER`	Used by monitors	Modifier group member in slot 49.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item50`	`INTEGER`	Used by monitors	Modifier group member in slot 50.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item51`	`INTEGER`	Used by monitors	Modifier group member in slot 51.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item52`	`INTEGER`	Used by monitors	Modifier group member in slot 52.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item53`	`INTEGER`	Used by monitors	Modifier group member in slot 53.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`item54`	`INTEGER`	Used by monitors	Modifier group member in slot 54.	Links modifier group membership to item definitions. Monitors: menu-item-profitability.
`price01`	`BIGINT`	Used by monitors	Price override for slot 01.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price02`	`BIGINT`	Used by monitors	Price override for slot 02.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price03`	`BIGINT`	Used by monitors	Price override for slot 03.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price04`	`BIGINT`	Used by monitors	Price override for slot 04.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price05`	`BIGINT`	Used by monitors	Price override for slot 05.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price06`	`BIGINT`	Used by monitors	Price override for slot 06.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price07`	`BIGINT`	Used by monitors	Price override for slot 07.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price08`	`BIGINT`	Used by monitors	Price override for slot 08.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price09`	`BIGINT`	Used by monitors	Price override for slot 09.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price10`	`BIGINT`	Used by monitors	Price override for slot 10.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price11`	`BIGINT`	Used by monitors	Price override for slot 11.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price12`	`BIGINT`	Used by monitors	Price override for slot 12.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price13`	`BIGINT`	Used by monitors	Price override for slot 13.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price14`	`BIGINT`	Used by monitors	Price override for slot 14.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price15`	`BIGINT`	Used by monitors	Price override for slot 15.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price16`	`BIGINT`	Used by monitors	Price override for slot 16.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price17`	`BIGINT`	Used by monitors	Price override for slot 17.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price18`	`BIGINT`	Used by monitors	Price override for slot 18.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price19`	`BIGINT`	Used by monitors	Price override for slot 19.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price20`	`BIGINT`	Used by monitors	Price override for slot 20.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price21`	`BIGINT`	Used by monitors	Price override for slot 21.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price22`	`BIGINT`	Used by monitors	Price override for slot 22.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price23`	`BIGINT`	Used by monitors	Price override for slot 23.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price24`	`BIGINT`	Used by monitors	Price override for slot 24.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price25`	`BIGINT`	Used by monitors	Price override for slot 25.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price26`	`BIGINT`	Used by monitors	Price override for slot 26.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price27`	`BIGINT`	Used by monitors	Price override for slot 27.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price28`	`BIGINT`	Used by monitors	Price override for slot 28.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price29`	`BIGINT`	Used by monitors	Price override for slot 29.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price30`	`BIGINT`	Used by monitors	Price override for slot 30.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price31`	`BIGINT`	Used by monitors	Price override for slot 31.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price32`	`BIGINT`	Used by monitors	Price override for slot 32.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price33`	`BIGINT`	Used by monitors	Price override for slot 33.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price34`	`BIGINT`	Used by monitors	Price override for slot 34.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price35`	`BIGINT`	Used by monitors	Price override for slot 35.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price36`	`BIGINT`	Used by monitors	Price override for slot 36.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price37`	`BIGINT`	Used by monitors	Price override for slot 37.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price38`	`BIGINT`	Used by monitors	Price override for slot 38.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price39`	`BIGINT`	Used by monitors	Price override for slot 39.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price40`	`BIGINT`	Used by monitors	Price override for slot 40.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price41`	`BIGINT`	Used by monitors	Price override for slot 41.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price42`	`BIGINT`	Used by monitors	Price override for slot 42.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price43`	`BIGINT`	Used by monitors	Price override for slot 43.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price44`	`BIGINT`	Used by monitors	Price override for slot 44.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price45`	`BIGINT`	Used by monitors	Price override for slot 45.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price46`	`BIGINT`	Used by monitors	Price override for slot 46.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price47`	`BIGINT`	Used by monitors	Price override for slot 47.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price48`	`BIGINT`	Used by monitors	Price override for slot 48.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price49`	`BIGINT`	Used by monitors	Price override for slot 49.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price50`	`BIGINT`	Used by monitors	Price override for slot 50.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price51`	`BIGINT`	Used by monitors	Price override for slot 51.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price52`	`BIGINT`	Used by monitors	Price override for slot 52.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price53`	`BIGINT`	Used by monitors	Price override for slot 53.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`price54`	`BIGINT`	Used by monitors	Price override for slot 54.	Price overrides determine modifier-driven revenue and margin. Monitors: menu-item-profitability.
`ownerid`	`INTEGER`	Available for future monitors	Owning configuration or location identifier.	Could scope modifier definitions by location if future analysis becomes site-specific. Potential monitors: menu-item-profitability.
`usernumber`	`INTEGER`	Available for future monitors	User-visible modifier-group number.	Useful for operator cross-reference, not for current scoring logic. Potential monitors: menu-item-profitability.
`shortname`	`VARCHAR(15)`	Available for future monitors	Short modifier-group name.	Readable label helps reporting if long names are unavailable. Potential monitors: menu-item-profitability.
`minimum`	`INTEGER`	Available for future monitors	Minimum number of modifiers required.	Required-choice rules can explain upsell pressure and modifier complexity. Potential monitors: menu-item-profitability.
`maximum`	`INTEGER`	Available for future monitors	Maximum number of modifiers allowed.	Modifier limits can explain basket composition and upsell ceilings. Potential monitors: menu-item-profitability.
`flowreq`	`VARCHAR(1)`	Available for future monitors	Flag indicating whether modifier flow is required.	Can help explain forced modifier interactions in future analysis. Potential monitors: menu-item-profitability.
`substitute`	`INTEGER`	Available for future monitors	Substitute-rule identifier or code.	Substitution behavior can influence modifier economics and future bundle logic. Potential monitors: menu-item-profitability.
`weight01`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 01.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight02`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 02.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight03`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 03.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight04`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 04.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight05`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 05.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight06`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 06.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight07`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 07.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight08`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 08.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight09`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 09.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight10`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 10.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight11`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 11.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight12`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 12.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight13`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 13.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight14`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 14.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight15`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 15.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight16`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 16.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight17`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 17.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight18`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 18.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight19`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 19.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight20`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 20.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight21`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 21.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight22`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 22.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight23`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 23.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight24`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 24.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight25`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 25.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight26`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 26.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight27`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 27.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight28`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 28.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight29`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 29.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight30`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 30.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight31`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 31.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight32`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 32.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight33`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 33.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight34`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 34.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight35`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 35.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight36`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 36.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight37`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 37.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight38`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 38.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight39`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 39.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight40`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 40.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight41`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 41.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight42`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 42.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight43`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 43.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight44`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 44.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight45`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 45.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight46`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 46.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight47`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 47.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight48`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 48.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight49`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 49.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight50`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 50.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight51`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 51.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight52`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 52.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight53`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 53.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`weight54`	`INTEGER`	Available for future monitors	Weighting or sort weight for slot 54.	Can refine future presentation or modifier-priority analysis. Potential monitors: menu-item-profitability.
`pricelvl01`	`INTEGER`	Available for future monitors	Price-level override for slot 01.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl02`	`INTEGER`	Available for future monitors	Price-level override for slot 02.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl03`	`INTEGER`	Available for future monitors	Price-level override for slot 03.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl04`	`INTEGER`	Available for future monitors	Price-level override for slot 04.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl05`	`INTEGER`	Available for future monitors	Price-level override for slot 05.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl06`	`INTEGER`	Available for future monitors	Price-level override for slot 06.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl07`	`INTEGER`	Available for future monitors	Price-level override for slot 07.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl08`	`INTEGER`	Available for future monitors	Price-level override for slot 08.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl09`	`INTEGER`	Available for future monitors	Price-level override for slot 09.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl10`	`INTEGER`	Available for future monitors	Price-level override for slot 10.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl11`	`INTEGER`	Available for future monitors	Price-level override for slot 11.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl12`	`INTEGER`	Available for future monitors	Price-level override for slot 12.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl13`	`INTEGER`	Available for future monitors	Price-level override for slot 13.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl14`	`INTEGER`	Available for future monitors	Price-level override for slot 14.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl15`	`INTEGER`	Available for future monitors	Price-level override for slot 15.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl16`	`INTEGER`	Available for future monitors	Price-level override for slot 16.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl17`	`INTEGER`	Available for future monitors	Price-level override for slot 17.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl18`	`INTEGER`	Available for future monitors	Price-level override for slot 18.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl19`	`INTEGER`	Available for future monitors	Price-level override for slot 19.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl20`	`INTEGER`	Available for future monitors	Price-level override for slot 20.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl21`	`INTEGER`	Available for future monitors	Price-level override for slot 21.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl22`	`INTEGER`	Available for future monitors	Price-level override for slot 22.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl23`	`INTEGER`	Available for future monitors	Price-level override for slot 23.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl24`	`INTEGER`	Available for future monitors	Price-level override for slot 24.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl25`	`INTEGER`	Available for future monitors	Price-level override for slot 25.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl26`	`INTEGER`	Available for future monitors	Price-level override for slot 26.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl27`	`INTEGER`	Available for future monitors	Price-level override for slot 27.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl28`	`INTEGER`	Available for future monitors	Price-level override for slot 28.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl29`	`INTEGER`	Available for future monitors	Price-level override for slot 29.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl30`	`INTEGER`	Available for future monitors	Price-level override for slot 30.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl31`	`INTEGER`	Available for future monitors	Price-level override for slot 31.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl32`	`INTEGER`	Available for future monitors	Price-level override for slot 32.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl33`	`INTEGER`	Available for future monitors	Price-level override for slot 33.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl34`	`INTEGER`	Available for future monitors	Price-level override for slot 34.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl35`	`INTEGER`	Available for future monitors	Price-level override for slot 35.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl36`	`INTEGER`	Available for future monitors	Price-level override for slot 36.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl37`	`INTEGER`	Available for future monitors	Price-level override for slot 37.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl38`	`INTEGER`	Available for future monitors	Price-level override for slot 38.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl39`	`INTEGER`	Available for future monitors	Price-level override for slot 39.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl40`	`INTEGER`	Available for future monitors	Price-level override for slot 40.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl41`	`INTEGER`	Available for future monitors	Price-level override for slot 41.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl42`	`INTEGER`	Available for future monitors	Price-level override for slot 42.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl43`	`INTEGER`	Available for future monitors	Price-level override for slot 43.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl44`	`INTEGER`	Available for future monitors	Price-level override for slot 44.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl45`	`INTEGER`	Available for future monitors	Price-level override for slot 45.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl46`	`INTEGER`	Available for future monitors	Price-level override for slot 46.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl47`	`INTEGER`	Available for future monitors	Price-level override for slot 47.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl48`	`INTEGER`	Available for future monitors	Price-level override for slot 48.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl49`	`INTEGER`	Available for future monitors	Price-level override for slot 49.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl50`	`INTEGER`	Available for future monitors	Price-level override for slot 50.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl51`	`INTEGER`	Available for future monitors	Price-level override for slot 51.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl52`	`INTEGER`	Available for future monitors	Price-level override for slot 52.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl53`	`INTEGER`	Available for future monitors	Price-level override for slot 53.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`pricelvl54`	`INTEGER`	Available for future monitors	Price-level override for slot 54.	Can support future configured-vs-realized price audits. Potential monitors: menu-item-profitability.
`prmethod01`	`INTEGER`	Available for future monitors	Price method for slot 01.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod02`	`INTEGER`	Available for future monitors	Price method for slot 02.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod03`	`INTEGER`	Available for future monitors	Price method for slot 03.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod04`	`INTEGER`	Available for future monitors	Price method for slot 04.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod05`	`INTEGER`	Available for future monitors	Price method for slot 05.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod06`	`INTEGER`	Available for future monitors	Price method for slot 06.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod07`	`INTEGER`	Available for future monitors	Price method for slot 07.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod08`	`INTEGER`	Available for future monitors	Price method for slot 08.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod09`	`INTEGER`	Available for future monitors	Price method for slot 09.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod10`	`INTEGER`	Available for future monitors	Price method for slot 10.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod11`	`INTEGER`	Available for future monitors	Price method for slot 11.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod12`	`INTEGER`	Available for future monitors	Price method for slot 12.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod13`	`INTEGER`	Available for future monitors	Price method for slot 13.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod14`	`INTEGER`	Available for future monitors	Price method for slot 14.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod15`	`INTEGER`	Available for future monitors	Price method for slot 15.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod16`	`INTEGER`	Available for future monitors	Price method for slot 16.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod17`	`INTEGER`	Available for future monitors	Price method for slot 17.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod18`	`INTEGER`	Available for future monitors	Price method for slot 18.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod19`	`INTEGER`	Available for future monitors	Price method for slot 19.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod20`	`INTEGER`	Available for future monitors	Price method for slot 20.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod21`	`INTEGER`	Available for future monitors	Price method for slot 21.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod22`	`INTEGER`	Available for future monitors	Price method for slot 22.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod23`	`INTEGER`	Available for future monitors	Price method for slot 23.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod24`	`INTEGER`	Available for future monitors	Price method for slot 24.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod25`	`INTEGER`	Available for future monitors	Price method for slot 25.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod26`	`INTEGER`	Available for future monitors	Price method for slot 26.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod27`	`INTEGER`	Available for future monitors	Price method for slot 27.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod28`	`INTEGER`	Available for future monitors	Price method for slot 28.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod29`	`INTEGER`	Available for future monitors	Price method for slot 29.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod30`	`INTEGER`	Available for future monitors	Price method for slot 30.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod31`	`INTEGER`	Available for future monitors	Price method for slot 31.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod32`	`INTEGER`	Available for future monitors	Price method for slot 32.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod33`	`INTEGER`	Available for future monitors	Price method for slot 33.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod34`	`INTEGER`	Available for future monitors	Price method for slot 34.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod35`	`INTEGER`	Available for future monitors	Price method for slot 35.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod36`	`INTEGER`	Available for future monitors	Price method for slot 36.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod37`	`INTEGER`	Available for future monitors	Price method for slot 37.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod38`	`INTEGER`	Available for future monitors	Price method for slot 38.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod39`	`INTEGER`	Available for future monitors	Price method for slot 39.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod40`	`INTEGER`	Available for future monitors	Price method for slot 40.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod41`	`INTEGER`	Available for future monitors	Price method for slot 41.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod42`	`INTEGER`	Available for future monitors	Price method for slot 42.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod43`	`INTEGER`	Available for future monitors	Price method for slot 43.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod44`	`INTEGER`	Available for future monitors	Price method for slot 44.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod45`	`INTEGER`	Available for future monitors	Price method for slot 45.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod46`	`INTEGER`	Available for future monitors	Price method for slot 46.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod47`	`INTEGER`	Available for future monitors	Price method for slot 47.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod48`	`INTEGER`	Available for future monitors	Price method for slot 48.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod49`	`INTEGER`	Available for future monitors	Price method for slot 49.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod50`	`INTEGER`	Available for future monitors	Price method for slot 50.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod51`	`INTEGER`	Available for future monitors	Price method for slot 51.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod52`	`INTEGER`	Available for future monitors	Price method for slot 52.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod53`	`INTEGER`	Available for future monitors	Price method for slot 53.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`prmethod54`	`INTEGER`	Available for future monitors	Price method for slot 54.	Pricing method metadata can explain how modifier prices are computed in future analysis. Potential monitors: menu-item-profitability.
`subindex`	`INTEGER`	Available for future monitors	Substitute or subgroup index.	Could support future substitute-group analysis. Potential monitors: menu-item-profitability.
`qstsmode`	`INTEGER`	Available for future monitors	Question-set mode or flow mode.	Could help future analysis of forced-choice complexity. Potential monitors: menu-item-profitability.
`refill`	`VARCHAR(1)`	Available for future monitors	Flag indicating refill behavior within the modifier group.	Refill semantics may influence modifier economics in future beverage analysis. Potential monitors: menu-item-profitability.
`maxrefills`	`INTEGER`	Available for future monitors	Maximum number of refills allowed.	Can affect future refill-value analysis. Potential monitors: menu-item-profitability.
`defrdmod`	`VARCHAR(1)`	Available for future monitors	Flag controlling default required modifier behavior.	Required modifiers may affect attachment-rate economics. Potential monitors: menu-item-profitability.
`nosub01`	`INTEGER`	Available for future monitors	No-substitute rule for slot 01.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub02`	`INTEGER`	Available for future monitors	No-substitute rule for slot 02.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub03`	`INTEGER`	Available for future monitors	No-substitute rule for slot 03.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub04`	`INTEGER`	Available for future monitors	No-substitute rule for slot 04.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub05`	`INTEGER`	Available for future monitors	No-substitute rule for slot 05.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub06`	`INTEGER`	Available for future monitors	No-substitute rule for slot 06.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub07`	`INTEGER`	Available for future monitors	No-substitute rule for slot 07.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub08`	`INTEGER`	Available for future monitors	No-substitute rule for slot 08.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub09`	`INTEGER`	Available for future monitors	No-substitute rule for slot 09.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub10`	`INTEGER`	Available for future monitors	No-substitute rule for slot 10.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub11`	`INTEGER`	Available for future monitors	No-substitute rule for slot 11.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub12`	`INTEGER`	Available for future monitors	No-substitute rule for slot 12.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub13`	`INTEGER`	Available for future monitors	No-substitute rule for slot 13.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub14`	`INTEGER`	Available for future monitors	No-substitute rule for slot 14.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub15`	`INTEGER`	Available for future monitors	No-substitute rule for slot 15.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub16`	`INTEGER`	Available for future monitors	No-substitute rule for slot 16.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub17`	`INTEGER`	Available for future monitors	No-substitute rule for slot 17.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub18`	`INTEGER`	Available for future monitors	No-substitute rule for slot 18.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub19`	`INTEGER`	Available for future monitors	No-substitute rule for slot 19.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub20`	`INTEGER`	Available for future monitors	No-substitute rule for slot 20.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub21`	`INTEGER`	Available for future monitors	No-substitute rule for slot 21.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub22`	`INTEGER`	Available for future monitors	No-substitute rule for slot 22.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub23`	`INTEGER`	Available for future monitors	No-substitute rule for slot 23.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub24`	`INTEGER`	Available for future monitors	No-substitute rule for slot 24.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub25`	`INTEGER`	Available for future monitors	No-substitute rule for slot 25.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub26`	`INTEGER`	Available for future monitors	No-substitute rule for slot 26.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub27`	`INTEGER`	Available for future monitors	No-substitute rule for slot 27.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub28`	`INTEGER`	Available for future monitors	No-substitute rule for slot 28.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub29`	`INTEGER`	Available for future monitors	No-substitute rule for slot 29.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub30`	`INTEGER`	Available for future monitors	No-substitute rule for slot 30.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub31`	`INTEGER`	Available for future monitors	No-substitute rule for slot 31.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub32`	`INTEGER`	Available for future monitors	No-substitute rule for slot 32.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub33`	`INTEGER`	Available for future monitors	No-substitute rule for slot 33.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub34`	`INTEGER`	Available for future monitors	No-substitute rule for slot 34.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub35`	`INTEGER`	Available for future monitors	No-substitute rule for slot 35.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub36`	`INTEGER`	Available for future monitors	No-substitute rule for slot 36.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub37`	`INTEGER`	Available for future monitors	No-substitute rule for slot 37.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub38`	`INTEGER`	Available for future monitors	No-substitute rule for slot 38.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub39`	`INTEGER`	Available for future monitors	No-substitute rule for slot 39.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub40`	`INTEGER`	Available for future monitors	No-substitute rule for slot 40.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub41`	`INTEGER`	Available for future monitors	No-substitute rule for slot 41.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub42`	`INTEGER`	Available for future monitors	No-substitute rule for slot 42.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub43`	`INTEGER`	Available for future monitors	No-substitute rule for slot 43.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub44`	`INTEGER`	Available for future monitors	No-substitute rule for slot 44.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub45`	`INTEGER`	Available for future monitors	No-substitute rule for slot 45.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub46`	`INTEGER`	Available for future monitors	No-substitute rule for slot 46.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub47`	`INTEGER`	Available for future monitors	No-substitute rule for slot 47.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub48`	`INTEGER`	Available for future monitors	No-substitute rule for slot 48.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub49`	`INTEGER`	Available for future monitors	No-substitute rule for slot 49.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub50`	`INTEGER`	Available for future monitors	No-substitute rule for slot 50.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub51`	`INTEGER`	Available for future monitors	No-substitute rule for slot 51.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub52`	`INTEGER`	Available for future monitors	No-substitute rule for slot 52.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub53`	`INTEGER`	Available for future monitors	No-substitute rule for slot 53.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`nosub54`	`INTEGER`	Available for future monitors	No-substitute rule for slot 54.	No-substitute rules can affect future substitution economics. Potential monitors: menu-item-profitability.
`type`	`INTEGER`	Available for future monitors	Modifier-group type code.	Group type can enrich future pricing and upsell analysis if decoded. Potential monitors: menu-item-profitability.
`hideprice`	`VARCHAR(1)`	Available for future monitors	Flag hiding prices in some modifier views.	Hidden pricing could matter for upsell visibility in future analysis. Potential monitors: menu-item-profitability.
`modifier_group_key`	`BIGINT`	Recommended extension	Stable warehouse key for the modifier group entity.	Recommended to provide one canonical modifier group identifier across clients.
`source_system`	`VARCHAR(100)`	Recommended extension	Canonical name of the source platform that produced the modifier group row.	Recommended to preserve lineage when different POS systems map into the same curated contract.
`source_modifier_group_id`	`VARCHAR(199)`	Recommended extension	Original modifier group identifier from the source platform.	Recommended to support traceability between curated and staging models.
`modifier_group_name`	`VARCHAR(255)`	Recommended extension	Readable business name of the modifier group.	Recommended because business users need a clear modifier-group label beyond short source names.
`modifier_option_name_summary`	`VARCHAR(65535)`	Recommended extension	Readable summary of the modifier options contained in the wide-slot row.	Recommended as a transitional business-friendly field while the structure remains slot-based.
`min_select`	`INTEGER`	Recommended extension	Canonical minimum number of options that can be selected from the group.	Recommended to standardize required-choice logic across clients.
`max_select`	`INTEGER`	Recommended extension	Canonical maximum number of options that can be selected from the group.	Recommended to standardize modifier selection rules across clients.
`is_active`	`BOOLEAN`	Recommended extension	Canonical flag indicating whether the modifier group is active in the curated model.	Recommended to make modifier availability easier to interpret than scattered source flags.
`tenant_key`	`BIGINT`	Recommended extension	Stable warehouse key for the tenant, brand, or client that owns the modifier group.	Recommended because a shared curated schema should preserve explicit client context for reference data.
`tenant_name`	`VARCHAR(255)`	Recommended extension	Readable tenant, brand, or client name associated with the modifier group.	Recommended to improve AI and business usability in cross-client modifier analysis.
`effective_from_utc`	`TIMESTAMP`	Recommended extension	UTC timestamp from which the current modifier-group version is valid.	Recommended to support history-aware analysis while the structure remains transitional.
`effective_to_utc`	`TIMESTAMP`	Recommended extension	UTC timestamp until which the current modifier-group version is valid.	Recommended to support point-in-time joins and future dimensional history.
`is_current`	`BOOLEAN`	Recommended extension	Canonical flag indicating whether the row is the current modifier-group version.	Recommended if this table evolves toward a slowly changing reference model.