1 / 6

Transactions Out of Protocol Report

Detailed report on transactions falling outside protocol, providing essential data for market analysis. Includes ETS-delivered CSV data processed manually via Access and visual basic.

burchg
Download Presentation

Transactions Out of Protocol Report

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. Transactions Out of Protocol Report Market Metrics Working Group March 1, 2006 Retail Market Analysis

  2. Transactions Out of Protocol Report • There was a desire by the market to have detail provided relating to the transactions that fall outside of protocol. This is related to the Public Utility Commission of Texas Performance Measures Reporting #24462. • The following is the result of efforts to provide this information by Retail Market Analysis.

  3. Transactions Out of Protocol Report • Data produced by ETS (Electronic Transactions System) • 1 set of data delivered in a batch job. (overnight) • Data is in csv format. • Requested by month for a max three month period. • This will be a manual process performed by Retail Market Analysis using Access and will include visual basic. • Initially email delivery • Can run for 1 Duns number • Implemented January 28, file starts from that point – no resummarization.

  4. Transactions Out of Protocol Report Data Elements CR- Duns number of Competitive Rep involved in the transaction TDSP- Duns number of the TDSP involved in the transactions Business Process- Switch, Move In Transaction Type- Transaction number, ex: 814_04 NAESB In- Date time of the transaction to ERCOT NAESB Out- Date/time of the transactions from ERCOT Global ID- ESI ID and original transaction numbers Hours Outside Protocol- time beyond the protocol time (excludes weekends and holidays) hours and hundredths of an hour

  5. Transactions Out of Protocol Report • Example of what Retail Market Analysis receives • Protocol Exception Export Feb 13 - ERCOT Summary • Start Date:,="02/2006" • End Date:,="03/2006" • CR:,All • TDSP:,All • CR,TDSP,Business Process,Transaction Type,NAESB In,NAESB Out,Global ID,Hours Outside Protocol • =“111111111",“666666666",Move-In,814_04,="02/06/2006 14:43:22",="01/03/2006 20:58:56",="0000000000000000000109999999999999999999999999999999999999999999",="507.740555555555555555555555555555555555"

  6. Transactions Out of Protocol Report • Next Steps: • Validate the data returned • Work with a small group of volunteer market participants • Implement for all market participants

More Related