******* 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