Turnover By Service Time, Fiscal Years 2009-2013
State of Oklahoma
@usgov.state_of_oklahoma_turnover_by_service_time_fiscal_year_f0d3bd1c
State of Oklahoma
@usgov.state_of_oklahoma_turnover_by_service_time_fiscal_year_f0d3bd1c
CREATE TABLE data_turnover_by_service_time_fy_2009_2013 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" DOUBLE,
"reduction_in_force" BIGINT,
"voluntary_buyout" DOUBLE,
"voluntary_buyout_retirement" DOUBLE,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
CREATE TABLE n__c_turnover_by_service_time_2009 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" VARCHAR,
"reduction_in_force" BIGINT,
"voluntary_buyout" VARCHAR,
"voluntary_buyout_retirement" VARCHAR,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
CREATE TABLE n__c_turnover_by_service_time_2010 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" VARCHAR,
"reduction_in_force" BIGINT,
"voluntary_buyout" VARCHAR,
"voluntary_buyout_retirement" VARCHAR,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
CREATE TABLE n__c_turnover_by_service_time_2011 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" VARCHAR,
"reduction_in_force" BIGINT,
"voluntary_buyout" VARCHAR,
"voluntary_buyout_retirement" VARCHAR,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
CREATE TABLE n__c_turnover_by_service_time_2012 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" BIGINT,
"reduction_in_force" BIGINT,
"voluntary_buyout" BIGINT,
"voluntary_buyout_retirement" BIGINT,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
CREATE TABLE n__c_turnover_by_service_time_2013 (
"fiscal_year" VARCHAR,
"service_time" VARCHAR,
"resignation" BIGINT,
"retirement" BIGINT,
"discharge" BIGINT,
"death" BIGINT,
"termination" BIGINT,
"transferred_out" BIGINT,
"reduction_in_force" BIGINT,
"voluntary_buyout" BIGINT,
"voluntary_buyout_retirement" BIGINT,
"voluntary" BIGINT,
"involuntary" BIGINT,
"total" BIGINT
);
Anyone who has the link will be able to view this.