Download
1 / 54
540 likes | 655 Views
Shipperless & Unregistered Workgroup. Wednesday 17 th September 2014. Agenda. Introduction Previous Actions Statistical Information – Update on S&U Reports Shipperless and Unregistered Sites Clearance Project Update GDNs Updates
E N D
Shipperless & Unregistered Workgroup Wednesday 17th September 2014
Agenda • Introduction • Previous Actions • Statistical Information – Update on S&U Reports • Shipperless and Unregistered Sites Clearance Project Update • GDNs Updates • Ofgem Query – Responsibility for a Meter at a Shipperless Site • Discussion Points: • Withdrawn Sites with Live MPRNs with No Meter Attached • Legitimately Unregistered • Contacts for 424, 425 and 410a • MNC MPRN Creation Process Changes - GDNs • Multiple MPRN Creation Requests • A.O.B.
Outstanding Actions Outstanding actions from previous meetings
Outstanding Actions Actions from meeting held on 06/05/14
Introduction • In response to Ofgem’s open letter to the Gas Distribution Networks regarding their concern over the existing population of Unregistered Sites, the GDN’s produced a plan which aimed to reduce this population. • In the plan narrative, the GDNs stated that in order to address the issue, a concerted effort by all industry participants was required. • The plan set out a series of activities spanning 12 months, starting in November 2013 and culminating in October 2014.
Actions Carried Out To Date • In November 2013, Xoserve collated records of all Shipperless and Unregistered Sites that had been identified on the Sites and Meters Database. This dataset was “ring-fenced” to form the base data for the exercise. • The dataset was categorised into the usual reporting “pots” that are issued to industry participants on a monthly basis. • The pots were issued to Shippers, UIPs, and Networks with the request for each party to investigate the records within the dataset and to report their findings back to Xoserve by the end of December.
Actions Carried Out To Date • A reminder was issued to Shippers and UIPs in mid December, and Xoserve’s Shipper Engagement team contacted Shippers on an individual basis to discuss the project and to urge them to reply. • By the end of December 2013, 5 UIPs and 8 Shippers had replied. • We received subsequent replies after the deadline and we were able to include these in our analysis.
Actions Carried Out To Date • In the meantime, Xoserve had engaged in an exercise to investigate possible data cleansing methods that could be used to clean the data before embarking on the End User Letter component of the GDN Plan which was scheduled to commence in February 2014. • Xoserve explored different approaches to data cleansing. • System Updates • Plot Addresses • Group Contracts • Duplicates • Large AQs • Age Analysis
Proposed Xoserve Data Cleansing • We found that data cleansing options available to Xoserve were time consuming and ineffective. • Additional information available to Shippers and Networks made their activities more effective in comparison. • Xoserve used available systems to remove sites that have been confirmed, and sites with a Meter Point Status of DE or EX. • Xoserve removed all sites with plot addresses and endeavoured to find alternative postal addresses. • Xoserve endeavoured to find duplicate MPRNs and remove them from the dataset. (This is only possible where a MSN is evident). Where a duplicate is established, the erroneous MPRN will be set to EX.
Lettering • Xoserve made the necessary amendments to the base data to create the datasets for producing End User Letters. • The feedback from Shippers, UIPs and GDNs, and data cleansing conducted by Xoserve was taken into consideration. • Letters were sent to 17,108 Shipperless and Unregistered sites over a number of tranches which started in March and finished in July. • Each site received a letter explaining that a gas supply was recorded on the central Sites and Meters Database but did not have a gas Supplier recorded for it. The end user was requested to provide Xoserve with information regarding the gas supply at their property.
Lettering • If no response was received after two weeks, a second letter was issued. • The information from the End User Letter responses was used to advise what action was required to resolve the Shipperless / Unregistered record. • A number of records were passed to Shippers associated with the Suppliers named by the End Users. • Any remaining records that were not resolved by “Desk-top” investigation or through the Lettering Process, were passed to the relevant GDN.
Next Steps • Xoserve has provided datasets to all GDNs for them to continue investigations. • GDNs to continue with investigations • Xoserve has also provided datasets to relevant Shippers where an end user has indicated that they are supplied by a Supplier. • Shippers to investigate and respond to Xoserve.
Lessons Learned • As with any project, Xoserve encountered a few difficulties. • As the new MUS (Manage Unregistered Sites) Contact procedure includes a lettering aspect, it was though prudent to examine what could be done better in the future. • Xoserve conducted an internal Lessons Learned Workshop. • It was thought appropriate to share some of the Lessons Learned.
Ofgem Query – Responsibility for a Meter at a Shipperless Site
Responsibility for a Meter at a Shipperless Site • Xoserve was recently contacted by Ofgem following an enquiry from an End User who was having difficulty getting the meter and service removed from their property. • No specific details were given, Ofgem wanted to know areas of responsibility in these circumstances. • Shipperless – known previous supplier • Shipperless – no known previous supplier • Can we have your comments on this situation?
Discussion Points • Shipperless and Unregistered Sites have been partly addressed by the Shipperless and Unregistered Clearance Project, and will continue to be addressed by the Contact Codes to be introduced as a result of MOD410a and MOD424/425 (MUS/GSR). • There are a number of Shipperless and Unregistered Sites that have not been touched. • Legitimately Unregistered • Shipperless Sites with No Meter Attached • Should these populations be the focus of the group’s attention?
Withdrawn Sites with Live MPRN and No Meter • Current Population: 392,144 • MPRN's which represent: Isolated and Withdrawn Sites • Usual route to the Shipperless Pot for Isolated and Withdrawn Sites is to go through the GSR Process. Only sites where a meter has been found connected during a GSR investigation will be included. • Current Population of Shipperless Pot: 5,725
Legitimately Unregistered • Current Population: 35,570 • MPRN's which represent: Vacant sites / No Gas meter but live service / Service still in planning stage. • This dataset is only updated by adding new records or when MPRNs currently in the dataset are set to DE/EX or Confirmed. • We have no way of knowing if the data that determined the inclusion of a record into this dataset is still correct, i.e. has someone moved into the property and consuming.
Group Activity • Split into two groups • Discuss one of the topics. • Root Causes • How does this affect the Industry? • How does this affect my organisation? • Does the issue need to be addressed? • What can be done to reduce the numbers? • Feedback to the whole group. • Formulate any necessary actions.
Contacts for 424, 425 and 410a Processes • A request has been made that a list of Shipper and Network Contacts should be made available for use during the investigation and resolution of GSR and MUS Contacts. • It is proposed that the Contact list that is being compiled for the S&U Process should be used for this purpose. • This list is still far from complete. We will be asking Xoserve’s Shipper Engagement Team to request contact details from each shipper.
When is an MNC not an MNC?….when it’s a FOM Dave Ackers
Background • Meter Point Reference Number (the identity of the pipe) should originate at the time when the Meter Point is created. • In the ‘ideal world’ this would be when the service pipe is in the ground and when the address of the property is officially registered by the Royal Mail. • Procedurally, all meter points are Tagged (since August 2002) and visible, providing the ability to determine its numeric identity and the UIP • These are posted to Xoserve in the form of a FOM Contact • MNCs should be rare
Background • Between January to June 2014 we received 39,665 FOMs ….average 6,600 per month • We have processed these within 4 – 6 hours of receiving them • Between January to June 2014 we received 8,325 MNCs ….average 1,400 per month • 1 in 17 MNCs are rejected …around 1,000 each year • We did a review of the MNC process as we noticed some MNC Contacts raised some doubts about their validity
FOMs & MNCs Explained • FOM • The FOM acronym stands for ‘FOundMeter’ - (Tagged Service) • It is a request to create an MPRN for a Live Supply Point (with or without a meter serial number) where UK link has no live record. This applies to tagged services only. • FOMs can be generated by Shippers or UIPs. • MNC • The MNC acronym stands for MNumber Creation – (non tagged service) • A request for Xoserve to create an MPRN for a Live Supply Point where UK Link has no live record. These will not be tagged • MNCs can be generated by Shippers or Networks
Sample Period / Results • Analysis undertaken • Conducted over a 6 months period January to June 2014 • Analysis of FOMs received and MNCs received • We did an address match comparison between the 39.5k FOMs and the 8.5k MNCs • Findings • Out of 48k MPRN creations (both FOMs and MNCs) we readily noticed 97 (1 in 500) were duplicate records were created • The various scenarios found are illustrated on the following slides • There may be other duplicate records created if there were slight or noticeable variants in the address format (MNC address v. FOM address)
Addressing the problem • The accuracy of the address and the timely provision of the approved address is one of the root causes • Out of the 6k – 7k FOMs received each month, 1k start their life as Plot Addresses • Many of these don’t get amended on UK-Link once the Royal Mail have given the premises an officially approved address. • Twelve months ago there were 70k Plot Addresses • We now have 40k Plot Address (worked with Shippers to obtain improved addresses and update UK-Link) • Had we not had this drive to amend Plot to Postal, the number of ‘poor addresses’ would have been around 100k
MNC raised before the FOM • MPRN 9327198111 was requested as an MNC for ‘16, Flat 2/2 Anon Place’ which was the PAF valid address. It was processed through CMS and the MPRN was created. • Days later, MPRN 9298453222 was requested as an FOM for ‘16, 2/2 Anon Place’. • As the addresses have a difference in the way the Flat is named, the system will create a second MPRN believing it is different. • We identified 10 instances similar to this scenario where two different versions of the same address had been requested by a FOM and MNC.
‘Multi Service’ – very unlikely • Of the 97 duplicate records created there were 75 that were attributed to a recently noticed practice of ticking the ‘Multi Service’ box on the CMS screen or indicating Y in the Multi Service file. • This ability to indicate ‘Multi Service’ applies to both MNCs and FOMs. • There were and addition 11 that didn’t cause a duplicate but the User selected ‘Multi Service’ when there was no existing MPRN on UK-Link. • By doing this, validation is by-passed and Shipperless or Unregistered sites are created
M No Creations left stranded • The following are combinations of scenarios seen…. • FOM raised first but MNC raised by Shipper on same day • MNC raised by Shipper A on the same day as Shipper B raised another MNC • Two MNCs raised by the same Shipper on the same day • Two MNCs raised by the same Shipper some days apart • MNC raised a few days before the FOM arrived • There are now 37 false ‘Unregistered’ sites added to the Pot
Time Between Contacts FOM - MNC • It is interesting to note the time difference between the two Contacts being raised. • The below chart shows how many weeks after an FOM Contact, an MNC was raised for the same address. No of MPRNs Weeks
Time Between Contacts MNC - FOM The below chart shows how many weeks after an MNC Contact, an FOM was raised for the same address. No of MPRNs Weeks
