Subject: | |
From: | |
Date: | Fri, 1 Oct 2010 08:29:40 -0500 |
Content-Type: | multipart/alternative |
Parts/Attachments: |
|
|
******* 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:
* ESIID Service History & Usage Extract
* Public Reference Data Extract
* Market Data Transparency ESIID Web Services
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<https://pi.ercot.com/contentproxy/proxy?doc_id=92663092> - 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<https://pi.ercot.com/contentproxy/proxy?doc_id=92663107> - 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
* XSD: Market Data Transparency Technical User Files v4.0 - can be found at http://www.ercot.com/services/mdt/xsds/index
* Market Aid Documentation:
* 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]<mailto:[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<http://lists.ercot.com/>.
dh
|
|
|