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

Raw File

Brink mapping for `curated.pos_modifiers`

Main staging sources

staging.brink_settings2_modifier_groups
staging.brink_settings2_modifier_group_items

Mapping groups

Business property mappings describe how Brink modifier group 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
`id`	`staging.brink_settings2_modifier_groups`	`modifier_group_id`	`NULL`	`Not mapped`	Direct modifier-group ID.
`longname`	`staging.brink_settings2_modifier_groups`	`display_name`	`NULL`	`Not mapped`	Best readable modifier-group name.
`free`	`staging.brink_settings2_modifier_groups`	`free`	`NULL`	`Not mapped`	Direct free-modifier count.
item01	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 1)	NULL	Not mapped	Modifier item ID at slot position 1.
item02	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 2)	NULL	Not mapped	Modifier item ID at slot position 2.
item03	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 3)	NULL	Not mapped	Modifier item ID at slot position 3.
item04	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 4)	NULL	Not mapped	Modifier item ID at slot position 4.
item05	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 5)	NULL	Not mapped	Modifier item ID at slot position 5.
item06	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 6)	NULL	Not mapped	Modifier item ID at slot position 6.
item07	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 7)	NULL	Not mapped	Modifier item ID at slot position 7.
item08	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 8)	NULL	Not mapped	Modifier item ID at slot position 8.
item09	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 9)	NULL	Not mapped	Modifier item ID at slot position 9.
item10	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 10)	NULL	Not mapped	Modifier item ID at slot position 10.
item11	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 11)	NULL	Not mapped	Modifier item ID at slot position 11.
item12	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 12)	NULL	Not mapped	Modifier item ID at slot position 12.
item13	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 13)	NULL	Not mapped	Modifier item ID at slot position 13.
item14	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 14)	NULL	Not mapped	Modifier item ID at slot position 14.
item15	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 15)	NULL	Not mapped	Modifier item ID at slot position 15.
item16	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 16)	NULL	Not mapped	Modifier item ID at slot position 16.
item17	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 17)	NULL	Not mapped	Modifier item ID at slot position 17.
item18	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 18)	NULL	Not mapped	Modifier item ID at slot position 18.
item19	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 19)	NULL	Not mapped	Modifier item ID at slot position 19.
item20	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 20)	NULL	Not mapped	Modifier item ID at slot position 20.
item21	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 21)	NULL	Not mapped	Modifier item ID at slot position 21.
item22	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 22)	NULL	Not mapped	Modifier item ID at slot position 22.
item23	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 23)	NULL	Not mapped	Modifier item ID at slot position 23.
item24	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 24)	NULL	Not mapped	Modifier item ID at slot position 24.
item25	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 25)	NULL	Not mapped	Modifier item ID at slot position 25.
item26	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 26)	NULL	Not mapped	Modifier item ID at slot position 26.
item27	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 27)	NULL	Not mapped	Modifier item ID at slot position 27.
item28	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 28)	NULL	Not mapped	Modifier item ID at slot position 28.
item29	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 29)	NULL	Not mapped	Modifier item ID at slot position 29.
item30	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 30)	NULL	Not mapped	Modifier item ID at slot position 30.
item31	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 31)	NULL	Not mapped	Modifier item ID at slot position 31.
item32	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 32)	NULL	Not mapped	Modifier item ID at slot position 32.
item33	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 33)	NULL	Not mapped	Modifier item ID at slot position 33.
item34	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 34)	NULL	Not mapped	Modifier item ID at slot position 34.
item35	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 35)	NULL	Not mapped	Modifier item ID at slot position 35.
item36	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 36)	NULL	Not mapped	Modifier item ID at slot position 36.
item37	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 37)	NULL	Not mapped	Modifier item ID at slot position 37.
item38	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 38)	NULL	Not mapped	Modifier item ID at slot position 38.
item39	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 39)	NULL	Not mapped	Modifier item ID at slot position 39.
item40	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 40)	NULL	Not mapped	Modifier item ID at slot position 40.
item41	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 41)	NULL	Not mapped	Modifier item ID at slot position 41.
item42	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 42)	NULL	Not mapped	Modifier item ID at slot position 42.
item43	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 43)	NULL	Not mapped	Modifier item ID at slot position 43.
item44	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 44)	NULL	Not mapped	Modifier item ID at slot position 44.
item45	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 45)	NULL	Not mapped	Modifier item ID at slot position 45.
item46	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 46)	NULL	Not mapped	Modifier item ID at slot position 46.
item47	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 47)	NULL	Not mapped	Modifier item ID at slot position 47.
item48	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 48)	NULL	Not mapped	Modifier item ID at slot position 48.
item49	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 49)	NULL	Not mapped	Modifier item ID at slot position 49.
item50	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 50)	NULL	Not mapped	Modifier item ID at slot position 50.
item51	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 51)	NULL	Not mapped	Modifier item ID at slot position 51.
item52	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 52)	NULL	Not mapped	Modifier item ID at slot position 52.
item53	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 53)	NULL	Not mapped	Modifier item ID at slot position 53.
item54	staging.brink_settings2_modifier_group_items	item_id (filtered by position = 54)	NULL	Not mapped	Modifier item ID at slot position 54.
price01	staging.brink_settings2_modifier_group_items	price (filtered by position = 1)	NULL	Not mapped	Modifier price at slot position 1.
price02	staging.brink_settings2_modifier_group_items	price (filtered by position = 2)	NULL	Not mapped	Modifier price at slot position 2.
price03	staging.brink_settings2_modifier_group_items	price (filtered by position = 3)	NULL	Not mapped	Modifier price at slot position 3.
price04	staging.brink_settings2_modifier_group_items	price (filtered by position = 4)	NULL	Not mapped	Modifier price at slot position 4.
price05	staging.brink_settings2_modifier_group_items	price (filtered by position = 5)	NULL	Not mapped	Modifier price at slot position 5.
price06	staging.brink_settings2_modifier_group_items	price (filtered by position = 6)	NULL	Not mapped	Modifier price at slot position 6.
price07	staging.brink_settings2_modifier_group_items	price (filtered by position = 7)	NULL	Not mapped	Modifier price at slot position 7.
price08	staging.brink_settings2_modifier_group_items	price (filtered by position = 8)	NULL	Not mapped	Modifier price at slot position 8.
price09	staging.brink_settings2_modifier_group_items	price (filtered by position = 9)	NULL	Not mapped	Modifier price at slot position 9.
price10	staging.brink_settings2_modifier_group_items	price (filtered by position = 10)	NULL	Not mapped	Modifier price at slot position 10.
price11	staging.brink_settings2_modifier_group_items	price (filtered by position = 11)	NULL	Not mapped	Modifier price at slot position 11.
price12	staging.brink_settings2_modifier_group_items	price (filtered by position = 12)	NULL	Not mapped	Modifier price at slot position 12.
price13	staging.brink_settings2_modifier_group_items	price (filtered by position = 13)	NULL	Not mapped	Modifier price at slot position 13.
price14	staging.brink_settings2_modifier_group_items	price (filtered by position = 14)	NULL	Not mapped	Modifier price at slot position 14.
price15	staging.brink_settings2_modifier_group_items	price (filtered by position = 15)	NULL	Not mapped	Modifier price at slot position 15.
price16	staging.brink_settings2_modifier_group_items	price (filtered by position = 16)	NULL	Not mapped	Modifier price at slot position 16.
price17	staging.brink_settings2_modifier_group_items	price (filtered by position = 17)	NULL	Not mapped	Modifier price at slot position 17.
price18	staging.brink_settings2_modifier_group_items	price (filtered by position = 18)	NULL	Not mapped	Modifier price at slot position 18.
price19	staging.brink_settings2_modifier_group_items	price (filtered by position = 19)	NULL	Not mapped	Modifier price at slot position 19.
price20	staging.brink_settings2_modifier_group_items	price (filtered by position = 20)	NULL	Not mapped	Modifier price at slot position 20.
price21	staging.brink_settings2_modifier_group_items	price (filtered by position = 21)	NULL	Not mapped	Modifier price at slot position 21.
price22	staging.brink_settings2_modifier_group_items	price (filtered by position = 22)	NULL	Not mapped	Modifier price at slot position 22.
price23	staging.brink_settings2_modifier_group_items	price (filtered by position = 23)	NULL	Not mapped	Modifier price at slot position 23.
price24	staging.brink_settings2_modifier_group_items	price (filtered by position = 24)	NULL	Not mapped	Modifier price at slot position 24.
price25	staging.brink_settings2_modifier_group_items	price (filtered by position = 25)	NULL	Not mapped	Modifier price at slot position 25.
price26	staging.brink_settings2_modifier_group_items	price (filtered by position = 26)	NULL	Not mapped	Modifier price at slot position 26.
price27	staging.brink_settings2_modifier_group_items	price (filtered by position = 27)	NULL	Not mapped	Modifier price at slot position 27.
price28	staging.brink_settings2_modifier_group_items	price (filtered by position = 28)	NULL	Not mapped	Modifier price at slot position 28.
price29	staging.brink_settings2_modifier_group_items	price (filtered by position = 29)	NULL	Not mapped	Modifier price at slot position 29.
price30	staging.brink_settings2_modifier_group_items	price (filtered by position = 30)	NULL	Not mapped	Modifier price at slot position 30.
price31	staging.brink_settings2_modifier_group_items	price (filtered by position = 31)	NULL	Not mapped	Modifier price at slot position 31.
price32	staging.brink_settings2_modifier_group_items	price (filtered by position = 32)	NULL	Not mapped	Modifier price at slot position 32.
price33	staging.brink_settings2_modifier_group_items	price (filtered by position = 33)	NULL	Not mapped	Modifier price at slot position 33.
price34	staging.brink_settings2_modifier_group_items	price (filtered by position = 34)	NULL	Not mapped	Modifier price at slot position 34.
price35	staging.brink_settings2_modifier_group_items	price (filtered by position = 35)	NULL	Not mapped	Modifier price at slot position 35.
price36	staging.brink_settings2_modifier_group_items	price (filtered by position = 36)	NULL	Not mapped	Modifier price at slot position 36.
price37	staging.brink_settings2_modifier_group_items	price (filtered by position = 37)	NULL	Not mapped	Modifier price at slot position 37.
price38	staging.brink_settings2_modifier_group_items	price (filtered by position = 38)	NULL	Not mapped	Modifier price at slot position 38.
price39	staging.brink_settings2_modifier_group_items	price (filtered by position = 39)	NULL	Not mapped	Modifier price at slot position 39.
price40	staging.brink_settings2_modifier_group_items	price (filtered by position = 40)	NULL	Not mapped	Modifier price at slot position 40.
price41	staging.brink_settings2_modifier_group_items	price (filtered by position = 41)	NULL	Not mapped	Modifier price at slot position 41.
price42	staging.brink_settings2_modifier_group_items	price (filtered by position = 42)	NULL	Not mapped	Modifier price at slot position 42.
price43	staging.brink_settings2_modifier_group_items	price (filtered by position = 43)	NULL	Not mapped	Modifier price at slot position 43.
price44	staging.brink_settings2_modifier_group_items	price (filtered by position = 44)	NULL	Not mapped	Modifier price at slot position 44.
price45	staging.brink_settings2_modifier_group_items	price (filtered by position = 45)	NULL	Not mapped	Modifier price at slot position 45.
price46	staging.brink_settings2_modifier_group_items	price (filtered by position = 46)	NULL	Not mapped	Modifier price at slot position 46.
price47	staging.brink_settings2_modifier_group_items	price (filtered by position = 47)	NULL	Not mapped	Modifier price at slot position 47.
price48	staging.brink_settings2_modifier_group_items	price (filtered by position = 48)	NULL	Not mapped	Modifier price at slot position 48.
price49	staging.brink_settings2_modifier_group_items	price (filtered by position = 49)	NULL	Not mapped	Modifier price at slot position 49.
price50	staging.brink_settings2_modifier_group_items	price (filtered by position = 50)	NULL	Not mapped	Modifier price at slot position 50.
price51	staging.brink_settings2_modifier_group_items	price (filtered by position = 51)	NULL	Not mapped	Modifier price at slot position 51.
price52	staging.brink_settings2_modifier_group_items	price (filtered by position = 52)	NULL	Not mapped	Modifier price at slot position 52.
price53	staging.brink_settings2_modifier_group_items	price (filtered by position = 53)	NULL	Not mapped	Modifier price at slot position 53.
price54	staging.brink_settings2_modifier_group_items	price (filtered by position = 54)	NULL	Not mapped	Modifier price at slot position 54.
`ownerid`	`N/A`	`N/A`	`NULL`	`Not mapped`	No owner ID is documented on Brink modifier groups.
`usernumber`	`N/A`	`N/A`	`NULL`	`Not mapped`	No user-visible modifier-group number is documented.
`shortname`	`staging.brink_settings2_modifier_groups`	`name`	`NULL`	`Not mapped`	Best secondary readable name.
`minimum`	`staging.brink_settings2_modifier_groups`	`minimum`	`NULL`	`Not mapped`	Direct minimum-select value.
`maximum`	`staging.brink_settings2_modifier_groups`	`maximum`	`NULL`	`Not mapped`	Direct maximum-select value.
`flowreq`	`staging.brink_settings2_modifier_groups`	`flow_required`	`NULL`	`Not mapped`	Direct flow-required flag.
`substitute`	`N/A`	`N/A`	`NULL`	`Not mapped`	No substitute-rule field is documented on Brink modifier groups.
`weight01`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight02`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight03`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight04`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight05`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight06`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight07`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight08`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight09`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight10`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight11`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight12`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight13`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight14`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight15`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight16`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight17`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight18`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight19`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight20`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight21`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight22`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight23`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight24`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight25`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight26`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight27`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight28`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight29`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight30`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight31`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight32`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight33`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight34`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight35`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight36`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight37`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight38`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight39`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight40`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight41`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight42`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight43`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight44`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight45`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight46`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight47`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight48`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight49`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight50`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight51`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight52`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight53`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`weight54`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl01`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl02`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl03`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl04`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl05`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl06`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl07`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl08`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl09`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl10`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl11`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl12`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl13`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl14`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl15`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl16`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl17`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl18`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl19`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl20`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl21`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl22`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl23`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl24`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl25`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl26`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl27`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl28`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl29`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl30`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl31`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl32`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl33`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl34`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl35`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl36`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl37`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl38`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl39`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl40`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl41`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl42`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl43`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl44`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl45`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl46`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl47`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl48`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl49`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl50`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl51`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl52`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl53`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`pricelvl54`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
prmethod01	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 1)	NULL	Not mapped	Modifier price method at slot position 1.
prmethod02	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 2)	NULL	Not mapped	Modifier price method at slot position 2.
prmethod03	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 3)	NULL	Not mapped	Modifier price method at slot position 3.
prmethod04	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 4)	NULL	Not mapped	Modifier price method at slot position 4.
prmethod05	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 5)	NULL	Not mapped	Modifier price method at slot position 5.
prmethod06	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 6)	NULL	Not mapped	Modifier price method at slot position 6.
prmethod07	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 7)	NULL	Not mapped	Modifier price method at slot position 7.
prmethod08	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 8)	NULL	Not mapped	Modifier price method at slot position 8.
prmethod09	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 9)	NULL	Not mapped	Modifier price method at slot position 9.
prmethod10	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 10)	NULL	Not mapped	Modifier price method at slot position 10.
prmethod11	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 11)	NULL	Not mapped	Modifier price method at slot position 11.
prmethod12	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 12)	NULL	Not mapped	Modifier price method at slot position 12.
prmethod13	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 13)	NULL	Not mapped	Modifier price method at slot position 13.
prmethod14	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 14)	NULL	Not mapped	Modifier price method at slot position 14.
prmethod15	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 15)	NULL	Not mapped	Modifier price method at slot position 15.
prmethod16	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 16)	NULL	Not mapped	Modifier price method at slot position 16.
prmethod17	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 17)	NULL	Not mapped	Modifier price method at slot position 17.
prmethod18	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 18)	NULL	Not mapped	Modifier price method at slot position 18.
prmethod19	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 19)	NULL	Not mapped	Modifier price method at slot position 19.
prmethod20	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 20)	NULL	Not mapped	Modifier price method at slot position 20.
prmethod21	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 21)	NULL	Not mapped	Modifier price method at slot position 21.
prmethod22	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 22)	NULL	Not mapped	Modifier price method at slot position 22.
prmethod23	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 23)	NULL	Not mapped	Modifier price method at slot position 23.
prmethod24	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 24)	NULL	Not mapped	Modifier price method at slot position 24.
prmethod25	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 25)	NULL	Not mapped	Modifier price method at slot position 25.
prmethod26	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 26)	NULL	Not mapped	Modifier price method at slot position 26.
prmethod27	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 27)	NULL	Not mapped	Modifier price method at slot position 27.
prmethod28	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 28)	NULL	Not mapped	Modifier price method at slot position 28.
prmethod29	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 29)	NULL	Not mapped	Modifier price method at slot position 29.
prmethod30	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 30)	NULL	Not mapped	Modifier price method at slot position 30.
prmethod31	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 31)	NULL	Not mapped	Modifier price method at slot position 31.
prmethod32	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 32)	NULL	Not mapped	Modifier price method at slot position 32.
prmethod33	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 33)	NULL	Not mapped	Modifier price method at slot position 33.
prmethod34	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 34)	NULL	Not mapped	Modifier price method at slot position 34.
prmethod35	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 35)	NULL	Not mapped	Modifier price method at slot position 35.
prmethod36	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 36)	NULL	Not mapped	Modifier price method at slot position 36.
prmethod37	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 37)	NULL	Not mapped	Modifier price method at slot position 37.
prmethod38	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 38)	NULL	Not mapped	Modifier price method at slot position 38.
prmethod39	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 39)	NULL	Not mapped	Modifier price method at slot position 39.
prmethod40	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 40)	NULL	Not mapped	Modifier price method at slot position 40.
prmethod41	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 41)	NULL	Not mapped	Modifier price method at slot position 41.
prmethod42	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 42)	NULL	Not mapped	Modifier price method at slot position 42.
prmethod43	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 43)	NULL	Not mapped	Modifier price method at slot position 43.
prmethod44	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 44)	NULL	Not mapped	Modifier price method at slot position 44.
prmethod45	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 45)	NULL	Not mapped	Modifier price method at slot position 45.
prmethod46	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 46)	NULL	Not mapped	Modifier price method at slot position 46.
prmethod47	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 47)	NULL	Not mapped	Modifier price method at slot position 47.
prmethod48	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 48)	NULL	Not mapped	Modifier price method at slot position 48.
prmethod49	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 49)	NULL	Not mapped	Modifier price method at slot position 49.
prmethod50	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 50)	NULL	Not mapped	Modifier price method at slot position 50.
prmethod51	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 51)	NULL	Not mapped	Modifier price method at slot position 51.
prmethod52	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 52)	NULL	Not mapped	Modifier price method at slot position 52.
prmethod53	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 53)	NULL	Not mapped	Modifier price method at slot position 53.
prmethod54	staging.brink_settings2_modifier_group_items	price_method (filtered by position = 54)	NULL	Not mapped	Modifier price method at slot position 54.
`subindex`	`N/A`	`N/A`	`NULL`	`Not mapped`	No subgroup/subindex field is documented.
`qstsmode`	`N/A`	`N/A`	`NULL`	`Not mapped`	No question-set mode field is documented.
`refill`	`N/A`	`N/A`	`NULL`	`Not mapped`	No refill flag is documented.
`maxrefills`	`N/A`	`N/A`	`NULL`	`Not mapped`	No max-refills field is documented.
`defrdmod`	`N/A`	`N/A`	`NULL`	`Not mapped`	No default-required-modifier field is documented.
`nosub01`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub02`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub03`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub04`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub05`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub06`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub07`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub08`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub09`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub10`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub11`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub12`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub13`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub14`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub15`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub16`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub17`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub18`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub19`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub20`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub21`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub22`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub23`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub24`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub25`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub26`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub27`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub28`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub29`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub30`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub31`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub32`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub33`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub34`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub35`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub36`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub37`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub38`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub39`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub40`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub41`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub42`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub43`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub44`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub45`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub46`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub47`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub48`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub49`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub50`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub51`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub52`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub53`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`nosub54`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`"type"`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`hideprice`	`N/A`	`N/A`	`NULL`	`Not mapped`	No hide-price flag is documented.
`modifier_group_name`	`staging.brink_settings2_modifier_groups`	`display_name`	`NULL`	`Not mapped`	Best readable business label.
`modifier_option_name_summary`	`staging.brink_settings2_modifier_group_items`	`item_id`	`NULL`	`Not mapped`	Requires a derived summary by joining `item_id` to the Brink item master if readable names are needed.
`min_select`	`staging.brink_settings2_modifier_groups`	`minimum`	`NULL`	`Not mapped`	Direct minimum-select value.
`max_select`	`staging.brink_settings2_modifier_groups`	`maximum`	`NULL`	`Not mapped`	Direct maximum-select value.
`is_active`	`staging.brink_settings2_modifier_groups`	`is_deleted`	`NULL`	`Not mapped`	Requires inverse transform if curated keeps active status.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`modifier_group_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_modifier_group_id`	`staging.brink_settings2_modifier_groups`	`modifier_group_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.
`effective_from_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No effective-start timestamp is documented on modifier groups.
`effective_to_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No effective-end timestamp is documented on modifier groups.
`is_current`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse SCD field.
`_etl_batch_id`	staging.brink_settings2_modifier_groups	_etl_batch_id	`_etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	staging.brink_settings2_modifier_groups	_etl_source_type	`_etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	staging.brink_settings2_modifier_groups	_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
`longname`	`Settings.GetModifierGroups -> ModifierGroups[].Description`	Keep `DisplayName` as the main mapping, but `Description` is also available in the Brink contract and can be exposed for internal/business interpretation.
`is_active`	`Settings.GetModifierGroups -> ModifierGroups[].IsDeleted`	Brink exposes raw delete state directly; use it to validate the derived active flag.
`item01`-`item54`	`temp/GetModifierGroups_WhenConfigured_CallsRealBrinkEndpoint.xml -> ModifierGroups[].Items[].(ItemId, Position, Price, PriceMethod)`	Sample payloads confirm the positional slot data exists in real responses.