1 rms update - ercot june 10, 2004. 2 supporting reports section
TRANSCRIPT
4
Missing 867 Report • The Missing 867 Report will provide TDSPs information about Service
Orders in a scheduled state for which ERCOT has not received an 867 completing transaction at least seven days after the scheduled meter read
• Weekly report provided to the TDSP Stats Summary:
Missing 867 Report
3/3/04Total
3/31/04Total
4/28/04Total
5/26/04Total
May'04
April'04
Mar'04
Feb'04
Jan'04
Dec'03
> 6 Months
AEP TX Central 2,256 2,024 1,089 1,153 712 283 86 35 5 15 17
AEP TX North 231 302 97 79 58 12 3 3 1 1 1
Centerpoint 891 684 550 571 375 157 22 9 3 2 3
Oncor 4,210 3,477 2,068 1,979 935 422 200 75 58 69 220
Sharyland 29 50 23 32 9 14 1 2 1 2 3
TNMP 534 447 213 300 94 84 38 36 13 7 28WTU - SPP 10 7 0 3 3 0 0 0 0 0 0Total 8,161 6,991 4,040 4,117 2,186 972 350 160 81 96 272
Breakout of 5/26/04 Data
5
Missing 867 Report
0
1,000
2,000
3,000
4,000
5,000
6,000
May
-04
Apr-0
4
Mar
-04
Feb-04
Jan-
04
Dec-0
3
Nov-0
3
Oct-
03
Sep-0
3
>6 m
onth
s
Month
Co
un
t o
f M
iss
ing
86
7s
3-Mar
31-Mar
28-Apr
26-May
6
Missing 867 Report
0
1,000
2,000
3,000
4,000
5,000
6,000
1 2 3 4 5 6 > 6
Months in the past
Co
un
t o
f M
iss
ing
86
7s
3-Mar
31-Mar
28-Apr
26-May
8
SituationERCOT periodically receives 867_03 Finals and 867_04s for service orders that are Canceled in ERCOT systems. The Service Order Statuses that are considered Canceled are: Canceled (manually or concurrent processing), Canceled by Customer Request, Canceled by Customer Objection, Canceled Permit Not Received, Canceled with Exception, Unexecutable and Rejected by TDSP. This can indicate an out-of-sync condition between the TDSP and ERCOT.
Mechanism for Handling 867 RCSO:Step 1: ERCOT produces 867RCSO data each Friday and submits a report file to each TDSP
and CR via the ERCOT PortalStep 2: The TDSPs review the FasTrak line items and take one of the following actions:
a) If the TDSP has cancelled the service order, no further action is requiredb) If the TDSP has completed the service order, they will initiate a day-to-day FasTrak issue and work with ERCOT to get ERCOT systems changed to complete. Completion of canceled service orders will require the approval of the CR initiating the transaction.
(Note: For Cancel by Customer Objection, the TDSP will honor the cancel in their systems)
867s received on Canceled Service Orders
9
867s received on Canceled Service Orders
TDSP Total
Cancelledby TDSP(In-Sync)
Completedby TDSP
(Out-of-Sync)
Awaiting TDSP
ResponseAEP 263 59 204 0CenterPoint 453 308 145 0ONCOR 498 220 177 101Sharyland 42 1 41 0TNMP 410 401 9 0Grand Total 1666 989 576 101
April 30, 2004 Status• Issues on FasTrak from 11/7/03 through 4/23/04• Issues to Portal Report starting 4/30/04
April 30, 2004 Status
Includes only data submitted via
FasTrak 11/7/03 through 5/28/04
Cancel Type TotalCancelled 571Customer Request 91Customer Objection 470Permit Not Received 266Cancelled w/ Exception 55Rejected by TDSP 141Unexecutable 201Grand Total 1,795
10
867s received on Canceled Service Orders
Completed Items
• ERCOT continues sending weekly FasTrak issues to TDSPs
• ERCOT modified process to omit 867 Cancels from reporting beginning with 2004
• ERCOT met with each TDSP on 2/4/04 and 2/5/04 to determine a consensus direction for clearing out-of-sync ESI IDs
• 867RCSO process helped to identify two processing issues with two different TDSP since its inception
• ERCOT moved the 867RCSO report from a FasTrak Initiated issue to an automated weekly portal report to the TDSP and the CR on April 30, 2004
Next Steps
• ERCOT to summarize data provided to the TDSPs for reporting to RMS for the next few months
11
FasTrak Issue Status• 2003 Day-to-Day• 2004 Day-to-Day• Data Extract Variances (DEV)• ERCOT Initiated Issues
12
FasTrak 2003 “Day to Day”Issue Stats (as of 06-01-04)
• Total ESI IDs worked on 2003 issues = 324,688STATUS 3/9/04 4/5/04 5/5/04 6/1/04
New 0 0 0 0 0.00%
In Progress (w/ERCOT) 0 0 0 0 0.00%
In Progress (w/TDSP) 1 0 0 0 0.00%
In Progress (w/CR) 0 0 0 0 0.00%
Resolved 13,096 13,098 13,099 13,099 93.22%
Rejected 950 953 953 953 6.78%
Total 14,047 14,051 14,052 14,052
3/9/04 4/5/04 5/5/04 6/1/04
New 727 365 332 314 4.85%
In Progress 795 464 369 318 4.91%
Resolved 4,800 5,482 5,604 5,673 87.60%
Rejected 159 166 171 171 2.64%
Total 6,481 6,477 6,476 6,476
Issue CountsNon-ERCOT
ERCOTIssue Counts Issues as a
% of Total
Issues as a% of Total
• Of the 632 New and In Progress Non-ERCOT issues, 30 are resolved and awaiting other party resolution check off
• 2 are for the year 2002
• Number of ESI IDs not tracked
13
FasTrak 2004 “Day to Day”Issue Stats (as of 06-01-04)
• Of the 277 New & In Progress, 117 are resolved and awaiting other party resolution check off
• Total ESI IDs worked to date since January 1, 2004 = 132,956
• Of the 2,049 New & In Progress, 262 are resolved and awaiting other party resolution check off
• Number of ESI IDs not tracked
STATUS 4/5/04 5/5/04 6/1/04
New 27 14 4 0.06%
In Progress (w/ERCOT) 58 31 34 0.47%
In Progress (w/TDSP) 86 76 85 1.19%
In Progress (w/CR) 166 117 154 2.15%
Resolved 3,835 5,210 6,349 88.65%
Rejected 397 485 536 7.48%
Total 4,569 5,933 7,162
4/5/04 5/5/04 6/1/04
New 398 307 249 3.50%
In Progress 1,448 1,696 1,800 25.31%
Resolved 2,322 3,703 4,811 67.64%
Rejected 88 189 253 3.56%
Total 4,256 5,895 7,113
Issue CountsNon-ERCOT
ERCOTIssue Counts Issues as a
% of Total
Issues as a% of Total
14
FasTrak Data Extract VarianceIssue Stats (as of 06-01-04)
STATUS4/5/04 5/5/04 6/1/04 4/5/04 5/5/04 6/1/04 3/9/04 4/5/04 6/1/04 3/9/04 4/5/04 6/1/04
New 1 0 27 0 0 0 1 0 27 0% 0% 1%
In Progress (w/ERCOT) 39 32 258 0 0 0 39 32 258 4% 2% 14%
In Progress (w/TDSP) 220 348 389 0 0 0 220 348 389 23% 26% 20%
In Progress (w/CR) 119 179 252 0 0 0 119 179 252 12% 13% 13%
2004 Resolved 405 585 730 1 1 1 406 586 731 43% 44% 38%
2004 Rejected 160 194 241 8 8 9 168 202 250 18% 15% 13%
Total 944 1,338 1,897 9 9 10 953 1,347 1,907
4/5/04 5/5/04 6/1/04 4/5/04 5/5/04 6/1/04 3/9/04 4/5/04 6/1/04 3/9/04 4/5/04 5/5/04
New 2 11 5 10 9 19 12 20 24 2% 2% 2%
In Progress 69 88 117 174 364 436 243 452 553 39% 43% 39%
2004 Resolved 158 225 290 176 310 480 334 535 770 54% 51% 55%
2004 Rejected 23 27 27 12 24 28 35 51 55 6% 5% 4%
Total 252 351 439 372 707 963 624 1,058 1,402
Issues% of Total
TotalIssuesUsageService History
ERCOT
Non-ERCOT (CR to TDSP)
Service History Usage Issue TotalsIssues
% of Total
Note: Of the 926 New & In Progress ERCOT Issues, 30 are resolved and awaiting other party resolution check off
15
FasTrak ERCOT Initiated Issues Issue Stats (as of 06-01-04)
• These are issue initiated by ERCOT to the TDSP or CR as a result of one of the following projects:– Customer Protection Period and 814.08– 867 Received on Canceled Service orders– 5 new issue types to support Energy Aggregation Management
Department issue process
STATUS 2/4/04 3/9/04 4/5/04 5/5/04 6/1/04
New 1 17 4 4 1 0.45%
In Progress (w/ERCOT) 17 37 23 29 27 12.11%
In Progress (w/TDSP) 48 37 48 37 9 4.04%
In Progress (w/CR) 3 1 0 0 0 0.00%
Resolved 49 68 107 140 184 82.51%
Rejected 0 0 2 2 2 0.90%
Total 118 160 184 212 223
ERCOTIssue Counts Issues as a
% of Total
18
LRS PROJECT INFORMATION
• Market Updates– TDSP Installation update as of 6/1/2004
– CR.csv examples have been demo with market
– Pilot Program to start end of June 2004 and run through Sept 2004
– TDSPs to enter Pilot Early July 2004
– CRs to enter Pilot 1 month thereafter
– During Pilot, Market will be working with ERCOT to resolve program issues
– Next LRS market meeting 6/23/2004 at MET Center
CompanyNumber of Sample
Points Reviewed Inspected Replaced InstalledSent file to ERCOT for
sample pointAEP North 375 375 3 0 3 0AEP Central 723 689 0 0 0 0Centerpoint 434 430 0 0 0 0Oncor -- Legacy 934 934 934 0 934 0Oncor -- New 1807 1746 0 0 0 0TNMP 107 104 104 0 98 0Sharyland 1 1 1 0 1 0Totals 4381 4279 1042 0 1036 0Complete to date 100.00% 97.67% 23.78% 0.00% 23.65% 0.00%
19
LRS PROJECT INFORMATION
• ERCOT Updates– Updated operation guide to reflect changes needed by market and
ERCOT
– Updated TDSP.CSV file for format clarifications
– Updated replacement rules for temporary service and OMR
– In-process is internal integration testing in preparation for pilot
– Supplemental additions to original samples completed for stratums that were not sampled at 100% but required for statistics
– Tracking sample point installations and working with TDSPs on sample point replacements
20
LRS PROJECT UPCOMING ACTIVITES
• July to Sept 2004, TDSPs to start “pilot” with ERCOT– Submitting installations of IDRs
– Submitting meter readings
– Obtaining responses for submitted data
– Working with ERCOT Load Profiling Group for errors
– Weekly conference calls with TDSPs
• August to Sept 2004, CRs to start “pilot” with ERCOT– Obtain accepted and/or aggregated raw IDR information (.LSE
and .CSV)
– Obtain control files and environment files
– Working with ERCOT Load Profiling Group for errors
– Updates on conference weekly calls