13.2 Core Public HR Metrics: Time-to-Hire, Turnover Rates, Cost-per-Hire, Diversity Indices & Civil Service Reporting

13.2 Core Public HR Metrics: Time-to-Hire, Turnover Rates, Cost-per-Hire, Diversity Indices & Civil Service Reporting

Public sector human resource management has evolved from transactional recordkeeping into an evidence-based strategic discipline. In an era of heightened fiscal scrutiny, demographic shifts, and competitive talent markets, public HR professionals must leverage quantitative metrics and workforce analytics to defend budget requests, optimize recruitment pipelines, enhance civil service efficiency, and comply with state and federal reporting mandates.

This section examines the core formulas, analytical frameworks, and statutory reporting instruments essential for professional public HR practice.

---

1. The Workforce Analytics Maturity Framework in Public Administration

Workforce analytics in government progresses through four distinct analytical stages:

+---------------------------------------------------------------------------------------------------+
|                         WORKFORCE ANALYTICS MATURITY IN PUBLIC HR                                 |
|                                                                                                   |
|   LEVEL 1: DESCRIPTIVE          LEVEL 2: DIAGNOSTIC          LEVEL 3: PREDICTIVE    LEVEL 4: PRESCRIPTIVE |
|   "What happened?"             "Why did it happen?"         "What will happen?"    "What should we do?"  |
|   +--------------------------+ +--------------------------+ +--------------------+ +--------------------+ |
|   | - Headcount reports      | | - Turnover root cause    | | - Retirement       | | - Targeted training| |
|   | - Average Time-to-Hire   | |   analysis by division   | |   forecasting      | |   interventions    | |
|   | - Overtime hours paid    | | - Testing failure rates  | | - Vacancy risk     | | - Competitive wage | |
|   | - Current vacancy rates  | |   by demographic group   | |   probability      | |   reclassification | |
|   +--------------------------+ +--------------------------+ +--------------------+ +--------------------+ |
+---------------------------------------------------------------------------------------------------+

• Descriptive Analytics: Historical reporting answering what occurred (e.g., "Our agency's overall turnover rate was 11.4% during Fiscal Year 2025").
• Diagnostic Analytics: Data exploration answering why it occurred (e.g., "Diagnostic exit interview analysis reveals that 65% of voluntary departures in Public Works occurred within the first 18 months of employment due to wage compression against regional municipal benchmarks").
• Predictive Analytics: Statistical modeling answering what is probable (e.g., "Actuarial retirement modeling projects that 38% of senior water treatment operators will retire within the next 36 months").
• Prescriptive Analytics: Optimization models answering what action to take (e.g., "Launching a sponsored apprenticeship program and a 5% retention stipend for certified operators will mitigate critical staffing shortages and save $450,000 in emergency overtime").

---

2. Time-to-Hire & Time-to-Fill in Civil Service Systems

Measuring recruitment cycle times is vital for assessing public sector merit system efficiency.

Definitions: Time-to-Fill vs. Time-to-Hire

• Time-to-Fill: The total number of calendar days elapsed from the date a job requisition/vacancy is formally approved to the date the selected candidate accepts the job offer (or their first day of work/Enter on Duty).
• Time-to-Hire: The number of calendar days elapsed from the date an individual candidate submits their application to the date that specific candidate accepts the job offer.

+---------------------------------------------------------------------------------------------------+
|                       PUBLIC SECTOR CIVIL SERVICE RECRUITMENT TIMELINE (135 DAYS)                  |
|                                                                                                   |
|   [REQ APPROVED] -> [POSTING] -> [MQ SCREEN] -> [EXAM & ORAL] -> [LIST ESTABLISHED] -> [INTERVIEW] -> [OFFER/BG] |
|      Days 1-14        Days 15-35    Days 36-48     Days 49-80        Days 81-90          Days 91-110   Days 111-135|
|                                                                                                   |
|   *Total Public Sector Time-to-Fill: 90 to 150+ Days (vs. Private Sector Average of 35-45 Days)   |
+---------------------------------------------------------------------------------------------------+

Stage-by-Stage Public Sector Bottleneck Analysis

While private sector firms can complete hiring in 30 to 45 days, public agencies frequently require 90 to 150+ days due to statutory merit requirements:

1. Requisition & Position Verification (Days 1–14): Confirmation of vacant PCN, job classification review, budget approval.
2. Statutory Job Posting Window (Days 15–35): Open recruitment window (typically 10–20 business days).
3. Minimum Qualification Screening (Days 36–48): HR analysts manually or systematically review transcripts, licenses, and experience.
4. Merit Examination Battery (Days 49–80): Written tests, scheduling SME oral boards, rating assessments.
5. Veterans' Preference & Eligible List Certification (Days 81–90): Point application, list ranking, Civil Service Commission certification.
6. Departmental Selection Interviews (Days 91–110): Appointing authority conducts interviews strictly within certification rules (e.g., Rule of Three).
7. Conditional Offer & Background Clearances (Days 111–135): Livescan fingerprinting, CJIS background checks, medical/psychological evaluations, reference checks, final appointment.

