NOTICE_EXTRACTS_WHOLESALE Archives

Notice_Extracts_Wholesale

NOTICE_EXTRACTS_WHOLESALE@LISTS.ERCOT.COM

Options: Use Forum View

Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Nodal Market Transition <[log in to unmask]>
Date:
Fri, 22 Oct 2010 13:54:17 -0500
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (4 kB) , text/html (38 kB)
*******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






ATOM RSS1 RSS2