Shipperless & Unregistered Workgroup

1. Shipperless & Unregistered Workgroup Wednesday 5th December 2012

2. Agenda • Introduction • MPRN Creation Workgroup • Modification update • MPRN Creation Process change ~ Update • MPRN’s set to DEad in error • Previous actions • Statistical Information • Overall industry volumes • ‘Churn’ figures & age profiles • Population cleansing – ‘Strawman’ update • End-User letter update • S&U Population ‘Pot’ Priorities • A.O.B.

3. MPRN creation Workgroup

4. Agenda • Modification update (C.Warner) • MPRN Creation Process change • Proposal update (D.Mitchell) • Consultation questions • MPRN’s set to DEad in error • A.O.B.

5. Work to scope/design ongoing since June’12 Consultation document published 28th November Via the Energy Networks Association Also distributed via key industry bodies; Joint Office Local Authorities Your views are essential – Opportunity to comment MPRN Creation proposal

6. MPRN Creation proposal

7. MPRN Creation proposal

8. Q1. What kind of impact do you think that this process change will have on speculative connections? (Speculative connections may include phased sites & units where the final usage is not known; in some cases gas supplies are installed but never used) Q2. What are the anticipated Supplier time scales from first contact with the end user until a supply contract is in place? Q3. Should ‘Assisted Connections’ be included in this process? Or are they considered out of scope due to the large number of ‘Assisted Connections’ requested by Local Authorities? MPRN Creation proposal: Consultation questions

9. Q4. How will this revised process affect the customer experience? Q5. Will this process affect shipper processes and systems? If so what are your expected timescales required to amended yoursystems? Q6. Does the amended process have any impact on the systems and Resources of Xoserve? MPRN Creation proposal: Consultation questions

10. Q7. Does this process cause any potential competition issues for any party effected by this proposal? If so how can they be addressed? Q8. Does this change target the root cause of the problem or should additional measures (i.e. MAM obligations) be considered to ensure that a supply contract is in place before a meter is installed? Q9. What implementation timescales do you expect will be required should this change be approved? MPRN Creation proposal: Consultation questions

11. MPRN’s set to DEad in error • Previously raised due to impacts on Shipper processes • Creation/Confirmation of new MPR • Updating records • Interface with EndUser / MAMs etc. • Xoserve only set to DEad at Shipper request (ISO contact) • Samples provided to DN’s for analysis • Low volumes • Updates to be shared with Workgroup

12. High level Isolation process Is there a request to set to DE? Yes Xoserve receive Site Visit results back from Network. Xoserve Send for Site Visit and await response. Xoserve Receive ISO Query Xoserve Validate ISO Query No Xoserve analyse and interpret data. Is there a request to set to LI? No Status Amendment Required No Have Network confirmed that the Service is DE? No No Status Amendment Required Yes Xoserve analyse and interpret data. Yes Xoserve Amend status of MPRN: to LI. Xoserve Amend status of MPRN: to DE. Xoserve update Query Management System and send resolution to Shipper. Xoserve update Query Management System and send resolution to Shipper. Xoserve update Query Management System and send resolution to Shipper. Xoserve update Query Management System and send resolution to Shipper.

13. Previous actions

14. Statistical Information

15. Overall Industry volumes

16. Site churn

17. Legitimately Unregistered: Age analysis

18. Orphaned sites: Age analysis

19. SSP: Age analysis

20. PTS: Age analysis

21. Overall Industry volumes: Age analysis

22. AQ values (10years +)

23. Overall Industry volumes: AQ values

24. Population cleansing ‘Strawman’ Proposal update

25. Background • Increasing S&U population • Since Sept’11 circa 7k more sites • Options to establish more accurate dataset • Enabling improved focus where required • Clearer data for AUGE • Workgroup agreed for defined methodology • Production of ‘Strawman’ process

