Icon for Socrata external plugin
Updated 3 months ago
Indexed 30 minutes ago

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.


NameSocrata field nameColumn name in sgr mountData typeDescription
Fiscal Yearfiscal_yearfiscal_yearTextFiscal 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.
% CT & OTct_otct_otNumberSum of comp time hours and overtime hours divided by regular hours. Expressed as a percentage
Over Time Paid (Hours)over_time_paidover_time_paidNumberHours of overtime paid in pay period
DepartmentdepartmentdepartmentTextName of the state agency or sub-unit of the state agency
Special Departmentspecial_departmentspecial_departmentTextName of state agency
Regular Hoursregular_hoursregular_hoursNumberRegular amount of hours worked in pay period
Holiday Earned (Hours)holiday_earnedholiday_earnedNumberHoliday hours earned in pay period.
Comp Time Earned (Hours)comp_time_earnedcomp_time_earnedNumberHours of comp time earned in pay period
Department Numberdepartment_numberdepartment_numberTextUnique code provided for the state agency or sub-unit of the state agency
Pay Periodpay_periodpay_periodTextPay period record is associated with. There are 26 pay periods in a fiscal year.
Pay Period Endpay_period_endpay_period_endCalendar dateDate pay period ended
Pay Period Startpay_period_startpay_period_startCalendar dateDate pay period started
FunctionfunctionfunctionTextFunctions are groups of agencies which make expenditures for similar programs and purposes
  • state_of_iowa_executive_branch_comp_time_holiday
Upstream Metadata