Month: January 2020

Changes to EQR Validations

Changes to EQR Validations

The Federal Energy Regulatory Commission (FERC) has updated their Electric Quarterly Reporting (EQR) software to Release 3.6, which has affected a few validations.

FERC EQR Release 3.6

  • 12/2/2019 – FERC posted updated EQR Release Notes identifying changes made in Release 3.6.
  • 12/31/2019 – FERC posted updated validation rules documentation (PDF, Excel).

Summary of Changes

  • A few existing validation warnings no longer apply for reporting periods of Q4 2019 and later
    • F.25.19 – Trade Date (Field 53) should not be empty or null if the transaction was entered into on or after 7/1/2013.
    • F.25.20 – Standardized Price (Field 68) should not be empty or null for Energy, Booked Out Power, or Capacity products if the transaction was entered into on or after 7/1/2013.
    • F.25.21 – Type of Rate (Field 55) should not be empty or null if the transaction was entered into on or after 7/1/2013.
    • F.25.24 – Standardized Quantity (Field 67) should not be empty or null for Energy, Booked Out power, or Capacity products if the transaction was entered into on, or after 7/1/2013.
  • A few new validation errors were added that apply for reporting periods Q4 2019 and later
    • F.30.42 – Trade Date (Data Dictionary Field No. 53) is required WHEN Contract Execution Date (Data Dictionary Field No. 21) is on or after 7/1/2013. Please review transactions with Transaction Unique IDs […list…]
    • F.30.43 – Transaction Type of Rate (Data Dictionary Field 55) is required when Contract Execution Date (Data Dictionary Field 21) is on or after 7/1/2013. Please review transactions with Transaction Unique IDs […list…]
    • F.30.44 – For product names ENERGY, CAPACITY, and BOOKED OUT POWER only. Standardized Price (Data Dictionary Field No. 68) is required when Contract Execution Date (Data Dictionary Field 21) is on or after 7/1/2013. Please review transactions with Transaction Unique IDs […list…]
    • F.30.45 – For product names ENERGY, CAPACITY, and BOOKED OUT POWER only. Standardized Quantity (Data Dictionary Field No. 67) is required when Contract Execution Date (Data Dictionary Field 21) is on or after 7/1/2013. Please review transactions with Transaction Unique IDs […list…]
    • F.30.48 – Transaction Point of Delivery Specific Location (PODSL) (Data Dictionary Field No. 58) is required. Please review transactions with Transaction Unique IDs […list…]
Figure 1: Changes highlighted in FERC Validations document

Next Steps for PowerShark EQR

We are working on a software update that will accommodate these changes to EQR validations as well as other enhancements to make PowerShark EQR faster and easier to use. Stay tuned for more info.

Do you have questions or need help with PowerShark EQR, contact Support.

If you haven’t seen PowerShark EQR in action or it’s been a while since you last saw a demo, then maybe it’s time you took another look at our product and see what many are saying is the most complete and affordable EQR solution available!  Please contact Bob VanValkenburg at sales@powersharkeqr.com or call 847-252-7286 to schedule a demo or free trial of PowerShark EQR today!