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

Raw File

Brink mapping for `curated.pos_jobs`

Business property mappings describe how Brink job content is 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
`job_id`	`staging.brink_settings2_jobs`	`job_id`	`job.job_id`	`Mapped`	Direct Brink job ID.
`name`	`staging.brink_settings2_jobs`	`name`	`job.name`	`Mapped`	Direct job name.
`job_unique_id`	`staging.brink_settings2_jobs`	`job_unique_id`	`job.job_unique_id`	`Mapped`	Direct unique identifier.
`export_code`	`staging.brink_settings2_jobs`	`export_code`	`job.export_code`	`Mapped`	Direct export code.
`is_bartender`	`staging.brink_settings2_jobs`	`is_bartender`	`job.is_bartender`	`Mapped`	Direct bartender flag.
`is_delivery_driver`	`staging.brink_settings2_jobs`	`is_delivery_driver`	`job.is_delivery_driver`	`Mapped`	Direct delivery driver flag.
`is_delivery_dispatcher`	`staging.brink_settings2_jobs`	`is_delivery_dispatcher`	`job.is_delivery_dispatcher`	`Mapped`	Direct delivery dispatcher flag.
`is_hostess`	`staging.brink_settings2_jobs`	`is_hostess`	`job.is_hostess`	`Mapped`	Direct hostess flag.
`training`	`staging.brink_settings2_jobs`	`training`	`job.training`	`Mapped`	Direct training flag.
`location_type`	`staging.brink_settings2_jobs`	`location_type`	`job.location_type`	`Mapped`	Direct location type.
`snapshot_date`	`staging.brink_settings2_jobs`	`snapshot_date`	`CAST(job.snapshot_date AS DATE)`	`Mapped`	Cast to DATE.
`is_active`	`N/A`	`N/A`	`NULL`	`Not mapped`	Deferred; Brink does not expose a clear active/inactive flag for jobs.
`currency_code`	`N/A`	`N/A`	`NULL`	`Not mapped`	No canonical currency source in Brink job payload.

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`source_system`	`N/A`	`N/A`	constant `'brink_pos'`	`Derived constant`	Warehouse constant.
`source_job_id`	`staging.brink_settings2_jobs`	`job_id`	`CAST(job.job_id AS VARCHAR(199))`	`Mapped`	Brink job ID cast to string for reconciliation.
`job_key`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse-generated key, not assigned by current insert.
`tenant_key`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse-generated tenant key, not assigned by current insert.
`tenant_name`	`N/A`	`N/A`	parameter `@tenant_id`	`ETL context`	Populated from ETL context, not from Brink payload.
`effective_from_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	SCD2 column deferred.
`effective_to_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	SCD2 column deferred.
`is_current`	`N/A`	`N/A`	`NULL`	`Not mapped`	SCD2 column deferred.
`_etl_batch_id`	`staging.brink_settings2_jobs`	`_etl_batch_id`	`job._etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	`staging.brink_settings2_jobs`	`_etl_source_type`	`job._etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	`staging.brink_settings2_jobs`	`_etl_ingested_at_utc`	`job._etl_ingested_at_utc AS _etl_ingested_at`	`Mapped`	ETL metadata propagated from staging.