$\text{Average Time to Fill} = \frac{\sum(\text{Total Calendar Days from Requisition Approval to Offer Acceptance})}{\text{Total Number of Requisitions Filled}}$

---

3. Public Sector Turnover & Retention Analytics

Turnover metrics evaluate organizational health, supervisory effectiveness, and compensation competitiveness.

+---------------------------------------------------------------------------------------------------+
|                              PUBLIC SECTOR TURNOVER TAXONOMY                                      |
|                                                                                                   |
|                                  TOTAL SEPARATIONS                                                |
|                                  /               \                                                |
|                                 /                 \                                               |
|                     VOLUNTARY SEPARATIONS    INVOLUNTARY SEPARATIONS                              |
|                     (Resignations,           (Probationary rejections,                            |
|                      Retirements)             Disciplinary discharges, RIFs)                      |
|                       /         \                                                                 |
|                      /           \                                                                |
|          FUNCTIONAL TURNOVER    DYSFUNCTIONAL TURNOVER                                            |
|          (Poor performers exit) (Top performers & mission-critical                                |
|                                  personnel depart agency)                                         |
+---------------------------------------------------------------------------------------------------+

Core Turnover Formulas

$\text{Crude Turnover Rate (\%)} = \left(\frac{\text{Total Separations during Period}}{\text{Average Active Headcount during Period}}\right) \times 100$

$\text{Voluntary Turnover Rate (\%)} = \left(\frac{\text{Voluntary Resignations + Service Retirements}}{\text{Average Active Headcount during Period}}\right) \times 100$

$\text{First-Year Turnover Rate (\%)} = \left(\frac{\text{Number of Employees Separating with } < 1 \text{ Year of Service}}{\text{Total New Hires Appointed in the Same Period}}\right) \times 100$

Practical Step-by-Step Calculation Example

A county agency began the fiscal year with 1,200 active employees and ended the fiscal year with 1,300 active employees. During the year, the agency recorded:

• 80 voluntary resignations
• 45 normal service retirements
• 15 probationary rejections / disciplinary discharges
• 10 promotions/transfers to another county department (internal movement)
• 25 of the separating employees had less than 1 year of service; total new hires during the year was 200.

1. Calculate Average Headcount: $\text{Average Headcount} = \frac{1,200 + 1,300}{2} = 1,250$
2. Determine Total External Separations: (Internal transfers within the county are excluded from agency-level turnover calculations): $\text{Total Separations} = 80 + 45 + 15 = 140$
3. Calculate Crude Turnover Rate: $\text{Crude Turnover Rate} = \left(\frac{140}{1,250}\right) \times 100 = 11.2\%$
4. Calculate Voluntary Turnover Rate: $\text{Voluntary Turnover Rate} = \left(\frac{80 + 45}{1,250}\right) \times 100 = \left(\frac{125}{1,250}\right) \times 100 = 10.0\%$
5. Calculate First-Year Turnover Rate: $\text{First-Year Turnover Rate} = \left(\frac{25}{200}\right) \times 100 = 12.5\%$

---

4. Cost-per-Hire (CPH) in Public Sector Budgeting

Evaluating the true financial investment required to fill a public vacancy enables HR to optimize recruitment sourcing and defend operational budgets under the ANSI/SHRM Standard (ANSI/SHRM 06001.2012).

$\text{Cost per Hire (CPH)} = \frac{\sum(\text{External Recruitment Costs}) + \sum(\text{Internal Recruitment Costs})}{\text{Total Number of Hires}}$

+---------------------------------------------------------------------------------------------------+
|                         COST-PER-HIRE (CPH) COMPONENT BREAKDOWN                                   |
|                                                                                                   |
|   EXTERNAL COSTS                                     INTERNAL COSTS                               |
|   - Job board advertising (GovernmentJobs, LinkedIn) - Recruiter & HR analyst salary/benefit hours|
|   - Civil service testing / exam scoring fees        - SME interview panelist productive hours    |
|   - Livescan fingerprinting & background fees        - Civil Service Commission proctor costs     |
|   - Pre-employment physical & drug screening         - Departmental hiring manager interview time |
|   - Executive search firm / advertising agency fees  - Internal background investigator hours     |
+---------------------------------------------------------------------------------------------------+

Example: A city hires 50 new police officers during a fiscal year. External expenses total $150,000 (medical/psych evals, Livescan, test materials). Internal expenses total $100,000 (HR staff hours, background investigator salaries, oral board panelist time). Total recruitment cost = $250,000.
$\text{Cost per Hire} = \frac{\$250,000}{50} = \$5,000\text{ per hire}$

---

5. Diversity Indices & The EEOC Four-Fifths (80%) Rule

