core_rus12__yearly_plant_labor
Return to SearchAnnual time series of labor and payroll information for plants owned by RUS borrowers.
- Most-recent data:
2021
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
USDA RUS Form 12 -- Financial and Operating Report: Electric Power Supply (Parts D, E, F, G - Section B)
- Primary key:
This table has no primary key. The primary key should be report_date, borrower_id_rus, plant_name_rus, and plant_type, but this table did not report plant_type before 2009 and there are respondents who report multiple rows per plant pre-2009. The data cannot be backfilled because there is no way to distinguish between duplicate rows pre-2009.
Usage Warnings
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
Note the lack of plant_type pre-2009 leading to a lack of reliable primary keys.
Plant-level data from core_rus12__yearly_plant_operations_by_plant can be matched to data from this table, but you must also join this data usingthe borrower_id_rus column as well as the report_date and plant_name. This is because the core_rus12__yearly_plant_operations_by_plant table includes records from each plant owner. The RUS instructions note that:
you should use caution when using total plant data since there are cases where more than one Borrower shares units at the same plant which means that you will be getting duplicate plant total records (and there is no guarantee that the total plant records entered by two borrowers for the same plant will be identical).
Columns
Date reported.
Unique identifier of RUS (Rural Utilities Service) borrower. These ID's are structured as: two character state acronyms followed by four digits.
Name of the plant as reported to RUS.
Type of plant.
Number of employees hired full-time for normal operations of the system.
Number employees regularly employed on a part-time basis. Exclude employees hired for short periods of time to complete special jobs.
Total number of hours worked by employees.
The amount of payroll spent on plant maintenance.
The amount of payroll spent on plant operations.
The amount of plant payroll spent on accounts other than maintenance and operations.