DSC Delivery Sub-Group 21 st October 2019 Agenda (1) Item Title - - PowerPoint PPT Presentation

DSC Delivery Sub-Group

21st October 2019

Agenda (1)

Item Title Document Ref Lead Action Required From DSG 1. Welcome and Introductions Verbal Chair Introduce yourself 2. Meeting Minutes Verbal Chair Approval of the meeting minutes for the previous meeting 3. Defect Summary Slides Mark Tullett None – For Information and Discussion 3a. Issue Management Verbal Megan Laki/ Eamonn Darcy Standing agenda item – for information (if there is an update) 4. Portfolio Delivery 4a. Portfolio Delivery Overview POAP POAP published on Xoserve.com Standing agenda item – for information (if there is an update) 4b. Retail and Network Delivery Overview Slides Richard Hadfield/Julie Bretherton Standing agenda item – for information (if there is an update) 4c. Data Delivery Overview Slides Jane Goodes Standing agenda item – for information (if there is an update) 5. Major Release Update 5a. June 19/20 Slides Simon Burton / Surfaraz Tambe Standing agenda item – for information (if there is an update) 5b. EUC Update Slides Matt Rider Standing agenda item – for information (if there is an update) 5c. November 19 Slides Tom Lineham Standing agenda item – for information (if there is an update) 5d. XRN4914 - MOD 0651- Retrospective Data Update Provision Slides Tracy O’Connor/ Paul Orsler Standing agenda item – for information (if there is an update)

Agenda (2)

5e. XRN4991 – MOD700 – Enabling large scale utilisation of Class 3 Slides Tom Lineham Standing agenda item – for information (if there is an update) 6. New Change Proposals - For Ratification of the Prioritisation Scores None for this meeting 7. Change Proposal Initial View Representations None for this meeting 8. Undergoing Solution Options Impact Assessment Review 8a. XRN4992 - Modification 0687 - Creation of new charge to recover Last Resort Supply Payments Verbal Ellie Rogers For information and discussion 9. Solution Options Impact Assessment Review Completed 9a. XRN 4738 - Shipper Portfolio Update of Proposed Formula Year AQ/SOQ Slides Jane Goodes For DSG Recommendation 10. Miscellaneous 10a. Report Review Update Verbal Charlie Haley For information and discussion 11. JMDG Update Slides Simon Harris None – For Information Only as no change 12. CSS Update Slides Emma Lyndon For Information 13. ChMC Update Slides Rachel Taggart For Information 14. Action Updates Action log published on Xoserve.com All Updates required on DSG owned actions (see below) 15. AOB Slides Various TBC 15a. XRN4932 - Improvements to the quality of the Conversion Factor values held on the Supply Point Register (MOD0681S) Slides Simon Harris For information

• 3. Defect Update

• 3a. DSG Defect Summary

Defect Summary Stats Stats as per HPQC extract taken on

Thursday 17th October 2019.

Defect Landscape (Open/Closed vrs PGL/New)

PGL Defects Newly Discovered Defects GRAND RELEASE TOTALS

D1 D2 D3 D4 D5

TOTAL

D1 D2 D3 D4 D5 Not Set

TOTAL

Urgent Fix (D1/D2)

1 1 1

Amendment Invoice Task Force

R4.09 1 3 4 4 On Hold 1 1 1 Requires CR 1 1 1 Release Planning Future Release Dependent 1 6 7 7 Currently Unallocated 3 36 2 41 41 TOTAL OPEN 5 48 2 55

55

Closed as Rejected 3 14 7 24 11 51 54 1 4 121 145 Closed as CR 3 8 11 11 6 17 28 Closed - Deployed to Production 7 28 59 9 103 9 214 514 297 15 10 1059 1162 Fix Deployed - Pending Data Correction 1 5 8 14 14 TOTAL CLOSED 7 34 81 16 138 9 226 581 365 16 14 1211

1349

GRAND TOTAL 7 31 73 16 138 9 225 570 399 18 14 1266

1404

R4.08b & R4.09a

The below fixes were all deployed to production on 4th and 11th of October (Inclusive of Amendment Invoice Impacting Defects)

Release 4.09b is scheduled for 18th October and Release 4.10a is scheduled for the 25th October Note: We are still planning a fortnightly release deployment. However if fixes are ready in the interim, we may deploy in between releases. This is why you may see “a” and “b” suffixes in the release names.

Defect ID Status Description Release Deployed/closed on: Amendment Invoice Impacting 1428 Fix deployed – Pending Data Correction MR15 exception not genereting for negavite variance volume R4.08 04/10/2019 Yes 1430 Closed - Deployed to Production UKLink Query : RGMA Estimated reads for AMR removal not loaded in SAP R4.08 04/10/2019 No

Urgent Fixes

The below fixes were all deployed as urgent.

Defect ID Status Description Release Deployed On: Amendment Invoice Impacting 1472 Closed - Deployed to Production If a shipper is sending TTZ = 0; the reads are getting marked to ‘P' (MOD0700) Urgent Fix (D1/D2) 2019-10-04 No

Amendment Invoice Impacting Defects - Open

Defect ID Status Primary Business Process Description 1333Under Analysis READS DM REC financial mismatches in Amendment supporting file 1415Awaiting CAB READS SAP - Actual Reads uploaded through the manual Read entry screen has resulted in zero consumption 1429 Ready For Assurance READS RGMA activity has performed both class 3 normal rec and Check to Check

• reconciliation. This should have ideally triggered only Check to Check rec

