NOTICE DATE: September 22, 2010 NOTICE TYPE: R-A092210-02 UPDATED Column and Table Names - Informational: Extracts - Retail SHORT DESCRIPTION: ERCOT is currently performing data prep and Nodal cutover activities in preparation of Nodal go-live. The ESI ID Service History and Usage Extract posted Tuesday, September 21, 2010 included Nodal data records in the STATIONSERVICEHISTE table. INTENDED AUDIENCE: All Market Participants DAY AFFECTED: September 21, 2010 LONG DESCRIPTION: ERCOT is currently performing data prep and Nodal cutover activities in preparation of Nodal go-live. The ESI ID Service History and Usage Extract posted Tuesday, September 21, 2010 included Nodal data records in the STATIONSERVICEHIST table. The STATIONSERVICEHIST Nodal data records that were sent contain a STARTTIME of December 1, 2010 with null values in the CMZONECODE and SUBUFECODE columns. The current ESIID Extract DDL does not allow for the Nodal data records to load because the CMZONECODE and SUBUFECODE columns in the DDL do not allow for null values. These data records should have failed to load into the Market Participant ESI ID Service History & Usage Extract databases. ADDITIONAL INFORMATION: On Monday, November 1, 2010, a new DDL will be in effect for the ESI ID Service History & Usage Extract that will allow the data in the CMZONECODE and SUBUFECODE columns in the STATIONSERVICEHIST table to be null. As part of the production Nodal cutover activities, ERCOT will be resending the STATIONSERVICEHIST Nodal data records to allow for them to load into Market Participant ESI ID Service History & Usage Extract databases. Details regarding the changes to the ESI ID Service History & Usage Extract will be provided in the Friday, October 1, 2010 30-day market notice. 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. DP/DH From: ERCOT Client Relations Sent: Wednesday, September 22, 2010 3:39 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-A092210-01 Informational: Extracts - Retail NOTICE DATE: September 22, 2010 NOTICE TYPE: R-A092210-01 Informational: Extracts - Retail SHORT DESCRIPTION: ERCOT is currently performing data prep and Nodal cutover activities in preparation of Nodal go-live. The ESI ID Service History and Usage Extract posted Tuesday, September 21, 2010 included Nodal data records in the STATIONSERVICHIST table. INTENDED AUDIENCE: All Market Participants DAY AFFECTED: September 21, 2010 LONG DESCRIPTION: ERCOT is currently performing data prep and Nodal cutover activities in preparation of Nodal go-live. The ESI ID Service History and Usage Extract posted Tuesday, September 21, 2010 included Nodal data records in the STATIONSERVICHIST table. The STATIONSERVICEHIST Nodal data records that were sent contain a STARTTIME of December 1, 2010 with null values in the CMZONECODE and SUBUFEZONE columns. The current ESIID Extract DDL does not allow for the Nodal data records to load because the CMZONE column in the DDL does not allow for null values. These data records should have failed to load into market participant ESIID Service History & Usage Extract databases. ADDITIONAL INFORMATION: On Monday, November 1, 2010, a new DDL will be in effect for the ESIID Service History & Usage Extract that will allow the data in the CMZONECODE and SUBUFEZONE columns in the STATIONSERVICEHIST table to be null. As part of the production Nodal cutover activities, ERCOT will be resending the STATIONSERVICEHIST Nodal data records to allow for them to load into market participant ESIID Service History & Usage Extract databases. Details regarding the changes to the ESIID Service History & Usage Extract will be provided in the Friday, October 1, 2010 30-day market notice. 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. DP/DH