NOTICE DATE:  December 15, 2011

NOTICE TYPE:  R-A121411-02 UPDATE:  ESIID Service History and Usage Extract Supplemental posting

SHORT DESCRIPTION:  ERCOT is reposting the supplemental ESIIDUSAGE file.

INTENDED AUDIENCE:  LSEs, MREs, and TDSPs

DAYS AFFECTED:  November 8 and December 14-15, 2011

LONG DESCRIPTION:  As indicated in market notice R-A121411-01, the ESIID Service History and Usage Extract posted on November 8, 2011 did not include the non-IDR ESIIDUSAGE data file. ERCOT posted a supplemental extract which included the ESIIDUSAGE file based on the current state of the usage data in ERCOT systems.

UPDATE:  The Supplemental ESIIDUSAGE file that was posted to the Market Information System (MIS) on Wednesday, December 14, 2011 contained date file formats that were not consistent with the format for which the ESIID Service History & Usage Files are generated. Due to the loading issues that the unexpected file formats can present, ERCOT is regenerating and reposting the Supplemental ESIIDUSAGE file.  ERCOT will provide notification once the updated Supplemental file is posted to the MIS.

As indicated in the initial market notice, the ESIID Service History and Usage Extract Supplemental will be posted in a zip format with the following naming convention:

ext.reportid.dunsnumber.yyyymmdd.hh24:mi:ss.ESIID_EXTRACT_Supplemental.zip

The zip file will contain a .csv file for the ESIIDUSAGE with the following naming convention:

DUNSNUMBER-ESIIDUSAGE-DD-MON-YY_Supplemental.csv 

This supplemental posting will only contain the ESIIDUSAGE file. The DDL of the ESIIDUSAGE file is the same as the daily files that are posted.

ADDITIONAL INFORMATION: Market Participants should first process their daily ESIID Service History and Usage Extract posted on December 14, 2011. The supplemental ESIIDUSAGE file provided on December 15, 2011 should then be processed to bring Market Participants systems to the current state of the ESIIDUSAGE data at ERCOT. The December 14, 2011 file should be disregarded.

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].

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.

JR/DH

 

From: ERCOT Client Services
Sent: Wednesday, December 14, 2011 1:53 PM
To: [log in to unmask]; [log in to unmask]
Cc: [log in to unmask]; [log in to unmask]; [log in to unmask]; 1 ERCOT Client Service Reps
Subject: R-A121411-01 ESIID Service History and Usage Extract Supplemental posting

 

NOTICE DATE:  December 14, 2011

NOTICE TYPE:  R-A121411-01 ESIID Service History and Usage Extract Supplemental posting

SHORT DESCRIPTION:  The ESIID Service History and Usage Extract posted on 11/08/2011 did not include the non-IDR ESIIDUSAGE data file. ERCOT is posting a supplemental extract today that includes the ESIIDUSAGE file based on the current state of the usage data in ERCOT systems.

INTENDED AUDIENCE:  LSEs, MREs, and TDSPs

DAYS AFFECTED:  November 8, 2011

LONG DESCRIPTION:  The ESIID Service History and Usage Extract posted on 11/08/2011 did not include the non-IDR ESIIDUSAGE data file. ERCOT is posting a supplemental extract today that includes the ESIIDUSAGE file based on the current state of the usage data in ERCOT systems.

The ESIID Service History and Usage Extract Supplemental will be posted in a zip format with the following naming convention:

ext. reportid.dunsnumber.yyyymmdd.hh24:mi:ss.ESIID_EXTRACT_Supplemental.zip

 

The zip file will contain a .csv file for the ESIIDUSAGE with the following naming convention:

DUNSNUMBER-ESIIDUSAGE-DD-MON-YY_Supplemental.csv 

This supplemental posting will only contain the ESIIDUSAGE file. The DDL of the ESIIDUSAGE file is the same as the daily files that are posted.

PROCESSING INFORMATION: Market Participants should first process their daily ESIID Service History and Usage Extract posted on 12/14/2011. The supplemental ESIIDUSAGE file should then be processed to bring Market Participants systems to the current state of the ESIIDUSAGE data at ERCOT. No additional file processing is necessary.

ISSUE RESOLUTION: The cause of the ESIIDUSAGE file not being included in the 11/08/2011 ESIID Service History and Usage Extract posting was due to an off cycle release interfering with the extract while it was generating. ERCOT has completed the impact analysis for the extract with the only impact being the missing ESIIDUSAGE file. ERCOT has updated the off cycle release process to include additional checks prior to migration taking place.

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].

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.

DP/DG

 

 

 




To unsubscribe from the NOTICE_EXTRACTS_WHOLESALE list, click the following link:
http://lists.ercot.com/SCRIPTS/WA-ERCOT.EXE?SUBED1=NOTICE_EXTRACTS_WHOLESALE&A=1