# HAV Seafood — Employee Identity & Organizational Reference

## Purpose

This workbook defines the enterprise-wide employee identity reference and current organizational assignments for HAV Seafood. It provides a single employee spine that other architectures can reference consistently while the detailed HR Architecture is still to be built.

The workbook contains **92 current synthetic employees**: the **65 existing Production/Operations employees** plus **27 additional employees** covering executive management, procurement, sales, marketing, finance/administration, HR, and IT.

## Workbook contents

- **Employees** — Enterprise employee identity list, current descriptive job titles, existing Production Role_ID values where available, employment category, lifecycle status, and source provenance.
- **Org_Assignments** — Current department, organizational unit, structural position, primary enterprise location, and manager assignment for every employee.
- **Production_Employee_Map** — Reconciles all 65 existing Production employee records with the Shared Enterprise department, organizational-unit, position, location, and management hierarchy.
- **Management_Reference** — Current occupants of all management/lead positions defined in the Company & Organizational Structure workbook, including the two Shift Supervisor seats.
- **Employment_Categories** — Controlled employment-category reference values used by the employee identity layer.
- **Architecture_Notes** — Key assumptions, ownership boundaries, transition rules, and scope limitations.
- **Data_Dictionary** — Field definitions, datatypes, key roles, and nullability rules.

## Relationship to Production Architecture

`EMP001` through `EMP065` are preserved from `seafood_production_people_dataset_v1.xlsx`. Their existing names, job titles and Production `Role_ID` values are retained. Production continues to own production-specific skills, proficiency, crew/shift assignments, work-center qualifications and cross-training.

The enterprise structure adds the Managing Director above the existing Production Manager and maps Production's mixed department/team labels into the enterprise department and organizational-unit model without changing the Production source records.

## Relationship to future HR Architecture

HR is the intended long-term authoritative owner of the Employee master and Job Role architecture. The future HR Architecture should adopt all 92 `Employee_ID` values from this workbook rather than create a replacement identifier set.

No new `Role_ID` values are created for the 27 non-production employees in this workbook. Their formal role IDs and job-family classifications will be defined in the separate Enterprise Job Roles & Job Families architecture.

## Boundaries

This workbook contains current static architecture only. It does not contain hire dates, salary, payroll, absence, attendance, employment history, performance history, transfers, termination history, personal contact information, bank details, national identifiers, or other private HR data.
