SDWIS Information Bulletin

Updated:  July 11, 2002

SDWIS User Support
Training
Revised Inventory Requirements Implementation

SDWIS User Support

For SDWIS related questions or comments, contact SDWIS User Support at 703-292-6121, or sdwisfed-pc@sdc-moses.com

Training

SDWIS Online Security Awareness Training

Effective December 31, 2002, all users of SDWIS must be certified as having completed the SDWIS Security Awareness Training. This training program will provide you with a background in SDWIS security issues and procedures.

Lead and Copper Rule

2 Days
More Information

 

Public Notice Rule

1 Day

MDBP Rule
1 Day

SETS    PDF Format ~  MS-Powerpoint

1 Day

 

Quick Reference Guides

Questions about these courses should be directed to Joe Lewis,  he can be reached via email at lewis.joe@epa.gov or at (202)564-4624

(to be implemented with Release 3.9, scheduled for January 2003):

• Implementation of Permanent and Unique Identification for Water System Facilities

For those states who do not maintain or report permanent facility identifiers, SDWIS currently generates the ID when the states report GGCs. However, we will no longer be able to continue generating facility IDs. With Release 3.9, GGCs (e.g., G0001) will be treated just like any other facility ID and will be stored in the data base exactly as it is input (e.g., G0001). Therefore, states should begin assigning permanent and unique IDs for all source, entry point, and treatment plant records as soon as possible.

• Elimination of Generated Treatment Plants

Currently treatment plant records are generated in SDWIS when a state reports treatments associated with a source or entry point instead of a treatment plant. Those treatments are then linked to the generated treatment plant. With Release 3.9, SDWIS software will reject any treatments associated with a source or entry point facility. Making the facility ID an alpha-numeric value provides those states the optional ability to take ownership of the existing generated treatment plant records by incorporating them into the state data base as their permanent and unique records. Otherwise, the state will need to define a new numbering scheme, create plant records and submit the new records with their associated treatments.

Locational data (lat/long coordinates and MAD codes) or an address must be reported for a treatment plant. Previously, when treatment plants were generated by SDWIS based on treatments being associated with source records, SDWIS also associated the locational data for the source with the generated treatment plant. Because treatment plants will no longer be generated and because existing generated plants will be deleted, states must report the locational data or the address for each treatment plant.

• Implementation of Filtration Status for Surface and Ground Under the Influence of Surface Systems as required under the Interim Enhanced Surface Water Treatment Rule (IESWTR)

Filtration status information required under the SWTR (filtered, required to filter, and successfully avoiding filtration which were reported as treatment objectives/processes - N350-N351, etc.) reporting changed under the implementation of the IESWTR to reporting as attributes within the source record. When possible, SDWIS will generate the filtration status codes based on the flow data. However, the "must install filtration" and "successfully avoiding filtration" status data must be reported by the state.

Previously, states could characterize ground water sources in a mixed surface and ground source system as not being subject to the surface water treatment rule. This provided the states an optional mechanism for addressing each source record in those systems. Roof catchment sources of water were also considered to be more like surface rather than ground. However, roof catchment sources were exempted from the SWTR filtration requirements and therefore would qualify for the source being characterized as "not [being] subject to the rule." SDWIS treats roof catchment sources as ground water sources; therefore, this characterization is superfluous. Under the IESWTR, roof catchment sources are still exempted from filtration. There is no exemption for surface or ground under the direct influence of surface source. Therefore this permitted value is being eliminated from the acceptable code values and will be removed from the database.

(to be implemented with Release 4.0, scheduled for July 2003):

• Initiation of Source and Treatment Plant Water System Facility Activity/Historical Status

  Source facilities and treatment plants are tracked as permanent facilities in SDWIS. Changes to key characteristic attributes (e.g., activity status - active, deactivated, unknown, transferred - PSW transferred to and transferred from; filtration status for surface or ground under the influence - filtered, successfully avoiding, unfiltered required to filter name; source treated status; and associated change dates) will be captured in a new water system facility history table. In release 3.9, activity status and the initial activity status date will be generated by SDWIS. In this release, activity status dates must be reported by the state when a new record is inserted to the data base. Deactivation and transfer dates must also be reported by the state.
  

• Disallowing Deletions of a Source, Entry Point, or Treatment Plant Facility
  
• Total Replace Matching on the Water System Facility ID Only

In a total replace update, if a user tries to delete a facility by leaving it out of the input file, it will not be deleted. Its facility status will be set to "U" (Unreported). States should update these "U" facilities by reporting them as "Inactive" if they are no longer operating before deleting them from the state data base. When a water system is reported as inactive by the state, SDWIS will set the activity status of its water system facilities to inactive also.

[Back to Top of Page]