Equipment Product Standards
Per-product-per-equipment production standards. Defines how long a specific product takes on a specific piece of equipment or station.
Purpose
Different products may have different production characteristics on different equipment or stations. For example, a heavy pallet load takes longer in the sterilization chamber than a standard load.
Equipment Product Standards let you configure Standard Hours — expected production time for this product on this equipment or station.
When this value is not set, the system falls back to the product-level default.
Database Table: oee_product_equipment_config
| Column | Type | Description |
|---|---|---|
id | UUID (PK) | Auto-generated |
product_id | UUID (FK) | Which Product |
equipment_id | UUID (FK) | Which equipment or station row |
standard_hours | NUMERIC(10,2) | Expected hours for this product on this equipment or station |
created_at | TIMESTAMPTZ | Row creation time |
updated_at | TIMESTAMPTZ | Last update time |
Unique constraint on (product_id, equipment_id) — one config per product-equipment pair.
Management UI
Configured in product details and in the equipment/station editor. When viewing a product’s details, expand the “Equipment Standards” section to see a table of all equipment with editable standard hours. When editing a station or equipment record from the Stations page, the Product Standards section edits only the changed product rows; saving equipment metadata alone leaves existing standard-hour rows untouched.
Fallback Chain
When the system needs standard hours for a product on equipment or a station:
- Equipment Product Standard (
oee_product_equipment_config) — most specific - Product default (
ops_products.standard_hours/ops_products.target_scrap_rate) — fallback
See Also
- Product Hierarchy — product and product family management
- Product — product glossary entry
- Machine — equipment glossary entry
- Station Product Standards — similar concept at the station level (for OPS/labor)