SDWIS Federal Reporting Services Data Dictionary
The following data dictionaries provide descriptions and definitions for the reports, filters, and data fields found within the SDWIS Federal Reports Search system.
On this page
SDWIS Federal Reporting Services Reports Dictionary
The reports dictionary contains descriptions for the reports available within the SDWIS Federal Reports Search system. The reports are listed in the order they appear in the system.
| Report Name | Description |
|---|---|
| Water System Summary | This report shows a summary of public water system (PWS) information, including the PWS type, location served, number of facilities (such as, storage tanks, well heads, water intakes), number of violations, and number of site visits. |
| Water System Detail | This report shows detailed public water system (PWS) information, including owner type, primary source (such as, surface water or ground water), activity status (active or inactive), population served count, and service connections count. |
| Service Area | This report details the types of areas served by the water system (such as, residential areas, schools, daycares, mobile home parks, etc.) and which one is considered the primary area served. |
| Geographic Area | This report shows the public water system's geographic area information, including area type (county, city, tribal, zip code or unknown) and specifies the particular area by name. |
| Site Visits | This report shows detailed public water system (PWS) site visit information, including the visit reason and comments. Examples of site visits include PWS inspections and sanitary surveys. Note: There may be multiple site visits per PWS. |
| Events and Milestones | This report shows detailed public water system (PWS) event milestone information, including the event reason and event comments. Examples include responses to fecal contamination, conducting a lead service line inventory, or responses to significant deficiencies. Note: There may be multiple events per PWS. |
| Facilities | This reports shows detailed public water system (PWS) facility information, including facility name, facility type, and facility activity. Examples of facilities include water storage tanks, well heads, water intakes, and pump stations. Note: There may be multiple facilities per PWS. |
| Violations | This report shows detailed public water system (PWS) violation information, including rule name, violation type, and compliance status. Note: There may be multiple violations per PWS. |
| Lead and Copper Report > Lead Completeness > Lead Completeness Summary | This report shows the total number of public water systems with population served counts greater than 3,300 by primacy agency and breaks down which of those systems have a Pb90th sample (the concentration of lead in the top ten percent of samples) within the latest three years of data available (displayed as total system count and percentage). |
| Lead and Copper Report > Lead Completeness > Lead Completeness System with Samples | This report shows public water system (PWS) information for PWSs that have a Pb90th sample (the concentration of lead in the top ten percent of samples) within the latest three years of data available. |
| Lead and Copper Report > Lead Completeness > Lead Completeness System without samples | This report shows public water system (PWS) information for PWSs that do not have a Pb90th sample (the concentration of lead in the top ten percent of samples) within the latest three years of data available. |
| Lead and Copper Report > Lead ALE Samples | This report shows all Pb90th samples (the concentration of lead in the top ten percent of samples) with results greater than or equal to 15.5 parts per billion (ppb). The sample start date, sample end date, and sample measure are included for each record. Note: By default, the report shows the latest 3 years of data but this can be modified in the report options prior to generating the report. |
| Lead and Copper Report > Lead Samples | This report shows all Pb90th samples (the concentration of lead in the top ten percent of samples). The sample start date, sample end date, and sample measure are included for each record. Note: The sample measure can be added in the report options prior to generating the report. By default, the report shows the latest 3 years of data but this can be modified in the report options prior to generating the report. |
| Lead and Copper Report > Copper ALE Samples | This report shows all Cu90th samples (the concentration of copper in the top ten percent of samples) with results greater than 1.3 ppb. The sample start date, sample end date, and sample measure are included for each record. Note: By default, the report shows the latest 3 years of data but this can be modified in the report options prior to generating the report. |
| Lead and Copper Report > Copper Samples | This report shows all Cu90th samples (the concentration of copper in the top ten percent of samples). The sample start date, sample end date, and sample measure are included for each record. Note: The sample measure can be added in the report options prior to generating the report. By default, the report shows the latest 3 years of data but this can be modified in the report options prior to generating the report. |
| Service Line Inventory | This report presents state primacy agency reporting for each public water system's service line counts to date, in the following categories: lead, galvanized requiring replacement, lead status unknown or unknown, and non-lead service lines. |
| Tribal PFAS Data > Tribal PFAS System Summary Report | This report shows a summary of PFAS (polyfluoroalkyl substances) samples collected by tribal public water systems. The analyte short name (description of a particular PFAS chemical) and sample collection date are included for each record. |
| Tribal PFAS Data > Tribal PFAS Sample Location Summary Report | This report shows a summary of the sample point (code given to identify the sample location where the sample was collected) and location (sample location where the sample was collected) for the PFAS samples collected by the tribal public waters systems. The sample collection date and lab method are included for each record. |
| Tribal PFAS Data > Tribal PFAS Result Report | This report shows detailed PFAS samples collected by tribal public water systems. The sample collection date, sample location (sample location where the sample was collected), analyte short name (description of a particular PFAS chemical), and result are included for each record. |
| AWIA Certification | This report will display which PWSIDs have and have not certified their RRA and ERP for the original AWIA compliance cycle, which took place during 2020-2021. After future five-year AWIA compliance deadlines have passed, EPA will update this report to add RRA and ERP certification data. |
SDWIS Federal Reporting Services Filter Dictionary
The filter dictionary contains definitions for the report filters available within the SDWIS Federal Reports Search system. The filters are listed in alphabetical order.
| Filter Variable | Definition |
|---|---|
| Activity Status | A PWS's most recent state of operation. A - Active I - Inactive M - Merged with another system N - Changed from public to non-public P - Potential future system to be regulated |
| Agency Type | The type of agency performing the visit, such as, water district, city, state, etc. If interested in a specify agency type, use the drop down to select an agency type. Otherwise, select All. |
| Availability | Code for how the source water is utilized by a water system. E - Emergency I - Interim O - Other P - Permanent S - Seasonal |
| Choose a report | Available in the Lead and Copper Report filters. Select from: Lead Completeness, Lead ALE Samples, Lead Samples, Copper ALE Samples, Copper Samples. |
| City | Name of the city within which the facility is located |
| City Served | Name of the city served by the facility. This filter field only displays 'All' option. |
| Combined Distribution System Identification | Combined distribution system (CDS) identifier. If interested in a specific CDS, enter the ID for the CDS. Otherwise, leave blank. |
| Compliance Evaluation | Result of the operator compliance evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable. Use drop down if interested in a specific result. Otherwise, select All. |
| Compliance Status | The current status of a violation, that is, known (K), open (O), returned to compliance (R), or system inactive (I). Violations with compliance status Known (violations with populated compliance period end dates) or Open (violations without compliance period end dates) are still in noncompliance (still in violation). Violations with status Returned to Compliance have returned to compliance (no longer in violation). Meanwhile, violations with System Inactive status have been closed due to the system becoming inactive but the violation could return if the system becomes active in the future. |
| Contaminant | Contaminant for which a public water system has incurred a violation of a primary drinking water regulation. If interested in a specific contaminant, select the desired contaminant form the drop down. Otherwise, select All. |
| Country Name | Country name where the treatment plant is located. |
| County Served | Name of the county served by the facility. This filter field only displays 'All' option. |
| Data Verification Evaluation | Result of the data verification evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| DBPR Schedule Category | Identifies the category for Stage 2 Disinfectant Byproducts Rule (DBPR) schedule. Category selection ranges based on population served or connection to a combined distribution system (CDS) serving a specific population served range. If interested in a specific category, select the category option. Otherwise, select All option. |
| Deactivation Date From | Date when the water system was deactivated (water system no longer actively serving water) or removed from federal oversight because it no longer met SDWA criteria as a public water system (PWS). This column is NULL (blank) if the water system is active. If interested in PWSs that were deactivated after a specific date, populate this field with the date for the start of the time frame you are interested in. >= MM/DD/YYYY. Otherwise, leave blank. |
| Deactivation Date To | Date when the water system was deactivated (water system no longer actively serving water) or removed from federal oversight because it no longer met SDWA criteria as a public water system (PWS). This column is NULL (blank) if the water system is active. If interested in PWSs that were deactivated before a specific date, populate this field with the end date of the time frame of interest <=MM/DD/YYYY. Otherwise, leave blank. |
| Distribution Evaluation | Result of the distribution system evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| EPA Region | The EPA region where the water system is located. There are ten (10) regions, each of which is responsible for several states, territories, or tribes. |
| EPA Region Checkbox | Filter available in the Tribal PFAS Monitoring report filers. Checkbox and map to select the EPA Region. Currently EPA Region 7, 8 and 10 are available options. |
| Event Actual From | Date on which the milestone was conducted or achieved. If interested in milestone events that were conducted or achieved after a specific date, populate field with the date that starts the time frame you are interested in >= MM/DD/YYYY. Otherwise, leave blank. |
| Event Actual To | Date on which the milestone was conducted or achieved. If interested in milestone events that were conducted or achieved before a specific date, populate field with the date that ends the time frame you are interested in <= MM/DD/YYYY. Otherwise, leave blank. |
| Event Date From | The calendar date when the scheduled activity was successfully completed. This date is optional if the Event Activity code is "DONE". If interested in milestone events that ended after a specific date, populate field with the date that starts the time frame you are interested in >= MM/DD/YYYY. Otherwise, leave blank. |
| Event Date To | Date on which the milestone event ended. If interested in milestone events that ended before a specific date, populate field with the date that ends the time frame you are interested in <= MM/DD/YYYY. Otherwise, leave blank. |
| Event Reason | The reasons for undertaking some action under the lead and copper rule, such as, Ground Water Rule, Initial Lead Service Line Inventory, Revised Total Coliform Rule, etc. Use drop down if interested in a specific reason. Otherwise, select All. |
| Event Type | Events performed under the lead and copper rule, such as, Fecal Indicator Contamination Action, Lead Action Level Exceedance, Lead Service Line Inventory, etc. Use drop down if interested in a specific event type. Otherwise, select All. |
| Facility Activity Code | The value of this attribute indicates the status of the facility. A - Active I - Inactive M - Merged with another system N - Changed from public to non-public P - Potential future system to be regulated If interested in facilities with a specific activity status, select an activity status from the drop down. Otherwise, leave blank. |
| Facility Deactivation Date From | Date the facility was deactivated (no longer active). This is date pertains to the facility not necessarily the public water system (PWS). A facility could be deactivated but the PWS may still be active. This column is NULL if the water system is active. If interested in facilities that were deactivated before a specific date, populate this field with the start date of the time frame of interest >=MM /DD/YYYY. Otherwise, leave blank. |
| Facility Deactivation Date To | Date when the water system was deactivated (water system no longer actively serving water) or removed from federal oversight because it no longer met SDWA criteria as a public water system (PWS). This column is NULL (blank) if the water system is active. If interested in PWSs that were deactivated within a specific time frame, populate this field with the end date of the time frame you are interested in. <= MM/DD/YYYY. Otherwise, leave blank. |
| Facility ID | Identification code for a specific water system facility. When this ID is used with the PWSID, it uniquely identifies a water system facility. Note: Facilities from different water systems may have the same Facility ID. There may be repeat Facility ID values nationally but not for the same water system. Examples of facilities include treatment plants, wells, consecutive connections, etc. If interested in a specific Facility ID, populate this field with the Facility ID. Otherwise, leave blank. NOTE: This is an open text field. Additionally to help the search, populate a PWS ID in the PWS ID field. |
| Facility Name | Name of water system facility. If interested in a specific water system facility, populate this field with the facility name. Otherwise, leave blank. NOTE: This is an open text field. Additionally to help the search, populate a PWS ID in the PWS ID field. |
| Filtration Status | A code reported by the state to indicate whether a non-emergency surface water source or a non-emergency ground water under the influence of surface water source is required to install filtration by a certain date or is successfully avoiding filtration. Filtration Already In Place Must install filtration Successfully avoiding filtration |
| Financial Evaluation | Result of the financial evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Finished Water Evaluation | Result of the finished water evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| GW or SW | Indicates if the water source for the water system is from a groundwater (GW) or surface water (SW) source under SDWA. For purposes of establishing which rules a water system is subject to, a system with any surface water sources, or ground water sources under the direct influence of surface water, is treated as having a surface water source. The primary source field provides more details about the type of source the water system uses as its primary source. |
| How would you like to filter? | Filter available in the Violation report. Allows swapping the order in which Rule, Violation, and Contaminant are displayed. |
| Is Daycare or School | Yes/No field that indicates if the water system’s primary service area is a school or daycare. |
| Is Grant Eligible | Yes/No field that indicates if the primacy agency has reported the minimum necessary data elements for this water system to include it in grant calculations. |
| Is Health Based | Indicates if this is a health based violation (Y) or not (N). |
| Is Outstanding Performer | Yes/No field that indicates if the system is an outstanding performer according to state policy. Outstanding Performers are eligible for reduced sanitary survey frequency. |
| Is Source Water Protected | Yes/No field that indicates if the water system has implemented source water protection according to state policy. |
| Is Source? | Indicates whether the water system facility is designated a source. CC - Consecutive Connection IG - Infiltration Gallery IN - Intake NP - Non-piped RC - Roof Catchment RS - Reservoir SP - Spring WL - Well NN - Non-piped non-purchased Y for Yes, N for No, and U for Unknown. |
| Is Wholesaler? | Yes/No field that indicates whether the system is a wholesaler of water, that is, sells water to other systems. |
| Latest Enforcement ID | The most recent enforcement action taken against this violation. |
| LT2 Schedule Category | Identifies the category for Long Term 2 Enhanced Surface Water Treatment (LT2) schedule. Category selection ranges from Schedule 1 to Schedule 5, option to select All is also included. If interested in a specific category, select the schedule option. Otherwise, select All option. |
| Management Operation Evaluation | Result of the management operations evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Non-Purchased Source | Indicates the type of facility, non-purchased source, such as, consecutive connection, intake, well, etc. If interested in specific facility type of non-purchased source, check the box for the facility type desired. Otherwise, select All Facility Types. |
| Non-Source | Indicates the type of facility, non-source. If interested in specific facility type of non-source, check the box for the facility type desired. Otherwise, select All Facility Types. |
| NPM Candidate | Public Water System National Program Measure candidate; indicates whether the PWS was open during part or all of the latest 4 quarters of data from the selected Submission Year and Quarter |
| Other Evaluation | Result of the other evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Outstanding Performer Date From | The begin date a water system was awarded outstanding performer status according to state policy. If interested in water systems that were awarded outstanding performer status within a specific time frame, populate this field with the start date of the time frame you are interested in. >= MM/DD/YYYY. Otherwise, leave blank. |
| Outstanding Performer Date To | The begin date a water system was awarded outstanding performer status according to state policy. If interested in water systems that were awarded outstanding performer status within a specific time frame, populate this field with the end date of the time frame you are interested in. <= MM/DD/YYYY. Otherwise, leave blank. |
| Owner Type | The ownership category of the water system. F - Federal Government L - Local Government M - Public/Private N - Native American P - Private S - State Government |
| Pop Cat 11 | Select from population categories based on population served by the water system: <100; 101-500; 501-1,000; 1,001-3,300; 3,301-10,000; 10,001-50,000; 50,001-100,000; 100,001-250,000; 250,001-500,000; 500,001-1,000,000; or >100,000,000 |
| Pop Cat 2 | Select from population categories based on population served by the water system: <10,000 or 10,000+ |
| Pop Cat 3 | Select from population categories based on population served by the water system: <=3,300; 3,301-50,000; or >50,000 |
| Pop Cat 4 | Select from population categories based on population served by the water system: <10,000; 10,000-49,999; 50,000-99,999; or 100,000+ |
| Pop Cat 5 | Select from population categories based on population served by the water system: <500; 501-3,300; 3,301-10,000; 10,001-100,000; or >100,000 |
| Primacy Agency | Name of the state, territory, or tribe having regulatory oversight for the water system. If the water system is regulated directly by EPA, then the primacy agency is the EPA Region. The Navajo Nation is currently the only tribe that has primacy over its water systems. |
| Primacy Type | Indicates if the water system is regulated by a state, tribal, or territorial primacy program. Note that EPA direct implementation programs, except for Wyoming, are tribal primacy programs. |
| Primary Service Area | The type of primary service area served by the water system (such as, residential area, school, daycare, or mobile home park). |
| Primary Source | Identifies the primary source of water for the water system beyond just the ground water (GW) and surface water (SW) categories. GW - Ground water GWP - Groundwater purchased SW - Surface water SWP - Surface water purchased GU - Groundwater under influence of surface water GUP - Purchased ground water under influence of surface water source |
| Public Notification Tier | Public Notification Tier required for the violation or situation. |
| Public Water System | Name and ID that uniquely identifies a public water system (PWS); consisting of a two-letter primacy agency or region code, followed by seven digits. The two-letter code indicates the primacy agency or region that regulates the water system. Note: Utah PWS IDs begin with 4 letters (UTAH) followed by 5 numbers. To filter by PWS, click the dropdown next to the filter field then select the PWS to populate the field. Otherwise, leave blank. |
| Pumps Evaluation | Result of the pump(s) evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Purchased Source | Indicates the type of facility, purchased source. Selecting any of these facility types allows the Purchased Source filters to appear. If interested in specific facility type of purchased source, check the box for the facility type desired. Otherwise, select All Facility Types. |
| PWS ID | ID that uniquely identifies a public water system; consisting of a two-letter primacy agency or region code, followed by seven digits. The two-letter code indicates the primacy agency or region that regulates the water system. Note: Utah PWS IDs begin with 4 letters (UTAH) followed by five digits |
| PWS Name | Name of the public water system in the SDWIS Federal Data Warehouse database |
| PWS Type | The type of drinking water system. Public water system (PWS) - A system for the provision to the public of piped water for human consumption, which has at least 15 service connections or regularly serves an average of at least 25 individuals at least 60 days out of the year. Community water system (CWS) - A PWS that serves at least 15 service connections used by year-round residents or regularly serves at least 25 year-round residents (such as, homes, apartments and condominiums that are occupied year-round as primary residences). Non-transient non-community water system (NTNCWS) - A PWS that regularly serves at least 25 of the same nonresident persons per day for more than six months per year. A typical example is a school or an office building that has its own water source, such as a drinking water well. Transient non-community water system (TNCWS) - A PWS that does not serve 25 of the same nonresident persons per day for more than six months per year. A typical example is a campground or a highway rest stop that has its own water source, such as a drinking water well. Non-public (NP) - A drinking water system reported to the EPA by a primacy agency that does not meet the definition of Public Water System above. Unknown - The primacy agency did not report the type of system to EPA. |
| Quarter | Calendar quarter of data submission to Safe Drinking Water Information System (SDWIS); SDWIS is updated, corrected if necessary, and frozen each quarter. This field allows the user to view the status of SDWIS data reported at a selected quarter. It is best thought of of version control. |
| Reason | Reason for the site visit. If interested in a specific site visit reason, select a reason from the drop-down. Otherwise, select All. |
| Reduced Monitoring Begin Date From | Initial start date of the reduced monitoring period for a system. If interested in systems that began reduced monitoring after a specific date, populate this field with a begin date >= MM/DD/YYYY. Otherwise, leave blank. |
| Reduced Monitoring Begin Date To | Initial start date of the reduced monitoring period for a system. If interested in systems that began reduced monitoring before a specific date, populate this field with a begin date <= MM/DD/YYYY. Otherwise, leave blank. |
| Reduced Monitoring End Date From | End date of the reduced monitoring period for a system. If interested in systems that ended reduced monitoring after a specific date, populate this field with a end date >= MM/DD/YYYY. Otherwise, leave blank. |
| Reduced Monitoring End Date To | End date of the reduced monitoring period for a system. If interested in systems that ended reduced monitoring before a specific date, populate this field with a end date <= MM/DD/YYYY. Otherwise, leave blank. |
| Reduced RTCR Monitoring | Frequency of Revised Total Coliform Rule (RTCR) reduced monitoring, which can be annual, semi-annual, quarterly, or every two months. If interested a specific RTCR reduced monitoring schedule, select the frequency. Otherwise, select All option. |
| RTC Date | The Return To Compliance (RTC) date. |
| RTC Enforcement ID | The enforcement ID of the most recent Enforcement Action taken against this Violation to Return To Compliance (RTC). |
| Rule | National Primary Drinking Water rule for which a public water system has incurred a violation. If interested in violations for a specific rule, select the desired rule from the drop down. Otherwise, leave unselected. |
| Rule Family | The rule family a violation falls under. Rules are categorized into families then groups, such as, Groundwater Rule, Lead and Copper Rule, PFAS Rules, etc. |
| Rule Group | The rule group a violation falls under. Rules are categorized into families then groups, such as, Chemicals, Microbials, etc. |
| Sample End Date | Date of the last day of the monitoring period in which 90th percentile data for lead or copper was acquired. |
| Sample Start Date | Date of the first day of the monitoring period in which 90th percentile data for lead or copper was acquired. |
| Season Begin Date From | A PWS may be seasonal, meaning that it is not open or serving water year-round. A typical example is a summer camp that has its own water source and is only open during the summer season but closed the rest of the year. The seasonal begin date is the opening month and day of the period of time when the water system serves water. If interested in a specific seasonal time frame, populate this field with the season begin date >= MM/DD/YYYY. The year in this date field does not impact the results as the results field is formatted to MM/DD only. This From date field is to be used as the starting date range in the seasonal begin date you are interested in. Otherwise, leave blank. |
| Season Begin Date To | A PWS may be seasonal, meaning that it is not open or serving water year-round. A typical example is a summer camp that has its own water source and is only open during the summer season but closed the rest of the year. The seasonal begin date is the opening month and day of the period of time when the water system serves water. If interested in a specific seasonal time frame, populate this field with the season begin date <= MM/DD/YYYY. The year in this date field does not impact the results as the results field is formatted to MM/DD only. This To date field is to be used as the ending date range in the seasonal begin date you are interested in. Otherwise, leave blank. |
| Season End Date From | A PWS may be seasonal, meaning that it is not open or serving water year-round. A typical example is a summer camp that has its own water source and is only open during the summer season but closed the rest of the year. The seasonal end date is the ending or closing month and day of the period of time when the water system serves water. If interested in a specific seasonal time frame, populate this field with the season end date >= MM/DD/YYYY. The year in this date field does not impact the results as the results field is formatted to MM/DD only. This From date field is to be used as the starting date range in the seasonal end date you are interested in. Otherwise, leave blank. |
| Season End Date To | A PWS may be seasonal, meaning that it is not open or serving water year-round. A typical example is a summer camp that has its own water source and is only open during the summer season but closed the rest of the year. The seasonal end date is the ending or closing month and day of the period of time when the water system serves water. If interested in a specific seasonal time frame, populate this field with the season begin date <= MM/DD/YYYY. The year in this date field does not impact the results as the results field is formatted to MM/DD only. This To date field is to be used as the ending date range in the seasonal end date you are interested in. Otherwise, leave blank. |
| Secondary Service | The type of secondary service area(s) served by the water system (such as residential area, school, daycare, or mobile home park). |
| Security Evaluation | Result of the security evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Select a Report | Radio button to select from Tribal PFAS Reports: System Summary Report Sample Location Summary Report Result Report |
| Seller PWSID | PWSID of the water system that is selling water to this system through this interconnection. PWSID of the upstream water system to this facility. |
| Seller PWSID Name | Name of the water system that is selling water to this system through this interconnection. Name of the upstream water system to this facility. |
| Seller Treatment Code | Indicates the seller's treatment status of the water. Applies only to source facilities. Seller Treatment Codes: F - Filtered G - Treated by seller, including 4-log for the Ground Water Rule Y - Partially treated by seller N - Not treated U - Unknown |
| Service Connections From | Number of service connections to the water system. If interested in systems with a specific minimum number of service connections, enter the minimum value of service connections. Otherwise, leave field blank. |
| Service Connections To | Number of service connections to the water system. If interested in systems with a specific maximum number of service connections, enter the maximum value of service connections. Otherwise, leave field blank. |
| Source Water Evaluation | Result of the source water evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Source Water Protection Date From | The start date a water system implemented source water protection. If interested in source water protection implemented in a specific time frame, populate this field with the begin date of the time frame you are interested in. >=MM/DD/YYYY. Otherwise, leave blank. |
| Source Water Protection Date To | The start date a water system implemented source water protection. If interested in source water protection implemented in a specific time frame, populate this field with the end date of the time frame you are interested in. <=MM /DD/YYYY. Otherwise, leave blank. |
| State | Official United States Postal Service (USPS) code for the states and outlying areas. For the purposes of the data warehouse, the code NN is used for the Navajo Nation. |
| State Facility ID | The ID that a state uses to identify a facility in their own state system database. |
| Street Address 1 | The first line of an address applicable to the Legal Entity being reported. |
| Street Address 2 | The second line of an address applicable to the legal entity being reported. |
| Submission Status | Code that indicates whether an active water system was reported, rejected, or not reported during the recent inventory submission to EPA's Safe Drinking Water Information System. This field is not applicable to inactive water systems. Generated by EPA's Output Delivery System (ODS). Y - Reported and accepted U - Unreported R - Reported but rejected |
| Submission Year | Calendar year of data submission to Safe Drinking Water Information System (SDWIS); SDWIS is updated, corrected if necessary, and frozen each quarter. This field allows the user to view the status of SDWIS data reported at a selected year. It is best thought of as version control. |
| Submission Year Quarter | Year and quarter of data submission to Safe Drinking Water Information System (SDWIS); best thought of as year of version control. Data is submitted quarterly with a one quarter delay for data entry and quality assurance checks. This field allows the user to view the status of SDWIS data reported at a selected year and quarter. It is best thought of as version control. |
| Treatment Evaluation | Result of the treatment evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable Use drop down if interested in a specific result. Otherwise, select All. |
| Treatment ID | Treatment ID that uniquely identifies a treatment process for this treatment plant. |
| Treatment Objective | The treatment objective to be attained through treatment of a source of water, such as, Corrosion Control, Disinfection, Organics Removal, etc. |
| Treatment Plant | Indicates the type of facility, treatment plant. Selecting treatment plant allows the Treatment Plant Filters to appear. If interested in specific facility type of treatment plant, check the box for the facility type desired. Otherwise, select All Facility Types. |
| Treatment Process | The treatment process used to obtain the treatment objective, such as, Distillation, Flocculation, Fluoridation, etc. |
| Tribal Code | The three-digit EPA code which represents the Indian reservation or Alaska Remote Village being served by a Water System. To filter by Tribal Code, click the button next to the filter field (three bullet list icon) then select the Indian reservation or Alaska Remote Village to populate the field. Otherwise, leave blank. |
| Tribe | The name and three-digit EPA code which represents the Indian reservation or Alaska Remote Village being served by a Water System. To filter by Tribal Code, click the dropdown next to the filter field then select the Indian reservation or Alaska Remote Village to populate the field. Otherwise, leave blank. |
| Type of Area Served | Indicates the geographic area type. TR - Tribal CN - County ZC - Zip Code CT - City IR - Indian Reservation |
| Violation | Violation of a primary drinking water regulation, such as: (01) Maximum Contaminant Level Violation (Single Sample); (03) Monitoring, Regular; (07) Treatment Technique; etc. If interested in a specific violation type, select the desired violation from the drop down. Otherwise, select All. |
| Violation Category | Violation categories. MCL - Maximum contaminant level MRDL - Maximum residual disinfectant level TT - Treatment technique MR - Monitoring and reporting MON - Monitoring RPT - Reporting Other |
| Violation NPM Candidate | Violation data included in NPM calculations, that is, a violation open and not returned to compliance during part or all of the latest 4 quarters from selected submission year and quarter. |
| Visit Date From | Date of the site visit. If interested in site visit that occurred after a specific date, populate this field with the start date of the time frame you are interested in >= MM/DD/YYYY. Otherwise, leave blank. |
| Visit Date To | Date of the site visit. If interested in site visit that occurred before a specific date, populate this field with the last date of the time frame you are interested in <= MM/DD/YYYY. Otherwise, leave blank. |
| Water Type | Code that indicates the source of the water. GW - Groundwater SU - Surface water GU - Groundwater under the influence of surface water. |
| Zip Code | Five-digit postal zip code served. |
SDWIS Federal Reporting Services Data Field Dictionary
The data field dictionary contains definitions for the report data fields available within the SDWIS Federal Reports Search system. The data fields are listed in alphabetical order.
| Data Field | Definition |
|---|---|
| # Galvanized Requiring Replacement Service Lines | Number of galvanized requiring replacement (GRR) service lines identified and reported by the public water system on its service line inventory. Galvanized requiring replacement (GRR) service lines: made of galvanized iron or steel that are currently, or previously were, downstream of a lead service line. |
| # Lead Service Lines | Number of lead service lines (LSL) identified and reported by the public water system on its service line inventory. Lead service lines (LSL): any service lines that have any portion of the pipe made of lead. |
| # Lead Status Unknown Service Lines | Number of lead status unknown (unknown) service lines identified and reported by the public water system on its service line inventory. Lead status unknown (unknown) service lines: the service line material is not known to be lead, galvanized requiring replacement (GRR), or non-lead (non-LSL). |
| # Non-lead Service Lines | Number of non-lead service lines (non-LSL) as identified and reported by the public water system on its service line inventory. Non-lead service lines (non-LSL): do not have any portion of the pipe made of lead or any portion of the pipe that is galvanized requiring replacement (GRR) and instead are made of a different material. |
| # of Facilities | Number of Facilities reported at the water system, such as, intakes, treatment plants, distribution systems, etc. |
| # of Site Visits | Number of site visits reported at the water system. |
| # of Violations | Number of violations reported at the water system. |
| % Systems with Sample | Percent of systems reporting an LCR Pb90th sample (the concentration of lead in the top ten percent of samples) in the latest sampling period. |
| 2E Violation Reported | Lead and Copper Rule treatment technique violations, 2E - LSL Inventory, issued to a public water system (PWS) due to one of the following: - Failure to complete the initial lead service line inventory by October 16, 2024. CFR §141.80(f)(3) & CFR §141.84(a) - Failure to make the inventory publicly accessible in accordance with CFR §141.84(a)(8) - A PWS has no lead, galvanized requiring replacement, or lead status unknown service lines fails to issue a written statement declaring the distribution system has no lead service lines in accordance with the requirements of CFR §141.84(a)(9) |
| 4G Violation Reported | Lead and Copper Rule reporting violation, 4G - LSL Reporting, issued to a public water system (PWS) due to one of the following: - Failure to submit an initial inventory of service lines to the primacy agency by October 16, 2024. CFR §141.90(e)(1) - A PWS without any lead, galvanized requiring replacement (GRR), or lead status unknown service lines fails to notify the primacy agency within 30 days upon discovery of any service lines requiring replacement and preparing an updated inventory that meets CFR §141.84 on a schedule agreed upon by the State. CFR §141.90(e)(3)(ii) |
| Address Line1 | First line of the administrative contact's physical address. |
| Address Line2 | Second line of the administrative contact's address. |
| Admin Name | Name of the water system administrative contact - usually a person's name. |
| Agency Type | The type of agency performing the site visit. |
| Agency Type Code | A coded value that represents the type of agency conducting the visit, such as, City, County, Federal etc. |
| Alt Phone Number | Administrative contact's alternative telephone number. |
| Analyte Code | A code value that represents the analyte sampled. |
| Analyte Full Name | Long name of the analyte sampled. |
| Analyte Name | Common name of the analyte sampled. |
| Analyte Short Name | Short name of analyte sampled. |
| ANSI Entity Code | American National Standards Institute (ANSI) code for the county, city, or legal statistical area. Taken with the ANSI state code, uniquely identifies a county (or other area) within the county. |
| ANSI State Code | ANSI code for the state. Taken with the ANSI area code, uniquely identifies a county (or other area) within the county. |
| Area Type | Indicates the area type. TR - Tribal CN - County ZC - Zip Code CT - City IR - Indian Reservation |
| Area Type Code | Indicates the area type by code. TR - Tribal CN - County ZC - Zip Code CT - City IR - Indian Reservation |
| Availability Code | Code for how the source water is utilized by a water system. E - Emergency I - Interim O - Other P - Permanent S - Seasonal |
| Availability Description | Description of how the source water is utilized by a water system. E - Emergency I - Interim O - Other P - Permanent S - Seasonal |
| CAS Number | A numerical designation for chemicals that is maintained by the Chemical Abstracts Service (CAS) of the American Chemical Society. |
| Cities Served | Name of the city served. Water systems can serve one or more cities, counties, tribal areas, or zip codes and a system that serves such an area does not necessarily serve the entire population of that area |
| City Name | Name of the city within which the facility is located. |
| City Served | Name of the city served by the system of interest. |
| Combined Distribution System ID | Combined Distribution System identifier that indicates a combined distribution system. The interconnected distribution system consisting of the distribution systems of wholesale systems and of the consecutive systems that receive some or all of their finished water from those wholesale systems. |
| Compliance Evaluation | Result of the compliance evaluation by description. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Compliance Evaluation Code | Result of the evaluation by code. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Compliance Period Begin Date | The calendar date of the beginning of a period in which a public water system was determined to be in violation of a primary drinking water regulation. |
| Compliance Period End Date | The calendar date of the end of a period in which a public water system was in violation of a primary drinking water regulation. |
| Compliance Status | The current status of violation. K - Known: for violations with populated compliance period end dates that are not returned to compliance or inactivated O - Open: for violations without compliance period end dates that are not returned to compliance or inactivated R - Returned To Compliance: violation was returned to compliance (RTC) I - Inactivated: system was inactivated. |
| Compliance Status Code | Code indicating the current status of violation. K - Known: for violations with populated compliance period end dates that are not returned to compliance or inactivated O - Open: for violations without compliance period end dates that are not returned to compliance or inactivated R - Returned To Compliance: violation was returned to compliance (RTC) I - Inactivated: system was inactivated. |
| Contaminant Code | A code value that represents a contaminant for which a public water system has incurred a violation of a primary drinking water regulation. |
| Contaminant Name | The contaminant for which a public water system has incurred a violation of a primary drinking water regulation, such as, lead, chlorine, etc. |
| Corrective Action ID | Unique ID that represents the corrective action taken by a public water system to resolve a violation. |
| Counties Served | Name of the county served. |
| Country Code | Two character abbreviation of the country code where the administrative contact is located. |
| County Served | Name of the county served |
| County Tribal | Bureau of Indian Affairs (BIA) code indicating the Tribal land where a facility is located. |
| Data Verification Evaluation | An Evaluation conducted to verify data entered to SDWIS. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Data Verification Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| DBPR Schedule Category | Stage 2 Disinfectant Byproducts Rule (DBPR) schedule category. Provides description for DBPR Schedule Category Code. 1 – System serving 100K or more people OR systems that are connected to a system serving 100K or more 2 - System serving 50K to 99,999 people OR belonging to a combined distribution system in which the largest system serves 50K to 99,999 3 - System serving 10K to 49,999 people OR belonging to a combined distribution system in which the largest system serves 10K to 49,999 4 - System serving fewer than 10,000 AND not connected to a larger system |
| DBPR Schedule Category Code | Stage 2 Disinfectant Byproducts Rule (DBPR) schedule category code. 1 – System serving 100K or more people OR systems that are connected to a system serving 100K or more 2 - System serving 50K to 99,999 people OR belonging to a combined distribution system in which the largest system serves 50K to 99,999 3 - System serving 10K to 49,999 people OR belonging to a combined distribution system in which the largest system serves 10K to 49,999 4 - System serving fewer than 10,000 AND not connected to a larger system |
| Distribution Evaluation | An evaluation of the distribution system. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Distribution Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Email Address | Email address for the water system |
| Enforcement Action | The most recent enforcement action taken against this violation. |
| Enforcement Action Type Code | Code for the most recent enforcement action taken against this violation. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| EPA Region | Two-digit code (01…10) for the EPA region having regulatory oversight for the water system. |
| EPA Region Name | The EPA region having regulatory oversight for the water system. |
| ERP Certified 2020-2021 | This column indicates which community water systems serving a population over 3,300 have certified (Y) or have not yet certified (N) completion of an emergency response plan (ERP) as required by Section 2013 of America's Water Infrastructure Act (AWIA) for the 2020-2021 compliance cycle. The data in this column is posted to SDWIS after the RRA certification deadline for each AWIA-specified size-category has passed. |
| Event Actual Date | The calendar date by which the activity must be successfully completed. Activities include Fecal Indicator Contamination Action, Lead Service Line Inventory, etc. |
| Event Comments | Any description, characteristic, or attribute that the State or EPA region wants to record for the scheduled activity. |
| Event End Date | The calendar date when the scheduled activity was successfully completed. This date is optional if the Event Activity code is "DONE". |
| Event Milestone | Events performed under the lead and copper, total coliform, revised total coliform, or lead and copper rule improvements. DEEM - System deemed optimized without Optimal Corrosion Control Treatment (OCCT) DONE - System done with OCCT FICF - Fecal Indicator Contamination Action FICI - Fecal Indicator Interim Step LSLR - Lead service line replacement required RTL1 - Revised Total Coliform Rule Level 1 Treatment Technique Trigger RTL2 - Revised Total Coliform Rule Level 2 Treatment Technique Trigger SDFF - Significant Deficiency/Sanitary Defect Corrective Action SDFI - Significant Deficiency/Sanitary Defect Interim Step |
| Event Milestone Code | Codes for events performed under the lead and copper, total coliform, revised total coliform, or lead and copper rule improvements. DEEM - System deemed optimized without Optimal Corrosion Control Treatment (OCCT) DONE - System done with OCCT FICF - Fecal Indicator Contamination Action FICI - Fecal Indicator Interim Step LSLR - Lead service line replacement required RTL1 - Revised Total Coliform Rule Level 1 Treatment Technique Trigger RTL2 - Revised Total Coliform Rule Level 2 Treatment Technique Trigger SDFF - Significant Deficiency/Sanitary Defect Corrective Action SDFI - Significant Deficiency/Sanitary Defect Interim Step |
| Event Reason | Reasons for undertaking an event performed under the lead and copper, total coliform, revised total coliform, or lead and copper rule improvements. B1 - Serving fewer than 50,000 B3 - Serving greater than 50,000: met action levels GW - Ground Water Rule L1TC - Level 1 Coliform Positive Insufficient Repeat Treatment Technique Trigger L1TD - Level 1 Multiple Total Coliform Positive Treatment Technique Trigger L2TA - Maximum Contaminant Level Treatment Technique Trigger L2TB - Second Level 1 Treatment Technique Trigger RTCR - Revised Total Coliform Rule SH - Subpart H (Interim Enhanced Surface Water Treatment Rule) WQP - Water Quality parameters |
| Event Reason Code | Codes indicating the reasons for undertaking an event performed under the lead and copper, total coliform, revised total coliform, or lead and copper rule improvements. B1 - Serving fewer than 50,000 B3 - Serving greater than 50,000: met action levels GW - Ground Water Rule L1TC - Level 1 Coliform Positive Insufficient Repeat Treatment Technique Trigger L1TD - Level 1 Multiple Total Coliform Positive Treatment Technique Trigger L2TA - Maximum Contaminant Level Treatment Technique Trigger L2TB - Second Level 1 Treatment Technique Trigger RTCR - Revised Total Coliform Rule SH - Subpart H (Interim Enhanced Surface Water Treatment Rule) WQP - Water Quality parameters |
| Event Schedule ID | ID that uniquely identifies an activity taken in respect to a milestone. |
| Facility Activity | The value of this attribute indicates the status of the facility. |
| Facility Activity Code | Code for the status of the facility. A - Active I - Inactive M - Merged with another system N - Changed from public to non-public P - Potential future system to be regulated |
| Facility Deactivation Date | Date when the water system was deactivated (water system no longer actively serving water) or removed from federal oversight because it no longer met SDWA criteria as a public water system. This column is NULL if the water system is active. |
| Facility ID | Identification that identifies a facility for a water system. When this ID is used with the PWSID, it uniquely identifies a water system facility. Note: Facilities from different water systems may have the same Facility ID. There may be repeat Facility ID values nationally but not for the same water system. |
| Facility Name | Name of water system facility. |
| Facility Type | Indicates the type of water system facility, such as intake, treatment plant, well, etc. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Facility Type Code | Code that indicates the type of water system facility, such as, intake, treatment plant, well, etc. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Fax Number | Administrative contact's fax number. |
| Filtration Status | Indicates whether a non-emergency surface water source or a nonemergency ground water under the influence of surface water source is required to install filtration by a certain date or is successfully avoiding filtration. |
| Filtration Status Code | A code reported by the state to indicate whether a non-emergency surface water source or a nonemergency ground water under the influence of surface water source is required to install filtration by a certain date or is successfully avoiding filtration. FIL - Filtration already in place MI - Must install filtration SAF - Successfully avoiding filtration |
| Financial Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Financial Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Finished Water Storage Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Finished Water Storage Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| First Reported Date | The date that the record for this water system was reported for the first time to EPA. |
| GW SW | Indicates if the water system is considered having a ground water (GW) or surface water (SW) source under SDWA. Systems with any surface water source are considered surface water. |
| GW SW Code | Code which indicates if the water system is considered having a ground water (GW) or surface water (SW) source under SDWA. Systems with any surface water source are considered surface water. |
| Is Grant Eligible | Code (Y/N) that indicates if the primacy agency has reported the minimum necessary data elements for this water system to include it in grant calculations. |
| Is Health Based | Indicates if this is a health based violation (Y) or not (N). |
| Is Major Violation | A code value that indicates the severity of a Monitoring and Reporting (M&R) violation, major or minor. The major versus minor designation does not apply to a sanitary survey M&R violation. Y/N field. |
| Is Primary Service Area | Indicates if the service area listed is the primary service area, Y/N field. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Is School or Daycare | Indicates if this system is primarily a school or daycare: Yes (Y) / No (N). |
| Is Source | Indicates if this facility type is also a source of water. Y for Yes, N for No, and U for Unknown. |
| Is Source Treated | Code that indicates whether the source water is treated, is not treated or if the treatment status is unknown. Y for Yes, N for No, and U for Unknown. |
| Is Wholesaler | Indicates if the system is a wholesaler of water, indicating that it primarily sells the water it produces to other water systems rather than directly to consumers. |
| Lab Assigned ID | Unique numeric code assigned to the sample by the laboratory that analyzed the sample. |
| Lab Method | Number identifying the laboratory method used to analyze the sample. |
| Last Reported Date | The date that the information for this water system was last reported to EPA |
| Latest ALE Sample Date | Date of the latest lead action level exceedance (ALE) sample. |
| Latest Enforcement ID | The most recent enforcement action taken against this violation. |
| Latest Sample Is ALE | Identifies if the latest sample is a lead action level exceedance (ALE). Yes (Y)/ No (N) field. |
| Less Than Code | MRL, Minimum Reporting Level, the minimum concentration that can be measured for the compound. |
| Less Than Indicator | Indicates whether result was less than the MRL, Y/N field. |
| LSL Begin Date | Date the service line inventory was conducted by the public water system. |
| LT2 Schedule Category | Identifies the category for LT2 schedule. 1 - At least 100,000 2 - 50,000 to 99,999 3 - 10,000 to 49,999 4 - 9,999 or less |
| LT2 Schedule Category Code | Code that identifies the category for LT2 schedule. 1 - At least 100,000 2 - 50,000 to 99,999 3 - 10,000 to 49,999 4 - 9,999 or less |
| Management Operation Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Management Operation Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Minimum Reporting Level | The minimum concentration that can be measured for the compound. |
| MRL Units | Units for the Minimum Reporting Level: micrograms per liter (ug/L), a concentration unit where there is one microgram of the analyte found within one liter of water. |
| NPM Candidate | Public Water System National Program Measure candidate; indicates whether the PWS was open during part or all of the latest 4 quarters of data from the selected Submission Year and Quarter. |
| NPM Candidate Vio | Public Water System National Program Measure candidate; indicates whether the violation was open during part or all of the latest 4 quarters of data from the selected Submission Year and Quarter. |
| Number Exceedances | A count indicating the number of samples exceeding a specific parameter. |
| Number Missing Samples | A count indicating the number of samples that are required to be taken for a Monitoring and Reporting (M&R) violation. |
| Number of Systems with Population >3300 with a Sample | Number of Systems with Population >3300 with a Pb90th sample (the concentration of lead in the top ten percent of samples) reported. |
| Number Required Samples | A count indicating the number of samples that were not taken for a Monitoring and Reporting (M&R) violation. |
| Org Name | The name of the organization where the administrative contact works. |
| Originator | Indicates if the enforcement action was initiated by an EPA Region (R) or by a state, territory, or tribe (S). |
| Originator Code | Code that Indicates if the enforcement action was initiated by an EPA Region (R) or by a state, territory, or tribe (S). |
| Other Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Other Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Outstanding Performer | Indicates whether a water system has been designated an outstanding performer for purposes of reduced sanitary survey frequency eligibility. Yes (Y)/No (N) field. |
| Outstanding Performer Begin Date | Date when the systems was designated an outstanding performer |
| Owner Type | The ownership category of the water system. F - Federal Government L - Local Government M - Public/Private N - Native American P - Private S - State Government |
| Owner Type Code | Code that identifies the ownership category of the water system. F - Federal Government L - Local Government M - Public/Private N - Native American P - Private S - State Government |
| Phone Ext Number | The telephone extension of the administrative contact. |
| Phone Number | Administrative contact's telephone number. |
| Pop Cat 11 | Field that groups water systems into a population category based on population served by the water system with 1 as the lowest pop category and 11 as the highest pop category. 1: <=100 2: 101-500 3: 501-1,000 4: 1,001-3,300 5: 3,301-10,000 6: 10,001-50,000 7: 50,001-100,000 8: 100,001-250,000 9: 250,001-500,000 10: 500,001-1,000,000 11: >1,000,000 |
| Pop Cat 11 Code | Numeric code that groups water systems into a population category based on population served by the water system. 1: <=100 2: 101-500 3: 501-1,000 4: 1,001-3,300 5: 3,301-10,000 6: 10,001-50,000 7: 50,001-100,000 8: 100,001-250,000 9: 250,001-500,000 10: 500,001-1,000,000 11: >1,000,000 |
| Pop Cat 2 | Field that groups water systems into a population category based on population served by the water system. 1: <10,000 2: 10,000+ |
| Pop Cat 2 Code | Numeric code that groups water systems into a population category based on population served by the water system. 1: <10,000 2: 10,000+ |
| Pop Cat 3 | Field that groups water systems into a population category based on population served by the water system. 1: <=3300 2: 3,301-50,000 3: >50,000 |
| Pop Cat 3 Code | Numeric code that groups water systems into a population category based on population served by the water system. 1: <=3300 2: 3,301-50,000 3: >50,000 |
| Pop Cat 4 | Field that groups water systems into a population category based on population served by the water system. 1: <10K 2: 10K-49,999 3: 50K-99,999 4: 100K+ |
| Pop Cat 4 Code | Numeric code that groups water systems into a population category based on population served by the water system. 1: <10K 2: 10K-49,999 3: 50K-99,999 4: 100K+ |
| Pop Cat 5 | Field that groups water systems into a population category based on population served by the water system. 1: <=500 2: 501-3,300 3: 3,301-10,000 4: 10,001-100,000 5: >100,000 |
| Pop Cat 5 Code | Numeric code that groups water systems into a population category based on population served by the water system. 1: <=500 2: 501-3,300 3: 3,301-10,000 4: 10,001-100,000 5: >100,000 |
| Population Served Count | Estimate of the number of people served by the system. |
| Population Served Count Vio | Estimate of the number of people served by the system. |
| Primacy Agency | Name of the state or territory having regulatory oversight for the water system. If the water system is regulated directly by EPA, this code will consist of the two-digit EPA Region number (01…10). The Navajo Nation (NN) has primacy over its water systems. |
| Primacy Agency Code | Two character postal code for the state or territory having regulatory oversight for the water system. If the water system is regulated directly by EPA, this code will consist of the two-digit EPA Region number (01…10). The Navajo Nation has primacy over its water systems, so NN is used in this case. |
| Primacy Type | Indicates if the water system is regulated by a state, tribal, or territorial primacy program. Note that EPA direct implementation programs, except for Wyoming, are tribal primacy programs. |
| Primary Source | Identifies the primary source of water for the water system to a further extent. GW - ground water GWP - groundwater purchased SW - surface water (SW), surface water purchased GU - groundwater under influence of surface water GUP - purchased ground water under influence of surface water source |
| Primary Source Code | Code that identifies the primary source of water for the water system to a further extent. GW - ground water GWP - groundwater purchased SW - surface water (SW), surface water purchased GU - groundwater under influence of surface water GUP - purchased ground water under influence of surface water source |
| Public Notification Tier | Numeric code for Public Notification Tier required for the violation or situation. Tier 1 - Notification within 24 hours Tier 2 - Notification within 30 days Tier 3 - Notification within a year |
| Pumps Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Pumps Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| PWS Activity Code | A public water system's most recent state of operation. A - Active I - Inactive M - Merged with another system N - Changed from public to non-public P - Potential future system to be regulated |
| PWS Activity Type | A public water system's most recent state of operation. A - Active I - Inactive M - Merged with another system N - Changed from public to non-public P - Potential future system to be regulated |
| PWS Deactivation Date | Date when the water system was deactivated (water system no longer actively serving water) or removed from federal oversight because it no longer met SDWA criteria as a public water system. This column is NULL (empty) if the water system is active. |
| PWS ID | ID that uniquely identifies a Public Water System. |
| PWS Name | The PWS name for the water system in the SDWIS Federal Data Warehouse database. |
| PWS Type | Definition of each individual PWS type code. CWS - Community Water System NTNCWS - Non-transient Non-Community Water System TNCWS - Transient Non-Community Water System |
| PWS Type Code | A code value which classifies the type of public water system according to federal and state requirements. CWS - Community Water System NTNCWS - Non-transient Non-Community Water System TNCWS - Transient Non-Community Water System |
| Reconciliation ID | An identifier used for reconciliation with the state data system or LAB assigned identifiers. |
| Reduced Monitoring Begin Date | Initial start date of the reduced monitoring period for a system. |
| Reduced Monitoring End Date | End date of the reduced monitoring period for a system. |
| Reduced RTCR Monitoring | Frequency of Revised Total Coliform Rule (RTCR) reduced monitoring, which can be annual, semi-annual, quarterly, or every two months. |
| Reported PN Tier | Numeric code for Public Notification Tier required for the violation or situation that was reported by the primacy agency. Tier 1 - Notification within 24 hours Tier 2 - Notification within 30 days Tier 3 - Notification within a year |
| Reported Rule Name | Name of the National Primary Drinking Water Rule reported by the primacy agency. |
| Result | Concentration result of the analyte sample. <MRL = less than the Minimum Reporting Level. |
| Result Sign | A sign used to indicate the detection limit reported for the data element Sample Measure. E: Equal to, meaning exactly equal to the value reported L: Less than, meaning below minimum detection limits |
| Result Sign Code | A sign used to indicate the detection limit reported for the data element Sample Measure. E: Equal to, meaning exactly equal to the value reported L: Less than, meaning below minimum detection limits |
| RRA Certified 2020-2021 | This column indicates which community water systems serving a population over 3,300 have certified (Y) or have not yet certified (N) completion of a risk and resilience assessment (RRA) as required by Section 2013 of America's Water Infrastructure Act (AWIA) for the 2020-2021 compliance cycle. The data in this column is posted to SDWIS after the RRA certification deadline for each AWIA-specified size-category has passed. |
| RTC Date | The Return To Compliance (RTC) date. |
| RTC Enforcement ID | The most recent Enforcement Action taken against this Violation to Return To Compliance (RTC). |
| Rule Code | Code for a National Primary Drinking Water rule. |
| Rule Family | The rule family a violation falls under. 110: Total Coliform Rules 120: Surface Water Treatment Rules 130: Filter Backwash Rule 140: Groundwater Rule 210: Stage 1 Disinfectants and Disinfection Byproducts Rule 220: Stage 2 Disinfectants and Disinfection Byproducts Rule 230: Total Trihalomethanes 310: Volatile Organic Chemicals 320: Synthetic Organic Chemicals 330: Inorganic Chemicals 340: Radionuclides 350: Lead and Copper Rule 400: Other 410: Public Notice Rule 420: Consumer Confidence Rule 430: Miscellaneous 500: Not Regulated |
| Rule Family Code | Code representing the rule family a violation falls under. 110: Total Coliform Rules 120: Surface Water Treatment Rules 130: Filter Backwash Rule 140: Groundwater Rule 210: Stage 1 Disinfectants and Disinfection Byproducts Rule 220: Stage 2 Disinfectants and Disinfection Byproducts Rule 230: Total Trihalomethanes 310: Volatile Organic Chemicals 320: Synthetic Organic Chemicals 330: Inorganic Chemicals 340: Radionuclides 350: Lead and Copper Rule 400: Other 410: Public Notice Rule 420: Consumer Confidence Rule 430: Miscellaneous 500: Not Regulated |
| Rule Group | National Primary Drinking Water rule group. 100: Microbials 200: Disinfectants and Disinfection Byproducts Rule 300: Chemicals 400: Other 500: Not Regulated |
| Rule Group Code | Code for a National Primary Drinking Water rule group. 100: Microbials 200: Disinfectants and Disinfection Byproducts Rule 300: Chemicals 400: Other 500: Not Regulated |
| Rule Name | Name of the National Primary Drinking Water Rule. |
| Sample Analysis Date | Date of sample analysis. |
| Sample Collection Date | Date the sample was collected. |
| Sample ID | Unique identifier for the sample. |
| Sample Location | Location where sample was collected within the water system. |
| Sample Measure (mg/L) | The result obtained from a sample analysis in milligrams per liter. |
| Sample Point | Code identifying the location at which the sample was taken within the water system. |
| Sample Result ID | Contains an identifying value referencing a sample result record in the primacy agency’s system of record. This column is conditionally mandatory based upon the type of violation per the rule reporting guidance. As an example, Ground Water Rule requires that with a Type 34- failure to monitor at the source, that the triggering positive total coliform result be reported. (GWR 141.402(a)(1), 141.402(a)(3) and 141.402(b))) |
| Sample Type Abbreviation | Code identifying the sample type collected: OC - Other, SP - Special. |
| Sampling End Date | Date of the last day of the monitoring period in which 90th percentile data for lead or copper was acquired. |
| Sampling Start Date | Date of the first day of the monitoring period in which 90th percentile data for lead or copper was acquired. |
| SAR ID | A system-generated number managed by the reporting jurisdiction that uniquely identifies each Sample Result record. As there a situations where there can be two sample results for a sample, the SAR_ID is used instead of the Contaminant code (as in ODS) in the primary key of this table. |
| Season Begin Date | If this is a seasonal water system (not open year-round), this column will contain the opening month and day of the period of time when the water system serves water. The column is NULL if the water system serves water year-round. |
| Season End Date | If this is a seasonal water system (not open year-round), this column will contain the ending month and day of the period of time when the water system serves water. The column is NULL if the water system serves water year-round. |
| Seasonal Startup System | Indicates whether the system is pressurized all year including during the off-season or whether the system was not pressurized all year. Only pertains to seasonal systems. |
| Security Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Security Evaluation Code | Code of the result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Seller PWS ID | PWSID of the water system that is selling water to this system through this interconnection. Is also the upstream water system to the parent of this facility. |
| Seller PWS Name | Name of the water system that is selling water to this system through this interconnection. Is also the upstream water system to the parent of this facility. |
| Seller Treatment | Indicates whether the seller is or is not treating the source or whether the seller treatment status is unknown. Applies only to source facilities. F: Filtered G: Treated by seller, including 4-log for the Ground Water Rule N: Not treated U: Unknown Y: Partially treated by seller |
| Seller Treatment Code | Code that indicates whether the seller is or is not treating the source or whether the seller treatment status is unknown. Applies only to source facilities. F: Filtered G: Treated by seller including 4-log for the Ground Water Rule N: Not treated U: Unknown Y: Partially treated by seller |
| Service Area Type | Definition of each individual service area type code. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Service Area Type Code | Two character alphabetic abbreviation of service area type. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Service Connections Count | Number of service connections to the water system. |
| Service Line Report Status | Identifies the public water system's status in reporting required service line types. Reported all required service line types Reported some but not all required service line types Did not report any required service line types |
| Severity Indicator Count | A count of the samples exceeding limits for certain Disinfectant ByProduct Rule (DBPR) and Interim Enhanced Surface Water Treatment Rule (IESWTR) violations. |
| SFDW Facility ID | Identification that identifies a facility for a water system. When this ID is used with the PWS ID, it uniquely identifies a water system facility. Note: Facilities from different water systems may have the same Facility ID. There may be repeat Facility ID values nationally but not for the same water system. |
| SFDW Facility Name | Name of water system facility. |
| SFDW Facility Type | Indicates the type of water system facility, such as intake, treatment plant, well, etc. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| SFDW GW SW | Indicates if the water system is considered having a ground water (GW) or surface water (SW) source under SDWA. Systems with any surface water source are considered surface water. |
| SFDW PWS Name | The PWS name for the water system in the SDWIS Federal Data Warehouse database. |
| Source Protection Begin Date | Date when the system's source water was protected. |
| Source Water Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Source Water Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Source Water Protection Code | Indicates if the source for the system is protected. Yes (Y), No (N), and Unknown (U). |
| State Code | Official United States Postal Service (USPS) code for the states and outlying areas. For the purposes of the data warehouse, the code NN is used for the Navajo Nation. |
| State Facility ID | The ID that a state uses to identify a facility in their own state system database. Usually different than PWSID in SDWIS. |
| State MCL | A numeric value that represents the maximum contaminant level which was exceeded that led to the identification of an MCL violation for a public water system. State MCLs must be at least as stringent as federal MCLs. |
| Submission Quarter | Calendar quarter of data freeze. Data is submitted quarterly with a one quarter delay for data entry and quality assurance checks. |
| Submission Status | Indicates whether an active water system was reported, rejected, or not reported during the recent inventory submission. This field is not applicable to inactive water systems. Generated by EPA's Output Delivery System (ODS). Y - Reported and accepted U - Unreported R - Reported but rejected |
| Submission Status Code | Code that indicates whether an active water system was reported, rejected, or not reported during the recent inventory submission. This field is not applicable to inactive water systems. Generated by EPA's Output Delivery System (ODS). Y - Reported and accepted U - Unreported R - Reported but rejected |
| Submission Status Code Vio | Code that indicates whether an active water system was reported, rejected, or not reported during the recent violation submission. This field is not applicable to inactive water systems. Generated by EPA's Output Delivery System (ODS). Y - Reported and accepted U - Unreported R - Reported but rejected |
| Submission Year | Calendar year of data freeze; Calendar year of data submission to Safe Drinking Water Information System (SDWIS); best thought of as year of version control. Data is submitted quarterly with a one quarter delay for data entry and quality assurance checks. |
| Submission Year Quarter | Quarter of data submission to Safe Drinking Water Information System (SDWIS); best thought of as year of version control. Data is submitted quarterly with a one quarter delay for data entry and quality assurance checks. |
| Sum (PFOS + PFOA) | Aggregate result of PFOS and PFOA. |
| Total # Service Lines Reported | Total number of service lines identified and reported by the public water system on its service line inventory. |
| Total Number of Systems with Population >3300 | Total Number of Systems with Population >3300. Systems serving below 3,300 are not required to report lead and copper samples unless they are above the action level. |
| Total Systems | Total Number of Systems in the latest LCR sampling period (null data.) |
| Total Systems with Sample | Total Number of Systems with a LCR sample in the latest sampling period. |
| Treatment Comments | Comments further describing the collection, processing, or interpretation of the latitude, longitude and/or vertical data. |
| Treatment Evaluation | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Treatment Evaluation Code | Result of the evaluation. M = Minor Deficiencies N = No deficiencies or recommendations R = Recommendations made S = Significant deficiencies X = Not Evaluated Z = Not applicable |
| Treatment ID | Treatment ID that uniquely identifies a treatment process for this treatment plant. |
| Treatment Objective | Categorizes the treatment objective to be attained through treatment of a source of water. |
| Treatment Objective Code | A code value that categorizes the treatment objective to be attained through treatment of a source of water. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Treatment Plant City Name | Name of the city within which the facility is located. |
| Treatment Plant Country Name | Two character abbreviation of the country code where the administrative contact is located. |
| Treatment Plant State Code | Official United States Postal Service (USPS) code for the states and outlying areas. For the purposes of the data warehouse, the code NN is used for the Navajo Nation. |
| Treatment Plant Street Address 1 | The first line of an address applicable to the Legal Entity being reported. |
| Treatment Plant Street Address 2 | The second line of an address applicable to the legal entity being reported. |
| Treatment Plant Zip Code | Five-digit postal zip code of the treatment plant. |
| Treatment Process | The treatment process used to obtain the treatment objective. |
| Treatment Process Code | Code representing the treatment process used to obtain the treatment objective. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Tribal Code | The three-digit EPA code which represents the Indian reservation or Alaska Remote Village being served by a water system. |
| Tribal Description | Definition of each individual tribal code. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Tribe Name | Name of the tribe, matches the BIA tribal code used in the County Tribe field. |
| Unit Of Measure | The unit of measure (UM) that is associated with the value reported for SAMPLE ANALYSIS RESULT. |
| Unit Of Measure Description | The unit of measure (UM) that is associated with the value reported for SAMPLE ANALYSIS RESULT. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Units | Units for the sample result concentration, micrograms per liter (ug/L). |
| Validity Indicator | EPA generated field indicating if record passes EPA data quality checks. |
| Violation Category Code | Code for violation categories. MCL: Maximum Contaminant Level MRDL: Maximum Residual Disinfectant Level TT: Treatment Technique MR: Monitoring and Reporting MON: Monitoring RPT:Reporting Other |
| Violation Code | Two character code identifying a violation type. |
| Violation First Reported Date | The date that the record for this violation was reported for the first time to EPA. |
| Violation ID | An alphanumeric value used to uniquely identify a specific violation of a primary drinking water regulation incurred by a public water system. |
| Violation Last Reported Date | The date that the record for this violation was last reported to EPA. |
| Violation Measure | A numeric value that represents the result obtained from a single analysis, or the average result obtained from multiple analyses, that led to the identification of an MCL violation for a public water system. |
| Violation Type | Indicates the type of violation. |
| Visit Comments | An alphanumeric value that represents any description, characteristic, or attribute that the State or EPA. |
| Visit Date | Date of the site visit/inspection. |
| Visit ID | A value used to uniquely identify a specific on-site visit made to a Water System. |
| Visit Reason | Description of the reason for a site visit. |
| Visit Reason Code | A code value that represents the reason why this activity is required. See SDWIS Federal Data Reporting Requirements for a complete listing of codes. |
| Water Type | Indicates the source of the water. GW - Ground Water SW - Surface water GU - Ground water under the influence of surface water |
| Water Type Code | Code that indicates the source of the water. GW - Ground Water SW - Surface water GU - Ground water under the influence of surface water |
| Zip Code | Five-digit postal zip code served. |
| Zip Code Served | Five-digit postal zip code served. |