DSG CSS Consequential Change 22 nd January 2019 Agenda Actions - PowerPoint PPT Presentation

DSG CSS Consequential Change 22 nd January 2019

Agenda • Actions from previous meeting • Gemini • Topics for finalisation: – Meter Readings at Transfer – Management of Market Participant Data – Management of MAP Id against Supply Meter Point – High level design options • New Topics for discussion: – SPA Updates – RGMA – Meter Sector Code – Meter Point Creation – Meter Point Status • Data Cleansing Update • Customer road map

CSS Consequential – Gemini High Level System Solution Impact Assessment

Existing Switch can be requested Switch Goes anytime between D-5 and D - Live with status Process 30 Switch is secured with LI @00:00:00 status CO @00:00:00 on D-2 D-2 D-1 D D+1 06:00 -> ACT_Number Job – UKLINK Batch runs at • Allocation 10 mins 10 / 11 AM To generate unique id for new Run – Xoserve meter id combination received Confirmed NDM/UIG in MDS MDS & AAQ File is • Nomination CON File generated and sent to 11:00 -> Demand position Processing Gemini Estimation & UIG suite of (run till job run close out) File Upload program Generate the nominations for ‘D’ day is run & entries stored in DB Cyclic Job runs every 2/3 Maintenance Window – 3 AM to 5 AM hours to reflect actual MDS / AAQ positions based on shipper nomination for DM sites values Customers Finalise Gas nomination Commence Gas Nomination position Gas Nomination ID submission for D Finalise gas purchases received from UK Link View initial gas allocation Revised gas allocation & UIG position & UIG portion portion

Switch can be requested anytime between D-1 and D - POST CSS Switch Goes Live 28 Switch is secured @17:00:00 @00:00:00 on D-1 D-1 D D+1 • Owing to CSS, if the file generation is moved to D-1, consideration is 17:30* -> CSS sends the confirmed information will be received by 17:30 position at 17:00 • SAP ISU could take c1.5 hours to Entries made in trigger table update custom tables and generate Batch run to generate consolidated • MDS/AAQ files Allocation MDS/AQQ file • Gemini will then need to schedule Run – ACT_NUMBER job on receipt of Xoserve NDM/UIG MDS/AAQ file Confirmed • Run the Demand Estimation and UIG • 20:00* -> ACT_Number Job – 10 CON File Nomination suite of jobs mins Processing position • Considering concurrency with other To generate unique id for new meter id (run till jobs (which has potential to overrun as combination received in MDS well), infrastructure capacity needs to close out) be assessed • 10% increase in ‘To - Be’ volumes has been considered for MDS/AAQ 20:15* -> Demand & UIG suit of job process run – 45 to 50 min • Impacts to external stakeholder Maintenance Window – 3 AM to 5 AM Generate the nominations for ‘D’ day unknown at this stage Will Reflect actual positions based on shipper nomination for DM Gas Nomination ID received from UK Customers Finalise Gas nomination Link from ~20:00 hours position Commence Gas Nomination submission Finalise gas purchases • All timings are indicative and for D Revised gas allocation & UIG need further analysis View initial gas allocation position & UIG portion portion after 20:15 hours

Change Overview CSS Consequential – Gemini Currently Gemini receives all the Portfolio updates on D-2 from SAP ISU on a daily basis via MDS/AAQ files. As part of this change, Gemini will receive the changes for switching data effective on D day on D-1 evening post CSS gate closure. Solution Options 1 Gemini to receive Portfolio updates on D-2 and D-1 for effective D day 2 Gemini to receive Portfolio updates on D-1 for effective D day

Gemini : As-Is Design Current Functionality : Gemini • Gemini receives all the Portfolio updates based on the below triggers on D-2 with effective date as D day from SAP ISU on a daily basis via MDS/AAQ files - o Class Change o AQ-Correction o SOQ Change Through Contract Change o Withdrawal Process o Isolation o Registration Process o Address Change (CMS) o Post Code Change Through Internal Screens o Site Takeover Process o EUC Change o SMP AQ Monthly Calculations o RATCHET o SOLR o Reconnection o SMP Exit Zone change for IGT site • The NTS / LDZ Unique sites are been manually created by Business (received as Worki tem from SAP ISU) via online screen on D-2 (Business days). • Activity Number for active DM meter types are created by Shipper via online screen or system generated. • Shipper do place DM nominations within a window i.e. D-35 05:00 to D-1 12:00 for gas flow D day via online screen / API / interfaces. • Activity Number for NDM / UG meter types are created by the system on D-1 06:00 • DM Nomination are being estimated on D-1 at 08:00 for active DM meter ids in case they are not present in the system. • Shipper can re-nominate for DM meter types within a window D-1 14:00 to D 04:59. • NDM / UG Nominations for D and D+1 are been calculated in the system using the AQ values, DM Nominations and Weather values • Gemini sends the data to internal & NG systems on scheduled times on a daily basis.

