sp_eqrlag
SP_EQRLAG - Electric Quarterly Reports Lag

Current Status

Report Name

Change Summary

Effective Date

Description

Template

Sample

sp_eqrlag

Modified. Effective with the October 2011 EQRLAG initial settlement report to be generated and distributed with the December 2011 Monthly Services Invoice and any reports regenerated from a previous timeframe, the following change in Source Settlement applies:

  • From "OATT Schedule 2: Black Start" to read "OATT Schedule 16: Black Start Credit"
11.21.2011 PDF Not available CSV and CSV
Access FERC Electric Quarterly Reporting Information
Access FERC EQR Initial and Resettlement Timeline

View Archived Status at the foot of this page

 

SP_EQRLAG – Electric Quarterly Reports Lag – Rev 0

Availability: After the issuance of the Monthly Services Invoice (the Invoice issued on or about the first Monday after the tenth calendar day of a month) for any items that were included in the Monthly Services Invoice for any settlements that are billed one month in arrears; and any time a resettlement is issued.

REPORT COLUMN

DESCRIPTION

Transaction Unique Identifier

The first record of each Customer file will start with T######## and increment upward by one (new number per record). Begins with T01000000

Seller Company Name

Customer name on file at ISO-NE

Customer Company Name

‘ISO New England’

Customer Duns Number

7881421213

Tariff Reference

‘FERC TARIFF REFERENCE’

Contract Service Agreement ID

‘ISO-NE MPSA’

Trans ID

The format is NE########. Numbers increment upward by one (new number per record). The numbers following 'NE' will match the numbers following 'T' in the transaction_unique_identifier column.

Transaction Begin Date

Begin timestamp for the time interval that the record applies to (Hour, Day, or Month). Format is YYYYMMDDHHMM

Transaction End Date

End timestamp for the time interval that the record applies to (Hour, Day, or Month). Format is YYYYMMDDHHMM

Time Zone

'ES' (Eastern Standard) and 'ED' (Eastern Daylight)

    • 25 hour day - Hour Ending 2 repeated (First Hour Ending 2 record will have time_zone = 'ED', the second Hour Ending 2 record will have time_zone = 'ES').
    • 23 hour day - Hour Ending 3 will not exist.

Point Of Delivery Control Area

‘ISNE’

Specific Location

For settlements that are generic to ISO-NE, use '32', which represents the New England control area.
For settlements that are specific to a generator, use generator's location ID.
For settlements that are specific to a load zone, use the load zone' location

Class Name

 

Term Name

‘ST’ because all settlements are less than one year

Increment Name

Appropriate value for the record M = Monthly, D = Daily, H = Hourly

Increment Peaking Name

Hourly settlements - 'P' or 'OP' based on ISO-NE's definition of Peak/Off-Peak
Daily and Monthly - 'N/A' for uplifts and 'FP' for Full Period Voltage and for Black Start

Product Name*

Populated in accordance with ISO-NE Settlements to FERC EQR Product mapping

Transaction Quantity*

FLAT RATE settlements will always be 1. All other settlements will be the appropriate quantity value (see ISO-NE Settlement to FERC EQR Product Mapping).

Transaction Price*

FLAT RATE settlements will always be equal to the Transaction Charge column.
Rest will be the appropriate Price (see ISO-NE Settlements to FERC EQR Product Mapping).

Units

FLAT RATE settlements will always be 'FLAT RATE'
All others will be the appropriate Unit (see ISO-NE Settlements to FERC EQR Product Mapping).

Total Transmission Charge

0 - No transmission charges will be reported by ISO-NE.

Transaction Charge

FLAT RATE settlements will always be equal to the Price column.
All other settlements, Transaction Charge = Transaction Quantity * Price
Carry out to number 2 places beyond decimal point.

Source Settlement*

Contains the name of the ISO-NE settlement associated with the given record

MIS Report*

Contains the MIS report(s) which contains the settlement.

Reporting Trigger*

Contains the reporting trigger that was tripped to create the given record.

* Please see the “FERC Electric Quarterly Reporting” webpage for additional information.

Archived Status

Report Name

Change Summary

Effective Date

sp_eqrlag

Existing. Added additional language to the "Note:" section.

10.01.2006

  Copyright ©2012 ISO New England Inc.