60 likes | 74 Views
Transactions Out of Protocol Report. Market Metrics Working Group March 1, 2006 Retail Market Analysis. Transactions Out of Protocol Report.
E N D
Transactions Out of Protocol Report Market Metrics Working Group March 1, 2006 Retail Market Analysis
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.
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.
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
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"
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