Station Product Standards
Station Product Standards define per-station production expectations for each Product Family. This allows the same product family 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 Product-Level Standard Hours
Products carry their own standard_hours field (see Product). The per-station standards in this table provide additional granularity for station-specific efficiency calculations, allowing the same product family to have different expectations depending on where in the process flow it is being worked.
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