# HAV Seafood — Cross-Domain Relationship Tables

## Purpose

This workbook is a **derived enterprise reference layer** that connects authoritative HAV Seafood architecture across organization, employees, roles, locations, external organizations, items, systems, data ownership and Production. It is designed to make cross-domain joins and AI navigation easier without duplicating ownership of the underlying master data.

Nothing in this workbook supersedes an authoritative architecture workbook. If a value conflicts with its source, the source workbook wins.

## Workbook contents

- **Enterprise_Entity_Reference** — Shows the authoritative architecture, business owner and system of record for governed enterprise master entities.
- **Employee_Organization** — Flattened current-state view of all 92 employees with role, job family, department, organizational unit, position, manager and primary location.
- **Department_Location** — Department-to-location relationships.
- **Department_System** — Department-to-system usage relationships.
- **Role_Department_Position** — Connects reusable job roles to departments, organizational units and structural positions.
- **External_Organization_Roles** — External organization identities and their supplier/customer/service/logistics/regulatory roles.
- **Item_Enterprise_Reference** — Compact reference for all 175 current enterprise items and their source masters.
- **Entity_Owner_System** — Combines business-domain ownership with system-of-record ownership for master entities.
- **Data_Object_System** — Compact system-of-record reference for all governed master, transactional and reporting data objects.
- **Production_Enterprise_Bridge** — Consolidates Production-to-enterprise mappings for employees, teams, roles, locations and item/hierarchy entities while preserving Production IDs.
- **Identifier_Reference** — Simplified extract of enterprise identifier conventions.
- **Relationship_Catalog** — Describes each relationship table, its meaning and authoritative source workbooks.
- **Architecture_Notes** — Scope, authority and regeneration rules.
- **Data_Dictionary** — Field definitions and relationship/key semantics.

## Key boundaries

This workbook contains **static derived relationships only**. It does not contain sales orders, purchase orders, production batches, absences, maintenance work orders, QC results, inventory movements, customer interactions or other operational history.

Detailed Production-only mappings such as line-to-SKU, material-to-work-center, product-to-raw-material and product-allergen relationships remain in `seafood_production_reference_tables_v1.xlsx`.

## Regeneration rule

Because this workbook is derived, it should be regenerated when upstream Shared Enterprise architecture changes materially. No new authoritative business IDs or master records should be created here.
