Scrap Reason

oee reason glossary

A Scrap Reason is a categorized explanation for why parts were scrapped during production. Scrap reasons follow the same group-reason hierarchy as other reason taxonomies.

Database Tables

`oee_scrap_groups`

Column	Type	Description
`id`	UUID (PK)	Auto-generated
`site_id`	UUID (FK)	References Site
`name`	VARCHAR(100)	Group name (e.g., “Material Defects”, “Process Issues”)
`sort_order`	INTEGER	Display ordering

`oee_scrap_reasons`

Column	Type	Description
`id`	UUID (PK)	Auto-generated
`group_id`	UUID (FK)	References `oee_scrap_groups`
`code`	VARCHAR(50)	Reason code (e.g., “SCR001”), unique per group
`name`	VARCHAR(255)	Reason name (e.g., “Dimensional Out of Tolerance”)
`description`	TEXT	Optional details
`is_active`	BOOLEAN	Whether reason is currently available for selection
`sort_order`	INTEGER	Display ordering

Usage

Referenced by oee_batch_details.scrap_reason_id for OEE Job scrap tracking
Used in Station Analytics scrap Pareto analysis
Used in Station Dashboard KPIs for top scrap reason calculation

Codebase Paths

Tables: database/sql_scripts/tables/oee_scrap_groups.sql, database/sql_scripts/tables/oee_scrap_reasons.sql

See Also