Metric migration / HR-01
HR-01 Voluntary turnover rate, annualized
Owner: Human Resources. Unit: %. Reconciliation tolerance: 0.1. Target: 10.0 (lower is better).
Written definition
- Source
- Human Resources employee records
- Calculation
- Voluntary separations in the month divided by headcount on the first day of the month, times 12, times 100.
- Inclusions
- Regular employees; termination reason Voluntary.
- Exclusions
- Retirements and involuntary separations.
- Time frame
- Calendar month of separation.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Voluntary turnover rate, annualized
- Note
- Voluntary separations in the month divided by headcount on the first day of the month
- Script
perf_hr_01.sql
CDR value against PerfDB
Calculation as run by the CDR
select m.month, 100.0 * 12 * (select count(*) from curated.dim_employee e where e.term_reason = 'Voluntary' and date_trunc('month', e.term_date) = m.month) / nullif((select count(*) from curated.dim_employee e where e.hire_date <= m.month and (e.term_date is null or e.term_date >= m.month)), 0) as value from (select generate_series('2025-10-01'::date, '2026-10-01'::date, interval '1 month')::date as month) m
Reproduce now from the curated layer Runs the SQL above against the current curated tables, read only.
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 11.6 | 11.617 | 0.017 | Within tolerance |
| Nov 2025 | 3.5 | 3.516 | 0.016 | Within tolerance |
| Dec 2025 | 9.4 | 9.403 | 0.003 | Within tolerance |
| Jan 2026 | 8.3 | 8.317 | 0.017 | Within tolerance |
| Feb 2026 | 4.8 | 4.795 | -0.005 | Within tolerance |
| Mar 2026 | 10.9 | 10.854 | -0.046 | Within tolerance |
| Apr 2026 | 2.4 | 2.446 | 0.046 | Within tolerance |
| May 2026 | 6.2 | 6.179 | -0.021 | Within tolerance |
| Jun 2026 | 10.0 | 10.010 | 0.010 | Within tolerance |
| Jul 2026 | 8.9 | 8.898 | -0.002 | Within tolerance |
| Aug 2026 | 6.4 | 6.431 | 0.031 | Within tolerance |
| Sep 2026 | 7.8 | 7.801 | 0.001 | Within tolerance |
| Oct 2026 | 10.5 | 10.503 | 0.003 | Within tolerance |
Reconciliation history
| Run | Result | Months |
|---|---|---|
| L-20261101-0100 | Within tolerance | 13 |
| R-20261102-0200 | Within tolerance | 13 |
| R-20261103-0200 | Within tolerance | 13 |
| R-20261104-0200 | Within tolerance | 13 |
| R-20261105-0200 | Within tolerance | 13 |
| R-20261106-0200 | Within tolerance | 13 |
| R-20261107-0200 | Within tolerance | 13 |
| R-20261108-0200 | Within tolerance | 13 |
| R-20261109-0200 | Within tolerance | 13 |
| R-20261110-0200 | Within tolerance | 13 |
| R-20261111-0200 | Within tolerance | 13 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.