I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
i
United States
Environmental Protection
Agency
Office of Information
Resources Management
Washington DC 20460
EPA/OIRM
EPA
FACILITY INDEX SYSTEM (FINDS)
USER'S GUIDE
n
laBWraao
oaooaaaaaaaal
*
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
'. \ , i A
Table of Contents
Page
1. 0 Introduction 1
1.1 Definition of a Facility 1
1. 2 Background 1
1. 3 Program Overview 3
1.3.1 FINDS ID 3
1.3.2 Facilities Contained in FINDS 3
2. 0 System Overview 6
2.1 System Description 6
2. 2 System Operation 7
2.2.1 Data Input 7
2.2.1.1 Automatic entry of Facility
Data 7
2.2.2 Data Retrievals 10
2.2.3 Data Base Administrator Functions 10
3 . 0 System Access 14
3 .1 Equipment Needed 14
3 .2 General Operating Procedures 14
3.2.1 Logging On 14
3.2.2 Logging Off 15
3.2.3 PFKEYS 16
3.2.4 Batch Submission 17
4, 0 Menus, Screens and Reports 18
4.1 Reports and Data Extracts 19
4.1.0 Reports and Data Extracts Menu 19
4.1.1 Selected Facilities List 20
4.1.2 Data Extracts 22
4. 2 Online Queries 23
4.2.0 Query Menu 23
4.2.0.1 Detailed Facility Info Menu 24
4.2.1 Search Finds Database 25
4.2.1.1 Facility Name Search 26
4.2.2 Single Facility Display 27
4.2.2.1 Source Program Office Information 27
4.2.3 Search D & B File 28
4.2.4 D & B Facility Display 29
4.2.5 Display D & B Parent 29
4.2.6 Subsidiary Selection List 30
4.2.7 Search FFIS File 31
5. 0 Production Considerations 32
5.1 Efficiency 32
cu 5.2 Security 33
22 5.3 Error Recovery 33
" 6.0 Error Messages fOOSUARTEIK IfBRARY ' ' ' 34
- ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON, D.C. 20460
-------
II
II
II
II
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
APPENDICES
A, File Descriptions Page
FINDS-FACILITY A-l
FINDS-SOURCE-TABLE A-2
FINDS-STATE-TABLE A-3
FINDS-COUNTY-TABLE A-4
STATE-USER-BLOCK-TABLE A-5
FINDS-USER-ID-TABLE A-6
B. Table Listings/Codes
Region Codes/States Chart B-l
State Table B-2
County Table B-3
Source-Program Table B-4
Other Codes B-5
Owner Type Codes B-5
Operator Type Codes B-5
Lat-Long Source Codes B-5
Lat-Long Accuracy Codes B-5
C. Report Formats
Selected Facilities C-l
Statistical / Management Report C-2
FIGURES
Figure 2. l(a) System Structure Chart - Main Menu 8
Figure 2. Kb) System Structure Chart - Data Entry 9
Figure 2.1(c) System Structure Chart - Reports/Extracts., 11
Figure 2.1(d) System Structure Chart - Online Queries.... 12
Figure 2.1(e) System Structure Chart - ADBA Functions.... 13
Figure 5. 1 Scheduling/Priority Table 32
TABLES
Table l.O(a) Distribution of FINDS Facilities by
by Program Office 4
Table l.O(b) Distribution of Facilities vs.
Number of Regulating Program Offices.... 5
-------
II
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1.0 Introduction
1.1 Definition of a Facility.
The Facility Index System (FINDS) is a central and common
inventory of facilities monitored or regulated by the EPA, with
cross-references to the program office data bases that have
additional programmatic information about the facility.
FINDS has adopted and modified the following facility definition
from the National Bureau of Standards, Federal Information
Processing System (FIPS):
"FACILITY: A locational entity, deliberately
established as a site for designated activities,
but not primarily for habitation (even though on-
site habitation may be necessary to the execution
of the primary activities); for example, a college,
factory, hospital, military base, national park,
office building, or prison."
Since the definition of a facility varies from EPA program to
program, the term facility is used in this document. Among EPA
programs, the regulated unit may be a smokestack (Clean Air Act),
a building or plant (NPDES), or a property (RCRA).
FINDS maintains the programmatic definition by showing the source
of the FINDS record, and pointers to the records in the
programmatic data base associated with the FINDS record.
1.2 Background
FINDS evolved from a Region II system which provided the region
with the names, addresses, locations (including latitude/
longitude) and regulating EPA programs for facilities in that
region. The Region II system was the basis for a mapping system
which displayed these facilities in relation to population
centers, fish and wildlife refuges, etc., as well as the medium
at risk from the site or facility.
In 1982, the Region II concept was adopted by the EPA
Headquarters for application to sites and facilities nationwide.
Orginally part of the Office of Solid Waste's Hazardous Waste
Data Management System (HWDMS), FINDS was used primarily for the
assignment of EPA ID's to facilities. It still serves this
purpose today.
-------
I
II
-------
In 1984, FINDS was separated from HWDMS and implemented as a
stand-alone system in ADABAS. This system operated until April
of 1988 when an enhanced version eliminated many data elements
which were not used, reduced the number of files from 5 to 2, and
implemented new online data entry and data base search programs.
These enhancements and improvements were documented in the "FINDS
System Enhancement Analysis Document", which was distributed for
review and comment to headquarters, regions, and interested
parties.
An attribute of the enhanced version of FINDS is the capability
for access and use by any authorized person. User support and
access questions can be directed to the Program Systems Division
(PM-218B) at 382-2416. Dan Cirelli of the Program Systems
Division is responsible for operation and management of the
FINDS.
-------
-------
1.3 Program Overview
To understand FINDS it is important to look at the two major
functions of the system:
o Assignment of EPA ID'S to regulated facilities, and
o Providing a unifying view of regulated facilities.
These functions are both centered around using a unique
identifier while allowing for the condition of a facility being
regulated and/or tracked by more than one program.
1.3.1 FINDS ID
The FINDS ID is composed of the following information:
o State Code (e.g., CA)
o Type of Number (e.g., Dun and Bradstreet Number,
GSA number, or a dummy number)
Dun and Bradstreet Numbers (DUNS Numbers) are used when there is
knowledge of the institution responsible for the facility, or the
General Services Administration (GSA) number is used when the
facility is a Federal Facility. Where neither of these
conditions apply, a "dummy DUNS" number is assigned.
Of the 262,736 records in FINDS:
o 152,523 have DUNS Numbers,
o 5,278 have GSA Numbers, and
o 104,935 have dummy DUNS numbers
1.3.2 Facilities Contained in FINDS
FINDS maintains information on facilities regulated by Program
Offices as manifested in their data systems. FINDS currently
maintains pointers to Program Office data systems. These
pointers have been updated infrequently; therefore users should
be aware of the possibility for less than current information.
Table 1.0(a) shows the distribution of FINDS facilities by
Program Office and the year of the last update. In the future,
FINDS will be updated at a pace consistent with Program Office
update cycles.
FINDS can maintain pointers to multiple Program Offices
regulating a single facility. Table 1.0(b) shows the
distribution of facilities versus number of Program Offices
having regulatory authority and responsibilities.
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
II
II
II
II
-------
TABLE L.O (a)
DISTRIBUTION OF FINDS FACILITIES BY PROGRAM OFFICE
Program
Office
Data
System
Number
Records
Yr. Last
Update
OSW HWDMS 170,719 1988
OWEP PCS 17,744 1983
OA CDS 48,916 1988
OPTS FATES 36,265 1984
OERR CERCLIS 28,821 1988
OLEC DOCKET 9,211 1988
OW FURS 6,590 1983
OFA FFI3 2,826 1988
OTS CICIS 6,991 1983
STATES * Various 11,559 1988
339,783 **
* Certain Regions enter State-regulated facilities into FINDS,
** Some facilites are regulated by two or more Program Offices,
There are actually 262,736 facility records in FINDS @ 3/88
-------
-------
TABLE l.O(b)
DISTRIBUTION OF FACILITIES VS. NUMBER OF REGULATING
PROGRAM OFFICES
Number of
Program Offices
Number of
Facilities
1
2
3
4
5
6
7
8
9
10
219,250
26,698
7,707
3,473
1,824
1,062
650
418
271
729
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
2.0 System Overview
2.1 System Description
FINDS is written in the NATURAL programming language to operate
on an ADABAS data base containing locational information on
facilities regulated by the EPA. It also contains pointers
(references) to Agency data bases and Program Offices having
regulatory responsibilities over each facility. Currently, there
are approximately 260,000 facility records in the FINDS data
base.
Each record contains a unique identification number ("EPA-ID")
assigned by FINDS Data Analysts located at Regional Offices.
These numbers are of three types depending on the type of
facility:
1. Industrial, contained in the Dun and Bradstreet "DUNS
Universal Numbering System" (DUNS) file,
2. Industrial, not contained in the DUNS file (dummy DUNS),
3. Federal facilities contained in the Office of Federal
Activities Federal Facilities Information System (FFIS).
The format for EPA-ID numbers is
where
ss
x
ddddddddd
ssxddddddddd
state code
D for DUNS or dummy DUNS numbers or
0-9 for GSA number
9-digit DUNS, dummy DUNS or GSA
number.
Dummy DUNS numbers are further characterized by "98" in position
4 and 5 of the EPA-ID number.
Certain Program Office data bases do not contain EPA-ID numbers.
Linkage between FINDS and these data bases is provided by the
"SOURCE" and "SOURCE-ID" fields in FINDS which are entered by
Regional data analysts. SOURCE refers to the Program Office
operating the data base (see p. 4 of Appendix B.) SOURCE-ID is a
number used internally by the Program Office to designate the
facility. (The format of SOURCE-ID numbers varies; no attempt
was made to characterize the number within FINDS.) These two
fields have been combined to form a Superdescriptor ("SOURCE-
SOURCE-ID") in FINDS to increase retrieval efficiency within
FINDS.
-------
-------
2.2 System Operation (see Fig. 2.1(a))
2.2.1 Data Input (Fig. 2.1(b))
There are two methods for input of data into FINDS:
a. Through requests by Program Offices personnel to the Regional
Data Analysts for EPA-ID numbers for new facilities.
In this case, the analyst researches the data base to determine
that the facility has not been entered into FINDS by another
Program Office. If FINDS contains a record for the facility, the
SOURCE and SOURCE-ID of the new regulating office are entered
into the record. If the facility is not contained in FINDS, an
EPA-ID number is assigned and the facility record is entered into
FINDS. In both cases, the EPA-ID number is reported to the
requesting Program office.
b. Through batch input of facility data received through the
"Program Office Reconciliation Process" or from State Offices.
Periodically, the FINDS Data Base Administrator will exercise a
module in FINDS which compares facility data in FINDS with
equivalent data in the Program Office data base. Facilities not
contained in FINDS are identified, assigned EPA-ID numbers if
necessary and entered into FINDS.
Certain State environmental offices maintain FINDS-like data
bases on STATE computers linked to the EPA communications
network. Perdiodically, this data is retrieved by FINDS for
batch input into the system.
2.2.1.1 Automatic Entry of Facility Data
With one exception, data entry into FINDS is done automatically
from the on-line DUNS or FFIS data bases. Linkage between FINDS
and these data bases are through a STATE-NAME-ZIPCODE key entered
via a FINDS screen by the analyst. The screens used for data
input are similar to the screen shown of pages 18-19 of the Users
Guide. (See also pp 29-34 of the Data Entry Manual.) By
comparing addresses of the input record with the alphabetical
list generated by the search parameters, the analyst can select
the proper record from the DUNS or FFIS file for automatic entry
into FINDS.
The exception is assignment of a User Block Number to a facility.
In this case the full name, address and other data is manually
entered by the FINDS analyst.
Data input is performed solely by Regional Data Analysts and by
the FINDS Data Base Administrator.
-------
-------
(0
§ •
± a
U. £
^ O
X £ o
S 2 *
" > »
« w 2
IL
>» (0
O
a
u.
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
w
Q *-
S S
U. £
~ O
X £ «
(8
tT i «
**• -. **
O
(0
u.
-------
-------
2.2.2 Data Retrievals (Fig. 2.1(c) and2.1(d))
Retrievals from FINDS are of two types: Reports/Data Extracts
and On-line. Each type is generated from user responses to
screen queries from FINDS.
Reports/Extracts are batch reports on multiple facilities having
a common characteristic, such as State, County, Zipcode, etc.
These reports/extracts are routed to the user's printer using a
FINDS screen which asks for Userid and other parameters required
by the RTF facilities. Alternately, this data can be stored as a
file for downloading to Personal Computers, Logical Mainframes or
other devices in the EPA communications network.
On-line retrievals display individual facility information from
the FINDS, DUNS or FFIS data bases. In addition, corporate
relationships contained in the DUNS file can be tracked and
displayed.
Any registered user of the EPA computer facilities at Research
Triangle Park, NC can access and utilize FINDS. Permission of
the Data Base Administrator or of NCC is not required.
2.2.3 Data Base Administrator Functions (Fig. 2.1(e))
This module is restricted for use solely by the FINDS DBA.
He/she will invoke the various programs when necessary to
accomplish the functions shown in Fig. 2.1(e). In addition,
he/she will batch update the entire FINDS file with State and
other batch input data (this function is in the design stage at
this time).
10
-------
-------
ui<12 iT
-------
-------
§~
Z «
d o
*•" U (0
C O •
c k_ t™
" §5
c
c c
« O
= to
'o
(8
IL
-------
I
-------
OT
Q **
C £ M
X ~ O C
• E • °
T 5 5 ?
«• ?, « §
• 51 = £
3 X S <
ID O CD
il "2 £ Q
(0
u.
-------
-------
3.0 Systen Access
The system operates on the EPA Mainframe computer, the IBM 3090,
and uses the ADABAS DataBase Management System with its NATURAL
programming language.
3.1 Equipment Needed
In order to access the system, the user will need one of the
following types of equipment:
o IBM 3270 or equivalent terminal
connected to the EPA Network
Display Terminals or PCs with modems to
dial in to the EPA Network
3.2 General Operating Procedures
3.2.1 Logging On
1.
2.
3.
4.
5.
6.
At the System Introduction Screen, Enter
'M' for menu.
At the EPA Telecommunications Network
Menu, Enter PCICS.
Type your USER-ID, Account, FIMAS-ID,
Group, Password and press .
At the NEWS Release menu, press PF3, A
blank screen will appear.
Type 'NSSP' and press .
At the Application screen, type
'FINDPROD' for APPLICATION-ID. The
FINDS Main Menu will be displayed where
you can continue using the system as
described in section 4.0.
14
-------
-------
3.2.2 Logging Off
1.
3.
Return to the FINDS MAIN MENU.
Press 'PF4' OR 'PF16'
A blank screen will appear.
Type 'CSSF LOGOFF' and press
The system will return to the
Introduction screen.
-------
-------
3.2.3 PFKEYS
A set of Program Function Keys (PF Keys) have been designed
into the system to make it easy to go from one menu or screen to
another. The PF Keys and the Key are listed and their
use is described here.
PF1/13 = HELP
This will bring up a help screen for the screen being
processed; Returns to the screen being processed when
PF3/15 is pressed.
PF3/15 = PREVIOUS SCREEN
This will return to the previous screen/menu, without
updating or adding the record.
PF4/16 = MAIN MENU
This will return to the FINDS Main Menu, without updating
or adding the record.
PF5/17 = RESTART LIST
This will restart a list which is being displayed.
PF8/20 = NEXT PAGE
This will give the user the capability to browse forward
within a file to find a record to be selected. (No
add/updating of data).
KEY (Data Entry Screens)
This will add or update the present record displayed/-
Brings up the next logical screen for entry or update of
more data.
KEY (Selection Screens)
This will copy or display the selected record; Transfers
to data entry or display screen as applicable.
16
-------
'IS3D
~ . i . t
PPQTECT:ON -GENC>
INDEX SY
SIN -
lESTINATICN -
PRIORI"1"!
TIME -
'•'EMU
' a » MAIN
-------
3.2.4 Batch Submission (FIZ100M)
Scheduling of batch programs is controlled by a batch
submissions function which is invoked whenever selections are
made for reports or extracts. The screen on the opposite page
is displayed and allows the user to enter parameters as shown.
OPERATING PROCEDURES
1. Enter your ACCOUNT.
2. Enter the REMOTE printer number or laser node number
prefixed by the letter 'N' e.g. RMT255 or N7.
3. Enter the BIN (Box) Number assigned to you.
4. Change the TIME and PRIORITY parameters which appear on
the screen if desired.
5. Press .
Your job will be submitted. The system will return to the
previous menu or screen and the job number will be displayed in
the upper left hand corner in the format "JOB###### xxx
SUBMITTED" where xxx is your USER-ID.
It is recommended that batch jobs be run during off-peak
hours (before 7 AM, EST or after 6 PM, EST). See Figure 5.1 for
scheduling/priority.
17
-------
NSSO
FINDCEVL
Fif*>x>p
1 PF1/13 - HELP
U.S. ENVIRCNhCNTfll. PROTECTION AGENCY :>•».•:««, 68 I
FACILITY INDEX SY3-EM 1-3 -39 57
MAIN fCNU Flr*X«OM
1 . REPORTS *ND DrtTA E
PF4X16 " EXIT 1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
-------
4.0
Menus, Screens and Reports (Screen, FIMOOOM)
FINDS is a menu-driven, on-line and batch system. Section 4
gives instructions on how to get the displays, and generate the
reports and extracts needed. The menu shown on the opposite page
is the initial menu the user will view upon entering FINDS. From
here, the user may select one of four functions shown on the
screen.
OPERATING INSTRUCTIONS
1. Enter a number between 1 and 4 to obtain one of the
following:
Selection 1
Selection 2
Selection 3
Selection 4
Reports and Data Extracts Menu
Online Queries Menu
Data Entry Menu
System Manager Functions
2. Press .
EDITS
1. Selection must be a number between 1 and 4.
2. For selection 3, the user must be authorized for data
entry
3. For selection 4, the user must be the System Manager or
his authorized representative.
18
-------
-<£';(.'
i
i
i
i
i
i
i
i
i
i
i
i
i
i
i
i
i
i
i
-------
4.1 Reports and Data Extracts
4.1.0 Reports and Data Extracts Menu {Screen FIROOOM)
This menu allows the user to select a general report screen or
the extract menu.
OPERATING INSTRUCTIONS
1. Enter 1 for the Selected Facilities Report Screen
(FIQ100M).
2. Enter 2 for the Data Extracts Menu.
EDITS
1. Selection must be either 1 or 2.
19
-------
".•53D
•J.3. ENVIRONMENTAL. .:
:=:~~:- =FECI- :••£ i= '-'CPE :- --E -i—: :•
IP =L-.c
-------
4.1.1
Selected Facilities List Report (Screen FIR100M)
This function is used to generate printed lists of
facilities. The selection criteria, sort sequence and report
format are specified by the user.
OPERATING INSTRUCTIONS
1. Enter the SELECTION CRITERIA. All selection criteria are
optional but at least one must be entered. Selection
criteria can be any combination of:
a. REGION
b. STATE
C. COUNTY
d. FEDERAL FACILITIES ONLY
e. PROGRAM OFFICES
Indicate whether report will include only facilities
monitored by all of the selected program offices or
report is to include facilities monitored by anv of
the selected program offices. (See Example under
EDITS 9.)
2. Press .
The system will display the second screen for this
function, screen FIR100M2.
3. Select a REPORT FORMAT by entering a number between 1 and
4.
The 4 report formats and samples of each are shown
in APPENDIX C.
4. Enter the number of the data item which is to be used
as the MAJOR SORT item on the report.
5. Enter the number of the data item which is to be used
as the SECOND SORT item on the report.
6. Enter the number of the data item which is to be used
as the THIRD SORT item on the report.
7. Press .
The system will display the batch options screen (FIZ100M
(See section 3.2.4 for a description of this screen).
6. The system will submit a batch job to generate the report.
20
-------
iMSSD
F ; NDDEVL
- JRlOOP
U.S. ENVIRON* EXTOL PROTECTION &GENCY
FBCILITY INDEX SYSTEM
5ELE';TED FACILITIES LIST
1 1 ijj! :s
FtHK'C:*
SELECTION CRITERIO (SPECIFY
OR MORE OF THE FOLLOWING):
AND
AND
-<-,Ll
i.sD
SEi-i
-OB-
*E3H3N : ..
CCUNTY NOME ;
-"ELEROL FACILITY : . (V jR &LONK )
REGULBTED fir - '. . ZFFICE 0= SOLID UOSTE
i. -STEB ENFORCEMENT OND PERMITS
J. O[R OND SAO I -T I ON
-. BEST 1C IS/ES » ran 1C SU&STONCE3
t. SUPESF'jND
r. -.^F HP.O COMPLIANCE 1QNITORINO
*. CHINKING -iflTES
•>. C iEI"(!--_3 . \. COWCRCE
3. i r-*E -JC-;«-n OFFICES
ONO STATE : .
/ COUNTY CQDEs
(OSU) : . <
(OWEP)
(OCR)
IOPTS)
L»>NK i
frLHNK )
&LMNK 1
BLMNK )
E.LMMH ,
frLMNKI
BLONK >
EILOMV
& _«IMK s
BLANK i
BLONK 1
PF 1 / 1 2
HELP
BF3/1S - PREVIOUS MENU
PFW1& - MAIN MENU
NSSD
F1NDDEV/L
U.S. EMVIRONMENTRl. PROTECTION flQENCY
FACILITY INDEX SYSTEM
SELECTED FOC1LITIES LIST
11 :23:3S|
REPORT FORMATS -
1. LIST OF FACILITIES (ONE LINE PER FACILITY)
£. ««TRIX SHOWING PHOGRftn OFFICES THflT MONITOR EPCM
3. nOTRK OF FOCILITY IDS OSSIQNED BY PROGRAM OFFICES FOR EftCH FACILITY
*. DETAILED INFORMATiaN (FOUR LINES PER FOCILTY)
SELECT ONE OF THE ABOVE REPORT FORMATS (J-*> I .
SORT SEQUENCES IOPT10KMI.} -
1. REGION Z. STATE 3. COUNTY
&. EP« ID 7. FACILITY NAME
*. CITY
. ZIP CODE
SELECT A MAJOR SORT SEQUENCE (1-7) i
SELECT A SECOND SORT SEQUENCE :
SELECT A THIRD SORT SEQUENCE ti-7) i
PF1/13 - HELP
PF3/19 - PREVIOUS MENU
Pf»/lfe - flAIN PIENU
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
EDITS
1. REGION, if entered, must be a number between 1 and 10
(Left or right justified).
2. STATE , if entered, must be a valid 2 character state
abbreviation.
3. COUNTY NAME, if entered, must exist on the County Table.
4. COUNTY CODE, if entered, must be a valid county code
for the STATE.
5. PROGRAM OFFICE - Must be ' y' or blank.
6. FEDERAL FACILITIES ONLY - Must be 'y' or blank.
7. FORMAT - must be a number between 1 and 4.
8. SORT CRITERIA - Must be a number between 1 and 5.
9. If program offices are selected, one of the two options,
facilities monitored by ALL of the selected program offices
or facilities monitored by ANY of the selected program
offices must be selected. Example: If 'Office of Solid
Waste' and ^Superfund' are selected with the ALL option,
then a facility must be monitored by both OSW and OERR to
apper on the report. However, if OSW and OERR are selected
with the ANY optionf the resulting report will contain
facilities monitored by either OSW or OERR.
Note that a facility on a report may be monitored by other
program offices in addition to the ones indicated in the
selection. If in the above example, the ANY option is
chosen for a MATRIX format, the additional program offices
will be *X'd along with either of the selected program
offices. This may appear to be confusing unless you keep in
mind the basic rules.
If no program offices are selected, then facilities will
appear on the report regardless of which office monitors
them. This is equivalen to selecting all program offices
with the ANY option and will cause the program to run more
efficiently.
21
-------
NSSO
FIN3DEVL
FI9433P
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY INDEX SYSTE1
DATA EXTRACTS lES'J
• 2/24/>)g
28:34:46
SELECTION CRITERIA {SPECIFY Ottt OR MORE OF THE FOLLOWING):
REGION : ..
STATE
PROGRAM OFFICE
(91 - 14 WHERE,
91
93
94
95
97
•a
11
14
SOLID WASTE (OStf)
WATER ENF AND PERMITS (OHCP)
AIR AND RADIATION (OAR)
PESTICIDES t TOXIC SUBST (OPTS)
S'JPERFUNO (OER3)
EMF ASO CONPL "IONITORIN3 (OEC«)
DRINKING HATER (ODM)
TOXIC SUBSTANCES INVESTOR* OTS)
STATE PROGRAM OFFICES )
PF1/13 • HELP
PF3/15 • PREVIOUS NENJ
PF4/16 • MAIN MENU
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
4.1.2 Data Extracts (Screen FIR400M)
This function is provided to allow selected portions of the
FINDS database to be extracted to a sequential disk file. Users of
this function can then copy the sequential file to diskette or
tape for transfer to their own computers.
Available extract types are by: REGION, STATE, PROGRAM OFFICE.
Sequential File Names are based on type of extract as follow
For Region: xxxyyyy.FINDS.EXTREzz
where xxx = User ID of person signed onto system
= Account Code for FINDS system
zz = Region Number of selected region
For State : xxxyyyy.FINDS.EXTSTzz
where xxx = User ID of person signed onto system
yyyy = Account Code for FINDS system
zz = State Abbreviation of selected state
For Program Office:
xxxyyyy.FINDS.EXTPOzz
where xxx = User ID of person signed onto system
yyyy = Account Code for FINDS system
zz = Program Office Number of selected
program office
See APPENDIX A6 for the standard format of this file.
OPERATING INSTRUCTIONS
1. Enter any combination of
STATE
REGION
PROGRAM OFFICE
2. Upon pressing , a batch options screen (FIZ100M)
will be displayed. (See section 3.2.4 for a description of
this screen).
EDITS
1. STATE - If entered, must be a valid 2 character state
abbreviation.
2. REGION - If entered, must be a number between 1 and 10.
3. PROGRAM OFFICE - If entered, must be a valid program
office.
22
-------
:,E=:E=
-CF jFr::r,3
••io.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Jl
-------
4.2 Online Queries
4.2.0
Query Menu
This Menu provides the capability of accessing any of the
Query functions available with FINDS.
OPERATING INSTRUCTIONS {Query Menu Screen, FIQOOOM)
1. Enter desired selection number.
2. Upon pressing the Key, one of several types of
screen will be displayed as follows •-
Option 1 - the FINDS search criterion screen.
Option 2 - an additional query selection screen
(FIQOOOM2) allowing entry of EPA-ID or
selection of SOURCE - SOURCE-ID.
Option 3 -- the D & B search criterion screen.
Option 4 - D & B company display.
Option 5 - D & B parent company display.
Option 6 - D & B subsidiary display.
Option 7 - the FFIS search criterion screen.
EDITS
1
Selection must be a number between 1 and 7.
2. Option 2 requires an EPA-ID number or a SOURCE and
SOURCE-ID.
3. Options 4, 5 and 6 require a DUNS Number, i.e. the last 9
digits of the EPA-ID number.
23
-------
MSSO U.S. ENVIRONMENTAL PROTECTION AGESCY •2/24/lt
PISDDSVL FACILITY INDEX SYSTEM 1»:SZ:4«
PIO.IHP DETAILED FACILITY INFORJ1ATIOK MENU ri3l»Jl2
ESTER EPA ID OK PROGRAM OFFICE AND PROGRAM OFFICE FACILITY-ID
EPA ID :
PROGRAM OFFICE CODE t ..
PROGRAM OFFICE FACILITY ID I
VALID PROGRAM OFFICE CODES ARC:
•1 • OS* (SOLID WASTE) IS OCRR (SUPERFUNDI
• 2 • OHEP (MATER EMF fc PERMITS) •! OECN (EMF i COHPL NONITORINS)
• ) • OAR (AIR fc RADIATION) II ODH (DRIMKINC HATER)
•4 • OPTS (PESTICIDES t TOXIC SOU 13 OTS (TOXIC SUISTANCES !MVE«TO*Y)
14 STATE PROCRAH OFFICES
PT1/1J • PltEVIOUS MENU PF4/1I • MAIM KENU
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
4.2.0.1 Detailed Facility Information Menu (Screen FIQOOOM2)
This Menu allows for the entry of EPA-ID or Program Office
and Program Office Facility ID for the Single Facility Display.
OPERATING INSTRUCTIONS
1. Enter the EPA-ID or
PROGRAM OFFICE AND PROGRAM OFFICE FACILITY ID.
2. Upon pressing the Key, the Single Facility Display
screen (FIQ200M) will be displayed.
EDITS
1. EPA-ID must exist on the FINDS database.
2. PROGRAM OFFICE and PROGRAM OFFICE ID must exist on the
FINDS database.
-------
;T«RTIMG PC-1 NT ~IR HM p-cPHABE':: -_:5T OF
PIC* THE 3E<«CH '0
ZIP CODE .....
PF1.--13 = HELP PF3/1S •» PREVIOUS SCREEN PF4/16 - MAIN r-eNU
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
4.2.1
Search FINDS Database (Screen FIQ100M1)
This screen is provided for the user to enter a state and
optional name, or zip code criteria for an alphabetic listing of
current FINDS facilities satisfying the entered criteria.
OPERATING INSTRUCTIONS
1. Enter a STATE.
2. Enter a FACILITY NAME at which to start the alphabetic
search. If no name is entered, the facility list will
start at the first facility in the state.
2
3
EDITS
1
Optionally enter the Zip Code.
Upon pressing , a facility listing screen (FIQ100M2)
will be displayed listing up to 12 facilities satisfying
your entered criteria.
STATE is required.
abbreviation.
Must be a valid 2 character state
25
-------
r
NSSO UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
FINODEVL FACILITY INDEX SYSTEM
FIQ108P FACILITY NAME SEARCH
SEARCHING FROM 'OW
• FACILITY NAME • • ADDRESS * • C I T Y •
1. OWENS ILLINOIS INC 2220 91ST ST N BERGEN
2. OWENS ILLINOIS INC BRI SORTH LAUREL ST BRIDGETON
3. OWENS-CORNING FIBERGLA SHREVE AVE t FIB BARRINGTON
4. OWENS-ILLINOIS INC CRYSTAL t FOWLER VIHELAND
S. PASSAIC VALLEY SEWER AC 600 WILSON AVENU NEWARK
6. PEARSAC.L CHEMICAL OIVI RIVER ROAD PHILLIPSBURG
7. PERTH AMBOY, CITY OF 260 HIGH ST PERTH AMBOY
1. PRICE LF DOWDY AND DELILA PLEAS ANTVILLE
9. PUBLIC SERV ELEC i GAS 3S0 RARITAN PARK EDISON (TOWNSHI
10. R i H TRUCKING CO INC 184 DOREMUS AVE NEWARK
11. RANDOLPH PRODUCTS COMP PARK PLACE EAST CARLSTAOT
12. REGINA CO DIV 313 RECINA AVE RAHWAY
SELECT FOR DETAIL SCREEN: ..
PF3/1S • PREVIOUS MENU PF4/16 • IAIN MENU ENTER • ACCEPT
L
•ST«
NJ
NJ
NJ
NJ
NJ
NJ
NJ
NJ
NJ
NJ
NJ
NJ
1
02/24/88
29:39:53
FKJUJ12
• EPA-IO *
NJD09L3S407S
NJD0023420S3
NJD002J- ?»15
NJDV923-I20B7
NJD06S818969
NJD0S6£028fl8
NJD0B1983884
NJD070281175
NJD039879994
NJD007B7S628
NJD002033846
NJ0038474870
INPUT/SCROLL FWO
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
4.2.1.1 Facility Name Search (Screen FIQ100M2)
OPERATING INSTRUCTIONS
1. SELECT FOR DETAIL SCREEN - To view 2 screens of detailed
information for a particular listed facility, enter the
line number associated with the facility here.
If is pressed without selecting a single facility
the list of facilities satisfying your entered criteria
will continue where it left off.
EDITS
1. Selection for detailed screen must be between 1 and 12.
26
-------
sficn U.S. ENVIROr*CNTAL PROTECTION MXK : O* 'Oo. 96
1"'1"' "»s^ FyW~ Ti T^"V TNM^,* 5^STE**1 **^ **^* ^ ^
:=- :c NUMBER ^.T 5
JSSv., ~™:' * iJSiTi}'-'^
LATITi-DE »:«•? -_Ar-._.TN& iCaJP-E
^«-.« •>»««> ^T^.>C— u«*.,
INDIAN 4-*ND -I =-EDEP-L rJC.L. •
:=M*.,TS
PC-, ,5 . PREVIOUS ^C P»-.-o - -WIN «*J
v ^
f -\
rjs=D u.s. ENVIRO*CNT«. PROTECTION acercv :••», oa- ss
-INDDEVL FACILITY INDEX SYSTEM :•« 47 0?
PICiv'P SCl.**CE PSCCRf*' CFFICE IfJFCWMoTION -ICiI-!'!^
-F_lrE ...jnrp,^ ;(STEt, PliC,. .,,.,-, CED B, c=JJp.-E -BKPrf- = '--E-'S
!'.€P :jt»T£P E'^iPEPMI1" FCe
:€;!•* E-^iCOMFL KMITft DCCl- £T
j:^ ^l.!!^ ;;=;s
:•-; ;.>F-CE :'!pr...,t 51,1
P*"5 •• » P»£v IOLS SCPEEM "** 's • MAIN ^-E'.'.
N-- >
1
1
|
1
1
|
1
•
|
•
!
1
1
1
1
1
1
1
1
.
II
ll
-------
4.2.2 Single Facility Display (Screen FIQ200M)
This function contains 2 screens detailing location, source
information and comments for a facility selected either through
the QUERY MENU or the SEARCH FINDS LIST.
OPERATING INSTRUCTIONS
1. Press to view the second screen (FIQ200M2).
EDITS
None.
4.2.2.1 Source Program Office Information (Screen FIQ200M2)
This screen displays program office information for the
facility selected for single facility display.
OPERATING INSTRUCTIONS
1. Press to return to the Facility Name Search
screen (FIQ100M2).
EDITS
None.
27
-------
:02OOP
FACILITY INDEX SYSTEM
SEARCH DUN i BRADS ~*
POINT FOR on ALPHABETIC SEwRCH OF F-:lLI*IE5
STATE
NAME
RESTRICT THE SEARCH TO
ZIP CODE
V,
PFl/13 - HELP PF3/13 • PREVIOUS MENU PF4/16 • MAIN MENU
NS5D
FIMDDEM.
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY INDEX SYSTEM
DUN 4 BRADSTREET NAME
BEGINNING WITH •
•>».
68
* FACILITi iskWC • • ADDRESS -
01 A o s INCORPORATED 2119 E SOUTH BLVD
O2 AARON OIL CO INC 226-D HUY 43
03 ABC HOLDINGS INC DC STATE DOCKS ROAD
CM ADHESIVES SALES 4 C BEARDEN RD
OS AGRI FLAVORS INC EAST LAKE RO
06 AIR PRODUCTS 4 CHEW IPSCO ST NU
07 AIR PRODUCTS 4 CHCH 20O RIVER RO
> O8 AIR PRODUCTS 4 CHEW 6 OFFICE PAX CIR
09 AIR PRODUCTS 4 CHEH HUY 202 UEST
1O AIR PRODUCTS AND CH 11O2 BLACKSHEAR
11 AIR PRODUCTS AND CH VAN HOOSEN RO
12 AIR PRODUCTS AND CH f 0 ALABAJ-IA RIVER
SELECT FOR DETAIL SCREEN ..
PFV13 • PREVIOUS MENU
k
- CITY
MONTGOMERY
SAF^AND
EUFAULA
PCLHAM
CUNTERSVILLE
DECATUR
MUSCLE SHOAL
BIRMINGHAM
ANNISTON
OOTHAN
FV.QHATON
CLAI BORNE
••
PF4/1* • MAIN
•ST.
AL
AU
M.
AL
AL
AL
AL
AL
AL
AL
AL
AL
MENU
-ZIP-
361 t&
36571
36027
35124
35976
3S6O2
35661
35223
36202
36302
36441
36434
•DUNS NBR.
947t61641
1 -»8->85327
1 53S92B1 I
055*02183
O94479664
05O985332,
004295697
O41023O29
112643978
021254198
004267696
1 321 OO496
A
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
4.2.3
Search D & B FILE (Screen, FIQ300M1)
This function is used by the data entry personnel to obtain
the D & B portion of the EPA-ID and by anyone wanting to browse
D & B data. It provides two screens, one for entering
search criteria and one for displaying the list of records
retrieved as a result of the search.
OPERATING INSTRUCTIONS
1. Enter a STATE.
2. Enter NAME. If not entered, search will start with first
facility for the state.
3. Optionally enter the ZIP CODE.
4. Upon pressing , a facility listing screen
(FIQ300M2) will be displayed listing up to 12 facilities
satisfying your entered criteria.
5. Press to continue the alphabetic facility list.
EDITS
1. STATE is required. Must be a valid 2 character state
abbreviation.
4.2.3.1 D & B Search List (Screen FIQ300M2)
OPERATING INSTRUCTIONS
1. SELECT FOR DETAIL SCREEN - For a closer look at a
facility, enter the line number here.
2. Press or PFKEY as shown below.
Note: If enter is pressed without selecting a single
facility, the list of facilities satisfying your
entered criteria will continue where it left off.
EDITS
1. Selection must be a number between 1 and 12. May be left
or right justified.
28
-------
MSSO
FINDDEVL
0.«. tWVtHOWWTAt MDTCCT1MI ACWCY
FACltlTTf INDEX SYSTEM
OUN i BRAOSTREET FILE SEARCH
92/25/11
18:17:37
STARTING POINT FOR AM ALPHABETIC SEARCH OF FACILITIES!
STATE t Bj
NAME : o«*».
RESTRICT THE SEARCH TO:
IIP CODE : .....
NSSO U.I. ENVIRONMENTAL PROTECTION AGENCY
FINDoeVL FACILITY INDEX SYSTEM
FIQjajP QUH t BRAOSTRtCT FILE SEARCH PACE 1
1
92/2S/38
I*: 17:37
FI3399»2
BEGINNING WITH 'OWE
*
• 1
• 2
>3
• 4
• 5
1C
IT
98
39
19
11
12
FACILITY NAME •
OWENS CORKING FIBER
OXFORD LABOR ATOftUS
OXIOENTAL ELECTROCH
P t K FLAVORS INC
P F C SALRS
P F LABORATORIES 11
P L C ENTERPRISES I
P L C ENTERPRISES 1
P L C ENTERPRISES*
P L C SPECIALTIES I
PMC INC
P « C SPECIALTIES G
• ADDRESS •
NEWARK TPKE
«• «9TH ST
BERRY AVENUE AT R
t»-D ENGLCHAROT A
1102 JtFPERSOU ST
790 UN I OH 3LVQ
«9«-719 GOTHAM PA
699 GOTHAM PA-tKb^
12J PATERSOU PLAS
29-lfl -UPLE AVENU
2 CAMPUS DRIVE
INUUSTRIAL WAY
• CITY •
KBARNY
GUTTCN«E*f:
CARLSTADT
AVENEL
HOOOKEN
TOTOWA
CARLSTADT
CARLSTAOT
CARLSTAOT
FAIR LAMM
SOMERSET
FORD 3
*5f
NJ
NJ
NJ
NJ
NJ
NJ
HJ
>1J
SJ
SJ
NJ
NJ
•ZIP*
97932
97993
97972
97991
07933
97512
37J72
J7372
J7J72
37413
33873
J3361
*OUNS NBR*
98S6«93S9
3751S9649
I9291J219
1«16S69»6
J44«1363S
1932S9725
1222941I>2
IS135?12'>
J851945I6
••41994716
JVMiJHl
14732352%
SELECT FOR DETAIL SCREEN: ..
k.
prs/u •
PREVIOUS ttlMU
PF4/1C - MAIN
MENU
t
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
4.2.4 D & B Facility Display (Screen FIQ600M)
This function displays a single company (or parent company)
from the D & B Database.
OPERATING INSTRUCTIONS
1. DISPLAY SUBSIDIARIES - To see a list of subsidiaries
for this facility, enter 'y' here.
2. DISPLAY PARENT - To see the parent facility of the
currently displayed facility/ enter 'y' here,
EDITS
1. Entry must be 'Y' or blank.
4.2.5 Display D & B Parent (Screen FIQ600M)
This function displays parent company information for the
facility whose DUNS Number is entered from the Query Menu or
which is being displayed in a single display function.
OPERATING INSTRUCTIONS (See section 4.2.4)
29
-------
1 NSSD U.S. ENV I RONMENTOL PROTECTION AGENCY Oa/O*/3S
1 PINDDEVL FACILITY INDEX SYSTEM llltfl:JS
i FIQ600B DUN i EIAAOSTREET DOCILITY OISPLOV FIO&CKHI
FQCILJTY NOME ORCO QLOSKO INC L*UNS MUMPER 1 OOIO32»3O
FQCILITY ODDRESS MILE 1* l/^ NORTH RD
KENOI flK 33611
MAILING ADDRESS 1410
Pti«l
NO.
-:N<
3iC
s:3
ENT COMPftMY PARENT DUNS: O*3*tf67i3
; OP BUSINESS OIL DRILLING
CODES ;38I : : : : :
'Liar SUBSIDIARIES <*> : P DISPLfiV PORENTtv.; .
PPl/:^ » HELP PP3/15 = CREVIOUS SCREEN PF*/16 " MOIN MENU
II
1
1
1
1
1
1
I
1
1
1
1
1
1
1
1
1
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
4.2.6
Subsidiary Selection List (Screen FIQ620M)
This function lists the subsidiaries from the D & B database
for the facility given. From this screen, a specific subsidiary
can be selected for detail display.
OPERATING INSTRUCTIONS
1. SELECT FOR DETAIL SCREEN - To get a detailed display of
subsidiary facility, enter the line number of the
facility here.
2. Press to list additional subsidiaries, or get the
D&B facility display if there are no more subsidiaries.
EDITS
1. Selection must be a number between 1 and 12.
30
-------
. 3 ENVIRONMENT.*.
"' '
•SEAPCH
-.*:: .:-:ES
e-:;-.>jM'
FCF AN
RESTRICT T>« S£*«CH TO
ZIP CODE
pFa/,3 . P»«VIOUS MENU PF4/16 - MAIN
r
' tSSiC1 U.S. ENVlRCf^CNTi^L. BOQ
Fi:iODEv/L FACILITY INDE".
~IC4'X-P FECCRAL Fi»ClLlTIE5
BEGINNING WITH
1 ftNNISTQN *ffM> DEPOT
SDSAB OEL EMD
ANNISTQN
2 COUBEPT STEAM PLANT
US ROUTE 72
PRIDE
3 LONG BEACH CSMS
3500 STEARNS STREET
LONG BEACH
A NATIONAL 9UARD ARMORY
P 0 BOX 2^6 At. HIGHWAY NQ. 66
COU.INSVILLE
5 NATIONAL GUARD AHWRY
67O MAIN STUEfcl
DORA
PF-3/1S • PREVIOUS SCREEN
TEC-ION AGENCY
5 ;~EM
N^ E SEt«CH PAGE 1
AGENCi -',38
AL 362oi ;>»e
AGENCY 6-»00
Ai.
AGENCY 2(13
AL »0922
AGENCY 2119
AL 33941 4296
AGENCY 2' 18
AL 33062 1080
,
PT4/16 • MAIN MENU
> '.-».-9e
* 5 «rv 29
F:>"v*i2
os^« ;->i2-
G5»« <>M73
GS<»* 123*4
CSA* i 2343
CSA« \ 2333
A
-------
4.2.7
Search Federal Facilities Database (Screen FIQ400M1)
This function is used by the data entry personnel to obtain
the GSA Number portion of the EPA-ID. It provides two types of
screens, one for entering search criteria and one for displaying
the list of records retrieved as a result of the search.
OPERATING INSTRUCTIONS
1. Enter a STATE.
2. Enter Facility NAME. If no name is entered, search will be
with the first facility for the state.
3. Optionally enter the ZIP CODE.
3. Upon pressing , a facility listing screen (FIQ400M2)
will be displayed listing up to 12 facilities satisfying
your entered criteria.
EDITS
1. STATE is required. Must be a valid 2 character state
abbreviation.
4.2.7.1 Federal Facilities Search List (FIQ400M2)
OPERATING INSTRUCTIONS
1. Press to continue the alphabetic facilities list
EDITS
NONE.
31
-------
-------
5.0 PRODUCTION CONSIDERATIONS
5.1 Efficiency
FINDS has a large user community. The user community includes
the FINDS data entry staff in each of the regions, program office
staff in each region and program office staff at EPA headquarters.
Although any given user may only use the system occasionally, the
total load on the system is significant, due to the number of
users.
With that in mind, it is recommended that batch jobs be run
during off-peak hours (before 7 AM, EST or after 6 PM, EST).
The following table is copied from the NCC Users Guide,
Section 3.3.2. It is included to give you some idea of how to
assign priorities for your batch jobs.
JOB SCHEDULING/PRIORITY TABLE
Service Timed
ASAP
Better than 3
Better than 2
90% of all jobs
done in 30
minutes
90% of all jobs
done in 60
minutes
90% of all jobs
done in 4 hours
overnight
See specific
priority above
No goal established
for WYLBUR; see
Section 3.4.1 for
TSO goals.
Figure 5.1
Consult the NCC IBM Users guide, section 3.3.2, 'Job
Scheduling JES2' for further information on scheduling priority
versus costs.
Priortv
5
4
3
2 (default)
Class I
Class II
Class III
1 (all
classes
Weekends
WYLBUR/TSO
Cost Multiplier
6.0 times normal
2.0 times normal
1.5 times normal
1.0 times normal
1.0 times normal
1.0 times normal
.8 times normal
.5 times normal
2.5 time normal
32
-------
-------
5.2 Security
All persons requiring access to the mainframe computer must
be registered under RACF, the mainframe system security facility,
and receive a user ID and password. Authorization on the old
FINDS system automatically qualifies users for the same type of
access on the new FINDS. In order to use the System, users must
also be authorized for NATURAL access.
Update access will be restricted to the FINDS Regional data
entry staff. Special functions such as data extracts and
archival will be restricted to the FINDS ADBA (System Manager).
Other than that, FINDS will be available to anyone for
information retrieval as it is a public database.
5.3 Error Recovery
FINDS is set up with sufficient backup procedures to provide
users with as few interruptions as possible in case of system
failure. However, if the system does go down, data updates will
likely be affected to the extent that some restoration and
re-entry will be necessary. For this reason, it is mandatory
that the System Manager be notified whenever there is a system
failure and that updates be suspended until data entry personnel
are given the go-ahead by the System Manager.
Minor errors which occur during regular data entry are
discussed in the next section.
33
-------
-------
6.0 ERROR MESSAGES
These errors are meant to be self-explanatory. If there is
a question about the meaning, first consult the help screen for
the function being executed. If there are still questions, contact
the FINDS System Manager at:
(202) 382-2416.
Daniel Cirelli
FINDS System Manager, PM218B
Office of Information Resources Management
US Environmental Protection Agency
401 M Street SW
Washington, D.C. 20460
"SINCE" DATE REQUIRED, PLEASE ENTER **"
REGION IS REQUIRED, PLEASE ENTER **"
AT LEAST ONE SELECTION CRITERION REQUIRED, PLEASE ENTER **"
STATE IS REQUIRED, PLEASE ENTER **"
NAME IS REQUIRED, PLEASE ENTER **"
SELECTIONS 1, 2 AND 3 REQUIRE AN EPA-ID **"
SELECTION REQUIRES AN EPA-ID OR SOURCE-ID **"
SELECTION REQUIRES A DUNS NUMBER **"
SOURCE NAME REQUIRED, PLEASE ENTER **"
USER ACCOUNT REQUIRED, PLEASE ENTER **"
COUNTY NAME REQUIRED, PLEASE ENTER **"
INVALID SELECTION, PLEASE ENTER _ THROUGH _ **"
INVALID KEY, PLEASE USE PF_/ , ... or ENTER **"
INVALID ENTRY, PLEASE ENTER "Y" OR LEAVE BLANK **"
INVALID STATE FOR SELECTED REGION **"
INVALID COUNTY CODE, PLEASE RE-ENTER **"
INVALID STATE, PLEASE RE-ENTER OR CONTACT SYSTEM MANAGER **"
INVALID ENTRY, PLEASE ENTER "D", "S", OR "P" **"
INVALID SOURCE ID, PLEASE RE-ENTER **"
INVALID SOURCE CODE, PLEASE RE-ENTER **"
INVALID USER-ID, PLEASE RE-ENTER **"
YEAR MUST BE GREATER THAN 81 **"
DAY MUST BE (01) THROUGH (31), AND VALID FOR MONTH **"
MONTH MUST BE (01) THROUGH (12), PLEASE RE-ENTER **"
PROGRAM OFFICE MUST BE A NUMBER BETWEEN 1 AND 14 **'"
DUNS NUMBER XXXXXXXXX NOT ON FILE **"
NO SUBSIDIARY FOR DUNS NUMBER XXXXXXXXX ON FILE **"
PARENT RECORD NOT ON FILE **"
USER NOT AUTHORIZED FOR THIS REGION **"
END OF RECORDS SATISFYING YOUR REQUEST **"
THIS FUNCTION NOT YET AVAILABLE **"
CHOOSE ONE SELECTION ONLY PLEASE **"
NO DATA FOR ENTERED INPUT, PLEASE RESELECT **"
PLEASE RE-ENTER (1) THROUGH (12) **" ALARM
35. "** FEATURE ONLY VALID IF ENTERED THRU d.e. SCREEN **"
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
"**
" * *
«« **
"**
«**
« **
« **
« **
" **
" **
« **
»**
»**
»**
"**
"**
«**
"**
"**
•• **
« **
»**
"**
«**
»**
«**
" **
" **
» **
"**
»**
» * *
» * *
»**
34
-------
-------
36. "** INVALID SELECT, PLEASE ENTER 'D', 'S' OR 'P' **"
37. "** INVALID DUNS NUMBER **"
38. "** NO FACILITIES FOUND, SATISFYING YOUR REQUEST **"
39. "** INVALID REGION, PLEASE RE-ENTER **"
40. "** INVALID COUNTY NAME FOR SELECTED STATE **"
41. "** COUNTY NAME AND COUNTY CODE DO NOT MATCH, RE-ENTER **"
42. "** EPA-ID NOT ON THE DATABASE **"
35
-------
-------
APPENDIX A
FILE DESCRIPTIONS
-------
-------
10>S9*56 "CONCEPTUAL PREDICT*
- DISPLAY FZLZ AND ELEMENTARY FZELDS -
SEAICH-C1IT. t FILE-FZXDS-FACZLIIY , TYPE-ALL. DBZ»«A11, OHKE1-ALL, KEY«ALL
FILE...>
TYPE...«
FILE-MR'
KEYS...:
FZNDS-FAC1LZTY
USER VIEW
138
ADDED: $7-12-2'
MODIFIED'
ADABAS ATTBZBUTXS
PRIMARY SEQUENCE F1£LD« IPA-ID
CIPHERED >
ADAH-FILE >
SECURITY LEVEL ACCESS.*
SECURITY LEVEL UPDATE.*
M (Y,N)
N tZ.K)
T L SB MAKE
LING S 9E VE
REMARK
1 AA
1 AX
1 AY
1 A2
1 AR
1 AD
1 AE
1 AF
1 AG
1 AH
1 AZ
1 AC
1 AJ
P 1 BB
2 AV
2 AU
AL
AH
AN
AO
AP
AS
BX
n AT
n AU
AZ
DA
DB
1 SA
1 SB
1 SC
EPA-ZD
UPDATE-DATE
DFDATE-USEU9
OUNE1-TYFE
OPERATOR-TYPE
FACZLZTY-NAHE
STREET-ADDRESS 1
STREET-ADDRESS!
CZTY
STATE
ZZP-CODE
REGION
COUXTY-CODE
SOUKCE-ZMFO&nATZON
SOURCE
SOURCE-ZD
COXGRESSIOMAL-DISTRZCT
1AT-LOMG-SOURCE
1AT-LOKG-ACCU1ACY
LATITUDE
LONGITUDE
INDIAN-LAND
FEDERAL-FACILITY-IND
SZC-CODES
COMMENTS
ARCHIVE
DUNS-NUNBER
TRZNET-ZD
REGIOK-STATE-MAHE
.LONG-LAT
SOURCE-SOURCE-ZD
12.0 F DE
6.0 F DE
3.0 F
1.0 F
1.0 F
30.0
30.0
30.0 X
25.0
2.0 F
9.0
2.0 F
3.0 F
2.0 N
13.0 N
2.0 N
2.0 N
1.0 N 1
6.0 N
7.0 N
1.0 N
1.0 N DE
-------
-------
13:37:40 'CONCEPTUAL PREDICT* 87-12-1
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT.:FILE-FINDS-SOURCE-TABLE,TYPE=ALL,DBID=ALL,OWNER=ALL,KEY=ALL
FILE...: FINDS-SOURCE-TABLE ADDED: 87-12-1
TYPE...: USER VIEW
FILE-NR: 8238
KEYS...: ,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED :
ADAM-FILE :
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
TY L DB NAME
(Y,N)
(Y,N)
LENG S D
MODIFIED:
REMARK
1 AV SOURCE
1 CC ABBREV
1 CD DESCRIPTION
1 CE ATTRIBUTE
A 2.0 N D
A 10.0 N
A 30.0 D
A 10.0 N
A-2
-------
-------
13:37:39 'CONCEPTUAL PREDICT* 87-12-U
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT.:FILE=FINDS-STATE-TABLE,TYPE=ALL,DBID=ALL,OWNER=ALL,KEY=ALL
FILE...: FINDS-STATE-TABLE ADDED: 87-12-1:
TYPE...: USER VIEW MODIFIED:
FILE-NR: 8238
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIEL::
CIPHERED : N (Y,N)
ADAM-FILE : N (Y,N)
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
TY L DB NAME
LENG S D
REMARK
1 AH STATE
1 CC ABBREV
1 CD DESCRIPTION
1 CE ATTRIBUTE
A 2.0 N D
A 10.0 N
A 30.0 D
A 10 . 0 N
A-3
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
15:36:22 *CONCEPTUAL PREDICT* 87-
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT.:FILE=FINDS-COUNTY-TABLE,TYPE=ALL,DBID=ALL,OWNER=ALL,KEY=ALL
FILE...: FINDS-COUNTY-TABLE ADDED: 87-
TYPE...: USER VIEd MODIFIED:
FILE-NR: 8238
KEio» * » I 9999999
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED : N (Y,N)
ADAM-FILE : N (Y,N)
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
TY L DB NAME
LENG S D
REMARK
1 CI STATE-COUNTY-CODE
1 CC ABBREV
1 CD DESCRIPTION
1 CE ATTRIBUTE
A 5. 0 N D
A 10.0 N
A 30.0 D
A 10.0 N
A-
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
13:37:41 *CONCEPTUAL PREDICT* 87-12-1
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-GRIT.:FILE=FINDS-USER-BLOCK-TABLE,TYPE=ALL,OBID=ALL,OWNER*ALL,KEY=ALL
FILE...: FINDS-USER-BLOCK-TABLE ADDED: 87-12-1
TYPE...: USER VIEW
FILE-NR: 8238
KEYS...: ,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED :
ADAM-FILE :
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
TY L DB NAME
N (Y,N)
N (Y,N)
MODIFIED:
LENG S D
REMARK
1 CF STATE-USER-BLOCK
1 CC ABBREV
1 CD DESCRIPTION
1 CE ATTRIBUTE
A 2. 0 N D
A 10.0 N
A 30.0 D
A 10.0 N
A-O
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
13.37:43 'CONCEPTUAL PREDICT* 87-12-
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT.:FILE=FINDS-USER-ID-TABLE,TYPE=ALL,DBID=ALL,OWNER=ALL,KEY=ALL
FILE...: FINDS-USER-ID-TABLE ADDED: 87-12-
TYPE...: USER VIEW MODIFIED:
FILE-NR: 8238
KEYS...: ,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED : N (Y,N)
ADAM-FILE : N (Y,N)
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
TY L DB NAME
F LENG S D
REMARK
1 CH USER-ID
1 CC ABBREV
1 CD DESCRIPTION
1 CE ATTRIBUTE
A
A
A
A
2.0 N D
10.0 N
30.0 D
10.0 N
A-6
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
EXTRACT FILE(S) FORMAT
All extract files will be sorted by EPA-ID and have the
following record format:
FIELD NAME TYPE LENGTH POSITION
EPA ID A/N 12 001-012
UPDATE DATE A/N 6 013-018
UPDATE USERID A/N 3 019-021
OWNER TYPE A/N 1 022-022
OPERATOR TYPE A/N 1 023-023
FACILITY NAME A/N 30 024-053
STREET ADDRESS A/N 60 054-113
CITY A/N 25 114-138
STATE A/N 2 139-140
ZIP CODE A/N 9 141-149
REGION A/N 2 150-151
COUNTY CODE A/N 3 152-154
SOURCE ID (1) through A/N 13 per
SOURCE ID (14) * SOURCE 155-336
CONGRESSIONAL DISTRICT A/N 2 337-338
LATITUDE/LONGITUDE SOURCE A/N 2 339-340
LATITUDE/LONGITUDE ACCURACY A/N 1 341-341
LATITUDE A/N 6 342-347
LONGITUDE A/N 7 348-354
INDIAN LAND INDICATOR A/N 1 355-355
FEDERAL FACILITY INDICATOR A/N 1 356-356
SIC CODES (1) A/N 4 per
SIC CODE (6) CODE 380-380
COMMENTS (first 30 characters) A/N 381-410
* Positional according to SOURCE, i.e. SOURCE ID (1) is for
SOURCE = 01. Only one SOURCE ID per SOURCE even if more t
one ID is on file for the SOURCE.
A-7
-------
I
I
I
I
-------
APPENDIX B
TABLE LISTINGS/CODES
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
REGION CODES / STATES
01
CT MA
ME
NH
RI
VT
02
NJ
NY
PR
VI
03
DC WV
DE
MO
PA
VA
04
AL NC
FL SC
GA TN
KY MS
05
IL WI
IN
MI
MN
OH
06
AR
LA
NM
OK
TX
07
IA
KS
MO
NE
oa
CO UIY
MT
NO
SO
UT
AO
AS
AZ
CA
CM
09
GU WQ
HI
MO
NV
TI
10
AK
ID
OR
WA
B-l
-------
-------
1
I NJSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 04/06/5
FINDDEVL FACILITY INDEX SYSTEM Io:l6:*
IPIA418P STATE TABLE DISPLAY PIA41Sr
_ —
1
1
1
1
•
1
1
1
1
I
1
1
1
STATE
Ah
AL
AR
AS
A2
CA
CO
CT
DC
DE
FL
GA
GU
HI
IA
ID
IL
IN
KS
KY
LA
MA
MD
ME
Ml
MN
MO
MO
MS
MT
NC
ND
NE
NH
NJ
NM
NV
NY
OH
OK
OR
PA
PR
RI
5C
REGION
10
04
Qt>
09
0°
0v
OS
01
03
03
04
04
09
e«?
07
10
05
05
07
04
06
01
03
01
O5
05
07
09
04
08
04
08
07
01
02
06
09
02
05
06
10
03
02
01
04
STATE NAME
ALASKA
ALABAMA
ARKANSAS
AMERICAN SAMOA
ARIZONA
CALIFORNIA
COLORADO
CONNECTICUT
DISTRICT OF COLUMBIA
DELAWARE
FLORIDA
GEORGIA
GUAM
HAWAII
IOWA
IDAHO
ILLINOIS
INDIANA
KANSAS
KENTUCKY
LOUISIANA
MASSACHUSSETS
MARYLAND
MAINE
MICHIGAN
MINNESOTA
MISSOURI
MIDWAY ISLAND
MISSISSIPPI
MONTANA
NORTH CAROLINA
NORTH DAKOTA
NEBRASKA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEVADA
NEW YORK
OHIO
OKLAHOMA
OREGON
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
a- 2
-------
-------
STATE RESIGN STATE NAME
SD
TN
TT
TX
UT
VA
VI
VT
WA
WI
wo
wv
WY
OB
0-
•39
0*
oa
03
Q.J
01
10
.JC
0=-'
Q3
OS
SOUTH DAKOTA
TENNESSEE
TRUST TERRITORY
TEXAS
UTAH
VIRGINIA
VIRGIN ISLANDS
VERMONT
WASHINGTON
WISCONSIN
WAKE ISLAND
WEST VIRGINIA
WYOMING
B-3
-------
-------
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
NSSD U.S. ENVIRONMENTAL PRO
FINDDEVL FACILITY INDEX
FIA438P SOURCE PROGRAM TAB
SOURCE PROGRAM OFFICE NAME
01 OFFICE OF SOLID WASTE
02 WATER ENF 4« PERMITS
03 AIR AND RADIATION
04 PESTICIDES A. TOXIC SUBS
05 SUPERFUND
07 ENF & COMPL MONITORING
08 DRINKING WATER
09 FED'L UND'GR INJECT CNT'I
10 SURFACE IMPOUNDMENT
13 TOXIC SUBST INVENTORY
14 STATE PROGRAM OFFICES
PF3/15 = PREVIOUS MENU PF4/1 6 = MAIN
B-4
iTECTION AGENCY
SYSTEM
LE DISPLAY
DATA
(OSW)
COWEP)
(OPTS)
(OERR)
•:OECM>
L COW)
-------
-------
OWNER TYPE
C - COUNTY
D - DISTRICT
F - FEDERAL
M - MUNICIPAL
P - PRIVATE
S - STATE
0 - OTHER
U - UNKNOWN
OPERATOR T,P£ CODES
F - FEDERALLY OPERATED
P - PRIVATELY OPERATED
L - LEASED AND OPERATED BY FEDERAL GOVERNMENT
C - OPERATED BY A PRIVATE CONTRACTOR TO THE FEDERAL GOVERNMENT
U - FEDERALLY OPERATED BUT PRIVATELY CONSTRUCTED FOR THEIR USE
LAT-LONG SOURCE CODES
A - RESEARCHED REGIONALLY
B - FROM GEOSRAPHS
Q - UNKNOWN
1 THRU 12 - SOURCE FROM UHICH THE LAT-LONG INFORMATION WAS OBTAINED
LAT-LONG ACCURACY CODES
0 - UNKNOWN
ft - WITHIN 1/33 OF A MILE
B - WITHIN 1/16 OF" A MILE
C - WITHIN 1/8 OF A MILE
D - WITHIN 1/4 OF A MILE
E - WITHIN 1/2 OF A MILE
P - WITHIN 3/4 OP A MILE
Q - WITHIN 1 MILE
H - WITHIN 1 1/3 MILE
\ " ur^IS ? 2!LES
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
APPENDIX C
REPORT FORMATS
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SELECTED FACILITIES REPORT FORMATS
Four formats are available with the Selected Facilities
Report: LIST, MATRIX, ID-MATRIX and DETAIL REPORT. The two matrix
formats are meant to depict the relationship between Program
Offices and Facilities on the FINDS database. The LIST and
DETAIL REPORT show general Facility data.
Each format is described here.
FORMAT CONTENTS
Includes EPA-ID, FACILITY-NAME and
ADDRESS, displaying an "x" to
indicate that a facility is being
monitored by a particular program.
Includes EPA-ID, FACILITY-NAME and
ADDRESS, displaying one SOURCE-ID
per program that is monitoring a
facility.
Includes: EPA-ID, FACILITY NAME, and
ADDRESS, LATITUDE, LONGITUDE.
-------
-------
£
*" i
o
N
a
UJ UJ
35
CL O
Z
a
^
«
^
e
P^
o
>• o
uj in in
< in Q i_>
Q M It
SS u.
»-« UJ U.
It u. U O
U 5 E
CL >- uj ac
in u E
< x 5 »•
t- iu O e
z D in
iu Z
S M E S
K J- 3 3
It It IU
> -j i- or
S
^ CL Q
irt u. uj u.
u DE
< x
M o:
s i
s
K
DC
UI
(SI
ac
M
>t
(M
UJ
a
t* n
*fl " UJ
UJ t/l 1—
h- O ««
< tk »-
u. u. in
*>
i>j
o
e
o
o
0
tt
in
0
•• in w
in B u
a 3 M
u u. u
fA
o
UJ
1
B
a
i
o~
0
H to
ui a
(j o 5
a. o x
s5
in
•• it
in -j
r u ••
S ™ 2
x u m
k, m
•< -T
a o
1*1
B o>
in «
Z U
o
.J
z
•** UJ UJ
M C E
<" Z OC Z
ry iu uj uj
0 3 t- 3
0 X Z X
ul8l
..
>4 (A
a in
1 UJ DC
« C 0
a. « a
t* ii
m •• uj
siH
u. u. in
in
•^
Lfl
O
a
a
•O
in
0
.. m
.. in «
U tk U
j?V
0
0
W
is
o P*
o e
0
U t- CO
Ut O
o e S
Sax
x^
in
•• it
in -J
x u in
o*
o
i- in
-J vt
e. o
B «
IU U
?
CL
^
in
o
o «
-»• B UI
•• i— >
— Z «
o 5 x
e iu CD it
3S55
.,
in
o in
i iu at
? 5 a
o» < o
UJ 2.. «ft
»l ..
in •• uj
225
o
PJ
^
a
o
e
0
PO
in
o
•• in
•• en «
2«y
U u. U
fs.
e
o
UJ
" S
in i
e o>
0 0
0
o i- to
UJ Q
ill
X
trt
•« M
C "•*
x u m
r— — •
3 IA
2 s
B *
UJ U
3
EL
>.
< o
* s
»j a
•o -i Z
in o a
ssi
o x in «
aj *
O IU Cfi IU
U CL * UJ
in
a m
Pt «• UI
1 UJ Qc
« E 0
SlzS
>* ••
« •» uj
rS5
< ac t-
u. u, in
i_l
e
e
o
in
0
a
a
•o
u>
e
•• in «
m B u
85 M
u. U
ft*
e
o
IU
e o
0
U h- ffi
ui S
tesK
s«
• • M
Q K <
Z UJ M
X U «l
§ •*•
< eg
a J
S <
T U
ZUJ
si
'So
5£"S
in ut in M
0 S > <
o x uj at
a ik
O IU O
5 S S «
u a. — in
,,
in
a in
i 1C o
a. « Q
uj Z <
** •»
in •• u
iu m i-
i— a <
< nc K
u. u. in
^
a
o
o
o
0
-o
o
in
0
•• J) w
in a U
0 3 rt
U u. U
pn.
e
o
UJ
0 O>
0 0
o
u 4- co
tfi *
K§K
g
tn
a B «
3 iu *t
x u in
nj
^
t- IA
-J <
a. u
.5
ul O
2 B
£ o
V IU
* a
-O CO •<
£=>£
— -s 3 >•
O £ UJ
0 O
52 S a
< 10 M Q
U S. - t
.,
- o-
UJ
A CJ
it
^
M >•
B
in H-
«QoS
S5*S
* -J X It
cv -J O
•0 it Z u.
0 1 < O
o in B
0 Z >-
^ JiU O >••
< X e M
u Q eg u
ii m
a in
It •• UJ
< E O
B. * O
u Z •<
•i ••
in •• iu
w in K-
>- o •«
< ac i—
u. u.
1- 0>
Z ac
UJ ^* ^
u u u
in in
UJ UJ
IU UJ
— In In
f» in in
o u u C
e M ••
« « < p
UB.fi. £
•* tf)
a en
»-« •• u
i uj ac
£58
IM Z <
>. .t
tfl •' UJ
uj m ^
»- a <
< a (-
U. Ii. Ui
^
In u
m u a S
o u. a £
0 It 0 <
U o. — a.
.,
.. m
a in
It •• UJ
i w ac
* c a
a < a
i — -j u
i *n- u
i muujn
i UU
l CJ k»pm i
1 -HJU.il
1 XUJIkll
i OlOn
i l-Z »
i itCIl
1 •« -OOil
i OTBOH
1 uJUJtttl
i "l«ii
1 tfl K-lt
t a. u*»— H
* Q^i/)n
t it
I O
i in UN
i h^O4 M
E U_U.l/lll
i tl
i ** 3T EI
E 2— wti
' OOE>El
( ^UJZH
j O ffljE
i dcZtflM
i SMII
> Oti-HXti
* McrOn
i -O M
11 M^_ H
it CM 11
it az ti
t UJQ3.1I
E a.£uii
i UJE)
1 Q. M
I z 5-^ «
I UJ El
1 ^
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
<0
M V.
o
., 4,
ij ^
^ ^
Q. Q
5
QC
«n "
5 3-
z a ••
u. a: in
O ~ i. u*
< in u
O M IM u.
« U.1X 0
1— — O
U »- E
UI ju M <
O I- O U
QL - K
in M X
— ^
< X 1-1 m
1— UJ I— O
Z P <
Ul Z U "
s >- § 2
K I— S IB
MM UJ
> J X QC
UJ U X K
* >— O
in u. M u»
v-
« t-
i- «
in c
a.
Q UJ
UJ K
§1-1
a
C
a.
o
to.
ex
£
(X
(ft >» 4( |- UJ
[J fr-4 O w 4ft
x x u »- a a
(ft »* «t
u. a a in
u, 3 a tn
o o u * ui i-
u uj ac u -J »-< m
U. < ^- UJ v>
u a (ft
a. u (ft
xx o r (ft
in
in
a
s
£
<
z
2
a
X
X
X
2
o
CM
U
a
2
o
S2
5"
2
fc1
K
Q
1»
Z
o
M
I/I
-J
K
A
Z
o
-<
1—
e
o
r*
LJ
o
X
X
X
•r
o
CVJ
U
a
g
O
S
i
m
X
•f 1*1
0 0
o o
§ §
Q 9
r- H
IH NH
w in
X X
UI
<
9 s
« g
" £
o >
•4
U>
g a
Q. CO
<
o -i
S x
*K K
UJ T
o
o
^
X
X
X
X
X
X
IS.
o
u*>
3
g
O
19
l-i
u.
0-
-^
UI
^
»H
UJ
a
a
o
u
5
2
0
1
in
CJ
o
o
3[
X
X
X
X
X
X
X
m
£
r
1-4
Z
CM
UI
K
h-
M
*-
<
tn
»••<
Qi;
%*
|
P
a
^
»y
O
O
31
X
X
X
X
X
X
r-
£
in
^
r
£
tn
H
QC
O
UJ
«(
at
5
*
R
*^
o
o
3C
1
1
X >
t
XXX XXXXXXXi
X
xxxxxxxxxxx
x xx x
X X
XXX XXXXXX
XXXXXX XXXX
XXXXXX XXXX
x£3£z'££S£S£
E
UJ U tt UI ^
-J CD O ^ -J UJ
iss«slpsuil|
uj 4 ^ uj uj O ^t ^ ^^ ft
ZXCX3u.C
ac < ea a: t
0- IU VI
•> in a x i
CM u; z in i
Z U. UI 1
u *> M a ^- i
Off EL u. IU < >
ui in u. ui
in o c N uj a o ^
M a acaeZacza: <
tf) ul X ul O O O
Mh-^Q. U!3l~^ 5IA<-l - < J >-
u. O O « uj J O v- B
QC QC t/> UJ —JO
tCKOuj U Ot OC <
OQp^^JJHpOuj
UJ Ul 1U P* Ul U^ UJ
^ . _ _
3 < < ^ m < 3 a; -i
asiiSafia:r^^
Sz^^o-otSzu x
3fio^5O3£fil»O
5e = z* >^ =
i I i I i i 1 1 1 1 1
isio-cooooo.niN.cie
000*00000000
XXXXXXXXXXX
— -J II
en- u
ffii— u
Szinn
wi
ON^^I
MUU.I
XUJU.I
O-iOi
*"5c!
«• ^n
0:0:11
k-OlJii
inaSii
tUUICXH
•«*2 u
m »-N
HO<"
Ouiinii
ii
M
in u)i>
ui(n»-i<
^-OM
MUJZPI
l-l-«ll
MXI/);;
•IXUti
2VH M
i O:«HXII
i i-taoit
- 1
u-n-i i
r 5- i
Zll
Ul J
l"-.bull
SZl-l
luini
•xs31!
SLU-l!
CXI
t
UJOH
*°S|
Z i
^ UJ 1
k— Q t
tfi r«
**E 5*'
O CM
1 P^Oh-til
ODuJit
i 5||i';
"mi
in-i i
CU i
Sato
UP1I
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
in
e
s.
(9 >~
« «
& a
19 — >-
•« in a ••
BOM
z 2 a. yj
U in u.
U E UJ O
*- UJ **
O t~ I- E
DC in 11 3
a. >- _< K
in w o
-J U O
•< x < a
*- uj U. 0.
z e
u £ o in
g «uj o
O V O ••
z M in IB
< oc
• ik
in a:
> 0.
kU O
O 10
in *• t
< a 5
c « a
i
H
tu
55 = !
IB Ul
-
•->
iflvin
B.
O.
S3
rt iu lu
Z M 1ft
2 u, iu
_ iu O O
g_z»2?*iSu.
Z Ziui
« z O Z i
IU ID < LI
IB -i u iu J 5
HI O J > I ^ C < S •-
u Z HI x o in u Q a: u -i tu oc
in
iu
x
H4
a.
2,0
Z Z V)
ss 3s
£ 3
p ».*-(-
5IU
IU
*• t- ac
$g £8
iu > H.
u < in
" B Z
u. iu O .
O >- in >- o M tn vi
«n ^ in a K ui a
is « ac ft > B z HI Ht iu •
z u < z QC < u. Q in z -i u
HI z u iu j iu s U ft in ^ J
m « iu«>iuEtui-i«i-i.ji — -J
5-i iu ac u HI — ac u. X C M iu
ID HI B ik iu B r- o 3
u — » i: Ox «t o ui Z o
B — O O IU Ctl Z^ OlfW ^
5-rP>oz4>H«ee«BKO<
C^njinu-ru-CNtnMzacQtu
!
i
1
u o >u in
i o N a. >-
: < m -i >. s
IK a M i-
: _ • i- in z
«
^S
5S
2I^
-si
I- >- I ««
iu m in m _j _ _
-< u NIU< iu •• a p iu i _, _
a> • at z M >- < _< < ? -i o S a in
< >-4u>-i-iBtnEO*-nM-j-<< >•«
Z Q w ^ ^ J P 5 3 in MOMZCKiua:
MOUZB. c u. - - - •=-.-.
a -J
H> — < iu
ui t— >
IU IU HI ^
a: H- a
P « in ^
in o a
< i 8
ac a. iu o
Q u iu u
ac -i «• H. <
iu t < J
ixS
*8i
UJ < I
S5
_ •• in > HI oi :
: >- at ac u f
in iu t iu iu z I- i
< tn
> *
i
i
!Ls!
O ^ HI J O.
& i Z :
j o z 8 i
I >• S ^ HI
o OCH> QC o IUE o HI
in o a. o o u H- o O •« u a
acu u H. UMUU IUMJI
u i u iu z J w t
> J ^<^Hi<«^acZZwu
Hi-J^iuDCO > 1UMIUHIM
ZlUH'lu UKKHi UJHI>
Zt-maciu uj-u-icrn.
^OWH-UJ«IUZIUV>O u
H minina.u3wa:3Di^^
SH-^lAH*^a.Zlua^UOH>-j^
N- iu^tuO
22
IKSSS*,:
K |
M a
o. P u a
335 u
,VS5SS5
I Z & U « VI HI
HI > 5 Qc -i
! «>*82!SB
5S3251
: 5 u ik 5
i a ip in DC
: U S « u u
i pc in i H> x
C ui « o
i ac u * HI a.
i oc < iu a in
i w a. _j <
5< iu z Z Z
H. z z Z z
« * W IU UJ IU
a a. a. a. a. a.
SO o H. S
z — a P —
So, ae
IU
U >- < Z
OC Hi IU
iu m i»
Z U < H>
intuH-iuiuz*-iuin7o
-JZHE «t<«Hia
Sac«^H>O3iuoQpiuQc-JHi
2 o 5 K O O e 2 o-1 u *n
itCt4au.atocw3ncQ.Hi — —
So M
HI U Ik IU
_J iu |B
U K
5 ? *
S 8§ 5
S
2l = SS
in 3! « H I
JrSJS^oSg .
UHi-lOOOCUXU u
>«.-Hia[iup u. t
a 2 iu M v u
w O J « > o
H OU UI OC IU I U
Z iu in o HI
IU < < Q. 5 U OC
(M) M tart < O ^
z z o. a u u
Hi < < IU IU
in > > I -i -i -i
5 H H IU O
Z in tn ^ »4 < «
Izzii^
IU IU IW IU MJ Z S-
Q. a. a. a. a, £ E
u w >- Z o
M IU O O IU U
-i z in -i u o
5O<-J J___ - _
artuuji^ociuZirt
iiua.OHi -1 " J J —
^l£(rih*^OclrtQ>*
Xinc9-iHiZ5Hi-»ac
p-iuujiijHiO-JO
CBOEQcminininviinininHiasa
'S£
•«•» — ^«n«iAinoP>il)nj«« — if)
o^ — »^w — o —
«rxojoooor>.4>-^»^m
w ~ TMftie^in . .
'MrtONttOM*^
-. ._. - -'Ifl — O — CM* —
o«rxojoooor>.4>-^»^m0->^
in«»tu*^rvn .p * «
oooooooboo _ _
ilalli?!?!?!!!?58333
*^sg
* O M
> o in o '
fn « * Q in o
c M o M m e
* o o o o o
iiiiii
i^-< — in — i/iuii/i
i — in«o»or-«
o *• o-
IM e o i
g»
-------
-------
s
ill?
IS5-
to *• K- >.
U • • U
M m n p»
•* • « e
S.S
ssr
28,1
u • u
ii ixil Ilii iiii iiii ill
32S-
M U 00
ilsf = si* si? El!
3*| S2s= 5s!8 iii
>--• U*«* U • 0 S) U0«
!2i2 2=SS SSSS S2S
i~3
I
>•*-••
•• y o
*
Ii!
53
*» i«.
z»
O M HI w
U *l H.
HI Z HI H.
to HI M S
O to to
-J UJ to to
Z H « << <
ul U to to
4 M M
39
0 Ml
•« M
0 H.
35
0
GS
79
IE
CT
LI
to
U X
5*
32
a q
M 3
•f HI
<« M
0 H.
«
•H
to •*
£3
•0 HI
sr
= s
>
IP*
M
h
FACILITY
NAME : ADDRESS : C
?s
m m
O —
SS2
SIT* S
i
w " " 2
555 s
S 5
to 3 U §
« •» at w
o -. S •
9
i.
CONNECTICUT U6HT t P
END OF HOQOHARO AVCNU
*
n
Ml
O
O
u
WM»
O
3
i
I
a
i
CONNECTICUT LIGHT • P
NAUBATUCK AVENUE
HILFORO
S
O
O
to
u
e
6ENERAL DYNAMICS CORP
EASTERN POINT ROAD
GROTON
M
•T
O
I
Q
O
HI
S
lA
TURNER AND SEYMOUR NFC
100 UUfTON STREET
TORRINCTON
S
r«
?
e
e
u
o
PERVEL INDUSTRIES INC
COmUNIlY AVENUE
PLAINFIELO
»
8
J
a
o
e
u
o
o
n
^
2
£
HI q
53
^t
** S
U- M
.8
to to
O HI
ii
Ii
m
M
^
«
«
o
e
S
u
o
1
I
OU PONT E I DE NEMOURS
•5 MILL PLAIN RD
FAIRFIELD
K
«
»
«
•«
2
O
0
u
2
3
NATIONAL DIST AND CNEH
10 WAND ST
2
At
S
—
o
o
s
u
tfk
i
HI
(•
O
p«
a
-------
------- |