The deliverable from this project would be an NJEMS-based module that enables water enforcement supervisors to track all inspection assignments for inspections and has the functionality to assign/re-assign inspections.

Data query/flow: Build a data query/flow that brings together all water resource management permits that require inspection by the DWE (coming from the NJPDES and Safe Drinking Water programs). This would include the NJPDES permit universe and the Safe Drinking Water Act universe.  At a minimum, this query would include each facility’s PI, Permit Number (or other unique identifying code), Facility Name, County, Municipality, Address, Permit Code (such as ‘A’ for a NJPDES DSW permit), Permit Category (NJPDES, Water Supply).

Centralize data: Using the data query/flow that aggregates all water enforcement data, build a module within NJEMS to enable water enforcement supervisors to:

• Display the aggregated list of DWE permits to be inspected and append the following fields to it.

• Update the “last inspected field” automatically when an inspection is locked in that permit in NJEMS.

• Track all inspection assignments and frequencies at which they must be inspected.

• Assign/re-assign inspections in one spot. Unit supervisors (A/B/C/D) should have the ability to see in one screen the number of people in their unit and their respective assignment loads (in terms of how many workplan hours and number of inspections of each permit type assigned).

• Calculate number of people needed for inspections.

• Determine which inspections have been signed off on, and the total number of hours it took for the inspection.

Interface: This would be comprised of the same functionality as was built for the Air inspect tool.

Data relationships: In addition to the permit inspection assignment functionality that constitutes the core of this project, DWE is also looking for an interface expansion that would provide the ability to interact with permits in a relational manner. Some PIs have only one permit. Others have dozens. An example of this are the many agricultural operations across the State that DWE inspects, each with many well permits and NJPDES discharge permits. Providing a simple interface where all permits with the same PI or other common denominator (such as a Farm ID) would be monumental for DWE supervisors and staff, who routinely spend hours clicking through NJEMS to obtain all pertinent permit information for a single PI. When developing a solution, a strategy of how to relate this information so that it can be stored and retrieved efficiently must be considered.

(2)    Reports: There will need to be both canned and dynamic (query variables dependent on what user chooses from drop-down menus or enters into text/date fields, etc.) reports and summarizations developed.