MIS LOG IN

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

Dec 2, 2020 - xlsx - 48.3 KB
Apr 26, 2016 - docx - 72.8 KB
ERCOT Nodal ICCP Communications Handbook v3.11
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.
Aug 2, 2021 - docx - 3.3 MB
Oct 21, 2010 - pdf - 62.6 KB
May 28, 2020 - docx - 67.8 KB
Oct 4, 2010 - doc - 155.5 KB
Aug 5, 2013 - doc - 127 KB
Resource ID (RID) and Recorder Extract User Guide
Technical guide describing the environment and strategies for data loading the scheduled RID and recorder extracts.
Mar 28, 2017 - docx - 128.1 KB
Oct 21, 2010 - doc - 137 KB
Mar 30, 2012 - xls - 386 KB
Oct 10, 2018 - doc - 425 KB

Retail

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.
Jan 18, 2022 - xlsx - 20.3 KB
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.
Jul 26, 2017 - docx - 90.4 KB
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.
Sep 20, 2010 - zip - 40.7 KB
May 28, 2020 - docx - 67.8 KB
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.
Jan 31, 2017 - xls - 103 KB
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.
Jan 18, 2022 - xlsx - 16.9 KB
Dec 22, 2009 - doc - 139 KB
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.
Feb 10, 2011 - doc - 73.5 KB
Market Data Transparency User Guide
Market Data Transparency User Guide
Jan 7, 2013 - doc - 981 KB
Jan 16, 2017 - zip - 45.1 MB
Potential Load Loss Extract User Guide
Guide to daily extract of potential customer loss notifications, based on ERCOT's receipt of TDSPs' 'accepted' responses.
Oct 25, 2011 - doc - 93 KB
Aug 2, 2013 - doc - 127 KB
Siebel Service Order Extract User Guide
Provides customer registration information on ESI ID Service Orders within the Siebel Registration System.
Jun 7, 2012 - doc - 144 KB
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.
Oct 27, 2011 - doc - 118.5 KB
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.
Oct 27, 2011 - doc - 125.5 KB
Oct 17, 2013 - doc - 139.5 KB

Zonal

Backcasted and Forecasted Load Profiles Extract User Guide
Guide to layout of the file information.
Jan 26, 2009 - xls - 60.5 KB
Aug 1, 2008 - pdf - 62.6 KB

Public Data

Nov 12, 2020 - docx - 1.4 MB
Apr 6, 2009 - doc - 1.1 MB
Dec 21, 2011 - doc - 1.3 MB