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

Raw File

Brink mapping for `curated.labor_shifts`

Main staging sources used today

staging.brink_labor_shifts
staging.brink_labor_breaks

Mapping groups

Business property mappings describe how Brink labor content is 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
`shift_id`	`staging.brink_labor_shifts`	`shift_id`	`s.shift_id`	`Mapped`	Direct Brink shift ID.
`employee_id`	`staging.brink_labor_shifts`	`employee_id`	`s.employee_id`	`Mapped`	Direct employee ID from shift.
`job_id`	`staging.brink_labor_shifts`	`job_id`	`s.job_id`	`Mapped`	Direct job ID from shift.
`business_date`	`staging.brink_labor_shifts`	`business_date`	`CAST(s.business_date AS DATE)`	`Mapped`	Cast to DATE.
`start_time`	`staging.brink_labor_shifts`	`start_time`	`s.start_time`	`Mapped`	Direct shift start time.
`end_time`	`staging.brink_labor_shifts`	`end_time`	`s.end_time`	`Mapped`	Direct shift end time.
`minutes_worked`	`staging.brink_labor_shifts`	`minutes_worked`	`s.minutes_worked`	`Mapped`	Direct total minutes worked.
`regular_minutes_worked`	`staging.brink_labor_shifts`	`regular_minutes_worked`	`s.regular_minutes_worked`	`Mapped`	Direct regular minutes.
`overtime_minutes_worked`	`staging.brink_labor_shifts`	`overtime_minutes_worked`	`s.overtime_minutes_worked`	`Mapped`	Direct overtime minutes.
`extended_minutes_worked`	`staging.brink_labor_shifts`	`extended_minutes_worked`	`s.extended_minutes_worked`	`Mapped`	Direct extended minutes.
`pay_rate`	`staging.brink_labor_shifts`	`pay_rate`	`s.pay_rate`	`Mapped`	Direct pay rate.
`declared_tips`	`staging.brink_labor_shifts`	`declared_tips`	`s.declared_tips`	`Mapped`	Direct declared tips.
`shift_number`	`staging.brink_labor_shifts`	`number`	`s.number AS shift_number`	`Mapped`	Maps from staging `number` column to curated `shift_number`.
`break_count`	`staging.brink_labor_breaks`	`shift_id`	`COUNT(b.shift_id)`	`Derived`	Aggregated from breaks via LEFT JOIN + GROUP BY.
`total_break_minutes`	`staging.brink_labor_breaks`	`minutes`	`COALESCE(SUM(b.minutes), 0)`	`Derived`	Aggregated from breaks via LEFT JOIN + GROUP BY.
`currency_code`	`N/A`	`N/A`	`NULL`	`Not mapped`	No canonical currency source in Brink labor payload.

Technical and ETL property mappings

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_shift_id`	`staging.brink_labor_shifts`	`shift_id`	`s.shift_id`	`Mapped`	Direct shift ID for reconciliation.
`labor_shift_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.
`_etl_batch_id`	`staging.brink_labor_shifts`	`_etl_batch_id`	`s._etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	`staging.brink_labor_shifts`	`_etl_source_type`	`s._etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	`staging.brink_labor_shifts`	`_etl_ingested_at_utc`	`s._etl_ingested_at_utc AS _etl_ingested_at`	`Mapped`	ETL metadata propagated from staging.