State of Iowa Executive Branch Comp Time, Holiday & Overtime Hours by Pay Period
mydata.iowa.gov | Last Updated 12 Dec 2023This 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.
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Function | function | text | Functions are groups of agencies which make expenditures for similar programs and purposes | Justice System Administration and Regulation Human Services Economic Development Education view top 100 |
| Special Department | special_department | text | Name of state agency | Corrections, Department of Human Services, Department of Commerce, Department of Education, Department of Inspections & Appeals, Department of view top 100 |
| Department Number | department_number | text | Unique code provided for the state agency or sub-unit of the state agency | 582 285 401 411 407 view top 100 |
| Department | department | text | Name of the state agency or sub-unit of the state agency | Corrections - Anamosa Human Services - Independence Corrections - Mt Pleasant Corrections - Clarinda Corrections - Newton view top 100 |
| Comp Time Earned (Hours) | comp_time_earned | number | Hours of comp time earned in pay period | 0.00 3.00 6.00 1.50 4.50 view top 100 |
| Holiday Earned (Hours) | holiday_earned | number | Holiday hours earned in pay period. | 0.00 8.00 16.00 12.00 24.00 view top 100 |
| Over Time Paid (Hours) | over_time_paid | number | Hours of overtime paid in pay period | 0.00 1.00 2.00 4.00 3.00 view top 100 |
| Regular Hours | regular_hours | number | Regular amount of hours worked in pay period | 80.00 160.00 240.00 320.00 400.00 view top 100 |
| % CT & OT | ct_ot | number | Sum of comp time hours and overtime hours divided by regular hours. Expressed as a percentage | 0 7.5 3.75 5 1.25 view top 100 |
| Pay Period Start | pay_period_start | calendar_date | Date pay period started | 2019-05-31T00:00:00.000 2020-02-07T00:00:00.000 2020-01-24T00:00:00.000 2021-06-11T00:00:00.000 2019-10-18T00:00:00.000 view top 100 |
| Pay Period End | pay_period_end | calendar_date | Date pay period ended | view top 100 |
| Fiscal Year | fiscal_year | text | Fiscal year pay period was in. Fiscal years start July 1st and end June 30th and are labeled after the calendar year for which they end. | 2020 2022 2021 2000 2001 view top 100 |
| Pay Period | pay_period | text | Pay period record is associated with. There are 26 pay periods in a fiscal year. | 6 23 25 5 22 view top 100 |