Skip to content
Between the Systems

Contents  /  Reference

What a Working Estate Looks Like

A description of the end state, assembled from everything here, as a checklist to measure a proposal against.

Reference · Reference

Rather than a summary, a description of the arrangement these notes point toward.

The foundations

One master for identity, referenced by every other system by identifier rather than by name.

One master per reference dimension — site, department, cost centre — with a named owner and effective dating.

A joiner, mover, leaver path that propagates in a stated order.

The joins

Four of them, drawn on one page, with what crosses, in which direction, by what mechanism, owned by whom.

Idempotent imports, a queryable delivery log, and a replay path for each.

A tolerance on the schedule-to-time comparison, so not every shift is an exception.

A narrow time-to-payroll interface carrying only what payroll uses.

The rules

A register: every pay rule, and the single system that applies it.

Versioned, reviewed after every reconfiguration and every upgrade.

Rules needing the schedule upstream; rules needing pay history in payroll.

The operation

A monthly reconciliation across all four joins, run before the pay run.

Differences investigated rather than absorbed.

A named chain owner with a deputy and allocated time.

A manual step register with owners.

A post-upgrade check, twenty minutes, every release.

The data

Retention periods that make sense across the four systems together.

Exports controlled or eliminated.

An access request answerable across the chain, rehearsed once.

The measures

Joins reconciling cleanly, month over month.

Manual corrections at period end, and hours spent on them.

Cross-module investigations and how long each took.

All three fall when the estate works, and all three are countable from what you already do.

What it produces

A pay figure that can be explained by following a chain rather than by asking three departments.

A problem that is found before payroll rather than after.

And a purchase decision made on the boundaries rather than the brochures, which is the difference between an estate and a collection of products.

Reviewing it annually

Six questions that describe whether the estate still works.

Do all four joins reconcile cleanly, month over month?

Have manual corrections at period end fallen?

Is the rule register current and versioned?

Do the retention periods across systems still make sense together?

Can a wrong figure be explained by following the chain rather than by asking three departments?

Would the estate be built this way again?

Follow the difficult record

Use the workflow reference to frame one representative case. The useful evidence is the record created when a value is corrected, approved and exported.