# HAV Seafood HR Reference Tables

## Purpose

This workbook is the **derived, AI-friendly reference layer** for HAV Seafood's HR & Organization Architecture. It consolidates current-state relationships from the authoritative HR, Shared Enterprise and Production architecture workbooks so that people, roles, positions, contracts, compensation, working time, leave, capability, performance, recruitment, policy, approval authority and systems can be understood and joined quickly.

It belongs to **Phase 1 — Business Architecture**.

## File

`hav_seafood_hr_reference_tables_v1.xlsx`

## Authority rule

This workbook does **not** own master data. If any value in this workbook conflicts with an authoritative source workbook, the authoritative source wins.

The reference layer should be refreshed whenever an authoritative HR architecture workbook changes.

## Main front-door sheets

- **Employee_HR_Reference** — one compact current-state HR record for all **92 employees**, combining enterprise identity, organization, position seat, employment, contract, compensation, working time, leave entitlement and performance-profile references.
- **Role_HR_Profile** — one compact record for all **56 enterprise job roles**, combining authoritative role defaults plus clearly labelled current-incumbent summaries and counts.
- **Position_Employee_Map** — all **95 approved position seats**, including occupied and vacant seats, with current incumbency and selected HR classifications.

## Workbook contents

- **Employee_HR_Reference** — 92 employee-level reference rows.
- **Position_Employee_Map** — 95 approved position-seat rows.
- **Role_HR_Profile** — 56 job-role reference rows.
- **Employment_Contract_Map** — 92 current employee-to-contract relationships.
- **Compensation_Map** — 92 current compensation-reference rows including grade, band and synthetic current base rate.
- **Working_Time_Map** — 92 current working-time assignments, including bridges to Production shifts where applicable.
- **Leave_Entitlement_Map** — 92 current employee entitlement-profile assignments with compact annual-leave reference fields.
- **Competency_Training_Map** — 1100 role requirement relationships combining the authoritative competency and training requirement tables.
- **Performance_Map** — 92 current employee performance-profile assignments with role-level core/important dimension summaries.
- **Recruitment_Onboarding_Map** — 56 role-level recruitment, offer, onboarding and system-access summaries.
- **Policy_Applicability_Map** — 48 policy applicability rules.
- **Approval_Authority_Map** — 42 HR processes with compact approval/control relationships.
- **System_HR_Data_Map** — 64 HR-owned data-object and HR process/system reference rows based on existing Shared Enterprise ownership and HR process mappings.
- **Production_HR_Bridges** — 65 Production employee bridges preserving enterprise employee IDs, role/organization links, HR working-time interpretation and Production shift references.
- **HR_Entity_Registry** — authoritative source and ownership registry for the main HR entities.
- **Architecture_Sources** — detailed source-workbook/sheet catalog used by the reference layer.
- **Relationship_Catalog** — human-readable HR relationship model.
- **Architecture_Notes** — scope, ownership and refresh boundaries.
- **Data_Dictionary** — output-field definitions.

## Important architecture boundaries

### Shared Enterprise

Shared Enterprise remains authoritative for shared identity and enterprise structures such as employee identity, enterprise roles, locations, systems and shared identifiers where defined. HR extends these structures with domain-specific employment and people-management attributes.

### Production

Production remains authoritative for production-specific skills, proficiency, cross-training, work-center authorization, shift definitions and other operational workforce capability. The reference workbook only bridges to those structures.

### HR authoritative workbooks

Detailed HR rules remain in their respective source workbooks, including:

- Employee Employment Master;
- Positions & Workforce Establishment;
- Employment Terms & Contract Framework;
- Compensation Structure;
- Working-Time Framework;
- Leave & Absence Framework;
- Competency & Training Framework;
- Performance & Development Framework;
- Recruitment & Onboarding Framework;
- HR Policy & Employee Relations Framework;
- HR Process & Approval Authority.

## Current-state versus operational data

The workbook contains architecture/current-state references only. It intentionally does **not** contain operational history such as:

- recruitment requisitions or candidates;
- employment changes;
- timesheets or attendance;
- leave requests or absence events;
- payroll runs or payslips;
- training attendance/completions;
- performance reviews or ratings;
- grievances, disciplinary cases or investigations;
- approval requests or decisions.

Those belong to Phase 3 after the business stories have been designed.

## Story neutrality

No new anomalies, gaps, bottlenecks, high/low performers, pay problems, attendance patterns, recruitment issues or other business stories are introduced by this workbook. It is strictly a derived navigation and joining layer.
