******* A draft of this Market
Notice was inadvertently sent to a group of distribution lists on Wednesday,
September 29, 2010. If you received this Notice draft, please disregard. The
below Market Notice is the official version. *******
*******TEXAS NODAL MARKET
NOTICE*******
NOTICE DATE: October 1,
2010
NOTICE TYPE: Extracts
SHORT DESCRIPTION: FIRST
NOTICE – November 1, 2010, effective date of changes to ESIID Service
History & Usage Extract, Public Reference Data Extract and Market Data
Transparency ESIID Web Services
INTENDED AUDIENCE: ERCOT
Market Participants
DAY AFFECTED: November 1,
2010
LONG DESCRIPTION: Existing
extracts that are currently live will be updated on November 1, 2010, to
support ERCOT providing Nodal data going forward. The impacted extracts and web
services are as follows:
The information below provides the location of the technical
files (DDLs and XSDs), market aid documentation and a summary of the changes
for each.
ESIID Service History
& Usage Extract
·
DDL: ext.(09-24-2010
09:02:10 ).ESIID Extract DDL v1.0 – can be found at http://www.ercot.com/services/mdt/ddls/index
and Report Explorer/Public/Extract Data Definitions
·
Market Aid Documentation:
·
User Guide: ESIID Service History & Usage
User Guide can be found at http://www.ercot.com/services/mdt/userguides/index
·
ESIID Join Diagram: ESIID Join Diagram can be
found at http://www.ercot.com/services/mdt/userguides/index;
will provide a visual for how tables join together in this extract
·
Summary of Changes:
·
Added column on the STATIONSERVICEHIST
table for UIDSETLPOINT
·
Added two new tables SETLPOINTHISTORY and
SETLPOINTTYPE
Public Reference Data
Extract
·
DDL: ext.(09-24-2010
09:02:11 ).PRDE Extract DDL v 1.1 – can be found at http://www.ercot.com/services/mdt/ddls/index
and Report Explorer/Public/Extract Data Definitions
·
XSD: PRDE Extract XSD – can be found at http://www.ercot.com/services/mdt/xsds/
·
Market Aid Documentation:
·
User Guide: Public Reference Data Extract
User Guide (PRDE) can be found at http://www.ercot.com/services/mdt/userguides/index
·
Summary of Changes:
·
Added column on the existing STATIONSERVICEHIST
table for UIDSETLPOINT
·
Added new tables to support the following
extracts:
·
ESIID Service History & Usage
Extract – Daily
·
Market Data Transparency
·
Real Time Market Market Operating
Day Extract
·
Real Time Market Consolidated
Operating Day Extract
·
Day Ahead Market Market Operating
Day Extract
·
Day Ahead Market Consolidated
Operating Day Extract
·
Settlements Input Data Extract
·
Balancing Account Extract
·
CRR Auction
Revenue Distribution (CARD) Extract
·
Monthly RUC Make Whole Charge and
Clawback Payment Report
·
Capacity Factors by Resource
Report
·
Confidentiality Expired Adjusted
Meter Load Report
Market Data Transparency
ESIID Web Services
·
User Guide: Market Data Transparency User
Guide can be found at http://www.ercot.com/services/mdt/userguides/index
·
Summary of Changes:
·
Provide All ESIID records web service –
being updated to include the UIDSETLPOINT column to the STATIONSERVICEHIST
table
·
Retire Provide Public Data Records and Provide
CMZone Assignment web services
ADDITIONAL INFORMATION: On November 1, 2010, the ESIID Service
History & Usage Extract will include the Nodal data set (data records with
12/1/2010 STARTTIME) for STATIONSERVICEHIST, SETLPOINTHISTORY and SETLPOINTTYPE
in addition to regular daily data updates.
CONTACT: If you have any questions, please contact
your ERCOT Account Manager. You may also call the general ERCOT Client Services
phone number at (512) 248-3900 or contact ERCOT Client Services via email at [log in to unmask].
If you
are receiving email from an ERCOT distribution list that you no longer wish to
receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
dh