Attachment P - KYTC Jobs PPE 6-15-21 - WC codes.xlsx

This is a Kentucky Transportation Cabinet (KYTC) jobs and personnel expenditure spreadsheet dated June 15, 2021, documenting workforce allocation and compensation across multiple job classifications and wage codes. The document provides a comprehensive labor budget breakdown for KYTC operations, encompassing positions ranging from executive leadership through administrative support, technical specialists, engineering personnel, maintenance workers, and transportation technicians. The spreadsheet details over 300 individual job codes with corresponding titles, work classifications, hours allocated, and associated compensation amounts, representing the staffing structure and payroll commitments for KYTC operations during the specified period.

The compensation data is organized by Workers Compensation (WC) codes, wage types, and hour classifications, including regular hours coded as 2000 (hourly), 9200 (salaried), and 2082 (overtime at 1.5x multiplier). Total documented hours and amounts span from minimal allocations for certain specialized positions to substantial commitments for field-level positions such as Highway Technician roles, which collectively account for significant personnel hours and expenditures. The document captures the full scope of KYTC's workforce compensation structure, including executive administration, engineering and design functions, right-of-way operations, maintenance and facilities management, equipment operations, and support services, representing the agency's personnel investment strategy across all operational divisions and classifications.