1 / 7

Real-Time Market Settlement Data Extraction Overview

Understand the process of extracting real-time market settlement data, including posting schedules, extract specifics, and necessary extracts. Learn how to utilize the data for efficient shadow settlements.

eratliff
Download Presentation

Real-Time Market Settlement Data Extraction Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nodal COMS RTM Extract Data Review SDAWG & DEWG Jackie Ashbaugh ERCOT 04/21/2008 ***NOTE: All information contained in this presentation is as of 04/17/2008 and is subject to change at anytime.

  2. Real Time Market Settlement Batch Timeline - DRAFT 04/21/2008

  3. RTM Extract Posting Schedule - DRAFT 04/21/2008

  4. RTM Consolidated Operating Day Extract • Certified Extract • Must be scheduled by market participants • CRRAHs, QSEs, PGCs & LSEs • Retrieve through MIS via Data Aggregation landing page, Settlements & Billing landing page or API • Published as a result of an APPROVED settlement statement for an operating day • Settlement APPROVED Operating Day specific data • Contains market participant level data • RTM settlement inputs and outputs in interval, scalar and telemeteresstatus data • One operating day in extract file • Posted in conjunction with RTM Market Operating Day Extract • To shadow settle RTM use in conjunction with the following extracts: • Public Reference Data Extract for dimensional descriptive data • RTM Market Operating Day Extract • DAM Consolidated Operating Day Extract for given Operating Day • DAM Market Operating Day Extract for given Operating Day 04/21/2008

  5. RTM Market Operating Day Extract • Secure Extract • CRRAHs, QSEs, LSEs & PGCs • Retrieve through MIS via Data Aggregation landing page, Settlements & Billing landing page or API • Published as a result of an APPROVED settlement statement for an operating day • Settlement APPROVED Operating Day specific data • Contains market level data • RTM settlement inputs and outputs in interval and scalar data • One operating day in extract file • Posted in conjunction with RTM Consolidated Operating Day Extract • To shadow settle RTM use in conjunction with the following extracts: • Public Reference Data Extract for dimensional descriptive data • RTM Consolidated Operating Day Extract • DAM Consolidated Operating Day Extract for given Operating Day • DAM Market Operating Day Extract for given Operating Day 04/21/2008

  6. RTM CODE & MODE Data • DRAFT Settlement DDL and XSD found at: http://nodal.ercot.com/readiness/reports/index.html • What Market? • Defined by extract posting name - RTM • Operating Day • Found in extract posting name • Found in interval/scalar tables as STARTTIME • BILLDETERMINANT table defines where billdeterminants can be found in the interval or scalar tables using the ‘billdeterminanttype’ field • LSTIME represents the ADDTIME of the data record • UIDSTATEMENTSCHED is a field on all interval/scalar records except MKTINPUT tables that can be used to associate data records to the same settlement approval • Header records: • Associated to either an interval record OR scalar record, not both • Have a one to many relationship with interval/scalar records • Delivered with interval/scalar record. This means that the header record may be sent multiple times. • Join to interval/scalar records using the UIDXXXXHEADER field • Contain all descriptive information about the interval/scalar records • Defines Market Participant ‘owner’ for certified records • Approved DAM data used in the RTM settlement will not be resent in RTM CODE and MODE extracts, therefore, DAM CODE and MODE extracts for the given operating day must be used for RTM shadow settlements 04/21/2008

  7. Questions? 04/21/2008

More Related