since DRE or AMR are registered. 1449 Ready for Internal Testing RGMA - READS RGMA activity received in a class 4 period post class change from class 2 to class 4 calculates incorrect volume. 1453Fix In Progress INV SAP - ASP RCA May-19 1458DRS completed READS Issue with class 3 read upload process - Non-opening read is inserted between two reads through UBR process and next read has a TTZ of 1, volume is calculated incorrectly through UBR process 1462Fix In Progress INV SAP - differences between the total of the K90 lines in the ASP file and the K92 lines in the AML 1463 Ready For Assurance READS Incorrect volume calculation for class 3 sites between class change date and first cyclic read received post class change to class 3 1477Fix In Progress READS Incorrect variance Energy created after NDM prime reconciliation and net

• ff volume and energy getting populated with 0

1479Awaiting CAB INV Wrong bill doc movement for 8 Series Docs

• 3b. Issue Management

Verbal update

• 4. Portfolio Delivery

Portfolio Delivery

• 4a. Portfolio Delivery Overview POAP
• 4b. Retail and Network Delivery Overview
• 4c. Data Delivery Overview

• 4a. Portfolio Delivery Overview POAP
• The POAP is available here.

• 4b. Retail and Network Delivery Overview

UK LINK OVERVIEW

DSG - 21st October 2019

2019 / 2020 UK Link Governance Timeline

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2019 2020

• Assumes RETRO will be Nov 2020 Major Release Delivery
• Please note that this includes potential activity within UK Link over the next 24 months

Sep- 19 / EUC BER Approval 09/01/19 Nov- 19

BER Approval 10/04/18

EQR Approval 06/02/19

RETRO

Potential Activity

Governance Approval dates tbc

On track At risk

Key

Complete

Feb- 20 BER Approval / Change Pack Issue 10/04/19 Jun

• 20

Change Pack Issue Dec-19 Scope Approval 10/07/19 MiR 5 ChMC Scope Approval 10/07/19 EQR Approval Aug-19 Scope Approval 10/07/19 MiR 6 Scope Approval Nov-19 MO D 700 Imp Plan / BER Approval Sept-19 BER Approval Nov-19

Proposed Release XRN Change Title Current Status UK Link Release Complexity Finance Sept 19

4376 GB Charging & Incremental (IP PARCA) Capacity Allocation Change Delivery (2019) In PIS September 2019 XL NTS 4665 Creation of new End User Categories (EUC) In PIS June/Sep-2019 XXL Shippers

Mod 700

4991 Enabling large scale utilisation of Class 3 - Mod 700 In PIS September 2019 Large Xoserve

Nov-19

4679 Requiring a Meter Reading following a change of Local Distribution Zone or Exit Zone In Delivery November 2019 Medium Xoserve 4725 New read reason type for LIS estimate readings In Delivery November 2019 Medium Xoserve 4621 Suspension of the validation between meter index and unconverted index In Delivery November 2019 Large Shipper 4866 UIG Recommendation – removal of validation on uncorrected read In Delivery November 2019 Small Shipper

Feb-20

4955 Amendments of MDD PSR needs code descriptions In Delivery February - 2020 Small Shippers / GT/IGTs

Jun-20

4865 Amendment to Treatment and Reporting of CYCL Reads In Delivery June-2020 Small Shippers / DNO 4691 CSEPs: IGT and GT File Formats (CGI Files) In Delivery June-2020 Small DNs / IGTs 4692 CSEPs: IGT and GT File Formats (CIN Files) In Delivery June-2020 Medium DNs / IGTs 4772 Composite Weather Variable (CWV) Improvements In Delivery June-2020 X-Large Shippers / DNO 4897, 4899 Resolution of deleted Contact Details at a Change of Supplier event / Treatment of PSR data and contact details on a change of supplier event In Design June-2020 Small To be agreed 4930 Requirement to Inform Shipper of Meter Link Code Change In Delivery June-2020 Small Shippers 4932 Improvements to the quality of the Conversion Factor values held on the Supply Point Register (MOD0681S) In Delivery June-2020 Medium Shippers / DNO 4850 Notification of Customer Contact Details to Transporters In Delivery June-2020 X-Large IGTs / DNO 4871 – B Modification 0665 – Changes to Ratchet Regime In Delivery June-2020 Large DNO 4888 Removing Duplicate Address Update Validation for IGT Supply Meter Points via Contact Management Service (CMS) In Delivery June-2020 Medium IGTs 4941 Auto updates to meter read frequency (MOD0692) In Project Delivery - awaiting MOD approval June-2020 Large Shippers

CSSC

4627 Consequential Central Switching Services In Delivery 2021 XXXL Shippers

Change Index – UK Link Allocated Change

XRN Change Title Current Status Indicative Release Complexity

4851 Moving Market Participant Ownership from SPAA to UNC/DSC (Documentation only) CP in Capture Feb-2020 TBC 4645 The rejection of incrementing reads submitted for an Isolated Supply Meter Point (RGMA flows) CP in Capture Major Release TBC 4801 Additional information to be made viewable on DES HLSO in Review Major Release Medium 4896 Failure to Supply Gas System and Template Amendment CP in Capture Major Release TBC 4923 AQ Calculation for RGMA (ONUPD) Estimate Reads CP in Capture Major Release TBC 4931 Submission of Space in Mandatory Data on Multiple SPA Files CP in Capture Major Release Small 4978 Notification of Rolling AQ value (following transfer of ownership between M5 and M) CP in Capture Major Release TBC 4990 Transfer of sites with Low Read Submission Performance from Class 2 and 3 into Class 4 (Mod 664) CP in Capture Major Release TBC 4992 Creation of new change type to recover last resort supply payment (Mod 0687) CP in Capture Major Release TBC 4914 Mod 651 - Retrospective Data Update Provisions Solution Approval Major Release 2020 TBC 4716 Increased Field Length – ‘Updated by’ data item HLSO in Review Minor Release Medium 4854 Transfer of NDM sampling obligations from Distribution Network Operators to the CDSP In Capture Unallocated TBC 4780 – B Inclusion of Meter Asset Provider Identity (MAP Id) in the UK Link system (CSS Consequential Change) Solution Approval Nov 20 or CSSC Large 4997 Introducing new charge codes for proactive payment of GSOP 3 and GSOP13 CP in Capture Minor Release TBC

