IPTD-370
Water Distribution System Deficit/Surplus Evaluation
Description
New Subject Item (SI) Details Window: Develop a new SI window to view deficit-surplus data. Note that the screen has four tabs with the focus on opening on the “Evaluation” tab. Below is a potential mockup screen example of what BWSE envisions.
A) This screen should be built as a PEGA window not an old NJEMS screen.
B) Please reference the detailed design document “Deficit Surplus design_12-01.docx” that will explain how the multi-tab screen is to function. As per that document this screen has data entry fields and auto calculated (contingent on the functions being written and added to the NJEMS reference table) fields.
C) It is essential that none of the functions associated with this screen are hard coded into the screen. They should be linked via a NJEMS reference table.
-
Replicate data/fields: The new SI shall display all the same fields that the current MS Excel file displays.
-
Auto Calculated Field: An auto calculated field shall exists that is populated based on a function/procedure for evaluating the deficit/surplus calculation.
-
Nightly Cycle: The auto calculated field shall be updated daily via a nightly cycle.
-
Data Miner Reports: Through the website, link Data Miner Reports to the deficit-surplus data within NJEMS to provide real-time data results rather than period posting of the MS Excel file.
Project Justification
There are approximately 600+ public community water systems. The smaller systems require a few minutes and larger systems require close to an hour. On average, we spend 15 minutes per system.
Time to update all systems = 600 x 0.25 (15 minutes) = 150 hours.
We have to update our DSTs every quarter.
Total time for a year = 150 x 4 = 600 hours.
Draft design received 10/3 with feedback due to CGI by 10/18/24. Draft design attached
OMB didn’t sign off on procurement package prior to quote date expiring. Upon getting new quotes, an additional 1% increase occurred. The latest quote is attached. This also means that the procurement package that was submitted contains an outdated quote because the package was submitted prior to the Dell 1% increase.
Procurement package sent to B&F on 1/29/24.
SOW Part 1 procurement package containing projects IPTD 335 - Licensed Operator Application RSP Service, IPTD 336 - Licensed Operator Training Hours RSP Service and IPTD 370 - Water Distribution System Evaluation have been sent to Division’s finance lead for processing. They have been alerted to the urgency to move this through as fast as possible due to the multiple agency reviews/signatures that are required.
ARInspect SOW (Part 1) - attached - sent to T-3121 Resellers for quotes on 12/20/2023. Part 1 SOW is for
8/24/2023 CGI Estimate $227,140 - $261,211(see attached)
Meeting with program scheduled for 8/22/23 to go over details.