Usage Warnings

• Borrower name data has been drawn from reported values over multiple years and tables of data which are not always consistent with each other. PUDL chooses the most consistent borrower name to facilitate cross-referencing even if that means some values will differ from the raw sources.

Additional Details

The data in this table comes from five different portions of RUS 12 corresponding to different plant types (steam, hydroelectric, combined_cycle, internal_combustion and nuclear). The original form includes plant operations data for each plant type reported in multiple ways: with records corresponding to the portion of plants that borrowers own as well as the whole plant. We split these records into two tables, core_rus12__yearly_plant_operations_by_borrower, which contains records reported at the borrower level, and core_rus12__yearly_plant_operations_by_plant, which contains records reported at the plant level.Records that are wholly owned by one borrower show up in both core_rus12__yearly_plant_operations_by_borrower and core_rus12__yearly_plant_operations_by_plant.

There are two boolean columns used to delineate which records are associated with the borrowers' share vs the whole plant - which is documented in _OR_PowerSupply Plant File Documentation.rtf in the newer years in the RUS 12 archive. One of these two fields - is_partly_owned_by_borrower - was not reported before 2009. For the pre-2009 years, we assume that all records that report TRUE for is_full_ownership_portion should end up in the by-plant table while all records should end up in the by-borrower portion of the table.Like the post-2009 records, this involves records from the original tables ending up in both of these PUDL tables.

Also there are two cleaning steps that we performed that alter the original data slightly:

• One dropped with unexpected ownership label and duplicate data: There is a Wisdom steam plant record that is labeled to be both fully owned by borrower and partly owned for one year, which is an unexpected combo based on the _OR_PowerSupply Plant File Documentation.rst documentation file in the rus12 archive. Luckily this plant has exactly the same records as the other Wisdom steam plant that year with more expected ownership labels.* Replaced two string values for unit_id_rus: There are two instances from 2018 of unit_id_rus's that have string values in them - WSL GT 12 and WSL ST 10. Based on pre-cleaned data, we were able to clearly identify that we can use just the numeric values in these bad strings - 12 and 10 respectively. This enables us to have an integer type for this unit_id_rus column..

Plant-level data can be matched to the :ref:core_rus12__yearly_plant_labor` and forthcoming core_rus12__yearly_plant_factors_and_maximum_demand, which report Section B and C data for all plants. 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).