United States Office of Water OMPC-01 -91
Environmental Protection (WH-546) February 1991
icy
&EPA The On-Site Assistance
Program (104)(g)(1)
Database Users Manual
-------
CLEAN WATER ACT
SEC. 104(g)(l) DATABASE USERS MANUAL
FOR THE ON-SITE ASSISTANCE PROGRAM
U.S. ENVIRONMENTAL PROTECTION AGENCY
February 1991
-------
TABLE OF CONTENTS
PAGE
TABLE OF CONTENTS .
EXHIBITS LISTING
Chapter l. INTRODUCTION *
1.1 Concept and Design ^
1. 2 Primary Functions f-
1.2.1 Add or Update a Facility -1
1.2.2 Request and/or Develop Reports 1
1.2.3 Database Administration 1
1. 3 Purpose of the Manual ~
1. 4 Manual Organization ~
1. 5 Additional Help 6
Chapter 2. SYSTEM ACCESS AND EXIT J
2.1 Mainframe Access *
2.2 I04(g) (1) Access '
2.3 System Exit
Chapter 3. ADDING OR UPDATING RECORDS 9
3. l Key Acronyms *
3. 2 Updating Records *
3.3 Adding Records 1Z
Chapter 4. REPORTS "
4.1 Key Acronyms *j?
4.2 System Formatted Reports "
4.2.1 Steps in Requesting Formatted Reports... 16
4*.2.2 Displaying and Printing a Report 25
4. 3 Developing Reports 28
4.3.1 Steps in Developing Reports •"
4.3.2 Brief Overview of Options Menus 33
41s*. 3 Display and Print a Designed Report 36
Chapter 5. HELP FUNCTION 37
5.1 Access to the Help Screens *'
5.1.1 Add or Update Records Menu, Help •*/
5.1.2 Add New Records. . ..Help 38
5.1.3 Report Display/View, Help 39
APPENDICES: A - Key Information Field Options 42
B - Comprehensive Acronyms/Abbreviations List.. 44
-------
EXHIBITS LISTING
EXHIBITS PAGE
2-1 EPA WELCOME SCREEN 4
2-2 SELECTION MENU 5
2-3 LOGON SCREEN 5
2-4 LOGON MESSAGES SCREEN 6
2-5 NEWS ALERT/READY PROMPT SCREEN •- 6
2-6 104(g)(l) WELCOME MENU 7
2-7 READY PROMPT SCREEN 8
2-8 GREATER THAN »> ' AND READY PROMPT SCREEN 8
3-1 104(g)(l) WELCOME MENU 10
3-2 ADD OR UPDATE RECORDS MENU 10
3-3 UPDATE FACILITY H
3-4 ADD OR UPDATE RECORDS MENU 13
3-5 ADD NEW FACILITY SCREEN 14
4-1 104(g)(l) WELCOME MENU 15
4-2 REPORTS FOR 104(g)(l) FACILITIES/TRAIN DATABASE MENU. 16
4-3 WHILE VIEWING THE REPORT ON SCREEN MENU 17
4-4 REPORT LOADED FOR PRINTING MESSAGE 18
4-5 HEADQUARTERS LISTING 18
4-6 NATIONAL POLLUTION DISCHARGE ELIMINATION SYSTEM RPRT. 20
4-7 LIST SYSTEM DATA REPORT 22
4-8 COUNT FACILITIES REPORT MENU 23
4-9 COUNT FACILITIES REPORT FORMATS 24
4-10 REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE... 25
4-11 REPORT LOADED FOR PRINTING MESSAGE 26
4-12 WHILE VIEWING THE REPORT ON SCREEN MENU 26
4-13 104(g)(l) WELCOME MENU 27
4-14 REPORT PARAMETERS 27
4-15 REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE... 29
4-16 AD HOC REPORT INSTRUCTIONS MENU 29
4-17 AD HOC UTILITY OPTIONS SCREEN #1 30
4-18 TABLE FILE 104(g)(l) BOX 30
4-19 AD HOC UTILITY OPTIONS SCREEN #2 31
4-20 TABLE FILE 104(g)(l) BOX 31
4-21 AD HOC UTILITY OPTIONS SCREEN #3 32
4-22 RECORDS SPECIFICATION OPTION 33
4-23 SELECTING A RELATION OPTION 33
4-24 FIELD COMPARISON OPTION 34
4-25 RECORD SELECTION TEST OPTION 34
ii
-------
EXHIBITS LISTING (CONTINUED)
4-26 OPTION TO ENTER A VALUE 34
4-27 REPORT FORMATTING OPTIONS 35
4-28 REPORT PROCESSING OPTIONS 35
4-29 RUNNING PROMPT 36
5-1 ADD OR UPDATE RECORDS MENU 37
5-2 ADD OR UPDATE RECORDS MENU - HELP SCREEN 38
5-3 ADD OR UPDATE DATA INPUT SCREEN 38
5-4 ADD OR UPDATE DATA INPUT - HELP SCREEN 39
5-5 REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE... 40
5-6 WHILE VIEWING THE REPORT ON SCREEN MENU 40
iii
-------
CHAPTER 1. INTRODUCTION
As a result of Section 104(g)(l) of the Clean Water Act, the EPA
has provided about $2 million a year to States for training and
technical assistance in the operation and maintenance of wastewater
treatment plants. The treatment plants, or facilities, are
organized by State, and the States are organized-into 10 regions.
1.1 CONCEPT AND DESIGN
The I04(g)(l) database was created to facilitate the gathering,
updating, and reporting of data on the successes and problems of
wastewater treatment systems, primarily through the recording of
performance limiting factors (PLFs).
1.2 PRIMARY FUNCTIONS
The primary functions of the 104(g)(l) database are briefly
described in the following subsections.
1.2.1 Add or Update a Facility
New facilities may be added and records for existing facili-
ties may be updated using this function. Three screens in this
function are the data input and update mediums for the entire
database.
1.2.2 Request and/or Develop Reports
Six reports were formatted during system design for access of
information in consistent report formats. Also, the 104(g)(l)
system provides the option to design report formats by state or
region.
1.2.3 Database Administration
The database administration function (DBA) is designed for the
update and maintenance of the 104(g)(l) system, including contribu-
ting programs, utilities, user tables, etc. Therefore, DBA access
is restricted to programmers and the database administrator.
-------
1.3 PURPOSE OF THE MANUAL
This manual has been prepared for I04(g)(l) system operators and
trainers located at headquarters, regional, and State facilities
across the country who are responsible for the input, update, and
report generation on the status of each wastewater treatment
facility assisted.
This manual can be used as:
o a guide for new users to acquaint them with the system
screens, features, functions, and procedures;
o a review of system operations for experienced users; and
o with the inclusion of every system screen, an easy
reference tool for management, experienced users, and new
users.
1.4 MANUAL ORGANIZATION
This manual is organized into a table of contents, exhibits list,
five chapters, and two appendices.
o Chapter lf Introduction: An introduction and overview of the
system, its design and concept, primary functions, the purpose
of the manual, the manual organization, and a point of contact
for additional help is provided in this chapter.
o Chapter 2, System Access and Exit: Instructions on how to
access and exit the NCC IBM at Research Triangle Park (RTP)
mainframe and 104(g)(l) systems are contained in this chapter.
o Chapter 3, Adding or Updating Records: This chapter begins
with key acronyms and abbreviations for adding or updating
records. Next, the steps for updating and/or adding new
facility records are presented.
o Chapter 4, Reports: Key acronyms and abbreviations, formatted
reports, and developing reports are subsections in this
chapter. The formatted reports section is further divided
into steps for accessing the six formatted reports and a
section on how to display and print a report. The developing
reports section is divided into three subsections: steps to
develop reports, a brief overview of option menus, and display
and print designed reports.
-------
o Chapter 5, Help Screens: Help screens are included in the
104(g)(l) program for adding and/or updating records and for
report generation. This chapter includes the steps to access
the screens (and functions) that offer a help screen, and it
provides instructions for accessing and exiting the help
screens.
o Appendix A, Key Fields Options: Three input fields have coded
options that require explanation. These fields and their
options are included in Appendix A. The 21 performance
limiting factors (or PLFs), which describe the results from
technical analyses of the training for each facility, is one
field. The compliance status of technical assistance (or TA)
is a second field. And, type of facility (or TYPE) is the
third field.
o Appendix B, Comprehensive List of 104(g)(l) Acronyms and
Abbreviations: Listings of acronyms and abbreviations
contained throughout the manual are compiled into Appendix B
for a comprehensive listing.
1.5 ADDITIONAL HELP
After consulting this manual, if you have additional questions
contact the National 104(g)(l) Database Coordinator at (202) 382-
5822.
Extra copies of this manual may be requested by either calling the
telephone number listed above or sending a written request to the
following address.
ENVIRONMENTAL PROTECTION AGENCY
Attn: National 104(g)(l) Database Coordinator
401 M Street, SW (WH-546)
Washington, DC 20460
-------
CHAPTER 2. SYSTEM ACCESS AND EXIT
The following sections provide steps for the access and exit of the
NCC-IBM mainframe computer at Research Triangle Park.
2.1 MAINFRAME ACCESS
Accessing the 104(g)(l) system is a two-step process. The first
step involves logging on and establishing communications with the
IBM 3090 computer at RTP. The second step involves accessing the
104(g)(l) system.
Step 1: Turn on the terminal.
Step 2: Access the EPA IBM mainframe as required by your
system until the Environmental Protection Agency
Welcome screen appears, Exhibit 2-1.
EXHIBIT 2-1
EPA WELCOME SCREEN
WELCOME TO THE
U.S. ENVIRONMENTAL PROTECTION AGENCY
TELECOMMUNICATIONS >NETWORK
ENTER COHMAND OR M FOR MENU
Step 3: Type »M' at the cursor and press . The
system will display a Selection Menu, Exhibit 2-2.
-------
EXHIBIT 2-2
SELECTION MENU
U S EPA TELECOMMUNICATIONS NETWORK MENU
"itfunun Thursday September 13, 1990
TERM: T2311831
Model 2
NATIONAL COMPUTER
PFKEY SELECTION SERVICE
PF13 PCICS ClCS-ProduCtiOn
FF14 DCICS ciCS-Development
PF18 CICS Disaster Recovery
PF19 TSO TSO - UCC
PF8 EMAIL EMAII.
PF10 ARBMEKRJ Arbiter Menu
PA1 LOGOFF Exit Ntwork Menu
LOGICAL 'MAINFRAME
PFKEY SELECTION SERVICE
PF1S HY
PF16 DV
PF1? WIC
PF20 SE
PF21 AT
JPF22 DA
PF23 KC
PF24 PH
PF2
PF3
PF4
PF5
CI
BN
CH
SF
TSO NEW YORK LMF
TSO DENVER NEIC LMF
TSO WASH INFO CENTER
TSO SEATTLE LMF
TSO ATLANTA L
TSO DALLAS LMF
TSO KANSAS CITY LMF
TSO PHILADELPHIA LMF
TSO CINCINNATI LKF
TSO BOSTON LMF
TSO CHICAGO LMF
TSO SAN FRANCISCO LMF
HIT PF KEY OR ENTER SELECTION
Step 4:
Press or type 'TSO' to access the Logon
Screen, Exhibit 2-3.
EXHIBIT 2-3
LOGON SCREEN
EPA2 TSO/J5 LOGON
LOGON PARAMETERS BELOW:
USERID =-=> XXX
< PASSWORD «**> XXXXXKXX
> PROCEDURE —>
ACCT NMBR **«*> XXXX ' ,
FIMAS »«=»> XXXXX
f SIZE '***> :. ' - .
\ COMMAND ==«> XXXX
RACF LQGOM PARAMETERS?
NEW PASSWORD ***>
XDENT
BIN 'NUMBER
DEST
BEFORE"EACH OPTION DESXRED^ELOW
-NOHQTICE
-------
Step 5:
Step 6:
Enter your three-letter 'USERID'.
.
Press or
Step 7;
Step 8:
Type in your 'PASSWORD', and press .
If your 'USERID' and 'PASSWORD' have been typed in
previously and the key pressed, the
'ACCOUNT', 'FIMAS ID', and 'PROCEDURE' numbers will
appear after the 'USERID' and 'PASSWORD' is entered.
Go to Step 8.
Type in the 'ACCOUNT' number, the 'FIMAS ID' (facilities
impact monitoring and analysis system identification used
to identify usage of applications at the data center for
statistical and reporting purposes), and 'PROCEDURE'
numbers if they have not been entered previously. Press
.
The 'ACCOUNT, 'FIMAS ID', and 'PROCEDURE' numbers
may vary with each user.
The system will display a screen with logon messages
followed by a line of three or four asterisks, Exhibit
2-4. Press .
EXHIBIT 2-4
LOGON MESSAGES SCREEN
ICH70001I PCA LAST ACCESS AT 09:11 OH WED., SEPTEMBER 26, 1990
IKJ56455I PCA LOGON IN PROGRESS AT 09: XIJ 42 ON SEPTEMBER 26, 1990
*** ',
A screen with current news alerts and a 'READY*
prompt, Exhibit 2-5, will appear.
EXHIBIT 2-5
READY PROMPT SCREEN
,09/11/90: FOCUS 6.0.6 INSTALLED FOB TESTING -SEE NEWS ALERS9
09/11/90: TESTING FOCUSS06 IN THE SU #ODE -SEE NEWS ALERT11
-09/07/90? NEW RELEASE OF SIM-DIALOBT,, EMAIL -SEE NEWS ALERT15
^09/0 4/90? FILE-AID/SPF V6.4.0 AVAILABILITY -SEE NEWS ALERT2 ,
^09/04/90: PHOENIX 7.2.2 TO BE INSTALLED -SEE NEWS ALER24
JREADY
-------
2.2 104(g)(l) ACCESS
After logging onto the mainframe, follow the step below to access
the 104(g)(1) system.
9- If 'A032' is listed as your account on the Logon
screen. Exhibit 2-3, type '104G' at the 'READY'
prompt. Press .
—OR—
Type EX 'A032.CLISTU04G)' after the 'READY'
prompt, Exhibit 2-5, and press if 'A032' is
not your account.
Access to the I04(g)(l) system is verified by the
appearance of the 104(g)(l) Welcome Menu, Exhibit
2-6.
EXHIBIT 2-6
104(g)(l) WELCOME MENU
WELCOME TO THE 104 FACILITIES / TRAINING SYSTEM
,mmmmmmmmmmmmmm mmmmmmmBmmmmmmmmmmmmmmm* mmmmmmmmmmmmmm-mmmm
PLEASE CHOOSE A FUNCTION:
I - ADD OR UPDATE A FACILITY
2 - REQtJEST REPORTS
3 - DBA MENU
X - EXIT THE SYSTEM
THE DEFAULT REGION IS:
I REGION 1
VALID
(I - X, OR, ALL)
mmmmmmmmmmmmmmmmmmmmmmmmmmmmmm mmmmwH*mm mmmmmmmm
SELECTION: REGIONS I
mmmmmmmmmmm-
PRESS ENTER TO ACCEPT
2.3 SYSTEM EXIT
The procedures in this section explain how to exit the 104(g)(l)
system and logoff of the mainframe.
-------
Step 1: The option to exit the system, 'X', is provided on
the Welcome Menu, Exhibit 2-6. Enter 'X' in the
'SELECTION' field. Press and the 'READY*
Prompt screen, Exhibit 2-7, should appear.
Several screens throughout the program provide
options (usually »Q' for quit or »X» for exit) to
retrieve the Welcome Menu, Exhibit 2-6. The user
should retreat to the Welcome Menu to exit the
104(g)(l) system.
EXHIBIT 2-7
»READY* PROMPT SCREEN
READY
LOGOFF
Step 2: Type 'LOGOFF' at the
'READY' prompt. Pr-
ess .
If the system displays a '>' prompt, Exhibit 2-8, instead of
the 'READY' prompt, follow Step 3 below.
EXHIBIT 2-8
GREATER THAN »>» AND 'READY» PROMPT SCREEN
Step 3: Type 'FIN' at the »>' ^™"
prompt. A 'READY'
prompt will now ap- 5
pear. , READY
s X.OQQFF ' '*,;.
Like Step 2, type }, ,, - 'f ;
'LOGOFF' at the 'REA- mi^m^limit^iiliim^i*mn^m+m*m*m*^
DY' prompt to logoff
of the system.
8
-------
CHAPTER 3. ADDING OR UPDATING FACILITY RECORDS
As additional facilities are included to receive training and
technical assistance or as current facilities are evaluated,
specific information must be input or updated in the 104(g)(l)
database.
Adding and updating records include the input of standard informa-
tion and the input of the results of training and status of
facility activities using a checklist of 21 performance limiting
factors. PLFs offer a consistent way to categorize the factors
that are frustrating good performance at the treatment facilities.
Appendix A contains a list, of the PLF codes and their meanings.
3.1 KEY ACRONYMS
MGD= million gallons per day
NPDES=national pollution discharge elimination system
PLF(s)=performance limiting factor(s)
3.2 UPDATING RECORDS
First, follow the procedures for logging on and accessing the
104(g)(l) system.
Step 1: Type in '!' in the 'SELECTION:' field on the
104(g)(l) Welcome Menu, Exhibit 3-1. Press
or to advance to the next field.
Step 2: Enter the specific region (I,II,...X) using Roman
numerals in the 'REGION:' field. Press to
advance to the Add or Update Records Menu, Exhibit
3-2.
NOTE: The 'ALL' option is not active during the
add or update functions.
-------
EXHIBIT 3-1
104(g)(l) WELCOME MENU
__^___
WELCOME TO THE'i04(g)(i> FACILITIES / TRAINING SYSTEM
_ __ __ __ __ — — — — —SB ss= ssss asss ssss s=ss ssss ssas =ss s==s ssss == =as --- ss
THE DEFAULT REGION IS:
I REGION 1
"VALID ENTRIES;
(I - X, OB ALL)
PLEASE CHOOSE A FUNCTION*
1 - ADD OR TIPDATE A FACILITY
2 - BEQUEST BEPOBTS
3 - DBA MENU
X - EXIT THE SYSTEM
SELECTIONS 1 REGIONS I
ess ssss ssss ssss ssss ssss asss ssss asss ssss ssss ssss asss ssss ssss saas ssss ssss ssss ssas SSSB ssss ssss ssas ssss ssss ssss ss
PRESS ENTER TO ACCEPT
EXHIBIT 3-2
ADD OR UPDATE RECORDS MENU
ADD OR UPDATE RECORDS FOR lQ4{g}U) SYSTEM
REGION 1
PLEASE ENTER THE FOLLOWING IWFORMATIOK
STATE : ( REQUIRED }
VALID STATES
CT MA ME HH RI
HMME:
ENTER 3C TO RETURN TO ICENU:
PRESS ENTER TO CONTINUE
PRESS PFS FOR HELP
10
-------
Step 3
Step 4
Step 4
Enter the State in the space provided after the
'STATE: » field on the Add or Update Records Menu,
Exhibit 3-2. Press .
Use the two-letter postal abbreviations (the States
in the specified region will be listed two rows
below the 'STATE:' field).
in the facility in the 'FACILITY NAME: • field.
to retrieve the ppdate Facility
screen, Exhibit 3-3.
If the facility is not known, press after
entering the State. An 104(g)(l) program browse
mode allows for a screen identical to the Update
Facility screen in Exhibit 3-3, but titled Update
Record, to appear for each facility in the specified
region and/or State in alphabetical order.
EXHIBIT 3-3
UPDATE FACILITY
REGION:
STATE:
* FACILITY NAME:
* PATE {JESDDYY} :
NPDES #:
GRANT t:
RESULTS OF TECH ASSIST:
COMMENTS:,
CT ' ''
BEACON FALLS
032787
CT0101061 s SI2£{MGX»t.
C090116 TYPE:
PERF LIMITING FACTORS:
.SCO
AS,.
H . :
R/C/X*
'
-TO ACCEPT RECORD AKD SEE HEX? RECORD ^^ ' ;
RECORD AND RETURN TO SELECTION SCREEN ,
THIS TRANSAC1?IO» AMD RETURN TO SELECTION
TAB TO DESIRED FIELD/PRESS ENTER TO COJ3TINUE/PRESS
HELP
11
-------
Step 5: Press or to move to a particular
field. Type the new information over the old
information. Press or to advance to
the next field.
After completing all of the updates, or
to the 'R/C/X:' field near the bottom of
the Update Facility (or Update Record) screen,
Exhibit 3-3.
Step 6- Type 'R', 'C', or 'X' or leave the 'R/C/X:' field
blank (see definition key at the bottom of the
Update Record, Exhibit 3-3). Press to
continue.
Instructions must be provided regarding the proces-
sing of the newly entered information. Consult the
key at the bottom of the Update Facility (or Update
Record) screen, and leave it blank or enter an 'R',
'C', or 'X', as applicable.
3.3 ADDING RECORDS
The update function contains many of the key steps and records
necessary for adding records.
Step 1: Type in »l» in the 'SELECTION:' field on the
104(g)(l) Welcome Menu, Exhibit 3-1. Press
or to advance to the next field.
Step 2: Enter the specific region (I,II,...X) using Roman
numerals in the 'REGION:' field. Press to
advance to the Add or Update Records Menu,
Exhibit 3-4.
NOTE: The 'ALL' option is not active during the
add or update functions.
12
-------
EXHIBIT 3-4
ADD OR UPDATE RECORDS MENU
ADD OR UPDATE RECORDS FOR 104{g)(l) SYSTEM
REGION 1
PLEASE ENTER THE FOLLOWING INFORMATION?
STATE t CT (REQUIRED)
VALID STATES
CT MA ME DJH RI
FACILITY NAME: EPA
ENTER X TO RETURN TO M
PRESS ENTER TO CONTINUE
PRESS PF8 FOR HELP
Step 3: Enter the State in the space provided after the
'STATE:' field on the Add or Update Records Menu
(Exhibit 3-4). Press .
Use the two-letter postal state abbreviations (the
States in the specified region will be listed two
rows below the 'STATE:' field).
Step 4: Type the new facility in the 'FACILITY NAME: ' field.
Press .
If the database does not find a match of the State
and facility entered, the Add New Facility screen.
Exhibit 3-5, will appear with the 'REGION:',
'STATE:', and 'FACILITY:' fields filled out.
13
-------
EXHIBIT 3-5
ADD NEW FACILITY SCREEN
ADD NEW FACILITY
REGION:
STATE:
* FACILITY NAME:
* DATE {MMDDYY):
HPDES #:
GRANT t:
RESULTS OF *TECH ASSIST*
COMMENTS:
I
CT
EPA
SIZE(MGD):
TYPE;
PERF LIMITING FACTORS:
s/c/x*
BLANK*-TO ACCEPT RECORD AND SEE NEXT RECORD „___„
» mn *rn?PT RECORD AND RETURN TO SELECTION SCREEN
C 3S «£S «?S^k«SMD RETURN TO SELECTION SCREEN
X -TO DELETE THIS RECORD
TAB TO DESIRED FIELD/PRESS ENTER TO CONTINUE/PRESS PF8 FOR HELP
Step 5;
Step 6!
Press or to move to the rest of the
fields and input the information (See Appendix A for
proper codes to fill in the "Type", "Results of
Technical Assistance", and Perf Limiting Factors
columns).
After completing all of the updates, or
to the 'R/C/X:' field near the bottom of
the Add New Facility screen, Exhibit 3-5.
Type »R» fC»f or »X» or leave the 'R/C/X:' field
blank (see definition key at the bottom of the Add
New Facility screen, Exhibit 3-5). Press
to continue.
Consult the key at the bottom of the Add New
Facility screen.
14
-------
CHAPTER 4. REPORTS
Whether formatted or developed, the primary specifications for
information desired include:
o the records to be included,
o the field information to be extracted, and
o the sort (i.e. by State or region).
4.1 KEY ACRONYMS AND ABBREVIATIONS
D=display
HQ=headquarters
NPDES=national pollution discharge elimination system
P=print
PLF(s)= performance limiting factor(s)
4.2 SYSTEM FORMATTED REPORTS
Six reports were formatted during system design for access of
routine information in consistent report formats. Follow the steps
below to access the formatted reports.
Step 1: Using or , move to the 'SELECTION:*
field on the 104(g)(l) Welcome Menu, Exhibit 4-1.
Type »2» to request and/or develop a report. Press
or .
EXHIBIT 4-1
104(g)(l) WELCOME MENU
WELCOME TO THE 104 FACILITIES / DRAINING SYSTEM
SSS8SSSSSSS85SSSSSS8SSBSSS88SSSS8SB5S asasasasassssassssasssssasssssssssasBSsasssaiasssasasssas:sB3tss=s:=s«sss=8ss«=
PLEASE CHOOSE A FUNCTION:
X - ADD OR UPDATE A FACILITY
2 - REQUEST REPORTS
3 - DBA MENU
X - EXIT THE SYSTEM
THE DEFAULT REGION TS:
I REGION 1
VALID ENTRIESs
(I - X, OR ALL)
SELECTION; 2
**»is**«as*ir*st»!«ift*te8*te****^te«*^
15
-------
steo 2- Enter the specific region using Roman numerals or
' enter 'ALL' for all regions in the 'REGION:' field.
Press to advance to the Reports for 104(g)-
(1) Facilities/Training Database menu, 4-2.
EXHIBIT 4-2
REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE MENU
REPORTS FOR 104{g)(1) FACILITIES/TRAINING DATABASE
STANDARD REPORTS
THE DEFAULT REGION FOR THE REPORT IS
1 - HQ LISTING
2 - NPDES REPORT
3 - LIST SYSTEM DATA
4 - COUNT FACILITIES
T - AD HOC REPORT UTILITY
X - RETURN TO TSAIN MENU
REGION 1
RETURN TO THE MAIN MENU
TO CHANGE THE DEFAULT
= —— —— —— —=
=tas SSSB SBSS ss s: ssss asss SISKSS ==sss=s ssss ssss SS=BT
REPORT *
DISPLAY! P
STATE :
(D - TO DISPLAY REPORT / P TO PRINT REPORT)
(ENTER THE STATE CODE FOR REPORT SELECTION^
PRESS ENTER TO ACCEPT
4.2.1
Formatted Reports
The Reports for 104(g)(l) Facilities/Training Database menu
allow the user to designate the type of report and display or print
the report for a particular State or for all regions. As shown in
Exhibit 4-2, four types of formatted reports (with the fourth type
having three options) may be requested and displayed or printed:
o headquarters listing,
o NPDES,
o list of system data, and
o count of the facilities (three).
4.2.1.1 Accessing the Headquarters Listing Report
The Headquarters Listing Report lists all facilities for
each State, region, or all regions.
16
-------
Step 3:
Step 4:
Step 5:
Type '!' in the 'REPORT:' field towards tne
bottom of the Reports for 104(g)(l) Facili-
ties/Training Database menu. Exhibit 4-2.
Press or .
Type 'D' or »P' in the 'DISPLAY:' field to
display or print the report. Press
or .
Using the two-letter abbreviations, enter the
State in which the report is desired in the
'STATE:' field. Press .
This field is optional. If the 'STATE:' field
is left blank, the entire region is the
default.
Exhibit 4-3, will appear if 'D» is selected. Exhibit 4-
4 contains a message that will appear as a notification that the
report has been loaded for printing if »P» is selected. The
display and print functions are further discussed in Section 4.2.2.
Report.
Exhibit 4-5 contains an example of a Headquarters Listing
EXHIBIT 4-3
WHILE VIEWING THE REPORT ON SCREEN MENU
WHILE VIEWING THE REPORT ON SCREEN,
tfSE THE FOLLOWING KEYS'.
PRESS ENTER TO PAGE THROUGH THE REPORT.
PFB TO PAGE FORWARD
PF7 TO PAGE BACKWARDS
PF3 TO CANCEL THE DISPLAY
, PFI TO SEE A HELP SCREEN
.-------s-^^^^ssss^^^^^---^^----^--^--^---^--------'---"-'-
«***= PRESS ENTER TO CONTINUE ***
17
-------
EXHIBIT 4-4
REPORT LOADED FOR PRINTING MESSAGE
THE REPORT HAS BEEN LOADED INTO THE REPORT FILE FOR PRINTING
******-*********^
PRESS ENTER TO CONTINUE
EXHIBIT 4-5
HEADQUARTERS LISTING
LISTING OF ICK. rt::iiTiES/on[s FOB AIL BEGICNS
AS OF 10/16/90
RES
III
zzx
III
III
III
III
XII
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
III
ST
V*
VA
V*
V*
V*
V*
V*
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
FACILITY
NAME
PURCELLVILIE
PURCELLVUIE-REV
REE:VILLE
REMINGTON
REHINGTON-REVISI
•URAL RETREAT
•AINT CHARLES
SALTVILLE
SALTVILLt-REVISX
SHENANDOAH
SHITHFIELO
SOUTH BOSTON
SOUTH HILL
SPERRTVILLE
STANLEY
STONY CREEK
TANSIER ISLAND
TXWERVILLE
UR5ANNA
HAKEFIELD
MARRENTON
MARSAU
HAVER LY
HEST POINT
MEST POINT -III
NEST POINT-REVIS
HOOOSTOCK
DATE
09/10/86
10/20/66
04/io/e*
06/10/6S
07/oi/ee
01/01/66
II/SO/M
09/10/86
01/04/69
10/19/68
04/10/64
it/ii/ei
02/04/66
06/01/60
01/01/69
06/11/66
03/01/66
06/26/69
09/10/6S
12/01/67
09/10/66
01/01/69
09/01/37
01/11/66
07/15/90
12/01/67
10/19/88
NPOES
NUMBER
VA0022802
VA0022602
VA00607I2
VA0062619
VA0062619
VA0021126
VA0022209
VA0026606
VAOOI6806
VA0021825
VA0021795
VA002016I
VA0069117
VA0062660
VA0062669
VA0067423
VA0027I11
VA0026261
VA002216S
VAOOS1I61
VA002«89I
VA006I110
VA002219S
VA0022195
VA0022I9S
VAOOI6466
GRANT
NUMBEP
CSI04S7
CS104S7
C5I0500
CS10551
CSIOSS1
C510000
CSIOOOO
CSIO«OI
CflO«01
C510582
C510529
CSI02S1
CSI0606
CSIO«67
CS10512
CSIOOOO
CS1028I
CS10551
CS10164
CS10297
C510297
CI10611
SIZE
n&o
.500
soo
.200
.320
320
.rso
.I2S
500
500
.250
.500
2 000
1 000
.sso
.100
.0*0
.100
.200
.100
.114
.000
.100
.150
100
.100
.100
.100
PfRF
RESULT lln
TtPE OF T.A FACTOR COrmtHT
EA
TF
EA
EA
EA
EA
EA
AS
EA
TF
00
cs
OD
AS
00
L
R8C
00
CS
L
AS
AL
AS
TF
TF
TF
OD
OC
AKNF
J
AFQ
FHKA
FANQ
ABQ
BKQ
AKNC
F9AN
J
FIE
FKA
AQN
HQB
CBOK
ABFH
AB
ARN
Q
AC I
FSAB
OF
TNAL
TFN
QA
DIAGNOSTICS OMLT
COMPLETED
DIAGNOSTIC ONLY
COMPLETED
COMPLETED
COMPLETED - REVISED PLAN OF ACTION
OIA6NOSTIC ONLY
COMPLETED
COMPLETED
COMPLETED
DIAGNOSTIC ONLY
COMPLETED
COMPLETED - NO TRAINING
COMPLETED
COMPLETED
TRAINING ENDED
COMPLETED
ACTIVE
COMPLETE
COMPLETED
COMPLETED
COMPLETED
COMPLETED
I/I STILL PROBLEM
ACTIVE t HOPELESS
COMPLETED
COMPLETED
18
-------
4.2.1.2 Accessing the NPDES Report
An NPDES Report lists all facilities by State or region
according to the NPDES number.
Step 1: Type '2' in the 'REPORT:' field towards the
bottom of the Reports for 104(g)(l) Facili-
ties/Training Database, Exhibit 4-2. Press
.
Step 2- Type 'D» or 'P' in the 'DISPLAY: ' field to
display or print a report. Press or
.
Step 3: Using the two-letter abbreviations enter the
State in which the report is desired in the
'STATE:' field. Press .
This field is optional. If the 'STATE:' field
is left blank, the entire region is the
default.
Exhibit 4-6 (on the next page) contains an example of an
NPDES report. Exhibit 4-3 will appear if 'D' is selected, or
Exhibit 4-4 will appear if 'P' is selected. Press to
continue.
19
-------
EXHIBIT 4-6
NPDES REPORT
LISTING OF IC4 FACILITIES FOR ALL REGIONS WITH NPDESt
AS OF 10/16/90
REG
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
POTW
ROCHELLE
ROHEOVILLE PLT82
RUSH VI LIE
SANDWICH
SOMONAUK
SOUTH BELOIT
STILLHAN VALLEY
STILLMAN VALLEY-
TONICA
VILLA G90VE
HALNUT»»
HAVER LY
WHITEHALL
HINSLOH
BATESVILLE
BROOKVILLE
CARLISLE
CKRISNEY
CLINTON
CLCVERDALE
CORYDON
CRAHFORDSVILLE
EATON
FARMERSBU9G
FERDINAND
FOULER
FRENCH LICK
GOSH EN
HAGERSTOMN
HANOVER
KEKNARD
KNIGHTSTOWN
KNOX
KNOX-2
LA FONTAINE
LAPEL
LAPEL-2
LEAVENHORTH
LINTON
LYNNVXLLE
LYNNVILLE
MIDDLEBUSY
MOORE LAND
riORRISTOMN
MT. VERNON
NEW CARLISLE
NORTH SALEM
NORTH VERNON
NPDES
NUMBER
IL0030741
IL0048526
IL0054241
IL0030970
IL0020265
IL0021156
ZL0031275
IL0031275
IL0023639
IL0059005
IL0031615
ZL0020401
IL0022390
IL0031679
IN0039268
IN0022446
IN0039S37
IN0039306
IN0022608
IN0022616
IN0020693
IN0032964
IN0021652
IN002114B
IN0020648
IN0050253
IN0022951
IN0025755
IN0020010
IN0020702
IN0040151
IN0040177
ZN0021385
IN0021385
ZN0020371
IN0020067
IN0020067
IN0021121
IN0020575
ZN0040282
IN0040282
ZN0023761
IN0040378
IN0023841
ZN0035696
IN0020486
ZN0040436
IN0020451
GRANT
NUMBER
C 172448
C171222
C170554
C 170859
C172295
C172050
C171226
C171865
C170502
C171424
C171171
84-660-842
C172615
Cl 72594
C180594
C180515
C180138-03
C180387
C180312
C180487
C180286
C180970
C180125
C160392
C180171
C180812
C180098
C180414
C180232
C180876
C180284
C180416
C180416
C180202
C180556-03
C180556-03
C180352
C160401-03
C180401
C180228
C180842
C180963
C1803S6
C180336
C180750-02
C180403-04
20
-------
4.2.1.3 Accessing the List System Data Report
The List System Data Report contains the region, facility
number, size, type, PLF(s), and any comments for each facility in
the specified state or region.
Type '3' in the 'REPORT:' field towards the
bottom of the Reports for 104(g)(l) Facili-
ties/Training Database, Exhibit 4-2. Press
.
Type 'D' or »P» in the 'DISPLAY:' field to
display or print a report. Press or
.
Using the two-letter abbreviations, enter the
State in which the report is desired in the
'STATE:' field. Press .
This field is optional. If the 'STATE:' field
is left blank, the entire region is the
default.
Exhibit 4-7 (on the next page) contains an example of a
List System Data Report. Exhibit 4-3 will appear if 'D' is
selected, or Exhibit 4-4 will appear if »P' is selected. Press
to continue.
Step 1:
Step 2:
Step 3:
21
-------
EXHIBIT 4-7
LIST SYSTEM DATA REPORT
LISTING OF 104 FACILITIES FOR ALL REGIONS
AS OF 10/16/90
REG
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIIT
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VXIZ
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VIII
VXIZ
VIII
VIII
ST
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
CO
MT
MT
HT
MT
MT
MT
MT
HT
HT
MT
MT
MT
MT
MT
MT
MT
MT
FACILITY
LAFAYETTE
LAS ANIMAS
LASALLE
LOUISVILLE i CITY
MESA HSSD
MOUNTAIN HSSD
NEW CASTLE
NEW CASTLE
NORTH LA JUNTA
OURAY
OVID, TOWN OF
OVID, TOWN OF
PUEBLO WEST MET.
RANGLEY
REDCLIFF
REDSTONE
RIDGEHAY
RIDGEH4Y
RIFLE
SEIE-ERT, TOWN OF
SILT
SIMLA, TOWN OF
TELLU=IDE
TRINIDAD
UPPER THOMPSON
VICTOR
VONA
HALSENBURG
UILLOWBROOK
MOOD LAND PARK
ALBERTON
ANACONDA
BASIN
BIG SANDY
BIG TIMBER
BOZEM'N
BUTTE-METRO
CANYON FERRY
CHINOOK
CHINOOK
COLSTRIP
COLUMBIA FALLS
CONRAD
DILLCN
EAST HELENA
FORSYTH
FT. BELNAP
SIZE
MOD
1.500
.350
.000
.ZOO
.040
.100
.200
.200
.063
.200
.040
.040
.300
1.000
.C70
.250
.100
.100
1.040
.030
.150
.050
.320
1.500
1.500
.030
.016
.500
.250
.000
.047
3.000
.045
.090
.523
3.000
4.500
.003
.025
.500
.600
.550
.650
1.100
.637
.500
.033
TYPE
RBC
L
SP
AS
AL
EA
EA
EA
AL
EA
AL
AL
AL
AL
AS
AS
AL
AL
L
AL
L
AL
AL
AS
AS
AS
EA
SP
SBC
SP
AL
AL
AL
AL
AL
AS
AS
EA
AL
OD
OD
EA
AL
AL
AL
AS
FL
C
0
n
c
T
C
C
C
N
C
C
X
N
T
N
C
CT
N
CT
I
I
C
C
c
N
I
C
c
c
N
C
CT
C
c
c
IT
C
c
c
c
IT
T
PLF
CK
IADQ
CO
CK
D
ADOfl
N
SN
HQU
TIKC
AH
DO
N
RA.1N
FTDA
AMN
ABEU
ABEU
AC
DO
ANC
D
I
ACHM
CH
AQKM
BR
AQMN
CHS
AE
L
AN
NARB
AU
A
A
AKQ
AN
HA
AD
AKE
D
A
EAN
KHD
AN
COMMENT
COMPLETED FALL 1983
CPE IMPLE.HIGH SULFATES*
COMPLETED TRAINING IN 198
COMPLETED 1-87
CPE-CO DEPT HEALTH
CPE ONLY BY STATE
COMPLETED FALL 1984
DIAGNOSTIC ONLY
STILL HAVE SOME VIOLATION
DIAGN. ONLY, TYPE 3
LIMITED CCP,«
CPE ONLY BY STATE
DIAGNOSTIC ONLY
CCP IMPL. INTO COMPLIANCE
CCP END 1/66, ADM LACK CO
CCP STARTED 6/68.*
REQUESTED ASST.CPE IN 3/8
CPE ONLY BY STATE*
COMPLETED FALL 1984
5/88 BEGAN CCP UNDER ENFO
COMPLETED FALL 1984
CPE ONLY BY STATE
CPE BY STATE ONLY-TYPE 3
COMPLETED FALL 1983
E/S OME, COMPLETED 9/86
DIAGNOSTIC ONLY-NO DISCHG
COMPLETED FALL 1983
CCP IMPL*
DIAGNOSTIC ONLY
CPE 3/69 CCP STARTED 3/89
LIMITED CCP FOR IMP. MAIN
CPE 4/69 CCP COMPLETED 5
CPE - 5/89 CCP STARTED 5/
CPE 7/66 CCP STARTED 9/86
DIAGNOSTICS ONLY
CPE 2/88.
CCP COMPLETED MAY 68
CCP STARTED 11/69 »
E/S CCP STOPPED MARCH 198
CPE 9/68
CPE BEGUN BY DICK* CHECK
CPE 4/88
E/S OME CCP FINISHED 9/67
CCP COMPLETED
CCP COMPLETED
CCP STARTED 5/90*
22
-------
4.2.1.4 Accessing the Count of the Facilities Report
Three separate reports count the facilities by type of
facility within a State or region, by the compliance status within
a State or region, and/or give a simple count of the number of
facilities in a State or region.
Type '4' in the 'REPORT:' field towards the
bottom of the Reports for 104(g)(l) Facili-
ties/Training Database, Exhibit 4-2. Press
.
Type »D» or »P' in the 'DISPLAY:' field to
display or print a report. Press or
.
Using the two-letter abbreviations enter the
State in which the report is desired in the
'STATE:' field. Press .
This field is optional, if the 'STATE:' field
is left blank, the entire region is the
default.
The Count the Facilities Report menu will appear, Exhibit
4-8, listing the three reporting format options.
Step 1:
Step 2:
Step 3:
Step 4:
Enter '!', '2', or »3' in the 'OPTION:' field
to receive the report formats displayed in
Exhibit 4-9.
EXHIBIT 4-8
COUNT THE FACILITIES REPORT MENU
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^••••••••••i
. ••••••••••^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
THIS REPORT WILL COUNT THE FACILITIES BY STATE
TOR BEGIOU I
YC«J HAY ALSO REQUEST & COUNT WITHIN EACH STATE BY;
X. TYPE OF FACILITY
2. COHPLIAttCE STATUS
3. NO ADDITIONAL COUNT
X. TO 'RETURN TO REPORT MENU
Exhibit 4-9 contains an example of each Count Faciliti-
es Report format. Exhibit 4-3 will appear if 'D» is selected, or
Exhibit 4-4 will appear if »P» is selected.
23
-------
EXHIBIT 4-9
THREE "COUNT THE FACILITIES" REPORT FORMATS
4-9(a)
COUNT OF FACILITIES FOR REGION 3 BY STATE ACROSS TYPE
REGIO;
III
< STATE
DE
no
PA
VA
MV
TYPE
0
11
3
4
17
AL
0
3
0
3
6
AS
6
34
20
19
4
CS
0
2
15
7
17
t-A
0
8
16
16
28
L
1
11
3
2
5
00
0
3
1
13
49
P
0
0
1
0
0
PC
0
0
1
0
0
RBC
0
7
2
4
10
SP
0
0
0
1
6
TF
1
8
11
7
4
TOTAL
8
87
73
76
146
TOTAL 35 12 83 41 68 22 66 1 1 23 7 31 390
4-9(b)
COUNT OF FACILITIES FOR REGION 1 BY STATE ACROSS COM
COM
C CT I IT N NT T TOTAL
REGION STATE
I
CT
MA
KS
NH
RI
VT
2
0
0
0
0
0
5
13
23
20
6
26
22
4
11
8
6
7
3
4
2
5
0
4
21
7
10
13
7
16
0
0
1
0
2
0
0
0
0
0
1
3
1
0
2
2
2
9
54
28
49
48
24
65
TOTAL 2 93 58 18 74 3 4 16 268
4~9(C)
COUNT OF FACILITIES FOR ALL REGIONS BY STATE
FACILITY
REGION STATE COUNT
I CT 46
HA 26
ME 48
NH 45
RI 20
VT 56
24
-------
4.2.2 Displaying and Printing a Report
Step 1: Enter the report option in the 'REPORT:» field of
the Reports for 104(g)(l) Facilities/Training
Database menu, Exhibit 4-10. Press or
.
Step 2: Enter »P» in the 'DISPLAY: ' field of the Reports for
104(g)(l) Facilities/Training Database menu. Exhibit
4-10, to load the report(s) for printing, or enter
'D' to display the report.
Step 3: Enter the State in the 'STATE:' field. Press
.
This field is optional. If the 'STATE:' field is
left blank, the entire region is the default.
EXHIBIT 4-10
REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE MENU
REPORTS FOR 104{gMD FACILITIES/TRAINING DATABASE
. ____ _—— ———=;— s-asss sassMSs: SBBSSB ssas asas sa=s asas asas asss ssss sras SB= BBSS ssas ssss BBSS BSSB ssss asss ssss _,
STANDARD REPORTS THE DEFAULT REGION FOR THE REPORT ISi
f
f
1 - HQ LISTING REGION I
2 - NPDSS REPORT
3 - LIST SYSTEM DATA RETURN TO THE MAIN MENU
4 * COUNT FACILITIES TO CHANGE THE DEFAULT
T - AD HOC REPORT UTILITY ' \
X - RBTORN TO MAIN MENU , - ,
f f
'*jtt»stt««»'s^tt»*«tt**»*w»«*«a^«*a
X
REPORT ;
DISPLAYS P
-------
4- The message contained in Exhibit 4-11 will appear
4. I"6,™/; is selected. As instructed, press
to continue.
—OR—
If »D» is selected, Exhibit 4-12, will appear. Read
the PF key definitions carefully. Press to
display the report.
After the report is viewed, press to return
to Exhibit 4-10.
EXHIBIT 4-11
REPORT LOADED FOR PRINTING MESSAGE
THE REPORT HAS BEEN LOADED INTO THE REPORT FILE FOR PRINTING
PRESS ENTER TO CONTINUE
WHILE VIEWING THE REPORT ON SCREEN MENU
WHILE VIEWING THE REPORT OKT SCREEN,
USE THE FOLLOWING KEYS;
-PRESS ENTER TO PAGE THROUGH THE REPORT
PF8 TO PAGE FORWARD
PF7 SO PAGE BACKWARDS
PF3 1!O CANCEL THE DISPLAY
PF1 «TO SEE A HELP SCREEN
PRESS ENTER TO CONTINUE --=
26
-------
Step 5: Enter 'X' in the 'REPORT:» field of the Reports for
104(g)(l) Facilities/Training Database, Exhibit 4-
10. Press .
The 104(g)(l) Welcome menu, Exhibit 4-13, will
appear.
Step 6: Type 'X' in the 'SELECTION:' field of Exhibit 4-13
to exit the system. Press .
EXHIBIT 4-13
104(g)(l) WELCOME MENU
WELCOME TO THE 104 (gMU FACILITIES/TRAINING SYSTEM
~~~
PLEASE CHOOSE A FUNCTION:
1 - ADD OR UPDATE A FACILITY
2 - REQUEST REPORTS
3 - DBA MENff
X - EXIT THE SXSTEM
THE DEFAULT REGION IS
I REGION 1
VALID ENTRIES*
(I - X, OR ALL)
SELECTION:
REGION: I
ttrtatte
PRESS ESTER TO ACCEPT
Before the system exit is completed, the following Report
Parameters screen, Exhibit 4-14, will appear.
EXHIBIT 4-14
REPORT PARAMETERS
———
104(g)U> FACILITIES/TRAINING DATABASE
BSS3s=ss:s=ass:s:stsB=s istssssasstssss ssss SMS ssss s«s BBSS ssss BBSS ssss ss BSSSSSSSSSSUSSS :asass
YOUR REPORTS WILL BE PRINTED WITH THE FOLLOWING PARAMETERS:
VOX3T MAT CHANGE THEM BEFORE SUBMITTING.
PRINTER:
BIN :
COPIES :
asaa ss=: ssas as: =rs= ass BSSS sss= as» ssss =rss ssss BBSS asss SZSB ssss sss issues: =:ss SBSS ssasasas sasass: atasse ===== A- }
PRESS ENTER TO CONTINUE
27
-------
Step 7- Enter the printer number, bin number, and number of
copies (1,2,3..9). Press .
4.3 DEVELOPING REPORTS - AD HOC REPORT UTILITY
The ad hoc report utility permits report development. Report
specifications are satisfied through the request of information
contained in the records and data fields, and the extraction of
that information into a determined format(s) and sort(s). More
specifically, report development includes:
o selecting records from the database that will be used in
the report,
o titling the report,
o sorting the order of the printed records, and
o specifying the data to appear in the report.
4.3.1 Steps in Developing Reports
The ad hoc report utility is explicitly menu driven. Read
each option carefully before choosing among the various options for
selecting the data fields, extracting information, deciding the
records from which to extract information, and designing a report
format.
Step 1- Enter »T» for ad hoc report utility in the 'REPORT: »
field on the Reports for 104(g)(1) Facilities/Train-
ing Database menu. Exhibit 4-15. Press to
get the ad hoc utility instructions menu, Exhibit
4-16.
Step 2: or to the filename under the 'Select
Filename' field. Press .
The ad hoc utility options screen #1, Exhibit 4-
17, will appear. It provides options to begin
developing a report.
28
-------
EXHIBIT 4-15
REPORTS FOR 104(g)(1) FACILITIES/TRAINING DATABASE MENU
^^^^^^^^^^^^^^^^^^^^••^•^^^^^•l^^l^H^^^HHHHI^^^HBM^^^^^^^B^H^^^^HMH^^^^^^I^M^^^^^^^^^^^^^^^^^^^^^^^^^^^
REPORTS FOR 104 FACILITIES/TRAINING DATABASE^
"STANDARD REPORTS THE DEFAULT REGION FOR THE REPORT is:
REGION i
RETURN TO THE MAIN MENU
TO CHANGE THE DEFAULT
1 - HQ LISTING
2 - NPDES REPORT
3 - LIST SYSTEM DATA
4 - COUNT FACILITIES
T - AD HOC REPORT UTILITY
X - RETURN TO MAIN MENU
-— assasssrassasrasarsa ssasssssssssassa sassass: saasasssssasasssssasassssaasassssaararsB ==sa==sssssas saarssassssBasasssasasas
REPORT i 1?
DISPLAY: (D - TO DISPLAY REPORT / P TO PRINT REPORT)
STATE : {ENTER THE STATE CODE FOR REPORT SELECTION)
s-----=~-~x^~^^^^=s^==~^^^^^~-^^=~-=^^~--~~~--~-~=--~~~--~--~~~
PRESS ENTER TO ACCEPT
AD HOC REPORT INSTRUCTIONS MENU
INSTRUCTIONS s 1-Move cursor to name of field with, tab keys
2-Depress ENTER to select a file
S-Depress PFS or PF12 to QUIT
4-use PFS to go flown a page^ PF? to go bacfc
select.
Filename
Description
104{g)U)
HOLD
THE 104{^>(1) FACILITIES DATA BASE
TEMPORARY FILE FOR SYSTEM USE ONLY
29
-------
EXHIBIT 4-17
AD HOC UTILITY OPTIONS SCREEN tl
Kevs- ENTER select PFI Field Definitions PF2 Revise Mode
Y PF^ 12 Undo PF4 Top PF5 Bottom
PF7 scroll up PFe scroll Down PF9 Multi-select
Do you want to:
PRINT the individual values
SUM tne values of
COUNT the instances of
WRITE tne PERCENT Of
WRITE tJke AVERAGE of
QUIT
•f (MORE) — -""-•»-—•—»•«-"•"•——-"—
Select a aata field
REGION
STATE
FACILITY
DATE
NPDES
GRANT
SIZE
TYPE
Step 3:
Step 4:
Press or to place the cursor on the
activity desired in the 'DO YOU WANT TO:' box.
Press .
Press or to place the cursor on the
data field desired in the 'SELECT A DATA FIELD' box.
Press to continue to the next screen,
Exhibit 4-17.
The 'TABLE FILE 104(g)(l)' box at the bottom of Exhibit 4-17
will keep track of the options selected. For example, Exhibit 4-
18 the box will read as follows if 'PRINT THE INDIVIDUAL VALUES
OF' is selected from the 'DO YOU WANT' box and 'REGION' is selected
from the 'SELECT A DATA FIELD' box.
EXHIBIT 4-18
TABLE FILE 104(g)(l) BOX
TABLE FILE 104(9)(1)
PRINT REGION
30
-------
The first report column has been designed.
Step 5: Select the next activity from the 'AND IN THE NEXT
REPORT COLUMN' box, EXHIBIT 4-19, (no more, print,
write, compute, etc..). Press .
EXHIBIT 4-19
AD HOC UTILITY OPTIONS SCREEN tt2
Keys: ENTER Select PT1 Field Definitions PF2 Revise Mode
PF3.12 Undo PF4 Top PF5 Bottom
PF7 Scroll Up PF8 Scroll Down PF9 Multi-select
Ana in the next report***
No more
And PRINT the individual ...
And WRITE the PERCENT Of
Select a data field
REGION
STATE
FACILITY
DATE
Step 6: Again, select a data field from the 'SELECT A DATA
FIELD' box. Press .
If 'AND WRITE THE PERCENT OF' is chosen from the
'AND IN THE NEXT REPORT' box and a data field is
chosen from the 'SELECT A DATA FIELD' box, the
'TABLE FILE 104(g)(l) box will read as follows.
Exhibit 4-20.
EXHIBIT 4-20
TABLE FILE 104(g)(l) BOX
TABLE FILE 104{g)tl)
PRINT REGION AND PERCENT SIZE AND COMPOTE PRODUCE
31
-------
steo 7- When all of the desired report columns are Pr°9ra™
med, place the cursor 'NO MORE' in the 'AND IN THE
NEXT REPORT' box, Exhibit 4-19. Press .
After 'NO MORE* is Chosen from the 'AND IN THE NEXT REPORT'
box, the sort information must be provided. Jhe next screen
Exhibit 4-21, is very similar to Exhibits 4-17 and 4-19, but win
contain a 'SELECT A SORT ORDER ACTION' box.
AD HOC UTILITY OPTIONS SCREEN »3
Keys:
ENTER select PFI Field Definitions
t>i?^ 1 ? Undo PF4 Top
PF7 Scroll up PF8 Scroll Dovn PF9 Multi-select
PF2 Revise Mode
PFS Bottom
Select a sort order action
None or no wore
Sort the rows ALPHABETICALLY BY field.
Sort the rows HIGH to LOW (2-A 9-0)
Sort the columns ACROSS the page
Sort the columns ACROSS high to low
4- (MORE) -——'———'«"•""-.—»••««•"•—-— -*•'-—•—*—"*
Select a data field
REGION
STATE
FACILITY
DATE
NPDES
GRANT
SIZE
TYPE
Step 8: or to the choice for the sort.
.
Press
32
-------
4.3.2 Brief Overview of Option Menus
The 104(g)(l) program will continue to provide menus to
specify the records to be selected;
EXHIBIT 4-22
RECORDS SPECIFICATION OPTION
BO you want to select only
No
yes - WHERE test
to select a relation between the fields or columns;
EXHIBIT 4-23
SELECTING A RELATION OPTION
Select a relation:
IS EQUAL to
Is N03? EQUAL to
T ft rf"*U JP^fTPtt TJH^WT
£. $> \24\£*x*i*L£«fv «il»f\£»
Is LESS THAN
IS GREATER THAN Or EQUAL tO
Is LESS THAN or EQUAL to
CONTAINS tne characters
OMITS the characters
33
-------
to compare fields;
EXHIBIT 4-24
FIELD COMPARISON OPTION
-What do you want to compare, .field. .?
-A specific value
field
to add record selection tests;
EXHIBIT 4-25
RECORD SELECTION TEST OPTION
-Any additional record selection tes-
ts?
-No
Yes - OR another condition
yes - AND another condition
and, to enter a value.
EXHIBIT 4-26
OPTION TO ENTER A VALUE
4-
' iEnter a values
34
-------
When all record specification, data specification, and
sorting information is provided, the following box will appear with
a final formatting question,
EXHIBIT 4-27
REPORT FORMATTING OPTIONS
-Do you want a page HEADING or FOOT-
ING?
-None or no more
Yes , HEADING
yes , ana CENTER the HEADING
y.es , a FOOTING
yes , a CENTERED FOOTING
Yes , a FOOTING at the page BOTTOM
Yes a CENTERED FOOTING at tne BOTTOM
and the final ad hoc utility reporting question will appear
EXHIBIT 4-28
REPORT PROCESSING OPTIONS
-Do you want to -
-Execute this request? -
Execute, as a test w/xintited records?
Send the report to the system printer
Save this request?
Save this session for later revision?
retrieve tte ftata but HOU> in a file?
Retrieve the data and SAVE in a file?
Clear this request?
QUIT
35
-------
4.3.3 Displaying and Printing a Designed Report
Exhibit 4-28 appears on the Ad Hoc Utility Options
Screen, Exhibit 4-21, after all data required and sort actions have
been entered. Follow the steps below to display or print the
report.
Step 9: or to the desired option. Press
.
Read all options carefully before choosing one.
To display the report, select 'EXECUTE THIS
REQUEST'. TO print, select 'SEND THE REPORT
TO THE SYSTEM PRINTER'. Press .
The 'RUNNING' prompt, Exhibit 4-29 will verify
a submission.
EXHIBIT 4-29
RUNNING PROMPT
RUNNING...
Exhibit 4-28 will re-appear after each option except
'CLEAR THIS REQUEST' and 'QUIT'. Exhibits 4-14 (Ad Hoc Instruc-
tions) and 4-15 (Reports for 104(g)(D) respectively will appear
after those options.
36
-------
CHAPTER 5. HELP FUNCTION
A help function is installed to assist with the input of informat-
ion and the display of reports.
5.1 ACCESSING THE HELP SCREENS
The 104(g)(l) database contains three help screens. Two are used
in the add or update function (Chapter 3), and one is used in the
report displaying function (Chapter 4).
5.1.1 Add or Update Records Menu - Help screen
The first help screen is accessible from the Add or Update
Records for 104(g)(l) System menu, Exhibit 5-1.
EXHIBIT 5-1
ADD OR UPDATE RECORDS MENU
ADD OR UPDATE RECORDS FOR 104U) SYSTEM
REGION J,
PLEASE ENTER THE FOLLOWING INFORMATION
STATE: (REQBJBED)
VALID STATES
CT m ME NH SI V3?
FACILITY NAME:
ENTER 3t TO RETURN TO MENUS
PRESS ENTER TO CONTINUE
PRESS FFS FOR HELP
,i
Step l: Press to access the Add or Update Records Menu
- Help Screen, Exhibit 5-2.
Step 2: Read instructions and/or definitions carefully.
Press to return to the Add or Update Records
for 104(g)(l) System screen. Exhibit 5-1.
37
-------
==s ==: ==== =
.««.««»•.-»«—» HELP SCREEN =================
STATE: ENTER THE POSTAL CODE
FACILITY: NAME OF COMMUNITY
OR WASTEWATER FACILITY
(ABBREV, TO 16 CHARS)
A BLANK FACILITY WILL ALLOW A SCAN OF
ALL FACILITIES IN THE STATE.
PRESS PF7 TO RETURN TO SCREEN
5.1.2 Add New Records. Update Facility, and Update Record
- Help Screen
The second help screen is accessible through the Add New
Facility Update Facility, and Update Record screens. Although the
titles are different, the three screens contain the exact same
fields for data input and/or update, Exhibit 5-3.
EXHIBIT 5-3
ADD OR UPDATE INPUT SCREEN
XXXXXXXX^XXXXXXX ===========
===========
REGION*. I
STATE;
* FACILITY J3AHE:
* DATE {MMDDYYJ :
JJPDES f:
, GRANT #:
RESULTS, OF ^TECH ASSIST:
COMMENTS:
CT
BEACON FALLS
032787
CT0101061 SIZE(MGD):
CQ9Q116 TYPE;
CT PSRF LIMITING, FACTORS:
.500
AS
H
BLAm -TO ACCEPT XUSCGRD AKD SEE HEX* RECORD
R -TO ACCEPT RECORD AND RETURN TO SELECTION SCREEN
C -TO CANCEL THIS TRANSACTIONf AMD RETURN TO SELECTION SCREEN
X -TO DELETE THIS RECORD
f*****«««*«»««a*^*mte**»^««s«»a^*»****
$AB TO DESIRED FIELD/PRESS ENTER TO CeaSTJNUE/PJRESS PF* FOR BELP
38
-------
Step 3: Press to access the Add or Update Data Input
Help Screen, Exhibit 5-4.
EXHIBIT 5-4
ADD OR UPDATE DATA INPUT - HELP SCREEN
HELP SCREEN **********»******«*'****
>*FACILITY: NAME OF COMMUNION OR WASTEWATER FACILITY (16 CHARS)
ENTER BLANK TO SCAN ALL FACILITIES FOR THE STATE*
* DATE! ENTER THE APPROXIMATE DATE ON-SITE TRAINING BEGAN
( * ENTER A NEW VALUE TO SEARCH FOR OR CREATE A NEW RECORD I
NPDES: ENTER THE EPA NPDES # ««..«»-«« :
GRANT: ENTER THE MOST RECENT GRANT # FOR FACILITY CONSTRUCTION
SIZE: ENTER THE DESIGN AVERAGE DAILY FLOW (DRY WEATHER) IN HGD*.
f f .
TYPE: AL-AERATED LAGOON OG-CLARK3ESTQR
AS-ACTIVATED SLUDGE PC-PHYS-CHEMICALj CARBON ABSORBTIOM
CS-CONTACT STAB. RBC-ROTATJNG BIOLOGICAL CONTACTOR & .
L-LAGOON SP-STABILIZATIOSf POND
Aeration TF-TRICKLING FILTER '-• ;-
OD-OXIDATION DITCH
RESULTS: C - IN COMPLIANCE N - UO CHANGE
I - IMPROVED PERFORMANCE T - STILL IN TRNG
PLFi ENTER UP TO 4 LETTERS FROM HEGGS LIST
PRESS PF7 TO RETURN TO SCREEN
Step 4: Read instructions and/or definitions carefully.
Press to return to the Update Record screen.
Exhibit 5-3.
5.1.3 Report Display/View - Help Screen
The third help screen is connected to the report function.
The help screen appears when the option to display/view a report
is chosen on Exhibit 5-5.
Step 5: Press on the Report View Menu, Exhibit 5-6.
to access the help function.
NOTE: This help screen is not yet functional. If
is pressed, the user will exit the 104(g)(l)
program.
39
-------
EXHIBIT 5-5
REPORTS FOR 104(g)(l) FACILITIES/TRAINING DATABASE MENU
REPORTS FOR 104{g)(l) FACILITIES/TRAINING DATABASE
__——— —
s a:B5s=sri= ss=as star sssa =ss =ss =:ss ssss as= assa =as sss
STANDARD REPORTS
THE DEFAULT REGION FOR THE REPORT IS:
1 - HQ LISTING
2 - NPDES REPORT
3 - LIST SYSTEM DATA
4 *• COUNT FACILITIES
T - AD HOC REPORT UTILITY
X - RETURN TO MAIN MENU
REGION I
RETURN TO THE MAIN «ENU
TO CHANGE THE DEFAULT
DISPLAY* D
STATE ;
-------
APPENDICES
-------
APPENDIX A: KEY INFORMATION FIELDS OPTIONS AND DEFINITIONS
PLF(S) = PERFORMANCE LIMITING FACTORS
Options: A, B, C, D, E, F, G, H, I, J, K, L, M, N, O,
P, Q, R, S, T, U
A - Poor understanding and application of process
control by operator
B - staffing (too few staff, low pay, turnover,
etc. )
C - Support from municipality (administrative and
technical)
D - Operating budget and user charge system
E - Operability/maintainability considerations
(process flexibility, automation, standby
units, alternate power source)
F - I/I
G - Construction problems
H - Process design errors (clarifiers, aerators,
disinfection, etc.)
I - Over design
j - Under design
K - Solids handling and sludge disposal
L - Pretreatment, industrial dischargers, and
toxics
M - O&M manual
N - PM program
0 - Spare parts inventory
p - Chemical inventory
Q - Laboratory capability for process/NPDES testing
R - NPDES reporting
S - Equipment/unit processes broken down/ino-
perable
T - Hydraulic Overload
U - Poor aeration system
Up to four letters can be assigned to each facility based
on the "performance limiting factors" that were found at
each facility that most contributed to its noncompliance
or its poor state of O&M. These should be listed from
left to right from most contributed to least contributed,
respectively. Use your best judgement in applying these
factors.
42
-------
APPENDIX A (CONTINUED)
RESULTS OF TA = COMPLIANCE STATUS OF TECHNICAL
ASSISTANCE
Options: C, CT, D, I, IT, M, MT. N, NT, T
*C - In Compliance, Assistance Completed
CT - compliance, Still in Training
*D - Diagnostics Only, Assistance Completed
*I - improved Performance, Assistance Completed
IT - Improved Performance, Still In Training
M - compliance Maintenance, Assistance Completed
MT - compliance Maintenance, Still in Training
*N - No Change, Assistance completed
NT - No Change, Still in Training
*T - Still in Training
*Primary codes to be used on the relevant fields. Other
codes can be used, if applicable. The codes should be
updated on a regular basis.
TYPE = TYPE OF FACILITY
Options: AL, AS, CS, EA, L, OD, OG, PC, RBC, SP, TF, OTH
AL - Aerated Lagoon
AS - Activated Sludge
CS - Contact Stabilization,
EA - Extended Aeration
L - Lagoon
OD - Oxidation Ditch
OG - Clarigestor
PC - Phys-chemical; Carbon Adsorption
RBC - Rotating Biological Contactor
SP - stabilization Pond
TF - Trickling Filter
OTH - Other (Use comment field to explain. )
43
-------
APPENDIX B: COMPREHENSIVE ACRONYMS AND ABBREVIATIONS LIST
AL - Aerated Lagoon
AS - Activated Sludge
C - In compliance, Assistance Completed
CS - Contact Stabilization
CT - Compliance, In Training
D - Diagnostics Only, Assistance Completed
DBA - Database Administration
EA - Extended Aeration
104(g)(l) Wastewater Treatment Systems Database
or 104(g)(1)
I - Improved Performance, Assistance Completed
IT - Improved Performance, In Training
L - Lagoon
M - compliance Maintenance, Assistance Completed
MGD - Million Gallons Per Day
MT - Compliance Maintenance, In Training
N - No Change, Assistance Completed
NPDES National Pollution
Discharge Elimination System
NT - No Change, In Training
OD - Oxidation Ditch
OG - Clarigestor
PC - Physical-Chemical; Carbon Absorption
PLF(s) Performance Limiting Factor(s)
RBC - Rotating Biological contactor
SIZE - The design average daily flow of the facility in MGDs
SP - Stabilization Pond
T - Still in Training
TA - The following options are used to indicate the compliance
status of technical assistance: C, CT, D, I, IT, M,
MT, N, NT, T
TF - Trickling Filter
TYPE - The following options are used to specify the type of
facility: TF, AS, CS, OG, RBC, SP, AL, L, PC, EA, OD,
OTH
44
------- |