User Guides

Topics

• Market Prices
• Retail
• Load Profiling
• Data Aggregation
• Settlements
• Public Data

Market Prices

• Market Shadow Price Extract User Guide
  Guide to shadow prices for commercially significant constraints (CSCs) for every 15-minute interval of an operating day
  (01/26/09, .doc, 634.5 KB)

Retail

• 867_03 Error Codes Table
  Codes and their descriptions for both successful and failed loading attempts of 867_03 transactions into the ERCOT database
  (11/18/09, .xls, 42.5 KB)
• 867_03 Error Report Layout
  Layout of report detailing successful and failed responses to ERCOT's attempts to load 867_03s into database
  (01/26/09, .xls, 30.5 KB)
• 997 Functional Acknowledgement Report Extract User Guide
  Guide to report detailing 997 'accept or reject' acknowledgements not received for EDI files sent
  (04/27/09, .doc, 119.5 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
  (11/17/09, .doc, 70.5 KB)
• ESIID Join Diagram v01
  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
  (11/17/09, .ppt, 329.5 KB)
• Extract and Report Information Guide
  Guide to provide a description of available extracts, SLA, and delivery times
  (02/16/10, .xls, 75.5 KB)
• Interval Data LSE Activity Report
  Layout of report detailing successful and failed responses to ERCOT's attempts to load AMS LSE files into the ERCOT database
  (12/22/09, .xls, 96.5 KB)
• Interval Data LSE Error Codes Table
  Codes and their descriptions for both successful and failed loading attempts of AMS LSE files into the ERCOT database.
  (12/22/09, .xls, 31 KB)
• Interval Data LSE File Specification v1.2
  (12/22/09, .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
  (11/17/09, .doc, 32.1 KB)
• Market Data Transparency User Guide
  Guide to Web Services for ad-hoc ESI ID data research and ESIID Service History and Usage audit capabilities
  (11/17/09, .doc, 1.4 MB)
• MarkeTrak User Guide
  Guide to the details of how to interact with the MarkeTrak toolset as well as associated business practices. 8-18-08
  (11/20/09, .zip, 42 MB)
• Move In/Move Out (MIMO) Exception User Guide
  Guide to extract identifying TDSP transaction exceptions that may indicate an out-of-sync condition between ERCOT and the TDSP
  (04/27/09, .doc, 154.5 KB)
• Potential Load Loss Extract User Guide
  Guide to daily extract of potential customer loss notifications, based on ERCOT's receipt of TDSPs' 'accepted' responses
  (04/27/09, .doc, 102.5 KB)
• Resource ID and Recorder Extract User Guide
  Resource ID and Recorder Extract User Guide
  (04/27/09, .doc, 207.5 KB)
• Siebel Service Order Extract User Guide
  Provides customer registration information on ESI ID Service Orders within the Siebel Registration System
  (04/27/09, .doc, 145.5 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
  (12/16/09, .doc, 122.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
  (12/16/09, .doc, 129.5 KB)
• TDSP ESI ID Extract User Guide
  Guide to report providing characteristic information on ESI IDs registered by each TDSP area
  (04/27/09, .doc, 138.5 KB)

Load Profiling

• Backcasted and Forecasted Load Profiles Extract User Guide
  Guide to layout of the file information
  (01/26/09, .xls, 60.5 KB)

Data Aggregation

• Generation Extract User Guide
  Guide to extract providing daily interval data, daily scalar data, premise information, entity names and entity relationship
  (01/26/09, .doc, 572.5 KB)
• Load Extract User Guide
  Guide to extract on aggregated load cuts in the ERCOT systems that are used for settlement purposes
  (01/26/09, .doc, 668.5 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
  (01/26/09, .doc, 433.5 KB)

Settlements

• ERO Fee Guide V1
  (06/25/09, .doc, 104 KB)
• Settlement Input Data (SID) Extract User Guide
  Guide to extract providing the QSE with the settlement billing determinants used for calculating the charge types that appear in the QSE's settlement statement
  (01/26/09, .doc, 687.5 KB)
• Settlements and Billing Extract User Guide
  Technical guide describing the environment and strategies for data loading the scheduled settlements and billing extract
  (01/08/10, .doc, 827.5 KB)

Public Data

• IE 6.0 Configuration Guide
  (04/06/09, .doc, 374 KB)
• IE 7.0 Configuration Guide
  (04/06/09, .doc, 1.1 MB)
• MOSPUBLIC Reports Screen Scraping/API Terms of Use
  (03/16/09, .doc, 209 KB)