Document ID: EPA-HQ-OW-2002-0043-0213
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-08-18T04:00Z

United
States
Environmental
Protection
Agency
Office
of
Ground
Water
and
Drinking
Water
Query
Tool
Production
Release
2.0
Contract
No.
68­
W­
99­
002
Task
Order
No.
007
Product
Control
No.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
SDC­
0002­
007­
HB­
2008B
April
21,
2000
QUERY
TOOL
PRODUCTION
RELEASE
2.0
CONTRACT
NO.
68­
W­
99­
002
TASK
ORDER
NO.
007
Prepared
for:

United
States
Environmental
Protection
Agency
Office
of
Ground
Water
and
Drinking
Water
401
M
Street,
SW.
Washington,
DC
20460
Task
Order
Project
Officer:

Edward
A.
Cottrill
Prepared
by:

Systems
Development
Center
Science
Applications
International
Corporation
6565
Arlington
Boulevard
Falls
Church,
VA
22042
SDC­
0002­
007­
HB­
2008B
April
21,
2000
iii
CONTENTS
1.0
INTRODUCTION
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
1
1.1
Purpose
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
1
1.2
Scope
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
2
1.3
References
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
2
2.0
SUMMARY
OF
FUNCTIONALITY
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
4
3.0
INSTALLATION
INSTRUCTIONS
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
4
SDC­
0002­
007­
HB­
2008B
April
21,
2000
1
1.0
INTRODUCTION
1.1
Purpose
The
United
States
Environmental
Protection
Agency
(
EPA)
Office
of
Ground
Water
and
Drinking
Water
(
OGWDW)
is
responsible
for
implementing
the
Public
Water
System
Supervision
(
PWSS)
Program
established
under
the
auspices
of
the
Safe
Drinking
Water
Act
(
SDWA)
of
1974
(
Public
Law
93­
523)
and
the
1996
reauthorization
of
the
Act.
Two
of
OGWDW's
major
responsibilities
under
the
Act
are
to
set
national
standards
for
drinking
water
quality
and
to
ensure
that
the
states
that
have
assumed
primary
enforcement
responsibility
are
enforcing
these
standards.

In
February
1994,
OGWDW
proposed
an
Information
Collection
Rule
(
ICR),
requiring
certain
Public
Water
Systems
(
PWS)
to
generate
and
provide
the
Agency
with
specific
microbiological
contaminant
and
Disinfection
By­
Product
(
DBP)
monitoring
data,
general
water
quality
data,
and
treatment
plant
design
and
operating
information
characterizing
their
water
systems.
OGWDW
began
developing
a
Data
Management
System
(
DMS)
to
support
the
PWSS
Program
Information
Systems
Modernization
(
ISM)
effort.
The
purpose
was
to
provide
contractor
support
to
complete
the
development
of
and
provide
support
for
the
following
automated
systems:

The
ICR
Water
Utility
Database
System.

The
ICR
Laboratory
Quality
Control
(
QC)
Database
System.

The
ICR
Federal
Database
System.

ICR
Data
Analysis
Database
1
(
i.
e.,
Auxiliary
1
Database)
and
accompanying
Query
Tool.

These
systems
are
described
collectively
as
the
ICR
DMS.
The
ICR
Water
Utility
Database
System
allows
water
utilities
to
report
required
data
via
software
directly
to
EPA.
The
Laboratory
QC
Database
System
enables
the
analytical
laboratories
that
are
approved
to
perform
sample
analyses
under
the
ICR
to
report
data
directly
to
the
Agency.
Capabilities
of
the
ICR
Federal
Database
System
include
data
population,
or
the
capability
to
upload
data
from
utilities
and
laboratories
to
the
central
database;
validation
of
Sample
Analytical
Result
(
SAR)
data,
according
to
standards
established
by
EPA;
and
support
for
tracking
the
approval
status
of
analytical
laboratories.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
2
After
data
are
loaded
into
the
ICR
Federal
Database
System
and
validated,
the
data
must
be
analyzed
by
a
number
of
researchers
and
analysts.
The
analysts
use
the
ICR
data
to
develop
regulations
to
assure
public
health
protection
from
disease­
causing
microbes
(
pathogens),
including
cryptosporidium,
virus,
giardia,
and
DBPs.
The
ICR
DMS
Team
was
tasked
with
developing
the
Auxiliary
1
Database,
which
stores
a
subset
of
data
extracted
from
the
ICR
Federal
Database
System.
The
Auxiliary
1
Database
provides
researchers
and
analysts
with
a
smaller,
yet
still
comprehensive,
version
of
the
ICR
Federal
Database
System.

