Pollution Prevention Successes Database (P2SDb) user guide

Abstract

When Pollution Prevention Opportunity Assessments (P2OAs) were launched at the Hanford Site during the summer of 1994, the first comment received from those using them expressed the desire for a method to report assessments electronically. As a temporary measure, macros were developed for use on word processing systems, but a more formal database was obviously needed. Additionally, increased DOE and Washington state reporting requirements for pollution prevention suggested that a database system would streamline the reporting process. The Pollution Prevention Group of Westinghouse Hanford Company (WHC) contracted with the Data Automation Engineering Department from ICF Kaiser Hanford Company (ICFKH) to develop the system. The scope was to develop a database that will track P2OAs conducted by the facilities and contractors at the Hanford Site. It will also track pollution prevention accomplishments that are not the result of P2OAs and document a portion of the Process Waste Assessments conducted in the past. To accommodate the above criteria, yet complete the system in a timely manner, the Pollution Prevention Successes Database (P2SDb) is being implemented in three phases. The first phase will automate the worksheets to provide both input and output of the data associated with the worksheets. The second phase will automate standard summary reports and ad hoc reports. The third phase will provide automated searching of the database to facilitate the sharing of pollution prevention experiences among various users. This User`s Guide addresses only the Phase 1 system.