(Add definitions to Section 2)

  1. Extract – Provides supplemental data to allow Market Participants a view into ERCOT’s operational and commercial systems. The data is provided in raw form to facilitate loading of data into a database.
  1. Report – Provides supplemental information to allow Market Participants a view into ERCOT’s operational and commercial systems. The information is provided in a formatted presentation which facilitates stand-alone reading.
  1. Private – Reports and Extracts that provide information defined as Protected Information by the ERCOT protocols. This information is provided only to the entities who own the information.
  1. Public – Reports and Extracts that provide information Not Considered Protected Information by the ERCOT Protocols. This information is provided to the market at-large.

11EXTRACTS AND REPORTS

ERCOT provides reports and extracts to assist Market Participants in understanding data relating to Energy and Ancillary Services, Market Prices, Retail and Wholesale activity, Load Profiling, Metering, Data Aggregation, Settlements, and the Market in general. In order to better relay what information is available and to whom it might be useful, a summary document of extracts and reports was created. Maintained by the Data Extracts Working Group, the Extract and Report Matrix is available for viewing on ERCOT.com:

The data available in the matrix is listed in the summary table of columns seen below:

Column Name / Description/Definition
Extract/Report Name / Formal name for extract/report and any common aliases
Extract/Report Definition / Description of the common uses for extract/report and/or a summary of information provided
Extract/Report Functional Process Origins / Indicates the functional group to which the extract or report belongs
Public or Market Participant Specific / Indicates whether the extract/report is available via a public or secured access
DDL Information / For extracts, indicates the location of the DDL on ERCOT media
Extract/Report Location / Indicates where the extract/report can be accessed generally
Delivery Point / Indicates where the extract/report can be accessed specifically (includes website location, file path, etc.)
Posting Name Format / Indicates the way the report output will be labeled as it is posted
How often posted (include holiday rules) / Posting frequency
Obligation - Formal and Informal
(Protocol Requirement, Market Expectation) / Indicates specific expectations or requirements for posting the extract/report if applicable
System Information / Indicates the originating data source and the extraction system
Record Addtimes / For each extract/report delivered, what is the timeframe captured.
ERCOT/MP Initiated? / Indicates whether the extract/report is available based on a standing request or if it must be requested by the MP as needed
ERCOT Contacts / ERCOT departments available to provide additional information concerning the extract/report
Does extract overlap with any other report/extract? / Provides names of extracts/reports related to current extract/report
Is this used by the market? / Is this extract/report current and useful to Market Participants. (yes/no field)
Pending/Related PRRs/SCRs?
Cross Reference Information / Indicates any outstanding requests for changes/improvements formally submitted at ERCOT
Additional Information Available / Training or documents which would support a better understanding
Comments / Any additional instructions regarding the report/extract

11.1Delivery Point

Each report or extract is delivered by one or more methods:

(1)Texas Market Link (TML) –When information being provided is private and protected, reports and extracts areare generally delivered via the Texas Market Link. The Texas Market Link (TML) is available to registered Market Participants, ERCOT and the PUCT. A Digital Certificateion is required for each user of the TML, and . Digital Certificates are is used to secure private information for MPs and to identify users to ERCOT. Digital certificates may be obtained from the User Security Administrator (USA) for each MP.

(2)ERCOT.com (Public Website) – ERCOT.com is the standard delivery method for Publicpublic information, reports and extracts. Most public reports and extracts are also available through Texas Market Link. Most public reports are not available through Texas Market Link...

(3)FTP – A Market Participant FTP site may be established to receive large reports. This point of delivery is used only for the Market Participant Transaction Report , the 867_03 Error Report, and the 997 Report. Contact your Retail Client Services representative to receive information via this delivery method.

(4)Email – Email is not a standard delivery method and is typically only used for ad hoc report/extract requests.

11.2 Type of Delivery Method

The data extracts provided by ERCOT are composed of two elements.

(1)The first is a Data Definition Language (DDL)or Data Definition Language file and contains the Structured Query Language (SQL) scripts necessary to build a database designed to hold the extracted data.

(2)The second element of a data extract comprises the data itself. The data is provided in a Comma Separated Value (CSV) fFormat. A CSV file or set of CSV files is zipped to reduce the overall size of the delivered object and posted to the appropriate delivery location. Once retrieved, the files can be extracted from the zip file and loaded into the Market Participant’s database. There are two types of data provided in this format:

  1. Initial – An initial extract contains referencial data that is relatively static. In other words, this data is required for the Participant’s database to function properly, but the data does not change on a daily basis. As the name implies, the initial data must be used to initialize a new database before any other data can be loaded.
  2. Daily – A daily extract contains mostly transactional data that does change on a daily basis. Whenever new referencial data is added to ERCOT’s systems, such as new Billing Determinants or new Congestion Management Zones, these records are also pushed to Market Participants through the daily extract.

Once the files are created, the files are zipped to reduce the overall size of the delivered object and posted to the agreed-upon delivery location. Once retrieved, the files can be extracted from the zip file and loaded by the Market Participant.

When extracts are delivered for the first time, there is usually an initial file containing multiple days of data to bring each participant up to a specific point in time after which they will begin receiving daily extract files.