# Production Relationships and Reference Tables Dataset

This Excel workbook provides cross-domain reference tables that connect the main structural datasets of the fictional Faroese seafood manufacturing facility.

It contains seven worksheets:

* **Role_Work_Center_Map** – 71 relationships showing which job roles can support or operate specific work centers.
* **Skill_Work_Center_Map** – 69 relationships linking required employee skills to production work centers.
* **Line_SKU_Map** – 98 relationships showing which production and support systems are involved in producing each finished SKU.
* **Material_Work_Center_Map** – 595 relationships connecting raw materials, ingredients, packaging materials, intermediates, and finished products to the work centers where they may be handled.
* **Product_Raw_Material_Map** – 87 high-level mappings connecting product variants and SKUs to their approved seafood raw-material forms.
* **Product_Allergen_Map** – 76 derived allergen relationships based on the existing recipes and ingredient definitions.
* **Entity_ID_Reference** – a master reference for 29 core entity types, ID conventions, and their authoritative source tables.

The workbook is intended as a relational lookup layer rather than a replacement for the detailed source datasets. It provides simplified cross-domain mappings that make later analysis, validation, event generation, and traceability easier while preserving the original workbooks as the authoritative data sources.
