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/inventory_items.md 4,891 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

Brink mapping for `curated.inventory_items`

Main staging sources

staging.brink_settings2_items

Mapping groups

Business property mappings describe how Brink item 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
`inventory_id`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose an inventory master or stock item ID.
`sku`	`staging.brink_settings2_items`	`plu`	`NULL`	`Not mapped`	`skus` can be used as a fallback alternate identifier.
`item_name`	`staging.brink_settings2_items`	`name`	`NULL`	`Not mapped`	Best match for the inventory item name.
`pos_item_id`	`staging.brink_settings2_items`	`item_id`	`NULL`	`Not mapped`	Direct POS item identifier.
`category_name`	`staging.brink_settings_get_item_groups`	`name`	`NULL`	`Not mapped`	Resolve category name by joining `staging.brink_settings2_items` to `staging.brink_settings2_item_groups` on `item_id` and then to `staging.brink_settings_get_item_groups` on `item_group_id`.
`unit_of_measure`	`staging.brink_settings2_items`	`unit_name`	`NULL`	`Not mapped`	Best available unit label.
`cost_per_unit`	`staging.brink_settings2_items`	`cost`	`NULL`	`Not mapped`	Direct item cost.
`quantity_on_hand`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose stock-on-hand quantities.
`par_level`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose par levels.
`reorder_point`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose reorder points.
`vendor_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose vendor data.
`last_updated`	`N/A`	`N/A`	`NULL`	`Not mapped`	No inventory update timestamp is documented.
`store_id`	`N/A`	`N/A`	`NULL`	`Not mapped`	No store identifier is documented on the item snapshot.
`store_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No store name is documented on the item snapshot.
`vendor_id`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose vendor IDs.
`item_status`	`staging.brink_settings2_items`	`is_active`	`NULL`	`Not mapped`	Requires a transform from boolean active flag to a status label.
`last_counted_at_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink staging does not expose count timestamps.
`updated_at_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No item-update timestamp is documented.
`currency_code`	`N/A`	`N/A`	`NULL`	`Not mapped`	Currency is not documented in the Brink item snapshot.
`snapshot_at_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse snapshot metadata, not a Brink API field.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`inventory_item_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_inventory_item_id`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink does not expose a separate inventory-item 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.
`_etl_batch_id`	staging.brink_settings2_items	_etl_batch_id	`_etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	staging.brink_settings2_items	_etl_source_type	`_etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	staging.brink_settings2_items	_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
`category_name`	`Settings.GetItemGroups -> ItemGroup.Name`	Join `Settings2.GetItems.Items[].ItemGroups[]` to `GetItemGroups.ItemGroup.Id`. This lookup is now documented in the local Brink staging model.
`item_name`	`temp/GetItems_WhenConfigured_CallsRealBrinkEndpoint.xml -> Items[].Name`	Confirms the item master response carries the readable item name in sample payloads.
`cost_per_unit`	`temp/GetItems_WhenConfigured_CallsRealBrinkEndpoint.xml -> Items[].Cost`	Confirms `Cost` is present in sample payloads, not only in the WSDL.