Change Index – UK Link Unallocated External Impacting Changes

Feb 2020 Major Release Retro 2020 Minor Release Unallocated

KEY

• 4c. Data Delivery Overview

Update on current Data Office change pipeline

7.9.1 Customer Impacting Data Changes: XRNs

Change Proposals Aug 19 Sept 19 Oct 19 Nov 19 Dec 19 Jan 19 Comments 4738: Shipper portfolio update of proposed Formula Year AQ/SOQ 4859: Increasing MAM Access to CDSP Data to Mitigate Reduced MAM Appointment Timescales 4824: National Grid Transmission Daily Gemini Report Awaiting Customer Sign off 4860: National ‘Temporary’ UIG Monitoring 4946: Reporting on Installed Meters with Conversion Capability 4795: Amendments to the PARR (520a) reporting 4779: UNC Modification 0657S - Adding AQ reporting to the PARR Capture **Estimated Delivery Change can be moved Delivery dates cannot be moved Delivery **Estimated delivery dates will be confirmed on completion of Capture and align to the chosen solution.

Data Changes: XRNs

Change Proposals Aug 19 Sept 19 Oct 19 Nov 19 Dec 19 Jan 20 Comments 4789: Updating Shipper Reporting Packs and glossary Will remain in delivery until all requirements fulfilled through DDP drops 4980: Change Supply Point Enquiry API to add in extra field and make certain

• ther fields visible.

BER Approval requested in October ChMC 4713: Actual read following estimated transfer read calculating AQ of

• 5. Major Release Update

• 5. Major Release Update
• 5a. June 2020
• 5b. End User Categories 19
• 5c. November 2019
• 5d. XRN4991 MOD 0700 - Enabling large scale utilisation of Class 3
• 5e. XRN4914 - MOD 0651- Retrospective Data Update Provision

• 5a. XRN4996 - June 20 Release - Status Update

21st October 2019 Overall Project RAG Status: Schedule Risks and Issues Cost Re Reso sources RAG Status Status Justification Schedule

• Plan: Market Trials options discussed in ChMC. Costed options to be shared in November and decision made.

Implementation date of 20th June will be proposed to ChMC for approval following completion of Design.

• Design: Design workshops are continuing, xrn4780B was descoped by ChMC and for xrn4941, ChMC instructed

Xoserve to proceed at risk pending Ofgem approval of MOD. Stage Gate B (Start Up) passed.

• Change Packs: Aiming to deliver the change packs to ChMC in November for approval in December.

Risks and Issues

• Risk – There is a risk that there is insufficient time to complete the design workshops due to limited SME resource

which will impact our ability to issue Change Packs by 15th November

• There is a risk that for xrn4941 a number of assumptions will be required in design which may not be validated until

after build because MOD0692 has not been approved leading to rework and delays Cost

• BER for full delivery to be presented to ChMC in November 19, this will include Market Trial options.

Resources

• Weekly monitoring of Xoserve SME resources supporting multiple demands (e.g. BAU defects, Future Releases etc.) is
• ngoing

XRN4996 - June 20 Release Timelines

Key Milestone Dates:

• Capture completion – 19/09/19
• Design Completion – 29/11/19
• Build & Unit Test Completion – 31/01/20 (provisional)
• System & UAT Completion – 24/04/20 (provisional)
• Regression Test Completion – 29/05/20 (provisional)
• Implementation – 20/06/20 (provisional)
• PIS Completion – 25/09/20 (provisional)

June 20 Release Summary

June 20 Release consists of 11 changes, Implementation is planned for June 2020:

• XRN4691 - CSEPs: IGT and GT File Formats (CGI Files)
• XRN4692 - CSEPs: IGT and GT File Formats (CIN Files)
• XRN4772 - Composite Weather Variable (CWV) Improvements
• XRN4780 (B) - Inclusion of Meter Asset Provider Identity (MAP Id) in the UK Link system (CSS Consequential Change)
• XRN4850 - Notification of Customer Contact Details to Transporters
• XRN4865 - Amendment to Treatment and Reporting of CYCL Reads
• XRN4871 (B) - Changes to Ratchet Regime (MOD0665)
• XRN4888 - Removing Duplicate Address Update Validation for IGT Supply Meter Points via Contact Management Service (CMS)
• XRN4830 – Requirement to Inform Shipper of Meter Link Code Change
• XRN4941* - Auto updates to meter read frequency (MOD0692)
• XRN4932 - Improvements to the quality of the Conversion Factor values held on the Supply Point Register (MOD0681S)

* Pending Solution/MOD approval by ChMC/DSG for remaining CRs.

• 5b. XRN4665 – EUC Release

21/10/19 Overall Project RAG Status: Schedule Risks and Issues Cost Resources RAG Status Status Justification Schedule

• Post Implementation Support (PIS)
• PIS activities (including First Usage monitoring) continue to be successfully monitored as per plan
• Preparation of Closedown activities commenced

Risks and Issues

• No key Risks or Issues open that impact the continuation of Post Implementation Support activities for the EUC release

Cost

