# Brink mapping for `curated.pos_tables`

## Main staging sources

- `staging.brink_settings2_get_tables`

## Mapping groups

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

## Business property mappings

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

## Technical and ETL property mappings

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

## Portal and sample validation

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