+------------------------+---------------------------------------------+
| ![](media/image1.png)  | ![](medi                                    |
|                        | a/image3.jpeg){width="1.4583333333333333in" |
| ![](media/image2.png)  | height="0.7916666666666666in"}**SDWIS/ODS\  |
|                        | Quality Assurance Utility 3.0 Installation  |
| United States          | and User Guide**                            |
| Environmental          |                                             |
| Protection Agency      |                                             |
|                        |                                             |
| Office of Ground Water |                                             |
| and Drinking Water     |                                             |
|                        |                                             |
| Contract No.           |                                             |
| EPA-1001002            |                                             |
|                        |                                             |
| SDWIS Project          |                                             |
|                        |                                             |
| Product Control No.    |                                             |
|                        |                                             |
| Gui                    |                                             |
| dent-SAIC-SDWIS-12.d1c |                                             |
|                        |                                             |
| Deliverable No. 12.d1  |                                             |
|                        |                                             |
| March 31, 2008         |                                             |
+------------------------+---------------------------------------------+

**SDWIS/ODS**

**QUALITY ASSURANCE UTILITY 3.0**

**Installation and User Guide**

**CONTRACT NO. EPA-1001002**

**SDWIS PROJECT**

**Prepared for:**

**United States Environmental Protection Agency**

**Office of Ground Water and Drinking Water**

**Drinking Water Protection Division**

**1200 Pennsylvania Ave., NW**

**Washington, DC 20460**

**Contracting Officer Representative**

**Clint Lemmons**

**Prepared by:**

**SAIC Solutions Delivery Center**

**Science Applications International Corporation**

**6565 Arlington Boulevard**

**Falls Church, VA 22042**

CONTENTS

