Station Product Standards
Station Product Standards define per-station production expectations for each Product Family. This allows the same product to have different standard hours, cycle times, and scrap rates at different stations.
Database Table: ops_station_product_standards
| Column | Type | Description |
|---|---|---|
id | UUID (PK) | Auto-generated |
product_family_id | UUID (FK) | References Product Family |
station_id | UUID (FK) | References Station |
cycle_time | NUMERIC | Expected cycle time at this station |
scrap_rate | NUMERIC | Expected scrap rate at this station |
standard_hours | NUMERIC | Station-specific standard hours |
Unique constraint: (product_family_id, station_id) — one standard per family-station combination.
Use Case
A product family “Widget Assembly” might have:
- Station “Cutting”: standard_hours = 0.5, scrap_rate = 2%
- Station “Assembly”: standard_hours = 1.5, scrap_rate = 1%
- Station “QC”: standard_hours = 0.25, scrap_rate = 0.5%
This granularity enables accurate per-station efficiency analysis.
Relationship to Standard Hours Cascade
The current Efficiency Calculation functions use the product/family-level standard hours:
COALESCE(ops_products.standard_hours, ops_product_families.standard_hours, 0)The per-station standard hours in this table provide additional granularity for station-specific efficiency calculations.
Codebase Paths
- Table:
database/sql_scripts/tables/ops_station_product_standards.sql - Functions:
database/sql_scripts/functions/ops/ops_product_family_station_spec_functions.sql