Public employers have an affirmative obligation to maintain equitable, non-discriminatory selection procedures under Title VII of the Civil Rights Act of 1964 and the EEOC Uniform Guidelines on Employee Selection Procedures (29 CFR Part 1607).

+---------------------------------------------------------------------------------------------------+
|                      THE FOUR-FIFTHS (80%) ADVERSE IMPACT RULE LOGIC                              |
|                                                                                                   |
|       +-----------------------------------------------------------------------------------+       |
|       |  STEP 1: Calculate Selection Rate (SR) for each demographic group                 |       |
|       |          SR = (Number of Applicants Hired / Number of Applicants in Group)        |       |
|       +-----------------------------------------------------------------------------------+       |
|                                                 |                                                 |
|                                                 v                                                 |
|       +-----------------------------------------------------------------------------------+       |
|       |  STEP 2: Identify the Benchmark Group (Group with the Highest Selection Rate)     |       |
|       +-----------------------------------------------------------------------------------+       |
|                                                 |                                                 |
|                                                 v                                                 |
|       +-----------------------------------------------------------------------------------+       |
|       |  STEP 3: Calculate Impact Ratio (IR) for Protected Comparison Groups              |       |
|       |          IR = Selection Rate of Comparison Group / Selection Rate of Highest Group|       |
|       +-----------------------------------------------------------------------------------+       |
|                                                 |                                                 |
|                                                 v                                                 |
|       +-----------------------------------------------------------------------------------+       |
|       |  STEP 4: Determine Adverse Impact:                                                |       |
|       |          - If Impact Ratio < 0.80 (80%) ---> ADVERSE IMPACT INDICATED             |       |
|       |          - If Impact Ratio >= 0.80 (80%) ---> NO ADVERSE IMPACT INDICATED         |       |
|       +-----------------------------------------------------------------------------------+       |
+---------------------------------------------------------------------------------------------------+

Step-by-Step Adverse Impact Calculation

A municipal civil service commission administers an entry-level firefighter examination with the following results:

• Group A (Majority Group): 300 applicants take the exam; 150 pass and are certified to the list.
• Group B (Protected Group): 100 applicants take the exam; 30 pass and are certified to the list.

1. Calculate Selection Rate for Group A: $\text{Selection Rate}_A = \frac{150}{300} = 0.50\text{ (50.0\%)}$
2. Calculate Selection Rate for Group B: $\text{Selection Rate}_B = \frac{30}{100} = 0.30\text{ (30.0\%)}$
3. Identify Highest Group: Group A is highest with 50.0%.
4. Calculate Impact Ratio: $\text{Impact Ratio} = \frac{\text{Selection Rate}_B}{\text{Selection Rate}_A} = \frac{0.30}{0.50} = 0.60\text{ (60.0\%)}$
5. Evaluate Against 80% Threshold: Since 60.0% is strictly less than 80.0% (4/5ths), the examination demonstrates adverse impact against Group B. The city must either validate the examination as job-related and consistent with business necessity or adopt an alternative selection instrument with less disparate impact.

---

6. Statutorily Mandated Public HR Reporting: The Federal EEO-4 Report

State and local governments are subject to strict federal and state statutory reporting mandates:

+---------------------------------------------------------------------------------------------------+
|                         FEDERAL EEO-4 STATUTORY REPORTING MATRIX                                  |
|                                                                                                   |
|   MANDATE               Biennial filing under Title VII, Section 709(c) (42 U.S.C. § 2000e-8(c)). |
|   APPLICABILITY         All state, county, city, and municipal governments with 100+ employees.    |
|   DATA MATRIX           Cross-tabulates race/ethnicity and gender across 8 job categories & salary|
+---------------------------------------------------------------------------------------------------+

The Eight Standard EEO-4 Job Categories

1. Officials and Administrators: City managers, department directors, bureau chiefs.
2. Professionals: Civil engineers, accountants, HR analysts, city planners, attorneys.
3. Technicians: GIS specialists, lab technicians, IT support, building inspectors.
4. Protective Service Workers (Sworn & Non-Sworn): Police officers, firefighters, correctional deputies.
5. Paraprofessionals: Library assistants, recreation leaders, code enforcement aides.
6. Administrative Support: Office specialists, payroll clerks, administrative assistants.
7. Skilled Craft Workers: Electricians, mechanics, water plant operators, carpenters.
8. Service / Maintenance: Custodians, park maintenance workers, refuse collectors.

Additional Public Sector Reporting Mandates

• Veterans' Employment Reporting (VETS-4212): Tracks affirmative hiring of protected veterans.
• Workers' Compensation Loss Runs & OSHA Form 300 Logs: Tracking recordable workplace injuries and Days Away, Restricted, or Transferred (DART) rates.
• Civil Service Commission Merit Status Reports: Annual municipal reports detailing provisional appointment durations, exam appeals, and certification utilization.