The IWOWSS pull-down menu is the gateway to the majority of data stored in IWOWSS. The bulk of the data within the IWOWSS database can be accessed at the IWOWSS pull-down. The following table is a fully expanded depiction of this menu.

IWOWSS is designed to assist the environmental professional at each Installation in the operation and maintenance of OWS and industrial wastewater issues. Several analysis tools are available to the user to assist in the analysis and resolution of industrial wastewater and OWS problems. These include: (1) viewing of OWS and/or facility diagrams, (2) analysis, comparison, and summarization of IWOWSS data, and (3) identification of pollutant types, sources, and quantities. Each of these analysis methods is discussed below.

Electronic diagrams that depict both plan and cross-section views of each OWS in the database can be viewed through IWOWSS. Diagrams depicting the location of the sanitary sewer line (and any associated OWS) relative to each facility are also available. This capability allows the user to quickly view OWS details as well as to easily locate OWS in the field. In addition, copies of the sanitary sewer map are available for locating specific sewer lines, OWS, and buildings relative to other Installation buildings and landmarks.

The IWOWSS database contains data related to processes and the pollutants generated by these processes at each shop in each facility on the Installation. This data may need to be summarized, compared, or analyzed to satisfy any number of requests or analyses that the Installation or Command may wish to perform.

Individual statistics related to each OWS and/or each shop can be easily viewed directly through the IWOWSS data screens. More complicated analyses can be performed through the custom adhoc report writer, which allows the user to develop reports of any data in the database. Several examples are discussed below:

Regardless of whether or not it flows to an OWS, any pollutant generated on the Installation that enters the sanitary sewer system and ultimately reaches the wastewater treatment plant can be summarized through IWOWSS. For example, if chromium wastes have been identified as a problem pollutant at the WWTP, the sources and quantities of chromium generated at each facility on the Installation can be summarized in a custom report. The report would include each shop and facility which generated a chromium waste, the process and products used which generated the waste, the quantity generated per day, the name of the person in charge of the process, and his/her phone number. By utilizing this report, Installation personnel can quickly identify the source(s) of problem pollutants and begin to take steps to eliminate these wastes through pollution prevention methods.

IWOWSS has several reporting features, which may be used to obtain data from within the database. These include (1) standards reports, which merely output the data on each screen, and (2) custom reports, which can be created for any number of analysis and/or reporting requirements.

Both the standard and custom reporting features of IWOWSS can be used to report facility and OWS-specific statistics. The standard reports allow the user to output data from a specific data screen for one or a collection of facilities and/or OWS. The custom reporting features of the IWOWSS adhoc report writer allow the user to develop reports from any field within the database. After data items are selected, they can be filtered, grouped, summarized, graphed, and reported in an infinite number of ways. A collection of mathematical functions can also be performed to assist in any statistical analyses.

The adhoc report writer allows the user to develop custom forms from within the database. These forms are typically developed to satisfy repetitive reporting requirements for data contained in the database. Once developed, the forms can be generated as frequently as needed. For example, many installations must periodically report wastewater sampling results to regulatory authorities to satisfy NPDES discharge monitoring report (DMR) requirements. To minimize time in completing this report, the DMR form could be created in the adhoc report writer and, if the sampling data is maintained, the form could be populated automatically from the database, printed out, and mailed to the regulatory authority. With the data in IWOWSS, the user would also be able to perform analyses of the sampling data as discussed previously.

Installations which have a small number of separators may not have the need for an established cleanout and maintenance schedule for each OWS. Instead, these installations may prefer to specify the cleanout and/or maintenance schedule for each OWS on a case-by-case basis. If so, the IWOWSS tickler feature can be used. When selected, this feature notifies the user when cleanouts and/or maintenance activities are pending based on historical data. The user is prompted for the time period of interest, and a report is run which displays OWS with pending cleanouts. This tool can be used to review cleanout and maintenance activities periodically in lieu of establishing a set maintenance schedule.

Data related to material usage is available in IWOWSS for each shop and facility at each installation. The custom report writer can be used to develop comparison reports of material usage at each shop for pollution prevention purposes. For example, material usage at shops which perform similar operations could be run to determine the type and quantities used at each shop. Resolution of the differences in similar materials used at each shop might lead to pollution prevention opportunities as well as cost savings. The comparison would also point out differences in the types of product used. This could lead to discoveries for the most effective an/or efficient product to use in each process.

You must have a valid username and password to download the software. The username and password will be changed periodically. You must be an employee of a qualified DoD organization to obtain a password. For the current password please contact Greg Pagett at (919)941-0333 or via email at GMPagett@mactec.com.