catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.
https://catalyst.coop/pudl
MIT License
465 stars 107 forks source link

check metadata/calculations in `retained_earnings_ferc1` #2619

Closed e-belfer closed 1 year ago

e-belfer commented 1 year ago

As noted in #1811, this table has no defined calculations in the metadata. However, the line items should sum to a total and calculations are embedded into the form. We will have to define these manually in order to explode this table successfully.

Table metadata visible here: https://xbrlview.ferc.gov/yeti/resources/yeti-gwt/Yeti.jsp#tax~(id~8*v~72)!con~(id~79963)!net~(a~143*l~35)!lang~(code~en)!path~(wc)!rg~(rg~4*p~1)

The relationships between the line items and the total are enumerated in the form itself: image image