New Hire Statistics

CREATE TABLE new_hire_headcount_trend (
  "year" BIGINT,
  "fy_beginning_count" BIGINT,
  "new_hires" BIGINT,
  "n__of_beginning_count" VARCHAR
);

CREATE TABLE new_hire_demographics_18 (
  "fiscal_year" BIGINT,
  "total_new_hires" BIGINT,
  "white" BIGINT,
  "n__white" VARCHAR,
  "american_indian" BIGINT,
  "n__american_indian" VARCHAR,
  "asian" BIGINT,
  "n__asian" VARCHAR,
  "black_african_american" BIGINT,
  "n__black_african_american" VARCHAR,
  "hispanic" BIGINT,
  "n__hispanic" VARCHAR,
  "pacific_islander" BIGINT,
  "n__pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "n__not_specified" VARCHAR,
  "female" BIGINT,
  "n__female" VARCHAR,
  "male" BIGINT,
  "n__male" VARCHAR,
  "officials_administrators" BIGINT,
  "n__officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "n__professionals" VARCHAR,
  "technicians" BIGINT,
  "n__technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "n__protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "n__paraprofessionals" VARCHAR,
  "officials_clerical" BIGINT,
  "n__officials_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "n__skilled_craft" VARCHAR,
  "service_maintenance" BIGINT,
  "n__service_maintenance" VARCHAR,
  "classified" BIGINT,
  "n__classified" VARCHAR,
  "unclassified" BIGINT,
  "n__unclassified" VARCHAR,
  "traditionalists" BIGINT,
  "n__traditionalists" VARCHAR,
  "baby_boomers" BIGINT,
  "n__baby_boomers" VARCHAR,
  "gen_x" BIGINT,
  "n__gen_x" VARCHAR,
  "millennials" BIGINT,
  "n__millennials" VARCHAR
);