Data Model Specification

What data the calculation engine needs, from where, at what quality. Drives the Phase 1 data audit.

How to use

Walk through each domain with the relevant system owner. Confirm whether the data exists, at what quality, and what gaps remain. Rate each domain Green / Amber / Red.

Data quality rating

Rating	Definition	Action
Green	Complete, accurate, current.	Proceed.
Amber	Workable for v1 with stated confidence.	Proceed with caveats.
Red	Missing or unreliable.	Escalate. Uplift required.

Domain 1

Workforce

Source: HRIS, Payroll

Field	Granularity	Used in	Min quality
Employee ID (anonymised)	Per employee	Baseline, supply	100% records
Role title	Per employee	Baseline, capability mapping	Standardised
Capability area	Per employee	Baseline, demand, gap	Mapped to taxonomy
Org unit, location, employment type, FTE, hire date, age band	Per employee	Baseline, supply	100% records
Demographics (gender, Indigenous, disability, CALD)	Per employee	Inclusion impact	Self-reported, opt-in

Domain 2

Compensation & cost

Source: Payroll, Finance

Field	Granularity	Used in	Min quality
Base salary, super, leave loading, on-costs, overheads	Per employee / org-wide	Cost roll-up	Current
EA escalation %, recruitment cost, training cost	Org-wide / per role	Cost forecast	Annual benchmark

Domain 3

Attrition & turnover

Source: HRIS exit data

Field	Granularity	Used in	Min quality
Termination date, reason, tenure	Per departure	Attrition rate	100% records
Annual attrition % by capability	Per capability	Supply model	3-year history
Voluntary vs involuntary	Per departure	Attrition analysis	Categorised

Domain 4

Recruitment & mobility

Source: ATS, HRIS

Field	Granularity	Used in	Min quality
Time-to-fill, hires per period, promotions	Per role family	Supply model	12-month rolling
Internal mobility moves	Per move	Supply model	12-month rolling

Domain 5

Capital program

Source: Capital Investment Plan

Field	Granularity	Used in	Min quality
Capital spend forecast, project pipeline, phase profile	Per year, per discipline	Project demand	5-year horizon
FTE per $M of capex	Per discipline	Project demand	Historical or industry

Domain 6

Asset & maintenance

Source: Asset Management System

Field	Granularity	Used in	Min quality
Asset units, condition rating, maintenance hours	Per asset class	Asset demand	Within 24 months

Domain 7

Service & customer

Source: Customer Service System

Field	Granularity	Used in	Min quality
Customer connections, interaction volume, growth forecast	Per segment / channel	Service demand	Annual

Domain 8

Contractor

Source: Finance, Project Portfolio

Field	Granularity	Used in	Min quality
Contractor spend, FTE-equivalent, bill rates, panel arrangements	Per category	Cost roll-up, intervention	12-month rolling

Domain 9

Training & licences

Source: LMS, Compliance

Field	Granularity	Used in	Min quality
Mandatory training, trade licences, dev plans, cohorts	Per employee / per cohort	Compliance, pipeline	Current