United States Office of Water EPA 812-B-93-001
Environmental Protection (WH-550) January 1993
Agency
v®/EPA Federal Reporting Data
System (FRDS-II)
Interactive Retrieval
Guide
Printed On Recycled Paper
-------
S DC-0055-005 -LN -2005
December 31, 1992
FEDERAL REPORTING DATA SYSTEM (FRDS-II)
INTERACTIVE RETRIEVAL USER'S GUIDE
CONTRACT NO. 68-W1-0055
DELIVERY ORDER NO. 0055-005
Prepared for:
United States Environmental Protection Agency
Office of Ground Water and Drinking Water
401 M Street, S.W.
Washington, D.C. 20460
Delivery Order Project Officer: Abraham I. Siegel
Prepared by:
EPA Systems Development Center
(A Contractor Operated Facility)
Science Applications International Corporation
200 North Glebe Road, Suite 300
Arlington, VA 22203
-------
SDC-0055-005-LN-2005
December 31, 1992
SAS, SAS/FSP, SAS/GRAPH, SAS/IMS-DL/1, SYSTEM 2000, SAS Communications, and
SAS Views are registered trademarks of SAS Institute Inc., Cary, NC, USA. SAS/ETS,
SAS/OR, SAS/REPLAY-CICS, SAS Training, and SASware Ballot are trademarks of SAS
Institute Inc.
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Federal Reporting Data System (FRDS-II)
Interactive Retrieval User's Guide
Release Log
Note: All change notices/descriptions that relate to the FRDS-II Interactive Retrieval User's Guide
should be filed immediately following the Release Log.
Release
Number
Effective
Date
Description of Release
1.00
10/01/89
Initial Release of Production Documentation
2.00
12/31/92
Revised Release of Production Documentation
Effective Date: 12/31/92
Release: 2.00
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
CONTENTS
Section I Introduction .... L-l
1.1 Purpose 1-1
1.2 Background 1-1
1.3 Constraints 1-2
1.4 User Profile 1-3
1 5 Organization of the Interactive Retrieval System User's Guide 1-4
Section 2 System Summary 2-1
2.1 System Overview . . . ... 2-1
2.2 Retrieval Overview ... 2-2
2.2.1 Establishing The Search Domain 2-2
2.2.2 Searching The Data Base 2-2
2.2.3 Extracting And Presenting The Data 2-3
2.3 Operational Environment 2-3
2.4 Equipment 2-5
2.4.1 Basic Equipment 2-5
2.4 2 NCC Requirements 2-5
2.4.3 User Support Staff Requirements 2-5
2.4.4 User's Own Staff Requirements 2-5
2.5 Security 2-6
Section 3 System Operation 3-1
3.1 Initiation Procedures 3-1
3.1.1 Logon Information 3-1
3.1.3 Telecommunications for PC Users 3-2
3.1.4 Full-Screen or Line-By-Line Access 3-2
3.1.5 Logon in Case of Terminal Disconnection 3-8
3 2 Operational Procedures 3-8
3.2.1 Executing FRDS-II/Interactive 3-8
3.2.2 Description of the Production Menu 3-9
3.2.3 Beginning FRDS-II/Interactive 3-9
3.2.4 Message Updates 3-9
3.2.5 Special Purpose Keys 3-11
3.2.6 FRDS-II/Interactive Session Cancellation 3-15
3.3 Error And Recovery Procedures 3-15
3.4 Exit Procedures 3-15
Effective Date: 12/31/92 Release: 2.00 i
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
December 31, 1992
Section 4 Using The Main Menu 4-1
4.1 Description Of The Main Menu 4-1
4.2 Main Menu Selections 4-2
4.2.1 Function '0' - To Terminate FRDS-Il/Interactive 4-4
4.2.2 Function 'A' - Assisted (Prompted) Query 4-6
4.2.3 Function 'D' - Display Of FRDS-II/Interactive Broadcast or System
Messages 4-24
4.2.4 Function 'E' - Retrieve PWSs Whose IDs Are In An External File . . . 4-26
4.2.5 Function 'G' - Obtain Geographic Information For A Specified City, County,
Or U. S. Postal Service (USPS) Zip Code 4-28
4.2.6 Function 'P' - Post Retrieval Output Options 4-30
4.2.7 Function 'S' - Enter The System 2000 Self-Contained Facility (Natural
Language) 4-31
4.2.8 User-defined Query 4-37
4.2.8.2 Function 'X' - Formulate Non-prompted Retrieval Selection Clauses4-37
4.2.8.2 Function 'Z' - Formulate Non-prompted Retrieval Selection Clauses4-40
Section 5 Using The Post Retrieval Output Options Menu 5-1
5.1 Description Of The Post Retrieval Output Options Menu 5-1
5.2 Post Retrieval Output Options Menu Selections And Report Examples .... 5-1
5.2.1 Option 'B' - Batch Job Submission 5-3
5.2.1.1 FRDS01 - Public Water System Comprehensive Report 5-4
5.2.1.2 FRDS03 - Public Water System Service Area And Source Area
Report 5-9
5.2.1.3 FRDS04 - Surface Water Treatment Report 5-13
5.2.1.4 FRDS07 - Facilities and Population Served by Primary Water Supply
Source 5-18
5.2.1.5 FRDS17 - Follow-up Actions Report 5-22
5.2.1.6 FRDS 19 - Violation Summary By Population 5-29
5.2.1.7 FRDS20 - Violation Summary By Primary Water Supply Source 5-33
5.2.1.8 FRDS24 - Public Water Supply System Summary And Violation
Data 5-35
5.2.1.9 FRDS31 - PWSs Months In Violation 5-38
5.2.1.10 FRDS32 - Grant Eligibility Report 5-46
5.2.1.11 FRDS35 - Annual Data Evaluation 5-54
5.2.1.12 FRDS43 - Non-Compliance Report 5-60
5.2.2 Option 'C' - Create A Flat Sequential File 5-67
5.2.4 Option 'L' - List in Standard Screen Format - Reports for Suboption
Screens 5-76
u
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC -0055-005 - LN-2005
December 31, 1992
5.2.5 Option 'Q1 - Quicklook Report Generator 5-82
5.2.5.1 Subsection I. Characteristics Of The QUICK Report That Are
Controlled By The User 5-83
5.2.5.2 Subsection II. Special Notes Relative To The Use And Operation Of
QUICK 5-89
5.2.5.3 Subsection III. Understanding The QUICK Report 5-93
5.2.5.4 Subsection IV. Data Elements That Are Displayed In An Edited
Fashion 5-98
5.2.5.5 Subsection V. Example QUICK On-line Session And Example
QUICK Report 5-103
5.2.6 Option 'E' - End Post Retrieval 5-115
APPENDIX A Special Symbols/Keywords/Keys A1
Effective Date: 12/31/92 Release: 2.00 iii
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
EXHIBITS
FRDS-II STRUCTURE CHART 2-4
COMMUNICATIONS PROTOCOL 3-2
FULL SCREEN LOGON 3-3
FULL SCREEN TSO LOGON 3-4
LINE-BY-LINE LOGON MODE 3-5
EXECUTING FRDS-II/INTERACTIVE 3-6
EXECUTE FRDS-II/INTERACTIVE 3-10
BROADCAST MESSAGES 3-13
SYSTEM MESSAGES 3-14
LOGOFF 3-15
MAIN MENU 4-1
FUNCTION '0' 4-5
FUNCTION A - NOVICE USER 4-12
FUNCTION A - INTERMEDIATE/ADVANCED USER 4-16
FUNCTION D 4-25
FUNCTION E 4-27
FUNCTION G 4-29
FUNCTION P 4-30
FUNCTION S or 87 4-32
FUNCTION X 4-38
FUNCTION Z 4-41
POST RETRIEVAL OUTPUT OPTIONS MENU 5-1
OPTION B 5-3
FRDS01 DIALOG 5-5
FRDS 01 REPORT 5-6
FRDS03 DIALOG 5-10
FRDS03 REPORT 5-11
FRDS07 DIALOG 5-19
FRDS07 REPORT 5-20
FRDS 17 DIALOG .. 5-23
FRDS 17 REPORT 5-24
FRDS 19 DIALOG 5-30
FRDS 19 REPORT 5-31
FRDS20 DIALOG 5-33
FRDS20 REPORT 5-34
FRDS24 DIALOG 5-36
FRDS24 REPORT 5-37
IV
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, J 992
FRDS31 DIALOG 5-42
FRDS31 REPORT 5-43
FRDS32 DIALOG 5-47
FRDS32 REPORT 5-49
FRDS35 DIALOG 5-55
FRDS35 REPORT 5-56
FRDS43 DIALOG 5-61
FRDS43 REPORT 5-63
OPTION C 5-68
OPTION F 5-74
OPTION L 5-77
QUICKLOOK OPTION ON-LINE SESSION 5-104
QUICKLOOK OPTION REPORT 5-108
Effective Date: 12/31/92 Release: 2.00 v
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
S DC-0055-005 - LN -2005
December 31, 1992
SECTION 1
INTRODUCTION
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
SDC-0055-005-LN-2005
December 31, 1992
Section I Introduction
1.1 Purpose
The purpose of the The Federal Reporting Data System (FRDS-II) Interactive Retrieval
User's Guide is to assist the FRDS-II user community in retrieving information interactively,
both in on-line and batch report format from the FRDS-II Data Base. This data base is
designed to support the Environmental Protection Agency (EPA) Office of Ground Water and
Drinking Water (OGWDW) in monitoring compliance with the Safe Drinking Water Act of
1974 and 1986 Amendments to the Act. The FRDS-II/Interactive software provides EPA
Headquarters, Regional, and State personnel with 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).
1.2 Background
FRDS first became operational in Federal Fiscal year 1977, and was designed to satisfy the
need for Federal oversight of the Public Water Supply Supervision (PWSS) program. At that
time, summary data for each PWS was collected on an annual basis and forwarded to the
EPA National Computer Center (NCC) at Research Triangle Park (RTP), North Carolina and
loaded into a SYSTEM 2000 (S2K) data base residing on EPA's Univac 1108 computer
system.
During fiscal years 1973-1984, 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 Region and State primacy agencies.
In fiscal year 1985, the EPA Office of Ground Water and Drinking Water (OGWDW) issued
guidance requiring primacy agencies to report their data on a quarterly, rather than an annual
basis.
In 1985, EPA initiated an effort to evaluate and revise, as appropriate, the Federal reporting
requirements for the PWSS program. This effort resulted in the publication of Water Supply
Guidance V-2, Public Water Supervision Revised Reporting Requirements (RRR). As a
result, FRDS-II was 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 contains a single Inventory (representing the most recent Inventory submission by
primacy agencies) and all of the Actions, Milestones, and Samples.
Effective Date: 12/31/92
Release: 2.00
Page: 1 - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
SDC-0055-005-LN-2005
December 31, 1992
The design of FRDS-II/Interactive focused on system use by non-technical personnel. The
system was developed and continues to be enhanced with the following guidelines:
• The terminology used is that of the PWSS program.
• Help is available by entering "?" to most prompts issued by the system allowing the
user to determine possible answers to the question being asked.
• A User Assistance hotline makes fast problem resolution possible.
• Users' wants and needs are considered in developing new FRDS-II/Interactive
features.
Typical of most good information systems, FRDS has accommodated many changes as part
of its normal growth pattern. With the revisions to the Safe Drinking Water Act and the
subsequent publication of the Revised Reporting Requirements, FRDS-II has been developed
to reflect the revisions.
1.3 Constraints
Several constraints are inherent in the design of FRDS-II/Interactive. They are as follows:
• On-line updating of the FRDS-II Data Base is not supported.
• In the prompted features of FRDS-II/Interactive, a user can only select information
based upon answers to previously defined questions.
• 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 each weekday after 4 P.M. Eastern Time.
Page: 1 - 2
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
SDC-0055-005-LN-2005
December 31, 1992
1.4 User Community
The FRDS-II/Interactive user community includes the following:
• EPA OGWDW
• FRDS-II Data Base Administrator (DBA)
• FRDS-II Production Control and User Support
• EPA Regions
• State users
• Other members/organizations of the Drinking Water Community
The FRDS-II DBA and the FRDS-II Production Control and User Support organizations
perform necessary data base maintenance functions including updating, backup, recovery,
archiving, and reloading.
This guide contains all the necessary information for the user to generate batch and on-line
reports through FRDS-II/Interactive. However, if additional information or assistance is
required, you may contact the following:
• National Computer Center (NCC)-IBM User Support NCC
79 Alexander Drive
4501 Building
Research Triangle Park, NC 27711
919 541-7862
800 334-2405
FTS 629-7862
Effective Date: 12/31/92
Release: 2.00
Page: 1 - 3
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
SDC-0055-005-LN-2005
December 31, 1992
• FRDS-II Production Control and User Support
EPA SYSTEMS DEVELOPMENT CENTER
(A Contractor Operated Facility)
Science Applications International Corporation
200 North Glebe Road, Suite 300
Arlington, VA 22203
703 908-2460
• FRDS-II DBA
OGWDW Data Management Staff
United States Environmental Protection Agency
Office of Ground Water and Drinking Water
401 M Street, SW. WH550E
Washington, D.C. 20460
202 260-2804
1.5 Organization of the Interactive Retrieval System User's Guide
This guide describes FRDS-II/Interactive features for the non-technical user including what it
does and how to use it. The guide is divided into the following five sections:
Section I provides an introduction to the system's purpose, background, constraints, and
user community.
Section 2 presents an overview of the system and its retrieval functions, and a summary of
its operational environment, equipment, and security.
Section 3 outlines the operation of the system to include procedures for initiation, operation,
error and recovery, and exiting FRDS-II/Interactive.
Section 4 describes use of the Main Menu and each of its selections.
Section 5 gives instructions for using the Post Retrieval Output Options Menu and each of its
selections along with report examples for each selection.
Page: 1 - 4
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Introduction
SDC-0055-005-LN-2005
December 31, 1992
Sample interactive sessions are displayed throughout this document, with each session being
annotated, where necessary, to better explain the various FRDS-II/Interactive functions to the
user. All user responses are italicized in sample sessions. In Section 5, excerpts from each
standard batch report are annotated with appropriate data elements and comments.
Effective Date: 12/31/92 Release: 2 00 Page* I - 5
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
SECTION 2
SYSTEM SUMMARY
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
Section 2 System Summary
2.1 System Overview
FRDS-II/Interactive provides a flexible means of retrieving PWS data.
TEN types of PWS data are maintained in FRDS-II:
• PWS Summary data, including: identification and statistical summary information for
• Inventory data, including: source information, source treatments, address information,
service areas, geographic areas, and historical information.
• Violation data, including: information pertaining to a PWS's non-compliance with
EPA and/or primacy standards.
• Variance, exemption, and other related data, including: information pertaining to
primacy agency exceptions to a PWS's normal standards, turbidity waiver
information, and Surface Water Treatment Rule Filtration Requirements.
• Enforcement action data, including: information pertaining to legal actions taken
against a PWS.
• Non-compliance profile data.
• State discretionary data.
• On-site visit data, including Sanitary Surveys.
• Milestone Data, including Lead and Copper Milestones.
• Sample Data, including Lead 90th Percentile levels and Unregulated Contaminant
information (future).
each PWS.
Effective Date: 12/31/92
Release: 2.00
Page: 2 - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
FRDS-II/Interactive sessions follow a question and answer format allowing the user to
perform several functions in order to select and retrieve information from the FRDS-II Data
Base. This guide provides sample sessions and captured screens to aid the user in
performing these functions.
2.2 Retrieval Overview
FRDS-II/Interactive data retrieval functions can be divided into several components:
• Establishing the search domain
• Searching the data base
• Extracting selected PWS data
• Presenting the selected data in an appropriate format
The illustration on Page 2-4 depicts the data base architecture of FRDS-II under the System
2000 (S2K) Data Base Management System (DBMS). The FRDS-II Data Base contains a
hierarchically arranged set of records which contain information relating to the PWSS
Program. A detailed definition of the data base structure is included in the Glossary of the
FRDS-II Data Element Dictionary under Data Base, Data Base Family, and Data Base
Record.
2.2.1 Establishing The Search Domain
When using the Assist function of FRDS-II/Interactive (Function A), the only search domain
that can be established is determined by a locate or search of the entire data base. The three
levels of this search domain which may be specified are:
• One or more PWSs which meet certain criteria.
• Violations that are recorded against PWSs that meet certain criteria.
• Enforcements that are recorded against PWSs that meet certain criteria.
2.2.2 Searching The Data Base
Once the retrieval statement has been formulated the user can submit it to
FRDS-II/Interactive for automatic searching of the data base. Details are described in
Page: 2-2
Release: 2.00
Effective Date: 12/3/192
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
Section 4, Using The Main Menu.
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. Details are described in Section 5, Using The Post Retrieval
Output Options Menu.
2.3 Operational Environment
The FRDS-II/Interactive software operates at EPA's NCC on an IBM ES9021-900 mainframe
computer located in NC, and uses VS COBOL II Programming and SAS Institute's
Procedural Language Extension (PLEX). The new user must contact the regional data
processing contact to establish an account at NCC. After that has been accomplished, to
obtain access to FRDS-II/Interactive, contact FRDS-II Production Control and User Support,
as noted in Section 1.4.
Effective Date: 12/31/92
Release: 2.00
Page: 2-3
-------
Federal Reporting Data System (FRDS-IU
Structure Chart
December 1, 1992
50
a>
s
V)
n
to
tn
2s
8
&
<
a
(U
«—r
n>
C300
C400
C600
C4*o a
TMCATMCNT
DATA
PW3-84-
TMATMEXT-
K>
t J
C0OO 4
8EAV1CC
AfUAS
C700 6
OM-Sttf
MST8
CO 1-14
STAfi
8UMMAtCf
CI100
7
VIOLATION
DATA
VIO-
C1180 7
LOU. 10
CNFOACCMEMT
tCtOO 13
MU8T0MC
CVttTS
MM-
MmSTONl
CI2*0 i
UNX TO
VIOLATION
C1200
•
(MFOftCEMEMT
DATA
ENf-
CtOO 8
MI8T0KV
PWS-HIST
CI 900
0
nc*»
CONTROL
HJA
cino 9
NOH-
COMFUAMCi
PROFILE
NCP-
CI000 7•
MOM-
COMPUANCC
DATA
NCD-
caioo 14
SAMPLE
OAT A
caooo 14
SAMPLE DATA
CONTROL
NOOE
N/A
C31O0 10
V 4 C
SCHEDULE
CJOOO 10
VAftANCE
(XEMPTION
DATA
VI
C4000 It
STATE
OtSC ACTION
AAV DATA
SOO
C4060 12
D6A-0ATA
OftA-
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
2.4 Equipment
2.4.1 Basic Equipment
Use of FRDS-II/Interactive requires an approved interactive terminal or personal computer
(PC) with a telephone connection to NCC in Research Triangle Park, NC. In order to gain
access to FRDS-II/Interactive, the user must logon to the IBM mainframe computer at NCC.
2.4.2 NCC Requirements
In addition to an approved terminal or PC, use of FRDS-II/Interactive also requires the
following from NCC:
• Telephone access number.
• User ID and Password.
• Nine-digit account code consisting of a four-digit NCC account ID and a five-digit
FRDS-II project ID.
• Access to TSO, IBM's Time Sharing Option.
• Validation for the $EPATSO logon procedure.
2.4.3 User Support Staff Requirements
The following is required from the FRDS-II User Support staff:
• Inclusion in the FRDS-II/Interactive users profile file.
2.4.4 User's Own Staff Requirements
The following is required from the user's own staff:
• Bin/box number
• Remote printer ID.
Effective Date: 12/31/92
Release 2.00
Page- 2 - 5
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Summary
SDC-0055-005-LN-2005
December 31, 1992
2.5 Security
Several types and levels of security protect the data in the FRDS-II data base. Access to the
data base requires the following:
• A valid user ID for the NCC system
• A valid account number for the NCC system
• The current password for the user ID
• FRDS-II/Interactive authorization
• Elementary knowledge of TSO
• $EPATSO logon procedure
• Access to the FRDSON-II Command List (CLIST)
Page 2 - 6
Release' 2 00
Effective Date 12/3/192
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
SECTION 3
SYSTEM OPERATION
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
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.2 or 3.1.3 as appropriate to the user's location.
3.1.1 Logon Information
To obtain current telephone access numbers, refer to Section 1.5 in contacting FRDS-II User
Support or call NCC Telecommunications Support at one of the following telephone
numbers:
NCC Telecommunications Support
919 541-4506
800 334-2405
FTS 629-4506
3.1.2 Logon for Users Dialing in Washington, DC
In Washington, DC, users gain access to NCC, through statistical multiplexers.
To obtain current telephone access numbers in Washington, DC, refer to Section 1.5 in
contacting FRDS-II User Support or 3.1.1 in contacting NCC Telecommunications Support.
The logon procedure consists of the following:
• Refer to Section 2.4 for the required parameters of terminal operation.
• Turn on power switches of the terminal and modem as necessary.
Effective Date: 12/31/92
Release: 2.00
Page: 3 - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
3.1.3 Telecommunications for PC Users
Users with PCs may access FRDS-II using local communications software such as
"CROSSTALK," an EPA standard. A modem, internal or external, and a telephone line are
also required.
The exhibit on the following page was "captured" when dialing into NCC using: 800 445-
2795. This phone number will support communications at baud rates ranging from 300 bits
per second(bps)- 9600 bps.
3.1.4 Full-Screen or Line-By-Line Access
Some users may wish to access FRDS-II in "Full-Screen" mode instead of "Line-by-line"
access mode. Sample sessions on the following pages show both logon procedures. It is
worthwhile to note, however, that "Full-Screen" mode is generally intolerably slow when
doing a screen refresh, unless a modem capable of at least 4800 bps is used.
The following table provides the communications protocol for both full-screen and line-by-
line screen users.
COMMUNICATIONS PROTOCOL
FULL SCREEN
LINE-BY-LINE
NCC Develcon Data Switch
Selection
TCP
IBMPSI
BAUD RATE
300-9600 bps
300-9600 bps
DATA BITS
7
7
PARITY
E
E
STOP BITS
1
1
DUPLEX
FULL
HALF
Page: 3 - 2
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
FULL SCREEN LOGON
NETMAIN
U.S. Environmental Protection Agency
Menu System
Date: 12/22/92
T line: 09:40:19
Terminal: T23AN006
Logmode: H2S0LC0
Please enter selection or conmand and then press ENTER.
1. INFORMATION News Alerts and User Memos
2. SYSTEM MENU System Selection Menu
3. MAIL EPA Electronic Mail for 3270
4. APPLICATIONS EPA Applications Menu
5. INTER-AGENCY Inter-Agency Applicat ions Menu
6. PUBLIC Public Access Applications Menu
WARNING: The use of this computer is for official Government business only.
Unauthorized use of this computer is a criminal offense under Title 18
United States Code, Section 641, and may subject violators to a fine of
up to $10,000, or imprisonment of up to 10 years, or both.
Coamand ===> tso
Welcome to the Environmental Protection Agency National Computer Center
Please enter one of the following selections:
IBMPSI for IBM
TCP for IBM 3270 EMULATION
VAXA for VAX SYS A
VAXB for VAX SYS B
MAIL for ALL-IM-1
Effective May 15, 1992 the 541-0700 rotor will no longer be
available. The NEW nuifcer to use is 541-4642.
Enter selection:71C/>
Connected.
* tHIiiiijfi
(Screen change)
** Cx-80 VER 04.83 **
* Once connected, the user can enter a series of characters, depending on the type
of terminal bing used or emulated. NCC will provide the user with this
information. If return is hit, the user will be prompted for his terminal device; a
two digit code will be given in response to his selection. This code can then be
used for all subsequent Full Screen logon sessions. The user may also request
from NCC a list of special function keys appropriate for the terminal being used.
Effective Date: 12/31/92
Release: 2.00
Page: 3 - 3
-------
FRDS-n INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
FULL SCREEN TSO LOGON
WELCOME TO THE
U.S. ENVIRONMENTAL PROTECTION AGENCY
TELECOMMUNICATIONS NETWORK
TERMINAL 10: T2410919
ENTER COMMAND TO LOGON
TSO
(Screen Change)
EPA2 TSO/E LOGON T2410919
PF3/PF15 ==> Logoff PA1 ==> Attention PA2 ==> Reshow
PF1/PF13 ==> Help
ENTER LOGON PARAMETERS BELOW:
USER ID ===> uuu
PASSWORD ===> pppppppp
PROCEDURE ===> SEPATSO
ACCT NMBR ===> aaaa
FI MAS ===> FFFFF
SIZE ===> 8500
COMMAND ===>
ENTER AN "S" BEFORE EACH OPTION DESIRED BELOW
-NOMA 1L -NONOTICE -NOSUMMARY
(Screen change)
RACF LOGON PARAMETERS:
NEW PASSWORD ===>
GROUP IDENT ===>
BIN NUMBER ===> bbbb
SYSOUT DEST ===> dddd
-CANCEL
ICH70001I uuu LAST ACCESS AT 09:08:54 ON MONDAY, JUNE 1, 1992
IKJ56455I uuu LOGON IN PROGRESS AT 10:50:10 ON JUNE 1, 1992
92/05/28: ADABAS SQL VERSION 1 .4.2
92/05/29: HARDWARE PROBLEMS ON DISK PACK USS045
92/05/28: ADABAS SQL VERSION 1.4.2
92/06/01: NCC CUSTOMER SUPPORT HOURS EXTENDED
92/05/27: CICS/V - CICS SYSTEM SOFTWARE UPGRADE
92/05/18: A LIST OF RECENTLY RELEASED EPA MEMOS
92/05/14: COBOL CONVERSION AID 1.6 AVAILA8LE
92/04/20: SUPERCALC 5.0 AVAILABLE FOR TESTING
- SEE NEWS ALERT 10
- SEE NEWS ALERT7
- SEE NEWS ALERT10
- SEE NEWS ALERT1
- SEE NEWS ALERT2
- SEE NEWS ALERT6
- SEE NEWS ALERT9
- SEE NEWS ALERT5
READY
Page: 3 - 4
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
LINE-BY-LINE LOGON MODE
Welcome to the Environmental Protection Agency National Computer Center
Please enter one of the following selections:
IBMPSI for IBM
TCP for IBM 3270 EMULATION
VAXA for VAX SYS A
VAXB for VAX SYS B
MAIL for ALL-1N-1
Effective May 15, 1992 the 541-0700 rotor will no longer be
available. The NEW nmtoer to use is 541-4642.
* milium
(Screen change)
" Cx-80 VER 04.83 **
YOUR SELECTION'* IIBBMMPPSSII
Connecting to IBMPSI via X.25 network
WIC1-3671/06 CONNECTED TO NET1/07
Called address: 90900001
COM
U.S. EPA (TTY-X25-IBM)
A TSO - NCC
8 WIC
C CINCINNATI
D ARBITER NCC
E ARBITER CINCY
F EPA OLS
SELECTION ->A
EPA200 ENTER USERID -
UIUI
EPA202 ENTER CURRENT PASSWORD FOR XXX -
¦PPPPPPPP
:EPA207 ENTER ACCOUNT NUMBER - OR FOR aaaa
*
EPA209 ENTER PROCEDURE NAME - OR FOR $EPATSO
*
EPA211 ENTER FIMAS ID - OR FOR fffff
*
EPA213 ENTER BIN NUMBER - OR FOR bbbb
*
EPA250 Default REGION SIZE is 8500
1CH70001I XXX LAST ACCESS AT 15:27:29 ON WEDNESDAY, NOVEMBER 18, 19
92
IKJ56455I XXX LOGON IN PROGRESS AT 09:34.12 ON NOVEMBER 20, 1992
READY
Effective Date. 12/31/92
Release: 2.00
Page: 3 - 5
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
In the following example, the user has executed FRDSONII (FRDS-II/Interactive.) The
welcome message indicates that execution of FRDS/Interactive was successful
EXECUTING FRDS-II INTERACTIVE
READY
EX FRDSONII
Loading FRDSONII ... One moment please "
Welcome to the Federal Reporting Data System (FRDS-II)
On-Line •''
FRDSONII version 2.2 Effective date: 06/26/91
Date: 06/10/92 Time: 17:36:45
********** SPECIAL NOTICE ***••«•***
In order to use FRDS-II / Interactive, you MUST
specify SIZE (8500) and PROCEDURE (SEPATSO) during
your TSO logon.
If you didn't specify the correct SIZE or PROCEDURE,
logon again using the values indicated above ...
Press to continue ...
Page' 3 - 6
Release: 2.00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31,1992
EXECUTING FRDS-II/INTERACTIVE (CONTINUED)
Federal Reporting Data System (FRDS-II) On-Line
PRODUCTION MENU
FRDSONII version 2.2 Effective date: 06/26/91
Function Description Code
End Session and Return to TSO 0 (zero)
FRDS-II / Interactive 1
Natural Language Interface 87
End Session and Logoff TSO 99
-> Enter Function Code ... /
Loading FRDS-11/Interactive One moment please 11
In the above example, the user chose FRDS-II/Interactive (Function Code 1.)
Effective Date: 12/31/92
Release: 2.00
Page: 3 - 7
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
3.1.5 Logon in Case of Terminal Disconnection
If the connection between the user's terminal and NCC is broken due to telephone
communication problems, power failure, or the like, immediately perform the logon
procedure appropriate to the user's geographical location. Whenever reconnection is
possible, there will be a "reconnect successful" message shown on the screen following a
successful reconnection. The user has approximately 30 minutes from the time of
disconnection to effect reconnection; after that time, the user must perform a complete logon
following the procedure appropriate to the user's geographical location.
3.2 Operational Procedures
The procedure necessary to implement FRDS-II/Interactive is:
• Execute FRDS-II/Interactive CLIST
• Begin FRDS-II/Interactive
• Access the integrated FRDS-II data base
• Select PWSs
• 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 the user is using an ASCII Terminal and accessing NCC as a line-by-line terminal, the
user must enter the following TSO command at the READY prompt prior to executing
FRDS-II/Interactive. "TERM TRAN(NPSI)"
Page: 3 - 8
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
After entering the TSO "TERM" Command the user may execute FRDS-II/Interactive. For
further information and assistance in executing FRDS-II/Interactive refer to Section 1.5 in
contacting FRDS-II User Support.
3.2.2 Description of the Production Menu
The system then displays the Production Menu which allows the user to choose the
FRDS-II/Interactive Function. The sample session on the next page shows the Function
Menu and how to use it to execute FRDS-II/Interactive.
3.2.3 Beginning FRDS-II/Interactive
Selecting Code '1' of the Function Menu allows the system to begin FRDS-II/Interactive.
3.2.4 Message Updates
When FRDS-II/Interactive is initiated, it will first display the current version and release
number of the FRDS-II/Interactive software. It will then give the user the opportunity to
obtain instructions on the use of FRDS-II/Interactive. It will then give the user the
opportunity to print out a copy of this documentation. This will then be followed by
FRDS-II/Interactive General Broadcast Messages.
Effective Date: 12/31/92
Release: 2.00
Page: 3 - 9
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
System Operation December 31, 1992
EXECUTE FRDS-II/INTERACTIVE
READY
EX FRDSONII
Loading FRDSONI I ... One moment please '!
= Welcome to the Federal Reporting Data System (FRDS-II) =
= On-Line '¦' =
= FRDSONII version 2.2 Effective date: 06/26/91 =
Date: 06/10/92 Time: 17:36:45
= ********** SPECIAL NOTICE ********** =
= In order to use FRDS-II / Interactive, you MUST =
= specify SIZE (8500) and PROCEDURE (SEPATSO) during =
= your TSO logon. =
= If you didn't specify the correct SIZE or PROCEDURE, =
= logon again using the values indicated above ... =
Press to continue ...
= Federal Reporting Data System (FRDS
II) On-Line =
PRODUCTION MEN
U =
= FRDSONII version 2.2 Effective date: 06/26/91 =
= Function Description
Code =
= End Session and Return to TSO
0 (zero) =
= FRDS-II / Interactive
1
= Natural Language Interface
87
= End Session and Logoff TSO
99
--> Enter Function Code (98 for Menu) ...
/
¦ Loading FRDS-1 I/Interactive ... One moment please 11
Page: 3-10
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0Q55-005-LN-2005
December 31, 1992
The system then prompts the user to answer if the user wants to see a display of the FRDS-II
System Messages.
Users with a hardcopy terminal are encouraged to keep copies of all message updates on
hand. Since FRDS-II/Interactive is continually evolving, documentation will be updated
periodically, but not necessarily when each new capability is first made available. Retaining
copies of these messages will allow the user to maintain up-to-date information prior to the
release of any updated documentation.
The sample session beginning on the next page shows the user how to respond to access 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.
• Enter if the user makes an error in responding to the prompted query dialogue
sequence that formulates data selection criteria statements. This interrupts the
prompted query dialogue 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 the user specifies all the parameters necessary for the data selection
criteria statement and wish 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 the user's terminal.
Effective Date: 12/31/92
Release: 2.00
Page: 3-11
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
FRDS-II/INTERACTIVE GENERAL BROADCAST MESSAGES
Welcome to FRDS/Interactive
for FRDS-11
Version: 2.0 Release: 1.1
10/24/91 17.11.53
Your FRDS-11/Interactive Session initiated at ...
17:37:10 on Wednesday, June 10, 1992
--> Would you like instructions on the use of
FRDS-11/Interactive' '
(Y)es or (N)o: N
* General Broadcast Messages for the FRDS-II System follow ... *
* ** Messages Last Updated on Friday, May 29, 1992 ** *
ATTENTION ALL FRDS USERS: Production Control and User Support's
new "Hotline" number is (703) 908-2460. Use BZM for UMAIL messages.
Many users have been experiencing problems with getting results
from Locate Statements and S2K SCF commands which involve a large
amount of sorting. Users were being thrown out to the TSO READY
prompt without any warning.
A temporary fix has been put in place which should solve these
problems. Anyone who still experiences this problem should contact
FRDS User Support at the above number.
FRDS-II System Messages were Last Updated on Monday 3/16/92.
*****************************************************************
* End of General Broadcast Messages for the FRDS-II System *
*****************************************************************
Press to continue
Page- 3-12
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
FRDS-IiyINTERACTIVE BROADCAST MESSAGES
FRDS/Interactive Broadcast Messages for FRDS-II follow...
• Messages Last Updated on Friday, May 29, 1992 *
At long last the new sinmary report for Enforcement Actions is now
available. The new report aggregates the number of Enforcements (the
17A) or the number of system with Enforcements (the 17B) by population
sizes by State.
The FRDS 17 Report should be generated after issuing a Locate
Statement retrieving by C1200 (not C100 or C1100) and generally should
be restricted by federal fiscal year (C1209) as well.
••*********************************************************************
* End of FRDS/Interactive Broadcast Messages for FRDS-II *
#*****************#*##***#********##*#*********************************
Press to continue ...
--> Would you like to display the FRDS-II System Messages7
(Y)es or (N)o: Y
Effective Date- 12/31/92
Release: 2.00
Page 3-13
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
System Operation
SYSTEM MESSAGES
********************************************
* System Messages for FRDS-II follow ... *
it*******************************************
The DRIPSS Bulletin Board
The DRinking Uater Information Processing Support System (DRIPSS) is a
drinking water program related, PC-based bulletin board system for data
management and progranmatic information exchange.
DRIPSS is free and open to all users. It can be reached 24 hours a day,
7 days a week at (800) 229-3737. Your software should be set to S data
bits, no parity, and 1 stop bit. The system supports either 1200 or
2400 baud modems. For more information on DRIPSS, call the CADMUS Group
at (703) 339-0420.
--> Continue with the next page of System Messages' (Y)es or (N)o: N
(Screen change)
Loading SYSTEM 2000 ... One moment please 'i
Page- 3-14
Release: 2.00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
FRDS-n/INTERACTIVE BROADCAST MESSAGES
FRDS/Interactive Broadcast Messages for FRDS-II follow...
* Messages Last Updated on Friday, May 29, 1992 *
At long last the new summary report for Enforcement Actions is now
available. The new report aggregates the number of Enforcements (the
17A) or the nurber of system with Enforcements (the 17B) by population
sizes by State.
The FRDS 17 Report should be generated after issuing a Locate
Statement retrieving by C1200 (not C100 or C1100) and generally should
be restricted by federal fiscal year (C1209) as well.
* End of FRDS/Interactive Broadcast Messages for FRDS-II *
a****#*********#*******************************************************
Press to continue ...
--> Would you like to display the FRDS-II System Messages7
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
SDC-0055-005-LN-2005
December 31, 1992
SYSTEM MESSAGES
********************************************
* System Messages for FRDS-II follou ... *
********************************************
The DRIPSS Bulletin Board
The DRinking Water Information Processing Support System (DRIPSS) is a
drinking water program related, PC-based bulletin board system for data
management and programmatic information exchange.
DRIPSS is free and open to all users. It can be reached 24 hours a day,
7 days a week at (800) 229-3737. Your software should be set to 8 data
bits, no parity, and 1 stop bit. The system supports either 1200 or
2400 baud modems. For more information on DRIPSS, call the CADMUS Group
at (703) 339-0420.
--> Continue with the next page of System Messages'' (Y)es or (N)o: N
(Screen change)
Loading SYSTEM 2000 ... One moment please '¦
Page: 3-14
Release: 2.00
Effective Date 12/31/92
-------
FRDS-ll INTERACTIVE RETRIEVAL USER'S GUIDE
System Operation
S DC-0055-005-LN-2005
December 31, 1992
3.2.6 FRDS-ll/Interactive Session Cancellation
In the unusual situation in which the user wants 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 the user's terminal and NCC is broken due to telephone
communication problems or power failure, refer to Section 3.1.5.
If the user makes an error in responding to the prompted query dialog 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.4 to obtain the telephone number to contact FRDS-II User Assistance.
3.4 Exit Procedures
To exit a session at the prompt for a Production Menu selection, enter '0' (zero), End, or
Quit. For further details on the Function Menu, refer to Section 3.2.2.
To exit a FRDS-II/Interactive session at the prompt for 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 following sample
session shows the user how to end a session at the 'READY' prompt.
LOGOFF
READY
logoff
uuu:aaaa IOGGEO OFF WEDNESDAY 06/10/92 AT 19:22:29
CPU: TC8 1:20.64, SR8 :07.51, TOTAL 1:28.15
10: DISK 43564, TERM 3556, OTHER 11, TOTAL 47131
COST: CPU 1.77, I/O t .21, TOTAL $.98
Effective Date: 12/31/92
Release: 2.00
Page: 3-15
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
SECTION 4
USING THE MAIN MENU
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Section 4 Using The Main Menu
4.1 Description Of The Main Menu
After FRDS-II/INTERACTIVE is initiated, the system prompts the user for a Main Menu
selection.
Due to the Main Menu's length, the system prompts the user for the Main Menu selection
without displaying the Main Menu. However, for demonstration purposes, the following
sample session shows how to display the Main Menu by entering 'MENU' at the prompt for
a Main Menu selection. We have entered HELP to show the currently available functions.
MAIN MENU
-•> Enter Function Code, END, or MENU: HELP
Enter a single nurber or letter which represents your desired response to the
question, Chen press .
*•**••»**•••••*»•••••**•**••* FRDS-ll/Interactive Menu ***•»»*••****••»**••»«
(0 i.e., zero), (END), or (QUIT) Terminates this FRDS/Interactive Session
*********************** Specify Retrievdl Cri tsr13 **************************
(A) Assisted (i.e., prompted) Locate statement preparation
(E) Retrieve PWSs whose IDs are contained in an External file
*** Non-prompted specification of what is to be retrieved ***
(i.e., specify S2k Locate commands of your own derivation)
(X) Execute the Locate command & pick Post Retrieval Output Option
(Z) Scan the Locate command for correct syntax & submit batch report
************************ Miscellaneous Functions ***************************
(D) Display FRDS-II Broadcaster System Messages
(G) Obtain Geographic Information for a specified City or County
(P) Process Retrieved data via Post Retrieval Output Options
(S) SYSTEM 2000 Self Contained Facility (i.e., Natural Language)
--> Enter Function Code, END, or MENU:
Effective Date: 12/31/92
Release: 2.00
Page: 4 - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
The user 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 selections. These are:
• (0) Terminates this FRDS-II/Interactive selection
• (A) Assisted (i.e., prompted) Locate statement preparation
• (D) Display FRDS-II Broadcast or System Messages
• (E) Retrieve PWSs whose IDs are contained in an External file
• (G) Obtain Geographic Information for a specified City, County, or Zip Code
• (P) Process Retrieved data via Post Retrieval Output Options
• (S) SYSTEM 2000 Self-Contained Facility (i.e., Natural Language)
• (X) Formulate one or more S2K Locate clauses
• (Z) Formulate one or more S2K Locate clauses and generate a batch report
The Terminate this FRDS-II/Interactive selection exits the FRDS-II/Interactive session and
returns the user to the Function Menu. For further details on the terminate
FRDS-II/Interactive selection, refer to Section 4.2.1. For further details on the Production
Menu, refer to Section 3.2.2.
Display FRDS-II/Interactive Re-Displavs Broadcast or System messages. 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 allows the
user to use a previously created sequential file of PWS IDs to perform retrievals against the
FRDS-II Data Base. For further details on this selection, refer to Section 4.2.4.
Page: 4 - 2
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
The selection to Obtain Geographic Information may be used to display latitude/longitude
data for specified cities, counties or zip codes. For further details, refer to Section 4.2.5.
The Post Retrieval Output Options selection invokes the Post Retrieval Output Options Menu
to format previously selected data records. For further details on the post-retrieval
processing options selection, refer to Section 5.
The User-Defined Query selections (X and Z) retrieve data from the FRDS-II Data Base.
Based upon the selection made, FRDS automatically invokes the Post Retrieval Output
Options Menu after the query has been satisfied. Post-Retrieval 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 4.2.4. For further
details on the S2K Self-Contained Facility selection, refer to Section 4.2.7.
The remainder of Section 4 shows how to use each Main Menu selection through the use of
sample sessions.
Effective Date: 12/31/92
Release: 2.00
Page 4 - 3
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.1 Function '0' - To Terminate FRDS-II/Interactive
The Main Menu provides the Terminate FRDS-II/Interactive selection. The Terminate
FRDS-II/Interactive selection enables the user to exit a FRDS-II/Interactive session al the
prompt for a Main Menu selection.
Selecting Function '0' returns the user 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'.
Page: 4 - 4
Release 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION 0'
--> Enter Function Code, END, or MENU: 0
Your FRDS-II/Interactive Session terminated at ..
19:40:10 on Wednesday, September 30, 1992
Elapsed time of Session ...
00:01:19
End of FRDS/Interactive
for FRDS-II
Press Enter Function Code (98 for Menu) 0
***** End of FRDSONII *****
Restoring TSO Environment
One Moment Please 1
TSO Environment Restored
Effective Date: 12/31/92
Release: 2.00
Page: 4 - 5
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Main Menu
4.2.2 Function 'A' - Assisted (Prompted) Query
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
that results in selection of the desired set of data, or takes an inordinate amount of time to
satisfy. 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. It may not, however, 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. 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/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
way in which they can respond to any given prompt.
Users restrict what is to be retrieved from the FRDS-II Data Base by the responses they
provide in six general areas (referred to as groups). These groups are divided into
subgroups. Also included in the list on the following pages are the prompt prefixes.
Page: 4 - 6
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0G55-005-LN-20O5
December 31, 1992
• Group 1 - PWS Inventory Characteristics f8 sub-groups')
Prompt Prefix
1. Classification and Location Data Elements PWS
2. Other Address Data Elements
PWS-AD
3. Source/Entity Data Elements
PWS-SE
4. Source Treatment Data Elements
PWS-SE-TREAT
5. Geographic Area Served Data Elements PWS-GA
6. Service Area Data Elements
PWS-SERV
7. On-site Visit Data Elements
PWS-VISIT
8. History Data Elements
PWS-HIST
tics (2 sub-groups)
Prompt Prefix
1. Violation Specific Data Elements
VIO
2. Violation Statistics Data Elements
VIO/NCP
Effective Date: 12/31/92
Release: 2.00
Page: 4 - 7
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
~ Groun 3 - Enforcement Characteristics (2 sub-groups)
Prompt Prefix
1. Enforcement Specific Data Elements ENF
2. Enforcement Statistics Data Elements ENF/NCP
• Group 4 - Variance/Exemption Characteristics (2 sub-groups)
Prompt Prefix
1. Variance/Exemption/Other Specific Data VE
Elements
2. Vanance/Exemption/Other Schedule Data VE-SCHED
Elements
• Group 5 - State Discretionary Data
Prompt Prefix
State Discretionary Data Information SDD
• Group 5 - Data Base Administrator Characteristics
Prompt Prefix
Significance Non-Compliance Information DBA
Page: 4-8
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
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 by entering either a
question mark (?) or the keyword "HELP."
The help message provides specific information about the prompt, what may be entered, and
how 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 follows:
Special Response Meaning
Exclamation Point (!) All user responses provided to this point are abandoned and the
prompting dialog is started over from the beginning.
Pound Sign (#) 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).
The Greater than (>) All criteria from the current group (or sub-symbol 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.
The Caret Symbol (Shift 6) 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 with all subsequent sub-groups that belong to the
current group bypassed.
< BREAK > or < ATTN > The informational display in progress is to be terminated
immediately.
Effective Date: 12/31/92
Release: 2.00
Page: 4-9
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Cnnnn For intermediate/advanced users only. Data element number(s)
may be entered in response to any group or sub-group prompt to
"direct" what prompts from that group or sub-group are to be
issued, and in what order. In addition to that which has already
been specified, user responses may include the following:
• Multiple data base values per line separated by a slash (e.g.,VI / V2 / V3) for data
base value prompts. Multiple values specified in this manner are always treated as
'or' conditions.
• Multiple data element numbers per line separated by a comma (e.g., CI, C2, C3) for
group and sub-group menu prompts. Multiple data element numbers specified in this
manner are always treated as 'and' conditions. (Intermediate/advanced users ONLY!)
• The SYSTEM 2000 relational operators as a prefix to data base value responses.
These relational operators are as follows:
Operator
Meaning
EQ
Equal (Default... Does not need to be explicitly entered as a data base
value prefix)
NE
Not Equal
GE
Greater than or Equal to
GT
Greater than
LE
Less than or Equal to
LT
Less than
SPANS
Value range ... SPANS V1*V2
EXISTS
The presence of any non-null value
FAILS
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) may be 'AND'ed or 'OR'ed together at the user's discretion.
As needed, normalization clauses are automatically inserted into the Locate statement
constructed (i e., ( CI00 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.
Page: 4 - 10
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
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 the 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 examples of on-line sessions are presented on the immediately following pages. The
first example session illustrates the "novice" user dialog and the second example session
illustrates the intermediate/advanced user dialog.
Effective Date: 12/31/92
Release: 2.00
Page: 4-11
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION A - NOVICE USER
--> Enter Function Code, END, or MENU: a
••> What User Experience Level do you want?
(N)ovice or (I)ntermediate: N
--> What User Access do you want?
Enter a valid Access Authority
- 97 98
01 thru 10
Valid State code: TX
¦¦> Do you want instructions on the use of the Assisted (i.e., prompted)
Locate statement preparation function' (Y)es or (N)o: N
--> Do you want to restrict your search to only those Public Water Systems
that have one or more violations? (Y)es or (N)o: N
••> Do you want to restrict your search to Public Water Systems that
are (C)urrent, (H)istorical, or (B)oth: HELP
Public Water Systems are either "Current" or "Historical".
Selecting "(B)oth" implies that your query results MAY include Public
Water Systems that are either current OR historical PWS(s).
If you intend to restrict your search to a particular PWS Status Code(s)
(a prompt for PWS Status Code appears later in this session), then
your response should be "(B)oth".
--> Do you want to restrict your search to Public Water Systems that
are (C)urrent, (H)istorical, or (B)oth: B
--> Do you want to restrict your search for Violation, Enforcement, and/or
Variance/Exemption data to one or more specific Federal Fiscal rears'
(Y)es or (N)o: N
¦•> Do you want to restrict your search to one or more specific EPA
Regions? (Y)es or (N)o: N
--» Do you want to restrict your search to one or more specific States?
(Y)es or (M)o: ¥
Acceptable States are EPA Region numbers 02 and 04 to 10, and/or two
character FIPS State codes
--> C3 - For which specific State(s) do you want to select data?
: TX
--> Oo you want to restrict your search based upon Public Water System
Inventory Characteristics? (Y)es or (N)o: Y
--> Do you want to restrict your search based upon Public Water System
Inventory Classification and Location (C100) data element values?
(Y)es or (N)o: Y
Among the Public Water System Inventory Classification and Location
data elements, must ALL of your selection criteria be met before
a PWS qualifies for retrieval? (Y)es or (N)o: '
Page: 4-12
Release: 2.00
Effective Date. 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Mam Menu December 31, 1992
Responses to data base value protrpts, within this Sub-Group, will
be 'AND'ed, or 'OR'ed, depending on your response.
A response of 'Y' will generate 'AND' conditions within this Sub-Group
A response of 'N' will generate 'OR' conditions within this Sub-Group
--> Among the Public Water System Inventory Classification and Location
data elements, must ALL of your selection criteria be met before
a PUS qualifies for retrieval? (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 is issued, simply press
--> C101 - (PWS) ID(s):
--> C102 - (PWS) Grant Eligibility Status Code(s):
--> C103 - (PWS) System Status Code(s): CAC/NAC/PAC
--> C111 - (PWS) Date(S) System became Operational (YYKM format)
--> C113 - (PWS) Date(s) System became Inactive (YYMH format)
: REVIEW
I0CATE(15) C100 WH
( C3 EO TX )
AND ( ( NK C103 EO CAC OR
NK CI03 EQ NAC OR
NK C103 EQ PAC ) ) :
--> CI13 - (PWS) Oate(s) System became Inactive (YYMM format)
--> CIIS - (PWS) Population Category Code(s):
--> CI17 - (PWS) Retail Population(s) Served:
--> CI19 - (PWS) Primary Source Type Code(s): HELP
PWS Primary Source Type Codes are:
S - Surface P - Purchased Surface
G - Groundwater W - Purchased Groundwater
Y - Groundwater UD1 Z - Purchased Groundwater UDl
Separate multiple values with a slash
If you so choose, you may use SYSTEM 2000 relational operators in
conjmction with any or all values you specify.
--» C119 - (PWS) Primary Source Type Code(s): S
--> C121 - (PWS) Percentage(s) of water obtained from Non-purchased Surface
water sources: >
--> Do you want to restrict your search based upon Public Water System
Inventory Other Address (C300) data element values? (Y)es or (N)o: N
--> Do you want to restrict your search based upon Public Water System
Inventory Source/Entity (MOO) data element values? (Y)es or (N)o: N
--> Do you want to restrict your search based upon Public Water System
Inventory Source Treatment (C480) data element values?
(Y)es or (N)o: Y
--> Among the Public Water System Inventory Source Treatment data
elements, must ALL of your retrieval criteria be met before a PWS
qualifies for selection? (Y)es or (N)o: Y
Effective Date: 12/31/92
Release: 2.00
Page: 4-13
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
If you do not want to restrict your search based upon the value(s) of a given
data element for which a prompt is issued, simply press ...
--> C481 - (PVS-SE-TREAT) ID(s):
--> C483 - (PUS-SE-TREAT) Objective Code(s):
Treatment Objective Codes
Code Description
B Disinfection By-products Control
C Corrosion Control
D Disinfection
E Dechlorination
F Iron Removal
I Inorganics Removal
H Manganese Removal
N No Treatment at Source
0 Organics Removal
P Particulate Removal
R Radionuclides Removal
S Softening (Hardness Removal)
T Taste / Odor Control
X Not Treated (Converted FRDS 1.S)
Press to continue ...
Y Treated (Converted FRDS 1.5)
Z Other
Separate multiple values with a slash
If you so choose, you may use SYSTEM 2000 relational operators in
conjunction with any or all values you specify.
--> C483 - (PUS-SE-TREAT) Objective Code(s): X
--> C485 - (PUS-SE-TREAT) Process Code(s): 000
--> Do you want to restrict your search based upon Public Uater System
Inventory Geographic Area Served (CS00) data element values7
(Y)es or (N)o: REVIEW
LOCATE(15) C100 UH
(
C3
EQ
TX
)
AND ( (
NK CI 03
EQ
CAC
OR
NK C103
EQ
NAC
OR
NK C103
EQ
PAC
)
AND
(
NK C119
EQ
S
)
)
AND C100 HAS ( (
NK C483
EQ
X
)
AND
(
NK C485
EQ
000
)
)
--> Do you want to restrict your search based upon Public Uater System
Inventory Geographic Area Served (C500) data element values7
(Y)es or (N)o: N
--> Do you want to restrict your search based upon Public Uater System
Inventory Service Area (C600) data element values7
(Y)es or (N)o: N
--> Do you want to restrict your search based upon Public Water System
Inventory On-site Visit (C700) data element values7 (Y)es or (N)o: N
Page: 4-14
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
--> Do you want to restrict your search based upon Public Water System
Inventory History (C900) data element values' (Y)es or (N)o: N
--> Do you want to restrict your search based upon Violation Characteristics'
(Y)es or (N)o: N
--> Do you want to restrict your search based upon Enforcement
Characteristics' (Y)es or (N)o: N
--> Oo you want to restrict your search based upon Variance/Exemption
Characteristics' (Y)es or (N)o: #
--> Please con-firm ... Have you specified ALL criteria for the Locate
statement that you have been defining' (Y)es or (N)o: Y
L0CATEC15) C100 UH
<
C3
EQ
TX
)
AND
( (
NK
C103
EQ
CAC
OR
NK
C103
EQ
NAC
OR
NK
C103
EQ
PAC
)
AND
(
NK
C119
EQ
S
)
)
AND C100 HAS
( (
NK
C483
EQ
X
)
AND
(
NK
C485
EQ
000
)
)
--> Is the Locate statement displayed above correct' (Y)es or (N)o: K
--> Do you want to interactively retrieve the data which meets this selection
criteria' (Y)es or (N)o: Y
Searching ... Please do not interrupt
Search completion pending ...
Successful Locate ...
201 PUS(s) found matching your criteria
-•> Enter Function Code. END, or MENU:
Effective Date: 12/31/92
Release: 2.00
Page: 4-15
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION A - INTERMEDIATE/ADVANCED USER
You must respond uith a single letter, 0 (zero), END, QUIT, or MENU
--» Enter Function Code, END, or MENU: A
--> What User Experience Level do you want?
(N)ovice or (I intermediate: /
--> What User Access do you want?
Enter a valid Access Authority
- 97 98
01 thru 10
Valid State code: 06
--> Do you want instructions on the use of the Assisted (i.e., prompted)
Locate statement preparation function'' (Y)es or (N)o: N
--> Do you want to restrict your search to only those Public Water Systems
that have one or more violations' (Y)es or (N)o: Y
--> Do you want to restrict your search to Public Water Systems that
are (C)urrent, (H)istorical, or (B)oth: C
--> 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: Y
Acceptable fiscal years are two numeric digits from 80 to the present
--> C1135, C1209, and/or C3023 - Federal Fiscal Year(s)?
: 92
--> Do you want to select data for ALL States in your EPA Region7
(Y)es or (N)o: N
Acceptable States are your two digit EPA region nunber (e.g., 02, 04) and/or
two character FIPS State codes for States in your Region
--> C3 - For which specific State(s) do you want to select data?
: TX
•> Do you want to restrict your search based upon Public Water System
Inventory Characteristics? (Y)es or (M)o: Y
-> For which Public Water System Inventory Sub-group(s) do you want to
specify selection criteria?
C100 - Classification and Location Data Elements (PWS),
C300 - Other Address Data Elements (PWS-AD),
C400 - Source/Entity Data Elements (PWS-SE),
C480 - Source Treatment Data Elements (PWS-SE-TREAT),
C500 - Geographic Area Served Data Elements (PWS-GA),
C600 - Service Area Data Elements (PWS-SERV),
C700 - On-site Visit Data Elements (PWS-VISIT),
C900 - History Data Elements (PWS-HIST),
All,
or None: C100
Page: 4-16
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
--> C100 - For which PWS Inventory Classification and Location data elements
do you want to specify values that restrict your search''
C101 - (PWS) ID,
C102 - (PUS) Grant Eligibility Status Code,
C103 - (PWS) System Status Code,
C105 - (PWS) Plant Type Code,
C107 - (PWS) Activity Indicator Code,
C111 - (PWS) Date System became Operational,
C113 - (PWS) Date Systen became Inactive,
C115 - (PWS) Population Category Code,
C117 - (PWS) Retail Population Served,
C119 - (PWS) Primary Source Type Code,
C121 - (PWS) Pet. of Water obtained from Non-purchased Surface Sources,
CI23 - (PWS) Pet. of Water obtained from Non-purchased Ground Sources,
C125 - (PWS) Pet. of Water obtained from Purchased Surface Sources,
C127 - (PWS) Pet. of Water obtained from Purchased Ground Sources,
C129 - (PWS) Treatment Class Code,
C131 - (PWS) System Name,
C1J7 - (PWS) System City,
C139 - (PWS) System State Code,
CU1 - (PWS) System ZIP Code,
C147 - (PWS) Retail Service Connections,
C159 - (PWS) Date on which Non-community Season Begins,
C161 - (PWS) Date on which Non-community Season Ends,
C163 - (PWS) Owner Type Code,
C165 - (PWS) Regulating Entity Code,
C167 - (PWS) Date Inventory Data Last Updated,
C168 - (PWS) Date Inventory Data Inserted,
C169 - (PWS) Date Any Related Data last Updated,
C173 - (PUS) FYnn Tracker Code,
All,
or None: C107, C10S , ClIS
-•> Among the Public Water System Inventory Classification and Location
data elements, must ALL of your selection criteria be met before
a PWS qualifies for retrieval' (Y)es or (N)o: Y
--> C107 - (PWS) Activity Indicator Code(s): A
--> C105 - (PWS) Plant Type Code(s): HEW
PWS Plant Type Codes are:
C - Community Water System
N • Non-conmunity Water System
P - Non-transient Non-commiity Water System
Separate multiple values with a slash
If you so choose, you may use SITSTEM 2000 relational operators in
conjunction with any or all values you specify.
--> C105 - (PUS) Plant Type Code(s): CJ N/P
--> C115 - (PUS) Population Category Code(s): REVIEW
LOCATE(IS) C1100 UH ( NK CI EQ 06 ) AMD
( C3 EQ TX )
AND < ( NJC C109 NE H ) AND
( NK C107 EQ A ) AND
( NK C105 EG C OR
NK C105 EQ P ) )
AND ( NIC C1135 EO 92 )
--> C115 - (PWS) Population Category Code(s):
--> Please confirm ... Do you want to override the prompting order
Effective Dale: 12/31/92
Release: 2.00
Page: 4-17
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
--> Do you want to restrict your search based upon Violation Characteristics7
(Y)es or (N)o: Y
--> For which Violation Sub-group(s) do you want to specify selection
criteria'
C1100 - Violation Specific Data Elements (VIO),
C1350 - Violation Related NCP Data Elements (VIO/NCP),
All,
or None: CI 100
--> C1100 - For which Violation Specific data elements do you want to
specify values that restrict your search?
C1101 - (VIO) ID,
C1103 - (VIO) Contaminant Code,
C1105 - (VIO) Type Code,
C1107 - (VIO) Compliance Period 8egin Date,
C1109 - (VIO) Compliance Period End Date,
C1111 - (VIO) Compliance Period Duration,
C1115 - (VIO) Date on which State became Aware,
C1117 - (VIO) Date Violation Data Inserted,
C1121 - (VIO) HCL Analysis Method Code,
C1123 - (VIO) HCL Analysis Result,
C1125 - (VIO) HCL Violated,
C1127 - (VIO) HON Number of Samples Required,
C1129 - (VIO) HON Nuifcer of Samples Taken,
C1131 - (VIO) HON Major Vio. Designation Code,
C1133 - (VIO) Date Violation Data Last Updated,
C1135 - (VIO) Fiscal Year,
C1137 - (VIO) Data Origin Code,
C1143 - (VIO) Source/Entity ID,
All,
or None: CI103,CI105
--> Among the Violation Specific data elements, must ALL of your selection
criteria be met before a PUS qualifies for retrieval?
(Y)es or (N)o: /
--> C1103 - (VIO) Contaminant Code(s): ?
Codes for REGULATED contaminants (through Phase I I/I IB) are:
Physical Contaminants
Inorganic Contaminants
Prior to Phase II
Phase II & IIB
0100 Turbidity
1005 Arsenic
1010 Barium
1015 Cadmiun
1020 Chromiun
1025 Fluoride
1030 Lead
1035 Mercury
1040 Nitrate (as N)
1045 Seleniun
1050 Silver
1041 Nitrite (as N)
1094 Asbestos
Page: 4-18
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Phase II Unregulated Inorganics
M&R only
1024
Cyanide
M&R only
1036
Nickel
HSR only
105S
Sulfate
M&R only
1074
Antimony
HSR only
1075
Beryl I inn
HSR only
1085
Thai t inn
Organic Contaminants
TTHM
2950
TTHM
SOCs (Prior to Phase II)
2005
Endrin
2010
Lindane
2015
Methoxychlor
2020
Toxaphene
2105
2,4-D
2110
2,4,5-TP (Silvex)
SOCs (Phase II & 1IB)
2043
Aldicarb sulfoxide
2044
Aldicarb sulfone
2046
Carbofuran
2047
Aldicarb
Press to continue .
2050
Atrazine
2051
Alachlor (Lasso)
2065
Heptachlor
2067
Heptachlor epoxide
2326
Pentachlorophenol
2383
Polychlorinated biphenyls (PCBs)
2931
Dibromochloropropane (OBCP)
2946
Ethylene dibrcmide (EOS)
2959
Chlordane
Phase I VOCs
2969
p-0ichIorobenzene
2976
Vinyl chloride
2977
1,1-Dichloroethylene
2980
1,2-DichIoroethane
2981
1,1,1-Tnchloroethane
2982
Carbon tetrachloride
2984
Trichloroethylene
2990
Benzene
Phase 1 I/I IB VOCs
2380
cis-1,2-Dichloroethylene
2955
Xylene (total)
2968
o-DichIorobenzene
Press to continue .
, ,
2979
trans-1,2-Dichloroethylene
2983
1,2-DichIoropropane
2987
Tetrachloroethylene
2989
HonochIorobenzene
2991
Toluene
2992
Ethyl benzene
2996
Styrene
Phase 1 Unregulated Organics
M&R only
2030
p-lsopropyI toluene (Cymene)
M&R only
2212
0ichIorodifIuoromethane
M&R only
2218
T nchlorof luoromethane
M&R only
2246
Hexachlorobutadiene
Effective Date- 12/31/92
Release: 2.00
Page: 4-19
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
H&R
only
2248
Napthalene
H&R
only
2378
1,2,4-Trichlorobenzene
H&R
only
2418
1,2,4-Trimethylbenzene
H&R
only
2420
1,2,3-T richlorobenzene
M&R
only
2422
n-8utylbenzene
H&R
only
2424
1,3,5-TrimethyIbenzene
H&R
only
2426
tert-Butylbenzene
H&R
only
2428
sec-ButyIbenzene
H&R
only
2430
Bromochloromethane
H&R
only
2994
IsopropyIbenzene
H&R
only
2998
n-Propylbenzene
H&R
only
2210
Chloromethane
H&R
only
2214
Bromomethane
H&R
only
2216
Chloroethane
Phase I H&R
only
2380
cis-1,2-Dichloroethylene
H&R
only
2408
0lbromomethane
H&R
only
2410
1,1-Dichloropropene
H&R
only
2412
1,3-0ichIoropropane
H&R
only
2413
1,3-Dichloropropene
H&R
only
2414
1,2,3-Trichloropropane
H&R
only
2416
2,2-D ichIoropropane
Phase 1 H&R
only
2931
OibromochIoropropane (DBCP)
H&R
only
2941
Chloroform
H&R
only
2942
Bromoform
H&R
only
2943
Bromodichloromethane
H&R
only
2944
DibromochIoromethane
Phase I H&R
only
2946
Ethylene dibromide (EOB)
H&R
only
2962
p-Xylene
H&R
only
2964
Dichtoromethane
H&R
only
2965
o-Chlorotoluene
Press to continue
. .
H&R
only
2966
p-Chlorotoluene
H&R
only
2967
m-Dichlorobenzene
Phase 1 H&R
only
2968
o-OlchIorobenzene
H&R
only
2978
1,1-Dichloroethane
Phase 1 H&R
only
2979
trans-1,2-Oichloroethylene
Phase 1 M&R
only
2983
1,2-01 ch I oropropane
H&R
only
2985
1,1,2-Trichloroethane
H&R
only
2986
1,1,1,2-Tetrachloroethane
Phase I H&R
only
2987
Tetrachloroethylene
H&R
only
2988
1,1,2,2-Tetraehloroethane
Phase I H&R
only
2989
MonochIorobenzene
Phase I H&R
only
2991
Toluene
Phase I H&R
only
2992
Ethylbenzene
H&R
only
2993
Bromobenzene
M&R
only
2995
m-Xylene
Phase 1 M&R
only
2996
Styrene
M&R
only
2997
o-Xylene
Phase II Unregulated Organics
H&R only
2021
Carbaryl
H&R
only
2022
Hethomyl
H&R only
2031
Dalapon
Press to continue
. ,
H&R
only
2031
Oiquat
H&R
only
2033
EndothalI
H&R only
2034
Glyphosate
H&R
only
2035
D i (2-ethyl exyUadi pate
H&R
only
2036
OxamyI (Vydate)
H&R
only
2037
Simazine
M&R
only
2039
Di <2-ethytexyl)phthalates
Page: 4 - 20
Release: 2.00
Effective Date- 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using (he Main Menu December 31, 1992
2040
Picloram
2041
Dinoseb
2042
Hexach lorocyc 1 open t ad i ene
2045
Metholachlor
2063
2,3,7,8-TCDD (Dioxin)
2064
3 -Hydroxycarbofuran
2070
Dieldrin
2076
ButacMor
2077
Prapachlor
2274
Hexachlorobenzene (HCB)
2306
Benzo(a)pyrene
2356
Aldrin
2440
Dicantoa
2595
Hetribuiio
MR only
HSR only
HSR only
HSR only
HSR only
HSR only
HSR only
HSR only
HSR only
HSR onty
HSR only
H&R only
HSR only
H&R only
Press to continue ...
Microbiological Contaminants 3000
3100
Radiological Contaminants 4000
4010
4020
MHO
4100
Celifcrm (pre-ICR)
Coliform (ICR)
Gross Alpha, Including Ra-226 but
excluding Radon and Uranium
Combined Ra-226 & Ra-228
Radian-226
Kad;iMvZ2B
Gross Beta Particle Activity
-¦> For which Contaminant Group would you like a conpretiensive code listing?
1--- (Inorganic Contaminants),
2--- (Organic Contaminants},
(Radiological Contaminants),
or Hone: NONE
--> C1103 • (V10) Contaminant Code(s): 29S0
--» CMOS - (VIO) Type Code: LE02/03/04
Do you want to restrict your search based upon Enforcement
Characteristics'' (Y)es or (N)o: REVIEW
L0CME(15>
CI100 UH t HK
( C3 EQ
CI EQ 06 > AMD
TX
>
AND
( ( MX C309 HE
H
)
AND
( NK C1Q7 EQ
A
)
AND
( NK C105 EQ
C
OR
KK C105 EQ
P
)
)
AND
( ( NK C1135 EQ
92
)
AND
( NK C1103 EQ
2950
>
AND
C NIC C1105 LE
02
OR
NK CI105 EQ
03
OR
NK CI105 EQ
04
)
--> Do you want to restrict your search based upon Enforcement
Characteristics' (T)es or (N)o: K
--> For which Enforcement Sub-group(s) do you want to specify selection
en teria?
C1200 - Enforcement Specific Data Elements (ENF),
C1350 - Enforcement Related NCP Data Elements (ENF/MCP),
AIL,
or None: NONE
Effective Date: 12/31/92 Release: 2.00 Page 4-21
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
--> Do you want to restrict your search based upon Variance/Exemption
Characteristics' (Y)es or (N)o: Y
--> For which Variance/Exemption Sub-group(s) do you want to specify
selection criteria'
C3000 - Variance/Exemption Specific Data Elements (VE),
C3100 - Variance/Exemption Schedule Data Elements (VE-SCHED),
All,
or None: ALL
--> 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 Date,
C3009 - (VE) Expiration Date,
C3011 - (VE) Status Code,
C3013 - (VE) Modified HCL,
C3015 - (VE) Required Treatment Process Code,
C3017 - (VE) Alternative Treatment Process Code,
C3019 - (VE) Reason Code,
C3021 - (VE) Date VE/Other Data last Updated,
C3023 - (VE) Fiscal Year,
C3025 - (VE) Data Origin Code,
C3031 - (VE) Source/Entity ID,
C3033 - (VE) Date VE/Other Data Inserted,
All,
or None: NONE
--> C3100 - For which Variance/Exefnption Schedule data elements do you want
to specify values that restrict your search'
C3101 - (VE-SCHED) ID,
C3103 - (VE-SCHED) Scheduled Action Code,
C3105 - (VE-SCHEO) Date Action Scheduled,
C3107 - (VE-SCHED) Date Scheduled Action Corrpleted,
All,
or None: NONE
> Do you want to restrict your search based upon State Discretionary Data
Characteristics' (Y)es or (N)o: N
--> Do you want to restrict your search based upon Data Base Administrator
Data Characteristics' (Y)es or (N)o: N
LOCATE(15) C1100 UH ( NK C1 EQ 06 ) AND
(
C3 E0
TX
)
AND
( (
NK C109 NE
H
)
AND
(
NK C107 EQ
A
)
AND
(
NK C105 EO
C
OR
NK C105 EQ
P
)
)
AND
( (
NK CI135 EQ
92
)
AND
(
NK CI103 EQ
2950
)
AND
(
NK C1105 LE
02
OR
NK CI105 EO
03
OR
NK CI105 EQ
04
)
)
--> Is the Locate statement displayed above correct' (Y)es or (N)o: Y
Page: 4 - 22
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Searching ... Please do not interrupt
Search completion pending ...
Successful Locate —
201 PWS(s) found match your criteria
-•> Enter function Code, END, or MENU:
Effective Date: 12/31/92
Release: 2.00
Page: 4-23
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.3 Function 'D' - Display Of FRDS-n/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' allows the user to review all of the FRDS II/Interactive Broadcast and
System Messages.
The sample session on the next page shows how to use Function 'D.'
Page: 4 - 24
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION D
--> Enter Function Code, END, or MENU: D
--> Would you like to display (B)roadcast, (S)ystem, or (N)either
Messages: B
* General Broadcast Messages for the FROS-II System follow ... *
* ** Messages Last Updated on Friday, December 18, 1992 ** *
ATTENTION ALL FRDS USERS: Production Control and User Support's
new "Hotline" nuiber is (705) 908-2460. Use BZM for UMAIL messages.
Many users have been experiencing problems with getting results
from Locate Statements and S2K SCF commands which involve a large
amount of sorting. Users were being thrown out to the TSO READY
prompt without any warning.
A temporary fix has been put in place which should solve these
problems. Anyone who still experiences this problem should contact
FRDS User Support at the above nunber.
FRDS-II System Messages were Last Updated on Monday 3/16/92.
* End of General Broadcast Messages for the FRDS-II System *
I******#*#*****#*#*****#******************#******#****************
Press to continue ...
• FRDS/Interactive Broadcast Messages for FRDS-II follow... *
* ** Messages Last Updated on Friday, Hay 29, 1992 ** *
***********************************************************************
At long last the new sunmary report for Enforcement Actions is now
available. The new report aggregates the nuiber of Enforcements (the
17A) or the nunber of system with Enforcements (the 17B) by population
sizes by State.
The FRDS 17 Report should be generated after issuing a Locate
Statement retrieving by C1200 (not C100 or C1100) and generally should
be restricted by federal fiscal year (C1209) as well.
ft********************************************#*************************
* End of FRDS/Interactive Broadcast Messages for FRDS-II *
#*#**#***********#***#***##***************************•***•************
Press to continue ...
Effective Date: 12/31/92
Release: 2.00
Page: 4-25
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.4 Function 'E' - Retrieve PWSs Whose IDs Are In An External File
The Main Menu offers the option of retrieving Public Water Systems whose PWS IDs are
contained in an external file.
Selecting Function 'E' allows the user to access the PWS ID Retrieval Menu. This function
enables the user to retrieve PWSs by using a previously created file containing PWS IDs for
selection. This file can be created by the user or created by the following batch reports:
FRDS04, FRDS32, and FRDS35.
The sample session on the next page shows how to use Function 'E.'
Page: 4 - 26
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION E
--> Enter Function Code, END, or MENU: E
Enter the fully qualified data set name of the file containing PUS
(• to exit) then press
IDs,
Note: PUS IDs must be in the first nine positions of this file'
Data set name: ?
ft fully qualified data set name consists of a User ID and
Account nuifcer (i.e., UUUAAAA), followed by a period and
one or more sets of one to eight characters separated by
periods. For example: UUUAAA^.name.of.my.pwsid.file
At a minimum, you must enter a User ID & Account number, a
period, and at least one alphabetic character. Example:
UUUAAAA.f
Or, in other uords, nine total characters.
At a maxinun, a fully qualified data set name cannot
exceed forty-four (44) total characters.
For a PUS ID file to be valid, the PUS ID must be in the
first nine positions of the file, and the file's logical
record length (i.e., LRECl) CANNOT exceed 2500 characters.
Enter the fully qualified data set name of the file containing PUS
(i to exit) then press
IDs,
Mote: PUS IDs must be in the first nine positions of this file'
--> Data set name: uuuaaaa.t>9206l0.TlS2324.PWSIDS
Locating PUSs in Data Base - One moment please
Successful Locate ...
PUS ID file name processed: uuuaaaa.Q920610.T182324.PUSIDS
PUS IDs in file processed: 25
PUSs located in Data Base: 25
Press to continue ...
FRDS-11/Interactlve
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (Q) Quicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code which corresponds to the desired Post Retrieval
Output Option:
Effective Date 12/31/92
Release- 2 00
Page 4-27
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.5 Function 'G' - Obtain Geographic Information For A Specified City, County, Or
U. S. Postal Service (USPS) Zip Code
The Main Menu offers the option of obtaining geographic information for a specified City,
County, or USPS Zip Code.
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. Zip Code does not require the State abbreviation.
The following sample session shows how to use Function 'G.'
Page: 4 - 28
Release: 2 00
Effective Dale 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using (he Main Menu
SDC-0055-005-LN-2005
December 31, 1992
FUNCTION G
-¦> Enter Function Code, END, or MENU: G
You have invoked the GEOGRAPHIC Help function
You will be asked to enter the name of a City or County
with the State abbreviation or a U. S. Postal Service Zip Code
for the area(s) you desire geographic information.
** NOTE ** This geographic information was compiled in 1988
and does not reflect any subsequent updates.
--> Do you want Geographic information'
--> Please enter (Y)es or (N)o: Y
--> Enter City Name or press Enter the State abbreviation: TX
FIPS Hydro
State County MSA Unit
City Name Code Code Code Code Latitude Longitude
AUSTIN TX 053 :::: 12090205 301600 974434
--> Would you like more Geographic information''
--> Please enter (Y)es or (N)o: V
--> Enter City Name or press to enter a County:
DALLAS
--> Enter the State abbreviation: TX
FIPS Hydro
State County MSA Unit
City Name Code Code Code Code Latitude Longitude
DALLAS TX 085 1920 12030105 324659 964800
--> Would you like more Geographic information"'
--> Please enter (Y)es or (N)o: N
--> Enter Function Code, END, or MENU: END
Effective Date: 12/31/92
Release: 2.00
Page. 4 - 29
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.6 Function 'P' - Post Retrieval Output Options
The Main Menu offers the Post Retrieval Output Options selection. The Post Retrieval
Output Options selection allows the user to access the Post Retrieval Output Options Menu
using previously selected data* without regenerating a query or reselecting the data.
Selecting Function 'P* allows the user to access the Post Retrieval Output Options Menu
using data already selected by a previous data selection criteria statement in Function 'A',
'E\ 'X', or 'Z' of the Main Menu.
For further details on the Post Retrieval Output Options Menu, refer to Section 5.
FUNCTION P
--> Enter Function Code, END, or HENU: P
* "P" not allowed - Select data first
--> Enter Function Code, END, or MENU: P
FRDS-1[/Interactive
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (0) Quick look Report Generator
(F-) Frequency Distribution
(E) End Post Retrieval
> Enter the Code which corresponds to the desired Post Retrieval
Output Option:
Page: 4 - 30
Release: 2.00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.7 Function 'S' - Enter The System 2000 Self-Contained Facility (Natural
Language)
The Main Menu offers the S2K self-contained facility selection allowing the user to formulate
queries and generate variable format ad hoc reports of selected data from the FRDS-II Data
Base.
The user interactively creates a set of S2K commands to select the desired data and format a
report. These commands may come either from a command file or the user's 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 with S2K commands, the user responds to system prompts in allocating
data set(s) for the report(s). The user can submit off-line batch job(s) to pnnt any
combination of the report data groups.
The sample session on the next page shows how to use Function 'S'. By selecting Function
87 the user accesses the S2K self-contained facility as well.
Effective Date: 12/31/92
Release: 2.00
Page- 4-31
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Main Menu December 31, 1992
FUNCTION S or 87
READY
EX FRDSONII
Loading FRDSONII ... One moment please 11
= Welcome to the Federal Reporting Data System (FRDS-II) =
= On-Lirve 111 =
= FRDSONI1 version 2.2 Effective date: 06/26/91 =
= Date: 06/11/92 Time: 05:34:30 =
= ********** SPECIAL NOTICE **********
= In order to use FRDS-II / Interactive, you MUST =
= specify SI2E (8500) and PROCEDURE (SEPATSO) during =
= your TSO logon. =
= If you didn't specify the correct SIZE or PROCEDURE, =
= logon again using the values indicated above ... =
Press to continue ...
= Federal Reporting Data System (FRDS-
-II) On-Line =
PRODUCTION HEN
U
= FRDSONI1 version 2.2 Effective date: 06/26/91 =
= Function Description
Code =
= End Session and Return to TSO
0 (zero) =
= FRDS-II / Interactive
1 =
= Natural Language Interface
87
= End Session and Logoff TSO
99
-•> Enter Function Code ...87
Loading Natural Language Interface ... One moment please "
Welcome to the Natural Language Interface
for FRDS-II
Version: 1.0 Release: 1.1
07/27/90 11.37.08
Page: 4-32
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Your Natural Language Interface Session initiated at ...
05:34:43 on Thursday, June 11, 1992
--> Would you like instructions on the use of the FRDS-II Natural
Language
Interface? (Y)es or (N)o: Y
The FRDS-II Natural Language Interface permits a user to submit S2K
batch jobs and/or enter the SYSTEM 2000 Self-contained Facility (SCF)
(i.e.. Natural Language).
The user may use up to 10 previously created command files and have
the system create up to 10 report files for use in S2K batch jobs
and/or an SCF session.
If you do not understand any prompt issued, enter a question mark
C) or the word "HELP" to obtain more information.
Please note: The FRDS-II Natural Language Interface docunentation is
not yet available 1>
DO NOT TRY TO PRINT THE DOCUMENTATION WHEN ASKED ...
Press to continue ...
--> Would you like to print a copy of the FRDS-II Natural Language
Interface docunentation'' (Y)es or (N)o: ?
Enter a single letter which represents your desired response to the
question, then press .
Enter the letter Y (i.e., Yes) if you would like to print a copy of
the FRDS-II Natural Language Interface docunentation.
Enter the letter N (i.e., No) if you don't want to print a copy of
the docunentation at this time.
--> Would you like to print a copy of the FRDS-II Natural Language
Interface docunentation''
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Main Menu
Enter the letter Y (i.e.. Yes) if you would like to submit one or more
S2K batch jobs, or if you would like to use one or more command files
during a Self-contained Facility (SCF) (i.e., Natural Language) session.
Enter the letter N (i.e.. No) if you do not want to submit an S2K batch job,
or you do not plan to utilize any command files during your SCF session.
If you intend to submit an S2K batch job, you MUST specify a command file ¦
--> Would you like to use any command files during this Natural Language
Interface session? (Y)es or (N)o: N
If you intend to submit an S2K batch job, you MUST create a report file ¦
--> Would you like to create any report files for use during this Natural
Language Interface session' (Y)es or (N)o: »
A report file is an external dataset that will be created by this program for
you, if desired. You can then direct SYSTEM 2000 to place its output into a
report file rather than viewing it at your terminal.
A maximun of 10 report files can be created for use during a Natural Language
Interface Session.
Enter a single letter which represents your desired response to the question,
then press .
Enter the letter Y (i.e., Yes) if you would like to submit one or more S2K
batch jobs, or if you would like to use one or more report files during a
Self-contained Facility (SCF) (i.e.. Natural Language) session.
Enter the letter N (i.e., No) if you do not want to submit an S2K batch job,
or you do not plan to utilize any report files during your SCF session.
If you intend to submit an S2K batch job, you MUST create a report file '
--> Would you like to create any report files for use during this Natural
Language Interface session' (Y)es or (N)o: Y
- -> How many' I
Below, you must specify the anticipated size of each report file that will be
created for your use.
Page' 4 - 34
Release 2 00
Effective Date. 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
CAUTION ... Specifying a size that is too small may result in abnormal
termination of an S2K batch job or SCF session. Specifying a size that is too
large wastes valuable resources and results in excessive disk storage charges.
« Report file nurber 01 of 01 »
--> Size' (S)mall, (M)ediuii, (L)arge, or E(X)tra-large: 5
Submission of an S2K batch job is not possible since you did not specify a
command file that would be used for the job.
--> Would you like to enter the SYSTEM 2000 Self-contained Facility (SCF)
(i.e., Natural language)? (Y)es or (N)o: ?
Enter a single letter which represents your desired response to the question,
then press .
Enter the letter Y (i.e.. Yes) if you would like to enter the SYSTEM 2000 Self-
contained Facility (SCF) (i.e.. Natural Language).
Enter the letter N (i.e.. No) if you do not want to enter the S2K SCF.
Those unfamiliar with SYSTEM 2000 and/or SCF should respond with the letter N.
--> Would you like to enter the SYSTEM 2000 Self-contained Facility (SCF)
(i.e.. Natural Language)? (Y)es or (N)o: Y
No conmand files have been specified for use in your SCF session '
Press to continue ...
Please note: To start placing output into a report file, enter:
The following report files that HAVE NOT BEEN USED in an S2K batch job may be
utilized during your SCF session:
REPORT FILE IS REPORTnn: (nn is the report file number)
To stop the placement of output into a report file, enter:
REPORT FILE IS OUTPUT:
RPT File «<< Report file dataset name >>>>
Size <<<<<< Corment >>>>>>>
REPORT01 wwwyyyy.0920611.T054854.REPORTOI
S Less than 250 pages
Press to continue ...
Loading SCF ... One moment please 11
06/11/92 05:49:47 BEGIN SYSTEM 2000 - RELEASE 11.6-01
COPYRIGHT (C) 1985 SAS INSTITUTE INC., CARY, N.C 27512, U.S A. -
USER, EPA:
ECHO OFF:
-556- OPENED FR0SII
13 2918 06/08/1992 19:37:57
COMMAND FILE IS SYSIN:
Effective Date: 12/31/92
Release: 2.00
Page 4-35
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
S DC-0055-005- LN -2005
December 31, 1992
The following report file was created at the beginning of this session. Since
you did not use it in an S2K batch job, it is assured that you placed output
from an SCF session into it. Therefore ...
RPT File <«< Report file dataset name »>> Size <<<<<< Comment >>>>>>>
REPORTOI wwwyyyy.0920611.T054854.REPORT01 S Less than 250 pages
--> Oo you want to print this report file' (Y)es or (N)o: N
The following report file was created at the beginning of this session. Since
you did not use it in an S2K batch job, or choose to print it when given the
opportunity ...
RPT File «<< Report file dataset name »>> Size <<<<<< Comment >>>>>>>
REPORT01 wwwyyyy.D920611.T054854.REPORT01 S Less than 250 pages
--> Do you want to delete this report file' (Y)es or (N)o: Y
Your Natural Language Interface Session terminated at ...
05:50:14 on Thursday, June 11, 1992
Elapsed time of Session ...
00:01:21
End of the Natural Language Interface
for FRDS-II
Press to continue ...
Page. 4 - 36
Release. 2 00
Effective Dale 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.8 User-defined Query
User-defined query allows the user to enter a user formulated data selection criteria
statement. The system then offers an opportunity to submit the statement as a query to the
data base or formulate and enter a new statement. When a query is submitted, the system
checks 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 or
PWSs with violations to a specific fiscal year, the are to use the data elements that have been
provided in FRDS-II to accomplish this.
There are two user-defined query retrieval selections. A discussion of each selection
follows.
4.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
the user to perform up to 11 unrelated searches. The results of each search are stored in
locate data storage areas consisting of up to 11 separate data files numbered from 0 through
10. These files are retained until the end of the FRDS-II/Interactive session, unless
overwritten by the execution of another locate statement. After the user has selected PWSs
using Function 'X', he/she can request any of the created locate data files can be used for
further output processing. Not specifying a locate file number has the same effect as
specifying locate file 0.
The sample session on the next two pages show how to use Function 'X'.
Effective Date: 12/31/92
Release: 2.00
Page- 4 - 37
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 3 I, 1992
FUNCTION X
--> Enter Function Code, END, or MENU: X
Enter your S2K Locate cotrenand on the following lines:
NOTE: You may enter multiple Locates using Locate Files 0 to 10.
Each Locate command can be from 1 to 20 lines of not
more than 70 characters per line.
Your command MUST start on the first line.
Your command MUST start in colum 1 of each line.
Your completed comnand MUST end uith a COLON.
To re-enter a Locate command from the beginning press
the or key.
When finished, enter the keyword EXIT without a Colon
Enter your S2K Locate command on the following lines:
- - > LOCA TE C100 WHERE CI 15 SPANS fK AND C3 EQ TX.
IS THIS THE LOCATE STATEMENT YOU WANT TO PROCESS7
LOCATE C100 WHERE C115 SPANS I*K AND C3 EO TX:
--> (Y)es or (N)o: Y
Searching ... Please do not interrupt
Search completion pending
Successful Locete
44 PWS(s) found matching your criteria
Page: 4 - 38
Release: 2.00
Effective Date. 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
Enter your S2K Locate command on the following lines:
- - > LOC (1) CI 100 WH NK CI 135 EQ 92 AND C3 EQ TX:
IS THIS THE LOCATE STATEMENT YOU WANT TO PROCESS'
LOC (1) C1100 UH NK C1135 EQ 92 AND C3 EQ TX:
--> (Y)es or (N)o: Y
Searching — Please do not interrupt
Search completion pending
Successful Locate ...
3,396 Violations found among 1,098 PUS(s) matching your criteria
Enter your S2K Locate conmand on the following lines:
- - > LOC 01 C120O WH NK C1209 EQ 91 AND NK C103 EQ CAC AND C3 EQ TX:
IS THIS THE LOCATE STATEMENT YOU UANT TO PROCESS'
LOC (2) C1200 UH NK C1209 EO 91 AND NK C103 EQ CAC AND C3 EQ TX:
--> (Y)es or (N)o: Y
Searching ... Please do not interrupt
Search completion pending ...
Successful Locate ...
3,327 Enforcements found among 1,102 PWS(s) matching your criteria
ft****************************************************************************
Enter your S2K Locate conmand on the following tines:
- - > LOCA TE 0) CI 100 WH SAME LOC(l) AND NK C103 EQ CAC.
IS THIS THE LOCATE STATEMENT YOU WANT TO PROCESS'
LOCATE (3) C1100 UH SAME L0C(1) AND NK C103 EQ CAC:
(Y)es or EXIT
Record selection complete ...
Do you wish to use one of your previously established LOCATE's
--> Enter (Y)es, (N)o, ', or Locate File #: Y
••> File#: 0
Effective Date: 12/31/92
Release: 2.00
Page- 4 - 39
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Main Menu
SDC-0055-005-LN-2005
December 31, 1992
4.2.8.2 Function 'Z' - Formulate Non-prompted Retrieval Selection Clauses
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 the
data selection criteria.
This differs from Function 'X' 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 scar, 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 'Z' is a non-prompted S2K locate statement facility allowing the user to perform up
to 11 unrelated searches. The results of each search are stored in locate data storage areas,
consisting of up to 11 separate data files numbered from 0 through 10. These files are
retained until the end of the FRDS-II/Interactive session, unless overwritten by the execution
of another locate statement. After selecting PWSs using Function 'Z,' the user can request
any of the created locate data files for further output processing. (See Section 5, Using The
Post Retrieval Ouput Options Menu.)
The sample session on the next page shows how to use Function 'Z\
Page: 4-40
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Main Menu December 31, 1992
FUNCTION Z
--> Enter Function Code, END, or MENU: Z
Enter your S2K Locate command on the following lines:
NOTE: You may enter multiple Locates using Locate Files 0 to 10.
Each Locate conrnand can be from 1 to 20 lines of not
more than 70 characters per line.
Your command MUST start on the first line.
Your command MUST start in colunn 1 of each line.
Your completed command MUST end with a COLON.
To re-enter a Locate comnand from the beginning press
the or key.
When finished, enter the keyword EXIT without a Colon
- -> LOCATE CI00 WH CllS SPANS l*K AND C3 EQ TX:
IS THIS THE LOCATE STATEMENT YOU WANT TO PROCESS?
LOCATE C100 UH CI15 SPANS I*K AND C3 EO TX:
--> (Y)es or (N)o: Y
Checking your Locate statement ...
Syntax check complete ...
Successful scan of your Locate statement ...
Enter your S2K Locate comnand on the following lines:
--> EXIT
Record selection complete ...
Do you wish to use one of your previously established LOCATE's
--> Enter (Y)es, (N)o, ?, or Locate File U: 0
********** FRDS-II Phase 1 Reports **********
REPORTS 1, 3, 4, 7, 17, 19, 20, 24, 31, 32, 35, & 43 ARE AVAILABLE
********** FRDS-II Phase 2 Reports **********
REPORTS 18, 21, 22, 23, 36 & 42 ARE NOT AVAILABLE
--> Enter the number of the desired FRDS report: I
--> Do you wish to add an additional identifying title line to your
FRDS01 report' (Y)es or Do you want to sort the report data? (Y)es or (M)o: Y
--> Sort on EPA region' (Y)es or (N)o: N
--> Sort on State'
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Main Menu December 31, 1992
Select one of the following minor sort sequences:
0 = None
1 = PUS ID
2 = PWS Type, PUS ID
3 = Retail Population Served (descending sequence), PUS ID
4 = Primary Source, PUS ID
5 = System City Name, PUS ID
6 = System Name, PUS ID
7 = System ZIP Code, PUS ID
--> Minor sort sequence nunber; I
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Huuu
Estimated Time: Short
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)©' K
Job 11877 Submitted ...
--> Uould you like to submit another FRDS report' (Y)es or (N)o: N
Page: 4 - 42
Release- 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
SECTION 5
USING THE POST RETRIEVAL OUTPUT OPTIONS MENU
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
Section 5 Using The Post Retrieval Output Options Menu
5.1 Description Of The Post Retrieval Output Options Menu
After data has been selected and successfully retrieved the system displays the Post Retrieval
Output Options Menu. Selections determine ways to process and report data.
The following sample session shows how to use the Post Retrieval Output Options Menu to
select the Batch Job Submission option. A description and examples of each of these options
are included in this section.
POST RETRIEVAL OUTPUT OPTIONS MENU
FRDS-II/Interactive
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (0) Ouicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
> Enter the Code which corresponds to the desired Post Retrieval
Output Option: B
5.2 Post Retrieval Output Options Menu Selections And Report Examples
The chart on the next page summarizes the unique features of each Post Retrieval Output
Options Menu selection.
A discussion of each Post Retrieval Output Options Menu selection follows. A sample
session and a report example are featured for each selection. Where necessary, reports have
been annotated with data elements and notes. The users' responses to dialogs have been
italicized.
Effective Date: 12/31/92
Release: 2.00
Page 5 - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
POST RETRIEVAL OUTPUT OPTIONS
SELECTION
Option 'B'
Option 'C'
Option 'F'
Option 'L'
Option 'Q'
Option 'E'
TITLE
Batch Job Submission
Create an External File
(FILEGEN)
Frequency Distribution
List in Standard Screen
Format
Quicklook Report Generator
End Post Retrieval
FEATURES
Provides information relating to
PWS inventory, enforcement
actions, violations, and variances
and exemptions in detailed and
summary listing formats.
Creates flat sequential files (1 e ,
for downloading to a PC), can
also be used to satisfy FOIA
requests (Freedom of Information
Act.)
Provides a frequency distribution
table of unique code value
occurrences for a specified data
element based upon the currently
selected PWS(s).
Provides up to five screens of
information relating to inventory,
source, violations, variance and
exemptions, and enforcements, in
detailed listing format.
Permits the user to design and
pnnt a report according to the
user's own specifications.
Terminates Post Retrieval
processing and returns user to
Main menu function selection.
Page: 5-2
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1 Option 'B' - Batch Job Submission
Option 'B' of the Post Retrieval Output 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
output 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. For most of
the reports, the user may also select a predefined sort order, if desired.
Each standard batch report begins with data selection criteria information, the sort order of
PWSs if applicable, and the total number of PWSs reported on. FRDS01, FRDS03,
FRDS04, FRDS07, FRDS24, FRDS32A,FRDS35, and FRDS43 are detailed reports.
FRDS17, FRDS19, FRDS20, FRDS31 and FRDS32BC, are summary reports.
The sample session that follows shows how to use Option 'B'. Report examples of the
standard batch reports available through Option 'B' are provided in Sections 5.2.1.1 through
5.2 1.12.
OPTION B
FRDS-11/Interactive
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (Q) Quicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code which corresponds to the desired Post Retrieval
Output Option: B
********** frds-II Phase 1 Reports **********
REPORTS 1, 3, 4, 7, 17, 19, 20, 24, 31, 32, 35, & 43 ARE AVAILABLE
********** frds-II Phase 2 Reports **•*•**«*«
REPORTS 18, 21, 22, 23, 36, 41, & 42 ARE NOT AVAILABLE
--> Enter the nunber of the desired FRDS report: 03
Effective Date: 12/31/92
Release: 2.00
Page- 5 - 3
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.1 FRDS01 - Public Water System Comprehensive Report
FRDS01 is the Public Water System Comprehensive Report which provides a summary (i.e.,
formatted dump) of the inventory data for each PWS. It allows the user to select a title and
determine the sorted order in which the PWSs are presented.
The report presents a cover page with the report selection criteria: locate statement used,
sort fields, and the number of PWSs selected for the report.
A report dialog screen and annotated example reports are shown on the next four pages.
Page: 5 - 4
Release: 2.00 Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Post Retrieval Output Options Menu December 31, 1992
FRDS01 DIALOG
PROS*11/Interactlve
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (Q) Quicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code uhich corresponds to the desired Post Retrieval
Output Option: B
********** frds-II Phase 1 Reports •******••«
REPORTS 1, 3, 4, 7, 17, 19, 20, 24, 31, 32, 35, & 43 ARE AVAILABLE
********** FRDS-II Phase 2 Reports **********
REPORTS 18, 21, 22, 23, 36, 41, & 42 ARE NOT AVAILABLE
--> Enter the nuifcer of the desired FRDS report: 01
--> Do you wish to add an additional identifying title line to your
FRDS01 report' Do you want to sort the report data' Sort on EPA region' (Y)es or (N)o: N
--> Sort on State' (Y)es or (N)o: N
Select one of the following minor sort sequences:
0 = None
1 = PUS 10
2 = PUS Type, PUS ID
3 = Retail Population Served (descending sequence), PUS ID
4 = Primary Source, PUS ID
5 = System City Name, PUS ID
6 = System Name, PUS ID
7 = System ZIP Code, PUS ID
--> Minor sort sequence nurber: I
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Mediim
Priority: 2
Printer Type- Destination
Copies of Report. 01
--> Are these parameters correct' (Y)es or (N)o' Y
Job 20190 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Effective Date: 12/31/92
Release 2.00
Page. 5 - 5
-------
10/14/92
FRDS01
FEDERAL REPORTING DATA SYSTEM - FRDS-II
REPORT SELECTION CRITERIA
LOCATE STATEHOnMS) USED FOR REPORT.
LOCATE (Ot C100 WH C11S SPANS I'K AND CJ EQ TX.
THE FOLLOWING SCHEMA ITEMS WERE USED FOR SORTING.
SORTED DV PMS ID
PUBLIC WATER SYSTEMS SELECTED FOR THE REPORT.
-------
10/14/92
PRDS01
IC^I I
IP^3I
FEDERAL REPORTING DATA SYSTEM - PROS-II
PUBLIC MATER SYSTEM - COMPREHENSIVE REPORT
EPA REGION. 06 PRIHACY STATE: TX
[mil ^ SVSTEM NAME i TEMPLE CITY OP
SYSTEM ADORESS: ATTO: B. JONES
4620 PARKS IDE OR -4
E52^
PRIMACYJ Y
PAGE
SORTED BY PWS 10
FWS ID: TX014000S*
PHONE t -«
TEMPLE
ADDRESSES.
ADDA.
TYPE.
NAME
A DDR.
CI 17
TX 76502
~
GRANT ELIGIBLE
STATUS
PLANT TYPE
OWNER TYPE
Y -
CAC-
C „
4 _
HSU
aid
IC3Q9r^
O - SYSTEM OWNER/RESPONSIBLE PARTY
S. SMITH
BUILDING 6 APT 104
1NDUSTOY ROAD
PLE
76502
PLANT SERVICE AREA. C INDICATES PRIMARY SERVICE AREA)
ID fcToTl MAJOR CATEGORY Ji „il lI SUBCATEGORIES
IC601I 01
VISITS: NONE
ACTIVE INDICATOR
POPULATION SERVED:
REGULATE BY
SURFACE %
'RESIDENTIAL
GEOGRAPHIC AREAS SERVEO
Ttshi
IHV UPDATE DATE ^^"05/26/92
NUMBER OP SERVICES! 22,2£0
INV INSERT DATE i 01/14/60
OROUND % :
lcnn
IC147I
jf BEG 11
SEAS'
LAST
^ PUR
IC1681
BEGIN DATE i
SEASON START i
LAST UPDATE DATE I
SURPACE «
DEACTIVATION DATE:
SEASON END
OS/26/92 PRIMARY SOURCE
GROUND t
PUR
ici69i
|C501|-^ 01
SOURCE < SRC |T/ENTRY I POINT iepti /
1 <9 A 1/1 d
ICS07I 11
ADMIN ADMIN CONG STATE FIPS lC5Q9l INDIAN
ID REGION DIST ^ DIST COUNTY COUNTY^* MSA RESV CD CITY
014 027 3B10
(PLT) INFORMATION:
•^^"San
C513I
TYPE ID NAME
I DATA
CODE AVAIL ORG LAT
LONG
SRC 001 GULF COAST G
PLT 9S0 ANCHOR ROAD MOB 0
SELLER ID ID OBJECTIVE
01 DISINFECTION
0290200 0952603
K^'l |c^5| Ic^Tl |C^3| IC^SI
TREATMENTS
PROCESS
GASEOUS CHLORI NATION. PRE
LOCATE STATEMENT
LOCATE (0) CI00 WH CI 15 SPANS l*K AND CJ Eg TX
-------
&
(TO
10/14/92
FRDS01
EPA REGION. 06
FEDERAL REPORTING DATA SYSTEM - FRDS-II
PUBLIC MATER SYSTEM - COMPREHD4S1 VE REPORT
PRIMACY STATE: TI
PRIMACY! Y
SORTBO BY PWS ID
PWS IDs TX014000S
SOURCE (SRC) /OVTItY POINT (EPTI /PLANT (PUT) INFORMATIONi
TYPE ID NAME
DATA
CODE AVAIL OfcO
LAT
LONG
SELLER IP
ID OBJECTIVE
PAGE 3
(CONTINUED)
TREATMENTS
PROCESS
SRC 001 LEON RIVER 8
£L
8
$
to
PLT »S0 IVMPLB CIT* OP O
H 031OSS3 0973033
icisllcln lc^3l jcmiicmilcnai icml lc^7i
01 Dlalnfectlon
02 PirClculatt Rnovi
03 Particulate Reaowa
04 Particulate Reaova
05 Partlculat* Reaova
06 Particulate Reaova
07 Tait* / Odor Contr
08 Dlelnlectlon
09 Dlalntectlon By-pr
10 Other
11 Corroalan Control
14 Dlelnfectlon
ii i
Oaaeoue Chlorlnation, pre
CoagulatIon
Rapid Mis
Floeculatlon
Sedlaantatlon
Filtration. Rapid Sand
Activated Carbon. Powdered
Ctiloraalnea
Chloraalnea
Fluoridation
pM Adjuatmnt
Oaaeoua ChlorlnatIon, Poat
m
8
a.
<
n>
O
w
f-*
CO
LOCATE STATEMENT
LOCATE <01 CIOO HH CI IS SPANS I*K AND C3 BQ TX:
ro
vD
K>
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.2 FRDS03 - Public Water System Service Area And Source Area Report
FRDS03 is a detailed report of PWS 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 PWSs in the report and the total number of PWSs reported on
FRDS03 also contains a summary page as the last page of the report. A report dialog screen
and annotated example reports are shown on the next three pages.
Effective Date: 12/31/92 Release: 2.00
Page 5 - 9
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS03 DIALOG
FROS-I1/Interactive
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (Q) Quicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code which corresponds to the desired Post Retrieval
Output Option: B
********** FROS-11 Phase 1 Reports **********
REPORTS 1, 3, 4, 7, 17. 19, 20, 24, 31, 32, 35, & 43 ARE AVAILABLE
********** FROS-11 Phase 2 Reports *•••**•***
REPORTS 18, 21, 22, 23, 36, 41, & 42 ARE NOT AVAILABLE
--> Enter the nurber of the desired FROS report: 03
--> Oo you wish to add an additional identifying title line to your
FRDS03 report' (Y)es or (N)o: N
--> Do you want to sort the report data' (Y)es or (N)o: Y
--> Sort on EPA region' (Y)es or (N)o: N
••> Sort on State' (Y)es or (N)o: N
Select one of the following minor sort sequences:
0 = None
1 = PUS ID
2 = PWS Type, PWS ID
3 = Retail Population Served (descending sequence), PWS ID
4 = Primary Source, PWS ID
5 = System City Name, PUS ID
6 = System Name, PUS ID
7 = System ZIP Code, PWS ID
--> Minor sort sequence nuntoer: 1
Your current Job parameters are:
FIHAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Medium
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)o' Y
Job 20321 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Page: 5-10
Release: 2.00
Effective Date. 12/31/92
-------
m
S5
p.
<
o
D
Si
n
to
u>
v£>
N>
73
2.
8
<3
K)
10/15/92
FRDS03
FEDERAL REPORTING DATA SYSTEM - FRDS-1I
REPORT SELECTION CRITERIA
LOCATE STATEMEHT(S) USED FOR REPORT.
LOCATE (0) C100 MH C3 EQ TX AND HK C103 EQ CAC:
THE FOLLOW I HO SCHEMA ITEMS WERE USED FOR SORTING.
SORTED BY PWS ID
PUBLIC MATER SYSTEMS SELECTED FOR THE REPORT: 4,653
PAi^E
TJ
W
(TO
r®
-------
7| |C483| |c4 8Sj
vO
to
LOCATE STATEMENT
LOCATE (01 C100 WH C3 EQ TX AND NK C103 EQ CAC
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.3 FRDS04 - Surface Water Treatment Report
FRDS04 is a detailed report containing information for systems and sources specific to the
Surface Water Treatment Rule.
At the time of publication of Release 2.00, the FRDS04 report was undergoing revisions.
Documentation insert pages will be distributed when available.
Effective Date: 12/31/92
Release. 2.00
Page: 5-13
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS04 DIALOG
THIS PAGE HAS BEEN LEFT BLANK INTENTIONALLY. INSERT PAGES ARE
FORTHCOMING.
Page 5 - 14
Release. 2.00
Effective Date- 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS04 DIALOG (CONTINUED)
THIS PAGE HAS BEEN LEFT BLANK INTENTIONALLY. INSERT PAGES ARE
FORTHCOMING.
Effective Date: 12/31/92
Release 2 00
Page 5-15
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS04 REPORT
THIS PAGE HAS BEEN LEFT BLANK INTENTIONALLY. INSERT PAGES ARE
FORTHCOMING.
Page 5-16
Release- 2 00
Effective Date- 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC-0055-005 - LN -2005
December 3 1, 1992
FRDS04 REPORT
THIS PAGE HAS BEEN LEFT BLANK INTENTIONALLY. INSERT PAGES ARE
FORTHCOMING.
Effective Date: 12/31/92
Release: 2.00
Page: 5-17
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 3 1, 1992
5.2.1.4 FRDS07 - Facilities and Population Served by Primary
Water Supply Source
FRDS07 is a detailed report of facilities and populations served by PWS sources. It breaks
down primary source into PURCHASED SURFACE, GROUND AND GROUND UNDER
THE DIRECT INFLUENCE OF SURFACE WATER; and NON-PURCHASED SURFACE,
GROUND AND GROUND UNDER THE DIRECT INFLUENCE OF SURFACE WATER.
FRDS07 reports on the number of Facilities or Systems and Percent of these Facilities that
qualify under the specific population being reported.
There is a State Report, a Region Report, Grand Summary Report, and a Regional Summary
Report when the user selects the State detail level.
The user can select State, Region, or Grand Report. When selecting Region, there is no
State Report. When selecting Grand, there is no Region or State Report.
The user can select from the following three formats:
• Standard Population Categories (11)
• 5 Population Categories
• User Specified Population Range(s)
Detailed help (?) is available to the user for both the following prompts:
• Do you wish to produce (S)tate, (R)egional, or (G)rand totals?
• Three (3) formats are available for report 07
Please select the Format desired.
A report dialog screen and annotated example reports are shown on the next three pages.
Page: 5-18
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Post Retrieval Output Options Menu December 31, 1992
FRDS07 DIALOG
--> Enter the number of the desired FRDS report: 07
--> Do you wish to add an additional identifying title line to your
FRDS07 report' (Y)es or (N)o: N
Having selected a FRDS07 report, you must provide
additional information ...
--> Do you wish to produce (S)tate, (R)egional, or (G)rand totals7
--> Enter (S)tate, (R)egional, or (G)rand: S
Three (3) formats are available for report 07
Please select the Format desired
1 = 11 Population Categories
2 = 5 Population Categories
3 = User Specified Population Range(s)
--> Please enter format desired, 1, 2 or 3: 2
Your current Job parameters are:
FIMAS 10: fffff
Destination: HOLD
Bin/Box: Huuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)o? Y
Job 20428 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Effective Date: 12/31/92
Release: 2.00
Page: 5-19
-------
FEDERAL REPORTING DATA SYSTEM - FRDS-I
10/15/92 REPORT SELECTION CRITERIA
FRDS07
LOCATE STATEMENT (S) USED FOR REPORT
LOCATE 10) C100 WH CI EQ TX AND NK C103 EQ CAC:
PUBLIC HATER SYSTEMS SELECTED FOR THIS REPORT:
-------
m
£*
8
cr
<
ft
a
£
N)
C3
SO
to
10/15/92
FRDS07
EPA REGION VI
STATE TEXAS
POPULATION
FEDERAL REPORTING DATA SYSTEM - PROS-7I
FACILITIES AND POPULATION SERVED BY PRIMARY WATER SUPPLY SOURCE
INVENTORY LAST UPDATE. 09/15/19^2
PAGE
-SURPACE
(000)
FAC POP
--~ROUND
(000)
FAC POP
CRND-UDI
(000)
FAC POP
PURCHASED
-SURFACE-- GROUND
(000) (000)
FAC POP FAC POP
-GRND-UDI -
(000)
FAC POP
-Hf-
---TOTAL
(000)
FAC POP
TO
a
n>
ro
^0
ro
cro
500 4 UNDER
NUMBER
PERCENTAGE
501-3,300
NUMBER
PERCENTAGE
3,301-10,000
NUMBER
PERCENTAGE
10,001-100,000
NUMBER
PERCENTAGE
OVER 100,000
NUMBER
PERCENTAGE
67 11 2,265 345
1 4 1 48.7 2 0
109 179 1,018 1,410
2 3 11 21.9 8.4
141
3 0
33 67
.2 14
287 434
6.2 2.6
54
1.2
14
1
60
5
TOTALS
NUMBER
PERCENTAGE
PERCENTAGES MAY
LOCATE STATEMENT:
IOCATE (0} C100 UH C3 EQ IK AND NK C103 EQ CAC:
0 2,540
0 54 6
403
2 4
1.468 2.103
31 5 12 S
420
2.298
102
19
98
228
1, 425
205
5. 337
66
77
2,184
689
20
926
5, 122
6. 7 37
39 9
3,578 5,319
595 3,435
20.4
224
338
7, 899
4,653 16.877
100 0 100 0
12
COUNT OF C101
IPWS ID)
SUM OF CI 17
(PWS-RETAIL-POP-SERVED)
DIVIDED BY 1000
PRIMARY
SOURCE
OBTAINED
FROM CI 19
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
5.2.1.5 FRDS17 - Follow-up Actions Report
FRDS17 is a summary report of follow-up actions. FRDS17A calculates the number of
follow-up actions by population category, while FRDS17B reports the number of systems
reporting follow-up actions, also by population category.
The user can select from the following three formats:
• Standard Population Categories (11)
• 5 Population Categories
• User Specified Population Range(s)
Detailed help (?) is available to the user for both the following prompts:
• Do you wish to produce (S)tate, (R)egional, or (G)rand totals?
• Three (3) formats are available for report 07
Please select the Format desired.
A report dialog screen and annotated example reports are shown on the next six pages.
Page- 5 - 22
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS17 DIALOG
--> Enter the nunber of the desired FRDS report: 17
--> Do you wish to add an additional identifying title line
FRDS17 report? (Y)es or CN)o: N
to your
Having selected a FR0S17 report, you must provide
additional information ...
--> Do you wish to (E)xclude or (l}nclude duplicate
enforcement actions in your FRDS17A report'
Note: EPA generally excludes duplicates in its reports
--> Enter (E)xclude or (I)nclude: E
--> Do you wish to produce (S)tate, (R)egional, or (G)rand
totals'
--> Enter (S)tate, (R)egional, or (G)rand: S
Three (3) formats are available for report 17
Please select the Format desired
1=11 Population Categories
2 = 5 Population Categories
3 = User Specified Population Range(s)
--> Please enter format desired, 1, 2 or 3: 2
Tour current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Short
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct7 (Y)es or (N)o' Y
Job 20677 Submitted ...
--> Would you like to submit another FRDS reporf (Y)es or
(N)o: N
Effective Date- 12/31/92
Release: 2 00
Page 5 - 23
-------
H3
U>
00
a
N> 10/26/92
4^
FEDERAL REPORTING DATA SYSTEM - FRDS-II
FRDS17A
REPORT SELECTION CRITERIA
POPULATION GROUP SELECTED FIVE POPULATION GROUPS
LOCATE STATEMENT(S) USED FOR REPORT.
?0
£L
8
o
a
LOCATE (0) CI 200 WH NK C1209 EQ 91 AND NK C103 EQ CAC AND C3 EQ TX
PUBLIC WATER SYSTEMS SELECTED FOR THIS REPORT. 1,095
EXCLUDE ALL SUBSTANTIVE DUPLICATES
m
55
8
<
a
O
tii
«-*
a
to
uj
vO
r j
-------
m
v'i
8
p.
<
O
r-»
n>
K>
to
JO
re
N>
10/26/92
FRDS17A
EPA REGION VI
TEXAS ^
-E2II
:o3|
FEDERAL FOLLOW UP ACTIONS TAKEN
FOLLOW UP ACTION
CODE AND DESCRIPTION
FEDERAL REPORTING DATA SYSTEM - FRDS-II
FOLLOW UP ACTIONS SUMMARY BY POPULATION
PAGE
INV LAST UPDATED 09/15/92
EWF LAST UPDATED 09/22/92
EXCLUDE ALL SUBSTANTIVE DUPLICATES
NUMBER OF FOLLOW UP ACTIONS BY POPULATION CATEGORY
UNDER
501
501-
3,300
3,301-
10,000
10,001-
100,000
OVER
100,000
TOTAL
12051 —
.......
~ *
¦ 1 FEDERAL - FORMAL ACTIONS
EF< Fed CFP Issued
1
-
-
1
EFl Fed PAO Issued
21
-
-
21
EFL Fed FAO Issued
10
-
-
10
EFJ Fed Formal NOV Issued
170 77
~ 19
8
1
274
SUB TOTAL
202 77
IS
a
1
306
TOTAL FEDERAL ACTIONS
202 77
IB
8
1
306
97 SUBSTANTIVE
DUPLICATE FEDERAL FOLLOW UP ACTION
RECORDS
ARB EXCLUDED FROM
THESE COUNTS.
LOCATE STATEMENT!
LOCATE (0) C1200 WH NK C1209 EQ 91 AND NK
C103 EQ CAC AND C3 EQ TX:
COUNT OF
NUMBER OP
C1200S FOR
THIS
C1205
POPULATION
CATEGORY
DETERMINED
FROM CI17
TS
M
CO
re
to
Ln
-------
OQ
fO
L/>
(O
On
10/36/92
FRDS17B
EPA REGION VI
TEXAS
STATE FOLLOW UP ACTIONS TAKEN
FOLLOW UP ACTION
CODE AND DESCRIPTION
STATE - FORMAL ACTIONS
FEDERAL REPORTINO DATA SYSTEM - FRDS-II
SYSTEMS WITH REPORTED FOLLOW UP ACTIONS SUMMARY BY POPULATION
UNDER
SOI
NUMBER OF SYSTEMS BY POPULATION CATEGORY
501-
3,300
3,301-
10,000
10,001-
100,000
PAGE
INV LAST UPDATED 09/15/9?
ENF LAST UPDATED 09/22/9?
OVER
100,000
TOTAL
5*3
n>
n
to
m
s5
8
CT.
<
O
O
«—*¦
o
SFU
St
Temp Restrain Order/Prell
1
-
-
-
-
1
SFP
SC
Civil Case under developm
9
3
-
-
-
12
SF9
SC
Civil Case referred to AG
5
-
-
-
-
5
SFR
St
Consent Decree/Judgement
22
4
-
-
-
26
SFH
St
Boll Water Order
8
4
1
1
-
14
SFJ
St
Formal NOV issued
442
283
87
59
5
876
SFK
St
BCA signed
44
17
1
2
-
64
SFQ
St
Civil Case Hied
128
14
1
1
-
144
SFT
St
Injunction
27
43
23
20
2
115
SUB TOTAL
569
298
88
59
5
1019
STATE - INFORMAL ACTIONS
SID
St
Site Visit (enforcement)
2
-
-
-
-
2
SUB TOTAL
STATE - OTHER ACTIONS
SOX St Compliance achieved
SUB TOTAL
TOTAL SYSTEMS WITH STATE ACTIONS
TOTAL SYSTEMS WITH ACTIONS
16
16
574
618
4
4
298
318
LOCATE STATEMENT:
LOCATE (0) C1200 WH NK C1209 EQ 91 AND NK C103 EQ CAC AND C3 EQ TX:
1
1
88
92
1
1
59
61
22
22
1024
1095
to
VO
to
-------
m
8
p.
<
rc
O
50
v©
ro
5*J
to
8
10/26/92
FRDS17B
EPA REGION VI
TEXAS
FEDERAL REPORTING DATA SYSTEM - FRDS-II
SYSTEMS WITH REPORTED FOLLOW UP ACTIONS SUMMARY BY POPULATION
FEDERAL FOLLOW UP ACTIONS TAKEN
FOLLOW UP ACTION
CODE AND DESCRIPTION
FEDERAL - FORMAL ACTIONS
EF< Fed cfp Issued
EFI Fed PAO Issued
EFL Fed FAO Issued
EFJ Fed Formal NOV Issued
SUB TOTAL
TOTAL SYSTEMS WITH FEDERAL ACTIONS
UNDER
SOI
INV LAST UPDATED 09/1S/92
LNF LAST UPDATtL) 09/22/92
NUMBER OF SYSTEMS BY POPULATION CATECORY
S01-
3, 300
LOCATE STATEMENT:
LOCATE (0) C1206 WH NK C1209 EQ 91 AND NK C103 EQ CAC AND C3 EQ TX.
3.301-
10.000
10,001 -
100.000
COUNT OF
SYSTEMS WITH
THIS ENF
ACTION
OVER
100,000
1
2 1
1 0
269
I IS
2IS
c09
POPULATION
CATEGORY
DETERMINED
KROM CI 17
~T3
QQ
a
t-n
ro
-j
-------
-o
(TO
ft
to
oo
50
2.
s
l/l
fl)
NJ
m
5s
8
cr.
<
D
p
a
10/26/92
FRDS17B
EPA RPSION VI
TEXAS
STATE FOLLOW UP ACTIONS TAKEN
FOLLOW UP ACTION
CODE AND DESCRIPTION
STATE - FORMAL ACTIONS
FEDERAL REPORTING OATA SYSTEM - FRDS-Il
SYSTEMS WITH REPORTED FOLLOW UP ACTIONS SUMMARY BY POPULATION
SUB TOTAL
STATE - OTHER ACTIONS
SOX St Compliance achieved
SUB TOTAL
TOTAL SYSTEMS WITH STATE ACTIONS
TOTAL SYSTEMS WITH ACTIONS
PArtE
INV I AST UPDATED 09/15/92
LNF LAST UHDATfcD U9/22/92
UNDER
SOI
-- NUMBER OF SYSTEMS BY POPULATION CATEGORY
SOI- 3.101- 10,001-
3.300 10.000 100,000
16
16
S7 A
618
4
4
298
= = s s
318
1
1
68
92
LOCATE STATEMENT
LOCATE 10) C1200 MH NK C1209 EQ 91 AND NK C101 EQ CAC AMD C3 EQ TX.
1
1
59
61
OVER
100 ouo
SFU
St
Temp Restrain Order/Preli
1
-
-
-
-
]
SFP
St
Civil Case under developa
9
3
-
-
-
12
SF9
St
Civil Case referred to AO
S
-
-
-
-
SFR
St
consent Decree/Judgement
22
4
-
-
-
2 O
SPH
St
Boil Water Order
9
4
1
1
-
1 4
SFJ
St
Formal NOV issued
442
233
87
59
5
876
SFK
SL
BCA signed
44
17
1
2
-
SFQ
St
Civil Case (Lied
128
14
1
1
-
1-14
SFT
St
Injunction
27
43
23
20
2
1 1 S
SUB TOTAL
S69
298
88
S9
S
1019
STATE - INFORMAL ACTIONS
SID
St
Site Visit (enforcement)
2
-
-
-
-
2
22
22
1024
10*5.
N)
\D
K>
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.6 FRDS19 - Violation Summary By Population
FRDS19A is a summary report calculating the number of violations by population category,
violation type, and contaminant type.
FRDS19B summarizes the number of systems in violation by population category, violation
type, and contaminant type.
FRDS19 may contain a message indicating that a certain amount of violations "not included
because of insufficient data." This actually means that there are contaminants encountered
that are not Federally regulated or are 'monitoring only contaminants.'
A report dialog screen and annotated example reports are shown on the next three pages.
Effective Date: 12/31/92
Release: 2.00
Page' 5 - 29
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS19 DIALOG
--> Enter the number of the desired FRDS report: 19
--> Do you wish to add an additional identifying title
FRDS19 report? (Y)es or Are these parameters correct? (Y)es or (N)o'' N
Accounting Parameters ...
FIMAS ID:
Now: fffff
-->
Job Routing Parameters ...
Destination:
Now: HOLD
Bin/Box:
Now: Muuu
- - >
Execution Parameters ...
Estimated Time ¦ (S)hort, (H)ediun, (Dong. (V)ery Long,
Now: Short
--> L
e(X)tra Long:
Priority:
Now: 2
--> #
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
Are these parameters correct"* (Y)es or (NJo' K
Job 20717 Submitted ...
Page- 5 - 30
Release: 2.00
Effective Date: 12/31/92
-------
|cT5T|
m
<
a
u
??
KJ
vD
to
£L
2
f?
to
FEDERAL REPORTING DATA SYSTEM - FRDS-II
VIOLATION SUMMARY BY POPULATION
FRDS19A
EPA REXII ON VI
STATE: TEXAS
VIOLATION TYPE/CONTAMINANT
PAGE
- - -NUMBER OF VIOLATIONS BY POPULATION CATEGORY---
100 4 101- 501- 1,001- 2.S01- 3,301- 5,001- 10,001- 50,001-
UNDER 500 1,000 2,500 3,300 5,000 10,000 50,000 75,000
75,001- OVER
100.000 100,000
TOTAL
MCL, AVERAGE
|V,A XV J| 1Q
9
3
2
2
26
ARSENIC
S
S
BARIUM
2
2
FLUORIDE
—IrTTiTn 29
31
8
10
2
80
NITRATE
23
16
1
1
4
64
SELENIUM
21
29
9
4
2
65
CROSS ALPHA,EXCL. RADON 4
6
6
2
3
1
18
COMBINED RADIUM <-226 & -2
7
8
2
4
1
22
SUB TOTAL
93
113
40
16
10
1
4
6
282
MONITORING, REGULAR
TURBIDITY
18
17
6
1
2
1
45
SUB TOTAL
IB
17
6
1
2
1
45
NOTIFICATION, PUBLIC
TURBIDITY
22
19
7
1
1
2
1
1
54
COLIFORM (TCR)
1.203
535
124
147
37
31
35
39
4
3
5
2,163
1,225
S54
131
148
38
33
36
40
4
3
5
2,217
TOTAL COLIFORM RULE
MCL, ACUTE
141
75
25
33
12
12
12
13
323
MONITORING, ROUTINE MAJOR
193
32
27
S
4
1
1
821
MONITORING, ROUTINE MINOR
h-M"-! 287
162
37
82
18
IS
24
19
3
1
4
652
MONITORING, REPEAT MAJOR
157
77
21
10
2
2
2
6
1
278
MONITORING. REPEAT HINOR
85
47
9
8
5
2
1
3
1
1
162
SUB TOTAL
1.243
567
128
160
42
35
41
44
4
3
5
2,272
MCL TOTAL
248
201
69
49
22
13
17
21
1
641
HON TOTAL
1,105
496
105
127
31
25
28
30
4
3
4
1,958
TOTAL
2. 578
1.251
305
324
91
71
B1
91
8
6
10
4,816
3 VIOLATIONS NOT INCLUDED BECAUSE OF INSUFFICIENT DATA
LOCATE STATEMENT:
LOCATE (0) C1100 WK NK C1135 EQ 92 AND C3 EQ TXt
COUNT OF NUMBER
OF VIOLATIONS OF
THIS VIOL TYPE
DETERMINED
FROM CI17
"O
cro
a
-------
y
rK
A
U>
K)
SO
JL
8
l/i
n
to
m
I
<"
a
O
Co
f-*
a
c
r ^
FEDERAL REPORTING DATA SYSTEM - FRDS-II
SYSTEMS IN VIOLATION-SUMMARY BY POPULATION
FRDS19B
EPA REGION VI
STATE TEXAS
VIOLATION TYPE/CONTAI
HCL. AVERAGE
PE/CONTAMINANT
'WW
TURBIDITY
ARSENIC
BARIUM
FLUORIDE
NITRATE
SELENIUM
GROSS ALPHA,EXCL. RADON
COMBINED RADIUM (-226 4
CI 103| 20
SUB TOTAL
MONITORING. REGULAR
TURBIDITY
SUB TOTAL
NOTIFICATION, PUBLIC
TURBIDITY
COLIFORM (TCR)
SUB TOTAL
TOTAL COLIFORM RULE
48
6
HCL. ACUTE (TCR)
MCL, MONTHLY (TCR)
MONITORING, ROUTINE MAJOR
MONITORING. ROUTINE MINOR
MONITORING. REPEAT MAJOR
MONITORING. REPEAT MINOR
JC11Q5|
SUB TOTAL
MCL TOTAL
HON TOTAL
TOTAL
PAGE
- NUMBER OF SYSTEMS IN VIOLATION BY POPULATION CATEGORY -
100 4 101- 501- 1,001- 2.S01- 3.301- 5.001- 10.001- 50,001- 75.001- OVER
UNDER 500 1.000 2.500 3.300 S.000 10.000 50.000 75.000 100,000 100.000
6
2
1
20
15
11
6
B
57
6
20
2
9
641
9
304
3
70
1
96
1
22
2
27
1
27
646
15
124
355
253
129
B2
307
13
67
128
145
69
46
73
4
24
21
35
17
8
96
28
19
68
10
7
23
11
5
14
2
4
29
11
4
15
2
2
28
1
12
1
IB
2
1
654
315
73
102
24
30
32
170
627
121
286
42
65
36
90
15
20
12
23
14
21
1
28
692
363
89
108
29
33
34
39
3 VIOLATIONS NOT INCLUDED BECAUSE OF INSUFFICIENT DATA
I OCA IE S1MEJCM1:
lOOtE (0) CI 100 WM NC C1131 CO 9? ANO C3 EQ TX:
COUNT OF
SYSTLMS
WITH 'I'll lb
Viol AT ION
TOTAL
16
2
1
S3
45
29
17
20
1 44
Id
18
21
1,231
1.247
36
2 89
534
574
238
1SS
1.277
4 25
1. 170
1. 398
DLTLKMINLI)
hhi >M <"11/
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.7 FRDS20 - Violation Summary By Primary Water Supply Source
FRDS20 is a report calculating violations by PWS source summarized by violation type,
contaminant type, and source type.
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.
FRDS20 may contain a message indicating that a certain amount of violations "not included
because of insufficient data." This actually means that there are contaminants encountered
that are not Federally regulated or are 'monitoring only contaminants'.
A report dialog screen and annotated example report are shown below and on the following
page.
FRDS20 DIALOG
--> Enter the nurber of the desired FRDS report: 20
--> Do you wish to add an additional identifying title line to your
FRDS20 report7 (Y)es or (N)o: N
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Huuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)o' Y
Job 20721 Submitted ...
--> Uould you like to submit another FRDS report'
-------
s
00
a
Ut
£L
s
$
to
til
8
p.
<
a
&>
K)
C2
FRDS20
EPA REGION VI
STATE. TEXAS
VIOLATION TYPE/CONTAMINANT
HCL, AVERAGE
TURBIDITY
ARSENIC
BARIUM
FLUORIDE
NITRATE
SELENIUM
GROSS ALPHA,EXCL.
COMBINED RADIUM I-
RADON *
226 t -2
SUB TOTAL
MONITORING, REGULAR
TURBIDITY
SUB TOTAL
NOTIFICATION. PUBLIC
TURBIDITY
COLIFORM (TCR)
SUB TOTAL
TOTAL COLIFORM RULE
HCL. ACUTE (TCRI
HCL. MONTHLY (TCR)
HONITORINO. ROUTINE MAJOR
Monitoring, routine minor
MONITORING, REPEAT MAJOR
MONITORING, REPEAT MINOR
SUB TOTAL
TOTAL
FEDERAL REPORTING DATA SYSTEM - FRDS-II
VIOLATION SUMMARY BY PRIMARY WATER SUPPLY SOURCE
-NUMBER OP VIOLATIONS/SYSTEMS BY PRIMARY SOURCE
PURCHASED-
vio/sys couwr
OF C1103
GROUND
VIO/SYS
240/
118
1,856/ 1,025
1,856/ 1.02S
30/
269/
714/
531/
255/
144/
30
243
464
470
31 5
137
1.943/ 1,058
4.039/ 1.15S
3 VIOLATIONS NOT INCLUDED BECAUSE OF INSUFFICIENT DATA
LOCATE STATEMENT.
LOCATE (0) C1100 WH NK C113S EQ 92 AMD C3 EQ TX.
SURFACE
VIO/SYS
GROUND
VIO/SYS
TOTAL
VIO/SYS
26/
16
26/
16
5/
2
21
t
3/
2
80/
5)
8/
5
5/
3
64 /
45
65/
29
18/
1 7
22/
20
11/
7
26/
16
5/
3
282/
14 4
45/
18
45/
18
45/
18
45/
18
54/
27
54/
27
169/
114
106/
68
32/
24
2.163/
1.231
169/
114
160/
84
32/
24
2,217/
1,247
1/
1
5/
S
36/
36
33/
29
16/
14
5/
3
32 3 /
289
64/
43
33/
19
10/
8
821 /
5 3 4
59/
49
46/
40
16/
15
652/
S7«
16/
16
6/
6
1 /
1
278/
2 18
10/
10
8/
8
162/
155
183/
123
114/
72
32/
24
2,272/
1,277
363/
125
34 5/
91
69/
27
4 , B1£/
1 398
VO
K>
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.8 FRDS24 - Public Water Supply System Summary And Violation Data
FRDS24 is a detailed report of PWS plant location and violation and related enforcements
summary data including violation duration in months.
FRDS24 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.
A report dialog screen and annotated example reports are shown on the next two pages.
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 35
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS24 DIALOG
--> Enter the number of the desired PROS report: 24
--> Do you msh to add an additional identifying title line to your
FRDS24 report' (Y)es or Do you want to sort the report data? (Y)es or (N)o: Y
--> Sort on EPA region? (Y)es or Sort on State' (Y)es or (N)o: N
Select one of the following minor sort sequences:
0 = None
1 = PUS ID
2 = PUS Type, PUS ID
3 = Retail Population Served (descending sequence), PUS ID
4 = Primary Source, PUS ID
5 = System City Name, PUS ID
6 = System Name, PUS ID
7 a System ZIP Code, PUS ID
--> Minor sort sequence nunber: I
Your current Job parameters are:
FIHAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Medium
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)o? Y
Job 20231 Submitted ...
--> Uould you like to submit another FRDS report' (Y)es or (N)o: N
Page: 5 - 36
Release: 2.00
Effective Date: 12/31/92
-------
m
_•»
8
p.
<
O
a
10/19/92
FRDS24
FEDERAL REPORTING DATA SYSTEM - FRDS-II
PUBLIC WATER SYSTEM - SUMMARY VIOLATIONS AND RELATED ENFORCEMENTS
PAGE
K>
VD
KJ
PWS ID.
TYPE
SYSTQ4
NAME/ADDRESS/TELEPHONE
POPULATION PRIM
SERVED SRC
ID
VIOLATION - ENFORCEMENTS
TYPE CNTAM RESULT DATE DUR ID ACT DATE
00
TX2120004 TYLER CITY OP
P O BOX 20)9
C TYLER
T* 75710
TX2200001 ARLINGTON CITY OF
P O BOX 2)1
C ARLINGTON
TX 76004
TX2200012 FT WORTH CITY OF
PO BOX 870
C FORT WORTH
TX 76101
TX220006) NORTH RICHLAND HILLS CITY O
7200 DICK FISHER DRIVE
C NORTH RICHLAND HILLS
TX 76102
80.000 S 91V0001 25 )100
90V0001 0) 0100
204,800 S 8702778 0) 0100
8412027 0) 3000
477,000 S 69V0001 0) )000
68,704 P 850)469 03 )000
06/01/91 01 91E0001
05/01/90 01 90E0001
06/01/87 01
06/01/84 01
07/01/89 01
02/01/85 01
TX2210001
ABILENE CITY OF
106.400 S
9211699
06
3100
P O BOX 60
9211698
24
3100
C
ABILENE
91V0001
25
3100
TX 79604
90V0001
03
3000
TX2260001
SAN ANGELO CITY OF
80,000 S
8504190
02
2950
P O BOX 1751
8504339
02
2950
10/01/91
10/01/91
06/01/91
04/01/90
0 12000000 06/11/85
0 12000000 10/23/84
TX2270001
TX2350002
4
1
SAN ANGELO
TX 76902
AUSTIN CITY OF
P O BOX 10B6
AUSTIN
TX 70767 ^10^11
VICTORIA CITY OF
P O BOX 1758 ^ IC135I
VICTORIA
TX 77901
466,000 S NO VIOLATIONS FOR THIS PWS
SO.700 C
t | >simzi
ICld5IC101IC139ICrTn
i A 8«
timing
8600952
8503605
8503759
03
3000
10/01/85
01
03
3000
04/01/85
01
03
3000
02/01/85
01
SFJ
SFJ
07/20/91
06/20/90
IC11 231
BlI'M
LOCATE STATEMENT:
LOCATE (0| C100 WH C11S SPANS I«K AND C3 EQ TX.
01
01
01
01
03
0)
91E0001
90E0001
SFJ 07/20/91
SFJ 05/20/90
iciion Icl5051 |ci3631
-4
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
5.2.1.9 FRDS31 - PWSs Months In Violation
FRDS31 is a summary report calculating the months in violation for selected PWSs. This
summarization is performed for various categories of PWSs and their violations. Two
elementary statistics - number of PWSs 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 PWS, and finally
geographic area by State and/or Region.
If user selection specifies the primary source, then the report shows the primary sources used
in the selection. However, if the user does not specify the primary source, 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 PWSs 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.
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 PWS has been in violation for a particular
Contaminant Code (CI 103) and Violation Type (CI 105), the report will count all months in
violation for that particular Contaminant Code (CI 103), which fall within the user-specified
date range at the user's option. It will 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 how many months a PWS has been in violation for a particular Contaminant
Code (CI 103) regardless of Violation Type (CI 105), the report determines which months the
PWS was in violation as before, but it counts a particular month only once if two or more
different violations occurred in that month.
Page 5 - 38
Release 2 00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
On the chart that follows, 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 violations, the PWS for this FY had six months in which violations were
reported. The PWS 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 occurrence 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.
Effective Date: 12/31/92
Release. 2.00
Page- 5 - 39
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
COMPUTING MONTHS IN VIOLATION FOR A SINGLE PWS
Raw Data for a Single PWS
TYPE
OCT
NOV
DEC
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
MCL
X
X
X
X
X
X
MON
X
X
X
MONTHS IN VIOLATION TOTALS BY MONTH
TYPE
OCT
NOV
DEC
JAN
FEB
MAR
APR
MAY
JUN
JULY
AUG
SEP
MCL
1
2
3
4
5
6
MON
1
2
3
COMB
1
2
3
4
5
6
7
Page: 5 - 40
Release. 2 00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
The particular month in violation is based upon the Violation Date (CI 107) with the range of
months marked based upon the Violation Duration (CI 111). 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:
VIOLATION DATE
October
January
MONTHS IN
VIOLATION
OCT, NOV, DEC
JAN, FEB, MAR
NUMBER OF
MONTHS IN
VIOLATION
Similarly, when both Violation Type (CI 105) and Contaminant Code (CI 103) are rolled up
to a higher level, a month is counted in violation only once, even if it had several different
violation types and contaminant codes occurring in it.
The sample session beginning on the next page shows how to generate FRDS31.
An annotated report example follows.
Effective Date: 12/31/92
Release: 2.00
Page: 5-41
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS31 DIALOG
--> Enter the nunber of the desired FRDS report: 31
--> Oo you wish to add an additional identifying title line to your
FRDS31 report? (Y)es or (N)o: IV
Having selected a FRDS31 report, you must provide
additional information ...
Enter the Beginning date of the period you want covered in YYMM format:
--> Date: 9101
Enter the Ending date of the period you want covered in YYMM format:
-•> Date: 9112
Do you want this report to (I)nclude total months
in violation (including those months which may
precede or follow the requested date range)
or, do you want to (E)xclude those months that
precede or follow the requested date range''
--> (I)nctude or (E)xclude: E
--> Do you want National totals on your FRDS31 report' (Y)es or (N)o: N
--> Do you want Regional totals on your FRDS31 report? (Y)es or (N)o: N
--> Do you want State totals on your FRDS31 report' (Y)es or (tOo: Y
--> Do you want an Individual Primary Source summary listing'
(Y)es or (N)o: Y
--> Do you want a Group Primary Source sunmary listing''
(Y)es or (N)o: y
--> Do you want an Aggregate Primary Source sunmary listing'
(Y)es or (N)o: Y
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
-•> Are these parameters correct' (Y)es or (N)o' Y
Job 20483 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Page: 5 - 42
Release: 2.00
Effective Date: 12/31/92
-------
m
u'l
8
p.
<
<0
D
p
f?
to
Cj
v©
to
10/1S/92
FRDS31
FEDERAL REPORTING DATA SYSTEM - PROS-11
REPORT SELECTION CRITERIA
LOCATE STATEMENT(S> USED FOR REPORT:
LOCATE (0) C100 WH C3 EQ TX AND NK C103 EQ CAC.
PUBLIC WATER SYSTEMS SELECTED FOR THIS REPORT.
4 , 653
50
ro
TJ
to
cro
n
t-n
-------
>v
v>
(TO
rt
ISl
-P-
FEDERAL REPORTING DATA SYSTEM - FRDS-II
10/15/92 MONTHS IN VIOLATION DURING VIO DATE RANGE
PROS 31
REGIONi 06 STATEi TO PWS CRITERIA! ACTIVE COMMUNITY SURFACE
VIO CRITERIA! (OlOOtlTJRBIDITY MCLISINQLB SAMPLE fc AVERAGE)
POPULATION MONTHS IN VIOLATION
12 3456789
10
11
PAGE 2
VIO DATE RANGE 9101-9112
12 >12 TOTAL
JO
a
to
tn
£
£?.
<
A
~
P
ST
K>
UJ
O
N>
100 k
UNDER
PWS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
POP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
101-500
PWS
2
0
0
1
0
0
0
0
0
0
0
0
0
3
POP
680
0
0
2S0
0
0
0
0
0
0
0
0
0
930
501-1,
000
pws
1
1
0
0
0
0
0
0
0
0
0
0
0
2
FOP
900
693
0
0
0
0
0
0
0
0
0
0
0
1593
1,001-
2,500
PHS
2
0
0
0
0
0
0
0
0
0
0
0
0
2
POP
3310
0
0
0
0
0
0
0
0
0
0
0
0
3310
2,501-
3, 300
PW8
0
0
0
0
0
0
0
0
0
0
0
0
0
0
POP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
3,301-
5,000
PWS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
POP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5,001-
10,000
PWS
1
1
0
0
0
0
0
0
0
0
0
0
0
2
POP
99S0
6405
0
0
0
0
0
0
a
0
0
0
0
16355
10,001
-SO,000
pws
1
0
0
1
r
0
0
0
0
0
0
0
0
2
POP
23500
0
0
~ 13707
0
0
0
0
0
0
0
0
0
37207
50,001
-75,000
FMS
1
0
0
0
0
0
0
0
0
0
0
0
0
1
POP
60687
0
0
0
0
0
0
0
0
0
0
0
0
60687
75.001
-100,000
PWS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
POP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
OVER 100.000
PWS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
POP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL
PWS
8
2
0
2
0
0
0
0
0
0
0
0
0
12
POP
99027
7098
0
13957
0
0
0
0
0
0
0
0
0
120082
100 4
101-
501-
1,001-
2.501-
3,301-
5,001-
10,001-
50,001-
75,001-
OVER
TOTAL
UNDER
500
1.000
2.S00
3,300
S.000
10,000
50,000
75,000
100,000
100,000
TOTAL
|note il Incite 2| |note
f 28
39
32
55
22
813
10289
24049
90865
63755
.00
A 7.69
6.251
3.64
.00
00
f 9.04
*
k 3.64
.00
37 34 66 S 6 14 3)8
148043 2SS607 1337692 314181 531712 5122382 7899368
.00 5 88 3.03 20.00 .00 .00 3.55
.00 6.40 2.78 19 12 00 .00 1.52
| NOTE 4| | MOTE 51
LOCATE STATEMENT:
LOCATE (0) C100 UH CJ EQ TX AMD MK C103 EQ CAC:
SEE NOTES ON NEXT
PAGE FOR SUMMARY
EXPLANATIONS
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FEDERAL REPORTING DATA SYSTEM - FRDS31 REPORT NOTES
The following explanations accompany the annotations on the example FRDS31 Report on
the previous page.
NOTE 1: The number of Public Water Systems (count of C101) for the PWSs identified
by the locate statement noted below.
NOTE 2: The sum of PWS-RETAIL-POP-SERVED (CI 17) for the PWSs identified by
the locate statement noted below.
NOTE 3; The sum of PWS-RETAIL-POP-SERVED (CI 17) for a given population
category, months in violation, violation criteria, PWS criteria and violation
date range.
NOTE 4- The ratio of qualifying PWSs divided by the PWS-RETAIL-POP-SERVED
(CI 17) on the page of the report shown, to the total domain identified by the
locate statement noted below.
NOTE 5: The number of PWSs for a given population category, months in violation,
violation criteria, and violation date range.
LOCATE STATEMENT:
LOCATE C100 WH C3 EQ TX AND NK C103 EQ CAC:
Effective Date: 12/31/92
Release: 2.00
Page: 5-45
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
5.2.1.10 FRDS32 - Grant Eligibility Report
FRDS32 is a three part report giving both detailed and summary information on Grant
Eligibility.
FRDS32A is a detailed report listing systems that are not grant eligible and the reasons for
failure.
FRDS32B provides state summary totals of reasons why Public Water Systems are not grant
eligible.
FRDS32C provides various state summary totals such as a PWS-TYPE break down for active
systems, Grant Eligibility percentage among current, active water supplies and the total
number of grant eligible current, active and community systems with the population served.
For non-community systems, the user can select the current grant eligibility requirements (the
Revised Reporting Requirements), or the FRDS-II Grant Requirements which become
effective on January 1, 1994.
A report dialog screen and annotated example reports are shown on the next seven pages.
Page: 5 - 46
Release: 2.00
Effective Date- 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 3 1, 1992
FRDS32 DIALOG
--> Enter the nimber of the desired FRDS report: 32
--> Do you wish to add an additional identifying title line to your
FRDS32 report' (Y)es or (N)o: N
Having selected a FRDS32 report, you must provide
additional information ...
--> Do you want to save the list of PWS IDs selected in a
computer file for later use' (Y)es or (N)o: Y
A file containing the PWS IDs of the systems selected will be created
for your later use ...
Please note the following file name for future reference:
xxxzzzz.D921120.Til 1413.PUS IDS
Which Grant Eligibility requirements do you wish to use for all
Transient Non-Commumty Public Water Systems'
1). The Revised Reporting Requirements.
2). The FRDS-ll Grant Requirements which become effective on
January 1, 1994.
--> Please enter 1 or 2: I
By selecting a FRDS32 report, you have three (3)
reports from which to choose from..
Do you wish to produce a FRDS32A report,
which gives reason(s) why a Public Water System
is NOT grant eligible and lists the PWS-ID,
PWS-STATUS and the SYSTEM-NAME'
--> Enter (Y)es or (N)o: Y
--> Do you want to sort the report data' (Y)es or (N)o: Y
Select one of the following sort sequences:
0 = None
1 = PWS ID
2 = PWS Status, PWS ID
3 = PWS System Name, PWS Status, PWS ID
--> Sort sequence ntmber. /
Do you wish to produce a FRDS32B report,
which provides state summary totals of reason(s)
why Public Water Systems are NOT grant eligible'
--> Enter (Y)es or (N)o: Y
Effective Date 12/31/92
Release 2 00
Page 5-47
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
Do you wish to produce a FRDS32C report,
which provides various state
surma ry totals
such as ...
A PUS-TYPE break down for active systems.
Grant Elig. X among current,
active water supplies
and the total nunber of grant eligible current,
active and community systems with
the population served.
--> Enter (Y)es or (N)o: Y
Your current Job parameters are
FIHAS 10:
fffff
Destination:
HOLD
Bin/Box:
Muuu
. Estimated Time:
Long
Priority:
2
Printer Type:
Dest mat l on
Copies of Report:
01
--> Are these parameters correct7 (Y)es or (N)o'> Y
Job 12397 Submitted ...
Page 5 - 48
Release 2 00
Effective Date 12/31/92
-------
m
3
8
c?.
<
FRDS32A FEDERAL REPORTING DATA SYSTEM PAC,E NO
O 10/15/92 REPORT SELECTION CRITERIA
£
f? LOCATE STATEMENT IS) OR PWSID FILE USED FOR REPORT.
J3 LOCATE (0) C100 WH C3 EQ TX AND NK C103 EQ CAC.
^ THE FOLLOWING ITEMS WERE USED FOR SORTING.
^3 SORTED BY RBQION, STATE, PWS-ID
PWSID FILE NAME CREATED FOR LATER USE.
UUUAAAA.D921015.T173442 PWSIDS
PUBLIC MATER SYSTEMS SELECTED FOR THE REPORT: 4,653
70
o>
s
(/>
a
NJ
TJ
p
00
a>
<-*
\o
-------
FRDS32A
10/15/92
FEDERAL REPORTING DATA SYSTEM
FRDS-II GRANT ELIGIBILITY REPORT
PAGF MO
2
ACCEPTABLE DATA/CONDITIONS FOR GRANT ELIGIBILITY
SPECIFIC DATA VALUES
CONDITIONAL GRANT REQUIREMENTS
PWS-TYPE (C105) - C,P,N
PWS-ACTIVITY-FLAG (C107) - A
PWS - S EASON - BEG IN (C159) REQUIRED FOR NTOC AND NON-COMM WATER
AND SYSTEMS MUST BE MORE THAN 59 DAYS FOR
PWS-SEASON-END IC161) NON-COMM SYSTEMS MUST BE MORE THAN
179 DAYS FOR NTNC SYSTEMS
GRANT ELIGIBILITY REQUIREMENTS
PWS-ID
PWS-RETAIL-POP-SERVED
OR
PWS-SERVICE-CONNECTIONS
(C101) - PUBLIC WATER SYSTEM IDENTIFICATION
(CI17) - BOTH MUST BE VALUED,
ANY PWS WITH POP-SERVED < 25 AND
(C147) SERV-CONN < 15 AND NOT A WHOLESALER OF
WATER IS NOT GRANT ELIGIBLE
PWS-SYSTEM-NAME
PWS-SYSTEM-CITY
PWS-SYSTEM-STATE
PWS-SYSTEM-21P
(CI31) - MUST BE VALUED
(C137) - MUST BE VALUED
(C139) - MUST BE VALUED
(C141) - MUST BE VALUED
NOTE
THE GRANT RULES ACCORDING TO THE REVISED REPORTING REQUIREMENTS HAVE BEEN SELECTED FOR NON-COMMUNITY WATLR SYSTEMS
-------
m
8
p.
<
o
to
K)
50
a
K>
FRDS32A
10/15/92
FEDERAL REPORTING DATA SYSTEM
FRDS-II GRANT ELIGIBILITY REPORT
STATE. TX
REGION. 06
PWS
STATUS
SYSTEM NAME
coil
REASON IS) FOR FAILURE
TX0010006
CAC
LAKESIDE ESTATES WATER SY
CI 47
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0010008
CAC
EDQEMATER SHORES
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0010032
CAC
OPBLOUSAS ESTATES WATER S
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0010042
CAC
QAYTOP VILLAGE INCORPORAT
CI 47
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0030081
CAC
OAK RIDOB MOBILE HOME PAR
C147
PWS-SERVICE-CONN ETTIONS
IS
LESS
THAN
IS
TXOO0OO42
CAC
QAYTOP VILLAGE
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0100062
CAC
RANCH HILLS WATER SUPPLY
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0100063
CAC
OAK COUNTRY PROPERTY OWNE
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0140161
CAC
CQ4TRAL TEXAS WATER SUPPL
C117
PWS-RETAIL-POP-SERVED IS
; LESS THAN 25
TX0140163
CAC
OWL CREEK PRK WATER SUPPL
CI 47
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0150203
CAC
TOWNE AND COUNTRY MOBILE
C147
PWS-S ERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0150221
CAC
SAINT ANTHONY HIGH SCHOOL
CI 47
PWS-S ER VICE-CONNECTIONS
IS
LESS
THAN
IS
TX0150223
CAC
BAPTIST CHILDRQJ'S HOME
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
TX0180041
CAC
SHULER POINT WATER SYSTEM
C147
PWS-SERVICE-CONNECTIONS
IS
LESS
THAN
IS
THE ORANT RULES ACCORDING TO THE REVISED REPORTING REQUIREMENTS HAVE BEEN SELECTED FOR NON-COMMUNITY WATER SYSTEMS
"0
to
era
n>
-------
*0
(TO
PJ
L/l
KJ
FRDS32B
10/15/92
FEDERAL REPORTING DATA SYSTEM
FRDS-II INELIGIBLE REASON SUMMARY REPORT
PAGE NO
REGION 06
STATE. TX
SYSTEM
NAMEIC131)
NOT VALUED
SEASON BBG1N
DATE(C159) NOT
VALUED/VALID
SYSTEM
CITY (CI 37)
NOT VALUED
SEASON END
DATE(C161) NOT
VALUED/VALID
SYSTEM
STATE (CI 39)
NOT VALUED
1
RETAIL POP
(CI17) NOT
VALUED/VALID
SYSTEM
ZIP (CI41)
NOT VALUED
SERVICE CONN
(C147) NOT
VALUED/VALID
24
337
THE GRANT RULES ACCORDING TO THE REVISED REPORTING REQUIREMENTS HAVE BEEN SELECTED FOR NON-COMMUNITY WATER SYSTLMS
a
8
m
re
LOCATE STATEMENT USED. LOCATE (0) CI00 WH C3 EQ TX AND NK CI03 EQ CAC
PWSID PILE NAME CREATED FOR LATER USE: UUUAAAA D921015-T173442 PWSIDS
ro
m
3
R
p.
<
rt
O
w
n
NJ
-------
tfl
8
a.
<
ft
O
CO
ft
to
UJ
N>
FRDS32C
10/15/92
RCGION 06
STATE TX
REGION TOTAL
GRAND TOTAL
FEDERAL REPORTING DATA SYSTEM
FRDS-II GRANT ELIGIBLE SUMMARY REPORT
TOTAL
PWS'S POPULATION
COMM/ACTIVE/CURR SERVED
4,653
4,653
4.653
GRANT ELIGIBLE
ACTIVE PWS'S
COMM NON-COMM NTOC
16,077,449
16,077,449
16,077.449
4, 302
4,302
4.302
TOTAL
4, 302
4,302
4. 302
PERCENTAGE OF
CURRENT,ACTIVE SYSTEMS
ELIGIBLE
92 4 %
92 4 %
92.4 %
?0
ft
8
(/>
ft
ro
•• NOTE •• THE GRANT RULES ACCORDING TO THE REVISED REPORTING REQUIREMENTS HAVE BEEN SELECTED FOR NON-COMMUNITY WATER SYSTEMS
LOCATE STATEMQ*T USED. LOCATE (0) CI00 WH C3 EQ TX AND NK C103 EQ CAC:
PWSID PILE NAME CREATED FOR LATER USE: UUUAAAA D92101S T173442. PWSIDS
HD
OQ
ft
l/i
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.11 FRDS35 - Annual Data Evaluation
FRDS35 will generate a list of PWS IDs to be used as input to other FRDS-II reports.
Selection of PWS IDs may be done in its entirety, or a random 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 'Y'. 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 FRDS35. A report
dialog screen and annotated example reports are shown on the next five pages.
Page 5 - 54
Release 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS35 DIALOG
--> Enter the nurber of the desired FROS report: 35
--> Do you wish to add an additional identifying title line to your
FRDS35 report? (Y)es or (N)o: N
Having selected a FRDS35 report, you must provide
additional information ...
Do you want to select Select (A)ll or select a (R)andom sample only: R
How many random samples do you want select'
--> Random samples (1 to 999999): 25
--> Do you want the number of random samples specified to be selected for
each State which has been qualified' (Y)es or (N)o: Y
A file containing the PWS IDs of the systems selected will be created
for your later use ...
Please note the following file name for future reference:
uuuaaaa.D920610.I182324.PWSIOS
--> Do you want to sort the report data' (Y)es or (N)o: V
--> Sort on EPA region? (Y)es or (N)o: N
--> Sort on State' (Y)es or (N)o: N
Select one of the following minor sort sequences:
0 = None
1 = PWS ID
2 = PWS Type, PWS ID
3 = Retail Population Served (descending sequence), PWS ID
4 = Primary Source, PWS ID
5 - System City Name, PUS ID
6 - System Name, PWS ID
7 = System ZIP Code, PWS ID
--> Minor sort sequence mmber: /
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct' (Y)es or (N)o' K
Job 20532 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Effective Date: 12/31/92
Release 2 00
Page. 5 - 55
-------
*T3
U>
OQ
a
i
^ FEDERAL REPORTING DATA SYSTEM - FRDS-II
Q\ 10/20/92 PUBLIC WATER SYSTEM - REPORT SELECTION CRITERIA
FRDS3S PAGE
--- PWS COUNT
I OF PWS'S TO BE SELECTED ORIGINAL LOCATE COMMAND OR PWSIO PILE USED REGION STATE QUALIFIED SELECTED
2S FROM EACH STATE
LOCATE (0) C100 WH C3 EQ TX AND NK C103 EQ CAC.
06 TX 4,653 25
TOTAL 4.6S3 2S
THE FOLLOWING SCHEMA ITEMS WERE USED FOR SORTING:
>3 SORTED BY PWS ID
a
2
K
m
s5
R
c.
<
n>
a
pa
f?
to
u>
K)
-------
10/20/92
FRDS35
FEDERAL REPORTING DATA SYSTEM - FRDS-II
ANNUAL DATA EVALUATION REPORT
EPA REOIONi 06 PRIMACY STATE: TX PRIMACY¦ Y
SYSTEM NAME t ANCHOR ROAD MOBILE HOME PARK
SYSTEM ADDRESS ¦ ATTN B. JONES'*^
56 MIMOSA COURT
LAKE JACKSON k
ADDRESSES!
0 ADDR. TYPEi
NAME)
ADORi
SORTED BY PWS ID
PWS ID: TX02002S1
PHONEJ ^
TX 77566
ici3^i jcmi
O - SYSTEM OHNER/RBSI
O B SUTTON
BUILDING 6 APT 104
731 HERITAGE LANE
PLANT SERVICE AREA:
ID MAJOR CATEGORY
IC601I ^ 01 *J^iqE}flIAL |C603|
_ IC303I
[C30S^
C307I
!C3oT
|C3 111
I* INDICATES PRIMARY SERVICE AREAI
LE PARTY"
LAKE JACKSON
SUBCATEGORIES
~RESIDEJITIAL ¦ IC.PU J|
^ficT^jlcrg [cTTTl fcTTTL^ IcTTI
GRANT ELIOIBLE
STATUS
PLANT TYPE
OWNER TYPE
VISITS: NONE
ACTIVE INDICATOR i # INV UPDATE DATE
POPULATION SERVED: 66 NUMBER OP SERVICES i
REGULATE BY : S INV INSERT DATE
SURFACE %
GEOGRAPHIC AREAS SERVED
^ GROUND % ^ P
^ ES3 |?na Iraq
03/1B/92 ff BEGIN DATE
22 SEASON START
03/14/60. LAST UPDATE DATE:
PUR SURFACE %
i
*TE: 03
Ens
Y
CAC
C
2
cias
cTTH
cTTJ?
cTTS
03/18/9
DEACTIVATION DATE.
SEASON EUD
PRIMARY SOURCE
FUR GROUND « :
IC113
CI 61
E
ID
01
ADMIN
.REGION
ADMIN
DIST
CONG STATE
PIPS
INDIAN
.REGION A DIST ^ DIST COUNTY J COUNTY MSA . RESV CD CITY
ifeni rc^i I4tcfta02Ife^i 039ig^ni1145 i&ra tfeii
IC5031 |C505| IC508I l4»
SOURCE (SRC) /ENTRY POINT INFORMATION:
TYPE ID NAME
DATA
CODE AVAIL ORG LAT
LONG
SRC 001 GULF COAST Q S 01
PLT 9S0 ANCHOR ROAD MOB O H 0290200 09S2603
M ~ ± ill Fn 1
|C405|[C40il|C4 03| |C407| IC413I jC415| |C4i7| |C411| IC48U
PWS ID FILE NAME USED.
RDNFRDP D921020.T152S31 PWSIDS
SELLER ID
ID OBJECTIVE
01 DISINFECTION
TREATMENTS
PROCESS
GASEOUS CHLORINATION, PRE
-------
-o
(re
re
IV»
oo
W
re
8
(/>
re
K>
tfl
3
8
e.
<
ft
O
v>
re
10/20/92
FRDS35
reyi
E£k^ E5Sk^
FEDERAL REPORTING DATA SYSTEM - PROS-
ANNUAL DATA EVALUATION REPORT
II
EPA RBQIONs 06 PRIMACY STATE;
VARIANCE OR EXEMPTION
CONTAMINANT
TX
PRIMACY. Y
SORTED BY PWS ID
PWS ID: TX0200251
-B4PORCEMENTS-
ID
MODIFIED MCL
VAR/EXMP VAR/EXMP
CODE ID
I 1 11
LEGAL
STATUS
DATE
RELATED VIOLS
8H«
SPJ
01/01/87
8700554'
SPJ
04/01/87
8700555
SIF
10/01/82
8301212
SIP
11/01/62
8301213
SIP
01/01/83
8301214
SIP
12/01/82
830121S
SIP
OS/01/83
8301216
SIP
04/01/83
8301217
SIP
11/01/81
8201172
SIP
10/01/81
8201173
SIP
12/01/81
8201174
SIP
01/01/82
8201175
SIP
08/01/82
8201176
SIP
09/01/82
8201177
SIP
05/01/82
8201178
SIP
04/01/82
8201179
SIP
02/01/82
8201180
SIP
03/01/82
8201181
SIP
06/01/82
8201182
SIP
07/01/82
8201183
SIP
10/01/80
81010S7
SIP
12/01/80
8101058
SIF
01/01/81
8101059
SIP
05/01/81
8101060
SIP
06/01/81
8101061
SIF
02/01/81
8101062
SIF
04/01/81
8101063
SIF
08/01/81
8101064
SIF
09/01/81
8101065
SIF
07/01/81
8101066
tCl^Oll
tO
OJ
vO
ro
PUSID FILE NAME USED:
uuuaaaa 0921020.T152531.PUSIDS
-------
m
8
a.
<
a
D
#-»
13
NO
to
50
rt>
s
C/>
a
ro
10/20/92
FRDS3S
EPA REGION; 06
FEDERAL REPORTING DATA SYSTEM - FRDS-II
ANNUAL DATA EVALUATION REPORT
CONT
BEGIN
ID
TY
DATE
DUR
3000
03
01/01/87
003
3000
03
11/01/82
001
3000
03
12/01/82
001
3000
03
04/01/83
001
3000
03
10/01/81
001
3000
03
09/01/82
001
3000
03
01/01/82
001
3000
03
03/01/82
001
3000
03
04/01/82
001
3000
03
07/01/82
001
3000
03
10/01/80
003
3000
03
01/01/81
003
3000
03
02/01/81
003
3000
03
0S/01/81
003
3000
03
09/01/81
003
3000
03
05/01/80
003
3000
03
07/01/80
003
3000
03
09/01/80
003
3000
03
01/01/80
003
3000
03
03/01/80
003
PRIMACY STATE. TX PRIMACY. Y
VIOLATIONS
AWARE SMP ANALYTICAL VIO
DATE TKN RESULT 10
SORTED BY PWS ID
PWS ID: TX02002S1
tt t t
000
000
000
000
000
000
000
000
000
000
000
000
000
000
000
«*(•>] »*I
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.1.12 FRDS43 - Non-Compliance Report
The FRDS43 Report provides information about the Significant Non-Comphers (SNC)
contained on the data base. It is basically three reports in one joined together by the fact that
they are driven off the contents of the C4050 (DBA-DATA) records which are SNCs for the
date selected. The three reports that make up the Non-compliance Report are:
FRDS43A - The summary non-compliance report;
FRDS43B - SNC and tier2 non-compliance detail report; and
FRDS43C - PWS(s) & related violations & enforcements report.
A report dialog screen and annotated example reports are shown on the next six pages.
Page. 5 - 60
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS43 DIALOG
-•> Enter the nunber of the desired FRDS report: 43
--> Do you wish to add an additional identifying title line to your
FRDS43 report' (Y)es or (N)o: N
You have selected the FRD43 Report which will be limited to those PWSs which
were identified as either Tierl and/or Tier2 Non-cotnpliers in your current
locate statement. The report will include ICR SMCs. In order to run the FRDS43
Report, certain additional information is required as follows:
For which Federal fiscal year and quarter do you wish to produce a SNC report?
--> Enter Fiscal Year and Quarter (YYOQ): 9103
For the fiscal year and quarter listed above, which type of SNC list
would you like to produce'
1 -- Preliminary SNC list (generated 20 days before the end of the quarter)
2 -- Final SNC list (generated at the end of the quarter)
--> Enter 1 or 2: 2
For which contaminant groups do you want a report'
1) Total Coliform (TCR)/Turbidity;
2) Chem/Rad;
3) Contaminant groups merged'
4) Contaminant groups separate'
--> Enter your contaminant group: 4
--> Please enter the type of Non-cocnpllance Report you wish:
1) Summary Only 5) Detail Only 7) Violation Only
2) Suimary & Detail 6) Detail & Violation
3) Summary & Violation
it) Suimary, Detail & Violation
--> Enter Non-compliance report choice 1 through 7: 4
--> Please enter the type of summary you wish:
1) State Only 5) Regional Only 7) National Only
2) State & Regional 6) Regional & National
3) State & National
Enter Suimary Type 1 through 7: /
The report will be produced with the information in order by Region and State.
Within Region and State, you may specify the order in which PUSs are to be
presented:
1) by PWS ID;
2) by System Name and PWS-ID
3) in descending sequence by population served
--> Enter Sort Order 1, 2, OR 3: I
Effective Date. 12/31/92
Release: 2.00
Page: 5-61
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
FRDS 43 DIALOG (CONTINUED)
Please indicate the tier to be presented:
1) Tier 1 (SNC(s))
Z) Tier 2 (Pre-SNC(s))
3) Both Tier 1 and 2 Merged together
4) Both Tier 1 and 2 reported separately
--» Enter Tier selection 1, 2, 3, or 4: 4
Your current Job parameters are:
FIMAS ID: fffff
Destination: HOLD
Bin/Box: Muuu
Estimated Time: Long
Priority: 2
Printer Type: Destination
Copies of Report: 01
--> Are these parameters correct-* (Y)es or (N)o' Y
Job 20806 Submitted ...
--> Would you like to submit another FRDS report' (Y)es or (N)o: N
Page- 5 - 62
Release: 2.00
Effective Date- 12/31/92
-------
m
8
P.
<
O
a
&>
fo
vo
5*
£L
s
t/1
«
K>
10V19/92
FRDS4 3A
FEDERAL REPORTING DATA SYSTEM - FRDS-II
REPORT SELECTION CRITERIA
LOCATE STATEMENT(S) USEO FOR REPORT:
LOCATE |0> C1100 Wi NK C113S EQ 92 AND C3 BQ TX.
THE FOLLOW IMG SCHEKA ITEMS MERE USED FOR SORTING:
SORTEO Br REGION, STATE. PWS ID
PUBLIC HATER SYSTEMS SELECTED FOR THE REPORT:
REPORT SELECTION CRITERIA
REPORT PERIOD SELECTED - 9103
BASE VEAFt/QTR 91/01
DATABASE PRODUCTION
36
RUN TYPE
SNC CONTAMINANT TYPES
REPORT CHOICE
SUMMARY TYPE
DETAIL SORT ORDER
TIER REQUESTED
= PINAL RUN
- ALL SEPARATE
= SUMMARY, DETAIL AND VIOLATION
- STATE ONLY
c BY PMS ID
= BOTH TIERS SEPARATE
CODE
CONTAMINANT
SNC
CODE
CONTAMINANT
SNC
CODE
CONTAMINANT
SNC
DESCRIPTION
LEVEL
DESCRIPTION
LEVEL
DESCRIPTION
LEVEL
1005
ARSENIC
.10000
2U36
36 UNREGULATED PHASE
I VOCS
NOT SET
2977
1,1-DICHLOROETHYLENE
.01400
1010
BARIUM
2 00000
2V07
7 REGULATED PHASE I
VOCS
NOT SET
29B0
1,1- D1CHLOROETHANE
04000
1015
CADMIUM
.02000
2V08
8 REGULATED PHASE I
VOCS
NOT SET
2981
1,1,1 -TRICHLOROETHANE
1
00000
1020
CHROMIUM
.10000
200S
ENDRIN
.00040
2982
CARBON TETRACHLORIDE
.03000
1025
FLUORIDE
5.00000
2010
LINDANE
.00400
2984
TOICH LOROETHY LIME
30000
1030
LEAD
.05000
2015
METHOKYCHLOR
.10000
2990
BENZENE
01000
1015
MERCURY
.00400
2020
TOXAPHENE
01250
4000
GROSS ALPHA
30
ooooo
1040
NITRATE
10.00000
2105
2.4-D
.20000
4010
COMBINED RADIUMI-226 1
-228 10.
.00000
1045
SELQHUM
.02000
2110
2.4.S-TP
02000
4100
MANHAOE BETA
10
00000
1050
SILVER
10000
2950
TTHMS
.10000
2U1S
IS UNREGULATED
PHASE I
VOCS
NOT SET
2969
P-DICHLOROBENZEUE
.15000
2U34
34 UNREGULATED
PHASE I
VOCS
NOT SET
2976
VINYL CHLORIDE
.00200
*X5
W
TO
CI
-------
*0
&
a
to
m
5s
R
r—f-
<
a
a
Si
?!
— LOCATE STATEHENT:
££ LOCATE (0) C1100 UH NIC C1135 EQ 92 AND C3 EQ TX:
hO
-------
m
3
8
<
o
O
tt>
re
N>
C2
vO
to
50
re
K>
T3
P>
cm
n
en
10/19/92
FROS43B
STATE: TEXAS
REGION: VI
NONCOMPLIANCE LEVEL(S): TIER! (SNC)
FEDERAL REPORTING DATA SYSTEM - FRDS-II
SNC t TIER2 NONCOMPLIANCE DETAIL REPORT
COMPLIANCE PERIOD 07/01/90 - 06/30/91
SORTED BY REGION, STATE, PWS ID
PWS-ID
IC101I
PUBLIC WATER SYSTEM NAME STAT TYP POPULATION CONTAMINANT
DESCRIPTION
IC103IIC1631
TIER/
TYPE
ANALYSIS MOST RECENT
RESULT ENFORCEMENT
ACTION
BASE YEAR/QTR: 91/03
DATABASE: PRODUCTION
CONTAMS: TCR/TURB
PAGE 2
DATE PRIOR QTR
OF SAME TIER
ACTION 1/2/3/4/5
TX0010051
WESTERN COMPANY
CIC
PRI
17
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
07/20/91
-/-/-/-/-
TX0100048
MT ZION CHRISTIAN MISSIO
PAC
MIX
75
COLIFORM
(TCR)
1/MAJOR
N/A
FED FAO ISSUED
07/28/92
Y/-/-/-/-
TX0220031
TERLINQUA GHOST TOWN
CAC
PRI
100
COLIFORM
(TCR)
1/MAJOR
N/A
FED FAO ISSUED
04/08/92
Y/-/-/-/-
TX0360005
GRAYS TRAILER COURT
CAC
PRI
39
COLIFORM
(TCR)
1/MAJOR
7.500
FED FORMAL NOV
07/24/91
-/-/-/-/-
TX0610172
CHEROKEE MEADOWS
CAC
PRI
50
COLIFORM
(TCR)
1/MAJOR
N/A
FED PAO ISSUED
10/29/91
Y/Y/Y/Y/Y
TX0680057
RICHEY'S MOBILE HOME PAR
CAC
PRI
40
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
04/20/91
Y/Y/Y/-/Y
TX0790261
NIAGRA SUBDIVISION WATER
CAC
PRI
90
COLIFORM
(TCR)
1 /MAJOR
N/A
FED FAO ISSUED
05/05/92
Y/Y/-/-/-
TX0840057
LOUIS BAIT CAMP
CAC
PRI
99
COLIFORM
(TCR)
1/MAJOR
N/A
FED PAO ISSUED
11/20/91
Y/Y/Y/Y/Y
TX0930002
SHADOW LAKE SUBDIVISION
CAC
MIX
23
COLIFORM
(TCR)
I/MAJOR
N/A
FED PAO ISSUED
06/15/92
Y/Y/Y/-/Y
TX1011S57
M H KOOMEY INC
PAC
PRI
58
COLIFORM
(TCR)
1 /MAJOR
N/A
FED PAO ISSUED
08/17/92
Y/Y/Y/-/-
TX10I2722
CHEMICAL RESEARCH AND LI
PAC
PRI
52
TURBIDITY
1/MAJOR
N/A
FED PAO ISSUED
07/14/92
-/-/-/-/-
TX1070024
GRADY'S MOBILE HOME PARK
CAC
PRI
51
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
10/20/91
Y/-/-/-/-
TX1080212
MUNI2 SUBDIVISION
CAC
PRI
200
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
10/20/91
Y/Y/Y/-/-
TX1100023
SOUTH COMMUNITY COOP
PAC
PRI
40
COLIFORM
(TCR)
1/MAJOR
N/A
FED FORMAL NOV
08/01/91
-/-/-/-/-
TX1330110
FOREST OAKS MOBILE HOME
CAC
PRI
80
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
10/20/91
Y/Y/Y/Y/Y
TX1450020
WEST CEDAR CREEK WATER S
CAC
PRI
30
COLIFORM
(TCR)
1/MAJOR
N/A
FED CFP ISSUED
08/31/92
Y/Y/Y/Y/Y
TX1450026
HILLS THE
CAC
PRI
32
COLIFORM
(TCR)
1/MAJOR
N/A
FED CFP ISSUED
08/28/92
Y/Y/Y/-/Y
TX1460115
SOUTH DAYTON OAKS
CAC
PRI
50
COLIFORM
(TCR)
1/MAJOR
N/A
ST FORMALNOV IS
10/20/91
Y/Y/Y/Y/Y
C117I tCl 1031
IC4051
I i 4
IC112 j Ic 12051 Icl 2031
LOCATE STATEMENT:
LOCATE (0) CI 100 WH NK C113B EQ 92 AND C3 EQ TX:
-------
*0
P?
TO
S
10/19/92
FRDS43C
STATE i TEXAS
REGION: VI
NONCOMPLIANCE LEVEL(SI i TIER1 (SNC)
PMS-ID, SYSTEM POPULATION
STATUS, NAME/ADDRESS/TELE PHONE SERVED
OWNER.
FEDERAL REPORTING DATA SYSTEM - FRDS-II
PWS(S) & RELATED VIOLATIONS 4 ENFORCEMENTS
COMPLIANCE PERIOD 07/01/90 - 06/30/91
SORTED BY REGION. STATE. PWS ID
NONCOMPLIANCE CHARACTERIZATION--
TIER AND RELATED VIOLATIONS
ID TYPE CNTAM RESULT DATE
BASE YEAR/QTR 91/03
DATABASE PRODUCTION
CONTAMS. TCR/TURB
PAGE 2
DUR
RELATED
ENFORCEMENTS
ACTION DATE
TX0010051
PRIVATE
ICIOII
TX0100048
MIXED
WESTERN COMPANY
15 RANGE AVE
PALESTINE
TX 75801 ( )
TIER1 - SNC - 91 - 0 3 - TCR - MAJOR
MO
IC4061I
91V0004
91V000S
91V0006
91V0001
|91V0002
91V0003
••VIOLATION NO LONOER IN FRDS**
••VIOLATION NO LONGER IN FRDS**
••VIOLATION NO LONOER IN FRDS**
23 3100
N/A
23 3100
N/A
04/01/91 03 ST FORMALNOV IS 07/20/91
FED FORMAL NOV 07/19/91
01/01/91 03 FED FORMAL NOV 07/19/91
ST FORMALNOV IS 04/20/91
••VIOLATION NO LONGER IN FRDS"
50
a
ft
to
CI 37
NT 2ION CHRISTIAN MI
17 DOCK STREET
PIPE CREEK
TX 76063 ( )
. 75 X
TIER1-SNC-91-03-TCR-MAJOR
10/02/91 MO
91V0004
91V0005
91V0002
91V0003
91V0001
90V0001
91V0003
••VIOLATION NO
••VIOLATION NO
25 3100
••VIOLATION NO
03 3000
LONGER IN FRDS" f
LONGER IN FRDS** IC406.
N/A 07/01/91
FED FAO ISSUED
01 ST FORMALNOV IS 08/20/91
07/28/92
FED PAO ISSUED 05/13/92
FED FAO ISSUED 07/26/92
03 3000
23 3100
* i
IC110SIC11031
LONOER IN FRDS**
N/A
N/A
N/A
10/01/90 03 ST FORMALNOV IS 01/20/91
FED FORMAL NOV 04/03/91
FED FORMAL NOV 04/03/91
FED FAO ISSUED 07/26/92
FED PAO ISSUED 05/13/92
FED FAO ISSUED 07/26/92
07/01/90 03 ST FORMALNOV IS 10/20/90
FED FORMAL NOV 04/03/91
FED FORMAL NOV 04/03/91
FED FAO ISSUED 07/28/92
FED PAO ISSUED 05/13/92
FED FAO ISSUED 07/28/92
01/01/91 03 FED FORMAL NOV 04/05/91
IC1107I ICllllI |C 12051 [Cn031
m
5
8
p.
<
D
W
a
LOCATE STATEMENT:
LOCATE (0) C1100 WH UK C1135 EG 92 AND C3 EQ TX:
K>
W
vO
K)
-------
rRDS-ll INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31,1992
5.2.2 Option 'C' - Create A Sequential File
This FRDS-II option provides the user with the ability to extract data from the data base and
place it in a sequential file. The user specifies what data is wanted in the file by answering
various questions (prompts) displayed on the screen.
The following sample session demonstrates how to use the Post Retrieval Output Option C.
Effective Date: 12/31/92
Release: 2.00
Page 5 - 67
-------
FRDS-ll INTERACTIVE RETRIEVAL USER'S GUIDE
IJsttiif the Post Retrieval Output Options Menu
S DC-0055 -005 - LN -2005
December 31, 1992
OPTION C
PROS-11/Interact1ve
Post Retrieval Output Options Menu
(B) Batch Job Submission (I) List in Standard Screen Format
(C) Create a Sequential File (Q) Quicktook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
Enter the Code which corresponds to the desired Post Retrieval
Output Option C
Uelcome to the FR0S-11 File Generator
Version: 1 00 Release: 0.0
10/26/91 16.19.33
*** Specification Definition Section ***
--> Uhat type of file would you like to generate7
(F)IXED format records,
(other file types will be added in later releases)
File Iype '
You have chosen to define a new file specification. This is the first
of several prompts that will request information about what data you
want in the file and in what format you want the data stored. Your
response to this prompt will define the basic type of file that you
want created. In Version 1.0 of this program, a single file type
is available. 'FIXED' Please refer to the FRDS-II File Generator
Capability Users' Manual for a complete description of this file
type
--> Press to continue:
--> Uhat type of file would you like to generate7
(F)IXED format records,
(other file types will be added in later releases)
F11e T ype: /•'
Please specify the data elements and data base records that are to
be included in your file. You may also request that literals
(enclosed in single quotes), the current date (DATE) and/or the
time of day (TIME) should be included as a field in the output
file Enter your output field requests individually, in response
to the "output field*" prompt When you have finished specifying
the desired contents of the output file, enter 'END' or a pound
sign ('#') in response to the "output field:" pron^jt, then press
the key.
Page 5 - 68
Release 2.00
Effective Date. 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION C (CONTINUED)
--> Output Field: HELP
You are defining the content desired to be placed into the
output file being generated. You may define the output fields
using any of the following:
JCOOE j
[DESCRIPTION]
key.
--> Press to continue:
--> Output Field: PWS-ID
C101 PWS-ID
--> Output Field: CI3I
C131 PWS-SYSTEM-NAME
--> Output Field: C103
C103 PWS-STATUS CODE
--> Output Field: CI03 D
C103 PUS-STATUS DESC
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT: C101 PUS-ID
ELEMENT: C131 PUS-SYSTEM-NAME
ELEMENT: C103 PUS-STATUS COOE
ELEMENT: C103 PUS-STATUS DESC
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT: C101 PUS-ID
ELEMENT: C131 PUS-SYSTEM-NAME
DATE
TIME
Effective Date: 12/31/92
Release: 2.00
Page: 5-69
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION C (CONTINUED)
--> Output Field: C103C
C103 PUS-STATUS CODE
--> Output Field: C103D
103 PUS-STATUS DESC
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT
ELEMENT
ELEMENT
ELEMENT
C101 PUS-ID
C131 PWS-SYSTEM-NAME
C103 PUS-STATUS CODE
C103 PUS-STATUS DESC
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT
ELEMENT
ELEMENT
C101 PUS-ID
C131 PUS-SYSTEM-NAME
C103 PUS-STATUS COOE
--> Output Field: CI17
C117 PUS-RETAIL-POP-SERVED
--> Output Field: PWS-SERVICE-CONNECTIONS
CK7 PUS-SERVICE-CONNECTIONS
--> Output Field: CI63
C163 PUS-OUNER-TYPE COOE
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT
ELEMENT
ELEMENT
ELEMENT
ELEMENT
ELEMENT
C101 PUS-ID
C131 PUS-SYSTEM-NAME
C103 PUS-STATUS COOE
C117 PUS-RETAIL-POP-SERVED
C167 PUS-SERVICE-CONNECTIONS
C163 PUS-OWNER-TYPE CODE
--> Output Field: C400
MOO PUS-SOURCE-ENTITY-INFO
--> Should FRDS generated data elements be CONCLUDED in or
(E)XCLUDED from the output file' /
Should the (C)OOE or (D)ESCRIPTION be output for
C405 PUS-SE-RECORD-TYPE C
Should the (C)ODE or (D)ESCRIPTION be output for
C407 PUS-SE-COOE C
Should the (C)ODE or (D)ESCRIPTION be output for
C409 PUS-SE-AVAILABILITY C
Page. 5 - 70
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Post Retrieval Output Options Menu December 31. 1992
OPTION C (CONTINUED)
Should the (C)OOE or (D)ESCRIPTION be output for
C413 PUS-SE-DATA-OR1GIN C
Should the (C)OOE or (D)ESCRIPTION be output for
C425 PUS-SE-OTR-SECTION C
Should the (C)ODE or (D)ESCRIPTIOM be output for
C4Z6 PWS-SE-OTR-QTR-SECTION C
Should the (C)OOE or (D)ESCRIPTION be output for
C429 PWS-SE-ON-REACH C
--> Output Field: C4S0
C480 PWS-SE- TREATMENT-DATA
--> Should FRDS generated data elements be CONCLUDED in or
(E)XCLUDED from the output file? E
Should the (C)OOE or (D)ESCRIPTION be output for
C483 PUS-SE-TREATHENT-OBJECT IVE C
Should the (C)GOE or (D)ESCRIPTION be output for
C485 PWS-SE- TREATMENT-PROCESS C
--> Output Field: REVIEW
FILE TYPE: FIXED
ELEMENT
C101
PWS-10
ELEMENT
C131
PWS-SYSTEM-NAME
ELEMENT
C103
PUS-STATUS COOE
ELEMENT
C117
PUS-RETAIL-POP-SERVED
ELEMENT
C147
PUS-SERVICE-CONNECT IONS
ELEMENT
C163
PUS-OWNER-TYPE COOE
RECORD:
MOO
PUS-SOURCE-ENTITY-INFO
GENERATED: INCLUDED
ELEMENT
C401
PUS-SE-ID
ELEMENT
C403
PUS-SE-NAME
ELEMENT
C405
PUS-SE-RECORD-TYPE COOE
ELEMENT
C407
PUS-SE-COOE COOE
ELEMENT
C409
PWS-SE-AVAILABILIT Y COOE
ELEMENT
C411
PUS-SE-SELLER-PUS-ID
ELEMENT
C413
PUS-SE-DATA-ORIGIN COOE
ELEMENT
C415
PUS-SE-LATITUDE
ELEMENT
C417
PUS-SE-LONGITUDE
ELEMENT
C418
PUS-SE-MERIDIAN-NAME
ELEMENT
C419
PUS-SE-TOUNSHIP
ELEMENT
C421
PUS-SE-RANGE
ELEMENT
C423
PUS-SE-SECTION
ELEMENT
C425
PUS-SE-QTR-SECT ION COOE
ELEMENT
C426
PUS-SE-QTR-OTR-SECTION COOE
ELEMENT
C427
PUS-SE-RIVER-REACH-NUM
ELEMENT
C429
PUS-SE-ON-REACH COOE
ELEMENT
C431
PUS-SE-REACH-MILES
ELEMENT
C433
PUS-SE-FUTURE-ALPHA
ELEMENT
C435
PUS-SE-FUTURE-DATE
ELEMENT
C437
PUS-SE-FUTURE-DEC
RECORD:
C480
PUS-SE-TREATMENT-DATA
Effective Date: 12/31/92
Release' 2.00
Page 5-71
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION C (CONTINUED)
GENERATED: EXCLUDED
ELEMENT: C481 PWS-SE-TREATMENT-ID
ELEMENT: C483 PWS-SE-TREATMENT-OBJECTIVE CODE
ELEMENT: C485 PWS-SE-TREATMENT-PROCESS COOE
--> Output Field: S
--> Uould you like -null- values converted to blanks7 (Y)ES or (N)0:
HELP
When no value has been supplied for a particular data element in the
FRDS-tl data base, an indicator is placed in the data element. This
indicator is called a "-null-" value. -Null- values have an adverse
effect on some computer applications, particularly many which are conmonly
used to down-load information from the mainframe to personal computers.
To circumvent this problem you may choose to have the -null- values
converted to blanks. Respond 'YES' to the question if you want them
converted, otherwise reply 'NO' and any -null- values in the output
fields you requested will be placed in the generated output file.
--> Press to continue:
--> Uould you like -null- values converted to blanks7 (Y)ES or (N)O:
Y
*** Specification Processing Section ***
The following files will be created and will contain the
requested output data and a description of that data:
'uuuaaaa.F2FGEN.D920610.T18S709.DESC'
'uuuaaaa.F2FGEN.D920610.T185709.OUTPUT'
--> Should your file be generated now or later (in batch mode)7
(N)0W or (L)ATER, in batch mode: N
Working ... To interrupt, press the or key
Files successfully generated'
The requested files have been created and contain the output
data and a description of that data.
--> Would you like to define or generate another file7
(Y)ES or (N)0: N
Exiting the FRDS-II File Generator1
Page 5 - 72
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC-0055 -005-LN -2005
December 31, 1992
5.2.3 Option 'F' - Frequency Distribution
Option 'F' of the Post-Retrieval Options Menu generates the Frequency Distribution of the
data selected. This report may be displayed on a terminal or printed on an off-line, high
speed printer.
The Frequency Distribution 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 be sorted by occurrence, from most to fewest.
The sample session on the next page shows how to use Option 'F\ Report samples and
explanations are also provided in the sample session.
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 73
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION F
FRDS-11/Interact i ve
Post Retrieval Output Options Henu
(B) Batch Job Submission CL) List in Standard Screen Format
(C) Create an External File (0) Quick look Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
•-> Enter the Code which corresponds to the desired Post Retrieval
Output Option: F
**** FREOUENCY OPTION *"*
You may interrupt the processing of a data element by pressing the or
key twice.
--» Do you wish to produce a Frequency Distribution'' (Y)es or Enter the Data Element Nintoer: C103
--> Do you wish to sort the distribution by occurrence (most/fewest)7
(Y)es or (N)o: N
--» Where should the report be produced7
On your (T)erminal or a High-speed (P)nnter: T
06/10/92
TALLY OF C103 - PVS-STATUS
********************************
OCCURRENCES VALUE
44 CAC
********************************
1 UNIQUE VALUES
44 TOTAL OCCURRENCES
********************************
IOC C100 UH C115 SPANS I*K AND C3 EQ TX:
********************************
--> Would you like to route this report to a printer now7 (Y)es or (N)o: N
--> Do you wish to produce another Frequency Distribution7 (Y)es or (N)o: Y
--* Enter the Data Element Nunber: C407
-•* Do you wish to sort the distribution by occurrence (most/fewest)7
(Y)es or (N)o: N
--> Where should the report be produced?
On your (T)erminal or a High-speed (P)rinter: T
Page: 5-74
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION F (CONTINUED)
ft*******************************
06/10/92
TALLY OF C407 - PUS-SE-CCOE
********************************
OCCURRENCES VALUE
74 G
44 0
16 P
42 S
********************************
4 UNIQUE VALUES
176 TOTAL OCCURRENCES
0 PWS(s) WITHOUT PWS-SOURCE-ENTITY-INFO
********************************
LOC C100 UH C115 SPANS l*K AND C3 EQ TX:
********************************
--> Would you like to route this report to a printer now?
(Y)es or Do you wish to produce another Frequency Distribution?
(Y)es or (N)o: Y
--> Enter the Data Element Nunber: C407
--> oo you wish to sort the distribution by occurrence (most/fewest)?
(Y)es or (N)o: Y
--> Where should the report be produced?
On your (T)erminal or a High-speed (P)rinter: T
********************************
06/10/92
TALLY OF C407 - PWS-SE-CODE
********************************
OCCURRENCES VALUE
74 G
44 O
42 S
16 P
4 UNIQUE VALUES
176 TOTAL OCCURRENCES
0 PWS(s) WITHOUT PWS-SOURCE-ENTITY-INFO
********************************
LOC C100 UH C115 SPANS I*K AND C3 EQ TX:
********************************
--> Would you like to route this report to a printer now?
(Y)es or (N)o: N
--> Do you wish to produce another Frequency Distribution?
(Y)es or (N)o: N
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 75
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.4 Option 'L' - List in Standard Screen Format - Reports for Suboption Screens
Option 'L' of the Post-retrievalOutput 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 follows:
Suboption Screen Type of On-line Information
1 PWS and Service Area Information
2 PWS and Source Information
3 PWS Variance and Exemptions Data
4 PWS Related Enforcements
When the user has selected Function 'A', which retrieves only PWSs with violations,
FRDS/Interactive invokes the Primary Screen Type #3 automatically and skips to the sort
question.
When the user has selected Function 'X' the system prompts for a Primary Screen Type.
In Function 'E' or 'X', the user has the choice of specifying various Secondary Screen Types
for viewing data on individual PWSs. Then, the PWSs may be optionally sorted in one of
several predefined ways.
Option 'L' gives the user the capability of viewing selected PWSs in the browse mode. The
reports may be displayed one PWS at a time on a terminal, or the entire set of selected
PWSs 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.
Page: 5 - 76
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION L
FRDS-1 I/Interactive
Post Retrieval Output Options Menu
(8) Batch Job Submission (L)
(C) Create an External File (Q)
(F) Frequency Distribution
List in Standard Screen Format
Quick look Report Generator
- - >
- - >
(E) End Post Retrieval
Enter the Code which corresponds to the desired Post Retrieval
Output Option: L
Enter primary screen selection type (1 to 5): I
Do you want to sort the report data? Y/N: ¥
--> Sort on region7 Y/N : N
--> Sort on state' Y/N : N
Select one of the following Minor SORT COOES:
0 = NONE
1 = PUS-ID
2 = PUS TYPE, PUS-ID
3 = RETAIL POPULATION SERVED(descending sequence), PUS-ID
4 = PRIMARY CODE, PUS-ID
5 = SYSTEM CITY NAME, PUS-ID
6 = SYSTEM NAME, PUS-ID
7 = SYSTEM ZIP COOE, PUS-ID
--> Sort code' 1
--> Do you want output listed offline' Enter Y/N: /V
--> Display these PUS(s)' Enter Y/N: Y
--> Stop after each PUS' Enter Y/N: K
PUS-ID: TX0140005
SYSTEM NAME/ADDRESS:
TEMPLE CITY OF
PUS-STATUS: CAC
CITY:
STATE REGION:
STATE DISTRICT:
FIPS COUNTY:
027
4820 PARKSIDE OR
TEMPLE TX
76502
PRIMARY SOURCE: S
OWNER-TYPE: 4
TOTAL VIOLATIONS:
POSTING DATE:
INV LAST UPDATED:
0 POPULATION SERVED:
SERVICE CONNECTIONS:
05/26/92
52,242
22,260
PRIMARY SERVICE AREA(S):
Residential Area
CURRENTLY AT PUS
1 OUT OF
44 POSSIBLE PUS'S
YOU CAN BROUSE THRU THE SELECTED PUS FILE IF YOU UISH
YOUR OPTIONS FOR BROWSING ARE:
F = FIRST PUS
L = LAST PUS
N = NO BROUSE, USE NEXT PUS
E = END BROWSING, SELECT NEXT FUNCTION
S = SKIP THRU THE SELECTED PUS FILE
C = CHANGE TO DIFFERENT SCREEN FOR THIS PUS
Effective Date: 12/31/92
Release' 2 00
Page: 5 - 77
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
OPTION L (CONTINUED)
-> Enter your option, please: C
-> Enter secondary screen selection type (1 to 5): 2
PUS-10: TX0140005 PUS-STATUS: CAC STATE REGION:
SYSTEM NAME/ADDRESS: OWNER NAME/ADDRESS: STATE DISTRICT:
TEMPLE CITY OF W A PREUITT III
4820 PARKSI0E OR
TEMPLE TX 76502
PRIMARY SOURCE: S TOTAL VIOLATIONS:
SYSTEM NAME
TEMPLE CITY OF
PRIMARY SOURCE: S TOTAL VIOLATIONS:
NO VIOLATIONS FOR THIS PUS IN DATA BASE
INV LAST UPOATED:
0 POPULATION SERVED: 52,242
TREATMENTS
ID
OBJ
PRO
01
D
403
02
P
240
03
P
600
04
P
360
05
P
660
06
P
345
07
T
125
06
D
200
09
B
200
10
Z
380
11
C
740
12
B
200
13
Z
380
14
D
401
REGION:
STATE DISTRICT:
FIPS COUNTY: 027
0 POPULATION SERVED: 52,242
DUR ENF-ID ACTION
¦--SOURCE---
ID NAME
REC DATA
TYP COO AVA ORIG RIVER REACH LATITUDE LONGITUDE
001 LEON RIVER
950 TEMPLE CITY OF P 0
310553 0972033
CURRENTLY AT PUS
1 OUT Of
44 POSSIBLE PWS'S
-> Enter your option, please: C
-> Enter secondary screen selection type (1 to 5): 3
PUS-ID: TX0140005
PUS-STATUS: CAC
STATE
VIOLATIONS AND ENFORCEMENTS
CNTM TY DATE VIO-ID
CURRENTLY AT PUS 1 OUT OF 44 POSSIBLE PUS'S
Page: 5-78
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE SDC-0055-005-LN-2005
Using the Post Retrieval Output Options Menu December 31, 1992
OPTION L (CONTINUED)
--> Enter your option, please: C
--> Enter secondary screen selection type (1 to 5): 4
PWS-IO: TX0140005 PUS-STATUS: CAC STATE REGION:
SYSTEM NAME STATE DISTRICT:
TEMPLE CITY OF F1PS COUNTY: 027
PRIMARY SOURCE: S TOTAL VIOLATIONS: 0 POPULATION SERVED: 52,242
- VARIANCES/EXEMPTIONS
TYPE CNTM VE-ID MOOIFIED MCL EXP DATE ACTION REASON
NO VARIANCES/EXEMPTIONS FOR THIS PUS IN DATA 8ASE
CURRENTLY AT PWS 1 OUT OF 44 POSSIBLE PUS'S
-•> Enter your option, please: C
--> Enter secondary screen selection type (1 to 5): 5
PUS-ID: TX0140005 PUS-STATUS: CAC
SYSTEM NAME
TEMPLE CITY OF
PRIMARY SOURCE: S TOTAL ENFORCEMENTS: 0 POPULATION SERVED: 52,242
ENFORCEMENT ACTIONS
ACTION RELATED VIOLATION DATA
ENF-ID DATE ACTION ID DATE TYPE CNTM
No enforcements for this PUS in data base
CURRENTLY AT PUS 1 OUT OF 44 POSSIBLE PUS'S
--> Enter your option, please: »
YOU CAN BROUSE THRU THE SELECTED PUS FILE IF YOU UISH
YOUR OPTIONS FOR BROUSING ARE:
F = FIRST PUS
L = LAST PUS
N = NO BROWSE, USE NEXT PUS
E = END BROUSING, SELECT NEXT FUNCTION
S = SKIP THRU THE SELECTED PUS FILE
C = CHANGE TO DIFFERENT SCREEN FOR THIS PUS
Effective Date' 12/31/92
Release 2 00
Page: 5 - 79
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
^DC-0055-005-LN-2005
December 31, 1992
OPTION L (CONTINUED)
--> Enter your option, please: S
ENTER +rmm TO SKIP FORWARD mrm PUS
ENTER -mm TO SKIP BACKWARD nnrm PUS
--> Enter skip parameter: +38
PWS-ID: TX2210001
SYSTEM NAME
ABILENE CITY OF
P 0 BOX 60
ABILENE
PUS-STATUS: CAC
CITY:
TX 79604
PRIMARY SOURCE: S TOTAL VIOLATIONS:
OUNER-TYPE: 4
PRIMARY SERVICE AREA(S):
Residential Area
STATE REGION:
STATE DISTRICT:
FIPS COUNTY: 441
POSTING DATE: 03/18/92
1NV LAST UPDATED:
4 POPULATION SERVED: 106,400
SERVICE CONNECTIONS: 36,767
CURRENTLY AT PWS
39 OUT OF
44 POSSIBLE PWS'S
-> Enter your option, please: C
-> Enter secondary screen selection type (1 to 5): 3
PUS-10: TX2210001
SYSTEM NAME
ABILENE CITY OF
PRIMARY SOURCE: S
PUS-STATUS: CAC
STATE REGION
STATE DISTRICT
FIPS COUNTY
TOTAL VIOLATIONS: 4 POPULATION SERVED:
VIOLATIONS AND ENFORCEMENTS
441
106,400
CNTM TY DATE VI0-ID
DUR ENF-ID ACTION
3100 24 10/01/91 9211698 SAMP-REQUIRED: / TAKEN: 0 1
3100 06 10/01/91 9211699 1
3100 25 06/01/91 91V0001 SAMP-REQUIRED: / TAKEN: 0 1 91E0001 SFJ
3000 03 04/01/90 90V0001 SAMP-REQUIRED: 100 / TAKEN: 096 1 90E0001 SFJ
ft*****************************************************************************
CURRENTLY AT PUS
39 OUT OF
44 POSSIBLE PUS'S
Page: 5 - 80
Release: 2.00
Effective Date. 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC -0055-005- LN -2005
December 31, 1992
OPTION L (CONTINUED)
--> Enter your option, please: C
--> Enter secondary screen selection type (1 to 5): 5
PUS-10: TX2210001 PUS-STATUS: CAC
SYSTEM NAME
ABILENE CITY OF
PRIMARY SOURCE: S TOTAL ENFORCEMENTS: 3 POPULATION SERVED: 106,400
ENFORCEMENT ACTIONS
ACTION RELATED VIOLATION DATA
ENF-ID DATE ACTION ID DATE TYPE CNTM
9102567
06/01/91
SFT
NO VIOLATIONS REFERENCED
IN FRDS
91E0001
07/20/91
SFJ
91V0001 06/01/91 25
3100
90E0001
05/20/90
SFJ
90V0001 04/01/90 03
3000
CURRENTLY AT PUS 39 OUT OF 44 POSSIBLE PUS'S
-> Enter your option, please: E
Effective Date: 12/31/92
Release: 2.00
Page: 5-81
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.5 Option 'Q' - Quicklook Report Generator
This section contains general information relative to the features and operation of the
FRDS-II Quicklook Report Generator (QUICK), version 5.4.
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 'A', 'E\ or 'X' functions of FRDS-II/Interactive.
The remainder of this section contains five subsections as follows:
Subsection I Characteristics Of The QUICK Report That Are Controlled By The User
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
Page: 5 - 82
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.5.1 Subsection I. Characteristics Of The QUICK Report That Are Controlled By
The User
Through prompts issued, the user can specify the following characteristics about the QUICK
report that is to be produced:
• The maximum number of characters that can be printed per line.
Permissible responses may range from 60 to 132. Most typically, one would use 80
characters per line if one intends to display the report on a terminal and 132
characters per line if the intention is to print the report on a high-speed printer.
• The maximum number of lines that can be printed per page.
Permissible responses may range from 17 to 58. Most typically, one would use 24
lines per page if the intention is to display the report on a terminal and 58 lines per
page if the intention is to print the report on a high-speed printer.
• 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 the user's personal experience and preference. It is recommended
that the user experiment with the minimum inter-column spacing until satisfied with
the effect produced by his/her choice.
Please note, however, that the actual number of spaces that will appear between
columns is affected by what is being printed in consecutive columns, and other
options that have been chosen (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 specified. Upper and lower
case letters may be entered if desired, however, most high speed printers will convert
lower case letters to upper case when the report is printed.
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 83
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• The type of column headings that are to be printed.
Four choices are available. They are:
• Data element numbers as assigned in the FRDS-II Data Base definition.
• Data element names as assigned in the FRDS-II Data Base definition.
• 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 lower case letters may be entered if
desired, however, most high speed printers will convert lower case letters to upper
case when the report is printed.
• No column headings at all.
• The location at which the QUICK report is to be produced.
Two choices are available. They are:
• The user's terminal.
• 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.
• The type of totaling that is to be performed.
Five choices are available. They are:
• Count... for each data element printed, QUICK checks each data element's
value. If it is a unique and significant value (See note below), it is counted.
• Sum ... for each data element printed QUICK checks each data element's
value. If it is a unique and quantitative value, it is summed.
• Both Count and Sum.
• User-defined by column.
Page: 5 - 84
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• 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.
• 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 the user requests printing the system name, the contaminant in violation,
and the Enforcement ID, and the PWS has two violations:
JOSEPH BROS. WTP Coliform 89-12345 (line 1)
89-54321 (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 PWS-SUMMARY data base record) as is the system name
on line 1. In other words, lines 2 and 3 are for the same PWS.
Next, note that line 3 illustrates that the contaminant in violation is identical, but that a ditto
mark is not printed. The reason for this situation is as follows:
Effective Date* 12/31/92
Release- 2 00
Page 5 - 85
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
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.
• 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 with the next page or not.
• For reports that are to be displayed at the user's terminal, whether QUICK is to
produce a general information report containing a complete description of the report
to be produced or not.
Reports that are pnnted on a high-speed printer automatically have the general
information report printed.
• The data that is to be pnnted in each column of the QUICK 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 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.
Page. 5 - 86
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC -0055-005- LN -2005
December 31, 1992
A more reasonable and accurate estimate of the maximum number of columns that can
be printed, is difficult to predict. Although 5 to 15 columns might seem reasonable to
expect, the actual number will 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 the user is 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:
• Numerous data elements' values are codes for which descriptions exist. QUICK
automatically recognizes these data elements and requests that the user specify
whether they want to print the code as it is stored in the data base, or the
descriptions which describe these codes. If code descriptions are to be printed, the
user must specify the number of characters of the descriptions to print.
• 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.
• 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 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 IV for a complete list
of data elements that are printed in an edited fashion.
• 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 were 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 will 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 will produce count
and/or sum subtotals (if totaling was requested) and begin a new page.
Effective Date 12/31/92
Release 2.00
Page. 5 - 87
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• 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.
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 which 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.
• 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.
• 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 which 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 QUICK prompts. Standard responses acceptable to other QUICK
prompts (see Subsection 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 typical prompt in QUICK
signifies that the user 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 QUICK reacts typically to a "null"
Page: 5 - 88
Release: 2.00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
user response (see Subsection II., item 5 below) compared to how it reacts here.
QUICK typically permits a "null" response in only three instances, and it 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.
5.2.5.2 Subsection EL Special Notes Relative To The Use And Operation Of QUICK
Items relative to the use and operation of QUICK version 5.4 are as follows:
• 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:
The instructions are displayed.
The user is given the opportunity to print a copy of this Quicklook documentation.
The user is given a lengthy introduction prior to the initial "Data Element:" prompt
for what to print in column number 1 as well as prior to the initial "Data Element:"
prompt for the very first data element on which the report is to be sorted. Thereafter,
an abbreviated form of this introduction is displayed.
• The opportunity to display instructions is given only once per QUICK session.
Therefore, a user who 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 Generator, the entry of a
question mark (?) or the entry of the word "HELP" causes the display of more
information about the prompt issued. The prompt to which the "?" or the word
"HELP" was entered as a response is then re-displayed.
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 89
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
• 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 new report or to return to FRDS-II /
Interactive.
There are five prompts to which the exclamation point is not a valid response. They
are:
• Would you like to continue the report definition?
• Would you like to continue the report generation?
• Would you like to print what was generated so far?
• Would you like to continue with the next page?
• Would you like to define a new 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 point causes QUICK
to verify the user's desire to cancel the print request.
• A null response (pressing the < RETURN > key as the sole response to a prompt) is
generally an unacceptable user reply to a prompt. However, it is acceptable in four
cases. They are:
• In response to the "Title:" prompt;
• In response to the "Column Heading:" prompt;
• In response to the "Data Element:" prompt when entering data elements to print,
the data element on which to paginate, or data elements on which to sort;
• 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.
Page: 5-90
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
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 with that which is being requested
remains unchanged.
• At any "Data Element:" prompt issued to the user by the QUICK Report Generator,
the entry of a pound sign (#) < RETURN > is synonymous with a "null" response as
described in the immediately preceding paragraph.
• If a report is being displayed on the terminal and the < BREAK > or < ATTN > 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.
• If a report is being generated (being output to a high-speed printer), and the
< BREAK > or < ATTN> 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.
• If a report is being sorted, it cannot be interrupted.
Effective Date: 12/31/92
Release: 2.00
Page: 5-91
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
• When a data element to be printed contains code values, the user is given the
opportunity to print the code values or their associated descriptions. If associated
descriptions are 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 was specified.
• When incompatible options are requested, QUICK decides what options are to be
used. For example:
• Both Count and Sum totaling is requested but no summable data elements are
specified to be printed ... Count only is assumed.
• When Sum totaling only is requested but no summable data elements are specified
to be printed ... No totaling is performed.
• 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.
• 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.
• QUICK will produce either a single spaced or double spaced report based upon what
the user has requested to be printed.
If any data elements from the CO data base record (STATE-SUMMARY) or the C100
data base record (PWS-SUMMARY) are being printed, and a data element or data
elements from any descendant for the C100 data base record (C300, C400, C480,
C500, C600, C700, C800, C900, C1000, CI 100, CI 180, C1200, C1280, C1350,
C2100, C3000, C3100, C4000 or C4050) are being printed also, the report will be
double spaced. Otherwise, the report is single spaced.
Page: 5 - 92
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.5.3 Subsection m. Understanding The QUICK Report
In general, there is little about a QUICK report that should not be easily understood by the
user. However, a few points are in order. They are as follows:
• 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:
• Line 1 always reads, "FRDS-II Quick Report Generator".
• Line 2 always contains the current Date (obtained from the computer) and the
page number of the report.
• Line 3 contains either the Title specified by the user or the text, "Title Not
Specified." Please note the following with 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.
- If the user specified title has multiple spaces between two words, they will be
translated into a single space.
• 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
sequence, it will appear as:
Order: Cnnnn/o Cnnnn/o ... Cnnnn/o
Where the "Cnnnn"'s will be replaced with the data element number(s) of the data
on which the report's data was sorted, and the 7o"'s will be replaced with the
order designated by the user for that data element's sort...either "/A" meaning
ascending sequence of "ID" meaning descending sequence.
Effective Date: 12/31/92
Release: 2.00
Page: 5-93
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
If the number of data elements on which the report's data was 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 will Fit on the line will be
printed.
* Line 5 contains either the data element number on which the report is being
paginated and the value of the data element being processed, or the text "For:
Pagination not requested."
• 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 will be printed.
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:
• If the data element number column heading option was chosen, data element
numbers will be printed above each column in the format "Cnnnn" with
periods on either side of the data element number to delineate the columns'
total width.
• If the data element name column heading option was chosen, data element
names (as defined for the FRDS-II data base) will be printed above each
column with periods on either side of the data element name to delineate the
column's total width.
• If the user defined column heading option was chosen, the column heading as
entered by the user will be printed above each column. Please note the
following with respect to user defined column headings:
- If the user enters leading spaces in a column heading, they will be ignored
... The user's response is left-justifred.
Page 5-94
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
- If the user's column heading has multiple spaces between two words, they
will be translated into a single space.
• Six notes are in order with reference to detail lines that may appear on a QUICK
report. They are:
• Data elements defined in the FRDS-II Data Base as character data ( X(nn) ) are
printed left-justified in a column.
• Data elements defined in the FRDS-II Data Base as numeric data ( 9(nn)) are
printed right-justified in a column.
• Both character data and numeric data may be pnnted 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).
• 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 PWS was not reported to EPA).
• 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 was to have been pnnted, but a violation did
not exist for the PWS).
• The appearance of a ditto mark in a detail line column means that the data
element's value is identical to that which appears on the previous line and that the
value is derived from the same data base record as the value on the previous line
Effective Date: 12/31/92
Release: 2.00
Page. 5 - 95
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• 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 I 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 two consecutive print lines (as defined by the maximum number of
characters per line X 2), only that number of characters that will fit on the two lines
will be printed (i.e., the excess characters will be truncated).
• Each QUICK report that is produced when 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 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 two lines are produced for a total ... two if both count and sum totaling
are in effect, one otherwise.
A total line is identified by "Cnt" for the Count Total or "Sum" for the Sum Total
appearing in the right hand margin.
• If the user chooses to print the QUICK 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:
• 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).
Page 5 - 96
Release: 2.00
Effective Date- 12/31/92
-------
FRDS-I1 INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• For data elements that have been printed, the letter that appears beneath the
headings "Cnt" and "Sum" means:
"Y" means this type of total has been produced for this data element
"N" means this type of total has not been produced for this data element
• For data elements that have been printed, used for pagination, and/or used to
order the QUICK report, the number which appears beneath the heading "Length"
means:
The number of characters of this data element's code value description that
have been printed, used in pagination, or used to order the QUICK report, or
The number of left-most characters of data elements that 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: 12/31/92
Release: 2.00
Page: 5 - 97
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC-0055 -005 -LN-2005
December 31, 1992
5.2.5.4 Subsection IV. Data Elements That Are Displayed In An Edited Fashion
• The following data elements are listed with leading zeros suppressed and commas
inserted, as needed. Example: A population served of 00001250 would be listed as
1,250.
CI 17 PWS-RETAIL-POP-SERVED
C145 PWS-METERS
C147 PWS-SERVICE-CONNECTIONS
C149 PWS-AVG-DAILY-PROD
C151 PWS--TOT-DESIGN-CAPACITY
C153 PWS-TOT-EMERGENCY-PROD
C155 PWS-TOT-STORAGE-CAPACITY
C157 PWS-MAX-DAILY-PROD
C1111 VIO-COMP-PERIOD-MONTHS
CI 127 VIO-SAMPLES-REQUIRED
C1129 VIO-S AMPLES-T AKEN
C1139 VIO-ACTUAL-DURATION-MONTHS
CI 353 NCP-WINDOW-MONTHS
CI 359 NCP-MCL-VIOLATIONS
CI 361 NCP-MCL-DURATION
CI 363 NCP-MON-VIOLATIONS
CI 365 NCP-MON-DURATION
CI 367 NCP-ENF-ACTIONS
C3029 VE-ALT-MON-FREQ
• The following data element is listed with leading zeros suppressed and commas
inserted, as needed. Example: A river reach mile of 0123.40 would be listed as
123.40
C431 PWS-SE-REACH-MILES
Page: 5 - 98
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
SDC-0055-005-LN-2005
December 31, 1992
Using the Post Retrieval Output Options Menu
• The following data elements are listed with leading zeros suppressed, as needed.
Example: An analysis result of 0001234.560000 would be listed as 1234.5670000.
C815 PWS-MILESTONE-VALUE
C1123 VIO-ANALYSIS-RESULT
C1125 VIO-MCL-VIOLATED
C2111 SAMPLE-ANALYSIS-RESULT
C3013 VE-MOD-MCL
C4007 SDD-QUANTITY.
• 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 %.
C121 PWS-PCT-SURFACE
CI 23 PWS-PCT-GROUND
C125 PWS-PCT-PUR-SURFACE
C127 PWS-PCT-PUR-GROUND
• 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.
Clll PWS-SYSTEM-BEGIN-Y YMM
CI 13 PWS-DEACT-Y YMM
C1351 NCP-WINDOW-BEG IN-Y YMM
• 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-MMDD
C161 PWS-SEASON-END-MMDD
• 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
C9
ST-ANY-DATA-LAST-UPDATE
ST-INV-L AST-UPDATE
Effective Date: 12/31/92
Release: 2.00
Page: 5 - 99
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
C13 ST-VIO-LAST-UPD ATE
C15 ST-ENF-LAST-UPDATE
C17 ST-VE-LAST-UPDATE
C29 ST-SAMPLE-LAST-UPDATE
CI 67 PWS-INV-LAST-UPDATE
C168 PWS-INSERT-DATE
CI 69 PWS-ANY-DATA-LAST-UPDATE
C703 PWS-VISIT-DATE
C803 PWS-MILESTONE-DATE
C811 PWS-MILESTONE-INSERT
C903 PWS-HIST-CHANGE-DATE
CI 107 VIO-COMP-PERIOD-BEGIN-DATE
C1109 VIO-COMP-PERIOD-END-DATE
CI 115 VIO-AWARE-DATE
C1117 VIO-INSERT-DATE
C1133 VIO-LAST-UPDATE
CI 141 VIO-RESOLVED-DATE
C1183 VIO-LINK-ENF-DATE
C1203 ENF-ACTION-DATE
CI207 ENF-LAST-UPDATE
C1213 ENF-INSERT-DATE
C1283 ENF-LINK-RANGE-BEGIN
C1285 ENF-LINK-RANGE-END
CI 287 ENF-LINK-PERIOD-BEGIN
C2103 SAMPLE-BEGIN-DATE
C2105 SAMPLE-END-DATE
C3007 VE-EFFECTIVE-DATE
C3009 VE-EXPIRATION-DATE
C3021 VE-LAST-UPDATE
C3033 VE-INSERT-DATE
C3105 VE-SCHED-DATE
C3107 VE-SCHED-ACCOMP-DATE
C4009 SDD-DATE
C4055 DBA-DATE
Page: 5 - 100
Release: 2.00 Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• The following data element is listed with dashes inserted between the water resource's
region and subregion, sub-region and accounting unit, 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-04-007.
C427 PWS-SE-RIVER-REACH-NUM
• The following data element is listed with dashes inserted between the degrees and
minutes, and minutes and seconds. Example: A PWS latitude of 384120 would be
listed as 38-41-20.
C415 PWS-SE-LATITUDE
• The following data element is listed with leading zeros suppressed, as needed, and
dashes inserted between the degrees and minutes, and minutes and seconds. Example:
A PWS longitude of 0885412 would be listed as 88-54-12.
C417 PWS-SE-LONGITUDE
• The following data element is listed with a USPS State code prefix and a dash
inserted before a 2-character data value. Example: A State of California
congressional district of 02 would be listed as CA-02.
C507 PWS-GA-CONGRESSIONAL-DIST
• The following data elements are listed with a USPS state code prefix and a dash
inserted before a 3-character data value. Example: A State of Maryland county code
of 017 would be listed as MD-017.
C508 PWS-G A-ST ATE-COUNT Y-CODE
C509 PWS-G A-FIPS-COUNTY-CODE
• The following data elements are listed with a USPS state code prefix and a dash
inserted before a 5-character data value. Example: A State of Alaska indian
reservation of 68235 would be listed as AK-68235.
C4 ST-IND-RES-CODE
C515 PWS-G A-IND-RES-CODE
Effective Date: 12/31/92
Release: 2.00
Page: 5-101
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• The following data elements are listed with a dash inserted between the fiscal year
and the ID. Example: A violation ID of 8912345 would be listed as 89-12345.
CI 101 VIO-ID
CI 181 VIO-LINK-ENF-ID
CI 201 ENF-ID
CI 281 ENF-LINK-VIO-ID
C3001 VE-ID
• The following data elements are listed with a dash inserted 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-SYSTEM-ZIP
C315 PWS-AD-ZIP
• 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 with parentheses surrounding the
area code, a blank preceding the telephone exchange, and a dash inserted between the
telephone exchange and number. Example: A telephone number of 7035561411
would be listed as (703) 556-1411.
C143 PWS-PHONE
• The following data element is listed with a "T." prefix. Example: A township of
015N would be listed as T.015N.
C419 PWS-SE-TOWNSHIP
• The following data element is listed with a "R." prefix. Example: A range of 125W
would be listed as R. 125W.
C421 PWS-SE-RANGE
Page. 5 - 102
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
• The following data element is listed with a "Sec." prefix. Example: A section of 25
would be listed as Sec.25.
C423 PWS-SE-SECTION
• 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).
C425 PWS-SE-QTR-SECTION
C426 PWS-SE-QTR-QTR-SECTION
5.2.5.5 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 and is immediately followed
by the example QUICK report.
Effective Date: 12/31/92
Release 2 00
Page 5-103
-------
FRDS-I1 INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION ON-LINE SESSION
FROS-II/Interactive
Post Retrieval Output Options Menu
(B) Batch Job Submission (L) List in Standard Screen Format
(C) Create an External File (Q) Quicktook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code which corresponds to the desired Post Retrieval
Output Option: Q
Welcome to the Quicklook Report Generator
Version: 5.4
01/03/92 04.27.43
--> Would you like instructions on the use of the Quicklook Report Generator''
(Y)es or (M)o: Y
This output processing option permits you to design a report according to your
own 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, how the report is to be ordered, and whether you want to view the
report at your terminal, or have it printed on a high-speed device. Also, note
that you may print, paginate, or sort on most any FRDS-ll data element so long
as all data elements specified belong to the same data base family.
If you do not understand any prompt issued* enter a question mark C) or the
word "HELP" to obtain more information.
If you want to stop the Report Generator, enter an exclamation point (¦) in
response to any pronpt, or press the / key to interrupt a
printing report.
Press the key when you are ready to proceed ...
--> Uould you like to print a copy of the Quicklook docunentation?
(Y)es or (N)o: N
--> Enter the maxinun nunber of characters per line: 80
--> Enter the maximm nunber of lines per page: SS
¦¦> Enter the minimum nunber of spaces to appear between columns: 2
--> What title would you like to appear on the report'
-¦> You failed to enter a title. Please confirm ... Was this your intention'
(Y)es or (N)o: Y
Page: 5-104
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION ON-LINE SESSION (CONTINUED)
--> What type of colum headings would you prefer7
Data element nunber (f¥), data element (N)ame, (U)ser-def ined by colum,
or (O)mit: V
--> Where should the report be generated?
On your (T)erminal or a High-speed (P)rinter: T
--> For each data element printed, what type of totalling would you prefer?
(C)ount, (S)uni, (B)oth (i.e., count and sum), (U)ser-defined by column,
or (N)one: U
--> Would you like a summary report only' (Y)es or (N)o: N
--> Would you prefer repeat suppression' (Y)es or (N)o: HELP
Enter a single letter which indicates your desired response to the question,
then press the key.
Enter the letter "Y" (Yes) if you want to suppress Che printing of identical
data which conies from 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.
--> Would you prefer repeat suppression' (Y)es or (M)o: Y
--> Would you like to stop at the end of each page' (Y)es or (N)o: Y
--> Would you like to display an initial information page'
(Y)es or (M)o: ?
Enter a single letter which indicates your desired response to the question,
then press the key.
Enter the letter "Y" (Yes) if you would like to display an initial page of
information which defines your report in its entirety, or the letter "N" (Ho)
if you are not interested in this feature.
--> Would you like to display an initial information page?
(Y)es or (N)o: Y
Now, please specify what data is to be printed in each colunri (from left to
right) of the report.
You may enter either a data element nutber or data element name 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.
<« Coluiri 01 »» (076 characters remain on the print line)
--> Print data element: PWS-ID
--> Totalling choice for this data element' (C)oimt or (N)one: N
--> Co limn Heading: PWS ID
«< Co limn 02 »» (065 characters remain on the print line)
--> Print data element: CI3I
--> This data element contains textual data. Would you like to print the
(L)eftmost or (A)LI of its characters: L
--> Nunber of characters (leftmost) to print: 20
--> Totalling choice for this data element? (C)ount or (N)one: N
--> Colum Heading: System Name
Effective Date: 12/31/92
Release: 2.00
Page: 5-105
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION ON-LINE SESSION (CONTINUED)
<<< Colum 03 »> (043 characters remain on the print line)
--» Print data element: CtOS
--> This data element contains code values. Uould you like to print the
(C)ode values or their associated (D)escriptions: C
--> Totalling choice for this data element? (C)ount or (N)one: N
--> Co limn Heading: Typ*
<<< Colum 04 »> (037 characters remain on the print line)
--> Print data element: C117
--> Totalling choice for this data element? (C)ount only, (S)un only,
(B)oth (i.e., count and sun), or (N)one: 5
Colum Heading: Population
«< Colum OS >>> (022 characters remain on the print line)
--> Print data element: CHOI
--> Totalling choice for this data element7 (C)ount or (N)one: N
•¦> Colum Heading: Vto ID
«< Colum 06 »> (012 characters remain on the print line)
--> Print data element: CI20I
The data element entered does not reside in the same data base family as
previously entered data elements
.<« Colum 06 >» (012 characters remain on the print line)
--> Print data element: CllSl
Insufficient space remains on the print line for totalling to be performed for
this data element ...
--> Colum Heading: Erf ID
«< Colum 07 »» (002 characters remain on the print line)
--> Print data element: 9
--> Please confirm ... Are you finished entering data elements to print?
(T)es or (N)o: Y
Your report's print definition is complete ...
--> Should the report have a new page started for each change in value of
a particular data element7 (Y)es or (N)o: N
--> Would you like your report to be sorted? (Y)es or (N)o: Y
Specify the order in which you want your report to be sorted.
This is accomplished by entering either a data element nimber 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.
Uhen you are finished specifying the desired report sequence, enter a pound
sign (#) in response to the "Sort data element:" prompt, then press the
key.
Page: 5-106
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION ON-LINE SESSION (CONTINUED)
<<< Sort # 01 >>>
--> Sort data element: PWS-SYSTEM-NAME
--> (A)scending or (D)escending order: A
<<< Sort # 02 »»
-•> Sort data element: CIOI
-•> (A)scending or (D)escending order: A
«< Sort # 03 »>
--> Sort data element: ff
¦•> Please confirm Are you finished entering data elements on which to
sort' (Y)es or (N)o: Y
Your report's sort definition is conplete ...
Your report is now being sorted ...
Please do not interrupt 'I*
Sort successfully completed ...
Press the key when you are ready to proceed ...
Effective Date: 12/31/92
Release: 2.00
Page: 5-107
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT
FRDS-II Quick Report Generator
Date: 06/11/W
Page:
1
General Information Report
Haxinun Characters/Line: 080
Maximun Lines/Page: 58
Miniirun Inter Col inn Spaces: 02
Report ID: 920611-055526
Report Title:
Title was not specified
Colum Headings: User-Defined
Surmary Report Only: No
PWSs are Ranked: No
Printing: Length Cnt. Sun
PVS-IO N N
PUS-SYSTEM-NAME 20 N N
PUS-TYPE N N
PWS-RETAIL-POP-SERVE N Y
VIO-ID N N
VIO-LINK-ENF-ID N N
Paginating on: Length
Pagination was not requested
Sorting on: Length Order
PUS-SYSTEM-NAME Ascending
PUS-ID Ascending
Symbols used within colimns:
Blank = Uhen a blank appears in a
coI urn, this implies that
the record in the data
base from which the data
is derived does not exist.
Example: You requested
that a V/E data
element be printed,
but no V/E existed for
the PUS.
* = Uhen an (*) appears in a
colunvi, this implies that
the record in the data
base from which the data
is derived exists, but the
individual data element
is not valued.
Example: You requested
that the MCL violated
be printed, but the
violation displayed is
a sampling violation.
Page: 5-108
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
FRDS-II Quick Report Generator
Date: 06/11/92 Page:
General Information Report
2
Syrobols used within coluins:
" = When an (") appears in a
column, this implies that
the value which would
normally appear is of the
same value, and is derived
from the same record in
the data base, as a prior
line's data (e.g., ditto).
Complete Locate Statement:
PUS IDs contained in the file: uuuaaaa.D920610.T182324.PWSIDS
Effective Date: 12/31/92
Release: 2.00
Page: 5-109
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
FRDS-II Quick Report Generator
Date: 06/11/92
Page:
1
Title
uas not specified
Order
: C0131/A C0101/A
Paginati
on uas not requested
.PWS ID..
System Name
Type
.Population..
.Vio ID.
.Enf ID.
TX1520224
BLUE SKY MOBILE H0HE
C
120
TX1550024
8RUCEVILLE-EDDY CITY
C
3,500
86-01034
II
II
II
it
85-04243
II
II
II
II
84-08759
II
II
II
II
83-08169
II
II
•1
It
82-12444
TX0290006
COASTAL
ACRES COOP
c
25
92-20160
II
ii
II
II
92-20161
II
it
<1
<1
86-00122
II
ti
H
II
85-00520
II
ii
II
II
85-00496
II
ii
II
II
85-00142
II
ii
II
II
84-01870
II
it
II
<1
84-01871
II
ii
II
II
84-01872
II
ii
II
II
83-01786
It
a
U
II
83-01787
II
ii
II
82-01603
II
ii
II
II
82-01604
II
ii
II
II
82-01605
II
ii
II
II
81-01272
TX0610065
CORINTH
CITY OF
C
4,200
92-10417
II
ii
II
II
92-10418
*1
ii
II
II
91-V0003
91-E0001
It
ii
II
II
91-V0002
91-E0001
II
ii
II
It
83-02889
II
ii
II
II
82-02785
II
ii
II
tl
80-03063
TX1020049
COUNTRY
VILLA MOBILE
C
54
85-01866
II
II
II
II
84-06866
II
II
II
II
84-06867
II
tl
II
II
84-06868
II
II
II
II
84-06869
II
II
II
II
84-06870
II
II
II
II
83-06389
II
II
II
II
83-06390
II
II
II
II
83-06391
II
II
II
II
82-05994
II
II
II
II
82-05995
II
II
II
II
82-05996
II
II
<1
II
82-05997
II
It
II
II
82-05998
II
II
II
II
81-05436
PWS
IDs contained in the
file:
uuuaaaa.D920610
. T182324.PUSIDS
Page: 5-110
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
FRDS-II Quick Report Generator
ite: 06/11/92 Page:
Title was not specified
Order: C0131/A C0101/A
Pagination was not requested
.PUS ID System Name Type .Population.. .Vio ID. .Enf ID.
TX1020049 COUNTRY VILLA N08ILE C 54 81-05437
» " " " 81-05438
» " " « 81-05439
u ii ii ii 81-05440
M ¦¦ ii ii 81-05441
¦' " " 11 80-06976
» " •' 11 80-06977
» " " " 80-06978
" 80-06979
u ii ii ii 80-06980
ii ii » ii 80-06981
« " " " 80-06982
TX2290007 CYPRESS CREEK WATER C 660 91-V0001 91-E0003
ii n 90-V0004 90-E0004
ii ii ii ii ii 91-E0002
ii ii ii ii 90-V0003 90-E0003
ii ii ii ii " 91-E0002
ii ii ii " 90-V0002 90-E0002
ii ii ii ii " 91-E0002
<> ¦¦ " » 90-V0001 90-E0001
¦¦ ii ii ii « 91-E0002
ii ii ii ii 89-V0003 91-E0002
« >¦ ¦' " 89-V0002 91-E0002
ii 89-V0001 91-E0002
ii ii ii ii 88-V0001 88-E0003
n •• » ii 88-02371 88-E0004
ii <• ii - 88-02372 88-E0001
ii « ii ii ii 91-E0002
ii 88-02373 88-E0002
ii » ii ¦¦ 87-03036
•• „ » ii 87-03037
« 86-00928
ii ii ii ii 85-03638
ii ii ii ii 85-03639
ii ii ¦¦ » 85-03673
•• ii ii ii 85-03515
i. » " » 85-03516
ii ii ii 85-01021
ii « ii 84-12666
ii ii ¦¦ ii 84-12667
¦i 84-12668
ii '¦ « ¦¦ 84-12669
ii » « ii 84-12670
¦I 83-11639
ii » " ¦¦ 83-11640
ii " ¦' » 83-11641
PUS IDs contained in the file: uuuaaaa.D920610.T182324.PUSIDS
Effective Date: 12/31/92
Release: 2.00
Page. 5-111
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
FRDS-1I Quick Report Generator
Date: 06/11/92
Page:
3
Title
uas not specified
Order: C0131/A C0101/A
Pagination was not requested
.PUS ID..
System Name
Type
.Population..
.Vio ID.
.Enf ID.
TX2290007
CYPRESS CREEK WATER
C
660
83-11642
W
II
II
ii
83-11643
II
M
It
•i
82-11245
It
If
II
ii
82-11246
II
II
II
ii
82-11247
II
II
II
ii
81-10199
II
tl
II
ii
80-12630
•1
II
II
ii
80-12631
tl
If
U
ii
80-12632
TX0570006
DESOTO CITY OF
c
30,150
TX0710076
FCI-LA TUNA
c
1,300
92-10485
M
If
tl
11
92-10486
II
II
II
91-V0001
91-£0001
II
II
II
II
85-00929
U
II
II
II
85-00930
tl
II
*1
II
84-03454
11
II
II
II
84-03455
II
II
II
II
82-03176
II
II
II
II
82-03177
M
•a
II
II
81-02665
II
<1
II
II
80-03583
TX0790298
FT BEND COUNTY HUD N
c
390
TX0840003
GALVESTON CITY OF
c
61,620
91-V0001
91-E0001
II
II
II
II
85-01240
TX2460001
GEORGETOWN CITY OF
c
19,344
91-V0002
91-E0003
II
II
11
41
n
91-E0004
II
II
11
II
91-V0001
91-E0001
II
II
II
II
II
91-E0003
II
II
II
II
80-13291
II
II
II
II
80-13292
TX1012361
HCO MUD NO 238
c
527
TX1010063
HCO UCID NO 91
c
2,970
89-V0001
90-E0001
ii
ii
11
II
87-01047
ii
ii
tl
M
86-00361
ii
ii
II
II
85-01314
ii
II
II
85-01315
ii
ii
II
II
84-04589
TX0700059
LAKEVIEU WATER STSTE
c
350
92-10471
ii
ii
II
II
92-10472
PUS
IDs contained in the
f i le:
uuuaaaa.0920610
T182324.PUSIDS
Page 5 - 112
Release: 2.00
Effective Date 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
FRDS-II Quick Report Generator
Oate: 06/11/92
Page:
4
Title was not specified
Order
: C0131/A C0101/A
Pagination was not requested
.PUS ID..
System Name
Type
.Population..
.Vio ID.
.Enf ID.
TX0700059
LAKEVIEU WATER SYSTE
C
350
92-10473
ii
ii
II
II
92-10474
ii
ii
II
II
86-00830
u
ii
II
II
85-00958
ii
ii
II
II
84-03399
n
n
II
II
82-03123
n
ii
II
II
81-02641
TX0790002
LATERNA VILLA SUBDIV
C
339
TX0280001
LOCKHART CITY OF
C
9,200
TX1660010
MINERVA WATER SUPPLY
c
350
91-V0003
91-E0001
ii
11
II
II
91-V0002
91-E0001
ii
II
II
II
85-02736
ii
II
II
II
84-09539
n
II
II
II
82-08493
n
II
II
II
82-08494
ii
II
II
II
82-08495
ii
II
II
II
82-08496
ii
II
II
II
81-07649
TX1260097
MOUNTAINAIRE MOBILE
c
72
86-00528
86-E0001
TX1810005
ORANGE COUNTY UCID N
c
5,919
85-03044
TX1210059
PINE TERRACE WATER S
c
60
TX0070005
POTEET CITY OF
c
3,063
89-V0001
TX0190008
REDUATER CITY OF
c
2,061
91-V0001
91-E0001
M
II
II
II
90-V0001
90-E0001
II
II
II
II
87-00169
II
II
II
II
87-00170
II
II
Ii
II
87-00171
U
II
II
II
87-00172
II
II
II
II
87-00173
II
II
II
II
87-00174
II
II
u
II
87-00175
U
II
II
II
87-00176
u
II
II
II
86-00045
u
II
u
II
86-00061
II
II
II
U
86-00029
II
II
u
II
81-00594
II
II
II
II
81-00595
II
II
II
II
81-00596
II
II
II
II
80-00861
PUS
IDs contained in the
file:
uuuaaaa.D920610
.T182324.PUS10S
Effective Date: 12/31/92
Release: 2.00
Page: 5-113
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
S DC-0055-005 - LN-2005
December 31, 1992
QUICKLOOK OPTION REPORT (CONTINUED)
Date: 06/11/92
FRDS-II Quick Report Generator
Title was not specified
Order: C0131/A C0101/A
Pagination was not requested
¦PUS ID..
System Name Type .Populati
C
TXO190008 REDWATER CITT OF
TX1012292 SOUTH FOUR M08ILE HO
II II
TX0570059 SUNNYVALE TOWN OF
TX1840080 WILLOW WOOO ADDITION
2,061
93
II
1,800
350
.Vio ID.
80-00862
Page:
.Enf ID.
91-V0001 91-E0001
89-V0001
85-03059
85-03060
PWS IDs contained in the file: uuuaaaa.D920610.T182324.PWSIDS
Date: 06/11/92
FRDS-II Quick Report Generator
Title was not specified
Order: C0131/A C0101/A
Pagination was not requested
Page:
.PUS ID System Name Type .Population.. .Vto ID. .Enf ID.
Grand Totals
148,517
Sun
Report generation successfully completed ...
-> Would you like to re-generate the report just produced7
Would you like to produce another Quicklook report? (Y)es or (N]o: N
Exiting the FRDS Quicklook Report Generator
Page: 5-114
Release: 2.00
Effective Date: 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Using the Post Retrieval Output Options Menu
SDC-0055-005-LN-2005
December 31, 1992
5.2.6 Option 'E' - End Post Retrieval
Option 'E' of the Post-retrievalOutput Options Menu permits the user to exit the
post-retrieval processing options capability and return to the prompt for a Main Menu
selection.
The following sample session shows how to use Option 'E':
OPTION E
FRDS-1 I/Interactlve
Post Retrieval Output Options Menu
(B) Batch Job Sutxmssion (L) List in Standard Screen Format
(C) Create an External File (0) Quicklook Report Generator
(F) Frequency Distribution
(E) End Post Retrieval
--> Enter the Code which corresponds to the desired Post Retrieval
Output Option: E
--» Enter Function Code, END, or MENU:
Effective Date: 12/31/92
Release: 2.00
Page: 5-115
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Appendix A Special Symbols/Keywords/Keys
SDC-0055-005-LN-2005
December 31, 1992
APPENDIX A
SPECIAL SYMBOLS/KEYWORDS/KEYS
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Appendix A Special Symbols/Keywords/Keys
SDC-0055-005-LN-2005
December 31, 1992
APPENDIX A
Special Symbols/Keywords/Keys
The following symbols, keywords and/or keys are used throughout FRDS/Interactive. They
have been summarized in Appendix A as a ready reference.
1. Special Symbols/Keywords/Keys
HELP
I
n
BREAK
ATTN
RETURN
ENTER
Display Help, if available
Display Help, if available
Stop the world ... I wanna get off
I'm done ... proceed with the next step
Interrupt what is going on ( ASCII line-by-line devices )
Interrupt what is going on ( 3270 full-screen devices )
Press after user response ( ASCII line-by-line devices)
Press after user response ( 3270 full-screen devices )
Effective Date: 12/31/92
Release: 2.00
Page A - 1
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Appendix A Special Symbols/Keywords/Keys
S DC-0055-005- LN -2005
December 31, 1992
2. Special keywords recognized at the FRDS/Interactive prompt which reads ...
Enter Function Code, END, or MENU:
END Exit FRDS/Interactive ... return to FRDSON CLIST menu
QUIT Exit FRDS/Interactive ... return to FRDSON CLIST menu
MENU Display Main Menu
END and QUIT are Synonymous with function code o (i.e., zero )
3. Special Symbols/Keywords recognized during the "Assisted" 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
execute it or submit a batch job using the constructed Locate statement.
CARET Advance to the next group ( i.e., go up ). If no further
(UPPER group exists, display the Locate statement constructed, ask if okay,
CASE 6) execute it or submit a batch job using the constructed Locate statement
SLASH Separates multiple responses to a data base value
(/) prompt ... ( e.g., CAC / CAH / NAC / NAH ). Multiple responses are
OR'ed together.
COMMA Intermediate/Advanced users only ... Separates
(,) multiple responses to a menu prompt .. ( e.g., C103 CI 15, CI 19 ) Multiple
responses are AND'ed together.
Page: A - 2 Release- 2.00 Effective Date- 12/31/92
-------
FRDS-II INTERACTIVE RETRIEVAL USER'S GUIDE
Appendix A Special Symbols /Keywords /Keys
SDC-0055-005-LN-2005
December 31, 1992
ASTERISK
C)
EQ NE
GT GE
LT LE
SPANS
EXISTS FAILS LT 500 / SPANS 1000*5000 / GT 10000
LT 500 / EQ 1000*5000 / GT 10000
LT 500 / 1000*5000 / GT 10000
Cnnnn 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.
ALL Intermediate/Advanced users only ... shortcut for indicating that the user
wants to consider ALL sub-groups displayed or ALL data elements displayed.
NONE Intermediate/Advanced users only ... shortcut for indicating that the user wants
to consider NONE of the sub-groups displayed or NONE of the data elements
displayed.
4. Special Symbols/Keywords recognized during the 'X' and 'Z' (i.e., Type your
own) Locate statement preparation Main menu function.
EXIT Leave the 'X' or 'Z' function
?? Display Locate statements presently defined. If using the 'X' function, the
number of records selected are displayed also.
Effective Date: 12/31/92 Release: 2.00 Page: A - 3
Used in conjunction with a response that is a range
(i.e., SPANS valuel * value2, EQ valuel * value2, valuel * value2 ).
May be used in conjunction with response to a data
base value prompt. For example:
£11.S GOVERNMENT PRINTING OFFICE 1993 - 718-316/61067
-------
|