+----------------------+-----------------------------------------------+
| ![](media/           | ![](me                                        |
| image1.wmf){width="2 | dia/image3.jpeg){width="1.4583333333333333in" |
| .2083333333333335in" | hei                                           |
| height="1            | ght="0.7916666666666666in"}**SDWIS/LabToState |
| .229861111111111in"} | 1.0**                                         |
|                      |                                               |
| United States        | **User Guide**                                |
| Environmental        |                                               |
| Protection Agency    |                                               |
|                      |                                               |
| Office of Ground     |                                               |
| Water and Drinking   |                                               |
| Water                |                                               |
|                      |                                               |
| Contract No.\        |                                               |
| EPA BPA              |                                               |
| OARMSC-SYS-04        |                                               |
|                      |                                               |
| SDWIS Project        |                                               |
|                      |                                               |
| Product Control No.  |                                               |
|                      |                                               |
| Sys                  |                                               |
| talex-SDWIS-01-6.d3b |                                               |
|                      |                                               |
| Deliverable No.      |                                               |
| 6.d3b                |                                               |
|                      |                                               |
| December 20, 2006    |                                               |
+----------------------+-----------------------------------------------+

**SDWIS/LABTOSTATE 1.0 USER GUIDE**

**CONTRACT NO. EPA BPA OARMSC-SYS-04**

**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**

**Edward Cottrill**

**Prepared by:**

**SAIC Solutions Delivery Center**

**Science Applications International Corporation**

**6565 Arlington Boulevard**

**Falls Church, VA 22042**

**CONTENTS**

[**1.0** **Introduction 1**](#introduction)

[1.1 Document Overview 1](#document-overview)

[1.2 Software and Hardware Test Environment
1](#software-and-hardware-test-environment)

[1.3 User Support 2](#user-support)

[2.0 SDWIS/LabToState User Instructions
3](#sdwislabtostate-user-instructions)

[2.1 SDWIS/LabToState Home Page 3](#sdwislabtostate-home-page)

[2.2 Upload and Validate Page 4](#upload-and-validate-page)

[2.2.1 XML Documents and CSV File Upload
5](#xml-documents-and-csv-file-upload)

[2.2.2 Retrieve Sample Data From Relational Database
6](#retrieve-sample-data-from-relational-database)

[2.2.3 Confirmation Page 9](#confirmation-page)

[2.2.4 Job Detail Page 9](#job-detail-page)

[2.3 Help Page 11](#help-page)

[2.4 Index and Summary Report Page 12](#index-and-summary-report-page)

**APPENDIX A** SDWIS/LabToState Reports

**APPENDIX B** CSV File and SQL Statement Physical Construct

**EXHIBITS**

[**Exhibit 1.** Hardware and Software Test Environment
2](#__RefHeading___Toc154364437)

[**Exhibit 2.** SDWIS/ LabToState Home Page
4](#__RefHeading___Toc154364438)

[**Exhibit 3.** Upload and Validate Page---XML Documents and CSV Files
6](#__RefHeading___Toc154364439)

[**Exhibit 4.** Upload and Validate Page---Relational Database
8](#__RefHeading___Toc154364440)

[**Exhibit 5.** Confirmation Page 9](#__RefHeading___Toc154364441)

[**Exhibit 6.** Job Detail Page 10](#__RefHeading___Toc154364442)

[**Exhibit 7.** Job Detail Warning Message
11](#__RefHeading___Toc154364443)

[**Exhibit 8.** Help Page 11](#__RefHeading___Toc154364444)

[**Exhibit 9.** Index and Summary Report Page
12](#__RefHeading___Toc154364445)

This page is intentionally left blank.

# Introduction

The *SDWIS/LabToState 1.0 User Guide* contains instructions for using
SDWIS/LabToState 1.0. SDWIS/LabToState may be deployed as a web-based,
platform‑independent application or as a stand‑alone client application.
It allows laboratories and other entities to format sample data into XML
documents, which are transferred to SDWIS/XML Sampling for additional
processing. The software is designed for use by and is available to all
laboratories, primacy agencies, and other entities required to format
sample data for submission to primacy agencies using SDWIS/XML Sampling.

## Document Overview

This document contains instructions for using SDWIS/LabToState 1.0. It
comprises the following two sections:

-   Section 1.0, Introduction, describes the content of the document,
    the software and hardware test environment, and user-support
    procedures.

-   Section 2.0, SDWIS/LabToState User Instructions, describes the
    SDWIS/LabToState user interfaces.

## Software and Hardware Test Environment

SDWIS/LabToState 1.0 was tested using the hardware and supporting
software versions listed in Exhibit 1. Exhibit 1 also identifies whether
the hardware and software listed was used to test the web‑based
application or the stand‑alone client application. More recent versions
of the supporting software may be available; the application, however,
has not been tested with these newer versions. SDWIS/LabToState,
additionally, interfaces with your site's local e-mail server.

+---------+----------+----------+--------------------+---------------+
| **      | **Pl     | **O      | **Software**       | **Hardware**  |
| Install | atform** | perating |                    |               |
| Pa      |          | System** |                    |               |
| ckage** |          |          |                    |               |
+=========+==========+==========+====================+===============+
| Client  | App      | Windows  | WINDOWS NT Server  | Dell OptiPlex |
| or      | lication | NT 4.0   | Software with      | GX400\        |
| We      | Server / | Server   | Service Pack 6     | (Pentium 4 -- |
| b‑Based | Web      |          |                    | 1.4 GHz       |
|         | Server   |          | Internet Explorer  | Processor)    |
|         |          |          | v6.0 with Service  |               |
|         |          |          | Pack 1             | 1 GB RAM      |
|         |          |          |                    |               |
|         |          |          | Java 2 SDK,        | Screen        |
|         |          |          | Standard Edition   | Resolution:   |
|         |          |          | (J2SE), v 1.4.2    | 1024 x 768    |
|         |          |          |                    | and Small     |
|         |          |          | Tomcat 5.0.28      | Fonts         |
|         |          |          |                    |               |
|         |          |          | SDWIS/XML Sampling |               |
|         |          |          | v1.0.3             |               |
+---------+----------+----------+--------------------+---------------+
|         | Database | Windows\ | WINDOWS NT Server  | Compaq        |
|         | Server   | NT 4 .0  | Software with      | Proliant      |
|         |          | Server   | Service Pack 6     | DL380,        |
|         |          |          |                    | Pentium III,  |
|         |          |          | Oracle 9i Release  | 933 MHz CPU,  |
|         |          |          | 2                  | 4GB Hard Disk |
+---------+----------+----------+--------------------+---------------+
|         | E-Mail   | Windows  | MS Exchange 2000   | Compaq        |
|         | Server   | 2000     |                    | Proliant      |
|         |          | Server   |                    | ML370 G2, two |
|         |          |          |                    | 1.3 MHz CPU,  |
|         |          |          |                    | 2 MB of       |
|         |          |          |                    | memory        |
+---------+----------+----------+--------------------+---------------+
|         | Client   | Windows  | Internet Explorer  | Dell OptiPlex |
|         | Wor      | 2000     | v6.0 with Service  | GX400\        |
|         | kstation |          | Pack 1             | (Pentium 4 -- |
|         |          |          |                    | 1.4 GHz       |
|         |          |          |                    | Processor)    |
|         |          |          |                    |               |
|         |          |          |                    | 1 G**B** RAM  |
|         |          |          |                    |               |
|         |          |          |                    | Screen        |
|         |          |          |                    | Resolution:   |
|         |          |          |                    | 1024 x 768    |
|         |          |          |                    | and Small     |
|         |          |          |                    | Fonts         |
+---------+----------+----------+--------------------+---------------+

[]{#__RefHeading___Toc154364437 .anchor}**Exhibit 1.** Hardware and
Software Test Environment

## User Support

As a representative of a primacy agency, you may call the SDWIS User
Support Hotline at (703) 292‑6298 or e‑mail SDWIS User Support at
<sdwis@saic-solutions.com>. If you represent a laboratory using the
SDWIS/LabToState product, you are encouraged to contact the primacy
agency to which you are reporting sample data. The primacy agency will
in turn contact the SDWIS User Support Hotline on your behalf. The
hotline/e-mail account is intended as a technical support tool for the
operation and functionality of SDWIS products such as SDWIS/LabToState.
A SDWIS team member answers calls to the hotline between 8 a.m. and 5
p.m., Eastern Standard Time (EST), on weekdays (except federal holidays)
and offers immediate user support when possible. During evenings,
weekends, or those times when the support personnel are temporarily not
available, callers may leave a detailed message. Questions requiring the
expertise of other team members, such as developers or subject matter
experts, are documented in the Events Tracking System, forwarded to
those individuals, and answered as soon as possible.

# SDWIS/LabToState User Instructions

This section describes the SDWIS/LabToState user‑interfaces. Each web
page consists of a Navigation Pane, which is located on the left side of
the page and the body of the web page, which contains the data presented
on the web page. The Navigation Pane includes links to assist you in
navigating among SDWIS/LabToState's functional capabilities. The
following links are presented on the Navigation Pane of each web page:

-   **Home/Job Listing**. Presents the SDWIS/LabToState Home Page, which
    is also referred to as the Job Listing page. This page lists
    information regarding files you have submitted to SDWIS/LabToState.

-   **Upload & Validate**. Presents the Upload & Validate page. This
    page allows you to submit sample data to SDWIS/XML Sampling.

-   **Logoff**. Closes your application session.

-   **Help.** Presents the Help page.

## SDWIS/LabToState Home Page

The SDWIS/LabToState Home Page presents the Job Listing Table as
depicted in Exhibit 2. It consists of the following columns:

**[List Criteria]{.underline}**

-   Job ID. The unique identification number assigned to the uploaded
    sample data. The Job ID is a link to the Job Detail Page, which is
    described in Section 2.2.4, Job Detail Page.

-   File Name. The name of the uploaded file.

-   Submitted By. The name of the user who uploaded the file.

-   Submitted On. The date and time the file was uploaded.

-   Laboratory Name. The name of the laboratory assigned to the user who
    uploaded the file.

-   Certified. If the file was certified by the laboratory for transfer
    to SDWIS/XML Sampling, this column contains a "Y." Otherwise, it
    contains an "N."

-   Certified By. The name of the user who certified the file.

-   Certified On. The date and time the file was certified.

-   Select. To remove the Job ID from the list, select the file using
    this checkbox and click the Remove Jobs From List button.

**[Button Section]{.underline}**

-   Remove Jobs From List. Removes the selected files from the Job List
    page.

-   Clear. Clears the Select column on the page.

![](media/image4.jpeg){width="6.711805555555555in"
height="3.826388888888889in"}

[]{#__RefHeading___Toc154364438 .anchor}**Exhibit 2.** SDWIS/ LabToState
Home Page

## Upload and Validate Page

The Upload and Validate page allows you to upload, format, and validate
files containing sample data. SDWIS/LabToState allows you to upload
files formatted as XML Documents and Comma-Separated-Value (CSV) Files
as well as retrieve sample data directly from a relational database. The
following sections describe how to upload these various file formats.

### XML Documents and CSV File Upload

To upload XML documents and CSV files, you enter the name of the file
containing the sample data, the format of the sample data in the file,
and the e‑mail address of the person to be notified when processing is
complete. To enter this information, you use the Upload and Validate
page, as depicted in Exhibit 3 and described below.

**[Selection Criteria]{.underline}**

-   File Format. Provides a dropdown list containing different file
    formats. To submit a CSV file, you select "CSV-File." To submit an
    XML Document, you select the type of XML document you are submitting
    (i.e., SDWIS‑EDWR‑XML, MDBP‑Summary‑XML, Sample‑Summary‑XML, or
    Sample‑Summary‑Result‑XML). Appendix B provides a detailed
    description on the physical construct of the CSV files.\
    \
    Note**:** The names presented in the drop down list box may be
    configured at each site. Therefore, the names identified above are
    the default names provided.

-   File Upload. Enter the complete path and name of the file to be
    uploaded. Note: In addition to entering the name of a file formatted
    as specified in the dropdown list box, you may also enter the name
    of a compressed file (i.e., zip file) containing multiple files of
    the selected format.

-   Notification E‑mail Addresses. Enter the e‑mail address of the
    person to be notified when processing is complete.

**[Button Section]{.underline}**

-   Process. After entering the required criteria described above, you
    click the **Process** button to upload, format, and validate the
    sample data. Once the job is submitted for processing, you will
    receive a confirmation page as described in Section 2.2.3,
    Confirmation Page. After processing is complete, an e‑mail message
    will be delivered to the e‑mail address you specified.

-   Clear. Clears the text fields.

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

[]{#__RefHeading___Toc154364439 .anchor}**Exhibit 3.** Upload and
Validate Page---XML Documents and CSV Files

### Retrieve Sample Data From Relational Database

To retrieve sample data from a relational database, you select
"ODBC‑SQL" from the dropdown list box. Then, for each logical object,
you enter the SQL statement, which is used to retrieve the sample data.
To enter this information, you use the Upload and Validate page, as
depicted in Exhibit 4 and described below.

**[Selection Criteria]{.underline}**

-   File Format. Provides a dropdown list containing different file
    formats. To retrieve data from a database, you select "ODBC‑SQL."\
    \
    Note: The names presented in the drop down list box may be
    configured at each site. The names identified above are the default
    names provided.

-   File Upload. For this file format, this text field should remain
    blank.

-   Notification E‑mail Addresses. Enter the e‑mail address of the
    person to be notified when processing is complete.

-   Structured Set SQL. For each logical business object, enter the SQL
    statement that will be used to retrieve the information from the
    database. Appendix B provides a detailed description of the physical
    construct of the SQL Statement.\
    \
    Note: The columns retrieved for each logical business object must be
    in the same order as the elements listed in the Element
    Configuration File. *SDWIS/LabToState Installation Guide*
    (Systalex-SDWIS-01-6.d3a, December 20, 2006) contains a description
    of the Element Configuration File.

**[Button Section]{.underline}**

-   Process. After entering the required criteria described above, you
    click the **Process** button to upload, format, and validate the
    sample data. Once the job is submitted for processing, you will
    receive a confirmation page as described in Section 2.2.3,
    Confirmation Page. After processing is complete, an e‑mail message
    will be delivered to the specified address.

-   Clear. Clears the text fields.

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

[]{#__RefHeading___Toc154364440 .anchor}**Exhibit 4.** Upload and
Validate Page---Relational Database

### Confirmation Page

The Confirmation Page, as depicted in Exhibit 5, notifies you that the
file has been submitted for processing.

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

[]{#__RefHeading___Toc154364441 .anchor}**Exhibit 5.** Confirmation Page

### Job Detail Page

The Job Detail Page, as depicted in Exhibit 6, allows you to certify the
sample data. To certify the data, you check the "I Agree" check box and
enter a PIN number assigned to you by the primacy agency. Then, you
click the **Submit** button after which the sample data is transferred
to SDWIS/XML Sampling for additional validation and storage. If the file
was already certified, a warning message is displayed as shown in
Exhibit 7. You may continue the certification by clicking the **OK**
button or stop the certification by clicking the **Cancel** button.

The Job Detail Page is logically grouped into the sections described
below.

**[Job Detail Section]{.underline}**

-   Job ID. The unique identification number assigned to the uploaded
    file.

-   File Name. The name of the uploaded file.

-   Laboratory. The name of the laboratory assigned to the user who
    uploaded the file.

-   Certified. If the file was certified by the laboratory for transfer
    to SDWIS/XML Sampling, this field contains a "Y." Otherwise, it
    contains an "N."

**[Certification Section]{.underline}**

-   Certification Statement. A statement prepared by each primacy agency
    to which you must agree in order to submit the data in to SDWIS/XML
    Sampling.

-   I Agree. Check the box to indicate you accept the Certification
    Statement.

-   Enter PIN Number. Enter the PIN Number assigned to you by the
    primacy agency.

-   Submit File(s) Button. Transfers the sample data to SDWIS/XML
    Sampling for additional validation and permanent storage.

**[Navigation Pane Additional Links]{.underline}**

-   View Report. Presents the Index and Summary Report Page as described
    in Section 2.4, Index and Summary Report Page.

-   summary.xml. Displays the generated XML document.

![](media/image8.jpeg){width="6.524305555555555in"
height="4.013888888888889in"}

[]{#__RefHeading___Toc154364442 .anchor}**Exhibit 6.** Job Detail Page

![](media/image9.png){width="6.489583333333333in" height="3.75in"}

[]{#__RefHeading___Toc154364443 .anchor}**Exhibit 7.** Job Detail
Warning Message

## Help Page

The Help Page is depicted in Exhibit 8. This page contains an index to
descriptions of additional SDWIS/LabToState capabilities.

![](media/image10.png){width="6.009722222222222in"
height="3.046527777777778in"}

[]{#__RefHeading___Toc154364444 .anchor}**Exhibit 8.** Help Page

## Index and Summary Report Page

The Index and Summary Report Page contains both a Navigation Pane and a
Summary Section as depicted in Exhibit 9. The Navigation Page contains
links to the detail reports and XML documents generated by
SDWIS/LabToState validation. The detail reports are described in
Appendix A. The Summary Section contains the information described
below:

**[Summary Section]{.underline}**

-   Structure Set. The name of the structure set.

-   Generation Record Count. The number of logical objects submitted for
    generation.

-   Generation Error Count. The number of logical objects in which an
    error is detected.

-   Validation Record Count. The number of logical objects submitted for
    XML Schema validation.

-   Validation Error Count. The number of logical objects in which an
    XML Schema validation error is detected.

![](media/image11.png){width="6.520833333333333in"
height="3.3291666666666666in"}

[]{#__RefHeading___Toc154364445 .anchor}**Exhibit 9.** Index and Summary
Report Page

**APPENDIX A**

SDWIS/LabToState Reports

This page is intentionally left blank.

**Index and Summary Report**

The Index and Summary Report is formatted as illustrated below. The
physical filename for this report is Index.html. It provides hyperlinks
as follows:

**Links**

-   [Generation Errors.]{.underline} Presents the errors detected during
    XML Generation and is illustrated later in this Appendix.

-   [\[XML Schema\]-Errors.]{.underline} Presents the errors detected
    during XML Validation. A separate link is presented for each
    supported XML Schema.

**[Columns]{.underline}**

-   Structure Set. Identifies the name of the structure set.

-   Generation Record Count. Counts the number of logical objects
    submitted for generation.

-   Generation Error Count. Counts the number of logical objects in
    which an error is detected.

-   Validation Record Count. Counts the number of logical objects
    submitted for XML Schema validation.

-   Validation Error Count. Counts the number of logical objects in
    which an XML Schema validation error is detected.

![](media/image11.png){width="6.520833333333333in"
height="3.3291666666666666in"}

**Generation Errors Report**

The Generation Errors Report is formatted as illustrated below. The
physical filename for this report is Generation-Errors.html. It contains
a list of the errors detected during XML Generation.

![](media/image12.png){width="6.510416666666667in"
height="2.4479166666666665in"}

**XML Schema Errors Report**

The XML Schema Errors Report is formatted as illustrated below. A
separate report is generated for each XML Schema supported. The physical
filename for this report is \[XMLSchema\]‑Errors.html. It contains a
list of the errors detected during XML Validation.

![](media/image13.png){width="6.520833333333333in"
height="1.0104166666666667in"}

This page is intentionally left blank.

**APPENDIX B**

CSV File and SQL Statement Physical Construct

This page is intentionally left blank.

**CSV File Physical Construct**

The CSV file containing sample data contains a single line for each
logical object defined by the primacy agency in the Object Configuration
File described in *SDWIS/LabToState Installation Guide*
(Systalex-SDWIS-01-6.d3a, December 20, 2006). For a default
implementation, those logical business objects are as follows:

-   Sample

-   SampleResult

-   SampleMeasure

-   SampleResultMeasure

-   SampleSummary

-   SampleSummaryResult

-   MDBPSummary

During installation, the elements included in each logical business
object are identified along with the order in which they are submitted
in the CSV file. For a default implementation, the Sample object is
configured to submit the elements identified below in the order in which
they are listed:

-   B_LAB_SAMPLE_NUM

-   B_STATE_SAMPLE_NUMBER

-   B_PWS_NUMBER

-   B_REPLACEMENT_INDICATOR

-   B_LABORATORY_CERTIFYING_AGENCY

-   B_LABORATORY_CERTIFICATION_ID

-   B_WSF_STATE_ASGN_ID

-   B_SAMPLING_POINT

-   B_SAMPLING_LOCATION

-   B_SAMPLE_CATEGORY

-   B_COMPLIANCE_INDICATOR

-   B_COLLECTION_DATE

-   B_COLLECTION_TIME

-   B_SAMPLE_TYPE

-   B_REPEAT_LOCATION

-   B_LAB_RECEIPT_DATE

-   B_COLLECTOR_NAME

-   B_SAMPLE_VOLUME

-   B_LEAD_COPPER_SAMPLE_TYPE

-   B_SAMPLE_REJECTION_REASON

-   B_COLLECTION_METHOD_CODE

-   B_ORIGINAL_LAB_SAMPLE_NUMBER

-   B_ORIGINAL_COLLECTION_DATE

-   B_LAB_COMPOSITE_NUMBER

-   B_COMPOSITE_DATE

-   B_FREE_CHLORINE_RESIDUAL

-   B_TOTAL_CHLORINE_RESIDUAL

-   B_SAMPLE_WATER_TEMPERATURE

-   B_TEMPERATURE_UNIT_MEASURE

-   B_TURBIDITY_MEASURE

-   B_PH_MEASURE

-   B_FLOW_RATE

-   B_SAMPLE_PURPOSE

-   B_STATE_CLASSIFICATION_CODE

-   B_SAMPLE_COMMENTS

-   B_ORIGINAL_LABORATORY_CERTIFYING_AGENCY

-   B_ORIGINAL_LABORATORY_CERTIFICATION_ID

When constructing the CSV file the first column of each line is the name
of the logical object. Also, to ensure that embedded spaces are
accurately represented in data elements such as name, descriptions, and
comments, it is recommended that each data value be embedded in
quotation marks. Using the default definition of the Sample object, an
example of the physical CSV file content is as follows:

![](media/image14.png){width="6.5in" height="0.6666666666666666in"}

Note: For display purposes, the physical line has been truncated.

Each CSV file may also contain data for multiple logical objects and the
logical objects may be in any order, as illustrated below.

![](media/image15.png){width="6.5in" height="1.1354166666666667in"}

**SQL Statement Physical Construct**

To use the SQL Plug‑In, you enter SQL statements retrieving the sample
data from any relational database using ODBC. The *SDWIS/LabToState
Installation Guide* (Systalex‑SDWIS‑01‑6.d3a, December 20, 2006)
describes the installation procedures to establish the ODBC connection.

You must develop a single SQL statement to retrieve sample data for each
logical object defined during installation. For a default
implementation, those logical business objects are as follows:

-   Sample

-   SampleResult

-   SampleMeasure

-   SampleResultMeasure

-   SampleSummary

-   SampleSummaryResult

-   MDBPSummary

During installation, the elements included in each logical business
object are identified along with the order in which they are submitted.
For a default implementation, the Sample object is configured to submit
the elements identified below in the order in which they are listed:

-   B_LAB_SAMPLE_NUM

-   B_STATE_SAMPLE_NUMBER

-   B_PWS_NUMBER

-   B_REPLACEMENT_INDICATOR

-   B_LABORATORY_CERTIFYING_AGENCY

-   B_LABORATORY_CERTIFICATION_ID

-   B_WSF_STATE_ASGN_ID

-   B_SAMPLING_POINT

-   B_SAMPLING_LOCATION

-   B_SAMPLE_CATEGORY

-   B_COMPLIANCE_INDICATOR

-   B_COLLECTION_DATE

-   B_COLLECTION_TIME

-   B_SAMPLE_TYPE

-   B_REPEAT_LOCATION

-   B_LAB_RECEIPT_DATE

-   B_COLLECTOR_NAME

-   B_SAMPLE_VOLUME

-   B_LEAD_COPPER_SAMPLE_TYPE

-   B_SAMPLE_REJECTION_REASON

-   B_COLLECTION_METHOD_CODE

-   B_ORIGINAL_LAB_SAMPLE_NUMBER

-   B_ORIGINAL_COLLECTION_DATE

-   B_LAB_COMPOSITE_NUMBER

-   B_COMPOSITE_DATE

-   B_FREE_CHLORINE_RESIDUAL

-   B_TOTAL_CHLORINE_RESIDUAL

-   B_SAMPLE_WATER_TEMPERATURE

-   B_TEMPERATURE_UNIT_MEASURE

-   B_TURBIDITY_MEASURE

-   B_PH_MEASURE

-   B_FLOW_RATE

-   B_SAMPLE_PURPOSE

-   B_STATE_CLASSIFICATION_CODE

-   B_SAMPLE_COMMENTS

-   B_ORIGINAL_LABORATORY_CERTIFYING_AGENCY

-   B_ORIGINAL_LABORATORY_CERTIFICATION_ID

The SQL statement must retrieve the data in the same order as defined by
your installation. Additionally, the first column must always be the
name of the logical object. For example, to retrieve sample data, the
SQL statement is similar to the following:

Select "Sample", Sample_Number, PWSID, ReplacementIndicator...

From Sample where ...