About this Dataset

State Of Iowa Executive Branch Comp Time, Holiday & Overtime Hours By Pay Period

This dataset includes hours of comp time earned, holiday earned and overtime paid for state employees within Executive Branch by pay period starting with the pay period ending July 8, 1999. Pay periods are two weeks long and end every other Thursday. Comp time and overtime reflect hours worked above an employee's regular work hours.
Organization: State of Iowa
Last updated: 2023-01-20T00:04:11.325804
Tags: comp-time, executive-branch, overtime, state-employees

Tables

Table 1

@usgov.state_of_iowa_state_of_iowa_executive_branch_comp_time_0131b78c.table_1

552.1 kB
35,121 rows
13 columns

CREATE TABLE table_1 (
  "function" VARCHAR,
  "special_department" VARCHAR,
  "department_number" BIGINT,
  "department" VARCHAR,
  "comp_time_earned_hours" DOUBLE  -- Comp Time Earned (Hours),
  "holiday_earned_hours" DOUBLE  -- Holiday Earned (Hours),
  "over_time_paid_hours" DOUBLE  -- Over Time Paid (Hours),
  "regular_hours" DOUBLE,
  "n__ct_ot" DOUBLE  -- % CT & OT,
  "pay_period_start" TIMESTAMP,
  "pay_period_end" VARCHAR,
  "fiscal_year" BIGINT,
  "pay_period" BIGINT
);