NOTICE DATE:  October 3, 2008

NOTICE TYPE:  M-A100308-01   Extracts Wholesale/Retail

CLASSIFICATION: Public

SHORT DESCRIPTION:  ASBIDSTACKS DDL Update

INTENDED AUDIENCE:  ERCOT Market Participants

DAY AFFECTED:  October 9, 2008

LONG DESCRIPTION:  ERCOT is updating the DDL for the ASBIDSTACKS extract to correct column names and to further explain the columns in the extract.  The updated DDL will be added to the website as ASBID_STACKS_v03.sql on October 9, 2008. 

An important note, there are no changes being made to the ASBIDSTACK extract file, this is a correction to the DDL which is an optional file used by Market Participants to understand the contents and structure of the existing posting.

The ASIDSTACK posting is located at https://pi.ercot.com/contentproxy/publicList?folder_id=10001685 and can also be accessed from the Public portion of the Report Explorer for your company on the Texas Market Link (TML).

 

The changes to the DDL are as follows:

 

·        For Table REGUPPRICE, Column RESPONSIVEPRICE is changing to REGUPPRICE

·        For Table REGDWPRICE, Column REGUPPRICE is changing to REGDWPRICE

·        For Table RESPRESERVPRICE, Column REGDNPRICE is changing to RESPRESERVPRICE

 

ERCOT has also updated the comments to reflect this new name change as well as add a comment for column ASBIDMW for each of the tables in this DDL.   The new DDL is attached for your reference.

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 e-mail at [log in to unmask].

If you are receiving e-mail 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.

kd