FERC Electric Quarterly Report (EQR)
FERC_EQRfree10 data-quality rules for the FERC Electric Quarterly Report (EQR) filed by jurisdictional sellers of wholesale electricity. Covers required seller/contract/transaction fields, product and rate-unit value sets, balancing-authority and point identifiers, non-negative price/quantity, quarter validity, and duplicate suppression. Use it to validate the EQR XML before submission to FERC.
Checks included (10)
Required Transaction Fields Present
Each transaction must carry the seller company, contract id, transaction begin/end dates, quantity, and price.
Seller Company Name Present(seller_company)
Each filing must identify the seller (filer) company name.
Transaction References a Contract
Every transaction's contract id must exist in the filed contracts data.
Product Name Is a Valid FERC Product
The product name must be from the FERC EQR product name list (energy, capacity, transmission, and related products).
Rate Units Are Valid(rate_units)
The price/rate units must be a valid FERC unit (e.g. $/MWH, $/MW-DAY, $/KW-MO, FLAT RATE).
Reporting Quarter Is Valid(reporting_quarter)
The reporting quarter must be Q1–Q4.
Transaction Quantity Is Non-Negative(quantity)
Reported transaction quantity cannot be negative.
Transaction Price Is Non-Negative(price)
Reported price should not be negative for standard products.
Transaction End Not Before Begin
The transaction end date/time cannot precede its begin date/time.
No Duplicate Transactions(transaction_unique_id)
Each transaction unique id must be reported once within a filing.