Subject: | |
From: | |
Date: | Fri, 22 Oct 2010 13:54:17 -0500 |
Content-Type: | multipart/alternative |
Parts/Attachments: |
|
|
*******TEXAS NODAL MARKET NOTICE*******
NOTICE DATE: October 22, 2010
NOTICE TYPE: Extracts
SHORT DESCRIPTION: SECOND NOTICE - November 1, 2010, effective date of changes to ESI ID Service History & Usage Extract, Public Reference Data Extract and Market Data Transparency ESI ID 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:
* ESI ID Service History & Usage Extract
* Public Reference Data Extract
* Market Data Transparency ESI ID 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.
ESI ID Service History & Usage Extract
* DDL: ESI ID Extract DDL v2 - can be found at http://www.ercot.com/services/mdt/ddls and Report Explorer/Public/Extract Data Definitions
* Market Aid Documentation:
* User Guide: ESI ID Service History & Usage User Guide can be found at http://www.ercot.com/services/mdt/userguides/index
* ESI ID Join Diagram: ESI ID 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: PRDE Extract v2.0 - can be found at http://www.ercot.com/services/mdt/ddls and Report Explorer/Public/Extract Data Definitions
* Removed the QUEUE_STATUS column from the CRRSELPOINT and RUCPROCESSHISTORY tables
* 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:
* ESI ID 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 ESI ID 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 ESI ID 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 ESI ID 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
|
|
|