Toxic
Chemical
Release
Inventory
> «
«*«
A **»*«
** *«»***
A** ** *
a* «
Toxic Chemical Release Inventory System (TRIS)
Information Retrieval Users Guide
Office of Toxic Substances
U.S. ENVIRONMENTAL PROTECTION AGENCY
-------
It
1-
Toxic
Chemical
Release
Inventory
<**. u r
*
I
I
'A***
r »* *!
. .«.-,. .,-!
> 0 t « I <*«(**(*
if' «»K*'A*r » . -
. f r t
- t < r r
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
11/18/91 iii 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
HI 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 WhatisTRIS?
TRJS 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
19,897
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/91 T^T 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 iTs 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 am! 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 .
NETMAINft
U.S. Environmental Protection Agency
Menu System
Please enter selection or command and then press ENTER.
1. INFORMATION News Alerts a- \ User Memos
2. SYSTEM MENU System Select, .n Menu
3. EMAIL EPA Electronic Mail for 3270
4. APPLICATIONS EPA Applications Menu
5. INTER-AGENCY Inter-Agency Applications Menu
6. PUBLIC Public Access Applications Menu
Command >
Optional Quick Logon - USERID ===>
PASSWORD ==->
Fl/F13=Help F5/F17=Refresh F12/F24=Cancel
Date: 10/30/91
Time: 15:47:43
Terminal: T2312613
Logmode: S3278R2
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.
EPA2 TSO/E LOGON
-T2312611
PF1/PF13 «-> Help PF3/PF15 =«> Logoff PA1 ==> Attention PA2 ==> Reshow
ENTER LOGON PARAMETERS BELOW: RACF LOGON PARAMETERS:
USERID ===> ABC
PASSWORD =-=> NEW PASSWORD ===>
PROCEDURE -«-> GROUP IDENT --->
ACCT NMBR «=>
FIMAS «-=> BIN NUMBER «»>
SIZE > SYSOUT DEST ««>
COMMAND -==>
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
4)
5)
System News Alert messages (Figure 2-4) will appear followed by a READY prompt.
Type NATP and press .
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 HILL 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-ED 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.
S. ENVIRONMENTAL PROTECTION AGENCY
OFFICE OF TOXIC SUBSTANCES
05/14/91
14:35:29
TTTTTTTTTTTTTTT
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
RRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRRlT IIIIIIIIIII
RRRRR RRRRRR IIIII
RRRRR RRRRR IIIII
RRRRR RRRRR 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
SSSSSSS
sssssssssss
sssssssssssssss
sssss 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 PF10PF11PF12
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. Sor . of these features are:
> Field level HELP with pop-up windows
> Use of wildca- '*) in searching
> Addition of b, 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
Number of Submissions
*1987*
79.051
*1988*
84,693
*1989*
82.513
Enter-PFl --- PF2 --- PF3 --- PF4 ---
CONT
--- PF7 --- PF8 --- PF9 --- PF10 PF11 PF12-
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 TOXIC RELEASE INVENTORY SYSTEM OS/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 PF10PF11PF12-
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~^8 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 .
NETMAINI U.S. Environmental Protection Agency Date: 10/30/91
Menu System Time: 15:47:43
Terminal: T2312613
Logmode: S3278R2
Please enter selection or command and then press ENTER.
1. INFORMATION News Alerts and User Memos
2. SYSTEM MENU System Selection Menu
3. EMAIL EPA Electronic Mail for 3270
4. APPLICATIONS EPA Applications Menu
5. INTER-AGENCY Inter-Agency Applications Menu
6. PUBLIC 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
05/30/91
16:24:57
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
RRRRRRRRRRR
RRRRRRRRRRRRR
RRRRRRRRRRRRRR
RRRRR RRRRRR
RRRRR RRRRR
RRRRR RRKRR
RRRRR RRRRRR
RRRRRRRRRRRRRRR
RRRRRRRRRRRRRR
RRRRR RRRRR RELEASE
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
RRRRR RRRRR
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
IIIII
mil
mil
mil
mil
mil
inn
mil
mil
iiiiniiiii
iiiiiiiim
iiiiiiiim
3.0
user name , Press for System
SSSSSSS
sssssssssss
sssssssssssssss
sssss 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 PF10PF11PF12--
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* *1988* *1989*
Number of Submissions 79,057 84.693 82,513
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
CONT 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
MAP: TRMOOOM1
TOXIC RELEASE INVENTORY SYSTEM
DATA RETRIEVAL MENU
05/16/91
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 PF10PF11PF12
HELP EXIT
Figure 2-15
11/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 '.-our USER ID, press and type your
PASSWORD, and press . (If Deviously 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.
1. INFORMATION News Alerts and User Memos
2. SYSTEM MENU System Selection Menu
3. EMAIL EPA Electronic Mail for 3270
4. APPLICATIONS EPA Applications Menu
5. INTER-AGENCY Inter-Agency Applications Menu
6. PUBLIC Public Access Applications Menu
Command ===>
Optional Quick Logon - USERID -«>
PASSWORD ===>
Fl/F13-Help F5/F17=Refresh F12/F24-Cancel
Date: 10/30/91
Time: 15:47:43
Terminal: T2312613
Logmode: S3278R2
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: TRISLOGO
MAP: LOGOMAP1
U. S-. ENVIRONMENTAL PROTECTION AGENCY
OFFICE OP TOXIC SUBSTANCES
05/30/91
16:24:57
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
RRRRRRRRRRR
RRRRRRRRRRRRR
RRRRRRRRRRRRRR
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
IIIII
IIIII
IIIII
IIIII
IIIII
3.0 IIIII
IIIII
IIIII
IIIIIIIIIII
IIIIIIIIIII
IIIIIIIIIII
Press for System
SSSSSSS
sssssssssss
sssssssssssssss
sssss ssss
sssss ssss
ssssss
ssssss
ssssss
ssssss
ssssss
ssss sssss
ssss sssss
sssssssssssssss
ssssssssssss
ssssssss
Messages
Enter-PFl --- PF2 --- PF3 --- PF4 --- PF5 ---
CONT
^ PF7 --- 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: 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.
***** + ***********x*******************************irx>rx*xx**)tir********x»
Reporting Year *1987* *1988* *1989*
Number of Submissions 79,057 84,693 82,513
Enter-PFl --- PF2 --- PF3 --- PF4 --- PF5 --- PF6 --- PF7 ---
CONT
^ PF9 --- PF10 PF11 PF12-
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
MAP: TRMOOOM1
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-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
-------
THIS 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^3TRIS 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 Length
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
Type
13
Reporting
Year
87
Sequence
Number
00000101
Check
Digit
1
State
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
,__... 0 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^6 TRIS 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^7 TRIS 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
MAP: TRQOOOM1
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 PFb PF6 PF7 PF8 PF9 PF10PF11PF12
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 YEAR....> 1989
FACILITY NAME....> 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 PF10PF11PF12-
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 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS90OMA FACILITIES 14:26:47
YEAR: 1989 FACILITY NAME: DU PONT
MARK FACILITY NAME
X 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
C*
TRI ID
27239DPNTCRT1BO
43612DPNTC710MA
29020DPNTMPODRA
08023DPNTCRT130
37415DPNTC4501A
19801DPNTC501CH
52730DPNTCHIGHW
29411DPNTCCYPRE
78362DPNTCHIGHW
* SUBM
3
2
9
54
5
1
1
11
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. : DUPONT
Ehtcr-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PRBV QMENU RPTS DCNS
Figure 5-4
09/03/91
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
MAP: TRS900MD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
FACILITY LATITUDE
FACILITY LONGITUDE
+0353645
-0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE
EPA ASSIGNED LONGITUDE
Enter-PFl PP2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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 CSP 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 PF10PF11PF12
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: TRS910MA SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY 10: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL NUM CHEMICAL NAME
X 13-89-03Q00421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
~ 13-89-03000423-2-NC METHANOL
Enter-PFl PF2 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
HASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONG TREATMENT EFFICIENCY/NA DATA
H R03 1 90.00 / N
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMBNU RPTS
Figure 5-8
09/03/91 5 - 8 ONLINE QUERIES
-------
TRIS 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 HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
FACILITY NAME : DU PONT CfcP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL HUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
HASTE 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-PFT PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PFI2
HELP MAIN PREV QMENU RPTS
Figure 5-9
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-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 NAME : DU PONT CfrP 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 PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU 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: TRS910N
MAP: TRS910MF
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
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
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl PF2 PF3-PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
HELP MAIN PREV O.MENU 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 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 PF7 PF8 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: TRQ020P TOXIC RELEASE INVENTORY SYSTEM 04/05/91
MAP: TRQ020M1 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
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
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.
5)
PGM: TRQ020N2 TOXIC RELEASE INVENTORY SYSTEM 06/12/91
MAP: TRS900MA FACILITIES 15:27:26
YEAR:
MARK
X
1969 STATE: NC COUNTY: DAVIDSON
FACILITY NAME
CAROLINA SEATING CO.
COBLE DAIRY PRODUCTS
COUNCILL CRAFTSMEN tl
DIXIE DINING ROOM DIV.
DIXIE FURNITURE CO. INC.
DIXIE FURNITURE CO.
DU PONT C&P HEALING SPRINGS
DURACELL USA
FOAM TECH INC.
HERMAN FURNITURE CO.
TRI ID
27263CRLNS101LI
27292CBLDR707NO
27239CNCLBPOBOX
27292DXFRNNCHUR
27292DXFRN411SS
27299DXFRNOLDLI
27239DPNTCRT1BO
27292DRCLL305NE
27292FMTCH117CE
27292HKMNF37PIC
* SUBM
1
2
5
5
5
6
3
5
1
1
Eiiter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU NEXT RPTS -PAGE -1-PAGE FACIL DCNS RELTR COORD
Figure 5-14
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: TRQ01ON3 TOXIC RELEASE
MAP: TRS900MB FACILITY
INVENTORY SYSTEM
INFORMATION
05/16/91
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 : NCD00047S608
PARENT DUNS: 001315704
PARENT CO. : DUPONT
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-15
09/03/91
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: TRS900MD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
FACILITY LATITUDE : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE
ZIP CENTROID LONGITUDE
EPA ASSIGNED LATITUDE
EPA ASSIGNED LONGITUDE
+0353800
-0800606
Enter-PFl --- PF2 --- PF3 --- PF4 --- PF5 --- PF6 --- P
HELP MAIN PREV QMENU RPTS
v^ PF8 --- PF9 --- PF1 O^H
DCNS
PF12 ---
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: TRS90OMC
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
These amounts are the totals
for all submissions for this
facility and Reporting Year.
RELEASES
FUGITIVE AIR 11,300
STACK AIR 32,600
WATER
UNDERGROUND
LAND
TOTAL RELEASES 43,900
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
Enter-PFl PF2 PF3 PF4 PFS PFfi PF7 PF6 PF9PFlOPFllPFl2
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-17
Releases include five types: Fugitive Air, Stack Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTN) 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:
HAP:
TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
TRS91OMA SUBMISSIONS AND CHEMICALS 14:28:06
FACILITY NAME : DU PONT C&P HEALING SPRINGS
TRI FACILITY ID: 21239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL MUM CHEMICAL NAME
X
13-89-03000421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
13-89-03000423-2-NC METHANOL
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT HASTE RELTR USES
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: TRS910N TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MC SUBMISSION HASTE TREATMENT INFORMATION 14:29:03
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
HASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONG TREATMENT EFFICIENCY/NA DATA
W R03 1 90.00 / N
Enter-PFl EF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
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
'MARX,' and press . The Submission Waste Minimization Information screen
(Figure 5-20) 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 CfiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL HUM: 13-89-03000421-B-NC
CHEMICAL NAME: AMMONIA
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION
CURRENT REPORTING YEAR
PRIOR REPORTING YEAR
PERCENT CHANGE
INDEX
REASON FOR ACTION
NA
NA
MAXIMUM AMOUNT ON SITE: 1,000 TO 9,999 LBS.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
HELP MAIN PREV QMENO 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: TRS91OME
TOXIC RELEASE INVENTORY SYSTEM 05/16/91
SUBMISSION RELEASES AND TRANSFERS 14:29:27
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
RELEASES
FUGITIVE AIR
STACK AIR
WATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
Enter-PFl PF2-
HELP MAIN
300
3,600
3,900
REPORTING FOR: AN ENTIRE FACILITY
PF3 PF4 PF5 ?F6 PF7 Pi 8 tfk'9 PF10 PF11 PF12
PREV QMENU RPTS
Figure 5-21
09/03/91
5-17 ONLINE QUERIES
-------
THIS 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
MAP: TRS910MF SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL HUM: 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 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: TRS910N TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS910MB 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. KISER
PHONE: 609/540-2666
PUBLIC CONTACT: C. A. CREHEANS
PHONE: 704/869-4571
Entec-PFl- PF2 PF3 PF4 PF5 PF6 PF7 PFB PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU RPTS
Figure 5-23
09/03/91 5 - 18 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The following Tables show PF Keys and corresponding functions for the City / 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 RPTS
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: TRQ030P TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ030MA 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
28208KLRTX2900H
28655SYNTHAMHER
28621WYRHSRT30F
27316WMNC POBOX
* SUBM
3
11
6
8
1
3
3
1
14
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF& 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
MAP: TRS900MB FACILITY
INVENTORY SYSTEM
INFORMATION
05/16/91
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 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-26
09/03/91
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 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 :
--- PFb --- PF7 --- PF8 --- PF9 --- PFlO^PFll PF12 ---
RPTS DCNS
Enter-PFT^
HELP MAIN PREV QMENU
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: TRQ01ON3
MAP: TRS90OMC
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-PFT^-PFZ PF3 PF4 PFS^-PFb PF7 PF8 PF? PF10PF11PF12
HELP MAIN PREV QMENU RPTS 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 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS910MA SUBMISSIONS AND CHEMICALS
05/16/91
14:26:06
FACILITY NAME : DU PONT CfiP HEALING SPRINGS
TRI FACILITY 10: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL HUM CHEMICAL NAME
X 13-89-03000421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
13-89-03000423-2-NC METHANOL
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU CNTCT RPTS -PAGE +PAGE TREAT HASTE RELTR USES
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 OS/16/91
MAP: TRS910MC SUBMISSION WASTE TREATMENT INFORMATION 14:29:03
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
HASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
HASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
H R03 1 90.00 / N
Entec-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11--PF12
HELP MAIN PREV QMENU RPTS
Figure 5-30
09/03/91 5 - 24 ONLINE QUERIES
-------
TRIS 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-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
HASTE 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 PF2 PF3 PF4 PF3 PFb^PF/^^PFS PF9 PF10PF1IPF12
HELP MAIN PREV QMENU RPTS
Figure 5-31
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-32) 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 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
WATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF -SITE
TOTAL TRANSFER
300
3,600
3,900
REPORTING FOR: AN ENTIRE FACILITY
Enter-PFl PF2 PF1 PF4 PF5 PF6 PF7 - -PF8 PF 9 PF10 Pt 11 VEL2
HELP MAIN PREV QMENU RPTS
09/03/91
Figure 5-32
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: TR5910N
MAP: TRS910MF
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
FACILITY NAME : DU PONT C&P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL HUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Entec-PFl PFZ PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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 .
PCM: TRS910N 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: 27239DPNTCRT180 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 PF7 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
-------
TRIS 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 ED
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 INVENTOR* SYSTEM 06/13/91
MAP: 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 =-=> _
Entet-PFl PF2 PF3 PF4 PF5 PF6 PP7 PF8 PF9 PF10PF11PF12
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 ED. 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: TRQ04OP1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ040M2 FACILITY KEY SEARCH BY TRI FACILITY ID 14:53:07
REQUIRED
REPORTING YEAR.
TRI FACILITY ID.
OPTIONAL
CAS NUMBER.
OR
CHEMICAL/CATEGORY NAME.
Key selection
...> 1989
...> 27239DPNTCRT1BO
. ..>
. ..>
criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
09/03/91
Figure 5-36
5 - 29 ONLINE QUERIES
-------
TRIS 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
ED and the number of submissions received from the facility for that Reporting Year are
displayed on each line.
4)
PGM: TRQ04OP1 TOXIC RELEASE INVENTORY
MAP: TRS90OMA FACILITIES
YEAR: 1989 TRI FACILITY ID: 27239DPNTCRT1BO
MARK FACILITY NAME
X DU PONT CtP HEALING SPRINGS
SYSTEM 06/13/91
14:54:15
TRI ID t SUBM
27239DPNTCRT1BO 3
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11-- -PF12
HELP MAIN PREV QMENU RPTS FACIL DCNS RELTR COORD
Figure 5-37
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 CSP 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. : DUPONT
Enter-PFl PF2 PF3---PF4 PF$ PF6 PF7---PFd PF9 PFl6--PFil-1-PFl'2---
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-38
09/03/91
5 - 30 ONLINE QUERIES
-------
THIS 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 : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : -1-0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE :
EPA ASSIGNED LONGITUDE :
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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
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 PF7 PF8 PF9 PF10PF11PF12
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: 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 HUM CHEMICAL NAME
X 13-89-03000421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
~ 13-89-03000423-2-NC METHANOL
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENO CNTCT RPTS -PAGE +PAGE TREAT HASTE RELTR USES
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 05/16/91
MAP: TRS91OMC SUBMISSION HASTE TREATMENT INFORMATION 14:29:03
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
HASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
H 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-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: TR5910N
HAP: TRS910MD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
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
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION
CURRENT REPORTING YEAR
PRIOR REPORTING YEAR
PERCENT CHANGE
INDEX
REASON FOR ACTION
NA
NA
MAXIMUM AMOUNT ON SITE: 1,000 TO 9,999 LBS.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PFB PF9 PF10PF11PF12
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: TRS91ON
MAP: TRS910ME
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 HUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES
FUGITIVE AIR
STACK AIR
WATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
300
3,600
3,900
REPORTING FOR: AN ENTIRE FACILITY
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
HELP 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 INVENTORY SYSTEM
MAP: TRS910MF SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
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
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 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: 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. KXSER
PHONE: 609/540-2666
PUBLIC CONTACT: C. A. CREMEANS
PHONE: 704/869-4571
Enter-PFl PF2---PF3 PF4 PF5 PF«---PF7-'--PF6 PF9 PFl'(J--PFll PF12
HELP MAIN PREV QMENU RPTS
Figure 5-46
09/03/91 5 - 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
MAP: TRQ050M1
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION DISPLAY SELECTION
06/13/91
14:55:04
1 TRI FACILITY ID
2 DUNS NUMBER
3 EPA ID
4 DOCUMENT CONTROL NUMBER
5 FACILITY NAME
6 PARENT DUNS NUMBER
7 PARENT COMPANY NAME
Key selection and press ===> _
Enter-PFl PF2
HELP MAIN
-PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
PREV 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 10 14:55:16
REQUIRED
REPORTING YEAR > 1989
TRI FACILITY ID > 27239DPNTCRT1BO
OPTIONAL
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-48
09/03/91 5 - 37 ONLINE QUERIES
-------
TRIS 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: TR005OP1
MAP: TRQ05OM9
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION DISPLAY
06/13/91
14:55:42
REPORTING YEAR: 1989
3 SUBMISSION FOUND FOR TRI FACILITY 10 27239DPNTCRT1BO
Press to view query
OR
Press the appropriate PF key
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
CONT HELP MAIN PREV RPTS
Figure 5-49
Press to continue to the next screen (Figure S-SO) to view information about
these submissions. To view information about the next submission, press .
PGM: TRQ.050N1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
HAP: TRQ050MB SUBMISSION DISPLAY 14:55:56
REGION: 04 TRI FACILITY 10: 27239DPNTCRT1BO
NAME : DO PONT C&P HEALING SPRINGS
STREET: RT fl BOX 102
CITY : DENTON
COUNTY: DAVIDSON
STATE : NC ZIP: 27239-
DOCUMENT CONTROL NUMBER : 13-89-03000421-8-NC
RPTG FOR ENTIRE FACILITY A (AN ENTIRE COVERED FACILITY)
MAXIMUM AMOUNT CODE 03 (1,0009,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 TRIID: 27239DPNTCRT1BO / DCN: 13-89-03000421-8-NC
Enter-PFl PFi PF$ PF4- PF$ PF'<5 PFl PF8 PF9 PFld~PFll~PFl2
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: TRQOSON1
MAP: TRQ05OKC
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION DISPLAY
06/13/91
14:56:08
ASSIGNED DUNS NUMBER
ASSIGNED EPA ID
STATE/COUNTY FIPS CODE
ASSIGNED CENTROID 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
(339129697
NCD000475608
37057
4-0353800
-0800606
+0353645
-0801036
DUPONT
001315704
G. L. KISER
(609) 540-2666
C. A. CREMEANS
(704) 869-4571
NA
SUBM: 1 OF 3
TRIID: 27239DPNTCRT1BO / DCN: 13-89-03000421-8-NC
Enter-PFl --- PF2 --- PF3 ---
CONT HELP MAIN PREV
6 --- PF7 --- PF8 --- PF9 --- PF10 PFll PF12 ---
NEXT RPTS
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)
2)
3)
Type 2 to select the POTW / Offsite Facility Name Search from the POTW / Offsite
Search menu (Figure 5-52).
PGM: TRQ06OP
MAP: TRQ060M1
TOXIC RELEASE INVENTORY SYSTEM
POTW / OFFSITE SEARCH
06/13/91
14:56:32
1 POTW / OFFSITE 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 PF10PF11PF12
HELP MAIN PREV RPTS
Figure 5-52
Type a REPORTING YEAR. This field is required. Reporting Year '1989' is used.
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*' ls used. Upper or lower case letters can be used. There are no other
optional fields available to narrow the search.
PGM: TRQ06OP1 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ060M2 POTW / OFFSITE SEARCH BY FACILITY ID
REQUIRED
REPORTING YEAR > 1989
POTW / OFFSITE FACILITY ID..> RICHMOND*
Key selection c.iiL«iJ.a and press <£nriBK>
06/13/91
14:56:40
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFT 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 number of submissions found that meet the search (Figure 5-54) will appear. The POTW
/ Offsite Facility Name selected for this search is also displayed.
PGM:
MAP:
TRQ06OP2 TOXIC RELEASE INVENTORY SYSTEM
TRQ06OM6 POTW / OFFSITE FACILITY SEARCH
06/13/91
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
4)
Figure 5-54
To view detailed information about the POTW / Offsite Facility submissions, press
. Two submissions (Figure 5-55) are displayed per screen.
PGM: TRQ060P2 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ06OMB POTW/OFFSITE FACILITY SEARCH
POTW/OFFSITE NAME: RICHMOND CITY LANDFILL
ADDRESS: BOX ANGLE RD. (P.O. BOX 250)
RICHMOND KY 40475
TRANSFER OFF-SITE ID: 40475RCHMNBOXAN CAS NUMBER:
DOC CONTROL NUM:
POTW/OFFSITE NAME: RICHMOND CITY LANDFILL
ADDRESS: BOX ANGLE RD. (P.O. BOX 250)
RICHMOND KY 40475
TRANSFER OFF-SITE ID: 40475RCHMNBOXAN CAS NUMBER:
DOC CONTROL NUM:
06/13/91
14:58:01
NA - -
13-89-03534443-9-KY
1 OF 73
007664-93-9
13-89-03541144-4-KY
2 OF 73
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 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 or page forward
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
CONT
HELP
MAIN
PREV
RPTS
PF 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 ED 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 10 > 25143MJJSNT1MONS
OR
FACILITY NAME >
INCLUDE DELISTED CHEMICALS: Y
CAS NUMBER >
--OR--
CHEMICAL/CATEGORY NAME >
Key selection criteria and press
(Y/N)
Entec-PPl PF2 PP3 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
MAP: TRQ07OM2
TOXIC RELEASE INVENTOR* SYSTEM
YEAR-TO-YEAR RELEASE/TRANSFER COMPARISON
06/13/91
17:49:28
TRIFID: 25143MNSNT1MONS ADDRESS: 1 MONSANTO RD.
NAME: MONSANTO CO. NITRO WV 25143
* History records exist - may be different name for a previous year *
CHEMICAL: ALL CHEMICALS INCLUDING DELIS TED 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 PF 1 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
-------
THIS 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)
2)
3)
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
2
3
4
5
6
Key
TRI FACILITY ID
HISTORICAL FACILITY NAME
HISTORICAL CITY / COUNTY
HISTORICAL REGION / STATE / ZIP
HISTORICAL PARENT DUNS NUMBER
HISTORICAL PARENT COMPANY NAME
selection and press ===>
CODE
2
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-58
Type a REPORTING YEAR. This is a required field. Reporting Year '1988' is used.
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: TRQ08ON2
MAP: TRQ080M3
REQUIRED
TOXIC RELEASE INVENTORY SYSTEM
HISTORY SEARCH BY FACILITY NAME
REPORTING YEAR > 1988
HISTORICAL FACILITY NAME > KEE*
Key selection criteria and press
06/13/91
15:00:29
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
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: TRS030N TOXIC
MAP: TRS030M1 HISTORY FA
NAME: KEE*
MARK FACILITY NAME
KEELER BRASS AUTOMOTIVE
KEELER BRASS AUTOMOTIVE
KEELER BRASS CO.
X KEENE CORP.
KEESHAN C BOST CHEMICAL CO.
Enter-PFl PF2 PF3 PF4 PF5
HELP MAIN PREV
RELEASE INVENTORY SYSTEM 06X14/91
CILITTC NAME SELECTION SCREEN 13:19:39
TRI FACILITY ID
49502KLRBR236ST
49508KLRBR29293
495Q3KLRBR955GO
19701KNCRP1100G
INC. 77578KSHNB22102
PF6 PF7 PF8 PF9 PF10--PFli--PFl'2---
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
MAP: TRQ08OM8
1 HISTORY RECORD (S)
Enter-PPl PF2- PF3--
HELP MAIN PREV
TOXIC RELEASE INVENTORY SYSTEM 06/14/91
HISTORICAL FACILITY SEARCH 13:20:50
FOUND FOR FACILITY NAME XEENE CORP.
Press to view
or
Press appropriate PF Key
-PP4 PFS PF6 PF7--~-PF8 PF9 PF10 PFH--PF12-
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
MAP: TRQ080MB
TOXIC RELEASE INVENTORY SYSTEM
HISTORICAL FACILITY SEARCH
06/14/91
13:20:58
CURRENT
HISTORICAL
19701KNCRP1100G
ARLON INC.
1100 GOVERNOR LEA RD.
REPORTING YEAR: 1988
:TRI FACIL ID:
:FACILITY NAME: KEENE CORP.
:ADDRESS: 1100 GOVERNOR LEA RD.
BEAR
NEW CASTLE
BAIRNCO CORP.
018288621
REASON FOR CHANGE:
DE 19701 :CITY/ST/2IP:
: COUNTY :
:PARENT NAME:
:PARENT DUNS:
BEAR
NEW CASTLE
BAIRNCO CORP.
018288621
Press to continue
DE 19701
OF 1
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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: TRQ09OP
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 PF7 PF8 PF9 PF10PF11PF12
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
MAP: TRQ09OM2
TOXIC RELEASE INVENTORY SYSTEM 06/14/91
CHEMICAL TABLE SEARCH 13:21:41
CHEMICAL /"CATEGORY / SYNONYM CAS NUMBER
FORMALDEHYDE
FORMALDEHYDE SOLUTION
FORMALDEHYDE, GAS .
FORMALIN
FORMALINE BLACK C
FORMALITH
FORMIC ACID, CHLORO-,
FORMIC ALDEHYDE
FORMIC ANAMMONIDE
FORMIC BLACK C
FORMIC BLACK CW
FORMIC BLACK EA
Enter-PFl PF2 PF3
HELP MAIN PREV
000050-00-0
000050-00-0
000050-00-0
000050-00-0
001937-37-7
: ooooso-00-0
ETHYL ESTER 000541-41-3
000050-00-0
000074-90-8
001937-37-7
001937-37-7
001937-37-7
PF4 tft'5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
RPTS -PAGE -1-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 PF7 PF8 PF9 PF10PF11PF12
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
TRR01OM1 BATCH REPORT PROFILE 07/04/90
USER-ID: GJA ACCOUNT NO: TRISBMSP
BIN/BOX: D166 SYSOUT CLASS: A
PRIORITY: 2 CPU-TIME: 05,03
REMOTE NO: R255 COPIES: 1
PRESS TO CONTINUE
Enter-PPl PF2 PF3 PF4 PF5 PF6 PP7 PF8 PF9 PF10PF11PF12-
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., Rl 14) 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
KG
PH
BN
CH
11/18/91
-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 I
I JOB JOB12345 Submitted Successfully I
AVAILABLE I Press to Return to Previous Screen I
1) FACILIT I IT FORMAT:
2) RELEASE + +.> 3
3) RELEASES/TRANSFERS + ACTIVITY/USE PER FACILITY
Enter-PFl PF2 PF3 PF4 PF5 PF6PF7 PF8PF9 PF10PF11PF12
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-
si te/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: TRROQOM1 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 PF10PF11PF12
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
-------
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 ED 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/OPFSITE 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 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
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-SITE 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^9 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 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
09/03/91 6-11 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: TRROQON3 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM3 FACILITY PROFILE REPORT SELECTION 12:42:16
REPORTING YEAR:...> 1989
PLEASE ENTER TRI FACILITY ID > 27239DPNTCRT1BO --OR--
DUNS NUMBER > --OR
PARENT DUNS NUMBER > --OR--
EPA ID NUMBER > --OR--
DOCUMENT CONTROL NUMBER > --OR--
FACILITY NAME >
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 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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 ED 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 INVENTORY 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
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11
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: TRROOON5 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM5 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-PFlPF2 PF3 PF4 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
-------
TRIS 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/category
name, geographical information, or SIC Code. Submissions are selected from the
Chemical/Geographic/SIC Code Report Selection screen. The sort 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 Chemical/Geographic/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: TRR060M1 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.> t i , i , t , t , , ,,
ZIP >
PART 3; ENTER SIC CODE (SOURCE CATEGORY)..>
Note: Just entering Part 3 criteria will cause the entire file to be read.
At least 5 minutes CPU time should be given.
Press to continue
Enter-PFl PF2 PF3 PF4-PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
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 Part 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 sort 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
HAP: TRR060M2 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.
Foe 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--PF1Z
HELP MAIN PREV PROFL QUERY
Figure 6-10
09/03/91 6-18 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.9 Year-To-Year Release / Transfer Comparison
FUNCTION: The Year-To-Year Release / Transfer Comparison Report displays release /
transfer information from submissions based on the following:
Geographic Location
TRI Facility ED
Facility Name / Facility Name Range
CAS Number
Chemical/Synonym/Category Name
Submissions are selected from the Year-To-Year Release / Transfer Comparison Selection screen.
The user can select the report to run with or without delisted chemicals. See Appendix B for an
example of this report.
ACCESS: Select option 7 from the Batch Report menu. The Year-to-Year Release / Transfer
Comparison Selection screen (Figure 6-11) will appear.
1) Type either GEOGRAPHIC LOCATION or FACILITY information. For Geographic
Location, the following optional fields may be entered to narrow the search: REGION,
STATE, CITY, COUNTY, and ZIP CODE. In this example (Figure 6-10), Region '03,'
State 'Va,' and City 'Richmond' are used. Upper or lower case letters can be used. For
FACILITY information, the following fields may be entered to narrow the search: either
a TRI FACILITY ID or FACILITY NAME. In this example, Facility information was
not used. You must enter at least one of these fields. One selection criterion is required,
but using several will narrow the search.
09/03/91 6-19 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The following optional 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: TRROOON7 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM7 YEAR-TO-YEAR RELEASE/TRANSFER COMPARISON SELECTIONS 12:44:34
REGION
CITY..
BY GEOGRAPHIC LOCATION
> 03 STATE > VA ZIP CODE >
. ...> RICHMOND COUNTY.... >
BY FACILITY
TRI FACILITY ID > OR
FACILITY NAME >
INCLUDE DELXSTED CHEMICALS: N (Y/N)
SEARCH CAN BE LIMITED BY SUPPLYING CHEMICAL INFORMATION:
CAS NUMBER > --OR--
CHEMICAL NAME..>
Key Selection Criteria and Press to Submit Report
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV PROFL QUERY
Figure 6-11
2) Record the JOB NUMBER and press to return to the Year-to-Year Release
/ Transfer Comparison Selection screen.
09/03/91
6-20
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 HASTE TREATMENT MENU
3 TOTAL ENVIRONMENTAL RELEASES MENU 9 HASTE 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 PF10PF11PF12
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:
MAP:
TRR210N1
TRR210M1
TOXIC RELEASE INVENTORY SYSTEM
FACILITY IDENTIFICATION MENU
10/02/91
09:37:47
1FACILITIES BY SIC CODE BY STATE
2 FORMS W/RELEASES BY STATE BY MEDIA
3 PARENT COMPANY NAMES W/NUMBER OF
FACILITIES AND RELEASES
4 FACILITIES PER PARENT COMPANY
5 FACILITIES RPT ENTIRE VS PART YR
6 FACILITIES BY COUNTY FOR EACH STATE
7 TOP 25 COUNTIES WITH FACILITIES
8 RELEASES BY MEDIA BY SIC CODE
9 RELEASES BY SIC CODE BY STATE
10 RELEASES BY MEDIA BY STATE
11 RELEASES BY MEDIA BY ACTIVITY-USE
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
************************************
Key selection-""=>
Reporting Year=-«>
* To display a description of a *
* report key selection number: *
~ ******************************* *77* *
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
HELP MAIN PREV PROFL QUERY
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 OP CHEMICALS PER FACILITY B FORMS BY MAX.AMT.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: TRR23OM1 TOTAL ENVIRONMENTAL RELEASES MENU 09:38:21
1 TOP 25 COUNTIES FOR RELEASES BY TOTAL 11 RELEASES BY KAX-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 PF12
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
MAP: TRR240M1
1 TOP 25 COUNTIES FOR
2 TOP 25 COUNTIES FOR
3 TOP 25 COUNTIES FOR
Reporting Year-=-->
TOXIC RELEASE INVENTORY SYSTEM 10/02/91
AIR EMISSIONS MENU . 09:38:31
RELEASE BY TOTAL AIR
RELEASE BY AIR-FUGITIVE
RELEASE BY AIR-POINT
* To display a description of a *
* report key selection number: *
************************************
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV PROFU 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: TRR2SON1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR250M1 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 7 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* it-
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
HELP MAIN PREV PROFL QUERY
Figure 6-17
6-25 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 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/18/91 6-26 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PGM: TRR260N1 TOXIC RELEASE INVENTORY SYSTEM 10/02/91
MAP: TRR26OM1 RELEASES TO GROUND t UNDERGROUND INJECTION HELLS 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
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 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 thai 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: *
************************************
Press to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
HELP MAIN PREV PROFL QUERY
1COUNTIES 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
1NUMBER 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)
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: *
**************************** **** to continue
Enter-PFl PF2 PF3 PF4 PF5 PF6 PFT PF8 PT9PF10
HELP MAIN PREV PROFL QUERY
Key selection"
Reporting Year=
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
^ FORMS BY WASTE MIN CODE BY STATE IT FORMS FILLING IN WASTE MIN BY
8 FORMS BY WASTE MIN CODE BY SIC CODE 3-DIGIT SIC CODE
9 FORMS BY WASTE KIN 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: *
************************************
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~^3 DATA 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: TRF01OM1 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 PF6 PF7 PF8 PF9 PF10PF11PF12-
HELP MAIN PREV
Figure 7-1
09/03/91 7 - 4 DATA 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: TRF02OP
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
WASTE MIN CODE
HASTE MIN CURRENT YEAR
HASTE MIN PRIOR YEAR
WASTE MIN PCT CHANGE
WASTE MIN INDEX
WASTE MIN REASON CODE
_ CHEMICAL NAME
_ CAS NUMBER
_ FUGITIVE/NON-PNT AIR
STACK/POINT AIR
WATER BODIES
~ UNDERGROUND INJECTION
LAND ON-SITE
POTW
~ OTHER OFF-SITE
_ UIC 10(1-2)
EPA ID(1)
~ 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 PF10PF11PF12-
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: TRF020M1
TOXIC RELEASE INVENTORY SYSTEM
SELECT DATA ELEMENTS
03/31/91
10:46:59
FACILITY NAME PUBLIC CONTACT
FACILITY STREET ~ PUBLIC PHONE
FACILITY CITY ~ TECHNICAL CONTACT
FACILITY COUNTY TECHNICAL PHONE
FACILITY STATE ~i PARENT COMPANY NAME
FACILITY ZIP _ PARENT DUNS NUMBER
FACILITY REPORT CODE STATE COUNTY FIPS CODE
FACILITY LATITUDE ~ HASTE MIN CODE
FACILITY LONGITUDE ~ HASTE MIN CURRENT YEAR
CENTROID LATITUDE _ HASTE MIN PRIOR YEAR
CENTHOID LONGITUDE WASTE MIN PCT CHANGE
MAXIMUM A *************"****************************"****
ACTIVITY U ** RECORD THE FOLLOWING INFORMATION **
** THE DOWNLOAD DSN NAME IS **
** AAABBBB.DYYMMDD.THHMMSS.DOWNLOAD.FILE **
NOTE: T ** JOB JOBNNNNN **
** SUBMITTED SUCCESSFULLY **
** PRESS TO RETURN TO SELECTION **
*********************************************
CHEMICAL NAME
CAS NUMBER
FUGITIVE/NON-PNT AIR
STACK/POINT AIR
HATER BODIES
UNDERGROUND INJECTION
LAND ON-SITE
POTW
OFF-SITE
UIC ID(1-2)
EPA ID(1)
CODE(1-3)
NUMBER(1)
TER>
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 7~^8 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
-------
THIS 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: TRUOOOMl
TOXIC RELEASE INVENTORY SYSTEM
TUTORIAL MENU
1 GENERAL INFORMATION
2 USING THE SYSTEM
3 ONLINE QUERIES
4 BATCH REPORTS
5 DATA OFFLOAD
6 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 JT~4 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
MAP: TRU010MO
TOXIC RELEASE INVENTORY SYSTEM
TUTORIAL: GENERAL INFORMATION
06/03/91
10:41:45
1 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 PP KEYS
4 HELP AND POP-UP WINDOWS
Key selection and press *»> _
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9-PF10PF11PF12-
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
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 ace used to search foe 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,
_v_««»wpwpHP>«v»v«iv»mpw«Pwiw»«wi»iw«««»«. J
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 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 PF7 PF8 PF9 PF10PF11PF12
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 06/07/91
MAP: TRU03M1B FACILITY NAME SEARCH 16:24:10
REQU]
OPTIC
RED REPORTING YEAR >
FACILITY NAME >
>NAL REGION >
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.
E'n't'er-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV TUTOR FULL
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: TRU050MA TUTORIAL 16:34:16
You have chosen to review the Data Offload function.
The Data Offload function allows the usec 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.
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: TRU06OF
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 PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11PF12-
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)
3)
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: TRU06OP
MAP: TRU06OM2
TOXIC RELEASE INVENTORY SYSTEM
USER SUPPORT MENU
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
4 SET PROGRAM FUNCTION (PF) KEYS
Please enter the number corresponding to the
User Support feature you would like to view or
press PF4/16 to return to the TUTORIAL menu =>
06X11/91
14:03:08
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV TUTOR
Figure 8-9
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
'O: TRIS User Support FROM: LOUISE HYDE
JT:
5E:
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.
Enter-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 9 - 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: TRPOOOP
MAP: TRPOOOM1
TOXIC RELEASE INVENTORY SYSTEM
USER SUPPORT MENU
03/31/91
10:48:27
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
4 SET PROGRAM FUNCTION (PF) KEYS
Key selection and press > ^
Bnter-PFl PF2 PF3 PF4 PF5 PF6 PF7 -PF8 PF9-
HELP MAIN PREV
PFIO PF0.1 -PF12
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: TRP01OP TOXIC RELEASE INVENTORY SYSTEM 06/03/91
HAP: TRP010M1 QUESTIONS AND SUGGESTIONS 10:38:17
TO: TRIS User SupportFROM:LOUISE HYDE
SUBJECT:
MESSAGE:
PHONE:(
Enter-PFl PFZ PF3 PF4 PF5 PF6-PF7 PF8 PF9 PF10PF11PF12
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
-------
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: TRP020M1 REQUEST DOCUMENTATION 10:48:40
TO: TRIS User SupportPROM:LOUISE HYDE
_ Information Retrieval Users Guide
~ Instructions and information for the menu-driven system
Users Quick Reference Card
~ Logon/logoff instructions, acronyms, SDSF, JCL
ADABAS File Descriptions
~ Revised April 1991 after major system enhancements
NLM 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 PF10PF11PF12
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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
9.3 Extract File Information
FUNCTION: This option provides current information concerning permanent THIS 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: TRP03OP TOXIC RELEASE INVENTORY SYSTEM
MAP: TRP030M1 EXTRACT FILE INFORMATION
FILE
TXLTRID. PROD041 9. CHEMICAL. FILE87
TXLTRID. PROD0419. FACILITY. FILE87
TXLTRID . PROD041 9 . OFFSITE . FILE87
TXLTRID. PROD0419.POTW.FILE87
TXLTRID. PROD0419. RELEASE. FILE87
TXLTRID. PROD0419. TREAT. FILE87
Press to view additional
YEAR
1987
1987
1967
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
Ehter-PTI PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
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: TRP04OP 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 PF10PF11PF12
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 A - 2 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ADABAS
AD ABAS 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
-------
TRIS 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 HI 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 IE.
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 B - 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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 4 SAMPLE BATCH REPORTS
-------
TRR04BF1
06X13/91
PAGE 1
U S. ENVIRONMENTAL PROTECT 014 AGENCY
TOXIC CHEMICAL RELEASE INVENTORY REPO TINS FORM FACSIMILE
PART I. FACILITY IDCNTIFICATIO'. INFORMATION
DCN : 13-89-03000102-4-D;
TRIFID: 19B09DPNTD10 YES < X > NO
2. CERTIFICATION NAME
JOHN S. KLOSS
1.2 IF ES IN 1.1. IS THIS CO»Y:
< > SANITIZED < > UMShNITIZLD
1.3 REPORTING YEAR
1989
CFRTIFICATION TITLE
PLANT MANAGER
DATE SIGNED
06/10/90
CO
C71
3 FACILITY IDENTIFICATION
3.1 FACILITY OR ESTABLISHMENT NAME
OU PONT EDGE MOOR
STREET ADDRESS
104 HAY RD.
CITY COUNTY
WILMINGTON NEW CASTLE
STATE ZIP CODE
OE 19009
3.Z THIS REPOPT CONTAINS INFORMATION TOR:
3.3 TECHNICAL CONTACT
JOHN C. CHANEY
3.4 PUBLIC CONTACT
JOHN C. CHANLY
3.5 SIC CODE
A. 2816
A. < X > ENTIRE FACILITY
TELI PHONE NUM! CH
302-761-2290
TELEPHONE NUM! FR
302-761-2290
B. <
> PA*T OF A FACILITY
3.6 LATITUDE: 394449
LONGITUDE: 752530
3.7 DUN AND BRADSTREET NUMBERS
A. 154407645
3.8 EPA IDENTIFICATION NUMBERS (RCRA I.D. NO.1
A. DED000800284
2
CO
5
3)
m
CO
m
o
I
m
co
>
-o
3)
m
3
3.9 NPDES PERMIT NUMBERS
A. DE0000051 B. DE0050644
RECEIVING STREAMS OR HATER BODIES
A. DELA1IARE RIVER
3.10 B.
0.
3.11 UNDERGROUND INJECTION HELL CODE (UIC) IDENTIFICATION NUMBERS
4. PARENT COMPANY INFORMATION
4.1 NAME OF PARENT COMPANY: DUPONT
4.2 PARENT COMPANY'S DUN AND BRAOSTREET NurtBES: 001315704
NA
-------
TRR04BF2
06/1J/91
PAGE 2
CD
O>
CO
>
~o
£
I
3)
m
3
1
1. PUBLICLY OWED TREATMENT HORKS (POTHS)
1.1 POTM NAME
NA
STREET ADDRESS
THIS FACSIMILE FORM R
PART II. OFF-SITE LOCATIONS TO HHICH TOXIC
CHEMICALS ARE TRANSFERRED IN HASTES
1.2 POTM NAME
STREET ADDRESS
DCN : 13-a9-03000362-4-DE
TRIFID: 19609DPNTD104HA
CITY
STATE
COUNTY
ZIP CODE
CITY
STATE
COUNTY
ZIP CODE
.'. OTHER OFF-SITE LOCATIONS
J.I OFF-SITE LOCATION NAME
DU PONT CHERRY ISLAND
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
NA
STREET ADDRESS
HAY ROAD
CITY COUNTY
EDGEMOOR NEW CASTLE
STATE ZIP
DE 19809
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< X > YES < > NO
:.3 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.I
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 OF REPORTING FACILITY ?
< > YES < > NO
CO
3
O
03
m
3
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
CO
O
o
m
2.5 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER IRCRA 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
-------
0
s
«3
-*
09
W
-Q
m
to
1
3)
m
1
TRR04BF3 PAGE 3 THIS FACSIMILE FORM R
06/13/91 PART III. CHEMICAL-SPECIFIC INFORMATION
1 . CHEMICAL IDENTITY
1.1 (RESERVED)
1.2 CAS NUMBER
000463-56-1
1.3 CHEMICAL OR CHEMICAL CATEGORY NAME
CARBONYL SULFIDE
1.4 GENERIC CHEMICAL NAME
C . MIXTURE COMPONENT IDENTITY
NA
3. 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 E. < X > AS A BYPRODUCT P. <
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.1A NA
5.2 STACK OR POINT AIR EMISSIONS 5.2A 600000
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.2A NA
FARMINS
5.5.3 SURFACE IMPOUNDMENT 5.5.3A NA
5.5.4 OTHER DISPOSAL 5.5.4A NA
OCN : 13-89-03000382-4-DE
TRIFID: 198090PNTD104HA
> 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. 3D NA
5.5.4B NA
J
3)
Z
|
(
O
3)
m
i?
m
<
c
V)
m
31
V)
O
6
m
-------
§
>
s2
CO
OB
(A
TJ
m
o
o
30
(fl
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
6.1.2 DISCHARGE TO POTM 1.2 6
6.2.1 OTHER OFF-SITE 2.1 NA 6
6.2.2 OTHER OFF-SITE 2.2 6
6.2.3 OTHER OFF-SITE 2.3 6
6.2.4 OTHER OFF-SITE 2.4 6
6.2.5 OTHER OFF-SITE 2.5 6
6.2.6 OTHER OFF-SITE 2.6 6
7. HASTE TREATMENT METHODS AND EFFICIENCY
A. GENERAL B. TREATMENT C. RANGE INFLUENT D. SEQUENTIAL
HASTESTREAM METHOD CONCENTRATION TREATMENT
7.1A A 7. IB A03 7. 1C 2 7. ID
7.2A 7.2B 7.2C 7.20
7.3A 7. SB 7.3C 7. 3D
7.4A 7.4B 7.4C 7.40
7.5A 7. SB 7.5C 7.50
7.6A 7.6B 7.6C 7.60
7.7A 7.7B 7.7C 7.70
7.6A 7.6B 7.6C 7.80
7.9A 7.9B 7.9C 7.90
7.10A 7.10B 7. IOC 7.10D
J. OPTIONAL INFORMATION ON HASTE MINIMIZATION
A. TYPE OF B. QUANTITY OF THE CHEMICAL IN HASTES C. INDEX
MODIFICATION PRIOR TO TREATMENT OR DISPOSAL
CURRENT YEAR PRIOR YEAR 1 OR PCT CHANGE
1
M4 680000 840000 1 -19.00 1.1
1
B. BASIS OF
ESTIMATE
. LIB
.1.26
.2. IB
.2.2B
.2.3B
.2.4B
.2. SB
.2.6B
E. TREATMENT
ESTIMATE
7. IE 0.00
7.2E 0.00
7.3E 0.00
7.4E 0.00
7.5E 0.00
7.6E 0.00
7.7E 0.00
7.8E 0.00
7.9E 0.00
7.10E 0.00
DCN : 1 3-89-03000382 -4-DE
TRIFID: 19809DPNTD104HA
C. TYPE OF TREATMENT/
DISPOSAL
6. 2. 1C
6.2.2C
6.2.3C
6.2.4C
6.2.5C
6.2.6C
EFF F. BASFO ON
OPERATING DATA
YES NO
7. IF X
7.2F
7.3F
7.4F
7.5F
7.6F
7.7F
7.8F
7.9F
7.10F
D. REASON FOR ACTION
R4
|
3)
Cff
2
§j
H
o
s^
53
m
%
tn
ID
O
C
O
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
-------
1
CO
-«
V)
2
TJ
m
5
-c
0
X
31
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
POTM
OFF SITE
TOTAL TRANSFER
THE
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
YEAR-TO-YEAR RE LFASE/TPANSFER COMPARISON REPORT
19609DPHTD104HA <"* NOTE: HISTORY RECORDS EXIST - THE NAME/ADDRESS INF
OU PONT EDGE MOOR
104 HAY RD.
WILMINGTON DE 19809
ALL CHEMICALS EXCLUDING GELISTEO CHEMICALS
y. or x of
1967 1966 CHANGE 1969 CHANGE
6 7-11 6 -IS
101774 2Z174 -79 36624 *7<*
935231 957010 *2 786 i^O -16
I0710Z5 19770 -99 270 -99
00 0
0 39 46 «Z3
2106030 996993 -53 625162 -16
00 0
553000 1250000 +124 D
SS3000 1250000 *126 0
PERCENT CHANGE HILL BE CALCULATED ONLY IF BOTH APPLICABLE REPORTING YEARS
06/13/91
09:47:05
0 MAY BE DIFFERANT FOR FPEVIOUS YEAR
y. OF y. OF
1990 CHANGE 1991 CHANGE
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
ARE GREATER THAN ZERO.
-1
55
I
\J
3)
>
5
z
3»
m
^j}
m
£
c
v>
m
3)
u>
O
c
o
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 SYSUM
06/13/91
21:02:35
FACILITY PROFILE REPORT FOR FACILITY ID: 198090PNTD104HA
REGION
03
TRI-FACILITY-ID
19809DPNTD104HA
EPA ID
DED000800264
NAME :
ADDRESS :
CITY/STATE/ZIP:
OU PONT EDGE MOOR
104 HAY RD.
WILMINGTON. DE 19609
00
i
in
OOCUHENT CONTROL NUMBER :
REPORTING YEAR
RPTG 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-89-03000362-4-DE
1969
A (AN ENTIRE COVERED FACILITY)
01 (0--99)
000463-58-1
CARBONYL SULFIDE
NA
JOHN 9. KLOSS
PLANT MANAGER
06/10/90
P (PHOTO COPY)
NEW CASTLE
154407845
DED000800284
10003
394630
-752942
394449
-752530
DUPONT
001315704
JOHN C. CHANEY
(302) 761-2298
JOHN C. CHANEY
(302) 761-2298
NA
D1353
»« HASTE MINIMIZATION **
HASTE MINIMUM CODE : M4
WASTE MINIMUM CURRENT YEAR QTY:
HASTE MINIMUM CRT YEAR QTY N/A:
WASTE MINIMUM PRIOR YEAR QTY :
WASTE MINIMUM PRIOR YR QTY N/A:
WASTE MINIMUM PERCENT CHANGE :
WASTE MININUM INDEX :
WASTE MINIMUM ACTION CODE :
(PROCESS PROCEDURE MODIFICATIONS)
680,000
840,000
-19.00
1.1
R4 (SELF-INITIATED REVIEW)
33
0)
O
33
33
m
3
m
CO
m
o
o
m
EPA ID NUMBER(S)
DUNS NUMBER!3)
SIC-CODE(S)
: DED000800284
: 154407645
: 2616
NPDES PERMIT NUMBER(S): DE000005I DE0050644
-------
TRR03BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
PA6E: 2 TOXIC RELEASE INVENTORY SYSTEM 21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19B09DPNTD104HA
REGION TRI-FACILITY-ID EPA ID NAME : DU PONT EDGE MOOR
03 19809DPNTD104HA DE0000600284 ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: HIU1INGTON, DE 19809
«» TYPES OF ACTIVITY/USES »
MANUFACTURE : PRODUCE BYPRODUCT
55
3J
m
w
m
3
o
o
m
I
o
£
CD
33
m
i
-------
TRR03BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
PAGE: 3 TOXIC RELEASE INVENTORY SYSTEM 21:02:25
.-'ACUITY PROFILE REPORT FOR FACILITY 10: 19609DPNTD10«HA
UEGION TRI-FACILITY-ID EPA ID NAME : DU PONT EDGE MOOR
03 19809DPNTD104HA OE0000800284 ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: MILMINGTON. Of. 19809
» FUGITIVE OR NON-POINT AIR EMISSIONS
IMPORTING RANGE :
ESTIMATE : 0
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA -I
55
*» STACK OR POINT AIR EMISSIONS ** T1
REPORTING RANGE : Q
ESTIMATE : 660,000
ESTIMATE N/A :
DASIS OF ESTIMATE I M (BASED ON MONITORING DATA OR MEASUREMENTS)
5
«* DISCHARGE TO HATER *«
STREAM CODE : A
STREAM NAME DELAWARE RIVER
REPORTING RANGE
bSTIHATE
ESTIMATE N/A
BASIS OF ESTIMATE
/. FROM STORMMATER
/ FROM STORMMATER N/A
i
o.oo fn
O
«-* UNDERGROUND INJECTION *«
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
> BASIS OF ESTIMATE : NA
... »* RELEASE TO LAND «*
> I AND DISPOSAL CODE : 002 (ON-SITE LANDFILL)
REPORTING RANGE :
ESTIMATE : 0
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
-------
1
CO
CO
CO
^
2"
1
m
CD
2
o
X
DO
m
TJ
o
3J
w
TRR03BP
PAGE: 4
FACILITY PROFILE REPORT
REGION TRI-FACILITY-ID
03 198090PNTD104MA
*» RELEASE TO LAND »»
LAND DISPOSAL CODE :
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A :
BASIS OF ESTIMATE :
«* RELEASE TO LAND »«
LAND DISPOSAL CODE :
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A :
BASIS OF ESTIMATE :
«« RELEASE TO LAND »*
LAND DISPOSAL CODE :
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A :
BASIS OF ESTIMATE :
» DISCHARGE TO POTM ««
FACILITY NAME
STREET ADDRESS
CITY
COUNTY
STATE
ZIP CODE
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
BASIS OF ESTIMATE
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
TOXIC RELEASE INVENTORY SYSTEM Z1:OZ:Z5
FOR FACILITY 10: 19809DPNTD104HA
EPA ID NAME : DU PONT EDGE MOOR
DED000600Z84 ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON. DE 19809
D03 (LAND TREATMENT/APPLICATION FARMING)
0
Y
NA
DOS (SURFACE IMPOUNDMENT)
0
Y
NA
D99 (OTHER DISPOSAL)
0
Y
NA
NA
0
H
JO
CO
3
O
2
^
3
z
3)
m
m
f
c
CO
m
3)
CO
0
c
m
-------
TRR03BP
PAGE: 5
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
06X13/91
21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19009DPNTD104HA
(O
REGION
03
TRI-FACILITY-ID
19809DPNT0104HA
EPA ID
DEOOOOa002B4
NAME :
ADDRESS :
CITY/STATE/ZIP:
DU PONT EDGE MOOR
104 HAY RO.
WILMINGTON, DE 19S09
«« OTHER OFF-SITE LOCATION »«
OFF-SITE 10
OFF-SITE LOCATION CODE
EPA ID (RCRA ID NO.)
FACILITY NAME
STREET ADDRESS
CITY
COUNTY
STATE
ZIP CODE
CONTROL OF RPT. FACIL.
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
BASIS OF ESTIMATE
TREATMENT/DISPOSAL
*« HASTE TREATMENT METHODS AND EFFICIENCY »»
19809DPNTCHAYRO
1
NA
DU PONT CHERRY ISLAND
HAY ROAD
EOGEMOOR
NEW CASTLE
DE
19809
Y CYES, LOCATION IS UNDER CONTROL OF REPORTING FACILITY OR PARENT COMPANY)
GENERAL HASTESTREAM CODE
TREATMENT METHOD CODE
RANGE OF INFLUENTAL CONCENT. CODE
SEQUENTIAL TREATMENT
TREATMENT EFFICIENCY ESTIMATE
BASED ON OPERATING DATA
A [GASEOUS (INCLUDING GASES, VAPORS, AIRBORNE PARTICULATES)I
A03 I SCRUBBER)
2 (100 PARTS PER MILLION (0.01 PERCENT) TO 1 PERCENT (10.000 PARTS PER MILLION))
0.00
(NO, TREATMENT EFFICIENCY ESTIMATE IS NOT BASED ON ACTUAL OPERATING DATA I
3J
CO
O
3J
X
m
5
m
I
c
m
O
6
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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 22 SAMPLE BATCH REPORTS
-------
09/03/91
CD
1
>
TJ
CD
Jj
o
1
m
|
TRR08BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06X13X91
PAGE 1 TOXIC RELEASE INVENTORY SYSTEM 21:05:16
CHEMICALXGEOGRAPMICALXSIC CODE REPORT, REPORTING YEAR: 1987
REGION: 03 » STATE: VA * CITY: RICHMO
DATA SORTED BY: » SFACIL-STATE * tFACI
FACILITY NAME X ADDRESS
DOCUMENT CONTROL HUM CHEMICAL NAME
HO * » ZIP CODE: 00000 THRU 99999
FUG AIR STACK
AIR HATER UNDER INJ LAND
JAMES RIVER CORP. FILTRATION PRODUCTS DIV-RICHMOND
TREDEGAR ST.
RICHMOND. VA 23219
1 3-89-03532 178-5-VA FORMALDEHYDE
13-89-035321 79-7-VA PHENOL
13-89-03532180-9-VA METMANOL
0 14
0 19
180.000 1.200
«»« TOTALS FOR JAMES RIVER CORP. FILTRATION 180,000 1,233
REHRIG INTERNATIONAL
90) NORTH LOMBARD Y ST.
RICHMOND. VA 23220
13-89-03558346-3-VA NICKEL
13-69-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
J.M. FRY CO. INC.
830 HULL ST.
RICHMOND, VA 23224
13-89-03542988-5-VA COPPER COMPOUNDS
250 LBS MAS USED FOR RELEASE
0
73
73
0
0
0
ESTIMATE FOR 1-499 REPORTING RANGE,
,000 1 0 0
,000 7 0 n
,000 160 0 0
,000 168 0 0
00 00
146 000
146 000
250 0 00
250 000
00 00
750 LBS FOR 500-999 RINGE
53
CO
n
§
1
0
1 RETRIE
£
CO
m
CO
O
5
m
-------
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
-------
09/03/9
^^
03
i
ro
to
|
TJ
m
§
^H
O
m
5
3)
tn
1RROSBP
PAGE : 1
TRI FACIL ID/
DOC CNTL HUH
24210STRLNNORHO
13-89-03506491 -6-VA
24210MSTNGHIGHH
13-89-03524000-9-VA
24210USTNSHIGHH
13-89-03524001-1-VA
24Z10HSTNSHIGHH
13-89-03524002-3-VA
24210HSTNGHIGHH
13-89-03524003-5-VA
23301PRDNCROUTE
13-89-0358052 3- 7-VA
23301PRDNCROUTE
13-89-03580524-9-VA
23301PRDNCROUTE
13-B9-03580525-2-VA
22312TLNTC5390C
13-89-03575229-6-VA
22312TLNTC5390C
13-89-03575230-8-VA
UNITED
YEAR:
FACILITY NAME
STERLING CASKET HARDHARE CO.
HESTINSHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
PERDUE FARMS INC.
PERDUE FARMS INC.
PERDUE FARMS INC.
ATLANTIC RESEARCH CORP.
ATLANTIC RESEARCH CORP.
STATES ENVIIIONMENTAL PROTECTION
TOXIC RELEASE INVENTORY SYSTEM
REGIONAL TRCS SUBMISSIONS REPORT
AGENCY
OS/ 12/91
16:02:17
1989 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
FACILITY ADDRESS
NORWOOD RD.
ABINGDON
VA 24210
HHY. 11 HESTINGHOUSE RD.
ABINGDON
VA 24210
HHY. 11 HHSTINGHOUSE RD.
ABINGDON
VA 24210
HHY. 11 HESTINGHOUSE RO.
ABINGDON
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 M. GENTRY
(703) 676-9152
LISA tl. 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 6. FOSTER
(703) 642-6448
CAS NUMBEP/
CHEMICAL NAI1E
71-55-6
1 1 1 1 1-TRICHLOROE FNANE
1330-20-7
XYLENE (MIXED ISOtlERS)
1319-77-3
CRESOL (MIXED ISOMER5)
7440-50-8
COPPER
108-95-f
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
(75
z
0
yi
>
5
z
3)
m
33
m
^
^
c
m
(/>
GJ
c
o
m
-------
TRR05HP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY ?!/l!/?!
PAGE- 170 TOXIC RELEASE INVENTORY SYSTEM 16:02:21
REGIONAL TRtS SUBMISSIONS REPORT
YEAR: 1909 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
TRI FACIL ID/ TFCH CONTACT NAME/ CAS NUMBER/
DOC CNTL NUM FACILITY NAME FACILITY ADDRESS PM!.^!!!?
REPORT SUMMARY *
«»»**»>
3
X
75-15-0 CARBON OISULFIDE m
75-21-8 ETHYLENE OXIDE
75-35-4 VINYLIOENE CHLORIDE
75-55-8 PROPYLENEIMINE
75-56-9 PROPYLENE OXIDE
5j 75-65-0 TERT-BUTYL ALCOHOL
76-13-1 FREON 113
77-70-1 DIMETHYL SULFATE
70-04-2 ISOBUTYRALDEHYDE
70-07-5 1,2-DICHLOROPROPANE
78-93-3 METHYL ETHYL KETONE
79-01-6 TRICHLOROETHYLENE
79-06-1 ACRYLAMIOE
79-10-7 ACRYLIC ACID
79-11-8 CHLOROACETIC ACID
80-62-6 METHYL METHACRYLATE
33
CO
33
(Tt
<
2
HI
33
OT
C)
O
-------
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
-------
c
1
CO
1
u
I
D
m
TCH REPORTS
TRR02BP
PAGE: I
09:45:08.2
UNITED
STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
TOXIC RELEASE INVENTORY SYSTEM
POTH/OFF-SITE LOCATION REPORT
POTH/CFF-SITE LOCATION REPORT FOR TRI-OFF-SITE-IO 53150BFHS1H143S MPOTM/OFF-SITE NAME: BFI HASTE SYSTEMS TOWN I
STREET: H143 S6400 COLLEGE CT. / COUNTY: HAUKESHA / CITY: MUSKEGO / STATE: HI / ZIP: 53150
REGION THI-FACILITY-ID:
EPA-ID :
DOC-CNTL-NUM :
53l67LtYPR1045P
HI0006077976
13-89-03581823-4-HI
CAS NUMBER : 000071-55-6
CHEMICAL NAME: 1 . 1 ,1-TRICHLOROETHANE
TYPE OF TRANSFER
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID:
EPA-ID :
DDC-CNTL-NUn :
CAS NUMBER : 007439-96-5
CHEMICAL NAME: MANGANESE
TYPE OF TRANSFER
00 1-499 500-999
LB. LBS. LBS.
53167LLYPR1045P
HID006077978
13-89-03581B21-0-HI
00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID:
EPA-ID :
DOC-CNTL-NUH :
CAS NUMBER : 007440-02-0
CHEMICAL NAME: NICKEL
TYPE OF TRANSFER
OTHER OFF-SITE LOCATION
53187LLYPR1045P
HI0006077978
13-89-03581822-2-HI
00 1-499 500-999
LB. LBS. LBS.
NAME
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS.
0
NAME :
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS.
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
KAUKESHA. HI 53187
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
HAUKESHA. HI 53187
772
= = == = = = = = = = = = = = = = = ==== ==== = = = ==== = = s===r==== = ===s= = = == = = = === = s=== = = =======s === = ==
NAME :
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS.
1.834
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
HAUKESHA, HI 53187
CO
INFORMATION RETRIEV
CO
m
c
0
m
-------
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
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
GEOGRAPHIC LOCATION / CHEMICAL PROFILE REPORT
08/12/91
16:04:16
YEAR: 1969 REGION: 03 STATE: VA ZIP CODE: 23331 CITY: RICHMOND
ADDRESS
4500 S. LABURNUM AVE.
RGN TRI-FACILITY-ID FACILITY NAME
03 23231TTMCR4500S AT&T MICROELECTRONICS
RICHMOND HORKS
CAS NUMBER : 007664-41-7 SIC-COOEIS): 3672 3661 NA
CHEMICAL NAME: AMMONIA
CITY / STATE
RICHMOND
VA
ZIP
23231
EPA-ID
VAD066000993
DCN: 13-89-03511056-2-VA
TYPES OF RELEASES
1 SUMMARY )
FUGITIVE AIR EMISSION
STACK/POINT AIR EMISSION
DISCHARGE TO HATER
UNDERGROUND INJECTION
RELEASE TO LAND
«» TOTALS FOR RELEASES:
00 1-499 500-999 ESTIMATE
LB. LBS. LBS. IN LBS.
0
17.700
0
0
0
17,700
TYPES OF TRANSFERS
(SUMMARY)
00
LB.
1-499
LBS.
500-999
LBS.
ESTIMATE
IN LBS.
DISCHARGE TO POTM
OTHER OFF-SITE LOCATIONS
« TOTALS FOR TRANSFERS:
59,500
0
59,500
» TYPES OF ACTIVITY/USES «»
MANUFACTURE : PRODUCE IMPORT ON-SITE USE
PROCESS : REACTANT FORMULATION ARTICLE
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
RGN TRI-FACILITY-ID FACILITY NAME ADDRESS
03 23231TTMCR4500S AT1T MICROELECTRONICS 4500 S. LABURNUM
RICHMOND WORKS
CAS NUMBER : 007762-50-5 SIC-CODE(S): 3672 3661 NA
CHEMICAL NAME: CHLORINE
SALE/DISTR
REPACKAGING
BYPRODUCT
CITY / STATE
AVE. RICHMOND
VA
IMPURITY
ZIP EPA-ID
Z3231 VAD066000993
DCN: 13-69-0351 1057-4-VA
TYPES OF RELEASES
(SUMMARY)
00
LB.
1-499
LBS.
500-999
LBS.
ESTIMATE
IN LBS.
TYPES OF TRANSFERS
(SUMMARY)
00
LB.
1-499
LBS
500-999
LBS.
ESTIMATE
I. IBS.
2
CO
3
33
m
m
CO
m
DO
CO
O
5
m
FUGITIVE AIR EMISSION
STACK/POINT AIR EMISSION
DISCHARGE TO HATER
UNDERGROUND INJECTION
RELEASE TO LAND
* TOTALS FOR RELEASES:
0
151
0
0
0
151
DISCHARGE TO POTH
OTHER OFF-SITE LOCATIONS
«» TOTALS FOR TRANSFERS:
*» TYPES OF ACTIVITY/USES «»
MANUFACTURE : PRODUCE IMPORT ON-SITE USE
PROCESS : REACTANT FORMULATION ARTICLE
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
SALE/DISTR
REPACKAGING
BYPRODUCT
IMPURITY
-------
TRPC1BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/13/91
PAGE: 1 TOXIC RELEASE INVENTORY SYSTEM 09:44:13
GEOGRAPHIC LOCATION / CHEMICAL PROFILE REPORT
YEAR: 1989 REGION: 03 STATE: VA ZIP CODE: 23Z31 CITY: RICHfOND
" H
* SUMMARY TOTALS FCR RELEASES AND TRANSFERS * 2)
« 55
_
z
TOTAL FACILITIES = 10
TOTAL SUBMISSIONS = 24
RELEASES TO ENVIRONMENT
FUGITIVE Al« = 383.690
CD STACK AIR = 316.168
MATER = 0
U UNDERGROUND = 0
LAND = 0
TOTAL =701,878 <
TRANSFERS
TO POTN = 109.673
TO OFF SITE = 35,050
TOTAL = 144.923 (0
O
O
m
CO
TJ
S
CD
|
DO
m
i
-------
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)
Listing of EPA Regional Offices by State
Alabama (AL) 4 Louisiana (LA) 6
Alaska (AK) 10 Maine (ME) 1
Arizona (AZ) 9 Maryland (MD) 3
Arkansas (AR) 6 Massachusetts (MA) 1
California (CA) 9 Michigan (MI) 5
Colorado (CO) 8 Minnesota (MN) 5
Connecticut (CT) 1 Mississippi (MS) 4
Delaware (DE) 3 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
District of Columbia (DC) 3
Florida (FL) 4
Georgia (GA) 4
Hawaii (HI) 9
Idaho (ID) 10
Illinois (IL) 5
Indiana (IN) 5
Iowa (LA) 7
Kansas (KS) 7
Kentucky (KY) 4
Listing of States by EPA Regional Office
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 1
Connecticut (CT)
Maine (ME)
Massachusetts (MA)
New Hampshire (NH)
Rhode Island (RT)
Vermont (VT)
Region 6
Arkansas (AR)
Louisiana (LA)
New Mexico (NM)
Oklahoma (OK)
Texas (TX)
Region 2
New Jersey (NJ)
New York (NY)
Puerto Rico (PR)
Virgin Islands (VI)
Region 7
Iowa (LA)
Kansas (KS)
Missouri (MO)
Nebraska (NE)
Region 3
Delaware (DE)
District of Columbia (DC)
Maryland (MD)
Pennsylvania (PA)
Virginia (VA)
West Virginia (WV)
Region_8
Coloiado (CO)
Montana (MT)
North Dakota (ND)
South Dakota (SD)
Utah(UT)
Wyoming (WY)
Region 4
Alabama (AL)
Florida (FL)
Georgia (GA)
Kentucky (KY)
Mississippi (MS)
North Carolina (NC)
South Carolina (SC)
Tennessee (TN)
Region 9
Arizona (AZ)
California (CA)
Hawaii (HI)
Nevada (NV)
American Samoa (AS)
Guam (GU)
Region 5
Illinois (TL)
Indiana (IN)
Michigan (MI)
Minnesota (MN)
Ohio (OH)
Wisconsin (WI)
Region 10
Alaska (AK)
Idaho (ID)
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
Important Type or print read instructions before complttint form )
Form Approved OMB No :070-0093
Approval Expires 01/94 LJ
Pace i of 5
gr (EPA u S Env'ronmental Protection Agency
TOXIC CHEMICAL RELEASE INVENTORY REPORTING FORM
Section 313 of tne Emergency Planning and Community Rlght-to-Know Act of 1986
also known as Title III of tna Supartund Amendments and Reauthorizatlon Act
EPA FORM
PART I.
FACILITY
IDENTIFICATION
INFORMATION
(This space for your optional use )
PuDhc waning Burden for inn
collection 01 information it estimated to
vary from 30 to 34 hours per response
with an average of 32 hours par
rasponso. including limo for reviewing
instructions searching existing data
sources galharing and maintaining the
data neodM ana computing and
reviewing the collection of information
Send comments regarding this Burden
estimate or any other asDect of Inn
collection of information including
suggestions for reouclnglnls Burden to
Chief. Information Policy Branch
(PM-223). US EPA. 401 M SI . SW
Washington. O C 20460 Ann TRI
Burden and to the Office of Information
and n«Bj
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important- Type or print; read instructions before completing form )
D
Page 2 of 5
RIThls space for your optional use I
0r tKA PART II. OFF-SITE LOCATIONS TO WHICH TOXIC
CHEMICALS ARE TRANSFERRED IN WASTES
t PUBLICLY OWNED TREATMENT WORKS (POTWs)
1 1 POTW name
Strut Adores*
City
Stall
2. OTHER OFF-SITE LOCATIONS
County
Zio
1 2 POTW name
Street Aorjreff
City County
Sun Zip
(DO NOT REPORT LOCATIONS TO WHICH WASTES ARE SENT ONLY FOR RECYCLING OR REUSE)
2 1 Off-site location name
EPA loenliticalion Number (RCRA ID No I
Street Aooref f
C.ly
State
Is location unaer conirol ol reporting facility
County
Zip
or oar*ni company9
[ I-, [ ]NO
2 2 Off-site location name
EPA identification Numoer (RCRA ID No )
Street Addreff
City County
Stale Zip
f 'ocat on unaer control of rvoorting facility or parent company9
[ ]Y., [ ]NO
2 3 Off-site location name
EPA laentilicalion Numoer (RCRA ID No )
SUM! AOOref f
City
Stall
't location unaer conirol ol reooriing facility
County
Zip
or oar en t comoany7
[ ]vi. [ ]NO
2 5 Oil-sue location name
EPA KMnnlicalion NumMr |RCRA ID No 1
Street Addrlff
C,l»
Stall
County
Zip
If location unoer control ol nooning lacilily or Darint company**
r 1 r i
1 J 'e. I J NO
2 4 Off-site location name
EPA lo.>ntificaiion NumMr (RCRA ID No )
Sira«t Adorasi
City County
Stai* Zip
'S 'OCanon unaer C0i.ro' of reporting Ucitily or parent company '
[ ]YI. [ ]NO
2 6 Off-site location name
EPA loiniilicalion ivumoer (RCRA O No )
Street Aodresi
City County
Slate Zip
If location unaer control ol reporting (acuity or parml company?
[ ]ve. [ ]~
^^^~*
] Cheek il andilienal oaoii of Part I ari allacnM Hevu many' ll«^^^^^^^^^^^^^La>a«a«a«a«a«a«a«a«a«a«a>^a«a>a>^a«a«a«a«!ia«^HI
EPA Form 9350-1 (Rev 1-9M - 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 )
D
Page 3 of S
£EPA
EPA FORM R
PART III. CHEMICAL-SPECIFIC INFORMATION
(This space lor your optional use I
1 CHEMICAL IDENTITYIDo not complete this section if you complete Section 2 )
1 1 (Reserved)
1 2
CAS Number (Ent*r only on* numoar *xaclly at il appaart on in* 313 lul Entar NA if reporting a crwmical category )
1 3
Chemical or Chemical Category Name lEmar only on* nam* *>aciiy > n appaart on in* 313 ntt I
1 4
Generic Chemical Name ICompi*l* oniy if Pan I. S*enon I 1 < cnac>*o v*t G*n*rie nam* mult b* llruciurally aeicriptiv* )
MIXTURE COMPONENT IDENTITY I Do not complete this section if you complete Section l I
2.
G*n*ric Gnomical Nam* Provided Dy Supplier (Limit tn* nam* lo a maximum ol 70 cnaractari ( g . numoert lettert lpac*l punctuation) )
3 ACTIVITIES AND USES OF THE CHEMICAL AT THE FACILITY (Check all that apply I
3 1
Manufacture the
chemical
a I J Produce
b I ] Import
If produce or import
(I For on-site
I use/processing
el J As a byproduct
[ 1 For sale/
» I J distribution
f I J As an Impurity
3 2
, Process tne
chemical
a L j As a reactant
d [ J Repackaging only
[ 1 As a formulation
1 I J component
T 1 As an article
l component
3 3
Otherwise use
the chemical
f 1 As a cnemical
L J processing aid
[ 1
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 code)
5 RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE
T
You may report releases of less than
1 000 pounds by checking ranges under A 1
(Do not use both A l and A 2)
5 1 Fugitive or non-point air emissions
S 2 Stack or point air emissions
S 3 Discharges lo receiving I I
streams or water bodies 5 > ' ''
32D
D
'Enl*r Idler cone from Bart I
Section 3 10 for itream(s) in 5
in* Dox proviOM )
533
S 4 Underground Injection
5 3 Releases to land
S S l On-iiia lanafin
552 Lana tr*alm*nt'application farming
553 Surtac* impoundment
5 S « Ol"*r disposal
5 la
A Total Release
(pounds/year)
A 1
Reporting Ranges
1-10 M-«9g 500-999
] [ ] [ ]
5 3 2a
S 3 3a
5 4a
S S la
5 S 2a
5 5 3a
] [ 1 [ 1
A 2
Enter
Estimate
5 3 Ib
5 3 2b
5 3 3b
S 4b
5 5 1b
5 5 2b
5 5 3b
5 5 46
n
[ j iCn*CK it additional information it provided on Part IV-Suopl*mental information I
EPA Form 9350-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
D-5
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
in n
(Important Type or print, read instructions before completing form ) Page 4 of S
a% ERA EPA FORMiR |ThlS space lor your °Ptlona) "so )
PART III. 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 both A 1 and A 2)
Oifcnarge to POTW __ __.
(«nl«r location numoer .
6 1 1 from Part II. Section 1 ) | ' | |
Other olf-tite location .__, .__.
. , (enter location number 1,1
6 2 1 tram Part II Section 2)1 2 1 1
Other oil-ma location __. __
... (enter location numoer ,
622 from Part II Section 2)1 ' \ \
Other otf-nle location __ . ,
(enter location number 1 . 1 1
623 from Part II Section 2 1 I ' I |
A Total Transfers B Basis of Estimate
(pounds/yr)
A 1 A 2
Reporting Ranges Enter
1-10 n-4»a SOO-SM Estimate
(enter code)
[][][] 61, bD
[][][] 6 2 1b D
[][][] 6 2 2b 1 1
[][][] 6 2 3b D
C Type of Treatment/
Disposal
622c[wrn
62 3C I M| | |
[ ] (Check if additional information is provided on Part IV-Supplemental Information )
7 WASTE TREATMENT METHODS AND EFFICIENCY
DNot Applicabi e |NA) - Check if no on-site treatment is applied to any waste stream containing the cnemical or cnemical
category
A General
Wastestream
(enter code)
7 la Q
7 2a F~|
7 3a Q
7 4a | |
7 5a 1 |
76a D
7 7a Q
7 8a Q
7 9a Q
7 lOa I""]
B Treatment
Method
(enter code)
7ib rm
72b rm
73b rm
74b rm
75b rm
76b rm
'»> rm
'e* rm
79b rm
7,ob nrn
C Range of
Influent
Concentration
(enter cooel
7.c n
7 2c | |
7 3c Q
7 4c Q
75C n
76c n
77c n
7ac Q
7 9c Q
7 IOC Q
D Sequential
Treatment'
(cneck if
applicable)
7 Id f ]
7 2d [ ]
73d []
7 4d [ 1
7 5d [ ]
7 6d [ ]
7 7d [ ]
7 8d [ ]
7 9d [ ]
7 lOd f 1
E Treatment
Efficiency
Estimate
7 1e %
7 2e %
7 3e %
7 4e %
7 Se %
7 6e %
7 7e %
7 8e %
7 9e %
7 lOe %
F Based on
Operating
Dala?
Yes No
7 " [ 1 [ 1
7 2f [ ] [ ]
73f [ ] [ ]
74, [ ] [ ]
751 [ ] t ]
761 [ ] [ ]
771 [ 1 1 ]
78, [ ] [
791 ( 1 [ 1
7,0, [ ] [ ]
I J (Check if additional Information is provided on Part IV-Supplemental Information )
B POLLUTION PREVENTION OPTIONAL INFORMATION ON WASTE MINIMIZATION
(Indicate actions taken to reduce the amount of the chemical bemg released from the facility See the instructions for coded
items and an explanation o, what information to include I
A Type of B Quantity of the Chemical in Wastes C Index
Modification Prior to Treatment or Disposal
(enter code)
Current Prior Or percent change
reporting year (Check M or (-))
year (pounds/yean f-\ .
r~~l 1 ipounosiyearj p! ^_^ __
D Reason for Action
(enter code)
ED
EPA Form 9350-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
D-6
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
n
(Important Type or print, read instructions before completing form )
a
Page 5 of 5
(This space for your optional use )
£L PDA EPA FORM R
*"' ** PART IV. SUPPLEMENTAL INFORMATION
Use this section if you need additional space for answers to questions in Part III
Number the lines used sequentially from lines in prior sections (eg. 534. 612 711)
ADDITIONAL INFORMATION ON RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE
(Part III, Section 5 3)
You may report releases of less than
1 000 pounds by checking ranges under
(Do not use both A 1 and A 2)
A
5 3 Discharges to _
receiving streams or [ 1
water bodies 5 3 L_l
(Enter letter coae from Part I |"~
Section 3 10 for ilraam(cl In e t 1
tna DOX oroviaed ) 3 J "
u
S3 n
1
5 3 a
5 3 a
S3 a
A Total Release
(pounds/yr)
A 1
Reporting Ranges
[ 1 [
] [ 1
] [ 1
[][][]
ADDITIONAL INFORMATION ON TRANSFERS OF THE CHEMICAL IN
(Part III. Section 6)
You may report
of less than 1 OC
ranges under A
botn A 1 ana A
transfers
0 pounds bv checking
1 (Do not use
Dlicnarge to BOTW . , , .
.. . lenler location numoer 1 . | | 1
0 1 from Part n Section i I | ' | | |
Otner olf-i.ta location , . _ .
e 2 (enter location numoer 2
8 ' from Pan II Section 2 1 1 * 1 I 1
Other off-nte location | . r i
6 2 lamer location numaer 12
'rwn Dart ii Section 2 I 1 1 1 1
Otner off-aite location , . , ,
A 2 (enter location numoer | * |
8 from Part ii Section 2 1 Lz J 1 1
ADDITIONAL
A ;e-eral
vvastestream
(enter coae
In box orovlded)
7 a | |
7 aQ
7 a | |
' 1
7 a n
7 a 1 1
i_j
7 a I 1
I___J
7 a | |
* '
7 a | |
' '
7 d i j
A Total Transfers
(pounas/yr|
A 1
Reporting Ranges
1-10 11-408 SOO-888
I
I
[
[
[
[ ]
[ ]
[ ]
[][][]
A 2
Enter
Estimate
B Basis of
Estimate
(enter code
in box
S3_bD
S3__bD
53 h[~
C % From
Stormwater
5 3 c %
5 3 c %
53 c %
WASTE TO OFF-SITE LOCATIONS
B Basis of
Estimate
A 2 (enter code
Enter In box
Estimate provided)
6 1
b|~l
62 b 1 1
62 b 1 1
62 b 1 1
C Type of Treatment/
Disposal
(enter code
In box
provided)
^gfca^E^H^^m||Bjjjffi(f(^SB
62 C[M[ [ \
B 2
C|M| | |
62 cHyvm
INFORMATION ON WASTE TREATMENT METHODS AND EFFICIENCY (Part III. Section
3 T-eatent
Method
(enter code
In box provided)
7 b rm
7 b rm
7 b III)
1 1 1 1
7 b Illl
'111
7 b rm
7 b rm
7 b rm
7 b rm
: o rm
C Range of
influent
Concentration
(enter code)
7
7
7
7
7
7
7
7
-
e n
i '
* n
«= n
c n
» n
= n
. r i
' '
D Se:.or.:
-------
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
-------
TRIS 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
in
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 Kermit software available. The Kermit
file transfer protocol was developed several years ago
by Columbia University for transferring data to and
from mainframes. Columbia placed Kermit 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 Kermit 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 Kermit file transfer prototol.
While all versions of MS-Kermit will perform Kermit
file transfer, Crosstalk must be version 3.6 or later to
perform Kermit file transfers. The opening banner of
Crosstalk will display the version as you start the
program as shown below:
09/03/91 E - 8 MICRO-TO-MAINFRAME LINK
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK - XVI
Crosstalk XVI ver 3 7b
Copyright(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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
-CROSSTALK - XVI Status Screen'
OTline
NAme Crosstalk default settings
NUmber 0700
LOaded STD
CApture Off
I Communications parameters'
SPeed 2400 PArity Even DUplex
DAta 7 STop 1 EMulate
POrt 1 MOde
Filter settings'
DEbug OT LFauto
Full DEbug OT LFauto OT
VT-100 TAbei Off BLankex Off
Call INTilter On OUtfiltr On
ATten
SWuch
GS CD
Home
Key sellings'
COmmand ETX CO
BReak End
f~ SEnd control settings ~I
CWait None
LWait None
I
I) EMAIL
Available command files
2) NEWUSER 3) SETUP 4) STD
5) TSO
Enter number for file to use ( I -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,
iog 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:
fiEADY
KERMIT
The following prompt will then appear:
Kermit-TSO>
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
Kermit-T50»SEN3 data-set-name
Delay in seconds before sending is 20
Escaoe to your local KERMIT and enter tne RECEIVE command
MS-KERMIT
DOWNLOAD
PROCEDURES
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.
Thp Kprmit-MS> prompt appease on the screen
Enter RECEIVE in response to the prompt as shown
below:
Kermit-MS>RECEIVE
Kermu-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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK
DOWNLOAD
PROCEDURES
I
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 ana luuLinues 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:
I
Kermit-TSO>REC
Entering receive mode
Escaoe to your local KERMIT ana enter the SEND command
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:
GommandTSEND myfile.m
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
09/03/91
E-14
MICRO-TO-MAINFRAME LINK
-------
IRIS 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:
Command?kermit mode binary
J
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.
9
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 f5!e transfer there rr.ust 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 The IRMA card from Digital Communications Asso-
FORTE CARD 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
UPLOADING
USING IRMA
OR FORTE
10
09/03/91
E-16
MICRO-TO-MAINFRAME LINK
-------
THIS 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\pct~ile.typ tso.dsnH.mbnJ [opuonsj
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
-------
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
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\IRMATEXTDOC 'ABCW123 IRMATEXT(MAY0189)'
RECFM(FB) LRECU80) BLKSIZE(6l60) SPACE(5.D 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 software 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
IRMATEXT 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 A:\IRMATEXT.DOC
'ABCW123.IRMATEXT(MAY0189)' ASCII CRLF
14
09/03/91 E - 20 MICRO-TO-MAINFRAME LINK
-------
TRIS 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 \myirmadoc 'target-dsn(mbr)1 ASCII CRLF
TRANSO1 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
UPLOADING
USING THE LAN
SNA GATEWAY
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.
To send, or upload, a file to the IBM mainframe from
your PC using the LAN SNA Gateway, the 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 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 (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 C:\MAINV
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
-------
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 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 VSENDFILE C \PCOXTEXT DOC
ASCII CRLF
A ' ABCW 1 23 PCOXTEXT( M AYO 1 8 9 )'
J
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 oponitos 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
-------
TRIS 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
CX1TEXT DOC to the C: disk drive on the PC from
a data set in TSO called 'ABCW123.CXITEXT1
member MAYO 189 through PCOX window A- to be
merged into a WordPerfect document on the PC, the
command would look like the following:
I CVRECEIVEC \CXITEXT DOC A ABCW123CXITEXTLMAY0189/
I ASCII CRLF
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,
meree. or orint thp new PC file
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 Tile 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-
pon en ts 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 ti mesh are 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
-------
THIS 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 File Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
Vxix
Node
LUNAME
Fl-Help F2-Msgs F3-Mam ESC-Quit AF2-ISRAF3-DOS
FlO-Select AFlO-Terminale
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
External File Interface Services
02-15-90
File Transfer
SEND
RECV
SENDR
RECVR
PC file --» Host
Host » PC File
Remote Disk --> Host
Host » Remote Disk
Other EFI Services
SELECT
DBXFER
SUBMIT
Predefined Extraction
Database Transfer
Submit Job to Host
Fl-Help F2-Msgs F3-Main ESC-Quit AF2-ISRAF3-DOS
FlO-Select
Next, highlight the SEND command and press F10.
The following screen appears1
23
09/03/91
E-29
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PC -» Host
From:
FilePaib C-
To:
HostDSN
Append No
Arbiter *
File Transfer
TEXT TEXT
Transfer Type B1NART
02-15-^0
| Member | ( )
Fl-Help F2-Msgs F3-Main F4-EFI FIO-Exec ESC-Quii AF2-ISR AF3-DOS
F3-T F6-4 F9-View
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 ir. the Arbiter Users Guide in Chapter 21
24
09/03/91
E-30
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The filepath field requires a valid PC file name and
optional path that references an existing PC file.
» 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-15-90
Remote Disk Environment Services
External File Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
VX.M
Node
LUNAME
Fl-Help F2-Msgs F3-Main ESC-Quu AF2-ISR \F3-DOS
L FlO-Select AFIO-Terminate
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
Arbiter *«
External File Interface Services
02-13-90
File Transfer
SEND
RECV
SENDR
RECVR
PC file --» Host
Host --» PC File
Remote Disk » Host
Host --» Remote Disk
Oiher EFI Services
SELECT
DBXFER
SUBMIT
Predefined Extraction
Database Transier
Submit Job to Host
Fl-He!p F2-Msgs Fj-Mam ESC Quit AF2-ISRAF3-DOS
FlO-Select
r
Next, select RECV using the highlighted bar and
F10. The following screen appears:
27
09/03/91
E-33
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
c
J I
Host --»
PC
Arbiter ««
File Transfer
: The Host Data Set h
From:
HoslDSN
-,
02-15-90
ame must be filled jo
TEXT
Transfer Type
TEXT
FIXREC
BINARY
To:
FilePaih
Replace
FI-Help
S^_
s~
| Member
(
)
C:
No
F2-Msss
F3-Main F4-EFI FlO-Eiec ESC-Quit
( F10
v_ _/
AF2-ISR AF3-DOS
\
I
I
%
>
J
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
s,
Replace
Fl-Help
No
Host -» PC File Transfer
FILE-EXT 8192 2-15-90 3:28p
F2-Msgs F3-Mam F4-EFI FIO-Eiec ESC-Qun AF2-ISR AF3-DOS
i
29
09/03/91
E-35
MICRO-TO-MAINFRAME LINK
-------
TR1S INFORMATION RETRIEVAL USERS GUIDE
COMMAND LINE You may suppress the full-screen panels of Arbiter
TRANSFERS
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:
lc\>
J SEND Idevlfile path /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.
/DSN='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
Arbiter file transfer 21
Arbiter PC software 21
Asynchronous transfer 1
AUTOMAX menu 11
g 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
Q 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 1
CXI card 13
CXI, WINDOWED version 13
Q 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 LO
Direct wired connection 1
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 Kermit 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
p File transfer, introduction 1
File transfer, Arbiter 21
File transfer, coax 10
File transfer, Kermit 2
File transfer, LAN SNA gateway 16
FORTE 1
FORTE card 10
FT3270 SEND/RECEIVE 10
FTTSO 10
Full-screen panels, for Arbiter 21
H HOTKEY 11, 13, 17
I IND$FILE 10, 16'
IRMA 1
IRMA card 10
K KERMIT RECEIVE 7
KERMIT SEND command 8
Kermit protocol 2
Index-2
09/03/91 E - 39 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
|_ 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
T 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
(J 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
W Workstation software 16
«U 5 Government P-.nline Off.cc 9«0-*:B-S.*
Index-4
09/03/91 E - 41 MICRO-TO-MAINFRAME LINK
-------
TRIS 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
+ 1 + 1 + PF11 equivalent
PF12 equivalent
11/18/91
F-7
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Keyboad mapping for:
KEY
FUNCTION
11/18/91
F-8
KEYBOARD MAPPINGS
* U i Goiernmont Printing Office 1991 - 312-014/40024
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX G
REGIONAL ACCOUNT MANAGERS
09/03/91 G 1 REGIONAL ACCOUNT MANAGERS
-------
THIS 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
TRTJD
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
TRIS
Region 3
Charles Isbell
EPA/NADB/MDAD-OA&R
Mutual Building
RTP, 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
-------
IRIS INFORMATION RETRIEVAL USERS GUIDE
TRI4
Region 4
TRI5
Region 5
TRI6
Region 6
TRI7
Region 7
TRI8
Region 8
Jesse Dooley
EPA/Region 4
345 Courtland St. NE
AUanta, 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: 1991517-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
------- |