UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
                                                                            WSG 111
                                                             Date Signed: July 10, 1998
MEMORANDUM

SUBJECT:   Revised Safe Drinking Water Information System (SDWIS) Inventory Reporting
             Requirements—Technical Guidance

FROM:      Robert J. Blanco, Director
             Implementation and Assistance Division
             Office of Ground Water and Drinking Water

TO:          Addressees

       This memorandum provides your staff with the detailed technical guidance needed to
implement the changes to the SDWIS/FED reporting requirements.  These changes result from
the data sharing process that was begun over three years ago to analyze EPA data needs and
existing reporting requirements.  These changes were recommended by the Data Sharing
Committee (DSC) and received considerable state and regional input through this process.
These recommendations were also reviewed and concurred on in substance by the ASDWA/EPA
Data Management Steering Committee, which also has EPA regional and state representatives.

       In April 1997 Cynthia Dougherty sent an early notice of new reporting requirements and
a fact sheet that summarized the tentative changes to the SDWIS inventory reporting
requirements. A copy of that memo is attached. The unresolved issue at that time was the
reporting of treatment data. The Executive Steering Committee requested the DSC to revisit the
cost data and to make its final recommendations based on the new data. Since that time new cost
data were obtained from states. Results were similar to the original figures. The DSC
formulated its final recommendations based on that new cost data and comments from its
committee, the states and ASDWA. This technical guidance document, therefore, contains some
new reporting requirements for treatment data.

       The final report attached today provides the detailed technical guidance to implement the
additional reporting requirements discussed in the April  1997 notice. The reporting
requirements included in this guidance are the following:

       Owner Type code (added to Core Data Set)
•      Service Area Characteristics (added to Core Data Set)
•      Geographic Area Data (added to Core Data Set)
•      Address Data (revised)
•      Treatment Data (added to Core Data Set)
•      Locational Data (added to Core Data Set)
•      Other inventory information and Data Sharing Goals

-------
                                                                             WSG 111
The Appendices include the following:

•      A technical guidance to implement treatment data requirements (Appendix A)
•      A technical guidance to implement locational data requirements, and the list of required
       and recommended data elements, definitions and coding standards (Appendices B, C, and
       D)
•      A grand summary of current reporting requirements (Appendix E)
•      An earlier memo on the definitions related to the types of water systems (Appendix F)
       List of SDWIS/FED contacts (Appendix G)

       A fact sheet that summarizes the changes to the SDWIS inventory reporting requirements
and the schedule for reporting are also included with this document. Most data are due to be
submitted no later than January 1, 2000.  I believe that we have struck a balance between setting
realistic, but not overly burdensome requirements.  Several of these reporting requirements will
improve the reporting of program functions and provide needed information to support
regulatory development and promote consistency across agency programs. In particular,
reporting of additional treatment data and the collection of locational coordinates will greatly
improve the understanding of source water protection and the use of spatial data within
SDWIS/FED.

       Thank you to the members of the DSC, including those state, regional, and headquarters
members who gave so much of their valuable time to the discussions and participated in the
workgroup meetings.

       I would appreciate any feedback on the utility of this format for conveying this technical
guidance to your staff.  If you have any questions on these new reporting requirements, please
contact me at (202) 260-5525 or Jan Auerbach at (202) 260-5274. Your staff may wish to
contact Tom Poleck (Region 5) at (312) 886-2407 or Roger Anzzolin (HQ) at (202) 260-7282.

Attachments

Addressees:    State Drinking Water Administrators
              Regional Drinking Water Program Managers/Coordinators
              Regional Drinking Water Enforcement Managers/Coordinators

cc:     Data Sharing Committee
       ASDWA/EPA Data Management Steering Committee
       Cynthia Dougherty, OGWDW
       Elizabeth Fellows, OGWDW
       Jan Auerbach, OGWDW
       Vanessa Leiby, ASDWA

-------
                                                                              WSG 111
April 11, 1997

MEMORANDUM

SUBJECT:  Early Notice on Revised Safe Drinking Water Information System (SD WIS)
             Inventory Reporting Requirements

FROM:      Cynthia Dougherty, Director
             Office of Ground Water and Drinking Water

TO:         Addressees

       This memorandum provides an early notice regarding the changes to the SDWIS/FED
inventory reporting requirements. These changes resulted from the data sharing process that we
began over two years ago to analyze EPA data needs and existing reporting requirements. The
Protocol for Making Data Sharing Decisions (December, 1995) was followed; that protocol
provided for State and Regional input with adequate review periods.  These recommendations
were also reviewed and concurred on in substance by the SDWIS Executive Steering Committee
and the ASDWA/EPA Data Management Steering Committee, both of which have EPA
Regional and State representatives.

       The purpose of transmitting this information to you now is to provide an early notice of
