About this Dataset

Turnover

This dataset contains resources that present State of Oklahoma workforce data through the current fiscal year. The data can be used for workforce planning purposes.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:59:48.393292
Tags: retirement, turnover, workforce, workforce-planning

Tables

FY 2018 Generational Turnover

@usgov.state_of_oklahoma_turnover.fy_2018_generational_turnover

3.83 kB
4 rows
4 columns

CREATE TABLE fy_2018_generational_turnover (
  "generation" VARCHAR,
  "starting_count" BIGINT,
  "turnover_count" BIGINT,
  "n__turnover" VARCHAR  -- % Turnover
);

FY 2018 Turnover By Generation

@usgov.state_of_oklahoma_turnover.fy_2018_turnover_by_generation

3.92 kB
4 rows
4 columns

CREATE TABLE fy_2018_turnover_by_generation (
  "generation" VARCHAR,
  "starting_count" BIGINT,
  "turnover_count" BIGINT,
  "n__statewide_turnover" VARCHAR  -- % Statewide Turnover
);

Retirement Eligibility And Age By Agency FY 2018

@usgov.state_of_oklahoma_turnover.retirement_eligibility_and_age_by_agency_fy_2018

18.76 kB
117 rows
10 columns

CREATE TABLE retirement_eligibility_and_age_by_agency_fy_2018 (
  "agency_number" BIGINT,
  "agency" VARCHAR,
  "end_fy_count" BIGINT,
  "avg_years_of_service" VARCHAR,
  "avg_age" VARCHAR,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "avg_years_to_retirement_eligibility" VARCHAR
);

Retirements: Eligible Vs. Actual

@usgov.state_of_oklahoma_turnover.retirements_eligible_vs_actual

5.88 kB
10 rows
6 columns

CREATE TABLE retirements_eligible_vs_actual (
  "fiscal_year" BIGINT,
  "number_eligible_to_retire" BIGINT,
  "n__workforce_eligible_to_retire" VARCHAR  -- % Workforce Eligible To Retire,
  "number_retirements" BIGINT,
  "n__of_total_workforce_retired" VARCHAR  -- % Of Total Workforce Retired,
  "n__retired_of_eligible" VARCHAR  -- % Retired Of Eligible
);

Turnover By Reasons Trends

@usgov.state_of_oklahoma_turnover.turnover_by_reasons_trends

9.66 kB
10 rows
12 columns

CREATE TABLE turnover_by_reasons_trends (
  "fiscal_year" BIGINT,
  "resignation" BIGINT,
  "retirement" BIGINT,
  "discharge" BIGINT,
  "death" BIGINT,
  "other" DOUBLE,
  "reduction_in_force" DOUBLE,
  "voluntary_buyout" DOUBLE,
  "voluntary_buyout_retirement" DOUBLE,
  "voluntary" VARCHAR  -- Voluntary %,
  "involuntary" VARCHAR  -- Involuntary %,
  "total_turnover" VARCHAR
);