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