&EPA
United States
Environmental Protection
Agency
Office of Water
(WH-550A)
October 1993
WATERS
Well Activities Tracking, Evaluation
and Reporting System
Version 2.0
User Guide
Compliance & Enforcement * Inventory'• MIT
* Permit * * Compliance & Enforce-
ment «. Inventory • * Permit •• Inspect Son
* Compliance & * *
• • inspection * Compliance &
Enforcement __^jBMa^ * Permit *
' " '' ' • •' [\ 1W Hf «
*
« Conn
nit * inspection
Permit *
eitient *
pliance &. Ei
• Compliance & * inventory *
• Permit • * Compliance &'
Enforcement * inventory * • Permit «
.Inspection • .Compliance & *
inventory • MIT • Permit •• Inspection • Com-
pliance & Enforcement • inventory * MIT *
$3) Printed on Recycled Paper
-------
INSTALLATION PACKAGE
N
(•upenedc* p*fti 5 Ik 6 in UKT Oujdc)
The basic HATERS installation package contains the following:
• One WATERS Program Diskette (EPA 813-C-93-001)
* One GIS Data Diskette (see specific EPA order numbers below)
« One Oder Guide (EPA 813-B-93-002, October 1993)
If you wish to use the optional HATERS Mapping System (WMS), you must also
obtain a Maplnfo™ runtime module. The runtime module includes several
diskettes, installation instructions, and user documentation.
Until February 28, 1994, a runtime module may be purchased at a reduced
price for the HATERS application from the following Maplnfo™ authorized
developer for $335.75 a copy (current price is $695.00). Payment must
accompany order.
American Management Systems, Inc.
1777 North Kent Street
Arlington, Virginia 22209
Attns Mr. Jerry Golley
After February 1994, runtime modules may be purchased at the regular
price through any authorized developer.
The specific order numbers for the CIS Data Diskette by EPA Region and State
are listed below.
Region States Included EPA Publication Number
I CT,ME,MA,NH,RI,VT 813-C-93-002
II NJ,NY,PR,VI 813-C-93-003
III DE,DC,MD,PA,VA,HV 813-C-93-004
IV AL,FL»GA,KY,MS,NC,SC,TN 813-C-93-005
V IL,IN,MI,MN,OH,HI 813-C-93-006
VI AR,LA,NM,OK,TX 813-C-93-007
VII IA,KS,MO,NE 813-C-93-008
VIII CO,MT,ND,SD,UT,HY 813-C-93-009
IX AZ,CA,HI,NV,AS,GU, 813-C-93-010
X AK,ID,OR,HA 813-C-93-011
-------
WATERS Mapping System Installation Addendum
(Tfeu a m Kidendum to Oupier ID; liaiaBatiat aid Stan-tip at fee WATERS Utw Oinde)
To install the Maplnfo™Runtime Module, follow the directions below.
Step 1. Insert the RUNTIME DISK 1 in Drive A. Then type A.Install.
Step 2. When you are asked. Do you wish to install the Maplnfo™
Runtime Sdftware?, select yes.
Step 3. When asked to confirm the destination path, select no. and then
type C;\WATERS\RT.
Step 4. You are instructed to insert Program Disk 1 and press ENTER to
begin installation. Then prompted for Program Disk 2 and the
Drivers Diskette.
Step 5, When asked, Do you want to see the READ,ME file?, select no.
Step 6. When asked Ho you wisft to specify your hardware configuration?,
select ves.
Step 7. Select the Display, Input, and Output Device.
Step 8. When asked Do you wish to load any data?, select no.
One of the files created when installing the Maplnfo™ Runtime Module is
the CGI.CFG file. A copy of this file should always be available for the
WATERS Mapping System. The file is created from Steps 6-7 above and is the
configuration file pointed to by the CGIPATH DOS variable.
When CGI.CFG is not found, an error message is displayed. In such
cases, the CGI.CFG file may not have been created during installation or
device configuration was incorrectly assigned. To correct the problem, add
CGIPATH=C;\WATERS\RT to the AUTOEXEC.BAT file, and then reboot your machine.
After installation of the Maplnfo™ Runtime Module, the CIS startup
displays a warning message indicating that the following files were not found:
• MAPINFO Help file
• Poijitfile CITY
To prevent these warnings messages from occurring, use a text editor
(such as EDIT) to modify the WMS.CNF file located in the WATERS directory.
Two changes need to be made to this file:
1) Deletes /H MAPINFO.HLP
2) Change: /P D:\WATERS\MAPDATA\CITY
3) To: /P C:\WATBRS\MAPDATA\CITY
where C: is the drive WATERS was installed.
-------
Table of Contents
V. WATERS Folders 18
UIC Folders 18
Single Record Folders 19
Multiple Record Folders 25
Non-UIC Folder.... 27
VI. Menus 29
Rle Menu 29
Edit Menu ? 32
Query Menu 34
Help Menu 41
VII. Query 43
Search Formats 43
Single-Folder Queries 44
Cross-Folder Queries 44
Linking 45
WATERS Query Messages 46
VIII. Reports 49
Common Report Features 50
Report Types 52
Schedule Reports — 52
Status Reports 54
Enforcement Reports 57
Well by Well Reports 59
Miscellaneous Reports. : 61
ii WATERS User Guide
-------
Table of Contents
Table of Contents
Acknowledgments vl
i. Introduction to WATERS , 1
Origins of WATERS 1
Version 2.0 Highlights 2
II. User Guide Overview ,. 3
Organization 3
Formatting Conventions 4
III. Installation and Start-Up ..5
Installation Package 5
WATERS System Requirements 6
Installing WATERS 7
Starling WATERS 9
Deleting Test Data.. 10
IV. The Basics of WATERS ; 12
Folders 12
Menus 13
Sample Screen 14
Navigation 14
Function Keys.... 15
Commands 17
WATERS User Guide i
-------
Table of Content?
Menus 85
Rle Menu 85
Edit Menu 87
Reids Menu 89
Color Menu '. 94
XI. HELP 96
On-line Help .-. 96
DOS Trouble-Shooting Tips 98
Rle Handles 98
The SHARE Program 100
UTILITY PACK program 100
Appendix A. WATERS Training Script A-l
A. Moving Between UIC Folders ... A-3
B. Moving Between Pages of a Folder..... A-5
C. Adding a New Well to WATERS A-7
D. Copying a Record A-10
E. Editing a Record A-l 3
F. Listing a Record A-l 5
G. Rnding a Record A-l 7
H. Saving a Query A-20
I. Loading a Query A-21
J. Deleting a Query A-23
K. Deleting a Record A-24
L Printing a Well Schematic A-26
iv WATERS User Guide
-------
Table of Contents
7520 Reports 63
IX. WATERS Mapping System 64
Overview 64
Installation and Start-up 64
System Requirements 64
Installation .64
Navigation 65
Letter Keys 65
Numeric Keypad 65
Function Keys 65
Crosshairs 66
Menus 66
File Menu 67
Edit Menu 68
Query Menu 72
Help Menu.. 74
WMS Utilities 75
Layers Editor 75
MOSS2MI Converter 78
X. WATERS Screen Editor 82
Core Pages 82
Page Names 83
Starting the Screen Editor 84
WATERS User Guide iii
-------
Chapter I. Introduction to WATERS
standard reports to support State/DI program
management and operation needs.
The reports may contain information for a single well,
a group of wells, or all the wells. These reports
enable you to take full advantage of WATERS' query
capabilities to determine which wells should be
included in a report. Some reports also allow you to
choose the time frame, enabling you to print current
reports for management purposes, or past reports
for reference purposes. The Custom Report feature
allows you to create ad hoc reports.
EPA designed the WATERS user interface to minimize
the amount of time you will need to leam and begin
to use the system. It includes a number of visual
effects to help you understand what the system is
doing. It also includes pull-down menus, dialog
boxes, and on-line help.
You can easily add to or edit the well data
contained in the system. In addition, by searching
for the contents of a specific field (or group of
fields), you can retrieve information about a well or
group of wells.
Version 2.0 while WATERS Version 1.0 was designed to track only
Highlights aass n we||s> WATERS 2.0 accommodates all UIC
wells, as well as non-UIC wells. Other new features
of WATERS 2.0 include:
* cross-folder searching
• the ability to add pages and data elements
* LAN compatibility
* mapping capabilities with GIS functions
• ad hoc reporting
• enhanced copying capabilities
• enhanced well schematic drawn to scale
• enhanced features to save and delete queries
2 WATERS User Guide
-------
Table of Contents
M. EPA 7520 Reports A-27
N. Creating a Custom Report A-29
O. Quirting WATERS A-33
Appendix B. WATERS Data Dictionary B-1
WATERS User Guide
-------
Acknowledgments
Acknowledgments
The basis of the Version 1.0 prototype of the Well
Activities Tracking, Evaluation and Reporting Systems
(WATERS) released in October 1991 was the effort of
the Data Management Workgroup which met
during 1989 to develop a minimum data set for the
Underground Injection Control (UIC) program. Many
advanced features and functions are incorporated
in Version 2.0, which reflects many of the comments
and suggestions from potential users and the insight
of the development team. Enhancements include
LAN compatibility, a GIS module, and increased
reporting capabilities (including the 7520 forms).
Contract support for the development of WATERS,
the accompanying documentation as well as the
UIC information management system was provided
by American Management Systems, Inc. of
Arlington, Virginia.
Comments on this document or on the WATERS
program should be directed in writing to:
A. Roger Anzzolin
Project Manager
U.S. Environmental Protection Agency
Office of Ground Water and Drinking Water
Ground Water Protection Division
401 M Street, SW ••^B MC 4602
Washington, DC 20460
Phone: (202) 260-7282
Fax: (202) 260-MI 0732
EPA e-mail: Box 4233
vi WATERS User Guide
-------
Chapter II. User Guide Overview
II. User Guide Overview
This User Guide discusses the features and
capabilities of WATERS and provides guidancetor
using the system. It is organized so that you have
two references for WATERS: the chapters and the
training script {Appendix A). The chapters describe
functions and features, while the training script
provides step-by-step examples of many WATERS
features.
All new users should review the training script before
using WATERS. Users familiar with WATERS can use
the script as a reference. When appropriate, the
chapters will provide the page numbers of
corresponding examples in the training script.
Similarly, the training script will cite the
corresponding chapter that has more in-depth
explanations of each function.
Organization The User Guide is organized as follows:
* Chapter 111 discusses the installation package,
system requirements, installation, program start-
up, and deleting test data.
• Chapter IV briefly discusses the basic
components of WATERS: database modules
(referred to as folders), menus, and navigation,
• Chapter V discusses WATERS' folders for UIC and
non-UIC wells.
• Chapter VI discusses WATERS' menus.
• Chapter VII discusses WATERS' query capabilities.
• Chapter VIII describes the reports available in
WATERS.
WATERS User Guide
-------
Chapter II. User Guide Overview
• Chapter IX describes the optional WATER
Mapping System (WMS).
• Chapter X discusses the WATERS Screen Editor,
which allows users to add screens and data
elements to tolders.
• Chapter XI summarizes the help available tor
WATERS users.
• Appendix A is a training script that provides step-
by-step instructions for many WATERS features.
• Appendix B contains the WATERS database and
field descriptions.
Formatting The WATERS User Guide follows several formatting
Conventions conventions, which are listed below:
• Text you type into the system is underlined (i.e.,
type Install A:).
• Burtons you must press appear as boxes (i.e.,
press I Retum I) .
• References to specific data element names are
in quotes (i.e., enter Y or N. in the "Rule
Authorized "field).
• Prompts and messages from the system appear
in a different font (i.e., c: \WATERS).
• Items of particular interest are identified as tips.
WATERS User Guide
-------
Chapter III Installation and Startup
III. Installation and Start-Up
This chapter describes how to install WATERS on your
PC or LAN and start the program.
Installation The basic WATERS installation package contains the
Package following: one program diskette and one
geographic information system (GIS) data diskette.
If you wish to use the optional WATERS Mapping
System (WMS), you must also obtain a Maplnfo
runtime module from EPA Headquarters or Maplnfo
Corporation. The runtime module includes several
diskettes, installation instructions, and user
documentation.
The WATERS program diskette contains four
programs:
• The WATERS program
This program includes the basic data entry and
query functions, a test database, and the ability
to print reports and produce a well schematic.
• The Screen Editor program
The Screen Editor enables you to add pages and
fields to the core WATERS system.
• The WATERS Mapping System (WMS)
WMS is an optional program that produces maps
of the geographic areas surrounding wells
tracked in WATERS.
* The WMS Layers program
The Layers program enables you to add, remove,
and change the style of geographic features in
WMS maps.
WATERS User Guide
-------
Chapter III. Installation and Start-Up
WATERS
System
Requirements
The GIS data diskette contains your region's
geographical data, which WMS uses to plot maps.
You must have a Maplnfo runtime module to
operate the WMS program. However, you can
install the WMS program prior to obtaining the
runtime module.
TIR:,-:Ypu can obtain a Maplnfo runtime module by
a\ 1PA
The WATERS program diskette and the GIS diskette
are labeled differently so you can easily distinguish
the two. The program diskette depicts a well
schematic and the title PROGRAM'DISKETTE above
the EPA logo. The GIS data diskette depicts a
compass, the title GIS DATA DISKETTE above the EPA
logo, and your region number in the upper right
comer.
This section describes WATERS' hardware and
software requirements. Specifically, WATERS Version
2.0 requires:
• An IBM or compatible 286 machine (a 386
machine or higher is recommended)
• 640K RAM with 570K free
• At least 3 megabytes (MB) of free hard disk
space
• An extended keyboard
• An HP Laser Jet II or III or compatible printer
• A color monitor for correct screen interpretation
• DOS version 3.30 or greater (version 5.0 or greater
is preferable)
See Chapter IX for WMS systems requirements.
WATERS User Guide
-------
Chapter III. Installation and Startup
Installing This section describes how to install WATERS and its
WATERS associated programs on a PC or a LAN, and how to
delete the test data. Generally, the drive which
accepts diskettes Is the A or B drive. Your hard drive
is usually the C drive. For simplicity, this chapter will
assume that your A drive receives the WATERS
diskettes, and your hard drive is the C drive.
Before installing WATERS, be sure that your computer
meets the system requirements discussed above.
"WPs tf you have irouWe boding WATERS, refer to
Chapter XI for additional DOS-related fnstatafion
"" ' s
Follow the steps below to install WATERS, the Screen
Editor, WMS, and the GIS data on an individual PC or
a local area network.
Step f: Insert the WATERS program disk into your A drive.
Step2: Type A: Press t Retam I.
Step 3: Type |nstaj| A: C: and press > Return I
The INSTALL program will create a directory on your
C drive named WATERS, and will then copy the
WATERS program and temporary database files to
the WATERS directory.
Step 4: WATERS will ask: Would you like to install the
WATERS Mapping System now? (Y/N). To install
WMS, type X, press I Retum I, and go to step 5. If
you do not want to install WMS, type N_, press
| Return | ana- go fo sfep 7
Step 5: When the system finishes installing the WMS program
files, it will prompt you to enter the diskette
containing the GIS data. Eject the WATERS program
diskette and insert the GIS data diskette into the A
drive and press I Retum ].
WATERS User Guide
-------
Chapter III. Installation and Start-Up
.Tlw (^ dtatabose requre^4 or5 rnegabytes of
*•„ -. . •*. ... :. ... ,-«. . ^ _ -i»^»U^' «!" .7
use
and
ataterdate. To
your A
At \ prompt.
*Therv fofiow Ihe^program^insiructions to install
CIS data ond The Maprfnfo uptime module,
Step 6; After the data has been installed, the system
displays a screen of information describing the
remaining steps you must take to make WMS
operational. You must:
• Install the Maplnfo runtime module according to
the instructions enclosed with the software
» Edit your autoexec.bat file to include the location
of the runtime module in your path
» Edit your autoexec.bat file to set the CGIPATH to
that of the runtime module.
For more details, see Chapter IX.
step 7: Remove the diskette from your A drive.
WATERS is now available on your C drive. You may
start WATERS and experiment with the test data, or
delete the test data and enter your own data.
If you are installing WATERS on a LAN, please
continue through step 1 1 to assign WATERS to the
network directory you choose.
Step 8: TO ensure WATERS can run properly on your system,
edit your config.sys file to set Files= value to 83.
See Chapter XI for more details.
Step 9: Copy WATERS into the appropriate network
directory.
Step 10: Delete WATERS from your local hard drive.
WATERS User Guide
-------
Chapter III. Installation and Startup
Step 1 1: Type Del *.mem at the DOS prompt for the network
drive to signal the network server that the data is
not on your hard drive.
users frie networ directory your IAN
• r>^.4adrrttrtfefrator chooses *fl replace the c* \HRTERS
£:/3 prompt, ,,\v ;\.v'v-t^ ' i..^ . ,-./..'.. .
Network administrators should inform users of how to
access WATERS on their particular network.
Starting Follow these steps each time you want to start
WATERS WATERS:
srep 1: Type £; (or specify the appropriate network drive)
and press I Return j
Sfep 2: Type CD\WATERS and press | Return |
You are now in the WATERS directory, as indicated
by the c : \WATERS prompt on your screen,
Step 3; YOU will only need to perform this step the first time
you start WATERS. It will prompt you to Please
enter the full path to the data. Press
} Return ] jf yOU have followed the installation
directions in this chapter and are not accessing
WATERS on a network. This signals to the computer
that the data path is c : \WATERS, However, if you
are a PC user and you did not follow the instructions
described above, or you are using WATERS on a
LAN, the data may be in a directory other than
c : \WATERS. Type the path to that directory and
press I Retam I.
steP 4: Type WATERS at the c : WATERS prompt and press
( Return "1
You have just instructed your computer to load
WATERS. While it is loading, a start-up screen with
the name of the program will appear on your
monitor.
WATERS User Guide
-------
Chapter III. Installation and Start-Up
i^ 4obd
use .of the Screen€cfitor,ttie Joodfog process wil
tokc i longer becouse WATERS must emote
Once WATERS is completely loaded, you will see the
Permits screen shown below in Exhibit III -1. The
system displays the first well in the database (sorted
by the "Well ID"). If there is no data in the
database, the screen will display a blank record.
Exhibit III • 1: Permits Screen
n
termits | | Inv«ncory | J I n» pact ion | | ICT | | Compi/Ent || Operations |
1
:
i
*
«
•
•
•
•
•
•
*
. „_,,._, „
5 Rule Authorized N
in Application Number 867585 Hell Identifier OT02337
SO Permit Number UT897S6«7W Type of Hell Frmtd Converted
§ Type of Well Permit Individual Class 2
•Q No. of Wells/Permit 1 Type 2H Liquid Hydroc
R5
§ Application Date 1967/04/05 Technical Review 1967/01/15
5j Date Permit Issued 1967/07/26 Public Sotice 1967/06/18
*D Date Permit Effective 1967/08/25 Public Hearing 1967/07/17
!§ Date Permit Modified 1969/07/07 Permit Term 5 Years
"fj Type of Permit Hod Permit Tra Expiration 1993/03/17
tO
•O Date Plugged/Abandoned / / Date Permit Denied / /
& Commercial Facility N Date Withdrawn / /
Won-UIC |m*N«nu|
•LzL±
PqUti
IT
a
2
U
Deleting Test
Data
Step 1:
Step 2:
The test database that is automatically installed with
WATERS will be very useful to you while you are
learning how to use the system. However, when you
are ready to begin entering your own data into
WATERS, you must delete the test data. Follow these
steps:
At the DOS prompt, type £; and then press
I Return |
Type CdXWATERS and press
Return
10
WATERS User Guide
-------
Chapter III. Installation and Startup
On your screen, c : \WATERS will appear. This is
called the c : WATERS prompt. It indicates that you
are in the WATERS directory.
3: Type utility Delete and press I Retuin I.
This command executes a program to delete all
existing data in all of the WATERS databases. Before
doing so, it will prompt you to confirm that you wish
to delete the records.
Type 1 to continue.
TIP: If you use the Utffity Delete program after you
* < . , . . ' begin adding your own data, you vviB delete your
.-. , own data! J{% ,.„-;.. «, /• "/":''
Step 4: Type C:\ WATERS and press | Retum | You have
now returned to the c : \WATERS prompt.
You are now ready to enter your own data into
WATERS.
Back up your WATERS data regutariy. WhSe the
programs cartbe reirataBed from did
-------
Chapter IV. The Basics of WATERS
IV. The Basics of WATERS
Folders WATERS contains two modules of data: one for 'C
wells and one for non-UIC wells. The data are
separated into folders according to UIC progrc •-.
activities. There are six folders for UIC wells and one
for non-UIC wells. The UIC folders are: Permits,
Inventory, Inspection, Mechanical Integrity Tests
(MIT), Compliance/Enforcement, and Operations
The non-UIC folder contains both permits and
Inventory information. A folder contains a screer or
a series of screens with data about individual wells.
Each folder is identified by tabs or labels that
appear near the top of the screen. All tabs are
visible regardless of which folder you are currently
accessing.
To access the UIC data, type M. To access non-UIC
data, type M- Once in the UIC dataset, select a
folder by typing the highlighted letter of its title (i.e.,
£ for Permits). When you access the non-UIC data,
you automatically access its one folder. Just as you
can flip through sheets of paper to see the contents
of a paper folder, you can flip through screens to
view the contents of the computer folder. WATERS'
visual effects appear to slide the screens into place.
Each well has only one Permits and Inventory
record, each containing multiple pages of data
elements. In contrast, the other folders have only
one page of data elements but may contain
multiple records for each well. Use the number keys
or | Pay Up I and |PafieDown|to move between
pages; they will appear to move horizontally across
the screen.
12 WATERS User Guide
-------
Chapter IV, The Basics of WATERS
Menus Four menus contain WATERS functions for operating
the system. Their names are always visible in the
upper left comer of the screen. They are as follows:
Menu Functions
File Menu Systems administration,
information and
control functions.
Ed/f Menu Database modification
functions.
Query Menu .Query and reporting
functions.
Help Menu Help text file.
The functions in these menus are described in more
detail in Chapter VI.
WATERS User Guide 13
-------
Chapter IV. The Basics of WATERS
Sample Screen
The exhibit below highlights the key components of
WATERS' user interface.
Exhibit IV" 1: Sample Screen
Menu
\
Active foUer (MIT)
Operator -
name
rile
Hit ttoery •* .-^.—.wnn R.te^«^=.=,m.,,..,..«.=. (--).-
femics 1 Inventory (inipecucfi || KT 1 1 Ceaml/&3f [Operation* |
I
a
i
i
i
i
•
•
a
•
•
m
•
BO Hell Identifier irrOZJil
^ Mte tacord Uxhttd HSO/12/1J
0 NIT Hitaeswd T
Q Injector Mot/Mo. Dm Oadvick/tO?
g OU*/tewlt of Lot KIT »i7/g(/li PeiMd
Q Uat Corrtctiv* letuo / /
53
0 Both Ft t Tec Cfcpltd/tetcsc T N
Q Bttt/tecult of UH: Teu mo/01/14 PuMd
Q Type of Uok Tut Cuiog /Tubing Preccui*
6 tote/iiBilt of Fluid Kif T»ft mo/03/li PtiMd
Q Type o! Fluid Migration TME Oirrent Itcord Htviw
0
C Mte of l«tdi*l Action l»8»/01/23
iO Type ot loedial Act ion Tubing/Packer
Ti' JWC';;;:} ioa-UIC [ switch to Mcbuiexl Integrity Ttfti tor tin Hell|
^--*
**j
31—
P
S
H
Active
.RntMrTmord
tor Ml
^^RES! piQO o f9cooj
(*Hat
Second page
of racora
Total nutrfcer of
S^IJ MITreconisfof
Massage box
Navigation
You navigate in WATERS by using your keyboard.
Generally, pressing and releasing a key performs an
action once. Holding the key repeats an action.
For instance, if you hold the \r*z*D°vm\ key, WATERS
will continue to flip through multiple pages of a
folder until you stop pressing I fage Down 1
14
WATERS User Guide
-------
Chapter IV. The Basics of WATERS
Letter and Number
Keys
A through Z
Number Keys
LUtoQ
OH
You can use the number and letter keys to navigate
through WATERS.
Press the highlighted letter of any title, menu item, or
folder name to access that item. For example, press
£ to move to the Permits folder or press I to move to
the Inventory folder. Pressing £ will bring up the Edit
menu. Letter keys will work from any point in the
system except when you are editing a recordT
constructing a query, or building a custom report.
You must finish editing the record, or complete the
query or custom report before you are able to use
the letter keys to navigate the system. If you wish,
f0 cancel your
you can use the I escape
editing, querying, or custom report session.
You may also use the number keys to navigate
through WATERS.
Flips through multiple pages of a folder.
Moves to the previous record in the current folder.
Moves to the next record in the current folder.
Function Keys
You can use a number of function keys to navigate
your way through WATERS.
Flips through pages of a folder in reverse order to
show the previous page or screen. For example, the
Inventory folder has six pages. If you are on the fifth
fourtn page.
page, press I
gef
You can also use the number keys to move between
pages.
If you are on the first page in the folder, I fagetjp j
will move to the last page of the previous folder. For
example, if you are on page one in the Inventory
folder, I Fageup TWJH move you to the last page in
the Permits folder. You cannot use I PageUp 1 jf yOg
are on the first page in the Permits folder.
WATERS User Guide
15
-------
Chapter^ IV. The Basics of WATERS
| Page Down |
| Escape |
| Return |
| Enter |
I
[FS"
Rips through multiple pages of a folder to show the
next page or screen. For example, the Inventory
folder has six pages. If you are on the second page,
press iraggPow"! to get to the third page. You can
also use the number keys move between pages.
If you are on the last page in the folder,
will move you to the first page of the next folder. For
example: If you are on page six in the Inventory
folder, I F*ge PQ™" will move you to page one in the
Inspections folder.
Returns you to the main menu. This function key is
useful if you decide not to select a menu option. For
example when you access a menu, you can use
to return to the main menu if you decide
not to select any of the menu options. Removes a
pop-up window when a cancel option is available.
Selects a title or item when it is highlighted. Moves
the cursor to the next field you can enter or edit
during data eniry, find, and custom report mode.
You can also use the tab key to move to the next
field.
Selects a title or item when it is highlighted (same as
return).
Moves the cursor to the next field you can enter or
edit during data entry, find, and custom report
mode. You can also use the tab key to move to the
next field.
Accesses on-line help.
Accesses the link menu.
Switches folders when constructing a link and when
searching across folders.
Marks fields for inclusion in custom reports.
Displays criteria for link.
16
WATERS User Guide
-------
Chapter IV. The Basics of WATERS
land!
land
Commands
Control
l-w
Control
Highlights the appropriate menu or folder. Press
I R**"™ I to select that item.
Moves you vertically through menu options and
fields in the edit, query, and custom report mode.
Press I Return 1 fO se|ect that item.
There are also a series of control-character
commands that can also help you make your way
through WATERS.
Displays a dialog box when you have entered,
edited, or copied a record. This box allows you to
save, cancel, or edit the record.
Displays a dialog box when you have entered
search criteria. This box allows you to submit, clear,
or edit the query criteria.
You may also use i controri . I fcn<* i
Displays a dialog box when you have entered,
edited, or copied a record. This box allows you to
save, cancel, or edit the record.
Displays a dialog box when you have entered
search criteria. This box allows you to submit, clear,
or edit the query criteria. You may also use
I Control""] . yy
WATERS User Guide
17
-------
Chapter V. WATERS Folders
V. WATERS Folders
This chapter describes all the folders in WATERS,
giving data elements, validity checks, and other
details and requirements for both UIC and non-UIC
wells. For UIC data, the chapter also describes how
the folders are related.
UIC Folders The six UIC folders in the WATERS system are Inter-
related because most UIC wells that you track will
have data in all folders. WATERS enables you to
relate the events in a folder (e.g., the inspections
records in the Inspection folder) to the wells to which
they apply. Each well must have one (and only
one) record in the Permits and Inventory folders.
These folders hold much of the basic information
about the well that seldom changes, such as permit
conditions, location, construction, and ownership.
This data is stored on multiple pages or screens,
which you can access using the I rage up ~\
If age Down i / or numDer keys.
In contrast, the Inspection. MIT. Compliance/
Enforcement and Operations folders may contain
multiple records for each well. This is because these
folders track recurring events for a well, such as
inspections, MITs, violations, and enforcement
actions. Each of these records is only one page in
length.
TIP: You can add pages toc^corcb fl
MIT, Conipfence/Enfprcement *wd
> folders by using ihe 5creeri;JEdltGr
Editoris
-------
Chapter V. WATERS Folders
links these events to the basic well information in the
Permits and Inventory folders.
WATERS' user-friendly interface enables you to
quickly and easily move between folders for a
specific well. You can also move through a specific
folder to view information about multiple events or
multiple wells. When you switch to a different folder,
you will see the data for the same well you were
viewing in the previous folder. For the folders with
the potential for multiple well records, you can also
move between well records in the folders to see
data on individual events related to that well. While
in any folder, you can move to the next well by
using the I * I and ' " ' keys.
When you move from folder to folder, you might try
to view a folder that contains no information for the
current well. If this happens, WATERS will display a
blank record in that folder with the Well ID in the top
right comer. You can instruct WATERS to change to
another folder by pressing the appropriate letter in
its title, or you can view a different well in the current
folder by pressing the I * I and ' " I keys (or
using the Query menu options to select a well).
TIP: To print
-------
Chapter V. WATERS Folders
Permits The permits folder consists of four pages of data
elements. The first page contains well identification
and permit application data elements. The second
page contains data elements on the well's allowed
operating parameters and permit conditions. The
third page contains financial responsibility data, and
the fourth page contains free-form comments.
WATERS automatically enters this folder upon start-
up. Type £ to get to the Permits folder if you are
working in any of the other UIC folders.
Since permits are the starting point of UIC tracking
and monitoring activities, the Permits folder has
several requirements and features to ensure that
WATERS adequately supports program functions.
These requirements are:
1. Each well MUST have a Permits record. WATERS
will not allow you to enter information into the
other folders until you have entered Permits data
for that well.
2. Every well MUST have a unique Well ID. This is the
key WATERS uses to track each well and to link
each event (i.e., violations, enforcement actions,
inspections) to a specific well.
3. For rule authorized wells, the only open fields on
the first page are "Well Identifier", "Type", "Date
Plugged", and "Commercial Facility".
4. For wells requiring a permit, you can enter data
into any of the open fields on page one. You
cannot save the well record unless you enter the
following fields:
• "Rule Authorized"
• "Permits Well ID"
5. WATERS automatically calculates the field "No. of
Wells/Permit". It determines how many wells
have the same permit number and displays that
value. When you add additional wells under that
20 WATERS User Guide
-------
Chapter V. WATERS Folders
area permit, WATERS automatically updates this
field.
6, The "Well ID" and the "Operator Organization"
are displayed at the top of the screen regardless
of the current folder.
WATERS verifies data when you attempt to save a
record. You can enter invalid data; however,
WATERS will not allow you to save the record. When
you save a new or updated record, some of the
data fields are automatically checked for accuracy.
An error message appears if there is a discrepancy
in the data. When it detects an error, WATERS
automatically places the cursor at the appropriate
field so you can re-enter the data without having to
search for the appropriate field. Error checks for the
Permits folder ensure that:
• Required fields are entered (i.e., "Rule
Authorized", "Permits Well ID", "Well Class" and
"Type").
• The "Permits Well ID" and "Application Number"
are unique.
» Salt Water Disposal wells are not "Rule
Authorized."
• "Expiration Date" is later than "Date Permit
Effective".
• "Date plugged/abandoned" is earlier than the
data entry date.
• "Well Class" and "Well Type" match.
• "Latitude" is between -90° 00' 00" and 90° 00'
00".
» "Longitude" is between -180° 00' 00 and 180° 00'
00".
• The minutes value for "latitude" and "longitude"
is less than 60'.
WATERS User Guide 21
-------
Chapter V. WATERS Folders
• The seconds value for "latitude" and "longitude"
is less than 60".
Bates am In fhe.' tojro of Yeac/Monlh/Day. tfyou
>. "try H>-enlat4h0*Jat* in a different form, WATERS
" % v ••' : ' •
When you finish entering the well's Permits data, you
must save the record in one of the following^hree
ways:
Press I F*&* UP 1 until you reach the first Permits
screen. Then press I r«seup 1 once more.
Press irageoowiii ynti| yoy reacn ^e |ast permits
screen. Press, iragepovm once more.
• Use the I confion. w or
I End 1 key sequences.
After you perform one of these actions, a dialog box
appears on the screen asking you if you wish to save
your changes. Select Yes.to save the new
information. Select No to delete the information you
just added. To return to the screen to make
changes, select Cancel. Choose the option by
highlighting it and pressing I Ketnm ~]
WATERS automatically creates a record in the
Inventory folder when you add a new well to the
Permits folder. You should enter the Inventory data
after entering the Permits data for a new well. Some.
data elements entered in the Permits folder are
automatically displayed on screens in the Inventory
folder for reference purposes. These fields are:
"Well ID", "Permits Number", "Rule Authorized", and
"Latitude" and "Longitude" of the well. However,
these fields can only be edited in the Permits folder.
Any changes are automatically reflected in the
Inventory folder.
22 WATERS User Guide
-------
Chapter V. WATERS Folders
Inventory
Construction
Information
The Inventory folder contains five types of data
elements displayed on six pages. They are well
identification, owner and operator data,
construction data, geological data, and
hydrogeological data. To access the Inventory
folder, type L
You cannot copy a well's record from the Inventory
folder without copying its Permits record because
the Permits and inventory information are
interrelated. When you try to use the copy function
in the Inventory folder, WATERS will automatically
move you to the Permits folder, where you can use
the copy function for both folders.
When you are entering or editing data in the
Inventory folder, WATERS performs error checks on
the data as it did for Permits. The error checks
ensure that the data in the Inventory folder are
accurate and meet the following requirements:
• The "Date Well Drilled" cannot be earlier than the
"Date Permits Issued".
* "Date Well Drilled" must be later than the "Date
Permit Effective".
• The "Date of First Injection" cannot be earlier
than the "Date Drilled".
• The "Date of First Injection" cannot be earlier
than the "Date Permit Effective".
* The "Date of First Injection" cannot be earlier
than the "Date Permit Issued".
• "Packer Depth" cannot exceed "Total Depth".
• "Packer Depth" cannot exceed "Plug Back Total
Depth".
• "Plug Back Total Depth" cannot exceed Total
Depth".
• "Surface Casing Diameter" must be greater than
the "Intermediate Casing Diameter".
WATERS User Guide
23
-------
Chapter V. WATERS Folders
Geological
Information
Hydrological
Information
"Surface Casing Diameter" must be greater than
the Long String Casing Diameter".
"Surf ac Casing Diameter" must be greater than
the "I, -g Diameter".
"Intermediate Casing Diameter" must be greater
than the "Long Sting Casing Diameter".
"Intermediate Casing Diameter" must be greater
than the "Tubing Diameter".
"Long Siring Casing Diameter" must be greater
than the "Tubing Diameter".
"Surface Casing Depth" must be greater than.
the "Total Depth".
"Intermediate Casing Depth" must be less than
"Total Depth".
"Long String Casing/Liner Depth" must be less
than "Total Depth".
"Tubing Depth" must be less the- "Total Depth".
"Injection Interval" must be wit" r- the "Injection
Zone".
"Confining Zone" must be above "Injection
Interval".
"Total Thickness" cannot be less than zero.
"Thickness of USDW" cannot be less than zero.
"Intervening Thickness" cannot be less than zero.
24
WATERS User Guide
-------
Chapter V. WATERS Folders
Multiple Record
Folders
Inspection
The Inspection, MIT, Compliance/Enforcement, and
Operations folders contain only one core page of
data elements; however, each may contain
multiple records for a specific well, each
represented by a single page or screen. For
example, wells inspected more than once will have
multiple records in the Inspections folder. To add a
record to these folders* a Permits record must exist
for the well.
Two options are available to determine if there are
multiple records for a specific well. First, a number
tab will appear along the right margin of the record
when there are multiple records for a well. Press
I p*se UP I or |r«seDowni to view these separate
records. Second, use the List option in the Query
menu to browse through all of the existing records. If
you see the same well identifier listed more than
once, then several records exist for that well. To
view a record, highlight it using
press
land
and
Return
While there are similarities across these folders, they
also have unique features: type of data, method of
access, and error checks. The next sections
describe these features.
The Inspection folder contains the name of the
inspector, the date and type of inspection, and the
outcome of the inspection.
The error checks ensure that:
* Required fields are entered {i.e., "Well ID" and
the "Date of Inspection").
• The combination of "Well ID" and "Date of
Inspection" is unique.
WATERS User Guide
25
-------
Chapter V. WATERS Folders
MIT The MIT folder contains the name of the inspector, a
record of the well's past tests, current test results,
and remedial actions from the current test. WATERS
automatically calculates the "Date/Result of Last
Ml?1 and "Last Corrective Action Date" fields in the
MIT folder. These fields cannot be edited.
WATERS reviews MIT records with the same "Well
Identifier" and retrieves the date and result of the
most recent MIT test and the most recent "Date of
Remedial Action" from the MIT folder. WATERS also
automatically generates the "Multiple Enforcement
Actions" field, alerting permit writers to recalcitrant
violators. A Y in this field indicates that more than
one enforcement action was needed to bring this
well back into compliance.
Error checks ensure that:
• Required fier: are entered (i.e., "Date Record
Updated" ana the "Well Identifier").
• The combination of the "Date Record Updated"
and "Well Identifier" is unique.
* A well passes both the fluid migration and the
leak test to have a complete two part test.
Compliance/ The Compliance/Enforcement folder contains data
E! nforcdun &n t
elements for violations, penalties, and enforcement
actions. In this folder, the pop-up list for the "Type of
Violation" field has violations marked with an asterisk
(*). This indicates that these violations are potentially
instances of Significant Non-Compliance (SNCs).
• Dates cannot be entered into both the "Date
Final" and "Date Withdrawn" fields.
» Required fields are entered:
1. "Type of Violation Occurred/Verified"
2. "Date Violation Occurred/Verified"
3. "Type of Enforcement Action"
26 WATERS User Guide
-------
Chapter V. WATERS Folders
Operations
Non-UIC Folder
4. "Date Enforcement Action Taken"
5. "Well Identifier"
• A combination of the following fields is unique:
1. "Date Violation Occurred/Verified"
2. "Date Enforcement Action Taken"
3. "Well Identifier" —
The Operations folder contains operating status
data, and fluid volume, rate, and pressure
information. Error checks ensure that:
• Required fields are entered (i.e., ''Well Identifier",
"Date Status Effective", and the
"Owner/Operator Number" fields).
• The combination of the "Well Identifier" and the
"Date Status Effective" is unique.
WATERS tracks a variety of non-UIC wells, including:
• Underground storage tanks
• Production wells
• Monitoring wells
» Drinking water wells
» RCRA facilities
• Superfund sites
• Manufacturing plants
« Industrial complexes.
Non-UIC data is stored in a single folder. It has three
pages containing a limited amount of data for well
identification, location, owner/operator information,
and general comments. To access the non-UIC
data, type H or use
option and press C
and I****! to highlight the
WATERS User Guide
27
-------
Chapter V. WATERS Folders
Many of the features of the non-UIC folder are
identical to those of the UIC folders. Like the Permits
and Inventory folders, the non-UIC folder has
multiple pages but only one record per well. You
use the same keys to navigate the folder, and have
the r.c.me menu options (see the next chapter).
WATERS also performs error checks in the non-UIC
folder.
Error checks ensure that:
• Required fields are entered (i.e., "Well Identifier".
"Latitude", and "Longitude" fields).
* The "Well Identifier" is unique.
• "Latitude" must be between -90° OO'OO'' and 90°
OO'OO."
• "Longitude" must be between -180° OO'OO'' and
180° OO'OO."
• The minutes value for "latitude" and for
"longitude" must be less than 60'.
* The seconds value for "latitude" and for
"longitude" must be less than 60".
28 WATERS User Guide
-------
Chapter VI. Menus
VI. Menus
This section describes the four menus WATERS uses to
administer, maintain and navigate the system: File,
Edit, Query and Help. You can select a menu by
typing the capitalized/highlighted letter in its title: £
for File, £ for Edit, Q. for Query, and H for Help.
You can also select menu options by using the 15J
and LU to highlight your choice and pressing
I Return |
File Menu The File menu allows you to customize portions of
WATERS' user interface and provides you with quick
access to information about the data and the
system.
To access this menu, type £. You cannot access the
File Menu by typing F if you are editing a record,
constructing a query, building a custom report, or
viewing another menu. Exhibit Vi-1 shows WATERS
with the File menu open.
WATERS User Guide 29
-------
Chapter VI. Menus
Exhibit VI -1: File Menu
?m&^®mmmm
Tally
Backu
P
Turn Effects Of!
Sec Verify Off
tort Configuration
clock
Quit
I
•
:
a
•
i
^ - * ^
entory II Inspection | | MIT || corapl/Ent | | Operations
lied N
Hunber 147853 Well Identifier OT023S3
er UT1234A Type o£ Well Prmtd Converted
1 Permit Area class 2
a/Permit 3 Type 2R Enhanced Reco
O Dat* Permit Issued / / Public Notice / /
O Date Pern;:. Effective / / Public Hearing / /
Q Data Per-.: Modified / / Permit Terw 10 Years
D Type of .-omiit Mod Expiration / /
JJ Date Plugged/Abandoned / / Date Permit Denied / /
V Commercial Facility N Date Withdrawn / /
"VtEIS.-; .j] »on-UIC (Display Current WATERS v«rsion Reference number ]
i
u
3
3
Pgt)nl
Version
The File menu contains the following options:
• Version
• Tally
• Backup
• Turn Effects Off/On
• Set Verify Off/On
• Port Configuration
• Clock
• Quit
To select a menu option, use LLJ and LU to
highlight the option you wish to select and then
press I Return 1 or press t(-,e highlighted letter of
the option's title.
The following section describes each of these
options in detail.
Displays the current version of WATERS and the
release date.
30
WATERS User Guide
-------
Chapter VI Menus
Tally
Backup
Turn Effects Off/On
Set Verify Off/On
Counts and displays the number of records In each
folder. The Permits and Inventory folders will have
the same number of records because an inventory
record is created automatically each time a new
well is added to the Permits folder. Since each well
has only one Permits record, the number of records
in the Permits folder is also the number of wells
tracked in WATERS.
Tally counts events in the Inspections, MIT,
Compliance/Enforcement, and Operations folders.
The tally given for each of these folders represents
the number of events for all wells.
The tafy may include deleted records tf you hove
not used the UTILITY PACK program since deleting
WATf RS records, the UT1UTY PACK program is
described in Chapter XI.
Creates a backup copy of your WATERS data. You
must use a formatted disk to backup data.
Turns the visual "effects" (flipping pages and sliding
folders) off and on. The default for this option is on.
Turning these effects off can increase the speed of
navigating through the system. The menu option
changes to reflect the current choice. For example,
if you have turned off the effects, the menu option
reads Turn Effects On. If you turn the effects on, the
menu option reads Turn Effects Off.
Turns verification on and off. The default for this
option is on. When verify is turned on, WATERS asks
you to confirm your choice any time you delete, edit
or save a record. WATERS will not ask you for
confirmation if you turn verify off. You can turn
verification off when you are making similar changes
to many records and do not want to verify each
change. The menu option changes to reflect the
current choice. If you have turned verify off, the
menu option will read Set Verify On. If you turn verify
on, the menu option reads Set Verify Off.
WATERS User Guide
31
-------
Chapter VI. Menus
Port Configuration
Clock
Quit
Edit Menu
Selects printer port for printing. The default is LPT 1,
Displays the current date and time of the internal PC
clock in a pop-up window.
Closes WATERS and returns you to DOS.
The Edit menu contains all of the options to add,
modify and delete UIC well data (see Exhibit VI-2).
Exhibit VI - 2: Edit Menu
File
£
i
i
i
i
i
i
i
i
i
i
-Op
s
nm^o"
***«
Bopy "'
Sdit
Delete
fable
rized N
lO Application Number 147853 w*ll Identifier OT0215J
B Permit Number OT1234A Type of Hell Pi-mtd converted
,_ Type of Well Permit Are* Class 2
i0 No. of Mel I*/ Permit 3 Type 2ft Enhanced Reco
=0
J? Application Date / / Technical Review / /
3?5 Date Permit Issued / / Public Notice / /
25 Date Penult Effective / / Public Hearing / /
Jg Date Permit Modified / / Permit Term 10 Year*
-------
Chapter VI. Menus
To select a menu option, use L2J and LU to
highlight the option you want and then press
I Return 1 you can also press the highlighted letter
of its title.
The following section describes each of these
options in detail.
Add Create a blank record into which you can enter
new well data. When you select add, the fields you
can enter data into turn red. To enter owner,
operator or guarantor data, press LEU while
positioned on these fields to access the Owner,
Operator, or Guarantor table, and select the
appropriate name. See Appendix A, Section V for
detailed instructions on adding records.
TIP: To odd or eo5r a name In the Owner, Operator or
Guarantor tables, access the Table option which
--'" b discussed beJow. '
Copy Copies information from a current record to a new
record. This feature enables you to avoid retyping
data if a well with similar characteristics is already in
the database. WATERS displays the fields that can
be edited in red. After you copy a record, you must
change information in some of the fields to ensure
that the record is unique. For instance, in the Permits
folder, all wells must have a unique well ID. In the
MIT folder there must be a unique well ID and date
updated combination. See Appendix A, Section VI
for detailed instructions on copying records.
TIP: You cannot copy a wel record In the Inventory
folder without copying the Wei's Permits folder
record because the Permits and Inventory
information are Interrelated. When you try to use
the copy function in the Inventory folder, WATERS
wi automaticafty move you back to the Permits
folder, where you can use the copy function for
both folders.
WATERS User Guide 33
-------
Chapter VI. Menus
Edit
Delete
Table
Query Menu
Enables you to change the information in the fields
of an existing record. Use the navigation keys to
move to the desired field; however, you must use
the Table function to edit owner, operator, and
guarantor fields. See Appendix A, Section VII for
detailed instructions on editing records,
Deletes a record. When issued from the Permits and
Inventory folders, this command deletes all the"
records for that well from every folder. When issued
from the Inspection, MIT, Compliance/Enforcement,
and Operations folders, it deletes only the specified
record. The option prompts you to verify your
choice before deleting. Press X to delete. Press H or
I to abort the deletion. WATERS will not
ask you to confirm your choice if you have selected
the Set Verify Off option in the File Menu. See
Appendix A, Section VIII for detailed instructions
about using the delete command.
Enables you to edit, add, list, and delete
owner/operator and guarantor information from a
lookup table. This information can be edited only by
using the Table function.
The Query menu contains functions that allow you to
search for wells by characteristics you specify, and
produce a variety of reports based on all wells or a
subset.
You can access this menu in two ways:
• Use the l*^"l and I "^H to highlight the Query
menu, and press I Return ~|
* Type Q. You cannot access Query menu by
typing £ if you are editing a record, constructing
a query, building a custom report, or viewing
another menu.
Exhibit VI-3 shows WATERS with the Query menu
open.
34
WATERS User Guide
-------
Chapter VI Menus
Exhibit VI - 3: Query Menu
rile \ Edit
F
i
:
•
*
•
:
:
:
•
•
i
limits 1
__ IWM
:O Rule Au
!Q
: n?
:|9*W^f!}J lelp (=.===
i^ife?t:%is p;;i*i5: %
Find
Clr Find
Deplain Criteria
Stve Query
Uud Query
Delete -Query
Load Custom Report
Delete Custom Report
Reports
•ell Schematic
OIS
.===i=«=«HATEES State Syscam-==i=»i==i==i====.«== 4- . ,_
on J^| HIT |J Compl/£nf || Operations [
l,,«u Well Identifier OT02353
2135W fypg Of Mejj pmtd Converted
Class 2
Type 2R Bihanced Reco
/ /
/ Technical Review / /
/ Public Notice / /
/ Public Hearing 10 Years
' Permit Term / /
Ejfniration
8f ^^^^^^^^^^^m : /
Date Plugged/Abandoned / / Date Permit Denied / /
;Q ConiBercial Facility H Date withdraw
PlUlllPf »on-OIC (List Records]
1
'gupj
3
1
n
Q
>qDrTl
The Query menu contains the following options:
• List
• Find
• Clear Rnd
• Explain Criteria
• Save Query
• Load Query
• Delete Query
• Load Custom Report
• Delete Custom Report
• Reports
• Well Schematic
• Geographic Information System (G1S)
WATERS User Guide
35
-------
Chapter VI. Menus
There are two ways to select a menu option:
• Use Lil and LU to highlight the option you wish
to select and then press I Return ~[
* Press the highlighted letter of the menu option's
You cannot choose menu options That are not
^ to exarr&*. you cannot Detect the
Delete Query option unless you No** taftaved a
, query. Options you cannot seidctjare shaded in
the menu, and doTiot havw^atohVWghlohtcd In
thettWw. -V.^-.TT'-'
The following section describes each of these
options in detail,
List Displays a table of key information about all active
well recorc: the cc :ve folder. You can scroll up
and down the list using LU and ULl or by typing a
part of the "Well ID". If you want to see one
particular well's records, scroll down to its line and
press l Ketum "] jf yOU want to see several wells'
records, press I Control i_ | Enter i When you
highlight a record. This will place a check-mark next
to the ID number of that well. When you press
I Return vou wj|| see ^e record of the first well
you check-marked. Your database will be limited to
the check-marked records until you select the Clear
Find option explained below.
Tu r lable on the following page outlines what
information the List option will show when you are in
each of the folders:
36 WATERS User Guide
-------
Chapter VI. Menus
Folder
Fields Displayed
Permits
"Well ID"
"Permits Number"
"Owner/Operator"
Inventory
"Wei! ID"
"Permits Number"
"Owner/Operator"
inspection
"Well ID"
"Date of Inspection"
MIT
"Well ID"
"Date MIT Record Updated"
Compliance/
Enforcement
"Well ID"
"Date Violation Occurred"
"Type of Violation"
"Date of Enforcement Action"
"Type of Enforcement Action"
Operations
"Well ID"
"Date Operating Status Effective"
Find
TVs The Ust function displays the Operator if one exists.
If the record does not contain operator
informolKm, ft fists the Owner. WATERS displays
Op: or Ow. before the organization name to
indicate which is shown.
See Appendix A, Section F for detailed instructions
on using the list function.
Locates records in the current folder based on
criteria you specify. You can search in all WATERS
fields in which you have entered data and across
multiple folders to locate information. For more
detailed explanations on the types of queries you
can perform, see Chapter VII.
WATERS User Guide
37
-------
Chapter VI. Menus
Explain Criteria
Clear Find Clears the current query. Use the Clear Find option
to regain access to the complete dataset. This
option is only available when a query is active.
When the Clear Find option is not available, the
menu option will be shaded and no letter of its title
highlighted. When the Clear Find option appears in
the menu, it indicates that you are not working with
the entire database.
Ttfh When a query fc active, the word "Find" appears
in the top rtght comer of you screen.
Lists the selection criteria of an active query. When
you select this option, a window appears at the top
of the screen listing your current selection criteria.
This option is only available when a query is active.
When the Explain Criteria option is not available, the
menu option will be shaded and no letter is
highlighted.
Save Query Saves an active query. This option is beneficial
when you want to retain your search criteria. When
you choose the Save Query option, a dialog box
appears in the middle of the screen asking you to
name the query. The name you choose will also be
used in the Load and Delete Query options
explained below. As in the Clear Find and Explain
Criteria options, you can only save a query after you
have performed a search with the Find option.
Load Query Retrieves and executes a previously saved query.
This option lists all saved queries in alphabetical
order. You can scan the list of query names and
select one to retrieve, which automatically begins a
search. Under the Load Query option, WATERS
replicates the search steps it does with the Find
option.
38
WATERS User Guide
-------
Chapter VI. Menus
Delete Query
Load Custom
Report
Delete Custom
Report
Reports
Well Schematic
Deletes a saved query. This option lists all saved
queries in alphabetical order. You can scan the list
of query names and select one to delete. WATERS
asks if you to confirm that you want to delete the
query. If you select Yes, your query will be deleted
and cannot be retrieved. WATERS will not ask you to
confirm your choice if you have selected the Set
Verify Off option in the File Menu.
Retrieves one of the customized reports previously
saved when using the Report menu option. This
option lists all saved reports in alphabetical order.
You can scan the list of report names and select
one to load. Loading the report automatically runs
the report so you do not have to recreate the
criteria.
Deletes a saved customized report. This option lists
all saved reports in alphabetical order. You can
scan the list of report names and select one to
retrieve. WATERS asks you to confirm the deletion. If
you select Yes, the report is deleted and cannot be
retrieved. WATERS will not ask you to confirm your
choice if you have selected the Set Verify Off option
in the File Menu.
Produces a variety of reports, including EPA's
Federal reporting forms, a variety of management
reports for local program use, and the ability to
design custom (ad hoc) reports. More detailed
information on reports can be found in Chapter VIII
and in Appendix A, Sections M and N.
Produces a diagram of the well on your screen. The
diagram displays the well's specific measurements,
dimensions and hydrogeological data based on the
data in its Permits and Inventory folders. You cannot
edit the well schematic when it is displayed on your
screen. To change a well schematic, you must edit
the data in the Permits and Inventory folders.
General Class II construction is used for all well
schematics. The well schematic displays up to three
WATERS User Guide
39
-------
Chapter VI. Menus
USDWs, two confining zones, and two injection
intervals. The specific elements displayed in the well
schematic are:
• "Well Owner/Operator Name"
• "Well Identifier"
• "Surface elevation"
• "Range of the USDW"
• "TDS of the USDW"
• "Range of the confining zone"
• "U'thology of the confining zone"
• "Surface casing diameter" (inches), "depth"
(feet) 3-d "grade"
• "Inter- ^diate casing diameter" (inches),
"depth" (feet), and "grade"
• "Long string casing/liner diameter" (inches),
"depth" (feet) and "grade"
• "Tubing diameter (inches), "depth" (feet) and
"grade"
• "Packer depth"
• "Total depth"
• "Injection interval" (feet)
TIP: WATERS dbptays the Operator if one e&ts, and
puts an -Op:* before the name: othetwbe. ft
displays the Owner and [places an 'Ow:1
preceding the Owner's name;
You do not need all of these data elements to
produce a well schematic. If a well does not have
data in certain fields, then this information will not be
displayed in the schematic.
40 WATERS User Guide
-------
Chapter VI. Menus
The well schematic in WATERS Version 2.0 has several
limitations:
« "Plug Back Total Depth" is not displayed.
• No cementing information is displayed.
• WATERS will produce well schematics for all well
classes, but the diagrams will follow the standard
Class II construction.
For detailed instructions on producing and printing a
well schematic, see Appendix A, Section L.
GIS Accesses the optional WATERS Mapping System
(WMS). If this option is shaded, you.do not have
access to WMS. See Chapter IX for more details.
Help Menu The Help menu provides a summary of key WATERS
commands and procedures.
You can access this menu in two ways:
1. Use the r^"l and l^l to highlight the Help menu,
and press I Return j
2. Type K You cannot type H to access the help
menu when editing a record, constructing a
query, building a custom report, or viewing
another menu.
Exhibit VI-4 shows WATERS with the Help menu open.
WATERS User Guide 41
-------
Chapter VI Menus
Exhibit VI-4: The Help Menu
rile I Id it | Query
feraits | | Inventory
•
•
•
I
•
*
•
•
•
»»vty»t:ioo K*y» "^ *~
mov DO I ... f
ilnepectionl | MIT 1 | Compl/Enf| (operations
Ops DUNCAN OIL PROPERTIES „««,,,,,
fi Rule Authorized
N
3 Application N amber 147*53 Well Identifier UT023S3
H Permit Number UT1234A Type of Well Prmtd Converted
£, Type of Well Permit Area Class 2
5 No. of Wells/Permit 3 Type 2R Enhanced Reeo
K Application Date
Z*. Date Permit Is*u<
/ / Technical Review / /
id / / Public Notice / /
X Date Permit Effective / / Public Hearing 10 Years
JQ Date Permit Modi:
led / / Permit Term / /
X Type of Permit Mod Expiration
o Date Plugged/Abandoned / / Dot* permit Denied / /
|Q Commercial Facility H Date withdrawn
' - , t
f1
ill«i|pf|| *on-OIC [Display Window with AH Navigation Keys |
This menu has two options: Navigation and How do
I..., There are two ways to select each option.
• Use LUand
to highlight the option you wish
to select and then press I Return \
• Press the highlighted letter of the menu option's
title.
The following section describes both of these
options.
Navigation Provides a brief synopsis of key navigation
comr .-nds, key sequences and function keys.
Chat ~,-r IV describes all WATERS commands in
greater detail.
How Do I... Provides an overview of WATERS functions and
features for easy reference.
42
WATERS User Guide
-------
Chapter VII. Query
VII. Query
WATERS' query capabilities are a powerful data
analysis tool that you can use to make more
informed decisions and increase your UIC program's
effectiveness. Queries enable you to locate and
select specific records based on criteria you specify.
They identify relationships within your database that
ordinarily may not have been noticed, or without
WATERS would have been too time-consuming to
demonstrate.
You can perform a query using several different
Query menu options described in Chapter VI and
VIII. You can use the Find option, the New/modify
query in the Reports option, or create a custom
report through the Reports option.
Regardless of the path you take to start a query, its
basic procedures are identical. You use the same
format to search individual fields. Each path offers
the same two types of queries: single-folder and
cross-folder. After you approve the query criteria,
WATERS displays the same messages. This chapter
will explain the search formats, single-folder and
cross-folder queries, and WATERS' query messages.
Search Formats WATERS allows you to do specialized queries for
character, logical, and date fields.
* To find all of the records in which that field is not
empty, type an asterisk (*).
• To find all records in which a field is empty, type a
minus sign (-).
» To search for an exact value (e.g., number,
date), enter the value in the field. A pop-up
window appears that asks you to enter the
WATERS User Guide 43
-------
Chapter VII. Query
Single-Folder
Queries
Cross-Folder
Queries
ending value in the range. Leave the field blank;
just press I Retum I.
» To search for a range of values (e.g., numbers,
dates), enter the beginning value of the range.
When the pop-up window asks, enter the ending
value.
• To find all of the records in which a particular
date field is empty, type 1901/01/01 into the field.
• To find all of the records in which that date field
contains a value, type 1900/01/01 for the
beginning of the range and 2099/12/31 for the
end of the range.
In single-folder queries, you search within one or
more fields within the same folder. For example, you
could search in the operations folder for all wells
whose observed "Maximum Injection Pressure" is
1500 psig. For detailed instructions on how to
perform a single-folder query, see Appendix A,
Section G.
Cross-folder queries allow you to search in multiple
fields across multiple folders. For example, you could
search for all wells whose observed "Maximum
Injection Pressure" is 1500 psig, but whose "Allowed
Injection Pressure" is 1400 psig. The observed
pressure is a data element in the Operations folder,
while the allowed pressure is an element in the
Permits folder.
Performing a cross-folder query involves several
steps. Enter your search criteria in one folder, just as
you would for single-folder queries. To move to
another folder, use either the irageoownl key or
|F3 I Pressing j PageDown! will move you page by
page through each folder. Pressing IF3.1 will
produce a pop-up window that lists each folder
name. To select a folder, type the highlighted letter
of the title or use your 141 and LU and press
44
WATERS User Guide
-------
Chapter VII. Query
| Return | Then enter your search criteria in that
folder. When you have finished entering the criteria,
press [ control "1 - w to begin the search.
Linking Ordinary cross-folder queries search for data in
multiple folders, but do not compare values of the
data elements. However, very often you will need
to search for a dependent relationship between two
elements. In the example given earlier, the search
criteria was wells whose observed injection pressure
was 1500 psig, while their allowed "Injection
Pressure" was 1400 psig. But it is more valuable to
know which wells exceed their allowed injection
pressure. You can perform the latter query through
linking the values of the allowed "Injection Pressure"
in the Permits folder to the observed "Maximum
Injection Pressure" in the Operations folder.
The restrictions for linking are listed below:
* A field can be linked to only one other field.
• One of these fields must be in the Permits or
Inventory folders.
• The fields must be in separate folders.
• Only fields of the same type can be linked
together: character to character, date to date,
and.numeric to numeric.
To link two fields, move to the first field in the Permits
or Inventory folder. To select that field, press 1^2 1.
WATERS places an asterisk next to the field you
selected to signify it is part of a link. A pop-up
window will appear, listing all folders, with the active
folder shaded. Select the second field's folder,
which will become active.
Move to the second field and press IF2 I again. A
new pop-up window lists a series of operators. The
message box on the bottom of the screen will
explain what each operator signifies. Scroll through
WATERS User Guide 45
-------
Chapter VII. Query
the list using [4J and 1*1 to select one operator. If
you were to perform the example given earlier, you
would select < (less than). A second window will
disnlav vour link criteria.
If you are linking two dates or two numbers, you will
have the option to modify your link further. You can
either add or subtract days/numbers from the"
second field you have linked. Building on the earlier
example, you may want to examine only the wells
whose injection pressure exceeded the allowed by
at least TOO psig. In this case, you would add 100 to
the observed "Maximum Injection Pressure". If you
do not want to modify the link, press i Return ~\
without entering a value. WATERS will move you
back to the Permits or Inventory folder where you
began your search.
You can perform as many links in a single query as
you would like. You can also delete a link without
deleting your query. Press IF5 I to see a list of the
links. Select the one you want to delete, and press
I Ketum "j. WATERS will ask you to confirm your
choice.
WATERS Query Once you have finished entering all your query
Messages criteria, press I ^ontro1 I - W. A pop-up window
gives you the option to begin, clear, or edit your
search. If you type £, WATERS starts to search for
matches to your criteria. While it does so, it displays
two new pop-up windows. The first, at the top of the
screen, lists the search criteria. The second, in the
middle of the screen, gives you an estimate of how
much of the search WATERS has completed. See
Exhibit VII for an example.
46 WATERS User Guide
-------
Chapter VII. Query
Exhibit VIM
Operating Statue i* not empty |
:
•
•
:
•
•
•
!
•
I
•
1
!g wall Identifier
•O Date Updated
•O Operating status *'
:O Status Effective <. 'f
,Q Injection
• 0 (ps:
• X Minimum '"•:•;
Jn Average
.Q Maximum
'O Annual Volume of
'•O Injected Fluid
iO Fluid Type
-/,"• r "'" '
V J ,
MBS J/1 |/day) (psig)
Processing 45/472 •:.>.:: : .:':'. VK'. J
Matches 39 l:;;:?i:; H'.'!'?! •:.':!.
to CancelJ:"" '••'&•&:%••
barrels
:>. «*& - i Won-UIC louery Menu
PgDn
The window shows the following:
• The pass the search is on
• The total number of passes the search requires
• The number of records processed so far
• The total number of records
• The number of matches found so far.
When WATERS completes a search, the first window
still displays the search criteria. The second window
displays the total number of matches found. After
you press any key, WATERS will display the word
FIND in a box at the top right comer of your screen.
WATERS reacts in different ways depending the
option you used to perform your query:
• If you use the Find option under the Query menu,
WATERS moves to the first record in the database
that satisfies the criteria you entered.
• If you use the Load Custom Report option,
WATERS will ask where you want the report sent
to and execute your choice.
WATERS User Guide 47
-------
Chapter VII. Query
• If you create a custom report or use the
New/modify Query option through the Reports
option, WATERS will either print or display the
report. When you exit a custom report, WATERS
will ask if you want to save the report.
TO* When you arefnfeh*d*itt» any query, remember
to gh the
octtve subset ol data.
48 WATERS User Guide
-------
Chapter VIII. Reports
VIII. Reports
WATERS' reporting function is a unique feature of the
system. WATERS can produce facsimiles of EPA 7520
quarterly reports. It also provides an extensive set of
management reports designed for use at the
program implementation level. You can create
custom reports to meet specific needs. To produce
reports, type Q. to access the Query menu and R to
select the Reports option.
Once you have done so, a dialog box with five
windows will appear on your screen (see Exhibit VII-1
below).
Exhibit VIII-1: Reports Menu
rile
•dit
===>«««=«-»"WATERS stat« System*
Reports
« Report
Status Reports
•nforceraent Reports
W»ll By Well Reports
Mice, Reports
7520 Kapprtt
-Och*diU* for:—i
Today
Month
Current Last
JU1 wells
New/modify Query
Each window represents a step you will take to
generate a given report. To select any choice in a
window, type the highlighted letter of the title, or use
WATERS User Guide
49
-------
Chapter Vi 11 Reports
your Ifl and LU to highlight the item and press
I Retum"""].
The first window. Select a Report Type, lists the
following six report types:
• Schedule Reports
• Status Reports
• Enforcement Reports
• Well by Well Reports
• Misc. Reports
» 7520 Reports
The second window is dynamic. It lists specific
reports associated with the report type highlighted
in the first window. The next three windows almost
always lists the well range, time frame, and report
destination. A few reports superimpose a different
window over the time frame.
This chapter discusses the standard windows for well
range, time frame, and report destination. It also
describes in aetail the report types, the individual
reports associated with each type, and any
changes to the time frame window for particular
reports.
TlPs The definitions for we! -
report are ttie sam«r t>oweS' tey om not
appfcaWe for ol reports, ^^eirarnp^. o Wei
'' schematic reports \ril riot .have a 'time frame.
When you select a report, ttne options that are
not avaiabie ore st>oded.
Common Report WATERS has a series of reporting features which will
Features yOU ^jig- repOrts to meet specific needs.
50 WATERS User Guide
-------
Chapter VIII. Reports
Well Range
Time frame
Report Destination
A well range limits the report to a subset of well
records. The four range choices are located in the
window titled Range: Current Well, Current List, All
Wells, and New/modify Query.
If you select Current Well, your report is limited to the
well record that was on your screen before you
accessed the Reports option. Current List restricts
the report to the wells that meet your query criteria
(if you processed a query before accessing the
Reports option). All Wells produces a report on the
entire database. New/modify query allows you to
either enter search criteria to limit your report, or
modify your current search criteria without exiting
the Reports option.
The procedures for using New/modify query are
identical to querying through the Find option. The
only difference occurs when you press any key to
remove the window displaying the number of
matches. Instead of returning to the first record
meeting the query criteria, WATERS generates the
report you selected.
The Schedule For window contains the time frames:
Today (current date). Month, Year, and the First
through Fourth Quarters of the Fiscal Year you
specify.
You have the choice of routing these reports to a
printer, sending them to a print file, or viewing them
on the screen (the HP LaserJet, Print File, and Screen
options respectively).
When you send a report to the HP LaserJet printer,
WATERS will print the entire report. You cannot print
a portion of a report. The printer must be in HP-PCL
mode. You cannot print reports using postscript.
Sending a report to a Print File allows you to print it
at a later time. The first time you select Print File in
any session, WATERS will ask you to name the print
WATERS User Guide
51
-------
Chapter VIII. Reports
Report Types
Schedule Reports
Inspection Schedule
file. If you select Print File more than once in a
session, WATERS will append the report to that file.
When you view reports on the screen, they may be
wider than your screen. You can scroll to the left
and the right by typing 1 or £. Type £ or Q. to move
across the screen at a slower pace. WATERS
displays the reports one screen at a time, allowing
you to view the current screen until you are ready to
continue or cancel the report. Type "N" to look at
the next page. An exit prompt appears at the
bottom of each screen.
TIPi There is no command to look at the previous
page H you type tLto rnove to the next page.
There are several report types available through
WATERS,
TO!
Reports thar include th% Owner, ond Operator
fields fct the Operator if one exte otherwise they
1st the Owner, Sc^e reiports jodfcote which b
listed by printing bp^, .4or aw: 't>efore the
organization name.
There are two types of Schedule Reports: Inspections
Schedule and MIT Schedule. You may choose a
schedule for inspections due or overdue today, in
the next month, or in the first through fourth quarter.
Each are described below.
Usts all routine periodic inspections that are due
within a specified time period. Periodic inspections
are due one year after the last inspection. If the
date of the next inspection is before the current
date, the inspection is overdue. The report is sorted
by "County".
This report displays the following fields:
• "County"
* "Permit Well ID"
52
WATERS User Guide
-------
Chapter VIII. Reports
• "Operator Name"
• "Wei! Type"
This report also provides historical information about
the last inspection. It includes:
• date the next inspection is due
• date of the last inspection (periodic or other)
• type of last inspection
« if there was a violation found at the last
inspection
» type of enforcement action taken, if any
• if there is an unresolved (i.e., open) violation in
the Compliance/Enforcement folder.
Unresolved violations are defined as violations which
have nothing entered in the "Date Returned to
Compliance" field.
MIT Schedule y^ a|| MIT inspections due within the time frame you
specify. The frequency of MIT inspections is specified
in the Permits folder for each well. MITs can be
conducted annually, semi-annually, or every five
years. If no frequency is specified, WATERS assumes
that the frequency is annual for this report. The
report is sorted by "Field Name" (found in the
Inventory folder).
This report displays the following fields and
information:
• "Permit Well ID"
* "Operator name"
• "Field Name"
* Date of the last MIT
• Result of the last MIT
* "Type of Construction"
WATERS User Guide 53
-------
Chapter VIII. Reports
Status Reports
Injection Status
• "Operating Status"
• "Date of next MIT "
• If the MIT is overdue
• If the well has an unresolved ("open") violation
An unresolved violation indicates that the well has
an unresolved, failed MIT, or an unresolved
compliance/enforcement action. The most recent
MIT record and all the Compliance/Enforcement
records are checked for this report.
WATERS generates a variety of status reports
including Injection Status, Folder Summary, and
Operating Status Sumr -ry.
Displays the most recent injection information for
each well. The information is sorted by "Permit Well
ID". The report displays the following fields:
• "Permit Well ID"
• "Owner/Operator Name"
• "Field Name"
• "Well Type"
• "Fluid Type"
• "Annual Volume"
• "Average Pressure"
• "Maximum Pressure"
• "Maximum Permitted Pressure"
• "Date Operations Record Updated"
All fields are from the Operations folder except the
"Permit Well ID" and "Maximum Permitted Pressure"
,whjch are from the Permits folder.
54
WATERS User Guide
-------
Chapter VIII. Reports
Folder Summary Summarizes key data for the active folder. The
active folder appears in parentheses next to the
menu option. For example, when selected from the
Permits database, this report option appears as:
"Folder Summary (Permit)." If you select Current Well
as the range, a Folder summary of Inspection, MIT,
Compliance/Enforcement, and Operations would
print all the records for that well in the folder. If you
select All Wells, only the most recent records of these
folders are selected.
The table on the following page shows what
information each Folder Summary Report contains.
WATERS User Guide 55
-------
Chapter VIII. Reports
Folder Name Fields Displayed
Permits
"Permit Well ID"
"Permits Action" (e.g.. Issued,
Rule, Modified),
"Date of Action" (unless the
well is rule authorized, in which
case the field contains
"Authorized")
Inventory
MIT
"Inventory Well ID"
"Rule Authorized"
"Owner/Operator Name"
"Well Description" (of the
location)
Inspections "Inspections Well ID"
"Inspector Name"
"Date of Inspection"
"Type of Inspection"
"Violation Discovered?"
"MIT Well ID"
"Inspector Name"
"Date of MIT Test"
"MIT Witnessed?"
"Result of MIT Test"
Comp//ance-
Enforcement
"Compliance/Enforcement
Well ID"
"SNC?"
"Date of Last Compliance
Review"
"Result of Last Compliance
Review"
Operations "Operations Well ID"
"Date Operations Record
Updated"
"Operating Status"
"Date Status Effective"
"Annual Volume of Injected
Fluid"
56
WATERS User Guide
-------
Chapter VIII. Reports
Operating Status
Summary
Enforcement
Reports
Violation & Enforcement
Administrative
Order List
Produces a summary of wells by type and operating
status.
There are five enforcement reports that WATERS can
generate, including the Violation and Enforcement
Report, the Administrative Order List, the Judicial
Order List, the Operator Violation Summary, and
Pressure Exceedence Report.
Prints the most recent violation and enforcement
information for each well. The report is sorted by
"Field Name".
The report displays the following fields:
• "Permit Well ID"
• "Operator Name"
« "Field Name"
• "Date of Violation"
• "Violation Type"
• "SNC?"
« "Date of Enforcement Action"
• "Type of Enforcement Action"
• "Penalty Assessed" (in dollars)
TIP: In reports that print the Type of Violation field
[e.g.. Enforcement Status. Area of Review), an
asterisk (*) appearing after the type of violation
Indicatesa potential SNC
Lists all administrative orders (AOs) issued within the
time period you specify. It also includes violations
resolved as the result of a previously issued AO. For
the reporting year, you can select one quarter or
the whole year. The default for the reporting year is
the current year.
The report includes the following fields:
WATERS User Guide
57
-------
Chapter VIII. Reports
• "Permit Well ID"
• "Owner/Operator Name"
• "Well Type"
• "Date Enforcement Action Taken"
• "Date Violation Occurred/Verified"
• "Date Returned to Compliance"
• "Docket Number" (first 14 characters)
• "Penalty Assessed" (in dollars)
• "Penalty Collected" (in dollars)
• "SNC?"
• "In Wellhead Protection Area?" (WHP)
• "Type of AO"
Judicial Order List Ltets all judicial orders issued within the time period
you specify. It also includes violations resolved as
the result of a previously issued judicial order. For the
reporting year, you can select one quarter or the
whole year. The default for the reporting year is the
current year.
The report includes the following fields:
• "Permit Well ID"
• "Owner/Operator Name"
• "Well Type"
• "Date Enforcement Action Taken"
• "Date Violation Occurred/Verified"
• "Date Returned to Compliance"
• "Docket Number" (first 14 characters)
• "Penalty Assessed" (in dollars)
• "Penalty Collected" (in dollars)
• "SNC?"
58 WATERS User Guide
-------
Chapter VIII Reports
Operator Violation
Summary
Pressure Exceedence
Well by Well
Reports
Folder Print Report
» "In Wellhead Protection Area?" (WHP)
• "Type of AO"
Lists violators and the percentage of violations that
are SNCs for the past 365 days. Violators are
defined as those operators/owners responsible for
one or more violation(s) in the past year, not
Including monitoring and reporting violations. The
report is sorted alphabetically by
"Owner/Operator", and displays the:
• "Owner/Operator Name"
• total number of wells for which Owner/Operator
is responsible
• number of these wells in violation
» percentage of the these violations that are SNCs
Computes all wells whose most recent recorded
pressure (found in the Operations folder) exceeds
the allowed pressure (found in the Permits folder).
The report displays the:
• "Operations Well ID"
• "Allowed Injection Pressure"
• "Observed Injection Pressure"
» "Date Operations Record Updated"
Each Well by Well Report compiles information on
one well. You can select All Wells for a range, but
this simply produces multiple reports on individual
wells.
Prints records from the specified WATERS folders.
While in the U1C database, you can print any of the
six UIC folders, or choose the entire set of folders.
You must be in the non-UIC module to print non-UtC
records. You can only send the Folder Print Report to
the HP LaserJet. The Print File and Screen options
are not available for this report.
WATERS User Guide
59
-------
ChapterVIII. Reports
Well Highlights
Compliance Report
Permit Data Report
Area of Review
Displays a limited amount of data for an individual
veil, including Permit information and the most
recent Inspection, MIT and
Compliance/Enforcement information.
Produces well-specific compliance/enforcement
information. WATERS finds all the violations within the
period you specified. The cefault period is two
years. This report includes tne:
• "Owner/Operator Name"
• "Permit Number"
• "Date Violat.. -. Occurred"
• "Type of Violation"
• "Date Enforcement Action Taken"
Sumr arizes permit data for a particular well. The
majors/ of the data shown comes from page one of
the Permits folder. This report also includes the:
• "Owner/Operator Name"
• "Operating Status"
• "Well Construction"
• "!. -ude" and "Longitude"
• "Date First Injected"
• "Date Drilled"
Lists all UIC and/or non-UIC wells in the current well's
Area of Review (AOR). You can specify the radius of
the well's AOR. The default is two miles. You can
also choose the type of wells to include in the AOR
(i.e., UIC, non-UIC or both).
WATERS compares the "Latitude" and "Longitude"
for each well in the system with the "Latitude" and
"Longitude" of the cur- .t well, and determines
which wells fall within the specified radius. WATERS
also determines if any well within the radius may be
60
WATERS User Guide
-------
Chapter VIII Reports
Well Schematics
Miscellaneous
Reports
Custom Report
defective. A well is potentially defective if it meets
any of the following conditions:
• the existing surface, intermediate, and long string
casings are not cemented
• it has an unresolved compliance/enforcement
violation (not including a monitoring or reporting
violation)
• the surface casing depth is less than the base
depth of USDW
• it failed its most recent MIT test (either part) and
has not yet been subject to a remedial action
• its depth penetrates the confining zone of the
current well
Prints the well schematics for all wells you select in
the given range. You can print a well schematic
when you view it on the screen; however, this report
is a fast way to print a batch of wells schematics.
WATERS can also generate some custom reports as
well as some reports on non-UIC wells.
Allows you to create your own report (i.e., ad hoc
report). A custom report can contain almost any
combinations of WATERS data elements and can be
combined with queries to provide greater flexibility.
You can save the report format and the search
criteria used to create the report.
TIP: The only fields you cannot use tn a custom report
are those fields that WATERS calculated. The four
calculated fields are:
* "Number of wefc/ permit"
"Date of tost MfT
"Result of last MfT
* "Last Corrective Action"
WATERS User Guide
61
-------
Chapter VIII. Reports
Once you have selected OK in the Reports window,
WATERS will open the active folder and display in
red all fields available for your report. The
commands needed to navigate this screen are the
same as those used during editing and querying.
While you are selecting the fields, you can also enter
any search criteria the report may require. To select
a field, press Lf-LJ. To move to another folder, select
on
The fields you select and the order in which you
select them determines the report's format. The
field names become the report's column headings.
The first column is always the Well ID. When you
finish viewing or printing the report, WATERS will give
you the option to save it.
For a detailed example of creating a custom report,
see Appendix A, Section P.
Non-uic Provides a brief overview of Permits and Inventory
data for non-UIC wells. You can choose this report
when you are in the UIC database. However, if you
are not in the non-UIC database, you cannot set the
report range to the Current Well or Current List, nor
can you issue or modify a query. The Non-UIC report
displays the following fields:
' "Non-UIC Well ID"
• "Latitude" and "Longitude"
• "Facility Type
• "Finds Number"
• "Permit Number"
• "Permit Type"
• "Date Permit Issued"
• "Date Permit Effective"
• "Legal Contact"
62 WATERS User Guide
-------
Chapter VIII. Reports
7520 Reports
Permit Review &
Issuance
Compliance Evaluation
Mechanical Integrity
Testing
Quarterly Exceptions
List
Grant Utilization
WATERS also generates all of the reports associated
with EPA Form 7520.
Form 7520 Prjnts a|| of the forms (EPA 7520-1. 2A, 2B, 3, 4, and 5).
Generates Parts I - VII of the Permits Review and
Issuance report (EPA 7520-1). Parts VIII and IX must
be completed manually. WATERS is not capable of
making the subjective decisions on the AQR_section
of the EPA 7520-1 section, so the program leaves
section VIII for you to complete. The AOR (Well by
Well) report can help you analyze the AOR and
complete the form.
WATERS prints forms EPA 7520-2A and 2B.
Prints EPA Form 7520-3. WATERS has more options for
MIT tests than the EPA 7520 forms approved by the
Office of Management and Budget (OMB).
However, the tests in WATERS are in the same order
as the tests listed on the OMB approved forms to
eliminate any confusion.
Prints EPA Form 7520-4. This report contains a list of
all SNCs that have not been addressed by an
enforcement action for 90 days or more. The wells
remain on the exceptions list until they have
returned to compliance. Wells will still appear on the
Exceptions List for the quarter in which they return to
compliance; the report will also show the date the
well returned to compliance. When the report-
shows "Noncompliant" instead of displaying the date
a well returned to compliance, the well has not
returned to compliance as of the ending date of the
quarter you selected.
Prints a blank copy of EPA Form 7520-5: Grant
Utilization.
TIP: 7520 reports may not be directed to the screen.
WATERS User Guide
63
-------
-------
Chapter IX. WATERS Mapping System
Use the mouse to highlight the option and press
I Return |
• Type the first capitalized letter of its title.
The following sections describes each WMS menu in
detail.
File Menu The File menu contains basic information about
WMS, geographical features, and printing functions.
The File menu contains the following options:
• Version
• Layers
• Print
• Quit
These options are described below.
Version Displays the current version and date of WMS. To
remove the message from your screen, press any
key.
Layers Allows you to select the attributes or layers you want
to display on the map. The default setup includes
layers for cities, rivers, highways, and boundaries for
water bodies, counties, states, regions, the U.S., and
hydrologic boundaries.
Use this option to turn layers on and off. Active
layers have unique symbols displayed in the left
column of the menu and the first letter in the titles
are capitalized. When you turn a layer off, its symbol
will not appear.
TIP: UC and non-UIC wefts are always plotted. You
cannot deactivate them with the Layers option.
Press
when you complete your layers
selection. WMS will automatically redraw the map.
WATERS User Guide
67
-------
Chapter IX. WATERS Mapping System
IX. WATERS Mapping System
Overview The WATERS Mapping System (WMS) is an optional
component of WATERS developed using Maplnfo
software. WMS displays maps of the geographic
areas surrounding the wells tracked in WATERS. You
can modify and print these maps to fit your program
needs. WMS is a powerful analytical tool because
you can use it to explore the spatial relationships of
wells that meet conditions you specify through
WATERS. As a result, you can identify trends or issues
that might not be apparent without a visual display
that plots the location of wells. In addition, WMS has
two supporting utilities that let you customize it to
meet your needs.
This section discusses the system requirements for the
GIS module and the necessary installation routines.
WMS has the same basic system requirements as
WATERS. In addition to the system requirements
identified in Chapter III, the WMS requires:
» a Maplnfo for DOS runtime module, and
* a network module for each simultaneous user.
Installation The WMS program was automatically installed when
you installed the WATERS program. WATERS users
also receive a diskette with regional data for map
layers. WMS data includes cities, rivers, highways,
and boundaries for water bodies, counties, states,
regions, the U.S., and hydrologic boundaries.
For WMS to be operational, you must also install a
Maplnfo runtime module. One runtime module and
one network module can accommodate two
simultaneous users. In other words, the number of
network modules needed will depend on how many
Installation and
Start-up
System
Requirements
64
WATERS User Guide
-------
Chapter IX WATERS Mapping System
Navigation
Letter Keys
Numeric Keypad
Function Keys
Escape
users will use the WMS simultaneously. For instance, if
you expect three users to access the WMS
component at the same time, you will need one
runtime module and two network modules. If you
expect four users to access the WMS component at
the same time, you will need one runtime module
and three network modules.
|f you do not have a runtime module, you must
obtain one from S*A or purchase one, and instal
rf before attempting to run the WMS.
Identify the path for the runtime module in the DOS
environment variable CGIPATH. For example, if the
Maplnfo runtime module was installed into a
directory called c: \WATERS\RT, the following
statements are required in the AUTOEXEC.BAT file:
SET CGIPATH=C:\WATERS\RT
PATH=%PATH%;C:\WATERS\RT;
You navigate in WMS using your keyboard and/or a
mouse.
Press the capitalized letter of any title, menu item to
select an option.
Press a number to select the cursor speed before
using the
and
Each number
corresponds to a cursor distance or speed. Low
numbers move the cursor small distances or at a
slower speed. High numbers move the cursor larger
distances. The default if 4.
There are a variety of function keys that can help
you navigate through the WMS.
Cancels an operation or command. Use the
escape key to return to a previous menu. If you are
using a mouse, the right mouse button performs the
same functions.
WATERS User Guide
65
-------
Chapter IX. WATERS Mapping System
When you access WMS from the Query menu in
WATERS, all layers are active and bodies of water
are filled. An active layer may not be plotted if your
map has no examples of the point line or boundary.
For instance, the cities layer includes the 250 largest
cities in the U.S, The city layer will not be displayed if
the area you plot is not located near one of these
cities
TIP: The vwater tayet; has two active modes. A body
ot w0a£ca^t» .outlnod
Print Prints the map displayed on your screen. A printed
map has two components. The map is printed on
the top half of the page, A legend is printed on the
lower half of the page. The legend includes a title,
display layer keys, north arrow, and a scale.
When you select the print option, WMS prompts you
to enter a title. Then press I Ketmn fo sencj to
printer. WMS uses the same port configuration as
WATERS. To change the port configuration, return to
WATERS. Press I fscxP* — | fO |eave the print option
and return to the original map.
Quit Closes the WMS and returns to the WATERS folder
you were on when you selected the GIS option.
WMS does not ask you to confirm your choice.
Edit Menu This menu contains options to modify the current
map display. When you access some of the options,
the cursor becomes a pair of crosshairs - intersecting
perpendicular lines. Using the mouse or L^l I"**!,
l_iJ, and 111 you can move the crosshairs to identify
the location of map items to modify. When
crosshairs appear on the screen, you can press LELJ
to display locational data. Latitude and longitude
(in decimal degrees) will appear in the left corner of
the screen.
68 WATERS User Guide
-------
Chapter IX, WATERS Mapping System
The Edit menu contains the following options:
» Edit
• Magnify
• Zoom
• Pan
« State View
• Last View
• Erase Text
» Label
These options are described below in detail.
Magnify Enlarges a portion of the map. When you select the
Magnify option, the crosshairs intersect at the
center of the screen. Use them to draw a box
around the area you want to magnify. To draw this
box, first move the crosshairs to the first corner of the
box to be magnified and press I Retum ~\ jnen
select the opposite comer of the box and press
I Return |
WMS redraws the map so that the selected area fills
your screen. The center point of the block becomes
the center of the new map. If the block is longer in
one direction than the other, the system will adjust
the display of the shorter dimension to account for
the fact that the map must be square. Therefore,
the resulting map displayed may contain a larger
area than that selected by the user.
WATERS User Guide 69
-------
Chapter IX. WATERS Mapping System
Enter |
anduJ
Crosshairs
Menus
Selects a menu or option when highlighted.
Selects a point.
If you are using a mouse, the right mouse button
performs the same functions as I Return j
Selects a menu or option when highlighted.
Selects a location for a map to be drawn.
If you are using a mouse, the right mouse button
performs the same functions as I
Displays locational data when you access the
Magnify and Pan options in the Edit menu.
Scrolls through the menus, options, and maps. For
any movement with arrows, you can also use your
mouse.
Marks points to be modified or explored. Crosshairs
consist of two perpendicular lines that intersect.
When you select the appropriate options, the
crosshairs appear on your screen. You move the
crosshairs with either the mouse or the F*n I'M,
and HI until the intersecting point is on the
feature or area you want to modify or leam more
about.
The WMS produces a map of the geographical area
surrounding a well within a specified radius. You can
modify and print these maps using the four WMS
menus: File, Edit, Query, and Help. You access the
menus and options three ways:
Use the
and l"^i to highlight the option,
and press I Return
66
WATERS User Guide
-------
Chapter IX. WATERS Mapping System
• Use the mouse to highlight the option and press
I Return |
• Type the first capitalized letter of its title.
The following sections describes each WMS menu in
detail.
File Menu The File menu contains basic information about
WMS, geographical features, and printing functions.
The File menu contains the following options:
• Version
• Layers
• Print
• Quit
These options are described below.
Version Displays the current version and date of WMS. To
remove the message from your screen, press any
key.
Layers Allows you to select the attributes or layers you want
to display on the map. The default setup includes
layers for cities, rivers, highways, and boundaries for
water bodies, counties, states, regions, the U.S., and
hydrologic boundaries.
Use this option to turn layers on and off. Active
layers have unique symbols displayed in the left
column of the menu and the first letter in the titles
are capitalized. When you turn a layer off, its symbol
will not appear.
TIP: UlC and non-UlC wells are always plotted. You
cannot deactivate tfiem with the Layers option.
Press
¥!¥1 — I
when you complete your layers
selection. WMS will automatically redraw the map.
WATERS User Guide
67
-------
Chapter IX. WATERS Mapping System
When you access WMS from the Query menu in
WATERS, all layers are active and bodies of water
are filled. An active layer may not be plotted if your
map has no examples of the point line or boundary.
For instance, the cities layer includes the 250 largest
cities in the U.S. The city layer will not be displayed if
the area you plot is not located near one of these
cities
TIP; The wafer layer has two active modes. A body
of water can be outSned or fled.
Print prints the map displayec on your screen. A printed
map has two components. The map is printed on
the top half of the page. A legend is printed on the
lower half of the page. The legend includes a title,
display layer keys, north arrow, and a scale.
When you select the print option, WMS prompts you
to enter a title. Then press I Return ~| jo sencj to the
printer. WMS uses the same port configuration as
WATERS. To change the port configuration, return to
WATERS. Press I *scape—I to leave the print option
and return to the original map.
Quit Closes the WMS and returns to -he WATERS folder
you were on when you selected the GIS option.
WMS does not ask you to confirm your choice.
Edit Menu This menu contains options to modify the current
map display. When you access some of the options,
the cursor becomes a pair of crosshairs - intersecting
perpendicular lines. Using the mouse or i"!!?: I, L^J,
LiJ, and LU, you can move the crosshairs to identify
the location of map items to modify. When
crosshairs appear on the screen, you can press LE2J
to display locational data. Latitude and longitude
(in decimal degrees) will appear in the left corner of
the screen.
68 WATERS User Guide
rt
-------
Chapter IX. WATERS Mapping System
Press any key to remove the message. Use the Pan
option to reposition the map center. Then select the
State View option again.
Last View Displays the previous view of a map after you make
changes using the Magnify, Zoom, Pan, or State
View options. You cannot display the previous map
if you turn off a layer. For example, if you turn off the
County layer using the Layers option, Last View will
not return to the state map with the County
boundaries shown.
TIP: Labels may be erased when using the Last View
option to view a larger area. For example, if you
use the Zoom option to move from a map of
IHinois to the map of the U.S. you cannot see
Illinois' labels. When you select Last View to
return to the Illinois map, labels are gone.
Erase Text Erases all labels and automatically redraws the map
display.
Label Allows you to selectively label any active
geographical feature. You cannot select features
you have made inactive with the Layers option
under the File menu. All active features have white
titles in the Edit menu. All inactive features are
displayed in yellow. Since features are dynamic,
you cannot type the first capital letter to select a
menu option.
When you select one of the features, the crosshairs
appear in the center of the screen. Use the
crosshairs to select the feature you want to label
and press I Return ~| yVMS labels the appropriate
feature closest to the point you selected. This text is
in the same color as the feature itself, so you can
easily identify it on your screen. Press I ^"P6 — I to
cancel the Label option.
WMS will not write a label in the place you select if:
WATERS User Guide - 71
-------
Chapter IX. WATERS Mapping System
• The feature you want to label is not located on or
near the point you selected.
» The area is crowed with text and there is no room
for additional labels.
* The point you select places labels too closely
together.
Press any key to continue.
TIP? If labels are removed from view, they will be
erased and must be replaced. For example, if
you use the Pan option to create a new map
that does not show the previous map's labeled
features, the labels wi be deleted.
Query Menu This menu enables you to choose a new well to view
in WMS or in WATERS, and to retrieve a variety of
information and locational data on wells and other
features on the map. For all of these options, you
select points or areas on your map using the
crosshairs.
When you access the Query menu, you will see the
following list of the options:
• Query
• Reselect
• Well info
* Distance
• Lot-Long?
These options are described below in detail.
72 WATERS User Guide
-------
Chapter IX. WATERS Mapping System
The Edit menu contains the following options:
• Edit
« Magnify
» Zoom
• Pan
• State View —
* Last View
• Erase Text
• Label
These options are described below in detail.
Magnify Enlarges a portion of the map. When you select the
Magnify option, the crosshairs intersect at the
center of the screen. Use them to draw a box
around the area you want to magnify. To draw this
box, first move the crosshairs to the first corner of the
box to be magnified and press I Return ~| Then
select the opposite corner of the box and press
I Return |
WMS redraws the map so that the selected area fills
your screen. The center point of the block becomes
the center of the new map. If the block is longer in
one direction than the other, the system will adjust
the display of the shorter dimension to account for
the fact that the map must be square. Therefore,
the resulting map displayed may contain a larger
area than that selected by the user.
WATERS User Guide 69
-------
Chapter _!XT WATERS Mapping System
Zoom Changes the scale of the map, while the center
remains constant. The map's scale denotes how
much space each inch of your screen symbolizes.
Therefore, if you change the width your screen
represents, you can increase or decrease the area
your map covers. If you increase the width, your
map covers more miles per inch of your screen (i.e.,
WMS "zooms out"). If you decrease the width, your
map covers fewer miles per inch of your screen (i.e.,
WMS "zooms in").
When you select this option, a pop-up window at
the top c* fhe screen displays the current map width
ano- Pror :: -ts you to enter a new width. After you
press I Ketum WMS rec|raws the map.
Pan Changes the center of the map. When you select
this option, the crosshairs intersect in the center of
the map. Move the crosshairs to select a new
center and press I Ketum | y^M$ redraws the
map, centering on the point you selected. The
scale remains the same. Cancel the Pan option by
I Escape
pressing ' £• '.
TIP: If you cannot see the labels on your original map
after you use the Zoom or Pan option, then these
labeb are deleted. You cannot select the Last
View option to recover the labels on your original
map.
state View Enlarges the map on your screen to display the
entire state. The center of the current map will
determine which state is drawn. For example, if a
well is in the Northwest corner of Massachusetts, the
center of the map could be in a neighboring state.
Therefore the State View option will draw that
neighboring state. Use the Pan option to reposition
the map center, and select the State View option
again.
If the map center is within embody of water, WMS
prints the message 'No state boundary found'.
70 WATERS User Guide
-------
Chapter IX. WATERS Mapping System
Reseiect Allows you to select a new well to view. You may
either redraw the map with that well as its center, or
return to WATERS to view that well's records in
WATERS' folders. Move the intersecting point of the
crosshairs to the well you wish to select. Press
I Retum > to get the "Well ID" of the new well you
selected. You are given three choices; GIS, WATERS,
or cancel. If you choose GIS, the WMS will redraw
the map using the well you selected as its center. If
you choose WATERS, you will be returned to WATERS
positioned on the well record in the folder that was
active before you accessed the GIS option.
TIP: You cannot retrieve the previous map with Last
View after you setect a new wel,
Well info Provides quick access to key data elements stored
in WATERS without leaving WMS. Use the crosshairs
to select a well and press I Return "1 |f there are
two wells in the point you select, the Well Info option
will provide a list of the Well IDs found and require
you to select one.
A pop-up window appears in the middle of the
screen. The first column contains command keys to
navigate the window. The second column contains
an alphabetical list of field names. The third column
contains well data for each of the field names. A
complete list of field descriptions is in Appendix B.
Select OK to return to the map. Select Print to
print the list. Press I ^"P* — I to cancel the Well Info
option.
WATERS User Guide 73
-------
Chapter IX. WATERS Mapping System
Distance
Lat-Long
Help Menu
Legend
Calculates the distance between two points. Move
the intersection of the crosshairs to select the first
point and press I Return "} jnen move the
crosshairs to the second point and press I Return "|
A pop-up window at the top of the screen displays
the distance in miles. Press any key to remove the
window. Press I - ^25 — I to remove the crosshairs
and deactivate this option.
Disc 'ays the latitude and longitude coordinates of a
we!* - ou select. Move the crosshairs until the
intersecting point is on the well whose coordinates
you wish to see, and press I Return A
your screen, a pop-up window displays the. latitude
and longitude coordinates of the point you
selected. Press any key to remove the window.
Press
Escape
to cancel this option.
The Help menu provides both a legend for your map
and explanations of WMS's major functions and
procedures. When you access the Help menu, the
following options will appear:
• Legend
• How Do I...
These options are described on the following page.
Provides a list of WMS symbols and their descrLotions.
The legend includes symbols for all wells and for all
active layers. You can activate and deactivate
these layers with the Layers option under the File
menu. All active layers and all wells are listed
regardless of whether or not they are plotted on
your map.
When you finish using the legend, either press
Escape
or select OK in the top right corner of the
legend window.
74
WATERS User Guide
-------
Chapter IX WATERS Mapping System
How Do I...
WMS Utilities
Layers Editor
Provides an overview of WMS functions and features
for easy reference.
When you installed WATERS, you not only installed
the Screen Editor, but also two utilities for WMS: the
Layers Editor and the MOSS2MI Converter. The
Layers Editor allows you to change WMS default
layers. Through the Layers Editor, you can add and
remove layers available to WMS users, and change
the style in which the layers are displayed. The
MOSS2MI Converter allows you to convert CIS data
in the MOSS format to the Maplnfo file format. This is
part of the process of converting other GIS files into
layers in WMS.
Both the Layers Editor and the MOSS2MI converter
are designed for experienced WMS users and LAN
system administrators. The rest of this chapter will
briefly explain the major points of the Layers Editor
and the MOSS2MI Converter.
When you use WMS, you can activate and
deactivate the layers. You cannot, however,
change the default setting or alter the styles of the
layer. However, the Layers Editor, a Maplnfo
application, allows you to add and remove the
layers available to WMS users, change the default
setting of the layers, and alter the default style of the
layers displayed.
To start the Layers Editor, return to the c: \WATERS
prompt and type LAYERS. Once the program is
loaded, the opening screen of the Layers Editor will
closely resemble the initial WMS screen, with a
standard map and four menus in the top line.
However, the Layers Editor title replaces the WMS
title, and the Query menu is replaced by the Style
menu. Most menu options in the Layers Editor are
identical to the WMS options. The Edit menu,
however, has additional options and the style menu
is new. This section will only discuss these new
features.
WATERS User Guide
75
-------
Chapter IX. WATERS Mapping System
Edit Menu
Add Layer
Remove Layer
The Layers Editor's Edit menu allows you to modify
the current map display, just as the WMS menu did.
However, there are two new options: Add Layer and
Remove Layer.
Makes a new layer available to WMS users. When
you select this option, you have three kinds of layers
you can chose from: boundaries, lines, and points.
Boundaries are completely enclosed, larger blocks
of land or water; (e.g., a lake, a county). Lines
include highways and rivers. Points can represent
smaller portions of land such as cities.
After you select the type of layer to add, the Layers
Editor presents a list of databases that you navigate
by using your mouse or r^"l, I"**! 1x1, and LU.
Select the database for the new layer, and another
list will display all the fields of that database. Select
the appropriate field. WMS will access this field to
plot the layer. Press >—^^—« and the Layers
Editor will automatically redraw the map to include
the new layer. The Layers Editor will also assign the
new layer a unique style. Use the Style menu to
create a new default style for the layer.
Removes a layer currently available to WMS users.
When you select this option, a list of all the layers in
WMS appears. To remove one, highlight it and press
I R-et"m-~l. The Layers Editor will automatically
redraw the map, and the WMS users will no longer
be able to activate or deactivate that layer.
TIP: if you want to retrieve a layer, you wffl have to
use the Add Layer option to redefine the
database and field of the layer.
76
WATERS User Guide
-------
Chapter IX. WATERS Mapping System
style Menu The Style menu allows you to change a layer's
display (activated or not), and the color of its
symbol and/or label. When you select the Style
menu option, it displays a list of all the available
WMS layers. If the layer is currently activated, it is
capitalized and its symbol is displayed in the right
column.
Press I Return | when you have highlighted the
layer whose style you want to change. You will see
a new window with three options for each layer:
Display, Symbol, and Text Color. The current options
are displayed in a box to the right of these options.
You select the option by using your mouse or by
using the LU and LU to move the box and pressing
I Return ^ ^ of fhe available choices for that
option will be displayed in the middle of the screen.
To navigate this list, use your mouse or uj and LU
to select the HOME, PG UP, PG DN, and END boxes to
the left of the list.
Each of the three options are described in detail
below.
Display Changes the current display. Each layer has at least
two Display options; outlined (OUT), or off. The
boundary layers have an additional option: filled
(FIL). To change the setting in the Display option,
click on the box until you see the setting you want.
TIPs if you select NONE for a boundary's fled symbol.
you cannot select a rated display (FIL).
WATERS User Guide 77
-------
Chapter IX. WATERS Mapping System
Symbol
Text Color
MOSS2MI
Converter
Step 1:
Step 2
Changes the symbol for boundaries and points.
Lines can only be displayed as lines and you cannot
change the color. Boundaries can have different
colors and patterns for the outline and filled displays.
The outline symbol is in the left box, while the filled
symbol is in the right. Points can have different
symbols and colors. Page down to the end of the
list and select NONE if you do not want to specify a
pattern or color. If you select NONE for a boundary's
filled symbol, you cannot select a filled display (FIL).
Changes the color of any labels on the map. If you
select NONE, and try to label a map, no labels will
print.
When you have completed your changes, press
I — ^E
and the Layers Editor will redraw the
map. When you exit the Layers Editor, the styles you
have chosen for each layer become the default
setting of WMS.
The MOSS2MI Converter is used to convert the MOSS
data format to the Maplnfo Import File format. The
MOSS file format is a standard GIS export format.
Map layers from other GIS systems, such as
ARC/INFO and ATLAS Pro, can be exported to the
MOSS ASCII file format and converted for use in the
WMS with this utility. The general steps to
accomplish this conversion are outlined below:
Create a MOSS file from your preexisting GIS
• From ARC/INFO™ use the ARCMOSS command
• From ATLAS Pro™ use the Export to Text
Command
use the converter to translate the MOSS file to the
Maplnfo Import File Format.
• For Boundaries the format is a .MBI file
* For Lines the" format is a .MMI file
78
WATERS User Guide
-------
Chapter IX WATERS Mapping System
• For Points the format is a .DBF file
step 3: use Maplnfo's IMPORT utility to convert the Boundary
or Line to a WMS map layer.
• For Boundaries the utility is called BDYIMP.EXE
• For Lines the utility is called MAPIMP.EXE
The Maplnfo Import utilities required for step 3 are
not provided in the WATERS package. States can
borrow them from EPA Headquarters or can
purchase them from Maplnfo Corporation, 200
Broadway, Troy, NY 12180, (800) 627-4968. The
MapFile Import Utility and Boundary Import Utility are
packaged together by Maplnfo for a price of
$495.00.
If the utilities are borrowed from EPA, they should be
used and immediately returned. The utilities are
protected by copyright laws and must be deleted
from the borrower's machine once translation is
complete. By deleting your copy, you are allowing
the legal use of the borrowed software for other
state agencies.
The MOSS2MI Utility was installed along with the
WATERS. Screen Editor, WMS, and LAYERS software.
If the input file does not exist or the WMS.PER file was
not found, an error message is displayed and
operation stops. If the output file already exists, you
have the option to overwrite it.
The MOSS2MI.EXE file has the following syntax:
MOSS2MI
[ color ] [ pattern ]
The first parameter is a keyword-either BDY for
boundary conversion, LINE for Line conversion, or
PNT for point conversion. The angle brackets (<>) in
the syntax line indicate that the parameter is
required, and the square brackets ([ ]) indicate the
parameter is optional. The optional color and
WATERS User Guide 79
-------
Chapter IX WATERS Mapping System
pattern parameters are used for line conversions
only. Legal color and pattern parameters are listed
below. When not provided, the default color is
YELLOW and the default pattern in SOLID.
Color Line Type
BLACK SOLID
WHITE LONG-DASH
RED DOTTED
GREEN DASH-DOT
BLUE MEDIUM-DASH
YELLOW DASH-DOT-DOT
CYAN SHORT-DASH
PURPLE
ORANGE
MAGENTA
LIGHT-GREEN
BROWN
ROYAL-BLUE
LIGHT-PURPLE
LIGHT-YELLOW
PINK
TIP: Since line segments symbols are defined during
the import process, ft Is not possible to change
the color or symbol of a Une layer In the Layers
Editor. However, the color and pattern for
bounc"y layers is configured and changed from
within ••-:& Layers Editor.
80 WATERS User Guide
-------
Chapter IX WATERS Mapping System
The table below lists the default layers in WMS.
Color
Layer
Description
Red
Cyn
Purple
CITY
The 250 largest cities in the
U.S.
Blue WATER Lakes and large rivers
extracted from the USGS river
reach file
HUC
Hydrologic Unit Code
boundaries defined by the
major drainage basins
White STATE 48 contiguous states in the
U.S.
County County boundaries
Blue RIVER Rivers from the river reach file
classified as pollution
monitored
Yellow
HiWAY
U.S. Highways
WATERS User Guide
81
-------
Chapter X. WATERS Screen Editor
X. WATERS Screen Editor
WATERS contains all required and suggested data
elements contained in the UIC Program's Minimum
Data Set (MDS), as stipulated in Guidance #68.
However, EPA's Underground Injection Control
Branch (UICB) recognizes that many primacy and Dl
programs have more extensive data management
requirements. Consequently, UICB designed the
WATERS Screen Editor so you can tailor VVATERS to fit
your own program's needs.
With the Screen Editor, you can add new pages to
existing folders and define addition data elements
for WATERS to tracK. You cannot, h; .-ever, add
new folders or alter core pages - they contain
information from the Minimum Data Set which must
remain consistent for all WA~~RS users. This chapter
describes the use c the W/* . £RS Screen Editor.
Core Pages WATERS has fifteen core pages which contain
information from the Minimum Data Set. You
cannot add new folders or alter core pages. These
"core" pages and folders must be preserved in
. order to compile the EPA Form 7520 reports, and
track all of the MDS. For a list of the core pages, see
the Page Names table on the following page.
The core pages which cannot be edited include:
• pages 1-4 in the Permits folder
• pages 1-6 in the Inventory folder
• page 1 in the Inspections folder
• page 1 in the MIT folder
• page 1 in the Compliance/Enforcement folder
82 WATERS User Guide
-------
Chapter X- WATERS Screen Editor
Page Names
* page 1 in the Operations folder
» page 1 in the non-UIC folder
The Screen Editor assigns page names to all pages in
WATERS. These page names include a reference to
the folder name and a page number. The Screen
Editor uses this naming convention when saving new
pages. Below is a list of core pages and page
names. The Screen Editor will generate additional
page names in the sequence in which you create
them.
WATERS Page
Enforcement, page 1
Operations, page 1
Non-UIC, page 1
Page Name
Permits, page 1
Permits, page 2
Permits, page 3
Permits, page 4
Inventory, page 1
Inventory, page 2
Inventory, page 3
inventory, page 4
Inventory, page 5
Inventory, page 6
Inspections, page 1
MIT, page 1
PERMJ
PERM_2
PERM_3
PERM.4
INVJ
INV_2
INV_3
INV_4
INV_5
INV_6
INSPJ
MITJ
Compliance/ COMPJ
OPER 1
NONUIC 1
WATERS User Guide
83
-------
Chapter X. WATERS Screen Editor
Starting the The Screen Editor can only be loaded and used
Screen Editor when you are in DOS at the c: WATERS prompt.
(You cannot use the Screen Editor to add pages or
fields while in WATERS, or while other users are
accessing WATERS on a network.) If you are at the
• c: prompt, type CD/Waters and press I Retum 1.
Then type Scrnedit and press I Return ~\
TIP! The Screen Editor may request that you to enter
the data path It Ifie Screen Editor program is not
stored in the same directory as WATERS. If you
foSowed the instalatton instructions hi Chapter ill,
then the Screen Editor is In the same directory as
WATERS. _ w. _..,._„. _,._....
While your system loads the Screen Editor, a screen
will appear that is almost identical to the WATERS
start-up screen. The letters "SE" will blink at the
bottom of the screen which signifies that the Screen
Editor is loading.
Once the Screen Editor is loaded, you will see ;;
screen that resembles WATERS' folders. The majority
of the screen represents a blank page of an
unnamed folder (the "adding" screen). (This is
where all of the editing of WATERS screens will take
place.) At the top left are the menus: File, Edit,
Fields, and Color. When you select a menu or
option, at the bottom of the screen will be the menu
or option's description. Numbers in the top right
corner correspond to the page and line location of
your cursor.
TIP: When you add a new page to folders that can
have multiple records, a special tab notation lets
you differentiate between the page you are on,
and the particular record you are viewing. See
Chapter IV for an example.
84 WATERS User Guide
-------
Chapter X- WATERS Screen Editor
Menus
File Menu
There are four menus in the Screen Editor: File, Edit,
Fields, and Color. To access these menus, you need
to move out of the adding screen by pressing the
I Mt I key and the highlighted letter of the
menu you wish to access.
The File menu has several options that allow you to
retrieve existing pages in WATERS, and either save or
delete the changes you have made through other
menus.
The File menu has five options:
• Load Page
• Save Page
• Save Page As
• Delete Page
• Quit
You can access these options the same way you
access menu options in WATERS.
• Use m and LU to highlight the option you wish
to select and then press I Return 1
• Press the highlighted letter of the menu option's
title.
You cannot choose menu options that ore not
applicable. For example, you cannot select the
Delete Page option unless you have loaded or
saved a page. Options you cannot select are
shaded in the menu, and do not have a letter
highlighted in their titles.
The following section describes each of these
options in detail.
WATERS User Guide
85
-------
Chapter X WATERS Screen Editor
Load Page The "Load Page" function retrieves core and adds
pages from any WATERS folder so you can edit
existing pages. When you access this option, you
will see a pop-up list of WATERS pages grouped by
folder. To select a page, highlight its name by either
using your L2J and LU and press I Return \ Once
a page is loaded, it looks exactly like it would in
WATERS.
TIP: If you Joad a core page, you can only save color
changes. For example, if you load Perm_l and
try to add a field, you wi not be able to save the
page as the corevpaaj? PetrnJ.
Save Page The Save Page option saves updates to pages
created with the Screen Editor. If the current page
has a name, you can select the Save Page option.
A page is named if you loaded an existing page or
previously saved the page. If the page has a name,
the Screen Editor displays it in the top right corner of
the screen. If the page is unnamed, then the Screen
Editor automatically reroutes you to the Save Page
As option, which is discussed below. After using the
Save Page option, the Screen Editor returns you to
the field you were on when you selected the option.
Save Page As The Save Page As option names a new page and
saves it in a folder.,
When you select the Save Page As option, the
Screen Editor asks you to choose a database if you
have not already done so through other menu
options (see the Select Database option under the
Edit menu). A new window then displays the list of
page names for that database. The left column
identifies three types of pages: core, used, and
available. Used pages are pages that have been
added to WATERS using the Screen Editor. If you
select a used page, you will replace that page with
the one you are trying to save. An available page is
the next empty page in the database. When the list
86 WATERS User Guide
-------
Chapter X. WATERS Screen Editor
of page names appears, the next available page is
highlighted in red.
You can use this function to save a page in two
different folders. For example, you may want to add
the same page of inspection data elements to both
the MIT and Inspections folder. First make the
changes or additions in one folder. Save them with
the Save Page option discussed above. Then use
the Save Page As option to save it to the second
folder.
Delete Page The Delete Page option deletes the page displayed
on your screen. You will get a message to confirm
your choice. When you select this option, the
Screen Editor will ask you to confirm that you want to
delete the page. If so, select yes.
TIP: You cannot delete any core pages ir> WATERS.
Core pages contain information .from the
Minimum Data Set
The Quit option ends the session with the Screen
Editor and returns you to the DOS prompt. To start
WATERS, type WATERS and press I Return j
TIP: After using the Screen Editor, WATERS wl take
longer to load because the database indexes
must be rebu8t. , • • .. i :
Edit Menu The Edit menu contains options that allow you to
alter, move, erase or clear entire blocks of the
screen you are creating. You can also add special
features and characters to the screen
The Edit menu has five options:
* Move Area
» Erase Area
» Clear Screen
• Draw Box/Line
Quit
WATERS User Guide
87
-------
Chapter X WATERS Screen Editor
• Ascli Character
You can access these options the same way you
access menu options in WATERS:
• Use LU and UJ to highlight the option you wish
to select and then press I Return "|
• Press the highlighted letter of the menu option's
title.
The sections below explain each of the options in
the Edit menu.
Move Area The Move Area option moves blocks of text on a
page. There are two stages in repositioning a block
- determining the parameters of the block to be
moved, and moving it. Place your cursor in the
upper left corner of the block you want to draw.
Then select the Move Area option. A small sample
block appears on the screen in place of the cursor.
Change the dimensions of this block by using the
cursor keys listed in the message box in the lower left
comer of the screen. Press I Return ~| When you
finish re-configuring the block to cover the area you
want to move. Use the same cursor keys to move
the block you have just defined to its new position.
Use the same command keys to place the block
and press I Retum I
Erase Area The Erase Area option erases whatever block you
define. (The Erase Area option behaves like the
Move Area option.) This option is useful when you
want to delete a portion of a page. Place your
cursor in the upper left corner of the block you want
to draw. Then select the Erase Area option. A small
sample block appears on the screen in place of the
cursor. Change the dimensions of this block by using
the cursor keys listed in the message box in the lower
left corner of the screen. Press I Return ~| fO erase
the area.
88 WATERS User Guide
-------
Chapter X. WATERS Screen Editor
Clear Screen
Draw Box/Line
Ascii Character
Fields Menu
TIP: You cannot choose menu:options that are not
applicable. Options not app8c.able are shaded
: ••: and no tetters are. htghigKted. You must have
.text on the screen In order to select either the
Move or Erase Area options..
The Clear Screen option clears all text on the screen.
The Draw Box/Line option draws a line or a box in
the designated space. To draw either a box or a
line, place your cursor in the left end or corner of the
line or box you want to draw. Select the Draw
Box/Line option, and select either a single or double
line style. A small segment of this line style will
appear at the left end of the line you want to draw.
To turn this segment into a line or box, use the cursor
keys at the bottom of the screen. When you are
finished drawing, press C
Return
The Ascii Character option displays an Ascii
character on the screen where designated, Ascii
characters cannot be created using the standard
keyboard. For example, you could not type a
check mark (/) or LLJ and LU . To create an Ascii
character, move your cursor to the spot where you
want to place the character. Then select the Ascii
Character option, which will display all the available
symbols. Position the cursor on the symbol you want
and press I
to select it and position it on
the screen.
The Fields menu allows you to create, modify, or
revise fields. Fields contain the well-specific
information for a particular data element. For
example, "Rule Authorized" is a specific data
element on page one of the Permits folder. The
space where you type Y or N. is the first field of the
Permits folder.
The Fields menu has these options:
• Select Database
WATERS User Guide
89
-------
Chapter X. WATERS Screen Editor
• Insert Field
• Create Field
• Move Field
» Erase Field
« Revise Field
You can access these options the same way-you
access menu options in WATERS:
* Use LiJ and LU to highlight the option you wish
to select and then press I Return 1
• Press the highlighted letter of the menu option's
title.
As with the Rle and the Edit menus, you cannot
choose options that are not applicable. Options
that are not applicable will be shaded, and no letter
will be highlighted.
The sections below explain each of the options.
Select Database The Select Database option allows you to select a
database when creating or inserting fields. You
should select a database before you select the
Create Field or Insert Field options. Below is a list of
folder names and the corresponding databases.
Folder Name
Permits
Inventory
Inspection
MIT
Compliance/
Enforcement
Operations
Non-UIC
Database
PERMIT
PERMIT
INSPECT
MECHTEST
COMPLY
OPERATE
NONUIC
90 WATERS User Guide
-------
Chapter X WATERS Screen Editor
If you want to add fields to a particular folder,
choose its corresponding database.
If you have used Insert Field, Create Field, or Load
Page, then the Select Database option is not
applicable. It will be shaded in the menu, and the
"S" will not be highlighted.
insert Field The Insert Field option inserts existing fields onto a
new page. Use the Select Database option to
specify the database locations for the field(s) you
want to insert. If you do not make this designation
before using the Insert Field option, a pop-up
window will display the database names for you.
You must select a database before continuing with
the Insert Field option.
After you choose a database, a new window will
appear with a list of database field names and
descriptions. Highlight the field name you want to
insert and press I Return 1 The screen Editor
places that field where your cursor was prior to
selecting this option.
TIP? When you insert a field, you are not just inserting
rts formaf and color from WATERS; you are also
inserting the well-specific data on your new
page.
Create Field The Create Field option allows you to create and
define a new field. Before creating a field, you must
designate a database using the Select Database
option. If you do not select a database through the
Select Database option, the Create Field option will
generate a pop-up window that lists the available
databases. After you have chosen a database, a
new window lists the following field attributes:
• Field Name
• Long Field Name
• Type
WATERS User Guide 91
-------
Chapter X WAT"~S Screen Editor
• Length
• Decimal
• Display Format
• Required
* Field Color
Field Name The Field Name is the official name of the new field.
This is the name used to identify the fields in the
WATERS database. This name must start with a letter
and have no spaces. The body of the name can
have letters A to Z and numbers 1 to 9. You cannot
save two fields with the same name.
TIP; Once you have saved a field name, you cannot
alter tf with the Revise Field option. You can only
delete the field.
Long Reid Name
The Long Field Name is the description of the field.
Unlike the Field Name, the Long Field Name does
not have to be continuous. Describe the field as
accurately a? possible, because the description will
be used late1 -or example, wnen you create
custom repor;. These field descriptions would head
the data columns; when you press LEU, these
descriptions would appear in the pop-up help
window.
Type: The jype at"..-_>ute specifies the type of field:
numeric, loc:cal, date, or character.
Length The Length aefines the length of the i:eld. Eacn field
type has different length limitations. See the table
below:
Type
Length
Numeric
1 to 25
Logical
Date
8
Character
1 to 74
92
WATERS User Guide
-------
Chapter X. WATERS Screen Editor
Decimal
Display Format
Required
Field Color
The length of a field includes the space for decimal
points in numeric fields. However, length does not
include commas for numeric fields, or slashes (/) for
date fields.
The Decimal describes the number of allowable
decimals in the numeric fields. This is applicable for
numeric fields only. The default is 0.
The Display Format describes the format you want
the field to appear on the screen in, if any. Press
L^ for a list of all formats applicable for the field
type you selected earlier. Once you select a
format, an example of it appears to the right of the
Display Format option. You can leave this blank.
A Required designation identifies fields as required.
Once a field is designated as required, you must fill
the new field in order to save a record in WATERS.
For example, "Rule Authorized" is a required field.
The field color function allows you to choose the
color you want a particular field to be. Press the
F1
key to designate a color for a particular field.
For more detailed instructions on how to use the
color chart, refer to the Color menu section.
To create your field, specify the characteristics you
want and press I control 1. vy to save. In order to
save, you must specify the field name, type, length,
and whether or not it is a required field in WATERS.
The Screen Editor places your new field where your
cursor was prior to selecting the option.
TIP: For examples of field names and long field
names, access the insert Field option, or turn to
Appendix B.
WATERS User Guide
93
-------
Chapter X WATERS Screen Editor
Move Field
Erase Field
Revise Field
Color Menu
The Move Field option repositions fields on a page.
Use this option if you want to move a single field. If
you have several fields to move, use the Move Area
option instead. To select the field you want to
move, place your cursor in that field before you
select this option. Once you access the Move Field
option, use the
and LLJ to move the
field and press I Return | fO p|ace jt.
The Erase Field option erases the field name and all
the attributes you designate prior to selecting the
c - tion. A pop-up window will ask you to confirm
that you want to delete this field.
The Revise Field option displays the list of field
attributes available for editing. If you try to revise a
field you have added, you can change all attributes
except the database designation. (You can only
change the color of core fields.)
To revise a field, place your cursor in the field to be
revised. Once you access the Revise Field option,
you will see the list of field attributes available for
editing. Make the necessary changes, and press
I Return |
The color menu allows you to alter the background
and foreground default colors of any single page,
and all the fields on a single page. This page can
be part of the core page or your own additional
pages. The colors of a page and its fields are unique
and specific to that page. To change all the pages
in WATERS to different colors, you must change the
colors of each individual page.
94
WATERS User Guide
-------
Chapter X. WATERS Screen Editor
TIP: The Color menu wi change the colors of fields
with the default color. However, you can assign
certain fields specific colors with the Create Field
and Revise Field options. These specific field
colors wiH not change when you use the Color
menu option. For example, if you make the "Well
ID" field yellow, and the default color of the other
fields is red. 1 hen the Color menu wffl only change
the red fields to a new color.
The Fields menu has two options: Screen and Fields.
You can access these options the same way you
access menu options in WATERS.
1. Use Li] and LU to highlight the option you wish
to select and then press CH^EH].
2. Press the highlighted letter of the menu option's
title.
Color Chart When you select either option, the same window
appears with a color chart for both the foreground
and background. To switch between the
foreground and background colors, use the ' I
and i"*"! To select a color in either column, you
have two options;
Use your l_LJ and
color you want
to move the triangle to the
• Type the capitalized letter adjacent to the color
you want.
At the top of the window, the Color Selection
Example box lets you see how different
combinations look. When you have marked both
the foreground and background colors you want,
press I Return I.
WATERS User Guide 95
-------
Chapter XI HELP
XI. HELP
If you have problems running WATERS, there are two
sources of on-line help: the WATERS and WMS Help
menus, and WATERS on-line help. The Help menu
provides a synopsis of key commands and
procedures. On-line help descrioes fields, or if
applicable, lists their data entry codes when you are
entering, editing, copying or querying a record.
Since the Help menu has already been described in
Chapter VI, this chapter focuses on on-line help and
DOS trouble-shooting tips.
On-line Help WATERS on-line help provides users with field
descriptions or pop-up lists of data en try codes for
use in performing queries or using the Edit, Add,
Copy options. To access on-line help, place your
cursor on the field in question and press LELl.
Many WATERS fields, such as "Permit Number" and
"State", do not have established data entry codes.
For these fields, the on-line help displays a pop-up
window containing the appropriate field
descriptions. You can press any key to remove the
window.
Fields that a^e restricted to a set of defined values,
such as "We; Class" and "Type", will display a pop-
up list. ExhioiT XI-1 below is an example of a pop-up
data entry code list.
96 WATERS User Guide
-------
Chapter X!. HELP
Exhibit XI-1
f Up Fid **" l-eft Char/Fid FS^D Next Page fl Help
i Down Fid *•* Rgut Char/Fid lac Exit without changes la* Toggle Over
pemuts 1 i invfrnterv f ;r^fiG?"iGS I 1 *rr ' ' n^r^/r** i i av>ra--r.r^ i
:
•
•i
•
*
3
•
•
a
a
3
•
•
P Rule Aucnoriz*d N
0
p Application Muunber JfTllSilt w*11
ld«nt l f ler Oyff735*: *: •
£ Perwit jfSoBJjaer i*r£2T«3k "^VP* of w*^^ Ppwtd eohv»rted
D Type of Well Ptnni: *re* Class
0 NO, o; w«;i s/pt»r«it 3 lyp*
O '
p Application D*t# / / Tech;
D Date P*r»it Hawed / / i*ui>i
^ Date Permit Ef Iect:we / / Pu&t
Q D*te Permit Modified . / 4 P*n»
4
2* fc*ZMal*r X&j*et.laa
2C Smlt W«t«r OiapoiMii
2X oth*r Clasii II
O D*te Plugg*d/AlMndon»d / / D*te Permit Denied :;. '; /'ii/; V
•0 Conaercial Facility * Sate Withdrawn ;:;•.-; ::/. ;>/V- '.-
.tree* , j son-inc edit «*r*u
?gual
21
GJ
ra
t^l,-l
When the on-line help produces a pop-up list you
have two ways to select a code. You can either
type the highlighted letter, or use
highlight the option and press
and
Return
select a letter that is not a valid option (not a listed
code), there will be no response. In order to return
to the data entry screen without selecting an option
press
[ Escape
The pop-up list is a tool to help you in the data entry
process, not a necessary step to add, edit, copy or
query a record. If you already know the code, you
can simply enter it. However, even when you know
the appropriate codes, using the pop-up lists is faster
whenever the codes are more than two letters. To
select a code from the pop-up list you only need to
type the single highlighted letter.
For example, press lELl in the Frequency of MIT
Tests field on the second page of the Permits folder.
You will see the options Annually, Semi-Annually,
Every 5 Years, and Other. Type A, £, E, or O_ to
choose an option. WATERS automatically writes the
full two-letter code on the screen.
WATERS User Guide
97
-------
Chapter XI. HELP
DOS Trouble-
Shooting Tips
File Handles
You also have the option of typing the first two
letters of the option in order to select it (I.e., AN for
annually). Again, WATERS displays the full field value
on the screen.
DOS commands can be used to alter your
computer's configuration so that -an
accommodate the WATERS prog, m requirements.
There are three trouble-shooting tips about DOS that
may help you use WATERS more easily. They are the
SHARE program, the UTILITY PACK program, and File
Handles.
If you are having difficulty running WATERS, the most
common problem is insufficient memory dedicated
to the WATERS program. If you do not have enough
memory to open the necessary WATERS files, your
system can send you many different and confusing
messages while running WATERS or WMS. For a list of
these messages, see the table on the following
page.
What
Details
WATERS message
DOS Error 4: Too many
open files (no file
handles left). Increase
FILES= in c:\config.sys
and/or File Handles= in
c:\shell.cfg.
WMS messages
Unable to open file
Error reading file
Error opening
WMS.NUM
Error reading
WMS.NUM
98
WATERS User Guide
-------
Chapter XI HELP
Option 1: Check your
c: \ conf ig. sys file.
Step 1:
Step 2:
Step 3:
Step 4:
Option 2: Check your
network directory.
Step 1:
Step 2:
Step 3:
Step 4:
Option3: Consult your
LAN administrator.
There are three ways to change the amount of
memory allocated to run WATERS. Each are
explained below, in the order you should try them.
The config.sys tile controls the number of files that
can be open at one time. To run WATERS, you need
at least 83 file handles. To check your conf ig. sys
file, follow these steps:
Quit WATERS and return to DOS. You should see c: \
on your screen.
Type edit c:\config.svs and press I Return \
If the number at the end of the Files = line is less
than 83, edit the line so it reads Files = 83.
Start WATERS. If you are still having memory
problems, see option two below.
The shell.cfg file in your PC network directory allows
you to open a certain number of files. To check the
file handles in shell.cfg, follow these steps:
Quit WATERS and return to the DOS prompt.
Type edit c:\shell.cfg and press I Return I
If the number at the end of the File Handles = 77
line is less than 77, edit the line so it reads File
'Handles = 77.
Start WATERS again. If this does not work, see option
three below.
The LAN administrator may not have allocated
enough file handles to open the files you specified in
your config.sys or shell .cfg files. To run
WATERS, your LAN administrator will have to increase
the number of file handles available.
WATERS User Guide
99
-------
Chapter XI. HELP
The SHARE
Program
UTILITY PACK
program
SHARE is a component of DOS that allocates file
space for file-sharing information. It is
recommended that you do not run the programs at
the same time, since combined with WATERS, it can
produce erratic results. However, DOS 4.0
automatically loads SHARE, so this may be
unavoidably. Regardless, if you do run SHARE while
using WATERS, you should increase the capacity of
the SHARE program by typing /F: and the increased
number of bytes SHARE needs.. There is no hard-
and-fast rule for the number of bytes needed, but
the longer the WATERS path name, the more space
SHARE requires. Refer to your DOS documentation
for more details on SHARE.
When you delete records in WATERS, your hard drive
still marks the space these deleted records took up
as occupied and the Tally option counts the deleted
records. It will continue to do so until you use the
UTILITY PACK program. This program will "re-pack"
that disk space, i.e. compress the records of all
database files by permanently removing the
deleted records. UTILITY PACK frees up disk space
and can even increasing system speed. Therefore, it
is a good idea to use the UTILITY PACK program
once every one to three months. The more records
you delete from WATERS the more often you should
re-pack your database.
To repack, type Utility Pack at the c: \WATERS
prompt. If by mistake youtype Utility, the program
will ask if you want to delete or pack. Type P.
TIP: It is critical that you do not type D because you
wil detete al your data)
The UTILITY PACK program also deletes WATERS'
internal index files. When you load WATERS next, it
will automatically reindex the database. Like the
first time WATERS was loaded on your machine, the
loading process will take longer than it normally
does.
100
WATERS User Guide
-------
Appendix A. WATERS Training Script
Appendix A. WATERS Training
Script
This training script gives you step-by-step instructions
for many WATERS features. All new WATERS users
should review the entire script before starting to
enter well data into the system. After you become
an experienced WATERS user, this script will serve as
a handy reference tool.
Topics covered in the script include:
* Moving Between Folders
• Moving Between Pages of a Folder
* Adding a New Well to WATERS
• Copying a Record
* Editing a Record
• Listing a Record
* Finding a Record
* Saving a Query
• Loading a Query
• Deleting a Query
* Deleting a Record
• Printing a Well Schematic
• Producing 7520 Reports
• Producing a Custom Report
• Quitting WATERS
Each section tells you which keys to press and what
options to select to complete a particular function.
WATERS User Guide A-1
-------
Appendix A. WATERS Training Script
The script also contains many examples of WATERS
screens to further assist you in learning to navigate
and use the system effectively.
This script shows you how to perform most WATERS
functions. To simplify the script and avoid
redundancy, each function is usually described for
only one folder. However, you can use these
functions in all of the folders. If there are any-
notable differences among the folders, they will be
discussed at the end of each section.
A-2 WATERS User Guide
-------
Appendix A. WATERS Training Script
A. Moving
Between UIC
Folders
Step 1:
WATERS contains six separate UIC folders that store
different sets of data elements. When WATERS starts,
you are in the Permits folder. To see all of the data
for a particular UIC well, you need to be able to
move freely between folders. In this example, you
will move from the Permits to the Inventory folder.
Access the Inventory folder. There are two ways to
do so:
• Type i, the highlighted letter for the Inventory
folder.
• Use the i*"' and i*^H to highlight the Inventory
folder. Then press L
Return
With either method, the screen below appears.
Notice the taller box for the Inventory folder. The
taller box indicates that the folder is active. Also
note that the number 1 on the right side of the
screen is in a red box that is wider box than the other
page tabs. This indicates that you are on page one.
Exhibit A-1
File idi t | Querv Belc [ ====
Permits Inventory 1 n»pe
n Columbu- Encr • <~
======-= -WATERS State System*- jnn=--= i=s"«-«= ><•
ction HIT [J comp:,Er,£ Operations
-O Permit UT897S647W State LTTCountv
• *0 Rule Auth N Region 11 Discr::i
"SO Part 1: 1C information
•"O finds NC. Field Name
= =0 AP! Number 43037:6517 Fedl Land
• SQ ' Facility ID Indian Land
• O Ownership Private
= an Part 2: Locational Indorsation
s su Section 28 Metft of Collect ion Cadastral Survey
• O Township 42S Accuracy
= 50 Range 22 E Description
" "O Latitude
= JO SE 1/4 NW 1/4 ;/•! 1/4 Longitude
S$J In Wellhead Protect : on Area Y Public Water SuDDlv Wells in AOR 1
-...-.
[iPoUpl
|i ?|
11 .
MPciDnl
TOC | Hon-L'IC Jswitch to Inventory for this Well |
Step 2:
Type P to return to the Permits folder.
WATERS User Guide
A-3
-------
Appendix A. WATERS Training Script
You can see from the screen below that you have
moved back to the first page of the Permits folder
(the Permits box is taller and the number 1 is both in
a wider red box).
Exhibit A-2
•File Id it Query5 Help |=s====s= ==±s=WA7£RS State Systero== ========= === = =====
fermits Inventor.- ) Inspection ( f HIT ] | Compl/Enf I | Operations |
8
•
•
•
•
-
*3 Rule Authorized N
SQ Application Number it'tr: «e . '. Identifier l'T02337
O Permit Number UT89"St»4~w Type of Well Prratd Converted
5 Type of Well Permit individual 71ass 2
30 No. of Walls/Permit 1 7yp« 2H Liquid Hydroc
3D
5 Application Date :9oT.Ci'3S 7*cnnical Review 1967/01/1S
^ Date Permit Issued :967 C" ;t >j = ;;c Notice 1967/06/18
O Date Permit Effective ;96"VC3 :'. f-jtiie Hearing 1967/07/'.7
JS Dace Permit: Modified 1969. C* " f«rnit Tlerm 5 Years
!!C | . ;ch to Per-..: :cr • .; «*i:|
= «-- .-
Pnl'pl
3
3
3
3
You can move among all six UIC folders using this
process In acdition, if you '-* :sh to view all of the
screens in all of the folders, start with page 1 of the
Permits folder and press I Fage Down] WATERS takes
you through all of the folders sequentially, allowing
you to see each page of each folder.
A-4
WATERS User Guide
-------
Appendix A. WATERS Training Script
B. Moving
Between Pages
off a Folder
This section describes how to navigate between
multiple pages of data elements in a folder.
This example starts in the Permits folder, which is in
Exhibit B-1 below. Note the numbers on the right
side'of the page. The number 1 is highlighted and in
a wider red box, indicating that you are currently on
page 1.
Exhibit B-1
Fi le
Id it
Permits
:
:
•
•
s
m
:
:
Query
Help
= ======= ===e=WAT£RS State System======- ============== *~ - * -*
Inventory | | Inspection
Op: Columbus Energy Co
SO 01 * . k
SO
S
•8
:o
:n
:o
•n
!U
•O
•o
so
!O
:0
sO
Application Number
Permit
Type of
No, of
Number
Well Permit
KIT
Compl/Enf y Operations
867585 Well Identifier UTQ2337
UT89756.J7W
Individua 1
Wells/Permit 1
Application Date
Date Permit Issued
Date Permit Effective
Date Permit Modified
Type of
Date PI
Permit
Mod
1967/04/05
1967/97/26
1967/08/25
1 969/07/07
Permit Tra
ugged/Abandoned / /
Commercial Fac i
ilty N
Type of Wei
Class
Type
1 Prmt d Conve reed
2
2H Liquid Hydroc
Technical Review 1967/01/15
Public Not ice 1967/05/18
Public Hearing 1967/07/17
Permit Term
Expiration
Date Pernu t
5 Years
1993/03/!?
Den led / /
Date Withdrawn / /
1
: TttC.
•on
-UIC [Switch to
Permit f or
This well |
!t=p^
I
2
3
_£
PqDri
Step 1:
Type 2 or press I Page
This moves you from page one to page two. Your
screen will look like Exhibit B-2. The page contents
have changed. Now the number 2 is in a wider red
box.
WATERS User Guide
A-5
-------
Appendix A WATERS Training Script
Exhibit B-2
rile
Edit
Permits
i
:
i
i
:
i
:
:
i
i
:
:
•
Query
Help
| Inventory
1
— Op: Columbus Energy Coi
•0
;O Frequency of MIT Tests
*§ Well Coordinates Lat/Lc
=O Latitude/Longitude Oat(
SO
^O Inject ion Data
I? Injection Pressui
•0 Injection Rate/Me
Is
S0 Recording Frequency
•0 Inject ion Pressui
E§ Flow Rate
•O Injection Volume
-- ._
Inspection | 1 KIT | | Compl /Enf | | Operations |
Annually
sng 37*10'49.3158
> 1937/02/03
•e 500 psig
'a sure 450 bbls/day
•e Week ly
Mont h 1 y
Mont h . v
/ 109'33'20 .3061-
: : • : OJ^1
.:.:.) Hon
-UIC (switch to Permit for this Well
,
1
Step 2:
Step 3:
Type 1 or press i rage up | to move back to the first
page of the Permits folder.
To move to page 3 or 4, select one of those numbers
or use the I Fage Down"| key.
Try changing pages using the number keys,
I rage up "j and I rage uownl until you are
comfortable with the process.
Moving from page to page in the Inventory folder
involves exactly the same process. The only
difference ;s that the Inventory folder contains six
pages rather than four.
A-6
WATERS User Guide
-------
Appendix A. WATERS Training Script
C. Adding a New
Well to WATERS
Step 1:
Step 2:
When you need to enter data for a new well into
WATERS, use the Add function. The first folder you
should enter new well data into is the Permits folder.
WATERS will not allow you to enter data for a well in
other folders unless the Permits folder contains a
record for that well. When you add a permit record,
an inventory record is automatically created. After
entering data in the Permits folder, you should then
enter data into the Inventory folder.
This example explains how to add a new well record
to the Permits folder.
Type P to move to the first page of the Permits
folder. The label for Permits folder will be highlighted
like the screen below.
Type E to access the Edit menu. Exhibit C-l below
shows Edit menu options. The Add function is
located under the Edit menu.
Exhibit C-1
Tile
Per";
s
M
•
•
z
m
m
•
3
S
:
=
s
m
—up
c
#Ut lo-er.
Add
Delete ?S.
Tshl*
IHt . : 1 ; »s = = = ^ = s = = = = WATERS State Systems = = »* = = « = = = = = » = = = = = = = = = =
•a H
:0 Applicat ion N^imDer 14?853 Well Identifier LT023S 3
•O Pernu t NumDcr CTI 2 34 A Type of Well Prmtd Converted
5 'Type of Wei* PerTUt Area Class 2
^) Ho. of Wei Is/ Perfjit, 3 Type 2S Eiihar.ceo Reco
3D
JQ Application D^ce / / Technical Review / /
;0 Date Permt Issued / / Public Notice / /
aO Date Pertr.it Zt feet i ve / / Pobl ;c Hearing / /
S 3dte Permit Modiiiec / / Permit Term 10 Years
=O
;Q Typ« o* Pfrritii;
•Q
Mod Expiration / /
3O Date Plu gged/AJsandoned / / Date Permi t Denied / /
sQ Commercial Facil.ty K Date Withdrawn / /
•0
-- .-
]
: -SIC
1 Bon-UIC
Add a Record J
?yjo I
4
n
D
FpoDnl
WATERS User Guide
A-7
-------
Appendix-A. WATERS Training Script
step 3: Choose the Add option by typing A or by pressing
and
L
Return
to highlight Add and then pressing
When you select the Add option, you
get a blank screen like Exhibit C-2. You can enter
data into the red fields or spaces. You must enter
data into the pink fields in order to save the record.
Exhibit C 2
f Up Fid •* l*tt Char/ Fid ?sB3n Ntxt ffege Fl Help
i Down Fid ~* f^ht Char/Fid B«c Exit without changes ^* 1093!* Over
PeiBilc ( | Inventory | ["""
1
•
«
I
•
•
:
-
f
I
:
i
Inspection f | KIT | | Conpl/Ehf | | qpe rations)
O Rule Authorized
O
S* Application Nuaber
Q Permt Nuafctr
O Type °f Hell Permit
O No. of Hells/Perait
O
~ Acplicacicn Date
Q Date Pernit Issued
1*11 Identifier . " .
'' Type of Well Pratd
Class
Type
/ / Teainicil Review
•" / t- HiBlicftotice .'.-...-. jf''y'^':f.:-
Q Date Perait effective / / RiUic Heanng :! •":"-?>' ":://":
O Date Permit Modified
O Type of Permt Mod
O
t I Remit l»r» •' Vrfir*
Bcpi rat ion .:^'::-. -•:.!/•'. ''".;/.
o Date Plugge#At»ndoned f f out Peu.it Denied :•/"' : f '•''">..("
Camera a 1 Facility
Date tfiuidtawn <•: • • f f
' tKB. J ton-OlC |sdit Meny
II PaCbl
a
p
Q
PQftl 1
Step 4: Enter a 1 or a H in the "Rule Authorized" field, and
then enter data in the remaining red or pink fields.
Step 5, When you finish entering data on the first page,
press [PageDown] to move to the second page.
Continue entering information and pressing
I Page Down"] until you have reached the fourth page.
Step 6: Save your new record when you finish entering data
on all pages. To save the record, press
or [ control 1 - w. A menu appears presenting you
with three choices: Save, Discard, or Edit. See
Exhibit C-3 for an example.
A-8
WATERS User Guide
-------
Appendix A. WATERS Training Script
Exhibit C-3
f Up Fid *"* Left Cnar/Fld ^jOn N«xt Page
1 Down Fid -* Rght Char/Fid *•"= Exit without changes
n
u»
H»ip
Togg 1 * Ow r
Permits | ( Inventory | | Inspection 1 | MIT [ J Cowpi/ihf | | Operations!
:
i
•
•
- •
•
•
s
s
•
a
•
«3
,O Rui» Authonz«d t
=0 '
jO Ptrmt Nwitotr II s*v* ctangt* 1
u Application D*t* • .- -:/. '• :/: -:--". T*c*trucai Revi*w .;• ! '•'/'' •:^-":".
JO Dat« F»rsiit l»u«d . .:.:•/..'./.'••.:":.: Public Not »c* :-'.'' '*:"/:--B
Jg o»t<- Ptrmit Effectiv* ' .'•'/","/•'•' Public H»«nna '". :/.''4l[ -. /
,3 oat* Prrr.i: Moii:f:«d •/ •/•:..': P»m: T»r»i - - Years
^3 Typ* of Petmit Mod . Expirof.on '.. / ,j ..'.
S3
5 Date Plu93«3/Aoaricon*d .- / / ''i--v D«t« P«ou t Deni»<3 "•--. / -^ •
f) Commercial facility .r. Date Withdraw ?-:x.":f':'-''f '•••;.
[
1 Pq-Jpj
3
a
Q
El
PcjDnH
CV J Ifon-UIC jalit Menu |
Type S for save or use the r*"l and
highlight the Save option and press
keys to
Return
Step 7: Once you have created a record in the Permits
folder, you can begin to add records to the other
folders. Follow steps 1 through 6 above to select a
folder, execute the Add function, and enter data
into the open fields displayed in red.
WATERS User Guide
A-9
-------
Appendix A. WATERS Training Script
D. Copying a
Record
Step 1:
Step 2:
Step 3:
Copying ell record is an easy process that can
save date / itry time. This function copies the
information in the current well record into a new
record so you do not have to retype data for a well
with similar characteristics.
You can use the copy function to copy well
information in all folders except the Inventory folder.
When you try to use the copy function while in the
Inventory folder, WATERS automatically moves you
to the Permits folder to execute the copy function.
And when you copy a record in the Permits folder,
WATERS automatically copies the Inventory folder of
the well.
In this example, you will copy a well record in the
Inspections folder.
Type S_ to choose the Inspection folder.
Type £ to access the Edit menu.
Type £. to access the Copy option. The copy
function will be highlighted as it is in Exhibit D-l.
Exhibit D-1
Verwi '
1
•
i
•
*
i
:
!
\
i
!
i
i
•
"
i
•o
O
3D
«>
0
S3
•Gilt -..
— * ^
"* " ^.' 1 [ ' ^*r»r>: : ^n 11 KTT 1 1 Como. 'E n! I I Ooerat ions 1
Table - d updated 1992/08/12
SspecTor Name/ No. _oe C./W)1
JQ Date o£ Inspection 1992/06/17
SO Type of Inspect ion CR Compliant Response
sO
ap Complaint Reso
SO
SO
sn
rime Required
lution well contaminated
2 days
^•j Qnergency Resolution
O Time Required
SO
sO
/iol. Discvd/P
JQ Action Taken
days
resent ?
Operator to Correct tnon-vi olat ion}
i'SHECC.-."": | man- me
Copy Current Record |
PgUp!
PaDnl
A-10
WATERS User Guide
-------
Appendix A. WATERS Training Script
Step 4: Change the necessary data to make the new
record unique. The fields in pink (in this example,
"Well ID" and "Date of Inspection") are fields you
must change. Those in red are ones you can, but
are not required, to change. See Exhibit D-2.
Exhibit D-2
T Up Fid *- Left Crtar/Fld PaDn Next Page
I Down Fid -• Rght Char/Fid **c Exit without changes
n
In*
Permits
Inventory
I nspection
Help
Togg1e Over
CampI/Enf
Operations
Wei I Ider.t; lier
Date Record Updated
IQ Inspector Name/No.
• "O
ISO
-UTO380
pq'Jel
C./9893
s=0
• "O Date of Inspection
^^ Type of Inspection
*O
"O
:ao
• o
Complaint Resolution
Time Requi red
C8 Compliant Response
2 days
Emergency Resolution : :. .- .-:... •- •
^° Time Re
-------
Appendix A. WATERS Training Script
Exhibit D-3
T Up Fid *- Left 'Char /Fid FgBn Next Page M. Help
i Down Fid -"* Rght Char /Fid EMC. Exit without changes Xn* Toggle Over
Femats [__
i
i
i
a
«
i
s
i
•
•
:O Well I
|§ Date R
JQ Inspec
j§ Date o
:O Type o
•O
•Q Conpla
Itwentorv I I inepeccion ( | KIT
UNCAN
dentil
ecord
tor Na
£ Ini
£ Ins
int r
:0 ^
IQ Emergency R«
•O Time Requiw
:O
.0
8Vi ol , Discvc
Ac t i on Ta ker
Updated i#^>«^/:»» ._
"'" ' """uV'i"'
_[ Conpl/Enf LJ Operations
Save changes
i^J [^iscardj i^JdUj
• solution : f r-s:*;-;* :« ;;«;•;. .;•• ;.; ;.:_;.¥« - .
sd %V.;:j:;days
I/Present |t..
Aerator to Correct ( non-violat ion)
::-:> Die At- J »on-uic
Edit Menij
|PaUp|
Type ^ for save or use the r^"l and
highlight the Save option and press
keys to
Return
A-12
WATERS User Guide
-------
Appendix A. WATERS Training Script
E. Editing a
Record
Step 1:
This function allows you to correct mistakes and to
update records as information changes. In this
example you will edit a record in the Inventory
folder.
Type I to choose the Inventory folder, which is shown
in Exhibit E-1.
Exhibit E-1
Fi le | Wit
Permits
H
•
a
s
•
•
•
s
•
"O Penut
•0 Rule Aut
SO
so Pa rt 1 :
Query | Help | = = ==-
Inventory " r,»pe
LT8975647W
h N
ID Inf ormat ion
«O F: nds No.
=0 API Number 4303716517
so Facility ID
<) Ownership Private
=0 Part 2:
W Section
Locationa; Informal
28
O Townshio 42 S
SO Ra nge
K)
22 E
*O S£ 1/4 NW 1 /< l-'4 "/4
*D !-, Wellhead Protection Area
»:»:*»» ^WATERS State Syste»=»«»=- •»»* =»*= -=»«» «= »-
-. . _
ction MT || Compl/Enf | Operations |
State UT County
Region 11 District
Field Name
Fedl Land
I ndi a n Lan d
on
Meth of Collection Cadastral Survey
Accuracy
Description
Latitude
Lonci tude
Djbl ;c water Suoolv We'.ls : i AO° 1
OSC | Hon
PqUpJ
13
3
3
il
"^1
PjDr.J
-VIC [switch to inventory far this Wei'. ]
Step 2:
Step 3:
Type E to access the Edit menu.
the appropriate fields. You can change the
information in any red field.
Your screen will look like Exhibit E-2 on the following
page.
WATERS User Guide
A-13
-------
Appendix A. WATERS Training Script
Exhibit E-2
fi le I idit I Query | Belp
•WATERS State System=
Inventory
In«pget ion
ICT
ttanpl/Eni
55Q
••o
a«0
= aO
• O
• O
= 80
a SQ
' Op: Col umbu s En crgy Corp .
Permit UT8975647W
Rule Auth K
Part Is ID Information
Finds »o.
API Number
Facility ID
Ownersh ip
Part 2:
Section
Township
Range
State ^ county
Reg ion f£ Distri
Field Name
Fedl Land
Ind ian I^and
Meth ol Collection
Ace uracy
Descript ion
Lat itude
Longitude
dastral Survey
37*10 '49. 3158*
109«33'20.3061"
:yvI| Bon-UIC [Edit Henu|
Step 4:
When you are finished, save your changes by
pressing i fage oownj on the sixth page, I Fage up \
on the first page, or pressing | control"! - w. A pop-
up window presents you with three choices: Save,
Discard, or Edit. Type S for save or use the H*"l and
|-»H keys to highlight the Save option and press
I Return |.
A-14
WATERS User Guide
-------
Appendix A, WATERS Training Script
F. Listing a Listing records enables you to see a summary of all
Record fne records in a particular folder and lets you
choose a particular record to view in more detail.
The same process is used for listing records in all of
the folders. However, the output varies across
folders.
This example shows how to list the records in the
Compliance/ Enforcement folder.
step 1: Type C to choose the Compliance/Enforcement
folder.
step 2: Type 0 to select the Query menu.
Type L or press |_rj and I T j to highlight the "List"
option and press I Return ~]
step 4: A list of all the records in the
Compliance/Enforcement folder appears. See
Exhibit F-1 for an example. You can scroll through
the records using the If I and IT I keys.
WATERS User Guide A-15
-------
Appendix A. WATERS Training Script
Exhibit F-1
File
Bdit
Help
= ============ WATERS State System=«===========«»
ft/ OT023J7
|| UTQ2337
|| ::. .-;»«ma;r... '
{I UTC2337
1 UTC2340
II UTQ 23 40
I UT02346
II UTQ2346
II UTQ 23 47
OT02348
1 UTQ 23 49
I (JT023SQ
I UTO 23 52
UTQ 23 52
UTO 23 52
UT023S3
UTO 26 36
UTO 26 36
mO 2618
1
Occurred
1990/09/01
- 1»W>/0»/»1
1989/01/01
1987/10/09
1982/09/18
1993/05/16
1979/05/23
1 989/08/19
1993/02/15
1987/12/12
1990/03/25
1992/07/15
I 99: / 03/0!
1985/03/18
1992/07/17
1990/04/11
1990/04/01
1984/09/1 2
Type of Violation
Pressure and/ or
;.; Violation or fa ;
Mechanical Inte
USDW Contasunat
Falsification*
Permit Violat 10
Mechanical Inte
Operation and M
Casing and Ceme
Casing and Cerae
USW Contajsjnat
Monitoring and
Operation and M
Casing and Ceme
Falsi fieat ion*
Mechanical Inte
USDW Contaninat
Mechanical Inte
Enforce
1990/1 1/02
: 19M/J.JL/02
1989/02/03
1987/10/09
1982/10/15
1993/06/18
1980/01/15
1989/08/23
1993/02/15
'.990/12/12
1990/08/16
1993/01/11
1992/08/01
1985/0 ''/ID
1992/08/31
1991/1 0/09
1990/07/01
1985/12/30
Type of Enforce
CR Criminal Ref
• : CR . CtSalMlX: ••£
UO Unilateral C
SI Shut-in
UO Unilateral C
AO Adita nisc rati
CR Criminal Ref
AO Administrate
UD Unilateral 0
CO Consent Orde
S! Shut -in
AO Actnu nist rac i
JO Judicial Ore
PS Pipeline Sev
CV Civi 1 Be {err
CD Consent Deer
UO Unilateral 0
CD Consent Deer •
PgDn]
Mon-UIC [Query Menu]
Step 5; Scroll through the records by typing part of the well
ID's or using the m and If I keys. When you find
the record you wish to select, press | Return"")
WATERS displays the Compliance/Enforcement data
for the selected record.
A-16
WATERS User Guide
-------
Appendix A. WATERS Training Script
G. Finding a
Record
Step 1:
Step 2:
Step 3:
Step 4:
This function enables you to select a record, (or
group of records) meeting criteria you specify. It is
useful if you are trying to locate a set of wells with
similar characteristics. The procedures for the Find
option are the same for all folders. This example
uses the Operations folders.
Type Q to choose the Operations folder.
Type Q. to access the Query menu.
Type F to select the Find option.
Type your search criteria in the appropriate fields.
All searchable fields are in red. In this example, type
an asterisk (*) in the "Operating Status" field; your
screen should look like the one below. This asterisk
indicates that you want to select any record with a
value in the that field.
Exhibit G-1
t Up fid *- t-efi Char/Fid fjtfBi Next Page fl H«lp
i Dcwn F.d -* Rght dar/Fld E*c at:t without changes *&• Toggle Over
Permits | ] Inventory j | Inspection ] | HIT | I Coupi/Enl ] | Operations!
•
:
•
•
•
•
•
9
S
:
^ Status Ejfectiv* ' ; / :/
^r In^ect:on Pressure Injection Rat* Amulus Pressure
J( ipsigl (Cbl>/d»y) (po»0)
*Z Hiniaua! .: ;- • :.•: >.'
*J Average : • • '
O MiXWum ._ _-•.: . .: •
3Q Annual Volwa»e of
iO Injected Fluid •• .- barrels
,-j Fluid Type :
£>
O
JO
WtC;^ \ Hcn-UIC [ouery Henvi |
1 Pgltei
pnOn 1
Step 5:
Type I PageUp I or I control I - w. A pop-up
window asks you to verify your query. It presents you
with three choices: Search, Clear, or Edit. See Exhibit
G-2 for an example.
WATERS User Guide
A-17
-------
Appendix A- WATERS Training Script
Exhibit G-2
I Up Fid *~ £•**£ Char/Fid PQSDn N*xt I%g* Fl H«lp
I Dcwn Fid -* Hght Char/Fid **= Exit without dh*ng*s I» Toggl* Ov*r
P«rait» f 1 Im?«ntory |
•
•
•
•
s
•
•
«
s
Infection | | MIT | [ Cos^l/Enf
Oprrat ICR* |
O «fell !<*• .fi*r
aQ Oat* Up&di*d
•3 ^3«rat'ing Status
-Q Status Effective
g ln3««
^ Mlnijium
*-> Av«rag*
5
30 Annual Voluaw of
£) lnj«ct«cl Fluid
j-j Huid Type
so
£>
ID
^-t"t.
/'"/
Begin s*arcn
V" •;" • ;• barr»l»
ulus Pr»*»ur*
(p«ig)
:v!:*ic. i | M^-UIC JQo«rv Mrnt
tl pgy^j
pqCn i
Type ^ or use the ^" and -^ keys to highlight the
Search option and press | Return""].
Exhibit G-3
File
Id it Stt*t7 Help
Perm
::s | [ invents 1 | :r
Explanation o! Cuerv Crite
Operating Status is -z- T^pty
a sO
•ssO
a=O
a so
DOOOOOOOO
H-fttfNIUII '
Well Identifier
Date Updated
Operating Status *
Status Effective
Injection
ips:
Minimum
Average
Maximum
Annual Volume of
Injected Fluid
Fluid Type
i»c«c';c". ] IDT | | Compl/Ent | Operations
••* h
\
t f
1 t
rn Rate Annulus Pressure
day) ipsig)
...... .. . .
" • .
1 ' :v'
barrels
::: .r;BJC:..v '- Hon-UIC Query Menu
--
--.
PQUp
PaDn
A-18
WATERS User Guide
-------
Appendix A. WATERS Training Script
Step 6:
Step 7:
WATERS indicates that it is searching for matches.
When the search is complete, the number of records
that match your criteria appears in the middle of the
screen.
press any ^ey to move to the Operations folder of
the first record. In the top right corner of the screen,
notice that the word Find appears. See Exhibit G-4
for an example. The word find indicates thatyou
only have access to the records found in your
search.
Exhibit G-4
Peomts 1 I Inventory I I Inspection | | KIT | 1 Comal/Etif 1
:
:
:
•
•
•
s
•
-
m
m
z
-
u
\
c
Operations [
O v»Ml I4»nti(i«r UT02J53
£ C»t* Opd«l
Q C|j«rmt mg
C St«tw» Eff
O
O
C
O
BMi
ID Aver.a*
O MlXXOiuB
O
5 Annual vol
«3 1992/04/1*
St atus Act* v*
art iv^ I 592/OS/I8
Zn}»ction Pr«ssure Inj«ction Rate Annuius Pressure
(psjgl Cbbls /cisy )
1500 7501
(psig)
1900
O ta]«ct«d Fluid 350,000 barrels
D Fluid Type
!O
USC \ Hon-UIC
Salt Wt«r
Query Menu J
PaUpl
Step 8:
Step 9:
To review the records, use the I + I and I - I keys.
You will only be able to see the records that meet
your search criteria.
When you are finished reviewing the records, you
should clear the search to regain access to all the
records in the folder. To start, type Q. to enter the
Query menu.
Type C to access the Clear Find function. Your
database is no longer limited to the records in your
query.
WATERS User Guide
A-19
-------
Appendix A. WATERS Training Script
H. Saving a
Query
Step 1:
Step 2:
Step 3:
Saving a query allows you to run the same query
without reentering all your search criteria. It also is a
convenient way to save an explanation of your
search criteria.
In this example, you will save the query you ran in
Section H, which searched for any record with a
value in the "Operating Status" field of the
Operations folder.
Follow the steps in Section G to run the sample
query.
Type Q. to access the Query menu. Press
I Return |.
Type S_ to access the Save Query option. Your
screen should look like Exhibit H-l. Press I Return
Exhibit H-1
Tile
I r— 1 I u»T!uc <»»». c™»— ,
J Etil .. | v«*yy 1 S« -p j
Pftrsits ! I lr,v<*ttorv |
•
•
3
•
•
•
•
:
•
•
1— Op: DUNCAN OIL PROPER!
£1
'O W«H Identifier
jj§ Oat* Upd«*d
^5 Operating Status
90 Status Cffectiv*
C
«
3D " Inj«cti
•0 (
"5 MUJIMJH
:n»pect:on 1 I KJT ' 1 1 Coac:/Enf 1
DT0235 J
IW2/04/W
Act ive
1992/05/18
— —
Op#rat ions
bJ^l
Sav. Qu.ry A»; 1 (PMfl)
p^s^^^^.s^r-^'l || 1
-------
Appendix A. WATERS Training Script
I. Loading a
Query
Step 1:
Step 2:
Step 3:
When you want to access one of your saved
queries, you use the Load Query option. This
example builds on the query you ran in Section G
and saved in Section H. Therefore, please work
through those two sections before you attempt this
one.
Type Q. to access the Query menu.
Type a to access the Load Query option.
Highlight the query named Operating Status, as it is
in Exhibit I-l. You have two ways to do so:
Use your m and if I
Type the first few letters of the title: ope
Exhibit 1-1
Xij.4
• i i .....MW.,— _, _
Select Query;s) is Lea- * ;•; : . -£nter~~Hit Enter to Beg;n Query
J OPE Cuerv Header
All Class II Irs;*.. 2-*. •?:"-, ts Class = 2* Type oi Well Pernut,
All Wei is Operated :., : " . . . . ps Operator • cont a ; ns " ?L?D 3 *
Op: Mcbii Operator t contains "M03C4"
op*r*cii«r ct*tu* op*2A£lv& $t*t**s 1* not *«pt^
Rule = Y Rule Authorized contains *Y*
•
:
•
s
=
•
•
•
^ Application ^ate / / T«chnica. Review .'
erat ions
-
J
•-•
^
ced Re
*3 Dace Perwit Iss^ea / / Public Notice / /
O Dace Perm;: £Jtec;.ve / / Public Hearing / <
•0 Date Perw.;^ Hccifieo / / Permit Tens 10 Years
w Type of Permit Moc Expiration / /
sO
^3 Date P!ugged/Atar,3or.ed / / Date Permit Denied ' /
^ Corrfnerc la 1 ™*3c:l;ty N Date Withdrawn .' /
VIC \ Non-UIC |Re:r.dex Ail WATERS Budget Reference Tdbl*s|
- . _
PQUCJ
Tl
Li)
m
11
^oDn]
Step 4:
Press | Return |. As shown in Exhibit 1-2, two dialog
boxes will appear in the middle of the screen,
displaying :
* Criteria for the query
• Pass WATERS is on
WATERS User Guide
A-21
-------
Appendix A WATERS Training Script
• Amount of records processed
• Total amount of records in the database
» Amount of matches found so far.
Exhibit 1-2
Wi le
•cut |l»i*i;d
•elp
ferntits I | Inventory I 1 In»pection
Explanation of Query Criteria — —
Operating status is not empty
i
;
;
•
*
•
9
•
;
pooooo ooooooo
111 II II II U II • 11 • II • II II
Well Identifier
Date updated
Operating Status
Status Effective
4..
Injection
IPS]
Minimum •:.;;,.
Average ,:ff!
Maximum 'ffi
Annual Volume of
Injected Fl uid
Fluid Type
^
't •'
J.
KIT | | Cotnpl/Ent | Operations
„„„_.
bon Rate Annul us Pressure
Pass !•'! I/day) (psig!
Processing 45/472 •.,... ...,. ,. ••
Hatches 39 m;?f ''?:•::>':"•
to Cancel p-:---'' -.-:.' ':-'-:
&. barr,
si
:..-, WC.,
| Hon-UIC [Query Menu
*.
rgup
PoDn
Step 5:
Then WATERS shows the total number of records that
match your query criteria.
Press any key to see the first of these records.
A-22
WATERS User Guide
-------
Appendix A. WATERS Training Script
J. Deleting a
Query
Step 1:
Step 2:
Step 3:
When you want to delete one of your saved queries,
use this option. For this example, you will build on
the query in Section G and saved in Section H. Work
through those sections before you attempt this one.
Type Q. to access the Query menu.
Type D to select the Delete Query option.
Highlight the query named Operating Status, as it is
in Exhibit J-1. You have two ways to do so:
Use your IT! and
ffl
Type the first few letters of the title: ope
Exhibit J-1
rile 1 idit \ guar?
•elp
J====;=====HATERS State Systen=========s====i~
Select Query" is} to Delete w/Ctr!-£r,ter--Hit ~.nter to Ream Query
/OPE
All Class II Individual
Ousrv Header
Permits Class = 2, Type of Weil Permit
All Wells Operated by Phillips
Op: Mobil
Operator t contains "PLP03"
Operator t contains "HOB04"
op«r«ijw 8e*tw» , . - op*r««iia> st«wi •***•* **Wf .
Rule = Y
•
•
:
•
i
^5 Application Date
*3 Date Permit Issy
ed
O Date Permit Effective
[Q Date Permit Hodi
iiec
*J Type of Permit Hod
£> Date Plugged/Abandoned
Rule Authcrized contains "Y"
-
- ,_
lerationsj
—^ —— -
«.
/ / Technical Review / /
/ / Public Notice / /
Public Hearing / /
-' ; Permit Term 10 'fears
Expiration / /
/ / Date Permit Denied / /
^ Conmercial Facility K Date withdrawn / /
• ,BIC ] Kon-UIC [Query Menu
'oupl
>aDn|
Step 4:
Press I Return |. in the middle of the screen a pop-
up window will ask you to confirm that you want to
delete this query. Type Y for yes.
WATERS User Guide
A-23
-------
Appendix A. WATERS Training Script
K. Deleting a
Record
Step 1:
Step 2:
Step 3:
Step 4:
The delete function enables you to permanently
delete records from your database. In this example,
you will delete a record from the MIT folder.
Type M to access the MIT folder.
Find the record you wish to delete, either through
the List function or the Find function (sections F & G
of this chapter, respectively). The Delete option
deletes the record in the folder that is active on your
screen.
Type E to access the Edit menu.
Type D to choose the Delete option. Your screen will
look like Exhibit K-l below.
Exhibit K-1
Table _
esse
S :Q Inspector Nane-:.'o
*" 'Q Date/Result c: U*»t M:~
iO Last Corrective Act.cr
- 'O
jJO Botn Pts -'.: r-pl-.; ?--.es:
•Suit "' \JkAf. Test
^6 Type of Lea< Test
Date/Resylt o! Fl».a Mig Test
jid x;gratior Test
iQ Date of Her.edia! Acticr,
!O Type of Remedial Action
UT02353
1990/J2/12
Y
Haclro Enforce'/645
1967/06/15 Passed
/ /
Y N
1990/03/14 Passed
Casing/Tubing Pressure
1990/03/15 Passed
Current Record Review
1989/01/23
Tubing/Packer
&K.
Mon-OIC JDeiete Current Record]
Step 5: A pop-up window shown in Exhibit K-2 asks you to
confirm that you want to delete this record. To
choose Yes, type Y or use the h*"l and i"*H to
highlight the yes option and press | Retum"~|.
A-24
WATERS User Guide
-------
Appendix A. WATERS Training Script
Exhibit K-2
rilel'lfctit.'*:'! Query lelp
Permits 1 1 Inver.tcrv
•
m
•
:
«
1
:
•
:
•
M
*
^_ op. ijSNCAN n!i, ppnp
:0 Well Identifier
;S Date Record Updated
SQ M" Witnessed
"O Inspector Naise/No.
IQ Last Corrective *
=0
== — ========WWERS State Systems== — ==-=====s===s=- ••
HIT
Compl/Enf | | Operations ]
UT02353
1990/12/12
Y
Macho Enforce' /645
re you sure you ware to delete'
ed
»0 Type of Leak Test Casing/Titling Pressure
:O
"§ Dace/Result of FluidMig Test 1990/03/15 Passed
yQ Type of Fluid Migration Test Current ffecord Review
•0
•0 Date of Remedial Action 1989/01/23
iQ Type of Remedial Action Tubing/ Packer
:*::&&:.• _\ Hon-UIC JEdit Men
u
PgDi 1
Deleting a record from the Permits folder works the
same way. However, deleting the Permit record for
a well automatically deletes all of that well's records
in the other folders.
WATERS User Guide
A-25
-------
Appendix A. WATERS Training Script
L. Printing a There are two ways to print a well schematic:
Well Schematic through the Reports option of the Query menu, or
you can print it while viewing one, which is what you
will do in this example.
Step 1: Type Q to access the Query menu.
step 2: Type W to access the Well Schematic option.
At the top left comer of the well schematic, the
record number of the current well will appear.
step 3: Type p to print the well schematic.
The word 'printing' will appear at the top of your
screen. At the same time, screen colors will change:
the confining zone turns white, and all the letters turn
black. When the screen flashes and the 'printing'
message disappears, your well schematic has
finished printing.
A-26 WATERS User Guide
-------
Appendix A WATERS Training Script
M. EPA 7520
Reports
Step 1:
Step 2:
This option enables you to generate EPA 7520
reports for your Class II wells. These reports are
computer-generated facsimiles of the OMB-
approved EPA 7520 forms. You can generate EPA
7520 reports from any folder. In this example, you
will print a Permit Review and Issuance report (EPA
7520-1).
Type Q. to select the Query menu.
Type R to access the Reports option, and a dialogue
box appears with five windows. Each window is a
consecutive step in completing a report. Exhibit M-1
shows the Reports dialogue box.
Exhibit M-1
Pile Bdit : Qu«ry Belp
=O
^D
-O
^D
-"O
**>
=O
=D
=O
^D
=O
=O
SSO
=o
=30
=WMERS State Syst«n=
Reports
Bcneoui*
Status Reports
Enforcement Reports
Hell By Wei. Reports
Misc. Reports
7520 Reports
m*port»"
Inspection
KIT Schedule
currene Melt
Query
Today
Month
Year
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
to-
IP LaserJet
frinc File
Bon™UIC I Query Menu
Step 3. Type 7 to select 7520 reports. In the second window
of the Reports dialogue box, all the 7520 reports
available are listed.
Step 4: jype £ to choose the Permit Review and Issuance
report.
Step 5; WATERS then prompts you for the year. Type 1993
and press | Return ~\.
WATERS User Guide
A-27
-------
Step 6:
Step 7:
Step 8:
Appendix A. WATERS Training Script
Press I Return 1 again. In a 7520 report, you cannot
report on a subset of the wells in your database.
You can only select a well range of All Wells.
Next you are prompted for the time period within
your selected year. To generate a report for the first
quarter, type 1 or use the
number 1.
ffl
and If I to highlight the
Press | Return j. You can only print 7520 forms, not
view them on your screen or print them later.
Your screen will look like Exhibit M-2.
Exhibit M-2
tile Idic :;Jaaef^":;| me If
=*> f
mo
-o /
=o
-0
1
1
^ ;
=« t
-o i
mf\ 1
!
=WATERS State System=
Reports
Schedule Reports
Status Reports
Ir.tcrcement Reports
Mel I By Weil Reports
Misc. Reports
-7520
torn
3Pemut Review and Issuance
Compliance Evaluation
Mechanical Integrity
Exceptions List (Quarterly]
Grant Utilization
Current Wei 1
Current List
All Wells
New/modify Query
Toaay
Month
Te«r
Tst yuarter
2nd Quarter
3rd Quarter
4tn Qua*"ter
step 9: A menu box in the lower left corner lets you approve
the report or cancel it. Use your i**"l and i-^H to
highlight OK and press | Return |. WATERS will now
print the report.
A-28
WATERS User Guide
-------
Appendix A. WATERS Training Script
N. Creating a
Custom Report
Step /.-
Step 2:
Step 3;
When you want to generate a report, check
WATERS standard reports to see if one meets your
reporting requirements, if not, you can create a
customized report on fields you have entered data
into in WATERS.
These elements become the columns of your report,
and the order in which you select them determines
the order of the columns. In addition to choosing
and ordering the data elements, you can build a
query into the report. In this example, you will select
elements of the Operations folder, and view only
wells that have a value in the "Operating Status"
field.
Type Q to move to the Operations folder.
Type Q to access the Query menu.
Type £ to access the Reports option. Your screen
will look like Exhibit N-l below.
Exhibit N-1
Pile
itfwnsiittiifff
Bdit
F
1
f
r
i
i
i
•!
I
C
,,.»»__.. f* n.
fceports
Si atus Deports
Bnf orcement Reports
Well By Well Reports
Itisc. Reports
7520 Reports
3ci»4ul* R^j>«a;t.*
XtttrP^C t Jpft SCJh^<5vl*
ICT Schedule
R*n
Currant List
JU 1 We 11 s
New/i«3ciify Query
Today
Hontn
Year
1st Quarter
2nd Quarter
3rd Quarter
4th guartor
HP LaserJet
Print Fi le
;jfe-r««i'.:-^-. .'"-:,-;': :••-.-;•:.
U^-J t^ss&l
IH Hon-UIC Quory MenuJ
_
E{
bi
El
CD
m
>aDn 1
WATERS User Guide
A-29
-------
Appendix A WATERS Training Script
Step 4:
Step 5:
Step 6:
Step 7:
Select Misc. Reports by typing M or press 141 and
LU to highlight Misc. Reports and press I Return 1
Select Custom Report by typing £. or press 141 and
If I to highlight Custom Report and press | Return 1
Choose All Wells for the report range by typing A. or
press 141 and if I to highlight AH Wells and press
[ Return"]
Choose the screen as the destination of the report.
To do so, type S_ or press m and IT I to highlight
Screen and press I Return | Your screen should
look like Exhibit N-2.
Exhibit N-2
Wile klit
=*>
-e
«*>
-0
-o
««
-o
-c
Help
========s====«ATERS State system==========s====s====s
Reports
-S«l»et * Report Ty]>«:
schedule Reports
Status Reports
Enforcement nepcrts
Well By HeiI Reports
7520 Reports
Kcr.-UIC Beport
| Curr
I Curr
I New/:
Current Weil
Current List
New/»pdify Query
Today
Montn
Year
1st Quarter
2nd Quarter
3rd Qua
4th
uarter
Jimiiif Mon-Uic| Query Her..
A-30
WATERS User Guide
-------
Appendix A WATERS Training Script
Step 8: press | Return | to select the OK box. You are now
in the Operations folder, and the fields in which you
can select as report columns and/or search are
displayed in red.
Step 9: Move to the "Date Status Effective" field and press
JF4 I. You have selected "Date Status Effective" as
the second column in your custom report. Yqy_will
see a 2 on the left side of the field. The first column is
automatically the Well ID, as denoted by the 1 next
to that field.
Step W: Move to the "Operating Status" field.
Step 11: Type an asterisk (*) in the "Operating Status" field.
This asterisks indicates that you want to select any
record with a value in the status field.
Step 12: ___
Press IF4 I to make the "Operating Status" field the
third column of your report. A 3 will appear to the
left of the field.
Step 13: I,-, I
Move to the "Date Updated" field and press LEU.
Your screen should look like Exhibit N-3 below.
Notice that the "Date Updated" has a 4 next to it.
Exhibit N-3
T Up Fid "- Left Char/Fid fyOs • Next Page tl
i Down Fid -» ' "SM Char/Fid *«e Exit without changes W
;
:
;
•
:
•
•
:
•
.
:
•
-
:
p well identifier I
O Dale Updated 4 ft
O Operating Status 3 »
6 Status Effective i / f
D
O
Help
Toggle c
Operations
ver
O Infection Pressure Injection Rate Annuluc Pressure
D (psig) (bfils/day)
O
O MlnlBUB •.-:•: ..-.-. . •.:;••:.-.•.
O Average ' ' :.-;..' . - .
£) Majunua • • ••- -.•.:•.. .
O
O
Q Annual Volume of
O Injected Fluid "X;.'-' barrels
Fluid Type
tpsig)
F4 to add or reaove a field from Custofi Report"| Width 88 of 176 characters
pgup|
JMp'nj
WATERS User Guide A-31
-------
Appendix-A. WATERS Training Script
Step 14: press | control ]. w. A pop-up window displays
three choices. Search, Clear, and Edit. Type £ to
begin the quev for the custom report.
Step 15: While WATERS indicates that it is searching for
matches and how far along in the process it is.
When the searcn is complete, the number of
matches found will appear in a new pop-up
window. Press any key to see your custom report.
Notice that the report lists the data in columns with
the field descriptions in the order you selected the
fields: "Well Identifier", "Date Status Effective",
"Operating Status", and "Date Record Updated".
To navigate the report, use the command keys listed
at the bottom of your screen.
Step W: When you finish looking at the report, type £ to exit.
A pop-up window will give you the option to save
the report. If you do not intend to use a report
again, type H- If you do intend to use a report
again, type 1 and then name the report. You can
use the Load Query option to retrieve and run this
report, and the Delete Query option to delete it.
A-32 WATERS User Guide
-------
O. Quitting
WATERS
Appendix A. WATERS Training Script
This function allows you to leave the WATERS system.
srep /: Type F to select the File menu.
Step 2: jype Q to select the quit option.
Exhibit O-1
:>i:l«(
1 Bdit 1 ouerv I Helo I — . — » W&TRRS dr*ra JSvcram =--
Version
Tally
Backup
Turn Effects off
Set Veri fy Of f
Fort configuration
clocSt
!^iS'*:K:«*.:,^:H«-.;"
i
!
!
«— - + **
'entorv II In»oect ion 1 1 KIT II comol/Enf I I Ooeratzons 1
ized N
Number 147853 Well Identifier UT02353
er OT1234A Type of Well Printd Converted
1 Permit Area Class 2
•Q Application Date / / Technical Review / /
sn Date Permit Issued / / Public Notice / /
iQ Date Permit Effective / / Public Hearing / /
:Q Date Permit Modified / / Permit Term 10 Years
IQ Type of Permit Hod Expiration / /
:0 Date Plugged/Abandoned / / Date Permit Denied / /
:Q Connercial Facility N Date Withdrawn
:•'•***•' "
Hon-UIC [Terminate MATERS program)
3
3
Step 3:
A pop-up window will ask you to confirm that you
want to quit. Use h^"l and I~^H and press
I Return 1 to select Yes. WATERS returns you to the
C: WATERS prompt.
WATERS User Guide
A-33
-------
-------
Appendix B. Data Dictionary
Appendix B. WATERS Data
Dictionary
This appendix contains a list of all of the data
elements included in WATERS. WATERS consists of
five databases:
• Permit
• inspection
• Mechtest
• Comply
• Operate
In general, the data elements are arranged in the
databases according to the folder of which they are
a part. However, the data elements in the Permit
and Inventory folders are combined into one
database (Permit).
The columns are labelled as follows:
FT: Field Type (N = Number, C = Character, and D =
Date)
FL: Field Length
FD: Field Decimal (number of decimal points)
R: Required Data Element (Y/N)
WATERS User Guide B-1
-------
Appendix B. Data Dictionary
No.
Title
FIELD NAME
FT
FL
FD
R
Calculated Fields
1
2
3
4
5
6
7
8
9
Date of Last Corrective Action
Date of Last MIT
Injection Interval A Net Feet •
Injection Interval B Net Feet
Intervening Thickness of USDW
Number of Wells per Permit
Permit Term Description
Result of Last MIT
Thickness of Lower-most USDW
LASTCACT
DATEMIT
ZONEAINT
ZONEBINT
INTVTHICK
APWN
TERMDESC
RESULTMIT •
THICKBLOCK
D
D
N
N
N
N
C
C
N
8
8
5
5
4
3
4
1
4
0
0
0
0
0
0
0
0
0
COMPLY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Compl/Enf Well Identifier
Compliance Schedule Written
Date Compl/Enf Record Updated
Date Compl/Enf Withdrawn
Date Compliance Required
Date Comply/Enf final
Date Enforcement Action Taken
Date of Notification
Date Penalty Assessed
Date Penalty Collected
Date Returned to Compliance
Date Vio Occurred/Verified
Docket Number
Last Compliance Result
Last Compliance Review
Multiple Enforcement Actions
Penalty Amount Assessed
Penalty Amount Collected
Significant Non-Compliance
Type of Enforcement Action
Type of Notification
Type Vio Occurred/ Verified
WELLID
CSWRITE
DATERU
DWITHDRW
DATECR
DFINAL
DATEEAT
DATENOTE
DATEASSD
DATECOLL
DATERET
DATOCCRD
EAID
LCRESULT
LASTCR
MULTEA
ASSESSED
COLLCTED
SNC
TYPEEAT
TYPENOTE
TYPEVRFD
C
C
D
D
D
D
D
D
D
D
D
D
C
C
D
C
N
N
C
C
C
C
15
1
8
8
8
8
8
8
8
8
8
8
15
1
8
1
6
6
1
2
2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Y
Y
Y
Y
Y
GUARNTR
1
2
3
4
5
6
7
Guarantor Address
Guarantor City
Guarantor Name
Guarantor Number
Guarantor Phone Number
Guarantor State
Guarantor Zip Code
GADDR
GCITY
GNAME
GNUM
GPHONE
GSTATE
GZIP
C
C
C
C
N
C
N
30
15
30
5
10
2
9
0
0
0
0
0
0
0
Y
B-2
WATERS User Guide
-------
Appendix B. Data Dictionary
No.
Title
F1ELDJIAME
FT
FL
FD
R
INSPECT
1
2
3
4
5'
6
7
8
9
10
11
Action Taken
Complaint Resolution
Date Inspection Record Updated
Date of Inspection
Emergency Resolution
Inspect Well Identifier
Inspector Name
Time Required for EMR Resolut.
Time Required for Resolution
Type of Inspection
Violation Discovered/Present
ACTION
COMPLAINT
DATERU
DATEINSP
EMERGENCY
WELLID
INSPNAME
ERTIME
CRTIME
TYPEINSP
VIOLATION
C
C
D
D
C
C
C
N
N
C
C
2
20
8
8
20
15
20
2
2
2
1
0
0
0
0
0
0
0
0
0
0
0
Y
Y
MAP
1
2
3
4
Map Well Identifier
Type of Well
XCOORD for MAP data base
YCOORD for MAP data base
WELLID
TYPECODE
XCOORD
YCOORD
C
N
N
N
15
2
11
11
0
0
Y
MECHTEST ,
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Both Point Tests Completed
Both Point Tests Retest
Date MIT Record Updated
Date of Fluid Migration Test
Date of Leak Test
Date of Remedial Action
Inspector Name
MIT Well identifier
MIT Witness
Result of Fluid Migration Test
Result of Leak Test
Type of Fluid Migration Test
Type of Leak Test
Type of Remedial Action
BPTCOMP
BPRETBT
DATERU P
DATEFMT
DATELT
DATERA
INSPTNAME
WELUD
MITWITNES
RESULTFMT
RESULTLT
TYPEFMT
TYPELT
TYPERA
C
C
D
D
D
D
C
C
C
C
C
C
C
C
1
1
8
8
8
8
20
15
1
1
1
2
2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Y
Y
NONUIC
1
2
3
4
5
6
7
Comment Field
Comment field
Comment Field
Date Permit Effective
Date Permit Issued
Finds Number
Latitude
COM1
COM2
COM3
EFFECTVE
ISSUED
FINDS
LAT
C
C
C
D
D
C
N
60
60
60
8
8
12
12
0
0
0
0
0
0
4
Y
WATERS User Guide
B-3
-------
Appendix B, Data Dictionary
No.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Title
Legal Contact
Longitude
NONUIC Well Identifier
Numeric Type of Facility
Numeric Type of Permit
Operator Number
Owner Number
Permit Number
Problems Reid
Problems Reid
Problems Reid
Total Depth
Type of Facility
Type of Permit
Well Description
XCOORD
YCOORD
FIELD NAME
LEGAL
LONG
WELLID
NFACTYPE
NPERMTYPE
OPNUM
ONUM
PERMIT
PROB1
PROB2
PROB3
TDEPTH
FACTYPE
PERMTYPE
WELLDESC
XCOORD
YCOORD
FT
C
N
C
N
N
C
C
C
C
C
C
N
C
C
C
N
N
FL
2
13
15
1
1
5
5
10
60
60
60
5
2
1
30
11 •
11
FD
0
4
0
0
' 0
0
0
0
0
0
0
0
0
R
Y
Y
Y
OPERATE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Annual Volume Injected Fluid
Average Annuius Pressure
Average Injection Pressure
Average Injection Rate
Date Operation Record Updated
Date Status Effective
Maximum Annuius Pressure
Maximum Injection Pressure
Maximum Injection Rate
Minimum Annuius Pressure
Minimum Injection Pressure
Minimum Injection Rate
Operate Well Identifier
Operating Status
Type of Fluid
IFLUID
APAVG
IPAVG
IRAVG
DATEUPD
DATESTAT
APMAX
IPMAX
IRMAX
APMIN
IPMIN
IRMIN
WELLID
OPSTAT
FLU1DTYPE
N
N
N
N
D
D
N
N
N
N
N
N
C
C
C
6
4
4
4
8
8
4
4
4
4
4
4
15
2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Y
Y
OPERATOR
1
2
3
4
5
Operator Address
Operator City
Operator Contact
Operator Name
Operator Number
OPADDR
OPCITY
OPCONTACT
OP NAME
.OPNUM
C
C
C
C
C
30
15
30
30
5
0
0
0
0
0
Y
B-4
WATERS User Guide
-------
Appendix B, Data Dictionary
No.
6
7
8
9
Title
Operator Organization
Operator Phone Number
Operator State
Operator Zip Code
FIELD J1AME
OPORG
OPHONE
OPSTATE
OPZIP
FT
C
N
C
N
FL
30
10
2
9
FD R
0
0
0
0
OWNER
1
2
3
4
5
6
7
8
9
Owner Address
Owner City
Owner Contact
Owner Name
Owner Number
Owner Organization
Owner Phone Number
Owner State
Owner Zip Code
OADDR
OCITY
OCONTACT
ONAME
ONUM
OORG
OPHONE
OSTATE
OZIP
C
C
C
C
C
C
N
C
N
30
15
30
30
5
30
10
2
9
0
0
0
0
0 Y
0
0
0
0
PERMIT
1
2
3
4
5
6
7
8
9
10
11
.12
13
14
15
16
17
18
19
20
21
22
23
Above USDW Depth
Above USDW Name
Above USDW TDS
Above USDW Thickness
Accuracy of the Location
Altitude Date
Altitude Method
Amount ot Coverage
Annulus Ruid
API Number
Application Date
Base Depth of USDW
Below USDW Depth
Below USDW Name
Below USDW TDS
Below USDW Thickness
Blanket Coverage
Class
Comment Reid
Comment Reid
Comment Reid
Commercial Facility (Y/NJ
Completion Type
USDWDPTH
USDWNAME
USDWTDS
USDWTHCK
ACCURACY
ALTDATE
ALTMETH
AMTCOV
ANNULUS
API
APPDATE
IBASDPTH
USDWDTH2
USDWNAME2
USDWTDS2
USDWTHK2
BCOVER
CLASS
COM1
COM2
COM3
CFACILITY
COMPLETET
N
C
N
N
N
D
C
N
C
C
D
N
N
C
N
N
C
N
C
C
C
C
C
4
20
4
4
3
8
1
6
2
10
8
4
4
20
4
4
1
1
60
60
60
1
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
WATERS User Guide
B-5
-------
Appendix B. Data Dictionary
No.
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
Title
Confin Zone A Effect Porosity
Conftn Zone A Fracture Press.
Confin Zone B Effect Porosity
Confin Zone B Fracture Press.
Confin Zone Geological Name A
Confin Zone Geological Name B
Confin Zone Perm A( 10th Power)
Confin Zone Perm B(10th Power)
Confining Zone A From
Confining Zone A Lithology
Confining Zone A To
Confining Zone B From
Confining Zone B Lithology
Confining Zone B To
Confining Zone Permeability B
Confining Zone Permear " / A
County of Well
Date Demonstration Last Review
Date of First Injection
Date Permit Denied
Date Permit Effective
Date Permit Issued
Date Permit Modified
Date Permit Withdrawn
Date Plugged/Abandoned
Date Well Drilled
Demonstration Expiration Date
Depth Measurement
Depth of TDS
Description of the Well
District of Well
Effective Porosity A
Effective Porosity B
Estimated Plugging Costs
Exempted Aquifier A (Y/N)
Exempted Aquifier B (Y/N)
Facility Identification
Federal Land (Y/N)
Field Name
Finds Number
FIELD.NAME
CZEPA
CZFPA
CZEPB
CZFPB
. CZGNA
CZGNB
CZPA10
CZPB10
ACZONFRM
CZLA
ACZONETO
BCZONFRM
CZLB
BCZONETO
CZPB
CZPA
COUNTY
DEMREV
DATEIB
DENIED
EFFECTVE
ISSUED
MODIFIED
WITHDRWN
ABANDON
DATEWELL
DEMEXP
DPTHMEAS
DTDS
DESCRIBE
DISTRICT
EPA
EPB
PLUGCOST
ACFR
BCFR
FAC1D
FEDERAL
FIELDX
FINDS
FT
N
N
N
N
C
C
N
N
N
C
N
N
C
N
N
N
C
D
D
D
D
D
D
D
D
D
D
C
N
C
C
N
N
N
C
C
C
C
C
C
FL
3
4
3
4
20
20
3
3
5
20
5
5
20
5
4
4
3
8
8
8
8
8
8
8
8
8
8
1
4
20
20
3
3
6
1
1
15
1
20
12
FD R
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
B-6
WATERS User Guide
-------
Appendix B. Data Dictionary
No.
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
Title
Flow Rate
Fracture Pressure A
Fracture Pressure B
Frequency of MIT Tests
Guarantor Number
Indian Land (Y/N)
Inject Zone Geological Name A
Inject Zone Geological Name B
Injection Interval Bottom A
Injection Interval Bottom B
Injection Interval Top A
Injection Interval Top B
Injection Pressure
Injection Pressure
Injection Rate Measure
Injection Volume
Injection Zone A From
Injection Zone A To
Injection Zone B From
Injection Zone B To
Injection Zone Lithology A
Injection Zone Lithology B
Intermediate Casing Cemented
Intermediate Casing Depth
Intermediate Casing Diameter
Intermediate Casing Grade
Intervening Thickness of TDS
Latitude/Longitude Date
Legal Contact
Lona String Casing Cement
Long String Casing Depth
Long String Casing Diameter
Long String Casing Grade
Measuring Pnt of Surface Elev
Method of Collection
Name of Lower-most USDW
National Refer Datum for Alt
Number of Wells Considered BC
OCZ Geological Name of A
OCZ Geological Name of B
F1ELD_NAME
FRCODE
FPA
FPB
MITCODE
GNUM
INDIAN
GNA
GNB
AZONEBOT
BZONEBOT
AZONETOP
BZONETOP
IPCODE
IPRESS
IRATE
IVCODE
AZONFROM
AZONETO
BZONFROM
BZONETO
IZLA
IZLB
ICEMENTED
IDEPTH
IDIAMETR
IGRADE
ITDS
COORDDATE
LEGAL
LSCEMENTD
LSDEPTH
LSDIAMTR
LSGRADE
MEASPNT
METHOD
INAME
NRDALT
NWBC
GNZONEA
GNZONEB
FT
C
N
N
C
C
C
C
C
N
N
N
N
C
N
N
C
N
N
N
N
C
C
C
N
N
C
N
D
C
C
N
N
C
C
C
C
C
N
C
C
FL
1
4
4
2
5
1
20
20
5
5
5
5
1
4
4
1
5
5
5
5
20
20
1
4
7
4
4
8
2
1
4
7
4
1
2
20
2
4
20
20
FD R
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
3
0
0
0
0
0
0
3
0
0
0
0
0
0
0
0
WATERS User Guide
B-7
-------
Appendix B. Data Dictionary
No.
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
Title
OCZ Total Thickness A
OCZ Total Thickness B
Operator Number
Other Confining Zones Lith. A
Other Confining Zones Lith. B
Owner Number
Ownership of the Well
Packer (Y/N)
Packer Depth
Permeability A
Permeability A (10th Power)
Permeability B
Permeability B ( 1 Oth Power)
Permit Application Number
Permit Expiration Date
Permit Number
Permit Term
Permit Well Identifier
Plug Back Total Depth
Pub. Water Supply Wells in AOR
Public Hearing Date
Public Notice Date
Quarter Four
Quarter One
Quarter Three
Quarter Two
Range
Region of Weil
Rule Authorized
Section
State of Well
Surface Casing Cemented (Y/N)
Surface Casing Depth
Surface Casing Diameter
Surface Casing Grade
Surface Elevation .
TDS Method One
TDS Method Two
Technical Review Date
Top Depth of USDW
FIELD^NAME
TTZONEA
TTZONEB
OPNUM
OCZONEA
OCZONEB
ON DM
OWNERSHIP
PACKER
PACKER D
PA
PAID
PB
PB10
APPNUM
EXPIRE
PERMIT
TERM
WELLID
PLUGBACK
PWS
PHDATE
PNDATE
Q4
Ql
Q3
Q2
RANGE
REGION
RULE
SECTION
STATE
SCEMENTED
SDEPTH
SDIAMETR
SGRADE
SURFACE
TDSMETHOD
TDSMETHD2
TRDATE
ITOPDPTH
FT
N
N
C
C
C
C
C
C
N
N
N
N
N
N
D
C
N
C
N
N
D
D
C
C
C
C
C
C
C
C
C
C
N
N
C
N
C
C
D
N
FL
4
4
5
20
20
5
2
1
5
4
3
4
3
12
8
10
2
15
5
3
8
8
2
2
2
2
3
2
1
2
2
1
4
7
4
4
2
2
8
4
FD R
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 Y
0
0
0
0
0
0
0
0
0
0
0 Y
0
0
0
0
3
0
0
0
0
0
0
B-8
WATERS User Guide
-------
Appendix B, Data Dictionary
No.
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
Title
Total Depth
Township
Tubing Depth
Tubing Diameter
Tubing Grade
Type of Construction
Type of Demonstration
Type of Permit Modification
Type of Well
Type of Well Permit
Type of Well Permitted
Well Coordinates (Latitude)
Well Coordinates (Longitude)
Well Logs Run
Wellhead Protection Area (Y/N)
FIELD.NAME
TDEPTH
TOWNSHIP
TUDEPTH
TDIAMETR
TGRADE
TYPECON
TDCODE
MODCODE
TYPECODE
TYPEWELL
WELLTYPE
LAT
LONG
WELLLOG
WPA
FT
N
C
N
N
C
C
C
C
C
C
C
N
N
C
C
FL
5
3
4
7
4
2
3
2
4
1
1
12
13
1
1
FD R
0
0
0
3
0
0
0
0
0
0
0 Y
4
4
0
0
QUERYDB
1
2
3
Query Description
Query Header
Query Name
QLOCEXP
QHEADER
QNAME
C
C
C
256
500
40
ADHOCDB
1
2
3
4
5
Custom Report Description
Custom Report Fields
Custom Report Header
Custom Report Name
Custom Report One Well Only
ALOCEXP
AFLDS
AHEADER
ANAME
AONE
C
C
C
C
N
256
256
500
40
1
WATERS User Guide
B-9
------- |