About this Dataset

Iowa Executive Branch Voluntary And Involuntary Employment Separations

The data provides information regarding voluntary and involuntary employment separations occurring within Iowa Executive Branch agencies except Regents. Voluntary employment separations generally include resignations, and retirements. Involuntary employment separations generally include dismissals, and layoffs. Reported data begins with the first pay period ending in Fiscal Year 2013, and is updated every two weeks. Fiscal years run from July 1 through June 30 and are labeled for the calendar year for which they end.
Organization: State of Iowa
Last updated: 2023-01-19T23:56:47.053156
Tags: dismissal, employment-separation, employment-status, layoff, resignation, retirement, state-employees

Tables

Table 1

@usgov.state_of_iowa_iowa_executive_branch_voluntary_and_invo_da3aa0b9.table_1

208.98 kB
14,499 rows
13 columns

CREATE TABLE table_1 (
  "record_number" BIGINT,
  "fiscal_year" BIGINT,
  "department_name" VARCHAR,
  "sub_unit_of_department" VARCHAR,
  "eeo_category_name" VARCHAR,
  "reason" VARCHAR,
  "employee_status" VARCHAR,
  "pay_plan" VARCHAR,
  "pay_grade" VARCHAR,
  "classification_title" VARCHAR,
  "separation_date" TIMESTAMP,
  "pay_period_end_date" TIMESTAMP,
  "current_fiscal_year" BOOLEAN
);