NOTICE DATE:  January 20, 2011
NOTICE TYPE:  M-B010511-02 Extracts
SHORT DESCRIPTION:  New date for table addition to PRDE
INTENDED AUDIENCE:  ERCOT Market Participants
DAY AFFECTED:  January 21, 2011
LONG DESCRIPTION:  ERCOT will add the MARKET table to the Public Reference Data Extract (PRDE) beginning on January 21, 2011. The release was delayed, which prevented the addition of the table as originally planned for the January 20, 2011, PRDE posting.
This new table is needed in order to decode the UIDMARKET field in the Settlement Extracts. Currently, there are four market types that are defined in the ERCOT Settlement System:  Real Time Market (RTM), Day-Ahead Market (DAM), Congestion Revenue Rights (CRR) and Miscellaneous (MISC). Each market type has an assigned UIDMARKET identifier as shown below:
UIDMARKET

MARKETCODE

MARKETNAME

1

RTM

REAL TIME MARKET

2

DAM

DAY-AHEAD MARKET

3

CRR

CONGESTION REVENUE RIGHTS

4

MISC

MISCELLANEOUS


With the addition of the MARKET table to the Public Reference Data Extract, users will be able to join the UIDMARKET field in the Settlement Extracts to the MARKET table in order to resolve the appropriate market name.
ADDITIONAL INFORMATION:  The updated DDL and XSD for the Public Reference Data Extract are attached for reference.  These updated versions will also be posted in the Market Data Transparency<http://www.ercot.com/services/mdt> area of ERCOT.com.
The Public Reference Data Extract User Guide<http://www.ercot.com/services/mdt/userguides/index> and the Settlements Join Diagram<http://www.ercot.com/services/mdt/userguides/index> have also been updated and reposted on ERCOT.com.
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.



dh