PG&E outlines RAMP data-template approach; discussion focuses on RRU granularity, CSV/SQL tradeoffs and NPV reporting

Pacific Gas and Electric Co. presented a draft Risk Assessment Mitigation Phase (RAMP) data template and a companion ‘‘RRU supplemental’’ table intended to link project-level information to mitigation-level risk results, PG&E representatives said at a California Public Utilities Commission technical working group session.

The PG&E presentation, led by Elijah and Vincent Loh and Yumi Boon, described a set of tabular outputs derived from the utility’s earlier transparency pilot and a joint IOU proposal for reporting risk-reducing units (RRUs). ‘‘We use that as our kind of starting basis for our RAMP data templates,’’ Vincent Loh, a representative for PG&E, said during the session. He noted the transparency pilot was filed in R.20-07-013 on Aug. 5.

Why it matters: the templates are meant to let parties and regulators trace how high-level risk reductions reported at the mitigation level map to individual projects or RRUs, while keeping the dataset queryable for analysis. Participants and utilities discussed trade-offs among file size, format, and analytic flexibility — whether data should be delivered as CSVs for database queries or as denormalized Excel spreadsheets for easier ad-hoc sorting.

PG&E’s proposal and the RRU supplemental table

PG&E described three core tables from the transparency pilot — the risk results table, a sensitivity table and a risk model listing — and proposed a supplemental table linking RRUs to risk tranche, year, mitigation and attribute. The RRU table would include RRU name, description, status, estimated contribution (a percent attributed to the mitigation’s risk reduction) and estimated cost. PG&E said the…