Repository Docs & Knowledge Base

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

Analytical data warehouse schemas, curated tables, and Redshift/Athena data models.

warehouse-model/docs/features/ETL/warehouse-data/brinkPos-curated-model-mapps/pos_tables.md 3,258 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

Brink mapping for `curated.pos_tables`

Business property mappings describe how Brink table 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.

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`id`	`staging.brink_settings2_get_tables`	`table_id`	`NULL`	`Not mapped`	Direct table ID.
`usernumber`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink table staging does not expose a user-visible table number separate from `name`.
`revcenter`	`N/A`	`N/A`	`NULL`	`Not mapped`	No revenue-center field is documented on the Brink table snapshot.
`numseats`	`staging.brink_settings2_get_tables`	`capacity`	`NULL`	`Not mapped`	Best available seat-capacity field.
`ownerid`	`N/A`	`N/A`	`NULL`	`Not mapped`	No owner ID is documented on Brink tables.
`"desc"`	N/A	N/A	`NULL`	`Not mapped`	No matching field documented.
`style`	`N/A`	`N/A`	`NULL`	`Not mapped`	Brink table staging does not expose a style code.
`table_name`	`staging.brink_settings2_get_tables`	`name`	`NULL`	`Not mapped`	Direct table name.
`revenue_center_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No revenue-center lookup is documented for Brink tables.
`zone_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No documented join from Brink tables to sections or zones exists in the current staging docs.
`style_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No table-style lookup is documented.
`is_active`	`staging.brink_settings2_get_tables`	`is_active`	`NULL`	`Not mapped`	Direct active flag.

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`table_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_table_id`	`staging.brink_settings2_get_tables`	`table_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.
`_etl_batch_id`	staging.brink_settings2_get_tables	_etl_batch_id	`_etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	staging.brink_settings2_get_tables	_etl_source_type	`_etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	staging.brink_settings2_get_tables	_etl_ingested_at_utc	`_etl_ingested_at_utc AS _etl_ingested_at`	`Mapped`	ETL metadata propagated from staging.

No additional Brink portal lookup was confirmed for the current curated.pos_tables fields beyond GetTables.