• Project delivery costs are tracking to approved internal budgets (Revised BER to include Financial Risk margin approved at

ChMC on 10/07/19) Resources

• Weekly monitoring of SME resources supporting multiple demands (e.g. BAU defects, Future Releases etc) is ongoing

XRN 4665 - EUC Release Timelines

Key Milestone Dates:

• PIS & First Usage monitoring activities ongoing and tracking to plan for completion by 29/11/19
• Preparation of Closedown activities commenced

December January 2019 2020 2018 October November December January February October November May June September July August March April

System Testing & SIT Mobilisation User Acceptance Testing Design Build Code Merge

665 EUC

Performance Testing Regression Testing Part A Go Live Part B Go Live

Closedown

XRN4665

PIS

NRL Issued T67 Issued

• 5c. XRN4828 - Nov 19 Release - Status Update

21/10/19 Overall Project RAG Status: Schedule Risks and Issues Cost Re Reso sources RAG Status Status Justification Schedule

• Regression Testing ongoing and on track to complete by the milestone date of 25/10/19
• Performance Test commenced and on track to complete by the milestone date of 25/10/19
• Implementation preparation in progress
• Deployment of in scope changes on track for 09/11/19

Risks and Issues

• There are currently no major Risks or Issues impacting the delivery of the November 19 release.

Cost

• The BER with full delivery costs were approved at ChMC in April 2019, BER for XRN4866 UIG Recommendation

approved by ChMC on 12th June Resources

• Weekly monitoring of Xoserve SME resources supporting multiple demands (e.g. BAU defects, Future Releases etc) is
• ngoing

XRN4828 - Nov 19 Release Timelines

Key Milestone Dates:

• System & UAT Completion – 27/09/19
• Regression Test Completion - 25/10/19
• Performance Test Completion – 25/10/19
• Pre-Implementation Preparation – 08/11/19
• Implementation – 09/11/19
• PIS Completion – 06/12/19

2019

Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec

XRN4828 Nov-19

HLD & Change Pack Production Desi gn Build & FUT ST & SIT UAT RT & PT / Implementation Prep PIS 04/02: EQR Approval 10/04: BER Approval 08/05: Change Pack Approval GO LIVE 09/11/19 - TBC

• 5d. XRN4914 – MOD 0651Retrospective

Data Update Provision

High Level System Solution Options for Retro Proof of Concept

7.4.1 What do you need to know about Project Retrospective Updates?

• Project raised in April 2019
• Three main parts to the Project
• Proof of Concept (PoC) exercise, followed by a Data

Cleansing and Enduring solution

• PoC Requirements have been captured and approved
• Regular project updates provided at DSG and Change

Management Committee (ChMC)

• Solution Options have been ratified with customers and

Approval is now sought on recommended High Level Solution

• We are now in the mobilisation phase
• Encouraging Customers to get involved if possible
• You can register your interest in the PoC by getting in touch with

the Customer Change team or your Customer Advocate

• Onboarding to take place with Shipper volunteers
• Agree design and delivery mechanism of datasets
• Contracting with selected Vendor
• Updates will continue to be provided to DSG and ChMC

Proof of Concept (PoC) phase Capture phase

Compare and Contrast Analysis Collaboration, Triaging and Reporting

Working with Shippers to receive datasets, sharing information and findings at a Portfolio and Market level

Receive Datasets

• Requirements shared

with industry

• Project Updates provided

at DSG and Change Management Committees

What’s happened so far? What’s happening Next?

We are here

• Enhance communication and engagement of Proof of Concept exercise
• Continue to provide regular project updates to DSG and Change Management Committee

Onboarding Mobilise phase

October 2019 January 2020

Change Overview

XRN4914 - MOD 0651Retrospective Data Update Provision

This change comprises 3 elements; a Proof of Concept (PoC), a Data Cleanse and an Enduring Solution. At this stage our preliminary focus is the Proof of Concept as this will enable us to quantify the type and frequency of data quality issues that exist with Customers against a pre-defined set of Meter Assets data items. The objective of the Proof of Concept is to gain insight on the data issues and support the strategy for the Data Cleanse element. The Proof of Concept is a voluntary exercise which is open to any Shippers willing to participate. Requirements have been drafted to support a flexible solution that allows Shippers to participate at different levels, whilst also ensuring quality reporting and analysis can be obtained. Outputs from the Proof of Concept will include comparison reports with participating Shippers, and market level analysis to aid our understanding of the key issues and the appropriate approach to tackle Data Cleansing.

Solution Options for the Proof of Concept

Xoserve’s Azure Cloud Solution with SAS Analytics and SAS reporting 3rd party Azure Cloud Solution with SAP Business Objects 3rd party Azure Cloud Solution Xoserve’s Azure Cloud Solution with SAS analytics and Azure Cloud Power BI reporting 1 2 3 4

Option 1

Description

Data Storage : All the necessary files for data comparison will be provided by Xoserve to vendor in the agreed format and via a secure means. Solution will securely store data in an SFTP which will be uploaded to the Azure platform. These will be stored in flat files and be available for analysis Comparison : A basic repository will be designed and implemented to contain the data to be compared and analysed. Solution will use SAS Data Integration Studio (DIS), on one

• f the Azure Demand Estimation environments solution for comparison exercise

Outputs: The reports for the visualisation of results and deep dive in data will be developed on SAS Visual Analytics.

Timeline Environment High Level Cost Estimate

3 - 4 Months Xoserve’s Azure Cloud Solution £240k - 290k exc VAT

Solution

Reports Analytical Toolsets (SAS DIS) Basic Repository in Azure Cloud UK Link Data Shipper Data

