ry
United Slates Office of Water March 1990
P-=te=.ion (WH-5S08) 800R90103
iff.! Agency
00^53
EPA Federal Reporting
Data System (FRDS-ll)
Interactive Retrieval
Users Guide
1 HEADQUARTERS LIBRARY .
co ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON, D.C. 20460
o
-------
Federal Reporting Data System (FRDS-II)
Interactive Retrieval System User's Guide
Release Log
Note:
All change notices/descriptions that relate to the FRDS-II
Interactive Retrieval System User's Guide should . be filed
immediately following the release log.
Change
Notice
Release
Number
1 .00
_ _
_
_ ___ __
Effective
Date
10/01/89
'
____ __
_________
i __________
1
Description of Release :.:.
Initial Release of Production Documentation
•
• - • • .
•
-
Effective Date: 10/01/89 ' Release Number: 1.00
Page: i
-------
TABLE OF COMTEHTS ,
Page
SECTION 1 - INTRODUCTION 1-1
1 . 1 Purpose 1-2
1 . 2 Design Philosophy 1-2
1. 3 Constraints . . 1-6
1 . 4 FRDS-II Data Base Features 1-6
1.«*.1 FRDS 1.5 vs FRDS-II Retrieval Capabilities 1-9
1.S User Profile 1-10
1.6 FRDS-II/Interactive Retrieval System User's Guide
Organization 1-11
SECTION 2 - SYSTEM SUMMARY 2-1
2. 1 System Overview 2-2
z . 2 Retrieval Overview 2-3
2.2.1 Establishing the Search Domain 2-3
2.2.2 Searching the Data Base 2-4
2.2.3 Extracting and Presenting the Data 2-4
2 . 3 Operational Environment 2-<4
2 .<* Equipment 2-6
2 . S Security 2-7
SECTION 3 - SYSTEM OPERATION 3-1
3 . 1 Initiation Procedures 3-2
3.1.1 Logon for Locations Using the TYMNET
Communications System 3-2
Effective Date: 10/01/89 Release Number: 1.00 Page: ii
-------
TABLE OF CONTENTS (CONTINUED)
Page
3.1.2 Logon for Users Dialing in Washington* DC
and Research Triangle Park, NC 3-4
3.1.3 Telecommunications for PC Users 3-11
3 . 1*. 4 Full-Screen Access 3-11
3.1.5 Logon in Case of Terminal Disconnection 3-m
3.2 Operational Procedures 3-14
3.2.1 Executing FRDS-II/Interactive 3-14
3.2.2 Description of the Function Menu 3-16
3.2.3 Beginning FRDS-II/Interactive 3-16
3.2."4 Message Updates : 3-16
3.2.5 Special Purpose Keys 3-19
3.2.6 FRDS-II/Interactive Session Cancellation 3-22
. 3 Error and Recovery Procedures 3-22
3.1 Exit Procedures 3-23
SECTION 4 - USING THE MAIN MENU 4-1
4.1 Description of the Main Menu 4-2
4 . 2 Main Menu Selections 4-2
4.2.1 Function 'Of - To Terminate FRDS/Interactive.. 4-6
4.2.2 Function 'A1 - Assist (prompted Query) '. 4-9
4.2.3 Function 'D' - Re-Display of FRDS-II/
Interactive and System Messages 4-28
4.2.4 Function 'E1 - Retrieve PMSs Whose IDs are
in an External File 4-31
Effective Date: 10/01/89 Release Number* 1.00 Page:
-------
TABLE OF CONTENTS (CONTINUED)
Page
4.2.5 Function 'G' ,-Obtain Geographic Information
for a Specific City or County 4-33
4.2.6 Function 'P1 -Post Retrieval Processing 4-35
4.2.7 Function 'Sf -Enter System 2000 Self Contained
Facility (Natural Language) 4-36
4.2.8 User-defined Query 4-41
4.2.8.1 Function 'X1 - Formulate Non-prompted
Retrieval Selection
Clauses 4-41
4.2.8.2 Function (Z* - Formulate Non-prompted
Retrieval Selection
Clauses 4-42
-ECTION 5 - USING THE POST-RETRIEVAL PROCESSING OPTIONS
tlENU 5-1
5.1 Description of the Post-retrieval Processing Options
Menu 5-2
5.2 Post-retrieval Processing Options Menu Selections and
Report Examples 5-»»
5.2.1 Option 'A1 - Aggregate Violations - Aggregate
Violations Report (Not
Available) 5-7
5.2.2 Option 'B' - Batch Job Submission 5-8
5.2.2.1 FRDS01 - Public Water System
Comprehensive . 5-13
Effective Date: 10/01/89 Release Number: 1.00 Page: iv
-------
TABLE OF CONTENTS (CONTINUED)
Page
5.2.2.2 FRDS03 - Public Mater System Service
Area and Source Area. . 5-15
5.2.2.3 FRDS07 - Facilities and Population
Served by Primary Mater Supply
Source 5-17
5.2.2.4 FRDS17 - Enforcement Actions Summary
by Population (Not Available) 5-19
5.2.2.5 FRDS18 - Enforcement Actions Summary
by Type and Primary Water Supply
Source (Not Available) 5-20
5.2.2.6 FRDS19 - Violation Summary by
Population 5-21
5.2.2.7 FRDS20 - Violation Summary by
Primary Mater Supply Source 5-26
5.2.2.8 FRDS21 - Variance and Exemption
Summary by Population (Not Available) 5-28
5.2.2.9 FRDS22 - Variance and Exemption
Summary by Primary Mater Supply
Source (Not Available) 5-29
5.2.2.10 FRDS23 - Public Mater Supply System
Violation and Source Data (Not
Available ) 5-30
5.2.2.11 FRDS24 - Public Mater Supply System
Summary and Violation Data 5-31
5.2.2.12 FRDS31 - PWSs Months in Violation.... 5-33
5.2.2.13 FRDS35 - Annual Data Evaluation 5-
-------
TABLE OF CONTENTS (CONTINUED)
Page
5.2.2.14 FRDS36 - Informal Enforcement
Actions (Not Available)... 5-47
5.2.2.15 FRDS37 - Multiple Tear Violations
(Not Available) 5-48
5.2.3 Option 'C' - Create a File for SAS -
Sequential File (Not Available) 5-49
5.2.4 Option 'F* - Frequency Distribution -
Frequency Distribution of Data Report 5-50
5.2.5 Option *G' - Graphs or Maps (Not Available).... 5-55
5.2.5.1 Graph 1 - Number of PWSs by
Administrative Region N/A
5.2.5.2 Graph 2 - Percent of PWSs by
Administrative Region N/A
5.2.5.3 Graph 3 - Number of PWSs by
Population N/A
5.2.5.4 Graph 4 - Per Cent of PWSs by
Population N/A
5.2.5.5 Graph 5 - Number of Violations by
County N/A
5.2.5.6 Graph 6 - Location of PWSs N/A
5.2.6 Option 'I' - Invoke IDRS/CERCLIS - IDRS State
flap, IDRS Region Map, IDRS United States Map,
Report for Crosswalk One, Reports for Cross-
. walks Two through Five (Not Available) 5-56
Effective Date: 10/01/89 Release Number: 1.00 Page: vi
-------
TABLE OF CONTENTS (CONTINUED)
Page
5.2.7 Option 'K' - Kounts or Suras oi PUS Elements -
Count/Summation of Data Report (Not Available). 5-57
5.2.8 Option 'Lf - List in Standard Screen Format -
Reports for Suboption Screens 5-58
5.2.9 Option frT - Hap of PWS by State, Region, or
United States - PUS State Map, PUS Region nap,
PUS United States Map (Not Available) .5-65
5.2.10 Option 'P.1 - Suicklook Report Generator -
fiuicklook Report 5-66
5.2.11 Option 'T* - Totals of PWS Information -
Totals Inventors' Summary and .Totals violation
Summary Report (Not Available) 5-103
5.2.12 option *E* - End Post-retrieval 5-104
SECTION A - APPENDIXES .' A-1
A.1 Appendix A - Special Syrabols/Keyuords/Keys A-2
Effective Date: 10/01/89 Release Number: 1.00 Page: vii
-------
-------
SECTIOM 1
INTRODUCTION
Effective Dates 1 0/0 1/89 Release Number: 1.00 Pages 1-1
-------
SECTIOK I - INTRODUCTION
1.1 PURPOSE
The Federal Reporting Data System (FRDS-II) is designed to
support the Environmental Protection Agency (EPA) Office of
Drinking Water (ODM) in monitoring compliance uith the Safe
Drinking Water Act of 1974. FRDS-II/Interactive provides EPA
Headquarters, Regional, and State personnel uith a convenient.
easy-to-use facility for searching through the files of FRDS-II
and retrieving the information available for each Public Water
System (PWS).
This release of the FRDS-II/Interactive Retrieval System User's
Guide does not include all functions and capabilities that will
eventually be incorporated into the FRDS-II System. This
release is intended for use uith the FRDS-II Base-line, which
will have a limited number of functions. All functions that are
unavailable in the FRDS-II Base-line System will be noted in the
Table of Contents and in the text as "NOT AVAILABLE" or "N/A".
1.2 DESIGN PHILOSOPHY
FRDS fizst became operational in Federal Fiscal year 1977, and
uas designed to satisfy the need for Federal oversight of the
Public Water Supply Supervision (PUSS) program. At that time,
summary data for each PWS uas collected on an annual basis and
foruarded to the EPA National Computer Center (HCC) at Research
Triangle Park (RTP), North Carolina and loaded into a SYSTEM 2000
(S2K) data base residing on EPA's Univac 1108 computer system.
Effective Date: 10/01x89 Release Number: 1.0.0 Pages 1-2
-------
During fiscal years 1978-198U, this process was repeated
annually with an entirely separate, and new, data base being
generated by EPA for each Federal fiscal year of data being
reported by primacy agencies. Also during this period of
time, there uere several operational and technical changes
made to FRDS, such as the migration of the -FRDS data base
from the UNIVAC 1108 to the IBM 370. None of these changes.
however, had an impact on the primacy agency reporting.
In fiscal year 1985, the EPA Office of Drinking Water CODU)
issued guidance requiring primacy agencies to report their data
on a quarterly, rather than an annual basis. Shortly after the
end of each quarter, EPA combined the most recently submitted
quarterly data with the data submitted over the prior three
quarters and generates a FRDS data base containing four quarters
of data. This method of data gathering (FRDS 1.5) is untenable
for the long term because of the inherent problems in data
management and technical limitations in conducting effective
oversight for periods of over 12 months.
• In 1985, EPA initiated an effort to evaluate and revise, as
appropriate, the Federal reporting requirements for the Public
Water Supply Supervision (PUSS) program. This effort resulted in.
the publication of Water Supply Guidance V-2, Public Mater
Supervision Revised Reporting Requirements (RRR). As a result,
FRDS-II has been designed to meet the needs of the RRR, and
increase the flexibility of FRDS to meet the present and future
information needs envisioned by the PWSS program. FRDS-II will
accommodate four major modifications in addition
Effective Date: 10/01/89 Release Number: 1.00 Page: 1-3
-------
to the incorporation of. many new features. The major
modifications include: Data Base Integration; Non-compliance
Tracking; Historical Data Retentions and Storage of State •
Discretionary Data.
As noted earlier, the original FRDS concept was to generate a
totally new and separate FROS data base for each submission
of data from primacy agencies. This has resulted in the
generation of 12 different FRDS data bases, each containing
similar information on Inventory and a summary of each fiscal
year's Actions (Violations, Variances C Exemptions, and
Enforcement Actions). In contrast, FRDS-II will contain a
single Inventory (representing the most recent Inventory
submission by primacy agencies) and all of the Actions for
the past 8 years. This "Continuum" data base will maintain
approximately 8 years of Actions (except for .Chemical and
Radiological contaminant related actions, which will be
retained for 20 years) with new quarterly reported Actions
being added and old Actions reported more than 8 years prior
to any FRDS-II update being archived.
FRDS-II incorporates a significantly different structure than
that of FRDS 1,5. The following page portrays FRDS 1.5 and the
locations in the FRDS-II structure where like data will be
stored.
FRDS-II/Interactive is an interactive tool used by clerical,
professional, and management personnel who are familiar with
Effective Date* 10/01/89 Release Number: 1.00 Page' 1-4
-------
FRDS1.5
= NOT CONVERTED
FRDS-II
Effective Date: 10/01/89
Release Number: 1.00
Page: 1-5
-------
the type of information stored in FRDS data base. However,
technical knowledge of computers is not needed in order to
operate the system.
The design philosophy of FRDS-II/Interactive focused on system
use by non-technical personnel. The system was developed and
continues to be enhanced uith the following as guidelines:
1) The terminology used is that of the PUS program.
2) Help is available by entering "?" to any prompt issued
by the system allowing you to determine possible
answers to the question being asked.
3) A User Assistance hotline makes fast problem resolution
possible.
4) Users" wants and needs are considered in developing new
FRDS-II/Interactive features..
1.3 CONSTRAINTS
Several constraints are inherent in the design of FRDS-II/
Interactive. They are as follows:
1) On-line updating of the FRDS-II Data Base is not
supported.
2) In the prompted features of FRDS-II/Interactive a user
can only select information based upon answers to
previously defined questions.
Effective Date: 10/01/89 Release Number: 1.00 Page: 1-6
-------
, 3) Updating the FRDS-II data base takes priority over
retrievals from the data base at selected times during
the year. notification of the update activity is
published in broadcast messages well in advance of and
during the time of these occurrences. Typically,
updates are performed after 1 P.M. Eastern Time.
1.U FRDS-II DATA BASE FEATURES
Typical of most good information systems, FRDS has accommodated
many changes as part of its normal growth pattern. The most
significant change thus far, has been in supporting the shift
from an annual to a quarterly reporting requirement that was
implemented in FRDS 1.5. The resultant FRDS 1.5 system
consisted of 10 data bases with a total of 2.5 billion
characters. The.increasing emphasis upon FRDS as an
oversight support system, especially with respect to
effective tracking of enforcement activity, placed a burden
upon the FRDS 1.5 system. It became more and more apparent
that in its present configuration, FRDS became too unwieldy
to support the expanding needs of the Drinking Mater Program.
With the revisions to the Safe Drinking Water Act and the
subsequent publication of the Revised Reporting Requirements,
FRDS-II has been developed.
FRDS-II is intended to increase the flexibility of FRDS to
meet the present and foreseeable future information demands
placed upon the system. To meet this objective, FRDS-II will
Effective Date: 10/01/89 Release Number: 1.00 Page: 1-7
-------
accommodate five major modifications in addition to several ;
new features. As mentioned in Section 1.2, these major
modifications are as follows'
o Data Base Integration - This effort combined (or inte-
grated) the last nine FY data bases uhich contained the
most current PUS information. The resulting data base
is a single data base uhich is available for updating
and retrieval. For this integration process, a
"Hatching Algorithm" uas developed and employed to
ensure the most effective match between PWSa as
possible. Kon-matching PUSs uere flagged as
"historical" for subsequent analysis and clean-up.
o Mon-Compliance Tracking - This feature adds a
non-compliance profile record to the FRDS-II data base.
This uill allow for the generation of 3-month, 12-month*
21-month, 36-month, and 48-month "compliance windows"
for each PUS having an enforcement and/or violation
action reported against it during the last five years
(seven years for CHEM and RAD violations). These
records are generated whenever additional violation or
enforcement actions are entered for the PUS.
o Historical Data Retention - This feature will allow
insertion of historical data records into the FRDS-II
data base whenever significant changes are detected to
the continuum FRDS-II inventory. Insertion of these
historical records is automatic and will highlight the
date and nature of the change.
Effective Date' 10/01/89 ' Release Number: 1.00 Pages 1-8
-------
o Storage: of State Discretionary Data - This feature will
provide the capability for primacy agencies to store
and retrieve whatever numerical, date or textual data
uithin their portion of the FRDS-II data base.
In addition to the four modifications noted above, design
differences betueen FRDS 1.5 and FRDS-ZI afforded the
opportunity to change data element numbers in the FRDS-ZI
system.
1.4.1 FRDS 1.5 vs. FRDS-II RETRIEVAL CAPABILITIES
Considerable effort has bean made to adapt the current
FRDS/Interactive retrieval system to the neu FRDS-II data base
structure and content while concurrently incorporating neu,
needed capabilities into the system. Future implementation
will proceed in a phased manner until all currently used FRDS
1.5 capabilities are available in FRDS-II. Additional retrieval
capabilities will include'
a) The ability to select PWSs, for either batch or
interactive reports, based upon any combination of data
contained in the Hon-Compliance Profile Records.
b) The ability to select PWSs, for either batch or
interactive reports, based upon any State Discretionary
Data (SDD) records.in the data base.
c) The ability to select PWSs, for either batch or
interactive reports, based upon a PUS's meeting
criteria to be a Significant Non-Complier (SHC).
Effective Date: 10/01/89 Release Number: 1.00 - Pages 1-9
-------
d) The ability to have batch reports include ONLY those
violations used in establishing selection criteria.
e) The ability to search, in a single data base, for all of
the significant information previously contained in the
12 separate fiscal year data bases maintained under PROS
1.5. Additionally, the capability to res.trict the search
to a specific fiscal year period remains intact.
1 .5 USER PROFILE
The FRDS-II/Interactive user community includes the follouing:
1) SPA ODW
2> FRDS-II Data Base Administrator (DBA)
3) FRDS-II Production Control and User Support
<4) EPA Regions
5) State users
The FRDS-II DBA and FRDS-II Production Control perform necessary
data base maintenance functions including updating, backup,
recovery, archiving, and reloading.
This manual contains all the necessary information for you to
generate batch and on-line reports through FRDS-II/Interactive.
Houever, for further information and assistance contact the
follouing:
Effective Date: 10/01/89 Release Number' 1.00 Pages 1-10
-------
1) national Computer Center (NCC)-IBM User Support
HCC
(919) 541-7862
1-(800) 334-2405
(FTS) 629-7862
2) FRDS-II User Assistance/FRDS Production .Control
PRC
(703) 556-1411
3) FRDS-II DBA
ODU Data Management Staff
(FTS) 382-2799
1.6 FRDS-II/IXTERACTIVE RETRIEVAL SYSTEM USER'S GUIDE
ORGANIZATION
This document describes FRDS-II/Interactive to the non-technical
user including uhat it does and hou to use it.
Section 1 provides an introduction to the system's purpose,
design philosophy, constraints, new features, and user community
Section 2 provides an overview of the system and its retrieval
functions, and a summary of its operational environment,
equipment, and security.
Section 3 provides a guide to the operation of the system. It
describes procedures for initiation, operation, error and
recovery, and exiting.
Effective Dates 10x01/89 Release Number: 1.00 Page: 1-11
-------
Section <* provides a guide for using, the Main-Menu. It
describes the Main Menu and each of its selections.
Section 5 provides a guide for using the Post-retrieval
Processing Options Menu. It describes the Post-retrieval
Processing Options Menu and each of its selections along with
report examples for .each selection. • . -
Sample interactive sessions are displayed throughout this
document, with each session being annotated so as to better
explain various FRDS-II/Interactive functions to the user.
Effective Date: 10/01/89 Release Number: 1.00 Page: 1-12
-------
SECTION 2
SYSTEM SUMMARY
Effective' Date: 10/01/89 Release Number: 1.00 Page: 2-1
-------
SECTION 2 - SYSTEM SUMMARY
2.1 SYSTEM OVERVIEW.
FRDS-II/Interactive provides a flexible means of retrieving and
reporting PUS data.
EIGHT types of PUS data are maintained in the FRD.S-II DATA BASE'
1) Summary data including identification and statistical
summary information for each PUS
2) Inventory data including source information, source
treatments, address information, service areas,
geographic areas, and historical information
3) Violation data including information pertaining to a
PUS's non-compliance uith EPA and/or primacy standards
<*) Variance, exemption., and other data including
information pertaining to primacy agency exceptions to
a PUSs normal standards and turbidity uaivez
information
5) Enforcement action data including information
pertaining to legal actions taken.against a PUS
6) Non-compliance profiles
7) State discretionary data
8) On-site visit, data
Effective Date: 10/01/89 Release Number: 1.00 Page: 2-2
-------
FRDS-II/Interactive presents a question and answer session
|allowing you to perform several functions in order to gain
information from the FRDS-II data base. These functions are:
1) Formulate selection criteria for use in finding
information from the data base
2) Search through the data base to find PWSs which satisfy
the specified selection criteria
3) Produce various reports required for analysis of
program implementation and other related uses
2.2 RETRIEVAL OVERVIEW
FRDS-II/Interactive data retrieval functions can be divided into
several components>
1? Establishing the search criteria or domain
2) Searching the data base
3) Extracting selected PUS data
«*) Presenting the selected data in an appropriate format
The illustration on page 2-5 depicts the data base architecture
of FRDS-II under the System 2000
-------
1) Search the data base for one or more PWSs which meet
certain criteria
2) Search the data base for violations that are recorded
against PWSs which meet certain criteria
2.2.2 Searching the Data Base
Once the retrieval statement has been formulated you can submit
it to FRDS-II/Interactive for automatic searching of the data
base.
2.2.3 Extracting and Presenting the Data
Once the data has been retrieved from the FRDS-II data base it
is available for presentation in several output formats.
2.3 OPERATIONAL ENVIRONMENT
FRDS-II/Interactive operates at EPA's National Computer Center
(NCC) on an IBM 3090/600-S computer located in Research Triangle
Park, NC and uses VS COBOL II Programming Language Extension
CPLEX). To obtain access to FRDS-II/Interactive, contact
FRDS-II User Support, as noted in Section 1.5. When authorized
to access the FRDS-II data base, each new user will be assigned:
1) User ID and password
2) NCC account number.
FRDS-II/Interactive, operating under the Time Sharing Option
(ISO) of the IBM system, provides all the necessary user
interface facilities for its operation.
Effective Date* 10/01/89 Release Number: 1.00 Page: 2-«*
-------
1
I . .
\
t
1
'
f
I
>
ft
It
ii
'i
• £
* n
»
1
L
II
«
1
1
.
• 1-
« iu 05 in
*• a
SS
o n
u
•
«i
-. i
i >» m
"* w§ Ik
o £ £
o 3
— W
o
- 2
o
tn o
o a
•T
U
— . a •< a
iu M h- a
M H- •< (ft
o >- a
0 O) U >-
* n a
u «i3
o
0 Z >
_» III O IU
^22*
o M ea
o ae iu
m 3 x
u > in
O> IU 1
i U a
K 3<^
0 O -1 < •
2Z E °
* >. i
§ S
a m i
OMB*
S x £
"•« i
h- « >-l
i-it- n
en M M
o i n >
0 Z M I
JJO> g
* 1
IU >
u • in
L> »- O t
0 D 1- Z 3
o o Z 1-1 d.
s«u,
— > 1
in o
in < <
Ul M 1
a o a ?c
0 o O-
m <
U
O 1
M III 0
IU -> IU
o ui in
s-»s «
u
» <
g~* ui i
a
S^£§
1*1 a
" U
u
»s
r< S
lu h» UI
o ix a
N U
** u.
U X
IU
*5 i
P2 5
« < «c
o -i a
•» O
— 1 M
0 >
£
IU
£
<
BJ (- IU
5< P5
i: K i
o < a in
» X
I 1
*>
j
i ."*
IU TJ *> •
ca t c*-
IU O «l *
J i8^°
|K3
•g
|
9> iu 1
12o
2 £g
u 8
« Z 1
00 X
»- M 2
H W
23 i
N M O U.
rt J M Z
U > M
r. £ ,
?£ «
IU M
C02DC 1
«•« M a a
-< -1 U. M
u z >
IU
Effective Date: 10/01/89
Release Number; 1.00
Pages 2-5
-------
2.4 E2UIPMENT
Use of FRDS-II/Interactive requires an app-roved interactive
terminal or PC with a telephone connection to HOC in Research
Triangle Park. HC. In order to gain access to
FRDS-II/Interactive you must logon and enter ISO.
In addition to an approved terminal or PC, use of
FRDS-II/Interactive also requires the following from MCC:
1) Telephone access number
2) User ID and Password
3) Nine-digit account code consisting of a four-digit KCC
account ID and a five-digit FRDS-II project ID
4) Access to TSO
5) Validation for the $EPATSO logon procedure
6) Validation for FRDS-II access.
The following is required from the FRDS-II User Assistance staff:
1) Inclusion in the FRDS-II/Interactive users profile file.
The following is required from the user's own staff:
1) Bin/box number
2) Remote printer number.
Effective Dates 10/01/89 Release Number: 1.00 Pages 2-6
-------
2.S SECURITY
Several types and-levels of security protect the data in the
FRDS-II data base. Anyone wishing to access the data base
uould have to know and be authorized to use the following:
1) A valid user ID for the KCC system
2) A valid account number for the NCC system
3) The appropriate password for the KCC computer account
1) FRDS-II/Interactive authorization
5) Elementary knowledge of TSO
6) SEPATSO logon procedure
Effective Date: 10/01/89 Release Number: 1.00 Page: 2-7
-------
-------
SECTIOM 3
SYSTEM OPERATION
Effective Date: 10/01/89 Release Number: 1.00 Pages 3-1
-------
SECTION 3 - SYSTEM OPERATION
3.1 INITIATION PROCEDURES
Initiation procedures for FRDS-II/Interactive vary according to
geographical location. To logon, follow the procedure in Section
3.1.1, 3.1.2, 3.1.3, or 3.1.4 appropriate to your location.
3.1.1 Logon for Locations Using the TYMNET Communications
System
TYMNET provides NCC with national and international access for
FRDS-Xl/Interactive users. This access is available in over 400
cities in the United States through locally dialed numbers.
TYMNET provides MATS access numbers to users in areas where
local numbers are not available.
To obtain current TYMNET telephone access numbers, refer to
Section 1.5 in contacting FRDS-II User Assistance or call NCC
Telecommunications Support at one of the telephone numbers below:
NCC Telecommunications Support
(919) 541-4506
1 (800) 334-0741
(FTS) 629-4506
The logon procedure for locations using the TYMNET
communications system consists of the following:
Effective Date: 10/01/89 Release Number: 1.00 Page: 3-2
-------
o -. Refer.to Section 2.4 for the required parameters of
terminal operation.
o Turn on power switches of the terminal and modem if
necessary.
o Determine the type of telephone communication equipment
in use and follow the appropriate method as indicated
below:
• - Personal Computer with an internal or external
modem
Direct the communication software (e.g.*
CROSSTALK, PROCOHM, etc.) to dial the telephone
access number applicable to the session location.
Data Telephone
Push the 'talk/clear* button on the telephone.
Dial the telephone access number applicable to the
session location. Wait for ringing, an answer,
and a data tone. Press the red button. Wait
until the ' talk/clear'_, button light indicates that
a connection has been made with NCC from the
geographical location of the session.
Modem with an Acoustic Coupler
I-
Dial the telephone access number applicable to the
session location. Wait for ringing, an answer,
and a data tone. Attach the telephone
Effective Date' 10/01/89 Release Kumber= 1.00 Page: 3-3
-------
receiver to the coupler. Wait until the light on
the coupler indicates that a connection has been
made with KCC from the geographical location of the
session.
Terminals with Acoustic Couplers
Dial the telephone access number applicable to the
session location. Wait for ringing, an answer*
and a data tone. Attach the telephone receiver to
the coupler. Wait until the light on the terminal
indicates that a connection has been made uith NCC
from the geographical location of the session.
- Press the carriage return or enter key.
Follou the sample session on the next page for the,
remainder of the logon.
3.1.2 Logon for Users Dialing in Washington, DC and Research
Triangle Park. NC
Users in Washington, DC and Research Triangle Park, NC access
FRDS-II/Interactive uith facilities other than TYMNET. In
Washington, DC users gain access through statistical
multiplexers while Research Triangle Park, NC users have direct
access to the system.
To obtain current telephone access numbers in Washington, DC
refer to Sectio'n 1.5 in contacting FRDS-II User Assistance or
Section 3.1.1 in contacting NCC Telecommunications Support.
Effective Date:' 10/01/89 Release Numbers 1.00 Page: 3-<*
-------
please type your terminal identifier
-0561:01-020-
pleaee log in: epaZ
MPC2 CONNECT
NODE 10372 HOST 1392: IBHI IS ON LINE
HelcoM to the Enviroroenttl Protection Agency Nation*! Coaputer Center
Pleese enter one of the following selection*:
IBMPSI for IBM
TCP for IBM 3270 EMULATION
VAXA for VAX SYS A
VAXB for VAX STS B
EMAIL for EMAIL
Enter aelectiomibopei
Coonec ted•
U.S. EPA (TTY-X85-IBM)
A TSO - NCC
B MY
C NE1C
D NIC
E SEATTLE
F ATLANTA
5 DALLAS
I KANSAS CITY
J PHILADELPHIA
K CINCINNATI
L SAN FRANCISCO
« BOSTON
N CHICAGO
SELECTION ?e
EPA200 ENTER USERID -
1
2
3
EPA202 ENTER CURRENT PASSWORD FOR
txxxxxx
-.EPA207 ENTER ACCOUNT NUMBER - OR "*" FOR yyyy
M
EPA209 ENTER PROCEDURE NAME - OR "»" FOR tEPATSO
*
EPA211 ENTER FIMAS 10 - OR "»" FOR
EPA213 ENTER BIN NUMBER - OR "»" FOR dddd
*
EPA250 Default REGION SIZE is 6500
ICU7000U MUM LAST ACCESS AT 14:56:28 ON MONDAY, OCTOBER 23, 1969
XKJ56455I HUM LOGON IN PROGRESS AT 14:59:39 ON OCTOBER 23, 1989
9
18
11
U
13
14
continues on next cage
Effective Date: 10/01/89
Release Number: 1.00
Page: 3-5
-------
continued from previous page
I <- - - For • valid response on your terminal. r«f«r to Section.1.5 in
contacting PROS User Assistance.
2 <- - - Systes) message.
3 <_ _ . systea logon infonMtion applicable to all user*.
4 <_._ _ Systes) message.
5 <- - - Indicates a successful comaetion to the systee.
6 < - The user specified a line terminal.
7 <- - - The user selected ISO.
A < torn = User 10 assigned by NCC.
9 <- - - xxxxxx = Password Known only to the user.< Passwords Bust
be six characters in length with at least one of the characters
being nuneric (0 - 9). The first character of the password
oust contain an alphabetic character (A - ZJ.
10<- - - yyyy = Account number assigned to the user by NCC.
11< »EPATSO = TSO procedure rtace.
12<- >"" « ADP utilization identifier assigned to the user by NCC.
13<- - - dddd » The users bin nu«b^r.
14< 6500 = Region size. When logging on to NCC for the first
tin«» the region size is established and thereafter Mill
default to that initial setting. The region size eust be
set to a einiein of 6500 or the FRDS-II/Interactive session
will •bnorawlly end because there will not be enough space
for the systee to execute.
Note: Once the the responses for prompts for numbers 10-13 (above)
have initially been *ade» the user need only respond with an
asterisk (*> to each of those prompts* if those values are to
remain the saee for the user's session.
Effective Date-' 10/01/89
Release Number: 1.00
Page-' 3-6
-------
Users in Research Triangle Park, NC have direct access to
FRDS-II/Interaetive. by dialing 5«H-<46i»2.
The logon procedure for locations using facilities other than
TYMNET consists oi the following*
o Refer to Section 2.
-------
indicates that a connection has been made with KCC
iron the geographical location of the session.
Terminals with Acoustic Couplers
Dial the telephone access number applicable to the
session location. Wait for ringing. an answer,
and a data tone. Attach the telephone receiver to
the coupler. Wait until the light on the terminal
indicates that a connection has been made with KCC
from the geographical location of the session.
Follou the sample session on the next page for the
remainder of the logon.
Effective Date: 10/01/89 Release Number: .1.00 Page: 3-8
-------
WELCOME TO THE ENVIRONMENTAL PROTECTION AGENCY
HEADQUARTERS DATA SWITCH
TO ACCESS:
I8« CTTY)
IBM 3270 EMULATION
EPA/DIALCOM ELECTRONIC MAIL
PRIME
VAX
MODEM POOL
OTHER SERVICES
TYPE:
IBMPSI
TCP
EMAIL
systea n«*
MODEM
HELP
NEED HELP? TYPE HELP
YOUR SELECTIOH?> ibnp»i
Connecting to RTP Data Switch.
HIC1-3671/06 CONNECTED TO MUXA/0*
Connected.
U.S. EPA (TTY-X25-IBH)
A TSO - NCC
6 NY
C NEIC
D MIC
E SEATTLE
f ATLANTA
G DALLAS
I KANSAS CITY
J PHILADELPHIA
K CINCINNATI
L SAN FRANCISCO
M BOSTON
N CHICAGO
SELECTION ?*
EPA200 ENTER USERIO -
EPA202 ENTER CURRENT PASSWORD FOR MM -
:xxxxxx
:EPA207 ENTER ACCOUNT NUMBER - OR "*" FOR yyyy
M
EPA209 ENTER PROCEDURE NAME - OR "*" FOR tEPATSO
»
EPA211 ENTER FIMAS ID - OH "*" FOR rrr*x
*
EPA213 ENTER BIN NUMBER - OR "«" FOR dddd
»•
EPA250 Def»ult REGION SIZE is 6500
<-
<-
<-
<-
<-
<-
<-
Z
I
3
I
4
!
- - 5
7
a
continues on next oaae
Effective Date: 10/01/89
Release Number: 1.00
Pages 3-9
-------
continued from previous page
1 <- - - Th« user selected TSO.
2 < MM = User 10 assigned by NCC.
3 <- - - xxxxxx = Password knotei only to the user. Passwords
. ba six characters in length with at least on* of 'the characters
being nuaeric (0 - 9). The first character of the password
•uat eontkin «n alphabetic character (A - 2).
<«<--- yyyy = Account number assigned to. the user by NCC.
5 < *EPATSO = TSO procedure name.
6 <- - ~ rrrzx * ADP utilization identifier assigned to the user by NCC.
7 <- - - dddd a The users bin number.
6 < 6500 a Region size. MKen logging on to NCC for the first
tia*» the region size is established and thereafter Hill
default to that initial setting. The region size Bust be
set to a Btninue of 6500 or the FROS-II/Interactive session
•ill abnormally end because there Mill not be enough space
for the systea to execute.
Note: Once the the response* for prompts for numbers 4-7, (above!
have initially been Mdet the user need only respond with an
asterisk (*) to each of those proBptSi if those values are to
reaain the lave for the user's session.
Effective Date •' 10/01/89
Release Number •' 1.00
Page: 3-10
-------
3.1.3 Telecommunications for PC Users
Users may access FRDS-II with personal computers with the use of
"CROSSTALK", an EPA standard which may be used to establish
communications through TYMNET or other facilities.
3.1.4 Full-Screen Access
Some users nay wish to access FRDS-II in "Full-Screen" mode.
The sample session on the next page shows the "Full-Screen"
logon procedure. It is worthwhile to note that "Full-Screen"
mode is generally intolerably slou when doing a screen refresh.
unless a modem capable of at least 4800 Baud is used.
Effective Date: 10/01/89 Release Number: 1.00 Page' 3-11
-------
WELCOME TO THE ENVIRONMENTAL PROTECTION AGENCY
HEADQUARTERS DATA SWITCH
TO ACCESS:
IBM (TTYI .
IBM 3270 EMULATION
EPA/DIALCCn ELECTRONIC MAIL
PRIME
VAX
MODEM POOL
OTHER SERVICES
HEED HELP? TYPE HELP
TYPE:
IBMPSI
TCP
EMAIL
•ysteai nan*
systen nan*
MODEM
HELP
YOUR SELECTION?>tcp
Connecting to the UIC TCP
HIC-3671/05 COKNECTEO TO S0601002
** CX-flO VER 04.83 «*
WELCOME TO THE .
U.S. ENVIRONMENTAL PROTECTION AGENCY
TELECOMMUNICATIONS NETWORK
ENTER COMMAND OR M FOR MENU
tso
1 <- - - 'TCP' is selected for full-screen access.
Z <- ~ - For a valid response on your terminal, refer to Section 1.5 in
contacting PROS User Assistance.
3 <- - - System o«ssage.
* < TSO is selected.
NOTE: Th« hyphenated lines shown in the above simulation are not part of
the actual screen displays, but are meant to indicate that the
various prompts and user replys are displayed on individual screens.
Effective Date * 10/01/89
Release Number: 1.00
Page: 3-12
-------
: __ EPA2 TSO/E LOGON T2402720
PF1/FFI3 ==> Help PF3/PF15 =-> Logoff PA1 ==> Attention PA2 --> ReshoM
ENTER LOGON PARAMETERS BELOW:
USERXD ===> MHH •
PASSWORD =«> xxxxxx <- - - Z
PROCEDURE ===> tEPATSO
ACCT NtSR «=> yyyy
FIMAS =aa> zzzzx <- - - *
SIZE ===> 6500
COW1AND
HACF LOGON PARAMETERS:
NEW PASSWORD =">
6ROUP IOENT ===>
BIN NUMBER ===>
SYSOUT DEST ===>
ENTER AN "S" BEFORE EACH OPTION DESIRED BELOW
-HOMAIL -NONQTZCE -NOSUMMART -CANCEL
ICH70001Z LVE LAST ACCESS AT 14:56:25 ON MONDAY, OCTOBER 23, 1989
XKJS6455I LVE LOGON IN PROGRESS AT 14:59:39 ON OCTOBER 23. 1909
READY
1 <_ _ _ ,40, s Th« us*r ID •ssicpted to th« ui«r by HCC.
2 <- - - xxxxxx - Th« pa«s»»opd KnOMn only to th* us«r.
3 <- - - yyyy = Th« aecocnt number ••signed to th« user by KCC.
* <- - - txrf* 3 Th« ADP utilization identifier assigned to the user by NCC.
NOTE: Thti hyphenated lines shown in the above simulation are not part of
the actual screen displays, but are aeant to indicate that the
various proapts and user replys are displayed on individual screens.
Effective Date' 10/01/89
Release Number: 1.00
Page: 3-13
-------
3.1.5 Logon in Case of Terminal Disconnection
If the connection between your terminal and NCC is broken due to
telephone communication problems, power failure, or the like
refer to Sections 3.1.1, 3.1.2, 3.1.3, or 3.1.4 in immediately
performing a logon following steps one through four of the
procedure appropriate to your geographical .location. Then
follow the sample session on the next page for the remainder of
the logon. You have 30 minutes from the time of disconnection
to follow this method. After that time refer to Section 3.1.1,
3.1.2, 3.1.3, or 3.1.4 in performing a complete logon following
the procedure appropriate to your geographical location.
3.2 OPERATIONAL PROCEDURES
The operational strategy for FRDS-II/Interactive is:
1) To execute FRDS-II/Interactive CLIST
2) To begin FRDS-II/Interactive
3) To access the integrated FRDS-II data base
.4) To select PUSs
5) To identify report formats for retrieved data and
generate reports.
3.2.1 Executing FRDS-II/Interactive
After logon the system displays the following message:
READY
If you are using an ASCII Terminal you must enter the following
TSO command at the ready prompt prior to executing FRDS-II/
Interactive. "TERM TRANCNPSD"
Effective Date' 10/01/89 Release Number: 1.00 Page: 3-14
-------
WELCOME TO THE ENVIRONMENTAL PROTECTION AGENCY
HEADQUARTERS DATA SWITCH
TO ACCESS:
IBI1 (TTT)
IBM 3270 EMULATION
EPA/DIALCOn ELECTRONIC MAIL
PRIME
VAX
MODEM POOL
OTHER SERVICES
TYPE:
IBMPSI
TCP
EMAIL
syst«« nan
•ystea n»m
MOO EH
HELP
NEED HELP? TYPE HELP
YOUR SELECTION?> ibnpsi
Connecting to RTP Oat* Snitch.
HIC1-3671/06 CONNECTED TO MUXA/04
Connected.
u.s. EPA cmr-xzs-iBn)
A TSO - NCC
8 NY
C NEIC
D MIC
E SEATTLE
F ATLANTA
6 DALLAS
I KANSAS CITY
J PHILADELPHIA
K CINCINNATI
L SAN FRANCISCO
n BOSTON
N CHICAGO
SELECTION ?•
EPA200 ENTER USERID -
EPA202 ENTER CURRENT PASSWORD FOIt
:xxxxxx
•-ICH70001I MMH LAST ACCESS AT 14:43:14 ON MONDAY, OCTOBER 23, 1989
IKT00300I LOGON RECONNECT SUCCESSFUL, SESSION ESTABLISHED
1
2
3
4
1 < The user selected TSO.
2 <- - - MMM = User ID assigned to the user by NCC.
3 <- - - xxxxxx = PassMord known only to the user.
4 <- - - System message indicating that the session has been automatically
reconnected.
Effective Dates 10/01/89
Release Number: 1.00
Pages 3-15
-------
After entering the ISO "TERM" Command; you may then execute
FRDS-II/Interactive. The sample session on the next page shows
you how to enter the TSO "TERM" Command and execute
FRDS-II/Interactive. For further information and assistance in
executing FRDS-II/Interactive refer to Section 1.5 in contacting
FRDS-II User Assistance.
3.2.2 Description of the Function Menu
The system then displays the Function Menu which allows you to
choose the FRDS-II/Interactive Function. The sample session on
the page after next shows the Function Menu' and how to use it.
3.2.3 Beginning FRDS-II/Interactive
Selecting Code '1 * of the Function Menu allows the system to
begin FRDS-II/Interactive.
For further information and assistance in beginning
FRDS-II/Interactive refer to Section 1.5 in contacting FRDS User
Assistance.
3.2.U Message Updates .
When FRDS-II/Interactive is initiated, it will first display the
current version and release number and then give the user the
opportunity to display instructions on the use of
* •
FRDS-II/Interactive. It will then give the user the opportunity
to display FRDS-II/Interactive documentation, which will then
automatically be followed by FRDS-II/Interactive broadcast
messages.
Effective Date: 10/01/89 - Release. Number •• 1.00 Page: 3-16
-------
READY
exec frdaonii
Loading FRDSONI1 ... On*
pleas. !!
* WelcoM to the Federal Reporting Data System (FRDS-II) =
3 On-Line !!! -
s ' s
= FRDSOHII version Z.1A Effvctiv* d«t«: 12/21/89 =
- Data: 01/06/90 TIM: 15:00:15 =
S 3
s mm«xm»Mi»n SPECIAL NOTICE •••
In ord«r to u»« FRD3-II / Int«r»etiv«> you MUST =
specify SIZE (7500) and PROCEDURE (tEPATSO) during =
your TSO logon. s
3
If you didn't specify th« correct SIZE or PROCEDURE. =
logon again using the value* indicated above ... =
Press <9ETUBN> to continue ...
1
I 1 <
1 2 <- - -
1
1
The user executes FRDS-II/Interactive
The Welcome Message indicates that execution
FRDS/Interaetive was successful.
of
Effective Bate: 10/01/89
Release Number•• 1.00
Page: 3-17
-------
= Federal ' Reporting Date Syst
= PRODUCTION
FROSONII version Z.1A
Function 'Description
End Session and Return to ISO
FRDS-II / Interactive
Natural Language Interface
DISPLAYS « OFF » turn on with
Change Data Base Prefix
Change Systea (Test/Production)
(PROS- II) On- Line =
HEKU =
' s
Effective date: 12/21/89 =
• s
Code -
0. (zero)
1
87
fid
90
91
s End Session and Logoff TSO 99 =
System: PRODUCTION Prefix: FROS.FIIPROO
--> Enter Function Code ...1 ' <-
•Loading FRDS-II/Interactive ... One
t please !!
I.1<- - - The user chose FRDS/Interactive
Effective Date' 10/01/S9
Release Number: 1.00
Page: 3-18
-------
The system then asks if you uant to display the
FRDS-II/Interactive System Messages, uhich will contain a list
of available functions, and other messages of interest to users.
Users with a hardcopy terminal are encouraged to keep copies of
all message updates on hand. Since FRDS-II/Interactive is
continually evolving, documentation uill be updated
periodically, but not necessarily when each neu capability is
first made available. Retaining copies of these messages uill
allow you to maintain up-to-date information prior to the
release of any updated documentation.
The sample session beginning on the next page shous you hou to
respond with the terminal type in use and choose to see the
second stage of message updates.
3.2.5 Special Purpose Keys
Certain features of FRDS-II/Interactive make it possible to
access help tables or interrupt a prompted query dialogue
sequence if necessary. A brief description of applicable
special purpose keys follows.
'?' —• Enter to see the help table of permitted responses to the
query prompt in effect. These features are available for most
query prompts. For further details on help tables refer to
Appendix A.
1!' — Enter if you make an error in responding to the prompted
query dialogue sequence that formulates data selection criteria
statements. This interrupts the prompted query dialogue
Effective Date: 10/01/89 Release Huraber: 1.00 Page: 3-19
-------
Uelcooe to FROS/Interactive
for FRCS-II
Version; 2.0 Release: 1.0
09/17/89 0.51.29
Your FRDS-n/lnteraetive Session initiated at ...
15:01:07 on Monday, October 23, 1969
• > Mould you like instructions on the us* of FRDS-II/Intar»ctive?
(Y)«s or (N)o: n
* FRDS/Interective Broadcast Messages for FROS-II follow ... *
* l»ll»l««H ••••»»><••» •HIIMMIIIIIIMIIHUBNIIIIEItllHUIIII*
SNCs *ay be located in FROS-II by examining the C4050, DBA-DATA, data has*
record for tha following ...
yy = Fedaral Fiscal Year
C4051 equal to "SHC-yy-qq-HCL" or "3NC-yy-qq-HON" qq = Federal Fiscal Qtr.
equal to "0100" (Turbidity)
»l », -1005", "1010", "1015", "1020", "1025", "1030",
"1035", "1040", "10*5", "1050" (Inorganics)
"2005", "2010", "2015", "2020", "2105", "2110"(Organ!cs)
"2950" (TTHM)
"3000" (Bacti)
(Rads)
C4055 equal to "wwddyy" Note: 0930yy appears on SNCs converted fro*
FROS 1.5
Where: mm is the calendar nonth, dd is the calendar day, and yy is the
calendar year.
The FROS/Interactive System Messages for FRDS-II Mere last updated on ...
Sunday, February 5, 1969 at 6:00 ae EST.
* End of FROS/Interactive Broadcast Messages for FRDS-II »
Press to continue ...
Effective Date: 10x01/89
Release Number: 1.00
Page: 3-20
-------
— > Mould you liK« to display the FRDS-II/Interactive Systea Messages?
tY)es or (N)o: y
<- - - 1
» FRDS/Tnteractiva System Messages for FRDS-II follow . .. *
MM MUM JO MM HKHKIIM »»«•>! II HIT HMK II minim II II MM Jill* II >*»>»
Main Menu Functions which are presently available include:
0 End Session (QUIT and END are synonyms to 0)
A Assisted (i.e.. prompted) Locate statement preparation
E Create Locate file fro* datiset containing PHS IDs
6 Geographic Help
P 60 to the Post Retrieval Output Options Menu to re-process
selected/retrieved data
S Natural Language Interface (S2K Self Contained Facility)
X Non-proopted specification of Locate, statement
Z Non-prompted specification of Locate statement for use by Batch
Report Generating Program
— > Continue with the next page of Messages? (Y)es or (N)o: y <- -
Post Retrieval Output Options Mhich are presently available include;
B Batch job submission of Standard format (i.e.i PROS) report
( Reports 01, 03, 07. 19, 20, £*, SI, 25. a 41 are available )
F Frequency distribution of values for a data 'element
L List in Standard Screen Format
Q QuicklooK Report Generator ( minus its PHS Ranking Feature )
E End Post Retrieval Processing
End of FRDS/Interactive Systea Messages for FROS-II «
Press to continue ...
1<- - - The user chooses to display the FRDS/Inttractive System Messages
2<- - - The user continues to the, next page of messages.
Effective Date: 10/01/89
Release Number: 1.00
Pa§e: 3-21
-------
sequence and returns you to the prompts for a Main Menu
selection. For further .details on the Main Menu refer to
Section 4."
'*' — Enter if you specify all the parameters necessary for your
data selection criteria statement 'and uish to bypass only the
questions remaining in the current group of questions. The
system then skips to the first question in the next group.
'BREAK* — Enter to terminate data being written to your
terminal.
3.2.6 FRDS-II/Interactive Session Cancellation
In the unusual situation in which you want to cancel or purge a
disconnected session in progress, refer to Section 1.5 in
contacting NCC-IBM User Support.
3.3 ERROR AND RECOVERY PROCEDURES
If the connection between your terminal and NCC is broken due to
telephone communication problems, power failure, or the like
refer to Section 3.1.5.
If you make an error in responding to the prompted query
(Vialogue sequence that formulates data selection criteria
statements, refer to Appendix A, "Special Symbols/Keywords/Keys".
For further information and assistance in any situation not
otherwise covered, refer to Section 1.5 in contacting FRDS-II
User Assistance.
Effective Date5 10/01/89 Release Numbers 1.00 Page: 3-22
-------
3.1 EXIT PROCEDURES
fo exit a session at the prompt for a Function Menu selection
enter '0*. For further details on the Function Menu, refer to
Section 3.2.2.
To exit a FRDS-II/Interactive session at the prompt fox a Main
Menu selection, enter '0'. For further details on the terminate
FRDS-II/Interactive selection from the Main Menu refer to
Section 4.2.1.
To end a session at the system prompt 'READY', enter 'LOGOFF'.
The sample session on the next page shows you how to end a
session at the 'READY* prompt.
When an exit procedure has been completed, turn off the power
switch on your terminal.
Effective Date: 10/01/89 Release Number: 1.00 Page: 3-23
-------
READY
logoff
MMM :yyyy LOGGED OFF 10/23/89 AT 15:04:04
0:04:24 CONNECT TIKE, 0:08.23 TCB, 0:00.98 SRB
EXCPS: 5476 DA. 0 KT, 366 TERN, 2 OTHER. 5644 TOTAL
CHARGES: *.S5 CONNECT, »1.60 CPU, $2.34 EXCPS
14.49 TOTAL CHARGE FOR SESSION
mm LOSSES OFF TSO AT 15:04:19 ON OCTOBER 23, 1989
I
< 1
< 2
<- - - 3
1<- System prompt uxfer TSO
2< TSO Cossa«nd to ter»in»t« the TSO session
3<- - - System
Effective Date: 10/01/89
Release Number: 1.00
Pages 3-
-------
SECTION «*
USING THE MAIN MENU
Effective Date' 10/01/89 Release Number' 1,00 Page: t»-
-------
SECTION 4 - USING THE MAIN MENU
4.1 DESCRIPTION OF THE MAIN MENU
After FRDS-II/INTERACTIVE is initiated, the system asks for a
Main Menu selection.
Due to the Main Menu's length, the system prompts you for a Main
Menu selection uithout displaying the Main Menu. However, .for
demonstration purposes, the sample session on the page after the
next page shows you how to see the Main Menu by entering 'menu1
at the prompt for a Main Menu selection.
You may choose to exit the FRDS-II/Interactive session at the
prompt for a Main Menu selection. For details on the exit
procedure at the prompt for a Main Menu selection* refer to
Section 3.4.
4.2 MAIN MENU SELECTIONS
The Main Menu offers nine types of selections. These are:
1) Terminate this FRDS-II/Interactive selection (0)
2> Assisted preparation of a SYSTEM 2000 Locate statement
based upon user provided responses CA)
3) Re-Display FRDS-II/Interactive Broadcast or
System Messages • CD)
4) Retrieve PWSs whose IDs are contained in an-
external file < E)
S3 Obtain Geographic Information for a specified City
or County . (G)
Effective Date: 10/01/89 Release Numbers 1.00. Page: n-2
-------
6) Re-process Retrieved data via Post Retrieval Output
Options CP)
7) SYSTEM 2000 Self Contained Facility (i.e.. Natural
Language ) (S)
8) Formulate one or more S2K Locate clauses (X)
9) Formulate one or more S2K Locate clauses and
generate a batch report ' (Z)
Che terminate FRDS-II/Interactive selection exits the
~RDS-II/Interactive session and returns you to the Function
1enu. For further details on the terminate FRDS-II/Interactive
selection, refer to Section H.2.1. For further details on the
function Menu, refer to Section 3.2.2.
fce-display FRDS-II/Interactive Re-Displays Broadcast or system
nessages. For further details on the Re-Display selection.
refer to section 4.2.3.
Retrieve PWSs whose IDs. are contained in a sequential file, is a
selection that allous the user to create a sequential file of
PUS ID and then use them to perform retrievals on the FRDS-II
3ata Base. For further details on this selection, refer to
Section U . 2 . <*.
Effective Date.: 10/01/89 Release Number: 1.00 Page: 4-3
-------
— > Enter Function Code. END. or MENU: menu
Enter • single number or 'letter which represent* your desired response to the
quest ion i then press .
mmiMiM»iiiiii»>«nii>m>iixiinm»»»iiii< FRCS-XX/Xnteraetive Menu
(0 i.e., zero), (END), or (WIT) Terminates this FRDS/Inter active Session
»iiiim>»iniiiiimniii«»iMimii«iiii Specify Retrieval Criteria »••»•••»• aim mmnmim>M»»m»»
(A) Assisted (i.e., prompted) Locate statement preparation
(E) Retrieve PWSs Mhose IDs are contained in an External file -. • '
Non-proepted specification of Mhat is to be retrieved ***
(i.e. i specify SZk Locate cooMrids of your otei derivation)
(X) Execute the Locate command * picK Post Retrieval Output Option
(Z) Scan the Locate commend for correct syntax & submit batch report
Kiscell
Functions •••••••••••miiHim>imniiiinii»iin
(0) Display FROS-XZ/Interactive Broadcast or System Hessagea
(6) Obtain Geographic Information for e specified City or County
(P) Process Retrieved date via Post Retrieval Output Options
(3) SYSTEM 2000 Self Contained Facility (i.e.. Nature! Language)
—> Enter Function Code, END. or MENU:
1<- - - The user entered 'menu1 in order to see the Main Menu
displayed. Using the special purpose Key '?' achieves
the s«oe result.
Z<- - - The user can DOM enter a selection from the Main Menu.
Effective Dates 10/01/89
Release Number: 1.00
Pages t*-t
-------
The selection to obtain geographic information may be used to
display latitude/longitude data for specified cities or
counties. For further details, refer to Section H.2.5.
The post-retrieval processing options selection invokes the
Post-retrieval Processing Options Menu to process previously
retrieved and reported data for another report format. For
further details on the post-retrieval processing options
selection, refer to Section 5.
The user-defined query selections retrieve data from the FRDS-II
data base. Based upon the selection made, FRDS automatically
invokes the Post-retrieval Processing Options Menu after the
query has been satisfied. Post-Retrival Processing enables the
user to report the data on-line, or permits the generation of
batch reports. For further details on the user-defined query
selection, refer to Section «». 2 . 7 . For further details on the
S2K self-contained facility selection, refer to Section H.2.H.
The remainder of Section 4 shows you how to use each Main Menu
•selection in sample sessions. Central to many of these sample
sessions is a hypothetical question that might be asked of the
system. The question is as follows:
What information is available in the FRDS-II data base on
community, active uater supplies in the State of
Pennsylvania having bacteriological violations?
Effective Date: 10/01/89 ' Release Number! 1.00 Page' t-5
-------
tf.2.1 'Function fO' - To Terminate FRDS-II/Interactive
The Main Menu offers the terminate FRDS-II/Interactive
selection. The terminate FRDS-II/Interactive selection allous
you to exit a FRDS-II/Interactive session at-the prompt for a
Main Menu selection. • • •
Selecting Function '0' returns you to the Function Menu. For
further details on the Function Menu refer to Section 3.2.2.
The sample session on the next page shows how to use Function
•0' .
Effective Date: 10/01/89 Release Number: 1.00 Page: 4-6
-------
--> Enter Function Code. END. or MENU: 0
Your FRDS-II/Interactiye Session terminated at
16:59:44 on Monday, October 23. 1999
Elapsed tiee of Session ...
00:03:17
End of FRDS/Interactive
for FRDS-II
Press to continue ...
Federel Reporting Data System (FRDS-ZZ) On-Line =
PRODUCTION MENU =
FROSONIZ version 2.0 Effective date: 09/15/69
Function Description Code
« _^ *•«»«._•* WWWHI^V^ ••*«*••»•••••••• ^^^^
End Session and Return to TSO 0 (zero)
FROS-ZZ / Interactive
S2K Natural Language
DISPLAYS to terminal
DISPLAYS to limbo
Change Data Base Prefix
1
87
M
89 <— On
90
End Session and Logoff TSO 99 =
r=r======si±========:r===z=====s=s==========="=========
Prefix: FRDS.FIIPHOO
> Enter Function Code (96 for Menu) ...0
***** End of FROSONII »*»*»
Restoring TSO Environment
One Moment Please !
TSO Environment Restored
READY
< 5
continues on next page
Effective Da.te'- 10/01/89
Release Number: 1.00
Page: «*-
-------
continued from previous page
l<-
2<-
3<-
5<_ , _
The user enters 0 to terminate the FROS-XI/Xnteraetive session.
Systee Mssage confirming the temirwtion of FRDS-XX/XiTt«r*cttv*.
The user •elects Function code 0 from the eenu to end the session «nd
return to TSO.
Syste* aessege confirming the session is ending.
TSO READY
Efiective Date: 10/01/89
Release Number: 1.00
Page'- 4-8
-------
t.2.2 Function 'A' - Assisted (Prompted) Suez?
The "A" Main Menu function of FRDS-II/Interactive refers to the,
"Assisted (i.e., prompted) Locate statement preparation function.
This function assists the user in the preparation of a SYSTEM
2000 Locate statement based upon user provided responses to the
prompts which are issued when this function is invoked.
Occasionally, a user may find that the "A" function is unable to
construct a Locate statement which results in selection of the
desired set of data, or takes an inordinate amount 'of time to
satisify. It should be noted that the objective of the "A"
function is to provide a "general" retrieval capability by
constructing a Locate statement for the vast majority of
retrieval needs, however, it may not be effective for ALL
retrievals. Further, this function is not intended to be a
replacement for the "X" and "Z* Main Menu functions of FRDS-II/
Interactive. Instead, it supplements those functions for users
•unfamiliar with SYSTEM 2000 Locate statement preparation.
Function *A* implements a multi-leveled approach with respect to
the user dialog provided: a verbose dialog is utilized for novice
users, and a more terse dialog is available for intermediate/
o
advanced users. Additionally, novice and intermediate/advanced
users are treated differently with respect to the way in which
prompts are issued to them and/or the uay in which they can
respond to any given prompt.
Effective Date: 10/01/89 "' Release Number: 1.00 Page: 4-9
-------
Users restrict uhat is to be retrieved from the FRDS-II Data
Base by the responses they provide in five general areas
(referred to as groups). These groups are as follows!
o Group 1 - PUS Inventory Characteristics (8 sub-groups)
1. Classification and Location Data Elements
2. Other Address Data Elements
3. Source/Entity Data Elements
4. Source Treatment Data Elements
5. Geographic Area Served Data Elements
6. Service Area Data Elements
7. On-site Visit Data Elements
8. History Data Elements
Prompt Prefix
(PUS)
(PUS-AD)
(PHS-SE)
(PUS-SE-TREAT)
(PWS-GA;
CPWS-SERV)
(PWS-VISIT)
(PWS-HIST)
6 Group 2 - Violation Characteristics (2 sub-groups)
1. Violation Specific Data .Elements
2. Violation Statistics Data Elements
Prompt Prefix
(VIO)
(VIO/NCP)
Effective Dates 10/01/89
Release Number: 1.00
Page
-------
o Group 3 - Enforcement Characteristics (2 sub-groups)
Prompt Prefix
1. Enforcement Specific Data Elements (ENF)
2. Enforcement Statistics Data Elements (EKF/HCP)
o Group 4 - Variance/Exemption Characteristics (2 sub-groups)
Prompt Prefix
1. Variance/Exemption/Other Specific Data
Elements CVE)
2. Variance/Exemption/Other Schedule Data
Elements • (VE-SCHED)
o Group 5 - Data Base Administrator Characteristics
Prompt Prefix
(e.g., Significant Mon Compliance information) (DBA)
User responses are edited to ensure proper response length,
format, and content with appropriate error messages issued as
needed.
At each prompt issued during the dialog, the user may obtain help
Effective Date: 10/01/89 Release Number: 1.00 Page: (4-11
-------
by entering either a question mark (?) or the keyword "HELP."
The help message provides specific information about the
prompt, uhat may be entered, and hou it is to be entered.
At any time during the prompting dialog, the user may review
the Locate statement that has been constructed thus far by
entering the keyword "REVIEW."
Other special user responses are available for all users. • These
special user responses (and their meaning) are as follous'
Special Response
Meaning
Exclamation Point All user responses-provided to this point are
abandoned and the prompting dialog is started
over front the beginning.
Pound Sign
The Greater than
Symbol
All criteria needed to select the desired
data have been specified (i.e.* no further
prompts from any of the remaining groups
(or their sub-groups) are to be issued).
All criteria from the current group (or sub-
group) have been specified (i.e.. no further
prompts from the current group (or sub-group)
are to be issued). Prompting resumes with the
next logical group or sub-group.
Effective Date: 10/01/89
Release Number: 1.00
Pages H-
-------
The Caret Symbol All criteria from the current group (or sub-
CShift 6) group) have been specified (i.e., no further
prompts from the current group (or sub-group)
are to be issued). Prompting resumes with
the next logical group with all subsequent
sub-groups that belong to the current group
bypassed.
or The informational display in progress is to
be terminated immediately.
Cnnnn
For intermediate/advanced users only. Data
element number(s) may be entered in response
to any group or sub-group prompt to "direct1*
uhat prompts from that group or sub-group are
to be issued, and in uhat order.
In addition to that which has already been specified, user
responses may include (where appropriate) the following'
o Multiple data base values per line separated by a slash (e.g.,
V1 / V2 / V3) for data base value prompts. Multiple values
specified in this manner are always 'OR'ed together.
o Multiple data element numbers per line separated by a comma
(e.g., C1, C2, C3) for group and sub-group menu prompts.
Multiple data element numbers specified in this manner are
always 'AHD'ed together. (Intermediate/advanced users ONLY!)
Effective Date: 10/01/89
Release Number: 1.00
Page: H-13
-------
o The SYSTEM 2000 relational operators as a prefix to data base
value responses. These relational operators are as follows:
Operator
HE
GE
GT
LE
LT
SPANS
EXISTS
FAILS
Meaning
Equal (Default ... Does not need to be explicitly
entered as a data base value
prefix)
Not Equal
Greater than or Equal to
Greater than
Less than or Equal to
Less than
Value range ... SPANS V1*V2
The presence of any non-null value
The existence of a null value
During construction of the Locate statement, responses to prompts
from different groups and sub-groups are 'AND'ed together.
However, user responses to data base value prompts from the same
group (or sub-group) nay be 'AND'ed or 'OR'ed together at the
user's discretion.
As needed, normalization clauses are inserted into the Locate
statement constructed (i.e., ( C100 HAS ( ... ) ) when selection
criteria from disjoint data base records is specified.
After all user criteria have been specified, the Locate statement
is displayed on the user's terminal for verification.
Effective Date: 10/01/89
Release Number: 1.00
Pages 1-
-------
The user may execute the Locate statement constructed
interactively and choose the method of displaying the data
retrieved, OR the user may have the Locate statement checked for
syntax only and submit one or more fixed format reports.- In this
latter case, the 'data requested is not retrieved interactively.
Instead* the data requested is retrieved in a "Batch" mode prior
to the production of the subject report.
Two example on-line sessions are presented on the immediately
following pages. The first example session illustates the
"novice" user dialog and the second example session illustrates
the advanced or intermediate user dialog.
Note' The dialog utilized for an individual user (i.e., novice
or intermediate/advanced) is dependent upon a profile
established when the user is registered for FRDS-II/
Interactive access. Contact FRDS User Assistance if you
prefer the alternate dialog from that uhich you are
presently utilising.
Effective Date: 10/01/89 Release Number* 1.00 Page* 1-15
-------
* This exaeple assumes • novice level EPA Region III individual is using *
» ASSIST *
MHimi>ll II Mllllll
—> Enter Function Cod*. ENDi or MENU: A .
—> Do you went instructions on th« us* of thai Assisted (i.e., prompted)
Locate statement preparation function? (Y)es or (N)o:- Y
< 1
INSTRUCTIONS
INTENTIONALLY
OMITTED
<- -
2
ZA
—> Mould you like to print • copy of the Assist documentation?
CY)es or tNIo: N
—> Do you want to restrict your search to only those Public Mater Syst
that hev« on* or -ore violations? (Y)e» or (Hlo: 'N ...
—>' Do you want to restrict your search to Public Hater Systems that
are (Ourrent, ((Historical.* or'(B)oth: HELP
Public Hater Systems are either "Current" or "Historical".
Selecting "(Bloth" inplies that your query results MAY include Public
Nater Systems that are either current of historical PHS(s).
If you intend to restrict your search to a particular PHS Status Code
(a prompt for PHS Status Code appears later in this session), then
your response should be "I8)oth".
--> Do you M*nt to restrict your search to Public Hater System that
are (Ourrent. (H)istorica)., or (B)oth: B
e- - - 3
<- -
< 5
<- -
> Do you want to restrict your search for Violation. Enforcement, and/or
Variance/Exemption data to one or. more specific Federal Fiscal Years?
(Y)es or (N)o: N <-
— > Do you want to select data for ALL States within your EPA Region?
(Y)es or (N)o: Y
— > Do you want to restrict your search based upon Public Hater System
Inventory Characteristics? (Y)es or (N)o: Y
— > Do you want to restrict your search based upon Public Hater Systen
Inventory Classification «:K! Location data element values?
(Y)es or (N)o: Y
~ > Aax>ng the Public Hater Systeii Inventory Classification and Location
data elements, must ALL of your selection criteria be aet before
a PHS qualifies for retrieval? (YJes or (N)o: ?
Responses to data base value prompts, within this Sub-Sroup, will
be 'AND'edi or 'OR'ed, depending on your response.
A response of 'Y' will generate 'AND' conditions within this Sub-Group
<- - 8
<- -
10
< -- II
continued on next oaaa
Effective Date: 10/01/89
Release Number: 1.00
Page: 14-16
-------
A response of 'Nl nill generate '(IP1 conditions within this Sub-Sroup
—> Among the Public Hater Systea Inventory Classification and Location
data elements» must ALL of your selection criteria-be met before
a PHS qualifies for retrieval? (Y)es or (N)o: Y <- - 12
If you do not want to restrict your search based upon the value(s) of a given
data element for which a prompt in issued* simply press ...
—> C101 - (PHS) IDCs):
--> C102 - (PHS) Grant Eligibility Status Code(s):
—> C103 - (PHS) System Status Codels): CAC / NAC / PAC <-
~> CHI - I PHS) Datels) System became Operational (YYMM format)
: REVIEH <-
13
- 14
LOGATE(15) CIOO MH ( Cl £Q 03 ) AND
( ( NX C103 EQ CAC
NX C103 EQ MAC
NK C103 EQ PAC
OR
OR
--> Clll - (PUS) Oatelsl System becaM Operational (YYW1 format)
—> C113 - CPUS) Date(») SystM
Inactive (YYMT format)
—> C1IS - (PUS) Population Cate Cll? - (PWS) Retail Population!*) Served:
—> C119 - CPUS) Primary Source Type CodaCs): HELP <- -
PWS Primary Source Type Codes are: '
S - Surface P - Purchased Surface
6 - Ground VI - Purchased Ground
--> C119 - (PUS) Primary Source Type Codels): S <
—-> C121 - (PUS) Percentage!s) of mater obtained fro* Non-purchased Surface
Mater sources: > <- -
—> Oo you mnt to restrict your search based upon Public Water Systea
Inventory Other Address data element values? (Y)ea or Do you want to restrict your search based upon Public Uater System
Inventory Source/Entity data elenent values? (Y)es or (N)o: N <- -
—•> Oo you want to restrict your search based upon Public Hater System
Inventory Source Treatment data element values? (Y)es or (N)o: Y <- -
—> Among the Public Uater Systeii Inventory Source Treatment data
elements» oust ALL of your retrieval criteria be net before a PWS
qualifies for selection? (Y)es or (N)o: Y <
If you do not want to restrict your search based upon the value(s) of a given
data element for which a prompt ir> issued> simply press ...
—> C483 - tPHS-SE-TREAT) Objective CodeCs): ? ' <
Treatment Objective Codes
continued on next paoe|'
15
1ft
17
19
20
21
22
Effective Dates 10/01/89
Release Number: 1.00
Pages H-
-------
B
C
0
E
F
I
n
N
0
P
R
S
T
X
Y
Z
Disinfection By-products Control
Corros i on.Control
Disinfection
Dechlori nati on
Iron Removal
Inorganics Removal
Manganese Removal
No- Treatment at Source
Organics Removal
Particul*te Removal
Radionuclides Removal
Softening (Hardness Removal)
Taste / Odor Control
Not Treated
Treated
Other
(Converted FBDS 1.5)
(Converted FRD3 1.5)
C463 - (PWS-3E-TREAT) Objective Code(s): , X
C465 - (PH3-3E-THEAT) Pnocess Code(s): 000
Do you want to restrict your search based upon Public Hater System
Inventory Geographic Area-Served data element values?
(Y)*s or (Nlo: REVIEW
23
LOCATE(15) C100 HH ( Cl EQ 03 ), AND
( ( NK C103 EQ CAC
NK C103 EQ flAC
NK C103 EQ I'AC
( NK C119 EQ 3
AND C100 HAS C ( NK C463 EQ X
( NK C48S EQ (100
OR
OR
) AND
) )
) AND
Do you Kent to restrict your search based upon Public Hater System '.
Inventory Geographic Area Served data element values?
(Y)es or (Nlo: N <-
Do you want to restrict your search based upon Public Hater System
Inventory Service Area data element values?
IY)es or (N)o: N <-
Do you want to restrict your search based upon Public Hater System
Inventory On-site Visit dava element values? (Y)es or (N)o: N <-
Do you want to restrict your search based upon Public Hater System
Inventory History data eleiient values? (Y)es or (N)o: N <-
Do you want to restrict your search based upon Violation Characteristics?
(Y)es or (Nlo: N <-
Do you want to restrict your search based upon Enforcement
Characteristics? (Y)es or (N)o: N
continued on next oaoa
25
26
27
28
29
30
Effective Date: 10/01/89
Release Number1 1.00
Pages t»-ig
-------
—> Do you want to restrict your search based upon Variance/Exemption
Characteristics? (Y)es or ' Please con-firm ... Have you specified ALL criteria for the Locate
statement that you have be«m defining? (Y)es or (H)o: Y
LOCATE(15) C100 MH ( Cl EQ 03 > AND
( ( NX C103 EQ CAC
NK C103 EQ rUC
NX C103 EQ I'AC
( NX C119 Ed 3
AND C100 HAS ( ( NK C463 EQ" X
( NK C445 EQ 000
31
32
33
OR
OR
) AND
) )
) AND
) 1
—> Is the Locate stat
t displayed above correct? (Ties or (N)o: Y <-
ts this selection
—> Do'you want to interactively retrieve the data which
criteria? (Y)es or INJo: Y
34
35
• »»ll •»•»•• ••MM
***»
HHNHH
Searching ... Please do not interrupt
Search completion pending ...
Successful Locate ...
5.909 PHS(s) fotnd Batching your criteria
<- -
FROS/Znteractive
Post Retrieval Output Options Menu
(B) Batch Job Subiiission
(F) Frexiuency Distribution
(L) List in Standard Screen Format
(Q) QuicKlook Report Generator
(El End Post Retrieval
Enter tn* Code which corresponds to the desired Post Retrieval
Output Option:
37
continued on next oaqe
Effective Date: 10/01/89
Release Number: 1.00
Page
-------
1< . Assisted (Prompted) Function is selected off the Main M«nu
Z<~ - - User requests instructions on the 'A' function
2A<- - - (Instructions intentionally omitted her*)
3<_ _ _ User doe* not want documentation printed
4<- - - PHS does not have to hove any violations to be selected
5<- - - User requests oore information on Current vs.- Historical Inventory
6<- - - Both Current and Historical systems will be searched
7< ALL Fiscal Years are to be searched
8<- T - The entire EPA Region (all states) will be searched
9<_ - _ User requests only systems with specific inventory characteristics
10<- - - User wants prompts for both classification and location characteristic*
IK Help is requested
12<- - - User wants ALL of his/her selection criteria to be met
13<- - -' Only Active* Community systems are sought
14<_ - _ Request is made to review the Locate statement constructed thus far
15<~ - _ Explanation of Primary Source Type Codes is requested
16<- - - User then chooses to restrict search to Surface (S) Primary Sources
17<- - - »>•« symbol results in skipping the remaining classification and
location characteristics prompts
18<- - - User is not interested in "Other Address" data selection criteria
J9<- - - User does not wish to restrict search by any Source/Entity criteria
20<- - * User requests prompts on PUS Source Treatment characteristics
2K- - - Requests that ALL criteria be met
22<- - - Explanation of Treatment Objective Codes is requested
23<- User selects all Untreated Sources as converted from FROS 1.5
2<»<- - - Another review of the Locate statement created thus far
25<- - - User is not interested in searching Geographic Areas
26<- - - ther is not interested in searching Service Areas
27<- - . User is not interested in searching On Site Visit data
28<- - - User is not interested in searching Historical Records
29<~ - - User is not interested in searching Violation data
30<- - - User is not interested in searching Enforcement data
31<_ _ _ User signifies that he/she is finished identifying his/her selection
criteria
32<- - - Confirms the completion of the selection criteria
33<- - - Created Locate statement is automatically displayed
34<- - - User verifies that this is the retrieval he/she wishes to execute
35<- - - Requests that an interttictive retrieval of output is sought
36< Interactive FROS notifies user that 5.909 PHSs satisfied the selection
criteria
37<- - - User is automatically given the Post Retrieval Output Options Menu to
process the Locate filu created by the 'A* Function.
continued on next oaoe
Effective Date* 10/01/89
Release Number: 1.00
Page: tf-20
-------
* This example assumes an intermediate lev*! EPA Region III individual *
» is using ASSIST «
—> Enter Function Cod*, END. or HENU: A
—> Do you want instructions on the us* of the Assisted (i.e.. prompted)
Locate statement preparation function? (Ties or (N)o: N
—> Do you Hant to restrict your search to only those Public Water Systea
that have on* or more violations? (Y)e» or (N)o: Y
--> Do you Man't to restrict your search to Public Meter Syst«
are (C)urrent. (H)istorical, or (B)oth: C
that
1
2
3
4
—> Do you want to restrict your search for Violation, Enforcement, and/or
Variance/Exemption data to on* or more specific Federal Fiscal Years?
(Y)es or (H)o: Y
Acceptable fiscal years are two nioeric digits froM 00 to the present
—> C1I35, C1Z09, and/or C3023 - Federal Fiscal Year(s)?
: 6E 85 <- -
—> Do you want to select data for ALL States within your EPA Region?
IY)es or (H)o: N
Acceptable States are two charactnr FIPS State codes for States in your Region
—> C3 - For which specific Statn(s) do you want to select data?
: PA . <- - 6
—> Do you want to restrict your search based upon Public Hater System
Inventory Characteristics? (Y)es or (N)o: Y
— >
For which Public Water Systen Inventory Sub-group(s) do you want to
specify selection criteria?
C100 - Classification and Location Data Elements (PH3),
C300 - Other Address Data Elements
C400 - Source/Entity Data Elements
C460 - Source Treatment Data Elements
CSOO - Geographic Area Served Data Elements
C600 - Service Area Data Elements
C700 - On-site Visit Data Elements
- History Data Elements
C900
All,
or None:
(PUS-AD),
(PWS-SE),
(PWS-SE-TREAT),
(PMS-GA),
(PW5-SERV),
(PWS-VISIT),
(PHS-HIST1,
C100
< --
1_
continued on next paae
Effective DateJ 10/01/89
Release Number: 1.00
Page* 4-21
-------
—> C100 - For which PHS Inventory Classification and Location data elements
do you want to specify values that restrict your search?
C101 - (PUS) ID,
C102 - (PUS) Grant Eligibility Status Code,
C103 - (PHS) System Status Code,
C105 - (PHS) Plant Type Code,
C107 - (PHS) Activity Indicator Code,
Clll - (PUS) Data System) bucame Operational, *
C113 - (PUS) Date Systeai bucame Inactive,
C115 - (PUS) Population Category Code,
CI17 - (PHS) Retail Population Served,
C119 - (PHS) Primary Source Type Code,
C121 - (PUS) Pet. of Mater obtained from Non-purchased Surface'Sources,
C12J - (PUS) Pet. of Hater obtained fro* Non-purchased Ground Sources,
C125 - (PHS) Pet! of Hater obtained from Purchased Surface Sources,
C127 - (PUS) Pet. of water obtained from Purchased Ground Sources,
C129 - (PHS) Treatment Class Code,
C131 - (PHS) System Name,
C137 - (PUS) System City,
C139 - (PHS) System State Code,
(PHS) System ZIP Code,
(PUS) Retail Servictt Connections,
(PUS) Date on which Non-community Season Begins,
(PHS) Date on which Non-comounity Season Ends,
(PHS) Owner Type Code,
(PHS) Regulating Entity Code,
Cl Among the Public Hater Systen Inventory Classification and Location
data eleoents, oust ALL of your selection criteria be net before
a PHS qualifies for retrieval? (Ties or (Nlo: Y
--> C107 - (PHS) Activity Indicator Code(s): A
—> C105 - (PUS) Plant Type Code(s): HELP
PHS Plant Type Codes are:
C - Community Hater Systen
N - Noo-Coa-nuni ty Water Systen
P - Non-transient Non-Community Water System
9
1C
—> C105 - (PUS) Plant Type Cadets): C / P
—> C115 - (PUS) Population Category Code(s):
REVIEW
1!
12
LOCATE(15) C1100 UH
( C3
AND
( ( NK C109 HE
( NK C107 EQ
( NK C105 EQ
NK C105 EQ
( NK Cl EH 03 ) AND
EQ F'A
H
A
C
I1
AND
OR
AND
( NK C1135 6E
(15
) AND
) )
)
—> C11S - (PHS) Population Category Code(s): -
<- - 13
continued on next paae
Effective Dates 10/01/89
Release Number1 1.00
Page: H-22
-------
-> Please confirm ... Do you want to override the prompting order
that you previously specified? (Ties or (N)o: Y
-> Do you want to restrict your search based upon Violation Characteristics?
(Yles or (Nlo: Y <-
-> For which Violation Sub-group's) do you want to specify selection
criteria?
C1100 - Violation Specific Data Elements (VIO),
C1350 - Violation Profile Data Elements (VIO/NCP),
All.
or None: CllOO
•> CllOO - For which Violation Specific data elements do you want to
specify values that restrict your search?
CHOI - (VIO) ID,
C1103 - (VIO) Contaminant Coda,
(VIO) Type Code,
(VIO) Compliance Period Begin Date.
(VIO) Compliance Period End Date,
(VIO) Compliance Period Duration,
(VIO) Date on which State became Aware,
(VIO) MCL Analysis Method Code,
(VIO) RCL Analysis Result,
(VIO) RCL Violated, '
(VIO) RON Number of Samples Required,
(VIO) RON Number of Samples Taken,
(VIO) RON Major Vio. Designation Code,
<- - IS
C1105
CU07
C1109
Cllll
cms
C1121
C1123
C112S
C1127
C11Z9
C1131
C1137
All,
or None:
- (VIO) Data Origin Code,
C1103 , C1105
— > Among the Violation Specific data elements, must ALL of your- selection
criteria be net 'before a PUS qualifies for retrieval?
(Y)e* or (Nlo: Y
— > C1103 - (VIO) Contaminant Cocle(s): ?
The EPA Regulated Contaminant Codes ore:
16
17
Physical Contaminants
Inorganic Contaminants
Organic Contaminants
0100 Turbidity
1005 Arsenic
1010 Barium
1015 Cadmium
1020 Chromium
1025 Fluoride
1030 Lead
1035- Mercury
1040 Nitrate (as N)
1045 Seleniua
1050 Silver
2005 Endrin
2010 Lindane
2015 Flethoxychlor
2020 Toxaphene
continued on next oaae
Effective Dates 10/01/89
Release Number: 1.00
Page: H-23
-------
2105
2110
2950
2969
2976
2977
2960
. 2981
2962
2964
2990
Microbiological Contaminants 3000
Radiological Contaainants 4000
4010
4020
4030
4100
2, 4 - D
2, 4t S - TP Silvex
TTHn
p - Dichlorobenzene
Vinyl Chloride
1>1- Oichloroethyli
It Z - Dichloroethan*
It 1, 1 - Trichloroethane
Carbon Tetrachlorid*
Trichloroethylene
Benzene
Colifore
Gross Alpha, Including Ra-226 but
excluding Radon and Uranium
Co«bin«J Sa-226 i Ra-223
Radium - 226
Radium - 226
Gross B«ta Part id* Activity
For which Contaminant Croup Mould you like • detailed description?
1— (Inorganic Contaminant*it
2—- (Organic Contaminants),
4-— (Radiological Contaminants),
or None: NONE
—> C1103 - (VIO) Contaminant Code(s): 2950
—> C1105 - tVIO) Type Coda(a): LT 03 / 03 / 04
—> Do you want to restrict your search based upon Enforc
Characteristics? (T)es or (N)o: REVIEW
LOCATE!15) C1100 HH ( NK Cl EQ 03 ) AND
<- -
AND
AND
EQ
ME
EQ
EQ
EQ
( C3
( NK C109
NK C107
NK C105
NK C105
NK C1135 GE
NK C1103 EQ
NK C1105 LT
NK C1105 EQ
NK C1105 EQ
PA
K
A
C
P
65
1950
03
03
04
) AND
) AND
OR
) AND
) AND
OR
OR
Do you want to restrict your, search based upon Enforcement
Characteristics? I Ties or (N)o: Y
For which Enforcement Sub-group(s) do you want to specify selection
criteria?
C12CO - Enforcement Specific Data Elements (ENF),
C1350 - Enforcement ProfiIn Data Elements (ENF/NCP),
All,
or None: NONE
< 21
continued on next
Effective Date: 10/01/89
Release Number: 1.00
Pages H-
-------
»> Do you want to restrict your search based upon Variance/Exemption
Characteristics? (Y)es or (Nlo: Y
ition Suh-group(s) do .you want to specify
- zz
For which Variance/Ex
selection criteria?
C3000 - Veriance/Exoaption Specific Data El
C3100 - Variance/Exemption Schedule Data El
All,
or None: ALL
(VE),
(VE-SCXEO),
-->
C3000 - For which Variance/Exemption Specific data elements do you want
to specify values-that restrict your search?
C3001 - (VE) ID.
C3003 - (VE) Contaminant Code,
C3005 - (VE) Record Type Code,
C3007 - (VE) Effective Oatit,
C3009 - (VE) Expiration Date,
C3011 - (VE) Status Code,
C3013 - (VE) Modified HCL,
C3015 - (VE) Required Treatment Process Code,
C3017 - (VE) Alternative Treatment Process Code,
C30I9 - (VE) Reason Code,
C3025 - (VE) Data Origin Code,
All.
or None: NONE
•> C3100 - For which Variance/Exemption Schedule date elements do you want
to specify values that restrict your search?
C3103 - (VE-SCHEDJ Scheduled Action Code,
C3105 - (VE-SCHED) Date Action Scheduled,
C3107 - (VE-SCHED) Date Scheduled Action Completed,
All,
or None: NONE
—> Do you want to restrict your search based upon Data Base Administrator
Data Characteristics? (Y)es or (Nlo: N <-
25
26
LOCATEC15) C1100 UH ( NK Cl EQ 03 ) AND
AND
AND
C3 EQ
NK C109 NE
NK C107 EQ
NK C105 EH
NK CIOS EQ
NK C1135 GE
NK C1103 EQ
NK C1105 LT
NK C1105 EQ
NK C1105 EQ
PA
H
A
C
l»
as
^950
03
03
OR
OR
OR
AND
AND
AND
AND
—> Is the Locate statement displayed above correct? (Y)es or (N)o: Y <-
--> Do you want to interactively retrieve the data which meets this selection
criteria? (Y3es or (H)o: N <-
27
continuea on next
Effective Date: 10/01/89
'Release Number1 1.00
Page: 4-25
-------
Checking your Locate statement ...
Syntax check complete ...
Successful scan of your Locate statement ...
FROS-IZ Phase 1 Reports • •••miiiiiiiii
Reports It 3, 7, 19, 20, 2<», 31, 35, « 41 are available
mn>»n»N!i»» FR03-II Ph*j« 2 Reports
Reports 17. 18. 21, 22, 23, 32, i 36 are NOT available
— > Enter th« number of the desired Phase 1 report:
<- -
29
continued on next page
Effective Dates 10/01/89
Release Number: 1.00
Page: 4-26
-------
1<- - - 'A* (i.e.i the assisted) Function is selected off the Main Kenu.
2<- - - User does not want instructions on the 'A1 function displayed.
3<- - - • Only those systems with violations are to be considered for selection
IK NO "Historical" systems are to be included in th« search.
5< UM,. requests "actions" information frtm FY 65 through th* current FT
6<- - - Only Pennsylvania (PA) data is to be selected.
7< u,«r requests .prompts for PUS-SYSTEn-SUnTIAHY (C100) data elements.
8< User requests prompts for PUS-ACTIVE (C107), PUS-TYPE IC105) and
PHS-POPULATION-CATESORY (C115) values.
-------
«*.2.3 Function *Df - Re-Display of FRDS-II/Interactive
Broadcast or System Messages
The Main Menu offers the option of re-displaying all of the
FRDS-II/Interactive Broadcast and System Messages.
Selecting Function 'D* uill allow the user to revieu all of the
FRDS Il/Interactive Broadcast and. System Messages.
the sample session on the. next page shows how to use Functio.n
'D' .
Effective Date: 10/01/89 Release Number'- 1.00 Page: t*-28
-------
—> Enter Function Coda, EHD, or MENU: d
—> Mould you like to display (Blroadcast* (S)ystes» or (Nlaither
Messages: b
I
< 1
< 2
* FRQS/Interactive Broadcast Messages for FRDS-II follow ... *
'
SNCs eay be located in FROS-II by examining the C4050, DBA-DATA, data base
record for the following ...
yy = Federal Fiscal Year
C4051 equal to "SNC-yy-qq-nCL" or "SNC-yy-qq-nON" qq a Federal Fiscal Qtr.
C4053 equal to "0100" (Turbidity)
»1 », "1005", "1010", "1015", "1020", "1025", "1030",
"1035", "1040", "1045", "1050" (Inorganics)
"2005", "2010", "2015", "2020", "2105", "2110"(0rganics)
"2950" CTTHM)
"3000" (Baeti)
Press to continue ...
»* », "4000", "4002", "4010" (Rads)
C4055 equal to "oaddyy" Note: 0930yy appears on SNCs converted froai
FROS 1.5
Mhare: KM is the calendar nonth, dd is the calendar day, and yy is the
calendar year.
The FROS/Interactive Systea Messages for FRDS-II Mere last updated on ...
Sunday, February 5, 1969 at 6:00 •• EST.
» End of FRDS/Intaractiva Broadcast Messages for FRDS-IX »
Press to continua ...
I 1<- - - The user enters a "d" to re-display messages.
I Z<- - - The user re-displays broadcast messages.
Effective Dates 10/01/89
Release Number: 1.00
Page: 4-29
-------
—> Enter Function Coda, END, or MENU: d
—> Mould you like to display (B)roadcast, (S)ystem, or (NJeither
Messages: »
WHH
* F*DS/Interective System Messages for FR03-II follow ... »
Main Menu Functions which are presently available include:
0 End Session (QUIT and EM) are synonym* to 01
A Assisted (i.e.* prompted) Locate statement preparation
E Create Locate file from dataset containing PUS IDs
6 Geographic Help
P Go to the Post Retrieval Output Options Menu to re-process
selected/retrieved data
S Natural Language Interface (S2K Self Contained Facility)
X Non-proapted specification of Locate statement
Z Non-prompted specification of Locate statement for us* by Batch
Report Generating Program
— > Continue nith the next page of Messages? (Y)es or (N)o: y
Post Retrieval Output Options which are presently available include:
B Batch job submission of Standard format (i.e., FRDS) report
( Reports 01, 03. 07, 19, 20, 24, 31, 35, I 41 are available 1
F Frequency distribution of values for a data element
L List in Standard Screen Format
4 Quicklook Report Generator ( minus its PUS Ranking Feature )
E End Post Retrieval Processing
End of FROS/Interactive System Messages for FRDS-II
•*•*«****»»«*
Press to continue ...
1
1 1<- - - The user enters a "d" to re-display messages.
1 2<- - - The user re-displays system messages.
1
1
1
I
i
Effective Date: 10/01/89
Release Number: 1.00
Pages t»-
-------
"4.2.U function 'E1 - Retrieve PWSs Whose IDs aze in an External
File
The Main Menu offers the option of retrieving Public Water
Systems uhose PUS IDs are contained in an external file.
Selecting Function 'E' allows you to access the PUS ID Retrieval
Menu. This function enables the user to retrieve PWSs by using
a previously created file containing PUS IDs for selection.
The sample session on the next'page shous hou to use Function
'E'.
Effective Date: 10/01/89 Release Number: 1.00 Page: 4-31
-------
--> Enter Function Code* END, or MENU: e -•
Enter the fully qualified data set name .of the fill containing PM3 IDs,
then press
—> Data set naoe: Ivefrds.ninebyte
Locating PWSs in Data Base - On* BOMant pleas* ...
Successful Locate ...
PUS ID file naoe processed: LVEFRD3.NINEBYTE
<- - -
PH3 IDs in file processed:
PMSs located in Data Base:
Press to continue ...
15
15
<
FRDS-II/Intoractive
Post Retrieval Output Options Menu
(B) Batch Job Subeiasion
(F) Frequency Distribution
(L) List in Standard Screen Forest
(Q) Quicklook Report Generator
tC) End Post Retrieval
-> Enter the Code which corresponds to the desired Post Retrieval
Output Option:
1< The user selected Function "E" to retrieve PMSs whos IDs are in an
external file.
2<- - - The user keys in the fully qualified data set name.
3<- - - The aystea responds wi th the number of PHSs successfully located.
4<- - - The user may select any Post-processing option.
Effective Dates 10/01/89
Release Number: 1.00
Pages «»-32
-------
1.2.5 Function 'G' - Obtain Geographic Information for a
Specified City or County.
The Main Menu offers the option of obtaining geographic
information for a specified City or County. •
Selecting Function 'G* allows access to the Geographic Help
Function Menu. The user may then enter the City or County,
along with the State abbreviation, for which geographic
information is desired.
The sample session on the next page shows how to use Function
•G*.
Effective Date: 10/01/89 Release Number= 1.00 Page: 1+-33
-------
—> Enter Function Code> ENDr or HENU: g
You have invoked the Geographic Help function
You will b« asked to enter the naoe of a City or County .
and the State abbreviation of the area(s) for t4tich you
desire geographic information.
—> Do you want Geographic information? CYles or (NJo: y
~> Enter City Na«e or press to enter a County: Carlisle
—> State abbreviation: pa
CARLISLE
City
State County MSA Hydro-ID Lat. Long.
PA 0*1 3240 02050305 04012 07711
—> Mould you like more Geographic information? [Y)es or (NJo:
1<- - - Function "6" is selected to obtain geographic date.
2<- - - The user has the option of continuing the geographic help function by
entering a "y"» or returning to the function proopt by entering
an "n".
3<- - - The city for teSich geographic help is desired* is entered.
4<- - - The State for twitch geographic help is desiredi is entered.
5<- - - The systea displays geographic data for the city and State requested.
6<- - - The user has the option of continuing the Geographic Help function
or returning to the function proapt.
Effective Date: 10/01/89
Release Number: 1.00
Page: H-
-------
f.2.6 Function 'P' - Post-retrieval Processing Options
The Main Menu offers the post-retrieval processing options
selection. The post-retrieval processing options selection
allows you to access the Post-retrieval Processing Options Menu
using previously selected data without regenerating a query or
reselecting the data.
Selecting Function 'Pr allows you to access the Post-retrieval
Processing Options Menu using data already selected by a
previous data selection criteria statement in Function 'A', '£',
•Xf, or '2* of the Main Menu.
For further details on the Post-retrieval Processing Options
Menu refer to Section 5.
Effective Date: 10/01/89 Release Number: 1.00 Page: 4-35
-------
<».2.7 Function *S' - Enter the System 2000 Self-contained
Facility (NATURAL LANGUAGE)
The Main Menu offers the S2K self-contained facility selection
allowing you to formulate queries and generate variable format
ad hoc reports of selected data from the FRDS-II data base. You
interactively create a set of S2K commands to select the desired
data and format a report. These commands may come either from a
command file or your terminal. They may either be executed in
an interactive session or be accumulated in the data area and
submitted as off-line batch job(s).
To generate reports uith S2K commands* you respond to system
prompts in allocating data set(s) for the report(s). You can
submit off-line batch job(s) to print any combination of the
report data groups.
The sample session on the next page shows hou to use Function
"S" .
Effective Date: 10/01/89 Release Number: 1.00 Page: 4-36
-------
—> Enter Function Code, END, or MENU: s
—> Do you have any Command files that you Mtsh to use? n
--> DO you have any Report files that you wish to create? y
After these REPORT FILES have been printed,
Oo you want to keep the* on the computer? Enter Y/N: n
—> Do you expect this report to be (SJshort, ttDmedim, or (L)long* s
—> Do you have any more? Enter Y/N: n
The following Report files are allocated to this session:
Reference name Data set naae
REPORT01 wwwyyyy.M1023«9.T175747.REPORT01
* When you wish to create an off-line Report, specify the following
command in response to the Syste* 2000 prompt " ":
REPORT FILE IS REPORTxx:
where "xx" is the Reference Name number of the Report file
that you wish to create, when you have finished creating a
specific report file, enter the following romainri;
REPORT FILE IS OUTPUT:
—> Oo you want to produce a Batch Job? Enter Y/N/!: n
—> Do you want an INTERACTIVE NATURAL LANGUASE SESSION? ENTER Y/N: y
10/23/69 17:59:17 BEGIN SYSTEM 2000 - RELEASE 11.5
COPYRIGHT CC1 1965 SAS INSTITUTE INC., CARY, N.C. 27511, U.S.A. -
<-
<-
<_ _ _
I
I
*
5
USER, EPA:
ECHO OFF:
-556- OPENED FRDSII
COMMAND FILE IS SYSIN:
limit 0,10/truncate:
LIMIT 0,10/TRUNCATE:
10/14/1969 04:01:08
continues on next page
Effective Date: 10/01/89
Release Number: 1.00
Page: 4-37
-------
continued fron previous page
list c3, clOlt ob clOl Nh
-------
continued frost previous page
report file is output:
REPORT FIUE IS OUTPUT:
writ:
IX1T:
18:25:21 10/23/69 EKD SYSTEM 2000 - RELEASE 11.5
COPYRIGHT (C) 1965 SAS INSTITUTE INC., CAST, N.C. 27511. U.S.A. -
--> Do you M«»h to print »ny REPORT Files? Enter Y/N: y <«
—> Enter the lut 2 digits of tlw REPORT File that you wish to print: 01 <-
—> Please enter your 4-digit BOX •: dddd
—> Please enter your 9-digit ACCOUHT t: yyyy
9
10
11
—> Please enter your 3-digit REMOTE Printer ff or NODE: mn
—> Please enter a 1-digit PRIORITY code: 2
—> Please enter nueber of COPIES to be eade of this report: I
Do you expect this report to be Short, Mediuet Long, or X-long?
--> Enter S, M, L. or X, OR ? (Default is S): s
Check the following information:
BOX dddd
ACCOUNT yyyy-
REMOTE 114
PRIORITY 2
COPIES 1
TIME S
IS THIS INFORMATION CORRECT?
JOB 3859 SUBMITTED
12
13
Effective Date-* 10/01/89
Release Number: 1.00
Page:
-------
continued front previous page
1< The us«r selects the "3" Function for S2K Natural Language.
2<- - - The user has no existing command file.
3<- - - The user MI she* to create) a new report file.
4<- - - The user does not *ish to »ave the report file.
S<- - - Based upon selection criteria! the user expects the report to be
wall. • . ' .
6<- - - The user does not- wish to allocate additional report files.
7<- - - System message to shoM the data set name of the allocated report file.
fl<- - -. The user selects • Natural Language session.
9<- - - The user wishes to print the report file.
10<- - - The user enters the number of the report file to be printed.
IK- - - The user enters requested destination information.
12<- - - The user is given an opportunity to change or correct the destination
information.
13<- - _ System eessage indicating the job number submitted. Users should note
the job nuober for future reference.
Effective Date* 10/01/89
Release Number: 1.00
Pages I»-
-------
4.2.8 User-defined Query
User-defined query allows you to enter your own formulated data
selection criteria statement. The system then offers you an
opportunity to submit the statement as a query to the data base
or formulate and enter a neu statement. When you submit a query,
the system cheeks the formulated data selection criteria
statement for proper syntax before performing data retrieval.
It is important to note that the user can access any data.in.
FRDS-II that has been reported to U.S. EPA» for the prior 8-year
period. If users wish to restrict a search on violations oz
PUS's uith violations to a specific fiscal year* neu data
elements have been provided in FRDS-II to accomplish this.
It is also important to note that data element numbers used in
FRDS-II may refer to a different set of data than in FRDS 1.5.
There are two user-defined query retrieval selections. A
discussion of each selection follows.
•1.2.8.1 Function 'X* - Formulate Non-prompted Retrieval
Selection Clauses
The Main Menu offers a non-prompted user-defined S2K locate
statement facility allowing you to perform up to 11 unrelated
searches. The results of each search are stored in locate data
storage data areas consisting of up to 11 separate data files
numbered from 0 through 10. These files are retained until the
Effective Date: 10/01/89 Release Number: 1.00 Page: 4-
-------
end of the FRDS-Il/lnteractive session* unless overwritten by the
execution of another locate statement. After you have selected
PWSs using' Function 'X', you can use one of the created locate
data files for further output processing. Hot specifying a
locate file has the same effect as specifying locate file 0.
The sample session on the next page shows how to use Function
*X' .
4.2.8.2 Function *Zf - Formulate Non-prompted Retrieval
Selection Clauses f
The Main Menu offers a non-prompted user-defined facility to
generate standard batch jobs routed to a remote high-speed
printer. It produces one or more standard reports from your
data selection criteria.
This differs from Function 'X1 in that Function 'Z' does not
retrieve data from the data base while on-line, but instead, at
the time of batch job execution. It does not scan the data base
immediately, but simply checks the formulated data selection
criteria statement for proper syntax before asking if the query
is to be submitted for batch processing.
Function 'Z1 is a non-prompted S2K locate statement facility
allowing you to perform up to 11 unrelated searches. The
results of each search are stored in locate data storage data
areas, consisting of up to 11 separate data files numbered from 0
through 10. These files are retained until the end of the
Effective Date: 10/01/89 Release Number: 1.00 Page: H-t
-------
—> En-tar Function Cod*, END, or MENU: x
Enter your S2K Locate command on the following lines:
NOTE: You My enter multiple Locates using Locate Files 0 to 10.
E*ch Locate command can be fro* 1 to 20 lines of'not nore
than 70 characters per line.
Your completed command MUST end with a COLON.
Te re-enter a Locate command fro* the beginning* press
the or key.
When finished, enter the keyword EXIT and press
—> locate clOO wh (c3 eq ps) and (cll03 eq 2950) and (Y)es or CN)o: y
Searching ... Please do net interrupt
Search completion pending ...
<
mmim»»
Successful Locate ...
99 PWSCs) found Batching your criteria
Enter your S2K Locate.command on the following lines:
—> exi t
Record selection complete ...
Do you wish to use one of your previously established LOCATE's
--> Enter (Y)es, (N)o, ?, or Locate File •: 0
FROS-II/Interect i ve
Post Retrieval Output Options Henu
(B)
(Ft
2
3
4
5
Batch Job Submission
Frequency Distribution
CD
List in Standard Screen Format
QuicKlooK Report Generator
(E) End Post Retrieval
Enter the Code which corresponds to the desired Post Retrieval
Output Option:
<
1<- - - The user has selected Function "x" to formulate a non-prompted locate
command. A colon must follow the locate statement to notify FRDS/
Interactive that query formulation is complete.
2<- - - The user formulates a locate command.
3<- - - The user enters a "y" to indicate that the locate command is correct.
4<- - - The system verifies that the data is available and gives totals.
5<- - - Additional locate statements may be formulated. Entering "exit"
terminates the query.
6<- - - The user nay choose a Post-retrieval processing option.
Effective Date: 10/01/89
Release Number: 1.00
Pages «*-«
-------
FRDS-II/lnteractive session, unless overwritten by the execution
of another locate, statement. After you have selected PWSs using
Function *Z', you can use one of the created locate data files
for further output processing."
The sample session on the next page shows hou to use Function
Effective Date: 10/01/89 Release Number: 1.00 Page
-------
—> Enter Function Coda. END* or MENU: z * <- - - 1
Enter your S2K Locate command on the following lines:
NOTE: You nay enter multiple Locates using Locate Files 0 to 10.
Each Locate command can be from I to 20 lines of not more
than 70 character* per line.
Your completed coaaand MUST end with e COLON.
To re-enter a Locate command from the beginning* press
the or key.
Wwn finished, enter the keyword EXIT and press
—> locate clQO wh (c3 eq pa) and (ell03 «q 2950) and (nk e!03 eq cae): <- - - 2
Is this the Locate statement that you want to process?
LOCATE C100 MH IC3 EQ PA) AND IC1103 EQ 2950) AND (NK C103 EQ CAC):
—> »«imiii»
Successful scan of your Locate statement ...
Enter your S2K Locate command on the following lines:
—> exit
Record selection eonplete ...
Do you wish to use one of your previously established LOCATE'!
--> Enter m«s, (N)o» ?, or Locate File •: 0
»»»imm»»ini FROS-IZ Phase 1 Reports **»**»»»**
Reports 1. 3, 7. 19, 20. 24. 31. 35, * 41 ere available
»*««»»»»*» FRDS-IZ Phase 2 Reports
Reports 17, 16, 21. 22, 23, 32. • 36 are NOT available
—> Enter the number of the desired PROS report:
<- - - S
j<_ _ _ The user selects Function "z" to formilate a non-prtxspted locate
command.
2<- - - The user formulates a locate eodniand.
3<_ - _ th« locate command as formulated is acceptable and the user wishes to
continue.
4< Additional locate commands may be formulated. Entering "exit
terminates the query.
5<- - - The user may choose a standard batch report.
Effective Date' 10x01/89
Release Number: 1.00
Page
-------
-------
SECTIOK 5
USIMG THE POST-RETRIEVAL PROCESSING OPTIOKS MENU
Effective Date: 10/01/89 Release Number* 1.00 Page: 5-1
-------
SECTION 5 - USING THE POST-RETRIEVAL PROCESSING OPTIONS MENU
5.1 DESCRIPTION OF THE POST-RETRIEVAL PROCESSING OPTIONS MENU
After data has been selected and successfully retrieved the
system displays the Post-retrieval Processing Options Menu.
Selections determine uays to process and report data.
The sample session on the next page shows hou to use the
Post-retrieval Processing Options Menu.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-2
-------
FRDS-II/Interacttve
Post Retrieval Output Options Menu
(Bl Batch Job Submission
(F) Frequency Distribution
CD List in Standard Screen Format
Enter the Code titich correspond* to the desired Post Retrieval
Output Option:
| 1<- - - The user onters a selection from the Post-Retrival Processing Options I
I Menu hare. I
Effective Date'- 10/01/89
Release Number: 1.00
Page: 5-3
-------
5.2 POST-RETRIEVAL PROCESSING OPTIONS MENU SELECTIONS AND REPO!
EXAMPLES
The chart on the next page summarizes the unique features of
each Post-retrieval Processing Options Menu selection.
A discussion of each Post-retrieval Processing. Options Menu
selection follows. A sample session and a report example are
featured for each selection.
Effective Date' 10/01/89 Release Number: 1 .,00 Page: 5-1
-------
Selection
Option 'A'
Option 'B'
Tit], a
Features
Option 'C'
»
Option *Ff
Option 'G
Option 'I
Aggregate Violations Hot Available
Batch Job Submission
Provides information
relating to PUS
inventory* enforcement
actions, violations, and
variances and exemptions
in detailed and summary
listing formats
Create a File for SAS Hot Available
Frequency Distribution
Graphs or Haps
Invoke IDRS/CERCLIS
Provides a frequency
distribution table of
unique code value
occurrences for a
specified data element
based upon the currently
selected PWSCs)
Not Available
Hot Available
Option 'K' Kounts or Sums of PWS Not Available
Elements
(continues on next page)
Effective Date: 10/01/89
Release Number* 1.00
Page' 5-5
-------
Selection
Option 'L'
Title
Features
Option 'fT
List in Standard Screen Provides information
Format . relating to inventory,
source, violationsf
variance and exemptions.
and enforcements, in
detailed listing format.
nap of PUS by State.
Region, or U.S.
Hot Available
Option '2'
Option 'Tf
Cuicklook Report
Generator
Totals of PUS
Information
Permits the user to
design and print a report
according to his/her oun
specifications
Not Available
Option 'E'
End Post Retrieval.
Terminates Post retrieval
processing and returns
user to Main menu
function selection.
Effective Date: 10/01x89
Release Number: 1.00
Page: 5-6
-------
5.2.1 Option 'A* - Aggregate Violations - Aggregate Violations
Report (Not Available)
Effective Dates 10/01/89 Release Number' 1.00 Page: 5-7
-------
5.2.2 Option 'B' - Batch Job Submission
Option 'B1 of the Post-retrieval Processing Options Menu
generates various standard batch reports. These reports are
printed on an off-line, high-speed printer.
The standard batch reports are Preformatted using, preformulated
calculations to report information from the retrieval. The user
must specify certain job. parameters including printer
distribution information (room number or box number), account
number, routing site, job priority, number of report, copies to
be printed, and job execution time/size. The user may also
select a predefined sort order for the reports, if desired.
Each standard batch report begins uith data selection criteria
information, the sort order of PWSs if applicable, and the total
number of PWSs reported on. FRDS01, FRDS03, FRDS24, and FRDS3S
are detailed reports. FRDS07, FRDS19, FROS20, FRDS31, FRDS41B,
and FRDS41D are summary reports.
Detailed standard batch reports and summary standard batch
reports are depicted in the chart beginning on the next page.
The sample session that follows shows hou to use Option 'B'.
Report examples of the standard batch reports available through
Option 'B' are provided in Sections 5.2.2.1 - 5.2.2.17.
Effective Date: 10/01/89 Release Numbers 1.00 Page? 5-8
-------
^ Title Detailed Summary PUS
ber PUS Inventory
Inventory and Action
01 Public Water System Comprehensive X
02 (For future use)
03 Public Uater System Service Area X
and Source Area
OH (For future use)
05 (For future use)
06 (For future use)
07 Facilities and Population Served X
by Primary Uater Supply Source
08 (For future use)
09 (For future use)
10 (For future use)
11 (For future use)
12 (For future use)
13 (For future use)
14 (For future use)
15 (For future use)
16 (For future use)
17 Enforcement Actions Summary by
Population (M/A) X
18 Enforcement Actions Summary by
Type and Primary Water Supply
Source (N/A) . X
19 Violation Summary by Population X
Effective Date: 10/01/89 Release Numbers 1.00 Page: 5-9
-------
Hum- Title
her
Detailed
PUS
Inventory
Summary PUS
Inventory
and Action
20 Violation Summary by Primary
Mater Supply Source
21 Variance and Exemption Summary
by Population (N/A)
22 Variance and Exemption Summary
by Primary Water Supply Source (N/A)
23 (For future use)
24 Public Mater Supply System
Summary and Violation Data X
25 (For future use)
26 (For future use)
27 (For future use)
28 (For future use)
29 (For future use)
30 (For future use)
31 PMS's Months in Violation
32 (For future use)
33 (For future use)
34 (For future use)
35 Annual Data Evaluation
36 Informal Enforcement Actions (M/A)
37 Multiple Year Violations (N/A)
38 (H/A)
41 Significant Kon-Compliers
X
X
X
X
(N/A) = Not Available
Effective Date: 10/01/89"
Release Number •• 1.00
Pages 5-1
-------
FROS-II/Interactive
Post Retrieval Output Options Menu
Batch Job Submission
(Fl Frequency Distribution
(L) List in Standard Screen Format
«J1 Quicklook Report Generator
(E) End Post Retrieval
--> Enter the Code nhich corresponds to the desired Post Retrieval
Output Option: b
<- . -
IHHHHHHHHM* FRDS-II Phase 1 Reports
Reports 1, 3i 7, 19, 20, 24. 31, 35, * 41 are available
FRQS-II Phase 2 Reports
»»***»*»*»
Reports 17, IS, 21 , 22, 23, 32, ft 36 are NOT available
— > Enter the number of the desired FROS report: 3
--> Do you wish to add an additional identifying title line to your
FRDS03 report? (Y)es or (N)o: n
--> Do you uant to sort the report data? (Y]es or (N)o: y
— > Sort on EPA region? (Y)es or (Nlo: n
«-> Sort on State? (T)es or (K)o: n
Select one of the following *iner sort sequences:
0 - None
1 = PWS ID
2 = PHS Type, PUS 10
3 = Retail Population Served (descending sequence), PHS ID
4 - Primary Source, PHS 10
5 = Systea City Nane, PHS ID
6 = Systea Name. PHS ID
7 - System ZIP Code, PHS 10
— > Minor mort sequence number: 1
Your current Job parameters are:
FIHAS 10: xxxxx
Destination: RMTrmn
Bin/Box: dddd
Estimated Time: Short
Priority: 2
Printer Type: Destination
Copies of Report: 01
— > Are these parameters correct? (Yles or (N)o? y
Job 7414 Submitted ...
< ---
<-
<-
3
4
<- - -
<- - -
continues on- next page
Effective Date: 10/01/89
Release Number: 1.00
Page: 5-11
-------
continued Iron previous page
1< _ Option "b" frow the Post-Retrieval Processing Menu is chosen,
2<_ . _ Standard report 3 is chosen. The report numbers may be entered
without leading zeros.
3<- An "n" is entered for no additional title lines. A "y" would give
give the user the-opportunity to enter an additional title.
t*<- - -. The user requests that a sort be perforaed.
5<_ _ _ A sort on PW3 ID is chosen.
6<- - - The user verifies: that the report routing information is correct.
Effective Date: 10/01/89
Release Number: 1.00
Page: S-12
-------
5.2.2.1 FRDS01 - Public Water System Comprehensive Report
FRDS01 is 'a summary report of the comprehensive PUS inventory.
FRDS01 begins with information on the report selection criteria,
or the details of the logical criteria, used in selecting the
PWSs in the report and the total number of PWSs reported on.
In addition to the report selection criteria information, FRDS01
contains a body composed of a varying number of pages containing
the specified information on the selected PWSs.
A report example follows on the next page.
Effective Date: 10/01/89 Release Number' 1.00 Pages 5-13
-------
Effective Date: 10/01/89
Release number"- 1.00
Pages 5-14
-------
5.2.2.2 FRDS03 - Public Uater System Service Area and
Source Area Report
FRDS03 is a detailed report of PUS plant location, service area,
and sources data.
FRDS03 begins with information on the report selection criteria,
or the details of the logical criteria* used in selecting the
PUSs in the report and the total number of PUSs reported on.
In addition to the report selection criteria information, FRDS03
contains a body composed of a varying number of pages containing
the specified information on the selected PUSs. FRDS03 also
contains a summary page as the last page of the report.
A report example follows on.the next page.
Effective Date-' 10/01/89 Release Number: 1.00 Pages 5-15
-------
V)
t* a
o a.
"I
Ul
e»-
°£
ss
Sol
U> Ul
DC w»
-a i
S r
Ul Ul
a t-
Ul M
u. >•>
»
i
0)
§
w>
•oo
o in
u»
«o
U) Ul
111 Ul
a: •>
u oo
2ui
M
s
s
«S*
32"
M
> I
2 ^
in K
§
Ul (A
t- u>
tfl 111
"I
h- in
l-l < M —
O > «M
U. «J
in u. —
u 3 z
3 u 3t u»
< K o
ae ac >• a-
S u. i ~
a u. 3 •<
-1 O K Q.
a
0
Effective Date: 10/01/89
Release Humbez: 1.00
Page: S-16
-------
5.2.2.3 - FRDS07 - Facilities and Population Served by
. Primary Water Supply Source
FRDS07 is a detailed report of facilities and populations
served by PUS sources.
FRDS07 begins with information on the report selection
criteria, or the details of .the logical criteria, used in
selecting the PUSs in the report and the total number of PUSs
reported on.
In addition to the report selection criteria information*
FRDS07 contains a body composed of a varying number of pages
containing the specified information on the selected PUSs.
FRDS07 also contains a summary page as the last page of the
report.
A report example follows on the next page.
Effective Date« 10/01/89 Release Numbers 1.00 Page' 5-17
-------
ui
(9
22
3 £
•—
o in
tn
«-• M
ii
u» ae
(9 EX
Z iu
11 W>
i§
n. ^4
u ^
BC <
K O
tu a.
o
in
x
S
tn
o 3
— o.
o
IAI OC «A
S a -
il S
o o o o
0 0
O O 0 O O O
in o • -< -a -f •*
«M • !"• • O •
f* «i m -a IA o
in
•
IS.
•f IA
•
o
»« •
•a
O
U
&
8
Effective Date' tO/01/89
Release Number: 1.00
Page-' 5-18
-------
5.2.2.4 FRDS17 - Enforcement Actions Summary by Population
CNot Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-19
-------
5.2.2.5 FRDS18 - Enforcement Actions Summary by Type and
Primary Water Supply Source (Not
Available)
Effective Dates 10/01/89 Release Number: 1.00 Pages 5-20
-------
5.2.2.6 FRDS19 - Violation Summary by Population
FRDS19 is 'a summary zepozt separately calculating the number
of violations by population category» and the number of
systems in violation by population category> for FRDS19A and
7RDS19B, respectively.
FRDS19 begins with information on the report selection
criteria* or the details of the logical criteria used in
selecting the PWSs in the report and the total number of PWSs
reported on.
In addition to the report selection criteria information,
FRDS19 contains a body composed of a varying number of pages
containing the specified information on the selected PWSs.
Two 19A and 19B reports follow, beginning on the next page.
The first example shows summaries for all years, for the
State of Pennsylvania, while the second example shows
summaries for FY 1987 only.
Effective Date: 10/01/89 Release Number: 1.00 Page-- 5-21
-------
UJ
(9
o a
a. H
u> t-
•3
3S
ae >
IU
o
o o
e -
€t « •
IB in i^
M •* M
>-
2 — a
a o
00-
M mm
^
K» o a
> in »•»
•» « *
O
I-
u
N.
X
>
IU >. «
-j f • c a. e
a. •- TJ v w ^ «.
KTJ— CCCX r O
«i.- «. « .- it a.v\ <+•
-* at . c
'M 5 < -2
CO.8 ^6 Q. *• E 0> ~ E O C
WWI-l -I.. L. E—U 63*0 >, « 3 «>4I
CCXrO UjO O <-8— 63 — — Cf— <- C C X i
•Dcx-y-4 K- IUL.E>? »— cri-iAT'OL3rei_»'«-H'ac-»'5(vr
C -^ O - O O O3.CO O <3t«"»£»4«l«l— 41 ••-£•.• «O«
UJ«Jh»CMU ^ «tHK(J' ^ ^^^OQLIOU^-^ ZI'Z « «rt tu J £ *" <^
05 3
Sul {Q c!>
> 3 UJ
ui < in a
•A >•• w w *^ r» ^ HI ^~
in j o > u T3 « - —
U3^-OCX*-4
uu 3 -H — C •- O - O
Effective Date' 10/01/89
Release Number: 1.00
Page: 5-22
-------
tu
I
IA
M
O
O
ae o
> o
a o
O OiA
IA 1^
§,
M " O
k- O O
< O O
-» - -
S2S
2
I O
V -» O
3— O
O O
O I* O
M - -
> Kl IA
in i*
>- (M tn
in
u. a a
o o u>
ift M •*
-i
o
o
in
U
u
M
5
i
u
tu
— T3
TJ — I-
.- 1. 41
ja o >
L. 3 ^
3 -H —•
t- U. V»
• c a.
m v t-
C C X I
— a a.tt\
(. TJ » -
TJ C X L T3 X »
*i *N
-------
IM
J
o
UJ
13 O
< 0
a. ce o
> 0
Oo
1 O
— 0
o o
• o
IA O
JL»-
>• o o
§0 IA
IA r»
5-Lo
U 0 0
0 0
O 0 0
•-» -4 in
3*"
1 0
£00
O 0 -
a. • o
M IA -»
M • >•
in «• o
a 2 22°
at o 2 to o
Ik M O - •
I- M Kt IA
'3 5
S3 -1 *
5. o -« o
h* rt M O O
Mb > IA m
>• • -
m >- u. • OC 1
o 5 moo
£ C O IA
M in
t-
§z
3 * o
M — O
Utt- 00
OC «t IA -
35
2* EH .
Q 1 Ol « O
Ul I U I O O
u. L__l — IA
•• OE
Ul
o a
• 2§
^
>^
u
<
c
IH
IX
Q.
• • • r^*^
1 o i 1 o I ^£
JS[ j_o[ 3
^4 wJ lij
ix >> a.
11 IA >-
2 H-
Z Z
O Ul Z
O >-« Q. O
a < cs w
\ O- UJ •• •—
O •« K 1U <
o in h- — '
X 0 •< < O
— (X Q. 1- w
— u. u >
OKI — «»>«-"«OK»'*"*»»«««*O
S » "" !O>»P*»MIA-»«>I
J- M IA
*^ ^
01
S*1 ""
^.
r» IA «• •* •* it •• *> •* 9
o •* •«
Ol
O>(MCaN«INM«tCllnlir
0 01 N IA
rt 5 41 0 C -1
x x o -» » u e
N « «Z »• L. .c ~< X 3
c*Q> ui--
«i — o o — n j: -T3
^OLUUXI-^ " "
O O O O 0 f « X(K
> (. -i -i -. — «i o ^a^
j.r ^5"g-g.i:H o « ^3^
U "O X •- .- 1 C -H C O C
E .- O-HQO-^OJlCJH-tfl.-
JQ .- >, i i - JQ g N — m J3
UJUEQC-HCg-»l-.— C-^O6
K
Ul
>
<
m
•o
•o
01
01
^^^^mm..lm
ti
ae c
Ul
s Is
in 01
in
Effective Date: 10/01/89
Release Mumber: 1.00
Page' S-2«t
-------
M
Ul
<9
CL '
M O
K M
I ^
iff <
O *J
22
,£
e >•
Ul 0>
H-
in >•
>• ec
*" 3
< 2
5!
S*
M »—
^•k <4(
St*
IX M
U >
*z
••I >w*
«
O! <2
«u C """"'I
o ut in
(Ml- 0
M. 01 U
>» I 1
W |^
^
**>
V
3
XI
M
cr
i — r n
1 ** 1 i r^
1 O 1 o
lul | u|
\ <
1 **
\ z
« >
H _l
*-H >•
H «
si
<7- IH CL
"V ^ UJ »»
0 -< EC Ul
O I/J h^
X O f <
— cc a. t-
-4 U. Ul Ul
^
!••»
a
o
'a: o
> e
O o
•«
1 0
•* o
o o
o -
* o
gS2
O 1
MOO
^ o o
^ » ^
"SS
t — o
^ o o
< o o
^ • •
20 o
— i m
i
1 O
n o o
§» o
in -«
h* 1
•* — 0
O it o
> win
z
M 1
-i O
moo
rm m
lu • ••
1- IM fl
M
>•
(O F
«• O
u. o o
O 0 M
K •• i CMr^*^if^*4«^Al"H*i."D^<» - —
l.L-DJ-3i»t.«-»«— «l— C--HPO -O
-'^-COUUK.-JCZI/IMIUWC^NU
z
in
vt *o^ft0i^i > a « o c -<
• ££.&*** OB
fKe*-»-ujc— X3
STJ O W O U >. UJ —
— o o -H d j; -TJ
Jl L i. L j: i. *- an
o o o o o *• « -c a:
>> i. ->-•-<.- «i o a.
«• «j;^j:t.>-«. s^-o
_i <- -H u u u (- oet-,ii-j3uN'-in^
>- UJI-EQC-<- >_ a >• — — — u t-
m <
K
l«»
Ift
01
S
r 5
M S
si
4 O M
«M U Z
r»
««
P^
eg
•o
••«
h»
-------
5.2.2.7 FRDS20 - Violation Summary by Primary Water
Supply Source
FRDS20 is a summary report calculating violations by PUS
source.
FRDS20 begins with information on the report selection
criteria, or the details of the logical criteria, used in
selecting the PWSs in the report and the total number of PWSs
reported on.
In addition to the report selection criteria information,
FRDS20 contains .a body composed of a varying number of pages
containing the specified information on the selected PUSs.
A report example follows on the next page.
Effective Date: 10/01/89 Release Humber' 1.00 Page' 5-26
-------
N
IU
(9
^
Q.
Ill
4j
•^
M O
M 0)
1
S5
So!
U. -
iu 5
oc S
-J 3
< tn
Sz
0 O
Ul H
Ik t-
X
0
•1
i^H
s
1 u
\
11/06/69
FRDS20
in
-j >-
< in
o o
t- 5
>
in
g >*
| IS
o S >
in
^ o
IS
•!|
£ui in
u >-
ui < in
h- u. X
in oc o
M W) >
X
i
M
*»
2
O in
K §5
UI S X
d) o o
c a M
a (9>
aui in
u >-
•< in
32
in >
i
>-
••
>•
y
i
n-n «-
0 Z
o <
' i ' Z
/ 5
i S 5
1 Z 0
i 5 *e
M 1 UI
EPA REGION III
STATE: PENNSYI
VIOLATION TYPI
xxxxxxxx x x'xx x ^^N-NJi^"^x-'v>>- « 1 «£|
^•n._Lcc^iO LJ T3 O « -3 .- S 3 •- — !.*•••• (-CCXX
«^Tu._nain>»> -J Sc •" •»• -» « •- c 3 — s i. 3nc«—t-SS'-'- •< J» — < jS--BOP1JO^(«Ji>^'OXlI
uj^— i ...C'*" O*O O CA3XQ O ^jL*ifBX«Hi8l »^ 01 •*• C •** fll O
_J »i u. in w -t i- «M u Z- 3 ui
in in < in ac
1*1 3
e Z
^4 *4
U •<
u. Z U
o a •<
u u
§O <7
M IU
82
u
g
Q
2
IL
or
IU
w
U
x.
io
IU O
UI u
> »- o
» IU IU
II H- »-
_1 _J
Effective Dates 10/01/89
Release Number: 1.00
Pages 5-27
-------
5.2.2.8 FRDS21 - Variance and Exemption Summary by
Population (Not Available)
Effective Date: 10/01/89 Release Number" 1.00 Pages S-28
-------
5.2.2.9 FRDS22 - Variance and Exemption Summary by
Primary Water Supply Source
(Not Available)
Effective Date: 10/01/89 Release Number: 1.00 • Page: 5-29
-------
5.2.2.10 FRDS23 - Public Water Supply System Violation
and Source Data (Not Available)
Effective Date: 10/01/89 < .. Release Numbers 1,00 Page: 5-30
-------
5.2.2.11 FRDS24 - Public Uater Supply System Summary and
. Violation Data
FRDS24 is a detailed report of-PUS plant location and
violation summary data including violation duration in
months.
FRDS2<* begins with information on the report selection
criteria, or the details of the logical criteria* used in
selecting the PWSs in the report and the total number of PUSs
reported on.
In addition to the report selection criteria information.
FRDS24 contains a body composed of a varying number of pages
containing the specified information on the selected PUSs.
FRDS21 also contains a summary page as the last page of the
report.
A report example follows on the next-page.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-31
-------
m
m a
Si
f- •< M
10 J
>- O VI
:«z
i_ >• >.
•<« ca
o a
gl S
M M oe
a- E
•« M
5«
^<
u
O I/I
X a
« te
u o
§<
M
s-
(I
r
S
2
a>cOcOeOcO<0cQco o> o> » o> v> »•«
cgctiCMMMNNCilCtf
coco>h>i>r^h>r«r»r»i>«KiHiNfMn«(MMCitM(M«i«K«J
o>ioco
-------
5.2.2.12 FRDS31 - PUSs Months in Violation
FRDS31 is a summary report calculating the months in
violation for selected PUSs. This summarization is performed
for various categories of PUSs and their violations. Two
elementary statistics - number of PUSs and their population
served - are provided.
Population size and months in violation are the two axes of
tabulation on every page of FRDS31. At successively higher
levels of aggregation, summation is done first over violation
type, then contaminant code, then primary source, then type
of PUS, and finally geographic area by State and/or Region.
If user selection specifies the Primary Source (Clla), then
the report shows the primary sources used in the selection.
However, if the user does not specify the Primary Source
(Cl1a), then the report is divided into only two categories -
Surface and Ground - with both purchased and unpurchased
sources being included together.
In addition to specifying criteria for selecting PUSs to be
reported on, the user also specifies limits on the dates of
violations to be considered. The user specifies a year and
month as starting date of this range, and a later year and
month as ending date.
The Geographic Area levels of aggregation are also specified
by the user, e.g.. State, Region, and/or Nation.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-33
-------
Computation for months in violation is handled in a special
way. The user has the option of including all months of
violation duration, if any month is within the date range, or
excluding all months outside the date range.
For example, in computing how many months a PUS has been in
violation for a particular Contaminant Code (C11Q3) and
Violation Type (01105)* the report will count all months in
violation for that particular Contaminant Code (C1103), which
fall within the user-specified date range at the user's
option. It uill also count any months in violation before
and/or after the date range for a violation, as long as at
least one of the months in violation falls within the date
range. Violation periods prior to January. 1976, are
excluded.
In computing hou many months a PUS has been in violation for
a particular Contaminant Code (C1103) regardless of Violation
Type CC110S), the report determines which months the PUS was
in violation as before, but it counts a particular month only
once if two or more different violations occurred in that
month.
On the chart that follows on the next page, the method of
computation is shown for a hypothetical report. The single
PWS has MCL violations in the months of October, November,
.December, January, February, and May. Thus, for MCL
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-3(4
-------
violations, the PUS for this FY had six months in which
violations were reported. The PUS also had monitoring
violations reported for the months of January, February, and
June, or three months in the FY. Starting in October the
occurrence of a single violation constitutes an accumulation
of months in violation for computing purposes. However, the
six months occuzzence for MCL added to the three months
occurrence for monitoring, do not constitute nine months
combined, since MCL and monitoring types are redundant in the
months of January and February, and should not be counted
twice using each violation type month-occurrence.
Computing Months in Violation for a Single PUS
tsaaaaasas:
Raw Data Type OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP
cor a MCL X X X X X X
Single PUS MOK XX X
Months in Violation Totals by Month
Violation Type OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP
MCL 12345 6
MON 12 3
Combined 1 2 3 <* 5 67
Effective Date: 10/01/89 Release Number: 1.00 .Page: 5-35
-------
The particular month in violation is based upon the Violation
Date (C1107) with the range of months marked based upon the
Violation Duration (C1111). MCL violations occurring in the
first quarter for a duration of three months, would be
portrayed differently depending on the violation date. The
results would.be as follows- assuming all other information
was the same"
Number of Months in
Violation Date Months in Violation Violation
October OCT.NOV.DEC 6
January JAN,FEB,MAR
-------
FROS-II/Xnteractive
Post Retrieval Output Options Menu
(S) Batch Job Subeission
(Fl Frequency Distribution
(L) Lilt in Standard Sera an foraat
(Ql QuicklooK Report Generator
(E) End Post Retrieval
—> Enter thai Cod* which corresponds to the desired Post Retrieval
Output Option: b
mnnmnniimi PROS-II Phase 1 Reports mn»H»nmmum
Reports 1, 3. 7, 19, 20. 2 Enter the nusbw of the desired PROS report: 31
Having selected • FRDS31 report, you Must provide
additional information ...
Enter the Beginning date of the period you want covered in YYMn format:
—> Date: 8901
Enter the Ending date of the period you want covered in YYMn format:
—> Date: 0910
Do you want this report to (IInclude total months
in violation (including those Months which nay
praceed or follox the requested date range)
or, do you want to (E)xclude those aonths that
precced or follow the requested date range?
—> CIInclude or (E)xclude: i
continues on next page
Effective Dates 10/01x89
Release Number: 1.00
Page: S-37
-------
continued fro* previous page
—> Do you Mant National totals on your FRDS31. report? (Yles or (N)o: n
—> Do you Mant Regional totals on your FRDS31 report? (Y)es or (Nlo: n
—> Do you Mant State totals on your FRDS31 report? CYles or (H)o: y
—> Do you Mant State totals on your FRDS31 report? (Yles or (Nlo: y
—> Do you Mant an Individual Primary Source summary listing?
(Yles or (Nlo: y
—> Do you Mant a Group Primary Source summary listing?
(Yles or (N)o: y
—> Do you Mant an Aggregate Primary Source summary listing?
(Yles or (Nlo: y
—> Do you Mish to add an additional identifying title line to your
FRDS31 report? (Yles or (Nlo: n
Your current Job parameters are:
FIMA3 ID: xxxxx
Destination: RHTnrm
Bin/Box: dddd
Estimated Time: Long
Priority: Z
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct? (Yles or (Nlo? y
Job 7457 Submitted ...
<- - -
1<- The user selects the FROS31 report.
2<- - - The user establishes the violation data range.
3<- - - The user »»y select desired totals and summaries.
4<- - - Verify that report routing information is correct.
Effective Date: 10/01/89
Release Number: 1.00
Pages 5-38
-------
3 <
? i O
\
I
. i
at
Ul
t-
r* o
o o
75
S5
h- _4
ll> O
>- >-•
in >
o:
2i
mi H-
K O
<
K
« z o»
ui O
ui ia
o < M
4t OC
U. IU t—
55 <
iu O
a. M
S *,
?:3 z'
S3. «
3 M
r n
o 3 M
°g x
u
X
O
/*
;r*i «
s /
a. /
• t^
|sl *
IS\ 2
•< ca
Ǥ
iu ^.
I- O
< o
\ 2 •
25 i
C> H- IH
CO .. i-l t-
is sS 3
o in M 3
N a go DJ
— £ CK > a.
— CO
9-
0 O
0 0
o o
O 0
o o
0 0
0 O
tft f* 04) o •* O<.OT*»Jr'
**« ** pj m -o M
4» ^ in »4 o NO -4 o MO N f* oo oo oo
•"• O NO NO NO NO -1 O OO OO OO
o oo in 'f it o
O" ~« in • it >o o
it -o f- in N
NO it in in -r NO oo •* o it ••» ^ o o o o o
o r«. it m o in oo
r» it o ix oocoooo
N O* U> OOOIXOItO O
O O O O«-*O9«O^* O
OOO.O - - O 0
omito - o i/i o -
o « - - o in r~ -< o
o o N it in x i i i o
ca -H
c>
10
o
N
N
tn
•"• 0
a o
1 O
-4 O
a o
o -
{52
« o
0 O
o o
>4 O
0 0
o o
M in
1 O
-« o
- o
tn -
i
ft a
M «•
it in
— < o
O 0
in it
N
1 O
•4 0
O O
in -
x O
o o
-> m
•• a
IU
0 Q
21
<» r«. co -o
4
ws«,<;
o .
O 0 0
o • •
s
in
^ o o o
•o o o
m • •
o
t*.
^S> "!*
|22
*o -a ~o ~r
r* •+ — ^
Ctl • •
N it in
r"
?g^R"
•o a o
a —
eg in Kl o
It co •<* »i
,oi/>a.oi/ia.oi/>a.ot/iQ.oi/ia.cE
iitsooso^iojaco -ggs;|
i a. «t en a.
:£ 52£
i
in a.
o. a. x x
32
00
Effective Date: 10x01/89
Release Number: 1.00
Pages 5-39
-------
FEDERAL REPORTING DATA SYSTEM - FRDS-II
FRDS31 REPORT NOTES
MOTE "I'- The number of Public Water Supplies (count of C101)
for the PUSs identified by the locate statement noted
belou.
NOTE 2: The sum of PWS-RETAIL-POP-SERVED (C117) for the PUSs
identified by the locate statement noted belou.
HOTS 3J The sum of PUS-RETAIL-POP-SERVED (C117) for a given
population category, months in violation, violation
criteria. PUS criteria and violation date range.
** .
NOTE M: The ratio of qualifying PUSs divided by the
PUS-RETAIL-POP-SERVED (C117) on the page of the
report shown, to the total domain identified by the
locate statement noted belou.
NOTE 5: The number of PUSs for a given population category,
months in violation, violation criteria, and
violation date range.
xxxxxxxxxxxxxxxxxxxxxxxx*
X *
* LOCATE STATEMENT: *
* -. *
* LOCATE C100 UH C3 EC PA AND NK C103 EC CAC:*
x *
xxxxxxxxxxxxxxxxxxxxxxxxx
Effective Date: 10/01/89
. Release Number: 1.00
Pages S-10
-------
-------
5.2.2.13 FROS35A - Annual Data Evaluation
FRDS35 will generate a list of PUS IDs to be used as input to
other FRDS-II reports. Selection of PUS IDs may be done in its
entirety, or a randoa selection may be performed. To accomplish
this processing of FRDS35. the system asks further questions in
addition to those asked for other reports.
The first question asks the user to specify the sample size of
selected PWSs to be used. If the user enters the maximum sample
size. 999999, then all selected PWSs will be used. The second
question asks whether the sample size is to be used for each
State* or is to be applied to the entire selected population.
This second question thus determines-whether a single report, or
a separate report for each State is to be produced. For example,
if the user desires to select 10 PWSs from each State, then the
second question would be answered '¥'. If* on the other hand.
the user wanted 10 PWSs Nation/Region wide, then the question
would be answered 'N'. If selection is made from only a single
State, then an answer of 'Y' or 'N' has the identical result.
The sample session beginning on the next page shows how to
generate FRDS3S. A report example follows.
Effective Date: 10/01/89 Release Kumber: 1.00 Page: 5-41
-------
FROS-II/lnteractive
Post Retrieval Output Options Menu
(8) Batch Job Submission
Frequency Distribution
(L) List in Standard Screen Format
19) Quicfclook Report Generator
(E) End Post Retrieval
~> Enter the Code tahich corresponds to the desired Post Retrieval
Output Option: b .
MMUMBMHMMM FROS-ZI Phase I Reports MMIHIMMUMMM
Reports 1, 3, 7, 19, 20, 24, 31, 35, « 41 are available
»M»»MMMMM» FRDS-II Phase 2 Reports HHMMMMMMUM
Reports 17, Id, 21, 22, 23, 32, I 36 are NOT available
—> Enter the number of the desired FRD3 report: 35 <- - -
Having selected a FROS35 report, you must provide
additional information ...
Do you want to select (A)ll PUSs which are qualified by the Locate command
presently in use, or do you want to select only a (R)andom sample from
those qualified by the Locate command presently in use?
—> Select Random samples (1 to 999999): Z . < - 3
—> Do you want the number of random samples specified to be selected for
each State Mhich has been qualified? CYJes or (N)o: y
A file containing the PNS IDs of the systems selected will bit created
for your later use ... <- -
Please note the following file name for future reference:
LVEFRDS.C891025.71937^2.PUSIDS
<- - - 5
continues on next page
Effective Date: 10/01/89
Release Number: 1.00
Pages 5-H2
-------
continued from previous page
—> Oo you Miah to add an addition*! identifying title line to your
FR033S report? (Ties or (N)o: n
~> Do you *ant to sort the report data? (Y)es or (N)o: n
Tour current Job parameters are:
FIHAS 10: ~"-T
Destination: RMTnrm
Bin/Box: dddd
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct? (Y)es or (N)o? y
Job 7463 Submitted ...
1< The user selects FROS35.
Z<- - - The user selects a random subset of qualified PWSs. •
3<- - - The user chooses the desired nvoober of randomly selected* Qualified
PMSs. If the user had ehoosen to use all of the qualified PMSsi this
prompt Mould not have appeared.
4< - The user has the choice of saving the selected PUS IDs in a data set
for later use.
5<- - - The system displays the data set name of selected PHS IDs.
6<- - - The user nay specify an additional title line for FROS35.
7<- - - Report routing may be verified. A response of "n" would allow the
user to make changes in the routing information.
Effective Dates 10/01/89
Release Mumbers 1.00
Page: 5-143
-------
< a. at in
Sin >-
— H.
Effective Date-' 10/01/89
Release Number: 1.00
Pages 5-4U
-------
13
<
GL
in
t-
u
g
M
a
at i-
"§
i a.
>- Z u
IA O t-
^ M UJ
Ml- UJ
«3 i
>- -I U
23 «
IU t-
(9 cr
Z < O
•i h- in
i: §
41
IA
*
£
a
i^
in
I
tu
h-
o
w»
i?
o •<
UJ ^
-I «0
MO Ifl I*
^ CM t> Ift
O M CO —
ON IA e
« J- O —
IA IA •* ft
CO « 00
O O IA IA IA * «M
<0 <0 <0 CO « CO CO
-i «> .r in «M — M 1*1
O M
ae
IU
s
Ik
CO
x in
CO Kl
o in
x c
— cr
/!
f-*-| w
!IA ac
|0| a.
u •
1
^
-
S
£
q «
i
\
\
A
e
i
u>
UJ
a
*c
a
UJ
a,
j;
!?S
Q£
^
^
a.
•x iu
iu o
§X 0
D£ O
« •<
1- >
32
IU
X
g M
ut O
< u.
ac a
< o
*-
IH
C 0
< »^
^v
2
O
u
R1
01
,^. - 01
>ql
|u
^"*1
*«"~ SI
Kt
| U)
J=1
FO I
U 1
:-|
0
^ 1 O 1
tn i
U 1
•
-------
ID
(L
1
m
g-
"•5
o
i a.
1C CK
m o
>• **
m N-
M t-
fa
-i
ot 3
FEDERAL
AN*
e>.
X I/I
¥
>— 1
u
£
z
o
1-4
ID
Ul
DC
a.
IU
> w
IP ANALYTICAL
(N RESULT
[
J
1 III Ul
'I2
§
a
Z <*l
IUQ
at
,_
i—
fen
0 M
U
o
ss
_J
«•(
_1 |y
n
•• in ^
:
i
^ fE H»
» < <
2°
a
Z iu
19 <
§*~ 0
»-t
U
o
o
o
o
o
o
o
a
o ' .
00000000000000000
XXXXXXXXXXXXXXXXX
OOCMCMCUCUCMOOOOOOOOOO
ooooooooeoooooooo
ooooi/iinoooo o o o o
x
nj
m
s
CO
X
o
o
o
o
x
^J
•n
S
X
c«
"*
S
cp
CO
e
o
e
o
o
o
it
o
-------
5.2.2.14 FRDS36 - Informal Enforcement Actions
. (Kot Available)
Effective Date: 10/01/89 Release Number: 1.00 Page
-------
5.2.2.15 FRDS37 - Multiple Year Violations (Not Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-H8
-------
5.2.3 Option 'C* - Create a File for SAS - Sequential File
(Not Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: S-i+9
-------
5.2.«4 Option Tf - Frequency Distribution of Data Report .
Option 'F'. of the Post-Retrieval Options Menu generates the
Frequency Distribution of Data Report. This report may be
displayed on a terminal or printed on an off-line, high speed
printer.
The Frequency Distribution of Data Report provides a frequency
distribution table of unique code value occurrences for a
specified data element, based upon the currently selected
PWS(s). The report always lists the unique code values and the
total number of occurrences. The frequency distribution may
optionally be sorted by occurrence.... from most to fewest.
The sample session on the next page shows hou to use Option
'F'. Report samples and explanations are also provided in the
sample session.
Effective Bate: 10/01/89 Release Number: 1.00 Page: 5-50
-------
FR03-II/Inter«et i ve
Post Retrieval Output Cottons Menu
IB) Batch Job Submission (L) List in Standard Screen Foraat
Enter tha Cod* which corresponds to the desired Past Retrieval
Output Option: f
**•« FREQUENCY OPTION •••»
You nay interrupt the processing of a component by
pressing the key twice.
— > Do you Mtsh to produce a Frequency Distribution? IY)es or (N)o: y
--> Enter the Data Element Number: cllOJ •
— > Do you wish to sort distribution by occurrence (most/fewest I? <- - -I
(Y)es or (K)o: n
Hhere should the report be produced?
On your (T)ereinal or a High-speed (P)rinter: t
*••*«*»**•••»»*««********»»***»*
01/03/89
TAUT OF CX103 - VIC-CONTAMINANT
• «»«*K*II*»»* »«*»«*»»*»****»*«***
OCCURRENCES VALUE
341 0100
36 1005
41 1010
35 1015
36 1020
3d 1025
39 1030
37 1035
66 1040
38 1045
36 1050
37 1052
1 2005
22 2950
1240 3000
5 • 4000
2 4100
2 4102
2 4174
»«»««»»****»«»*»********««»*»*•*
19 UNIQUE VALUES < --- 2
2054 TOTAL OCCURRENCES
»»»»»«»»»»»»»»» »»»•»»»«»»»»*»»*«
LOCATE C1100 WH C3 EQ PA AND C103 EQ CAC AND C1135 EQ 37: < --- 3
*«****«***»*•»*****«*»********»*
Effective Date: 10/01/89 Release Number: 1.00 Page: .5-51
-------
Mould you like to rout* this report DOM to a printer? (Y)es or (N)o: n
--> Do you wish to produce another Frequency Distribution? lYJes or (N)o: y
— > Enter the Data Element Number: cl!03
— > Do you wish to tort distribution by occurrence ( MM t/ fewest)? <- - - *
(Y)«s or (N)oj y
Where should the report be produced?
On your (T)eronnal or a High-speed (P)rinter: t
IHMHHNHHI«HMMNMHMHMMMHHMNHHMMNte»
01/93/89
TALLY OF C1103 - VIO-CONTAMINANT
MMHHHHMHMHHHHHHNHWHHMHMIHHHI***
OCCURRENCES VALUE
1240 3000
341 0100
66 1040
41 1010
39 1030
38 1025
38 1045
37 1035
37 1052
36 1005
36 1020
36 1050
35 1015
22 2950
S 4000
2 4100
2 4102
2 4174
1 ZOOS
•ft******************************
19 UNIQUE VALUES . < --- 5
2054 TOTAL OCCURRENCES
LOCATE CllOO UN C3 EQ PA AND C103 EQ CAC AND C1135 EQ 87:
»*»*»******»»»*»****»»*»*•******
Mould you like to route this report nou to a printer? (Y)es or (K)o: n
--> Do you uish to produce another Frequency Distribution? Enter the Data Element Number: c603
— > Do you wish to sort distribution by occurrence (most/fewest)?
lYJes or (Nlo: n <- - - 7
--- > Data normalized to PMS-level < --- 8
Effective Dates 10/01/89 Release Number* 1.00 Page: 5-52
-------
Where should the report be produced?
On your (T)erainal or a High-speed (P)rinter:
01/03/89
TALLY OF C603 - PHS-SERV-CATE60RY
OCCURRENCES
740
196
424
267
4
5
46
20
2
5
1
M*m*mm+*m mm m n •
« M H PV1W WOT*V>VN» WWWW IVWIC
VALUE
01
09
Rl
R2
R9
SI
S2
Tl
T2
T4
T6
T9
12 UNIQUE VALUES <- - - 9
1714 TOTAL OCCURRENCES
0 PUS WITHOUT PWS-SERVICC-AREAS
»»•»**•»*• MHMMMMI »»»•»••»•»*•••»
LOCATE C1100 MH C3 EQ PA AND C103 EQ CAC AND C1135 EQ S7: < 10
»»«*»»»»»•»»»»»»»•»»««•*•**•*•H*
Mould you like to route this report now to a printer? (Y)es or (N)o: y
Report File Disposition - (K)eep for later printing or (Dlelete:
Now:
--> fc <- - - 11
Your current Job parameters are:
FlttAS ID: XXXXX
Destination: RnTm
Bin/Box: XXXX
Estimated Time: Short
Priority: 4
Printer Type: Destination
Report File Disposition: Keep
Number of Pages of Output: Average
Copies of Report: 01
—> Are these parameters correct? (Y)es or (N)o? y
Job 9376 Submitted ...
—> Do you wish to produce another Frequency Distribution? (Y)es or (N>o: n
Effective Dates 10/01/89 Release Number: 1.00 Page: 5-53
-------
I <- - - The user chooses not to sort th* output by occurrence from most
tO fewest.
2 <- - - Th* detailed output is summarized.
3 <- - - The report's date selection criteria statement is displayed.
* <- - - The user chooses to generate a second report and sort the output
by' occurrence fro» most to fewest.
5 <- - - The detailed output is summarized.
6 <- - - The report's data selection criteria is displayed.
7 <- - - The user chooses to generate a third report and not to sort the
output by occurrence fro* most to fewest.
8 <- - - System message indicating that a different data base path will
be used.
9 <- - - The detailed output is summarized.
10 <- - - The report's data selection criteria is displayed.
U <- _ - The user chooses to keep the selected data in a report- file for
later reference.
Effective Date: 10/01/S9 Release Number '• 1.00 .• Page! 5-SH
-------
5.2.S Option *G" - Graphs or Maps (Mot Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-55
-------
5.2.6 Option 'I' - Invoke IDRS/CERCLIS - IDHS State Map
IDRS Region Map. IDRS United States Map,
Report fox Cross-Walk One, Reports for
Crosswalks Two through Five.
(Not Available).
Effective Date* 10/01/89 Release Kumber' 1.00 Pages 5-56
-------
5.2.7 Option 'K* - Kounts or Sums of PWS Elements - Count/
Summation of Data Report (Not Available)
Effective Date: 10/01/89 Release Numbers 1.00 Page: 5-57
-------
5.2.8 Option 'L* - List in Standard Screen Format -
Reports for Suboption Screens
Option 'L' of the Post-retrieval Processing Options Menu allows
the user to list information for previously selected PWSs. The
user may optionally sort the selected PWSs or browse through the
output in an on-line mode.
The available reports generated through suboption screens are as
followss
Primary/Secondary Screen Types
Suboption Type of On-line Information
Screen
1 PUS and Service Area Information
2 PUS and Source Information
3 PUS Related Violations
4 PUS Variance and Exemptions Data
5 PUS Related Enforcements
When the user has selected Function 'A', which retrieves only
PUSs with violations, FRDS/Interactive invokes the Primary
Screen Type f3 automatically and skips to the sort question.
When the user has selected Function 'X* the system prompts you
for a Primary Screen Type.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-58
-------
In Function 'E' oz 'X'» the user has the choice of specifying
various Secondary Screen Types for vieuing data on individual
PUSs. Then, the PUSs may be optionally sorted in one of several
predefined uays.
Option ?L* gives the user the capability of vieuing selected
PUSs in the browse node. The reports may be displayed one
PUS at a time on a terminal, or the entire set of selected
PUSs may be printed off-line on a high-speed printer.
The sample session beginning on the next page shows how to
use Option 'L'. Report examples for each of the five
suboption screens follow.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-59
-------
FRDS-II/lnteracttve
Post Retrieval Output Options Menu
saaSaaaiSaSSSSSSSaaasSSSSSSSSSSSSSaaasaaSSSSSSSSSSSSSBasSSSSSSSSSSSSSSSSSa
IB) Batch Job Submission CD
(M Frequency Distribution (Q)
List in Standard Screen Foraat
Quicklook. Report Generator
—>
(E) End Post Retrieval
Enter the Code which corresponds to the desired Post Retrieval
Output Option: 1
Do you want to sort the report data? Y/N: n
Do you want output listed offline? Enter Y/N: n
Display these violations? Enter Y/N: y
Stop after each PUS? Enter Y/N: y
—>
tl
PUS-ID: PA1090001
SYSTEM NAME
BRISTOL BOROUGH WATER ft SEWER
PUS-STATUS: CAC
CITY!
STATE RE6ZON: 01
STATE DISTRICT: 11
PIPS COUNTY: 017
POND ft MULBERRY STS
BRISTOL PA
1215) 766-363*
19007
PRIMARY SOURCE:
CWNER-TYPE:
TOTAL VIOLATIONS:
POSTING DATE: 09/07/89
INV LAST UPDATED:
25 POPULATION SERVED: 30,000
SERVICE CONNECTIONS: 8,540
PRIMARY SERVICE AREA(S):
Residential Area
CURRENTLY AT PUS 1 OUT OF 753 POSSIBLE PUS'S
YOU CAN BROWSE THRU THE SELECTED PUS FILE IF YOU WISH
YOUR OPTIONS FOR BROUSIN6 ARE:
F = FIRST PUS
L = LAST PWS
N 3 NO BROWSE. USE NEXT PUS
E » END BSOHSINS, SELECT NEXT FUNCTION
S * SKIP THRU THE SELECTED PMS FILE
C = CHANCE TO DIFFERENT SCREEN FOR THIS PUS
continued on next page
Effective Date' 10/01/89
Release Number: 1.00
Page: 5-60
-------
—> Enter your option* plaasa: e
--> Entar Mcondary scr««n ••lection typ« (1 to 51: 2
PUS-IO: PA1090001
SYSTEM NAME/ADDRESS:
BRISTOL BOROUGH HATER i SEHER
POND ft MULBERRY STS
BRISTOL PA 19007
(215) 786-3636
PRIMARY SOURCE: S TOTAL VIOLATIONS:
PUS-STATUS: CAC
OWNER NAME/ADDRESS:
STATE REGION: 01
STATE DISTRICT: 11
25
INV LAST UPDATED:
POPULATION SERVED: 30,000
—SOURCE J!EC DATA TREATMENTS
ID NAME TYP COO AVA OBIS RIVER REACH LATITUDE LONGITUDE ID OBJ PRO
001 DELAWARE RIVER S
002 3 HELLS
400546 0745110
400740 0744940
01
02
03
04 Y
05 Y
Y
Y
Y
01
02
03
»»»»»il»m>miiiiimnim»»i«mi«
062
06S
084
065
092
061
082
092
«•»»
»••»•»*•»•• HM»» II »«»»«I>»IIII»»»«II»»II»»»»»»»M» »»•••»•» •••••••BUB
CURRENTLY AT PUS
1 OUT- OF
753 POSSIBLE PUS'S
continued on n*xt p*g«
Effective Date* 10x01/89
Release Number: 1.00
Page: s-61
-------
—> Enter your option, please: e
—> Enter secondary screen selection type (1 to 5): 3
PUS-ID: PA1090001
SYSTEM NAHE
BRISTOL BOROUGH HATCH ft SEWER
PUS-STATUS: CAC
STATE REGION: 01
STATE DISTRICT: 11
FIPS COUNTY: 017
PRIMARY SOURCE: S
CNTH TY DATE VIO-ID
TOTAL VIOLATIONS: 25. POPULATION SERVED:
VIOLATIONS AND ENFORCEMENTS -- — ----
30i000
OUR ENP-ID ACTION
1015 01 04/14/69 6912813
1015 .04 06/26/68 6912815
2020 03 06/24/62 6510963
2015 03 06/24/62 6510965
1050 03 06/25/64 6510966
2010 03 06/24/82 8510967
1045 03 06/25/64 6510966
2005 03 06/24/62 6510969
1040 03 06/25/84 6510970
2110 03 06/24/62 6510971
1015 03 06/25/64 6510972
2105 03 06/24/62 6510973
1010 03 06/25/64 8510974
1005 03 06/25/84 8510975
0100 03 06/01/85 8510976
1035 03 06/25/64 6510977
1030 03 06/25/64 6510978
1025 03 06/25/64 6S1Q979
1020 03 06/25/64 6510960
0100 03 07/01/85 8537642
05 04/01/62 6205724
05 05/01/62 8206204
05 08/01/62 6200319
05 07/01/62 6227656
3000 03 06/01/61 6133793
m)iii»i»»»iin>m»»iii»m>i»)H
1 OUT OF
^••••••••••••••i
I«»I>«M
CURRENTLY AT PWS
753 POSSIBLE PUS'S
continued on next page
Effective Dates 10/01/89
Release Number: 1.00
Page: 5-52
-------
— > Enter your option* ple«se: c
— > Enter secondary screen selection type (1 to 5): 4
PMS-ID: PA1090001
SYSTEM NAME
BRISTOL BOROUGH MATER I
PRIMARY SOURCE: 3 TOTAL
TYPE CNTM VE-ID
PUS-STATUS: CAC
3EHER
VIOLATIONS: 25 POPULATION
STATE RESIGN: 01
STATE DISTRICT: 11
FIPS COUNTY: 017
SERVED: 30,000
MODIFIED MCL EXP DATE ACTION REASON
NO VARIANCES/EXEMPTIONS FOR THIS PUS IN DATA BASE
CURRENTLY AT PHS
1 OUT OF 753 POSSIBLE PWS'S
continued on next page
Effective Date' 10/01/89
Release Number: 1.00
Page: 5-63
-------
— > Enter your option* please: e
— > Enter secondary
PUS-ID: PA109000I
SYSTEM NAME
screen selection type
PWS-STATU3
(1 to 5): 5
: CAC .
BRISTOL BOROUGH HATER 1 SEHER
PRIMARY SOURCE: 3
EHF-ID DATE
8912813 06/01/69
6912615 06/01/89
8510963 10/21/85
6537642 10/07/85
8205724 09/30/82
8133793 07/19/81
TOTAL VIOLATIONS:
ACTION 10
FJ 6912813
FJ 8912615
FX 6510963
6510965
8510966
8510967
6510966
6510969
6510970
6510971
8510972
8510973
6510974
6510975
6510977
6510978
6510979
6510980
1C 6537642
E* 6205724
8206204
6200319
8227856
IA 8133793
25 POPULATION SERVED:
ACTIONS— •
VIOLATION
DATE TYPE
04/14/89 01
06/26/88 04
06/24/62 03
06/24/82 03
06/t5/84 03
06/24/82 03
06/25/84 03
06/24/82 03
06/25/84 03
06/24/82 03
06/25/84 03
06/24/82 03
06/25/64 03
06/25/84 03
06/25/84 03
06/25/84 03
06/25/84 03
06/25/64 03
07/01/85 03
04/01/62 05
05/01/82 05
08/01/82 05
07/01/82 05
06/01/61 03
30.000
10
1015
1015-
2020
2015
1050
2019
1045
2005
1040
Z110
1015
2105
1010 .
1005
1035
1030
1025
1020
0100
3000
CURRENTLY AT PUS 1 OUT OF 753 POSSIBLE PMS'S
Effective Dates 10/01/89
Release Number: 1.00
Pages S-6<*
-------
5.2.9 Option 'fT - Hap of PUS by State, Region, or United
States - PUS State nap, PUS -Region Map, PUS
United States Map (Not Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-65
-------
5.2.10 Option 'Q' - Quicklook Report Generator
Section 5.2.10 contains general information relative to the features
, .d operation of the FRDS-II Quicklook Report Generator (QUICK),
version 5.0.
QUICK permits the user of FRDS-II/Interactive to design and print a
report according to his/her own specifications. This is accomplished
through user responses to a series of clear and easily understood
prompts.
QUICK is invoked via the "(Q)uicklook" output processing option
of FRDS-II/Interactive.
The data displayed on a QUICK report represents that subset of
data extracted by way of the "LOCATE" performed prior to the
entry into QUICK. The "LOCATE" is formulated as a result of the
..", "E", or "X" functions of FRDS-II/Interactive.
The remainder of section 5.2.10 contains five subsections as
follows:
Subsection I. Characteristics of the QUICK report that are
i controlled by the user
i
Subsection II. Special notes relative to the use and operation
of QUICK
Subsection III. Understanding the QUICK report
Subsection IV. Data Elements that are displayed in an edited
fashion
Subsection V. Example QUICK on-line session and example
QUICK report
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-66
-------
* Subsection I. Characteristics of the 9.UICK report that are
* controlled by the user
Through prompts issued, the user can specify the following
characteristics about the 9.UXCK report that is to be produced:
1. The maximum number of characters that can be printed per line.
Permissible responses may range from 60 to 132. Most typically.
one uould use 80 characters per line if you intend to display
the report on your terminal and 132 characters per line if you
intend to print the report on a high-speed printer.
2. The maximum number of lines that can be printed per page.
Permissible responses may range from 17 to 58. Most typically,
one uould use 24 lines per page if you intend to display the
report on your terminal and 58 lines per page if you intend to
print the report on a high-speed printer.
3. • The minimum number of spaces that should occur between
consecutive columns printed.
Permissible responses may range from 1 to 10. The number used
in actual practice will be based on your personal experience
and preference.. It is recommended that you experiment uith
the minimum inter-column spacing until you are satisfied uith
the effect produced by your choice.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-67
-------
Please note, however, that the actual number of spaces that
will appear between columns is affected by uhat is being
printed in consecutive columns, and other options you have
chosen to use (e.g., totaling, code value translation, etc.).
«*. A report title, if desired.
Permissible responses range from no title at all to a title
that has a length of less than or equal to the maximum number
of characters per line you specified. Upper and louer case
letters may be entered if desired, however, most high speed
printers uill convert louer case letters to upper 'case uhen
the report is printed.
The type of column headings that are to be printed.
Four (4) choices are available. They are:
o Data element numbers as assigned in the FRDS-II data base
definition;
o Data element names as assigned in the FRDS-II data base
definition;
o User defined for each column ... permissible responses
range from no column heading at all to a column heading
that has a length of less than or equal to 30 characters
or less than or equal to the number of characters that
remain on the print line, whichever is smaller. Upper and
louer case letters may be entered if desired* houever,
Effective Date: 10/01x89 " Release Number: 1.00 Page: 5-68
-------
most high speed printers uill convert louer case letters
to upper case uhen the report is printed;
- or -
o Ho column headings at all.
6. The location at uhich the 2UICK report is to be produced.
T«o (2) choices are available. They are:
o The user's terminal;
- 'or -
o A high-speed computer printer: The printer can be located
at the user's remote site, or at a site different than
his/her own.
7. The type of totaling that is to be performed.
Five (5) choices are available. They are'
o Count ... for each data element printed, CUICK checks each
data element's value. If it is a unique and significant
value (See note belou), it is counted;
o Sum ... for each data element printed 2UICK checks each
data element's value. If it is a unique and quantitative
value, it is summed;
o Both Count and Sum;
Effective Date: 10/01/89 Release Numbers 1.00 Pages 5-69
-------
o User-defined by column; . .
- or. -
o No totaling at all. . •
Note* A significant value is one that is non zero, not null,
and not blank. .
In each of the cases where,a totaling option is chosen* grand
totals are accumulated and printed at the report's end.
If the user requests that the report is to be paginated
(described below), sub-totals are accumulated and printed each
time the pagination data element's value changes.
If totaling has been requested* whether the report produced
is to be a summary report. A summary report causes the
individual detail lines to be omitted ... only sub-totals (as
applicable) and grand totals are printed.
9. If a summary .report has NOT been chosen, whether the report
produced is to use repeat suppression. Repeat suppression
causes a ditto mark to be printed in place of data that is
identical to data on the preceding line and derived from the
same data base record.
For example ... If you print the system name, the contaminant
in violation, and the Enforcement ID, and the
PUS has tuo violations
Effective Date-' 10/01/89 Release Number: 1.00 Page: 5-70
-------
JOSEPH BROS. WTP Coliform 89-123^5 (line 1)
" " 89-514321 (line 2)
" Coliform '89-89012 (line 3)
First, note that lines 2 and 3 illustrate that the system name
is identical and from the same data base record (in this case",
the PUS-SUMMARY data base record) as is the system name on
line t. In other words, lines 2 and 3 are for the same PUS.
Next, note that line 3 illustrates that the contaminant in
violation is identical, but that a ditto mark is not printed.
The reason is simple.
A ditto mark is printed on line 2 beneath "Coliform," because
the contaminant in violation is identical to and is derived
from, the same data base record (in this case, the VIOLATION-
DATA data base record) as is the contaminant in violation on
line 1 ... or, in other words, it is the same violation.
A ditto mark is not printed on line 3 beneath the previous
line's ditto mark in the contaminant in violation column,
because this contaminant .in violation, although an identical
value to the previous line's, is derived from a completely
separate .VIOLATION-DATA data base record ... it is a different
violation.
10. For reports that are to be displayed at the user's terminal,
whether QUICK is to pause at the end of each page of the
report displayed and give the user the opportunity to continue
Effective Date - 10/01/89 Release Number: 1.00 Page: 5-71
-------
uith the next page or not.
„*
11. For reports that are to be displayed at the user's terminal,
whether 9.UICK is to produce a general information report
containing a complete description of the report to be produced
or not.
Reports that are printed on a high-speed printer automatically
have the general information report printed.
12. The data that is to be printed in each column of the * 2UICK
report.
The user may enter any FRDS-II data element number or data
element name in specifying what he/she wants printed. However,
all data elements specified must belong to the same data .base
family. Refer to data base structure chart to determine the*
family to which a data element belongs. The data base family
appears in the upper right-hand corner of each block which
'• represents a data base record.
Hypothetically, a maximum of thirty-three (33) columns can be
printed. In reality, however, this would be possible only in
a situation in which 33 one-character data elements were to be
printed with either no column headings, or a single character
user defined column heading for each column.
A more reasonable and accurate estimate of the maximum number
of columns that can be printed, is difficult to predict.
Effective Dates 10/01/89 Release Numbers 1.00 Pages 5-72
-------
Although five (5) to fifteen (15) columns might seem reasonable
to expect, the actual number uill depend upon a number- of
related factors. Factors such as the maximum number of
characters per line specified, the type of column headings
being utilized, whether or not totaling is being performed,
and the cumulative length of the data elements you are
attempting to print, all affect the maximum number of columns
that can be printed.
As the user specifies what is to be printed, three comments
are in order. They are:
o Numerous data elements' values are codes for which
descriptions exist. 2UICK automatically recognises these
data elements and requests that the user specify whether
they uant to print the code as it is stored in the data
base, or the descriptions uhich describe these codes. If
code descriptions are to be printed, the user must specify
the number of characters of the descriptions to print.
o Several data elements' values are textual in nature.
QUICK automatically recognizes these data elements and
requests that the user specify whether they want to print
all, or only a specified number of the left-most characters
of the data element's values.
o Numerous data elements' values are printed in an edited
fashion. This means that leading zeroes are suppressed
(not printed) in quantitative values, commas and decimal
points are inserted where appropriate in quantitative
Effective Date: 10/01/89 . Release Number-- 1.00 Page: 5-73
-------
values, and slashes or dashes are inserted in various
other data elements' values' to improve readability (e.g.,
dates, telephone numbers, etc.). Refer to Subsection XV
t
for a complete list of data elements that are printed in
an edited fashion.
13. Whether the report is to be paginated or not, and, if so, on
what data element.
The report can be paginated on any FRDS-II data element that
belongs to the same data base family as data elements that
uere specified to be printed.
The data element specified to be used in pagination is
automatically used by QUICK as the first sort argument on
which the report uill be sorted.
Pagination can be performed only on a single data element.
When this data element's value (or the value's description, if
• requested) changes, QUICK uill produce count and/or sum sub-
totals (if totaling was requested) and begin a new page.
11. The order in which the data on the QUICK report is to be
sequenced.
The user may enter any FRDS-II data element number or data
element name in specifying how the report is to be sequenced,
so long as each data element specified belongs to the same
family as data elements that were specified to be printed.
•
Effective Date' 10/01/89 Release Xuraber= 1.00 Pages 5-71
-------
If the user chose to paginate his/her report, the data element
on which* pagination is performed is automatically inserted as
the initial data element on uhich the report will be sorted.
It is possible, although not necessarily advisable, to sort
the report on data elements that are not printed.
A maximum of ten (10) data elements may be specified in
. defining the report sequence. For each, the user is given the
opportunity to specify whether the data is to be ordered in
ascending (A to Z / zero to 9) or descending (Z to A / 9 to
zero) sequence.
15. After a report has been generated, the user is given the
option to re-generate it. If selected, several options such
as destination and lines per page are again requested.
16. For reports that are being printed on a high-speed printer,
the user is presented several options relative to the
completion of this task.
Options include the user's box and account number, the output
report routing, type of printing device on uhich the report is
to be printed, and the number of copies of the report that are
to be produced.
Please note that the prompts issued relative to these options
are treated differently than all other 2UICK prompts. Standard
responses acceptable to other QUICK prompts (see Subsection
Effective Date: 10x01/89 Release Numbers 1.00 Page'-5-75
-------
II. below) may or may not be acceptable responses to these
prompts, or QUICK may act differently to a user's response
here than it does in other places.
For example, a user reply of an exclamation point (!) to a
* - -f
typical prompt in 9.UICK signifies that you may want to
discontinue the current report definition. Here* however, a
user reply of an exclamation point to any prompt will offer
the user the opportunity to cancel the printing of .the pending
report.
Another such example is in the manner in which 2UICK reacts
typically to a "null" user response (see Subsection II., item
S below) compared to how it reacts here. 9.UICK typically
permits a "null" response in only three instances, and it
•* t
reacts by asking the user to confirm the "null" reply. To
these prompts, on the other hand, QUICK treats a "null" reply
to mean ... -Do not alter the value that was previously
associated with the item being requested.
Effective Date: 10/01/89 . Release Number: i.QO -. Page: 5-76
-------
* Subsection II. Special notes relative to the use and operation of *
* fiuick *
Items relative to the use and operation of QUICK version 5.0 are as
follows!
1. Each time the user chooses the "(Q)uicklook" output processing
option of FRDS-II/Interactive, an opportunity is given to
display instructions about the QUICK report generator. When
the user replies "Yes" to this option, several things occur.
They are!
o The instructions are displayed;
o The user is given the opportunity to print a copy of this
Quicklook documentation;
o The user is given a lengthy introduction prior to the
initial "Data Element:" prompt for uhat to print in column
number 1 as well as prior to the initial "Data Element:1*
prompt for the very first data element on which the report
is to be sorted. Thereafter, an abbreviated form of this
introduction is displayed.
2. The opportunity to display instructions is given only once per
QUICK session. Therefore, a user uho produces more than one
report during a given QUICK session will be prompted for
instructions prior to defining the first report only.
At every prompt issued to the user by the QUICK report.
Effective Dates 10/01/89 Release Number-- 1.00 Pages 5-77
-------
generator, the- entry of a question mark (?) or the entry of
the uord "HELP" causes the display of more information about
the prompt issued. The prompt to uhich the "?* or the uord
"HELP" was entered as a response is then re-displayed.
. . *.
4. At nearly every prompt issued to the user by the QUICK report
generator, the entry of an exclamation point (!) permits the
user to discontinue the present report definition* if so
desired. If the user chooses not to continue the present
report definition* an opportunity is given to define a neu
?•
report or to return to FRDS-II / Interactive.
There are five (5) prompts to uhich the exclamation point is
not a valid response. They ares
o Mould you like to continue the report definition;
o Would you like to continue the.report generation;
o Mould you like to print uhat uas generated so far;
o Would you like to continue with the next page;
- and -
o ' Would you like to define a neu report.
Further, prompts that deal with documentation or report
printing on a high-speed printer (box, account number,
destination, priority, copies, etc.) react differently to an
exclamation point. To any of these prompts, an exclamation
Effective Date: 10/01/89 Release Number: 1.00 - Page: 5-78
-------
point causes QUICK to verify youz desire to cancel the print
request.
5. A null response (pressing the key as the sole response
to a prompt) is generally an unacceptable user reply to a
prompt. However, it is acceptable in four (4) cases.
They are:
o In response to the "Title:" prompt;
o In response to the "Column Heading:" prompt;
o In response to the "Data Element:" prompt when entering
data elements to print, the data element on uhich to
paginate, or data elements on uhich to sort;
- and -
o In response to the box, account number, destination,
priority, copies, etc. prompts when preparing to print the
documentation or report on a high-speed printer.
*
In the first three cases, the user is asked to confirm the
"null" response before being permitted to proceed.
In the fourth case, the value previously associated uith that
uhich is being requested remains unchanged.
6. At any "Data Element:" prompt issued to the user by the QUICK
report generator, the entry of a pound sign (#) is
synonymous uith a "null" response as described in the
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-79
-------
immediately preceding paragraph.
7. If a report is being displayed on the terminal and the
or key is depressed, the user is notified of the state
of completeness of the report and given an opportunity to
continue the display of the report at the point where it was
interrupted.
If the user chooses not to continue displaying the report* the
remainder of the report is cancelled and an opportunity is
given to regenerate the same report, define a new report, or
to return to FRDS-II/Interactive.
8. If a report is being generated (being output to a high-speed
printer), and the or key is depressed, the user
is notified of the state of completeness of the report and
given an opportunity to continue generating the report at the
point where it was interrupted.
If the user chooses not to continue the report generation, the
remainder of the report is cancelled and an opportunity is
given which permits the user to proceed with printing that
which was generated so far. Thereafter, the user is given the
opportunity to regenerate the same report, define a new
report, or to return to FRDS-II/Interactive.
9. If a report is being sorted, it cannot be interrupted.
10. When a data element to be printed contains code values, the
Effective Date: 10/01/89 Release Number: 1.00 Page' 5-80
-------
user is given the opportunity to print the code values or
their associated descriptions. If associated descriptions are
V-
to be printed, the user must specify how many characters of
the description are to be printed. If the number specified
exceeds the length of the longest description available for
that data element, the length of the longest description
"available is substituted for what uas specified.
11. When incompatible options are requested. QUICK decides what
options are to be used. For example:
<£ o Both Count and Sum totaling is requested but no suramable
data elements are specified to be printed ... Count only
is assumed;
o When Sum totaling only is requested but no sumraable data
elements are specified to be printed ...No totaling is
performed;
o When Sum totaling only is specified and a summary report
is requested but the user fails to select any summable
data element to be printed ... The summary report request
is ignored;
o When totaling is specified on a column specific basis and
a summary report is requested but the user fails to select
any totaling for any column ... The summary report request
is ignored.
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-81
-------
12. QUICK will produce either a single spaced or double .spaced
report based upon uhat the user has requested to be printed.
If any data elements from the CO data base record' (STATE-
SUnnARY) or the C100 data base record (PUS-SUMMARY) are being
printed, and a data element or data elements from any
descendant for the C100 data base record (C300, C400, CH80,
CSOO, C600, C700, C900, C1000, C1100, C1180, C1200, C1280,
C1350, C3000. C3100, C1000 or CH050) are being printed also,
the report will be double spaced. Otherwise, the report is
single spaced.
Effective Date: 10/01/89 .. Release Number: 1.00 Page:.5-82
-------
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
* Subsection III. Understanding the QUICK report *
*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
. jeneral, there is little about a QUICK report that should not be
easily understood by the user. However* a feu points are in order.
They are as follows*
1. Each QUICK report has five lines of heading information on
each detail page printed. These heading lines are centered on
the output report based on the maximum number of characters
per line specified by the user. The five lines contain the
following:
o Line 1 aluays reads. "FRDS-II Quick report Generator1*;
o Line 2 aluays contains the current Date (obtained form
the computer) and the page number of the report;
o Line 3 contains either the Title specified by the user or
the' 'tex.t. "Title Not Specified." Please note the
following uith respect to a user specified title:
If the user enters leading spaces in a title,
they will be ignored ... The user's response is
left-justified;
- and -
If the user•specified title has- multiple spaces
between tuo'uords, they will be translated into a
single space;
Effec'tive Date: 10x01/89 Release Number: 1.00 Page: 5-83
-------
o Line <4 contains either the report's sort sequence as
specified by the user or the text, "Order: Sort Not
Specified." If the Line contains a user specified sort
i
sequence, it uill appear as:
Order: Cnnnn/o Cnnnn/o ... Cnnnn/o
* *•
Uhere the "Cnnnn"'s uill be replaced with-the data element
number(s) of the data on uhich the report's data uas
sorted, and the "/o"'s uill be replaced with,the order
designated by the user for that data element's sort ...
either "/A" meaning ascending sequence of "/D" meaning
*.
.descending sequence.
If the number of data elements on uhich the report's data
uas.sorted consume more space than exists on the print
line -(as defined by the maximum number of characters per
line), only those sort data elements that uill fit on the
line uill be printed.
-. o Line 5 contains either the data element number on uhich
the report is being paginated and the value of the data
element being processed, or the text "For: Pagination not
requested."
2. If the user chose data element numbers, data element names, or
the user defined option for column headings, a blank line, a
line of column headings, and another blank line uill be
printed.
Effective Date: 10/01/89 . Release Number' 1.00 -Page: 5-8"*
-------
If the user chose the "No column headings" option (Omit), a
blank line will appear in place of the line of column
headings.
The column heading line is formatted as follows=
o If the data element number column heading option uas
chosen* data element numbers uill be printed above each
column in the format "Cnnnn" with periods on either side
of the data element number to delineate the columns' total
uidth;
o If the data element name column heading option uas chosen,
data element names (as defined for the FRDS-II data base)
uill be printed above each column with periods on either
side of the data element name to delineate the column's
total uidth;
- or -
o If the user defined column heading option uas chosen, the
column heading as entered by the user uill be printed
above each column. Please note the follouing uith respect
to user defined column headings:
If the user enters leading spaces in acolumn
heading, they uill be ignored ... The user's
response is left-justified;
- and -
- If the user's column heading has multiple spaces
Effective Bate: 10/01/89 Release Kumber' 1.00 Page-* 5-85
-------
between two words, they will be translated into a
single space.
3. Six notes are in order with reference to detail lines which
may appear on a QUICK report. They are:
o Data elements defined in the FRDS-II data base as character
data ( X(nn) ) are printed left-justified in a column;
o Data elements defined in the FRDS-II data base as numeric
data ( 9(nn) ) are printed right-justified in a column;
o Both character data and numeric data may be printed in an
edited fashion ... zeroes suppressed, commas and decimal
points inserted in quantitative values, slashes and dashes
inserted in dates and other data elements to improve their
readability (Refer to Subsection IV for a complete list
of data elements that are printed in an edited fashion);
o The appearance of an asterisk or asterisks in a detail
line column means that the data element that was to have
appeared in that column was not valued in the data base
(e.g., the system-zip code for a PUS was not reported to
EPA);
o The appearance of a space or spaces in a detail line
column means that the data element that was to have
appeared in that column did not exist in the data base
(e.g., the contaminant in violation uas to have been
Effective Date' 10/01/89 - Release Number' 1.00 Page/ 5-86
-------
printed, but a violation did not exist for the PUS);
' ' *
- and -
o The appearance of a ditto mark in a detail line column
means that the data element's value is identical to that
uhich appears on the previous line and that the value is
derived from the same data base record as the value on the
previous line. •
4. Each QUICK report has one or two lines of footing information
on each detail page printed. These footing lines follow a
single blank line and are centered on the output report based
on the maximum number of characters per line specified by the
user. The lines contain the SYSTEM 2000 "LOCATE" statement as
formulated by the FRDS-II /Interactive "A", "E", or "X"
function. In other words, the "LOCATE" statement designates
the subset of data that is represented on the report.
•• If the number of characters in the "LOCATE" statement consumes
more space than exists on tuo consecutive print lines (as
defined by the maximum number of characters per line X 2),
only that number of characters uhich will fit on the tuo lines
uill be printed (i.e.. the excess characters uill be
truncated).
5. Each 2UICK report that is produced uhen any totaling option is
in effect has a grand total page produced as the final page of
the report. Further, if pagination was requested, at least
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-87
-------
one sub-total will be produced. There is a sub-total produced
for each'change in value of the pagination data element's
value.
Either one or tuo lines are produced ior a total ... two if
both count and sum totaling are in effect* one otheruise.
A total line is identified by "Cnt1* for the Count Total or
"Sum" for the Sum Total appearing in the right hand margin.
6. If the user chooses to print the Q.UICK report on a high-speed
printer..a "General Information Report" page or pages is
produced. A report displayed on the user's terminal has this
section of the report produced only at the user's request.
The "General Information Report" page or pages of the report
is self-explanatory with three exceptions.:
o For data elements that have been printed, used for
pagination, and/or used to order the QUICK report, the
first twenty positions of the data element name are
printed or displayed (i.e., positions 21 - 30 of the data
element name are truncated).
o For data elements that have been printed, the letter which
appears beneath the headings "Cnt" and "Sum" means:
"Y" means this type of total has been produced for
this data element
"H" means this type of total has not been produced for
Effective Date: 10/01/89 Release Number* 1.00 Page: 5-88
-------
this data element
Foz data .elements that have been printed, used for
pagination, and/ox used to oxdez the 2UICK report, the
number which appears beneath the heading "Length1* means2
The number of characters of this data element's code
value description which have been printed, used in
pagination, or used to order the 2UICK report
- or -
The number of left-most characters of data elements
, t
which contain textual data that have been printed
If the user chose to print the QUICK report on a
high-speed printer, interrupted the report generation
before its logical conclusion, and proceeded to print
what was generated prior to the report's interruption,
the standard footing lines for the last page are
replaced with the text, "Report generation cancelled"
and the remainder of the report is absent.
Effective Date: 10x01/89 . . Release Number: 1.00 Page: 5-89
-------
* Subsection IV. Data Elements that axe displayed in an edited *
* fashion *
i . The following data elements are listed uith leading zeros
suppressed and commas inserted, as needed. Example: A
population served of 00001250 would be listed as 1.250.
C117 PWS-RETAIL-POP-SERVED
C1H7 PWS-SERVICE-CONNECTIOHS
C 1 1 1 1 VIO-COItP-PERIOD-nONTHS -
C1127 VIO-SAMPLES-REfiUIRED
C1129 VIO-SAMPLES-TAKEN
C1139 VIO-ACTUAL-DURATION-MONTHS
C1353 MCP-UINDOU-nOHTHS
C1359 NCP-HCL-VIOLATIONS
C1361 KCP-nCL-DURATIOM
C1363 MCP-MOH-VIOLATIONS
C1365 MCP-rtON-DURATION
C1367 KCP-EHF-ACTIONS
C3029 VE-ALT-MOK-FREfi
2. The following data element is listed with leading zeros
suppressed and commas inserted* as needed. Example1 A
river reach mile of 0123.to would be listed as 123.10
C431 PUS-SE-REACH-MILES
3. The following data elements are listed with leading zeros
suppressed, as needed. Example: An analysis result of
of 0001234.5670000 would be listed as 1234.5670000
C1123 VIO-ANAL*SIS-RESULT
C1125 VIO-MCL-VIOLATED
C3013 VE-MOD-MCL
CH007 SDD-eUANTITY
Effective Date5 10/01/89 . .Release Number: 1.00 Page: 5-90
-------
The following data elements are listed with leading zeros
suppressed, as needed, followed by a blank and percent
symbol. Example: A surface percentage of 035 would be listed
as 35 7.
C121 PUS-PCT-SURFACE
C123 PUS-PCT-GROUHD
C12S PWS-PCT-PUR-SURFACE
C127 PWS-PCT-PUR-GROUND
5. The following data elements are listed with a slash inserted
between the year and the month. Example: A system begin
date of 8906 would be listed as 89/06
Ct11 PWS-SYSTEM-BEGIN-YYnM
C113 PWS-DEACT-YYMM
C1351 NCP-WIHDOW-BEGIN-YYMH
6. The following data elements are listed with a slash inserted
between the month and the day. Example» A season begin date
of 0315 would be listed as 03/15
C159 PWS-SEASON-BEGIN-MHDD
C161 PWS-SEASON-END-MMDD
7. The following data elements are listed with slashes inserted
between the month and day, and day and year. Example: A last
update date of 061889 would be listed as 06/18/89.
C7 ST-ANY-DATA-LAST-UPDATE
«
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-91
-------
C9 ST-INV-LAST-UPDATE
C13 ST-VIO-LAST-UPDATE
.CIS ST-ENF-LAST-UPDATE
C17 ST-VE-LAST-UPDATE
C167 PUS-INV-LAST-UPDATE
C168 PWS-INSERT-DATE
C169 PWS-AHY-DATA-LAST-UPDATE
C703 PWS-VISIT-DATE
C903 PWS-HI5T-CHANGE-DATE
C1107 VIO-COI1P-PERIOD-BEGIN-DATE
C1109 VIO-COMP-PERIOD-EXD-DATE
C1115 VIO-AUARE-DATE
C1117 VIO-INSERT-DATE
C1133 VIO-LAST-UPDATE
C1111 VIO-RESOLVED-DATE
C1183 VIO-LIKK-EMF-DATE
C1203 EMF-ACTION-OATE
C1207 ENF-LAST-UPDATE
C1213 ENF-INSERT-DATE
C12S3 ENF-LINK-RANGE-BEGIN
C12S5 ENF-LIKK-RANGE-END
C1287 ENF-LIMK-PERIOD-BEGIN
C3007 VE-EFFECTIVE-DATE
C3009 VE-EXPIRATIOH-DATE
C3021 VE-LAST-UPDATE
C3033 VE-IMSERT-DATE
C310S VE-SCHED-DATE
C3107 VE-SCHED-ACCOtlP-DATE
CU009 SDD-DATE
C40SS DBA-DATE
8. The following data element is listed with dashes inserted
between the water resources region and subzegion, sub-region
and accounting unitf accounting unit and cataloging unit, and
cataloging unit and river reach segment number. Example* A
river reach number .of 15020304007 would be listed as
15-02-03-0<*-007
CH27
PWS-SE-RIVER-REACH-NUM
Effective Date: 10/01^89
Release Mumber= 1.00
Page* 5-92
-------
9. The following data element is listed uith dashes inserted
between the degrees and minutes, and minutes and seconds.
Example: A latitude of 38*4120 would be listed as 38-
-------
be listed as AK-68235
C4 ST-IND-RES-CODE
C515 PWS-GA-IND-RES-CODE
14, The following data elements axe listed uith a dash inserted
between the fiscal yeaz and the 10. Example: A violation ID
of 8912345 would be listed as 89-12345
C1101 VIO-ID
C1131 VIO-LIMK-EXr-ID
C1201 ENF-ID
C1281 ENF-LINK-VIO-ID
C3001 VE-ID
15. The following data elements aze listed with a dash insetted
between the ZIP code and the ZIP+4, if the ZIP+4 is present
Example: A ZIP code including a ZIP*4 of 803036053 would be
listed as 80303-6053
C141 PWS-SYSTEH-ZIP
C315 PWS-AD-ZIP
16. The following data element is listed with a dash inserted
between the telephone exchange and number, if the area code is
not present. Example: A telephone number of 5561411 would be
listed as 556-1411
- or -
If the area code is present, the data element is listed uith
parentheses surrounding the area code, a blank
Effective Date: 10/01/89 Release Number' 1.00 Page: 5-g«*
-------
preceding the telephone exchange, and a dash inserted between
the telephone exchange and number. Example: A telephone
number of 7035561(411 uould be listed as (703) 556-1111
C143 PMS-PHOHE
17. The following data element is listed with a "T^" prefix.
Example: A township of 0 1 SH would be listed as T.015N
C«H9 PWS-SE-TOWNSHIP
18. The following data element is listed with a "R." prefix.
Example: A range of 125U uould be listed as R.125U
C«»21 PWS-SE-RAHGE
The following data element is listed with a "Sec." prefix
Example: A section of 25 uould be listed as Sec. 25
C423 PUS-SE-SECTION
20. The following data elements are listed with a left parenthesis
prefix and a "1/4)" suffix. Example: A quarter section of SE
would be listed as (SE1/4)
CU25 PWS-SE-2TR-SECTION
C426 PWS-SE-2TR-2TR-SECTION
Effective Dates 10x01/89 Release Number' 1.00 Page: 5-95
-------
* Subsection V. Example QUICK on-line session and example QUICK
* Report (Partial output produced as a result of
* The example on-line session)
**•••
The example QUICK on-line session begins on the next page.. It • is
immediately followed by the example QUICK report.
Effective Date: 10/01/89 Release Number: 1.00 Page.* 5-96
-------
FRDS/Xnteractive
Post Retrieval Output Option* nenu
(B) Batch Job Submission
(F) Frequency Distribution
(LI List in Standard Screen Format
(Q) Quieklook Report Generator
(El End Pest Retrieval
—> Enter the Code which corresponds to the desired Post Retrieval
Output Option: Q
Heleoae to the Quieklook Report generator
Version: 5.0 (Initial CROS-IZ version)
ne/dd/yy hh.M.s*
Mould you like instructions on the use of the Quieklook Report Generator?
IYles or tN)o: Y <-
This output processing option permits you to design • report according to your
~—• specifications.
In particular* you will be asked to define the report formatting
characteristics* what data elements are to be printed* how the report is to be
paginated* Sow the report is to be ordered* and whether you want to view the
report at your terminali or have it printed on a high-speed device. Also* note
that you may print* paginate* or sort on most any FROS-XX data element so long
as all data elements specified belong to the same data base family.
Xf you do not understand any prompt issued* enter a question mark (?) or the
word "HELP" to obtain more information.
Xf you want to stop the Report Generator* enter an exclamation point (!) in
response to any prompt* or press the / key to interrupt a
printing report.
Press the key when you are ready to proceed ...
*
—> Would you like to print a copy of the Quieklook documentation?
(Yles or (N)o: N <-
—> Enter the maximum number of characters per line: 132 -<-
--> Enter the maximum number of lines per page: 55 <-
—-> Enter the minimum number of spaces to appear between columns: 2 <-
continuea on next oaae
Effective Date: 10/01/89
Release Number: 1.00
Page: .5-97
-------
continued from previous page
-> Mhat title would you like to appear on the report?
: Pennsylvania Community-Active-Current PMSs with TTHtl Violations
-> Mhat type of column headings would you prefer?
Date element number (S), data element (N)ams. (U)ser-defined by column.
or (O)mit: U <-
-> Where should the report be genereted?
On your (Tier-mine! or a High-speed (P)rinter: P <-
5
6
For each data element printed, what type of totaling would you prefer?
(Oount. (Slum. (B)oth (i.e.. count and SUM). (U)ser-defined by column.
._ / »j » _. . ^ n ^
(H)
: U
< --- 7
Mould you like a •unary report only?
Mould you prefer repeat suppression?
(Ties or (N)o: N
(Ties or (Nlo; HELP
0
9
Enter a single letter which indicates your desired response to the question*
than press the key.
Enter the letter "Y" (Yes) if you want to suppress the printing of identical
data which comes fro* the same record in the data base, or the letter "N" (No)
if printing a ditto mark in place of the identical data is unacceptable.
—> Mould you prefer* repeat suppression? (T)es or (N)o: Y <-
pleas* specify what data is to be printed in each column (fro* left to
right) of the report.
You may enter either a data element nu*ber or data element nane in response to
the following "Print data element:" prompts. When you are finished specifying
what you want printed* enter a pound sign (•) in response to the "Print data
element:" prompt, then press the key.
«< Coition 01 >» (129 characters remain on the print line)
— > Print data element: PHS-1D
— > Totaling choice for this data element? (C)ount or (N)one: N
— > Column Heading: System 10
<« Column 02 >» (117 characters remain on the print line)
— > Print data element: C131
— -> This data element contains textual data. Mould you like to print the
(L leftmost or IAU1 of its characters: L
— > Nueber of characters (leftmost) to print: 25
— > Totaling choice for this data element? (C)ount or (N)one: N
— > Column Heading: System Name
«< Column 03 >» 1090 characters remain on the print line)
— > Print data element: C117
— > Totaling choice for this data element? (C)ount only, (S)um only*
(B)oth (i.e.» count and sum)> or (N)one: B
--> Column Heading: Population
continued on next oaoe
<
<
<
<
11
12
13
Effective Date' 10/01/89
Release Number: 1.00
Page: 5-98
-------
continued from previous pag*
<« Coluan 04 >» (075 characters remain on the print line)
—> Print data element: C1107
--> Totaling choice for this data element? (Oount or (N)ooe: N
~> Column Heading: Viol. Oat*
«< Column 05 >» (063 characters remain on the print line)
—> Print data element: C1105
--> This data element contains cod* values. Uould you like to print the
(Clod* values or their associated (D)escriptions: C
—> Totaling choice for this data element? (Oount or (N)one: N
--> Column Heading: Type
<« Column 06 >» (057 characters- remain on the print line)
--> Print data element: VIO-COKTArtlNAHT
—> This deta element contain* cod* values. Uould you like to print the
(C)oda values or their associated (descriptions: 0
--> Number of characters (leftmost) of th* description to print: 25
~> Totaling choice for this date element? (Oount or (Nlonei C
—> Column Heading: Contaminant
<« Coluan 07 >» (030 characters
—> Print data element: C1205
•in on the print line)
The data element entered doe* not reside in the »a*e data IMS* family as
previously entered data elements
< 15
«< Coluan 07 >» (030 character* remain on th* print line)
—> Print data element: CUSS
--> This data element contains cod* values. Uould you like to print th*
(Clod* values or their associated ((Descriptions: D <- - - 16
—> Nurrber of characters (leftmost) of th* description to print: 30
—> Totaling choice for this data element? (Oount or (N)one: C
—> Column Heading: Action Taken
Insufficient spec* remain* on th* print line for you to enter additional date
elements to print ...
Your report's print definition is complete ... <- - - 17
--> Should the report have a net* page started for each change in value of
e particular data element? (Ties or (N)o: ? < Ifl
Enter a single letter which indicates your desired response to th* question,
then press the key.
Enter the letter "Y" (Yes) if you want to start a new page when the value
associated with a particular data element changes, or the letter "N" (No] if
you are not interested in this feature.
continued on next oaae
Effective Dates 10/01/89
Release Number: 1.00
Page: 5-99
-------
continued from previous page
-- > Should the report hav* a D«M page started for each change in value, of
• particular data •lament? CYJes or (N)o: Y
— > Paginate data element: C119 . <- - - 19
— > Thi» data eleeent contains code values. Would you like to paginate on
• the (C)ode values or their associated ((Descriptions: 0
— > Nuober of charaeteni (leftmost) of the description on. which to
paginate: 40
the data eleeent you chose Mill be used as the initial date el
your report Mill be sorted.
on which
Therefore* you oust choose
ascending or descending).
the order in which it Mill be sequenced (i.e..
(A)scending or. (descending order: A
<- - 20
— >
Mould you like your report to be sorted on anything other than the date
element on which your report Mill be paginated? (Y)es or (N)o: Y
Specify the order in which you want your report to be sorted.
This ?• accomplished by entering either a data element number or data element
name in response to the following "Sort data element:" prompts. You should
enter the most important data, element.on which to sort first, the next most
important data element next, and so on.
When you are finished specifying the desired report sequence• enter a pound
sign (t) in response to the "Sort data element;" prompt* then press the
key.
<« Sort t 02 >»
—> Sort data element: C101 <-
—> (A)scending or (Diescending order: A
<« Sort • 03 >»
—> Sort data element: C1107
—> (A)scending or (O)escending order: A
<« Sort t 04 >»
—> Sort data element: VIO-CCKTXMINANT
—> This data element contains code values. Would you like to sort on the
(Ctode values or their associated ([Descriptions: D
—> Nusber of characters (leftmost) of the description on which to sort: 40
—> (A)scending or (D)escending order: A
<« Sort f 05 »>
—> Sort data element: VIC-TYPE
--> This data element contains code values.
(Oode values or their associated (D)«
—> (Alscending or ((Descending order: A
<« Sort * 06 »>
—> Sort data element: t
Would you like to sort on the
scriptions: C
<- - 22
21
continued on next okoa
Effective Dates 10/01/89
Release Number! 1.00
Page: 5-100
-------
continued fro* previous page
—> Please confirm ... Are you finished entering data elements on leSich to
sort? (Y)es or (N)o: Y <- - 23
Your report's sort definition is complete ...
Your report is now being sorted
Pleese do not interrupt !!!
.Sort successfully eoepleted ...
Your report' is not* being generated ...
To interrupt* press the / key
Press the Kay when you »re ready to proceed ..
Report File Disposition - (K)eep for later printing or (Olelete:
No*:
—> 0
Your current Job parameters are:
FZHA3 10: FRDSD
Destination: HOLD
Bin/Box: nXBH
Estimated Tina: Short
Priority: 4
Printer Type: Destination
Report File Disposition: Delete
Copies of Report: 01 '
--> Are these parameters correct? (Y)e* or CNlo? Y
Job 6601 Submitted ...
Report generation successfully completed ...
—> Would you like to re-generate the report just produced?
(Y)es or Mould you like to produce another Quicklook report? CY)es or (N)o: N <- -
Exiting the FRDS Quicklook Report generator ...
continued on next oaoa
25
26
27
Effective Date: 10/01/89
Release Number: 1.00
Page: 5-101
-------
continued fro* previous page
Note key ... as referenced on previous peg**
1< Option 'Q1 i* chosen fro* the Post Retrieve! Output Options Menu.
2< User requests that Quicklook instructions be displayed.
3<- - - A printed copy of the Quickloek documentation is available at
the user's discretion.
4<- - - The user specifies the physic*! size and spacing of the report
to be generated by Quicklook.
5<- - - The user opts to specify his/her OOT column headings.
6<- - - The Quicklook report will be printed on the high speed printer.
7<- - - User also opts to determine 'his/her owt totaling, controls.
ft< A "detailed" report is requested.
9<- - - User requests HELP in explaining "repeat suppression."
10<- - - Repeat suppression is chosen by the.user.
11<- - - Quicklook automatically calculates remaining line space available.
12<- - - User specifies the data element to print in column I.
IK User specifies the totaling feature(s) desired.
14<- - - user specifies his/her otet eoluen heading.
15<- - - User is reminded of the "samm family" restriction of Quickloek.
l»<- - - Descriptions of coded values are chosen to be presented instead of
the codes theeselves.
17<_ . . The Print definition phase is automatically concluded i*en remaining
columns are exhausted.
lfl< Kelp and "?" are synonymous.
19<- - - Page control breaks on C119 (i.e.i primary source code) is chosen.
20<- - - The report Mill be sorted in ascending primary source sequence.
2K- - - Secondary sort fields O02 - SOS) are specified.
ZZ<- User notifies Quicklook that all sort specifications are completed.
23<- _ - Confirms that all sort specifications have been completed.
24< user tells Ouicklook to delete report file after it is printed.
25<- - - The user verifies that the report routing information is correct.
26<- - - The user opts not to have this report regenerated.
27<- - * Quicklook is notified that this report generation session is completed.
Effective Date-' 10x01/89
Release Number1 1.00
Pages 5-102
-------
Si?????
•a— — .• .«> —
«. ****»f*; ^^>
a i» «• +• .c C • « Z
» c^ « ••»• 1 «•*••*•
-3 it
c
>
(O
X
**
4
-; f ; -5
O r « * C
tt «• A •«••»•
II
*
Effective Date5 10/01/89 Release Number: 1.00 Page: 5-103
-------
s
u
*
M f
i C •
« 1 -J
s 3s*s:i*=
II
a t»
SI'S J! "8
0 £ 5 «• *
•""
«l- >i * m Q 9 Q *~ ^ • > *"*
*" I. "i1? S-2 -2*"° ** "^^Sf
fi QE 9 ^ X 8* *^ fv f! S M
| I sll *^!r:si |s t :if
! | ||| ^|]|^| S| |f;*|
3l-g .. __._..««_^
S3 O 9 M
« *• fe-*
s •SBL ' 2
* * !; f
U
u
o
-
I*
o
Effective Date: 10/01/89 Release Numbers 1.00 Page: 5-10t
-------
I
a.
2oou
tt«i«
oc OE oc K EC a a IK neat ac ae a a K at K ac at — — — —
* 8SS!!.Ijjllj.ilj.iljjjjs -«>>>>>>>»>
+*+*+*+*+*+*+*+*-+*+*+*+*+*+*+*+*+*4* ** 4* 0 «f 4) 41 41 4 41 9 9
nHN Vio
C 11 OS/ A
ied
Ji 5?l i
m wi
I103
-pur
e • <• i
1 1:1
*.^.
S2i
>.-«•*•
L. U •
1^1
- •
8588
=:=^=== = = = 8
—
o M * *
~-« 5 t
3-2
c c
-J 1.
** 5
a i.i 4 *!.§
sS5*'i.ST SS^'c
• •- IB oi-o-ooiuB>
-J
"*
o i.s 41 xl.§
•'-
*•
I
K
| >2a
iiT - * B a —
i minminmMi'iMMMfMi'tmmmritinfMmuiuiiAiAiAtMrMminMfnHiiAiAitmmMmmiMiAMmKti
3% OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOl
•
*
s
i
u
I
in
Is"
S " C
(j I. O
• Ik
• "a
•~ t.
e o
«o«i(Oaio»^***>f>»'"«-«-«««-<-«"«<"'**«»''*'»*-ai»*'*'»* Q.
Effective Date: 10/01/89
Release Number' 1.00
Page: 5-105
-------
8.
•
IX
on*
o
4*
•
I.
U
«M
1
at
•g
« o O
«• a '<9
u u
< II
1 •<
>x *
•»* o* »^
S"" 2 S
o u
Iw"
5 » t.
U (. O
,-s^
cS
•
>
— t
>
j
I
us
• •
MUUOOUUU
Notice
Achieved
8 5 -a-av
- - - - — >>~>>>ii >>*
ie'eeeeeeeeeeeeee*'** ee
,_ am ._ ._ ._ ._ .f, ._ ... ._ ._ .— ... ... . w • • ... .— .— .— ,~ •<- .- .5
•g-g-g-g-g-g-g-g-g-g-g-g-g-g-g-g-;-. i-g-g-s-g-gjjj
<<<<•<•<•<••<<<<<•<•<•<•<•<•< J H <<<<<^<<
-s-sgggggsss s§ !!?£3&gi!Sgili!i!§S?i!>:p3 HilgiiS
uu«>**-*-*^ •"»•»•<• — • •••••••••••••••noo •«••••«
o
>0
11111111111111! n I
ouuuuuuuuuuuuuuu i- i-
u u u u u u u i
lori
ene
ene
TThe
Col i fore
Benzene
Carbon Te t
P-Dichloro
Trichloroe
Vinyl Chlo
1,1-Dichlo
1,1,1-Tric
1, 2-0 ichlo
TThM
re
5
M
Ou
a .2,S5.3c2 ?li.3«.£ ,
sS| -IJirihH^jfn"
JO p L.»Z«XC'H«0«— «— O
u i- < a B u u wu. J c c z w «i i-
e c 3 a— •.- u
SS'Co-g^!'
C t. n X «X C^
uixio»'<»T*'ai-i"« -*•»'**•»'•»'«»••*•*
OOO J«ICUN«, <
in a.
M
u
II
M
n
ii
H
»
ii
ii
TESIAN HTR CO
NEHT
09
:::::::::::::::
a.
a.
a
0
HTR OEPT
QUAKERTOHN
S2
Effective Date- 10/01/89
Release Number: 1.00
Page: 5-106
-------
s,
s.
j
I
i
I
.
2 858
.
2858
«
•g
1
M
I
in
o
DC
li
£3
f-U
£?*
.- n •
:s«
1:1
525
i. «• •
]» Cfe' II ** ^ 0** O1* ^* ^^ "* ^ ^ ^ ^ ^ ^ ^* ^ ^^
'^ S O- Q ?NN*NNNNNN*??N*
ULJp^ WMp^p^*M»«p««^w^w^«****^*^p^*«
<•* • ooooooooooooooo
I^C* -I VNXNXNN.NNN-VXXNN
>%.(J O ~i^~-i-*&& > •! N J — O • > I - t —
£ £-* — ea C «- a •- £ C — ^ w -«
C.Z*«-3«i c. i-.- - - . O
t>-. — — a>uo.i-U>-. — — o
o
u
£
Cf
w
u
s
::::::
o-
in
•*t
Q.
Effective Date' 10/01x89
Release Number: 1.00
Page: 5-107
-------
in
•o
s
«
in
ui
...2 .**&
• X*Q p-^-0
*• *• * 1
24. a *• N •
» 3 o * M
• C m *• «- ^
• U .- I 3 A
M c a • j n**
™ — * £ 3 •• o
• M a*- ••«•*•
• -H- a.
in
*
|
£
o
E
fit
III
VI
Effective Date: 10/01/89
Release Number2 1.00
Pages 5-108
-------
5.2.11 Option "T* - Totals of PUS Information - Totals
Inventory Summary and Totals Violation
Summary Report (Hot Available)
Effective Date: 10/01/89 Release Number: 1.00 Page: 5-109
-------
5.2.12 Option '£' - End Post-retrieval
Option '£' of the Post-retrieval Processing Options Menu permits
the user to exit the post-retrieval processing options
capability and return to the prompt for a Main Menu selection.
The sample session on the next page shous hou to use Option '£'.
Effective Date: 10/01x89 Release Number: 1.00 Page: 5-110
-------
FRDS-II/Interactive
Post Retrieval Output Options flenu
3333333S23S333S833353as33333333333S33S333S33SS3333S38
CB) Batch Job Submission
(F) Frequency Distribution
(L) List in Standard Scr**n Format
(9) Quicfcloak Report S«n«-«tor
IE) End Pest R*tri«v«l
—> Enter th« Cod* which corresponds ta tha dasirad Post Retrieval
Output Option: •
--> Enter Function Code, END> or MENU:
1 <- - - The user enters «n '•' to end Post-Retrieval processing.
2 <- - - The user nay chaos* a Main Menu function.
Effective Date: 10x01/89
Release Number: 1.00
Page: 5-111
-------
-------
SECTION A
APPENDIXES
Effective Date: 10/01/89 Release Number: 1.00 Page: A-1
-------
SECTION A - APPENDIXES
A-1 Appendix A
The following symbols, keywords and/or keys are used throughout
FRDS/Interactive. They have been included in this document as a
ready reference.
1. Special Symbols/Keywords/Keys
? Display Help, if available
HELP Display Help, if available
! Stop the world ... I wanna get off
t I'm done ... proceed with the next step
BREAK Interrupt what is going on ( ASCII line-by-line
devices )
ATTN Interrupt what is going on ( 3270 full-screen
devices )
RETURN Press after user response ( ASCII line-by-line
devices )
ENTER Press after user response ( 3270 full-screen
devices )
Effective Date: 10/01/89
Release Number: 1.00
Page: A-2
-------
2. Special keywords recognized at the FRDS/Interactive prompt
which reads ... Enter Function Code, END. or MENU!
END
BUILT
MENU
Exit FRDS/Interactive .
CLIST menu
Exit FRDS/Interactive .
CLIST menu
Display Main Menu
return to FRDSON
return to FRDSOK
END and fiUIT are Synonymous uith function code o ( i.e., zero )
3. Special Symbols/Keywords recognized during the "Assisted1*
preparation of a Locate statement Main menu function ...
REVIEW Review the Locate statement constructed so far
GREATER Advance to the next sub-group. If no further
THAN sub-group exists, advance to the next group question
(» ( i.e., go forward ). If no further group exists,
display the Locate statement constructed, ask if
okay, execute it or submit a batch job using the
constructed Locate statement.
CARET Advance to the next group ( i.e., go up ). If no
(UPPER further group exists, display the Locate statement
CASE 6) constructed, ask if okay, execute it or submit a
batch job using the constructed Locate statement.
Effective Date: 10/01/89
Release Number: 1.00
Page: A-3
-------
SLASH Separates multiple responses to a .data base value
(/} prompt ... ( e.g., CAC / CAH / NAG / NAH ). Multiple
responses are OR'ed together.
COMMA
ASTERISK
(*)
Intermediate/Advanced users only ... Separates
multiple responses to a menu prompt ... ( e.g., C103
, C115 , C119 ). Multiple responses a.re AHD'ed
together.
Used in conjunction with a response that is a range
(i.e., SPANS value 1 * value2, Efi value! * value2,
value 1 * valueZ ).
Eft HE May be used in conjunction with response to a data
6T GE base value prompt. For example:
LT LE
SPANS .
EXISTS FAILS LT 500 / SPANS 1000*5000 / GT 10000
LT 500 / E2 1000*5000 / GT 10000
LT 500 / 1000*5000 / GT 10000
Cnnnn
ALL
Intermediate/Advanced users only ... A data base
record or data element number to "DIRECT" what
prompts from that group of sub-group are to be
issued, and, in what order.
Intermediate/Advanced users only ..- shortcut for
indicating that you uant to consider ALL sub-groups
displayed or ALL data elements displayed.
Effective Bate: 10/01/89
Release Number: 1.00
Page:
-------
HONE Intermediate/Advanced users only ... shortcut for
indicating that you want to consider NONE .of the
sub-groups displayed or NONE of the data elements
displayed.
1. Special Symbols/Keywords recognized during the 'X' and *Z
(i.e.* Type your oun) Locate statement preparation Main
menu function.
EXIT Leave the 'X1 or 'Z1 function
?? Display Locate statements presently defined. If
using the 'X* function* the number of records
selected are displayed also.
Effective Date: 10/01/89 Release Number: 1.00 Page: A-5
-------
|