ReportVIEW Case Study - Plover Wastewater
SUMMARY
Facility managers are faced with a need to cope with automated process data, laboratory data, industrial discharge data, energy management, regulatory reporting and numerous other data management applications. Database technology has been defined as the best available technology for managing this data. ReportVIEW provides a rapid application development tool set allowing the technology to be employed while minimizing software, development, and training costs.
The City of Plover Wastewater Utility has a fully developed ReportVIEW facility management application. The system imports statistically reduced process, maintenance and energy data from SCADA to a central SQL database on an hourly basis. The SCADA import includes data from the plant and from remote pumping stations. Laboratory information is collected both automatically from instrumentation and manually entered into laboratory bench sheets. At Plover ReportVIEW is configured with electronic bench sheet forms for use in the lab allowing both calculated results and quality control functions to be automated and saved to the facility database. Plant operators also enter manually observations into the facility data base. Trucked waste receiving and industrial wastewater discharger data are additional applications that are managed in the same facility management database.
The ReportVIEW application is accessible from a number of computers on the local area network. The manager has configured report templates for process, laboratory quality control, energy management, predictive maintenance, regulatory reporting and a number of other applications. The database solution uses the best available technology to help manage all facility data management needs in the common SQL database. This data base is also a powerful engineering analysis tool as it holds many years of time-series historical data available for instantaneous analysis.