UK Link / BW Data (Selective) Customer Data Files Comparative Algorithms Exception Reporting

• 1. Source Data
• 2. Data Storage
• 3. Comparison
• 4. Outputs
• 5. Integration

Azure Data Factory (ADF)

BW ISU Files

1

Option 2

Description

Data Storage: Extraction tool to be used to extract data from SAP BW and reports will be used for data extraction from SAP ISU into a staging area in Azure SQL Cloud server Comparison : Data processing and reconciliation as part of comparison exercise will use Python for building algorithms Outputs: The reports for the visualisation of results and deep dive in data will be developed on SAP Business Objects.

Timeline Environment High Level Cost Estimate

4 – 5 Months 3rd Party Azure Cloud Solution £330k - 380k exc VAT

Solution

Reports Analytical Toolsets (Azure Cloud) Enterprise Data Storage (Azure SQL - Cloud) UK Link Data Shipper Data

UK Link / BW Data (Selective) Customer Data Files Comparative Algorithms Exception Reporting

• 1. Source Data
• 2. Data Storage
• 3. Comparison
• 4. Outputs
• 5. Integration

Azure Data Factory (ADF) / IQNxt (Data Quality)

BW ISU Files

2

Option 3

Description

Data Storage: Solution will store asset data in both a structured format such as a relational database, and in a raw format in the platform server Comparison : Data processing and reconciliation as part of comparison exercise will use analytical tools in Azure Cloud Outputs: Solution suggested to propose and quote for work that will implement an Enterprise-ready reporting platform tailored to the needs of Xoserve after Comparison exercise is finished.

Timeline Environment High Level Cost Estimate

6.5 – 7.5 months 3rd Party Azure Cloud Solution £640k – 690k exc VAT

Solution

Reports Analytical Toolsets (Azure Cloud) Azure Cloud UK Link Data Shipper Data

UK Link / BW Data (Selective) Customer Data Files Comparative Algorithms Exception Reporting

• 1. Source Data
• 2. Data Storage
• 3. Comparison
• 4. Outputs
• 5. Integration

Azure Data Factory (ADF)

BW ISU Files

3

Option 4

Description

Data Storage: Data storage hosted on Azure will be used to store both UK Link/BW and Shipper Data files. Data storage will be funded on a Pay as you Go basis. Azure will provide scalability in terms of processing power, storage and environments Comparison : The existing SAS Platform (currently support Demanding Estimation) will have a direct connection to the data storage to retrieve data. Base SAS jobs will be used to compare data sets and generate any exceptions based on agreed rules. These jobs will be re-usable and can be scheduled if the Retro POC matures into an enduring solution Outputs: Exception reporting will be generated in the agreed formats to provide detail where data is misaligned. Data can be made available through Azure (OneDrive) to deliver

• utputs to customers.

Solution Timeline Environment High Level Cost Estimate

3 – 4 Months Xoserve’s Azure Cloud Solution £220k - 270k exc VAT

Reports (Azure Cloud) Analytical Toolsets (Azure Cloud) Azure SQL - Cloud UK Link Data Shipper Data

UK Link / BW Data (Selective) Customer Data Files Comparative Algorithms Exception Reporting

• 1. Source Data
• 2. Data Storage
• 3. Comparison
• 4. Outputs
• 5. Integration

Azure Data Factory (ADF) / Azure Data Quality Services

BW ISU Files

4

Assessment criteria with recommended solution

Cost Resource Data Timescales Risk Security Enduring

1

Cost to deliver this change is forecasted to be in the range £240k – £290k Includes forecast for additional cost for procuring SFTP server Dedicated Data team resources required Minimum IS Ops resource required 3rd party supplier resources required for comparison and deep dive exercises As part of this exercise data received and analysed will be stored Xoserve’s cloud platform Delivery timescale of 3 – 4 months Additional re-work required to transition to enduring solution Medium confidence level for delivery Risk of not establishing a SFTP mechanism with in timelines Low security risk assessment required – internal platform already assessed Security risk assessment required on SFTP element Partially aligns with the enduring solution

2

Cost to deliver this change is forecasted to be in the range £330k - £380k Dedicated Data team resources required Minimum IS Ops resource required 3rd party supplier resources required for comparison and deep dive exercises As part of this exercise data received and analysed will be stored 3rd party’s cloud platform Delivery timescale of 4 – 5 months Security full risk assessment will take 3-4 weeks Additional re-work required to transition to enduring solution Low confidence level for delivery Risk of key resources occupied with Class 3 (Mod 700) and

• ther Xoserve commitments

Full security risk assessment required on external hosted platform – would take 3 – 4 weeks Security risk assessment required on SFTP element Does not align with the enduring solution

3

Cost to deliver this change is forecasted to be in the range £640k - £690k Dedicated Data team resources required Minimum IS Ops resource required 3rd party supplier resources required for comparison and deep dive exercises As part of this exercise data received and analysed will be stored 3rd party’s cloud platform Delivery time scale of 6 weeks

• nly for comparison exercise

Additional 4 months to complete activity Security full risk assessment will take 3-4 weeks Additional re-work required to transition to enduring solution Low confidence level for delivery No reporting solution provided as part of firm quoting for proof

• f concept.

Full security risk assessment required on external hosted platform – would take 3 – 4 weeks Security risk assessment required on SFTP element Does not align with the enduring solution

4

Cost to deliver this change is forecasted to be in the range £220k - £270k Dedicated Data team resources required Minimum IS Ops resource required 3rd party supplier resources required for comparison and deep dive exercise As part of this exercise data received and analysed will be stored Xoserve’s cloud platform Delivery timescale of 3 -4 months Less re-work required to transition to enduring solution High confidence level for delivery Creation of data storage is a dependency for Retro proof of concept. Low risk re Security review as internal platform already assessed Low security risk assessment required – internal platform already assessed Aligns with enduring solution