1 Option 1 – Gemini to receive Portfolio updates on D-2 and D-1 for effective D day Triggers for Triggers for Process on D-2 Process on D-1 Changes on D-2 Changes on D-1 Class Change Registration process System Generates Activity numbers AQ- Correction [DM/ NDM /UG Meters] Withdrawal process System Generates Activity numbers [DM/ NDM /UG Meters] SOQ Change through Contract Change Isolation Shippers can nominate / re-nominate for Address Change DM meters on D-2 for any new / existing meter id for the ones triggered as part of Post Code Change through D-2 updates. Internal screen Estimation will run for the missing DM Re-Nomination for the active Site Takeover Process meter id EUC Change In case of no DM Nomination for any active meter id, the estimation will run on D-1 at 800 hour bar for the NDM / UG SMP AQ Monthly calculation nomination process Ratchet SOLR The NDM / UG Nomination run for D day will be triggered on D-1 as The NDM / UG Nomination run for D day in with the data present in the Reconnection will be triggered on D-1 as in with the system data present in the system SMP Exit Zone change for IGT site

Option 1 - High Level Impact Assessment 1 Impacted Systems Assumptions • MDS/AAQ files needs to be received and loaded before D-1 midnight, however a Gemini Impact tool will be built to correct the data. • No scheduling changes will be made for NDM & UG Nomination / Allocation / Invoicing suite Marketflow SAP PO CMS SAP ISU • No changes required in pre / post closeout processes in Gemini • For Gas Year change, MDS/AAQ files will API SAP BW DES be loaded on D-2 and any changes can be updated on D-1 • Last Sync message will be received from CSS by 6:00 pm Pros Cons DM Nominations will be applicable for 13 triggers Technically complex for Gemini to handle 2 files loading D+1 and D updates received on D-2 updates within its timelines sequentially on D-1 Incorrect mapping will be present for Future dates i.e. D+1 while D will contain the corrected record which will leads to incorrect NDM/UG Nominations Overall Impact Medium

Option 1 - System Impact Assessment 1 Gemini SAP ISU System Component: Process Code Process Code Development Type: Code Change / Code Change Scheduling Impacted User(s): Shippers Gemini Build Type: Existing Existing System will be amended to load the Change Description: Code Changes will D-2 and D-1 updates be done to send the in Gemini followed 13 triggered on D-2 by creation of activity and rest 2 in D-1. number and estimation process. Requirement Clarity: Change Complexity: A A A A Integration Complexity: G G Test Data Prep Complexity: G G A A Test Execution: A A Regression Testing Impact: A A Performance Impact:

Option 1 - Process Impact Assessment 1 File External Batch Performance Process Area Complexity Exception Formats Screens Jobs Test? Meter Details M N n/a N Y Y Nomination / Re- M N n/a N N Y nomination Gas Trades n/a n/a n/a n/a n/a n/a Measurements n/a n/a n/a n/a n/a N Allocation n/a n/a n/a n/a n/a Y Invoicing n/a n/a n/a n/a n/a Y Interfaces M N n/a n/a Y Y External System M N n/a n/a N Y API n/a n/a n/a n/a n/a N

Option 2 – Gemini to receive Portfolio updates on D-1 for effective D day 2 Triggers for Changes on D-1 Process on D-1 Class Change AQ- Correction System Generates Activity numbers [DM/ NDM /UG Meters] SOQ Change through Contract Change Isolation Address Change Post Code Change through Internal screen Estimation will run for the missing DM Site Takeover Process Re-Nomination for the active meter id EUC Change SMP AQ Monthly calculation Ratchet SOLR Reconnection NDM / UG Nomination run for D day will be triggered on D-1 as in with the data SMP Exit Zone change for IGT site present in the system Registration process Withdrawal process