The tables behind Core HR

The central person record and the single source of truth for who is employed. Every other HR app in the stack references this table.

Authenticated human/service identity; an employee record or matching email alone grants no access.

Effective role, delegated preparation or restricted subject/class access, separately authorized and revocable.

Governed legal-employer and policy-country scope; no payroll calculation.

Worker classifications with their policy and statutory defaults.

Dated employment episode for a stable employee identity, preserving rehire breaks and employer changes.

Next-of-kin contacts per employee, employee-editable.

Spouse, partner, and children. Captured here so Payroll and a Benefits app can pull coverage without re-keying.

Versioned employee/lifecycle/master/policy proposal; only approved current content creates immutable history.

Reviewed deletion/retention/hold action with actual protected-store outcome and minimal audit tombstone.

Seat-level org entries. A Position is what an Employee fills — the “chair” — and persists across incumbents.

Canonical job titles (Software Engineer II, Regional Sales Manager).

Organizational departments (Engineering, Sales, People, Finance).

Physical and remote locations where employees work.

Top-level business units that roll up departments (Commercial, Technology, Operations, Corporate).

Organizational cost-center reference codes shared with external Payroll/Finance; this app does not calculate employee cost or originate GL journals.

One whole-seat dated primary assignment per employee; approved future intervals reserve capacity without changing present headcount.

The seat-side mirror of employment history: when a Position opened, was filled, refilled, or frozen — independent of which Employee occupied it.

One dated opening/fill episode per whole capacity slot; retained across refills and transfers.

Point-in-time captures of the org structure for audit and “what did the org look like on date X” queries.

Declared safe current/as-of reporting projection for organization and headcount screens.

Governed legal-employer and policy-country scope; no payroll calculation.

Versioned employee/lifecycle/master/policy proposal; only approved current content creates immutable history.

Immutable actual-person decision bound to exact subject, revision, domain scope and conflict exclusions.

Every lifecycle event: hire, promotion, transfer, manager change, leave-of-absence, termination, rehire.

Dated employment episode for a stable employee identity, preserving rehire breaks and employer changes.

The seat-side mirror of employment history: when a Position opened, was filled, refilled, or frozen — independent of which Employee occupied it.

One whole-seat dated primary assignment per employee; approved future intervals reserve capacity without changing present headcount.

The central person record and the single source of truth for who is employed. Every other HR app in the stack references this table.

Effective role, delegated preparation or restricted subject/class access, separately authorized and revocable.

Authenticated inbound fact and outbound request/outcome identity; external status cannot rewrite HR-approved employment.

Independently reviewed nonposting HR cutover preserving people, employment, obligations and unresolved external work.

Leave categories with country- and class-scoped accrual rules. Vacation, Sick, Parental, Bereavement, Unpaid, Jury Duty.

Effective country/type/entity leave rule with explicit schedule, reservation, accrual and rollover semantics.

Versioned local holiday/nonwork date basis used only for day-based leave calculation.

Effective employee work-pattern snapshot for leave dates; not time tracking or shift-roster software.

Employee-submitted leave requests requiring manager approval.

Frozen daily fraction, leave-year and balance allocation with explicit reserved/taken/cancelled evidence.

Append-only signed day ledger; each business effect changes explicit balance buckets atomically.

Derived day balance for one employee, leave-type pool and leave year; effective ledger entries and active daily reservations are the authority.

Immutable actual-person decision bound to exact subject, revision, domain scope and conflict exclusions.

Dated employment episode for a stable employee identity, preserving rehire breaks and employer changes.

Per-hire (or per-separation) container of lightweight tasks. Drives first-90-days workflow and offboarding clearance.

Immutable reviewed lightweight task template, not a separate ITSM system.

Stable assigned task with actual completion/waiver/external outcome evidence and minimal participant data access.

Versioned employee/lifecycle/master/policy proposal; only approved current content creates immutable history.

Immutable actual-person decision bound to exact subject, revision, domain scope and conflict exclusions.

Dated employment episode for a stable employee identity, preserving rehire breaks and employer changes.

One whole-seat dated primary assignment per employee; approved future intervals reserve capacity without changing present headcount.

Effective role, delegated preparation or restricted subject/class access, separately authorized and revocable.

Authenticated inbound fact and outbound request/outcome identity; external status cannot rewrite HR-approved employment.

Tax forms (W-4, I-9, Form 16), contracts, NDAs, visa and work-permit documents, certificates, and policy acknowledgments.

Versioned policy documents employees must acknowledge — handbook, conduct, IT-acceptable-use, harassment, privacy.

One exact published policy version/content obligation for one employee/spell.

Configured effective evidence requirement and access class, without a legal-compliance verdict.

Scoped employee requirement result linked to reviewed current evidence; safe alerts are separate from files.

Reviewed deletion/retention/hold action with actual protected-store outcome and minimal audit tombstone.

Versioned employee/lifecycle/master/policy proposal; only approved current content creates immutable history.

Immutable actual-person decision bound to exact subject, revision, domain scope and conflict exclusions.

Effective role, delegated preparation or restricted subject/class access, separately authorized and revocable.

Authenticated inbound fact and outbound request/outcome identity; external status cannot rewrite HR-approved employment.

Declared safe current/as-of reporting projection for organization and headcount screens.

Point-in-time captures of the org structure for audit and “what did the org look like on date X” queries.

Dated employment episode for a stable employee identity, preserving rehire breaks and employer changes.

One whole-seat dated primary assignment per employee; approved future intervals reserve capacity without changing present headcount.

One dated opening/fill episode per whole capacity slot; retained across refills and transfers.

Every lifecycle event: hire, promotion, transfer, manager change, leave-of-absence, termination, rehire.

Derived day balance for one employee, leave-type pool and leave year; effective ledger entries and active daily reservations are the authority.

Append-only signed day ledger; each business effect changes explicit balance buckets atomically.

One exact published policy version/content obligation for one employee/spell.

Scoped employee requirement result linked to reviewed current evidence; safe alerts are separate from files.

Independently reviewed nonposting HR cutover preserving people, employment, obligations and unresolved external work.