tentative new reporting requirements.  The final notice is planned to be sent later this summer,
once the complete technical guidance is developed and final decisions on reporting requirements
are made. A fact sheet that summarizes the tentative changes to the SDWIS inventory reporting
requirements is attached. Please feel free to use this information for planning purposes, but
recognize that the technical details and even the decisions on some specific requirements have
not been finalized.

       The category of information which is still in question is treatment data. Our contractor is
currently preparing the complete technical guidance to implement the current recommendations.
Once this occurs, we will be able to more accurately judge the impacts of the recommended new
reporting and decide, with your input, whether the impacts are warranted.  One possible
advantage to reporting more complete treatment data such as corrosion control treatment would
be to eliminate the need for reporting the milestone under the Lead and Copper Rule that this
treatment has been installed.

       I recognize that, overall, these changes result in an increase in the amount of inventory
data that must be reported to SDWIS/FED. Much effort went into balancing the need for data at
the Federal level with setting realistic reporting requirements that are achievable and not overly
burdensome on States.

       These new reporting requirements will better support our program functions by providing
information to support regulatory development, facilitate oversight, and promote consistency
across  environmental media.  In addition, our on-going review of existing reporting requirements

-------
                                                                              WSG 111
for the major drinking water rules will likely result in reduced reporting requirements, especially
for rules like the Lead and Copper Rule. Where there are some definite cost and resource
impacts, such as for latitude/longitude data, phased-in implementation schedules have been set
that reduce annual cost and minimize the reporting burden.  We request suggestions for how we
might be able to assist States with the collection and reporting of any of these data.

      Thank you to everyone who participated in this effort, especially those States and
Regions that served directly on the Data Sharing Committee. Your efforts have helped us make
what I hope  you agree are reasonable decisions on reporting requirements.

      If you have any questions on these revised requirements, please contact me at 202-260-
5543, or Jan Auerbach at 202-260-5274. You may also wish to contact Tom Poleck, Chair of the
Data Sharing Committee, at 312-886-2407.
Addressees:  State Drinking Water Administrators
             Regional Drinking Water Program Managers/Coordinators
             Regional Drinking Water Enforcement Managers/Coordinators

cc:           Data Sharing Committee
             Data Sharing Committee Advisory Group
             ASDWA/EPA Data Management Steering Committee
             Robert Blanco, OGWDW
             Jan Auerbach, OGWDW
             Vanessa Leiby, ASDWA

-------
                                                                               WSG 111


               Safe Drinking Water Information System (SDWIS)

                                 FACT  SHEET

Revised Inventory Reporting Requirements	June 1998

The reporting requirements as described in this fact sheet are the result of an extensive review of
the SDWIS inventory data needs  and the current reporting requirements conducted by the
SDWIS Data Sharing Committee (DSC) and others. The changes to the current inventory
reporting requirements are presented below in general terms.  The technical details and
implementation guidance are found in the technical guidance document, Revised Inventory
Reporting Requirements for the Safe Drinking Water Information System (SDWIS/FED)
Technical Guidance, June 26, 1998. A summary of the reporting requirements is also found in
Appendix E of this revised guidance.

The needed data, represented in SDWIS/FED as data attributes, are divided into two main
groups: Core Data Set attributes,  and Data Sharing Goal attributes. Core Data Set attributes
represent the new reporting requirements and will be associated with state annual grant
allotments. These attributes were judged as the most essential to describe the drinking water
program at the national level and to support U.S. EPA's most basic program responsibilities.
Only Core Data Set attributes are discussed in this fact sheet. Data Sharing Goal attributes are
also needed by EPA to support important program functions and, where possible, should be
negotiated by each Region and State and reported to SDWIS/FED.

The following data will no longer be in the Core Data Set or counted toward grant eligibility
for FY 2001 and beyond.  The grant figures for FY1999 and FY 2000 will still use these
attributes so they must continue  to be reported until March  1999.

•     Season begin and end dates for noncommunity water systems

       The reasons for discontinuing this requirement include: the lack of use for these data except for
       performing grant calculations, and the perceived inaccuracy of the data due to reported dates that
       meet the reporting requirement, but do not accurately reflect actual season begin and end dates.
       The inventory reporting guidance is modified to reinforce the requirement to only report
       inventory to SDWIS/FED that meets the Federal definition. Double-checking by EPA to see that
       noncommunity water systems were opened for the required number of days is redundant and not
       a convincingly justified use  of the data.

The following requirement for address data is revised:

