Workday · Core HR
Core HR
Four reports built on two facts and five dimensions. Every page carries the definitions, the traps, the SQL, and sample rows, and the sample numbers tie across all four reports.
◆The data model
◆Reports
Headcount & FTE TrendLive
The four definitions that make dashboards disagree, fixed once, and the query on the snapshot.
MovementLive
Three kinds of hire, the tenure-reset trap, and net change that ties to headcount.
Turnover & RetentionLive
The denominator fixed, retention done as a cohort, and the first two-fact query.
Span of ControlLive
Who counts as a manager, the distribution over the average, and the layer signal.
◆Objects behind the reports
WorkerLive
The center of the model: who counts, the delivered windows, and dim_worker as SCD2.
Supervisory OrganizationLive
The reporting tree, the flatten recipe, and the reorg trap that corrupts extracts.
Job ProfileLive
The job architecture, the business-title trap, and dim_job with history.
Cost Center & CompanyLive
The finance bridge: one mapped dimension joining Workday people cost to ERP spend.
Want Core HR live on your cloud in 10 days?
The model on these pages, built on your data, reconciled against Workday, and you own every line.