Toxic
Chemical
Release
Inventory
• ••••••• s
- ••
• •••
• • • •
• •••••••«. t*.1r
• •••••••»*».,-
.•
••••••••••••••••••
*«.«.- •••••••••••••••••••••••••••• • •••
'•••••••••••••••••••••••••••A ••• •••••
••••••••••••••••••••A •••• ••••••••
•••••••••••••••••••••••••A* •••• ••••••••
. . ••
v rr. i- '••••••••••••••••••••••
••••••••••••••••••••••••••••••
• «..... ,v • • • •
«. » .. ^ r, <«*»•«•• w » » * «••»»•••«*•••••••• ••••
• • f » » 6r « • • * 0- <• ?• . •••••••••• • • •
*• •»«l4t*•«^*l^^«- ••••• ••(
*- ^ * - ^ -^ « * i» * fc » • • «,- » ••. » • • • 0i
• •
•
Toxic Chemical Release Inventory System (TRIS)
Information Retrieval Users Guide
Office of Toxic Substances
U.S. ENVIRONMENTAL PROTECTION AGENCY @ Printed on Recycled Paper
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF CONTENTS
1 INTRODUCTION 1-1
1.1 What is SARA? 1-3
1.2 What is TRIS? 1-3
1.3 What Type of Information is Available in TRIS? 1-3
1.4 How is Information Received? 1-4
1.5 How is Information Prepared for Access? 1-4
1.6 How Much Information is Available in TRIS? 1-4
1.7 Who Can Access TRIS? 1-5
1.8 TRIS Direct Access Users 1-5
1.9 Access via "Other Means" 1-6
1.10 System Administration 1-6
1.11 TRIS User Support 1-6
1.12 Special Requests 1-7
1.13 Requests For Printed Material 1-7
1.14 Answer All Questions 1-8
1.15 NCC User Support 1-8
2 ACCESS TO TRIS 2-1
2.1 TSO Logon Procedure 2-4
2.2 TSO Logoff Procedure 2-8
2.3 CICS Logon Procedure 2-9
2.4 CICS Logoff Procedure 2-13
2.5 Quick Logon Procedure 2-13
2.6 Quick Logoff Procedure 2-15
11/18/91 i TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF CONTENTS (Continued)
3 TRIS GENERAL FEATURES 3-1
3.1 Operational Features 3-3
3.2 Menu Operation 3-3
3.3 Keyboard Operation 3-3
3.4 Information Messages / Windows 3-4
3.5 Online Help Feature 3-4
3.6 TRIS Data Keys 3-4
3.7 Document Control Number 3-5
3.8 TRI Facility ID 3-5
3.9 Searching Using Wildcard 3-6
3.10 Searching Using Chemical Synonym 3-6
3.11 Codes Used in TRI Data 3-7
4 MAKING TRIS WORK FOR YOU 4-1
4.1 Reporting Package and Form R 4-3
4.2 Defining Your Data Search 4-4
4.3 Different Types of Data Retrievals 4-4
4.4 Data Retrieval using the Online Queries 4-5
4.5 Data Retrieval using the Batch Reports 4-5
4.6 Data Retrieval using the Data Offload 4-6
4.7 Helpful Hints 4-8
11/18/91 ii TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF CONTENTS {Continued)
5 ONLINE QUERIES .............................................. 5-1
5.1 Facility Name Search ...................................... 5-4
5.2 City / County Search ..................................... 5-12
5.3 CAS / Chemical Search ................................... 5-20
5.4 Alternate Facility Key Search ............................... 5-28
5.5 Submission Display ...................................... 5-36
5.6 POTW / Offsite Search .................................... 5-40
5.7 Year-to-Year Release / Transfer Comparison ..................... 5-44
5.8 Historical Facility Information Search ......................... 5-46
5.9 Chemical Table Search .................................... 5-50
6 BATCH REPORTS ............................................. 6-1
6.1 Controlling Where and When Reports Print ...................... 6-4
6.2 Recording the Job Number .................................. 6-6
6.3 Geographic / Chemical Profile Report .......................... 6-7
6.4 POTW / Off-Site Location Report ............................. 6-9
6.5 Facility Profile Report .................................... 6-11
6.6 Form R Facsimile Report .................................. 6-13
6.7 Regional TRIS Submissions Report ........................... 6-15
6.8 Chemical / Geographic / SIC Code Report ...................... 6-17
6.9 Year-To-Year Release / Transfer Comparison .................... 6-19
6.10 SAS Reports Menu ...................................... 6-21
6.10.1 Facility Identification Data .......................... 6-22
6.10.2 TRI Chemicals ................................... 6-23
6.10.3 Total Environmental Releases ........................ 6-24
TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF CONTENTS (Continued)
6.10.4 Air Emissions 6-25
6.10.5 Discharges to Water 6-27
6.10.6 Releases to Ground and Underground Injection Wells 6-28
6.10.7 Transport of Chemicals Wastes Off-site for Treatment
or Disposal 6-29
6.10.8 Waste Treatment 6-31
6.10.9 Waste Minimization 6-32
7 DATA OFFLOAD 7-1
7.1 IBM Sequential Data File 7-7
7.2 Understanding the Printed Report 7-8
8 TUTORIAL 8-1
8.1 General Information 8-5
8.2 Using the System 8-6
8.3 Online Queries 8-7
8.4 Batch Reports 8-9
8.5 Data Offload 8-10
8.6 User Support 8-11
9 USER SUPPORT 9-1
9.1 Questions and Suggestions 9-4
9.2 Request Documentation 9-5
9.3 Extract File Information 9-6
9.4 Set Program Function Keys 9-7
11/18/91 iv TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDICES
APPENDIX A
APPENDIX B
APPENDIX C
APPENDIX D
APPENDIX E
APPENDIX F
APPENDIX G
GLOSSARY
SAMPLE BATCH REPORTS
EPA REGIONS AND STATES
FORMR
MICRO-TO-MAINFRAME LINK
KEYBOARD MAPPING
REGIONAL ACCOUNT MANAGERS
09/03/91
TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLES
5-1 Facility Name Search - Facilities Screen 5-11
5-2 Facility Name Search - Submission & Chemical Screen 5-11
5-3 City / County Search - Facilities Screen 5-19
5-4 City / County Search - Submission & Chemical Screen 5-19
5-5 CAS / Chemical Search - Facilities Screen 5-27
5-6 CAS / Chemical Search - Submission & Chemical Screen 5-27
5-7 Alternate Facility Key Search - Facilities Screen 5-35
/
5-8 Alternate Facility Key Search - Submission & Chemical Screen 5-35
5-9 Submission Display 5-39
5-10 POTW / Offsite Search 5-43
5-11 Year-to-Year Release / Transfer Comparison 5-45
5-12 Historical Facility Search 5-49
5-13 Chemical Table Search 5-52
09/03/91 vi TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1 INTRODUCTION
09/03/91 1 - 1 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 1 - 2 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1 INTRODUCTION
1.1 What is SARA?
In 1986, Congress passed the Superfund Amendments and Reauthorization Act, or SARA. Title
III of SARA, known as the Emergency Planning and Community Right-to-Know Act (EPCRA),
mandates in Section 313, that an inventory of toxic chemicals released into the air, water, or land
must be maintained by the Environmental Protection Agency (EPA). It also mandates that the
EPA must make this information available to the public.
1.2 What is TRIS?
TRIS stands for the Toxic Chemical Release Inventory System. It is the computer system used
by the Environmental Protection Agency to track the annual estimated release of toxic chemicals
into the environment. It serves as a management tool used by the EPA to simplify the collection
and organization of toxic chemical release data received from industries regulated under SARA.
1.3 What Type of Information is Available in TRIS?
TRIS contains information about the releases and transfers of over 300 different toxic chemicals.
This includes information, such as, CAS Number and chemical name, company name, amount
of the chemical released or transferred off-site, medium released into (air, water, land...), Standard
Industrial Classification (SIC) code, activity and use of the toxic chemical, technical and public
contacts, waste treatment information, and the locations to which chemicals are transferred.
09/03/91 1 - 3 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1.4 How is Information Received?
Companies which must report under this rule complete EPA's Form R. Information contained
on the Form R may be submitted by the reporting companies on magnetic tape or floppy disk.
This information is then sent to the EPCRA Reporting Center in Washington, D.C.
1.5 How is Information Prepared for Access?
Form Rs are received at the EPCRA Reporting Center for processing. The information on each
Form R is keyed by data entry personnel into the TRIS Data Entry System. The TRIS Data
Entry System is a menu driven data entry and tracking system located on a PC local area
network. If the information is submitted on floppy disk or magnetic tape, the information is
simply electronically read into the TRIS Data Entry System. Once the data are entered, it is
checked for accuracy against the submission. Then it is transferred to the IBM ES/9000 at EPA's
National Computer Center (NCC) in Research Triangle Park, North Carolina.
1.6 How Much Information is Available in TRIS?
TRIS currently contains information for three reporting years; 1987, 1988, and 1989. Companies
throughout the U.S. and its territories (District of Columbia, Guam, Puerto Rico, American
Samoa, the U.S. Virgin Islands, and the Commonwealth of Northern Marianas Islands) submitted
TRI Form Rs in the quantities shown on the following page.
09/03/91 1 - 4 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Year
1987
1988
1989
Companies
19397
21,404
22,641
Submissions
79,057
84,693
82,513
Pounds*
21 billion
8.2 billion
5.8 billion
* Note that changes in
chemicals for which
reporting is required.
account for a substantial
amount of the differences
between years
The above figures are current on the date this document was produced. These statistics will
change as TRIS is updated (i.e., new submissions added and existing submissions revised).
1.7 Who Can Access TRIS?
EPA (headquarters and regions), states and their contractors may access TRIS directly through
the NCC IBM ES/9000 mainframe computer. The public may access toxic release inventory
information via "other means" including microfiche at public libraries, through TOXNET at the
National Library of Medicine, magnetic tape and other computer products from the National
Technical Information Service (NTIS) or the U.S. Government Printing Office (GPO), and EPA's
published national report (a summary of the data submitted).
1.8 TRIS Direct Access Users
Authorized users around the country may access the TRI database on the NCC's IBM ES/9000,
using a direct connect 327x terminal or by using a terminal or PC connected to the mainframe
via a modem. However, the user must have a NCC IBM User ID and a TRIS account to access
the system. To obtain a User ID or TRIS account, contact your Regional Account Manager listed
in Appendix G. A new user will need to become familiar with the mainframe access procedures,
described in Section 2, Access to TRIS.
09/03/91 1 - 5 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1.9 Access via "Other Means"
Although the public does not have direct access to the TRI database on NCC's IBM ES/9000,
access is provided a number of ways, including: on microfiche at many public libraries, through
TOXNET at the National Library of Medicine, on magnetic tape or other computer products from
the National Technical Information Service (NTIS) or the U.S. Government Printing Office
(GPO), and in EPA's published national report summarizing the data submitted.
1.10 System Administration
The Office of Toxic Substances (OTS), Information Management Division (IMD) has been given
the responsibility to receive and process industry submissions as a result of Title in of the
Superfund Amendments and Reauthorization Act (SARA).
The TRI System is administered and maintained by the Non-Confidential Systems Section
(NCSS), Public Data Branch (PDB) that is within the Information Management Division (IMD)
of OTS.
1.11 TRIS User Support
TRIS User Support is a team of dedicated professionals available to all TRIS users connected to
the IBM ES/9000 accessing the EPA internal database. It is based at the EPA Headquarters in
Washington, D.C. General questions about the ES/9000 machine (such as resetting passwords)
should still be referred to NCC User Support. Answering questions, providing current updates
on TRIS, and receiving feedback from users make up the backbone of TRIS User Support.
09/03/91 1 - 6 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
You can request assistance by:
1. Calling the TRIS User Support Telephone number: (202) 260-9419
2. Sending requests to the TRIS FAX number: (202) 260-4655
3. Sending requests to EPA MAIL address: TRIS.USER.SUPPORT or EPA74013
4. Using the TRIS Online User Support Function (see Section 9 of this document)
1.12 Special Requests
TRIS User Support will handle most special requests for ad hoc programming. Ad hoc requests
can be produced for users who require unique or highly complex data searches that are not
available through the TRIS menu driven system.
TRIS User Support can run complex reports but need detailed specifications from the user. It
is very important to have all the necessary information. Specifications include search criteria,
special calculations, and report or file format.
1.13 Requests For Printed Material
TRIS User Support handles requests for printed materials including:
• TRIS Information Retrieval Users Guide • Extract File Specifications
• TRIS Quick Reference Card • Training materials
• ADABAS File Definitions • Newsletters
• Updates on the latest enhancements • NLM Tape Specifications
• GPO/NTIS Tape Specifications
09/03/91Tl INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1.14 Answer All Questions
TRIS User Support will answer all kinds of questions including:
• Logon/logoff procedures specific to TRIS
• How to access TRIS
• Explanations of screens on the system
• How to find specific information in the system
• How to search the system online
• How to request a batch report (printed report)
• Explanations of error messages
• Discussions on Data Quality, Data Linkage, & Data Integration
• What to do if you find errors in TRIS data
• What is the status of data entry/how many submissions have been received
• Information on training schedules
• What types of training materials are available
1.15 NCC User Support
The National Computer Center (NCC) is one of the largest, most modern computer centers in the
nation. One of its primary missions is to support the Environmental Protection Agency in
applications, such as the TRIS database. NCC set up a User Communications Center to provide
adequate support for the users of TRIS and other applications.
09/03/91 n • INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
User Support through the User Communications Center is the primary point of contact between
any TRIS end user and the NCC IBM facility. Your calls are screened by an experienced
technician who will decide which NCC specialist or department can best handle your problem.
Besides the User Communications Center located in Raleigh, North Carolina; Washington D.C.
area users have support available to them through the Washington Information Center (WIC)
Network Support Group.
The NCC User Support group handles problems and questions such as getting your password
reset, communications problems (dialing out), and access to the IBM ES/9000.
The numbers to call for this support are:
Washington, D.C. 260-HELP
In North Carolina (919)-541-7862
FTS 629-7862
Outside North Carolina (800)-334-2405
For more information on the National Computer Center and its services, a manual entitled Guide
to NCC Services is available. This is an excellent manual distributed by NCC. You may obtain
a copy by calling NCC User Support. Users will need to supply their name, address, phone
number, and User ID.
09/03/91 1 - 9 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 1-10 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2 ACCESS TO TRIS
09/03/91 2 -1 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 2 - 2 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2 ACCESS TO TRIS
TRIS is stored on an IBM ES/9000 mainframe computer located at EPA's National Computer
Center (NCC) in Research Triangle Park, North Carolina. To access TRIS, you must have the
following:
• a computer terminal
• a mainframe user ID
• permission to use TRIS
If you do not have a mainframe user ID or access to TRIS, call TRIS User Support at (202)
260-9419 for the name ant! phone number of your Account Manager. All other mainframe
computer questions may be directed to NCC User Support at:
FTS 629-7862
Inside North Carolina (919) 541-7862
Outside North Carolina (800) 334-2405
Your computer terminal may be hardwired (synchronous) or a microcomputer equipped with a
dial-up modem. A microcomputer must run communications software like CROSSTALK or
PROCOMM PLUS that can emulate a full-screen terminal. TRIS cannot be accessed by a TTY
(teletype) terminal.
The following instructions describe how to access TRIS using a hardwired terminal. If your
terminal is not hardwired to the NCC Mainframe, refer to the Guide to NCC Services (available
from NCC User Support) for assistance with other communications methods.
11 /18/91 2-3 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2.1 TSO Logon Procedure
1) Turn on the hardwired terminal; the EPA Menu System screen (Figure 2-1) will appear.
Type TSO and press .
WETMAIN*
U.S. Environmental Protection Agency
Menu System
Please enter selection or command and then press ENTER.
Date: 10/30/91
Time: 15:47:43
Terminal: T2312613
Logmode: S3278R2
1.
2.
3.
4.
5.
6.
INFORMATION
SYSTEM MENU
EMAIL
APPLICATIONS
INTER-AGENCY
PUBLIC
News Alerts a- i User Memoa
System Select -;n Menu
EPA Electronic Mail for 3270
EPA Applications Menu
Inter-Agency Applications Menu
Public Access Applications Menu
Command
-=>
Optional Quick Logon - USERID
PASSWORD
Fl/F13=Help F5/F17=Refresh F12/F24=Cancel
Figure 2-1
11/18/91
2-4
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2)
3)
At the TSO/E Logon screen (Figure 2-2), type your three character USER ID and press
to advance to the PASSWORD field. Type your PASSWORD and press
. (If previously supplied, PROCEDURE, ACCT NMBR, FIMAS, and BIN
NUMBER are entered automatically). See Appendix A for an explanation of these terms.
j. EPA2 TSO/E LOGON T2312611
PF1/PF13 «> Help PF3/PF15 ==> Logoff PA1 ==> Attention PA2 ==> Reshow
ENTER LOGON PARAMETERS BELOW:
USERID ===> ABC
PASSWORD ===>
PROCEDURE -«>
ACCT NMBR ===>
FIMAS ===>
SIZE -==>
COMMAND ===>
RACF LOGON PARAMETERS:
NEW PASSWORD ===>
GROUP IDENT "=>
BIN NUMBER ===>
SYSOUT DEST «=>
ENTER A "S" BEFORE EACH OPTION DESIRED BELOW
-NOMAIL -NONOTICE -NOSUMMARY
-CANCEL
Figure 2-2
A logon confirmation message (Figure 2-3) will appear followed by three asterisks. Press
to continue.
ICH70001I ABC LAST ACCESS AT 14:31:36 ON WEDNESDAY, MARCH 27, 1991
IKJ56455I ABC LOGON IN PROGRESS AT 14:32:39 ON MAY 14, 1991
ARC1020I DFHSM IS RECALLING FROM TAPE DSN-HLRTRID.TABLES, YOU MAY CANCEL WAIT
FOR RECALL BY PRESSING THE ATTENTION KEY.
ARC0612I VOLUME MOUNT ISSUED FOR RECALL OR RECOVER OF ABCTRID.TABLES
Figure 2-3
11/18/91
2-5
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
i nia iraruriMM i IVJIN nc i nicvML uocno ouiuc
System News Alert messages (Figure 2-4) will appear followed by a READY
Type NATP and press .
4)
5)
prompt.
91/05/09:
91/05/01:
91/04/17:
91/03/27:
91/02/27:
READY
NATP
POSSIBLE MISPLACED PRINT OUTPUT
RACF VERSION 1.9
MEMORIAL DAY HOLIDAY SCHEDULE
SUPPORT FOR ADAMINT PROGRAMS WILL END
CHANGE IN ARCHIVAL OF DATA SETS (UPDATE)
- SEE NEWS ALERT4
- SEE NEWS ALERT1
- SEE NEWS ALERT3
- SEE NEWS ALERT9
- SEE NEWS ALERT2
Figure 2-4
The NATURAL Logon Procedure screen (Figure 2-5) will appear.
APPLICATION-ID prompt, type TRISONLN and press .
At the
***** NATURAL LOGON PROCEDURE *****
ENTER APPLICATION-ID: TRISONLN
USER-ID: ABC
FOR A LIST OF APPLICATIONS CURRENTLY AVAILABLE FOR SELECTION,
ENTER '??' AS THE APPLICATION-ID.
TO TERMINATE NATURAL. ENTER 'FIN' AS THE APPLICATION-ID.
FOR MORE HELP. ENTER A '?' AS THE APPLICATION-ID.
Figure 2-5
11/18/91
2-6
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6) The TRIS Welcome screen (Figure 2-6) will appear. Press to continue.
PGM: TRISLOGO
MAP: LOGOMAP1
U.
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
S. ENVIRONMENTAL PROTECTION AGENCY
OFFICE OF TOXIC SUBSTANCES
05/14/91
14:35:29
RRRRRRRRRRR
RRRRRRRRRRRRR
RRRRRRRRRRRRRI?
RRRRR RRRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRRR
RRRRRRRRRRRRRRR
RRRRRRRRRRRRRR
RRRRR RRRRR RELEASE
RRRRR RRRRR
RRRRR
RRRRR
RRRRR
RRRRR
RRRRR
RRRRR
RRRRR
RRRRR
user name
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
IIIII
inn
IIIII
IIIII
IIIII
IIIII
IIIII
IIIII
IIIII
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
3.0
Press for System
SSSSSSS
sssssssssss
sssssssssssssss
sssss ssss
sssss ssss
S5SSSS
ssssss
ssssss
ssssss
ssssss
ssss sssss
ssss sssss
sssssssssssssss
ssssssssssss
ssssssss
Messages
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFV PF8 PF9 PF10—PF11—PF12 —
CONT EXIT
Figure 2-6
7) The TRIS System Message screen (Figure 2-7) will appear containing submission
statistics and other important information. Press to continue.
PGM: TRISLOGO
MAP: LOGOMAP2
TOXIC RELEASE INVENTORY SYSTEM
SYSTEM MESSAGE SCREEN
05/14/91
14:35:40
On 4/26/91. TRIS Release 3.0 v, nstalled on the NCC ES/9000. This
release contains many new feat , designed to make the system easier
to use and more productive. So, . of these features are:
> Field level HELP with pop-up windows
> Use of wildca- (*) in searching
> Addition of i>, j chemical synonyms
> Online searches with multiple cities, counties, and CAS number
> Selection criteria remain on screen when returning from display
> New function: DATA OFFLOAD
> New function: TUTORIAL
> New function: USER SUPPORT
> Leading zeroes no longer needed for CAS numbers.
> And much more Many enhancements resulted from your comments.
Please continue to inform us on how we can improve the system.
**********************************************************************
Reporting Year -1987* -1988* *1989*
Number of Submissions 79,057 84,693 82,513
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
CONT EXIT
Figure 2-7
11/18/91
2-7
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8) TRIS Data Retrieval menu (Figure 2-8) will appear. Options are discussed in detail in
individual sections in this document. Please refer to:
• Section 5 Online Queries
• Section 6 Batch Reports
• Section 7 Data Offload
• Section 8 Tutorial
• Section 9 User Support
PGM: TRMOOOP
MAP: TRMOOOMl
TOXIC RELEASE INVENTORY SYSTEM
DATA RETRIEVAL MENU
1 ONLINE QUERIES
2 BATCH REPORTS
3 DATA OFFLOAD
4 TUTORIAL
5 USER SUPPORT
X EXIT SYSTEM
Key selection and press ===> _
05/16/91
09:53:41
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11--PF12
HELP EXIT
Figure 2-8
2.2 TSO Logoff Procedure
1) At the Data Retrieval menu, type X and press , or press .
2) At the READY prompt, type LOGOFF and press .
3) The EPA Menu System screen (Figure 2-1) will be redisplayed.
4) To exit the EPA Menu System screen, turn off the hardwired terminal.
11/18/91 2~Hi ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2.3 CICS Logon Procedure
1) Turn on the hardwired terminal. The EPA Menu System screen (Figure 2-9) will appear.
Type PCICS and press .
NETMAIN*
U.S. Environmental Protection Agency
Menu System
Please enter selection or command and then press ENTER.
Date: 10/30/91
Time: 15:47:43
Terminal: T2312613
Logmode: S3278R2
INFORMATION
SYSTEM MENU
EMAIL
APPLICATIONS
INTER-AGENCY
6. PUBLIC
News Alerts and User Memoa
System Selection Menu
EPA Electronic Mail for 3270
EPA Applications Menu
Inter-Agency Applications Menu
Public Access Applications Menu
Command
=> PCICS
Optional Quick Logon - USERID ===>
PASSWORD ===>
Fl/F13=Help F5/F17=Refresh F12/F24=Cancel
Figure 2-9
11/18/91
2-9
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2)
At the prompts (Figure 2-10), type your USER ID and press . Type your
PASSWORD and press . (If previously supplied, ACCT ID, FIMAS, GROUP
WENT and BIN NUMBER are entered automatically.)
ZZSNSHT
U.S. Environmental Protection Agency
PRODUCTION CICS logon
Date: 10/30/91
Time: 15:53:28
Enter USERID and PASSWORD and then press ENTER.
USERID ===> ABC
PASSWORD ===> NEW PASSWORD =
Change other logon parameters (Y/N) ===> N
Command ===>
Fl/F13=Help F3/F15=Exit
Figure 2-10
3) The CICS Sign-on Facility screen (Figure 2-11) will appear. Type NATP and press
.
ZZSNINT
U.S. Environmental Protection Agency
CICS Sign-on Facility
Date: 10/30/91
Time: 15:56:33
SIGN-ON COMPLETED
Please enter initial CICS transaction below and then
press enter.
Initial trans: NATP
CLEAR=Exit
Figure 2-11
11/18/91
2 - 10
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4) The NATURAL Logon Procedure screen (Figure 2-12) will appear.
APPLICATION-ID prompt, type TRISONLN and press .
At the
***** NATURAL LOGON PROCEDURE *****
ENTER APPLICATION-ID: TRISONLN USER-ID: ABC
FOR A LIST OF APPLICATIONS CURRENTLY AVAILABLE FOR SELECTION,
ENTER '??' AS THE APPLICATION-ID,
TO TERMINATE NATURAL, ENTER 'FIN' AS THE APPLICATION-ID.
FOR MORE HELP, ENTER A ' ?' AS THE APPLICATION-ID.
Figure 2-12
5) The TRIS Welcome screen (Figure 2-13) will appear. Press to continue.
PGM: TRISLOGO
MAP: LOGOMAP1
U. S.
ENVIRONMENTAL PROTECTION AGENCY
OFFICE OF TOXIC SUBSTANCES
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
RRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRRR IIIIIIIIIII
RRRRR RRRRRR IIIII
RRRRR RRRRR IIIII
RRRRR RRKRR IIIII
RRRRR RRRRRR IIIII
RRRRRRRRRRRRRRR IIIII
RRRRRRRRRRRRRR IIIII
RRRRR RRRRR RELEASE 3.0 IIIII
RRRRR RRRRR IIIII
RRRRR RRRRR IIIII
RRRRR RRRRR IIIIIIIIIII
RRRRR RRRRR IIIIIIIIIII
RRRRR RRRRR IIIIIIIIIII
user name , Press for System
05/30/91
16:24:57
SSSSSSS
SSSSSSSSSSS
sssssssssssssss
5SSSS SSSS
SSSSS SSSS
ssssss
ssssss
ssssss
ssssss
ssssss
SSSS SSSSS
SSSS SSSSS
sssssssssssssss
ssssssssssss
ssssssss
Messages
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12--
CONT EXIT
Figure 2-13
11/18/91
2- 11
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6)
The TRIS System Message screen (Figure 2-14) will appear containing submission
statistics and other important information. Press to continue.
PGM: TRISLOGO
MAP: LOGOMAP2
TOXIC RELEASE INVENTORY SYSTEM
SYSTEM MESSAGE SCREEN
05/14/91
14:35:40
On 4/26/91, TRIS Release 3.0 was installed on the NCC ES/9000.This
release contains many new features designed to make the system easier
to use and more productive. Some of these features are:
> Field level HELP with pop-up windows
> Use of wildcard (*) in searching
> Addition of 5,000 chemical synonyms
> Online searches with multiple cities, counties, and CAS number
> Selection criteria remain on screen when returning from display
> New function: DATA OFFLOAD
> New function: TUTORIAL
> New function: USER SUPPORT
> Leading zeroes no longer needed for CAS numbers.
> And much more Many enhancements resulted from your comments.
Please continue to inform us on how we can improve the system.
Reporting Year *1987*
Number of Submissions 79,057
IT****************
*1988* *1989*
84,693 82,513
Enter-PFl --- PF2 --- PF3— PF4 --- PF5 --- PF6 --- ?
CONT
l— PF8— PF9 --- PFlO— PFll— PF12-
EXIT
7)
Figure 2-14
The Data Retrieval menu (Figure 2-15) will appear. Options are discussed in detail in
individual sections in this document. Please refer to:
• Section 5 Online Queries
• Section 6 Batch Reports
• Section 7 Data Offload
• Section 8 Tutorial
• Section 9 User Support
PGM: TRMOOOP TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRMOOOM1 DATA RETRIEVAL MENU 09:53:41
1 ONLINE QUERIES
2 BATCH REPORTS
3 DATA OFFLOAD
4 TUTORIAL
5 USER SUPPORT
X EXIT SYSTEM
Key selection and press ===>
Enter-PFl PF2 PF3— PF4 PF5 PF6 PF? PF8— PF9 PFlO— PFll— P'ST?--- •
HELP EXIT
Figure 2-15
1 1/18/91 2-12 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2.4 CICS Logoff Procedure
1) On the Data Retrieval menu, type X and press , or press .
2) A blank screen will be displayed. Type CSSF LOGOFF and press .
3) The EPA Menu System screen (Figure 2-9) will be redisplayed.
4) To exit the EPA Menu System screen, turn off the hardwired terminal.
2.5 Quick Logon Procedure
1) Turn on the hardwired terminal; the EPA Menu System screen (Figure 2-16) will appear.
Type TRIS, press , and type your USER ID, press and type your
PASSWORD, and press . (If picviously supplied, ACCTID, FIMAS, GROUP
WENT, and BIN NUMBER, are entered automatically).
NETMAIN*
U.S. Environmental Protection Agency
Menu System
Please enter selection or command and then press ENTER.
Date: 10/30/91
Time: 15:47:43
Terminal: 12312613
Logmode: S3278R2
1.
2.
3.
4.
5.
6. PUBLIC
INFORMATION
SYSTEM MENU
EMAIL
News Alerts and User Memos
System Selection Menu
EPA Electronic Mail for 3270
APPLICATIONS EPA Applications Menu
INTER-AGENCY Inter-Agency Applications Menu
Public Access Applications Menu
Command ==>
Optional Quick Logon - USERID »«>
PASSWORD ===>
Fl/F13-Help F5/F17-Refresh F12/F24-Cancel
Figure 2-16
11/18/91
2-13
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2) The TRIS Welcome screen (Figure 2-17) will appear. Press to continue.
PGM: TRIS LOGO
MAP: LOGOMAP1
TTTTTTTTTTTTTTT
TTTTTTTTTTTTTTT
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
U. S. ENVIRONMENTAL PROTECTION AGENCY 05/30/91
OFFICE OF TOXIC SUBSTANCES
RRRRRRRRRRR
RRRRRRRRRRRRR
RRRRRRRRRRRRRR
RRRRR RRRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRRR
RRRRRRRRRRRRRRR
RRRRRRRRRRRRRR
RRRRR RRRRR RELEASE 3
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
IIIII
inn
IIIII
IIIII
IIIII
IIIII
.0 IIIII
IIIII
IIIII
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
user name , Press for System
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF
CONT
16:24:57
SSSSSSS
SSSSSSSSSSS
SSSSSSSSSSSSSSS
sssss ssss
sssss ssss
ssssss
ssssss
ssssss
ssssss
ssssss
ssss sssss
ssss sssss
SSSSSSSSSSSSSSS
ssssssssssss
ssssssss
Messages
7 PF8 PF9 PF10 — PF11 — PF12
EXIT
Figure 2-17
3) The TRIS System Message screen (Figure 2-18) will appear containing submission
statistics and other important information. Press to continue.
PGM:
MAP:
TRISLOGO
LOGOMAP2
TOXIC RELEASE INVENTORY SYSTEM
SYSTEM MESSAGE SCREEN
05/14/91
14:35:40
On 4/26/91, TRIS Release 3.0 was installed on the NCC ES/9000.fHIs
release contains many new features designed to make the system easier
to use and more productive. Some of these features are:
> Field level HELP with pop-up windows
> Use of wildcard {*) in searching
> Addition of 5,000 chemical synonyms
> Online searches with multiple cities, counties, and CAS number
> Selection criteria remain on screen when returning from display
> New function: DATA OFFLOAD
> New function: TUTORIAL
> New function: USER SUPPORT
> Leading zeroes no longer needed for CAS numbers.
> And much more Many enhancements resulted from your comments.
Please continue to inform us on how we can improve the system.
a**************************************************************'****-**
Reporting Year *1987* *1988* *1989*
Number of Submissions 79,057 84,693 82,513
Enter-PFl PF2—PF3 PF4 PF5 PF6 PF? PF8—PF9—PF10—PF11—PF12-
CONT EXIT
Figure 2-18
11/18/91
2-14
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7) The Data Retrieval menu (Figure 2-19) will appear. Options are discussed in detail in
individual sections in this document Please refer to:
• Section 5 Online Queries
• Section 6 Batch Reports
• Section 7 Data Offload
• Section 8 Tutorial
• Section 9 User Support
PGM: TRMOOOP TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRMOOOM1 DATA RETRIEVAL MENU 09:53:41
1 ONLINE QUERIES
2 BATCH REPORTS
3 DATA OFFLOAD
4 TUTORIAL
5 USER SUPPORT
X EXIT SYSTEM
Key selection and press ===> _
Enter-PFl— PF2 PF3 PF4 PF5 PF6 PF7 PF8—PF9 PF10--PF11--PF12-
HELP EXIT
Figure 2-19
2.6 Quick Logoff Procedure
1) On the Data Retrieval menu, type X and press , or press .
2) A blank screen will be displayed. Type CSSF LOGOFF and press .
3) The EPA Menu System screen (Figure 2-9) will be redisplayed.
4) To exit the EPA Menu System screen, turn off the hardwired terminal.
Note: The NCC is in the process of automating the Quick Logoff procedure. Implementation
is expected in December 1991. The Information Retrieval Users Guide will be revised
accordingly at the next opportunity.
11/18/91 2-15 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
11/18/91 2 - 16 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3 TRIS GENERAL FEATURES
09/03/91 3 - 1 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 3 - 2 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3 TRIS GENERAL FEATURES
3.1 Operational Features
There are features of the operation of TRIS that are common throughout the system. These
features are explained in detail below.
3.2 Menu Operation
TRIS is a menu-driven system. Data are retrieved by selecting an option from a menu, entering
requested variables where prompted, and pressing to move to the next screen.
3.3 Keyboard Operation
The keyboard utilizes either single keys or combinations of keys to enter variables and perform
operations in TRIS. There are also specially designated keys or key combinations that are unique
to TRIS; these are called Program Function or PF keys. PF keys in TRIS are used to move from
screen-to-screen, to obtain help, or to exit from TRIS. PF keys are displayed at the bottom of
each screen with a short translation indicating what function will be performed. Standard PF
keys in TRIS are:
= HELP Invokes online help function
= MAIN Transfers to data retrieval main menu
= PREV Transfers to previous screen
Other PF keys are active for various functions on a screen-by-screen basis. See Appendix F for
an explanation of keyboard mapping using assorted telecommunications packages.
09/03/91 3 - 3 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3.4 Information Messages / Windows
TRIS protects the user from attempting to perform an operation not defined in the system, or
from entering variables that the system does not recognize. If an invalid operation or selection
is entered, the user receives an informational message at the top of the screen, or in a pop-up
window, stating that the operation or variable is not valid. For certain variables required by
TRIS, a pop-up window offering a selection of valid options is displayed.
3.5 Online Help Feature
TRIS contains an extensive online HELP feature. You may access HELP in several ways; for
example: pressing , placing a ? in the field and pressing , entering an
incorrect value in a field, or leaving a required field empty. Each method instantly displays a
pop-up window with HELP information. Detailed instructions on what is required or actual
values in a "pick list" are provided.
3.6 TRIS Data Keys
Several data elements that correspond to parts of Form R, are designated as data keys. These
keys allow users to search and retrieve data from the database. One of the most important keys
is the facility name. Other data keys include, but are not limited to the state, county, city, and
ZIP Code of the facility. Two special keys, described in detail below, are the Document Control
Number and TRI Facility ID.
09/03/91 3 - 4 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3.7 Document Control Number
The Document Control Number (DCN) is a unique identification number assigned to each Form
R submission as it is received by EPA. The DCN is used to help locate documents after they
have been physically stored; help track the status of processing for each submission document;
and link other correspondence received from the submitter. The format for the DCN is:
Positions
1 -2
3-4
5- 12
13- 13
14- 15
2
2
8
1
2
Description
Document Type (always '13')
Reporting Year
Eight Digit Sequence Number
Check Digit
State Abbreviation
Example:
Submission Reporting Sequence Check
Type Year Number Digit
13
State
87
00000101
MD
3.8 TRI Facility ID
It is necessary to track submissions from specific facilities from one reporting year to the next
in a reliable manner. The TRIS database uses a unique identifier constructed initially using parts
of the facility name, street address, and ZIP code. This technique is comparable to the method
that some subscription systems, i.e., magazine subscriptions, used to identify subscribers. The
unique identifier used in TRIS is called the TRI Facility ID. This identifier is assigned with the
first Form R submitted by a facility.
09/03/91
3-5
TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The 15 character TRI Facility ID is constructed as follows:
Position Contents
1 - 5 First 5 numbers of ZIP Code
6-10 First 5 consonants of name
11-15 First 5 letters or numbers of a street address
Example:
Waste Disposal Inc.
100 Main Street
Anywhere, State 99887
ZIP Name Street
,_--.. _ Code Address
100 Mam Street
99887 WSTDS 100MA
It is important to note that if a facility changes its name or the U.S. Post Office assigns a new
ZIP Code, its TRI Facility ID will not change. The TRI Facility ID identifies a facility based
on physical location.
3.9 Searching Using Wildcard
The wildcard notation, *, is used in many standard software packages to search for random
values. This feature is also available in TRIS. By entering the beginning portion of a search
string and attaching the wildcard notation, *, a range of values is found. For example, to obtain
a list of all Du Pont facilities, the correct search criteria would be Du Pont*.
3.10 Searching Using Chemical Synonym
TRIS allows searching by chemical synonyms in addition to the chemical names printed in the
Toxic Chemical Release Inventory Reporting Package and Federal Register.
09/03/91 3~niTRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Approximately 5,000 synonyms are available. Most TRI chemicals have one or more synonyms.
This option eliminates the time consuming task of entering lengthy CAS registered names. For
example, a synonym name of the chemical temponitrin is tempo.
3.11 Codes Used in TRI Data
Codes are used in TRIS to represent TRI data elements. There are two types of codes used:
1) Standard codes used by industry
2) Codes unique to TRIS
There are two standard codes used by government, business and industry to represent information
that is used commonly throughout related industries, the Standard Industrial Classification (SIC)
code and the Dun and Bradstreet (D&B or DUNS) number. The SIC code is used to classify
business establishments by specific activities that are performed at a single physical location.
The first two digits of a four-digit SIC code define a major business sector and the last two digits
denote a facility's specialty within the major sector. The SIC Code classification system is
managed by the Office of Management and Budget. The DUNS number is a unique number
issued to businesses by Dun and Bradstreet, a large accounting and financial reporting firm.
Because the DUNS Number is a unique number, it is used in TRIS so that data from other
sources may be linked to TRIS.
Note for ad hoc users: Codes unique to TRIS are codes designated by EPA to standardize and
abbreviate TRIS data. For example, the maximum amount of the chemical on site at any time
during the calendar year (question ni.4 on Form R) is represented by codes 01-11. These codes
correspond to designated ranges of pounds described in the Reporting Package. For example,
code 01 corresponds to the range of 0-99 pounds. For more information, refer to the Toxic
Chemical Release Inventory Reporting Package.
09/03/91 3~~7TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 3 - 8 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4 MAKING TRIS WORK FOR YOU
09/03/91 4 - 1 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 4 - 2 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4 MAKING TRIS WORK FOR YOU
4.1 Reporting Package and Form R
A critical element in making the TRIS database work effectively and efficiently is an
understanding of the annual Toxic Chemical Release Inventory Reporting Package. The TRIS
database is the collection and storage of Form R data on the computer. The annual Reporting
Package contains, but is not limited to, the following:
• FormR
• Detailed instructions for preparing Form R
• Example of a properly prepared Form R
• Codes for Form R
• Common errors found on Form R reports
• Threshold determinations
• Chemical specific issues
• Policy directives
• Section 313 document request form
All users are encouraged to request the latest copy of the Reporting Package from their Regional
Section 313 Coordinator or send your request to:
Section 313 Document Distribution Center
P.O. Box 12505
Cincinnati, OH 45212
09/03/91 " 4~^3 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4.2 Defining Your Data Search
TRIS currently contains data from over 246,000 submissions, each representing one Form R, and
from more than 25,000 facilities over three (3) reporting years (1987 through 1989). Before
beginning a retrieval session on the TRIS database, you should have a definite plan in mind as
to what information you want to find and how to go about retrieving that information. The
following sections are intended to help you understand the different types of retrievals that are
available.
4.3 Different Types of Data Retrievals
In determining what type of data retrieval to perform, the user should ask how do I want to view
and/or use the information? There are three different ways to retrieve data from the TRI menu-
driven system:
• Online Searches
• Batch Reports
• Data Offload
A general overview, along with reasons for choosing each type of data retrieval, is presented in
the following sections. Detailed instructions for performing these data retrievals can be found
in Sections 5 through 7.
09/03/91 4 - 4 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4.4 Data Retrieval using the Online Queries
Online data searches are fast and display the information directly back to the screen. These are
the easiest ways to obtain data from the database if you only need a small amount of data. Some
online searches will only display a maximum of 100 facilities or submissions. In these cases you
are requested to narrow the search by supplying additional selection criteria. As discussed in
Section 1, an extensive Help feature is available which displays detailed instructions or presents
"pick lists" wherever the user needs to enter search criteria. A full discussion of online queries
comprise Section 5 of this manual.
The general circumstances for using an online search include:
• Search and display data for a specific facility
• Search and display data for a specific submission (i.e., chemical) from a facility
• Search and display data for facilities or submissions that use a specific chemical
• Compare the releases/transfers for a facility across all reporting years
• Search and display Historical Information concerning a facility
4.5 Data Retrieval using the Batch Reports
A second type of data retrieval is accomplished through batch, or offline print, reports. We
recommend that you use this method when you need a printed report or search a large volume
of data. Batch jobs run in the 'background,' meaning that once you have submitted the job, you
can continue to work on something else without having to wait for the search to be completed.
09/03/91 4 - 5 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
This will help you to keep working, rather than tying up your terminal for long periods of time
while the job is being executed or printed. This function is very similar to the online queries,
but is designed for your obtaining somewhat large volumes of information in printed format. A
full discussion of batch reports comprises Section 6 of this manual.
The general circumstances for using a batch report include:
• Search and print data for a geographic area
• Search and print data for a specific chemical
• Search and print data for a specific SIC Code
• Compare the releases/transfers for a geographic area and/or chemical across all
reporting years
• Print data concerning a specific facility
4.6 Data Retrieval using the Data Offload
The third type of data retrieval is performed using the Data Offload function. The Data Offload
was created in response to numerous user requests for "extracts" of the TRIS data. These extract
files are used by different program offices and projects to compare, analyze, and summarize TRI
data. Extract files are usually used as input to other computer software. The Data Offload
enables the user to create a customized extract file from the TRIS database. The user must first
supply geographic and/or chemical search criteria, then choose any combination of TRI data
elements. A computer program is automatically constructed and executed, transferring data onto
a mainframe sequential (extract) file.
09/03/91 4 - 6 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The Data Offload function alleviates the user from performing the following:
• Coding a NATURAL program in the TRISH ad hoc library
• Coding the corresponding Job Control Language (JCL)
• Submitting the job to execute
The extract file can then be transferred to a Personnel Computer (PC) or Local Area Network
(LAN); or used with other mainframe software. Simultaneously, a second file is generated that
can be used to define a dBASE database reflecting the extract file. A detailed report also is
produced describing the content of the extract file. A full discussion of the data offload comprise
Section 7 of this manual.
To transfer the extract file from the Mainframe to a PC, the PC used must have:
• Communications program installed
• Connection to the Mainframe
Instructions for transferring files between Mainframe and PC can be found in The Guide to NCC
Services, chapter entitled "Micro-to-Mainframe Link" (included in Appendix E).
09/03/91 4 - 7 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4.7 Helpful Hints
Obtain a copy of the Toxic Chemical Release Inventory Reporting Package and Form R, and
become familiar with the TRIS data.
Obtain a copy of The Guide to NCC Services from NCC User Support. It provides excellent
information regarding accessing the IBM ES/9000 and transferring files between mainframe and
micro computers.
Have a copy of the Information Retrieval Users Guide handy when performing searches.
Use the HELP feature throughout the menu-driven system.
Use the WILDCARD feature, *, when searching by facility name.
Use the CHEMICAL SYNONYM if you don't know the official chemical name.
Contact TRIS User Support. Their job is to assist you!
09/03/91 4 - 8 MAKING TRIS WORK FOR YOU
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5 ONLINE QUERIES
09/03/91 5 - 1 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 5 - 2 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5 ONLINE QUERIES
FUNCTION: Use the Online Queries to quickly search and display information directly on your
screen from the database. There are currently nine (9) online searches available.
Online queries are done primarily to search and display information for a specific
facility or chemical or submission (Form R). Additional queries are available to
compare releases/transfers across all years for a facility, display historical
information, and display applicable chemicals/synonyms/compounds names.
ACCESS: Select option 1 from the Data Retrieval menu. The Online Queries Menu screen
(Figure 5-1) will appear.
PGM: TRQOOOP
HAP: TRQOOOMl
TOXIC RELEASE INVENTORY SYSTEM
ONLINE QUERIES MENU
03/22/91
15:15:45
1 FACILITY NAME SEARCH
2 CITY / COUNTY SEARCH
3 CAS / CHEMICAL SEARCH
4 ALTERNATE FACILITY KEY SEARCH
5 SUBMISSION DISPLAY
6 POTW / OFF-SITE SEARCH
7 YEAR-TO-YEAR COMPARISON
8 HISTORICAL FACILITY INFORMATION
9 CHEMICAL TABLE SEARCH
10 Future Use
11 Future Use
12 Future Use
Key selection and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV RPTS
Figure 5-1
1) To select a specific search, type the CORRESPONDING NUMBER at the prompt and
press .
09/03/91
5-3
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.1 Facility Name Search
FUNCTION: Use the Facility Name Search to display information about facilities and their
submissions if you have the facility name, or some beginning portion. By
entering a facility name without the wildcard, *, you will search for an exact
match. By entering a beginning portion of name with the wildcard, *, you will
search for facilities with like names. For example:
Du Pont Antioch searches for facilities that exactly match
Du Pont* searches for facilities beginning with "Du Pont"
Note that the Reporting Year is required and only the first fifteen (15) characters of a facility
name can be entered. In addition to facility name, the search can be further limited by supplying
one or more of the following:
• EPA Region Code
• State Code
• Five digit ZIP Code
• CAS Number
• Chemical/Synonym/Compound
After a search of the database, the names of facilities that meet the search criteria are displayed
with their TRI Facility IDs and number of submissions for the applicable Reporting Year. From
this screen, the user is given several options based upon Program Function (PF) keys, to display
selected information.
09/03/91 5 - 4 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ACCESS: Select option 1 from the Online Queries menu. The Facility Name Search screen
(Figure 5-2) will appear.
PGM: TRQ01OP TOXIC RELEASE INVENTORY SYSTEM 04/02/91
MAP: TRQ010M1 FACILITY NAME SEARCH 13:50:56
REQUIRED REPORTING TEAR. ,..> 1989
FACILITY JJAME....> du pont c*
OPTIONAL REGION....>
STATE >
ZIP CODE >
CAS NUMBER >
— OR --
CHEMICAL/CATEGORY NAME >
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV RPTS
Figure 5-2
1) Type a REPORTING YEAR. This is a required field. In this example, Reporting Year
'1989' is used.
2) Type a FACILITY NAME (or range using the wildcard, *). This is a required field.
In this example, 'Du Pont C*' is used. Either upper or lower case letters can be used.
The following optional fields may be entered to narrow the search: REGION, STATE,
ZIP CODE, and CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME.
In this example, none of these optional fields have been entered. Press to
begin the search.
09/03/91 5 - 5 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search (Figure 5-3) will appear. The search criteria used are
displayed at the top of the screen. If the list is longer than one screen, press to page
backward and to page forward. In addition to the facility name, the TRI Facility ID
and the number of submissions received from the facility for that Reporting Year are displayed
on each line.
3)
PGM: TRQ010N3
MAP: TRS900MA
TOXIC RELEASE INVENTORY SYSTEM
FACILITIES
05/16/91
14:26:47
YEAR: 19B9
FACILITY NAME: DU PONT C*
MARK FACILITY NAME
TRI ID
SUBM
DU PONT CtP HEALING SPRINGS
DU PONT CSP TOLEDO
DU PONT CAMDEN PLANT
DU PONT CHAMBERS WORKS
DU PONT CHATTANOOGA SITE
DU PONT CHRISTINA LAB
DU PONT CLINTON PLANT
DU PONT COOPER RIVER SITE
DU PONT CORPUS CHRISTI PLANT
27239DPNTCRT1BO 3
43612DPNTC710MA 2
29020DPNTMPODRA 9
08023DPNTCRT130 54
37415DPNTC4501A 5
19801DPNTC501CH 1
52730DPNTCHIGHW 1
29411DPNTCCYPRE 11
78362DPNTCHIGHW 7
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QMENU RPTS -PAGE +PAGE FACIL DCNS RELTR COORD
Figure 5-3
To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The Facility Information screen
(Figure 5-4) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS900MB FACILITY INFORMATION 14:27:37
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
STREET: RT *1 BOX 102
CITY : DENTON
COUNTY: DAVIDSON
STATE : NC ZIP: 27239
MAILING NAME/ADDRESS:
NAME : SAME AS ABOVE
STREET:
CITY :
STATE : ZIP:
PRIMARY SIC CODE:
ASSIGNED DUNS : 039129697 PARENT DUNS: 001315704
ASSIGNED EPA ID : NCD000475608 PARENT CO. : OUPONT
Enter-PFl PF2 PF3 PF4
HELP MAIN PREV QMENU
09/03/91
PF5 PF6 PF7 PF8 PF9 PFlO—PFll— PFi2---
RPTS DCNS
Figure 5-4
5 - 6 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4)
5)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude / Longitude screen
(Figure 5-5) will appear. To return to the Facilities screen, press .
PGM: TRQ01ON3
MRP: TRS90OHD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
FACILITY LATITUDE : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE
EPA ASSIGNED LONGITUDE
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11—PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-5
To display the total amount of Releases and Transfers reporting by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-6) will appear.
To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MC
TOXIC RELEASE INVENTORY SYSTEM
FACILITY RELEASES AND TRANSFERS
05/16/91
14:28:25
FACILITY NAME : DU PONT CiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
These amounts are the totals
for all submissions for this
facility and Reporting Year.
RELEASES
FUGITIVE AIR 11,300
STACK AIR 32,600
HATER
UNDERGROUND
LAND
TOTAL RELEASES 43, 900
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFV PF8 PF9 PFlO-PFll—PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-6
Releases include five types: Fugitive Air, Stack Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTW) and Other Offsite Locations.
09/03/91
5-7
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6)
7)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the column labeled 'MARK,' and press . The Submissions
and Chemicals screen (Figure 5-7) will appear. To return to the Facilities screen, press
.
PGM: TRS910N TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS91OMA SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL NUM CHEMICAL NAME
X 13-89-03000421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
~i 13-89-03000423-2-NC METHANOL
Enter-PFl PFZ PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT HASTE RELTR USES
Figure 5-7
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-8) will appear. To return to the Submissions and Chemicals
screen, press .
PGM: TRS910N TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS91OMC SUBMISSION HASTE TREATMENT INFORMATION 14:29:03
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
W R03 1 90.00 / N
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV QMENU RPTS
Figure 5-8
09/03/91 5 - 8 ONLINE QUERIES
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
8)
9)
To display Waste Minimization data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Waste Minimization Information screen
(Figure 5-9) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS910N
MAP: TRS910MD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION WASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
FACILITY NAME : DO PONT C. The Submission Releases and Transfers screen (Figure
5-10) will appear. To return to the Submissions and Chemicals screen, press .
PGM: TRS910N
MAP: TRS910ME
TOXIC RELEASE INVENTORY SYSTEM 05/16/91
SUBMISSION RELEASES AND TRANSFERS 14:29:27
FACILITY 'NAMti : DO PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAUD
TOTAL RELEASES
TRANSFERS
POTS
OFF-SITE
TOTAL TRANSFER:
REPORTING FOR: AN ENTIRE FACILITY
300
3,600
3.900
Entex-PFl— '-PF2 PF3— -PF4 PF5 PF6 PF7 PF8— PF9— PF10— PF11— PF12
HELP MAIN PREV QMEtTO RPTS
Figure 5-10
09/03/91
5 - 9 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
10) To display Activity and Uses data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Activity and Uses Information screen
(Figure 5-11) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MF SUBMISSION ACTIVITY AND OSES INFORMATION 14:29:35
FACILITY NAME : DU FONT C6P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl PF2 PF3 PF4—=PF5 PF6-—PF1 PF8 PF9 PE10--PE11—PF12
HELP MAIN PREV QMENU RPTS
Figure 5-11
11) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information screen (Figure 5-12) will appear.
To return to the Submissions and Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS91OMB SUBMISSION CONTACT INFORMATION 13:28:04
FACILITY NAME : DU PONT C*P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
TECHNICAL CONTACT: G. L. RISER
PHONE: 609/540-2666
PUBLIC CONTACT: C. A. CREMEANS
PHONE: 704/8(9-4571
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PFS PF9 PF10--PF11— PF12
HELP MAIN PREV QMENU RPTS
Figure 5-12
09/03/91 5 - 10 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The following Tables show PF Keys and corresponding functions for the Facility Name Search.
Facility Name Search
Facilities Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Batch report menu
Page backward
Page forward
Facility data
DCN/chemical data
Release/transfer data
Latitude/longitude data
Screen Label
HELP
MAIN
PREV
QMENU
RPTS
-PAGE
+PAGE
FACIL
DCNS
RELTR
COORD
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-1
Facility Name Search
Submissions and Chemicals Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Contact name/phone data
Batch report menu
Page backward
Page forward
Treatment data
Waste minimization data
Release/transfer data
Activity and use data
Screen Label
HELP
MAIN
PREV
QMENU
CNTCT
RPTS
-PAGE
+PAGE
TREAT
WASTE
RELTR
USES
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF5/17
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-2
09/03/91
5-11
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.2 City / County Search
FUNCTION: Use the City / County Search to display information about facilities and their
submissions if you have the facility city or county name, or just the beginning
letter of the city / county name. If you enter an incomplete or invalid city/county
name, a pop-up window will appear listing cities or counties beginning with the
same first letter. For example, in Virginia:
Richmond searches for facilities in this city
Ricmond activates a pop-up window for all cities beginning with 'R'
You can then select the correct spelling from the window
and search for facilities in this city.
Note that the Reporting Year and State are required and only city or county can be entered, but
not both. In addition to facility city / county name, the search can be further limited by
supplying one or more of the following:
• Facility Name or range using the wildcard, *
• CAS Number
• Chemical/Synonym/Compound
After a search of the database, the names of facilities that meet the search criteria are displayed
with their TRI Facility IDs and number of submissions for the applicable Reporting Year. From
this screen, the user is given several options, based upon Program Function (PF) keys, to display
selected information.
09/03/91 5-12 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ACCESS: Select option 2 from the Online Queries menu. The City / County Search screen
(Figure 5-13) will appear.
PGM: TRQ02OP TOXIC RELEASE INVENTORY SYSTEM 04/05/91
MAP: TRQ020N1 CITY / COUNTY SEARCH 15:01:46
REQUIRED REPORTING YEAR > 1989
FACILITY STATE > NC
FACILITY CITY > --OR-- FACILITY COUNTY >
DAVIDSON
OPTIONAL FACILITY NAME >
CAS NUMBER >
—OR—•
CHEMICAL/CATEGORY....>
Key selection criteria and press
Ente r-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV RPTS
Figure 5-13
1) Type REPORTING YEAR. This is a required field. In this example, Reporting Year
'1989' is used.
2) Type STATE. This is also required. Here, 'NC' is used.
3) Type either FACILITY CITY or FACILITY COUNTY. In this example, the county
'DAVIDSON' is used.
4) To further limit your search, optional fields may be used. Use to advance to the
FACILITY NAME and CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY
NAME fields and enter the corresponding information if desired. In this example, none
of these optional fields are used. Press to begin your search.
09/03/91 5-13 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search (Figure 5-14) will appear. The search criteria appear at the
top of the screen. If the list is longer than one screen, press to page backward and
to page forward. In addition to the facility name, the TRI Facility ID and the number
of submissions received from the facility for that Reporting Year are displayed on each line.
PGM: TRQ020N2 TOXIC RELEASE INVENTORY SYSTEM 06/12/91
MAP: TRS900MA FACILITIES 15:27:26
YEAR: 1989 STATE: NC COUNTY: DAVIDSON
MARK FACILITY NAME TRI ID g SUBM
CAROLINA SEATING CO.
COBLE DAIRY PRODUCTS
COUNCILL CRAFTSMEN *1
DIXIE DINING ROOM DIV.
DIXIE FURNITURE CO. INC.
~ DIXIE FURNITURE CO.
X DU PONT C&P HEALING SPRINGS
DURACELL USA
~ FOAM TECH INC.
~ HERMAN FURNITURE CO.
27263CRLNS101LI 1
27292CBLDR707NO 2
27239CNCLBPOBOX 5
27292DXFRNNCHUR 5
27292DXFRN411SS 5
27299DXFRNOLDLI 6
27239DPNTCRT1BO 3
27292DRCLL305NE 5
27292FMTCH117CE 1
27292HKMNF37PIC 1
Enter-PFl PF2 PF3 PF4 PFS PF6— PF7 PF8 PF9---PFl'0~PFll~PET2---
HELP MAIN PREV QMENU NEXT RPTS -PAGE +PAGE FACIL DCNS RELTR COORD
Figure 5-14
5) To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The Facility Information screen
(Figure 5-15) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS900MB FACILITY INFORMATION 14:27:37
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
STREET RT 11 BOX 102
CITY DENTON
COUNTY DAVIDSON
STATE NC ZIP: 27239
MAILING NAME/ADDRESS:
NAME SAME AS ABOVE
STREET
CITY
STATE ZIP:
PRIMARY SIC CODE:
ASSIGNED DUNS : 039129697
ASSIGNED BPA ID : NCD000475608
PARENT DUNS: 001315704
PARENT CO. : DUPONT
Enter-PFi-— PF2 PF3 'PF4 — -PF5 PF6 PF7 PFB— -PF9 PFlO — PFll — PF12---
HELP MAIN PREV QMENU RPTS DCNS
09/03/91
Figure 5-15
5 - 14 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6)
7)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude / Longitude screen
(Figure 5-16) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS9DOMD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
FACILITY LATITUDE : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0600606
EPA ASSIGNED LATITUDE
EPA ASSIGNED LONGITUDE
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-16
To display the total amount of Releases and Transfers reported by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-17) will appear.
To return to the Facilities screen, press .
PGM: TRQ01ON3
MAP: TRS900MC
TOXIC RELEASE INVENTORY SYSTEM
FACILITY RELEASES AND TRANSFERS
05/16/91
14:28:25
FACILITY NAME : DU PONT CfiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
11,300
32,600
43,900
These amounts are the totals
foe all submissions for this
facility and Reporting Year.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-17
Releases include five types: Fugitive Air, Slack Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTW) and Other Offsite Locations.
09/03/91
5-15
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8)
9)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the column labeled 'MARK,' and press . The Submissions
and Chemicals screen (Figure 5-18) will appear. To return to the Facilities screen, press
.
PGM: TRS910N
MAP: TRS910MA
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL NUM
CHEMICAL NAME
13-89-03000421-8-NC
13-89-03000422-0-NC
13-89-03000423-2-NC
AMMONIA
FORMALDEHYDE
METHANOL
Enter-PFl PF2 PF3 PF4 PFS--;-PF6 PF"> PF8—PF9 PF10--PF11--PF12
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT WASTE RELTR OSES
Figure 5-18
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-19) will appear. To return to the Submissions and
Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS91OMC SUBMISSION WASTE TREATMENT INFORMATION 14:29:03
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
« R03 1 90.00 / N
Enter-PFl PF'2 PF5 PP4 PF$-~ PF6---PF7 PF8 PF9 PFlti--p1p'il--CTT3'==
HELP MAIN PREV QMENU RPTS
Figure 5-19
09/03/91 5-16 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
10) To display Waste Minimization data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Waste Minimization Information screen
(Figure 5-20) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MD SUBMISSION WASTE MINIMIZATION INFORMATION 14:29:16
FACILITY NAME : DU PONT CSP HEALING SPRINGS ' —
TRI FACILITY ID: 27239DPNTCRTIBO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION : NA
CURRENT REPORTING YEAR:
PRIOR REPORTING YEAR :
PERCENT CHANGE :
INDEX :
REASON FOR ACTION : NA
MAXIMUM AMOUNT ON SITE: 1.000 TO 9,999 LBS.
Enter-PFl PF2 PF3 PF4 PF5 PFg PF7 PF8 PF9 PFl'O— PFll— PF12---
HELP MAIN PREV QMENU RPTS
Figure 5-20
11) To display Release and Transfer data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Releases and Transfers screen (Figure
5-21) will appear. To return to the Submissions and Chemicals screen, press .
PGM: TRS910N
MAP: TRS910ME
TOXIC RELEASE INVENTORY SYSTEM 05/16/91
SUBMISSION RELEASES AND TRANSFERS 14:29:27
FACILITY NAME : DU PONT CiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
REPORTING FOR: AN ENTIRE FACILITY
300
3,600
3,900
Enter-PFl PF2---PF3 PF4 PF5 PF6 PF7 PF8 PF9 PFiO— PFll--PFl2"-~
HELP MAIN PREV QMENU RPTS
09/03/91
Figure 5-21
5-17 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
12) To display Activity and Uses data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Activity and Uses Information screen
(Figure 5-22) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MF SUBMISSION ACTIVITY AND USES INFORMATION 14:29:35
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND OSES:
ANCILLARY OR OTHER USE
Enter-PPl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QMENU RPTS
Figure 5-22
13) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information (Figure 5-23) will appear. To
return to the Submissions and Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS910MB SUBMISSION CONTACT INFORMATION 13:28:04
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
TECHNICAL CONTACT: G. L. KISER
PHONE: 609/540-2666
PUBLIC CONTACT: C. A. CREMEANS
PHONE: 704/869-4571
Enter-PFl PF2 PF3 PF4 PF5 PF6~ PF? PF8— PF9 PF10--PF11— PF12
HELP MAIN PREV QMENU RPTS
Figure 5-23
09/03/91 5 - 18 ONLINE QUERIES
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
The following Tables show PF Keys and corresponding functions for the Gty / County Search.
City / County Search
Facilities Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Batch report menu
Page backward
Page forward
Facility data
DCN/chemical data
Release/transfer data
Latitude/longitude data
Screen Label
HELP
MAIN
PREV
QMENU
RPTS
-PAGE
+PAGE
FACIL
DCNS
RELTR
COORD
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-3
City / County Search
Submissions and Chemicals Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Contact name/phone data
Batch report menu
Page backward
Page forward
Treatment data
Waste minimization data
Release/transfer data
Activity and use data
Screen Label
HELP
MAIN
PREV
QMENU
CNTCT
RPTS
-PAGE
+PAGE
TREAT
WASTE
RELTR
USES
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF5/17
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-4
09/03/91
5- 19
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.3 CAS / Chemical Search
FUNCTION: Use the CAS Number / Chemical Name Search to display information about
facilities and their submissions if you have the CAS Number(s) or the
chemical/synonym/category name(s). Leading zeroes are not necessary when
typing CAS Number(s). If you enter an incomplete or invalid
chemical/synonym/category name, a pop-up window will appear listing names that
begin with the same first letters. For example:
Formaldehyde searches for facilities releasing this chemical
Form or Form* activates a pop-up window for names starting with 'form'
You can then select the correct spelling from the window
and search for facilities with at least one submission
reporting releases for this chemical.
Note that the Reporting Year is required and only the first forty (40) characters of a
chemical/synonym/category name can be entered. In addition to CAS Number and
chemical/synonym/category name, the search can be further limited by supplying one or more
of the following:
• EPA Region Code
• State Code
• Five digit ZIP Code
After a search of the database, the names of facilities that meet the search criteria are displayed
with their TRI Facility IDs and number of submissions for the applicable Reporting Year. From
this screen, the user is given several options, based upon Program Function (PF) keys, to display
selected information.
09/03/91 5-20 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ACCESS: Select option 3 from the Online Queries menu. The CAS Number / Chemical
Name Search screen (Figure 5-24) will appear.
PGM: TRQ030P
MAP: TRQ030M1
REQUIRED
CAS NUMBER
TOXIC RELEASE INVENTORY SYSTEM
CAS NUMBER / CHEMICAL NAME SEARCH
REPORTING YEAR. ..> 1989
> — OR— CHEMICAL/CATEGORY MAME >
FORMALDEHYDE
05/13/91
13:51:06
OPTIONAL
REGION > 04
STATE > NC
— OR —
ZIP CODE..>
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10— PF11 — PF12
HELP MAIN PREV RJPTS
Figure 5-24
1) Type a REPORTING YEAR. This is a required field. In this example, Reporting Year
'1989'is used.
2) Type a CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME (or range
using the wildcard, *). One of these is required. It is not necessary to type leading zeros
in CAS Numbers. In this example, 'FORMALDEHYDE' is used. Either upper or lower
case letters can be used. The following optional fields may be entered to narrow the
search: REGION, STATE, and ZIP CODE. In this example, Region '04' and State
'NC' have been entered. Press to begin the search.
09/03/91
5-21
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search (Figure 5-25) will appear. The search criteria used are
displayed at the top of the screen. If the list is longer than one screen, press to page
backward and to page forward. In addition to the facility name, the TRI Facility ID
and the number of submissions received from the facility for that Reporting Year are displayed
on each line.
3)
PGM: TRQ03OP TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ03OM& FACILITIES 10«08:59
YEAR: 1989 REGION: 04 STATE: NC
CHEMICAL: FORMALDEHYDE
MARK FACILITY NAME (** not in alphabetical order **}
X DU PONT CSP HEALING SPRINGS
EASCO HAND TOOLS INC.
MONSANTO CO.
ICI RAYCA
CUSTOMADE CHEMICALS INC.
KOLORTEX CORP.
SYNTHRON INC.
WEYERHAEUSER CO.
WEIMAN co.
TRI ID
27239DPNTCRT1BO
28053SCHND1228I
28301MNSNTCEDAR
28120RYCCH235TU
28217CSTMD4401S
28208KLRTX290QH
28655SYNTHAMHER
28621WYRHSRT3OF
27316WMNC POBOX
» SUBM
3
11
6
8
1
3
3
1
14
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV QMENU RPTS -PAGE +PAGE FACIL DCNS RELTR COORD
Figure 5-25
To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The Facility Information screen
(Figure 5-26) will appear. To return to the Facilities screen, press .
PGM: TRQ01ON3 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS900MB FACILITY INFORMATION 14:27:37
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
STREET RT fl BOX 102
CITY DENTON
COUNTY DAVIDSON
STATE NC ZIP: 27239
MAILING NAME/ADDRESS:
NAME SAME AS ABOVE
STREET
CITY
STATE ZIP :
PRIMARY SIC CODE:
ASSIGNED DUNS : 039129697
ASSIGNED EPA ID : NCD000475608
PARENT DUNS: 001315704
PARENT CO. : DUPONT
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PF8 PF9 PF10--PF1I-- PFi2
HELP MAIN PREV QMEND RPTS DCNS
09/03/91
Figure 5-26
5 - 22 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4)
5)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude /Longitude screen
(Figure 5-27) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MD
TOXIC RELEASE INVENTOR* SYSTEM
FACILITY LATITUDE t LONGITUDE COORDINATES
05/16/91
14:23:36
FACILITY NAME : DO PONT"C'«P DEALING SPRINGS
TRI FACILITY ID: 27239DPHTCRT1BO
REPORTING YEAR: 1969
FACILITY LATITUDE : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE :
EPA ASSIGNED LONGITUDE :
Entec-PFl PF2 PF3 PF4 PF5 PFg PF? PF8 PF9 PFlO—
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-27
To display the total amount of Releases and Transfers reporting by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-28) will appear.
To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MC
TOXIC RELEASE INVENTORY SYSTEM
FACILITY RELEASES AND TRANSFERS
05/16/91
14:28:25
FACILITY NAME : DU PONT CtP HEALING SPRINGS'
TRI FACILITY ID: 27239DPNTCRT1BO
REPORTING YEAR: 1989
RELEASES
FUGITIVE AIR:
STACK AIR :
HATER :
UNDERGROUND :
LAND :
TOTAL RELEASES:
TRANSFERS
POTW :
OFF-SITE :
TOTAL TRANSFER:
11,300
32,600
43.900
These amounts are the totals
for all submissions for this
facility and reporting- year.
Enter-PFl PF2 PF3 PF4—-PF5 PF6 PF? PF8-
KELP MAIN PREV QMENU
RPTS
-PF9 PFlO—PF11—PF1J
DCNS
Figure 5-28
Releases include five types: Fugitive Air, Stack Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTW) and Other Offsite Locations.
09/03/91
5-23
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6)
7)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the column labeled 'MARK,' and press . The Submissions
and Chemicals screen (Figure 5-29) will appear. To return to the Facilities screen, press
.
PGM: TRS910N
MAP: TRS910MA
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL NUM
CHEMICAL NAME
13-89-03000421-8-NC
13-89-03000422-0-NC
13-89-03000423-2-NC
AMMONIA
FORMALDEHYDE
METHANOL
Enter-PFl PF2---PF3 PF4 PF5 PF6 PF? PFfl PFS PF16—PF11--PF12—
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT WASTE RELTR OSES
Figure 5-29
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-30) will appear. To return to the Submissions and
Chemicals screen, press .
PGM: TRS910N TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS910MC SUBMISSION WASTE TREATMENT INFORMATION
FACILITY NAME : DU PONT C£P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT
CODE METHOD INFLUENT CONG TREATMENT EFFICIENCY /NA
W R03 1 9Q.OO /
05/16/91
14:29:03
OPERATING
DATA
N
Ehter-PFl PF2 PF3 PF4 PFS PF6 PF7 PF8 PF9 PFIO--PF11--PF12
HELP MAIN PREV QMENU RPTS
Figure 5-30
09/03/91
5-24
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8) To display Waste Minimization data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Waste Minimization Information screen
(Figure 5-31) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS910N
MAP: TRS910MD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION WASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION : NA
CURRENT REPORTING YEAR:
PRIOR REPORTING YEAR :
PERCENT CHANGE :
INDEX :
REASON FOR ACTION : NA
MAXIMUM AMOUNT ON SITE: 1,000 TO 9,999 LBS.
Entec-PFl PFZ PF3 PF. The Submission Releases and Transfers screen (Figure
5-32) will appear. To return to the Submissions and Chemicals screen, press .
PGM: TRS910N
MAP: TRS91OME
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION RELEASES AND TRANSFERS
05/16/91
14:29:27
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE :
TOTAL TRANSFER:
300
3,600
3,900
REPORTING FOR: AN ENTIRE FACILITY
Enter-PFl PFZ PF3 PF4 PF5 PF6 PF7 PF8 PF9 PFlO—PFil—PF12
HELP MAIN PREV QMENU RPTS
Figure 5-32
09/03/91
5-25
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
10) To display Activity and Uses data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Activity and Uses Information screen
(Figure 5-33) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS910N
MAP: TRS910MF
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
FACILITY NAME : DO PONT C&F HEALING SPRINGS
TRI FACILITY ID: 27239DPMTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl— -PF2 PF3 PF4—-PF5 PF6---PF7 PF8 PF9 PF10—PF11—PFI2
HELP MAIN PREV QMENU RPTS
Figure 5-33
11) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information screen (Figure 5-34) will appear.
To return to the Submissions and Chemicals screen, press .
PGM: TRS910N
MAP: TRS910MB
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION CONTACT INFORMATION
06/14/91
13:28:04
FACILITY NAME : DU FONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL HUH: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
TECHNICAL CONTACT: G. L. KISER
PHONE: 609/540-2666
PUBLIC CONTACT: C. A. CREMEANS
PHONE: 704/869-4571
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFT—-PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV QMENU RPTS
Figure 5-34
09/03/91
5-26
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The following Tables show PF Keys and corresponding functions for the CAS / Chemical Search.
CAS / Chemical Search
Facilities Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Batch report menu
Page backward
Page forward
Facility data
DCN/chemical data
Release/transfer data
Latitude/ longitude data
Screen Label
HELP
MAIN
PREV
QMENU
RPTS
-PAGE
+PAGE
FACIL
DCNS
RELTR
COORD
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-5
CAS / Chemical Search
Submissions and Chemicals Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Contact name/phone data
Batch report menu
Page backward
Page forward
Treatment data
Waste minimization data
Release/transfer data
Activity and use data
Screen Label
HELP
MAIN
PREV
QMENU
CNTCT
RPTS
-PAGE
+PAGE
TREAT
WASTE
RELTR
USES
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF5/17
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-6
09/03/91
5-27
ONLINE QUERIES
-------
IRIS INFORMATION RETRIEVAL USERS GUIDE
5.4 Alternate Facility Key Search
FUNCTION: Use the Alternate Facility Key Search to display information about facilities and
their submissions if you do not have the facility name but have one or more of the
following identifying criteria:
• TRI Facility ID
• DUNS Number
• EPA ID
• Document Control Number (DCN)
• Parent Company DUNS Number
• Parent Company Name
Note that the Reporting Year is required for each selection. In addition to items listed above,
the search can be further limited by supplying one of the following:
• CAS Number
• Chemical/Synonym/Compound
After a search of the database, the names of facilities that meet the search criteria are displayed
with their TRI Facility IDs and number of submissions for the applicable Reporting Year. From
this screen, the user is given several options, based upon Program Function (PF) keys, to display
selected information.
ACCESS: Select option 4 from the Online Queries menu. The Facility Key Search screen
(Figure 5-35) will appear.
09/03/91 5-28 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type 1 to select TRI Facility ID from the Facility Key Search Selection menu (Figure
5-35). Press . In this example, TRI Facility ID is used.
PGM: TRQ040P TOXIC RELEASE INVENTORY SYSTEM 06/13/91
HAP: TRQ040M1 FACILITY KEY SEARCH SELECTION 14:52:45
1 TRI FACILITY ID
2 DUNS NUMBER
3 EPA ID
4 DOCUMENT CONTROL NUMBER
5 PARENT DUNS NUMBER
6 PARENT COMPANY NAME
Key selection and press ==™>
Enter-PFl PFZ PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV RPTS
Figure 5-35
2) Type a REPORTING YEAR. This is a required field. In this example, '1989* is used.
3) Type a TRI FACILITY ID. This is also required. Here '27239DPNTCRT1BO' is used.
Upper or lower case letters can be used. The following optional fields may be used to
narrow the search: a CAS NUMBER or a CHEMICAL/SYNONYM/CATEGORY
NAME. In this example (Figure 5-36), none of these optional fields are used. Press
to begin the search.
PGM: TRQ010P1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ040H2 FACILITY KEY SEARCH BY TRI FACILITY ID 14:53:07
REQUIRED
REPORTING YEAR > 1989
TRI FACILITY ID > 27239DPNTCRT1BO
OPTIONAL
CAS DUMBER.. ..>
—OR—
CHEMICAL/CATEGORY NAME >
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10— PF11— PF12--
HELP MAIN PREV RPTS
Figure 5-36
09/03/91 5 - 29 ONLINE QUERIES
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search criteria (Figure 5-37) will appear. The search criteria used
are displayed at the top of the screen. If the list is longer than one screen, press to
page backward and to page forward. In addition to the facility name, the TRI Facility
ID and the number of submissions received from the facility for that Reporting Year are
displayed on each line.
PGM: TRQ040P1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRS900MA FACILITIES 14:54:15
YEAR:1989TRI FACILITY ID:27239DPNTCRT1BO™"
MARK FACILITY NAME TRI ID I SUBM
X DU PONT C*P HEALING SPRINGS 27239DPNICRT1BO 3
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9-—-PF16—PFll~PFl2
HELP MAIN PREV QMENU RPTS FACIL DCNS RELTR COORD
Figure 5-37
4) To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The Facility Information screen
(Figure 5-38) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS900MB FACILITY INFORMATION 14:27:37
FACILITY NAME : DU PONT C&P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
STREET RT #1 BOX 102
CITY DENTON
COUNTY DAVIDSON
STATE NC ZIP: 27239
MAILING NAME /ADDRESS:
NAME SAME AS ABOVE
STREET
CITY
STATE ZIP :
PRIMARY SIC CODE:
ASSIGNED DUNS : 039129697
ASSIGNED EPA ID : NCD000475608
PARENT DUNS: 001315704
PARENT CO. : DUPONT
Enter-PFl PF2 PF3 PF4 PF5 PF6— PF7 PFfl PFJ PFl6--PFll--PF12'---
HELP MAIN PREV QMENU RPTS DCNS
09/03/91
Figure 5-38
5 - 30 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5)
6)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude / Longitude screen
(Figure 5-39) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
FACILITY LATITUDE : 40353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE :
EPA ASSIGNED LONGITUDE :
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-39
To display the total amount of Releases and Transfers reported by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-40) will appear.
To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MC
TOXIC RELEASE INVENTORY SYSTEM
FACILITY RELEASES AND TRANSFERS
05/16/91
14:28:25
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
RELEASES
FUGITIVE AIR:
STACK AIR :
WATER :
UNDERGROUND :
LAND :
TOTAL RELEASES:
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
11,300
32,600
43,900
These amounts are the totals
for all submissions for this
facility and reporting year.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PFI1--PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-40
Releases include five types: Fugitive Air, Stack Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTW) and Other Offsite Locations.
09/03/91
5-31
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7)
8)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the 'MARK' column, and press . The Submissions and
Chemicals screen (Figure 5-41) will appear. To return to the Facilities screen, press
.
PGM: TRS91ON
MAP: TRS910KA
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSIONS AMD CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU POM Cst HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRTXBO REPORTING YEAR: 1989
MARK DOC CNTL HUM
CHEMICAL NAME
13-89-D3000421-8-NC
13-89-03000422-0-NC
13-89-03000423-2-NC
AMMONIA
FORMALDEHYDE
METHANOL
Enter-PFl---PF2 PF3 PF4 PF5 PF6—PF1? PFB---BFS PFlO—PF11--PF12
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT WASTE RELTR OSES
Figure 5-41
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-42) will appear. To return to the Submissions and
Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS910KC SUBMISSION WASTE TREATMENT INFORMATION
FACILITY NAME : DU PiNl CtP HEAL'lNG SPRINGS '
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR:
DOC CNTL
1989
05/16/91
14:29:03
NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1
WASTESTREAM
CODE
W
Enter-PFl-
HELP
TREATMENT
METHOD
R03
— PF2 PF3—
MAIN PREV
RANGE OF SEQUENTIAL
INFLUENT CONC TREATMENT
1
OF 1
TREATMENT
OPERATING
EFFICIENCX/NA DATA
90.00 /
— PF4 PF5 PF6 PF7 PF8 PF9 EF10—
QMENl) RPTS
N
-PF11--PF12
Figure 5-42
09/03/91
5-32
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9)
To display Waste Minimization data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Waste Minimization Information screen
(Figure 5-43) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS910N
MAP: TRS910MD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 21239DPNTCRT1BQ REPORTING YEAR: 1.989
DOC CNTL NUM: 13-89-03000421-B-NC
CHEMICAL NAME: AMMONIA
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION NA
CURRENT REPORTING YEAR
PRIOR REPORTING YEAR
PERCENT CHANGE
INDEX
REASON FOR ACTION
MAXIMUM AMOUNT ON SITE: 1,000 TO 9,999 LBS.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PF8 PF9 BFlO-BFtt— gFl2-—
HELP MAIN PREV QMENU RPTS
Figure 5-43
10) To display Release and Transfer data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Releases and Transfers screen (Figure
5-44) will appear. To return to the Submissions and Chemicals screen, press .
PGM: TRS910N
MAP: TRS910MB
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION RELEASES AND TRANSFERS
05/16/91
14:29:27
FACILITY NAME : OU gONt CSP KBALtNG SPRIGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES REPORTING FOR: AN ENTIRE FACILITY
FUGITIVE AIR 300
STACK AIR 3, 600
WATER
UNDERGROUND
LAND
TOTAL RELEASES 3,900
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PFfl PF9 PFlO—PFll—PF12-
KELP MAIN PREV QMENU RPTS
Figure 5-44
09/03/91
5-33
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
11) To display Activity and Uses data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Activity and Uses Information screen
(Figure 5-45) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS910N TOXIC RELEASE INVENTOR? SYSTEM 05/16/91
MAP: TRS910MF SUBMISSION ACTIVITY AND USES INFORMATION 14:29:35
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL MUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFV PF8 PF9 PFlO^PFll—PF12
HELP MAIN PREV QMENU RPTS
Figure 5-45
12) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information screen (Figure 5-46) will appear.
To return to the Submissions and Chemicals screen, press .
PGM: TRS910N TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS910MB SUBMISSION CONTACT INFORMATION 13:28:04
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
TECHNICAL CONTACT: G. L. KISER
PHONE: £09/540-2666
PUBLIC CONTACT: C. A. CREMEANS
PHONE: 704/969-4571
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV QMENU RPTS
Figure 5-46
09/03/91 S - 34 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The following Tables show PF Keys and corresponding functions for the Alternate Facility Key
Search.
Alternate Facility Key Search
Facilities Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Batch report menu
Page backward
Page forward
Facility data
DCN/chemical data
Release/transfer data
Latitude/longitude data
Screen Label
HELP
MAIN
PREV
QMENU
RPTS
-PAGE
+PAGE
FACIL
DCNS
RELTR
COORD
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-7
Alternate Facility Key Search
Submissions and Chemicals Screen
Function/Data
System HELP
Main Menu
Previous Screen
Online query menu
Contact name/phone data
Batch report menu
Page backward
Page forward
Treatment data
Waste minimization data
Release/transfer data
Activity and use data
Screen Label
HELP
MAIN
PREV
QMENU
CNTCT
RPTS
-PAGE
+PAGE
TREAT
WASTE
RELTR
USES
PF Key
PF1/13
PF2/14
PF3/15
PF4/16
PF5/17
PF6/18
PF7/19
PF8/20
PF9/21
PF10/22
PF11/23
PF12/24
Table 5-8
09/03/91
5-35
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.5 Submission Display
FUNCTION: Use the Submission Display to display information submitted on an individual
Form R. You can search the database if you have one of the following identifying
criteria:
• TRI Facility ID
• DUNS Number
• EPA ID
• Document Control Number (DCN)
• Facility Name or range using wildcard, *
• Parent Company DUNS Number
• Parent Company Name or range using the wildcard, *
Note that the Reporting Year is required for each selection. In addition to items listed above,
the search can be further limited by supplying one of the following:
• CAS Number
• Chemical/Synonym/Compound
After a search of the database, a series of screens are presented that display all the information
from the Form Rs for the applicable Reporting Year. The user may skip to the next Form R in
a series at any screen.
ACCESS: Select option 5 from the Online Queries menu. The Submission Display Selection
screen (Figure 5-47) will appear.
09/03/91 5-36 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type 1 to select TRI Facility ID from the Submission Display Selection menu (Figure
5-47). In this example, TRI Facility ID is used.
PGM: TRQ050P TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ05OM1 SUBMISSION DISPLAY SELECTION 14:55:04
1
2
3
4
5
6
7
TRI FACILITY ID
DUNS NUMBER
EPA ID
DOCUMENT CONTROL NUMBER
FACILITY NAME
PARENT DUNS NUMBER
PARENT COMPANY NAME
Key selection and press — => _
Enter-PFl PF2 PF3 PF4 —
HELP MAIN PREV
-PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
RPTS
Figure 5-47
2) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
3) Type a TRI FACILITY ID. This is also required. Here '27239DPNTCRT1BO' is used.
Upper or lower case letters can be used. The following optional fields may be used to
narrow the search: a CAS NUMBER or a CHEMICAL/SYNONYM/CATEGORY
NAME. In this example (Figure 5-48), none of these optional fields are used. Press
to begin the search.
PGM: TRQ050P1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ050M2 SUBMISSION DISPLAY BY TRI FACILITY ID 14:55:18
REQUIRED
REPORTING YEAR > 1989
TRI FACILITY ID > 27239DPNTCRT1BO
OPTIONAL
CAS NUMBER >
— OR—
CHEMICAL/CATEGORY NAME. . . .>
Key selection criteria and pcess
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF0 PF9 PF10 — PF11 — PF12
HELP MAIN PREV RPTS
Figure 5-48
09/03/91 5 - 37 ONLINE QUERIES
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
The number of submissions found that meet the search criteria will appear. The Reporting Year
selected for this search is displayed at the top of the screen (Figure 5-49). The TRI Facility ID
entered is also displayed.
4)
PGM: TRQ05OP1
MAP: THQ050M9
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION DISPLAY
06/13/91
14:55:42
REPORTING YEAR: 1989
3 SUBMISSION(S) FOUND FOR TRI FACILITY ID 27239DPNTCRT13O
Press to view query
OR
Press the appropriate PF key
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11—PF12
CONT HELP MAIN PREV RETS
Figure 5-49
Press to continue to the next screen (Figure 5-50) to view information about
these submissions. To view information about the next submission, press .
PGM: TRQ050N1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ050MB SUBMISSION DISPLAY 14:55:56
REGION: 04 TRI FACILITY ID: 27239DPNTCRT1BO
NAME : Dti PONT CfiP HEALING SPRINGS
STREET: RT *1 BOX 102
CITY : DENTON
COUNTY: DAVIDSON
STATE : NC 2IP: 27239-
DOCUMENT CONTROL NUMBER 13-89-03000421-8-NC
RPTG FOR ENTIRE FACILITY A (AN ENTIRE COVERED FACILITY)
MAXIMUM AMOUNT CODE 03 (1,000—9,999)
CAS NUMBER 007664-41-7
CHEMICAL NAME AMMONIA
CERTIFICATION NAME C. A. CREMEANS
CERTIFICATION TITLE PLANT MANAGER
CERTIFICATION DATE SIGNED 04/19/90
SUBM; 1 OF 3 TRJID: 27239DPNTCRT1BO / DCN: 13-89-03000421-8-NC
Enter-PFl J?F2 PF3 SF4 PF5 PF6 PF7— PF8 PF9 PF1.0--PF11— PF12
CONT HELP MAIN PREV - NEXT RPTS
Figure 5-50
09/03/91 5 - 38 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
If is pressed, the second screen (Figure 5-51) for this submission will appear. The
number of screens depends on the amount of information for each submission. Continue to press
to view all data for the submission.
PGM: TRQ05ON1
MAP: TRQ05OMC
TOXIC RELEASE INVENTOR* SYSTEM
SUBMISSION DISPLAY
06/13/91
14:56:08
ASSIGNED DUNS NUMBER
ASSIGNED EPA ID
STATE/COUNTS FIPS CODE
ASSIGNED CEKTROID LATITUDE
ASSIGNED CENTROID LONGITUDE
LATITUDE
LONGITUDE
PARENT COMPANY NAME
PARENT DUNS NUMBER
TECHNICAL CONTACT NAME
TECHNICAL CONTACT PHONE
PUBLIC CONTACT NAME
PUBLIC CONTACT PHONE
UIC ID
MIXTURE COMPONENT ID
039129697
NCD000475608
37057
+0353800
-0800606
+0353645
-0601036
DUPONT
001315704
G. L. RISER
(609) 540-2666
C. A. CREMEANS
<704) 869-4571
NA
SUBM: 1 OF 3
IRIID: 27239DPNTCRT1BO / DCN: 13-89-03000421-8-NC
Enter-PFl—-PF2 PF3—PF4 PF5 PF6 PF7—^P
CONT HELP MAIN PREV NEXT RPTS
3 PF9 PF10—PFll—PF12
Figure 5-51
The Table below shows PF Keys and corresponding functions for the Submission Display.
Submission Display
Function/Data
Continue or page forward
System HELP
Main Menu
Previous Screen
Skip to next submission
Batch report menu
Screen Label
CONT
HELP
MAIN
PREV
NEXT
RPTS
PF Key
ENTER
PF1/13
PF2/14
PF3/15
PF5/17
PF6/18
Table 5-9
09/03/91
5-39
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.6 POTW / Offsite Search
FUNCTION: Use the POTW / Offsite Search to display information about Publicly Owned
Treatment Works or Offsite disposal locations. You can search using the
following criteria:
« POTW / Offsite ID
• POTW / Offsite Name or range using wildcard, *
• POTW / Offsite City or County
• POTW / Offsite ZIP Code
Note that the Reporting Year is required for each selection. When using the POTW / Offsite
City / County or POTW / Offsite ZIP Code selections, the search can be further limited by
supplying POTW / Offsite Name or range using wildcard, *.
After a search of the database a series of screens are presented which display the following:
• POTW / Offsite Name and Address
POTW / Offsite ID
• CAS Number
• Document Control Number
ACCESS: Select option 6 from the Online Queries menu. The POTW / Offsite Search
screen (Figure 5-52) will appear.
09/03/91 5 - 40 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type 2 to select the POTW / Offsite Facility Name Search from the POTW / Offsite
Search menu (Figure 5-52).
PGM: TRQ06OP TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ06OH1 POTW / OFFSITE SEARCH 14:56:32
1 POTW / OPFSITE ID
2 POTW / OFFSITE FACILITY NAME
3 POTW / OFFSITE CITY / COUNTY
4 POTW / OFFSITE ZIP CODE
Key selection and press ===> _
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV RPTS
Figure 5-52
2) Type a REPORTING YEAR. This field is required. Reporting Year '1989' is used.
3) Type a POTW / OFFSITE FACILITY NAME (or range using the wildcard, *). This
is also required. Press to begin the search. In this example (Figure 5-53),
'Richmond*' is used. Upper or lower case letters can be used. There are no other
optional fields available to narrow the search.
PGM: TRQ060P1 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ060M2 POTW / OFFSITE SEARCH BY FACILITY ID
REQUIRED
REPORTING YEAR > 1989
POTW / OFFSITE FACILITY ID..> RICHMOND*
Key selection criteria and press
06/13/91
14:56:40
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV RPTS
Figure 5-53
09/03/91 5 - 41 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The
701
number of submissions found that meet the search (Figure 5-54) will appear. The POTW
ffsite Facility Name selected for this search is also displayed.
PGM: TRQ06OP2 TOXIC RELEASE INVENTORY SYSTEM 06/1-3/91
MAP: TRQ06OM6 POTW / OPFSITE FACILITY SEARCH 14:57:49
73 POTW / OFFSITE RECORD (S) FOUND FOR NAME RICHMOND*
Press to view
or
Press appropriate PF Key
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
CONT HELP MAIN PREV RPTS
Figure 5-54
4) To view detailed information about the POTW / Offsite Facility submissions, press
. Two submissions (Figure 5-55) are displayed per screen.
PGM: TR0060P2
MAP: IRQ06OMB
TOXIC RELEASE INVENTORY SYSTEM
POTW/OFFSITE FACILITY SEARCH
06/13/91
14:58:01
POTW/OFFSITE NAME: RICHMOND CITY LANDFILL
ADDRESS: BOX ANGLE RD. (P.O. BOX 250)
RICHMOND KY 40475
TRANSFER OFF-SITE ID: 40475RCHMNBOXAN
CAS NUMBER: NA - -
DOC CONTROL NUM: 13-89-03534443-9-KY
1 OF 73
POTW/OFFSITE NAME: RICHMOND CITY LANDFILL
ADDRESS: BOX ANGLE RD. (P.O. BOX 250)
RICHMOND KY 40475
TRANSFER OFF-SITE ID: 4047SRCHMNBOXAN
CAS NUMBER: 007664-93-9
DOC CONTROL NUM: 13-89-03541144-4-KY
2 OF 73
Enter-PFl --- PFS --- PF3 --- PF4 --- PF5 --- PF6---PF7 --- PF8— PF& --- PFlO— PFlT— PF12 ---
CONT HELP MAIN PREV RPTS
Figure 5-55
09/03/91
5-42
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The Table below shows PF Keys and corresponding functions for the POTW / Offsite Search.
POTW / Offsite Search
Function /Data
Continue on page forward
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
CONT
HELP
MAIN
PREV
RPTS
pr Key
ENTER
PF1/13
PF2/14
PF3/15
PF6/18
Table 5-10
09/03/91
5-43
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.7 Year-to-Year Release / Transfer Comparison
FUNCTION: Use the Year-to-Year Release / Transfer Comparison to display release/transfer
information from facilities if you have the TRI Facility ID or the Facility Name
(or range using the wildcard, *). You can search on one specific chemical by
entering either the chemical/category/synonym name or CAS Number, or you may
view all the chemicals for a facility.
ACCESS: Select option 7 from the Online Queries menu. The Year-to-Year Release /
Transfer Comparison screen (Figure 5-56) will appear.
PGM: TRQ070P TOXIC RELEASE INVENTORY SYSTEM 03/27/91
MAP: TRQ07OM1 YEAR-TO-YEAR RELEASE / TRANSFER COMPARISON 10:54:34
REQUIRED
OPTIONAL
TRI FACILITY ID....> 25143MNSNT1MONS
— OR--
FACILITY NAME >
INCLUDE DELI5TED CHEMICALS: Y
CAS NUMBER >
— OR--
CHEMICAL/CATEGORY NAME >
Key selection criteria and press
(Y/N)
Enter-PPl — PF2 — PF3 — PF4 — PF5 — PF6 — PF7 — PF8 — PF9 — PF10--PF11 — PF12
HELP MAIN PREV RPTS
Figure 5-56
1) Type either the TRI FACILITY ID or the FACILITY NAME. One field is required.
In this example (Figure 5-56), TRI Facility ID '25143MNSNT1MONS' is used. Upper
or lower case letters can be used.
2) Type Y to include delisted chemicals in your search or N to exclude them.
3) To further limit your search, include a CAS NUMBER or a
CHEMICAL/SYNONYM/CATEGORY NAME. In this example, neither of these
optional fields have been entered. Press to begin your search.
09/03/91 5-44 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Year-to-Year Release / Transfer information (Figure 5-57) will appear for the TRI Facility ID
selected.
PGM: TRQ07OP
HAP: TRQ07OM2
TOXIC RELEASE INVENTORY SYSTEM
YEAR-TO-YEAR RELEASE /TRANSFER COMPARISON
06/13/91
17:49:28
TRIFID: 25143MNSNT1MONS ADDRESS: 1 MONSANTO RD.
NAME: MONSANTO CO. NITRO HV 25143
* History records exist - may be different name for a previous year *
CHEMICAL: ALL CHEMICALS INCLUDING DELZSTED CHEMICALS
1987 1988 1989 1990
* OF SUBMISSIONS 20 19 17 0
FUGITIVE AIR
STACK AIR
WATER
UNDERGROUND
LAND
REL TOTALS
POTW
OFF-SITE
TRANS TOTALS
507400
100500
57100
0
16350
681350
0
67000
67000
509600
118517
434350
0
16150
1078617
0
66800
66800
501700
196775
432250
0
1950
1132675
0
14000
14000
0
0
0
0
0
0
0
0
0
1991
0
0
0
0
0
0
0
0
0
0
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV RPTS
Figure 5-57
4) To end your search, press or .
The Table below shows PF Keys and corresponding functions for the Year-to-Year Release /
Transfer Comparison.
Year-to-Year Release / Transfer Comparison
Function/Data
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
HELP
MAIN
PREV
RPTS
PF Key
PF1/13
PF2/14
PF3/15
PF6/18
Table 5-11
09/03/91
5-45
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.8 Historical Facility Information Search
FUNCTION: Use the Historical Facility Information Search to display historical information
about a facility. Historical data includes Facility Name and Address, Parent
Company DUNS Number, and Parent Company Name. You can search using the
following identifying criteria:
• TRI Facility ID
• Historical Facility Name or range using wildcard, #
• Historical City / County
• Historical Region / State / ZIP Code
• Historical Parent DUNS Number
• Historical Parent Company Name or range using wildcard, *
Note that the Reporting Year is required. After a search of the database, a series of screens will
be presented that display current facility data on the left-hand side and historical facility data on
the right-hand side.
ACCESS: Select option 8 from the Online Queries menu. The Historical Facility
Information Search screen (Figure 5-58) will appear.
09/03/91 5 - 46 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) To search the database by Historical Facility Name, type 2 from the Historical Facility
Information Search menu (Figure 5-58). Press .
PGM: TRQ080P TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ080M1 HISTORICAL FACILITY INFORMATION SEARCH 14:59:48
1 TRI FACILITY ID
2 HISTORICAL FACILITY NAME
3 HISTORICAL CITY / COUNTY
4 HISTORICAL REGION / STATE / ZIP CODE
5 HISTORICAL PARENT DUNS NUMBER
6 HISTORICAL PARENT COMPANY NAME
Key selection and press ===> 2
Enter-PFl—- PF2 PF3 PF4---PF5 PF6---PF?—- PF8 PF9---PF10-- PFll— PF12
HELP MAIN PREV RPTS
Figure 5-58
2) Type a REPORTING YEAR. This is a required field. Reporting Year '1988' is used.
3) Type a HISTORICAL FACILITY NAME (or range using the wildcard, *). This is also
required. Press to begin the search. In this example (Figure 5-59), 'KEE*'
is used. Upper or lower case letters can be used. There are no other optional fields
available to narrow the search.
PGM:
MAP:
TRQ08ON2 TOXIC RELEASE INVENTORY SYSTEM
TRQ080M3 HISTORY SEARCH BY FACILITY NAME
06/13/91
15:00:29
REQUIRED
REPORTING YEAR > 1988
HISTORICAL FACILITY NAME > KEE*
Enter
Key selection criteria and press
-PFl PF2 PP3 PF4 PF5---PF6 PF7---PF6 PF9 PFlO— PFll--P.Fl2=
HELP MAIN PREV PPTS
Figure 5-59
09/03/91 5 - 47 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search and their TRI Facility ED (Figure 5-60) will appear. The
search criteria used are displayed at the top of the screen. If the list is longer than one screen,
press to page backward and to page forward.
PGM: TRS03ON TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS030M1 HISTORY FACILITY NAME SELECTION SCREEN 13:19:39
NAME: KEE*
MARK FACILITY NAME TRI FACILITY ID
KEELER BRASS AUTOMOTIVE 49502KLRBR236ST
~ KEELER BRASS AUTOMOTIVE 49508KLRBR29293
_ KEELER BRASS CO. 49503KLRBR9S5GO
X KEENE CORP. 19701KNCRP1100G
KEESHAN & BOST CHEMICAL CO. INC. 77578KSHNB2210JJ
Enter-PFl PF2 PF3 PF4—PF5 PF6 PF7 PF8 PF* PFlO--PFl1i--PFT2---
HELP MAIN PREV RPTS -PAGE SELCT
Figure 5-60
4) To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The number of history records
found that meet the search and the Facility Name (Figure 5-61) will appear. To return
to the Historical Facility Name screen, press .
PGM: TRQ080N2 TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRQ080M8 HISTORICAL FACILITY SEARCH 13:20:50
1 HISTORY RECORD to view
or
Press appropriate PF Key
Enter-PFl— — PF2 PF3 PF4 PF5 PF6 PF? PF8 PF9 PFlO--PFll--PFl'2
HELP MAIN PREV RPTS
Figure 5-61
09/03/91 5 - 48 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5) To view detailed information about the Historical Facility submissions, press .
Current facility information is displayed on the left and Historical information on the right
(Figure 5-62).
PGM: TRQ08ON9
HAP: TRQ080MB
TOXIC RELEASE INVENTORY SYSTEM
HISTORICAL FACILITY SEARCH
06/14/91
13:20:58
CURRENT
HISTORICAL
19701KNCRP1100G
AHLON INC.
1100 GOVERNOR LEA RD.
REPORTING YEAR: 1988
JTRI FACIL ID:
:FACILITY NAME: KEENE CORP.
:ADDRESS: 1100 GOVERNOR LEA RD.
BEAR
NEW CASTLE
BAIRNCO CORP.
016288621
REASON FOR CHANGE:
DE 19701 :CITY/ST/ZIP:
: COUNTY :
:PARENT NAME:
:PARENT DUNS:
BEAR
NEW CASTLE
BAIRNCO CORP.
016288621
Press to continue
DE 19701
OP 1
Enter-PFl—-PF2 PF3 PFi—-PF5-—PF6r^-PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV RPTS
Figure 5-62
6)
Press to view all available data.
The Table below shows PF Keys and corresponding functions for the Historical Facility Search.
Historical Facility Search
Function/Data
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
HELP
MAIN
PREV
RPTS
PF Key
PF1/13
PF2/14
PF3/15
PF6/18
Table 5-12
09/03/91
5-49
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.9 Chemical Table Search
FUNCTION: Use the Chemical Table Search to display information about Chemical, Synonym,
and Category names from the TRI Chemical Table. This search does not examine
actual submissions. By entering a name without the wildcard, *, you will search
for an exact match. By entering a beginning portion of name with the wildcard,
*, you will search for chemicals wu,. .ike names. For example:
Formaldehyde searches the table only for this chemical name
Form* searches for all chemical/synonym/category names starting
with 'form'
After a search of the database, the names of chemicals, synonyms, and categories that meet the
search criteria are displayed with their CAS Numbers.
ACCESS: Select option 9 from the Online Queries menu. The Chemical Table Search
screen (Figure 5-63) will appear.
09/03/91 5 - 50 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1)
Type a CHEMICAL or CATEGORY or SYNONYM NAME (or range using the
wildcard, *). This is a required field. In this example (Figure 5-63), 'FORM*' is used.
Press to begin the search. There are no other optional fields available to
narrow the search.
PGM: IRQ090P
MAP: TRQ09OM1
TOXIC RELEASE INVENTORY SYSTEM
CHEMICAL TABLE SEARCH
06/14/91
13:21:28
REQUIRED
CHEMICAL or CATEGORY or SYNONYM...> FORM*
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PF8 PF$ PFlO— PFll— PF12
HELP MAIN PREV RPTS
Figure 5-63
A detailed Chemical/Synonym/Category listing that meets the search criteria (Figure 5-64) will
appear. If the list is longer than one screen, press to page backward and
to page forward. In addition to the Chemical/Synonym/Category name, the CAS Number is
displayed on each line. To return to the Chemical Table Search screen, press .
PGM: TRQ09OP TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ09OM2 CHEMICAL TABLE SEARCH
CHEMICAL 1 CATEGORY / SYNONYM
xc 9»c ant amoE 33 w aasc wee »w ra-se son se -at save swocgaseso -at
FORMALDEHYDE
FORMALDEHYDE SOLUTION
FORMALIN
FORMALINE BLACK C
FORMIC ACID, CHLORO-, ETHYL ESTER
FORMIC ALDEHYDE
FORMIC BLACK C
FORMIC BLACK CW
FORMIC BLACK EA
06/14/91
13:21:41
CAS NUMBER
sp'o; sa-a awt aaae aea
000050-00-0
000050-00-0
000050-00-0
000050-00-0
001937-37-7
000050-00-0
000541-41-3
000050-00-0
000074-90-8
001937-37-7
001937-37-7
001937-37-7
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7-— • -PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV RPTS -PAGE +PAGE
Figure 5-64
09/03/91 5 - 51
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The Table below shows PF Keys and corresponding functions for the Chemical Table Search.
Chemical Table Search
Function/Data
System HELP
Main Menu
Previous Screen
Batch report menu
Page backward
Page forward
Screen Label
HELP
MAIN
PREV
RPTS
-PAGE
+PAGE
PF Key
PF1/13
PF2/14
PF3/15
PF6/18
PF7/19
PF8/20
Table 5-13
09/03/91
5-52
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6 BATCH REPORTS
09/03/91 6 - 1 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 6 - 2 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6 BATCH REPORTS
FUNCTION: Use the Batch Reports to search and send information from the database to a
printer attached to the IBM ES/9000. There are currently seven (7) reports
available. Batch reports are done primarily to search for and print information for
a geographic area, SIC codes, specific chemicals, and facilities. Additional reports
are available to compare releases/transfers across all years for a facility or
geographic area and display data applicable to POTW and Off-site locations. In
addition, there are 113 reports available through the SAS Reports menu.
ACCESS: Select option 2 from the Data Retrieval menu.
1) To select a specific report, type the CORRESPONDING NUMBER at the Batch Report
menu (Figure 6-1), and press .
PGM: TRROOOP TOXIC RELEASE INVENTORY SYSTEM 10/18/91
MAP: TRROOOMO BATCH REPORT MENU 12:36:40
1 GEOGRAPHIC / CHEMICAL PROFILE REPORT 7 YEAR-TO-YEAR COMPARISON REPORT
2 POTW / OFF-SITE LOCATION REPORT 8 SAS REPORTS MENU
3 FACILITY PROFILE REPORT 9 Future use
4 FORM R FACSIMILE REPORT 10 Future use
5 REGIONAL TRIS SUBMISSIONS REPORT 11 Future use
6 CHEMICAL/GEOGRAPHIC/SIC CODE REPORT 12 CHANGE BATCH REPORT PROFILE
Key selection and press ===>
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PFfl PF9 PFlO—PFll—PFlS
HELP MAIN PREV QUERY
Figure 6-1
11/18/91 6-3 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.1 Controlling Where and When Reports Print
FUNCTION: The TRIS user must decide where and when reports print when generating the
information. This is done by setting report printing parameters. The Batch Report
Profile screen controls the printing report parameters. Use it to control the
account, time, priority, output destination, and number of copies for the report
selected from the Report Menu. Before submitting a report to print the first time,
the user should contact their region's Account Manager regarding this information.
ACCESS: Select option 12 from the Batch Report menu. The Batch Report Profile screen
(Figure 6-2) will appear.
TOXIC RELEASE INVENTORY SYSTEM
TRR010M1 BATCH REPORT PROFILE 07/04/90
USER-ID: GJA ACCOUNT NO: TRISBMSP
BIN/BOX: D166 SYSOUT CLASS: A
PRIORITY: 2 CPU-TIME: 05,00
REMOTE NO: R2S5 COPIES: 1
PRESS TO CONTINUE
Enter-PFl PF2 PF3 PF4 PFS PF£ PF? PF6 PF$ PF10—PFll—PFl2
HELP MAIN PREV QUERY
Figure 6-2
The Batch Report Profile screen displays the current User ID. All other variables can be
modified to meet individual user requirements. After users have entered batch report parameters,
they are stored in the system for future reference. The Batch Report Profile screen will not be
displayed again, unless requested by the user.
11/18/91 6-4 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type the ACCOUNT NUMBER you are charging. The default is TRISDBMSP.
2) Type the BIN/BOX where you want the final report to be printed. The default is D166
(TRIS User Support at the Washington Information Center).
3) Type the SYSOUT CLASS for the type of printer desired. The defualt is A for standard
printer. The laser printer is designated as F.
4) Type the PRIORITY for this job. The default is 2. Priority 1 is overnight. See Section
5.3.2 of the NCC IBM User's Guide for a more detailed explanation.
5) Type the estimated CPU TIME in minutes, seconds. This parameter specifies the
maximum amount of CPU time. The default is 5 CPU minutes. See Section 4.0 of the
NCC IBM User's Guide for a more detailed explanation.
6) Type your REMOTE PRINTER NUMBER beginning with R (e.g., R114) or destination
(see table below). The default is WIC (Washington Information Center). Output may be
held on the system by using *R255' or 'HOLD'.
7) Type the number of COPIES needed. The default is 1. When all fields are complete,
press . Since parameters are stored for each user, it is unnecessary to reenter
the same parameters to run other reports.
HELP is available for all fields. To view HELP screens, move the cursor to the desired field and
press . Press to return to the Main Menu. Press to return to the
previous screen.
Regional Office Destination
Regional Office Destination
WIC
New York
Denver
Dallas
Seattle
WIC
NY
DV
DA
SE
Atlanta
Kansas City
Philadelphia
Boston
Chicago
AT
KC
PH
BN
CH
11/18/91
6-5
BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.2 Recording the Job Number
FUNCTION: After the user types the selection criteria for a report (discussed in detail in the
following sections) and presses , the report is submitted to the ES/9000
and assigned a job number. It is recommended that users record their job numbers
so that all reports can be accounted for once they are retrieved. The job number
is displayed in a window. An example appears in figure 6-3.
PGM: TRROOON1 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM1 GEOGRAPHIC LOCATION / CHEMICAL PROFILE SELECTION 12:38:00
REQUIRED: REPORTING YEAR >1989
GEOGRAPHIC LOCATION SELECTION:
REGION....) 03 STATE > VA
CITY > RICHMOND
COUNTY >
ZIP CODE..> SIC CODE..>
CHEMICAL PROFILE SELECTION:
I JOB JOB12345 Submitted Successfully |
AVAILABLE I Press to Return to Previous Screen |
1) FACILIT I |T FORMAT:
2) RELEASE + +.> 3
3) RELEASES/TRANSFERS + ACTIVITY/USE PER FACILITY
Enter-PFl PF2-—PF3-—PF4 PF5-—• PFfi PF?—-PFfl—- PF9— PF10-- PFll— PF12
HELP MAIN PREV PROFL QUERY
Figure 6-3
1) After recording the job number, press to return to the previous screen.
11/18/91 6-6 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.3 Geographic / Chemical Profile Report
FUNCTION: This report lists all facilities within a geographic location and/or submitting a
specific chemical. Submissions are selected from the Geographic Location /
Chemical Profile Report Selection screen by supplying geographic selection
criteria and/or CAS Number or Chemical/Synonym/Category Name. This report
is sorted on facility name. See Appendix B for an example of this report A
specific report format must be chosen from the following three options:
1) Facility Identification Information: Listed for each facility is
Name, Address, EPA ID, TRI Facility ID, and the primary SIC
Code with a total of facilities selected.
2) Releases / Transfers Per Facility: Listed for each facility is the
amount of releases to air, water and land, transfers to off-
site/POTW locations, and the total amount of releases and transfers,
besides the above information. This report will also show the
aggregate release and transfers for all facilities selected.
3) Releases / Transfers and Activity / Use Per Facility: Listed for
each facility are the activities and uses of the chemical in addition
to the above information.
ACCESS: Select option 1 from the Batch Report menu. The Geographic Location /
Chemical Profile Selection screen (Figure 6-4) will appear.
09/03/91 6 - 7 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
2) Type either GEOGRAPHIC LOCATION or CHEMICAL PROFILE information. For
Geographic Location, the following optional fields may be entered to narrow the search:
REGION, STATE, CITY, COUNTY, ZIP CODE, and SIC CODE. In this example,
Region '03,' State ' Va,' and City 'Richmond* are used. Upper or lower case letters can
be used. For Chemical Profile information, the following fields may be entered to narrow
the search: either a CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME.
In this example, Chemical Profile information was not used. You must enter at least one
of these fields.
3) Type the REPORT FORMAT. This is a required field. In this example, '3' was used.
Press to submit the report. Your job is submitted and a message appears at
the bottom of the screen advising you of the job number assigned.
PGM: TRROOON1 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM1 GEOGRAPHIC LOCATION / CHEMICAL PROFILE SELECTION 12:38:00
REQUIRED: REPORTING YEAR > 1989
GEOGRAPHIC LOCATION SELECTION:
REGION.,..> 03 STATE > VA
CITY , . > RICHMOND
COUNTY....>
ZIP CODE..> SIC CODE..>
CHEMICAL PROFILE SELECTION:
CAS NUMBER > --OR—•
CHEMICAL NAME...> '
AVAILABLE REPORT FORMATS:
1) FACILITY IDENTIFICATION INFORMATION SELECT REPORT FORMAT:
2) RELEASES/TRANSFERS PER FACILITY (1,2,3) > 3
3) RELEASES/TRANSFERS + ACTIVITY/USE PER FACILITY
Enter-PFl PF2 PF3 PF4-- -PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV PROFL QUERY
Figure 6-4
4) Record the JOB NUMBER and press to return to the Geographic Location
/ Chemical Profile Selection screen.
09/03/91 6~T BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.4 POTW / Off-Site Location Report
FUNCTION: This report lists all facilities transferring chemicals to a specified POTW or Off-
Site location. Submissions are selected from the POTW / Off-Site Location
Report Selection screen by supplying a POTW / Off-Site ID or POTW / Off-Site
name. The selection can be further limited by supplying a CAS number or
Chemical/Synonym/Category name. This report is sorted by POTW / Off-Site
name and CAS Number. See Appendix B for an example of this report.
ACCESS: Select option 2 from the Batch Report menu. The POTW/Off-Site Location
Selection screen (Figure 6-5) will appear.
PGM: TRROOON2 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM2 POTW/OFF-SITE LOCATION REPORT SELECTION 12:39:21
REPORTING YEAR > 1989
POTW/OFFSITE ID >
—OR--
POTW/OFFSITE NAME > BFI WASTE SYSTEMS
SEARCH CAN BE LIMITED BY SUPPLYING CHEMICAL INFORMATION:
CAS NUMBER....> —OR—
CHEMICAL NAME.>
Key selection Criteria and Press to Submit Report
Eriter-PFl PF2 PE3 PF4—-PF5 PF6-—PF7—PF8 PF9 PF10—PF11—PF12--
HELP MAIN PREV PROFL QUERY
Figure 6-5
1) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
2) Type either a POTW OFF-SUE ID or POTW OFF-SITE NAME. One of these is
required. In this example, 'BFI WASTE SYSTEMS' is used. Upper or lower case letters
can be used. The following optional fields may be entered to narrow the search: CAS
09/03/91 6^1 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME. In this example (Figure
6-2), none of these optional fields have been entered. Press to submit the
report. Your job is submitted and a message appears at the bottom of the screen advising
you of the job number assigned.
3) Record the JOB NUMBER and press to return to the POTW/Off-Site
Location Report Selection screen.
09/03/91 6-10 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.5 Facility Profile Report
FUNCTION: This report lists all information for a selected facility or submission on the
database. The length of this report depends upon the number of Off-Site
locations, POTWs, and waste treatment methods/efficiency entries in the
submission. Facilities or submissions must be selected from the Facility Profile
Report Selection screen by one of the following:
• TRI Facility ID
• DUNS Number
• Parent DUNS Number
• EPA ID
• Document Control Number
• Facility Name or range using the wildcard, *
The search can be limited by supplying a CAS Number or Chemical/Synonym/Category name.
All versions of the resulting report are identical in format, except the first page, that lists the
selection criterion. See Appendix B for an example of this report.
ACCESS: Select option 3 from the Batch Report menu. The Facility Profile Report
Selection screen (Figure 6-6) will appear.
1) Type a REPORTING YEAR. This is a reqinn-d field. In this example, '1989' is used.
2) Select the FACILITY based on the following options: TRI FACILITY ID, DUNS
NUMBER, PARENT DUNS NUMBER, EPA ID NUMBER, DOCUMENT
09/03/91 eT~n BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CONTROL NUMBER, or FACILITY NAME (or range using the wildcard, *). This
is also required; you must enter at least one field. In this example, the TRI Facility ID
'27239DPNTCRT1BO' is used. Upper or lower case letters can be used. If a facility
name range is entered, the Facility Name Selection screen is displayed. Select the facility
of choice by placing an X before the facility name and pressing . The
following optional Chemical information fields may be entered to narrow the search: CAS
NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME. In this example, none
of these optional fields have been entered. Press to submit the report. Your
job is submitted and a message appears at the bottom of the screen advising you of the
job number assigned.
PGM: TRROOON3 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM3 FACILITY PROFILE REPORT SELECTION 12:42:16
REPORTING YEAR:...> l&SS '
PLEASE ENTER TRI FACILITY ID > 27239DPNTCRT1BO —OR—
DONS NUMBER > —OR—
PARENT DUNS NUMBER > --OR--
EPA ID NUMBER > --OR--
DOCUMENT CONTROL NUMBER > --OR--
FACILITY NAME > IZZZIIIIIIIII
SEARCH CAN BE LIMITED BY SUPPLYING CHEMICAL INFORMATION TO:
CAS NUMBER > —OR—
CHEMICAL NAME >
Key Selection Criteria and Press to Submit Report
Enter-PFl --- PF2 --- PF3 -- PF4 -- PFS -- PFg -- PF? --- PF6 --- PF9 --- PFld— PF11— PF12-- -
HELP MAIN PREV PROFL QUERY
Figure 6-6
3) Record the JOB NUMBER and press to return to the Facility Profile Report
Selection screen.
09/03/91 6 -12 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.6 Form R Facsimile Report
FUNCTION: This report lists all information for a selected facility or submission on the
database. This report displays the submitted data in the same order as they were
submitted on Form R. Submissions must be selected from the Form R Facsimile
Report Selection screen by one of the following:
• TRI Facility ID
• EPA ID Number
• Parent DUNS Number
DUNS Number
• Facility Name or range using the wildcard, *
• Document Control Number
The search can be limited by supplying a CAS number or Chemical/Synonym/Category name.
All versions of the resulting report are identical in format, except the first page, listing the
selection criteria. See Appendix B for an example of this report.
ACCESS: Select option 4 from the Batch Report menu. The Form R Facsimile Report
screen (Figure 6-7) will appear.
1) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
2) Select the FACILITY based on the following options: TRI FACILITY ID, DUNS
NUMBER, PARENT DUNS NUMBER, EPA ID NUMBER, DOCUMENT
CONTROL NUMBER, or FACILITY NAME (or range using the wildcard, *). This
09/03/91 6-13 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
is also required, you must enter at least one field. In this example, the TRI Facility ID
'27239DPNTCRT1BO' is used. Upper or lower case letters can be used. If a facility
name range is entered, the Facility Name Selection screen is displayed. Select the facility
of choice by placing an X before the facility name and pressing . Press
to submit the report. Your job is submitted and a message appears at the
bottom of the screen advising you of the job number assigned.
PGM: TRROOON4 TOXIC RELEASE INVENTOR* SYSTEM 06/18/91
MAP: TRROOOM4 FORM 'R' FACSIMILE REPORT 12:42:41
REPORTING YEAR > 1989
TRI FACILITY ID > 27239DPNTCRT1BO —OR--
EPA ID NUMBER > --OR--
PARENT DONS NUMBER > --OR—
DUNS NUMBER > —OR—
FACILITY NAME > —OR—
DOCUMENT CONTROL NUMBER...>
Key Selection Criteria and Press to Submit Report
Ente'r-PFl---PFi-~PF3 FF'4 PFS PF6 2F7 PF8 PF9—PF1Q-- PF11--PF12-
HELP MAIN PREV PROFL QUERY
Figure 6-7
3) Record the JOB NUMBER and press to return to the Form R Facsimile
Report screen.
09/03/91 6 -14 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.7 Regional TRIS Submissions Report
FUNCTION: This report lists facility and chemical information for individual submissions
within a specified geographical area. Submissions are selected using the Regional
TRIS Submissions Report Selection screen. A summary is provided for each state
as well as a final report summary, which includes number of submissions, number
of facilities, and a list of chemicals/categories reported within the region of
interest The selection may be further limited by entering a state or ZIP code.
This report is sorted by state, city, and facility name. See Appendix B for an
example of this report.
ACCESS: Selection option 5 from the Batch Report menu. The Regional TRIS Submission
Report screen (Figure 6-8) will appear.
PGM: TRROOONS TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOQM5 REGIONAL TRIS SUBMISSIONS REPORT 12:43:40
REPORTING YEAR > 1989
REGION > 03
STATE > VA
ZIP CODE > 23231
Key Selection Criteria and Press to Submit Report
Enter-PFl—P£2 'PF3 P£4 PF5 PF6—PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV PROFL QUERY
Figure 6-8
1) Type a REPORTING YEAR. This is a required field. In this example,' 1989' is used.
09/03/91 6-15 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2) Type GEOGRAPHIC information from the following options: REGION CODE,
STATE, or ZIP CODE (or range using the wildcard, *). One of these fields is required.
In this example, Region '03,' State 'Va,' and ZIP Code '23231' are used. Press
to submit the report. Your job is submitted and a message appears at the
bottom of the screen advising you of the job number assigned.
3) Record the job number, press to return to the Regional TRIS Submissions
Report Selection screen.
09/03/91 6 - 16 BATCH REPORTS
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
6.8 Chemical / Geographic / SIC Code Report
FUNCTION: This report lists facility name and address and release data for submissions
selected based on any combination of CAS Number or chemical/synonym/categoiy
name, geographical information, or SIC Code. Submissions are selected from the
ChemicaVGeographic/SIC Code Report Selection screen. The son order of the
report is determined by the user who can select the report to run with totals only,
or with both detail lines and totals. See Appendix B for an example of this report.
ACCESS: Select option 6 from the Batch Report menu. The ChemicaVGeographic/SIC Code
Report screen (Figure 6-9) will appear.
1) Type a REPORTING YEAR. This is a required field. In this example,' 1989' is used.
PGM: TRROOON6 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRR060H1 CHEMICAL/GEOGRAPHICAL/SIC CODE REPORT 16:35:56
REPORTING YEAR: 1989CONTROL TOTALS ONLY: N (Y/N)
CLEAN AIR ACT CHEMICALS ONLY: N (Y/N>
PART 1; ENTER CAS NUMBER.. ....>
—OR—
CHEMICAL/CATEGORY NAME > toluene
PART 2: ENTER REGION.> 03 (01 THRU 10)STATE..> va
CITY...> (MUST ENTER A STATE ALSO)
COUNTY.> ' ' ' ' ' ' ' ' ' ' ' "
ZIP > ^
PART 3; ENTER SIC CODE (SOURCE CATEGORY)..>
Note: Just entering Part 3 criteria will cause the entice file to be read.
At least 5 minutes CPU time should be given.
Press to continue
Entet-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV QUERY
Figure 6-9
2) To avoid reporting Control Totals only, press for 'No.'
3) To avoid reporting Clean Air Act chemicals only, press for 'No.'
09/03/91 6-17 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4) Type CHEMICAL, GEOGRAPHIC, or SIC CODE selection criteria from Pan 1 and/or
Part 2 and/or Part 3. At least one part must be entered. To narrow the report, you may
use more than one part. Press to proceed to the son selection screen.
5) Specify the SORT SEQUENCE by typing numbers ' 1' through '7' in front of the various
selections (Figure 6-10), where T is the highest level sort and '7* is the lowest level sort.
At least one field must be selected for sorting. If CAS Number or Chemical/Category
Name was specified, this automatically becomes the highest level sort. Summary totals
are listed for each sorted field. Press to begin the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
6) Record the JOB NUMBER, press to return to the Regional TRIS
Submissions Report Selection screen.
PGM: TRROOON6 TOXIC RELEASE INVENTORY SYSTEM 06/19/91
MAP: TRR06OM2 CHEMICAL/GEOGRAPHICAL/SIC CODE REPORT 12:23:11
Enter the desired sort order
1 CAS NUMBER OR CATEGORY
REGION
"* STATE
~ CITY
~ COUNTY
"ZIP CODE
~ SIC CODE
Note: Highest level sort should be '!', next level '2', etc.
For example, sorting city within state would be
1 STATE 2 CITY
Summary totals will be given for each sorted field.
Press to submit report
Enter-PFl—-PF2-—PF3 PF4---PF5 PF6---PF7-—PF8---PF9™PF10—PF11—PF12—--
HELP MAIN PREV PROFL QUERY
Figure 6-10
09/03/91 6-18 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.10 SAS Reports Menu
FUNCTION: Use the SAS Reports menu to access the various Statistical Analysis System
(SAS) reports that contributed to the creation of the first TRI National Report
released by the U.S. Environmental Protection Agency's Office of Toxic
Substances. The SAS reports are divided into the following nine parts:
• Facility Identification Data
• TRI Chemicals
• Total Environmental Releases
• Air Emissions
• Discharges to Water
• Releases to Ground and Underground Injection Wells
• Transport of Chemicals Wastes Off-site for Treatment or Disposal
• Waste Treatment
• Waste Minimization
ACCESS: Select option 8 from the Batch Report menu.
1) To select a specific submenu, type the CORRESPONDING NUMBER at the SAS
Reports menu (Figure 6-12), and press .
PGM: TRROOON8 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRRSOOM8 SAS REPORTS MENU 09:37:33
1 FACILITY IDENTIFICATION MENU 7 TRANSPORT OF CHEMICALS WASTES OFF-
SITE FOR TREATMENT/DISPOSAL MENU
2 TRI CHEMICALS MENU 8 WASTE TREATMENT MENU
3 TOTAL ENVIRONMENTAL RELEASES MENU 9 WASTE MINIMIZATION MENU
4 AIR EMISSIONS MENU 10 Future use
5 DISCHARGES TO WATER MENU 11 Future use
6 RELEASES TO GROUND AND UNDERGROUND 12 Future use
INJECTION WELLS MENU
Key selection and press ===>
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV QUERY
Figure 6-12
11/18/91 6-19 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.10.1 Facility Identification Data
FUNCTION: Use the Facility Identification Data menu to produce reports that provide general
facility information covering the geographical distribution of TRI facilities,
industrial categories, parent companies, and facility activities and uses of TRI
chemicals.
ACCESS: Select option 1 from the SAS Reports menu screen. The Facility Identification
menu screen (Figure 6-13) will appear.
PGM: TRR210N1
MAP: TRR210M1
TOXIC RELEASE INVENTORY SYSTEM
FACILITY IDENTIFICATION MENU
10/02/91
09:37:47
12 RELEASES BY MEDIA BASIS-OF-EST
13 FORMS BY MEDIA BY SIC CODE
14 FORMS BY MAX AMT CDE BY STATE
15 FORMS BY MAX AMT CDE BY SIC-CDE
16 FACILITIES BY ACT USE CDE BY ST
17 FACILITIES BY ACT USE CDE BY SC
18 FACILITIES BY 3-DIGIT SIC CODE
19 REPORTING RLSES BY 3-DIGIT SC
20 REPORTING NO RLSES BY 3-DIGIT SC
21 FORMS BY 3-DIGIT SIC CODE
22 REPORTING BY ACT USE CDE BY SC
23 REPORTING BY MAX AMT CDE BY SC
A***********************************
•> * To display a description of a *
•> * report key selection number: *
****************************»***«T«*
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV PROFL QUERY
FACILITIES BY SIC CODE BY STATE
FORMS N/RELEASES BY STATE BY MEDIA
PARENT COMPANY NAMES H/NUMBER OF
FACILITIES AND RELEASES
FACILITIES PER PARENT COMPANY
FACILITIES RPT ENTIRE VS PART YR
FACILITIES BY COUNTY FOR EACH STATE
TOP 25 COUNTIES WITH FACILITIES
RELEASES BY MEDIA BY SIC CODE
RELEASES BY SIC CODE BY STATE
10 RELEASES BY MEDIA BY STATE
11 RELEASES BY MEDIA BY ACTIVITY-USE
Key selection===
Reporting Year"
Figure 6-13
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
11/18/91
6-20
BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Facility Identification
menu screen.
6.10.2 TRI Chemicals
FUNCTION: Use the TRI Chemicals menu to produce reports that analyze how often and in
what amounts releases of individual chemicals and categories were reported. The
reports classify the chemicals according to structural features and examine how
classes of chemicals were used and released by different industries throughout the
nation.
ACCESS: Select option 2 from the SAS Reports menu screen. The TRI Chemicals menu
screen (Figure 6-14) will appear.
PGM: TRR220N1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR220M1 TRI CHEMICAL MENU 09:38:11
1 FORMS BY SIC CODE BY CHEMICAL 7 FACILITIES PER CHEMICAL/SIC CODE
2 DISTRIBUTION OF CHEMICALS PER FACILITY 8 FORMS BY MAX. AMI. CDE BY CHEMICAL
3 CHEMICALS PER FACILITY BY STATE 9 FORMS BY ACT.USE.CDE BY CHEMICAL
4 CHEMICALS PER FACILITY BY SIC CODE 10 RELEASE FOR CHEMICALS BY SIC CDE
5 DISTRIBUTION OF FACILITIES PER CHEMICAL 11 CHEMICAL PER FACILITY BY SIC CDE
6 FACILITIES PER CHEMICAL PER STATE 12 FACILITY PER CHEMICAL BY SIC CDE
************************************
Key selection=====> * To display a description of a *
Reporting Year====> * report key selection number: *
************************************
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11--PF12
HELP MAIN PREV PROFL QUERY
Figure 6-14
11/18/91 6-21 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the TRI Chemicals menu
screen.
6.10.3 Total Environmental Releases
FUNCTION: Use the Total Environmental Releases menu to produce reports showing general
trends in the production and use of toxic chemicals across the nation. These
reports provide information on the location of facilities that emitted toxic
chemicals, the types of industries and facilities recording the largest emissions,
and the specific toxic chemicals released. The reports in this submenu also
provide information on how facilities calculated their releases.
ACCESS: Select option 3 from the SAS Reports menu screen. The Total Environmental
Releases menu screen (Figure 6-15) will appear.
1) For a description of a specific report, use to advance the cursor to the prompt:
To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
11/18/91 6-22 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PGM: TRR230N1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR230M1 TOTAL ENVIRONMENTAL RELEASES MENU 09:38:21
1 TOP 25 COUNTIES FOR RELEASES BY TOTAL ll RELEASES BY MAX-AMT CODE BY CHEM
2 FACILITIES REPORTING RELEASES 12 RELEASES BY ACT-USE CODE BY CHEM
3 RELEASES BY MEDIA GROUP BY CHEMICAL 13 RELEASES BY SIC CODE BY STATE
4 RELEASES BY MEDIA GROUP BY SIC CODE 14 RELEASES BY SIC CODE BY CHEMICAL
5 RELEASES BY MEDIA GROUP BY STATE 15 INDIVIDUAL RELEASES BY MEDIA
6 RELEASES BY MEDIA GROUP BY ACT-USE 16 RELEASES BY 3-DIGIT SIC CODE
7 RELEASES BY ACT-USE CODE BY SIC CODE 17 AMOUNT OF RELEASES BY SIC CODE
8 RELEASES BY MEDIA BY BASIS-OF-ESTIMATE 18 RELEASES BY ACT-USE BY SIC CODE
9 RELEASES BY BASIS-OF-ESTIMATE BY STATE 19 RELEASES BY MAX-AMT BY SIC CODE
10 RELEASES BY BASIS-OF-ESTIMATE BY SIC CODE
Reporting Year»««> * report key selection number: *
Press to continue
Enter-PFl PF2 PF3— PF4 PF5 PF6 PF7— PF8— PF9— PF10— PF11— PF1Z—
HELP MAIN PREV PROFL QUERY
Figure 6-15
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Total Environmental
Releases menu screen.
6.10.4 Air Emissions
FUNCTION: Use the Air Emissions menu to produce reports that present the top 25 counties
nationwide with the highest fugitive air emissions, stack air emissions, and total
air emissions.
ACCESS: Select option 4 from the SAS Reports menu screen. The Air Emissions menu
screen (Figure 6-16) will appear.
11/18/91
6-23
BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PGM: TRR24ON1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR24OM1 AIR EMISSIONS MENU 09:38:31
1 TOP 25 COUNTIES FOR RELEASE BY TOTAL AIR
2 TOP 25 COUNTIES FOR RELEASE BY AIR-FUGITIVE
3 TOP 25 COUNTIES FOR RELEASE BY AIR-POINT
* * ******
Key selectlon=====> * to display a description of a *
Reporting Year— -==> * report key selection number: *
Press to continue
Enter-PFl PF2 PF3 PF4 PFS PF6 PF? PFB— PF9---PF10— PF11--PF12
HELP MAIN PREV PROFL QUERY
Figure 6-16
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Air Emissions menu
screen.
11/18/91 6-24 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.10.5 Discharges to Water
FUNCTION: Use the Discharges to Water menu to produce reports on the amounts of toxic
chemicals that facilities released directly and indirectly to water, where they were
released, by which industries and facilities, and what chemicals were released in
the largest amounts. The distinction between direct and indirect releases must be
recognized. In both cases, chemicals are released to water, but only direct releases
indicate chemicals going straight to water in the environment. The actual amounts
of chemicals released to the environment as a result of indirect releases, and
whether those releases are to water, land, or air, cannot be determined from TRI
reports.
ACCESS: Select option 5 from the SAS Reports menu screen. The Discharges to Water
menu screen (Figure 6-17) will appear.
PGM: TRR250N1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR2SOM1 DISCHARGES TO WATER MENU 09:38:46
~ITOP 25 COUNTIES RLSE BY TOTAL WATER5FORMS WITH TRANSFERS TO ONE OR
MULTIPLE POTWs
2 TOP 25 COUNTIES RLSE BY SURFACE WATER 6 RELEASES TO ONE POTW VS MULTIPLE
3 TOP 25 COUNTIES RLSE TO POTW 1 FORMS AND TOTAL SURFACE WATER
4 FACILITIES WITH TRANSFERS TO ONE OR 8 FACILITIES AND TOTAL SURFACE
MULTIPLE POTWs WATER WITH VALID NPDES
************************************
Key selection=====> * To display a description of a *
Reporting Year"»"!=> * report key selection number: *
*********************************T**
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12
HELP MAIN PREV PROFL QUERY
Figure 6-17
11/18/91 6-25 BATCH REPORTS
-------
TRJS INFORMATION RETRIEVAL USERS GUIDE
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Discharges to Water
menu screen.
6.10.6 Releases to Ground and Underground Injection Wells
FUNCTION: Use the Releases to Ground and Underground Injection Wells menu to produce
reports that examine where and by what industries and facilities toxic chemicals
are disposed of on land and by underground injection at onsite locations, as well
as the specific chemicals that are released in the largest amounts.
ACCESS: Select option 6 from the SAS Reports menu screen. The Releases to Ground and
Underground Injection Wells menu screen (Figure 6-18) will appear.
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the
CORRESPONDING NUMBER and press . A detailed explanation of the
report will appear.
11 n *®1 6-26 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PGM: TRR26ON1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR26OM1 RELEASES TO GROUND ( UNDERGROUND INJECTION WELLS MENU 09:38:57
1 TOP 25 COUNTIES RLSE BY LANDFILL 6 TOP 25 COUNTIES RLSE BY
UNDERGROUND INJECTIONS
2 TOP 25 COUNTIES RLSE BY LAND TREATMENT 7 FACILITY ID, UIC ID, £ RLSE AMT.
FOR EACH UNDERGROUND INJECTION
3 TOP 25 COUNTIES RLSE BY SURFACE 8 FACILITIES AND RELEASES TO LAND
IMPOUNDMENTS
4 TOP 25 COUNTIES RLSE BY OTHER LAND 9 FORMS AND TOTAL RELEASES TO LAND
FOR FACILITIES W/WO VALID RCRA ID
5 TOP 25 COUNTIES RLSE BY LAND NO-CODE
V
Reporting Year====> * report key selection number: *
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PFB PF9 PF10 — PF11 — PF12
HELP MAIN PREV PROFL QUERY
Figure 6-18
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Releases to Ground and
Underground Injection Wells menu screen.
6.10.7 Transport of Chemicals Wastes Off-site for Treatment or Disposal
FUNCTION: Use the Transport of Chemicals Wastes Off-site for Treatment or Disposal menu
to produce reports that provide information describing the geographical
distribution of the facilities from and to which wastes were transferred, the
industries that transferred large amounts of wastes, and the prominent chemicals.
Also offered are the types of treatment that chemicals received at off-site facilities.
11/18/91 6 - 27 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ACCESS: Select option 7 from the SAS Reports menu screen. The Transport of Chemicals
Wastes Off-site menu screen (Figure 6-19) will appear.
PGM: TRR270N1
MAP: TRR27OM1
TOXIC RELEASE INVENTORY SYSTEM
TRANSPORT OF CHEMICALS WASTES OFF-SITE MENU
10/02/91
09:39:17
7 OFF-SITE LOCATIONS WITH MOST
FACILITIES REPORTING ITS USE
8 FACILITIES REPORTING IS LOCATION
UNDER CONTROL OF PARENT COMPANY
9 FORMS AND AMT OF RELEASES TO
OFF-SITES W/WO VALID RCRA NUMBER
10 RELEASES FOR OFF-SITE TRANSFERS
IN/OUT-OF-STATE
11 FORMS AND AMT OF RELEASES TO
OFF-SITES BY TREAT/DISPOSAL CODE
12 OFF-SITE TRANSFERS IN/OUT-STATE
BY STATE OF TRANSFER
************************************
* To display a description of a *
* report key selection number: *
******************************* * *TF* *
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12—
HELP MAIN PREV PROFL QUERY
1 COUNTIES FOR RELEASE BY OTHER
OFF-SITE TRANSFERS
2 FACILITIES REPORTING OFF-SITE
IN/OUT-OF-STATE BY FACILITY STATE
3 FACILITIES REPORTING OFF-SITE
IN/OUT-OF-STATE BY STATE OF TRANSFER
4 DIFFERENT OFF-SITE LOCATIONS REPORTED
BY STATE OF THE OFF-SITE LOCATION
5 AVERAGE NUMBER OF OFF-SITE LOCATIONS
PER FACILITY
6 DISTRIBUTION OF OFF-SITE LOCATIONS
PER FACILITY
Key selection=====>
Reporting Year»===>
Figure 6-19
1) For a description of a specific report, use to advance the cursor to the prompt:
To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Transport of Chemicals
Wastes Off-site menu screen.
11/18/91
6-28
BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.10.8 Waste Treatment
FUNCTION: Use the Waste Treatment menu to produce reports that provide information on the
geographical and industrial distribution of facilities that treated wastes onsite, and
describe the chemicals and types of wastestreams that were treated. There is also
information on the waste treatment methods and their efficiencies.
ACCESS: Select option 8 from the SAS Reports menu screen. The Waste Treatment menu
screen (Figure 6-20) will appear.
PGM: TRR280N1
MAP: TRR280M1
TOXIC RELEASE INVENTORY SYSTEM
WASTE TREATMENT MENU
10/02/91
09:39:36
1 NUMBER OF FACILITIES BY SIC CODE BY
STATE WITH WASTE TREATMENT
2 NUMBER OF FORMS REPORTING WASTE
TREATMENT BY CHEMICAL
3 NUMBER OF FACILITIES WITH SEQUENTIAL
TREATMENT {1 of 2)
4 NUMBER OF FORMS WITH SEQUENTIAL
TREATMENT {2 of 2}
Key selection=====>
Reporting Year==»=>
5NUMBER OF FACILITIES IN EACH
GROUP
6 AMOUNT OF RELEASES BY MEDIA GROUP
7 AVG MAX AMT OF CHEMICAL ON SITE
FOR FACILITIES W/WASTE TREATMENT
8 FACILITIES REPORTING WASTE
TREATMENT BY 3-DIGIT SIC CODE
* To display a description of a *
* report key selection number: *
******************************** *T**
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11--PF12
HELP MAIN PREV PROFL QUERY
Figure 6-20
1) For a description of a specific report, use to advance the cursor to the prompt:
'To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
11/18/91
6-29
BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Waste Treatment menu
screen.
6.10.9 Waste Minimization
FUNCTION: Use the Waste Minimization menu to produce reports that examine where and in
what industries the facilities, that attempted to minimize wastes, are located and
identify which chemicals were most often targeted for waste reduction.
ACCESS: Select option 9 from the SAS Reports menu screen. The Waste Minimization
menu screen (Figure 6-21) will appear.
PGM: TRR290N1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR290M1 WASTE MINIMIZATION MENU 09:39:50
1 FAC W/WASTE MIN BY SIC CODE BY STATE 11 COMPARISON OF PRODUCTION INDEX
2 FAC W/WASTE MIN BY ACT-USE BY STATE TO PERCENTAGE CHANGE {2 of 2}
3 FAC W/WASTE MIN BY ACT-USE BY 12 FORMS BY SIC CODE BY STATE
SIC CODE 13 FORMS BY SIC CODE BY ACT-USE
4 FAC BY WASTE MIN CODE BY STATE 14 FORMS BY STATE BY ACT-USE CODE
5 FAC BY WASTE MIN CODE BY SIC CODE 15 FORMS BY SIC CODE BY CHEMICAL
6 DISTR OF CHEM FOR FAC W/WASTE MIN 16 FAC W/WASTE MIN BY SIC CODE
7 FORMS BY WASTE MIN CODE BY STATE 17 FORMS FILLING IN WASTE MIN BY
8 FORMS BY WASTE MIN CODE BY SIC CODE 3-DIGIT SIC CODE
9 FORMS BY WASTE MIN CODE BY CHEMICAL 18 FAC BY WASTE MIN BY SIC CODE
10 COMPARISON OF PRODUCTION INDEX TO 19 FORMS BY WASTE MIN CODE BY
PERCENTAGE CHANGE (1 OF 2} 3-DIGIT SIC CODE
Key selection=====> * To display a description of a *
Reporting Year====> * report key selection number: *
********************************TT**
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7— PF8— PF9 PF10--PF11— PF12—
HELP MAIN PREV PROFL QUERY
Figure 6-21
11/18/91 6-30 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) For a description of a specific report, use to advance the cursor to the prompt:
To display a description of a report key selection number.' Type the CORRESPONDING
NUMBER and press . A detailed explanation of the report will appear.
2) To select a specific report, type the CORRESPONDING NUMBER at the prompt: 'Key
selection field.' Then use to advance the cursor and type the REPORTING
YEAR. These fields are required. Press to submit the report. Your job is
submitted and a message appears at the bottom of the screen advising you of the job
number assigned.
3) Record the JOB NUMBER and press to return to the Waste Minimization
menu screen.
11/18/91 6-31 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
11/18/91 6-32 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7 DATA OFFLOAD
09/03/91 7 - 1 DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 7 - 2 DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7 DATA OFFLOAD
FUNCTION: The Data Offload enables the user to create a customized extract file from the TRI
database. By supplying geographic and/or chemical search criteria, and then
choosing any combination of TRI data elements; a program is automatically
constructed and executed that offloads the data onto an IBM ES/9000 mainframe
sequential (extract) file.
Besides the extract file, the function also produces a dBASE description file. The dBASE
description file is generated to help in the creation of a dBASE database on a PC or LAN.
Some users will wish to download the extract file and dBASE description file to a PC or LAN.
To download or transfer files from the IBM ES/9000 mainframe to a PC or LAN, the PC used
must have:
• Communications program installed
• Connection to the IBM ES/9000 mainframe
Instructions for downloading or transferring data from IBM ES/9000 mainframe to PC can be
found in The Guide to NCC Services, chapter entitled "Micro-to-Mainframe Link" (included in
Appendix E).
NOTE: The TRIS database contains a large volume of data. Users are cautioned
to consult with their LAN Administrator concerning storage space before
attempting to transfer a Data File from the IBM ES/9000 mainframe to a
LAN.
09/03/91 7^1DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ACCESS: Select option 3 from the Data Retrieval menu and press . The Select
Geographic/Chemical Information selection screen (Figure 7-1) will appear.
1) Type a REPORTING YEAR. This field is required.
2) After Reporting Year, either GEOGRAPHIC or CHEMICAL INFORMATION must
be supplied. Both Geographic and Chemical Selection may be entered, but one criterion
is required. The following fields may be entered to narrow the search: the Region, State,
City, County, ZIP Code, CAS Number, or Chemical/Synonym/Category. Upper or lower
case letters can be used. Once the search criteria has been supplied, press to
display the Select Data Elements screen.
PGM: TRF01OP TOXIC RELEASE INVENTORY SYSTEM 03/31/91
MAP: TRF010M1 SELECT GEOGRAPHIC/CHEMICAL INFORMATION 09:39:19
REQUIRED YEAR:
OPTIONAL REGION:
STATE: ~
CITY:
COUNTY:
ZIP CODE: ~~~~~~
CAS NUMBER:
—OR—
CHEMICAL/CATEGORY:
Type Geographic and/or Chemical information and press
Enter-PFl PF2 PF3 PF4 PF5 PFfi PF? PFfl PF9 PF10— PFll— PF12-
HELP MAIN PREV
Figure 7-1
09/03/91 ^4DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3) After selecting Geographic and/or Chemical information, you may include specific data
elements in the extract file (Figure 7-2). The TRI Facility ID and Document Control
Number (DCN) are automatically included. Type X in the space to the left of the data
elements to be selected. Press to advance the cursor through the data fields.
Press when selection is complete.
PGM: TRF020P
MAP: TRF020M1
TOXIC RELEASE INVENTORY SYSTEM
SELECT DATA ELEMENTS
03/31/91
10:46:59
FACILITY NAME
FACILITY STREET
FACILITY CITY
FACILITY COUNTY
FACILITY STATE
FACILITY ZIP
FACILITY ENT/PRT CODE
FACILITY LATITUDE
FACILITY LONGITUDE
CENTROID LATITUDE
CENTROID LONGITUDE
MAXIMUM AMOUNT CODE
ACTVTY USE CODE(1-13)
PUBLIC CONTACT
PUBLIC TELEPHONE
TECHNICAL CONTACT
TECHNICAL TELEPHONE
PARENT COMPANY NAMF
PARENT DUNS NUMBER
STATE COUNTY FIPS CODE
HASTE MIN CODE
HASTE MIN CURRENT YEAR
HASTE MIN PRIOR YEAR
WASTE MIN PCT CHANGE
WASTE MIN INDEX
HASTE MIN REASON CODE
CHEMICAL NAME
CAS NUMBER
FUGITIVE/NON-PNT AIR
STACK/POINT AIR
WATER BODIES
UNDERGROUND INJECTION
LAND ON-SITE
OTHER OFF-SITE
UIC ID (1-2)
EPA ID(l)
SIC CODE (1-3)
DUNS NUMBER (1)
Type X to select data elements and press
NOTE: The TRI Facility ID and the DCN will be selected automatically
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV PROFL
Figure 7-2
Like Batch Reports, the Data Offload submits a job to run in 'background' mode on the IBM
ES/9000. The same job profile parameters (e.g., output destination, number of copies, etc.) that
are used for Batch Reports are used for the Data Offload. See Section 6.1 for a detailed
explanation. The Batch Job Profile can be accessed directly from the Select Data Elements
screen by pressing .
In addition, Releases/Transfers totals for Water Bodies, Land On-Site, POTW, and Other Off-Site
are cumulative for all occurrences per submission.
09/03/91
7-5
DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4) After pressing to submit the job, a message is displayed that contains the
extract file name and the job number (Figure 7-3). Record this information for future
reference. See Section 7.1, "IBM Sequential Data File," for a definition of the naming
conventions used for the Data File.
PFGM: TRF02OP
MAP: TRF02OM1
TOXIC RELEASE INVENTORY SYSTEM
SELECT DATA ELEMENTS
03/31/91
10:46:59
FACILITY
FACILITY
FACILITY
FACILITY
FACILITY
FACILITY
FACILITY
FACILITY
FACILITY
CENTROID
CENTROID
MAXIMUM
ACTIVITY
NOTE:
NAME PUBLIC CONTACT
STREET ~ PUBLIC PHONE
CITY ~ TECHNICAL CONTACT
COUNTY TECHNICAL PHONE
STATE ~ PARENT COMPANY NAME
ZIP ~ PARENT DUNS NUMBER
REPORT CODE STATE COUNTY PIPS CODE
LATITUDE ~ HASTE MIN CODE
LONGITUDE ~ WASTE MIN CURRENT YEAR
LATITUDE _ WASTE MIN PRIOR YEAR
LONGITUDE WASTE MIN PCT CHANGE
^ ft************"****************************"****
U ** RECORD THE FOLLOWING INFORMATION **
** THE DOWNLOAD DSN NAME IS **
** AAABBBB.DYYMMDD.THHMMSS.DOWNLOAD.FILE ** TER>
T ** JOB JOBNNNNN **
_ ** SUBMITTED SUCCESSFULLY **
** PRESS TO RETURN TO SELECTION **
*********************************************
CHEMICAL NAME
~ CAS NUMBER
I FUGITIVE/NON-PNT AIR
_ STACK/POINT AIR
WATER BODIES
~ UNDERGROUND INJECTION
~ LAND ON-SITE
~ POTW
~ OFF-SITE
~ UIC 10(1-2)
EPA ID(1)
CODE (1-3)
NUMBER(1)
AUTOMATICALLY
Figure 7-3
09/03/91
7-6
DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7.1 IBM Sequential Data File
The intermediate IBM Data File is created in the EBCDIC format when the job has completed.
The file can then be converted to an ASCII file and transferred to a LAN or PC. The Data File
name has the following five parts:
1) Logon ID and Account number
2) Date Stamp
3) Time Stamp
4) Function type
5) Storage device type
The following naming conventions apply to the Data File name;
AAABBBB.DYYMMDD.THHMMSS.DOWNLOAD.FILE
Where:
• AAA is your three character User ID
• BBBB is your four character account code
• DYYMMDD is the current date in year, month, day format
• THHMMSS is the current time in hours, minutes, seconds format
• DOWNLOAD is the name of the function
• FILE is the storage device
09/03/91 7~7 DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7.2 Understanding the Printed Report
A printed batch report provides information which includes the name of the file created; the date
and time the file was created; the number of records selected based on the Geographic/Chemical
selection; and the format of each record on the file. The corresponding report generated from
the Data Offload Function contains the following information:
• Report Title
• Data File Name
• Selection Criteria
• Total number of records found
• Data File Format:
1) Data Element Name
2) Data Element Type
3) Data Element Length
• Data File size in ASCII
• Data File size in dBASE
• dBASE Description File Name
The Data File name is identical with that displayed when the job is submitted.
09/03/91 " ~B DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The selection criteria repeat the parameters supplied on the Select Geographic/Chemical
Information screen. The number of records found is the number of Form R submissions that
matched the selection criteria and were output to the Data File.
The Data File format lists each data element chosen on the Select Data Elements Screen. It also
lists the corresponding Data Type and Data Length. The Data Type can be character (C) or
numeric (N). The Data Length shows the number of bytes for each Data Element. Some
numeric elements may contain both whole and decimal digits.
The file size in both ASCII and dBASE is supplied so that users can determine the amount of
storage space if the Data File is to be transferred to a PC or Local Area Network (LAN).
The dBASE Description File Name is automatically generated and intended for transfer into a
dBASE database on a PC or LAN. This is a specially formatted database definition file that
corresponds to the Data File. Like the Data File, this file can be transferred to a PC or LAN.
The following page contains a sample of the report generated from the Data Offload, which is
delivered to the users' bin.
09/03/91 7 - 9 DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRF04BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 07/04/91
PAGE: 1 TOXIC RELEASE INVENTORY SYSTEM 10:30:04
TRIS MAINFRAME DATA OFFLOAD LAYOUT REPORT
THE TRIS DATA FILENAME IS = AAABBBB.D910704.T102933.DOWNLOAD.FILE
GEOGRAPHICAL/CHEMICAL SELECTION CRITERIA
REPORTING YEAR = 1989
SELECTED REGION =03
SELECTED STATE = VA
SELECTED CITY = RICHMOND
SELECTED ZIP CODE = 00000
SELECTED ZIP CODE THRU = 99999
SELECTED CAS NUMBER = 000050000
SELECTED CHEMICAL/CATEGORY = FORMALDEHYDE
USING THE GEOGRAPHIC/CHEMICAL SELECTION CRITERIA ABOVE, THE TOTAL NUMBER OF
RECORDS FOUND ON THE TRIS DATABASE WAS 2
SEQUENCE DATA ELEMENT DATA TYPE DATA LENGTH
1 FACIL-NAME-1 C 30.0
2 FACIL-NAME-2 C 30.0
3 PUBLIC-CONTACT-NAME C 45.0
4 PUBLIC-CONTACT-PHONE C 10.0
5 NON-PNT-RLSE-TOTAL N 11.0
6 PNT-RLSE-TOTAL N 11.0
7 WATER-RLSE-TOTAL N 11.0
8 UNDRGRD-RLSE-TOTAL N 11.0
9 LAND-RLSE-TOTAL N 11.0
10 POTW-RLSE-TOTAL N 11.0
11 OFFSITE-RLSE-TOTAL N 11.0
12 DOC-CNTL-NUM C 15.0
13 TRI-FACILITY-ID C 15.0
14 FILLER C 1
ASCII FILESIZE FOR THE AAABBBB.D910704.T102933.DOWNLOAD.FILE IS 446 BYTES
DBASE FILESIZE FOR THE AAABBBB.D910704.T102933.DOWNLOAD.FILE IS 960 BYTES
THE DESCRIPTION FILE NAME IS AAABBBB.D910704 .T102933 .DESCRIPT.FILE
09/03/91 7-10 DATA OFFLOAD
-------
TRIS INFORMATION RETRIEVAL .USERS GUIDE
8 TUTORIAL
09/03/91 8-1 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 8 - 2 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8 TUTORIAL
FUNCTION: The TRI menu driven system features an online Tutorial. The Tutorial is designed
to help the novice user who is unable to attend the regularly scheduled training
course. It also may assist the more experienced user as new system enhancements
are added. The Tutorial covers basic skills necessary to retrieve data from the
system using Online Queries, Batch Reports, and Data Offload. Much of the
Tutorial is interactive and requires the user to provide search criteria and use the
correct PF keys. In addition, the Tutorial explains terminology and concepts
unique to TRIS.
ACCESS: Select option 4 from the Data Retrieval menu and press . The Tutorial
menu (Figure 8-1) will appear.
PGM: TRUOOOP
MAP: TRUOOOM1
TOXIC RELEASE INVENTORY SYSTEM
TUTORIAL MENU
1 GENERAL INFORMATION
2 USING THE SYSTEM
3 ONLINE QUERIES
4 BATCH REPORTS
5 DATA OFFLOAD
£ USER SUPPORT
Key selection and press =•==> _
03/31/91
14:32:16
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV
Figure 8-1
09/03/91 8 - 3 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The online Tutorial has the following six (6) sections:
1) GENERAL INFORMATION including screens defining:
• The TRIS Database
• TRI Facility ID
• Document Control Number
• Current and Historical Data
2) USING THE SYSTEM including screens defining:
• Menus and Selection Criteria
• Keyboard Configuration
PF Keys
• HELP and Pop-up Windows
3) ONLINE QUERIES includes screens defining:
How to use all nine (9) online data searches
4) BATCH REPORTS - (not yet available)
5) DATA OFFLOAD includes screens defining:
How to use the Data Offload function to create an extract file
6) USER SUPPORT includes screens defining:
How to use all four (4) user support online functions
09/03/91 ifT^TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.1 General Information
FUNCTION: This option explains terminology and concepts unique to TRIS. The TRIS
database, TRI Facility ID, Document Control Number, and Current and Historical
Data are described.
ACCESS: Select option 1 from the Tutorial menu and press . The General
Information menu screen (Figure 8-2) will appear.
PGM: TRU010P TOXIC RELEASE INVENTORY SYSTEM 06/03/91
HAP: TRU010MO TUTORIAL: GENERAL INFORMATION 10:41:45
I THE TRIS DATABASE
2 TRI FACILITY ID
3 DOCUMENT CONTROL NUMBER
4 CURRENT AND HISTORICAL DATA
Key selection and press =«==> _
Enter-PFl PF2 PF3 PF4-—PF5 PF6 PF7 PF8 PF9 PF10—PF11—PF12-
HELP MAIN PREV
Figure 8-2
1) To view information on one of the topics, type the corresponding number, either 1, 2, 3,
or 4, and press .
09/03/91 8 - 5 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.2 Using the System
FUNCTION: This option explains the menus system and keyboard configuration using four
communications packages: IRMA, CROSSTALK, PROCOMM, and Mainframe.
In addition, PF keys and HELP and Pop-up windows are defined.
ACCESS: Select option 2 from the Tutorial menu and press . The Using The
System menu screen (Figure 8-3) will appear.
PGM: TRU020P TOXIC RELEASE INVENTORY SYSTEM 06/03/91
MAP: TRU020MO TUTORIAL: USING THE SYSTEM 10:43:03
1 MENUS AND SELECTION CRITERIA
2 KEYBOARD CONFIGURATION
3 PF KEYS
4 HELP AND POP-UP WINDOWS
Key selection and press => _
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9—-PFIO—-PF11—PF12*
HELP MAIN PREV
Figure 8-3
1) To view information on one of the topics, type the corresponding number, either 1, 2, 3,
or 4, and press .
09/03/91 8 - 6 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.3 Online Queries
FUNCTION: This option describes how to use all nine (9) online data searches.
ACCESS: Select option 3 from the Tutorial menu and press . The Online Queries
Tutorial introduction screen (Figure 8-4) will appear.
PGM: TRU030P TOXIC RELEASE INVENTORY SYSTEM 06/07/91
MAP: TRU030M1 ONLINE QUERIES TUTORIAL 16:23:34
•
H
f. •• •»«•••••••»••••* w *••••• 4
You have chosen to review the Online Queries Tutorial.
For convenience, most of the data searches in TRIS are done as
online queries since these results are available immediately.
Queries are used to search for specific information about:
a facility, a submission, geographic location, or a particular
chemical.
There are various queries used to retrieve data. From the next
screen you may select the Online Query you choose to view.
h j
•
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PFIO--PF11 — PF12
HELP MAIN PREV TUTOR
Figure 8-4
1) The Online Queries Tutorial screen provides a brief explanation of the purpose of online
queries. The user is prompted to press to continue to the next screen and
choose one of the queries. This is an interactive tutorial.
09/03/91
8-7
TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2)
3)
At the prompt on the Online Queries Tutorial menu, type the CORRESPONDING
NUMBER of the online query to be viewed. Press . In this example (Figure
8-5), 1 was selected.
PGM: TRU03OP
MAP: TRU03OM2
TOXIC RELEASE INVENTORY SYSTEM
ONLINE QUERIES TUTORIAL
06/07/91
16:23:58
1 FACILITY NAME SEARCH
2 CITY / COUNTY SEARCH
3 CAS / CHEMICAL SEARCH
4 ALTERNATE FACILITY KEY SEARCH
5 SUBMISSION DISPLAY
7 YEAR-TO-YEAR COMPARISON
8 HISTORICAL FACILITY INFORMATION
9 CHEMICAL TABLE SEARCH
10 Future Use
11 Future Use
12 Future Use
6 POTW / OFF-SITE SEARCH
Select the query you would like to view
by entering the corresponding number •==>
+
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF") PF8 PF9 PF10—PF11--PF12
HELP MAIN PREV TUTOR
Figure 8-5
Additional HELP information is displayed on a mock Facility Name Search screen (Figure
8-6). Press to continue. The tutorial gives the user prompts to type specific
data and simulates an online query.
PGM: TRU03OP1 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRU03M1B FACILITY NAME SEARCH
REQU]
OPTIC
•
-
[RED REPORTING YEAR >
FACILITY NAME >
)NAL REGION >
h™~"
06/07/91
16:24:10
This is the Facility Name Search screen, this query is used to
conduct a search using the 2 required fields, reporting year and
facility name. REQUIRED means you must supply data in a field.
The 5 optional fields (hidden by this window) are used as a means
of narrowing your search. To view the FULL screen press .
Fields contain 'POP-UP' windows (Tutorial 2.3), which may be used
whenever you are unsure of what data element to enter in a field.
Enter-PFl PF2-—PF3 PF4 PF5-~PFfi---PF7---pF8 PF9---PF'1'8
HELP MAIN PREV TUTOR FULL
•
•
--PF11— PFW
Figure 8-6
09/03/91
8-8
TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.4 Batch Reports
FUNCTION: This option is not yet available.
09/03/91 8 - 9 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.5 Data Offload
FUNCTION: This option describes how to use the Data Offload function to create an extract
file.
ACCESS: Select option 5 from the Tutorial menu and press . The Data Offload
Tutorial introduction screen (Figure 8-7) will appear.
PGM: TRU05OP TOXIC RELEASE INVENTORY SYSTEM 06/07/91
MAP: TRU05OMA. TUTORIAL 16:34:16
•
•
You have chosen to review the Data Offload function.
The Data Offload function allows the user to transfer TRIS data
from the mainframe ADABAS files to a mainframe sequential file.
The sequential file can then be used to offload the data to a
Personal Computer (PC) or a Local Area Network (LAN), or used by
other mainframe software to produce a report.
In this tutorial we will introduce you to the various screens and
fields you will encounter in using the Data Offload function.
»
'
Enter-PFl PF2 PF3 PF4 EF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN TUTOR -PAGE +PAGE
Figure 8-7
1) The Tutorial screen provides a brief explanation of the Data Offload function. The user
is prompted to press to continue to the next screen and type specific data in
required fields. This is an interactive tutorial.
09/03/91
8-10
TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.6 User Support
FUNCTION: This option provides information on how to use all four user support online
functions.
ACCESS: Select 6 from the Tutorial menu and press . The User Support Tutorial
introduction screen (Figure 8-8) will appear. TRIS User Support is briefly
described.
PGM: TRU060P
MAP: TRU060M1
TOXIC RELEASE INVENTORY SYSTEM
USER SUPPORT TUTORIAL
06/07/91
16:41:10
You have chosen to review the User Support Tutorial.
TRIS User Support is a medium that helps all TRIS
users in accomplishing tasks requiring the use of the
TRIS Database.
Enter-PFl P.FZ PF3 PF4-— PF5 PF6 PF7 PF8 PF9 PFlU—PF11—PF12-
HELP MAIN PREV TUTOR
Figure 8-8
1) From the User Support screen, the user is prompted to press to continue. This
is an interactive tutorial.
09/03/91
8-11
TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2) At the prompt on the User Support Tutorial menu, type the CORRESPONDING
NUMBER of the User Support feature to be viewed. Press . In this example
(Figure 8-9), 1 was selected.
PGM: TRU060P
MAP: TRU06OM2
•
•
TOXIC RELEASE INVENTORY SYSTEM
USER SUPPORT MENU
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
4 SET PROGRAM FUNCTION
06/11/91
14:03:08
•
•
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV TUTOR
Figure 8-9
3) Additional HELP information is displayed on a mock Questions and Suggestions screen
(Figure 8-10). Press to continue. The tutorial gives the user prompts to type
specific information to simulate submitting an online suggestion.
PGM: TRU06OP TOXIC RELEASE INVENTORY SYSTEM 06/11/91
MAP: TRU06OMB QUESTIONS AND SUGGESTIONS 14:03:37
1
SUBJEC
MESSAC
•
•
CO: TRIS User Support FROM: LOUISE HYDE
JT:
»E:
The Questions And Suggestions option allows you to relay messages
to TRIS User Support via this screen.
You may send a message regarding any aspect of the EPA internal
TRIS database. The questions and/or suggestions are reviewed by
a supervisor who will route them to the appropriate personnel.
•
E"nter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 — PF11 — PF12
HELP MAIN PREV TUTOR CLEAR FULL
Figure 8-10
09/03/91 8-12 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9 USER SUPPORT
09/03/91 9 - 1 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 g - 2 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9 USER SUPPORT
FUNCTION: TRIS User Support is a team of dedicated professionals available to all TRIS users
connected to the IBM ES/9000 accessing the EPA internal database. Answering
questions, providing current updates on TRIS, and receiving feedback from users
make up the backbone of TRIS User Support. There are four methods to reach
TRIS User Support: Telephone, FAX, EMAIL, and the online User Support
function. This chapter discusses the online User Support function.
ACCESS: To select the online User Support function option, type 5 from the Data Retrieval
menu and press . The User Support menu (Figure 9-1) will appear.
PGM:
HAP:
tRPOOOP TOXIC RELEASE INVENTORY SYSTEM
TRPOOOK1 USER SUPPORT MENU
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
4 SET PROGRAM FUNCTION (PF>
Key selection «nd press — >
03/31/91
10:48:27
KEYS
Ent«-PFl~" -PF2-—- PF3 — *-PF4— —PF5 PF6— -- PF7---PF8-— • PF9-—-PFiP»-PFll~» PFJ2~—
HEUP MAIN PREV
Figure 9-1
09/03/91 9 - 3 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9.1 Questions and Suggestions
FUNCTION: This function allows users to send questions, suggestions, and general comments
to User Support from within the menu-driven system. This function is intended
for questions and suggestions that arise while users are operating the online
system. Using this function is more convenient than exiting the system, preparing
a memo, and then sending it via FAX or electronic mail.
ACCESS: Select option 1 from the User Support menu. The Questions and Suggestions
screen (Figure 9-2) will appear.
PGM: TRP010P TOXIC RELEASE INVENTORY SYSTEM 06/03/91
MAP: TRP01OM1 QUESTIONS AND SUGGESTIONS 10:38:17
TO: ' TRIS User Support FROTH LOUISE HYDE
SUBJECT:
MESSAGE: ~ '—
PHONE: (
Enter-PFl --- PF2 --- PFJ --- PF4 --- PFS --- PF6-- '-Pg1? --- PFfl --- PFJ— - PF10-- PFll—
SEND HELP MAIN PREV CLEAR
Figure 9-2
1) Type the text of the memo's SUBJECT and press . This is required.
2) Type the text of the MESSAGE. Use the key to advance the cursor.
3) Type your complete TELEPHONE NUMBER and press . This is required.
4) Upon completion, a pop-up window appears and the user is prompted to confirm whether
the message should be sent. Type either Y or N and press .
09/03/91 9T4 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9.2 Request Documentation
FUNCTION: This option allows the user to submit a request for Documentation from within the
menu-driven system.
ACCESS: Select option 2 from the User Support menu. The Request Documentation screen
(Figure 9-3) will appear.
PGM: TRP020P TOXIC RELEASE INVENTORY SYSTEM 03/31/91
MAP: TRP02OM1 REQUEST DOCUMENTATION 10:48:40
TO: TRIS User SupportFROM:LOUISE HYDE
_ Information Retrieval Users Guide
Instructions and information for the menu-driven system
_ Users Quick Reference Card
~ Logon/logoff instructions, acronyms, SDSF, JCL
AOABAS File Descriptions
~ Revised April 1991 after major system enhancements
NLK Tape Specifications
~ Tape format used to supply National Library of Medicine
GPO/NTIS Tape Specifications
~ Tape format used for Gov. Printing Office and NTIS
Extract File Specifications
~ Extract files on the NCC ES9000
Please mark documentation you wish to receive with X and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11—PF12
SEND HELP MAIN PREV CLEAR
Figure 9-3
1) Select specific documentation by typing an X in the left column. Press to
advance through the options.
2) Upon completion press . A pop-up window appears and the user is prompted
to confirm whether the request for documentation should be sent. Type either Y or N and
press .
09/03/91 9 - 5 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9.3 Extract File Information
FUNCTION: This option provides current information concerning permanent TRIS extract files
for each reporting year.
ACCESS: Select option 3 from the User Support menu. The Extract File Information screen
(Figure 9-4) will appear.
PGM: TRP030F TOXIC RELEASE INVENTORY SYSTEM
VIA?: TRP030H1 EXTRACT FILE INFORMATION
FILE
TXLTRID.PROD0419. CHEMICAL. FILE87
TXLTRIO.PROD0419. FACILITY. FILE87
TXI/TRID.PROD0419.0FFSITE. FILES?
TXLTRIO.PROD0419.POTW.FILE87
TXLTRID.PROD0419. RELEASE. PILES?
TXI/TRID.PROD0419. TREAT. FILE87
Press to view additional
YEAR
1987
1987
1987
1987
1987
1987
reporting
06/03/91
10:40:08
LAST REVISION
4/19/91
4/19/91
4/19/91
4/19/91
4/19/91
4/19/91
years
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PFIO — PFli — PFJ.2
CONT HELP MAIN PREV
Figure 9-4
1) To view additional reporting year information, press . Permanent Extract files
are available for all reporting years in which the data have been released to the public.
09/03/91
9-6
USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9.4 Set Program Function Keys
FUNCTION: This option allows the user to set the Program Function (PF) keys on their
workstation. The PF keys become active immediately and are then the default for
subsequent sessions. This option should only be used for dedicated mainframe
workstations.
ACCESS: Select option 4 from the User Support menu. The Program Function (PF) Keys
screen (Figure 9-5) will appear.
PGM: TRP040P TOXIC RELEASE INVENTORY SYSTEM 06/03/91
MAP: TRP040M1 PROGRAM FUNCTION (PF) KEYS 10:40:45
1 PF1 through PF12
2 PF13 through PF24
Key selection and press —> _
Enter-PFl—-PF2 PF3^ PF4 PF5 PF6 PF7 PF8-— PF9——PF10--PF11—-PF1Z---
HELP MAIN PREV
Figure 9-5
1) To set Program Function keys PF1 through PF12, press 1 and press .
2) To set Program Function keys PF13 through PF24, press 2 and press .
09/03/91 9 - 7 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 9 - 8 USER SUPPORT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX A
GLOSSARY
09/03/91 A - 1 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 A72- GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ADABAS
ADABAS is the database management system utilized by TRIS on NCC's IBM ES/9000.
Batch
Batch is a term carried over from the early days of data processing. Large computer jobs were
batched, or grouped together, for overnight processing. It is the opposite of online, or real-time,
processing. It applies to functions that potentially take a large amount of computer resources;
therefore, these functions are not suitable as online queries. Today these types of jobs do run
during business hours; however, they are run in "background" mode so as not to interfere with
online response time.
CAS
Chemical Abstract Services assigns CAS registry numbers and names to chemicals.
CICS
Customer Information Communications System. One of two means of interfacing with the IBM
ES/9000. SeeTSO.
Data Element
A single piece of information. For example, the state where a facility is located (i.e., VA) is a
single element of information.
Database
A collection of data or information organized for rapid research and retrieval by a computer.
Conceptually, it is organized similar to a filing cabinet. Pieces of information (elements), are put
together in a file (Form R submission), which are put together in a drawer (database).
DCN
Document Control Number. EPA has designated a number beginning with the type of
submission, reporting year, a unique number, and then a two-letter state code, to be a Document
Control Number. This number is used to track a single submission through the data entry and
information acceptance process.
09/03/91 A - 3 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
De Minimis
Mixtures containing "trace" quantities of Section 313 chemical do not have to be reported if they
contain less than 1% chemical in the mixture, or less than 0.1% if the chemical is a carcinogen.
Due Date
The Form R for Reporting Year January-December is due on or before July 1 of the following
year.
D&B or DUNS
The unique identifying number (nine digits) assigned by Dun and Bradstreet. TRIS carries both
parent company and facility DUNS.
ETD
Economics and Technology Division
EPA ID Number
A twelve digit number assigned to facilities covered by hazardous waste regulations under the
Resource Conservation and Recovery Act (RCRA).
EPCRA
The Emergency Planning and Community Right-to-Know Act or Section 313 of SARA Title III.
Facility
All buildings, equipment, structures, and other stationary items which are located on a single site
or on contiguous or adjacent sites and which are owned or operated by the same person. Owners
or operators of a facility must report if the facility has 10 or more full-time employees; is
included in the Standard Industrial Classification Codes 20-39; and manufactured (imported,
processed, or otherwise used) any listed chemical in quantities equal or greater than the
established threshold in one calendar year.
Form R
The Toxic Chemical Release Inventory Reporting Form. A completed Form R must be submitted
for each toxic chemical manufactured, processed, or otherwise used at each facility prescribed
in the reporting rule.
09/03/91 A - 4 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Form R Facsimile
After information from a Form R is entered into the computer, a printout can be made to
approximately look like a Form R (with all the box titles) with the information placed in the
appropriate box. This facsimile can be useful to verify that the information has been entered into
the computer correctly.
IMD
Information Management Division
Influent
A fluid input into a reservoir or a process.
JCL
Job Control Language. JCL are codes that tell a computer how to answer a question (i.e., job
priority), who is asking the question (i.e., user name), and how to answer the question (i.e., to
a printer).
Latitude/Longitude
Latitude is the distance north or south of the equator. Longitude is the distance east or west of
the prime meridian. To determine the latitude and longitude of the facility, a topographic map
from the United States Geological Survey (USGS) must be used.
Manufacture
To produce, prepare, compound, or import a listed toxic chemical.
NATP
The NATURAL Production environment.
NATURAL
The programming language utilized by TRIS.
NCC
National Computer Center. This is where EPA's IBM ES/9000 is located.
09/03/91 A - 5 GLOSSARY
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
NCSS
The Non-Confidential Systems Section is in the Public Data Branch (PDB), within the
Information Management Division (IMD) of the Office of Toxic Substances (OTS).
NLM
National Library of Medicine. This is where the public version of the TRI database resides.
NPDES
National Pollution Discharge Elimination System. It represents a nine digit number assigned to
a facility by EPA or the State under the authority of the Clean Water Act.
OCM
Office of Compliance Monitoring
Online
Online indicates a direct computer link. Requests are answered directly back to the computer
screen.
Online HELP
A key can be pressed to display helpful information on how to proceed while using a computer
system. In TRIS, this is .
Otherwise Use
Any use of a listed chemical at a facility that does not fall under the definitions of "manufacture"
or "process".
OTS
Office of Toxic Substances
Parent Company
The corporation or other business entity that is the ultimate United States parent company over
the reporting facility(s).
09/03/91 A - 6 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PDB
Public Data Branch
PF Keys
The Program Function keys (usually at the top of a computer keyboard) can be programmed to
make a system easy for the user. They may be marked "Fl" on a PC or "PF1" on a mainframe
terminal.
POTW
Publicly Owned Treatment Works
Process
The preparation of a listed toxic chemical, after its manufacture, for distribution in commerce.
Query
A question made to a computer, also known as: Online Search.
RCRA
Resource Conservation and Recovery Act
Reporting Package
The TRIS Reporting Package is mailed each year in January to facilities which submitted a Form
R the previous reporting year. The Reporting Package includes the latest Form R and detailed
instructions on how to successfully complete it.
Reporting Year
The Reporting Year is the calendar year being reported. For example, the Form R for Reporting
Year 1989 is due July 1, 1990, and covers toxic chemical releases from January 1, 1989 to
December 31, 1989.
RTP
Research Triangle Park is the location of the National Computer Center (NCC).
09/03/91 A - 7 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Sanitized Form R
The generic copy of the Form R (see Trade Secret).
SARA
Superfund Amendments and Reauthorization Act of 1986. On October 17, 1986, the President
signed into law the Superfund Amendments and Reauthorization Act of 1986 (SARA). Title III,
-Section 313 of SARA, known as the Emergency Planning and Community Right-to-Know Act,
mandates that an inventory of toxic chemicals released into the air, water, or land must be
maintained by the EPA, and that EPA must make this information available to the public.
SDSF
Spool Display and Search Facility. It is a software product used on the IBM ES/9000 by which
output held on the system can be viewed online.
Section 313
Section 313 is that part of Title III of SARA that requires owners and operators of certain
facilities that manufacture, process, or otherwise use a listed chemical to report annually their
releases of listed chemicals to any environmental medium. Section 313 also specifies that EPA
must publish a uniform toxic chemical release form.
Section 328
Provides EPA with the authority to promulgate such regulation as may be necessary to carry out
the purposes of Title in.
SIC
Standard Industrial Classification. SIC Codes classify business establishments by specific
activities that are performed at a single physical location. The first two digits of a four-digit SIC
code define a major business sector and the last two digits denote a facility's specialty within the
major sector.
Submission
A Form R from a single facility containing release and transfer information for a single chemical
that is entered into the Toxic Chemical Release Inventory database.
09/03/91 ' A-8 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Threshold
Section 313 reporting is required if threshold quantities are exceeded. The thresholds vary
depending upon the year for which the report is submitted and separate thresholds apply to the
amount of the chemical that is manufactured, processed, or otherwise used. A facility must
report for any listed chemical that is manufactured or processed over the course of the year in
excess of the following threshold:
For calendar year 1987: 75,000 pounds
For calendar year 1988: 50,000 pounds
For calendar year 1989 and subsequent years: 25,000 pounds
A facility must report if the quantity of a listed chemical that is otherwise used is 10,000 pounds
during the course of a calendar year.
Trade Secret
As prescribed in 40 CFR Part 350, published July 29, 1988 in the Federal Register (53 FR
28772), a facility can claim the CAS registry number and chemical name as trade secret. Two
Form Rs must be submitted for a chemical whose identity is claimed as a trade secret, one with
the a generic chemical name, and one that identifies the chemical. Only the information from
the generic one will be available to the public. A facility must have approval from EPA to claim
a toxic chemical as a trade secret.
TRIS
Toxic Chemical Release Inventory System (or TRI System). It is the computer system designed
by EPA to track the annual estimated release of toxic chemicals into the environment. TRIS is
a management tool used for collection and organization of toxic chemical release data received
from industries regulated under SARA.
TRISH
The NATURAL application library where end-users can perform their own programming against
the TRIS ADABAS files.
TRISONLN
The NATURAL application library where the online menu-driven system resides.
09/03/91 A - 9 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRI Data
All the pieces of information reported to EPA on Form R is sometimes referred to as TRI data
or Toxic Release Inventory Data.
TRI System
See TRIS
TRI Facility ID
EPA has designated a Facility ID (consisting of letters and numbers) to identify a Facility. It is
analogous to a social security number. The TRI Facility ID makes it possible to track
submissions from a facility across all reporting years.
TSO
Time Sharing Option. One of two means of interfacing with the IBM ES/9000, (see CICS).
UIC
Underground Injection Well Code. Twelve-digit number that permits a facility to inject toxic
chemicals into Class 1 deep wells. Numbers are assigned by EPA or by the State under the
authority of the Safe Drinking Water Act.
09/03/91 A-10 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX B
SAMPLE BATCH REPORTS
09/03/91 8 - 1 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 2 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
FORM R FACSIMILE
09/03/91 B - 3 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03*1 B - 4 SAMPLE BATCH REPORTS
-------
TRR04BF1 PAGE 1 U S. ENVIRONMENTAL PROTECT 014 AGENCY DCN : 13-89-03000102-4-0:
g 06X13X91 TOXIC CHEMICAL RELEASE INVENTORY REPU TING FORM FACSIMILE TRIFID: 19809DPNTD104HA
PART I. FACILITY IDCNTIFICATIO'. INFORMATION
I.I ARE rOU CLAIMING IDENTITY ON PAGE 3 TRADE SECRET? 1.2 IF 'E3 IN 1.1, IS THIS CO°Y: 1.3 REPORTING YEAR
1 < > YES < X > NO < > SANITIZED < > IIMSHNITIZLD 1989
Z. CERTIFICATION NAME
JOHN S KLOSS
CFRTIFICATION TITLE DATE SIGNED
PLANT MANAGER 06X10X90
3. FACILITY IDENTIFICATION
3.1 FACILITY OR ESTABLISHMENT NAME
DU PONT EDGE MOOR Jj
STREET AQD9ESS 55
104 HAY RD.
CITY COUNTY
Z
WILMINGTON NEU CASTLE Q
STATE ZIP CODE 3)
OE 19009
3.2 THIS REPOPT CONTAINS INFORMATION FOR: A. < X > ENTIRE FACILITY B. < > PAST OF A FACILITY
3.3 TECHNICAL CONTACT TELI PHONE NUMI r.K
JOHN C. CHANEY 302-761-2290
O, 3.4 PUBLIC CONTACT TELEPHONE NUMI FR
JOHN C. CHANLY 302-761-2290
01
3.5 SIC CODE
A. 2616
3.6 LATITUDE: 394449 LONGITUDE: 752530 C
CO
3.7 DUN AND BRADSTREET NUMBERS 3)
A. 154407645 CO
O
3.6 EPA IDENTIFICATION NUMBERS (RCRA I.D. NO.) O
A. DED000000264
CO 3.9 NPDES PERMIT NUMBERS
£ A. DE0000051 B. DE0050644
T)
m RECEIVING STREAMS OR HATER BODIES
CO A. DELAIIARE RIVLR
5 3.10 B.
O 0.
33 3.11 UNDERGROUND INJECTION WELL CODE (UIC) IDENTIFICATION NUMBERS / NA
rn
4. PARENT COMPANY INFORMATION
4.1 NAME OF PARENT COMPANY: OUPONT
4.2 PARENT COMPANY'S DUN AND BRADSTREET NuMBER: 001315704
-------
TRR04BF2
06/13/91
PAGE 2
CD
O>
1. PUBLICLY OWNED TREATMENT WORKS (POTUSI
1.1 POTH NAT1E
NA
STREET ADDRESS
T R I S FACSIMILE FORM R
PART II. OFF-SITE LOCATIONS TO HHICH TOXIC
CHEMICALS ARE TRANSFERRED IN HASTES
1.2 POTH NAME
STREET ADDRESS
DCN : 13-89-03000362-4-DE
TRIFID: 19609DPNTD104HA
CITY
STATE
COUNTY
ZIP CODE
CITY
STATE
COUNTY
ZIP CODE
>. OTHER OFF-SITE LOCATIONS
!.l OFF-SITE LOCATION NAME
DU PONT CHERRY ISLAND
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
NA
STREET ADDRESS
HAY ROAD
CITY COUNTY
EOGEHOOR NEH CASTLE
STATE ZIP
DE 19809
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< X > YES < > NO
2.3 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER CRCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< > YES < > NO
2.2 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL CF REPORTING FACILITY ?
< > YES < > NO
2.4 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY ?
< > YES < > NO
O
3J
3)
m
m
r-
(/>
m
o
O
m
I
3)
m
•o
O
I
2.5 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< > YES < > NO
2.6 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY ?
< > YES < > NO
-------
o
1
<£
~*
CD
I
•vl
CO
TJ
fil
CD
^
o
X
2J
m
1
TRR04BF3 PAGE 3 T R I S FACSIMILE FORM R
06/13/91 PART III. CHEMICAL-SPECIFIC INFORMATION
1 . CHEMICAL IDENTITY
1.1 (RESERVED)
1.2 CAS NUMBER
000463-58-1
1.3 CHEMICAL OR CHEMICAL CATEGORY NAME
CARBONYL SULFIDE
1.4 GENERIC CHEMICAL NAME
: . MIXTURE COMPONENT IDENTITY
NA
2. ACTIVITIES AND USES OF THE CHEMICAL AT THE FACILITY
MANUFACTURE THE A. < X > PRODUCE C. < > FOR ON-SITE D. <
1.1 CHEMICAL: USE/PROCESSING
B. < > IMPORT 1. < X > AS A BYPRODUCT F. <
3.2 PROCESS THE A. < > AS A REACTANT B. < > AS A FORMULATION C. <
CHEMICAL: COMPONENT
D. < > REPACKAGING ONLY
3.3 OTHERWISE USE A. < > AS A CHEMICAL B. < > MANUFACTURING C. <
THE CHEMICAL: PROCESSING AID AID
•
4. MAXIMUM AMOUNT OF THE CHEMICAL ON-SITE AT ANY TIME DURING THE CALENDAR YEAR
01
5. RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE A.I REPORTING RANGES A. 2
0 1-499 500-999 ESTIMATE
5.1 FUGITIVE OR NON-POINT AIR EMISSIONS 5.1 A NA
5.2 STACK OR POINT AIR EMISSIONS 5.2A 680000
5.3 DISCHARGES TO RECEIVING 5.3.1A 5.3.1A NA
STREAMS OR HATER BODIES
5.3.2B 5.3.2A
5.3.3C 5.3.3A
5.4 UNDERGROUND INJECTION 5.4A NA
5.5 RELEASES TO LAND
5.5.1 ON-SITE LANDFILL 5.5.1A NA
5.5.2 LAND TREATMENT/APPLICATION 5. 5. 2 A NA
FARMING
5.5.3 SURFACE IMPOUNDMENT 5.5.3A NA
5.5.4 OTHER DISPOSAL 5.5.4A NA
DCN : 13-89-03000382-4-DE
TRIFID: 19809DPNTD104HA
> FOR SALE/
DISTRIBUTION
> AS AN IMPURITY
> AS AN ARTICLE
COMPONENT
> ANCILLARY OR OTHER USE
BASIS OF
ESTIMATE
5. IB NA
5.2B M
C.X STORMHATER
5. 3. IB 5. 3. 1C
5.3.2B 5.3.2C
5.3.3B 5.3.3C
5.4B NA
5. 5. IB NA
5.5.2B NA
5.5.3B NA
5.5.4B NA
zj
CO
z
O
jS
— (
o
z
3)
33
m
<
£
CO
m
to
0
C
m
-------
1
-
03
00
CO
1
-a
m
m
H
3
rn
3)
5!
TRR04BF4 PAGE 4 T R I S FACSIMILE FORM R
06/13/91 PART III. CHEMICAL-SPECIFIC INFORMATION
TRANSFERS OF THE CHEMICAL IN HASTE TO OFF-SITE LOCATIONS
A.I REPORTING RANGES A. 2 ESTIMATE
0 1-499 500-999
6.1.1 DISCHARGE TO POTH 1.1 *•
6.1.2 DISCHARGE TO POTH 1.2 '•
6.2.1 OTHER OFF-SITE 2.1 NA 6.
6.2.2 OTHER OFF-SITE 2.2 '•
6.2.3 OTHER OFF-SITE 2.3 *•
6.2.4 OTHER OFF-SITE 2.4 6.
6.2.5 OTHER OFF-SITE 2.5 '•
6.2.6 OTHER OFF-SITE 2.6 *•
7. HASTE TREATMENT METHODS AND EFFICIENCY
A. GENERAL B. TREATMENT C. RANGE INFLUENT D. SEQUENTIAL
NASTESTREAM METHOD CONCENTRATION TREATMENT
7.1A A 7. IB A03 7. 1C 2 7.10
7.2A 7.2B 7.2C 7.20
7.3A 7.3B 7.3C 7.30
7.4A 7.4B 7.4C 7.40
7.5A 7. SB 7.5C 7.5D
7.6A 7.6B 7.6C 7.60
7.7A 7.7B 7.7C 7.70
7.8A 7.6B 7.8C 7.80
7.9A 7.9B 7.9C 7.90
7.10A 7.10B 7. IOC 7.10D
.). OPTIONAL INFORMATION ON HASTE MINIMIZATION
A. TYPE OF B. QUANTITY OF THE CHEMICAL IN HASTES C. INDEX
MODIFICATION PRIOR TO TREATMENT OR DISPOSAL
CURRENT YEAH PRIOR YEAR 1 OR PCT CHANGE
1
n<. 660000 840000 1 -19.00 1.1
1
B.
LIB
1.2B
2. IB
2.2B
2.3B
2.4B
2. SB
2.6B
E
7. IE
7.2E
7.3E
7.4E
7.5E
7.6E
7.7E
7. BE
7.9E
7.10
DCN : 13-69-030003B2-4-OE
TRIFID: 19609DPNTD104HA
BASIS OF C. TYPE OF TREATMENT/
ESTIMATE DISPOSAL
6. 2. 1C
6.2.2C
6.2.3C
6.2.4C
6.2.5C
6.2.6C
. TREATMENT EFF F. BASFO ON
ESTIMATE OPERATING DATA
YES NO
0.00 7. IF X
0.00 7.2F
0.00 7.3F
0.00 7.4F
0.00 7.5F
0.00 7.6F
0.00 7.7F
0.00 7.8F
0.00 7.9F
E 0.00 7.10F
0. REASON FOR ACTION
R4
3)
CO
g
S
3J
5
3)
m
m
>
CO
m
3)
CO
O
6
m
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
YEAR-TO-YEAR RELEASE/TRANSFER
COMPARISON
09/03/91 B - 9 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 10 SAMPLE BATCH REPORTS
-------
09/03/91
CD
1
SAMPLE
5
X
DO
m
1
TRRIOBP
PAGE : 1
TRI FACILITY ID:
FACILITY NAME :
ADDRESS :
CHEMICAL:
I OF SUBMISSIONS
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTH
OFF SITE
TOTAL TRANSFER
THE
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
YEAR-TO-YEAR RELFASE/TRANSFER COMPARISON REPORT
19809DPMTD104HA «*« NOTE: HISTORY RECORDS EXIST - THE NAME/ADDRESS INFO MAY
DU PONT EDGE MOOR
104 HAY RD.
WILMINGTON DE 19809
ALL CHEMICALS EXCLUDING DELISTED CHEMICALS
•/.Of X Of
1987 1986 CHANGE 1989 CHANGE 1990
8 7-13 6 -15 0
101774 22174 -79 38624 *74 0
935231 957010 +2 786 i40 -16 0
1071025 19770 -99 270 -99 0
00 0 0
0 39 48 «23 0
2108030 998993 -53 625162 -16 0
00 0 0
553000 1250000 «126 0 0
553000 1250000 +126 0 0
08/13/91
09:47:05
BE DIFFERANT FOR PREVIOUS YEAR
•/.or •/. of
CHANGE 1991 CHANGE
0
0
0
0
0
0
0
0
0
0
PERCENT CHANGE MILL BE CALCULATED (INLY IF BOTH APPLICABLE REPORTING YEARS ARE GREATER THAN ZERO.
33
V)
1
>
5
m
3
m
r—
. USERS
0
5
m
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 12 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
FACILITY PROFILE REPORT
09/03/91 B • 13 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B -14 SAMPLE BATCH REPORTS
-------
TRR03BP
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTM
06/13/91
21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 198090PNTD104HA
REGION
03
THI-FACILITY-IO
19809DPNTD104HA
EPA ID
DED000600264
NAME :
ADDRESS :
CITY/STATE/ZIP:
DU PONT EDGE MOOR
104 HAY RO.
WILMINGTON, DE 19609
CO
•O
73
m
3
I
OOCUMENT CONTROL NUMBER :
REPORTING YEAR
RPT6 FOR ENTIRE FACILITY
MAXIMUM AMOUNT CODE
CHEMICAL ID
CHEMICAL NAME
MIXTURE COMPONENT ID
CERTIFICATION NAME
CERTIFICATION TITLE
CERTIFICATION DATE SIGNED
CERT. SIGNATURE INDICATOR
FACILITY COUNTY
ASSIGNED DUNS NUMBER
ASSIGNED EPA ID
STATE/COUNTY FIPS CODE
ASSIGN CENTROID LATITUDE
ASSIGN CENTROID LONGITUDE
LATITUDE
LONGITUDE
PARENT COMPANY NAME
PARENT DUNS NUMBER
TECHNICAL CONTACT NAME
TECHNICAL CONTACT PHONE
PUBLIC CONTACT NAME
PUBLIC CONTACT PHONE
UIC ID
MAGNETIC MEDIA ID
13-69-03000362-4-DE
1969
A (AN ENTIRE COVERED FACILITY)
01 (0—99)
000463-58-1
CARBONYL SULFIDE
NA
JOHN 3. KLOSS
PLANT MANAGER
06/10/90
P (PHOTO COPY)
NEW CASTLE
154407645
DE0000600264
10003
394630
-752942
394449
-752530
DUPONT
001315704
JOHN C. CHANEY
(302) 761-229S
JOHN C. CHANEY
(302) 761-229S
NA
01353
*•« HASTE MINIMIZATION •»
WASTE MINIMUM CODE
WASTE MINIMUM CURRENT YEAR QTY
WASTE MINIMUM CRT YEAR QTY N/A
WASTE MINIMUM PRIOR YEAR QTY
WASTE MINIMUM PRIOR YR QTY N/A
WASTE MINIMUM PERCENT CHANGE
WASTE MINIMUM INDEX
WASTE MINIMUM ACTION CODE
M4 (PROCESS PROCEDURE MODIFICATIONS)
660,000
640,000
-19.00
1.1
R4 (SELF-INITIATED REVIEW)
3)
CO
o
33
3)
m
C
CO
m
o
o
m
EPA ID NUMBER(S)
DUNS NUMBER(S)
: DED000600284
: 154407645
SIC-CODE(S) : 2816
NPDES PERMIT NUMBER(S): DE0000051 DE0050644
-------
TRROJBP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
PAGE: 2 TOXIC RELEASE INVENTORY SYSTEM 21i02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19809DPNTD104HA
REGION TRI-FACILITY-ID EPA ID NAME : DU PONT EDGE MOOR
03 19809DPNTD104HA DED000600284 ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON, DE 19809
«» TYPES OF ACTIVITY/USES »»
MANUFACTURE : PRODUCE BYPRODUCT
g
V)
0>
3)
m
I
o
5
m
0)
CD
m
3
-------
1
TJ
CD
3)
m
CO
TRR03BP
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
06/13/91
21:02:25
-•ACUITY PROFILE REPORT FOR FACILITY ID: 19S09DPNTD104HA
HEGION
03
TRI-FACILITY-ID
19809DPNTD104HA
EPA ID
DED000800284
NAME : DU PONT EDGE MOOR
ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON. DE 19609
'« FUGITIVE OR NON-POINT AIR EMISSIONS *»
HEPORTING RANGE :
ESTIMATE : 0
ESTIMATE N/A : Y
OASIS OF ESTIMATE : NA
-» STACK OR POINT AIR EMISSIONS «*
REPORTING RANGE :
ESTIMATE : 680,000
ESTIMATE N/A :
OASIS OF ESTIMATE : M (BASED ON MONITORING DATA OR MEASUREMENTS)
DELAWARE RIVER
** DISCHARGE TO HATER ««
STREAM CODE
STREAM NAME
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
BASIS OF ESTIMATE
•/. FROM STORMMATER 0.00
•/. FROM STORMMATER N/A
v* UNDERGROUND INJECTION *«
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
»* RELEASE TO LAND ««
I AND DISPOSAL CODE : D02
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
(ON-SITE LANDFILL)
0
CO
1
33
m
CO
m
o
i
-------
TRR03BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY !'/i?/!i
pill; 4 TOXIC RELEASE INVENTORY SYSTEM 21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19e09DPNTD104HA
REGION TRI-FACUITY-ID EPA ID NAME : DU PONT EDGE MOOR
03 19809DPNTD104MA DED0006002a* ADDRESS : 10* HAY RD.
CITY/STATE/ZIP: HILMINGTON, DE 19B09
«» RELEASE TO LAND »*
LAND DISPOSAL CODE : D03 (LAND TREATMENT/APPLICATION FARMING)
REPORTING RANGE :
ESTIMATE : 0
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA ^
TJ
«* RELEASE TO LAND »• §
LAND DISPOSAL CODE : DOS (SURFACE IMPOUNDMENT) j£
REPORTING RANGE
ESTIMATE - =
ESTIMATE N/A : Y O
BASIS OF ESTIMATE : NA ^
OB HI
*» RELEASE TO LAND »» m
LAND DISPOSAL CODE : 099 (OTHER DISPOSAL)
REPORTING RANGE :
ESTIMATE : «
ESTIMATE N/A : Y CO
BASIS OF ESTIMATE : NA [g
CO
O
** DISCHARGE TO POTU ** Q
s
CO
FACILITY NAME
STREET ADDRESS
CITY
CO COUNTY
~— STATE
^ ZIP CODE
REPORTING RANGE
ESTIMATE
03 ESTIMATE N/A
BASIS OF ESTIMATE
O
DO
m
NA m
-------
_*
03
i
_i
to
5
2
T)
s
00
0
X
TRR03BP
PAGE: S
FACILITY PROFILE REPORT FOR FACILITY ID:
REGION TRI-FACILITY-ID EPA ID
03 19B09DPNTD104HA DED00080D2B4
<•« OTHER OFF-SITE LOCATION •»
OFF-SITE ID 19B09DPNTCHAYRO
OFF-SITE LOCATION CODE 1
EPA ID (RCRA ID NO. ) NA
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
TOXIC RELEASE INVENTORY SYSTEM 21:02:25
19fl090PNTD104HA
NAME : DU PONT EDGE MOOR
ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON, DE 19809
FACILITY NAME OU PONT CHERRY ISLAND
STREET ADDRESS HAY ROAD
CITY EOGEMOOR
COUNTY NEW CASTLE
STATE DE
ZIP CODE 19609
CONTROL OF RPT. FACIL. Y (YES, LOCATION IS UNDER CONTROL OF REPORTING FACILITY OR PARENT COMPANY)
REPORTING RANGE
ESTIMATE 0
ESTIMATE N/A Y
BASIS OF ESTIMATE
TREATMENT/DISPOSAL
** HASTE TREATMENT METHODS AND EFFICIENCY
GENERAL NASTESTREAFI CODE : A
TREATMENT METHOD CODE : A03
RANGE OF INFLUENTAL CONCENT. CODE: 2
SEQUENTIAL TREATMENT :
»»
(GASEOUS (INCLUDING GASES, VAPORS, AIRBORNE PARTICULATE3»
(SCRUBBER)
(100 PARTS PER MILLION (0.01 PERCENT) TO 1 PERCENT (10.000 PARTS PER MILLION))
TREATMENT EFFICIENCY ESTIMATE : 0.00
BASED ON OPERATING DATA : N
(NO. TREATMENT EFFICIENCY ESTIMATE IS NOT BASED ON ACTUAL OPERATING DATA!
— (
3)
V)
—
-n
o
D
S.
H
0
z
jj
m
H
3
m
>
r"
c
m
3
en
O
c
o
m
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 20 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CHEMICAL/GEOGRAPHIC/
SIC CODE REPORT
09/03/91 B - 21 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B-22 SAMPLE BATCH REPORTS
-------
TRR08BP
PAGE 1
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
CHEnlCAL/GEOGRAPHICAL/SIC CODE REPORT, REPORTING YEAR: 1969
REGION: 03 * STATE: VA « CITY: RICHMOND * * ZIP CODE: 00000 THRU 99999
DATA SORTED BY: • SFACIL-STATE * 8FACIL-CITY • • « « «
FACILITY NAME / ADDRESS
DOCUMENT CONTROL NUM CHEMICAL NAME FUG AIR
STACK AIR
HATER
UNDER INJ
06/13/91
21:05:16
LAND
JAMES RIVER CORP. FILTRATION PRODUCTS DIV-RICHMOND
TREDEGAR ST.
RICHMOND. VA 23219
13-89-0353217fl-5-VA FORMALDEHYDE 0 14,000
13-89-03532179-7-VA PHENOL 0 19,000
13-89-03532180-9-VA HETHANOL 160,000 1,200,000
«*« TOTALS FOR JAMES RIVER CORP. FILTRATION 160,000 1,233,000
1
7
160
166
CO
3
3J
CD
ro
CO
CO
>
TJ
REHRIG INTERNATIONAL
901 NORTH LOMBARDY ST.
RICHMOND, VA 23220
13-89-0355B346-3-VA NICKEL
13-89-03558347-5-VA HYDROCHLORIC ACID
«** TOTALS FOR REHRIG INTERNATIONAL
U.S. HISTORICAL SOCIETY
2422 EAST FRANKLIN ST.
RICHMOND, VA 23223
13-89-03573005-0-VA LEAD
««» TOTALS FOR U.S. HISTORICAL SOCIETY
0
73
73
0
146
146
250
250
3)
m
m
I
CO
m
3
o
6
m
3>
m
J.M. FRY CO. INC.
630 HULL ST.
RICHMOND, VA 23224
13-69-03542986-5-VA COPPER COMPOUNDS 000
250 LBS MAS USED FOR RELEASE ESTIMATE FOR 1-499 REPORTING RANGE. 750 LBS FOR 500-999 RINGE
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 24 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
REGIONAL TRIS SUBMISSIONS REPORT
09/03/91 B - 25 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 26 SAMPLE BATCH REPORTS
-------
«
u
CD
i
ro
0)
2
TJ
5
f^
£
3J
m
o
31
w
1RR05BP
PAGE : 1
UNITED
STATES ENVIIIONMENTAL PROTECTION
TOXIC RELEASE INVENTORY SYSTEM
AGENCY
HE/ 12/91
16:02-17
REGIONAL TRtS SUBMISSIONS REPORT
1RI FACIL ID/
DOC CNTL MUI1
242IOSTRLNNORHO
13-89-03506491-6-VA
24210HSTNGHIGHH
13-89-03524000-9-VA
2'i210USTNSHIGHH
13-B9-03524001-1-VA
24Z10HSTNSHIGHH
13-89-03524002-3-VA
24210HSTNGHIGHH
13-89-03524003-5-VA
23301PRDNCROUTE
13-89-03580523-7-VA
23301PRDNCROUTE
13-89-03580524-9-VA
23301PRDNCROUTE
13-B9-03580525-2-VA
22312TLNTC5390C
13-89-03575229-6-VA
22312TLNTC5390C
1 3-89-03575230-8-VA
YEAR:
FACILITY NAME
STERLING CASKET HARDHARE CO.
HESTINSHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
Era
HESTINGHOUSE ELECTRIC CORP.
EMU
PERDUE FARMS INC.
PERDUE FARMS INC.
PERDUE FARMS INC.
ATLANTIC RESEARCH CORP.
ATLANTIC RESEARCH CORP.
1989 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
FACILITY ADDRESS
NORWOOD RD.
ABINGDON
VA 24210
HUY. 11 HESTINGHOUSE RD.
ABINGDON
VA 24210
HHY. 11 UCSTINGHOUSE RD.
ABINGDON
VA 24210
HHY. 11 HESTINGHOUSE RD.
ABINGOON
VA 24210
HHY. 11 HI.STINGHOUSE RD.
ABINGDON
VA 24210
U.S. RTE. 13
ACCOMAC
VA 23301
U.S. RTE. 13
ACCOMAC
VA 23301
U.S. RTE. 13
ACCOMAC
VA 23301
5390 CHEROKEE AVE.
ALEXANDRIA
VA 22312
5390 CHEROKEE AVE.
ALEXANDRIA
VA 22312
TECH CONTACT NAME/
PHONE NUMBER
BEN B. SCOTT
(703) 628-7153
LISA M. GENTRY
(703) 676-9152
LISA M. GENTRY
(703) 676-9152
LISA H. GENTRY
(703) 676-9152
LISA M. GENTRY
(703) 676-9152
JAMES EICHELBERC.ER
(804) 787-2700
JAMES EICHELBERGER
(804) 787-2700
JAMES EICHELBERGER
(804) 787-2700
JENNIFER G. FOSTER
(703) 642-6448
JENNIFER G. FOSTER
(703) 642-6448
CAS MMBEP/
CHEMICAL NAME
71-55-6
1 . 1 , 1-TRICHLOROE PHANE
1330-20-7
XYLENE (MIXED ISOMERS)
1319-77-3
CRESOL (MIXED ISOMERS)
7440-50-8
COPPER
108-95-:
PHENOL
7782-50-5
CHLORINE
7664-41-7
AMMONIA
7664-93-9
SULFURIC ACID
1332-21-4
ASBESTOS (FRIABLE)
71-55-6
1 • 1 • 1-TRICHLOROETHANE
H
W^
3
D
1
o
3j
m
H
m
^
r~
C
tn
m
w
O
c
0
m
-------
TRROSOP
PAGE:
170
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
REGIONAL TRIS SUBMISSIONS REPORT
YEAR: 1989 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
06X12/91
16:02:21
TRI FACIL ID/
DOC CNTL NUN
FACILITY NAME
FACILITY ADDRESS
TFCH CONTACT NAME/
PHONE NUMBER
CAS NUMBER/
CHEMICAL NAME
»(«IHHHt«»»IHtlHHMHHHHHH>IHIIHMH»»«»fHHIIKHHHt
« REPORT SUMMARY *
TOTAL NUMBER OF SUBMISSIONS = 1667
00
•o
33
m
s
TOTAL NUMBER OF FACILITIES =
473
LIST OF ALL CAS NUMBERS (WITH CHEMICAL NAMES) USED:
(0
S
50-00-
55-63-
56-23-
63-25-
67-56-
67-63-
67-64-
67-66-
67-72-
71-36-
71-43-
71-55-
74-85-
74-87-
75-00-
75-05-
75-07-
75-09-2
75-15-0
75-21-8
75-35-4
75-55-8
75-56-9
75-65-0
76-13-1
77-78-1
78-84-2
78-87-5
78-93-3
79-01-6
79-06-1
79-10-7
79-11-8
80-62-6
FORMALDEHYDE
NITROGLYCERIN
CARBON TFTRACHLORIDE
CARBARYL
HETHANOL
ISOPROPYL ALCOHOL (MANUFACTURING, STRONG-ACID PROCESS ONLY. NO PROCESS
ACETONE
CHLOROFORM
HEXACHLOROETHAHE
N-BUTYL ALCOHOL
BENZENE
1,1,1-TRICHLOROETHANE
ETHYLENE
CHLOROMETHANE
CHLOROETHANE
ACETONITRILE
ACETALDEHYOE
DICHLOROHETHANE
CARBON OISULFIDE
ETHYLENE OXIDE
VINYLIDENE CHLORIDE
PROPYLENEIMINE
PROPYLENE OXIDE
TERT-BUTYL ALCOHOL
FREON 113
DIMETHYL SULFATE
ISOBUTYRALDEHYDE
1,2-OICHLOROPROPANE
METHYL ETHYL KETONE
TRICHLOROETHYLENE
ACRYLAMIDE
ACRYLIC ACID
CHLOROACETIC ACID
METHYL METHACRYLATE
3
i
c
m
O
O
m
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
POTW/OFF-SITE LOCATION REPORT
09/03/91 B - 29 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 30 SAMPLE BATCH REPORTS
-------
09/03/91 B - 31 SAMPLE BATCH REPORTS
TRR02BP UNITE
PAGE : 1
09:45:08.2
POTH/OFF-SITE LOCATION REPORT FOR TRI-OFF-SITE-
STREET: H143 36400 COLLEGE CT. / COUNTY: HAUKES
=====S========±================================
REGION TRI-FACILITY-ID: 53187LLYPR1045P
EPA-ID : HID006077976
DOC-CNTL-NUM : 13-89-03581823-4-HI
CAS NUMBER : 000071-55-6
CHEMICAL NAME: 1 ,1 ,1-TRICHLOROETHANE
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID: 53187LLYPR1045P
EPA-ID : HI0006077978
DOC-CNTL-NUM : 1 3-89-0358182 1-0-HI
CAS NUMBER : 007439-96-5
CHEMICAL NAME: MANGANESE
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID: 53187LLYPR1045P
EPA-ID : HID006077978
DOC-CNTL-NUM : 13-89-03581822-2-WI
CAS NUMBER : 007440-02-0
CHEMICAL NAME: NICKEL
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
D STATES ENVIRONMENTAL PROTECTION AGENCY 08/13/91
TOXIC RELEASE INVENTORY SYSTEM
POTH/OFF-SITE LOCATION REPORT
ID 53150BFHSTH143S **POTH/OFF-SITE NAME: BFI HASTE SYSTEMS TOWN *
HA / CITY: MUSKEGO / STATE: HI / ZIP: 53150
NAME : ALLOY PRODUCTS CORP.
ADDRESS : 1045 PERKINS AVE.
CITY/STATE/ZIP: HAUKESHA. HI 53187
SIC CODE: 3551
ESTIMATE
IN LBS.
0
NAME : ALLOY PRODUCTS CORP.
ADDRESS : 1045 PERKINS AVE.
CITY/STATE/ZIP: HAUKESHA. HI 53187
SIC CODE: 3551
ESTIMATE
IN LBS.
772
NAME : ALLOY PRODUCTS CORP.
ADDRESS : 1045 PERKINS AVE.
CITY/STATE/ZIP: HAUKESHA, HI 53187
SIC CODE: 3551
ESTIMATE
IN LBS.
1,834
TRIS INFORMATION RETRIEVAL USERS GUIDE
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 32 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
GEOGRAPHIC/CHEMICAL
PROFILE REPORT
09/03/91 B - 33 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 34 SAMPLE BATCH REPORTS
-------
TRR01BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
PAGE: 1 TOXIC RELEASE INVENTORY SYSTEM
GEOGRAPHIC LOCATION / CHEMICAL PROFILE REPORT
YEAR: 1969 REGION: 03 STATE: VA ZIP CODE: 23231 CITY: RICHMOND
RGN TRI-FACILITY-ID FACILITY NAME ADDRESS CITY / STATE
03 23231TTMCR4500S AT«T MICROELECTRONICS 4500 S. LABURNUM AVE. RICHMOND
RICHMOND WORKS VA
CAS NUMBER : 007664-41-7 SIC-CODE(S): 3672 3661 NA
CHEMICAL NAME: AMMONIA
TYPES OF RELEASES 00 1-499 500-999 ESTIMATE TYPES OF TRANSFERS
(SUMMARY) LB. LBS. LBS. IN LBS. (SUMMARY)
FUGITIVE AIR EMISSION 0 DISCHARGE TO POTH
STACK/POINT AIR EMISSION 17,700 OTHER OFF-SITE LOCATIONS
DISCHARGE TO HATER 0
UNDERGROUND INJECTION 0
RELEASE TO LAND 0
«» TOTALS FOR RELEASES: 17,700 «* TOTALS FOR TRANSFERS:
*• TYPES OF ACTIVITY/USES *»
MANUFACTURE : PRODUCE IMPORT ON-SITE USE SALE/DISTR BYPRODUCT
PROCESS : REACTANT FORMULATION ARTICLE REPACKAGING
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
RGN TRI-FACILITY-ID FACILITY NAME ADDRESS CITY / STATE
03 23231TTMCR4500S AT1T MICROELECTRONICS 4500 3. LABURNUM AVE. RICHMOND
RICHMOND HORKS VA
CAS NUMBER : 007762-50-5 SIC-CODE(S): 3672 3661 NA
CHEMICAL NAME: CHLORINE
TYPES OF RELEASES 00 1-499 500-999 ESTIMATE TYPES OF TRANSFERS
(SUMMARY) LB. LBS. LBS. IN LBS. (SUMMARY)
FUGITIVE AIR EMISSION 0 DISCHARGE TO POTH
STACK/POINT AIR EMISSION 151 OTHER OFF-SITE LOCATIONS
DISCHARGE TO HATER 0
UNDERGROUND INJECTION 0
RELEASE TO LAND 0
•• TOTALS FOR RELEASES: 151 «* TOTALS FOR TRANSFERS:
*« TYPES OF ACTIVITY/USES »•
MANUFACTURE : PRODUCE IMPORT ON-SITE USE SALE/DISTR BYPRODUCT
PROCESS : REACTANT FORMULATION ARTICLE REPACKAGING
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
06/12/91
16:04:16
rrsrssr rsrrrsrrr rrrrrr rr srrrzr sr rs=r
ZIP EPA-ID
23231 VAD066000993
OCN: 13-69-03511056-2-VA
00 1-499 500-999 ESTIMATE
LB. LBS. LBS. IN LBS.
59,500
0
59,500
IMPURITY
ZIP EPA-IO
23231 VAD066000993
DCN: 13-89-03511057-4-VA
00 1-499 500-999 ESTIMATE
LB. LBS LBS. 1. IBS.
0
0
0
IMPURITY
— (
33
V)
—
3
§
2
p*
33
m
33
m
i—
c
m
33
(/)
O
C
o
m
-------
TRPCIUP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 08/13/91
PAGE: 1 TOXIC RELEASE INVENTORY SYSTEM 09:44:13
GEOGRAPHIC LOCATION / CHEMICAL PROFILE REPORT
YEAR: 1969 REGION: 03 STATE: VA ZIP CODE: 23231 CITY: RICHrOND
«««*»* lt«Kltlt»*ft*Mft
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX C
EPA REGIONS AND STATES
09/03/91 C - 1 EPA REGIONS AND STATES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 C - 2 EPA REGIONS AND STATES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF STATES AND
EPA REGIONS (STATES)
Alabama (AL)
Alaska (AK)
Arizona (AZ)
Arkansas (AR)
California (CA)
Colorado (CO)
Connecticut (CT)
Delaware (DE)
4
10
9
6
9
8
1
3
District of Columbia (DC) 3
Florida (FL) 4
Georgia (GA) 4
Hawaii (HI) 9
Idaho (ID) 10
Illinois (IL) 5
Indiana (IN) 5
Iowa (IA) 7
Kansas (KS) 7
Kentucky (KY) 4
Listing of EPA Regional Offices by State
Louisiana (LA) 6
Maine (ME) 1
Maryland (MD) 3
Massachusetts (MA) 1
Michigan (MI) 5
Minnesota (MN) 5
Mississippi (MS) 4
Missouri (MO) 7
Montana (MT) 8
Nebraska (NE) 7
Nevada (NV) 9
New Hampshire (NH) 1
New Jersey (NJ) 2
New Mexico (NM) 6
New York (NY) 1
North Carolina (NC) 4
North Dakota (ND) 8
Ohio (OH) 5
Listing of States by EPA Regional Office
Region 1
Connecticut (CT)
Maine (ME)
Massachusetts (MA)
New Hampshire (NH)
Rhode Island (RI)
Vermont (VT)
Oklahoma (OK) 6
Oregon (OR) 10
Pennsylvania (PA) 3
Rhode Island (RI) 1
South Carolina (SC) 4
South Dakota (SD) 8
Tennessee (TN) 4
Texas (TX) 6
Utah (UT) 8
Vermont (VT) 1
Virginia (VA) 3
Washington (WA) 10
West Virginia (WV) 3
Wisconsin (WI) 5
Wyoming (WY) 8
American Samoa (AS) 9
Guam (GU) 9
Puerto Rico (PR) 2
Virgin Island (VI) 2
Region 2
New Jersey (NJ)
New York (NY)
Puerto Rico (PR)
Virgin Islands (VI)
Region 3
Delaware (DE)
District of Columbia (DC)
Maryland (MD)
Pennsylvania (PA)
Virginia (VA)
West Virginia (WV)
Region 4
Alabama (AL)
Florida (FL)
Georgia (GA)
Kentucky (KY)
Mississippi (MS)
North Carolina (NC)
South Carolina (SC)
Tennessee (TN)
Region 5
niinois (IL)
Indiana (IN)
Michigan (MI)
Minnesota (MN)
Ohio (OH)
Wisconsin (WI)
Region 6
Arkansas (AR)
Louisiana (LA)
New Mexico (NM)
Oklahoma (OK)
Texas (TX)
Region 7
Iowa (IA)
Kansas (KS)
Missouri (MO)
Nebraska (NE)
Region 8
Colorado (CO)
Montana (MT)
North Dakota (ND)
South Dakota (SD)
Utah (UT)
Wyoming (WY)
Region 9
Arizona (AZ)
California (CA)
Hawaii (HI)
Nevada (NV)
American Samoa (AS)
Guam (GU)
Region 10
Alaska (AK)
Idaho (ED)
Oregon (OR)
Washington (WA)
09/03/91
C-3
EPA REGIONS AND STATES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 C - 4 EPA REGIONS AND STATES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX D
FORMR
09/03/91 D - 1 FORM R
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 D - 2 FORM R
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
u
•Important Tvpe or print, read instructions before completing form )
Form Approved OMB No 2070-0093
Approval Expires -
Pane l of 5
u S Envir<>nrnental Protection Agency
TOXIC CHEMICAL RELEASE INVENTORY REPORTING FORM
Section 313 of the Emergency Planning and Community Rlght-to-Know Act of 1986
also known as Title III of the Super-fund Amendments and Reauthorfzatlon Act
IDENTIFICATION
INFORMATION
(This space tor your optional use I
Public reporting burden for tnis
collection of information n eitimaieo to
vary from 30 to 34 rtourf per response
with an average of 32 hours out
response including time for reviewing
instructions searching existing data
sources, gathering and maintaining tne
data nseded and completing and
reviewing the collection of information
Send comments regarding this burden
estimate or any other aspect of this
collection of information, including
suggestions lor reducing tnis burden, to
CriSt. Information Policy Branch
(PM-223) US EPA. 401 M St . SW.
Washington. 0 C 20460 Atln THI
Burden end to tns> Office ol Information
•ltd nei»»sln> Affairs, Otflcai ol
Management end Budget Paperwork
Beauctlen Pro|ecl (20793i
Washington O C 20603
1 1 Are you claiming tne chemical Identity on page 3 trade secret?
I I Yes (Answer Question 12, I I No (Do not answer I 2
Attacn substantiation forms I Go to Question 1 3 1
1 2 If -Yes' in 1 1 is this copy
I J Sanitized I J Unsanitized
1 3 Reporting Year
19
2 CERTIFICATION (Read and sign after completing all sections )
nereov certify that 1 nave reviewed me attached documents and that to me oeit of my knowledge and Mlief me suomiiied mformalion n true and
comoiete and tnai me amounts and values in mis raodrt are accurate based on reasonable estimates using data available to ine preoanjrs of tnis rep
Name and official title of owner'ooerator or senior management official
Signature
Date signed
3 FACILITY IDENTIFICATION
3 1
-aciiity or Establishment Name
Street Aaaress
C.ty
County
Zip Cooe
THI Facility identification Mumper
WHERE TO SEND COMPLETED FORMS:
1 EPCRA REPORTING CENTER
P O BOX 23779
WASHINGTON. DC 20026-3779
ATTN- TOXIC CHEMICAL RELEASE INVENTORY
2. APPROPRIATE STATE OFFICE (See instructions
in Appendix G)
"its report contains .113' r— at, or *or iCnec* oni* anei
i* anei r
a 1 -n enure lacmtv
f 1
L J s<*r' °' a '
33 I
'ecnnicai Contact
Teieonone Numoer (include area cooe)
3 4
; Public Contact
Teieonone Mumper (include area cooe)
3 6
Degrees
1 Dun 4 B'aastreet Numoerisi
37
3 B
E°A identification iNumoerisi (RCRA I O No i
3 9
NPOES Permit Numoerisl
Receiving Sl'eams or MVater Bodies tenter one na^e oer oo*l
3 10
3 11 ,
Unoergrouna injection v\en Coco lUiC) ucenui. cation Mumoerm
d PARENT COMPANY INFORMATION
Name ol Parent Comoany
Parent Camcanv s 2-n & Bradsueet Numoer
EPA Form 9350-1 (Rev i -Si) - Previous editions are oosoiete
07/31/91
D-3
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important Type or print, read instructions before completing form )
D
Page 2 of 5
R(Thls space for your optional use )
on NumtMf (RCRA O No |
Street Aoares«
City
State
County
is location unoer control ot reporting facility or parent company?
[ ]ve. [ ]N.
2 6 Olf-sue location name
EPA klentilicalion Numner (RCRA 4D No )
Street Address
City
State
is location unoer cont'Ol of reporting lacilily or parent company?
[ ]ve. [ ]»
|||||^^
[ ] Crtoeh if aodntonai t»ge* of Part 11 aro attaehea Hew many1' |||l|j|l^^
EPA Form 9350-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
D-4
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important Type or print, read instructions before completing form )
Page 3 of 5
&EPA
EPA FORM R
PART III CHEMICAL-SPECIFIC INFORMATION
(This space tor your optional use )
CHEMICAL IDENTITYIDo not complete this section if you complete Section 2 )
1 1 [Reserved)
I 2
CAS Number (Enl*r only on* numoar *aaclly at it apc*ars on tne 313 list Enwr MA if reporting * erwmical category )
Chemical or Chemical Category Name
MIXTURE COMPONENT IDENTITY (Do not complete this section if you complete Section 1 I
G*n*ric Chemical Nam* Providad by Suopliar (Limit in* nam* lo a maximum of 70 enaraclars (a a • numo*r« letlaff cpaoaf punctuation) J
3 ACTIVITIES AND USES OF THE CHEMICAL AT THE FACILITY (Cheek all (hat apply 1
Manufacture the
chemical
a I J Produce
b I ] Imoort
If produce or import
II For on-site
•I use/processing
e [ J As a byproduct
f 1 For sale/
0 L J distribution
1 [ ] As an Impurity
3 2
Process me
chemical
a [ J AS a reactant
d [ j Repacnaging only
[ 1 As a formulation
D I J component
[1 As an article
1 component
3 3
Otherwise use
the chemical
11 As a cnemical
J processing aid
I As a manufacturing aid
.[
J Ancillary or other use
4 MAXIMUM AMOUNT OF THE CHEMICAL ON-SITE AT ANY TIME DURING THE CALENDAR YEAR
I I I (enter cooe)
RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE
You may report releases of less than
1 000 pounds by checking ranges under A 1
(Do not use both A 1 and A 21
S 1 Fugitive or non-point air emissions
5 2 Stack or point air emissions
5 3 Discharges to receiving j I
streams or waier bodies 3 J * •——'
D
l£m«f l*tl*r coo* from Part i
Section 3 10 (ex sirtamrsl >n 532
tn« DON providM )
533
D
5 4 Underground Infection
5 5 Releases to land
5 5 i On-cita lanolin
552 Lana traarnieni'iootrcalion farming
553 Surlaeo imoounamanl
554 Oin*r disoosai
2a
S 3 la
5 3 2a
5 3 3a
S ta
Si la
5 5 2a
5 5 3a
A Total Release
(pounds/year)
A 1
Reporting Ranges
1.1Q M-«98 500-989
I 11 1 I 1
Mini
A 2
Enter
Estimate
I (Chock il aooilional mlormalion is Drovaao on Pin IV-SuM>lam*nlal information I
EPA Form 9350-1 (Rev i-9i| - Previous editions are obsolete
09/03/91
D-5
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
n D
(Important Type or prim, read instructions before completing form ) Page 4 of S
3 EPA
PART III.
EPA FORM R |TW8 SpaC° '°r V°Ur °PIIOnal USe '
CHEMICAL-SPECIFIC INFORMATION
(continued)
6 TRANSFERS OF THE CHEMICAL IN WASTE TO OFF-SITE LOCATIONS
You may report transfers
of less than 1 000 pounds by
checking ranges under A 1 (Do
not use Doth A 1 and A 2)
Direnarge to POTW ._. __
(enter location numDer 1.11
6 1 1 from Pan « Section 1 ) | ' | |_
Other off-site location __, , ,
. , , (enter location numDer 1 , 1
6 2 1 from Pan II Section 2 1 1 ' \ \
Other off-site location . . __
6_ » (enter location numDer loll
Z Z from Pan II Section 2)1 II
Other off-nte location __, __
(enter location numoer 1 ~ \ \
623 from Part II Section 2 ) | * | |
A Total Transfers B Basis of Estimate
(pounds/yr)
A 1 A 2
Reporting Ranges Enter
1-10 11-488 500-899 Estimate
(enter code)
[][][] BllbD
[][][] 6 2 1b 1 1
[][][] 622bll
[][][] 6 2 3b I )
C Type of Treatment/
Disposal
^^^(entercode^^^
622cWT1
623c|M| | |
[ ]( Check if additional information is provided on Part IV-Supplemental Information )
7 WASTE TREATMENT METHODS AND EFFICIENCY
DNot Applicabl e |NA| - Check if no on-site treatment is applied to any waste stream containing the cnemical or chemical
catagory
A General
Wastestream
(enter code)
7 la [ |
7 2a I I
7 3a [ |
7 4a | |
7 Sa | |
7 Sa ri
7 7a Q
7 8a Q
7 9a 0]
7 lOa Q
B Treatment
Method
(enter code)
7ib rm
72b rm
73b rm
7
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
n
(Important Type or print, read instructions before completing form )
A EPA
Use this
Number the
EPA FORM R
PART IV. SUPPLEMENTAL INFORMATION
section if you need additional space for answers to questions in Part III
lines used sequentially from lines in prior sections |e g . 5 3 4 612.7
D
Page 5 of 5
(This space for your optional use I
11)
fol?.'!.1.0 eAL ""FORMATION ON RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE
l« ari in. oection 5 3)
You may report releases of less than
1 000 pounds by checking ranges under A 1
(Do not use both A 1 and A 2)
5 3 Discharges to
receiving streams or
water bodies 53 1 — I 5
(Enter letter code from Pan I [~~|
Section 3 10 for nream(a) In c » c
tne oo« orovioed ) ' ' 5 3 1 1 5
,, n.,
3 a
3 a
3 a
A Total Release
(pounds/yr)
A
Reporting
1-10 It--
[ 1 [
Ranges Enter
99 500-999 Estimate
1 [ 1
[][][]
[][][]
B Basis of
Estimate
(enter code
In box
provided)
53_bD
5 3 b[_
C % From
Stormwater
5 3 c %
5 3 e %
fpDD.'T!i° cAL INFORMATION ON TRANSFERS OF THE CHEMICAL IN WASTE TO OFF-SITE LOCATIONS
l~an in, aection B)
You may report transfers
of less than 1.000 pounds by checking
ranges under A 1 (Do not use
botn A 1 and A 2)
Ditcnarge to POTW __
6, (enter location numoar 1 . 1
1 from Pan n Section l 1 [ ' | 1 1
Otner off-t.te location •—, •—,
6 2 tenter location numoer 2
from Part n Section 2 1 1 1 f 1
Otner off-tile location r— — i »— «i
6 2 (enter location numser 12
Otner off-lite location ,— — , __,
e 2 (enter location numoor * 1 1 1
" " from Pan 11 Section 2 I 1 * 1 | |
ADDITIONAL
A _arerai
Wastestream
(enter cooe
In box provided)
7 -n
7 -D
' -D
7 -D
7 a | |
' ~ *
7 a 1 1
' '
7 a | |
7 a | |
' ^ 1 i
*" '
A Total Transfers
(pounds/yr)
A 1
Reporting Ranges
1-10 11-499 500-999
[
[
[
[
[
1 f
[ ]
[ ]
1 f 1
[][][]
A 2
Enter
Estimate
B Basis of
Estimate
(enter code
In box
provided)
61 bD
62 b 1 1
62 b 1 1
62 b 1 1
C Type of Treatment/
Disposal
(enter code
In box
provided)
HUHyBfiBtfM
• SaSSB&iBiuSB^SBK
62 c [ivi] T~)
6 2
C|M| | |
62 cRTI
INFORMATION ON WASTE TREATMENT METHODS AND EFFICIENCY (Pert Ml. Section
3 T-eat-rent
Method
(enter code
In box provided)
7 b rm
' b MM
7 b rm
* » rm
7 b rm
7 b rm
7 b rm
7 b rm
: o rm
EPA Form 9350-1 (Rev 1-91) - Prevlou
C Range of
Influent
Concentration
(enter code)
7
7
7
7
7
7
7
7
-
• editions are
° n
- n
- n
- n
= n
= n
" n
= n
. i— i
* i
obsolete
0 Sec-er.-.'al
Treatment?
(check If
7 d[ ] 7
7 d[ ] 7
7 d[ ] 7
7 d[ ] 7
7 d[ 1 7
7 d[ 1 7
7 d[ ] 7
7 d[ ] 7
7 -[ ] -
E T-eatment
Efficiency
Estimate
e
%
e %
%
e *
e
e
e
e
e
%
*
%
%
•4
F
7
7
7)
Sasea on
Operating
Data?
Yes No
-'MM
-'[ ][ 1
7 f [ ] [ ]
7
-'[ ][ 1
7 f [ ] [ ]
7
7
f r i r i
' [ ] [ 1
7 f f 1 f 1
j
7
f r ] r i
09/03/91
D-7
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 D - 8 FORM R
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX E
MICRO-TO-MAINFRAME LINK
09/03/91 E - 1 MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIALLY LEFT BLANK
09/03/91 E - 2 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
MICRO-TO-MAINFRAME LINK
FEBRUARY 1990
Prepared by:
US Environmental Protection Agency
National Data Processing Division
National Computer Center
Research Triangle Park
North Carolina
09/03/91 E - 3 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Preface
Micro-to-Mainframe Link provides essential information for
users of the National Computer Center who transfer files between
the mainframe and a Personal Computer Each type of file
transfer is discussed including asynchronous, coax, LAN SNA
gateway, and Arbiter.
ill
09/03/91 E - 4 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CONTENTS
INTRODUCTION 1
ASYNCHRONOUS FILE TRANSFERS 2
KERMIT PROTOCOL 2
MS-KERMIT 5
MAINFRAME TO PC 5
MS-KERMIT DOWNLOAD PROCEDURES 6
CROSSTALK DOWNLOAD PROCEDURES 7
UPLOADING DATA TO THE MAINFRAME VIA
CROSSTALK OR MS-KERMIT 7
KERMIT BINARY FILE TRANSFER 8
COAX FILE TRANSFERS 10
IRMA CARD AND FORTE CARD 10
UPLOADING USING IRMA OR FORTE 10
CXI CARD 13
UPLOADING USING THE CXI CARD 13
DOWNLOADING USING COAX CARDS 13
LAN SNA GATEWAY FILE TRANSFERS 16
UPLOADING USING THE LAN SNA GATEWAY 16
DOWNLOADING USING THE LAN SNA GATEWAY 19
09/03/91 E - 5 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CONTENTS
ARBITER FILE TRANSFERS 21
TWO METHODS TO USE WITH ARBITER 21
UPLOADING USING ARBITER 22
DOWNLOADING USING ARBITER 25
COMMAND LINE TRANSFERS 30
INDEX Index-1
VI
09/03/91 E - 6 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INTRODUCTION
Although there are many data file transfer needs
within the Environmental Protection Agency, this
portion of the Guide to NCC Services is limited to
transfers of text or binary data from MS DOS, IBM-
compatible microcomputers to any of the NCC-IBM
mainframe computers. It is assumed that you have
acquired a User-ID and account on at least one of the
NCC-IBM mainframes and are able to log on to TSO.
For more information on registration procedures and
for detailed logon instructions, refer to the section of
this guide entitled Getting Started.
File transfers can occur across any micro-to-main-
frame connection except the NCC's System Network
Architecture (SNA) protocol converter, also referred
to as the Terminal/Controller Processor (TCP). The
NCC supports transfer accesses in the following
categories:
• Asynchronous: dialup, multiplexers, and DEC
terminal servers
• Coaxial. IRMA, CXI, and FORTE
• Local Area Network (LAN) SNA gateway
connections
Asynchronous connections are established through
modems such as HAYES 1200 or 2400 baud modems
or through direct wired connections. These direct
connections include multiplexer devices, often re-
ferred to as muxes, and DEC terminal servers.
09/03/91 E - 7 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ASYNCHRONOUS FILE TRANSFERS
KERMIT Hermit is a file transfer protocol which will ensure
PROTOCOL error free data transfer between two computers across
asynchronous communications connections. A Ker-
mit file transfer requires that both computers in-
volved have Hermit software available. The Hermit
file transfer protocol was developed several years ago
by Columbia University for transferring data to and
from mainframes. Columbia placed Hermit in the
public domain, and it has been developed for many
different computer systems including IBM-compat-
ible PC's and IBM mainframes. The version on the
NCC-IBM mainframe is called TSO-Kermit; the ver-
sion for the IBM PC is called MS-Kermit.
Both Crosstalk and MS-Kermit may be used on the
PC to accomplish Hermit text file transfers with
other computers across asynchronous connections.
» Crosstalk and MS-Kermit both accomplish file trans-
fers, but each has its own set of display menus and
screens. Their similarities lie in the fact that both
use the Hermit file transfer prototol.
While all versions of MS-Kermit will perform Hermit
file transfer, Crosstalk must be version 3.6 or later to
perform Hermit file transfers. The openingbanner of
Crosstalk will display the version as you start the
program as shown below:
09/03/91 E - 8 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK - XVI
Crosstalk XVI ver 3 7b
Copyrighl(C) 1982. 1988
Digital Communications Associates. Inc
All Rights Reserved
IBM Personal Computer Version
This screen will disappear after a few seconds, or you
can just press ENTER and the following screen will
appear:
09/03/91
E-9
MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
-CROSSTALK - XVI Status Screen
OTTline
NAme Crosstalk default settings
NUmber 0700
LOaded
CApture
STD
Off
' Communications parameters'
—_^ -——--—— fwa MIU*. i^i 0 i i Filler settuifis ^^^^^^
SPeed 2400 PArity Even DUplex Full DEbug Off LFauto OT
DAta 7 Slop I EMulate VT-100 TAbex Off BLankei OT
P0rt ' MO* Call INTilter On OUtfiltr On
ATten GS CD
SWitcIi Home
Key settings
I (~ SEnd control settings ~l
COramand ETX CO CWait None
BReak End LWait None
1) EMAIL
Available command files '
2) NEWUSER 3) SETUP 4) STD 5) TSO
Enter number for file to use ( l -12 X.
Command files allow you to automatically access the
hardware by storing the phone numbers and other
parameters in a macro-like file. For example, this
screen has been set up to allow access to TSO on the
mainframe simply by entering the number 5.
For more information on setting up your own com-
mand files, see the Crosstalk documentation or call
User Suoport.
09/03/91
E-10
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
MS-KERMIT
MAINFRAME
TO PC
Note that if you add or delete a command file, num-
bering will change because Crosstalk arranges the
files alphabetically.
For convenience, the MS-Kermit version includes the
Kermit transfer protocol along with a terminal emu-
lation program to allow you to log on to the main-
frame and transfer data in the same program.
Every mainframe/PC transfer (either direction) must
begin with the mainframe because you are using the
PC as a way to enter commands.
Transferring data from a mainframe to a PC is
commonly referred to as downloading. To begin a
Kermit file transfer from the mainframe to your PC,
log on to the IBM and get to the TSO READY prompt.
Refer to the section of this guide entitled Getting
Started for logon details. Then enter the following
at the TSO READY prompt:
READY
KERMIT
The following prompt will then appear:
Kermit-T50>
Then type SEND followed by the TSO data set name
you wish to transfer to your PC. A message should
appear instructing you to begin receiving data on
your PC An example follows:
09/03/91
E-11
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
f
I
Kermit-TSO»SEND data-set-name
Delay in seconds Before sending is 20
Escaoe to your local KERMIT and enter tne RECEIVE command
1
At this point procedures differ depending on whether
you are using Crosstalk (version 3.6 or later) or MS-
Kermit (currently version 2.30).
If you are using MS-Kermit, press CTRL-] followed
by C to escape to the command mode on the PC. In
newer versions of MS-Kermit, Alt-X will function the
same way.
The Kprmit-MS> prompt appeals on the screen
Enter RECEIVE in response to the prompt as shown
below:
MS-KERMIT
DOWNLOAD
PROCEDURES
Kermit-MS>RECEIVE
Kermit-MS: V2 30
File name
KBytes transferred
Receiving
Number of packets
Packet length
Number of retries-
Last error
Last warning
8 Jan 1988
DATA SET NAME
12345
In progress
0
1
None
None
The transfer begins and Kermit continues to display
the status of the transfer until it completes.
09/03/91
E-12
MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK
DOWNLOAD
PROCEDURES
Command?
If you are using Crosstalk, press your Attn (atten-
tion) key, which is usually defined as ESC, to go to the
PC. You will see a Command? prompt on the bottom
of your screen as shown below:
J
UPLOADING
DATA TO THE
MAINFRAME VIA
CROSSTALK OR
MS-KERMIT
Enter KERMIT RECEIVE in response to the prompt.
The file transfer begins ami luulmues to display the
status of the transfer until it is complete.
Commands can be abbreviated to their shortest
unique length. For example, RECEIVE can be short-
ened to REC.
Sending data from your PC to the IBM mainframe is
very much like receiving data. First log on to the
mainframe and get the TSO READY prompt. Then
type KERMIT to get the Kermit-TSO> prompt. Tell
the mainframe to begin receiving data by issuing a
RECEIVE data set command at the Kermit-TSO>
prompt as shown below:
Kermit-TSO>REC
Entering receive mode
Escape to your local KERMIT ana enter the SEND command
1
09/03/91
E-13
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Then escape from the terminal mode of MS-Kermit
or Crosstalk, (CTRL-] or Attn key as discussed be-
fore) and tell your PC to send the data you wish to
transmit. Crosstalk uses the following command at
the Command? prompt to send data to the TSO data
set:
KERMIT SEND filename
The command to do the same thing in MS-Kermit is
as follows:
SEND filename
An example follows:
Cotnmand?SEND myfile.txt
J
KERMIT BINARY
FILE TRANFER
Kermit binary file transfers are used when the data
being transferred is data that must not be changed.
Since text is represented differently on mainframes,
such as the NCC's IBM 3090, than on PC's, the text
must be converted as the data is transmitted. Kermit
translates unless you instruct it to leave the data
alone. Ifyou disable the translate feature, you will be
affecting a binary file transfer.
To transfer binary data you must first tell TSO-
Kermit to handle the data as binary by issuing the
8
09/03/91
E-14
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
following command at the Kermit-TSO> prompt prior
to starting your SEND or RECEIVE of any data:
SET FILE BINARY
To reverse this and start text file transfers the com-
mand is SET FILE TEXT.
MS-Kermit requires no special commands to switch
to binary mode from text mode. It recognizes the
mainframe activities as binary activities and switches
accordingly.
However, Crosstalk must be told to switch to binary
mode before starting to send or receive data with the
following entered at the Command? prompt:
r
V
Command?kermit mode binary
Binary file transfers must not be used when sending
text data from a PC to the mainframe to be further
edited or printed. The resulting data on the main-
frame will be useless except by another PC which
could download the data in binary mode and have a
duplicate copy of what was transferred to the main-
frame.
Binary data file transfers are useful for distributing
data such as WordPerfect files, dBASE files, and
Lotus files as well as programs for IBM-compatible
PC's.
09/03/91
E-15
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
COAX FILE TRANSFERS
Another method which is used within the EPA to
connect IBM-compatible PCs to the various IBM
mainframes uses coaxial cable (often referred to as
coax). This coax is connected to the PC by use of coax
adapters or interface cards installed inside the PC.
There are three major coax cards used within EPA
and supported by NCC User Support:
• IRMA
• FORTE
• CXI (PCOX)
All three products can perform file transfers pro-
vided that you have the right software installed on
your PC. As in any file transfer there must be
software on each computer capable of communicat-
ing with the other across the communications link.
The NCC supports one software package called
IND$FILE on the IBM mainframes which will com-
municate with any of the three interface cards men-
tioned.
IRMA CARD AND
FORTE CARD
UPLOADING
USING IRMA
OR FORTE
The IRMA card from Digital Communications Asso-
ciates (DCA) will transfer files using IND$FILE with
software on the PC called FT3270 SEND/RECEIVE.
The product called FTTSO is not supported by the
NCC and should not be used.
Like the IRMA card, the FORTE card, also manufac-
tured by DCA, uses the FT3270 SEND/RECEIVE
software.
To send, or upload, a file to the IBM mainframe from
your PC using the IRMA or FORTE card, the IRMA
or FORTE terminal software must be loaded as
10
09/03/91
E-16
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
resident in the PC's memory for FT3270 to work. See
the IRMA or FORTE manuals for more information
on making the terminal software resident.
Access the IBM through the IRMA or FORTE connec-
tion (often just by selecting the software from the
AUTOMAX menu). Then log on to TSO and get to the
READY prompt. See the section of this guide called
Getting Started for logon details. At the READY
prompt, press the HOTKEY.
The HOTKEY is usually defined as pressing both
shift keys simultaneously to escape to the DOS
prompt. At the DOS prompt enter the following
command:
SEND d:\path\pctile.typ tso.dsnllmbrjj [options)
Where the command elements are explained as fol-
lows:
d:\path\ represents the DOS path to the file to be
sent, such as C:\MAINV
pcfile.typ represents the DOS filename of the file to
be sent to the mainframe.
tso.dsn is the destination data set name in TSO fol-
lowed by an optional partitioned data set member
name if the target data set is a partitioned data set.
options at the end of the command may include any
of the following:
11
09/03/91 E - 17 MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
• Data Control Block (DCB) information:
BLKSIZE (size of logical data blocks)
LRECL (length of logical data records)
RECFM (record format such as fixed or van-
able)
SPACE (how much space to allow for the
data on the mainframe)
TRACKS or CYLINDERS to refer to the
SPACE option
• ASCII (to translate from ASCII to EBCDIC)
• CRLF (to define CRLF as end of logical rec-
ords)
• APPEND (to add the new data to an existing
data set on the mainframe;
For example, to send a small text file called
IRMATEXT.DOC from the PC's A: disk drive to a
data set in TSO called ABCW123.IRMATEXT with
member MAY0189 to be printed from the IBM main-
frame, the command would look like the following:
CVSEND A \IRMATEXT DOC 'ABCW123 IRMATEXT(MAY0189V
RECFM(FB) LRECL(SO) BLKSIZE(6160) SPACE(5.1) TRACKS ASCII CRLF
Since the DCB information is default values, the
command can be shortened to the following-
12
09/03/91
E-18
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CXI CARD
UPLOADING
USING THE
CXI CARD
DOWNLOADING
USING COAX
CARDS
SEND A:\IRMATEXT.DOC
'ABCW123.IRMATEXT(MAY0189)' ASCII CRLF
For more information on TSO data set data control
block information, refer to Section 3 of the IBM
Ready Reference or refer to IBM documentation.
After entering the SEND command, a status line
appears on the PC's screen and displays the progress
of the file transfer. When it is complete, you can
HOTKEY back to the TSO session and browse, edit,
or print the newly uploaded data set.
The CXI card from Novell (sometimes called the
PCOX card) has its own SEND/RECEIVE software
product. However, like FT3270 SEND/RECEIVE the
CXI SEND/RECEIVE soilwdie will communicate
with IND$FILE to transfer files to and from the
mainframe.
The SEND command syntax for the CXI/PCOX card
is the same as the IRMA and FORTE syntax unless
you are using the WINDOWED version of the CXI/
PCOX product. For the WINDOWED (multi-session)
product, a window designator such as A: must be
placed in front of the TSO data set name to direct the
data to the appropnate session for transfer to a TSO
data set.
For more information on WINDOWED CXI/PCOX
sessions see the PCOX documentation.
The RECEIVE command is used to move data from a
TSO data set to a file on your PC The command
syntax is as follows:
13
09/03/91
E-19
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
RECEIVE d:\path\pcfile.typ tso.dsn [(mbr)] [opt]
Where the command elements are explained as fol-
lows:
d:\path\ represents the DOS path to the file to be
created on the PC.
pcfile.typ represents the DOS filename of the file to
be received from the mainframe.
tso.dsn is the data set name in TSO from which you
wish to receive the data followed by an optional
partitioned data set member name if the source data
set is a partitioned data set.
There are fewer options at the end of the RECEIVE
command than in the SEND command:
• ASCII (to translate from EBCDIC to ASCII).
• CRLF (to define CRLF as end of logical rec-
ords)
• APPEND (to add the new data to an existing
file on the IBM PC).
For example, to receive a small text file called
IRiMATEXT.DOC to the A. disk drive on the PC from
a data set in TSO called 'ABCW123 IRMATEXT'
member MAY0189 to be merged into a WordPerfect
document on the PC, the command would look like
the following.
RECEIVE AAIRMATEXT DOC
'ABCW123 IRMATEXT(MAY0189)' ASCII CRLF
14
09/°3/91 E - 20 MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
After you enter the RECEIVE command, a status line
appears on the PC's screen and displays the progress
of the file transfer, as shown in the example below:
CVRECEIVE A \myirma doc 'target-dsn(mbr)1 ASCII CRLF
TRANSOI File transfer command being processed
TRANS02 Number of bytes of file transferred so far --> 8447
TRANS03 File transfer complete
Transfer statistics
Total no of chars received 8690
Actual no of data bytes 8447
overhead (x) 2
Transfer messages are different for each type of coax
transfer. But each will notify you that the transfer is
complete.
When your tranfer from the mainframe is complete,
you can edit, merge, or print the new PC file.
15
09/03/91
E-21
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
LAN SNA GATEWAY FILE TRANSFERS
PC TOKEN
RING LAN
PC Token Ring LAN's, installed throughout the
Agency, often provide an easily accessible pathway to
the IBM mainframe. EPA sites with Novell SNA
gateways will have the Novell Workstation software
available for 3270 emulation. This software is simi-
lar to the CXI/PCOX coax software discussed previ-
ously.
Like the CXI/PCOX software, the workstation soft-
ware must be loaded as resident in memory for the
SEND and RECEIVE software to function in the PC.
The main difference between the LAN file transfer
and the coax file transfer is in the SEND command.
The SEND command for the LAN conflicts with a
utility which is available for LAN users to send
messages to each other and is called SEND. To
resolve this problem NCC has renamed the file trans-
fer send command to the following:
SENDFILE
With the exception of SENDFILE, command syn-
taxes for sending and receiving are the same as for
the CXI/PCOX access method.
The LAN SNA Gateway software from Novell in con-
junction with the IBM Token Ring cards will transfer
files using IND$FILE with software on the PC called
CXI PCOX SEND/RECEIVE.
UPLOADING To send, or upload, a file to the IBM mainframe from
USING THE LAN your PC using the LAN SNA Gateway, the Gateway
SNA GATEWAY software must be resident on the PC's memory.
16
09/03/91
E-22
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
For more information on making the terminal soft-
ware resident, see the CXI PCOX manual.
Access the IBM through the LAN SNA Gateway
connection. Then log on toTSO and get to the READY
prompt. See the section of this guide called Getting
Started for logon details. At the READY prompt,
press the HOTKEY (usually defined as Alt-PageUp)
to escape to the DOS prompt. At the DOS prompt
enter the following command:
SENDFILE d:\path\pcfile.typ w.tso.dsn[(mbr)]
[options]
Where the command elements are explained as fol-
lows:
d:\path\ represents the DOS path to the file to be
sent, such as CAMAINV
pcfile.typ represents the DOS filename of the file to
be sent to the mainframe.
w: refers to the window you wish to transfer the data
with, since the gateway software operates in a win-
dowed mode.
tso.dsn is the destination data set name in TSO
followed by an optional partitioned data set member
name if the target data set is a partitioned data set.
options at the end of the command may include any
of the following:
17
09/03/91 E - 23 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
• Data Control Block (DCB) information:
BLKSIZE (size of logical data blocks)
LRECL (length of logical data records)
RECFM (record format such as fixed or vari-
able)
SPACE (how much space to allow for the data
on the mainframe)
TRACKS or CYLINDERS to refer to the
SPACE option
• ASCII (to translate from ASCII to EBCDIC)
• CRLF (to define CRLF as end of logical rec-
ords)
• APPEND (to add the new data to an existing
data set on the mainframe)
For example, to send a small text file called
PCOXTEXT.DOC from the PC's C: disk drive to a
data set in TSO called 'ABCW123.PCOXTEXT' with
member MAYO 189 using the A: window to be printed
from the IBM mainframe, the command would look
like the following:
C \>SENDFILE C \PCOyTEXT DOC
ASCII CRLF
18
09/03/91
E-24
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
DOWNLOADING
USING THE LAN
SNA GATEWAY
For more information on TSO data set data control
block information, see Section 3 of IBM Ready Ref-
erence and IBM documentation.
After entering the SENDFILE command, a status
line appears on the PC's screen and displays the
progress of the file transfer. When it is complete, you
can HOTKEY back to the TSO session and browse,
edit, or print the newly uploaded data set.
The SEND and RECEIVE command syntax for the
CXI/PCOX LAN SNA Gateway product is the same
as the CXI/PCOX coax card syntax
For more information on WINDOWED CXI/PCOX
sessions see the PCOX documentation
The RECEIVE command is used to move data from
a TSO data set to a file on your PC The command
syntax is as follows:
RECEIVE d:\path\pcfile typ w tso dsn|(mbr)|
[options!
Where the command elements are explained as fol-
lows.
d:\path\ represents the DOS path to the file to be
created on the PC.
w: refers to the window you wish to transfer the data
with, since the gateway software operates in a win-
dowed mode.
pcfile.typ represents the DOS filename of the file to
be received from the mainframe
19
09/03/91
E-25
MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
tso.dsn is the data set name in TSO from which you
wish to receive the data from followed by an optional
partitioned data set member name if the source data
set is a partitioned data set.
options include the following:
• ASCII (to translate from EBCDIC to ASCII)
• CRLF (to define CRLF as end of logical rec-
ords)
• APPEND (to add the new data to an existing
file on the IBMPC)
For example, to receive a small text file called
CXITEXT.DOC to the C' disk drive on the PC from
a data set in TSO called 'ABCW123.CXITEXT
member MAYO 189 through PCOX window A: to be
merged into a WordPerfect document on the PC, the
command would look like the following:
r-1 T
CVRECEIVE C \CXITEXT DOC A ABCW123CXITEXHMAY0189/
ASCII CRLF
I
I
After entering the RECEIVE command a status line
appears on the PC's screen and displays the progress
of the file transfer. When it is complete you can edit,
menre. or onnt thf new PC flip
20
09/03/91
E-26
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ARBITER FILE TRANSFERS
ARBITER FILE
TRANSFERS
TWO METHODS
TO USE WITH
ARBITER
Arbiter has many features including using the main-
frame as disk drive server, 3270 full-screen terminal
emulation, data translation, and file transfers. This
section will cover the file transfer features of Arbiter
Like MS-Kermit, Crosstalk, and IRMA, Arbiter can
transfer data between your PC and the NCC-IBM
mainframe. However, unlike all of the other meth-
ods available at the NCC, Arbiter is not specific to
any one connection type. It can attach IBM-compat-
ible PC's to the IBM mainframe using a variety of
connection methods. Arbiter supports almost all of
the NCC communications access methods. In addi-
tion, all features of Arbiter are available to you
regardless of the access method you choose to use
The NCC purchases, installs, and maintains the
Arbiter mainframe products The PC software com-
ponents and documentation are available at no charge
through PC Site Coordinators and Information
Centers at Washington and RTP Or Arbiter soft-
ware and documentation kits can be obtained from
NCC Production Control for a copy fee of $25.00 per
kit. Contact Production Control at one of the tele-
phone numbers listed below and be sure to have a
valid IBM timeshare account number available for
billing purposes
(FTS) 629-3609
(919) 541-3609
After logging onto Arbiter, there are two ways to
transfer a file-
Full-Screen Panels. Full screen panels prompt you
through the process All field data is retained from
one transfer session to the next to allow for easy
editing of repeated transfers
21
09/03/91
E-27
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
UPLOADING
USING ARBITER
Extended commands. You can issue extended
commands on the DOS command line. This is useful
when automating file transfers using the DOS batch
functions.
To start a transfer of data from the PC to the main-
frame using full-screen prompting, issue the com-
mand $ at the DOS prompt. The following screen
appears:
"Arbiter "
Main Services Selection Menu
02-15-90
Remote Disk Environment Services
External FUe Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
Vixx
Node
LliNAME
Fl-Help F2-Msgs F3-.Mam ESC-Quii AF2-ISRAF3-DOS
FlO-Select AFiO-Termmaie
22
09/03/91
E-28
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Select the EXTERNAL FILE INTERFACE (EFI)
option by moving the higlighted bar with your arrow
keys and pressing F10. The next screen then ap-
pears:
"Arbiter "
EiternaJ File Interface Services
02-15-90
File Transfer
• SEND
• RECV
• SENDR
• RECVR
PC file --» Hosi
Hosi — » PC File
Remote Disk --•> Host
Host --» RemcaeDisk
Other EFI Services
• SELECT
• DBXFER
• SUBMIT
Predefined Esiracuon
Database Transfer
SubnrJt Job to Hosi
Fl-Help F2-Msgs F3-Mam ESC-Qim AF2-ISRAF3-DOS
FlO-Selea
Next, highlight the SEND command and press F10.
The following screen appears:
23
09/03/91
E-29
MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
••Arbiter **
PC — » Host FUe Transfer 02-15-90
TEXT
Transfer 1
From:
FilePath C-
To:
HostDSN
Append No
TEXT
type BINARY
Member ( )
Fl-He!p F2-MS8S F3-Vam F4-EFI FIO-Exec ESC-Quit AF2-ISR AF3-DOS
. F3-T F6-4 F9-Viev
Specify the PC path and file name of the PC file you
wish to send, the TSO data set name which will
receive the data (including a member name if needed
for a partitioned data set), and the file transfer type
(TEXT or BINARY).
More information on the file transfer type may be
found in the Arbiter Users Guide in Chapter 21
24
09/03/91
E-30
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The filepath Held requires a valid PC file name and
optional path that references an existing PC Hie.
» The TSO data set field requires the name of a PRE-
ALLOCATED data set on the mainframe because
Arbiter is not capable of dynamic allocation of TSO
data sets. However, members of partitioned data
sets (PDSs) will be dynamically created once the PDS
is allocated.
DOWNLOADING Downloading data is easier than uploading because
USING ARBITER you need not allocate PC files. The receive process is
started like the send process by issuing the $ com-
mand at the DOS prompt. You will again see the
following screen:
25
09/03/91 E - 31 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
"Arbiter •*
Main Services Selection Menu
02-13-90
Remote Di$Jc Environment Services
External File Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
Vxix
Node
LUNAME
Fl-Help F2-M?gs F3-Main ESC-Quu AF2-ISR AF3-DOS
. FlO-SeJect AFiO-Terminate
V-L
Select the EFI option with the highlighted bar, being
sure to press F10 to select the option. The following
screen appears:
26
09/03/91
E-32
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
' " ' ' '<*#-,,-,„' '-' >''"','"'$'
r ->
'•Arbiter **
External File Interface Services 02-15-90
File Transfer
• SEND PC file — » Host
• RBCV Host -» PC File
• SENDR Remote Disk «» Host
• RECVR Host — » Remote Disk
Other EFI Services
• SELECT Predefined Extraction
• DBXFER Dataoase Transier
• SUBMIT Submit Job to Host
Fl-Help F2-Msgs F3-Mam ESC-Quit AF2-ISRAF3-DOS
^ F10 -Select j
•\
, f
it,
f
, z
i
w
&
Next, select RECV using the highlighted bar and
FlO. The following screen appears:
27
09/03/91
E-33
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
From:
"Arbiter •*
Host --» PC File Transfer 02- 1 5-90
The Host Data Set N
atne must be filled in
TEXT
Transfer Type
TEXT
FIXRBC
BINARY
HostDSN
Member
( )
To:
FilePaih
Replace
C: 1
No |
Fl-Help F2-MSRS F3-\1ain H-EFI FlO-Eiec ESC-Qu-i AF2-ISR AF3-DOS
On the Host ==» PC panel, specify the host data set
name and a member name if the data set is a parti-
tioned data set, a PC file name to receive the host
data, and the type of data transfer (TEXT or BI-
NARY)
The type of file transfer may be one of the selections
you see by pressing the F5 and F6 keys on your
keyboard with the cursor placed in the box labeled
28
09/03/91
E-34
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Transfer Type', or you may create a transfer type of
your own by pressing the F9 key.
For more information on modifying transfer charac-
teristics, see the Arbiter Users Guide, Chapter 21.
The last field on the the Host ==» PC screen is the
Replace field. The default is NO. If you place YES in
this box, you will overwrite the data in the PC file if
the PC file already exists; otherwise, the file transfer
will abort and tell you that the PC file cannot be
overwritten.
When all fields are complete, press F10 to begin the
file transfer. The PC will display a small window at
the bottom of your screen showing the status of your
file transfer. This window displays the name of the
file into which data is being written, the date and
time of the transfer, and the number of bytes trans-
ferred, as shown in the following example:
L
Replace
FI-Help
No
Host — » PC File Transfer
FILfcEXT 8192 2-15-90 328p
F2-Msgs F3-Main F4-EFI FIO-Eiec ESC-Quii AF2-ISR AF3-DOS
J
A
29
09/03/91
E-35
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
COMMAND LINE
TRANSFERS
You may suppress the full-screen panels of Arbiter
if you wish to use PC batch processing to transmit
and receive data from the mainframe. All of the
options available from the panels may be placed on
the command line of the $ command, as shown in the
following example:
[C\>$SENDldevlfilepaih /DSN-dsname /TXtype-TEXT /APPend /Batch
J
The $ SEND command is used to transfer data from
the PC to the mainframe. Some of the commonly
used options are as follows:
dev
filepath
Such as C' for a hard drive
Such as \DOS\ for a DOS subdi-
rectory.
/DSNs'dataset' Defines the TSO data set.
/TXtype=TEXT Transfer type such as TEXT or
BINARY.
/APPend
/Batch
Appends file to end of mainframe
data set.
Suppresses the Arbiter panels.
30
09/03/91
E-36
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
More information on other transfer options may be
found in the Arbiter Users Guide in Chapter 21.
31
09/03/91
E-37
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
$
A
$ command
Account
22
1
B
Arbiter file transfer 21
Arbiter PC software 21
Asynchronous transfer 1
AUTOMAX menu 11
Binary file transfer 1, 8, 9, 24, 28
Binary file transfer, using Arbiter 24, 28
Binary file transfer, using Crosstalk 9
Binary file transfer, using Kermit 8
Coax cards 10
Coax file transfer 10
Coaxial cable 10
Coaxial transfer 1
Columbia University 2
Command line transfers, using Arbiter 30
Command mode, on the PC 6
Command prompt 7
Command, abbreviating 7
Command, extended for Arbiter 22
Commands, KERMIT SEND 8
Commands, RECEIVE 6, 14, 19
Commands, RECV 27
Commands, SEND 6, 8, 11, 16, 23
Commands, SENDFILE 16
Crosstalk 2,3
CXI (PCOX) card 10
CXI i
CXI card 13
CXI, WINDOWED version 13
Data set, preallocated 25
DEC terminal server 1
Dialup connection 1
Index-1
09/03/91
E-38
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
Digital Communications Associates 10
Direct wired connection l
Documentation, for Arbiter 21
Downloading, using Arbiter 25
Downloading, using coax cards 14
Downloading, using Crosstalk 7
Downloading, using CXI 14
Downloading, using FORTE 14
Downloading, using IRMA 14
Downloading, using Hermit 5
Downloading, using MS-Kermit 6
Downloading, using the LAN SNA gateway 19
EFI (Extended File Interface) 23, 26
Extended command, for Arbiter 22
External File Interface 23, 26
File transfer, introduction 1
File transfer, Arbiter 21
File transfer, coax 10
File transfer, Kermit 2
File transfer, LAN SNA gateway 16
FORTE l
FORTE card 10
FT3270 SEND/RECEIVE 10
FTTSO 10
Full-screen panels, for Arbiter 21
E
F
H
HOTKEY
IND$FILE
IRMA
IRMA card
KERMIT RECEIVE
KERMIT SEND command
Kermit protocol
11, 13, 17
10, 16
1
10
7
8
2
Index-2
09/03/91
E-39
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
L LAN (Local Area Network) 1
LAN SNA gateway 1
LAN SNA gateway file transfer 16
Local Area Network 1
M Mainframe to PC 5
Modem 1
MS-Kermit 2,5
Multiplexer connection 1
N NCC Production Control 21
Novell workstation 16
P Preallocated data set 25
Production Control 21
Protocol converter 1
Protocol, file transfer 2
R RECEIVE command 6, 14, 19
Receive, using MS-Kermit 6
Receiving, using Arbiter 25
Receiving, using coax cards 14
Receiving, using Crosstalk 7
Receiving, using CXI 14
Receiving, using FORTE 14
Receiving, using IRMA 14
Receiving, using MS-Kermit 7
Receiving, using the LAN SNA gateway 19
RECV command 27
5 SEND command 6, 8, 11,16, 23, 30
SEND command, LAN SNA gateway 16
SENDFILE command 16, 17
Sending, using Arbiter 22
Sending, using Crosstalk 7
Sending, using CXI 13
Sending, using FORTE 10
Index-3
09/03/91
E-40
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
Sending, using IRMA 10
Sending, using LAN SNA gateway 16
Sending, using MS-Kermit 5
Shift keys (HOTKEY) 11
SNA (System Network Architecture) 1
SNA gateway 1
System Network Architecture (SNA) 1
Telephone numbers, Production Control 21
Terminal/Controller Processor (TCP) 1
Text file transfer 1, 24, 28
Text file transfer, command to set 9
Text transfer, compared to binary 8
Time Sharing Option 1
Token Ring card 16
Token Ring LAN 16
Translation, of text 8
TSO (Time Sharing Option) 1
TSO-Kermit 2
Uploading, using Arbiter 22
Uploading, using Crosstalk 7
Uploading, using CXI 13
Uploading, using FORTE 10
Uploading, using IRMA 10
Uploading, using LAN SNA gateway 16
Uploading, using MS-Kermit 7
User-ID 1
Workstation software 16
«U S Government Fpiniing Off ce flOO-TB-iJ"
Index-4
09/03/91 E - 41 MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIALLY LEFT BLANK
09/03/91 E - 42 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX F
KEYBOARD MAPPINGS
09/03/91 F -1 KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 F - 2 KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
KEYBOARD REVIEW
Program Function (PF) Keys
TRIS makes extensive use of program function (PF) keys to navigate from menu to menu.
Within TRIS the first three PF keys always produce the same result:
PF1 = HELP Online help
PF2 = MAIN Return to opening TRIS menu
PF3 = PREV Back up to previous menu
Unfortunately, the exact location, assignment, and number of PF keys vary greatly from keyboard
to keyboard. Documentation delivered with your terminal, emulation board, or communications
software will detail precisely how PF and other keys are mapped and sent to the mainframe.
Some common translations for PF keys are shown on the following pages. If different mappings
exist at your location, use the page provided at the end of this section to record them.
11/18/91 F-3 KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
MAINFRAME TERMINAL
Keyboard Configuration
PF1 / PF13
thru
PF12 / 24
Enter data and take the next logical action
Moves the cursor to the input field below the current one
Moves the cursor to the next input field
Stays on until or is pressed
Deletes one character
Moves the cursor to the first input field
Resets the terminal when a lock condition occurs
PF1 equivalent
PF12 equivalent
11/18/91
F-4
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
IRMA
Keyboard Configuration
The key sequences in brackets are for an enhanced PC keyboard operating in terminal emulation
mode using the IRMA terminal emulation software. TRIS functions described on the bottom line
of the mainframe screen (the PF keys) are accessible by pressing and the number
simultaneously. For example, PF1 calls a help screen in TRIS. When using IRMA, press
and 1 simultaneously.
+ 1
thru
+ 9
+ 0
+ <->
+ <=>
Enter data and take the next logical action
Moves the cursor to the next input field
Deletes one character
Moves the cursor to the first input field
Stays on until or is pressed
Reset locked terminal or turn off insert mode
PF1 equivalent
PF9 equivalent
PF10 equivalent
PF11 equivalent
PF12 equivalent
+ Return to PC (DOS)
11/18/91
F-5
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK
Keyboard Configuration
The key sequences shown in brackets are for an enhanced PC keyboard operating in terminal
emulation mode using the CROSSTALK terminal emulation software.
+ R
Enter data and take the next logical action
Moves the cursor to the next input field
Resets the terminal when a lock condition occurs
+ 1 +
thru
+ 9 +
PF1 equivalent
PF9 equivalent
+ 1 + 0 + PF10 equivalent
+ 1 + 1 + PF11 equivalent
PF12 equivalent
11/18/91
F-6
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PROCOMM PLUS
Keyboard Configuration
The key sequences shown in brackets are for an enhanced PC keyboard operating in terminal
emulation mode using the PROCOMM PLUS terminal emulation software.
Enter data and take the next logical action
Moves the cursor to the next input field
Deletes one character
Moves the cursor to the first input field
+ R
Resets the terminal
+ 1 +
thru
+ 9 +
PF1 equivalent
PF9 equivalent
+ 1 + 0 + PF10 equivalent
PF11 equivalent
+ 1 + 2 + PF12 equivalent
11/18/91
F-7
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USER'S GUIDE
Keyboad mapping for:
KEY
FUNCTION
11/18/91
F-8
KEYBOARD MAPPINGS
* U S Government Printing Office 1991 - 312-014/40024
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX G
REGIONAL ACCOUNT MANAGERS
09/03/91 G -1 REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 G - 2 REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Account Name
Region/Location
Account Manager
TNEI
NEIC/Denver, CO
TOSW
Office of Solid
Waste
TRID
SYCOM/Developers
TRIS
Headquarters
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-9419
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
09/03/91
G-3
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TOAQ
Office of Air Quality
Planning & Standards
TRIP
EPCRA Center
TRI1
Region 1
TRI2
Region 2
TRI3
Region 3
Charles Isbell
EPA/NADB/MDAD-OA&R
Mutual Building
RTF, NC 27711
(FTS) 629-5448
(919) 541-5448
Doug Sellers
OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-3587
(202) 260-3587
Michael McDougall
EPA/Region 1
JFK Federal Bldg.
Boston, MA 02203
(FTS) 835-3377
(617) 565-3377
Robert Messina
EPA/Region 2
26 Federal Plaza
New York, NY 10278
(FTS) 264-9850
(212) 264-9850
Kim Woodall
EPA/Region 3
841 Chestnut Big.
Philadelphia, PA 19107
(FTS) 597-9358
(215) 597-9358
09/03/91
G-4
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRI4
Region 4
TRIS
Region 5
TRI6
Region 6
TRI7
Region 7
TRI8
Region 8
Jesse Dooley
EPA/Region 4
345 Courtland St. NE
Atianta, GA 30365
(FTS) 257-2316
(404) 347-2316
Sandra Darden
EPA/Region 5
230 S. Dearborn Street
Chicago, IL 60604
(FTS) 353-1770
(312) 353-1770
David White
EPA/Region 6
1445 Ross Avenue
Dallas, TX 75202
(FTS) 255-6540
(214) 655-6540
Dale Parke
EPA/Region 7
726 Minnesota Avenue
Kansas City, KS 66101
(FTS) 757-2827
(913) 551-2827
Dianne Groh
EPA/Region 8
999 18th Street
Denver, CO 80202
(FTS) 330-1730
(303)293-1730
09/03/91
G-5
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRI9
Region 9
TRIO
Region 10
Judy Quan
EPA/Region 9
P5-2
75 Hawthorne St.
San Francisco, CA 94105
(FTS) 484-1802
(415) 484-1802
August (Gus) Parlier
EPA/Region 10
1200 6th Avenue
Seattle, WA 98101
(FTS) 399-2988
(206) 442-2988
*U.S. GOVERNMENT PRINTING OFFICE: 1991—517-003/47033
09/03/91
G-6
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
COMMENTS AND SUGGESTIONS
Please assist us in improving this publication. Your comments about the content, format, and
use of this publication are an important part in the input used for revisions.
Forward your comments to:
TRIS USER SUPPORT
401 M Street, SW
Washington, DC 20460
Page Circle One: Incorrect Unclear Incomplete
Comments
Date:
Name:
Company:
Address:
Telephone Number:
09/03/91 ~~ ~ COMMENT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 COMMENT
------- |