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