Recommended Solution

Timeline / Cost Overview

Option Timeline High Level Cost Estimate

1 3 – 4 months £240k – 290k exc VAT 2 4 – 5 months £330k - 380k exc VAT 3 6.5 – 7.5 months £640k - 690k exc VAT 4 3 – 4 months £220k - 270k exc VAT

Xoserve Recommended Solution

• 5e. XRN4991 – MOD0700 Status Update

30th September Overall Project RAG Status: Schedule Risks and Issues Cost Re Reso sources RAG Status Status Justification

Schedule

• MOD0700 Implementation was completed on 28th September
• Monitoring of the system post deployment has demonstrated change is operating as expected.
• Outstanding Inner Tolerance changes to be deployed on 19th October on the basis all testing is complete and signed off.

Contingency will be to deploy w/c 21st October.

• Interim MOD0700 reports delivered on 12th October. Changes to Shipper pack and PARR reports to be reflected in November
• Post Implementation Support (PIS) to conclude on 25th October

Risks and Issues

• Risk: There is a risk that the number of Inner Tolerance rejections will increase as a result of this implementation – these

rejections will be monitored and a solution has been identified, but will need to be implemented based on criticality

• Risk: There is a risk that additional funding is required to cover the cost of completing delivery for Inner Tolerance Check and

Reporting; expectation is that this will be covered in the agreed risk margin Cost

• The BER has been presented and approved by ChMC on the 11th Sept

Resources

• Daily stand-up with all areas; resources being understood and prioritized for Inner Tolerance check and Reporting

XRN4991 - MOD0700 Timelines

2019

Aug Sept Oct

SAP - ISU

Key: Completed Slipped / High risk Medium risk On-target

Market Flow Reporting

Design Build & Test (Unit, System, UAT and Regression) PIS Performance Test 11/09: BER Approval GO LIVE 28/09/19 28/08: Change Pack Approval Design Build & Test (Unit & System) PIS UAT and Regression Received from AMT20/09 GO LIVE 28/09/19 Key: dashed line - proposed

today

Inner Tolerance Planning Reporting

• 6. New Change Proposals

For Ratification of the Prioritisation Scores

• 6. New Change Proposals

For Ratification of the Prioritisation Scores

• None for this meeting

• 7. Change Proposal Initial View Representations

• 7. Change Proposal Initial View Representations
• None for this meeting

• 8. Undergoing Solution Options Impact

Assessment Review

• 8. Undergoing Solution Options Impact Assessment

Review

• 8a. XRN4992 - Modification 0687 - Creation of new charge to

recover Last Resort Supply Payments

• 8a. XRN4992 - Modification 0687 Clarification of

Supplier of Last Resort (SoLR) Cost Recovery Process

High Level System Solution Impact Assessment

• 8a. XRN4992 - Modification 0687 Clarification of

Supplier of Last Resort (SoLR) Cost Recovery Process

• Verbal update to be given by Ellie Rogers.

• 9. Solution Options Impact Assessment Review

Completed

• 9. Solution Options Impact Assessment Review

Completed

• 9a. – XRN 4738 - Shipper Portfolio Update of Proposed Formula Year

AQ/SOQ

XRN4738

Shipper portfolio update of proposed Formula Year AQ/SOQ

Overview

• Shippers asked Xoserve to look into options to inform

them of their proposed Formula Year AQ/SOQ values

• nce they have been calculated (in December) before

NRL files are issued in late March

• It has been identified that CoS transactions that take

place between the delivery of the March NRL (that carries the new Formula Year AQ / SOQ) and the 1st April will not contain the new FYAQ.

• As such, a separate mechanism is needed to provide

customers with FYAQ details post NRL.

Proposed Data Items – DSG Actions

• MPRN
• Confirmation Reference Number
• Confirmation Effective Date – to show

it is a gained site.

• AQ
• Customers are requested to

confirm that these data items will suffice and then a high level solution can be presented at the next DSG Meeting due to be held on 4th November.

• Actions:
• Review slides and confirm the report is still required
• Confirm the above data items will meet customer requirements

Proposed Solution - Action

• Report to be generated showing MPRN gains post NRL
• Time period to cover any Confirmation/Re-Confirmations

post generation of NRL files and up to/including 1st April

• Issue date 1st week post 1st April
• Shippers to be target audience of report
• Email delivery mechanism
• Action – confirm all of the above pre-requisites are still

valid

• 10. Miscellaneous

• 10. Miscellaneous
• 10a. Report Review Update

• 10a. Report Review Update
• Verbal update to be provided by Charlie Haley

• 11. JMDG Update

Domestic M-Number Helpline [Gas]

27

Solution overview Use case overview

• Replace the existing method of providing this service with an online solution
• 500k calls per year, used by domestic consumers

JMDG progression Assessed, prioritised and requested project team to provide solution. Phase 1 – Web Portal has been delivered to gas consumers. Consumers can obtain MPRN, Gas Supplier and Transporter name Phase 2 –Enhancement to Web Portal. Key updates include fuzzy matching on searches, more searchable fields and inclusion unregistered sites. Plan Phase 1 was delivered in September 2018. Phase 2 has commenced and is on track to launch on 21st June 2019 Phase 2 was delivered in June 2019. Phase 2 provided enhancements to search and address matching functionality

Analysis Complete LOW RISK MED RISK HIGH RISK

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2018 2019

