Find "provision for depreciation" in the original ferc1 database

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

456 stars 106 forks source link

Find "provision for depreciation" in the original ferc1 database #46

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

There's a respondent-wide depreciation value reported to FERC, but it's not in the Plant In Service table. Uday/CPI want that number, so we need to figure out which FERC1 table it's in, and make sure we pull that table into the FERC1 and then PUDL DBs.

swinter2011 commented 7 years ago

Page 219. Account number 108.

See page 49 of form1_blank.pdf in pudl > docs > ferc > form1

zaneselvans commented 7 years ago

Looks like this is found in table f1_accumdepr_prvsn, which is stored in F1_3.DBF. It can be pulled in easily alongside the other initial tables that we're pulling, so I'll add it to constants.ferc1_default_tables so we can get it ingested too.