# HR Employee Employment Master

## Purpose

`hav_seafood_hr_employee_employment_master_v1.xlsx` defines the **current-state employment master** for HAV Seafood's 92 existing employees. It is part of Phase 1 business architecture and contains structural employment attributes only.

The workbook extends the existing Shared Enterprise employee identity and organizational reference rather than creating a competing employee master. Existing `Employee_ID` values `EMP001`-`EMP092`, role IDs, department IDs, organizational units, positions, managers and enterprise locations are preserved.

## Main contents

- **Employee_Employment** — one current employment record per employee, including employment status/type, full-time/part-time category, weekly hours, FTE, pay basis, HR employee group, employment start/continuous-service dates, time-registration/overtime flags and Production shift references where applicable.
- **Employment_Statuses** — controlled current employment-status codes.
- **Employment_Types** — permanent, fixed-term, temporary, seasonal and contractor classifications.
- **Employment_Categories** — existing Shared Enterprise `EC-*` full-time/part-time categories adopted unchanged.
- **Pay_Basis_Types** — salaried vs hourly structural pay basis.
- **HR_Employee_Groups** — HR workforce segmentation used to support later rules and dataset generation.
- **Control_Parameters** — full-time-hours baseline and authoritative system/company references.
- **Source_Mappings** — field-level ownership and source boundaries.
- **Architecture_Notes** — scope, assumptions and architecture boundaries.
- **Data_Dictionary** — field definitions and logical datatypes.

## Source relationships

The workbook is grounded in the existing:

- Shared Enterprise company/organization structure
- enterprise employee identity and organizational reference
- enterprise job role/job family model
- identifier standards
- enterprise systems landscape
- system/data ownership model
- Production people master
- Production shift patterns

`ESYS-005` **People & Payroll** is the intended authoritative employee/employment system of record.

For `EMP001`-`EMP065`, existing Production `Weekly_Hours` and `Hire_Date` values are preserved. Production shift group/pattern IDs are referenced but remain Production-owned. For `EMP066`-`EMP092`, employment start dates are synthetic current-state HR architecture seed values.

## Boundaries

This workbook does **not** contain:

- employment change history
- recruitment events or applicants
- attendance or time-clock records
- absence events
- overtime worked
- payroll runs or payslips
- salary/wage amounts
- performance records
- training activity/history
- termination events
- Production skills, proficiency or work-center qualifications

Detailed contractual rules, compensation structures, working-time rules, leave/absence rules, positions/workforce establishment and other HR frameworks belong to later HR architecture workbooks.

## Important modeling decisions

- All 92 current employees are modeled as **permanent employees** in the initial architecture.
- Existing full-time/part-time classifications are preserved; `EMP086` is modeled at 24 weekly hours, while existing Production part-time hours are preserved exactly.
- `1.0 FTE = 40 weekly hours`, consistent with the existing Production workforce architecture.
- FTE is derived from weekly hours.
- This is a **current-state master**, not an effective-dated history model.
- If a copied cross-domain reference conflicts with its authoritative Shared Enterprise or Production workbook, the authoritative source wins.

## Known source-data issue

The source Production people master contains two future-dated `Hire_Date` values relative to the architecture date 2026-08-12: `EMP015` = 2026-12-03 and `EMP026` = 2026-12-25, while both employees are classified as Active. These values are preserved and explicitly flagged in the HR workbook rather than silently replaced. They should be reconciled in the authoritative source architecture before later operational data generation.
