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.
◆History
Heads or FTELive
The workforce number nobody labels: headcount and full-time equivalents, side by side from one fact.
Contingent workforceLive
The real count: 351 employees plus the 27 contingent workers every delivered headcount excludes by design.
Headcount as of any dateLive
Where delivered history stops, and the owned daily snapshot that answers any date, any year.
The trending storeLive
Monthly grain, a window of about 36 periods, purge beyond it. The limits, and the copy-out.
Turnover calculationLive
The 200 percent artifact, endpoint denominators, and the average-headcount math that holds up.
◆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.