Delivery Decision Point Delivery Point Use Case No. Indicative delivery

27

Solution overview Use case overview

• Meter asset data on UK Link is not correctly maintained by industry participants
• A reporting service will be provided to compare the MAM / MAP meter point reference number and meter serial number to that held on UK Link

JMDG progression Assessed, prioritised, requested project team to analyse requirements with MAPs

Analysis Complete LOW RISK MED RISK HIGH RISK

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2018 2019

Delivery Decision Point Delivery Point Use Case No. Indicative delivery

06

MAPs - Meter Asset Details [Gas]

06

Phase 1 – MAPs to UKLink meter asset comparison service (Dec ’18) - Completed Phase 2 – MAP to MAP meter asset comparison service (May ‘19) – Completed Phase 3 – Introduction of MAP ID into UKLink (CSSC) – Enduring solution (TBC – would be linked to a UKLink Release schedule)

Overview Use case overview

• Provide data services to Third Parties

JMDG progression Assessed, prioritised, requested project team to conduct initial analysis

Analysis Complete LOW RISK MED RISK HIGH RISK

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2018 2019

Delivery Decision Point Delivery Point Use Case No. Indicative delivery

23

Third Party Services [Twin]

33

• A gas data permissions matrix has been created detailing current industry participants permissions to data
• The data permissions matrix will help highlight potential API services. MOD 649 will help expedite the governance process to provision data new data

services to industry participants while still providing a robust approval process

• MRASCo Board has been establishing precedents for third party access approach, which can supplement the gas matrix
• A Third Party industry engagement approach concluded. Use case identified for Housing Associations (Use Case 60)

Overview Use case overview

• There is an opportunity to create a service where MAPs can query the current and historic Supplier ID for assets installed on a supply meter point

JMDG progression Assessed, prioritised, requested project team to move to delivery

58

MAP API [Gas]

58

• Change Proposal has been raised and sponsored by Colin Blair (MPB Member)
• Project team to provide ChMC feedback to MAPs post meeting to highlight any considerations
• MOD and Data Permission Matrix (DPM) Amendment approved
• Change delivered on 28th June 2019

Analysis Complete LOW RISK MED RISK HIGH RISK

Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept 2018 2019

Delivery Decision Point Delivery Point Use Case No. Indicative delivery

Overview Use case overview

• There is an opportunity to create a service where MAPs can query the current and historic Supplier ID for assets installed on a meter point

JMDG progression Assessed, prioritised, requested project team to move to delivery

59

UKRPA Access to Gas data [Gas]

59

• To ensure consistency with other related parties who have also requested access to gas data for theft investigation, Xoserve are exploring the

strategic approach for this type of request

Analysis Complete LOW RISK MED RISK HIGH RISK

Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept 2018 2019

Delivery Decision Point Delivery Point Use Case No. Indicative delivery

• 12. CSS Update

Switching Programme

The primary CSS Interface design has concluded with the design being approved by Ofgem’s Design

• Authority. Xoserve continue to raise our concerns that the design has concluded without an

appreciation of the end to end technologies, process architecture or supporting business rules. Our concerns continue to be raised at Programme delivery and implementation groups as well as raising Programme risks. Over the past few weeks Xoserve have been reviewing the CSSIP (Core Systems and Services Integration Plan) and the CSSIA (Core System and Services Integration Approach) alongside the MAD log (milestones, assumption and dependencies). These three artefacts have been reviewed alongside each other with a number of queries raised against the CSSIA and the MAD log. Xoserve have accepted these documents with a caveat that our queries will be addressed over the coming weeks. The CSSIA and CSSIP will be presented to Programme Delivery Group for ratification and approval. At this point the programme will move from design to build.

Switching Programme

In relation to Network connectivity Xoserve have consistently raised a number of questions in relation to the requirements. The Network and security workstreams have a dependency on each other and this needs to be taken hand in hand with the primary interface design, we have raised concerns that this approach carries risk and potential change for industry parties. The SI technical data working groups are continuing, these workgroups have been arranged to scope the data migration approach and underlying processes. Workgroups commenced in September and are planned to conclude at the end of October at which point the data migration solution will be taken for approval at the November Ofgem data working group in line with the Programme level 2 milestone L2-26. Xoserve have raised a risk that this design will not be fully scoped in readiness for this date and will impact parties data migration design and build activities. Following DCC’s request via Ofgem for address data from ESP’s (existing service providers) and suppliers, parties are requested to provide data to Landmark by the 18th October. Xoserve are on track to provide this data and have requested via Ofgem a process and understanding of the analysis activities and potential cleansing areas be provided in order for Industry parties to understand required activities and timelines.

Switching Programme

Our Extraordinary CSSC DSG meetings have completed and our first two change packs were released for Industry consultation on the 16th September. These included supply meter point creation and nomination and switching. Consultation has concluded for these change packs, reps have been received and we are currently working through and providing responses. These change packs will be presented at ChMC for approval during this meeting. Our next change packs are due to be released for consultation on the 21st October, these include:

• Settlement data
• Supply meter point updates
• Gemini
• Updated consequential change BRD’s following detailed design conclusion which include updated

To Be Processes

Switching Programme

• Our consequential programme continues with detailed design concluding this month and build

activities continuing to plan. From a testing perspective we continue to work with the SI, Ofgem and PWC. As soon as we have agreed a date for our workgroup I will send out invites. I am aiming to also introduce data discussions and updates alongside testing into this workgroup.

• Xoserve’s website has been updated to provide further information in relation to our Adapter
• service. Please take the time to review this information and if you wish to discuss or have any

enquiries please contact me directly via emma.j.Lyndon@xoserve.com

