Risk Assessment Tool Matt Bower Operations Team Leader March 2019 - PowerPoint PPT Presentation

Risk Assessment Tool Matt Bower Operations Team Leader March 2019

Background - Risk is important

Background - Risk is important So is water testing…..

Background - Risk is important But sampling only tells us about quality at a point in time

Background - Risk is important

So why the tool?

So why the tool? • Consistent approach across Scotland • More flexible, relevant RA • Enable DWQR to better support RA • Opportunity to record digitally • Improve functionality – Registration, Mapping, Storage, Water Safety Plan

How did we get here? • Jan 2018 commenced project • 3 stages of user consultation • Sept 2018 6 2-day training workshops • Dec 2018 “sandpit” phase • Jan 2019 system goes live

What does it look like?

What does • User Management it look like? • Local Authority Front Page • Supply Front Page • Supply Register • Supply Risk Assessment • Four Export Formats

Register Supply Generate Risk Assessment Submit RA 5yr Review

Fulfils requirements of regulations Tells system how many sources, tanks, properties etc. Register Enables supply to be mapped Supply Generate Risk Assessment Submit RA 5yr Review

Each RA is created to match the supply Flexible to enable supply details to be modified Ability to choose treatment processes (centralised and property specific) Register Supply Generate Risk Assessment Submit RA 5yr Review

22 Risk Sections Ensures RA to EN 15975 – Revise risk score to account for control measures All sections need to be completed before it will submit Register Supply Generate Risk Assessment Submit RA 5yr Review

Each RA needs full review every five years Straightforward - Can clone previous RA Provides lasting record of supply and risk profile Register Supply Generate Risk Assessment Submit RA 5yr Review

DWQR Hopes New RA tool should be used for new / reviewed RAs • Phased approach, not a “Big Bang” – don’t stop risk assessing! • Ultimate aim to have all Regulated PWS on tool • Detailed implementation approach is up to LA • LA decision whether to register Exempt supplies • Some details (e.g. properties) may need to be refined over time • Drinking Water Safety Plan output will be useful in driving improvements & ownership

Some Stats Users on system PWS registered Risk assessments started

Tips Map Unable to Missing Risk Submit RA Sections • Item plotting off Cornwall • Check all • Go to edit • Check grid ref. sections supply and complete ensure relevant part is • Look for blue complete bar against section and question

Issues Bulk Data Address Adding Upload Look-up Sections • Unable to • Postcode not • Where RA edit / add found originally sections created without • Duplicates • C.Treatment • D + Mgt

Issues Bulk Data Address Adding Upload Look-up Sections • Unable to • Postcode not • Where RA edit / add found originally sections created without • Duplicates • C.Treatment • D + Mgt

Issues Bulk Data Address Adding Upload Look-up Sections • Unable to • Postcode not • Where RA edit / add found originally sections created without • Duplicates • C.Treatment • D + Mgt

The Future….. Quick Hits • Add delete function (RA’s & Assets) • Improve front page clarity • Ability for LA to report on supplies on register • Make RA question process slicker

The Future….. Longer term • Enhance mapping • Enhanced reporting • Database querying • Ability to include actions against each risk • Property look up from UPRN (?)

Thank You Queries / Problems? privatewatersupplies@gov.scot