# 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. |