1 / 7

Nodal COMS Posting Updates Review

Nodal COMS Posting Updates Review. SEWG Jamie Lavas ERCOT. ***NOTE: All information contained in this presentation is as of 02/10/2009 and is subject to change at anytime. Information Hot Spots.

marshagalloway
Download Presentation

Nodal COMS Posting Updates Review

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 Posting Updates Review SEWG Jamie Lavas ERCOT 02/16/2009 ***NOTE: All information contained in this presentation is as of 02/10/2009 and is subject to change at anytime.

  2. Information Hot Spots • The Nodal Data Services Master List (NDSML) is updated Friday’s with the latest information. It is located at: http://nodal.ercot.com/about/news/2008/0118a.html • The site will be updated each Friday with the latest extract & report specifications and DDLs and XSDs. http://nodal.ercot.com/readiness/reports/index.html 09/22/2008

  3. Specification Updates The following updates have been made to the Specification Documents • CONSOLIDATED MDT – Specifications • Consolidated the COMS & EDW Specification into one workbook • Added Project Delivery Information to each tab to signify COMS or EDW project • Clean up of all administrative tabs • Addition of Bill Determinant & Expiration tab • Reports removed from scope: • TDSP Summarized Load Report • Day Ahead PTP Option Prices Report • Real Time PTP Option Prices Report • ESIID Extract – Supplemental • Data Agg Daily Postings All of these reports have been grayed out on the home tab and will not be visible going forward.

  4. NDSML Updates The following updates have been made to the Specification Documents • NDSML – EDW/COMS • Currently going through major overhaul • Verifying all protocol and posting requirements • Creating a list of posting requirements from protocols to determine any missed reports • Creating new columns for Landing Page, Portlet & Report ID • Upcoming change: Similar effort for all ‘notices’

  5. DDL & XSD Updates The following Changes have been made to DDLs / XSDs • DDL/XSD • To be posted this week: • Addition of table ASEXECUTION to PRDE • Re-synching all columns to database • Alphabetizing all tables in PRDE & Settlements DDL • To be posted next month: • All field names/comments to be populated

  6. What’s Next In the Pipeline: • User Guides for Reports/Extracts • Draft Settlements User Guides to be posted 2/28 • DDL Comments • Draft comments to be posted 2/28 • Join Documentation • Draft to be posted 2/28 • Additional Effort • New Market Data Transparency Page live by end of February

  7. Questions? 09/22/2008

More Related