The
Auxiliary
1
Database
is
designed
such
that
it
is
simple
to
examine
a
single
variable
across
all
plants
(
e.
g.,
Total
Trihalomethane
[
TTHM]
concentration
at
the
finished
water
sample
point
in
chlorination
plants).
It
is
more
difficult,
although
not
impossible,
to
examine
a
single
variable
through
a
single
plant
(
e.
g.,
change
in
Total
Organic
Carbon
[
TOC]
concentration
through
a
specific
plant
practicing
enhanced
coagulation).
The
Query
Tool
is
designed
to
facilitate
throughplant
analyses
for
the
ICR
data
analysts.
Its
primary
function
is
to
allow
ICR
data
analysts
to
aggregate
plant
data
in
a
horizontal
fashion.
The
Query
Tool
enables
analysts
to
perform
analyses
without
having
an
in­
depth
knowledge
of
database
execution,
such
as
making
complex
joins
in
Microsoft
®
AccessJ.

1.2
Scope
The
Task
Order
Project
Officer
(
TOPO)
tasked
the
ICR
DMS
Team
with
delivering
the
Query
Tool
Production
Release
2.0
and
the
Query
Tool
User
Documentation
Release
2.0
on
April
19,
2000.
This
document
presents
the
release
notes
for
the
Query
Tool
and
the
Query
Tool
User
Documentation.

The
Query
Tool
User
Documentation
is
the
on­
line
help
for
the
Query
Tool.
The
on­
line
help
was
developed
in
RoboHelp
®
and
is
designed
to
work
with
the
Query
Tool
software.
The
online
help
for
the
Query
Tool
(
aux1help.
hlp)
is
included
in
the
Query
Tool
deliverable.
Installation
instructions
for
the
Query
Tool
are
listed
in
Section
3.0
of
this
document.
The
Query
Tool
User
Documentation
will
be
automatically
be
installed
along
with
the
Query
Tool.

1.3
References
The
following
documents
are
applicable
to
the
release
of
the
Query
Tool
and
the
Query
Tool
User
Documentation.
They
include
government,
industry,
and
ICR
project
documents,
standards,
specifications,
plans,
regulations,
manuals,
and
other
materials
used
to
develop
the
software
for
the
release.

Note:
The
documents
are
listed
in
reverse
chronological
order.

Query
Tool
Production
Release
1.0.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
3
SDC;
SDC­
0002­
007­
MS­
2008A;
January
19,
2000.

Auxiliary
1
Database
and
Documentation,
Production
Release
5.0.
Systems
Development
Center
(
SDC);
SDC­
0002­
007­
HB­
2011B;
April
19,
2000

Auxiliary
1
User
Documentation,
Version
4.0.
SDC;
SDC­
0002­
007­
EB­
1026A;
January
7,
2000.

Year
2000
Calendar
Date
Standard
Waiver,
ICR,
Contract:
68­
W­
99­
002,
Task
Order
007,
Mod:
09,
August
12,
1999.

Project
Plan
for
Information
Systems
Development
and
User
Support
for
the
Public
Water
System
Supervision
(
PWSS)
Program's
Information
Collection
Rule
(
ICR).
EPA
SDC;
SDC­
0002­
007­
HB­
1001A;
December
22,
1998.

Revised
Information
Collection
Rule
(
ICR)
Data
Management
System
(
DMS)
System
Manual.
EPA
SDC;
SDC­
0002­
007­
SS­
1021;
July
2,
1999.

Chapters
3
through
9
of
the
Information
Collection
Rule
(
ICR)
Data
Analysis
Requirements
Specification.
EPA
SDC;
SDC­
0055­
083­
EB­
7031;
September
29,
1998.

Technical
Summary
for
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Joint
Application
Design
(
JAD)
Meeting,
August
17­
19,
1998.
EPA
SDC;
SDC­
0055­
083­
BN­
7027;
September
23,
1998.

