Skip to main content

Case Study: PACS 2000 Pretreatment Information Management System at the Cincinnati MSD

Buy Article:

$9.50 plus tax (Refund Policy)

Or sign up for a free trial

The Metropolitan Sewer District of Greater Cincinnati ( has implemented a significant upgrade to its Industrial Pretreatment Information Management System (PIMS). This Oracle based system is both comprehensive for pretreatment activities and able to interact with the District's LIMS and enterprise applications such as GIS.

This presentation will: 1) chronicle (a) the District's journey from a paper-based system to the current Oracle based system, (b) the installation phase of data migration and configuration, (c) the start-up phase; 2) demonstrate (a) the work order scheduling of monitoring, (b) reports and correspondence, (c) the LIMS interface and the compliance evaluation of laboratory results; 3) forecast (a) the positive impact of implementing workflow using the systems ‘Task-on-statuschange’ feature, and (b) the integration of enterprise applications.

The District's pretreatment program began with a consultant's study in 1981 using a mainframe database. After Ohio EPA approval in 1986 the District began tracking industrial monitoring, permitting and compliance on paper. In 1988, a single IBM 286 PC using a Lotus 123 spreadsheet was purchased and used for this purpose. By 1990, the US EPA's free database software PCME was used on a Token-ring Novell network. In 1993, an extensive and expensive custom-built oracle based PIMS was rolled out. However, spreadsheets persisted and by 1997 a functional substitute was constructed in MS Access 2.0 by the users. In 2001, the District purchased the PACS 2000 PIMS system from enfoTech and Consulting, Inc of New Jersey (

Multiple silos of data existed in the District's pretreatment program and installation required cooperation of the data owners, cleansing of bad data, enhancing of poor data, and mapping the resulting data set for migration into the new database. Many sets of configuration data were needed to fill in the drop down lists (pick lists) in the PACS 2000 system. Reference tasks, specific to the District, were needed for the work order based monitoring schedule. Start-up presented challenges both to the users and designers with a heavy emphasis on screen navigation.

The PACS 2000 PIMS will be demonstrated using a copy of the database as used just prior to this presentation. The key features of scheduling of monitoring, tracking samples from empty bottles to certified LIMS output, through compliance evaluation and applicable enforcement.

In conclusion, the presentation will address progress in implementing workflow using the ‘taskon- status-change (planned, scheduled, complete, incomplete, rescheduled, passed, failed, cancel)’. As time permits, a brief discussion of integration with enterprise applications would be appropriate particularly concerning the Cincinnati Area Geographic Information System (CAGIS), which represents a significant public investment in enterprise wide data integration.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Data/Media
No Metrics

Document Type: Research Article

Publication date: 2003-01-01

More about this publication?
  • Proceedings of the Water Environment Federation is an archive of papers published in the proceedings of the annual Water Environment Federation® Technical Exhibition and Conference (WEFTEC® ) and specialty conferences held since the year 2000. These proceedings are not peer reviewed.

    A subscription to the Proceedings of the Water Environment Federation includes access to most papers presented at the annual WEF Technical Exhibition and Conference (WEFTEC) and other conferences held since 2000. Subscription access begins 12 months after the event and is valid for 12 months from month of purchase. A subscription to the Proceedings of the Water Environment Federation is included in Water Environment Federation (WEF) membership.

    WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access. Access begins 12 months after the conference or event
  • Subscribe to this Title
  • Membership Information
  • About WEF Proceedings
  • WEFTEC Conference Information
  • Learn about the many other WEF member benefits and join today
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free trial content
Cookie Policy
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more