SRTC Input to DOE-HQ R and D Database for FY98

IDWP is a software application that was developed to identify the groundwater monitoring wells at SRS that require containerization and treatment for purge water generated during sampling. Created by the Statistical Consulting Section of SRTC, IDWP is a SAS application that retrieves the necessary data for wells selected by the user from the Site's extensive groundwater database on a remote machine. The program then applies an algorithm, derived by the Environmental Protection Department from the SRS Investigation-Derived Waste (IDW) Management Plan, to the analytical results to determine whether containerization is required for the specified wells. IDWP produces output files that designate the containerization status of each of the selected wells, provide statistics to support the treatment facilities' permits, and assist with controlling and scheduling the handling of the managed purge water. The SRS Aqueous IDW Administrator in the Environmental Restoration Division (ERD) uses IDWP in conjunction with knowledge of new wells to produce quarterly reports that specify which groundwater monitoring wells require purge water containerization for each treatment facility. Special reports supply other groundwater information of interest to ERD, such as analytical concentration plots and groundwater data gathering. Benefits include the timely generation of containerization lists for each treatment facility; the automatic retrieval of, and complex calculations for, extremely large amounts of data, ensuring consistent, accurate, and current containerization lists; and features such as a user-friendly interface, availability through computer networks, access for simultaneous multiple users, and independence from any particular person. The scope of IDWP continually expands to accommodate changes to the IDW Management Plan and to satisfy additional needs as they are identified, including the development of an Intranet interface for FY99