26. Desktop investigation to determine bulk process All Unregistered MPRNs All Unregistered MPRNs Sample of 100 Sample of 100 Sample Selection Sample Selection >10 years old identified >10 years old identified MPRNs selected MPRNs selected Xoserve System Xoserve System UK UK - - Link examined for: nominations; failed Link examined for: nominations; failed DES examined for: DES examined for: Conquest examined for: Conquest examined for: Checks Checks confirmations; failed asset updates confirmations; failed asset updates CSEP Indicator CSEP Indicator MPRN Creation Request MPRN Creation Request Local Authority Local Authority Internet Search Internet Search GB Address Manager GB Address Manager Websites used to Websites used to Engines used to Engines used to and Post Office and Post Office Internet Internet check if site is check if site is obtain additional obtain additional Website used to Website used to Searches Searches occupied. occupied. information information Validate Address Validate Address MAMs MAMs – – The The UIPs UIPs - - The The Shippers Shippers – – ad ad Networks Networks - - ad ad sample would be sample would be sample would be sample would be External External hoc requests for hoc requests for hoc requests for hoc requests for provided to our provided to our provided to our provided to our Communications Communications information. information. information. information. existing MAM existing MAM existing MAM existing MAM contacts contacts contacts contacts Further Actions Further Actions MRA Site Visit MRA Site Visit End User Letters End User Letters

27. Possible outcomes following investigation Another Live MPRN exists on UK-Link with the same address (Domestic Sites Only) Another Live MPRN exists on UK-Link with an equivalent flat address (Flat 1 vs. Flat A) The site has been identified as a CSEP or IGT site The MPRN has a plot address and is <5years old MPRNs will be set to EX if OR OR OR It has been determined that the site has been demolished It has been determined that the service has been removed It has been determined that the service has been replaced MPRNs will be set to DE if OR OR It has been determined that the service exists but the meter has been removed or no meter was ever fitted If a Nomination or Confirmation is received for the MPRN. No Action Required Further action* will be deemed necessary if It no conclusion can be drawn from investigations * Further action may include End User Letters; MRA Site Visits or Network Site Visits tbc

28. Next steps • Agree on scope of analysis • Targeted the Orphaned population (100 oldest sites) • Agree on methodology • Followed the steps agreed with Industry 19th Sept • Agree on confidence levels • Shared output with DN’s and await feedback • Findings/updates to be shared via the Workgroup

29. Findings • Detailed system analysis (100 oldest sites >10yrs) • High level ‘themes’; • Flats & possible renovations • Duplicates & Dead/Demolished • Data conflict across systems • Agree if action can be taken without a site visit

30. Data Analysis Results 100 MPRN’s analysed

31. Findings • In 71% of cases a site visit is required • Establish: MSN/MPR/Capable of passing gas/Supplier identity • 13% Dead (property no longer exists) • 14% Extinct (duplicate MPRN) • 2% have subsequently been confirmed!

32. End User letters Recap… • Trial exercise undertaken in May'12 (100 sites) • 20% of sites confirmed or resolved as duplicate MPRN's • Ongoing industry discussion re. benefit of further exercises • Recent dialogue with Ofgem/DN's/Xoserve to target issue

33. End User letters Next steps… • 'Strawman' desktop exercise encouraging ongoing option • 30% resolved • Suggestion to further pursue desktop approach • Collaborative Xoserve/DN exercise • Utilising central & local systems • Maintain commitment for ongoing focus & priority

34. S&U Population ‘Pot’ Priorities

35. S&U Pot Priorities • Xoserve has assigned a priority ratings to each of the S&U pots • Two priorities have been assigned • Initial priority; applied to the fresh datasets that are issued on a bi-monthly basis. • Secondary priority; applied on an ongoing basis, for continuous work to reduce the overall population • The ratings were mainly based on the apparent ability to consume gas

36. Pot Descriptions and Trends

37. Initial Pot Priorities

38. Secondary Pot Priorities

39. Respected expertise, visibly engaged Industry Engagement SolutionDelivery Operations Customer service functions 9297386901 Creative solutions, delivered responsibly Critical services, expertly delivered

40. AOB • Any other business? • Thanks for your attendance… • … your contribution & support • Have a safe journey home!