• Improvements on the existing underground storage tank (UST) were completed in fiscal year 2020. • Improvements to the odor scrubbers were completed in fiscal year 2020. • Tertiary filter and meter station SCADA integration upgrades for 50 valves were completed in the fiscal year 2020. • Integration of additional aeration basin mixers into the SCADA system is anticipated to be completed in fiscal year 2021. • Installation of nitrate analyzers and flow meters in each aeration basin, as Phase I of efforts to improve control of methanol addition and nitrogen removal in the basins, completed in fiscal year 2020. • Planning for Phase II of the automated methanol closing program, which will improve control of methanol addition and nitrogen removal in the basins, is expected to be complete in fiscal year 2021. • Planning for concrete rehabilitation, baffle wall repairs and modifications to Aeration Basin No. 1 are anticipated to complete in fiscal year 2021. • Information Technology • Upgrade of the Customer Information System (CIS-Cayenta) was completed in fiscal year 2019. • Upgrade of the JD Edwards financial system was completed in fiscal year 2020. • Phase II replacement of the Computerized Maintenance Management System (CMMS-Hansen) was completed in fiscal year 2020. The project provides for increased operational efficiencies and enables the migration of hardware and operating system to a Microsoft platform. • Development of a database to house the vertical asset registry was completed in fiscal year 2019. Buildout of the vertical asset database is underway. The project is estimated for completion in fiscal year 2023. The project will provide an inventory of above ground facilities to track work performed on assets within the CMMS Cityworks application. • Replacement of the SCADA equipment monitoring system is currently underway, with functionality enhancements that allow for increased reliability to customers, automation of existing manual processes, increased security and real- time monitoring, and increased use of smart phone and other enhancements to SCADA controls by field personnel. The project is estimated for completion in fiscal year 2022. • Procurement and implementation of SCADAWatch analytical software was completed in fiscal year 2019. The project enhanced the reporting capabilities of the SCADA application by providing access to SCADA data for reporting and analysis and allow the water hydraulic model to be calibrated/validated with near-real time data. • Update of the sewer hydraulic model to an all-pipes model was completed in 2019. Desktop calibration of the sewer model was completed in fiscal year 2020. • Implementation of the Dell Boomi integration platform, which allows for the efficient exchange of information between business systems, was completed in fiscal year 2019. • Deployment of Tableau visualization software, which allows for the creation of custom designed interactive user dashboards, was completed in fiscal year 2019. • Design and deployment of two business analytics dashboards were completed in fiscal year 2019. This project provides at-a-glance customer and financial information within an interactive graphical user interface. • Deployment of a mobile device management solution was completed in fiscal year 2019. The application allows the Information Technology Department to monitor, manage, and secure employees’ mobile devices remotely from a single portal. In addition to the capital projects mentioned, residential and commercial development activity continues throughout Prince William County. Cooperative efforts with developers have led to the design and developer-funded construction of major interceptor sewers, sewage pumping stations, water transmission lines and associated infrastructure. In fiscal years 2020 and 2019, developers installed and conveyed to the Authority for ownership and operation approximately 27 miles and 41 miles, respectively, of additional water mains, sanitary sewers, and related infrastructure representing approximately $13.9 million and $27.1 million, respectively, in total value. In fiscal year 2020, 464 development plans representing 1,285 residential units and 3.8 million square feet of commercial development were reviewed, and over 34 miles of water and sewer mains were inspected. In fiscal year 2019, 452 development plans representing 916 residential units and 5.9 million square feet of commercial development were reviewed, and over 24 miles of water and sewer mains were inspected. MANAGEMENT’S DISCUSSION AND ANALY SIS FINANCIAL SECTION 27
Prince William County Service Authority | 4 County Complex Court Woodbridge, VA 22192