Equipment Product Standards
Per-product-per-equipment production standards. Defines how long a specific product takes on a specific piece of equipment and what scrap rate to expect.
Future migration: This relationship is currently at the equipment level. In a future release, it will migrate to the station level, as stations are the OPS-level organizational unit.
Purpose
Different products may have different production characteristics on different equipment. For example, a heavy pallet load takes longer in the sterilization chamber than a standard load, and may have a higher scrap rate on certain equipment.
Equipment Product Standards let you configure:
- Standard Hours — expected production time for this product on this equipment
- Target Scrap Rate (%) — expected scrap percentage for this product on this equipment
When these values are not set, the system falls back to the product-level defaults.
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 |
standard_hours | NUMERIC(10,2) | Expected hours for this product on this equipment |
target_scrap_rate | NUMERIC(5,2) | Expected scrap % for this product on this equipment |
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 the OEE Settings modal under the Product Families tab. When viewing a product’s details, expand the “Equipment Standards” section to see a table of all equipment with editable standard hours and scrap rate fields.
Fallback Chain
When the system needs standard hours or scrap rate for a product on an equipment:
- 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)