- Home
- Services
- Market Data Transparency
- User Guides
User Guides
As a service to the market, ERCOT publishes helpful guides on how to use data extracts and applications. For descriptions of ERCOT extracts and reports, please refer to the ERCOT Market Information List (EMIL).
Wholesale
ERCOT Nodal ICCP Communications Handbook v3.22
This handbook sets practices, conventions, and fundamental parameters required for Market Participants to exchange data with ERCOT using ICCP protocol in the TX Nodal Market.
Market Submission Validation Rules
Information on validation submission rules, notification rules, software documentation, and pre-validation processes.
Resource ID (RID) and Recorder Extract User Guide
Technical guide describing the environment and strategies for data loading the scheduled RID and recorder extracts.
Retail
867_03 Activity Report Description
Layout of report detailing successful and failed responses to ERCOT's attempts to load 867_03s into database.
867 03 Error Codes Document v1.3
Codes and their descriptions for both successful and failed loading attempts of 867_03 transactions into the ERCOT database.
ESI ID Service History and Usage Extract User Guide
Business user and technical data loading guide to ESI ID data extract used for settlements and shadow-settlement systems.
ESIID Join Diagram v2.0
Diagram to show the table structure and all the joins for all the tables included in the ESIID Service History and Usage Extract, Supplemental AMS Interval Data Extract and Supplemental IDR Required Interval Data Extract.
Interval Data LSE Activity Report Description
Layout of report detailing successful and failed responses to ERCOT’s attempts to load AMS LSE files into the ERCOT database.
Interval Data LSE Error Codes Table v1.5
Codes and their descriptions for both successful and failed loading attempts of AMS LSE files into the ERCOT database.
Market Data Transparency Quick Reference Guide
A quick reference guide to Web Services available for ad-hoc ESI ID data research and ESIID Service History and Usage audit capabilities.
Market Data Transparency User Guide
Market Data Transparency User Guide
Potential Load Loss Extract User Guide
Guide to daily extract of potential customer loss notifications, based on ERCOT's receipt of TDSPs' 'accepted' responses.
Public Reference Data Extract User Guide
Data Extract User Guide
Siebel Service Order Extract User Guide
Provides customer registration information on ESI ID Service Orders within the Siebel Registration System.
Supplemental AMS Interval Data Extract User Guide
Guide to daily extract that provides Market Participants with fifteen minute interval data reads for ESIIDs that have Advanced Meters installed at the premise.
Supplemental IDR Required Interval Data Extract User Guide
Guide to daily extract that provides Market Participants with their IDR required interval data loaded at ERCOT systems.
Zonal
Backcasted and Forecasted Load Profiles Extract User Guide
Guide to layout of the file information.