Primary
Auxiliary
Database
Chapter
of
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Design
Specification,
EPA
SDC;
SDC­
0055­
083­
FH­
7026;
August
21,
1998.

Primary
Auxiliary
Database
Chapter
of
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Requirements
Specification.
EPA
SDC;
SDC­
0055­
083­
EB­
7022A;
July
24,
1998.

Technical
Summary
for
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Joint
Application
Design
(
JAD)
Meeting,
June
15­
17,
1998.
EPA
SDC;
SDC­
0055­
083­
MH­
7023;
July
6,
1998.

Technical
Summary
for
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Joint
Requirements
Planning
(
JRP)
Meeting,
May
19­
20,
1998.
EPA
SDC;
SDC­
0055­
083­
MH­
7021;
June
1,
1998.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
4

Revised
Technical
Summary
for
the
Information
Collection
Rule
(
ICR)
Data
Extraction
Joint
Requirements
Planning
(
JRP)
Meeting,
April
14­
16,
1998.
EPA
SDC;
SDC­
0055­
083­
EB­
7019A;
May
22,
1998.

Information
Collection
Rule
(
ICR)
Data
Extraction
Joint
Requirements
Planning
(
JRP)
Meeting,
February
20,
1998.
EPA
SDC;
SDC­
0055­
083­
MH­
7015;
March
6,
1998.

2.0
SUMMARY
OF
FUNCTIONALITY
The
release
of
the
Query
Tool
incorporates
all
functions
listed
as
requirements
in
the
document,
Auxiliary
1
Database
and
Documentation,
Production
Release
5.0.
Systems
Development
Center
(
SDC);
SDC­
0002­
007­
HB­
2011B;
April
19,
2000.

The
Query
Tool
User
Documentation
provides
on­
line
help
to
Query
Tool
users.
The
following
functions
are
included
in
the
Query
Tool
help:

Instructions
regarding
the
use
of
the
Query
Tool.

On­
line
data
dictionary.

Data
mapping
of
the
Auxiliary
1
Database
Field
Attribute
Name
to
the
Field
Name
in
the
Auxiliary
1
Database
to
the
Query
Output
Field
Caption
(
i.
e.,
Microsoft
®
AccessJ
Alias).

3.0
INSTALLATION
INSTRUCTIONS
This
software
is
designed
to
be
run
under
Microsoft
®
AccessJ
97
on
a
Windows
95J
Personal
Computer
(
PC)
platform.
Please
note
that
Microsoft
®
AccessJ
97
must
be
installed
on
your
computer
before
you
install
the
Query
Tool.
To
install
the
Query
Tool:

Ensure
that
you
do
not
have
a
sub­
directory
called
QTOOL
on
your
hard
drive.

Copy
TACRUN.
EXE,
Install.
bat
and
Qtool.
mdb
files
to
a
temporary
sub­
directory
on
the
C:\
drive.

Double
click
on
the
Install.
bat
file
from
the
temporary
sub­
directory
on
the
C:\
drive.
The
install
is
complete
when
"
finished"
displays
in
the
title
bar
of
the
DOS
window.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
5
Note:
The
Query
Tool
help
file,
aux1help.
hlp,
is
included
in
the
install.
This
help
file
must
reside
in
the
same
directory
as
the
qtool.
mdb
in
order
to
function
properly.

Use
Windows
Explorer
to
find
the
C:\
QTOOL
sub­
directory
and
find
the
QTOOL.
MDB.

Double
click
on
the
QTOOL.
MDB
to
open
the
Query
Tool.

If
a
message
displays
stating
that
the
links
to
the
Auxiliary
1
Database
are
invalid
or
do
not
exist,
click
OK
to
display
a
dialog
box
where
you
can
search
for
the
Auxiliary
1
Database.
Click
on
Open
to
establish
the
links
to
the
database.

The
Intro
screen
of
the
Query
Tool
contains
the
Query
Tool
Help
button.
Click
the
Query
Tool
Help
button
to
list
the
table
of
contents.
SDC­
0002­
007­
HB­
2008B
April
21,
2000
6
This
page
intentionally
left
blank.