About this Dataset

Louisville Metro KY - Total Hours Worked (Historical)

** The data set is no longer being updated.

The Office of Performance Improvement strives to provide Metro Government and its partners with customized improvement support to create a world-class city.

Data Dictionary:

L_ACCT - The account from which working hours were paid
L_FUND - The fund from which working hours were paid
WORKED_HRS_TYPE - The type of hours that were worked

REGULAR TIME - regularly scheduled hours worked
SCHEDULED OVERTIME - planned hours worked over regularly scheduled hours
UNSCHEDULED GENERAL FUND OVERTIME - unplanned hours worked over regularly scheduled hours paid by the general fund
OTHER OVERTIME - unplanned hours worked over regularly scheduled hours not paid by the general fund
L_DIVISION - The division code where hours were worked
DivName - The division name where hours were worked
DEPTID - The department code where hours were worked
Dept - The department name where hours were worked
SubDept - The area in the department where hours were worked
BIWEEKLY_PAY_PERIOD_END_DATE - The end date for the pay period when hours were worked
FiscalYear - The fiscal year when hours were worked
EARN_CODE - The code for the type of hours worked
EARN_DESCR - The description for the type of hours worked
AMOUNT_HOURS - The amount of hours worked
AMOUNT_DOLLARS - The amount of dollars paid for worked hours
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:23:27.179115
Tags: city-management-and-performance, historical, hours-worked, human-resources, louisville, louisville-metro, louisville-metro-ky, office-of-performance-improvement, opi

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_total__1925ca00.table_1

1.57 MB
69,764 rows
15 columns


CREATE TABLE table_1 (
  "l_acct" BIGINT,
  "l_fund" BIGINT,
  "worked_hrs_type" VARCHAR,
  "l_division" BIGINT,
  "divname" VARCHAR,
  "deptid" BIGINT,
  "dept" VARCHAR,
  "subdept" VARCHAR,
  "biweekly_pay_period_end_date" VARCHAR,
  "fiscalyear" BIGINT,
  "earn_code" VARCHAR,
  "earn_descr" VARCHAR,
  "amount_hours" DOUBLE,
  "amount_dollars" DOUBLE,
  "objectid" BIGINT
);