Highlights of SDWIS Modernization System Updates

DMUC 2020 - SDWIS Modernization September 15, 2020 Michael Plastino Tina Chen Justin Wright Renee Morris Deric Teasley

Overview SDWIS Team Updates Highlights since the July 2019 DMUC SDWIS Modernization - Highlights and Upcoming Plans SDWIS Modernization System SDWIS State Compliance Monitoring Data Portal 2

SDWIS Team Updates SDWIS Modernization System - Tina Chen, Percy Addo, Justin Wright Pilot Updating of Data Entry Instructions (GWR) Percy Addo SDWIS State Justin Wright, Renee Morris CMDP Deric Teasley, Trang Le, Towana Dorsey (BPA Trang Le) SDWIS Fed, Data Quality / Analyses Renee Morris, Chandler Klawitter SDWIS Fed Coordinator, DMAC Co-Chair Justin Wright Locational Data Access / Quality Assurance Towana Dorsey SRF Data System Roger Howard, Renee Morris ARCS, UIC Data Application Roger Howard DWPD IT Mission Support Contract Renee Morris, Roger Howard 3

Highlights since July 2019 DMUC July 19 through Jan 20 SDWIS Tech Stat Meetings, E-Enterprise Leadership Council SDWIS Prime / BRE Technical Assessment SDWIS State 3.4 Feb 20 through Now SDWIS Modernization Board Alternatives Analysis CMDP contract support transition from Attain to Systalex CMDP improvements, transition of new agencies to Production 4

SDWIS Modernization System Highlights since June 25 Alternatives Analysis Community Update July 31 - State Board Members recommended Option 2, centralized cloud hosted system with outyears option for states to procure supplemental hosting of state specific User Interface and/or Database features August EPA Office of Water / Office of Mission Support conducted supplemental risk assessments (schedule, costs, delivery assurance, ) 5

SDWIS Modernization System Highlights from September 9th SDWIS Modernization Board meeting Parallel Path for SDWIS support for Lead and Copper Rule Revisions (LCRR) Short term basic support in SDWIS State Longer term support in SDWIS Modernization System EPA agreement with State Board Members recommendation for EPA to provide a centrally hosted system More information gathering to determine if COTS (Commercial Off The Shelf) software or EPA contractor custom developed software is best for providing the system 6

SDWIS Modernization System Integrated Project Team (OW, OMS) preparing a COTS (Commercial Off The Shelf) RFI package, with Board input Package will include key requirements documents Plan to release the RFI in late October/early November 2020 timeframe Community updates will be provided via EPA s All Things SDWIS calls Concurrent w/ RFI, DWPD IT Mission Support Contract RFP will occur Contract cover O&M, development, user support for slide 3 suite of systems Optional SDWIS Modernization System development task (using same requirements documents as the RFI) 7

SDWIS Modernization System Other upcoming SDWIS Modernization System prep activities Update Board Charter / Establish Governance Discuss SDWIS Prime Lessons Learned -> Recommendations for SDWIS Modernization System Requirements review / validation Pilot updating of Data Entry Instructions (GWR) 8

QUESTIONS? MICHAEL PLASTINO TINA CHEN

SDWIS State: Update to 3.4 Update for security purposes completed in January was smooth and successful On time and on budget Testing by two states and one EPA region Also improved the performance of SDWIS State 19 Primacy Agencies in 3.4 Adoption issues minor: related to state hosting environment Contact & adoption tracking sheet

SDWIS State: SDWIS Bridge Previously known as GWRBridge, but will be altered to accommodate LCRR. Working name SDWIS Bridge Required update due to Flash retirement Update has been going well so far: on track to be completed and tested by end of CY2020 11

Implementation Plan for LCRR The Implementation Plan will consist of the following major components: 1. Review of the final LCRR 2. Create Data Entry Instructions 3. Detailed SDWIS Suite requirements gathering using final rule and DEI and completion of detailed requirements spreadsheet 4. For each application in SDWIS Suite to be updated the process will include the following: o Development o Internal Testing o User Testing o Implementation and training, including development of user guides

SDWIS Suite updates for LCRR SDWIS State Store any additional data elements required to be reported: Inventory (including Lead Service Lines) Event schedule activities Samples Violations SDWIS State to perform the necessary compliance determinations based on the LCRR and the DEI. SDWIS State to generate the new/updated violations using either existing SDWIS State compliance determination processes, or by using database stored procedures in conjunction with existing compliance determination processes. SDWIS Bridge Functionality to allow users to manage candidate compliance records for LCRR Functionality to allow users to better manage Compliance Schedule/Compliance Schedule Activities for all rules 13

SDWIS Suite updates for LCRR cont SDWIS Drinking Water Watch (DWW) Pages specific to LCRR to provide rule specific content for transparency and usability Consumer Confidence Report (CCR) generation SDWIS Compliance Monitoring Data Portal (CMDP) Additional data reporting related to samples and sample results Water Quality Parameter reporting to include any new components specified by LCRR or DEI SDWIS FedRep Extraction component to extract new/changed data elements Validation component to meet new data reporting requirements, including additional edit checks necessary for SDWIS-Free source data Update upload component to ensure new required reporting elements are successfully reported to SDWIS ODS Address known issues 14

SDWIS Suite updates for LCRR cont SDWIS ODS water systems utilizing the three-year domain SDWIS ODS to receive new required reporting data SDWIS ODS Extract to include LCRR data elements Modify Total Replacement Process of Inventory and Actions with regards SDWIS Federal Data Warehouse (SFDW) SFDW to extract and import new required reporting data Appropriate reports/matrices to include the new LCRR data 15

QUESTIONS? JUSTIN WRIGHT RENEE MORRIS

Compliance Monitoring Data Portal (CMDP) Welcome Aboard! South Carolina Indiana Virginia Region 3 (DC) Region 8 Wyoming 17

16 Primacy Agencies in Production Over 270 Labs and Water Systems Represented At least 5 Regional / National Labs Represent Multiple Primacy Agencies CMDP - Stats 8 CMDP Releases Over the Past Year UAT / Power User's Group 18

CMDP Improvements Year in Review Approve, Promote, Reject and Remove Multiple Jobs Validation Improvements Retaining Trailing Zeros (Significant Digits) Operational Data Available via Web Services and the Data Synchronization Engine (DSE) Theme Update to Improve Look and Feel DSE Configuration Wizard 19

Further Shared CROMERR Services (SCS) Integration Improvements View Only Role CMDP Development Roadmap Improved Ability to Track Organizational Changes Retraction of Certified Samples Composite Samples Improvements Monthly Operating Reports (MORs) 20

QUESTIONS? CMDP HELP CENTER (HTTPS://CMDP.ZENDESK.COM/HC/EN-US) DERIC TEASLEY TRANG LE TOWANA DORSEY