ADDRESS DATA   The official address of a public water system represents the name and
                     mailing address of the responsible person (e.g., an owner or operator)
                     associated  with the public water system.
*•      Address information is required for all water system types and should become part of a
       state's routine updating or replacement of inventory data. The official address consists of

-------
                                                                               WSG 111
       the name of the water system, two address lines which are used to identify the
       responsible person and the mailing street address, a city, state and zip code.
*•      If the latitude and longitude of any treatment plants are not reported, then an additional
       physical address must also be reported for each plant.

The following new inventory data are being added to the Core Data Set:

GEOGRAPHIC AREA DATA     Geographic area data include the city(s) and county(s)
                                  served by the water system.

*•      City and county served data are required for all water system types  and should become
       part of a state's routine updating or replacement of inventory data.  County served or a
       county equivalent, must be reported for all water systems. City served is only reported in
       those cases where the water system serves a city or equivalent jurisdiction. Where
       multiple cities or counties are served, all should be reported.
*      The city served is an alphanumeric value that represents a city, community or jurisdiction
       that is being served by a public water system in whole or in part.  The county served is a
       code value that represents a county, or county equivalent, that is being served by a public
       water system in whole or in part.

OWNER TYPE CODE     A code that indicates the owner type (e.g.,  Federal, private, Native
                           American, etc.) for each water system is to be reported. This used
                           to be a grant-eligibility  data element but was removed from the list
                           a few years ago.  Owner type code is required for all water system
                           types and should become part of a state's routine updating or
                           replacement of inventory data.

SERVICE AREA CHARACTERISTICS A code that represents the primary type of area
                                        (e.g., schools, day care centers, mobile home parks,
                                        etc.) being served by a water system in whole or in
                                        part is to reported. This used  to be a grant-
                                        eligibility data element but was removed from the
                                        list a few years ago. Service Area Characteristic
                                        codes are required for all water system types and
                                        should become part of a state's routine updating or
                                        replacement of inventory data.

LATITUDE & LONGITUDE DATA     The latitude/longitude coordinates and the six
                                        required method, accuracy and description (MAD)
                                        codes under the EPA Locational Data Policy (LDP)
                                        are to be reported for all active sources of water
                                        (surface  water intakes and wellheads). The
                                        guidance lists as a Data Sharing Goal the reporting
                                        of locational data of the water treatment plant(s).
                                        The LDP also recommends eight (8) optional

-------
                                                                              WSG 111
                                        elements to be collected.

TREATMENT DATA      As part of the SDWIS/FED inventory Core Data Set, the following
treatment data are required to be reported:

       a.     All treatment data (treatment objectives and processes) for all sources of water;
       b.     All water sources that are untreated;
       c.     Any new and innovative treatment combination or process;
       d.     Treatment status by the seller of purchased water; and the
       e.     Linkage between sources of water and treatment plants.

Treatment information is required for all water system types and should become part of a state's
routine updating or replacement of inventory data.

Implementation Schedule

Except for latitude/longitude data and treatment data, all new requirements will become effective
on January 1, 2000.  For latitude/longitude data and treatment data, all data for community water
systems are due by January 1, 2000. For latitude/longitude and treatment data for non-transient,
non-community water systems, 20% of the data are due by January 1, 2001 and 20% more per
year until January 1, 2005. For treatment data, all transient noncommunity water systems are
due by January 1, 2005. Reporting of lat/long data for transient noncommunity water systems is
not in the Core Data Set, but is a Data Sharing Goal. Where possible, reporting for transient
systems is encouraged.

SDWIS/FED is being modified to accept all of the new requirements. As these new capabilities
go into production, the states and regions will be notified as to the earliest date that certain data
can be reported to SDWIS/FED. As of today, the following data can be reported to
SDWIS/FED:

•      owner type codes
•      service area characteristics
•      geographic areas
•      address data
•      some of the required water system facility data (i.e. all required basic facility inventory
       elements, treatment objective and process codes, latitude and longitude coordinates
       reported as degrees, minutes and seconds).

The reporting of latitude/longitude data should be possible by the end of this year or in early
1999. The reporting of treatment linkages and  the other new treatment codes will be available
soon after the locational data processing is available.

Until these new requirements become effective, the current reporting requirements must,  at a
minimum, continue to be reported.

-------
                                                                         WSG 111
Revised Inventory Reporting Requirements for the Safe Drinking Water Information
System (SDWIS/FED)—Technical Guidance

This guidance is too large to include in this manual. To obtain a copy of this guidance, see
Index 5 of this manual.

Document numbers:

EPA#:
816-R-98-007

NCEPI #:
816/F-98-007

WRC#:
816/F-98-007

-------