[1.0 Introduction 1](#introduction)

[2.0 Requesting a Qa Extract 1](#requesting-a-qa-extract)

[3.0 Using the QA IMPORT TOOL 4](#using-the-qa-import-tool)

[3.1 QA Import Utility User Instructions
4](#qa-import-utility-user-instructions)

[3.2 Using the Imported Data 6](#using-the-imported-data)

**APPENDIX A** Descriptions of Tables And Column

**APPENDIX B** Map Objects and Elements to XML Schema, SDWIS/STATE
Database, and SDWIS/ODS Database

**EXHIBITS**

[**Exhibit 1.** Central Data Exchange Request Page
2](#__RefHeading___Toc194723343)

[**Exhibit 2.** SDWIS ODS File Request 3](#__RefHeading___Toc194723344)

[**Exhibit 3.** QA Extract Request Confirmation Page
3](#__RefHeading___Toc194723345)

[**Exhibit 4.** SDWIS/ODS QA Import Utility
5](#__RefHeading___Toc194723346)

[**Exhibit 5.** Import Successfully Completed
5](#__RefHeading___Toc194723347)

# Introduction

During the Safe Drinking Water Information System/Operational Data
System (SDWIS/ODS) Joint Requirements Planning (JRP) sessions, the state
and regional participants expressed a need to access data in SDWIS/ODS
for problem resolution and tactical analysis. Access to the data from
the SDWIS/ODS database is required prior to its availability in the data
warehouse. The Quality Assurance Extract and Import Utility were
developed to satisfy that need.

Upon request, the data for a single primacy agency is extracted from
SDWIS/ODS into standard text files referred to as the Quality Assurance
(QA) Extract. The requesting user loads the QA Extract into a Microsoft
(MS) Access database using the Import Tool. To satisfy their specific
requirements, users may develop queries and reports against the data in
the MS Access database.

This document provides instructions for requesting a QA Extract and
using the QA Import Tool to load the extracted data into the MS Access
database.

# Requesting a Qa Extract

You may request a QA Extract from the SDWIS/ODS through EPA's Central
Data Exchange (CDX) by completing the following steps:

1.  Access the CDX home page.

2.  Follow the instructions on the CDX pages to access your MyCDX page
    as depicted in Exhibit 1.

3.  Click on the SDWIS: SDWIS ODS File Request link from the MyCDX page
    (Exhibit 1). The SDWIS ODS File Request page is displayed as
    depicted in Exhibit 2.

4.  Select the primacy agency for which you are requesting a QA Extract.
    If you are representing a primacy agency, your primacy agency will
    be presented in the text box labeled State. If you are representing
    a region, the dropdown list box lists the primacy agencies for which
    you are responsible.

5.  Enter the starting date for data to be extracted. If a starting data
    is not entered, SDWIS/ODS assumes a start date 10 years prior to the
    current date.

6.  Click on the **Start** button and the confirmation page depicted in
    Exhibit 3 is presented. Your request is forwarded to SDWIS/ODS for
    processing and the data extraction is initiated. After the
    extraction is completed, the QA Extract is returned to CDX for
    delivery to your CDX Inbox.

7.  Retrieve the QA Extract from your CDX Inbox.

![](media/image4.png){width="6.159722222222222in"
height="3.8159722222222223in"}

[]{#__RefHeading___Toc194723343 .anchor}**Exhibit 1.** Central Data
Exchange Request Page

![](media/image5.png){width="6.170833333333333in" height="3.825in"}

[]{#__RefHeading___Toc194723344 .anchor}**Exhibit 2.** SDWIS ODS File
Request

![](media/image6.png){width="6.161111111111111in"
height="3.8194444444444446in"}

[]{#__RefHeading___Toc194723345 .anchor}**Exhibit 3.** QA Extract
Request Confirmation Page

# Using the QA IMPORT TOOL 

After receipt of the text files, use the QA Import Tool, developed in MS
Access, to load the data into an MS Access database. You may access the
extracted data set using the standard MS Access reporting and querying
capabilities. Since the structure of the MS Access database mirrors that
of SDWIS/ODS, the table and column names are the same as those described
for SDWIS/ODS. Appendix A contains descriptions of the tables and
column. Appendix B contains a mapping of the SDWIS/FedRep elements to
the XML schema element tags and the SDWIS/STATE and SDWIS/ODS table and
column names.

After the data is imported into the MS Access database, you may access
the extracted data set using the standard MS Access reporting and
querying capabilities.

## QA Import Utility User Instructions

To import the data, complete the following steps:

1.  Unzip the QA Extract file, which contains the text files into an
    empty directory. Note: The directory must ONLY contain the text
    files extracted from the zip file; no other text files may be placed
    in the directory.

2.  Create a new copy of the QA Import tool (i.e., the
    ods_QA_Import_Utility.mdb) before starting a new import process. The
    import process clears existing data from the database before loading
    the data contained in the text files. Performing this activity
    prevents previously imported data from being overwritten.

3.  Open the MS Access QA Import tool by double-clicking on the
    ods_QA_Import_Utility.mdb file. The database opens and the QA Import
    Tool form depicted in Exhibit 4 is automatically displayed.

![](media/image7.jpeg){width="6.5in" height="4.375in"}

[]{#__RefHeading___Toc194723346 .anchor}**Exhibit 4.** SDWIS/ODS QA
Import Utility

4.  Click on the **Browse** button and select the directory containing
    the unzipped text files. Note: You must highlight a file within the
    directory to "Select Directory."

5.  Click on **Import** button to start the import process. The process
    is completed when the message box as depicted in Exhibit 5 is
    displayed.

6.  Click the **OK** button to complete the load.

![](media/image8.png){width="2.0520833333333335in"
height="1.0416666666666667in"}

[]{#__RefHeading___Toc194723347 .anchor}**Exhibit 5.** Import
Successfully Completed

## Using the Imported Data

You can now access the data contained in the MS Access database to
create reports and queries for data analysis. The SDWIS Project Team
recommends that you create a separate MS Access database containing the
reports targeting the QA Import database. You can access the data by
creating link tables to the tables in the QA Import database. This
approach will be helpful in maintaining a separation between your
reports and the data, since the data will be continuously refreshed with
each extract process. Refer to Appendix A for descriptions of the tables
and columns.

**APPENDIX A**

Descriptions of Tables and Columns

This page is intentionally left blank.

+-----+---+------------------+------------------+--------------------+
| **  |   |                  |                  |                    |
| SDW |   |                  |                  |                    |
| IS/ |   |                  |                  |                    |
| ODS |   |                  |                  |                    |
| D   |   |                  |                  |                    |
| ata |   |                  |                  |                    |
| bas |   |                  |                  |                    |
| e** |   |                  |                  |                    |
|     |   |                  |                  |                    |
| *   |   |                  |                  |                    |
| *Ta |   |                  |                  |                    |
| ble |   |                  |                  |                    |
| and |   |                  |                  |                    |
| V   |   |                  |                  |                    |
| iew |   |                  |                  |                    |
| D   |   |                  |                  |                    |
| esc |   |                  |                  |                    |
| rip |   |                  |                  |                    |
| tio |   |                  |                  |                    |
| n** |   |                  |                  |                    |
+=====+===+==================+==================+====================+
| **L | * | **Table or View  | **Description**  | **Comment**        |
| ogi | * | Name**           |                  |                    |
| cal | T |                  |                  |                    |
| Pa  | a |                  |                  |                    |
| rti | b |                  |                  |                    |
| tio | l |                  |                  |                    |
| n** | e |                  |                  |                    |
|     | o |                  |                  |                    |
|     | r |                  |                  |                    |
|     | V |                  |                  |                    |
|     | i |                  |                  |                    |
|     | e |                  |                  |                    |
|     | w |                  |                  |                    |
|     | * |                  |                  |                    |
|     | * |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | E                | Itemizes the     |                    |
| ost | a | nforcementAction | Enforcement      |                    |
| ing | b |                  | Actions taken    |                    |
| and | l | stgE             | against a Water  |                    |
| S   | e | nforcementAction | System which may |                    |
| tag |   |                  | include          |                    |
| ing |   |                  | requirements     |                    |
|     |   |                  | that must be met |                    |
|     |   |                  | to rectify a     |                    |
|     |   |                  | failure to       |                    |
|     |   |                  | perform under    |                    |
|     |   |                  | the PWSS         |                    |
|     |   |                  | Program.         |                    |
|     |   |                  | Enforcement      |                    |
|     |   |                  | Actions are      |                    |
|     |   |                  | informal and     |                    |
|     |   |                  | formal and are   |                    |
|     |   |                  | usually          |                    |
|     |   |                  | associated       |                    |
|     |   |                  | Violations that  |                    |
|     |   |                  | were issued      |                    |
|     |   |                  | against the      |                    |
|     |   |                  | Water System.    |                    |
|     |   |                  | Enforcement      |                    |
|     |   |                  | Actions are      |                    |
|     |   |                  | typically issued |                    |
|     |   |                  | by the primacy   |                    |
|     |   |                  | agency but may   |                    |
|     |   |                  | be issued by its |                    |
|     |   |                  | representative   |                    |
|     |   |                  | or the EPA.      |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | EnforcementAs    | Describes the    | The                |
| ost | a | signmentCriteria | Violations for   | Enforcement        |
| ing | b |                  | which a specific | AssignmentCriteria |
| and | l | stgEnforcementAs | enforcement      | is submitted by    |
| S   | e | signmentCriteria | action is taken. | the primacy agency |
| tag |   |                  |                  | with each          |
| ing |   |                  |                  | Enforcement        |
|     |   |                  |                  | Action. Using the  |
|     |   |                  |                  | EnforcementA       |
|     |   |                  |                  | ssignmentCriteria, |
|     |   |                  |                  | each               |
|     |   |                  |                  | EnforcementAction  |
|     |   |                  |                  | is associated to   |
|     |   |                  |                  | one or more        |
|     |   |                  |                  | Violations.        |
+-----+---+------------------+------------------+--------------------+
| P   | T | Event            | Describes        |                    |
| ost | a | ScheduleActivity | actions taken    |                    |
| ing | b |                  | with respect to  |                    |
| and | l | stgEvent         | milestones.      |                    |
| S   | e | ScheduleActivity |                  |                    |
| tag |   |                  |                  |                    |
| ing |   |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | FacilityFlow     | Describes the    |                    |
| ost | a |                  | relationship or  |                    |
| ing | b | stgFacilityFlow  | connections      |                    |
| and | l |                  | between the      |                    |
| S   | e |                  | Water System     |                    |
| tag |   |                  | Facilities.      |                    |
| ing |   |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | GeographicArea   | Identifies       |                    |
| ost | a |                  | political units  |                    |
| ing | b | s                | established by   |                    |
| and | l | tgGeographicArea | geographic       |                    |
| S   | e |                  | boundaries, such |                    |
| tag |   |                  | as State, city,  |                    |
| ing |   |                  | or county served |                    |
|     |   |                  | by a Water       |                    |
|     |   |                  | System.          |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | LegalEntity      | Describes an     |                    |
| ost | a |                  | individual,      |                    |
| ing | b | stgLegalEntity   | corporation, or  |                    |
| and | l |                  | government       |                    |
| S   | e |                  | agency. Contains |                    |
| tag |   |                  | the information  |                    |
| ing |   |                  | such as address, |                    |
|     |   |                  | telephone        |                    |
|     |   |                  | numbers, etc.,   |                    |
|     |   |                  | of the           |                    |
|     |   |                  | individual or    |                    |
|     |   |                  | the entity       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | LegalE           | Characterizes    |                    |
| ost | a | ntityAffiliation | the role assumed |                    |
| ing | b |                  | by entities (as  |                    |
| and | l | stgLegalE        | described in the |                    |
| S   | e | ntityAffiliation | LegalEntity      |                    |
| tag |   |                  | table) for       |                    |
| ing |   |                  | different Water  |                    |
|     |   |                  | Systems and      |                    |
|     |   |                  | Water System     |                    |
|     |   |                  | Facilities.      |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | LocationDetail   | Characterizes a  |                    |
| ost | a |                  | physical         |                    |
| ing | b | s                | location of a    |                    |
| and | l | tgLocationDetail | Water System     |                    |
| S   | e |                  | Facility on the  |                    |
| tag |   |                  | surface of the   |                    |
| ing |   |                  | earth using      |                    |
|     |   |                  | la               |                    |
|     |   |                  | titude/longitude |                    |
|     |   |                  | and altitude     |                    |
|     |   |                  | coordinates.     |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Publ             | Describes which  | The                |
| ost | a | icNoticeCriteria | Violations a     | Pu                 |
| ing | b |                  | specific Public  | blicNoticeCriteria |
| and | l | stgPubl          | Notice Violation |                    |
| S   | e | icNoticeCriteria | is issued for.   | is submitted by    |
| tag |   |                  |                  | the primacy agency |
| ing |   |                  |                  | with each public   |
|     |   |                  |                  | notice Violation.  |
+-----+---+------------------+------------------+--------------------+
| P   | T | Sample           | Describes a      |                    |
| ost | a |                  | water specimen   |                    |
| ing | b | stgSample        | taken for the    |                    |
| and | l |                  | purpose of       |                    |
| S   | e |                  | analyzing water  |                    |
| tag |   |                  | quality. Samples |                    |
| ing |   |                  | may be taken     |                    |
|     |   |                  | from either raw  |                    |
|     |   |                  | (untreated) or   |                    |
|     |   |                  | treated water    |                    |
|     |   |                  | sources. Samples |                    |
|     |   |                  | are typically    |                    |
|     |   |                  | taken at         |                    |
|     |   |                  | different        |                    |
|     |   |                  | locations within |                    |
|     |   |                  | the distribution |                    |
|     |   |                  | system or at     |                    |
|     |   |                  | entry points to  |                    |
|     |   |                  | the distribution |                    |
|     |   |                  | system. The      |                    |
|     |   |                  | object details   |                    |
|     |   |                  | the sample       |                    |
|     |   |                  | collection date, |                    |
|     |   |                  | sample           |                    |
|     |   |                  | analytical       |                    |
|     |   |                  | results,         |                    |
|     |   |                  | contaminant      |                    |
|     |   |                  | details (if      |                    |
|     |   |                  | found), etc.     |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | SampleResult     | Describes the    |                    |
| ost | a |                  | outcome of the   |                    |
| ing | b | stgSampleResult  | sample analysis  |                    |
| and | l |                  | by a laboratory  |                    |
| S   | e |                  | and the field    |                    |
| tag |   |                  | equipment.       |                    |
| ing |   |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | ServiceArea      | Defines the      |                    |
| ost | a |                  | sensitive        |                    |
| ing | b | stgServiceArea   | populations that |                    |
| and | l |                  | receive water    |                    |
| S   | e |                  | from the Water   |                    |
| tag |   |                  | System.          |                    |
| ing |   |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | SiteVisit        | Characterizes    |                    |
| ost | a |                  | the attendance   |                    |
| ing | b | stgSiteVisit     | by a             |                    |
| and | l |                  | representative   |                    |
| S   | e |                  | of a regulatory  |                    |
| tag |   |                  | agency to a      |                    |
| ing |   |                  | Water System or  |                    |
|     |   |                  | Water System     |                    |
|     |   |                  | Facility for the |                    |
|     |   |                  | purpose of       |                    |
|     |   |                  | compliance       |                    |
|     |   |                  | inspection,      |                    |
|     |   |                  | technical        |                    |
|     |   |                  | support, or      |                    |
|     |   |                  | complaint        |                    |
|     |   |                  | investigation.   |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | TreatmentData    | Identifies the   |                    |
| ost | a |                  | objectives and   |                    |
| ing | b | stgTreatmentData | processes for    |                    |
| and | l |                  | treating water   |                    |
| S   | e |                  | intended for     |                    |
| tag |   |                  | safe public      |                    |
| ing |   |                  | consumption from |                    |
|     |   |                  | a Water System   |                    |
|     |   |                  | Facility.        |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Violation        | Describes        |                    |
| ost | a |                  | violations       |                    |
| ing | b | stgViolation     | issued against a |                    |
| and | l |                  | public Water     |                    |
| S   | e |                  | System when      |                    |
| tag |   |                  | there is a       |                    |
| ing |   |                  | failure to meet  |                    |
|     |   |                  | certain state,   |                    |
|     |   |                  | region or        |                    |
|     |   |                  | federal drinking |                    |
|     |   |                  | water            |                    |
|     |   |                  | regulations.     |                    |
|     |   |                  | Violations are   |                    |
|     |   |                  | detected by      |                    |
|     |   |                  | assessment of    |                    |
|     |   |                  | sample results   |                    |
|     |   |                  | or reviews       |                    |
|     |   |                  | (including site  |                    |
|     |   |                  | visits).         |                    |
|     |   |                  | Violations may   |                    |
|     |   |                  | lead to legal    |                    |
|     |   |                  | actions or       |                    |
|     |   |                  | compliance       |                    |
|     |   |                  | orders and are   |                    |
|     |   |                  | publicized, when |                    |
|     |   |                  | required, by     |                    |
|     |   |                  | public           |                    |
|     |   |                  | notification.    |                    |
|     |   |                  | Violations may   |                    |
|     |   |                  | be remedied by   |                    |
|     |   |                  | compliance       |                    |
|     |   |                  | enforcement, for |                    |
|     |   |                  | example by       |                    |
|     |   |                  | improved         |                    |
|     |   |                  | filtration       |                    |
|     |   |                  | techniques or    |                    |
|     |   |                  | changes in       |                    |
|     |   |                  | procedures.      |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | WaterSystem      | Describes an     |                    |
| ost | a |                  | institutional    |                    |
| ing | b | stgWaterSystem   | entity providing |                    |
| and | l |                  | water for human  |                    |
| S   | e |                  | consumption.     |                    |
| tag |   |                  | Identifies       |                    |
| ing |   |                  | collections of   |                    |
|     |   |                  | Water System     |                    |
|     |   |                  | Facilities       |                    |
|     |   |                  | assembled for    |                    |
|     |   |                  | distribution of  |                    |
|     |   |                  | water to a       |                    |
|     |   |                  | specified        |                    |
|     |   |                  | geographic       |                    |
|     |   |                  | area(s), owned   |                    |
|     |   |                  | by a legal       |                    |
|     |   |                  | entity. Water    |                    |
|     |   |                  | systems are      |                    |
|     |   |                  | classified       |                    |
|     |   |                  | according to     |                    |
|     |   |                  | rules developed  |                    |
|     |   |                  | by the U.S.      |                    |
|     |   |                  | Environmental    |                    |
|     |   |                  | Protection       |                    |
|     |   |                  | Agency and each  |                    |
|     |   |                  | state. Water     |                    |
|     |   |                  | systems fall     |                    |
|     |   |                  | into two broad   |                    |
|     |   |                  | categories:      |                    |
|     |   |                  | public and       |                    |
|     |   |                  | non-public. A    |                    |
|     |   |                  | public Water     |                    |
|     |   |                  | System is        |                    |
|     |   |                  | further          |                    |
|     |   |                  | classified as    |                    |
|     |   |                  | Community,       |                    |
|     |   |                  | Non-Transient    |                    |
|     |   |                  | Non-Community,   |                    |
|     |   |                  | or Transient     |                    |
|     |   |                  | Non-Community.   |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Wat              | Characterizes    |                    |
| ost | a | erSystemFacility | any location or  |                    |
| ing | b |                  | facility related |                    |
| and | l | stgWat           | to a Water       |                    |
| S   | e | erSystemFacility | System. Examples |                    |
| tag |   |                  | include          |                    |
| ing |   |                  | distribution     |                    |
|     |   |                  | systems,         |                    |
|     |   |                  | treatment        |                    |
|     |   |                  | plants, pumping  |                    |
|     |   |                  | facilities,      |                    |
|     |   |                  | water storage    |                    |
|     |   |                  | facilities, and  |                    |
|     |   |                  | the like.        |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | ContaminantRule  | Translates a     | The                |
| ost | a |                  | rule code to     | Enforcement        |
| ing | b |                  | contaminant      | AssignmentCriteria |
|     | l |                  | codes.           | table contains a   |
|     | e |                  |                  | rule code that is  |
|     |   |                  |                  | used to identify   |
|     |   |                  |                  | the Violations for |
|     |   |                  |                  | which an           |
|     |   |                  |                  | enforcement action |
|     |   |                  |                  | is taken. This     |
|     |   |                  |                  | table supports the |
|     |   |                  |                  | translation of     |
|     |   |                  |                  | rule codes to      |
|     |   |                  |                  | contaminant codes  |
|     |   |                  |                  | for the purpose of |
|     |   |                  |                  | establishing       |
|     |   |                  |                  | Enforcement to     |
|     |   |                  |                  | Violation links.   |
+-----+---+------------------+------------------+--------------------+
| P   | T | Contaminant      | Translates an    |                    |
| ost | a |                  | analyte code to  |                    |
| ing | b |                  | the name and     |                    |
|     | l |                  | provides other   |                    |
|     | e |                  | metadata about   |                    |
|     |   |                  | the analyte.     |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | EDRRe            | Provides a       |                    |
| ost | a | ferencePointCode | translation from |                    |
| ing | b |                  | the permitted    |                    |
|     | l |                  | values in the    |                    |
|     | e |                  | LLDescription    |                    |
|     |   |                  | column in the    |                    |
|     |   |                  | LocationalDetail |                    |
|     |   |                  | table to EPA's   |                    |
|     |   |                  | data standard    |                    |
|     |   |                  | for Reference    |                    |
|     |   |                  | Point Code as    |                    |
|     |   |                  | described in the |                    |
|     |   |                  | Environmental    |                    |
|     |   |                  | Data Registry    |                    |
|     |   |                  | (EDR).           |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | EDRSour          | Provides a       |                    |
| ost | a | ceMapScaleNumber | translation from |                    |
| ing | b |                  | the permitted    |                    |
|     | l |                  | values in the    |                    |
|     | e |                  | LLSourceScale    |                    |
|     |   |                  | column in the    |                    |
|     |   |                  | LocationalDetail |                    |
|     |   |                  | table to EPA's   |                    |
|     |   |                  | data standard    |                    |
|     |   |                  | for Source Map   |                    |
|     |   |                  | Scale Number as  |                    |
|     |   |                  | described in the |                    |
|     |   |                  | Environmental    |                    |
|     |   |                  | Data Registry    |                    |
|     |   |                  | (EDR).           |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | ViolationEnfor   | Establishes the  | The                |
| ost | a | cementAssignment | relationship     | Enforcement        |
| ing | b |                  | between the      | AssignmentCriteria |
|     | l |                  | records in the   | describes the      |
|     | e |                  | Violation table  | Violation for      |
|     |   |                  | and the          | which an           |
|     |   |                  | E                | Enforcement Action |
|     |   |                  | nforcementAction | is taken. This     |
|     |   |                  | table as         | table establishes  |
|     |   |                  | described by the | the relationship   |
|     |   |                  | EnforcementAs    | between the        |
|     |   |                  | signmentCriteria | Enforcement action |
|     |   |                  | table.           | and the Violation. |
+-----+---+------------------+------------------+--------------------+
| P   | T | SNC              | Contains the SNC |                    |
| ost | a |                  | data generated   |                    |
| ing | b |                  | at the SDWIS     |                    |
|     | l |                  | Warehouse. Each  |                    |
|     | e |                  | quarter, after   |                    |
|     |   |                  | the SNC          |                    |
|     |   |                  | processing, SNC  |                    |
|     |   |                  | data is copied   |                    |
|     |   |                  | from the         |                    |
|     |   |                  | Warehouse into   |                    |
|     |   |                  | this table.      |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | ViolAssoc        | Contains the     |                    |
| ost | a |                  | VIOLASSOC data   |                    |
| ing | b |                  | generated by the |                    |
|     | l |                  | SNC processing   |                    |
|     | e |                  | at the SDWIS     |                    |
|     |   |                  | Warehouse. Each  |                    |
|     |   |                  | quarter, after   |                    |
|     |   |                  | the SNC          |                    |
|     |   |                  | processing,      |                    |
|     |   |                  | VIOLASSOC data   |                    |
|     |   |                  | is copied from   |                    |
|     |   |                  | the Warehouse    |                    |
|     |   |                  | into this table. |                    |
|     |   |                  | An additional    |                    |
|     |   |                  | column called    |                    |
|     |   |                  | ViolAssocseqno   |                    |
|     |   |                  | has been added   |                    |
|     |   |                  | as the primary   |                    |
|     |   |                  | to this table.   |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | ViolationType    | Contains the     |                    |
| ost | a |                  | Violation Types  |                    |
| ing | b |                  | and              |                    |
|     | l |                  | descriptions.    |                    |
|     | e |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Enfor            | Contains the     |                    |
| ost | a | cementActionCode | Enforcement      |                    |
| ing | b |                  | Action Codes and |                    |
|     | l |                  | descriptions.    |                    |
|     | e |                  |                  |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Violation_log    | An audit table   | When SDWIS/ODS     |
| ost | a |                  | that records     | users insert a     |
| ing | b |                  | changes made to  | record, the log    |
|     | l |                  | the data in the  | table captures the |
|     | e |                  | Violation table  | image of the new   |
|     |   |                  | by SDWIS/ODSWEB  | record. In case of |
|     |   |                  | users. This      | deletions and      |
|     |   |                  | table contains   | modifications, the |
|     |   |                  | four columns in  | log table captures |
|     |   |                  | addition to all  | the before action  |
|     |   |                  | the columns in   | image of the       |
|     |   |                  | the Violation    | record.            |
|     |   |                  | table. Those     |                    |
|     |   |                  | four columns     |                    |
|     |   |                  | are:             |                    |
|     |   |                  |                  |                    |
|     |   |                  | > LOGSEQ -- A    |                    |
|     |   |                  | > sequentially   |                    |
|     |   |                  | > generated      |                    |
|     |   |                  | > number that    |                    |
|     |   |                  | > uniquely       |                    |
|     |   |                  | > identifies     |                    |
|     |   |                  | > records in all |                    |
|     |   |                  | > the log        |                    |
|     |   |                  | > tables.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > ACTION --      |                    |
|     |   |                  | > Indicates      |                    |
|     |   |                  | > whether the    |                    |
|     |   |                  | > user           |                    |
|     |   |                  | > 'Inserted',    |                    |
|     |   |                  | > 'Updated', or  |                    |
|     |   |                  | > 'Deleted' the  |                    |
|     |   |                  | > record.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > WHENOCCURRED   |                    |
|     |   |                  | > -- Date and    |                    |
|     |   |                  | > time at which  |                    |
|     |   |                  | > the action     |                    |
|     |   |                  | > occurred.      |                    |
|     |   |                  | >                |                    |
|     |   |                  | > USERID --      |                    |
|     |   |                  | > UserID of the  |                    |
|     |   |                  | > SDWIS/ODS user |                    |
|     |   |                  | > who performed  |                    |
|     |   |                  | > the action.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Enforcement_log  | An audit table   | When SDWIS/ODS     |
| ost | a |                  | that records     | users insert a     |
| ing | b |                  | changes made to  | record, the log    |
|     | l |                  | the data in the  | table captures the |
|     | e |                  | E                | image of the new   |
|     |   |                  | nforcementAction | record. In case of |
|     |   |                  | table by         | deletions and      |
|     |   |                  | SDWIS/ODSWEB     | modifications, the |
|     |   |                  | users. This      | log table captures |
|     |   |                  | table contains   | the before action  |
|     |   |                  | four columns in  | image of the       |
|     |   |                  | addition to all  | record.            |
|     |   |                  | the columns in   |                    |
|     |   |                  | the              |                    |
|     |   |                  | E                |                    |
|     |   |                  | nforcementAction |                    |
|     |   |                  | table. Those     |                    |
|     |   |                  | four columns     |                    |
|     |   |                  | are:             |                    |
|     |   |                  |                  |                    |
|     |   |                  | > LOGSEQ -- A    |                    |
|     |   |                  | > sequentially   |                    |
|     |   |                  | > generated      |                    |
|     |   |                  | > number that    |                    |
|     |   |                  | > uniquely       |                    |
|     |   |                  | > identifies     |                    |
|     |   |                  | > records in all |                    |
|     |   |                  | > the log        |                    |
|     |   |                  | > tables.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > ACTION --      |                    |
|     |   |                  | > Indicates      |                    |
|     |   |                  | > whether the    |                    |
|     |   |                  | > user           |                    |
|     |   |                  | > 'Inserted',    |                    |
|     |   |                  | > 'Updated', or  |                    |
|     |   |                  | > 'Deleted' the  |                    |
|     |   |                  | > record.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > WHENOCCURRED   |                    |
|     |   |                  | > -- Date and    |                    |
|     |   |                  | > time at which  |                    |
|     |   |                  | > the action     |                    |
|     |   |                  | > occurred.      |                    |
|     |   |                  | >                |                    |
|     |   |                  | > USERID --      |                    |
|     |   |                  | > UserID of the  |                    |
|     |   |                  | > SDWIS/ODS user |                    |
|     |   |                  | > who performed  |                    |
|     |   |                  | > the action.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Enforce          | An audit table   | When SDWIS/ODS     |
| ost | a | mentCriteria_log | that records     | users insert a     |
| ing | b |                  | changes made to  | record, the log    |
|     | l |                  | the data in the  | table captures the |
|     | e |                  | EnforcementAs    | image of the new   |
|     |   |                  | signmentCriteria | record. In case of |
|     |   |                  | table by         | deletions and      |
|     |   |                  | SDWIS/ODSWEB     | modifications, the |
|     |   |                  | users. This      | log table captures |
|     |   |                  | table contains   | the before action  |
|     |   |                  | four columns in  | image of the       |
|     |   |                  | addition to all  | record.            |
|     |   |                  | the columns in   |                    |
|     |   |                  | the              |                    |
|     |   |                  | EnforcementAs    |                    |
|     |   |                  | signmentCriteria |                    |
|     |   |                  | table. Those     |                    |
|     |   |                  | four columns     |                    |
|     |   |                  | are:             |                    |
|     |   |                  |                  |                    |
|     |   |                  | > LOGSEQ -- A    |                    |
|     |   |                  | > sequentially   |                    |
|     |   |                  | > generated      |                    |
|     |   |                  | > number that    |                    |
|     |   |                  | > uniquely       |                    |
|     |   |                  | > identifies     |                    |
|     |   |                  | > records in all |                    |
|     |   |                  | > the log        |                    |
|     |   |                  | > tables.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > ACTION --      |                    |
|     |   |                  | > Indicates      |                    |
|     |   |                  | > whether the    |                    |
|     |   |                  | > user           |                    |
|     |   |                  | > 'Inserted',    |                    |
|     |   |                  | > 'Updated', or  |                    |
|     |   |                  | > 'Deleted' the  |                    |
|     |   |                  | > record.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > WHENOCCURRED   |                    |
|     |   |                  | > -- Date and    |                    |
|     |   |                  | > time at which  |                    |
|     |   |                  | > the action     |                    |
|     |   |                  | > occurred.      |                    |
|     |   |                  | >                |                    |
|     |   |                  | > USERID --      |                    |
|     |   |                  | > UserID of the  |                    |
|     |   |                  | > SDWIS/ODS user |                    |
|     |   |                  | > who performed  |                    |
|     |   |                  | > the action.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | PublicNo         | An audit table   | When SDWIS/ODS     |
| ost | a | ticeCriteria_log | that records     | users insert a     |
| ing | b |                  | changes made to  | record, the log    |
|     | l |                  | the data in the  | table captures the |
|     | e |                  | Publ             | image of the new   |
|     |   |                  | icNoticeCriteria | record. In case of |
|     |   |                  | table by         | deletions and      |
|     |   |                  | SDWIS/ODSWEB     | modifications, the |
|     |   |                  | users. This      | log table captures |
|     |   |                  | table contains   | the before action  |
|     |   |                  | four columns in  | image of the       |
|     |   |                  | addition to all  | record.            |
|     |   |                  | the columns in   |                    |
|     |   |                  | the              |                    |
|     |   |                  | Publ             |                    |
|     |   |                  | icNoticeCriteria |                    |
|     |   |                  | table. Those     |                    |
|     |   |                  | four columns     |                    |
|     |   |                  | are:             |                    |
|     |   |                  |                  |                    |
|     |   |                  | > LOGSEQ -- A    |                    |
|     |   |                  | > sequentially   |                    |
|     |   |                  | > generated      |                    |
|     |   |                  | > number that    |                    |
|     |   |                  | > uniquely       |                    |
|     |   |                  | > identifies     |                    |
|     |   |                  | > records in all |                    |
|     |   |                  | > the log        |                    |
|     |   |                  | > tables.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > ACTION --      |                    |
|     |   |                  | > Indicates      |                    |
|     |   |                  | > whether the    |                    |
|     |   |                  | > user           |                    |
|     |   |                  | > 'Inserted',    |                    |
|     |   |                  | > 'Updated', or  |                    |
|     |   |                  | > 'Deleted' the  |                    |
|     |   |                  | > record.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > WHENOCCURRED   |                    |
|     |   |                  | > -- Date and    |                    |
|     |   |                  | > time at which  |                    |
|     |   |                  | > the action     |                    |
|     |   |                  | > occurred.      |                    |
|     |   |                  | >                |                    |
|     |   |                  | > USERID --      |                    |
|     |   |                  | > UserID of the  |                    |
|     |   |                  | > SDWIS/ODS user |                    |
|     |   |                  | > who performed  |                    |
|     |   |                  | > the action.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | SNC_log          | An audit table   | When SDWIS/ODS     |
| ost | a |                  | that records     | users insert a     |
| ing | b |                  | changes made to  | record, the log    |
|     | l |                  | the data in the  | table captures the |
|     | e |                  | SNC table by     | image of the new   |
|     |   |                  | SDWIS/ODSWEB     | record. In case of |
|     |   |                  | users. This      | deletions and      |
|     |   |                  | table contains   | modifications, the |
|     |   |                  | four columns in  | log table captures |
|     |   |                  | addition to all  | the before action  |
|     |   |                  | the columns in   | image of the       |
|     |   |                  | the SNC table.   | record.            |
|     |   |                  | Those four       |                    |
|     |   |                  | columns are:     |                    |
|     |   |                  |                  |                    |
|     |   |                  | > LOGSEQ -- A    |                    |
|     |   |                  | > sequentially   |                    |
|     |   |                  | > generated      |                    |
|     |   |                  | > number that    |                    |
|     |   |                  | > uniquely       |                    |
|     |   |                  | > identifies     |                    |
|     |   |                  | > records in all |                    |
|     |   |                  | > the log        |                    |
|     |   |                  | > tables.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > ACTION --      |                    |
|     |   |                  | > Indicates      |                    |
|     |   |                  | > whether the    |                    |
|     |   |                  | > user           |                    |
|     |   |                  | > 'Inserted',    |                    |
|     |   |                  | > 'Updated', or  |                    |
|     |   |                  | > 'Deleted' the  |                    |
|     |   |                  | > record.        |                    |
|     |   |                  | >                |                    |
|     |   |                  | > WHENOCCURRED   |                    |
|     |   |                  | > -- Date and    |                    |
|     |   |                  | > time at which  |                    |
|     |   |                  | > the action     |                    |
|     |   |                  | > occurred.      |                    |
|     |   |                  | >                |                    |
|     |   |                  | > USERID --      |                    |
|     |   |                  | > UserID of the  |                    |
|     |   |                  | > SDWIS/ODS user |                    |
|     |   |                  | > who performed  |                    |
|     |   |                  | > the action.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Users            | An audit table   |                    |
| ost | a |                  | that keeps       |                    |
| ing | b |                  | tracks of the    |                    |
|     | l |                  | users who logs   |                    |
|     | e |                  | into the         |                    |
|     |   |                  | SDWIS/ODSWEB.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | PageGroup        | Contains         |                    |
| ost | a |                  | information      |                    |
| ing | b |                  | about the        |                    |
|     | l |                  | various page     |                    |
|     | e |                  | groups within    |                    |
|     |   |                  | the              |                    |
|     |   |                  | SDWIS/ODSWEB.    |                    |
|     |   |                  | Users are        |                    |
|     |   |                  | granted access   |                    |
|     |   |                  | to the page      |                    |
|     |   |                  | groups based on  |                    |
|     |   |                  | their roles.     |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | UserRole         | Contains the     |                    |
| ost | a |                  | various roles    |                    |
| ing | b |                  | and their        |                    |
|     | l |                  | descriptions     |                    |
|     | e |                  | used by          |                    |
|     |   |                  | SDWIS/ODSWEB.    |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | RolePageGroup    | Contains the     |                    |
| ost | a |                  | association      |                    |
| ing | b |                  | between Roles    |                    |
|     | l |                  | and PageGroup.   |                    |
|     | e |                  | The security     |                    |
|     |   |                  | routine, which   |                    |
|     |   |                  | receives the     |                    |
|     |   |                  | role information |                    |
|     |   |                  | from the CDX,    |                    |
|     |   |                  | uses this table  |                    |
|     |   |                  | to find out the  |                    |
|     |   |                  | page groups that |                    |
|     |   |                  | the user must be |                    |
|     |   |                  | permitted to     |                    |
|     |   |                  | access.          |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | DataQuality      | Contains         |                    |
| ack | a |                  | detailed         |                    |
| ing | b |                  | information      |                    |
|     | l |                  | about the errors |                    |
|     | e |                  | detected by the  |                    |
|     |   |                  | Check Data       |                    |
|     |   |                  | Quality Rules    |                    |
|     |   |                  | component. Each  |                    |
|     |   |                  | time an error is |                    |
|     |   |                  | detected, a      |                    |
|     |   |                  | record is        |                    |
|     |   |                  | inserted into    |                    |
|     |   |                  | this table.      |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | ErrorCode        | Contains         |                    |
| ack | a |                  | SDWIS/ODS        |                    |
| ing | b |                  | validation and   |                    |
|     | l |                  | data quality     |                    |
|     | e |                  | error codes and  |                    |
|     |   |                  | detailed message |                    |
|     |   |                  | text.            |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | ErrorDetails     | Provides a       |                    |
| ack | a |                  | temporary        |                    |
| ing | b |                  | location to log  |                    |
|     | l |                  | each error       |                    |
|     | e |                  | detected by the  |                    |
|     |   |                  | SDWIS/ODS Check  |                    |
|     |   |                  | for Compliance   |                    |
|     |   |                  | component.       |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | ErrorHistory     | Contains an      |                    |
| ack | a |                  | aggregate count  |                    |
| ing | b |                  | of number of     |                    |
|     | l |                  | times each error |                    |
|     | e |                  | was detected     |                    |
|     |   |                  | during a         |                    |
|     |   |                  | SDWIS/ODS        |                    |
|     |   |                  | processing.      |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | ErrorSummary     | Provides a       |                    |
| ack | a |                  | temporary        |                    |
| ing | b |                  | location to log  |                    |
|     | l |                  | errors detected  |                    |
|     | e |                  | for a specific   |                    |
|     |   |                  | record           |                    |
|     |   |                  | occurrence.      |                    |
|     |   |                  | Records in the   |                    |
|     |   |                  | ErrorSummary     |                    |
|     |   |                  | table are the    |                    |
|     |   |                  | parent records   |                    |
|     |   |                  | to records in    |                    |
|     |   |                  | the ErrorDetails |                    |
|     |   |                  | table.           |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | JobOrigin        | Translates the   |                    |
| ack | a |                  | two-character    |                    |
| ing | b |                  | code of the      |                    |
|     | l |                  | primacy agency   |                    |
|     | e |                  | and the regions  |                    |
|     |   |                  | to its name.     |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | RequestLog       | Tracks the       |                    |
| ack | a |                  | processing       |                    |
| ing | b |                  | requests         |                    |
|     | l |                  | submitted to     |                    |
|     | e |                  | SDWIS/ODS. For   |                    |
|     |   |                  | every submitted  |                    |
|     |   |                  | XML document and |                    |
|     |   |                  | QA Extract       |                    |
|     |   |                  | request received |                    |
|     |   |                  | by SDWIS/ODS, a  |                    |
|     |   |                  | record is        |                    |
|     |   |                  | created in this  |                    |
|     |   |                  | table containing |                    |
|     |   |                  | metadata         |                    |
|     |   |                  | regarding the    |                    |
|     |   |                  | job and status   |                    |
|     |   |                  | information      |                    |
|     |   |                  | about the job's  |                    |
|     |   |                  | processing.      |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | V | JobStatus        | Provides a view  |                    |
| ack | i |                  | of the           |                    |
| ing | e |                  | RequestLog table |                    |
|     | w |                  | depicting all    |                    |
|     |   |                  | the XML document |                    |
|     |   |                  | processing       |                    |
|     |   |                  | requests.        |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | V | ODSData          | Provides a view  |                    |
| ack | i | ExtractionStatus | of the           |                    |
| ing | e |                  | RequestLog table |                    |
|     | w |                  | depicting only   |                    |
|     |   |                  | the QA Data      |                    |
|     |   |                  | Extraction       |                    |
|     |   |                  | requests.        |                    |
+-----+---+------------------+------------------+--------------------+
| Tr  | T | Tr               | Contains summary |                    |
| ack | a | ansactionHistory | counts of the    |                    |
| ing | b |                  | number of        |                    |
|     | l |                  | records          |                    |
|     | e |                  | accepted,        |                    |
|     |   |                  | ignored, and     |                    |
|     |   |                  | rejected by job. |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_E            | Contains the     |                    |
| ost | a | nforcementAction | E                |                    |
| ing | b |                  | nforcementAction |                    |
|     | l |                  | records that     |                    |
|     | e |                  | failed the data  |                    |
|     |   |                  | quality checks   |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_Enforce      | Contains all the |                    |
| ost | a | mentAsgnCriteria | EnforcementAs    |                    |
| ing | b |                  | signmentCriteria |                    |
|     | l |                  | records          |                    |
|     | e |                  | belonging to     |                    |
|     |   |                  | E                |                    |
|     |   |                  | nforcementAction |                    |
|     |   |                  | records, which   |                    |
|     |   |                  | were rejected    |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_Event        | Contains all the |                    |
| ost | a | ScheduleActivity | Event            |                    |
| ing | b |                  | ScheduleActivity |                    |
|     | l |                  | records that     |                    |
|     | e |                  | failed the data  |                    |
|     |   |                  | quality checks   |                    |
|     |   |                  | data were        |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_FacilityFlow | Contains all the |                    |
| ost | a |                  | FacilityFlow     |                    |
| ing | b |                  | records          |                    |
|     | l |                  | belonging to     |                    |
|     | e |                  | Wat              |                    |
|     |   |                  | erSystemFacility |                    |
|     |   |                  | records, which   |                    |
|     |   |                  | were rejected    |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_             | Contains all the |                    |
| ost | a | LocationalDetail | LocationalDetail |                    |
| ing | b |                  | records          |                    |
|     | l |                  | belonging to the |                    |
|     | e |                  | Wat              |                    |
|     |   |                  | erSystemFacility |                    |
|     |   |                  | records that     |                    |
|     |   |                  | were rejected    |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_SiteVisit    | Contains all the |                    |
| ost | a |                  | SiteVisit        |                    |
| ing | b |                  | records that     |                    |
|     | l |                  | failed the data  |                    |
|     | e |                  | quality checks   |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Bad_Violatio     | Contains all the |                    |
| ost | a | nEnforcementAsgn | ViolationEnfor   |                    |
| ing | b |                  | cementAssignment |                    |
|     | l |                  | records          |                    |
|     | e |                  | belonging to the |                    |
|     |   |                  | EnforcmentAction |                    |
|     |   |                  | records or       |                    |
|     |   |                  | Violation        |                    |
|     |   |                  | records that     |                    |
|     |   |                  | were rejected    |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS        |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Dup_E            | Contains all the |                    |
| ost | a | nforcementAction | E                |                    |
| ing | b |                  | nforcementAction |                    |
|     | l |                  | records that     |                    |
|     | e |                  | failed unique    |                    |
|     |   |                  | identifier check |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | D                | Contains all the |                    |
| ost | a | up_TreatmentData | Treatment        |                    |
| ing | b |                  | records that     |                    |
|     | l |                  | failed the       |                    |
|     | e |                  | unique           |                    |
|     |   |                  | identifier check |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Dup_Violation    | Contains all the |                    |
| ost | a |                  | Violation        |                    |
| ing | b |                  | records that     |                    |
|     | l |                  | failed the       |                    |
|     | e |                  | unique           |                    |
|     |   |                  | identifier check |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+
| P   | T | Dup_Wat          | Contains all the |                    |
| ost | a | erSystemFacility | Wat              |                    |
| ing | b |                  | erSystemFacility |                    |
|     | l |                  | records that     |                    |
|     | e |                  | failed the       |                    |
|     |   |                  | unique           |                    |
|     |   |                  | identifier check |                    |
|     |   |                  | when data were   |                    |
|     |   |                  | migrated from    |                    |
|     |   |                  | SDWIS/FED to     |                    |
|     |   |                  | SDWIS/ODS.       |                    |
+-----+---+------------------+------------------+--------------------+

+------------------+--------------+----------------+------------------+
| **SDWIS/ODS**    |              |                |                  |
|                  |              |                |                  |
| **Common Column  |              |                |                  |
| Descriptions**   |              |                |                  |
|                  |              |                |                  |
| **(These columns |              |                |                  |
| exist in most of |              |                |                  |
| the post area    |              |                |                  |
| tables)**        |              |                |                  |
+==================+==============+================+==================+
| **Table**        | **Column**   | *              | **Comment**      |
|                  |              | *Description** |                  |
+------------------+--------------+----------------+------------------+
| E                | VALID        | Indicates      |                  |
| nforcementAction | ITYINDICATOR | whether a      |                  |
|                  |              | record has     |                  |
| EnforcementAs    |              | passed all the |                  |
| signmentCriteria |              | data quality   |                  |
|                  |              | checks. If the |                  |
| Event            |              | value in this  |                  |
| ScheduleActivity |              | column is "N," |                  |
|                  |              | the record has |                  |
| Facilityflow     |              | failed one or  |                  |
|                  |              | more data      |                  |
| Geographicarea   |              | quality        |                  |
|                  |              | checks. If the |                  |
| Legalentity      |              | value is "Y,"  |                  |
|                  |              | spaces, or     |                  |
| Legale           |              | null, the      |                  |
| ntityAffiliation |              | record has     |                  |
|                  |              | passed all the |                  |
| LocationalDetail |              | data quality   |                  |
|                  |              | checks.        |                  |
| Publ             |              |                |                  |
| icNoticeCriteria |              |                |                  |
|                  |              |                |                  |
| Sample           |              |                |                  |
|                  |              |                |                  |
| SampleResult     |              |                |                  |
|                  |              |                |                  |
| ServiceArea      |              |                |                  |
|                  |              |                |                  |
| SiteVisit        |              |                |                  |
|                  |              |                |                  |
| TreatmentData    |              |                |                  |
|                  |              |                |                  |
| Violation        |              |                |                  |
|                  |              |                |                  |
| Watersystem      |              |                |                  |
|                  |              |                |                  |
| Wat              |              |                |                  |
| erSystemFacility |              |                |                  |
+------------------+--------------+----------------+------------------+
| E                | FIRST        | Contains the   |                  |
| nforcementaction | REPORTEDDATE | date on which  |                  |
|                  |              | the record was |                  |
| Event            |              | reported for   |                  |
| ScheduleActivity |              | the first time |                  |
|                  |              | to SDWIS/ODS.  |                  |
| FacilityFlow     |              |                |                  |
|                  |              |                |                  |
| Legalentity      |              |                |                  |
|                  |              |                |                  |
| LocationalDetail |              |                |                  |
|                  |              |                |                  |
| Publ             |              |                |                  |
| icNoticeCriteria |              |                |                  |
|                  |              |                |                  |
| Sample           |              |                |                  |
|                  |              |                |                  |
| SampleResult     |              |                |                  |
|                  |              |                |                  |
| ServiceArea      |              |                |                  |
|                  |              |                |                  |
| SiteVisit        |              |                |                  |
|                  |              |                |                  |
| TreatmentData    |              |                |                  |
|                  |              |                |                  |
| Violation        |              |                |                  |
|                  |              |                |                  |
| WaterSystem      |              |                |                  |
|                  |              |                |                  |
| Wat              |              |                |                  |
| erSystemFacility |              |                |                  |
+------------------+--------------+----------------+------------------+
| E                | LAST         | Contains the   |                  |
| nforcementAction | REPORTEDDATE | date on which  |                  |
|                  |              | the record was |                  |
| EnforcementAs    |              | reported for   |                  |
| signmentCriteria |              | the last time  |                  |
|                  |              | to SDWIS/ODS.  |                  |
| Event            |              |                |                  |
| ScheduleActivity |              |                |                  |
|                  |              |                |                  |
| FacilityFlow     |              |                |                  |
|                  |              |                |                  |
| GeographicArea   |              |                |                  |
|                  |              |                |                  |
| LegalEntity      |              |                |                  |
|                  |              |                |                  |
| LegalE           |              |                |                  |
| ntityAffiliation |              |                |                  |
|                  |              |                |                  |
| LocationalDetail |              |                |                  |
|                  |              |                |                  |
| Publ             |              |                |                  |
| icNoticeCriteria |              |                |                  |
|                  |              |                |                  |
| Sample           |              |                |                  |
|                  |              |                |                  |
| SampleResult     |              |                |                  |
|                  |              |                |                  |
| ServiceArea      |              |                |                  |
|                  |              |                |                  |
| SiteVisit        |              |                |                  |
|                  |              |                |                  |
| TreatmentData    |              |                |                  |
|                  |              |                |                  |
| Violation        |              |                |                  |
|                  |              |                |                  |
| WaterSystem      |              |                |                  |
|                  |              |                |                  |
| Wat              |              |                |                  |
| erSystemFacility |              |                |                  |
+------------------+--------------+----------------+------------------+

+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *S |               |             |              |       |          |
| DW |               |             |              |       |          |
| IS |               |             |              |       |          |
| /O |               |             |              |       |          |
| DS |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| Co |               |             |              |       |          |
| lu |               |             |              |       |          |
| mn |               |             |              |       |          |
| De |               |             |              |       |          |
| sc |               |             |              |       |          |
| ri |               |             |              |       |          |
| pt |               |             |              |       |          |
| io |               |             |              |       |          |
| ns |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *M |               |             |              |       |          |
| ap |               |             |              |       |          |
| pi |               |             |              |       |          |
| ng |               |             |              |       |          |
| to |               |             |              |       |          |
| SD |               |             |              |       |          |
| WI |               |             |              |       |          |
| S/ |               |             |              |       |          |
| Fe |               |             |              |       |          |
| dR |               |             |              |       |          |
| ep |               |             |              |       |          |
| Bu |               |             |              |       |          |
| si |               |             |              |       |          |
| ne |               |             |              |       |          |
| ss |               |             |              |       |          |
| Ob |               |             |              |       |          |
| je |               |             |              |       |          |
| ct |               |             |              |       |          |
| a  |               |             |              |       |          |
| nd |               |             |              |       |          |
| E  |               |             |              |       |          |
| le |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| Na |               |             |              |       |          |
| me |               |             |              |       |          |
| ** |               |             |              |       |          |
+====+===============+=============+==============+=======+==========+
| *  |               |             |              | *     |          |
| *S |               |             |              | *SDWI |          |
| DW |               |             |              | S/Fed |          |
| IS |               |             |              | Rep** |          |
| /O |               |             |              |       |          |
| DS |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  | **Column**    | **De        | **Comment**  | **Bus | *        |
| *T |               | scription** |              | iness | *Element |
| ab |               |             |              | Obj   | Name**   |
| le |               |             |              | ect** |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| nf |               |             |              |       |          |
| or |               |             |              |       |          |
| ce |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| Ac |               |             |              |       |          |
| ti |               |             |              |       |          |
| on |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gE |               |             |              |       |          |
| nf |               |             |              |       |          |
| or |               |             |              |       |          |
| ce |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| Ac |               |             |              |       |          |
| ti |               |             |              |       |          |
| on |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | E     | PWS ID   |
|    |               | uniquely    |              | nforc |          |
|    |               | identifies  |              | ement |          |
|    |               | a Public    |              | A     |          |
|    |               | Water       |              | ction |          |
|    |               | System. PWS |              |       |          |
|    |               | ID is       |              |       |          |
|    |               | always      |              |       |          |
|    |               | prefixed    |              |       |          |
|    |               | with a      |              |       |          |
|    |               | valid       |              |       |          |
|    |               | United      |              |       |          |
|    |               | States      |              |       |          |
|    |               | Postal      |              |       |          |
|    |               | Service     |              |       |          |
|    |               | (USPS)      |              |       |          |
|    |               | State       |              |       |          |
|    |               | a           |              |       |          |
|    |               | bbreviation |              |       |          |
|    |               | or EPA      |              |       |          |
|    |               | Region      |              |       |          |
|    |               | code, which |              |       |          |
|    |               | is then     |              |       |          |
|    |               | followed by |              |       |          |
|    |               | a           |              |       |          |
|    |               | 7-character |              |       |          |
|    |               | identifier  |              |       |          |
|    |               | unique for  |              |       |          |
|    |               | each Water  |              |       |          |
|    |               | System      |              |       |          |
|    |               | within that |              |       |          |
|    |               | State or    |              |       |          |
|    |               | Region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFID         | This        |              | E     | ENF      |
|    |               | a           |              | nforc | ORCEMENT |
|    |               | lphanumeric |              | ement | ID       |
|    |               | value       |              | A     |          |
|    |               | uniquely    |              | ction |          |
|    |               | identifies  |              |       |          |
|    |               | a specific  |              |       |          |
|    |               | enforcement |              |       |          |
|    |               | action      |              |       |          |
|    |               | taken       |              |       |          |
|    |               | against a   |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System. It  |              |       |          |
|    |               | is unique   |              |       |          |
|    |               | for each    |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | D             | A code      | The          |       |          |
|    | ATAORIGINCODE | value       | permitted    |       |          |
|    |               | indicating  | values       |       |          |
|    |               | whether the | associated   |       |          |
|    |               | Enforcement | with element |       |          |
|    |               | Action      | are "S" for  |       |          |
|    |               | originated  | state owned  |       |          |
|    |               | with the    | enforcements |       |          |
|    |               | state or    | and "R" for  |       |          |
|    |               | region.     | federal      |       |          |
|    |               | Regionally  | e            |       |          |
|    |               | owned       | nforcements. |       |          |
|    |               | enforcement |              |       |          |
|    |               | actions are |              |       |          |
|    |               | referred to |              |       |          |
|    |               | as federal  |              |       |          |
|    |               | en          |              |       |          |
|    |               | forcements. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFDATE       | A value     |              | E     | ENF      |
|    |               | r           |              | nforc | ORCEMENT |
|    |               | epresenting |              | ement | DATE     |
|    |               | the         |              | A     |          |
|    |               | calendar    |              | ction |          |
|    |               | date on     |              |       |          |
|    |               | which an    |              |       |          |
|    |               | enforcement |              |       |          |
|    |               | action was  |              |       |          |
|    |               | taken       |              |       |          |
|    |               | against a   |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFACTIONTYPE | A code      | These code   | E     | ACTION   |
|    |               | value       | values are   | nforc | CODE     |
|    |               | r           | documented   | ement |          |
|    |               | epresenting | in the       | A     |          |
|    |               | the         | SDWIS/FedRep | ction |          |
|    |               | specific    | Requirements |       |          |
|    |               | type of the | Document     |       |          |
|    |               | enforcement | (Appendix    |       |          |
|    |               | action      | O).          |       |          |
|    |               | taken.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFCOMMENTS   | An          |              | E     | ENF      |
|    |               | a           |              | nforc | ORCEMENT |
|    |               | lphanumeric |              | ement | COMMENT  |
|    |               | value       |              | A     |          |
|    |               | r           |              | ction |          |
|    |               | epresenting |              |       |          |
|    |               | any         |              |       |          |
|    |               | d           |              |       |          |
|    |               | escription, |              |       |          |
|    |               | char        |              |       |          |
|    |               | acteristic, |              |       |          |
|    |               | or          |              |       |          |
|    |               | attribute   |              |       |          |
|    |               | that the    |              |       |          |
|    |               | State or    |              |       |          |
|    |               | EPA region  |              |       |          |
|    |               | wants to    |              |       |          |
|    |               | record for  |              |       |          |
|    |               | the         |              |       |          |
|    |               | associated  |              |       |          |
|    |               | enforcement |              |       |          |
|    |               | action.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERID        | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user who    |              |       |          |
|    |               | inserted or |              |       |          |
|    |               | modified    |              |       |          |
|    |               | this        |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| nf |               |             |              |       |          |
| or |               |             |              |       |          |
| ce |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| As |               |             |              |       |          |
| si |               |             |              |       |          |
| gn |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| Cr |               |             |              |       |          |
| it |               |             |              |       |          |
| er |               |             |              |       |          |
| ia |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| E  |               |             |              |       |          |
| nf |               |             |              |       |          |
| or |               |             |              |       |          |
| ce |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| As |               |             |              |       |          |
| si |               |             |              |       |          |
| gn |               |             |              |       |          |
| me |               |             |              |       |          |
| nt |               |             |              |       |          |
| Cr |               |             |              |       |          |
| it |               |             |              |       |          |
| er |               |             |              |       |          |
| ia |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Enfo  | PWSID    |
|    |               | identifies  |              | rceme |          |
|    |               | the public  |              | ntAss |          |
|    |               | Water       |              | ignme |          |
|    |               | System to   |              | ntCri |          |
|    |               | which the   |              | teria |          |
|    |               | Enforce     |              |       |          |
|    |               | mentAssignm |              |       |          |
|    |               | entCriteria |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFID         | This column |              | Enfo  | ENF      |
|    |               | identifies  |              | rceme | ORCEMENT |
|    |               | the         |              | ntAss | ID       |
|    |               | Enforcement |              | ignme |          |
|    |               | Action to   |              | ntCri |          |
|    |               | which the   |              | teria |          |
|    |               | Enforce     |              |       |          |
|    |               | mentAssignm |              |       |          |
|    |               | entCriteria |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EACIDENTIFIER | System      |              |       |          |
|    |               | generated   |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | a specific  |              |       |          |
|    |               | Enforcem    |              |       |          |
|    |               | entAssignme |              |       |          |
|    |               | ntCriteria. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RULECODE      | Identifies  | []{.mark}    | Enfo  | AS       |
|    |               | a group of  |              | rceme | SOCIATED |
|    |               | Co          |              | ntAss | J5000    |
|    |               | ntaminants. |              | ignme | GROUP    |
|    |               | Violations  |              | ntCri |          |
|    |               | for those   |              | teria |          |
|    |               | C           |              |       |          |
|    |               | ontaminants |              |       |          |
|    |               | are to be   |              |       |          |
|    |               | linked the  |              |       |          |
|    |               | Enforcement |              |       |          |
|    |               | Action.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LINKBEGINDATE | Start date  | []{.mark}    | Enfo  | AS       |
|    |               | of a date   |              | rceme | SOCIATED |
|    |               | range.      |              | ntAss | J5000    |
|    |               | Violations  |              | ignme | GROUP    |
|    |               | with        |              | ntCri |          |
|    |               | compliance  |              | teria |          |
|    |               | period      |              |       |          |
|    |               | begins date |              |       |          |
|    |               | in this     |              |       |          |
|    |               | date range  |              |       |          |
|    |               | are to be   |              |       |          |
|    |               | linked to   |              |       |          |
|    |               | the         |              |       |          |
|    |               | Enforcement |              |       |          |
|    |               | Action.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LINKE         | End date of | []{.mark}    | Enfo  | AS       |
|    | XPIRATIONDATE | a date      |              | rceme | SOCIATED |
|    |               | range.      |              | ntAss | J5000    |
|    |               | Violations  |              | ignme | GROUP    |
|    |               | with        |              | ntCri |          |
|    |               | compliance  |              | teria |          |
|    |               | period      |              |       |          |
|    |               | begins date |              |       |          |
|    |               | in this     |              |       |          |
|    |               | date range  |              |       |          |
|    |               | are to be   |              |       |          |
|    |               | linked to   |              |       |          |
|    |               | the         |              |       |          |
|    |               | Enforcement |              |       |          |
|    |               | Action.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VCODE         | Violation   |              | Enfo  | V        |
|    |               | code of the |              | rceme | IOLATION |
|    |               | associated  |              | ntAss | TYPE     |
|    |               | Violation.  |              | ignme |          |
|    |               |             |              | ntCri |          |
|    |               |             |              | teria |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CCODE         | A code      | These code   | Enfo  | CON      |
|    |               | value that  | values are   | rceme | TAMINANT |
|    |               | represents  | documented   | ntAss | CODE     |
|    |               | a           | in the       | ignme |          |
|    |               | contaminant | SDWIS/FedRep | ntCri |          |
|    |               | for which a | Requirements | teria |          |
|    |               | public      | Document     |       |          |
|    |               | Water       | (Appendix N, |       |          |
|    |               | System has  | Violation    |       |          |
|    |               | incurred a  | Object,      |       |          |
|    |               | violation   | Element Name |       |          |
|    |               | of a        | is           |       |          |
|    |               | primary     | Contaminant  |       |          |
|    |               | drinking    | Code).       |       |          |
|    |               | water       |              |       |          |
|    |               | regulation. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ASSOCIAT      | This column |              | Enfo  | AS       |
|    | EDVIOLATIONID | contains    |              | rceme | SOCIATED |
|    |               | the         |              | ntAss | V        |
|    |               | Violation   |              | ignme | IOLATION |
|    |               | ID for      |              | ntCri | IDS      |
|    |               | which this  |              | teria | (Y5000)  |
|    |               | Enforcement |              |       |          |
|    |               | Action is   |              |       |          |
|    |               | taken.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LINKTYPECODE  | Describes   | Permitted    | []{.  |          |
|    |               | the type of | values       | mark} |          |
|    |               | the         | associated   |       |          |
|    |               | Enforce     | with element |       |          |
|    |               | mentAssignm | are "Y"      |       |          |
|    |               | entCriteria | (means the   |       |          |
|    |               | record.     | record       |       |          |
|    |               |             | contains     |       |          |
|    |               |             | Violation ID |       |          |
|    |               |             | of the       |       |          |
|    |               |             | associated   |       |          |
|    |               |             | Violation)   |       |          |
|    |               |             | and "J"      |       |          |
|    |               |             | (means the   |       |          |
|    |               |             | record was   |       |          |
|    |               |             | created from |       |          |
|    |               |             | a J5000      |       |          |
|    |               |             | group).      |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERID        | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user who    |              |       |          |
|    |               | inserted or |              |       |          |
|    |               | modified    |              |       |          |
|    |               | this        |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| ve |               |             |              |       |          |
| nt |               |             |              |       |          |
| Sc |               |             |              |       |          |
| he |               |             |              |       |          |
| du |               |             |              |       |          |
| le |               |             |              |       |          |
| Ac |               |             |              |       |          |
| ti |               |             |              |       |          |
| vi |               |             |              |       |          |
| ty |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| St |               |             |              |       |          |
| gE |               |             |              |       |          |
| ve |               |             |              |       |          |
| nt |               |             |              |       |          |
| Sc |               |             |              |       |          |
| he |               |             |              |       |          |
| du |               |             |              |       |          |
| le |               |             |              |       |          |
| Ac |               |             |              |       |          |
| ti |               |             |              |       |          |
| vi |               |             |              |       |          |
| ty |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Event | PWS ID   |
|    |               | identifies  |              | Sch   |          |
|    |               | the public  |              | edule |          |
|    |               | Water       |              | Act   |          |
|    |               | System to   |              | ivity |          |
|    |               | which the   |              |       |          |
|    |               | EventSched  |              |       |          |
|    |               | uleActivity |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EV            | An          |              | Event | EVENT    |
|    | ENTSCHEDULEID | al          |              | Sch   | ACTIVITY |
|    |               | pha-numeric |              | edule | ID       |
|    |               | value used  |              | Act   |          |
|    |               | to uniquely |              | ivity |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | Event       |              |       |          |
|    |               | Schedule    |              |       |          |
|    |               | Activity.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EVENTACTIVITY | This column | These code   | Event | ACTIVITY |
|    |               | describes   | values are   | Sch   | TYPE     |
|    |               | the         | documented   | edule | CODE     |
|    |               | activity    | in the       | Act   |          |
|    |               | associated  | SDWIS/FedRep | ivity |          |
|    |               | with the    | Requirements |       |          |
|    |               | schedule.   | Document     |       |          |
|    |               |             | (Appendix    |       |          |
|    |               |             | R).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EVENTENDDATE  | The         |              | Event | ACTIVITY |
|    |               | calendar    |              | Sch   | END DATE |
|    |               | date on     |              | edule |          |
|    |               | which the   |              | Act   |          |
|    |               | activity is |              | ivity |          |
|    |               | s           |              |       |          |
|    |               | uccessfully |              |       |          |
|    |               | completed.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EV            | The         |              | Event | ACTIVITY |
|    | ENTACTUALDATE | calendar    |              | Sch   | ACTUAL   |
|    |               | date by     |              | edule | DATE     |
|    |               | which the   |              | Act   |          |
|    |               | activity    |              | ivity |          |
|    |               | must be     |              |       |          |
|    |               | s           |              |       |          |
|    |               | uccessfully |              |       |          |
|    |               | completed.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EVENTREASON   | A code      | These code   | Event | REASON   |
|    |               | value that  | values are   | Sch   | CODE     |
|    |               | represents  | documented   | edule |          |
|    |               | the reason  | in the       | Act   |          |
|    |               | why this    | SDWIS/FedRep | ivity |          |
|    |               | activity is | Requirements |       |          |
|    |               | required.   | Document     |       |          |
|    |               |             | (Appendix    |       |          |
|    |               |             | R).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EVENTCOMMENTS | An          |              | Event | ACTIVITY |
|    |               | a           |              | Sch   | COMMENT  |
|    |               | lphanumeric |              | edule |          |
|    |               | value that  |              | Act   |          |
|    |               | represents  |              | ivity |          |
|    |               | any         |              |       |          |
|    |               | d           |              |       |          |
|    |               | escription, |              |       |          |
|    |               | char        |              |       |          |
|    |               | acteristic, |              |       |          |
|    |               | or          |              |       |          |
|    |               | attribute   |              |       |          |
|    |               | that the    |              |       |          |
|    |               | State or    |              |       |          |
|    |               | EPA region  |              |       |          |
|    |               | wants to    |              |       |          |
|    |               | record for  |              |       |          |
|    |               | the         |              |       |          |
|    |               | schedule    |              |       |          |
|    |               | activity.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| Fa |               |             |              |       |          |
| ci |               |             |              |       |          |
| li |               |             |              |       |          |
| ty |               |             |              |       |          |
| Fl |               |             |              |       |          |
| ow |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| Fa |               |             |              |       |          |
| ci |               |             |              |       |          |
| li |               |             |              |       |          |
| ty |               |             |              |       |          |
| Fl |               |             |              |       |          |
| ow |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column | The PWSID is | Fac   | PWS ID   |
|    |               | identifies  | logically    | ility |          |
|    |               | the public  | related to   | Flow  |          |
|    |               | Water       | the          |       |          |
|    |               | System to   | WaterSystem  |       |          |
|    |               | which the   | table.       |       |          |
|    |               | F           |              |       |          |
|    |               | acilityFlow |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACIDFROM     | The ID      |              | Fac   | FACILITY |
|    |               | (FACID) of  |              | ility | ID FLOW  |
|    |               | the Water   |              | Flow  | FROM     |
|    |               | System      |              |       |          |
|    |               | Facility    |              |       |          |
|    |               | which is    |              |       |          |
|    |               | delivering  |              |       |          |
|    |               | water.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACIDTO       | The ID      |              | Fac   | FACILITY |
|    |               | (FACID) of  |              | ility | ID FLOW  |
|    |               | the Water   |              | Flow  | TO       |
|    |               | System      |              |       |          |
|    |               | Facility    |              |       |          |
|    |               | which is    |              |       |          |
|    |               | receiving   |              |       |          |
|    |               | water.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| Ge |               |             |              |       |          |
| og |               |             |              |       |          |
| ra |               |             |              |       |          |
| ph |               |             |              |       |          |
| ic |               |             |              |       |          |
| Ar |               |             |              |       |          |
| ea |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| Ge |               |             |              |       |          |
| og |               |             |              |       |          |
| ra |               |             |              |       |          |
| ph |               |             |              |       |          |
| ic |               |             |              |       |          |
| Ar |               |             |              |       |          |
| ea |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Geogr | PWS ID   |
|    |               | identifies  |              | aphic |          |
|    |               | the public  |              | Area  |          |
|    |               | Water       |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Geo         |              |       |          |
|    |               | graphicArea |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| [  | TYPECODE      | Contains    | Permitted    | []{.  | [        |
| ]{ |               | the type of | values for   | mark} | ]{.mark} |
| .m |               | the         | this column  |       |          |
| ar |               | Grog        | are "CT"     |       |          |
| k} |               | raphicArea. | (city), "CN" |       |          |
|    |               |             | (county),    |       |          |
|    |               |             | "TR" (tribal |       |          |
|    |               |             | area), and   |       |          |
|    |               |             | "ZC" (zip    |       |          |
|    |               |             | code).       |       |          |
+----+---------------+-------------+--------------+-------+----------+
| [  | STATESERVED   | A code      | These code   | Geogr | US STATE |
| ]{ |               | value that  | values are   | aphic | CODE     |
| .m |               | represents  | documented   | Area  |          |
| ar |               | the U.S.    | in the       |       |          |
| k} |               | Postal      | SDWIS/FedRep |       |          |
|    |               | Service     | Requirements |       |          |
|    |               | (USPS)      | Document     |       |          |
|    |               | State       | (Appendix    |       |          |
|    |               | a           | G).          |       |          |
|    |               | bbreviation |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the city    |              |       |          |
|    |               | served by a |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System is   |              |       |          |
|    |               | located.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CITYSERVED    | The city    |              | Geogr | CITY     |
|    |               | served by   |              | aphic | NAME     |
|    |               | the Water   |              | Area  |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FIPSCOUNTY    | The FIPS    |              | Geogr | FIPS     |
|    |               | code        |              | aphic | COUNTY   |
|    |               | r           |              | Area  | CODE     |
|    |               | epresenting |              |       |          |
|    |               | the state   |              |       |          |
|    |               | and county  |              |       |          |
|    |               | served by   |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FIPSTRIBAL    | A code      | These code   | Geogr | TRIBAL   |
|    |               | value that  | values are   | aphic | CODE     |
|    |               | represents  | documented   | Area  |          |
|    |               | an Indian   | in the       |       |          |
|    |               | reservation | SDWIS/FedRep |       |          |
|    |               | or Alaska   | Requirements |       |          |
|    |               | remote      | Document     |       |          |
|    |               | village, if | (Appendix    |       |          |
|    |               | any, being  | G).          |       |          |
|    |               | served by a |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System in   |              |       |          |
|    |               | whole or in |              |       |          |
|    |               | part.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ZIPSERVED     | The zip     |              | Geogr | SERVICE  |
|    |               | code of the |              | aphic | AREA ZIP |
|    |               | population  |              | Area  | CODE     |
|    |               | served by   |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *L |               |             |              |       |          |
| EG |               |             |              |       |          |
| AL |               |             |              |       |          |
| EN |               |             |              |       |          |
| TI |               |             |              |       |          |
| TY |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gL |               |             |              |       |          |
| EG |               |             |              |       |          |
| AL |               |             |              |       |          |
| EN |               |             |              |       |          |
| TI |               |             |              |       |          |
| TY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CON           | An          |              | Legal | ADDRESS  |
|    | TACTADDRESSID | al          |              | E     | ID       |
|    |               | pha-numeric |              | ntity |          |
|    |               | value used  |              |       |          |
|    |               | to uniquely |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | addressee   |              |       |          |
|    |               | of a public |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System or a |              |       |          |
|    |               | Treatment   |              |       |          |
|    |               | Plant       |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LEST          | Contains    |              |       |          |
|    | ATEIDENTIFIER | the         |              |       |          |
|    |               | 2-character |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency      |              |       |          |
|    |               | code.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTSTATE  | A code      | These code   | Legal | US STATE |
|    |               | value that  | values are   | E     | AND      |
|    |               | represents  | documented   | ntity | CANADIAN |
|    |               | the U.S.    | in the       |       | PROVINCE |
|    |               | Postal      | SDWIS/FedRep |       | CODE     |
|    |               | Service     | Requirements |       |          |
|    |               | (USPS)      | Document     |       |          |
|    |               | State       | (Appendix    |       |          |
|    |               | a           | D).          |       |          |
|    |               | bbreviation |              |       |          |
|    |               | or the      |              |       |          |
|    |               | Canadian    |              |       |          |
|    |               | Province    |              |       |          |
|    |               | State       |              |       |          |
|    |               | a           |              |       |          |
|    |               | bbreviation |              |       |          |
|    |               | in which a  |              |       |          |
|    |               | legal       |              |       |          |
|    |               | entity is   |              |       |          |
|    |               | located.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | C             | The legal,  |              | Legal | ORGA     |
|    | ONTACTORGNAME | formal name |              | E     | NIZATION |
|    |               | of the      |              | ntity |          |
|    |               | o           |              |       |          |
|    |               | rganization |              |       |          |
|    |               | responsible |              |       |          |
|    |               | for a Water |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACT       | The         |              | Legal | A        |
|    |               | individual  |              | E     | DDRESSEE |
|    |               | name of a   |              | ntity | NAME     |
|    |               | person or   |              |       |          |
|    |               | contact     |              |       |          |
|    |               | associated  |              |       |          |
|    |               | with a      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CO            | The first   |              | Legal | ADDRESS  |
|    | NTACTADDRESS1 | line of an  |              | E     | LINE 1   |
|    |               | address     |              | ntity |          |
|    |               | applicable  |              |       |          |
|    |               | to a legal  |              |       |          |
|    |               | entity.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CO            | The second  |              | Legal | ADDRESS  |
|    | NTACTADDRESS1 | line of an  |              | E     | LINE 2   |
|    |               | address     |              | ntity |          |
|    |               | applicable  |              |       |          |
|    |               | to a legal  |              |       |          |
|    |               | entity.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTCITY   | The city in |              | Legal | CITY     |
|    |               | which a     |              | E     |          |
|    |               | legal       |              | ntity |          |
|    |               | entity is   |              |       |          |
|    |               | located.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | C             | A two       | These code   | Legal | COUNTRY  |
|    | ONTACTCOUNTRY | character   | values are   | E     | CODE     |
|    |               | alphabetic  | documented   | ntity |          |
|    |               | code that   | in the       |       |          |
|    |               | represents  | SDWIS/FedRep |       |          |
|    |               | the         | Requirements |       |          |
|    |               | countries   | Document     |       |          |
|    |               | of the      | (Appendix    |       |          |
|    |               | world.      | D).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTZIP    | The U.S.    |              | Legal | POSTAL   |
|    |               | Postal      |              | E     | CODE     |
|    |               | Service     |              | ntity |          |
|    |               | (USPS) Zip  |              |       |          |
|    |               | Code or the |              |       |          |
|    |               | in          |              |       |          |
|    |               | ternational |              |       |          |
|    |               | postal code |              |       |          |
|    |               | in which a  |              |       |          |
|    |               | legal       |              |       |          |
|    |               | entity is   |              |       |          |
|    |               | located.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTPHONE  | The         |              | Legal | T        |
|    |               | telephone   |              | E     | ELEPHONE |
|    |               | number of a |              | ntity | NUMBER   |
|    |               | Water       |              |       |          |
|    |               | System or   |              |       |          |
|    |               | the         |              |       |          |
|    |               | system\'s   |              |       |          |
|    |               | primary     |              |       |          |
|    |               | contact.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CO            | The number  |              | Legal | T        |
|    | NTACTPHONEEXT | assigned    |              | E     | ELEPHONE |
|    |               | within an   |              | ntity | E        |
|    |               | o           |              |       | XTENSION |
|    |               | rganization |              |       | NUMBER   |
|    |               | to extend   |              |       |          |
|    |               | the         |              |       |          |
|    |               | external    |              |       |          |
|    |               | teleph      |              |       |          |
|    |               | one-number. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTFAX    | The fax     |              | Legal | FAX      |
|    |               | number of a |              | E     | NUMBER   |
|    |               | Water       |              | ntity |          |
|    |               | System or   |              |       |          |
|    |               | the         |              |       |          |
|    |               | system\'s   |              |       |          |
|    |               | primary     |              |       |          |
|    |               | contact.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CONTACTEMAIL  | The e-mail  |              | Legal | EL       |
|    |               | address of  |              | E     | ECTRONIC |
|    |               | the Water   |              | ntity | ADDRESS  |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| LE |               |             |              |       |          |
| GA |               |             |              |       |          |
| LE |               |             |              |       |          |
| NT |               |             |              |       |          |
| IT |               |             |              |       |          |
| YA |               |             |              |       |          |
| FF |               |             |              |       |          |
| IL |               |             |              |       |          |
| IA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| LE |               |             |              |       |          |
| GA |               |             |              |       |          |
| LE |               |             |              |       |          |
| NT |               |             |              |       |          |
| IT |               |             |              |       |          |
| YA |               |             |              |       |          |
| FF |               |             |              |       |          |
| IL |               |             |              |       |          |
| IA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Legal | ADDRESS  |
|    |               | identifies  |              | E     | ID       |
|    |               | the public  |              | ntity |          |
|    |               | Water       |              | A     |          |
|    |               | System to   |              | ffili |          |
|    |               | which the   |              | ation |          |
|    |               | L           |              |       |          |
|    |               | egalEnetity |              |       |          |
|    |               | Affiliation |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CON           | Contains    | This column, |       |          |
|    | TACTADDRESSID | the ID of   | combined     |       |          |
|    |               | the         | with         |       |          |
|    |               | associated  | LESTAT       |       |          |
|    |               | legal       | EIDENTIFIER, |       |          |
|    |               | entity      | logically    |       |          |
|    |               |             | connects     |       |          |
|    |               |             | LegalEntit   |       |          |
|    |               |             | yAffiliation |       |          |
|    |               |             | table to the |       |          |
|    |               |             | LegalEntity  |       |          |
|    |               |             | table.       |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LEST          | Contains    |              |       |          |
|    | ATEIDENTIFIER | the         |              |       |          |
|    |               | 2-character |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency      |              |       |          |
|    |               | code.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | This column | The FACID is | Legal | FACILITY |
|    |               | identifies  | logically    | E     | ID       |
|    |               | the Water   | related to   | ntity |          |
|    |               | System      | the          | A     |          |
|    |               | Facility to | WaterSy      | ffili |          |
|    |               | which the   | stemFacility | ation |          |
|    |               | LegalEntity | table. A     |       |          |
|    |               | Affiliation | constraint   |       |          |
|    |               | is          | does not     |       |          |
|    |               | associated. | exist        |       |          |
|    |               |             | between      |       |          |
|    |               |             | these two    |       |          |
|    |               |             | tables.      |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | AF            | A code      | These code   | Legal | AFF      |
|    | FILIATIONTYPE | value which | values are   | E     | ILIATION |
|    |               | categorizes | documented   | ntity | TYPE     |
|    |               | the reason  | in the       | A     |          |
|    |               | for         | SDWIS/FedRep | ffili |          |
|    |               | associating | Requirements | ation |          |
|    |               | a legal     | Document     |       |          |
|    |               | entity with | (Appendix    |       |          |
|    |               | a public    | E).          |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
|    |               | Note: only  |              |       |          |
|    |               | one         |              |       |          |
|    |               | adm         |              |       |          |
|    |               | inistrative |              |       |          |
|    |               | contact     |              |       |          |
|    |               | should be   |              |       |          |
|    |               | identified  |              |       |          |
|    |               | for each    |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| LO |               |             |              |       |          |
| CA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| AL |               |             |              |       |          |
| DE |               |             |              |       |          |
| TA |               |             |              |       |          |
| IL |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| LO |               |             |              |       |          |
| CA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| AL |               |             |              |       |          |
| DE |               |             |              |       |          |
| TA |               |             |              |       |          |
| IL |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Locat | PWS ID   |
|    |               | identifies  |              | ional |          |
|    |               | the public  |              | D     |          |
|    |               | Water       |              | etail |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Locat       |              |       |          |
|    |               | ionalDetail |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | This column |              | Locat | FACILITY |
|    |               | identifies  |              | ional | ID       |
|    |               | the Water   |              | D     |          |
|    |               | System      |              | etail |          |
|    |               | Facility to |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Locat       |              |       |          |
|    |               | ionalDetail |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LATDEGMINSEC, | Coordinate  |              | Locat | LATITUDE |
|    |               | rep         |              | ional | DEG:M    |
|    |               | resentation |              | D     | INS:SECS |
|    |               | indicating  |              | etail |          |
|    |               | a location  |              |       |          |
|    |               | on the      |              |       |          |
|    |               | surface of  |              |       |          |
|    |               | the earth,  |              |       |          |
|    |               | using the   |              |       |          |
|    |               | earth\'s    |              |       |          |
|    |               | Equator as  |              |       |          |
|    |               | the origin, |              |       |          |
|    |               | reported in |              |       |          |
|    |               | degrees,    |              |       |          |
|    |               | minutes,    |              |       |          |
|    |               | and         |              |       |          |
|    |               | seconds.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LONGDEGMINSEC | Coordinate  |              | Locat | L        |
|    |               | rep         |              | ional | ONGITUDE |
|    |               | resentation |              | D     | DEG:M    |
|    |               | indicating  |              | etail | INS:SECS |
|    |               | a location  |              |       |          |
|    |               | on the      |              |       |          |
|    |               | surface of  |              |       |          |
|    |               | the earth,  |              |       |          |
|    |               | using the   |              |       |          |
|    |               | Prime       |              |       |          |
|    |               | Meridian    |              |       |          |
|    |               | (Greenwich, |              |       |          |
|    |               | England) as |              |       |          |
|    |               | the origin, |              |       |          |
|    |               | reported in |              |       |          |
|    |               | degrees,    |              |       |          |
|    |               | minutes,    |              |       |          |
|    |               | and         |              |       |          |
|    |               | seconds.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LATDECDEG     | Coordinate  |              | Locat | LATITUDE |
|    |               | rep         |              | ional | MEASURE  |
|    |               | resentation |              | D     |          |
|    |               | indicating  |              | etail |          |
|    |               | a location  |              |       |          |
|    |               | on the      |              |       |          |
|    |               | surface of  |              |       |          |
|    |               | the earth,  |              |       |          |
|    |               | using the   |              |       |          |
|    |               | earth\'s    |              |       |          |
|    |               | Equator as  |              |       |          |
|    |               | the origin, |              |       |          |
|    |               | reported in |              |       |          |
|    |               | decimal     |              |       |          |
|    |               | degrees.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LONGDECDEG    | Coordinate  |              | Locat | L        |
|    |               | rep         |              | ional | ONGITUDE |
|    |               | resentation |              | D     | MEASURE  |
|    |               | indicating  |              | etail |          |
|    |               | a location  |              |       |          |
|    |               | on the      |              |       |          |
|    |               | surface of  |              |       |          |
|    |               | the earth,  |              |       |          |
|    |               | using the   |              |       |          |
|    |               | Prime       |              |       |          |
|    |               | Meridian    |              |       |          |
|    |               | (Greenwich, |              |       |          |
|    |               | England) as |              |       |          |
|    |               | the origin, |              |       |          |
|    |               | reported in |              |       |          |
|    |               | decimal     |              |       |          |
|    |               | degrees.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLC           | Method used |              | Locat | HO       |
|    | OLLECTIONMETH | to          |              | ional | RIZONTAL |
|    |               | determine   |              | D     | CO       |
|    |               | the         |              | etail | LLECTION |
|    |               | latitude    |              |       | METHOD   |
|    |               | /longitude. |              |       | CODE     |
|    |               | This        |              |       |          |
|    |               | represents  |              |       |          |
|    |               | the primary |              |       |          |
|    |               | source of   |              |       |          |
|    |               | the data.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LL            | Q           |              | Locat | HO       |
|    | HORIZACCURACY | uantitative |              | ional | RIZONTAL |
|    |               | measurement |              | D     | ACCURACY |
|    |               | of the      |              | etail | MEASURE  |
|    |               | amount of   |              |       |          |
|    |               | deviation   |              |       |          |
|    |               | from true   |              |       |          |
|    |               | value in a  |              |       |          |
|    |               | measurement |              |       |          |
|    |               | for         |              |       |          |
|    |               | latitude or |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | (estimate   |              |       |          |
|    |               | of error).  |              |       |          |
|    |               | It          |              |       |          |
|    |               | describes   |              |       |          |
|    |               | the         |              |       |          |
|    |               | correctness |              |       |          |
|    |               | of the      |              |       |          |
|    |               | latitud     |              |       |          |
|    |               | e/longitude |              |       |          |
|    |               | m           |              |       |          |
|    |               | easurement, |              |       |          |
|    |               | in meters.  |              |       |          |
|    |               | Only the    |              |       |          |
|    |               | least       |              |       |          |
|    |               | accurate    |              |       |          |
|    |               | measurement |              |       |          |
|    |               | is          |              |       |          |
|    |               | recorded,   |              |       |          |
|    |               | regardless  |              |       |          |
|    |               | whether it  |              |       |          |
|    |               | is for      |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | or          |              |       |          |
|    |               | latitude.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    |               | Category of |              | Locat | R        |
|    |               | the feature |              | ional | EFERENCE |
|    |               | referenced  |              | D     | POINT    |
|    |               | by the      |              | etail | CODE     |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLHORIZDATUM  | Reference   |              | Locat | HO       |
|    |               | standard    |              | ional | RIZONTAL |
|    |               | for three   |              | D     | R        |
|    |               | dimensional |              | etail | EFERENCE |
|    |               | and         |              |       | DATUM    |
|    |               | horizontal  |              |       | CODE     |
|    |               | positioning |              |       |          |
|    |               | established |              |       |          |
|    |               | by the U.S. |              |       |          |
|    |               | National    |              |       |          |
|    |               | Geodetic    |              |       |          |
|    |               | Survey      |              |       |          |
|    |               | (NGS) and   |              |       |          |
|    |               | other       |              |       |          |
|    |               | bodies.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLSOURCESCALE | Scale of    |              | Locat | SOURCE   |
|    |               | the map     |              | ional | MAP      |
|    |               | used to     |              | D     | SCALE    |
|    |               | determine   |              | etail |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | c           |              |       |          |
|    |               | oordinates. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LL            | Value       |              | Locat | G        |
|    | GEOMETRICTYPE | indicating  |              | ional | EOMETRIC |
|    |               | whether the |              | D     | TYPE     |
|    |               | latitude    |              | etail | CODE     |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | coordinates |              |       |          |
|    |               | represent a |              |       |          |
|    |               | point,      |              |       |          |
|    |               | multiple    |              |       |          |
|    |               | points on a |              |       |          |
|    |               | line, or an |              |       |          |
|    |               | area.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLC           | Date when   |              | Locat | DATA     |
|    | OLLECTIONDATE | the         |              | ional | CO       |
|    |               | latitude    |              | D     | LLECTION |
|    |               | and         |              | etail | DATE     |
|    |               | longitude   |              |       |          |
|    |               | coordinates |              |       |          |
|    |               | were        |              |       |          |
|    |               | determined. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | COORDINATE    | Party       |              | Locat | CO       |
|    | DATA SOURCE   | responsible |              | ional | ORDINATE |
|    | CODE          | for         |              | D     | DATA     |
|    |               | collecting  |              | etail | SOURCE   |
|    |               | or          |              |       | CODE     |
|    |               | otherwise   |              |       |          |
|    |               | providing   |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLVERIF       | A code      |              | Locat | VERI     |
|    | ICATIONMETHOD | r           |              | ional | FICATION |
|    |               | epresenting |              | D     | METHOD   |
|    |               | the process |              | etail | CODE     |
|    |               | by which    |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | coordinates |              |       |          |
|    |               | have been   |              |       |          |
|    |               | verified by |              |       |          |
|    |               | EPA,        |              |       |          |
|    |               | grantees,   |              |       |          |
|    |               | or          |              |       |          |
|    |               | c           |              |       |          |
|    |               | ontractors. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLVERTMEASURE | Vertical    |              | Locat | VERTICAL |
|    |               | distance    |              | ional | MEASURE  |
|    |               | from the    |              | D     |          |
|    |               | vertical    |              | etail |          |
|    |               | datum to    |              |       |          |
|    |               | the land    |              |       |          |
|    |               | surface or  |              |       |          |
|    |               | other       |              |       |          |
|    |               | measuring   |              |       |          |
|    |               | point, in   |              |       |          |
|    |               | meters.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLVERTCOL     | Code        |              | Locat | VERTICAL |
|    | LECTIONMETHOD | r           |              | ional | CO       |
|    |               | epresenting |              | D     | LLECTION |
|    |               | the method  |              | etail | METHOD   |
|    |               | used to     |              |       | CODE     |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | measure.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | L             | Q           |              | Locat | VERTICAL |
|    | LVERTACCURACY | uantitative |              | ional | ACCURACY |
|    |               | measurement |              | D     | MEASURE  |
|    |               | of the      |              | etail |          |
|    |               | amount of   |              |       |          |
|    |               | deviation   |              |       |          |
|    |               | from true   |              |       |          |
|    |               | value in    |              |       |          |
|    |               | the         |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | measure     |              |       |          |
|    |               | (estimate   |              |       |          |
|    |               | of error).  |              |       |          |
|    |               | It          |              |       |          |
|    |               | describes   |              |       |          |
|    |               | the         |              |       |          |
|    |               | correctness |              |       |          |
|    |               | of the      |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | measure, in |              |       |          |
|    |               | meters.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLVERTDATUM   | Code        |              | Locat | VERTICAL |
|    |               | r           |              | ional | R        |
|    |               | epresenting |              | D     | EFERENCE |
|    |               | which       |              | etail | DATUM    |
|    |               | national    |              |       | CODE     |
|    |               | reference   |              |       |          |
|    |               | standard    |              |       |          |
|    |               | for         |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | control     |              |       |          |
|    |               | established |              |       |          |
|    |               | by the U.S. |              |       |          |
|    |               | National    |              |       |          |
|    |               | Geodetic    |              |       |          |
|    |               | Survey      |              |       |          |
|    |               | (NGS) is    |              |       |          |
|    |               | used to     |              |       |          |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | measure.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LLCOMMENTS    | Comments    |              | Locat | LOCATION |
|    |               | further     |              | ional | COMMENT  |
|    |               | describing  |              | D     | TEXT     |
|    |               | the         |              | etail |          |
|    |               | collection, |              |       |          |
|    |               | processing, |              |       |          |
|    |               | or          |              |       |          |
|    |               | int         |              |       |          |
|    |               | erpretation |              |       |          |
|    |               | of the      |              |       |          |
|    |               | latitude,   |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | and/or      |              |       |          |
|    |               | vertical    |              |       |          |
|    |               | data.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| SA |               |             |              |       |          |
| MP |               |             |              |       |          |
| LE |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| SA |               |             |              |       |          |
| MP |               |             |              |       |          |
| LE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | S     | PWS ID   |
|    |               | identifies  |              | ample |          |
|    |               | the public  |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Sample is   |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMPLEID      | A qualifier |              | S     | SAMPLE   |
|    |               | used to     |              | ample | ID       |
|    |               | uniquely    |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | sampling    |              |       |          |
|    |               | occurrence  |              |       |          |
|    |               | related to  |              |       |          |
|    |               | a Water     |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | A           |              | S     | FACILITY |
|    |               | sta         |              | ample | ID       |
|    |               | te-assigned |              |       |          |
|    |               | value which |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMPL         | The         |              | S     | SAMPLE   |
|    | EMONBEGINDATE | calendar    |              | ample | BEGIN    |
|    |               | date of the |              |       | DATE     |
|    |               | first day   |              |       |          |
|    |               | of the      |              |       |          |
|    |               | monitoring  |              |       |          |
|    |               | period in   |              |       |          |
|    |               | which 90th  |              |       |          |
|    |               | percentile  |              |       |          |
|    |               | data for    |              |       |          |
|    |               | lead or     |              |       |          |
|    |               | copper was  |              |       |          |
|    |               | acquired.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAM           | For lead    |              | S     | SAMPLE   |
|    | PLEMONENDDATE | and copper  |              | ample | END DATE |
|    |               | samples,    |              |       |          |
|    |               | the         |              |       |          |
|    |               | calendar    |              |       |          |
|    |               | date of the |              |       |          |
|    |               | last day of |              |       |          |
|    |               | the         |              |       |          |
|    |               | monitoring  |              |       |          |
|    |               | period in   |              |       |          |
|    |               | which 90th  |              |       |          |
|    |               | percentile  |              |       |          |
|    |               | data was    |              |       |          |
|    |               | acquired.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | S             | The         |              | S     | SAMPLE   |
|    | AMPLECOLLDATE | calendar    |              | ample | CO       |
|    |               | date on     |              |       | LLECTION |
|    |               | which the   |              |       | DATE     |
|    |               | sample was  |              |       |          |
|    |               | collected.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACWATERTYPE  | A code      |              | S     | SOURCE   |
|    |               | value which |              | ample | TYPE     |
|    |               | indicates   |              |       |          |
|    |               | the type of |              |       |          |
|    |               | source from |              |       |          |
|    |               | which an    |              |       |          |
|    |               | unregulated |              |       |          |
|    |               | contaminant |              |       |          |
|    |               | monitoring  |              |       |          |
|    |               | sample was  |              |       |          |
|    |               | taken.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMPL         | A numeric   |              | S     | QTY      |
|    | ECOMPOSITEQTY | value that  |              | ample | CO       |
|    |               | represents  |              |       | MPOSITED |
|    |               | the total   |              |       |          |
|    |               | number of   |              |       |          |
|    |               | individual  |              |       |          |
|    |               | samples     |              |       |          |
|    |               | contained   |              |       |          |
|    |               | in a        |              |       |          |
|    |               | composite   |              |       |          |
|    |               | sample      |              |       |          |
|    |               | analysis.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SRCTRTCODE    | A code      |              | S     | SAMPLE   |
|    |               | value that  |              | ample | TYPE     |
|    |               | represents  |              |       |          |
|    |               | the type of |              |       |          |
|    |               | sample      |              |       |          |
|    |               | collected.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMP          | An          |              | S     | SAMPLING |
|    | LESTATEASGNID | identifier  |              | ample | RECONC   |
|    |               | used for    |              |       | ILIATION |
|    |               | rec         |              |       | ID       |
|    |               | onciliation |              |       |          |
|    |               | with the    |              |       |          |
|    |               | state data  |              |       |          |
|    |               | system or   |              |       |          |
|    |               | LAB         |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | i           |              |       |          |
|    |               | dentifiers. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| SA |               |             |              |       |          |
| MP |               |             |              |       |          |
| LE |               |             |              |       |          |
| RE |               |             |              |       |          |
| SU |               |             |              |       |          |
| LT |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| *  |               |             |              |       |          |
| *s |               |             |              |       |          |
| tg |               |             |              |       |          |
| SA |               |             |              |       |          |
| MP |               |             |              |       |          |
| LE |               |             |              |       |          |
| RE |               |             |              |       |          |
| SU |               |             |              |       |          |
| LT |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | S     | PWS ID   |
|    |               | identifies  |              | ample |          |
|    |               | the public  |              | R     |          |
|    |               | Water       |              | esult |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Sample is   |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMPLEID      | A qualifier |              | S     | SAMPLE   |
|    |               | used to     |              | ample | ID       |
|    |               | uniquely    |              | R     |          |
|    |               | identify a  |              | esult |          |
|    |               | specific    |              |       |          |
|    |               | sampling    |              |       |          |
|    |               | occurrence  |              |       |          |
|    |               | related to  |              |       |          |
|    |               | a Water     |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SARIDENTIFIER | A           |              |       |          |
|    |               | syste       |              |       |          |
|    |               | m-generated |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | each        |              |       |          |
|    |               | S           |              |       |          |
|    |               | ampleResult |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CCODE         | The         |              | S     | SAMPLE   |
|    |               | ide         |              | ample | CON      |
|    |               | ntification |              | R     | TAMINANT |
|    |               | number of   |              | esult |          |
|    |               | the         |              |       |          |
|    |               | contaminant |              |       |          |
|    |               | for which   |              |       |          |
|    |               | sample data |              |       |          |
|    |               | have been   |              |       |          |
|    |               | reported    |              |       |          |
|    |               | for a       |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SA            | A code      | These code   | S     | SAMPLE   |
|    | MPLANALMETHOD | value that  | values are   | ample | ANALYSIS |
|    |               | represents  | documented   | R     | METHOD   |
|    |               | the         | in the       | esult |          |
|    |               | analysis    | SDWIS/FedRep |       |          |
|    |               | technique   | Requirements |       |          |
|    |               | or method   | Document     |       |          |
|    |               | that was    | (Appendix    |       |          |
|    |               | used to     | N).          |       |          |
|    |               | obtain an   |              |       |          |
|    |               | analytical  |              |       |          |
|    |               | result.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RESULTSIGN    | A sign      |              | S     | SAMPLE   |
|    |               | value used  |              | ample | RESULT   |
|    |               | to indicate |              | R     | SIGN     |
|    |               | the         |              | esult |          |
|    |               | detection   |              |       |          |
|    |               | limit       |              |       |          |
|    |               | reported    |              |       |          |
|    |               | for data    |              |       |          |
|    |               | element     |              |       |          |
|    |               | SAMPLE      |              |       |          |
|    |               | ANALYSIS    |              |       |          |
|    |               | RESULT.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SAMPLEMEASURE | A numeric   |              | S     | SAMPLE   |
|    |               | value that  |              | ample | ANALYSIS |
|    |               | represents  |              | R     | RESULT   |
|    |               | the result  |              | esult |          |
|    |               | obtained    |              |       |          |
|    |               | from a      |              |       |          |
|    |               | sample\'s   |              |       |          |
|    |               | analysis.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | UNITMEASURE   | The unit of |              | S     | UNIT OF  |
|    |               | measure     |              | ample | MEASURE  |
|    |               | (UM) that   |              | R     |          |
|    |               | is          |              | esult |          |
|    |               | associated  |              |       |          |
|    |               | with the    |              |       |          |
|    |               | value       |              |       |          |
|    |               | reported    |              |       |          |
|    |               | for SAMPLE  |              |       |          |
|    |               | ANALYSIS    |              |       |          |
|    |               | RESULT      |              |       |          |
|    |               | (C2111).    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *S |               |             |              |       |          |
| ER |               |             |              |       |          |
| VI |               |             |              |       |          |
| CE |               |             |              |       |          |
| AR |               |             |              |       |          |
| EA |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gS |               |             |              |       |          |
| ER |               |             |              |       |          |
| VI |               |             |              |       |          |
| CE |               |             |              |       |          |
| AR |               |             |              |       |          |
| EA |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Se    | PWS ID   |
|    |               | identifies  |              | rvice |          |
|    |               | the public  |              | Area  |          |
|    |               | Water       |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | ServiceArea |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PSVCAREA      | Indicates   | Permitted    |       |          |
|    |               | whether a   | values of    |       |          |
|    |               | service     | this column  |       |          |
|    |               | area is the | are "Y"      |       |          |
|    |               | primary     | (means the   |       |          |
|    |               | service     | record is    |       |          |
|    |               | area of the | the primary  |       |          |
|    |               | Water.      | service      |       |          |
|    |               |             | area), and   |       |          |
|    |               |             | "N" (means   |       |          |
|    |               |             | that the     |       |          |
|    |               |             | record is    |       |          |
|    |               |             | not the      |       |          |
|    |               |             | primary      |       |          |
|    |               |             | service      |       |          |
|    |               |             | area), null  |       |          |
|    |               |             | (which also  |       |          |
|    |               |             | means that   |       |          |
|    |               |             | the record   |       |          |
|    |               |             | is not the   |       |          |
|    |               |             | primary      |       |          |
|    |               |             | service      |       |          |
|    |               |             | area).       |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SVCAREA       | A code      | These code   | Se    | SERVICE  |
|    |               | value that  | values are   | rvice | AREA     |
|    |               | describes a | documented   | Area  | CODE,    |
|    |               | cat         | in the       |       |          |
|    |               | egorization | SDWIS/FedRep |       | PRIMARY  |
|    |               | of the      | Requirements |       | SERVICE  |
|    |               | areas       | Document     |       | AREA     |
|    |               | serviced by | (Appendix    |       | CODE     |
|    |               | the Public  | F).          |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *S |               |             |              |       |          |
| IT |               |             |              |       |          |
| EV |               |             |              |       |          |
| IS |               |             |              |       |          |
| IT |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gS |               |             |              |       |          |
| IT |               |             |              |       |          |
| EV |               |             |              |       |          |
| IS |               |             |              |       |          |
| IT |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Site  | PWS ID   |
|    |               | identifies  |              | Visit |          |
|    |               | the Water   |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | SiteVisit   |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VISITID       | A value     |              | Site  | VISIT ID |
|    |               | used to     |              | Visit |          |
|    |               | uniquely    |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | on-site     |              |       |          |
|    |               | visit made  |              |       |          |
|    |               | to a Water  |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VISITDATE     | A value     |              | Site  | VISIT    |
|    |               | that        |              | Visit | DATE     |
|    |               | represents  |              |       |          |
|    |               | the         |              |       |          |
|    |               | calendar    |              |       |          |
|    |               | date on     |              |       |          |
|    |               | which a     |              |       |          |
|    |               | visit was   |              |       |          |
|    |               | made to a   |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VISITREASON   | A code      | These code   | Site  | VISIT    |
|    |               | value       | values are   | Visit | REASON   |
|    |               | r           | documented   |       |          |
|    |               | epresenting | in the       |       |          |
|    |               | the reason  | SDWIS/FedRep |       |          |
|    |               | a visit was | Requirements |       |          |
|    |               | made to a   | Document     |       |          |
|    |               | Water       | (Appendix    |       |          |
|    |               | System.     | P).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VISITAGENCY   | A code      | These code   | Site  | VISIT    |
|    |               | value that  | values are   | Visit | AGENCY   |
|    |               | represents  | documented   |       | TYPE     |
|    |               | the type of | in the       |       |          |
|    |               | agency that | SDWIS/FedRep |       |          |
|    |               | conducted   | Requirements |       |          |
|    |               | the Site    | Document     |       |          |
|    |               | Visit.      | (Appendix    |       |          |
|    |               |             | P).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | M             | A code      | These code   | Site  | CATEGORY |
|    | ANAGEMENTOPER | value that  | values are   | Visit | EV       |
|    | ATIONEVALCODE | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | MA       |
|    |               | the outcome | SDWIS/FedRep |       | NAGEMENT |
|    |               | of          | Requirements |       | AND      |
|    |               | evaluating  | Document     |       | OP       |
|    |               | this        | (Appendix    |       | ERATIONS |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | S             | A code      | These code   | Site  | CATEGORY |
|    | OURCEEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | SOURCE   |
|    |               | the outcome | SDWIS/FedRep |       |          |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SEC           | A code      | These code   | Site  | CATEGORY |
|    | URITYEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | SECURITY |
|    |               | the outcome | SDWIS/FedRep |       |          |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PUMPSEVALCODE | A code      | These code   | Site  | CATEGORY |
|    |               | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | PUMPS    |
|    |               | the outcome | SDWIS/FedRep |       |          |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | OTHEREVALCODE | A code      | These code   | Site  | CATEGORY |
|    |               | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | OTHER    |
|    |               | the outcome | SDWIS/FedRep |       |          |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | OPERATORCOMPL | A code      | These code   | Site  | CATEGORY |
|    | IANCEEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | OPERATOR |
|    |               | the outcome | SDWIS/FedRep |       | CO       |
|    |               | of          | Requirements |       | MPLIANCE |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAVERIFIC   | A code      | These code   | Site  | CATEGORY |
|    | ATIONEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | MO       |
|    |               | the outcome | SDWIS/FedRep |       | NITORING |
|    |               | of          | Requirements |       | R        |
|    |               | evaluating  | Document     |       | EPORTING |
|    |               | this        | (Appendix    |       | DATA     |
|    |               | category    | P).          |       | VERI     |
|    |               | during the  |              |       | FICATION |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TREA          | A code      | These code   | Site  | CATEGORY |
|    | TMENTEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | T        |
|    |               | the outcome | SDWIS/FedRep |       | REATMENT |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FI            | A code      | These code   | Site  | CATEGORY |
|    | NISHEDWATERST | value that  | values are   | Visit | EV       |
|    | ORAGEEVALCODE | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | FINISHED |
|    |               | the outcome | SDWIS/FedRep |       | WATER    |
|    |               | of          | Requirements |       | STORAGE  |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DISTRIB       | A code      | These code   | Site  | CATEGORY |
|    | UTIONEVALCODE | value that  | values are   | Visit | EV       |
|    |               | describes   | documented   |       | ALUATION |
|    |               | in summary, | in the       |       | DIST     |
|    |               | the outcome | SDWIS/FedRep |       | RIBUTION |
|    |               | of          | Requirements |       |          |
|    |               | evaluating  | Document     |       |          |
|    |               | this        | (Appendix    |       |          |
|    |               | category    | P).          |       |          |
|    |               | during the  |              |       |          |
|    |               | site visit. |              |       |          |
|    |               | This is one |              |       |          |
|    |               | of the      |              |       |          |
|    |               | elements    |              |       |          |
|    |               | set out in  |              |       |          |
|    |               | EPA/State   |              |       |          |
|    |               | Joint       |              |       |          |
|    |               | Guidance on |              |       |          |
|    |               | Sanitary    |              |       |          |
|    |               | Surveys.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VISITCOMMENTS | An          |              | Site  | SITE     |
|    |               | a           |              | Visit | VISIT    |
|    |               | lphanumeric |              |       | COMMENT  |
|    |               | value that  |              |       |          |
|    |               | represents  |              |       |          |
|    |               | any         |              |       |          |
|    |               | d           |              |       |          |
|    |               | escription, |              |       |          |
|    |               | char        |              |       |          |
|    |               | acteristic, |              |       |          |
|    |               | or          |              |       |          |
|    |               | attribute   |              |       |          |
|    |               | that the    |              |       |          |
|    |               | State or    |              |       |          |
|    |               | EPA region  |              |       |          |
|    |               | wants to    |              |       |          |
|    |               | record for  |              |       |          |
|    |               | the site    |              |       |          |
|    |               | visit.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *T |               |             |              |       |          |
| RE |               |             |              |       |          |
| AT |               |             |              |       |          |
| ME |               |             |              |       |          |
| NT |               |             |              |       |          |
| DA |               |             |              |       |          |
| TA |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gT |               |             |              |       |          |
| RE |               |             |              |       |          |
| AT |               |             |              |       |          |
| ME |               |             |              |       |          |
| NT |               |             |              |       |          |
| DA |               |             |              |       |          |
| TA |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Trea  | PWS ID   |
|    |               | identifies  |              | tment |          |
|    |               | the public  |              | Data  |          |
|    |               | Water       |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Tr          |              |       |          |
|    |               | eatmentData |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | A           |              | Trea  | FACILITY |
|    |               | sta         |              | tment | ID       |
|    |               | te-assigned |              | Data  |          |
|    |               | value which |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TRTID         | A numeric   |              | Trea  | T        |
|    |               | value used  |              | tment | REATMENT |
|    |               | to uniquely |              | Data  | ID       |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | treatment   |              |       |          |
|    |               | applied to  |              |       |          |
|    |               | a source of |              |       |          |
|    |               | water for a |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TRTOBJCODE    | A code      | These code   | Trea  | T        |
|    |               | value that  | values are   | tment | REATMENT |
|    |               | categorizes | documented   | Data  | O        |
|    |               | the         | in the       |       | BJECTIVE |
|    |               | treatment   | SDWIS/FedRep |       |          |
|    |               | objective   | Requirements |       |          |
|    |               | to be       | Document     |       |          |
|    |               | attained    | (Appendix    |       |          |
|    |               | through     | L).          |       |          |
|    |               | treatment   |              |       |          |
|    |               | of a source |              |       |          |
|    |               | of water.   |              |       |          |
|    |               | Examples    |              |       |          |
|    |               | include     |              |       |          |
|    |               | objectives  |              |       |          |
|    |               | such as     |              |       |          |
|    |               | di          |              |       |          |
|    |               | sinfection, |              |       |          |
|    |               | particulate |              |       |          |
|    |               | removal,    |              |       |          |
|    |               | corrosion   |              |       |          |
|    |               | control,    |              |       |          |
|    |               | softening,  |              |       |          |
|    |               | etc.        |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | T             | A code      | These code   | Trea  | T        |
|    | RTPROCESSCODE | value that  | values are   | tment | REATMENT |
|    |               | categorizes | documented   | Data  | PROCESS  |
|    |               | the         | in the       |       |          |
|    |               | treatment   | SDWIS/FedRep |       |          |
|    |               | process to  | Requirements |       |          |
|    |               | be applied  | Document     |       |          |
|    |               | to a source | (Appendix    |       |          |
|    |               | of water    | L).          |       |          |
|    |               | for a Water |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TRTCOMMENTS   | Describes a |              | Trea  | T        |
|    |               | treatment   |              | tment | REATMENT |
|    |               | combination |              | Data  | COMMENT  |
|    |               | or process. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *V |               |             |              |       |          |
| IO |               |             |              |       |          |
| LA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gV |               |             |              |       |          |
| IO |               |             |              |       |          |
| LA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Viol  | PWS ID   |
|    |               | identifies  |              | ation |          |
|    |               | the public  |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Violation   |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | A           |              | Viol  | FACILITY |
|    |               | sta         |              | ation | ID       |
|    |               | te-assigned |              |       |          |
|    |               | value which |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VIOID         | An          |              | Viol  | V        |
|    |               | a           |              | ation | IOLATION |
|    |               | lphanumeric |              |       | ID       |
|    |               | value used  |              |       |          |
|    |               | to uniquely |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | violation   |              |       |          |
|    |               | of a        |              |       |          |
|    |               | primary     |              |       |          |
|    |               | drinking    |              |       |          |
|    |               | water       |              |       |          |
|    |               | regulation  |              |       |          |
|    |               | incurred by |              |       |          |
|    |               | a public    |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VCODE         | A code      | Code values  | Viol  | V        |
|    |               | value which | are          | ation | IOLATION |
|    |               | categorizes | documented   |       | TYPE     |
|    |               | a           | in the       |       |          |
|    |               | violation.  | SDWIS/FedRep |       |          |
|    |               |             | Requirements |       |          |
|    |               |             | Document     |       |          |
|    |               |             | (Appendix    |       |          |
|    |               |             | N).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CCODE         | A code      | Code values  | Viol  | CON      |
|    |               | value that  | are          | ation | TAMINANT |
|    |               | represents  | documented   |       | CODE     |
|    |               | a           | in the       |       |          |
|    |               | contaminant | SDWIS/FedRep |       |          |
|    |               | for which a | Requirements |       |          |
|    |               | public      | Document     |       |          |
|    |               | Water       | (Appendix    |       |          |
|    |               | System has  | N).          |       |          |
|    |               | incurred a  |              |       |          |
|    |               | violation   |              |       |          |
|    |               | of a        |              |       |          |
|    |               | primary     |              |       |          |
|    |               | drinking    |              |       |          |
|    |               | water       |              |       |          |
|    |               | regulation. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | COMP          | The         |              | Viol  | CO       |
|    | LPERBEGINDATE | calendar    |              | ation | MPLIANCE |
|    |               | date of the |              |       | PERIOD   |
|    |               | beginning   |              |       | BEGIN    |
|    |               | of a period |              |       | DATE     |
|    |               | in which a  |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System was  |              |       |          |
|    |               | determined  |              |       |          |
|    |               | to be in    |              |       |          |
|    |               | violation   |              |       |          |
|    |               | of a        |              |       |          |
|    |               | primary     |              |       |          |
|    |               | drinking    |              |       |          |
|    |               | water       |              |       |          |
|    |               | regulation. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CO            | The         |              | Viol  | CO       |
|    | MPLPERENDDATE | calendar    |              | ation | MPLIANCE |
|    |               | date of the |              |       | PERIOD   |
|    |               | end of a    |              |       | END DATE |
|    |               | monitoring  |              |       |          |
|    |               | period in   |              |       |          |
|    |               | which a     |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System was  |              |       |          |
|    |               | in          |              |       |          |
|    |               | violation   |              |       |          |
|    |               | of a        |              |       |          |
|    |               | primary     |              |       |          |
|    |               | drinking    |              |       |          |
|    |               | water       |              |       |          |
|    |               | regulation. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VIOLMEASURE   | A numeric   |              | Viol  | ANALYSIS |
|    |               | value that  |              | ation | RESULT   |
|    |               | represents  |              |       |          |
|    |               | the result  |              |       |          |
|    |               | obtained    |              |       |          |
|    |               | from a      |              |       |          |
|    |               | single      |              |       |          |
|    |               | analysis,   |              |       |          |
|    |               | or the      |              |       |          |
|    |               | average     |              |       |          |
|    |               | result      |              |       |          |
|    |               | obtained    |              |       |          |
|    |               | from        |              |       |          |
|    |               | multiple    |              |       |          |
|    |               | analyses,   |              |       |          |
|    |               | that led to |              |       |          |
|    |               | the         |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | of an MCL   |              |       |          |
|    |               | violation   |              |       |          |
|    |               | for a       |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATEMCL      | A numeric   |              | Viol  | LEVEL    |
|    |               | value that  |              | ation | VIOLATED |
|    |               | represents  |              |       |          |
|    |               | the maximum |              |       |          |
|    |               | contaminant |              |       |          |
|    |               | level which |              |       |          |
|    |               | was         |              |       |          |
|    |               | exceeded    |              |       |          |
|    |               | that led to |              |       |          |
|    |               | the         |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | of an MCL   |              |       |          |
|    |               | violation   |              |       |          |
|    |               | for a       |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
|    |               | Only        |              |       |          |
|    |               | reported    |              |       |          |
|    |               | when the    |              |       |          |
|    |               | State MCL   |              |       |          |
|    |               | is more     |              |       |          |
|    |               | stringent   |              |       |          |
|    |               | than the    |              |       |          |
|    |               | Federal     |              |       |          |
|    |               | MCL.        |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | MAJORVIOLIND  | A code      | Code values  | Viol  | MAJOR    |
|    |               | value that  | are          | ation | V        |
|    |               | indicates   | documented   |       | IOLATION |
|    |               | the         | in the       |       | I        |
|    |               | severity of | SDWIS/FedRep |       | NDICATOR |
|    |               | a           | Requirements |       |          |
|    |               | Monitoring  | Document     |       |          |
|    |               | and         | (Appendix    |       |          |
|    |               | Reporting   | N).          |       |          |
|    |               | (M&R)       |              |       |          |
|    |               | violation,  |              |       |          |
|    |               | major or    |              |       |          |
|    |               | minor. The  |              |       |          |
|    |               | major       |              |       |          |
|    |               | versus      |              |       |          |
|    |               | minor       |              |       |          |
|    |               | designation |              |       |          |
|    |               | does not    |              |       |          |
|    |               | apply to a  |              |       |          |
|    |               | sanitary    |              |       |          |
|    |               | survey M&R  |              |       |          |
|    |               | violation.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERID        | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user who    |              |       |          |
|    |               | inserted or |              |       |          |
|    |               | modified    |              |       |          |
|    |               | this        |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| PU |               |             |              |       |          |
| BL |               |             |              |       |          |
| IC |               |             |              |       |          |
| NO |               |             |              |       |          |
| TI |               |             |              |       |          |
| CE |               |             |              |       |          |
| CR |               |             |              |       |          |
| IT |               |             |              |       |          |
| ER |               |             |              |       |          |
| IA |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              | Publi | PWS ID   |
|    |               | identifies  |              | cNoti |          |
|    |               | the public  |              | ceCri |          |
|    |               | Water       |              | teria |          |
|    |               | System to   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Violation   |              |       |          |
|    |               | is          |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VIOID         | An          |              | Publi | V        |
|    |               | a           |              | cNoti | IOLATION |
|    |               | lphanumeric |              | ceCri | ID       |
|    |               | value used  |              | teria |          |
|    |               | to uniquely |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | specific    |              |       |          |
|    |               | violation   |              |       |          |
|    |               | of a        |              |       |          |
|    |               | primary     |              |       |          |
|    |               | drinking    |              |       |          |
|    |               | water       |              |       |          |
|    |               | regulation  |              |       |          |
|    |               | incurred by |              |       |          |
|    |               | a public    |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PNCIDENTIFIER | A system    |              |       |          |
|    |               | generated   |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | each Public |              |       |          |
|    |               | Notice      |              |       |          |
|    |               | Criteria    |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RELATEDVIOLID | For a       |              | Publi | PUBLIC   |
|    |               | public      |              | cNoti | NOTICE   |
|    |               | notice      |              | ceCri | UN       |
|    |               | violation,  |              | teria | DERLYING |
|    |               | this field  |              |       | V        |
|    |               | contains    |              |       | IOLATION |
|    |               | the         |              |       | ID       |
|    |               | violation   |              |       |          |
|    |               | ID of the   |              |       |          |
|    |               | underlying  |              |       |          |
|    |               | violation.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERID        | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user who    |              |       |          |
|    |               | inserted or |              |       |          |
|    |               | modified    |              |       |          |
|    |               | this        |              |       |          |
|    |               | record.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *W |               |             |              |       |          |
| AT |               |             |              |       |          |
| ER |               |             |              |       |          |
| SY |               |             |              |       |          |
| ST |               |             |              |       |          |
| EM |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gW |               |             |              |       |          |
| AT |               |             |              |       |          |
| ER |               |             |              |       |          |
| SY |               |             |              |       |          |
| ST |               |             |              |       |          |
| EM |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This        |              | Water | PWS ID   |
|    |               | qualifier   |              | S     |          |
|    |               | is used to  |              | ystem |          |
|    |               | uniquely    |              |       |          |
|    |               | identify a  |              |       |          |
|    |               | Public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System. PWS |              |       |          |
|    |               | ID is       |              |       |          |
|    |               | always      |              |       |          |
|    |               | prefixed    |              |       |          |
|    |               | with a      |              |       |          |
|    |               | valid       |              |       |          |
|    |               | United      |              |       |          |
|    |               | States      |              |       |          |
|    |               | Postal      |              |       |          |
|    |               | Service     |              |       |          |
|    |               | (USPS)      |              |       |          |
|    |               | State       |              |       |          |
|    |               | a           |              |       |          |
|    |               | bbreviation |              |       |          |
|    |               | or EPA      |              |       |          |
|    |               | Region code |              |       |          |
|    |               | (excluding  |              |       |          |
|    |               | Region 03), |              |       |          |
|    |               | which is    |              |       |          |
|    |               | then        |              |       |          |
|    |               | followed by |              |       |          |
|    |               | a           |              |       |          |
|    |               | 7-character |              |       |          |
|    |               | identifier  |              |       |          |
|    |               | unique for  |              |       |          |
|    |               | each Water  |              |       |          |
|    |               | System      |              |       |          |
|    |               | within that |              |       |          |
|    |               | State or    |              |       |          |
|    |               | Region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSTYPECODE   | A code      |              | Water | PWS TYPE |
|    |               | value which |              | S     |          |
|    |               | classifies  |              | ystem |          |
|    |               | the type of |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System      |              |       |          |
|    |               | according   |              |       |          |
|    |               | to federal  |              |       |          |
|    |               | and state   |              |       |          |
|    |               | re          |              |       |          |
|    |               | quirements. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSNAME       | The name of |              | Water | PWS NAME |
|    |               | the Water   |              | S     |          |
|    |               | System. The |              | ystem |          |
|    |               | name can be |              |       |          |
|    |               | the formal, |              |       |          |
|    |               | legal, or   |              |       |          |
|    |               | common name |              |       |          |
|    |               | that is     |              |       |          |
|    |               | used most   |              |       |          |
|    |               | generally   |              |       |          |
|    |               | in          |              |       |          |
|    |               | referring   |              |       |          |
|    |               | to the      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
|    |               | When        |              |       |          |
|    |               | multiple    |              |       |          |
|    |               | facilities  |              |       |          |
|    |               | exist for   |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System at   |              |       |          |
|    |               | different   |              |       |          |
|    |               | physical    |              |       |          |
|    |               | locations,  |              |       |          |
|    |               | the name    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the means   |              |       |          |
|    |               | by which    |              |       |          |
|    |               | the system, |              |       |          |
|    |               | as a whole, |              |       |          |
|    |               | is          |              |       |          |
|    |               | generally   |              |       |          |
|    |               | known.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PW            | A code      |              | Water | ACTIVITY |
|    | SACTIVITYCODE | value that  |              | S     | FLAG     |
|    |               | categorizes |              | ystem |          |
|    |               | the         |              |       |          |
|    |               | activity of |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System and  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSDEA        | The month,  |              | Water | DEAC     |
|    | CTIVATIONDATE | day and     |              | S     | TIVATION |
|    |               | year that   |              | ystem | DATE     |
|    |               | the Water   |              |       |          |
|    |               | System or   |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility    |              |       |          |
|    |               | activity    |              |       |          |
|    |               | indicator   |              |       |          |
|    |               | code was    |              |       |          |
|    |               | last        |              |       |          |
|    |               | changed.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWS           | Indicates   |              | Water | W        |
|    | WHOLESALERIND | whether the |              | S     | HOLESALE |
|    |               | Water       |              | ystem | ROFWATER |
|    |               | System is a |              |       |          |
|    |               | wholesaler  |              |       |          |
|    |               | of water.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | P             | A value     |              | Water | RETAIL   |
|    | WSRETPOPSERVD | that        |              | S     | PO       |
|    |               | indicates   |              | ystem | PULATION |
|    |               | the         |              |       | SERVED   |
|    |               | estimated   |              |       |          |
|    |               | average     |              |       |          |
|    |               | daily       |              |       |          |
|    |               | population  |              |       |          |
|    |               | count for a |              |       |          |
|    |               | given type  |              |       |          |
|    |               | of          |              |       |          |
|    |               | population  |              |       |          |
|    |               | served by a |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSSVCCONN    | A value     |              | Water | RETAIL   |
|    |               | that        |              | S     | SERVICE  |
|    |               | indicates   |              | ystem | CON      |
|    |               | the number  |              |       | NECTIONS |
|    |               | of service  |              |       |          |
|    |               | connections |              |       |          |
|    |               | for a Water |              |       |          |
|    |               | System for  |              |       |          |
|    |               | a           |              |       |          |
|    |               | particular  |              |       |          |
|    |               | type of     |              |       |          |
|    |               | service     |              |       |          |
|    |               | connection. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SEAS          | The         |              | Water | NON-C    |
|    | ONBEGINMONDAY | calendar    |              | S     | OMMUNITY |
|    |               | day and     |              | ystem | SEASON   |
|    |               | calendar    |              |       | BEGIN    |
|    |               | month in    |              |       | (MONTH   |
|    |               | which the   |              |       | AND DAY) |
|    |               | Water       |              |       |          |
|    |               | System\'s   |              |       |          |
|    |               | season of   |              |       |          |
|    |               | operation   |              |       |          |
|    |               | commences.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SE            | The         |              | Water | NON-C    |
|    | ASONENDMONDAY | calendar    |              | S     | OMMUNITY |
|    |               | day and     |              | ystem | SEASON   |
|    |               | calendar    |              |       | END      |
|    |               | month in    |              |       | (MONTH   |
|    |               | which the   |              |       | AND DAY) |
|    |               | Water       |              |       |          |
|    |               | System\'s   |              |       |          |
|    |               | season of   |              |       |          |
|    |               | operation   |              |       |          |
|    |               | ends.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSOWNERCODE  | A code      |              | Water | OWNER    |
|    |               | value that  |              | S     | TYPE     |
|    |               | identifies  |              | ystem |          |
|    |               | the type of |              |       |          |
|    |               | owner for a |              |       |          |
|    |               | public      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SUBMISS       | A code      | If the value |       |          |
|    | IONSTATUSCODE | indicating  | in this      |       |          |
|    |               | the whether | column is    |       |          |
|    |               | an active   | "Y," the     |       |          |
|    |               | Water       | active Water |       |          |
|    |               | System was  | System was   |       |          |
|    |               | reported,   | reported and |       |          |
|    |               | rejected,   | accepted     |       |          |
|    |               | or not      | during the   |       |          |
|    |               | reported    | last         |       |          |
|    |               | during the  | inventory    |       |          |
|    |               | recent      | submission.  |       |          |
|    |               | inventory   | If the value |       |          |
|    |               | submission. | is "R," the  |       |          |
|    |               |             | Water System |       |          |
|    |               | This field  | was reported |       |          |
|    |               | is not      | but rejected |       |          |
|    |               | applicable  | during the   |       |          |
|    |               | to inactive | last         |       |          |
|    |               | Water       | inventory    |       |          |
|    |               | Systems.    | submission.  |       |          |
|    |               |             | If the value |       |          |
|    |               |             | is "U," the  |       |          |
|    |               |             | Water System |       |          |
|    |               |             | was not      |       |          |
|    |               |             | reported in  |       |          |
|    |               |             | the last     |       |          |
|    |               |             | submission.  |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *W |               |             |              |       |          |
| AT |               |             |              |       |          |
| ER |               |             |              |       |          |
| SY |               |             |              |       |          |
| ST |               |             |              |       |          |
| EM |               |             |              |       |          |
| FA |               |             |              |       |          |
| CI |               |             |              |       |          |
| LI |               |             |              |       |          |
| TY |               |             |              |       |          |
| ** |               |             |              |       |          |
|    |               |             |              |       |          |
| ** |               |             |              |       |          |
| st |               |             |              |       |          |
| gW |               |             |              |       |          |
| AT |               |             |              |       |          |
| ER |               |             |              |       |          |
| SY |               |             |              |       |          |
| ST |               |             |              |       |          |
| EM |               |             |              |       |          |
| FA |               |             |              |       |          |
| CI |               |             |              |       |          |
| LI |               |             |              |       |          |
| TY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This        |              | Water | PWS ID   |
|    |               | qualifier   |              | S     |          |
|    |               | is used to  |              | ystem |          |
|    |               | uniquely    |              | Fac   |          |
|    |               | identify a  |              | ility |          |
|    |               | Public      |              | Other |          |
|    |               | Water       |              |       |          |
|    |               | System. PWS |              |       |          |
|    |               | ID is       |              |       |          |
|    |               | always      |              |       |          |
|    |               | prefixed    |              |       |          |
|    |               | with a      |              |       |          |
|    |               | valid       |              |       |          |
|    |               | United      |              |       |          |
|    |               | States      |              |       |          |
|    |               | Postal      |              |       |          |
|    |               | Service     |              |       |          |
|    |               | (USPS)      |              |       |          |
|    |               | State       |              |       |          |
|    |               | a           |              |       |          |
|    |               | bbreviation |              |       |          |
|    |               | or EPA      |              |       |          |
|    |               | Region code |              |       |          |
|    |               | (excluding  |              |       |          |
|    |               | Region 03), |              |       |          |
|    |               | which is    |              |       |          |
|    |               | then        |              |       |          |
|    |               | followed by |              |       |          |
|    |               | a           |              |       |          |
|    |               | 7-character |              |       |          |
|    |               | identifier  |              |       |          |
|    |               | unique for  |              |       |          |
|    |               | each Water  |              |       |          |
|    |               | System      |              |       |          |
|    |               | within that |              |       |          |
|    |               | State or    |              |       |          |
|    |               | Region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACID         | A           |              | Water | FACILITY |
|    |               | sta         |              | S     | ID       |
|    |               | te-assigned |              | ystem |          |
|    |               | value which |              | Fac   |          |
|    |               | identifies  |              | ility |          |
|    |               | the Water   |              | Other |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FA            | A code      |              | Water | ACTIVITY |
|    | CACTIVITYCODE | value that  |              | S     | FLAG     |
|    |               | categorizes |              | ystem |          |
|    |               | the         |              | Fac   |          |
|    |               | activity of |              | ility |          |
|    |               | the Water   |              | Other |          |
|    |               | System and  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System      |              |       |          |
|    |               | Facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACDEA        | The month,  |              | Water | DEAC     |
|    | CTIVATIONDATE | day and     |              | S     | TIVATION |
|    |               | year that   |              | ystem | DATE     |
|    |               | the Water   |              | Fac   |          |
|    |               | System or   |              | ility |          |
|    |               | Water       |              | Other |          |
|    |               | System      |              |       |          |
|    |               | Facility    |              |       |          |
|    |               | activity    |              |       |          |
|    |               | indicator   |              |       |          |
|    |               | code was    |              |       |          |
|    |               | last        |              |       |          |
|    |               | changed.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACNAME       | The name of |              | Water | FACILITY |
|    |               | the Water   |              | S     | NAME     |
|    |               | System      |              | ystem |          |
|    |               | Facility.   |              | Fac   |          |
|    |               |             |              | ility |          |
|    |               |             |              | Other |          |
+----+---------------+-------------+--------------+-------+----------+
|    | F             | The ID that |              | Water | STATE    |
|    | ACSTATEASGNID | a state     |              | S     | DATABASE |
|    |               | uses to     |              | ystem | FACILITY |
|    |               | identify a  |              | Fac   | ID       |
|    |               | facility in |              | ility |          |
|    |               | their own   |              | Other |          |
|    |               | state       |              |       |          |
|    |               | system      |              |       |          |
|    |               | database.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACTYPECODE   | A code      |              | Water | FACILITY |
|    |               | value which |              | S     | TYPE     |
|    |               | categorizes |              | ystem | CODE     |
|    |               | the water   |              | Fac   |          |
|    |               | facility.   |              | ility |          |
|    |               | The code    |              | Other |          |
|    |               | specifies   |              |       |          |
|    |               | the type of |              |       |          |
|    |               | source,     |              |       |          |
|    |               | plant, or   |              |       |          |
|    |               | entry point |              |       |          |
|    |               | facility    |              |       |          |
|    |               | (e.g., WL   |              |       |          |
|    |               | is a well   |              |       |          |
|    |               | which is a  |              |       |          |
|    |               | type of     |              |       |          |
|    |               | source).    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FACWATERTYPE  | A code      |              | Water | FACILITY |
|    |               | value that  |              | S     | WATER    |
|    |               | categorizes |              | ystem | TYPE     |
|    |               | the source  |              | Fac   | CODE     |
|    |               | water used  |              | ility |          |
|    |               | or the      |              | S     |          |
|    |               | water       |              | ource |          |
|    |               | purchased   |              |       |          |
|    |               | by the      |              |       |          |
|    |               | facility.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FA            | A code      |              | Water | AVAI     |
|    | CAVAILABILITY | value that  |              | S     | LABILITY |
|    |               | categorizes |              | ystem |          |
|    |               | the         |              | Fac   |          |
|    |               | ci          |              | ility |          |
|    |               | rcumstances |              | S     |          |
|    |               | under which |              | ource |          |
|    |               | a source of |              |       |          |
|    |               | water is    |              |       |          |
|    |               | utilized by |              |       |          |
|    |               | a Water     |              |       |          |
|    |               | System.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SELLERPWSID   | An          |              | Water | SELLER   |
|    |               | a           |              | S     | PWS ID   |
|    |               | lphanumeric |              | ystem |          |
|    |               | value that  |              | Fac   |          |
|    |               | represents  |              | ility |          |
|    |               | the ID# of  |              | S     |          |
|    |               | a Water     |              | ource |          |
|    |               | System from |              |       |          |
|    |               | whom raw or |              |       |          |
|    |               | treated     |              |       |          |
|    |               | water is    |              |       |          |
|    |               | purchased.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SELLERTRTCODE | This        |              | Water | SELLER   |
|    |               | indicator   |              | S     | SOURCE   |
|    |               | is          |              | ystem | T        |
|    |               | applicable  |              | Fac   | REATMENT |
|    |               | to          |              | ility | CODE     |
|    |               | purchased   |              | S     |          |
|    |               | sources     |              | ource |          |
|    |               | only and    |              |       |          |
|    |               | indicates   |              |       |          |
|    |               | whether the |              |       |          |
|    |               | seller is   |              |       |          |
|    |               | or is not   |              |       |          |
|    |               | treating    |              |       |          |
|    |               | the source  |              |       |          |
|    |               | or whether  |              |       |          |
|    |               | the seller  |              |       |          |
|    |               | treatment   |              |       |          |
|    |               | status is   |              |       |          |
|    |               | unknown.    |              |       |          |
|    |               | Applies     |              |       |          |
|    |               | only to     |              |       |          |
|    |               | source      |              |       |          |
|    |               | facilities. |              |       |          |
|    |               | Y = Treated |              |       |          |
|    |               | N = Not     |              |       |          |
|    |               | Treated     |              |       |          |
|    |               | F=Filtered. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SOURCETRTIND  | An          |              | Water | SOURCE   |
|    |               | indicator   |              | S     | TREATED  |
|    |               | associated  |              | ystem | CODE     |
|    |               | with a      |              | Fac   |          |
|    |               | Water       |              | ility |          |
|    |               | System      |              | S     |          |
|    |               | source      |              | ource |          |
|    |               | facility    |              |       |          |
|    |               | used to     |              |       |          |
|    |               | specify     |              |       |          |
|    |               | that a      |              |       |          |
|    |               | source is   |              |       |          |
|    |               | not being   |              |       |          |
|    |               | treated.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RPTDFIL       | A code      |              | Water | REPORTED |
|    | TRATIONSTATUS | reported by |              | S     | FI       |
|    |               | the state   |              | ystem | LTRATION |
|    |               | to indicate |              | Fac   | STATUS   |
|    |               | whether a   |              | ility | CODE     |
|    |               | no          |              | S     |          |
|    |               | n-emergency |              | ource |          |
|    |               | surface     |              |       |          |
|    |               | water       |              |       |          |
|    |               | source or a |              |       |          |
|    |               | no          |              |       |          |
|    |               | n-emergency |              |       |          |
|    |               | ground      |              |       |          |
|    |               | water under |              |       |          |
|    |               | the         |              |       |          |
|    |               | influence   |              |       |          |
|    |               | of surface  |              |       |          |
|    |               | water       |              |       |          |
|    |               | source is   |              |       |          |
|    |               | required to |              |       |          |
|    |               | install     |              |       |          |
|    |               | filtration  |              |       |          |
|    |               | by a        |              |       |          |
|    |               | certain     |              |       |          |
|    |               | date or is  |              |       |          |
|    |               | s           |              |       |          |
|    |               | uccessfully |              |       |          |
|    |               | avoiding    |              |       |          |
|    |               | filtration. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SUBMISS       | A code      | If the value |       |          |
|    | IONSTATUSCODE | indicating  | in this      |       |          |
|    |               | the whether | column is    |       |          |
|    |               | an active   | "Y," the     |       |          |
|    |               | Water       | active Water |       |          |
|    |               | System      | System       |       |          |
|    |               | Facility    | Facility was |       |          |
|    |               | was         | reported and |       |          |
|    |               | reported,   | accepted     |       |          |
|    |               | rejected,   | during the   |       |          |
|    |               | or not      | last         |       |          |
|    |               | reported    | inventory    |       |          |
|    |               | during the  | submission.  |       |          |
|    |               | recent      | If the value |       |          |
|    |               | inventory   | is "R," the  |       |          |
|    |               | submission. | Water System |       |          |
|    |               |             | Facility was |       |          |
|    |               | This field  | reported but |       |          |
|    |               | is not      | rejected     |       |          |
|    |               | applicable  | during the   |       |          |
|    |               | to inactive | last         |       |          |
|    |               | Water       | inventory    |       |          |
|    |               | System      | submission.  |       |          |
|    |               | Facilities. | If the value |       |          |
|    |               |             | is "U," the  |       |          |
|    |               |             | facility was |       |          |
|    |               |             | not reported |       |          |
|    |               |             | in the last  |       |          |
|    |               |             | submission.  |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| RE |               |             |              |       |          |
| QU |               |             |              |       |          |
| ES |               |             |              |       |          |
| TL |               |             |              |       |          |
| OG |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS   |              |       |          |
|    |               | and every   |              |       |          |
|    |               | QA Data     |              |       |          |
|    |               | Extraction  |              |       |          |
|    |               | request     |              |       |          |
|    |               | processed   |              |       |          |
|    |               | by          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ORIGINNAME    | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | tw          |              |       |          |
|    |               | o-character |              |       |          |
|    |               | USPS code   |              |       |          |
|    |               | of the      |              |       |          |
|    |               | State or    |              |       |          |
|    |               | Region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CDXTRANID     | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | transaction |              |       |          |
|    |               | ID that CDX |              |       |          |
|    |               | assigned to |              |       |          |
|    |               | the         |              |       |          |
|    |               | request.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBFOLDER     | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | the         |              |       |          |
|    |               | directory   |              |       |          |
|    |               | on the      |              |       |          |
|    |               | application |              |       |          |
|    |               | server that |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the files   |              |       |          |
|    |               | generated   |              |       |          |
|    |               | while       |              |       |          |
|    |               | processing  |              |       |          |
|    |               | a job.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | WATE          | This column |              |       |          |
|    | RSYSTEMDOMAIN | contains    |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | System type |              |       |          |
|    |               | code over   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency has  |              |       |          |
|    |               | enforcement |              |       |          |
|    |               | resp        |              |       |          |
|    |               | onsibility. |              |       |          |
|    |               | Data value  |              |       |          |
|    |               | for this    |              |       |          |
|    |               | column is   |              |       |          |
|    |               | taken from  |              |       |          |
|    |               | the Message |              |       |          |
|    |               | Summary of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EXTRAC        | This column |              |       |          |
|    | TIONBEGINDATE | contains    |              |       |          |
|    |               | the begin   |              |       |          |
|    |               | date of the |              |       |          |
|    |               | domain      |              |       |          |
|    |               | period.     |              |       |          |
|    |               | Data value  |              |       |          |
|    |               | for this    |              |       |          |
|    |               | column is   |              |       |          |
|    |               | taken from  |              |       |          |
|    |               | the Message |              |       |          |
|    |               | Summary of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EXTR          | This column |              |       |          |
|    | ACTIONENDDATE | contains    |              |       |          |
|    |               | the end     |              |       |          |
|    |               | date of the |              |       |          |
|    |               | domain      |              |       |          |
|    |               | period.     |              |       |          |
|    |               | Data value  |              |       |          |
|    |               | for this    |              |       |          |
|    |               | column      |              |       |          |
|    |               | comes from  |              |       |          |
|    |               | the Message |              |       |          |
|    |               | Summary of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NOTIF         | This column |              |       |          |
|    | ICATIONEMAILS | contains a  |              |       |          |
|    |               | list of the |              |       |          |
|    |               | e-mail      |              |       |          |
|    |               | addresses   |              |       |          |
|    |               | that were   |              |       |          |
|    |               | present in  |              |       |          |
|    |               | the message |              |       |          |
|    |               | summary     |              |       |          |
|    |               | section of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | file.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CD            | This column |              |       |          |
|    | XDOCUMENTNAME | contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | file that   |              |       |          |
|    |               | SDWIS/ODS   |              |       |          |
|    |               | received    |              |       |          |
|    |               | from CDX.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CD            | This column |              |       |          |
|    | XDOCUMENTTYPE | contains    |              |       |          |
|    |               | the type of |              |       |          |
|    |               | the file    |              |       |          |
|    |               | that        |              |       |          |
|    |               | SDWIS/ODS   |              |       |          |
|    |               | received    |              |       |          |
|    |               | from CDX.   |              |       |          |
|    |               | Since       |              |       |          |
|    |               | SDWIS/ODS   |              |       |          |
|    |               | receives    |              |       |          |
|    |               | only zipped |              |       |          |
|    |               | files from  |              |       |          |
|    |               | CDX, this   |              |       |          |
|    |               | column      |              |       |          |
|    |               | always      |              |       |          |
|    |               | contains    |              |       |          |
|    |               | 'ZIP' for   |              |       |          |
|    |               | XML         |              |       |          |
|    |               | processing  |              |       |          |
|    |               | requests.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBTYPECODE   | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the text    |              |       |          |
|    |               | "Valid" or  |              |       |          |
|    |               | "Invalid"   |              |       |          |
|    |               | indicating  |              |       |          |
|    |               | whether an  |              |       |          |
|    |               | XML request |              |       |          |
|    |               | was         |              |       |          |
|    |               | processed   |              |       |          |
|    |               | without any |              |       |          |
|    |               | error, or   |              |       |          |
|    |               | an error    |              |       |          |
|    |               | was         |              |       |          |
|    |               | detected    |              |       |          |
|    |               | while       |              |       |          |
|    |               | processing  |              |       |          |
|    |               | an XML      |              |       |          |
|    |               | request.    |              |       |          |
|    |               | For a QA    |              |       |          |
|    |               | Extract     |              |       |          |
|    |               | job, this   |              |       |          |
|    |               | column will |              |       |          |
|    |               | contain a   |              |       |          |
|    |               | value of    |              |       |          |
|    |               | 'Valid',    |              |       |          |
|    |               | 'Invalid',  |              |       |          |
|    |               | or          |              |       |          |
|    |               | 'Pending'   |              |       |          |
|    |               | indicating  |              |       |          |
|    |               | whether the |              |       |          |
|    |               | request was |              |       |          |
|    |               | processed   |              |       |          |
|    |               | without any |              |       |          |
|    |               | error, or   |              |       |          |
|    |               | an error    |              |       |          |
|    |               | was         |              |       |          |
|    |               | detected    |              |       |          |
|    |               | during the  |              |       |          |
|    |               | data        |              |       |          |
|    |               | extraction, |              |       |          |
|    |               | or the job  |              |       |          |
|    |               | is waiting  |              |       |          |
|    |               | to be       |              |       |          |
|    |               | activated   |              |       |          |
|    |               | by the      |              |       |          |
|    |               | production  |              |       |          |
|    |               | control.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATUSMESSAGE | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | detailed    |              |       |          |
|    |               | text        |              |       |          |
|    |               | message     |              |       |          |
|    |               | describing  |              |       |          |
|    |               | why a job   |              |       |          |
|    |               | failed or   |              |       |          |
|    |               | was         |              |       |          |
|    |               | cancelled.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SUBJECTAREA   | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the subject |              |       |          |
|    |               | area for    |              |       |          |
|    |               | the         |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | XML         |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ORIGINCODE    | This column |              |       |          |
|    |               | contains a  |              |       |          |
|    |               | code that   |              |       |          |
|    |               | indicates   |              |       |          |
|    |               | the         |              |       |          |
|    |               | ownership   |              |       |          |
|    |               | of the data |              |       |          |
|    |               | in the XML  |              |       |          |
|    |               | file.       |              |       |          |
|    |               | Possible    |              |       |          |
|    |               | values in   |              |       |          |
|    |               | this column |              |       |          |
|    |               | are 'S'     |              |       |          |
|    |               | (State's    |              |       |          |
|    |               | data), 'R'  |              |       |          |
|    |               | (Region's   |              |       |          |
|    |               | data), or   |              |       |          |
|    |               | 'H'         |              |       |          |
|    |               | (He         |              |       |          |
|    |               | adquarters' |              |       |          |
|    |               | data). Data |              |       |          |
|    |               | value for   |              |       |          |
|    |               | this column |              |       |          |
|    |               | comes from  |              |       |          |
|    |               | the Message |              |       |          |
|    |               | Summary of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | S             | This column |              |       |          |
|    | UBMISSIONDATE | contains    |              |       |          |
|    |               | the date on |              |       |          |
|    |               | which       |              |       |          |
|    |               | SDWIS/ODS   |              |       |          |
|    |               | received an |              |       |          |
|    |               | XML file.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATECODE     | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | tw          |              |       |          |
|    |               | o-character |              |       |          |
|    |               | state or    |              |       |          |
|    |               | region code |              |       |          |
|    |               | of the      |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency that |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | document.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FE            | This column |              |       |          |
|    | DREPSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/FedRep |              |       |          |
|    |               | validation  |              |       |          |
|    |               | step        |              |       |          |
|    |               | initiated.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FEDREPENDTIME | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/FedRep |              |       |          |
|    |               | validation  |              |       |          |
|    |               | step        |              |       |          |
|    |               | completed.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SUBM          | This column |              |       |          |
|    | ISSIONPREPARA | contains    |              |       |          |
|    | TIONSTARTTIME | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | submission  |              |       |          |
|    |               | preparation |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SU            | This column |              |       |          |
|    | BMISSIONPREPA | contains    |              |       |          |
|    | RATIONENDTIME | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | submission  |              |       |          |
|    |               | preparation |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EXTRA         | This column |              |       |          |
|    | CTORSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | extraction  |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EXT           | This column |              |       |          |
|    | RACTORENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | extraction  |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VALIDA        | This column |              |       |          |
|    | TIONSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | for         |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | validation  |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VALI          | This column |              |       |          |
|    | DATIONENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | for         |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | validation  |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | M             | This column |              |       |          |
|    | ERGESTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Post  |              |       |          |
|    |               | to          |              |       |          |
|    |               | Operational |              |       |          |
|    |               | Database    |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | MERGEENDTIME  | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Post  |              |       |          |
|    |               | to          |              |       |          |
|    |               | Operational |              |       |          |
|    |               | Database    |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAQUALIT    | This column |              |       |          |
|    | YCHKSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | Data        |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAQUAL      | This column |              |       |          |
|    | ITYCHKENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | Data        |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATUSLOG     | This column |              |       |          |
|    | GINGSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCap,       |              |       |          |
|    |               | Generate    |              |       |          |
|    |               | Error       |              |       |          |
|    |               | Content     |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATUSL       | This column |              |       |          |
|    | OGGINGENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | sta         |              |       |          |
|    |               | tus-logging |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NOTIFICA      | This column |              |       |          |
|    | TIONSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | N           |              |       |          |
|    |               | otification |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NOTIFI        | This column |              |       |          |
|    | CATIONENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | N           |              |       |          |
|    |               | otification |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CLE           | This column |              |       |          |
|    | ANUPSTARTTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCap,       |              |       |          |
|    |               | Cleanup     |              |       |          |
|    |               | Staging     |              |       |          |
|    |               | Database    |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | C             | This column |              |       |          |
|    | LEANUPENDTIME | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Cleanup     |              |       |          |
|    |               | Staging     |              |       |          |
|    |               | Database    |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EDITMODE      | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the date    |              |       |          |
|    |               | and time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | Cleanup     |              |       |          |
|    |               | Staging     |              |       |          |
|    |               | Database    |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBTYPE       | This column |              |       |          |
|    |               | indicates   |              |       |          |
|    |               | whether the |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | record is   |              |       |          |
|    |               | for an XML  |              |       |          |
|    |               | file        |              |       |          |
|    |               | processing  |              |       |          |
|    |               | or a QA     |              |       |          |
|    |               | Data        |              |       |          |
|    |               | Extraction  |              |       |          |
|    |               | processing. |              |       |          |
|    |               | Two         |              |       |          |
|    |               | permitted   |              |       |          |
|    |               | values for  |              |       |          |
|    |               | this column |              |       |          |
|    |               | are:        |              |       |          |
|    |               |             |              |       |          |
|    |               | XML_D       |              |       |          |
|    |               | ATAFLOW_IN, |              |       |          |
|    |               | and         |              |       |          |
|    |               |             |              |       |          |
|    |               | ODSDATA     |              |       |          |
|    |               | EXTRACTION. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAEXT       | This column |              |       |          |
|    | RACTSTARTTIME | contains    |              |       |          |
|    |               | the time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | QA Data     |              |       |          |
|    |               | Extraction  |              |       |          |
|    |               | step        |              |       |          |
|    |               | started.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAE         | This column |              |       |          |
|    | XTRACTENDTIME | contains    |              |       |          |
|    |               | the time at |              |       |          |
|    |               | which the   |              |       |          |
|    |               | QA Data     |              |       |          |
|    |               | Extraction  |              |       |          |
|    |               | step ended. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAEXTR      | This column |              |       |          |
|    | ACTPARAMETERS | contains    |              |       |          |
|    |               | the primacy |              |       |          |
|    |               | agency      |              |       |          |
|    |               | codes for   |              |       |          |
|    |               | which the   |              |       |          |
|    |               | data was    |              |       |          |
|    |               | extracted   |              |       |          |
|    |               | during a    |              |       |          |
|    |               | given QA    |              |       |          |
|    |               | Data        |              |       |          |
|    |               | Extraction. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REGULATEDSAM  | An          |              |       |          |
|    | PLESINDICATOR | indicator   |              |       |          |
|    |               | associated  |              |       |          |
|    |               | with a      |              |       |          |
|    |               | regulated   |              |       |          |
|    |               | sample.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | U             | An          |              |       |          |
|    | NREGULATEDSAM | indicator   |              |       |          |
|    | PLESINDICATOR | associated  |              |       |          |
|    |               | with an     |              |       |          |
|    |               | unregulated |              |       |          |
|    |               | sample.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DAT           | This column |              |       |          |
|    | AEXTRACTIONDO | contains    |              |       |          |
|    | MAINSTARTDATE | the start   |              |       |          |
|    |               | date of the |              |       |          |
|    |               | domain      |              |       |          |
|    |               | period.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | FEDREPVERSION | The version |              |       |          |
|    |               | of FedRep   |              |       |          |
|    |               | that the    |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency used |              |       |          |
|    |               | to validate |              |       |          |
|    |               | the file.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | XML           | The version |              |       |          |
|    | SCHEMAVERSION | of the XML  |              |       |          |
|    |               | Schema that |              |       |          |
|    |               | FedRep uses |              |       |          |
|    |               | to validate |              |       |          |
|    |               | the file.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REPORTDELI    | The time at |              |       |          |
|    | VERYSTARTTIME | which the   |              |       |          |
|    |               | report had  |              |       |          |
|    |               | been        |              |       |          |
|    |               | started for |              |       |          |
|    |               | delivery to |              |       |          |
|    |               | the CDX.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REPORTDE      | The time at |              |       |          |
|    | LIVERYENDTIME | which the   |              |       |          |
|    |               | report has  |              |       |          |
|    |               | been        |              |       |          |
|    |               | delivered   |              |       |          |
|    |               | to the CDX. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CL            | This column |              |       |          |
|    | IENTCDXTRANID | contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | transaction |              |       |          |
|    |               | ID that CDX |              |       |          |
|    |               | gives to    |              |       |          |
|    |               | the client. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ISN           | The flag    |              |       |          |
|    | ODESUBMISSION | which       |              |       |          |
|    |               | defines     |              |       |          |
|    |               | whether the |              |       |          |
|    |               | submission  |              |       |          |
|    |               | of the file |              |       |          |
|    |               | through the |              |       |          |
|    |               | State Node  |              |       |          |
|    |               | or the Web  |              |       |          |
|    |               | site.       |              |       |          |
|    |               |             |              |       |          |
|    |               | If it is    |              |       |          |
|    |               | "Y," then   |              |       |          |
|    |               | file is     |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | through the |              |       |          |
|    |               | State Node. |              |       |          |
|    |               |             |              |       |          |
|    |               | If it is    |              |       |          |
|    |               | "N," then   |              |       |          |
|    |               | the file is |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | through the |              |       |          |
|    |               | Web Site.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | S             | The email   |              |       |          |
|    | UBMITTEREMAIL | of the      |              |       |          |
|    |               | submitter.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DA            | The start   |              |       |          |
|    | TAEXTNRPTDELI | time of the |              |       |          |
|    | VERYSTARTTIME | data        |              |       |          |
|    |               | extraction  |              |       |          |
|    |               | process.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATAEXTNRPTDE | The end     |              |       |          |
|    | LIVERYENDTIME | time of the |              |       |          |
|    |               | data        |              |       |          |
|    |               | extraction  |              |       |          |
|    |               | process.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | APPROVERID    | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user who    |              |       |          |
|    |               | approved    |              |       |          |
|    |               | the job     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | APPROVEDDATE  | Date and    |              |       |          |
|    |               | time at     |              |       |          |
|    |               | which a     |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user        |              |       |          |
|    |               | approved    |              |       |          |
|    |               | the job.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | AP            | Optional    |              |       |          |
|    | PROVALMESSAGE | message or  |              |       |          |
|    |               | comment     |              |       |          |
|    |               | that the    |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user        |              |       |          |
|    |               | entered     |              |       |          |
|    |               | while       |              |       |          |
|    |               | approving   |              |       |          |
|    |               | or          |              |       |          |
|    |               | rejecting   |              |       |          |
|    |               | the job.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | A             | Indicate    |              |       |          |
|    | PPROVALSTATUS | whether the |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user        |              |       |          |
|    |               | approved or |              |       |          |
|    |               | rejected    |              |       |          |
|    |               | the job.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATESUBMISS  | The job     |              |       |          |
|    | IONPREPNUMBER | number      |              |       |          |
|    |               | associated  |              |       |          |
|    |               | with the    |              |       |          |
|    |               | submission  |              |       |          |
|    |               | preparation |              |       |          |
|    |               | that        |              |       |          |
|    |               | happened at |              |       |          |
|    |               | the primacy |              |       |          |
|    |               | agency.     |              |       |          |
|    |               | This        |              |       |          |
|    |               | information |              |       |          |
|    |               | is taken    |              |       |          |
|    |               | from the    |              |       |          |
|    |               | message     |              |       |          |
|    |               | summary of  |              |       |          |
|    |               | the XML     |              |       |          |
|    |               | file        |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATESUBMISSI | Contains    |              |       |          |
|    | ONPREPCOMMENT | the comment |              |       |          |
|    |               | that the    |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/FedRep |              |       |          |
|    |               | user        |              |       |          |
|    |               | entered     |              |       |          |
|    |               | into the    |              |       |          |
|    |               | comment     |              |       |          |
|    |               | filed of    |              |       |          |
|    |               | SDW         |              |       |          |
|    |               | IS/FedRep's |              |       |          |
|    |               | submission  |              |       |          |
|    |               | preparation |              |       |          |
|    |               | page while  |              |       |          |
|    |               | preparing   |              |       |          |
|    |               | the file    |              |       |          |
|    |               | for         |              |       |          |
|    |               | submission  |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *D |               |             |              |       |          |
| AT |               |             |              |       |          |
| AQ |               |             |              |       |          |
| UA |               |             |              |       |          |
| LI |               |             |              |       |          |
| TY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DQSEQ         | DQSEQ is a  |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | records in  |              |       |          |
|    |               | the data    |              |       |          |
|    |               | quality     |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the PWSID   |              |       |          |
|    |               | of the      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System for  |              |       |          |
|    |               | which the   |              |       |          |
|    |               | data        |              |       |          |
|    |               | quality     |              |       |          |
|    |               | error was   |              |       |          |
|    |               | detected.   |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | WaterSystem |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SECONDARYID1  | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the ID of   |              |       |          |
|    |               | the record  |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the data    |              |       |          |
|    |               | quality     |              |       |          |
|    |               | error was   |              |       |          |
|    |               | detected.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SECONDARYID2  | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the ID of   |              |       |          |
|    |               | the record  |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the data    |              |       |          |
|    |               | quality     |              |       |          |
|    |               | error was   |              |       |          |
|    |               | detected.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATATYPE      |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORCODE     | This column |              |       |          |
|    |               | contains a  |              |       |          |
|    |               | unique      |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | to the type |              |       |          |
|    |               | of error    |              |       |          |
|    |               | detected by |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Data        |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | Rules       |              |       |          |
|    |               | component.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SE            | This column |              |       |          |
|    | CONDARYNUMID1 | contains    |              |       |          |
|    |               | the ID of   |              |       |          |
|    |               | the record  |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the data    |              |       |          |
|    |               | quality     |              |       |          |
|    |               | error was   |              |       |          |
|    |               | detected.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REPORTFLAG    | This column |              |       |          |
|    |               | indicates   |              |       |          |
|    |               | whether a   |              |       |          |
|    |               | particular  |              |       |          |
|    |               | data        |              |       |          |
|    |               | quality     |              |       |          |
|    |               | error must  |              |       |          |
|    |               | be reported |              |       |          |
|    |               | on the data |              |       |          |
|    |               | quality     |              |       |          |
|    |               | report for  |              |       |          |
|    |               | the job.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| ER |               |             |              |       |          |
| RO |               |             |              |       |          |
| RS |               |             |              |       |          |
| UM |               |             |              |       |          |
| MA |               |             |              |       |          |
| RY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSID         | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the PWSID   |              |       |          |
|    |               | of the      |              |       |          |
|    |               | Water       |              |       |          |
|    |               | System for  |              |       |          |
|    |               | which the   |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | for         |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | detected an |              |       |          |
|    |               | error.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORID       | The ErrorID |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the record  |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | detected an |              |       |          |
|    |               | error.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TABLENAME     | This        |              |       |          |
|    |               | TableName   |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | the table   |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the         |              |       |          |
|    |               | rejected    |              |       |          |
|    |               | parent      |              |       |          |
|    |               | record      |              |       |          |
|    |               | resides.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| ER |               |             |              |       |          |
| RO |               |             |              |       |          |
| RD |               |             |              |       |          |
| ET |               |             |              |       |          |
| AI |               |             |              |       |          |
| LS |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORID       | The ErrorID |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the record  |              |       |          |
|    |               | in which    |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | detected an |              |       |          |
|    |               | error. It   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | E           |              |       |          |
|    |               | rrorSummary |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORCODE     | This column |              |       |          |
|    |               | contains a  |              |       |          |
|    |               | unique      |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | to the type |              |       |          |
|    |               | of error    |              |       |          |
|    |               | detected by |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| ER |               |             |              |       |          |
| RO |               |             |              |       |          |
| RH |               |             |              |       |          |
| IS |               |             |              |       |          |
| TO |               |             |              |       |          |
| RY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORTYPE     | This column |              |       |          |
|    |               | indicates   |              |       |          |
|    |               | whether the |              |       |          |
|    |               | error was   |              |       |          |
|    |               | detected by |              |       |          |
|    |               | the Check   |              |       |          |
|    |               | for         |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | or the      |              |       |          |
|    |               | Check Data  |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | Rules       |              |       |          |
|    |               | component   |              |       |          |
|    |               | of NCaP.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORCODE     | This column |              |       |          |
|    |               | contains a  |              |       |          |
|    |               | unique      |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | to the type |              |       |          |
|    |               | of error    |              |       |          |
|    |               | detected by |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | or the      |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | for Data    |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | Rules       |              |       |          |
|    |               | component.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORCOUNT    | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of times    |              |       |          |
|    |               | each        |              |       |          |
|    |               | validation  |              |       |          |
|    |               | check was   |              |       |          |
|    |               | detected    |              |       |          |
|    |               | for a       |              |       |          |
|    |               | specific    |              |       |          |
|    |               | job.        |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| TR |               |             |              |       |          |
| AN |               |             |              |       |          |
| SA |               |             |              |       |          |
| CT |               |             |              |       |          |
| IO |               |             |              |       |          |
| NH |               |             |              |       |          |
| IS |               |             |              |       |          |
| TO |               |             |              |       |          |
| RY |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | JOBID         | The JobID   |              |       |          |
|    |               | is a        |              |       |          |
|    |               | s           |              |       |          |
|    |               | equentially |              |       |          |
|    |               | assigned    |              |       |          |
|    |               | number that |              |       |          |
|    |               | uniquely    |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | every XML   |              |       |          |
|    |               | document    |              |       |          |
|    |               | submitted   |              |       |          |
|    |               | to          |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
|    |               | It is a     |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | RequestLog  |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DATATYPE      | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | business    |              |       |          |
|    |               | objects.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RECORDSIN     | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of records  |              |       |          |
|    |               | inserted    |              |       |          |
|    |               | into the    |              |       |          |
|    |               | Staging     |              |       |          |
|    |               | Database.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RE            | This column |              |       |          |
|    | CORDSREJECTED | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of records  |              |       |          |
|    |               | rejected in |              |       |          |
|    |               | the Staging |              |       |          |
|    |               | Database.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | R             | This column |              |       |          |
|    | ECORDSIGNORED | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of records  |              |       |          |
|    |               | ignored in  |              |       |          |
|    |               | the Staging |              |       |          |
|    |               | Database.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RE            | This column |              |       |          |
|    | CORDSACCEPTED | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of records  |              |       |          |
|    |               | moved from  |              |       |          |
|    |               | the Staging |              |       |          |
|    |               | Database to |              |       |          |
|    |               | the Posting |              |       |          |
|    |               | Database.   |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | R             | This column |              |       |          |
|    | ECORDSDELETED | contains    |              |       |          |
|    |               | the number  |              |       |          |
|    |               | of records  |              |       |          |
|    |               | that were   |              |       |          |
|    |               | deleted     |              |       |          |
|    |               | from the    |              |       |          |
|    |               | post area.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| RR |               |             |              |       |          |
| OR |               |             |              |       |          |
| CO |               |             |              |       |          |
| DE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ERRORCODE     | This column |              |       |          |
|    |               | contains a  |              |       |          |
|    |               | unique      |              |       |          |
|    |               | ide         |              |       |          |
|    |               | ntification |              |       |          |
|    |               | to the type |              |       |          |
|    |               | of error    |              |       |          |
|    |               | detected by |              |       |          |
|    |               | the NCaP,   |              |       |          |
|    |               | Check for   |              |       |          |
|    |               | Compliance  |              |       |          |
|    |               | component   |              |       |          |
|    |               | or the      |              |       |          |
|    |               | NCaP, Check |              |       |          |
|    |               | for Data    |              |       |          |
|    |               | Quality     |              |       |          |
|    |               | Rules       |              |       |          |
|    |               | component.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DESCRIPTION   | This column |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the message |              |       |          |
|    |               | text        |              |       |          |
|    |               | associated  |              |       |          |
|    |               | with every  |              |       |          |
|    |               | error       |              |       |          |
|    |               | detected by |              |       |          |
|    |               | SDWIS/ODS.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *C |               |             |              |       |          |
| ON |               |             |              |       |          |
| TA |               |             |              |       |          |
| MI |               |             |              |       |          |
| NA |               |             |              |       |          |
| NT |               |             |              |       |          |
| RU |               |             |              |       |          |
| LE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CCODE         | Ccode is    |              | Viol  | CON      |
|    |               | the         |              | ation | TAMINANT |
|    |               | contaminant |              | &     | CODE     |
|    |               | code.       |              | E     |          |
|    |               |             |              | nforc |          |
|    |               |             |              | ement |          |
+----+---------------+-------------+--------------+-------+----------+
|    | RULECODE      | RuleCode    |              | Viol  | AS       |
|    |               | identifies  |              | ation | SOCIATED |
|    |               | the rule to |              | &     | J5000    |
|    |               | which a     |              | E     | GROUP    |
|    |               | specific    |              | nforc |          |
|    |               | contaminant |              | ement |          |
|    |               | code is     |              |       |          |
|    |               | associated. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *J |               |             |              |       |          |
| OB |               |             |              |       |          |
| OR |               |             |              |       |          |
| IG |               |             |              |       |          |
| IN |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ORIGINNAME    | The         |              |       |          |
|    |               | OriginName  |              |       |          |
|    |               | contains    |              |       |          |
|    |               | the code    |              |       |          |
|    |               | associated  |              |       |          |
|    |               | with the    |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency or   |              |       |          |
|    |               | region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ORGANIZATION  | O           |              |       |          |
|    |               | rganization |              |       |          |
|    |               | is the name |              |       |          |
|    |               | of the      |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency or   |              |       |          |
|    |               | region.     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| DR |               |             |              |       |          |
| SO |               |             |              |       |          |
| UR |               |             |              |       |          |
| CE |               |             |              |       |          |
| MA |               |             |              |       |          |
| PS |               |             |              |       |          |
| CA |               |             |              |       |          |
| LE |               |             |              |       |          |
| NU |               |             |              |       |          |
| MB |               |             |              |       |          |
| ER |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | S             | Scale of    |              |       |          |
|    | OURCEMAPSCALE | the map     |              |       |          |
|    |               | used to     |              |       |          |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | c           |              |       |          |
|    |               | oordinates. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DESCRIPTION   | Description |              |       |          |
|    |               | of the      |              |       |          |
|    |               | scale of    |              |       |          |
|    |               | the map     |              |       |          |
|    |               | used to     |              |       |          |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | c           |              |       |          |
|    |               | oordinates. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EDRCODE       | EDR Scale   |              |       |          |
|    |               | of the map  |              |       |          |
|    |               | used to     |              |       |          |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | c           |              |       |          |
|    |               | oordinates. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | E             | EDR         |              |       |          |
|    | DRDESCRIPTION | Description |              |       |          |
|    |               | of the      |              |       |          |
|    |               | scale of    |              |       |          |
|    |               | the map     |              |       |          |
|    |               | used to     |              |       |          |
|    |               | determine   |              |       |          |
|    |               | the         |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | c           |              |       |          |
|    |               | oordinates. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| DR |               |             |              |       |          |
| RE |               |             |              |       |          |
| FE |               |             |              |       |          |
| RE |               |             |              |       |          |
| NC |               |             |              |       |          |
| EP |               |             |              |       |          |
| OI |               |             |              |       |          |
| NT |               |             |              |       |          |
| CO |               |             |              |       |          |
| DE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REFER         | The         |              |       |          |
|    | ENCEPOINTCODE | national    |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum for   |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
|    |               | This is a   |              |       |          |
|    |               | national    |              |       |          |
|    |               | standard    |              |       |          |
|    |               | for three   |              |       |          |
|    |               | dimensional |              |       |          |
|    |               | and         |              |       |          |
|    |               | horizontal  |              |       |          |
|    |               | positioning |              |       |          |
|    |               | establishes |              |       |          |
|    |               | by the U.S. |              |       |          |
|    |               | National    |              |       |          |
|    |               | Geodetic    |              |       |          |
|    |               | Survey. In  |              |       |          |
|    |               | general, a  |              |       |          |
|    |               | datum is a  |              |       |          |
|    |               | m           |              |       |          |
|    |               | athematical |              |       |          |
|    |               | equation    |              |       |          |
|    |               | used to     |              |       |          |
|    |               | describe    |              |       |          |
|    |               | the         |              |       |          |
|    |               | earth\'s    |              |       |          |
|    |               | surface.    |              |       |          |
|    |               | There are   |              |       |          |
|    |               | in          |              |       |          |
|    |               | existence   |              |       |          |
|    |               | several     |              |       |          |
|    |               | national    |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum       |              |       |          |
|    |               | systems.    |              |       |          |
|    |               | Nearly all  |              |       |          |
|    |               | of EPA\'s   |              |       |          |
|    |               | data is in  |              |       |          |
|    |               | NAD27.      |              |       |          |
|    |               | Providers   |              |       |          |
|    |               | of latitude |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | data need   |              |       |          |
|    |               | to specify  |              |       |          |
|    |               | the         |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum their |              |       |          |
|    |               | coordinates |              |       |          |
|    |               | are based   |              |       |          |
|    |               | on in order |              |       |          |
|    |               | for others  |              |       |          |
|    |               | to          |              |       |          |
|    |               | accurately  |              |       |          |
|    |               | interpret   |              |       |          |
|    |               | the data.   |              |       |          |
|    |               | If the      |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum is    |              |       |          |
|    |               | not         |              |       |          |
|    |               | available,  |              |       |          |
|    |               | data        |              |       |          |
|    |               | providers   |              |       |          |
|    |               | should      |              |       |          |
|    |               | specify     |              |       |          |
|    |               | that this   |              |       |          |
|    |               | information |              |       |          |
|    |               | is not      |              |       |          |
|    |               | available.  |              |       |          |
|    |               | Reference   |              |       |          |
|    |               | Datum       |              |       |          |
|    |               | should be   |              |       |          |
|    |               | in the      |              |       |          |
|    |               | format BB   |              |       |          |
|    |               | where BB is |              |       |          |
|    |               | the year of |              |       |          |
|    |               | the datum.  |              |       |          |
|    |               | Category of |              |       |          |
|    |               | the feature |              |       |          |
|    |               | referenced  |              |       |          |
|    |               | by the      |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DESCRIPTION   | Description |              |       |          |
|    |               | of the      |              |       |          |
|    |               | REFERENC    |              |       |          |
|    |               | EPOINTCODE. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | EDRCODE       | EDR's       |              |       |          |
|    |               | national    |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum for   |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
|    |               | This is a   |              |       |          |
|    |               | national    |              |       |          |
|    |               | standard    |              |       |          |
|    |               | for three   |              |       |          |
|    |               | dimensional |              |       |          |
|    |               | and         |              |       |          |
|    |               | horizontal  |              |       |          |
|    |               | positioning |              |       |          |
|    |               | establishes |              |       |          |
|    |               | by the U.S. |              |       |          |
|    |               | National    |              |       |          |
|    |               | Geodetic    |              |       |          |
|    |               | Survey. In  |              |       |          |
|    |               | general, a  |              |       |          |
|    |               | datum is a  |              |       |          |
|    |               | m           |              |       |          |
|    |               | athematical |              |       |          |
|    |               | equation    |              |       |          |
|    |               | used to     |              |       |          |
|    |               | describe    |              |       |          |
|    |               | the         |              |       |          |
|    |               | earth\'s    |              |       |          |
|    |               | surface.    |              |       |          |
|    |               | There are   |              |       |          |
|    |               | in          |              |       |          |
|    |               | existence   |              |       |          |
|    |               | several     |              |       |          |
|    |               | national    |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum       |              |       |          |
|    |               | systems.    |              |       |          |
|    |               | Nearly all  |              |       |          |
|    |               | of EPA\'s   |              |       |          |
|    |               | data is in  |              |       |          |
|    |               | NAD27.      |              |       |          |
|    |               | Providers   |              |       |          |
|    |               | of latitude |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude   |              |       |          |
|    |               | data need   |              |       |          |
|    |               | to specify  |              |       |          |
|    |               | the         |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum their |              |       |          |
|    |               | coordinates |              |       |          |
|    |               | are based   |              |       |          |
|    |               | on in order |              |       |          |
|    |               | for others  |              |       |          |
|    |               | to          |              |       |          |
|    |               | accurately  |              |       |          |
|    |               | interpret   |              |       |          |
|    |               | the data.   |              |       |          |
|    |               | If the      |              |       |          |
|    |               | reference   |              |       |          |
|    |               | datum is    |              |       |          |
|    |               | not         |              |       |          |
|    |               | available,  |              |       |          |
|    |               | data        |              |       |          |
|    |               | providers   |              |       |          |
|    |               | should      |              |       |          |
|    |               | specify     |              |       |          |
|    |               | that this   |              |       |          |
|    |               | information |              |       |          |
|    |               | is not      |              |       |          |
|    |               | available.  |              |       |          |
|    |               | Reference   |              |       |          |
|    |               | Datum       |              |       |          |
|    |               | should be   |              |       |          |
|    |               | in the      |              |       |          |
|    |               | format BB   |              |       |          |
|    |               | where BB is |              |       |          |
|    |               | the year of |              |       |          |
|    |               | the datum.  |              |       |          |
|    |               | Category of |              |       |          |
|    |               | the feature |              |       |          |
|    |               | referenced  |              |       |          |
|    |               | by the      |              |       |          |
|    |               | latitude    |              |       |          |
|    |               | and         |              |       |          |
|    |               | longitude.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | E             | Description |              |       |          |
|    | DRDESCRIPTION | of the EDR  |              |       |          |
|    |               | Code.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *C |               |             |              |       |          |
| ON |               |             |              |       |          |
| TA |               |             |              |       |          |
| MI |               |             |              |       |          |
| NA |               |             |              |       |          |
| NT |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NAME          | The common  |              |       |          |
|    |               | name of a   |              |       |          |
|    |               | contaminant |              |       |          |
|    |               | as used by  |              |       |          |
|    |               | states and  |              |       |          |
|    |               | EPA in the  |              |       |          |
|    |               | rules and   |              |       |          |
|    |               | other       |              |       |          |
|    |               | documents.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | SC            | A text      |              |       |          |
|    | IENTIFIC_NAME | string      |              |       |          |
|    |               | r           |              |       |          |
|    |               | epresenting |              |       |          |
|    |               | the         |              |       |          |
|    |               | scientific  |              |       |          |
|    |               | name of the |              |       |          |
|    |               | analyte.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | TYPE_CODE     | A code      |              |       |          |
|    |               | describing  |              |       |          |
|    |               | the analyte |              |       |          |
|    |               | type.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CODE          | The         |              |       |          |
|    |               | standard    |              |       |          |
|    |               | code used   |              |       |          |
|    |               | by EPA and  |              |       |          |
|    |               | the states  |              |       |          |
|    |               | to          |              |       |          |
|    |               | represent   |              |       |          |
|    |               | analytes in |              |       |          |
|    |               | the         |              |       |          |
|    |               | national    |              |       |          |
|    |               | database.   |              |       |          |
|    |               | Each        |              |       |          |
|    |               | analyte has |              |       |          |
|    |               | a unique    |              |       |          |
|    |               | code        |              |       |          |
|    |               | assigned to |              |       |          |
|    |               | it for      |              |       |          |
|    |               | reference   |              |       |          |
|    |               | in          |              |       |          |
|    |               | compliance  |              |       |          |
|    |               | det         |              |       |          |
|    |               | ermination. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CAS           | A computed  |              |       |          |
|    | _REGISTRY_NUM | a           |              |       |          |
|    |               | lphanumeric |              |       |          |
|    |               | value that  |              |       |          |
|    |               | identifies  |              |       |          |
|    |               | the CAS     |              |       |          |
|    |               | Registry    |              |       |          |
|    |               | Number. The |              |       |          |
|    |               | CAS         |              |       |          |
|    |               | Registry    |              |       |          |
|    |               | Number is a |              |       |          |
|    |               | unique      |              |       |          |
|    |               | identifier, |              |       |          |
|    |               | assigned by |              |       |          |
|    |               | the         |              |       |          |
|    |               | Chemical    |              |       |          |
|    |               | Abstract    |              |       |          |
|    |               | Service     |              |       |          |
|    |               | (CAS) for a |              |       |          |
|    |               | specific    |              |       |          |
|    |               | chemical    |              |       |          |
|    |               | compound    |              |       |          |
|    |               | (e.g., an   |              |       |          |
|    |               | unregulated |              |       |          |
|    |               | co          |              |       |          |
|    |               | ntaminant). |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | CFR_S         | CODE OF     |              |       |          |
|    | ECTION_REF_CD | FEDERAL     |              |       |          |
|    |               | REGULATIONS |              |       |          |
|    |               | SECTION     |              |       |          |
|    |               | REFERENCE   |              |       |          |
|    |               | CODEA code  |              |       |          |
|    |               | value,      |              |       |          |
|    |               | which       |              |       |          |
|    |               | provides a  |              |       |          |
|    |               | reference   |              |       |          |
|    |               | to the Code |              |       |          |
|    |               | of Federal  |              |       |          |
|    |               | Regulations |              |       |          |
|    |               | Section.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | MONI          | Indicates   |              |       |          |
|    | TORING_IND_CD | whether     |              |       |          |
|    |               | this        |              |       |          |
|    |               | contaminant |              |       |          |
|    |               | is          |              |       |          |
|    |               | monitored.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | REG           | Indicates   |              |       |          |
|    | ULATED_IND_CD | whether the |              |       |          |
|    |               | analyte has |              |       |          |
|    |               | an          |              |       |          |
|    |               | established |              |       |          |
|    |               | numerical   |              |       |          |
|    |               | value for   |              |       |          |
|    |               | regulatory  |              |       |          |
|    |               | use (e.g.   |              |       |          |
|    |               | MCL, action |              |       |          |
|    |               | level,      |              |       |          |
|    |               | performance |              |       |          |
|    |               | level).     |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STA           | A code      |              |       |          |
|    | TE_CLASS_CODE | describing  |              |       |          |
|    |               | the analyte |              |       |          |
|    |               | type.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | COMMENT_TEXT  | Provides a  |              |       |          |
|    |               | textual     |              |       |          |
|    |               | comment     |              |       |          |
|    |               | about the   |              |       |          |
|    |               | analyte.    |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *V |               |             |              |       |          |
| IO |               |             |              |       |          |
| LA |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| TY |               |             |              |       |          |
| PE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | VCODE         | A code      | Code values  |       |          |
|    |               | value which | are          |       |          |
|    |               | categorizes | documented   |       |          |
|    |               | a           | in the       |       |          |
|    |               | violation.  | SDWIS/FedRep |       |          |
|    |               |             | Requirements |       |          |
|    |               |             | Document     |       |          |
|    |               |             | (Appendix    |       |          |
|    |               |             | N).          |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NAME          | The common  |              |       |          |
|    |               | name of a   |              |       |          |
|    |               | violation   |              |       |          |
|    |               | as used by  |              |       |          |
|    |               | states and  |              |       |          |
|    |               | EPA in the  |              |       |          |
|    |               | rules and   |              |       |          |
|    |               | other       |              |       |          |
|    |               | documents.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *E |               |             |              |       |          |
| NF |               |             |              |       |          |
| OR |               |             |              |       |          |
| CE |               |             |              |       |          |
| ME |               |             |              |       |          |
| NT |               |             |              |       |          |
| AC |               |             |              |       |          |
| TI |               |             |              |       |          |
| ON |               |             |              |       |          |
| CO |               |             |              |       |          |
| DE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ENFACTIONTYPE | A code      | These code   |       |          |
|    |               | value       | values are   |       |          |
|    |               | r           | documented   |       |          |
|    |               | epresenting | in the       |       |          |
|    |               | the         | SDWIS/FedRep |       |          |
|    |               | specific    | Requirements |       |          |
|    |               | type of the | Document     |       |          |
|    |               | enforcement | (Appendix    |       |          |
|    |               | action      | O).          |       |          |
|    |               | taken.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | NAME          | The common  |              |       |          |
|    |               | name of a   |              |       |          |
|    |               | enforcement |              |       |          |
|    |               | type as     |              |       |          |
|    |               | used by     |              |       |          |
|    |               | states and  |              |       |          |
|    |               | EPA in the  |              |       |          |
|    |               | rules and   |              |       |          |
|    |               | other       |              |       |          |
|    |               | documents.  |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *U |               |             |              |       |          |
| SE |               |             |              |       |          |
| RS |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERID        | User ID of  |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | USERNAME      | User Name   |              |       |          |
|    |               | of the      |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | INI           | Date and    |              |       |          |
|    | TIALLOGINDATE | time at     |              |       |          |
|    |               | which a     |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user        |              |       |          |
|    |               | initially   |              |       |          |
|    |               | logged into |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | a           |              |       |          |
|    |               | pplication. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | LASTLOGINDATE | Most recent |              |       |          |
|    |               | date and    |              |       |          |
|    |               | time at     |              |       |          |
|    |               | which a     |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user logged |              |       |          |
|    |               | into the    |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | a           |              |       |          |
|    |               | pplication. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ROLES         | Contains    |              |       |          |
|    |               | roles that  |              |       |          |
|    |               | the user    |              |       |          |
|    |               | was         |              |       |          |
|    |               | assigned to |              |       |          |
|    |               | when the    |              |       |          |
|    |               | user logged |              |       |          |
|    |               | into        |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | the last    |              |       |          |
|    |               | time.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STATES        | Contains    |              |       |          |
|    |               | the list of |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agencies    |              |       |          |
|    |               | that the    |              |       |          |
|    |               | user was    |              |       |          |
|    |               | authorized  |              |       |          |
|    |               | to access   |              |       |          |
|    |               | when the    |              |       |          |
|    |               | user logged |              |       |          |
|    |               | into        |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | the last    |              |       |          |
|    |               | time.       |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | STARTINGPAGE  | The page    |              |       |          |
|    |               | that        |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user wants  |              |       |          |
|    |               | to see      |              |       |          |
|    |               | after       |              |       |          |
|    |               | logging     |              |       |          |
|    |               | into the    |              |       |          |
|    |               | a           |              |       |          |
|    |               | pplication. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DEFAULTSTATE  | The default |              |       |          |
|    |               | primacy     |              |       |          |
|    |               | agency      |              |       |          |
|    |               | whose data  |              |       |          |
|    |               | the that    |              |       |          |
|    |               | the         |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user wants  |              |       |          |
|    |               | to see      |              |       |          |
|    |               | after       |              |       |          |
|    |               | logging     |              |       |          |
|    |               | into the    |              |       |          |
|    |               | a           |              |       |          |
|    |               | pplication. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | PWSSTATUS     | The default |              |       |          |
|    |               | activity    |              |       |          |
|    |               | status code |              |       |          |
|    |               | filter for  |              |       |          |
|    |               | the Water   |              |       |          |
|    |               | Systems     |              |       |          |
|    |               | that the    |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | user wants  |              |       |          |
|    |               | to see in   |              |       |          |
|    |               | SD          |              |       |          |
|    |               | WIS/ODSWEB. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *P |               |             |              |       |          |
| AG |               |             |              |       |          |
| EG |               |             |              |       |          |
| RO |               |             |              |       |          |
| UP |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | GROUPNAME     | Contains    |              |       |          |
|    |               | name of the |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | page group. |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | URLPATTERN    | Contains    |              |       |          |
|    |               | pattern of  |              |       |          |
|    |               | the pages   |              |       |          |
|    |               | includes in |              |       |          |
|    |               | the Page    |              |       |          |
|    |               | Group.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DESCRIPTION   | Contains    |              |       |          |
|    |               | description |              |       |          |
|    |               | of the page |              |       |          |
|    |               | group.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| ** |               |             |              |       |          |
| US |               |             |              |       |          |
| ER |               |             |              |       |          |
| RO |               |             |              |       |          |
| LE |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ROLENAME      | Contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | various     |              |       |          |
|    |               | roles used  |              |       |          |
|    |               | by          |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | users.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | DESCRIPTION   | Contains    |              |       |          |
|    |               | the         |              |       |          |
|    |               | description |              |       |          |
|    |               | of role     |              |       |          |
|    |               | name used   |              |       |          |
|    |               | by          |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | users.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
| *  |               |             |              |       |          |
| *R |               |             |              |       |          |
| OL |               |             |              |       |          |
| EP |               |             |              |       |          |
| AG |               |             |              |       |          |
| EG |               |             |              |       |          |
| RO |               |             |              |       |          |
| UP |               |             |              |       |          |
| ** |               |             |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | ROLENAME      | Contains    |              |       |          |
|    |               | the name of |              |       |          |
|    |               | various     |              |       |          |
|    |               | roles used  |              |       |          |
|    |               | in          |              |       |          |
|    |               | S           |              |       |          |
|    |               | DWIS/ODSWEB |              |       |          |
|    |               | pages. This |              |       |          |
|    |               | is a        |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | UserRole    |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+
|    | GROUPNAME     | Contains    |              |       |          |
|    |               | name of     |              |       |          |
|    |               | Page Group. |              |       |          |
|    |               | This is a   |              |       |          |
|    |               | foreign key |              |       |          |
|    |               | to the      |              |       |          |
|    |               | PageGroup   |              |       |          |
|    |               | table.      |              |       |          |
+----+---------------+-------------+--------------+-------+----------+

**APPENDIX B**

Map Objects and Elements to XML Schema, SDWIS/STATE Database,

and SDWIS/ODS Database

This page is intentionally left blank.

**Click on the icon below to view the electronic file for Appendix B**

![](media/image9.wmf)