TDSP ESI ID Extract
TDSP ESI ID Extract
User Guide
Updated 3/19/2007
About ERCOT Data Extracts
About TDSP ESI ID Extracts
TDSP ESI ID FULL Extract
TDSP ESI ID NEW Extract
Format of the TDSP ESI ID Extract
About ERCOT Data Extracts
ERCOT data extracts provide a framework that allows Market Participants to retrieve ERCOT market data for analysis. This framework is comprised of two elements: DDL and Data Extract distributions.
Data Definition Language (DDL)
ERCOT provides the structures for Market Participants to load ERCOT data into their own environment in the form of data definition language (DDL). This DDL provides the metadata data for the data type of each field, the table primary and foreign key constraints, and a brief description of the data that is to be loaded into each column.
Data Extract Distributions
ERCOT utilizes a standard comma-separated value file format (CSV) for extract data delivery to ensure portability across most platforms and architectures. These CSV files are distributed to the market through the Texas Market Link (TML) website packaged in zip files.
While data extracts are not intended to provide a single solution to resolve allMarket Participant needs, they are meant to provide Market Participants with the data sets used by ERCOT to manage and settle the energy market.
About TDSP ESI IDExtracts
The TDSP ESI IDExtract is a publicextract that provides characteristic information on ESI IDs registered by each TDSP area. This Extract provides Market Participants with the ability to verify ESI IDs by TDSP area for a Service Delivery Point (SDP) using the Service Address.
Recipients of this extract include Market Participants with access to Texas Market Link (TML) or anyone with access to On TML, the TDSP ESI ID Extract can be found under the Extract Explorer link in the “Public” folder.
On the TDSP ESI ID Extract can be found in the Market Information>Retail section.
The TDSP ESI ID Extract has 2 formats:
- Full – Available once per calendar month containing all ESI IDs by TDSP territory and limited characteristic data.
- New – Incremental file produced weekly containing ESI ID changes for the prior week by TDSP.
TDSP ESI ID FULLExtract
The TDSP ESI ID Full Extract is available once every month posted on the first Tuesday following the first Monday.Since this extract is available to the public, there are no requirements to opt-in via the TML Extract Scheduler. The data included in the Full Extractwill be for all of time up through 23:59:59 on the Saturday prior to posting. The Full Extract is comprehensive, so only the most recent Full Extract will be posted at any given time.
Once completed, the FullExtract is posted on TML and using the ZIP file naming convention:
20070312.215405.TDSP_NAME___FUL.zip
The first 8 digits refer to the posting date and the second six digits are an internal numerical identifier. The “TDSP_NAME____” is replaced by the TDSP the Extract includes data for. The underscores located at the end of the name serve to maintain a 13 character length requirement.
When saved locally to the Market Participant’s computer, the ZIP file naming convention is:
rptPublicTDSPEsiidExtracts20070312215405TDSP_NAME___FUL.zip
Once unzipped, the CSV file naming convention is:
TDSP_NAME___FUL-EXTRACTS-12-MAR-07.csv
TDSP ESI ID NEW Extract
The TDSP ESI ID New Extract is available once every weekby 10am on Tuesday. Each New Extract contains incremental weekly changes that have occurred in each TDSP area since the last full Extract was posted. The incremental changes included are for Sunday 00:00:00 up through the prior Saturday 23:59:59.
Once completed the New Extract is posted in the same location on TML and as the Full Extract. The ZIP file naming convention is:
20070312.215405.TDSP_NAME___NEW.zip
When saved locally to the Market Participant’s computer, the ZIP file naming convention is:
rptPublicTDSPEsiidExtracts20070312215405TDSP_NAME___NEW.zip
Once unzipped, the CSV file naming convention is:
TDSP_NAME___NEW-EXTRACTS-12-MAR-07.csv
TDSP ESI ID Extract
Type / Run Time/Post Time / Content / RestrictionsFull / Runs Monday 7PM and posts on the first Tuesday following the first Monday of the month by 10AM / Beginning of time to 23:59:59 on prior Saturday / Once per month
New / Runs Monday 7PM and posts by Tuesday 10AM / ESI ID changes from two Sunday’s prior at 00:00:00 through Saturday 23:59:59 / Once per week when Full Extracts are not provided
Format of the TDSP ESI ID Extract
Below is a brief description of the columns in the TDSP ESI ID Extract.The grey boxed characteristics will be null values in the extract until the implementation of project PR_40038TX SET 3.0.
Column / Name / DescriptionA / ESI ID / The Electric Service Industry Identifier (ESI ID) as assigned by the TDSP
B / ADDRESS / Registered Street Address
C / ADDRESS_OVERFLOW / Address Overflow information - if necessary
D / CITY / Registered City
E / STATE / Registered State
F / ZIPCODE / Registered Zip Code
G / DUNS / The Duns number assigned to the Market Participant
H / METER_READ_CYCLE / Structure Type ex: 03
I / STATUS / Status of the organization account ex: Active
J / PREMISE_TYPE / Denotes the type of premise as either Residential, Small Non-Residential, or Large Non-Residential
K / POWER_REGION / The unique character code identifying the power region the ESI ID is electrically connected in as assigned by the TDSP (ERCOT, SPP, SERC, WSCC)
L / STATIONCODE / The unique character code to identify a substation serving an ESI ID as assigned by the TDSP and used in the ERCOT Network Model
M / STATIONNAME / The long name to identify a substation used in the ERCOT Network Model
N / METERED / The derivation of the PROFILETYPE of the PROFILECODE. If the PROFILETYPE is = NM, the data would show N for not metered. If the PROFILETYPE is > NM, the data would show Y for metered
O / OPEN_SERVICE_ORDERS / Concatenation of all pending service orders by pipe ( | ) that includes the service order type and scheduled date
P / POLR_CUSTOMER_CLASS / Calculated POLR Customer class assignment by ERCOT
- 1 -