shipperless & unregistered site working group recommendations to address the unregistered sites...

Shipperless & Unregistered siteworking group

Recommendations to address the Unregistered Sites

Collectively establish & execute activities to correct the current unregistered & shipperless datasets recorded

within the central systems;

Unregistered sites with Shipper activity

Widened identification scope of MPRNs that have metering activity and monthly reports sent to Shippers.

Propose that MPRNs created over 12 months must be responded to.

• Sites with a Shipper commitment to confirm will be monitored by Customer team.

• Orphaned sites will be processed through the end user letter process.

• xoserve will continue to report at appropriate industry forums

• Currently 8k (2.5 over 12 months old)

USNANA

Activities and sample work carried out to date have identified a number of process improvements to help resolve the

unregistered status of these sites.

Original data set 113k

Duplicates identified via reports to match exact addresses and

properties that have both an USNANA MPRN and a registered MPRN. 15k

Erroneous plot addresses 15k

Shipper billing – total USNANA dataset sent to all Shippers to

identify MPRNs on their billing systems 5k

End user letter trial 1k

Orphaned sites from the original unregistered pot 4k

Pre 1996 sites 2k

MPRNs less than 12 months old - analysis of the confirmations

during 2006 indicated that the average number of days taken to

confirm was 95. However over 1,000 sites across the largest seven

portfolios took over 12 months to confirm 27k

Outstanding for desk top cleanse 44k

PAF 20%

Non PAF 80%

I&C 10%

Domestic 90%

Desktop analysis commitment by xoserve to process the remaining 44k sites which will result in the following scenarios;

• Erroneous sites set to DE

• End user letters

PSA report leading to a confirmation

Vacant site

No gas

No response leading to a site visit

Current resource levels will complete this project work within 12 months.

As at 9th October xoserve are awaiting the results of the sample site visits each Network have agreed to carry out.


Original Unregistered Shipper Activity Pot as at 08/10/078,497 sites

Unregistered Null response (orphaned), 34%

Unregistered Yes Responses, 18%

Set to DE or EX, 6%

Registered, 42%

Number of MPRN's unconfirmed versus number of confirmed as at June 2007

0

2

4

6

8

10

12

14

MPRN's Created in May 2007 MPRN's Created in November2006

MPRN's Created in May 2006

Th

ou

sa

nd

s

Month

Nu

mb

er

of

MP

RN

s

Number of Mprn's Unconfirmed to date Number of Mprn's Confirmed to date

Number of Unconfirmed MPRN's with Shipper Activity Versus Number of MPRN's with Shipper Acivity

0

1

2

3

4

5

6

7

8

9

10

MPRN's Created in May 2007 MPRN's Created in November2006

MPRN's Created in May 2006

Th

ou

san

ds

Month

Nu

mb

er

of

MP

RN

's

Number of Unconfirmed with No Shipper Activity Number of Unconfirmed with Shipper Activity


Extrapolated USNANA end user trial figures

No gas 11,966 11%Vacant site 9,144 8%

Conf live 17,804 16%No reply 41,091 36%

Conf dead 32,995 29%

The End User letter trial carried out in July and August 2007 took a relative sample of 1000 sites across the age profile of the USNANA

data set.

The extrapolated results indicate that 16% of sites should be confirmed as using gas.

19% are legitimately shipperless

29% are erroneous

36% may need a site visit to establish the status

A plot address sample of 365 sites concentrated on plots created in 2003 and 2004 and allowed us to update 26% to the correct

address.

USNANA Plot address

No reply from council36%

Council checked the data and could not provide the correct address details38%

Council checked the data and address details w ere amended on UK-Link26%


USNANA Age Analysis

0

5

10

15

20

25

Before1996

1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007

Th

ou

sa

nd

s

Year

Nu

mb

er

of

MP

RN

s

USNANA Load Analysis

0

20

40

60

80

100

120

Domestic Large I&C Small I&C

Th

ou

sa

nd

s

Year

Nu

mb

er o

f M

PR

Ns

USNANA MPRN's by Network

0

10

20

30

40

50

60

National Grid Plc Northern GasNetworks Ltd

Scotland GasNetworks Ltd

Southern GasNetworks Ltd

Wales & the WestUtilities

Th

ou

sa

nd

s

Network

Nu

mb

er

of

MP

RN

's

Recommendation to concentrate on anything after 1996 and over twelve months old leaves 90k


Identify the root causes & fix the process deficiencies

Code 12 MPRN requests

• Shippers have an action to identify their process deficiencies including the live/dead check

• xoserve to investigate why not already allocated by UIP

• IGTs to report on supplier details

• Implement process for shippers to feedback on code12 cancellations

Cancelled services

• xoserve to liaise with Networks, UIPs and Shippers to continually identify cancelled service lay jobs

Refurbishment / redevelopments. Old service not set to dead by Network or withdrawn from by shipper and continue to

bill. Newly created MPRN matched correct tag but never confirmed.

• xoserve to progress with relevant industry parties to improve communication and system flows.

Plot addresses

• Not to create an MPRN with the same plot and similar matched postcode as likely duplicate to be mapped

• UIP source via quotation systems

Publish all USNANA over 12 months to all Shippers.

• Possible notice board or virtual notice board to identify sites to all Shippers (possible xonet posting)

New MPRN allocation process at meter fix or some point nearer to the time when gas is to be consumed.

• Long term strategy requiring sign on from all industry parties

Early notification of interest.

• Introduce a Nomination stage for new domestic site process.


xoserve allocate batch of MPRN's to UIP

Customer requests new supply service quote

UIP Produces New Supply Service Quote

Customer Accepts New Supply Service Quote

UIP sends MPRN creation Request to xoserve via Conquest EFT file

xoserve investigate the MPRN creation request and either create MPRN or Reject Creation Request

MPRN allocated at Quote Acceptance (Current)

UIP Lay New Service

UIP Allocates MPRN and Informs jobrequester of MPRN.

Disadvantages

MPRN created as a result of cancelled jobs.A large number of plot addressescreated on S&M.MPRN’s created on S&M with no corresponding live service which could potentially be confirmed by shippers.

Advantages

MPRN available to shippers very early when undertaking meter fit.


Advantages

No MPRN created for cancelled new service jobs.Less plot addresses created on S&M as postal address is available at the point of creation.Only MPRN that has a corresponding live service will be on S&M.Majority of MPRN’s can be linked to a shipper via meter fit job.All created MPRN’s will have a live service and meter.

Disadvantages

The MPRN will not be available to Shippers when undertaking a meter fit.





UIP Lay New Service

UIP Allocates MPRN and Informs jobrequester of MPRN.

UIP sends MPRN creation Request to xoserve via Conquest EFT file

xoserve investigate the MPRN creation request andeither creates MPRN or Rejects Creation Request

Shipper undertakes meter fit and informs UIP that meter fit job has been completed

MPRN allocated at Meter Fit


Disadvantages

The MPRN will not be available to Shippers as early when undertaking a meter fit.

Advantages

MPRN’s will not be created as a result of cancelled jobs.Only MPRN’s that have a corresponding live service will be on S&M.As the MPRN allocation process occurs later, less plot addresses will be created on UKLink. The postal address will be availale at the point of MPRN creation.





UIP Lay New Service

UIP Allocates MPRN and contacts Job Requesterin order to source potential postal address

UIP sends MPRN creation Request toxoserve via Conquest EFT file

MPRN allocated at Completion of New Service Lay

xoserve investigate the MPRN creation request andeither creates MPRN or Rejects Creation Request

shipperless & unregistered site working group recommendations to address the unregistered sites...

Documents