Funding status

CSSC Funding Status

£0 £5,000,000 £10,000,000 £15,000,000 £20,000,000 £25,000,000

Forecast Estimate to Completion (Forecast) Actual

• 13. DSC Change Management Committee

Update

9th October 2019 meeting

New Change Requests

Xoserve Ref No. Change title Next steps Service area DSC impact

4627 CSS Consequential Central Switching Services Parent CP for CSSC information only N/A N/A 5027 UK Link Data Cleanse of Conversion Factor in line with MOD0681S Approved for Capture 1 Existing service line 5029 Service Description Table updates October 2019 Information only 16 New service line

Change Proposals – Capture complete - None

Xoserve Ref No. Change title Voting Outcome

4627 CSSC - Create Supply Meter Point and Market Sector Code Approved 4627 CSSC - Nomination Enquiry and Registration Deferred N/A Potential EUC Description File Format Description Change Approved N/A Amendments to MRF_TYPE_CODE description field to provide additional clarity Approved

Detailed Design Outcomes – September Change Packs

Change Documents

• BER - Approved
• XRN4980 Change to Supply Point Enquiry API
• XRN5013 Data Access Platform – PAFA
• BER – Deferred
• XRN5003 Data Access Platform - DN Dashboard
• Amended Funding - Approved
• XRN4865 – Amendment to treatment and reporting CYCL reads – 100%

Shipper funded

• CCR - Approved
• XRN4954 Minor Release Drop 5

Summary key messages

• June 20 – XRN4780 (MAP ID) descoped to be delivered

within CSSC. XRN4897 & XRN4899 (Creation of new charge to recover Last Resort Supply Payments) to be added – Solution Change Pack currently out for consultation.

• Update on the Shipper - Data Discovery Platform Drop 2

and the Networks - Data Discovery Platform Drop 1.

• Automation and Optimisation Options for the change

XRN4857 Report Review

• 14. Action Updates

• 14. Action Updates
• The DSG Actions Log will be published on the DSG pages of

Xoserve.com

• 15. AOB

AOB

• 15a. XRN4932 - Improvements to the quality of the Conversion Factor

values held on the Supply Point Register (MOD0681S)

• 14a. XRN4932 - Improvements to the quality of the

Conversion Factor values held on the Supply Point Register (MOD0681S)

Design Considerations

Overview

• UNC Modification 0681S was progressed to give the

CDSP the right to amend the Conversion Factor (CF) at Supply Meter Points (SMP) when certain conditions are met

• XRN4932 was raised to facilitate the change within

CDSP systems and is in scope of June 2020 release

• Detailed Design is ongoing, however 5 design

considerations have been found (so far) that we would like DSG steer on

Design Consideration 1

• As the CDSP needs to notify industry participants (Shippers) of the

need for a CF amendment and give them 30 days to carry out the update themselves, there will be instances where the Supply Meter Point has changed Shipper between the notification being issued and the CDSP attempting to update the CF

• Where these instances occur we have 2 options…

1. Update the CF regardless of any Shipper amendments 2. Only update where we have notified the Registered User (at time

• f CDSP update) of a need to amend the CF
• CDSP has no preferred option, a simpler solution means leaning to
• ption 1 due to not having to carry out an additional check,

however both are doable

Design Consideration 2

• Supply Meter Points across all Class Products are in scope of

MOD0681S rules (excluding sites with Corrector devices installed)

• However, during Detailed Design we have identified that Class

Product 1 & 2 would, where the CDSP has to update the CF, require File Format amendments (additional value in the Reading Indicator field) to facilitate the issuing of estimate readings via MDR file for these Product Classes

• After checking the rules to be applied, 10 sites were identified as

needing a CF amendment (out of 1,600) for Product Class 1 & 2

• CDSP recommendation is to de-scope Product Class 1 & 2 from

automated system CF updates (but still include them in the notification that the CF needs to be looked at)

Design Consideration 3

• Where sites that have been identified as needing CF

amendments and no action has been taken by the Registered Shipper the CDSP will attempt to make the CF amendment via a cosmetic exchange

• If unsuccessful, potentially due to ongoing SPA or RGMA

activities, we are proposing no further action is taken

• Adding in monitoring and reprocessing would add

complexity to the solution and could potentially result in a backlog of CF that keep rejecting

Design Consideration 4

• From a solution perspective, once the notification has been issued and the 30 day

period lapsed the CDSP will check to see if the CF amendment is still needed to be carried out

• One consideration for this is surrounding the AQ threshold that should be checked

against the MOD rules

• As the window is 30 days there could be a scenario where a new AQ is about to go

live when the CDSP comes to do the CF update that could (if the check was done a few days later) resulting in no CF amendment needed

• We are proposing that when we come to check if an update is still needed, we would

carry out this by considering any future AQ’s that are due to go live, not just the current AQ

• Logic for this would be that if the CDSP carried out the CF amendment (via cosmetic

exchange) and then again the following month (as the AQ may have changed) would add in unnecessary asset updates (with CDSP estimate reads) that could restrict future reads from coming, with the risk being increased as RGMA readings cannot be replaced and also restrict potential valid RGMA updates from happening prior to the CDSP cosmetic exchange

Design Consideration 5

• Legal text states that a notification needs to go out to the

registered user informing them of any action taken by the CDSP

• Current solution to facilitate this and to reduce the impact
• n customers, is to use the MBR file containing

estimated FINX/OPNX reads for the cosmetic exchange along with the old and new Conversion Factor (Class 3 & 4)

• Do DSG feel this will be sufficient notification that the

CDSP has carried out the activity on their behalf?