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

539.16 KB
35121 rows
13 columns


CREATE TABLE table_1 (
  "function" VARCHAR,
  "special_department" VARCHAR,
  "department_number" BIGINT,
  "department" VARCHAR,
  "comp_time_earned_hours" DOUBLE,
  "holiday_earned_hours" DOUBLE,
  "over_time_paid_hours" DOUBLE,
  "regular_hours" DOUBLE,
  "n__ct_ot" DOUBLE,
  "pay_period_start" TIMESTAMP,
  "pay_period_end" VARCHAR,
  "fiscal_year" BIGINT,
  "pay_period" BIGINT
);