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