-------
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
09/03/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
09/03/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
09/03/91 iii TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF CONTENTS (Continued)
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
09/03/91 iv TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDICES
APPENDIX A
APPENDEX B
APPENDIX C
APPENDIX D
APPENDIX E
APPENDIX F
APPENDIX G
GLOSSARY
SAMPLE BATCH REPORTS
EPA REGIONS AND STATES
FORMR
MICRO-TO-MAINFRAME LINK
KEYBOARD MAPPING
REGIONAL ACCOUNT MANAGERS
09/03/91
TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TABLES
5-1 Facility Name Search - Facilities Screen 5-11
5-2 Facility Name Search - Submission & Chemical Screen 5-11
5-3 City / County Search - Facilities Screen 5-19
5-4 City / County Search - Submission & Chemical Screen 5-19
5-5 CAS / Chemical Search - Facilities Screen 5-27
5-6 CAS / Chemical Search - Submission & Chemical Screen 5-27
5-7 Alternate Facility Key Search - Facilities Screen 5-35
5-8 Alternate Facility Key Search - Submission & Chemical Screen 5-35
5-9 Submission Display 5-39
5-10 POTW / Offsite Search 5-43
5-11 Year-to-Year Release / Transfer Comparison 5-45
5-12 Historical Facility Search 5-49
5-13 Chemical Table Search 5-52
09/03/91 vi TABLE OF CONTENTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1 INTRODUCTION
09/03/91 1 - 1 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 1 .2 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1 INTRODUCTION
1.1 What is SARA?
In 1986, Congress passed the Superfund Amendments and Reauthorization Act, or SARA. Title
III of SARA, known as the Emergency Planning and Community Right-to-Know Act (EPCRA),
mandates in Section 313, that an inventory of toxic chemicals released into the air, water, or land
must be maintained by the Environmental Protection Agency (EPA). It also mandates that the
EPA must make this information available to the public.
1.2 What is TRIS?
TRIS stands for the Toxic Chemical Release Inventory System. It is the computer system used
by the Environmental Protection Agency to track the annual estimated release of toxic chemicals
into the environment. It serves as a management tool used by the EPA to simplify the collection
and organization of toxic chemical release data received from industries regulated under SARA.
1.3 What Type of Information is Available in TRIS?
TRIS contains information about the releases and transfers of over 300 different toxic chemicals.
This includes information, such as, CAS Number and chemical name, company name, amount
of the chemical released or transferred off-site, medium released into (air, water, land...), Standard
Industrial Classification (SIC) code, activity and use of the toxic chemical, technical and public
contacts, waste treatment information, and the locations to which chemicals are transferred.
09/03/91 1 - 3 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1.4 How is Information Received?
Companies which must report under this rule complete EPA's Form R. Information contained
on the Form R may be submitted by the reporting companies on magnetic tape or floppy disk.
This information is then sent to the EPCRA Reporting Center in Washington, D.C.
1.5 How is Information Prepared for Access?
Form Rs are received at the EPCRA Reporting Center for processing. The information on each
Form R is keyed by data entry personnel into the TRIS Data Entry System. The TRIS Data
Entry System is a menu driven data entry and tracking system located on a PC local area
network. If the information is submitted on floppy disk or magnetic tape, the information is
simply electronically read into the TRIS Data Entry System. Once the data are entered, it is
checked for accuracy against the submission. Then it is transferred to the IBM ES/9000 at EPA's
National Computer Center (NCC) in Research Triangle Park, North Carolina.
1.6 How Much Information is Available in TRIS?
TRIS currently contains information for three reporting years; 1987, 1988, and 1989. Companies
throughout the U.S. and its territories (District of Columbia, Guam, Puerto Rico, American
Samoa, the U.S. Virgin Islands, and the Commonwealth of Northern Marianas Islands) submitted
TRI Form Rs in the quantities shown on the following page.
09/03/91 1 - 4 INTRODUCTION
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Year
1987
1988
1989
Companies
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 modem 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 iTi 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
-------
THIS 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 and 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
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.
09/03/91 2 - 3 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2.1 TSO Logon Procedure
1) Turn on the hardwired terminal; the Telecommunications Network Logon screen (Figure
2-1) will appear. Type TSO and press .
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. MAIL EPA Electronic Mail for 3270
4. APPLICATIONS EPA Applications Menu
5. INTER-AGENCY Inter-Agency Applications Menu
Date: 05/14/91
Time: 14:30:06
Terminal: T2312611
Logmode: S3278R2
Command =-=> TSO
Fl/F13=Help F5/F17-Refresh F12/F24-Cancel
Figure 2-1
09/03/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 ED and press
to advance to the PASSWORD field. Type your PASSWORD and press
. (If previously supplied, PROCEDURE, ACCT NMBR, and FIMAS are
entered automatically). See Appendix A for an explanation of these terms.
PF1/PP13 =-> Help
EPA2 TSO/E LOGON -
PF3/PF15 ~> Logoff PA.1
ENTER LOGON PARAMETERS BELOW:
USERID =-> ABC
PASSWORD ===>
PROCEDURE =>
ACCT NMBR »-=>
FIMAS -»=>
SIZE ===>
COMMAND --»>
........................................ *F2 312 £11
Attention PA2 «> Reshow
RACF LOGON PARAMETERS:
NEW PASSWORD >
GROUP IDENT =«=>
BIN NUMBER --»>
SYSOUT DEST =-=>
ENTER A "S" BEFORE EACH OPTION DESIRED BELOW
-NOMAIL -NONOTICE -NOSUMMARY
-CANCEL
Figure 2-2
A logon confirmation message (Figure 2-3) will appear followed by three asterisks. Press
to continue.
ICH70001I ABC LAST ACCESS AT 14:31:36 ON WEDNESDAY, MARCH 27, 1991
IKJ56455I ABC LOGON IN PROGRESS AT 14:32:39 ON MAY 14, 1991
ARC1020I DFHSM IS RECALLING FROM TAPE DSN-HLRTRID.TABLES, YOU MAY CANCEL WAIT
FOR RECALL BY PRESSING THE ATTENTION KEY.
ARC0612I VOLUME MOUNT ISSUED FOR RECALL OR RECOVER OF ABCTRID.TABLES
***
Figure 2-3
09/03/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 WILL END
CHANGE IN ARCHIVAL OF DATA SETS (UPDATE)
- SEE NEWS ALERT4
- SEE NEWS ALERT!
- SEE NEWS ALERT3
- SEE NEWS ALERT9
- SEE NEWS ALERT2
Figure 2-4
The NATURAL Logon Procedure screen (Figure 2-5) will appear.
APPLICATION-ID prompt, type TRISONLN and press .
At the
***** NATURAL LOGON PROCEDURE *****
ENTER APPLICATION-ID: TRISONLN USER-ID: ABC
FOR A LIST OF APPLICATIONS CURRENTLY AVAILABLE FOR SELECTION,
ENTER '??' AS THE APPLICATION-ID.
TO TERMINATE NATURAL. ENTER 'FIN' AS THE APPLICATION-ID.
FOR MORE HELP, ENTER A '?« AS THE APPLICATION-ID.
Figure 2-5
09/03/91
2-6
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6) The TRIS Welcome screen (Figure 2-7) will appear. Press to continue.
PGM: TRISLOGO
HAP: LOGOMAP1
TTTTTTTTTTTTTTT
TTTTITTTTTTTTTT
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
U. 5. ENVIRONMENTAL PROTECTION AGENCY 05/14/91
OFFICE OF TOXIC SUBSTANCES
RRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRRR 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
14:35:29
SSSSSSS
sssssssssss
sssssssssssssss
sssss ssss
sssss ssss
ssssss
ssssss
ssssss
ssssss
ssssss
ssss sssss
ssss sssss
sssssssssssssss
ssssssssssss
ssssssss
Messages
Enter-PPl PF2 PF3 PF4 PP5 PP6 PP7 PF8 PP9 PF10 PP11 PP12
CONT EXIT
Figure 2-7
7) The TRIS System Message screen (Figure 2-8) 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
Number of Submissions
*1987*
79,057
*1988*
84,693
*1989*
82,513
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8
CONT
-PF9 PF10PF11 PF12-
EXIT
Figure 2-8
09/03/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
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-PFlPF2 PF3 PF4 PF5PF6 PF7 PF8 PF9 PF10PFilPFT2-
HELP EXIT
Figure 2-8
2.2 ISO 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 Telecommunications Network Logon screen (Figure 2-1) will be redisplayed.
4) To exit the Network Logon screen, turn off the hardwired terminal.
09/03/91
2-8
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2.3 CICS Logon Procedure
1) Turn on the hardwired terminal. The Telecommunications Network Logon screen (Figure
2-9) will appear. Type PCICS and press .
Menu System
Please enter selection or command and then press ENTER.
1. INFORMATION News Alerts and User Meraos
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
Time: 16:19:49
Terminal: T2312628
Logmode: S3278R2
Command ==«> PCICS
Fl/F13=Help F5/F17=Refresh F12/F24=Cancel
Figure 2-9
09/03/91
2-9
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
2)
3)
At the prompts (Figure 2-10), type your USER ID and press . (If previously
supplied, ACCOUNT, FIMAS, and GROUP are entered automatically.) Type your
PASSWORD and press .
PRODUCTION CICS
NETNAME" T2312628
USERID: ABC
ACCOUNT:
FIMAS ID:
GROUP:
PASSWORD:
NEW PASSWORD: (OPTIONAL)
INITIAL TRANSACTION:
- NO NEWS (ENTER ANY CHARACTER TO SUPPRESS NEWS ALERTS)
PF1/13: HELP PF3/15 OR CLEAR: TERMINATE SIGNON PF12/24: LOGOFF
Figure 2-10
The News Alert screen (Figure 2-11) will appear. Press to continue.
PREFIX:
CICS - NEWS ALERT FACILITY
(CICS, ADAS, ALERT, OR BLANK FOR ALL)
91/05/24 RACF VERSION 1.9 (UPDATE)
91/05/29 JOB OUTPUT LOST
91/02/27 CHANGE IN ARCHIVAL OF DATA SETS (UPDATE)
91/05/28 POSSIBLE DATA LOSS ON USR201 AND OVH009
91/05/22 PIE/TSO UPGRADE
91/05/29 POSSIBLE DATA LOST ON USS113
91/05/15 POSSIBLE DATA LOSS ON USS055
91/05/15 ADABAS SQL VERSION 1.4.1 IMPLEMENTATION
91/05/20 POSSIBLE DATA LOSS ON VSAH03
91/03/27 SUPPORT FOR ADAMINT PROGRAMS WILL END
ALERT1
ALERT10
ALERT2
ALERT3
ALERT4
ALERTS
ALERT6
ALERT?
ALERTS
ALERT9
PF1/13: HELP PF3/15: END ENTER: VIEW PF7/19: PREV PAGE PF8/20: NEXT PAGE
Figure 2-11
09/03/91
2-10
ACCESS TO TRIS
-------
5)
TRIS INFORMATION RETRIEVAL USERS GUIDE
4) A blank screen (Figure 2-12) will appear. Type NATP and press .
NATP
Figure 2-12
The NATURAL Logon Procedure screen (Figure 2-13) 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-13
09/03/91
2-11
ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6) The TRIS Welcome screen (Figure 2-14) will appear. Press to continue.
MAP: LOGOMAP1
OFFICE OF TOXIC SUBSTANCES
16:24:57
TTTTTTTTTTTTTTT
TTTTTTTTTTTTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
TTTTT
Welcome to TRIS,
RRRRRRRRRRR IIIIIIIIIII
RKRRRRRRRRRRR IIIIIIIIIII
RRRRRRRRRRRRRR 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 PF10PP11PF12--
CONT EXIT
Figure 2-14
7) The TRIS System Message screen (Figure 2-15) will appear containing submission
statistics and other important information. Press to continue.
PGM: TRISLOGO TOXIC RELEASE INVENTORY SYSTEM 05/14/91
MAP: LOGOMAP2 SYSTEM MESSAGE SCREEN 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 PF10 PF11 PF12
CONT EXIT
Figure 2-15
09/03/91 2-12 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8) The Data Retrieval menu (Figure 2-16) 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 PF10 PF11 PF12
HELP EXIT
Figure 2-16
2.4 CICS Logoff Procedure
1) On the Data Retrieval menu, type X and press , or press .
2) On the NATURAL Logon screen (Figure 2-13), type FIN .
3) A blank screen will be displayed. Type CSSF LOGOFF, press .
4) The Telecommunications Network Logon screen (Figure 2-9) will be redisplayed.
5) To exit the Network Logon screen, turn off the hardwired terminal.
09/03/91 2-13 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 2-14 ACCESS TO TRIS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3 TRIS GENERAL FEATURES
09/03/91 3 - 1 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 3 - 2 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3 TRIS GENERAL FEATURES
3.1 Operational Features
There are features of the operation of TRIS that are common throughout the system. These
features are explained in detail below.
3.2 Menu Operation
TRIS is a menu-driven system. Data are retrieved by selecting an option from a menu, entering
requested variables where prompted, and pressing to move to the next screen.
3.3 Keyboard Operation
The keyboard utilizes either single keys or combinations of keys to enter variables and perform
operations in TRIS. There are also specially designated keys or key combinations that are unique
to TRIS; these are called Program Function or PF keys. PF keys in TRIS are used to move from
screen-to-screen, to obtain help, or to exit from TRIS. PF keys are displayed at the bottom of
each screen with a short translation indicating what function will be performed. Standard PF
keys in TRIS are:
= HELP Invokes online help function
= MAIN Transfers to data retrieval main menu
= PREV Transfers to previous screen
Other PF keys are active for various functions on a screen-by-screen basis. See Appendix F for
an explanation of keyboard mapping using assorted telecommunications packages.
09/03/91 iTaTRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3.4 Information Messages / Windows
TRIS protects the user from attempting to perform an operation not defined in the system, or
from entering variables that the system does not recognize. If an invalid operation or selection
is entered, the user receives an informational message at the top of the screen, or in a pop-up
window, stating that the operation or variable is not valid. For certain variables required by
TRIS, a pop-up window offering a selection of valid options is displayed.
3.5 Online Help Feature
TRIS contains an extensive online HELP feature. You may access HELP in several ways; for
example: pressing , placing a ? in the field and pressing , entering an
incorrect value in a field, or leaving a required field empty. Each method instantly displays a
pop-up window with HELP information. Detailed instructions on what is required or actual
values in a "pick list" are provided.
3.6 TRIS Data Keys
Several data elements that correspond to parts of Form R, are designated as data keys. These
keys allow users to search and retrieve data from the database. One of the most important keys
is the facility name. Other data keys include, but are not limited to the state, county, city, and
ZIP Code of the facility. Two special keys, described in detail below, are the Document Control
Number and TRI Facility ID.
09/03/91 3 - 4 TRIS GENERAL FEATURES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
3.7 Document Control Number
The Document Control Number (DCN) is a unique identification number assigned to each Form
R submission as it is received by EPA. The DCN is used to help locate documents after they
have been physically stored; help track the status of processing for each submission document;
and link other correspondence received from the submitter. The format for the DCN is:
Positions
1 -2
3-4
5- 12
13- 13
14- 15
2
2
8
1
2
Description
Document Type (always '13')
Reporting Year
Eight Digit Sequence Number
Check Digit
State Abbreviation
Example:
Submission
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
,__... _ 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 Brads tree t (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 iT~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
-------
THIS 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 IT~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: TRQOOOMl
TOXIC RELEASE INVENTORY SYSTEM
ONLINE QUERIES MENU
03/22/91
15:15:15
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: TRQQ10M1 FACILITY NAME SEARCH 13:50:56
REQUIRED REPORTING YEAR > 1989
FACILITY NAME > du pont e*
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: TRQ01ON3 TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS900MA FACILITIES 14:26:47
YEAR:
MARK
X
1989 FACILITY NAME: DU PONT C*
FACILITY NAME
DU PONT CSP 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
TRI ID
27239DPNTCRT1BO
43612DPNTC710MA
29020DPNTMPODRA
08023DPNTCRT130
37415DPNTC4501A
19801DPNTC501CH
52730DPNTCHIGHW
29411DPNTCCYPRE
78362DPNTCHIGHW
# SUBM
3
2
9
54
5
1
1
11
7
Enter-PPl PF2 PP3 PP4 PP5 PP6 PP7 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: TRQ01ON3 TOXIC RELEASE
MAP: TRS900MB FACILITY
INVENTORY SYSTEM
INFORMATION
05/16/91
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
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-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: 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 :
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PFB 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 C&P 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-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
HAP: TRS910MA SUBMISSIONS AND CHEMICALS
05/16/9X
14:28:06
FACILITY NAME : DU PONT CSP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARX DOC CNTL NUM 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 WASTE RELTR OSES
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
MAP: TRS91OMC SUBMISSION HASTE TREATMENT INFORMATION
FACILITY NAME : DU PONT C&P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTRBAM TREATMENT RANGE OF SEQUENTIAL TREATMENT
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA
H R03 1 90.00 /
/
/
/
05/16/91
14:29:03
OPERATING
DATA
N
Etvter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENTJ 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: TRS91ON
MAP: TRS91OMD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
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
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-PET- PF2- PF3 PF4-PF5 PF6 PF7 PF8 PF9 PF10PF11PF12
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: TRS91ON
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 MUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
RELEASES
FUGITIVE AIR
STACK AIR
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTH
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: TRS91ON
MAP: TRS91OMF
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 PF10PFI1PFI2-
HELP MAIN PREV QMENU RPTS
Figure 5-11
11) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information screen (Figure 5-12) will appear.
To return to the Submissions and Chemicals screen, press .
PGM: 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: 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
-------
THIS 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
ChemicaVSynonym/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
MAP: TRQ020M1
REQUIRED
FACILITY CITY
TOXIC RELEASE INVENTORY SYSTEM
CITY / COUNTY SEARCH
REPORTING YEAR. > 1989
FACILITY STATE > NC
> OR FACILITY COUNTY ....
DAVIDSON
04/05/91
15:01:46
OPTIONAL
FACILITY NAME >
CAS NUMBER >
OR
CHEMICAL/CATEGORY. . . . >
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-13
1) Type REPORTING YEAR. This is a required field. In this example, Reporting Year
1989' is used.
2) Type STATE. This is also required. Here, 'NC' is used.
3) Type either FACILITY CITY or FACILITY COUNTY. In this example, the county
'DAVIDSON' is used.
4) To further limit your search, optional fields may be used. Use to advance to the
FACILITY NAME and CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY
NAME fields and enter the corresponding information if desired. In this example, none
of these optional fields are used. Press to begin your search.
09/03/91 5 - 13 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
A list of facilities meeting the search (Figure 5-14) will appear. The search criteria appear at the
top of the screen. If the list is longer than one screen, press to page backward and
to page forward. In addition to the facility name, the TRI Facility ID and the number
of submissions received from the facility for that Reporting Year are displayed on each line.
5)
PGM: TRQ020N2 TOXIC RELEASE INVENTORY SYSTEM 06/12/91
MAP: TRS900MA FACILITIES 15:27:26
YEAR: 1989 STATE: NC COUNTY: DAVIDSON
MARK FACILITY NAME
CAROLINA SEATING CO.
COBLE DAIRY PRODUCTS
~ COUNCILL CRAFTSMEN tl
DIXIE DINING ROOM DIV.
DIXIE FURNITURE CO. INC.
DIXIE FURNITURE CO.
X DU PONT C&P HEALING SPRINGS
DURACELL USA
FOAM TECH INC.
HERMAN FURNITURE CO.
TRI ID
27263CRLNS101LI
27292CBLDR707NO
27239CNCLBPOBOX
27292DXFRNNCHUR
27292DXFRN411SS
27299DXFRNOLDLI
27239DPNTCRT1BO
27292DRCLL305NE
27292FMTCH117CE
27292HKMNF37PIC
» SUBM
1
2
5
5
5
6
3
5
1
1
Eriter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU NEXT RPTS -PAGE +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: TRQ010N3 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS900MB FACILITY INFORMATION
FACILITY NAME : DU PONT C5P HEALING
TRI FACILITY ID: 27239DPNTCRT1BO
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
Enter-PFl PF2 PF3 PF4 PF5
HELP MAIN PREV QMENU
SPRINGS
REPORTING YEAR: 1989
PARENT DUNS: 001315704
PARENT CO. : DUPONT
05/16/91
14:27:37
-PF6 PF7 PF8 PF9 PF10 PF11 PF12
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 CtP 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
+03S380Q
-0800606
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF11--PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-16
To display the total amount of Releases and Transfers reported by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-17) will appear.
To return to the Facilities screen, press .
PGM: TRQ01ON3
MAP: 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
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 PFB PF9 PF10PF11PF12
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 (POTW) and Other Offsite Locations.
09/03/91
5-15
ONLINE QUERIES
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
8)
9)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the column labeled 'MARK,' and press . The Submissions
and Chemicals screen (Figure 5-18) will appear. To return to the Facilities screen, press
.
PGM: TRS910N TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS910MA SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DO PONT CSP HEALING SPRINGS
T.RI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
MARK DOC CNTL NUM CHEMICAL NAME
X 13-89-03000421-8-NC AMMONIA
13-89-03000422-0-NC FORMALDEHYDE
~ 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 WASTE RELTR OSES
Figure 5-18
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-19) will appear. To return to the Submissions and
Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MC SUBMISSION HASTE TREATMENT INFORMATION 14:29:03
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
W R03 1 90.00 / N
Entec-PFl PF2 PF3 PF4 PF5- PF6- PF7 PF8~-PF9-~PFiO"PFll~PFi2~'-
HELP MAIN PREV QMENU RPTS
Figure 5-19
09/03/91 5-16 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
10) To display Waste Minimization data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Waste Minimization Information screen
(Figure 5-20) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS91ON
MAP: TRS910MD
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
FACILITY NAME : DO PONT CfiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE MINIMIZATION DATA
TYPE OF MODIFICATION
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 PF10
HELP MAIN PREV QMENU RPTS
Figure 5-20
11) To display Release and Transfer data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Releases and Transfers screen (Figure
5-21) will appear. To return to the Submissions and Chemicals screen, press .
PGM: TRS91ON
MAP: TRS910ME
TOXIC RELEASE INVENTORY SYSTEM 05/16/91
SUBMISSION RELEASES AND TRANSFERS 14:29:27
FACILITY NAME : DU PONT CfiP 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 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN 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
MAP: TRS91OMF
TOXIC RELEASE INVENTORY SYSTEM
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 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 QMENU RPTS
Figure 5-22
13) To display Contact data, type an X before the DCN in the column labeled 'MARK,' and
press . The Submission Contact Information (Figure 5-23) will appear. To
return to the Submissions and Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS910MB SUBMISSION CONTACT INFORMATION 13:28:04
FACILITY NAME : DU PONT CtP 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
Entec-PFl PF2 PF3 PF4 PF5 PFfi PF? PF8 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: TRQ03OM1
TOXIC RELEASE INVENTORY SYSTEM
CAS NUMBER / CHEMICAL NAME SEARCH
05/13/91
13:51:06
REQUIRED
REPORTING YEAR...> 1989
CAS NUMBER... . > OR
CHEMICAL/CATEGORY NAME.
FORMALDEHYDE
OPTIONAL
REGION....> 04
STATE > NC
--OR--
ZIP CODE..>
Key selection criteria and press
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11PF12-
HELJP 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 DD 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 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV QMENU RPTS -PAGE +PAGE FACIL DCNS RELTR COORD
Figure 5-25
To obtain more information about a particular facility, type an X before the Facility Name
in the column labeled 'MARK,' and press . The Facility Information screen
(Figure 5-26) will appear. To return to the Facilities screen, press .
PGM: 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" PF5 PF6- PF? PFfl---PF'9---PFlO--PFii PF12--
HELP MAIN PREV QME1TO RPTS DCNS
09/03/91
Figure 5-26
5 - 22 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4)
5)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude / Longitude screen
(Figure 5-27) will appear. To return to the Facilities screen, press .
PGM: TRQ010N3
HAP: TRS900MD
TOXIC RELEASE INVENTORY SYSTEM
FACILITY LATITUDE / LONGITUDE COORDINATES
05/16/91
14:28:36
FACILITY NAME : DU PONT CCP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1969
FACILITY LATITUDE
FACILITY LONGITUDE
ZIP CENTROID LATITUDE
ZIP CENTROID LONGITUDE
EPA ASSIGNED LATITUDE
EPA ASSIGNED LONGITUDE
-(0353645
-0801036
+0353800
-0800606
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10PF1IPF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-27
To display the total amount of Releases and Transfers reporting by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-28) will appear.
To return to the Facilities screen, press .
PGM: 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
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 --
HELP MAIN PREV QMENU
^ PF6 --- PF7 --- PF8 --- PF9 --- PF10 PF11 PF12 ---
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: TRS91ON
MAP: TRS910MA
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSIONS AND CHEMICALS
05/16/91
14:28:06
FACILITY NAME : DU PONT CiP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
HARK DOC CNTL NUM
CHEMICAL NAME
13-89-03000421-8-NC
13-89-03000422-0-NC
13-89-03000423-2-NC
AMMONIA
FORMALDEHYDE
METHANOL
Enter-PFl PF2 PF3' PF4 PFS PF6 PF7 PF8 PF9 PF10--PF11--PF12
HELP MAIN PREV QMENO CNTCT RPTS -PAGE +PAGE TREAT WASTE RELTR OSES
Figure 5-29
To display Waste Treatment Methods and Efficiency data, type an X before the DCN in
the column labeled 'MARK,' and press . The Submission Waste Treatment
Information screen (Figure 5-30) will appear. To return to the Submissions and
Chemicals screen, press .
PGM: TRS91ON TOXIC RELEASE INVENTORY SYSTEM 05/16/91
MAP: TRS910MC SUBMISSION WASTE TREATMENT INFORMATION 14:29:03
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
WASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT OPERATING
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA DATA
W R03 1 90.00 / N
Enter-PFl---PF'2- PF3 PF4 -PFS---PF6 PF? pF8~-PF9-~PFiO~PFil~PF'i2"---
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 HASTE MINIMIZATION INFORMATION
05/16/91
14:29:16
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
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-PFl PF2 PF3 PF4 PF5 PF6=PF7 PF8 PF9 PF10PF11PF12
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 C&P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NTJM: 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-32
09/03/91
5 - 25 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
10) To display Activity and Uses data, type an X before the DCN in the column labeled
'MARK,' and press . The Submission Activity and Uses Information screen
(Figure 5-33) will appear. To return to the Submissions and Chemicals screen, press
.
PGM: TRS91ON
MAP: TRS910MF
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION ACTIVITY AND USES INFORMATION
05/16/91
14:29:35
FACILITY NAME : DU PONT C6P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
ACTIVITY AND USES:
ANCILLARY OR OTHER USE
Enter-PFl 'PF2 PF3-PF4-PF5 PF6 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 .
PGM: TRS91ON
MAP: TRS910MB
TOXIC RELEASE INVENTORY SYSTEM 06/14/91
SUBMISSION CONTACT INFORMATION 13:28:04
FACILITY NAME : DU PONT CSP HEALING
TRI FACILITY ID: 27239DPNTCRT180
DOC CNTL NUM: 13-89-03000421-8-NC
SPRINGS
REPORTING YEAR: 1989
CHEMICAL NAME: AMMONIA
TECHNICAL CONTACT:
PHONE:
PUBLIC CONTACT:
PHONE:
G. L. RISER
609/540-2666
C. A. CREMEANS
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 ID
DUNS Number
EPA ID
Document Control Number (DCN)
Parent Company DUNS Number
Parent Company Name
Note that the Reporting Year is required for each selection. In addition to items listed above,
the search can be further limited by supplying one of the following:
CAS Number
Chemical/Synonym/Compound
After a search of the database, the names of facilities that meet the search criteria are displayed
with their TRI Facility IDs and number of submissions for the applicable Reporting Year. From
this screen, the user is given several options, based upon Program Function (PF) keys, to display
selected information.
ACCESS: Select option 4 from the Online Queries menu. The Facility Key Search screen
(Figure 5-35) will appear.
09/03/91 5-28 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type 1 to select TRI Facility ID from the Facility Key Search Selection menu (Figure
5-35). Press . In this example, TRI Facility ID is used.
PGM: TRQ04OP TOXIC RELEASE INVENTORY SYSTEM 06/13/91
HAP: TRQ040M1 FACILITY KEY SEARCH SELECTION 14:52:45
1 TRI FACILITY ID
2 DUNS NUMBER
3 EPA ID
4 DOCUMENT CONTROL NUMBER
5 PARENT DUNS NUMBER
6 PARENT COMPANY NAME
Key selection and press >
Enter-PFl-PF2 PF3 PF4PF5 PF6 PF7PF8 PF9 PF10--PF11PF12
HELP MAIN PREV RPTS
Figure 5-35
2) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
3) Type a TRI FACILITY ID. This is also required. Here '27239DPNTCRT1BO' is used.
Upper or lower case letters can be used. The following optional fields may be used to
narrow the search: a CAS NUMBER or a CHEMICAL/SYNONYM/CATEGORY
NAME. In this example (Figure 5-36), none of these optional fields are used. Press
to begin the search.
PGM: TRQ04OP1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ04OM2 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
Enter-PFl PF2 PF3 PF4 PF5
HELP MAIN PREV
...> 1989
...> 27239DPNTCRT1BO
. . .>
. ..>
criteria and press
PF6 PF7 PF8 PF9 PF10--PF11-- -PF12--
RPTS
Figure 5-36
09/03/91
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
ID 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 CSP HEALING SPRINGS
SYSTEM 06/13/91
14:54:15
TRI ID * SUBM
27239DPNTCRT1BO 3
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11--PF12
HELP MAIN PREV QMENO 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 PFS---PF6---PF7 PFd PF$' PF10-- PF11 PFlS
HELP MAIN PREV QMENU RPTS DCNS
09/03/91
Figure 5-38
5 - 30 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5)
6)
To display Latitude and Longitude coordinates, type an X before the Facility Name in the
column labeled 'MARK,' and press . The Facility Latitude / Longitude screen
(Figure 5-39) will appear. To return to the Facilities screen, press .
PGM: TRQ01ON3
HAP: TR5900MD
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: 1969
FACILITY LATITUDE : +0353645
FACILITY LONGITUDE : -0801036
ZIP CENTROID LATITUDE : +0353800
ZIP CENTROID LONGITUDE : -0800606
EPA ASSIGNED LATITUDE :
EPA ASSIGNED LONGITUDE :
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF? PF8 PF9 PF10-- PF11-- PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-39
To display the total amount of Releases and Transfers reported by a facility for that
Reporting Year, type an X before the Facility Name in the column labeled 'MARK,' and
press . The Facility Releases and Transfers screen (Figure 5-40) will appear.
To return to the Facilities screen, press .
PGM: TRQ010N3
MAP: TRS900MC
TOXIC RELEASE INVENTORY SYSTEM
FACILITY RELEASES AND TRANSFERS
05/16/91
14:28:25
FACILITY NAME : DU PONT CtP HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
RELEASES
FUGITIVE AIR
STACK AIR
WATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTW
OFF-SITE
TOTAL TRANSFER
11,300
32,600
43,900
These amounts are the totals
for all submissions for this
facility and reporting year.
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11PF12
HELP MAIN PREV QMENU RPTS DCNS
Figure 5-40
Releases include five types: Fugitive Air, Stuck Air, Water, Underground, and Land. Transfers
include two types: Publicly Owned Treatment Works (POTW) and Other Offsite Locations.
09/03/91
5-31
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
7)
8)
To display Document Control Numbers and Chemical Names, type an X before the
Facility Name in the 'MARK' column, and press . The Submissions and
Chemicals screen (Figure 5-41) will appear. To return to the Facilities screen, press
.
PGM: TRS91ON 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 QMENU CNTCT RPTS -PAGE +PAGE TREAT WASTE 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: TRS910N TOXIC RELEASE INVENTORY SYSTEM
MAP: TRS91OMC SUBMISSION WASTE TREATMENT INFORMATION
FACILITY NAME : DU PONT C&P HEALING SPRINGS
TRI FACILITY ID: 27239DPNTCRT1BO REPORTING YEAR: 1989
DOC CNTL NUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
WASTE TREATMENT METHODS AND EFFICIENCY 1 OF 1
HASTESTREAM TREATMENT RANGE OF SEQUENTIAL TREATMENT
CODE METHOD INFLUENT CONC TREATMENT EFFICIENCY/NA
W R03 1 90.00 /
05/16/91
14:29:03
OPERATING
DATA
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: TRS910N
MAP: TR5910MD
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 HUM: 13-89-03000421-8-NC
CHEMICAL NAME: AMMONIA
HASTE 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 PFIDPFI1PF12
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: TRS91OME
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION RELEASES AND TRANSFERS
OS/16/91
14:29:27
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
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
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 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 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. RISER
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-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 ED is used.
PGM: TRQ05OP TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ05OM1 SUBMISSION DISPLAY SELECTION 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 -PF2PF3 PF4 PF5-PF6 PF7 PF8 PF9 PF10PF11PF12
HELP MAIN 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 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-48), none of these optional fields are used. Press
to begin the search.
PGM: TRQ05OP1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ050M2 SUBMISSION DISPLAY BY TRI FACILITY ID 14:55:18
REQUIRED
REPORTING YEAR. ...> 1989
TRI FACILITY ID > 27239DPNTCRT1BO
OPTIONAL
CAS NUMBER >
OR
CHEMICAL/CATEGORY NAME....>
Key selection criteria and 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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
The number of submissions found that meet the search criteria will appear. The Reporting Year
selected for this search is displayed at the top of the screen (Figure 5-49). The TRI Facility ID
entered is also displayed.
4)
PGM: TRQ050P1
MAP: TRQ05OM9
TOXIC RELEASE INVENTORY SYSTEM
SUBMISSION DISPLAY
06/13/91
14:55:42
REPORTING YEAR: 1989
3 SUBMISSION to view query
OR
Pcess 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 5-50) to view information about
these submissions. To view information about the next submission, press .
PGM: TRQ050N1 TOXIC RELEASE INVENTORY SYSTEM 06/13/91
MAP: TRQ050MB SUBMISSION DISPLAY 14:55:56
REGION: 04 TRI FACILITY ID: 27239DPNTCRT1BO
NAME : DU PONT C&P HEALING SPRINGS
STREET: RT #1 BOX 102
CITY : DENTON
COUNTY : DAVIDSON
STATE : NC ZIP: 27239-
DOCUMENT CONTROL NUMBER : 13-89-03000421-8-NC
RPT6 FOR ENTIRE FACILITY ; A (AN ENTIRE COVERED FACILITY)
MAXIMUM AMOUNT CODE : 03 (1.000 9,999)
CAS NUMBER : 007664-41-7
CHEMICAL NAME : AMMONIA
CERTIFICATION NAME : C. A. CREMEANS
CERTIFICATION TITLE : PLANT MANAGER
CERTIFICATION OAtE SIGNED: 04/19/90
SUBM: 1 OF 3 TRITD: 27239DPNTCRT1BO / DCN: 13-89-03000421-8-NC
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11--PF12
CONT HELP MAIN PREV - NEXT RPTS
Figure 5-50
09/03/91 5 - 38 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
If is pressed, the second screen (Figure 5-51) for this submission will appear. The
number of screens depends on the amount of information for each submission. Continue to press
to view all data for the submission.
PGM: TRQ05ON1
MAP: TRQ050MC
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
039129697
NCD000475608
37057
+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-:PF4 PF5 PF6 PF7 PF8- PF9- PF10PF11PF12
CONT HELP MAIN PREV 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
-------
THIS 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: TRQ060P
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^-PFJ PF10PF1I^-PF12
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*' is used. Upper or lower case letters can be used. There are no other
optional fields available to narrow the search.
PGM: TRQ060P1 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ060M2 POTW / OFFSITE SEARCH BY FACILITY ID
REQUIRED
REPORTING YEAR > 1989
POTW / OFFSITE FACILITY ID..> RICHMOND*
Key selection criteria and press
06/13/91
14:56:40
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-53
09/03/91
5-41
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
The
701
number of submissions found that meet the search (Figure 5-54) will appear. The POTW
"fsite Facility Name selected for this search is also displayed.
PGM: TRQ06OP2
MAP: TRQ06OM6
TOXIC RELEASE INVENTORY SYSTEM 06/13/91
POTW / OFFSITE FACILITY SEARCH 14:57:49
73 POTW / OPFSITE RECORD (S) FOUND FOR NAME RICHMOND*
Press to view
or
Press appropriate PF Key
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
CONT HELP MAIN PREV RPTS
Figure 5-54
4) To view detailed information about the POTW / Offsite Facility submissions, press
. Two submissions (Figure 5-55) are displayed per screen.
PGM: 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 ID or the Facility Name
(or range using the wildcard, *). You can search on one specific chemical by
entering either the chemical/category/synonym name or CAS Number, or you may
view all the chemicals for a facility.
ACCESS: Select option 7 from the Online Queries menu. The Year-to-Year Release /
Transfer Comparison screen (Figure 5-56) will appear.
PGM: TR0.070P TOXIC RELEASE INVENTORY SYSTEM 03/27/91
MAP: TRQ07OM1 YEAR-TO-YEAR RELEASE / TRANSFER COMPARISON 10:54:34
REQUIRED
OPTIONAL
TRI FACILITY ID > 25143MNSNT1MONS
OR--
FACILITY NAME >
INCLUDE DELISTED CHEMICALS: Y
CAS NUMBER >
--OR--
CHEMICAL/CATEGORY NAME....>
Key selection criteria and press
(Y/N)
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-56
1) Type either the TRI FACILITY ID or the FACILITY NAME. One field is required.
In this example (Figure 5-56), TRI Facility ID '25143MNSNT1MONS' is used. Upper
or lower case letters can be used.
2) Type Y to include delisted chemicals in your search or N to exclude them.
3) To further limit your search, include a CAS NUMBER or a
CHEMICAL/SYNONYM/CATEGORY NAME. In this example, neither of these
optional fields have been entered. Press to begin your search.
09/03/91 5-44 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Year-to-Year Release / Transfer information (Figure 5-57) will appear for the TRI Facility ID
selected.
PGM: TRQ07OP
MAP: TRQ070M2
TOXIC RELEASE INVENTORY SYSTEM
YEAR-TO-YEAR RELEASE/TRANSFER COMPARISON
06/13/91
17:49:28
TRIFID: 25143MNSNT1MONS ADDRESS: 1 MONSANTO RD.
NAME: MONSANTO CO. NITRO 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
HATER
UNDERGROUND
LAND
REL TOTALS
POTW
OFF-SITE
TRANS TOTALS
507400
100500
57100
0
16350
681350
0
67000
67000
509600
118517
434350
0
16150
1078617
0
66800
66800
501700
196775
432250
0
1950
1132675
0
14000
14000
0
0
0
0
0
0
0
0
0
1991
0
0
0
0
0
0
0
0
0
0
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-57
4)
To end your search, press or .
The Table below shows PF Keys and corresponding functions for the Year-to-Year Release /
Transfer Comparison.
Year-to-Year Release / Transfer Comparison
Function/Data
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
HELP
MAIN
PREV
RPTS
PF Key
PF1/13
PF2/14
PF3/15
PF6/18
Table 5-11
09/03/91
5-45
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.8 Historical Facility Information Search
FUNCTION: Use the Historical Facility Information Search to display historical information
about a facility. Historical data includes Facility Name and Address, Parent
Company DUNS Number, and Parent Company Name. You can search using the
following identifying criteria:
TRI Facility ID
Historical Facility Name or range using wildcard, *
Historical City / County
Historical Region / State / ZIP Code
Historical Parent DUNS Number
Historical Parent Company Name or range using wildcard, *
Note that the Reporting Year is required. After a search of the database, a series of screens will
be presented that display current facility data on the left-hand side and historical facility data on
the right-hand side.
ACCESS: Select option 8 from the Online Queries menu. The Historical Facility
Information Search screen (Figure 5-58) will appear.
09/03/91 5 - 46 ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) To search the database by Historical Facility Name, type 2 from the Historical Facility
Information Search menu (Figure 5-58). Press .
PGM: TRQOBOP 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
2) Type a REPORTING YEAR. This is a required field. Reporting Year'1988'is used.
3) Type a HISTORICAL FACILITY NAME (or range using the wildcard, *). This is also
required. Press to begin the search. In this example (Figure 5-59), 'KEE*'
is used. Upper or lower case letters can be used. There are no other optional fields
available to narrow the search.
PGM: TRQ080N2
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 ID (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 RELEASE INVENTORY SYSTEM 06/14/91
MAP: TRS03OM1 HISTORY FACILITY NAME SELECTION SCREEN 13:19:39
NAME: KEE*
MARK FACILITY NAME
KEELER BRASS AUTOMOTIVE
KEELER BRASS AUTOMOTIVE
KEELER BRASS CO.
X KEENE CORP.
KEESHAN £ BOST CHEMICAL CO. INC.
TRI FACILITY ID
49502KLRBR236ST
49508KLRBR29293
49503KLRBR955GO
19701KNCRP1100G
77578KSHNB22102
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS -PAGE SELCT
4)
Figure 5-60
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: TRQ080M8
1 HISTORY RECORD (S)
TOXIC RELEASE INVENTORY SYSTEM
HISTORICAL FACILITY SEARCH
FOUND FOR FACILITY NAME KEENE CORP.
Press to view
or
Press appropriate PF Key
06/14/91
13:20:50
Enter-PFl PF2 -PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN PREV RPTS
Figure 5-61
09/03/91
5-48
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5) To view detailed information about the Historical Facility submissions, press .
Current facility information is displayed on the left and Historical information on the right
(Figure 5-62).
PGM: TRQ08ON9
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 10:
:FACILITY NAME: -KEENE CORP.
:ADDRESS:
BEAR
NEW CASTLE
BAIRNCO CORP.
018288621
REASON FOR CHANGE:
DE 19701 :CITY/ST/ZIP:
: COUNTY :
:PARENT NAME:
:PARENT DUNS:
1100 GOVERNOR LEA RD.
BEAR
NEW CASTLE
BAIRNCO CORP.
018288621
DE 19701
Press to continue
OF 1
Enter-PFl PF2 PF3 PF4- PF5 PF6-PF7- PF8 PF9 PF10--PF11--PF12
HELP MAIN PREV RPTS
Figure 5-62
6)
Press to view all available data.
The Table below shows PF Keys and corresponding functions for the Historical Facility Search.
Historical Facility Search
Function/Data
System HELP
Main Menu
Previous Screen
Batch report menu
Screen Label
HELP
MAIN
PREV
RPTS
PF Key
PF1/13
PF2/14
PF3/15
PF6/18
Table 5-12
09/03/91
5-49
ONLINE QUERIES
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
5.9 Chemical Table Search
FUNCTION: Use the Chemical Table Search to display information about Chemical, Synonym,
and Category names from the TRI Chemical Table. This search does not examine
actual submissions. By entering a name without the wildcard, *, you will search
for an exact match. By entering a beginning ponion of name with the wildcard,
*, you will search for chemicals wiu. .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
HAP: TRQ090M1
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 PF4H?F5 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 TOXIC RELEASE INVENTORY SYSTEM
MAP: TRQ090M2 CHEMICAL TABLE SEARCH
CHEMICAL / CATEGORY / SYNONYM
FORMALDEHYDE
FORMALDEHYDE SOLUTION
FORMALDEHYDE, GAS
FORMALIN
FORMALINE BLACK C
FORMALITH .'
FORMIC ACID. CHLORO-, ETHYL ESTER
FORMIC ALDEHYDE
FORMIC ANAMMONIDE
FORMIC BLACK C
FORMIC BLACK CH
FORMIC BLACK EA
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10-
HELP MAIN PREV RPTS -PAGE +PAGE
06/14/91
13:21:41
CAS NUMBER
sow sow swnejow me
000050-00-0
000050-00-0
. 000050-00-0
000050-00-0
001937-37-7
000050-00-0
000541-41-3
000050-00-0
000074-90-8
001937-37-7
001937-37-7
001937-37-7
-PF11 PF12
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 Offsite locations.
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 06/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 Future use
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 PF10--PF11 PF12
HELP MAIN PREV QUERY
Figure 6-1
09/03/91 6 - 3 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.1 Controlling Where and When Reports Print
FUNCTION: The TRIS user must decide where and when reports print when generating the
information. This is done by setting report printing parameters. The Batch Report
Profile screen controls the printing report parameters. Use it to control the
account, time, priority, output destination, and number of copies for the report
selected from the Report Menu. Before submitting a report to print the first time,
the user should contact their region's Account Manager regarding this information.
ACCESS: Select option 12 from the Batch Report menu. The Batch Report Profile screen
(Figure 6-2) will appear.
TOXIC RELEASE INVENTORY SYSTEM
TRR010M1 BATCH REPORT PROFILE 07/04/90
USER-ID: GJA ACCOUNT MO: TRISBHSP
BIN/BOX: D166 PRIORITY: 2
CPU-TIME: 05,00 REMOTE NO: N3
COPIES: 1
PRESS TO CONTINUE
Enter-PFl PF2 PF3 PF4 PF5 PP6 PF7-PF8PF9- PF10-- PF11PFli-
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 Profile Report screen will not be
displayed again, unless requested by the user.
09/03/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 estimated 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.
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 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'.
6) 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
WIC WIC
New York NY
Denver DV
Dallas DA
Seattle SE
Atlanta AT
Kansas City KG
Philadelphia PH
Boston BN
Chicago CH
09/03/91 6^5 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.2 Recording the Job Number
FUNCTION: After the user types the selection criteria for a report (discussed in detail in the
following sections) and presses , the report is submitted to the ES/9000
and assigned a job number. It is recommended that users record their job numbers
so that all reports can be accounted for once they are retrieved. The job number
is displayed in a window. An example appears in figure 6-3.
PGM: TRROOON1 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM1 GEOGRAPHIC LOCATION / CHEMICAL PROFILE SELECTION 12:38:00
REQUIRED: REPORTING YEAR > 1989
GEOGRAPHIC LOCATION SELECTION:
REGION....> 03 STATE > VA
CITY > RICHMOND
COUNTY >
ZIP CODE..> SIC CODE..>
CHEMICAL PROFILE SELECTION:
I I
I JOB JOB12345 Submitted Successfully I
AVAILABLE | Press to Return to Previous Screen f
1) FACILIT I |T FORMAT:
3) RELEASES/TRANSFERS 4- ACTIVITY/USE PER FACILITY
Enter-PFl PF2 PF3 PF4-PF5PF6 PF7 PF8-PP9 PF10--PF11PF12
HELP MAIN PREV PROFL QUERY
Figure 6-3
1) After recording the job number, press to return to the previous screen.
09^3/91 6 - 6 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.3 Geographic / Chemical Profile Report
FUNCTION: This report lists all facilities within a geographic location and/or submitting a
specific chemical. Submissions are selected from the Geographic Location /
Chemical Profile Report Selection screen by supplying geographic selection
criteria and/or CAS Number or Chemical/Synonym/Category Name. This report
is sorted on facility name. See Appendix B for an example of this report. A
specific report format must be chosen from the following three options:
1) Facility Identification Information: Listed for each facility is
Name, Address, EPA ID, TRI Facility ID, and the primary SIC
Code with a total of facilities selected.
2) Releases / Transfers Per Facility: Listed for each facility is the
amount of releases to air, water and land, transfers to off-
site/POTW locations, and the total amount of releases and transfers,
besides the above information. This report will also show the
aggregate release and transfers for all facilities selected.
3) Releases / Transfers and Activity / Use Per Facility: Listed for
each facility are the activities and uses of the chemical in addition
to the above information.
ACCESS: Select option 1 from the Batch Report menu. The Geographic Location /
Chemical Profile Selection screen (Figure 6-4) will appear.
09/03/91 6 - 7 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
1) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
2) Type either GEOGRAPHIC LOCATION or CHEMICAL PROFILE information. For
Geographic Location, the following optional fields may be entered to narrow the search:
REGION, STATE, CITY, COUNTY, ZIP CODE, and SIC CODE. In this example,
Region '03,' State 'Va,' and City 'Richmond' are used. Upper or lower case letters can
be used. For Chemical Profile information, the following fields may be entered to narrow
the search: either a CAS NUMBER or CHEMICAL/SYNONYM/CATEGORY NAME.
In this example, Chemical Profile information was not used. You must enter at least one
of these fields.
3) Type the REPORT FORMAT. This is a required field. In this example, '3' was used.
Press to submit the report. Your job is submitted and a message appears at
the bottom of the screen advising you of the job number assigned.
PGM: TRROOON1 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM1 GEOGRAPHIC LOCATION / CHEMICAL PROFILE SELECTION 12:38:00
REQUIRED: REPORTING YEAR > 1989
GEOGRAPHIC LOCATION SELECTION:
REGION > 03 STATE > VA
CITY > RICHMOND
COUNTY.... >
ZIP CODE.-> ____ SIC CODE..>
CHEMICAL PROFILE SELECTION:
CAS NUMBER > OR
CHEMICAL NAME...> --
AVAILABLE REPORT FORMATS:
1} FACILITY IDENTIFICATION INFORMATION SELECT REPORT FORMAT:
2) RELEASES/TRANSFERS PER FACILITY (1,2,3) > 3
3) RELEASES/TRANSFERS + ACTIVITY/USE PER FACILITY
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10--PF11PF12
HELP MAIN PREV PROFL QUERY
Figure 6-4
4) Record the JOB NUMBER and press to return to the Geographic Location
/ Chemical Profile Selection screen.
09/03/91 6~HJBATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.4 POTW / Off-Site Location Report
FUNCTION: This report lists all facilities transferring chemicals to a specified POTW or Off-
Site location. Submissions are selected from the POTW / Off-Site Location
Report Selection screen by supplying a POTW / Off-Site ID or POTW / Off-Site
name. The selection can be further limited by supplying a CAS number or
Chemical/Synonym/Category name. This report is sorted by POTW / Off-Site
name and CAS Number. See Appendix B for an example of this report.
ACCESS: Select option 2 from the Batch Report menu. The POTW/Off-Site Location
Selection screen (Figure 6-5) will appear.
PGM: TRROOON2 TOXIC RELEASE INVENTORY SYSTEM 06/18/91
MAP: TRROOOM2 POTW/OFF-SITE LOCATION REPORT SELECTION 12:39:21
REPORTING YEAR > 1989
POTW/OFFSITE ID >
--OR--
POTW/OFFSITE NAME > BFI WASTE SYSTEMS
SEARCH CAN BE LIMITED BY SUPPLYING CHEMICAL INFORMATION:
CAS NUMBER > OR
CHEMICAL NAME.?
Key Selection Criteria and Press to Submit Report
Enter-PFlPF2-PF3 PF<4PF5PF6 PF7PF8 PF9 PF10--PF11PF12-
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^9BATCH 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 reared 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: TRROOON3 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--
DONS 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 PF10-- PFilPF12
HELP MAIN PREV PROFL QUERY
Figure 6-6
3) Record the JOB NUMBER and press to return to the Facility Profile Report
Selection screen.
09/03/91 6-12 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
6.6 Form R Facsimile Report
FUNCTION: This report lists all information for a selected facility or submission on the
database. This report displays the submitted data in the same order as they were
submitted on Form R. Submissions must be selected from the Form R Facsimile
Report Selection screen by one of the following:
TRI Facility ID
EPA ID Number
Parent DUNS Number
DUNS Number
Facility Name or range using the wildcard, *
Document Control Number
The search can be limited by supplying a CAS number or Chemical/Synonym/Category name.
All versions of the resulting report are identical in format, except the first page, listing the
selection criteria. See Appendix B for an example of this report.
ACCESS: Select option 4 from the Batch Report menu. The Form R Facsimile Report
screen (Figure 6-7) will appear.
1) Type a REPORTING YEAR. This is a required field. In this example, '1989' is used.
2) Select the FACILITY based on the following options: TRI FACILITY ID, DUNS
NUMBER, PARENT DUNS NUMBER, EPA ID NUMBER, DOCUMENT
CONTROL NUMBER, or FACILITY NAME (or range using the wildcard, *). This
09/03/91 6-13 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
is also required, you must enter at least one field. In this example, the TRI Facility ID
'27239DPNTCRT1BO' is used. Upper or lower case letters can be used. If a facility
name range is entered, the Facility Name Selection screen is displayed. Select the facility
of choice by placing an X before the facility name and pressing . Press
to submit the report. Your job is submitted and a message appears at the
bottom of the screen advising you of the job number assigned.
PGM: TRROOON4 TOXIC RELEASE 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 PF10PF11PF12-
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.
PGH: 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-PFl PF2 PE3 PF4-PF5PF6 PF7 PF8 PF9-PF10-- PF11PF12
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: 1989
PART 1
PART 2
PART 3
Note
: ENTER CAS NUMBER.
CHEMICAL/CATEGORY
: ENTER REGION. > 03
CITY...>
COUNTY. >
ZIP >
CONTROL TOTALS ONLY: N (Y/N)
CLEAN AIR ACT CHEMICALS ONLY: N (Y/N)
OR
NAME > toluene
(01 THRU 10) STATE.. > va
(MUST ENTER A STATE ALSO)
: ENTER SIC CODE (SOURCE CATEGORY )..>
: 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 PF10 PF11-- PF12
HELP MAIN PREV QUERY
Figure 6-9
2) To avoid reporting Control Totals only, press for 'No.'
3) To avoid reporting Clean Air Act chemicals only, press for 'No.'
09/03/91 6-17 BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
4) Type CHEMICAL, GEOGRAPHIC, or SIC CODE selection criteria from 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
2 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--PF12
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 ID
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
> 03
> RICHMOND
GEOGRAPHIC LOCATION
STATE > VA ZIP CODE >
COUNTY >
TRI FACILITY
FACILITY NAME
INCLUDE
BY FACILITY
ID > OR
>
DELISTED 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-
HELP MAIN PREV
PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
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
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
-------
THIS 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
MAP: TRF01OM1 SELECT GEOGRAPHIC /CHEMICAL INFORMATION
REQUIRED YEAR:
OPTIONAL REGION:
STATE:
CITY:
COUNTY:
ZIP CODE:
CAS NUMBER:
OR
CHEMICAL/CATEGORY :
Type Geographic and/or Chemical information and press
03/31/91
09:39:19
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
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 ED and Document Control
Number (DCN) are automatically included. Type X in the space to the left of the data
elements to be selected. Press to advance the cursor through the data fields.
Press when selection is complete.
PGM: TRF020P
HAP: 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
HASTE 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 ID(1-2)
EPA IDU)
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:
MAP:
TRF020P
TRF02OM1
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 ~ PARENT COMPANY NAME
~ FACILITY ZIP ~ PARENT DUNS NUMBER
FACILITY REPORT CODE ~ STATE COUNTY FIPS CODE
~ FACILITY LATITUDE ~ WASTE MIN CODE
~ FACILITY LONGITUDE ~ WASTE MIN CURRENT YEAR
_ CENTROID LATITUDE ~ WASTE MIN PRIOR YEAR
_ CENTROID LONGITUDE WASTE MIN PCT CHANGE
MAXIMUM A ************T****************************~****
~ 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
WATER BODIES
UNDERGROUND INJECTION
LAND ON-SITE
POTW
OFF-SITE
UIC ID(1-2)
EPA ID(l)
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 follpwing 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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8 TUTORIAL
09/03/91 "8-1 'TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 8 - 2 TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8 TUTORIAL
FUNCTION: The TRI menu driven system features an online Tutorial. The Tutorial is designed
to help the novice user who is unable to attend the regularly scheduled training
course. It also may assist the more experienced user as new system enhancements
are added. The Tutorial covers basic skills necessary to retrieve data from the
system using Online Queries, Batch Reports, and Data Offload. Much of the
Tutorial is interactive and requires the user to provide search criteria and use the
correct PF keys. In addition, the Tutorial explains terminology and concepts
unique to TRIS.
ACCESS: Select option 4 from the Data Retrieval menu and press . The Tutorial
menu (Figure 8-1) will appear.
PGM: TRUOOOP TOXIC RELEASE INVENTORY SYSTEM 03/31/91
MAP: TRUOOOMl TUTORIAL MENU 14:32:16
1 GENERAL INFORMATION
2 USING THE SYSTEM
3 ONLINE QUERIES
4 BATCH REPORTS
5 DATA OFFLOAD
£ USER SUPPORT
Key selection and press «««> _
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PFIOPF11PF12-
HELP MAIN FREV
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 iTl TUTORIAL
-------
THIS 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: TRU01OP
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 PF KEYS
4 HELP AND POP-UP WINDOWS
Key selection and press
Enter-PF1 PF2 PF3 PF4PF5 PF6 PF7 PF8 PF9-PF1QPF11PF12-
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: TRU03OP 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 are used to search for specific information about:
a facility, a submission, geographic location, or a particular
chemical.
There are various queries used to retrieve data. From the next
screen you may select the Online Query you choose to view.
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: TRU030P
MAP: TRU03OH2
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
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
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
REQUH
OPTK
RED REPORTING YEAR >
FACILITY NAME >
)NAL REGION >
fmmm*mw**m-{
This is the Facility Name Search screen, this query is used to
conduct a search using the 2 required fields, reporting year and
facility name. REQUIRED means you must supply data in a field.
The 5 optional fields (hidden by this window) are used as a means
of narrowing your search. To view the FULL screen press .
Fields contain 'POP-UP' windows (Tutorial 2.3), which may be used
whenever you are unsure of what data element to enter in a field.
'
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF1I 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: TR0050P 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 user to transfer TRIS data
from the mainframe ADABAS files to a mainframe sequential file.
The sequential file can then be used to offload the data to a
Personal Computer (PC) or a Local Area Network (LAN) , or used by
other mainframe software to produce a report.
In this tutorial we will introduce you to the various screens and
fields you will encounter in using the Data Offload function.
j
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7 PF8 PF9 PF10 PF11 PF12
HELP MAIN TUTOR -PAGE +PAGE
Figure 8-7
1) The Tutorial screen provides a brief explanation of the Data Offload function. The user
is prompted to press to continue to the next screen and type specific data in
required fields. This is an interactive tutorial.
09/03/91
8-10
TUTORIAL
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
8.6 User Support
FUNCTION: This option provides information on how to use all four user support online
functions.
ACCESS: Select 6 from the Tutorial menu and press . The User Support Tutorial
introduction screen (Figure 8-8) will appear. TRIS User Support is briefly
described.
PGM: TRU060P
MAP: TRU060M1
TOXIC RELEASE INVENTORY SYSTEM
USER SUPPORT TUTORIAL
06/07/91
16:41:10
You have chosen to review the User Support Tutorial.
TRIS User Support is a medium that helps all TRIS
users in accomplishing tasks requiring the use of the
TRIS Database.
Enter-PFl 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) 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 TOXIC RELEASE INVENTORY SYSTEM 06/11/91
MAP: TRU060M2 USER SUPPORT MENU 14:03:08
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
4 SET PROGRAM FUNCTION (PF) KEYS
J. ^__ ^^f.rf^.rr^,^.^ -M--r»n--nf.--n *»«»» r--y-f- -r- f,tr-M of la -i-
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 =>
f
Enter-PFl PF2PF3 PF4 PFS PF6PF7 PF8 PF9 PF10--PF11--PF12-
HELP MAIN PREV TUTOR
Figure 8-9
3) Additional HELP information is displayed on a mock Questions and Suggestions screen
(Figure 8-10). Press to continue. The tutorial gives the user prompts to type
specific information to simulate submitting an online suggestion.
PGM: TRU060P TOXIC RELEASE INVENTORY SYSTEM 06/11/91
MAP: TRU 060MB QUESTIONS AND SUGGESTIONS 14:03:37
1
SUBJEC
MESSAt
PO: TRIS User Support FROM: LOUISE HYDE
:T:
3E:
kn-nn-Hn«» -*m J
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.
£n'ter-PFl PF2 PF3 PF4 PFS PF6 PF7 PF8 PFS 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
1 QUESTIONS AND SUGGESTIONS
2 REQUEST DOCUMENTATION
3 EXTRACT FILE INFORMATION
03/31/91
10:48:27
4 SET PROGRAM FUNCTION (PF) KEYS
Key
Enter-PFl PF2 PF3
HELP MAIN PREV
selection and press »»««> _
-PF4 PF5 PF6 PF7 PF8 PF9
PF10 PF11 PF0.2
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
MAP: TRP01OM1 QUESTIONS AND SUGGESTIONS 10:38:17
TO: TRIS User SupportFROM:LOUISE HYDE
SUBJECT:
MESSAGE:
PHONE: {"
Enter-PFl PF2 PF3 PF4-PF5---PF6-PF7-PF8 PF9 PF10PFllPF12
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 gT4 USER SUPPORT
-------
THIS 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: TRP02OP TOXIC RELEASE INVENTORY SYSTEM 03/31/91
MAP: TRP020M1 REQUEST DOCUMENTATION 10:48:40
TO: TRIS User SupportFROM:LOUISE HYDE
Information Retrieval Users Guide
~ Instructions and information for the menu-driven system
_ Users Quick Reference Card
~ Logon/logoff instructions, acronyms, SDSF, JCL
_ AOABAS File Descriptions
~ Revised April 1991 after major system enhancements
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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
9.3 Extract File Information
FUNCTION: This option provides current information concerning permanent TRIS extract files
for each reporting year.
ACCESS: Select option 3 from the User Support menu. The Extract File Information screen
(Figure 9-4) will appear.
PGM: TRP030P TOXIC RELEASE INVENTORY SYSTEM
MAP: TRP030M1 EXTRACT FILE INFORMATION
FILE
TXLTRID.PROD0419. CHEMICAL. FILE87
TXLTRID.PROD0419. FACILITY. FILE87
TXLTRID.PROD0419.0FFSITE.FILE87
TXLTRID.PROD0419.POTW.FILE87
TXLTRID.PROD0419. RELEASE. FILE87
TXLTRID.PROD0419. TREAT. FILE87
Press to view additional
Enter-PFl PF2 PF3 PF4 PF5 PF6 PF7
CONT HELP MAIN PREV
YEAR
1987
1987
1987
1987
1987
1987
reporting
06/03/91
10:4Q;Q8
LAST REVISION
4/19/91
4/19/91
4/19/91
4/19/91
4/19/91
4/19/91
years
-PF8 PF9 PF10 PF11 PF12
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 PFS 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 g. 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
ADABAS is the database management system utilized by TRIS on NCC's IBM ES/9000.
Batch
Batch is a term carried over from the early days of data processing. Large computer jobs were
batched, or grouped together, for overnight processing. It is the opposite of online, or real-time,
processing. It applies to functions that potentially take a large amount of computer resources;
therefore, these functions are not suitable as online queries. Today these types of jobs do run
during business hours; however, they are run in "background" mode so as not to interfere with
online response time.
CAS
Chemical Abstract Services assigns CAS registry numbers and names to chemicals.
CICS
Customer Information Communications System. One of two means of interfacing with the IBM
ES/9000. SeeTSO.
Data Element
A single piece of information. For example, the state where a facility is located (i.e., VA) is a
single element of information.
Database
A collection of data or information organized for rapid research and retrieval by a computer.
Conceptually, it is organized similar to a filing cabinet. Pieces of information (elements), are put
together in a file (Form R submission), which are put together in a drawer (database).
DCN
Document Control Number. EPA has designated a number beginning with the type of
submission, reporting year, a unique number, and then a two-letter state code, to be a Document
Control Number. This number is used to track a single submission through the data entry and
information acceptance process.
09/03/91 A - 3 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
De Minimls
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
-------
THIS 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 in,
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 in.
SIC
Standard Industrial Classification. SIC Codes classify business establishments by specific
activities that are performed at a single physical location. The first two digits of a four-digit SIC
code define a major business sector and the last two digits denote a facility's specialty within the
major sector.
Submission
A Form R from a single facility containing release and transfer information for a single chemical
that is entered into the Toxic Chemical Release Inventory database.
09/03/91 A - 8 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Threshold
Section 313 reporting is required if threshold quantities are exceeded. The thresholds vary
depending upon the year for which the report is submitted and separate thresholds apply to the
amount of the chemical that is manufactured, processed, or otherwise used. A facility must
report for any listed chemical that is manufactured or processed over the course of the year in
excess of the following threshold:
For calendar year 1987: 75,000 pounds
For calendar year 1988: 50,000 pounds
For calendar year 1989 and subsequent years: 25,000 pounds
A facility must report if the quantity of a listed chemical that is otherwise used is 10,000 pounds
during the course of a calendar year.
Trade Secret
As prescribed in 40 CFR Part 350, published July 29, 1988 in the Federal Register (53 FR
28772), a facility can claim the CAS registry number and chemical name as trade secret. Two
Form Rs must be submitted for a chemical whose identity is claimed as a trade secret, one with
the a generic chemical name, and one that identifies the chemical. Only the information from
the generic one will be available to the public. A facility must have approval from EPA to claim
a toxic chemical as a trade secret.
TRIS
Toxic Chemical Release Inventory System (or TRI System). It is the computer system designed
by EPA to track the annual estimated release of toxic chemicals into the environment. TRIS is
a management tool used for collection and organization of toxic chemical release data received
from industries regulated under SARA.
TRISH
The NATURAL application library where end-users can perform their own programming against
the TRIS ADABAS files.
TRISONLN
The NATURAL application library where the online menu-driven system resides.
09/03/91 A - 9 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRI Data
All the pieces of information reported to EPA on Form R is sometimes referred to as TRI data
or Toxic Release Inventory Data.
TRI System
See TRIS
TRI Facility ID
EPA has designated a Facility ID (consisting of letters and numbers) to identify a Facility. It is
analogous to a social security number. The TRI Facility ID makes it possible to track
submissions from a facility across all reporting years.
TSO
Time Sharing Option. One of two means of interfacing with the IBM ES/9000, (see CICS).
UIC
Underground Injection Well Code. Twelve-digit number that permits a facility to inject toxic
chemicals into Class 1 deep wells. Numbers are assigned by EPA or by the State under the
authority of the Safe Drinking Water Act.
09/03/91 A-10 GLOSSARY
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX B
SAMPLE BATCH REPORTS
09/03/91 B - 1 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 2 SAMPLE BATCH REPORTS
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
FORM R FACSIMILE
09/03/91 B - 3 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/81 -_ .. .
B 4 SAMPLE BATCH REPORTS
-------
TRR04BF1 PAGE 1 U.S. ENVIRONMENTAL PROTFCT ON AGENCY DCN : 13-89-03000102-4-D:
§ 06X13X91 TOXIC CHEMICAL RELEASE INVENTORY REPO TING FORM FACSIMILE TRIFID: 19809DPNTD104HA
p PART I. FACILITY IDCNTIFICATIO'. INFORMATION
1.1 ARE fOU CLAIMING IDENTITY ON PAGE 3 TRADE SECRET? 1.2 IF ES IN 1.1, IS THIS CO°Y: 1.3 REPORTING YEAR
1. < > YES < X > NO < > SANITIZED < U'lSdNITIZLD 1989
2. CERTIFICATION NAME
JOHN S. KLOSS
CFRTIFICATION TITLE DATE SIGNED
PLANT MANAGER 06X10X90
3. FACILITY IDENTIFICATION
3.1 FACILITY OR ESTABLISHMENT NAME
OU PONT EDGE MOOR 3)
STREET ADDRESS JjJ
104 HAY RD.
CITY COUNTY
WILMINGTON NEH CASTLE
STATE ZIP CODE
OE 19009
3.2 THIS REPORT CONTAINS INFORMATION COS: A. < X > ENTIRE FACILITY B. < > PA?T OF A FACILITY pr
3.3 TECHNICAL CONTACT TELI PHONE NUtll r.H y
JOHN C CHANEY 302-761-2290
Q, 3.4 PUBLIC CONTACT TELEPHONE NUHI FR fp
JOHN C. CHANLY 302-761-2298 H
3.5 SIC CODE
A. 2816
3.6 LATITUDE: 394449 LONGITUDE: 752530 C
(A
3.7 DUN AND BRADSTREET NUMBERS -Jj
A. 154407845 (ft
O
3.8 EPA IDENTIFICATION NUMBERS (RCRA I.D. NO.)
A. DED0000002B4
CO 3.9 NPDES PERMIT NUMBERS
£ A. DE0000051 B. DE0050644
TJ
m RECEIVING STREAMS OR HATER BODIES
A. DELAIIARE RIVER
3.10 B.
rt o.
3.11 UNDERGROUND INJECTION HELL CODE (UIC) IDENTIFICATION NUMBERS / NA
m
4. PARENT COMPANY INFORMATION
4.1 NAME OF PARENT COMPANY: OUPONT
4.2 PARENT COMPANY'S DUN AND BRADSTREET NUMBER: 001315704
-------
TRR04BF2
06/15/91
PAGE 2
00
O>
CD
3J
m
TJ
O
1. PUBLICLY OWNED TREATMENT WORKS (POTHS)
1.1 POTM NAME
NA
STREET ADDRESS
T R I S FACSIMILE FORM R
PART II. OFF-SITE LOCATIONS TO MUCH TOXIC
CHEMICALS ARE TRANSFERRED IN HASTES
1.2 POTM NAME
STREET ADDRESS
DCN : 13-69-03000362-4-DE
TRIFID: 19809DPNTD104HA
CITY
STATE
COUNTY
ZIP CODE
CITY
STATE
COUNTY
ZIP CODE
>. OTHER OFF-SITE LOCATIONS
M OFF-SITE LOCATION NAME
DU PONT CHERRY ISLAND
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
NA
STREET ADDRESS
HAY ROAD
CITY COUNTY
EOGEtlOOR NEM CASTLE
STATE ZIP
OE 19809
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< X > YES < > NO
OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< > YES < > NO
2.5 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY?
< > YES < > NO
2.2 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL CF REPORTING FACILITY ?
< > YES < > NO
2.4 OFF-SITE LOCATION NAME
EPA IDENTIFICATION NUMBER (RCRA ID. NO.)
STREET ADDRESS
CITY COUNTY
STATE ZIP
IS LOCATION UNDER CONTROL OF REPORTING FACILITY ?
< > YES < > NO
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
CO
3)
m
3
m
-------
0
£5
§
^
CD
^1
CO
z
TO
fi
CD
>
o
33
m
1
TRR04BF3 PAGE 3 T R I S FACSIMILE FORM R
06/13/91 PART III. CHEMICAL-SPECIFIC INFORMATION
1 . CHEMICAL IDENTITY
1.1 (RESERVED)
1.2 CAS NUMBER
000463-56- 1
1.3 CHEMICAL OR CHEMICAL CATEGORY NAME
CARBONYL SULFIDE
1.4 GENERIC CHEMICAL NAME
I . MIXTURE COMPONENT IDENTITY
NA
2. ACTIVITIES AND USES OF THE CHEMICAL AT THE FACILITY
MANUFACTURE THE A. < X > PRODUCE C. < > FOR ON-SITE D. <
i.l CHEMICAL: USE/PROCESSING
B. < > IMPORT E. < X > AS A BYPRODUCT F. <
3.2 PROCESS THE A. < > AS A REACTANT B. < > AS A FORMULATION C. <
CHEMICAL: COMPONENT
D. < > REPACKAGING ONLY
3.3 OTHERWISE USE A. < > AS A CHEMICAL B. < > MANUFACTURING C. <
THE CHEMICAL: PROCESSING AID AID
4. MAXIMUM AMOUNT OF THE CHEMICAL ON-SITE AT ANY TIME DURING THE CALENDAR YEAR
01
5. RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE A.I REPORTING RANGES A. 2
0 1-499 500-999 ESTIMATE
5.1 FUGITIVE OR NON-POINT AIR EMISSIONS 5.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
FARMING
5.5.3 SURFACE IMPOUNDMENT 5.5.3A NA
5.5.4 OTHER DISPOSAL 5.5.4A NA
DCN : 13-69-03000382-4-DE
TRIFID: 19809DPNTD104HA
> FOR SALE/
DISTRIBUTION
> AS AN IMPURITY
> AS AN ARTICLE
COMPONENT
> ANCILLARY OR OTHER USE
BASIS OF
ESTIMATE
5. IB NA
5.2B M
C.X STORMMATER
5. 3. IB 5. 3. 1C
5.3.2B 5.3.2C
5.3.3B 5.3.3C
5.4B NA
5. 5. IB NA
5.5.2B NA
5.5.3B NA
5.5.4B NA
53
CO
z
Tl
o
33
>
0
7L
33
H
33
m
<
r
c
CO
m
5
O
c
o
m
-------
£
1
2
CD
09
CO
TJ
m
OD
H
S
31
m
TJ
o
JO
CO
TRR04BF4 PAGE 4 T R I S FACSIMILE FORM R
06/13/91 PART III. CHEMICAL-SPECIFIC INFORMATION
TRANSFERS OF THE CHEMICAL IN HASTE TO OFF-SITE LOCATIONS
A.I REPORTING RANGES A. 2 ESTIMATE
0 1-499 500-999
6.1.1 DISCHARGE TO POTH 1.1 6.1.
6.1.2 DISCHARGE TO POTH 1.2 6.1.
6.2.1 OTHER OFF-SITE 2.1 NA 6.2.
6.2.2 OTHER OFF-SITE 2.2 6.2.
6.2.3 OTHER OFF-SITE 2.3 6.2.
6.2.4 OTHER OFF-SITE 2.4 6.2.
6.2.5 OTHER OFF-SITE 2.5 6.2.
6.2.6 OTHER OFF-SITE 2.6 6.2.
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.10 7
7.2A 7.2B 7.2C 7.20 7
7.3A 7.3B 7.3C 7.30 7
7.4A 7.4B 7.4C 7. 40 7
7.5A 7. SB 7.5C 7.50 7
7.6A 7.6B 7.6C 7.6D 7
7.7A 7.7B 7.7C 7.70 7
7.6A 7.6B 7.6C 7.60 7
7.9A 7.9B 7.9C 7. 90 7
7.10A 7.10B 7. IOC 7.100 7
1. 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 I OR PCT CHANGE
1
M4 660000 640000 1 -19.00 1.1
1
B. BASIS OF
ESTIMATE
IB
2B
IB
2B
3B
4B
SB
6B
I. TREATMENT
ESTIMATE
.IE 0.00
.2E 0.00
.3E 0.00
.4E 0.00
.5E 0.00
.6E 0.00
.7E 0.00
.6E 0.00
.9E 0.00
. 10E 0.00
D. RE
DCN : 13-89-03000382-4-DE
TRIFID: 198090PNTD104HA
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. BASFD 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
ASON FOR ACTION
R4
5jj
CO
z
3
3)
1
m
H
JO
m
>
c
CO
m
3)
CO
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
-------
c
W TRR10BP
<£ PAGE : 1
TRI FACILITY ID:
FACILITY NAME :
ADDRESS :
CHEMICAL:
OF SUBMISSIONS
RELEASES
FUGITIVE AIR
STACK AIR
CD
1
HATER
UNDERGROUND
LAND
TOTAL RELEASES
TRANSFERS
POTH
CO
TJ OFF SITE
CO TOTAL TRANSFER
0
3)
m
3
3
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
YEAR-TO-YEAR RELFASE/TRANSFER COMPARISON REPORT
08/13/91
09:47:05
19809DPNTD104HA »« NOTE: HISTORY RECORDS EXIST - THE NAME/ADDRESS INFO MAY BE DIFFERANT FOR 1 PEVIOUS YEAR
OU PONT EDGE MOOR
104 HAY RD.
WILMINGTON DE 19809
ALL CHEMICALS EXCLUDING OELISTED CHEMICALS
X OF X OF
1987 1988 CHANGE 1989 CHANGE
8 7-13 6 -15
101774 22174 -79 38624 «74
935231 957010 «2 786 J40 -18
1071025 19770 -99 270 -99
00 0
0 39 48 «23
2108030 998993 -53 825182 -18
00 0
553000 1250000 *126 0
553000 1250000 »126 0
PERCENT CHANGE HILL BE CALCULATED (INLY IF BOTH APPLICABLE REPORTING YEARS
X OF X OF
1990 CHANGE 1991 CHANGE
. H
33
o o »
I
(kj
0 0 >
5
0 0 Z
JJ
m
0 0 H
m
0 0 >
c
CO
33
CO
0 ° 0
C
o
m
0 0
0 0
0 0
ARE GREATER THAN ZERO.
-------
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 SYSTFM
06/13/91
21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 196090PNTD104HA
REGION
01
TRI-FACILITY-ID
19B09DPNTD1Q4HA
EPA ID
OEOOOO&00284
NAME :
ADORESS :
CITY/STATE/ZIP:
DU PONT EOGE KOOR
104 HAY RO.
WILMINGTON. DE 19609
CD
I
tn
OOCUHENT CONTROL NUMBER
REPWTINS YEAR
HPTG 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 :
I3-69-03DOQ382-4-DE
1909
A (AN ENTIRE COVERED FACILITY)
01 (099)
000463-58-1
CARBONYL SULFIDE
NA
JOHN S. KLOSS
PLANT MANAGER
06/10/90
P tPHOTO COPY)
NEW CASTLE
154407645
OEDOOOa00204
1000)
394630
-75294Z
394449
-752530
DUPONT
001315704
JOHN C. CHANEY
(302) 761-2298
JOHN C. CHANEY
(3021 761-229S
NA
D1353
HASTE MINIMIZATION
HASTE MINIMUM CODE :
WASTE MINIMUM CURRENT YEAR QTY:
HASTE MINIMUM CRT YEAR QTY K/A:
HASTE MINIMUM PRIOR YEAR QTY :
HASTE MINIMUM PRIOR YR QTY K/A:
HASTE MINIMUM PERCENT CHANGE :
HASTE MINIMUM INDEX :
HASTE MINIMUM ACTION CODE :
N4 (PROCESS PROCEDURE MODIFICATIONS)
660,000
040,000
-19.00
1.1
R4 (SELF-INITIATED REVIEW)
2
CO
o
OJ
3J
m
2
m
i
en
m
20
Cfl
Ci
0
m
EPA ID NUKBER(S)
DUNS NUMBER!3t
SIC-CODE(S)
: DED000800ea4
; 154407645
: 2616
NPOES PERMIT NUMBER)S): DE0000051 DE0050644
-------
TRR03BP UNITED STATES ENVIRONMENTAL PROTECTZON AGENCY 06/13/91
PAGE: 2 TOXIC RELEASE INVENTORY SYSTEM 21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19809DPNTD10WA
REGION TRI-FACILITY-IO EPA ID NAME : DU PONT EDGE MOOR
03 19B09DPNTD104HA DED000800264 ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON, DE 19009
»» TYPES OF ACTIVITY/USES »»
MANUFACTURE : PRODUCE BYPRODUCT
CO
CO
f
3>
-------
TRR03BP
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
06/13/91
21:OZ:25
.-'AGILITY PROFILE REPORT FOR FACILITY ID: 198090PNTDKX.HA
KEGION
03
TRI-FACILITY-ID
19B09DPNTD104HA
EPA ID
DED0008002B4
NAME : OU PONT EDGE MOOR
ADDRESS : 104 HAY RD.
CITY/STATE/ZIP: WILMINGTON. OE 19809
< FUGITIVE OR NON-POINT AIR EMISSIONS *
IMPORTING RANGE :
ESTIMATE : 0
ESTIMATE N/A : Y
DASIS OF ESTIMATE : NA
'» STACK OR POINT AIR EMISSIONS *
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
DASIS OF ESTIMATE : M
660.000
(BASED ON MONITORING DATA OR MEASUREMENTS I
3J
(0
1
3)
*» DISCHARGE TO HATER
STREAM CODE
STREAM NAME
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
BASIS OF ESTIMATE
7. FROM STORMHATER
X FROM STORMMATER N/A
: A
: DELAWARE RIVER
: Y
0.00
v* UNDERGROUND INJECTION MI
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
3J
m
m
I
CO
m
o
o
m
»« RELEASE TO LAND »»
I AND DISPOSAL CODE : D02
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
(ON-SITE LANDFILL)
0
-------
II
TRR03BP
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
06/13/91
21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19609DPNTD104HA
m
s
3)
REGION
03
TRI-FACILITY-ID
19609DPNTD104HA
EPA ID
DE00008002A4
NAME : DU PONT EDGE MOOR
ADDRESS : 104 HAY RO.
CITY/STATE/ZIP: WILMINGTON, DE 19809
« RELEASE TO LAND »
LAND DISPOSAL CODE : D03
REPORTING RANGE :
ESTIMATE :
ESTIMATE N/A : Y
BASIS OF ESTIMATE : NA
(LAND TREATMENT/APPLICATION FARMING)
g
CO
CD
00
CO
CD
«* 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 POTH
FACILITY NAME
STREET ADDRESS
CITY
COUNTY
STATE
ZIP CODE
REPORTING RANGE
ESTIMATE
ESTIMATE N/A
BASIS OF ESTIMATE
DOS
: Y
: NA
(SURFACE IMPOUNDMENT)
0
: 099 (OTHER DISPOSAL)
: 0
: Y
: NA
NA
m
m
CO
m
CO
O
6
m
-------
TRR03BP
PAGE:
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
06/13/91
21:02:25
FACILITY PROFILE REPORT FOR FACILITY ID: 19B09DPNTD104HA
CD
(0
REGION TRI-FACILITY-ID EPA ID NAME : DU PONT EDGE MOOR
03 19809DPNTD104HA DE0000800284 ADDRESS : 104 HAY RO.
CITY/STATE/ZIP: HILMINGTON, DE 19009
LOCATION »
198090PNTCHAYRO
1
NA
DU PONT CHERRY ISLAND
HAY ROAD
EOGEriOOR
NEW CASTLE
DE
19609
Y (YES. LOCATION IS UNDER CONTROL OF REPORTING FACILITY OR PARENT COMPANY)
«* OTHER OFF-SITE
OFF-SITE ID
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 »»
GENERAL MASTESTREAM CODE : A (GASEOUS (INCLUDING GASES, VAPORS, AIRBORNE PARTICULATES))
TREATMENT METHOD CODE : A03 (SCRUBBER)
RANGE OF INFLUENTAL CONCENT. CODE: Z (100 PARTS PER MILLION (0.01 PERCENT) TO 1 PERCENT (10.000 PARTS PER MILLION))
SEQUENTIAL TREATMENT :
TREATMENT EFFICIENCY ESTIMATE : 0.00
BASED ON OPERATING DATA : N (NO, TREATMENT EFFICIENCY ESTIMATE IS NOT BASED ON ACTUAL OPERATING DATA)
2
CO
o
20
m
m
%
c
W
m
31
o
m
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 20 SAMPLE BATCH REPORTS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CHEMICAL/GEOGRAPHIC/
SIC CODE REPORT
09/03/91 B - 21 SAMPLE BATCH REPORTS
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 B - 22 SAMPLE BATCH REPORTS
-------
o
to
TRR08BP
PAGE
1
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
TOXIC RELEASE INVENTORY SYSTEM
CHEMICAL/GEOGRAPHICAL/SIC CODE REPORT, REPORTING YEAR: 1989
REGION: 03 * STATE: VA * CITY: RICHMOND » * ZIP CODE: 00000 THRU 99999
SFACIL-CITY » « » »
FUG AIR STACK AIR
DATA SORTED BY: » SFACIL-STATE
FACILITY NAME / ADDRESS
DOCUMENT CONTROL NUM CHEMICAL NAME
MATER
UNDER INJ
06/13/91
21:05:16
LAND
00
CO
TJ
JAMES RIVER CORP FILTRATION PRODUCTS DIV-RICHMONO
TREDEGAR ST.
RICHMOND, VA 23219
13-89-03532178-5-VA FORMALDEHYDE
13-89-03532179-7-VA PHENOL
13-89-03532180-9-VA METMANOL
«»* TOTALS FOR JAMES RIVER CORP. FILTRATION
REHRIG INTERNATIONAL
901 NORTH LOMBARDY 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
0
0
180,000
180,000
0
73
73
14,000
19,000
1,200,000
1,233,000
0
146
146
250
250
1
7
160
168
2
CO
|
|
O
m
m
co
m
3J
co
O
6
m
O
3)
m
3
J.n. FRY CO. INC.
830 HULL ST.
RICHMOND, VA 23224
13-89-03542988-5-VA COPPER COMPOUNDS 000
250 LBS HAS USED FOR RELEASE ESTIMATE FOR 1-499 REPORTING RANGE, 750 LBS FOR 500-999 RkNGE
-------
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
GO
i
10
CO
3;
TJ
m
§
^
O
^^
3)
m
Q
3J
CO
TRROSBP
PAGE : 1
1RI FACIL ID/
DOC CNTL HUH
242IOSTRLNNORHO
1 3-89-03506491 -6-VA
24210HSTNGHIGHH
13-B9-03524000-9-VA
2'i210HSTNSHIGHU
13-69-03524001-1-VA
24Z10HSTNSHIGHH
13-89-03524002-3-VA
24210HSTNGHIGHH
13-89-03524003-5-VA
23301PRDNCROUTE
13-89-03580523-7-VA
23301PRDNCRQUTE
13-89-03580524-9-VA
23301PRDNCROUTE
13-B9-03580525-2-VA
22312TLNTC5390C
13-89-03575229-6-VA
22312TLNTC5390C
13-69-03575230-6-VA
UNITED
YEAR:
FACILITY NAME
STERLING CASKET HARDHARE CO.
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINGHOUSE ELECTRIC CORP.
EMD
HESTINSHOUSE 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
oe/ 12/91
16:02:17
1989 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
FACILITY ADDRESS
NORWOOD Rl).
ABINGOON
VA 24210
HHY. 11 HESTINGHOUSE RD.
ABINGDON
VA 24210
HHY. 11 HrSTINGHOUSE 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) 6Z8-7153
LISA M. GENTRY
(703) 676-9152
LISA M. GENTRY
(703) 676-9152
LISA M. GENTRY
(703) 676-9152
LISA M. GENTRY
(703) 676-9152
JAMES EICHELBERC.ER
(804) 787-2700
JAMES EICHELBERGER
(804) 787-2700
JAMES EICHELBERGER
(804) 787-2700
JENNIFER G. FOSTER
(703) 642-6448
JENNIFER G. FOSTER
(703) 642-6448
CAS NUMBEP/
CHEMICAL MAI1E
71-55-6
1 . 1 1 1-TRICHLOROE RUNE
1330-20-7
XYLENE (MIXED ISOMERS)
1319-77-3
CRESOL (MIXED ISOMERS)
7440-50-8
COPPER
108-95-J
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
CO
Z
s
33
>
H
0
z
33
m
3J
m
>»
r~
C
CO
m
33
CO
O
c
O
m
-------
TRR05BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 06/12/91
PAGE: 170 TOXIC RELEASE INVENTORY SYSTEM 16:02:21
REGIONAL TRIS SUBMISSIONS REPORT
YEAR: 1909 REGION: 03 STATE: VA ZIP CODES: 00000 THRU 99999
TRI FACIL ID/ TFC.H CONTACT NAME/ CAS NUMBER/
DOC CNTL NUM FACILITY NAME FACILITY ADDRESS PHONE NUMBER CHEMICAL NAME
REPORT SUMMARY
TOTAL NUMBER OF SUBMISSIONS = 1667
TOTAL NUMBER OF FACILITIES = 473
LIST OF ALL CAS NUMBERS (HITH CHEMICAL NAMES) USED:
50-00-0 FORMALDEHYDE
55-63-0 NITROGLYCERIN
56-23-5 CARBON TFTRACHLORIDE
63-25-2 CARBARYL
CD 67-56-1 METHANOL 33
67-63-0 ISOPROPYL ALCOHOL (MANUFACTURING, STRONG-ACID PROCESS ONLY. NO PROCESS HI
10 67-64-1 ACETONE
67-66-3 CHLOROFORM
67-72-1 HEXACHLOROETHANE
71-36-3 N-BUTYL ALCOHOL
71-43-2 BENZENE
71-55-6 1,1,1-TRICHLOROETHANE C
74-85-1 ETHYLENE
75-05-8 ACETONITRILE
75-07-0 ACETALDEHYDE (~
75-09-2 DICHLOROMETHANE S5
75-15-0 CARBON DISULFJDE
75-21-0 ETHYLENE OXIDE
75-35-4 VINYLIDENE CHLORIDE
75-55-8 PROPYLENEItllNE
^ 75-56-9 PROPYLENE OXIDE
75-65-0 TERT-BUTYL ALCOHOL
f- 76-13-1 FREON 113
m 77-78-1 DIMETHYL SULFATE
CO 78-84-2 ISOBUTYRALDEHYDE
78-87-5 1,2-DICHLOROPROPANE
O 78-93-3 METHYL ETHYL KETONE
79-01-6 TRICHLOROETHYLENE
79-06-1 ACRYLAMIOE
79-10-7 ACRYLIC ACID
2 79-11-8 CHLOROACETIC ACID
5g 80-62-6 METHYL METMACRYLATE
-------
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
-------
3
«
CO
to
SAMPLE
>.
rCH REPORTS
TRR02BP UNITED
PAGE: 1
09:45:08.2
STATES ENVIRONMENTAL PROTECTION AGENCY 08/13/91
TOXIC RELEASE INVENTORY SYSTEM
POTH/OFF-SITE LOCATION REPORT
POTH/OFF-SITE LOCATION REPORT FOR TRI-OFF-SITE-ID 53150BFHSTH143S *«POTH/OFF-SITE NAME: BFI HASTE SYSTEMS TOWN I
STREET: H143 S6400 COLLEGE CT. / COUNTY: HAUKESHA / CITY: MUSKEGO /
REGION TRI-FACILITY-ID: 53187LLYPR1045P
EPA-ID : HID006077978
OOC-CNTL-NUM : 13-89-03581823-4-HI
CAS NUMBER : 000071-55-6
CHEMICAL NAME: 1 ,1,1-TRICHLOROETHANE
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID: 53187LLYPR1045P
EPA-ID : HID006077978
DOC-CMTL-NUM : 13-B9-03581821-0-HI
CAS NUMBER : 007439-96-5
CHEMICAL NAME: MANGANESE
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
REGION TRI-FACILITY-ID: 531B7LLYPR1045P
EPA-ID : HID006077976
DOC-CNTL-NUn : 13-69-03581B22-2-HI
CAS NUMBER : 007440-02-0
CHEMICAL NAME: NICKEL
TYPE OF TRANSFER 00 1-499 500-999
LB. LBS. LBS.
OTHER OFF-SITE LOCATION
NAME :
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS
0
NAME :
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS.
772
NAME :
ADDRESS :
CITY/STATE/ZIP:
SIC CODE: 3551
ESTIMATE
IN LBS.
1,634
STATE: HI / ZIP: 53150
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
HAUKESHA, HI 53187
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
HAUKESHA, HI 53187
ALLOY PRODUCTS CORP.
1045 PERKINS AVE.
HAUKESHA, HI 53187
33
CO
Z
1
iTION RETRIEVAI
i^
c
m
V)
O
5
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
-------
c
-»
00
1
en
^
o
ni
>
H
o
X
3)
m
TRR01BP UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
PAGE: 1 TOXIC RELEASE INVENTORY SYSTEM
GEOGRAPHIC LOCATION / CHEMICAL PROFILE REPORT
YEAR: 1989 REGION: 03 STATE: VA ZIP CODE: 21231 CITY: RICHMOND
RGN TRI-FACILITY-ID FACILITY NAME ADDRESS CITY / STATE
03 Z3231TTMCR4500S AT&T MICROELECTRONICS 4500 S. LABURNUM AVE. RICHMOND
RICHMOND WORKS VA
CAS NUMBER : 007664-41-7 SIC-CODE(S): 3672 3661 NA
CHEMICAL NAME: AMMONIA
TYPES OF RELEASES 00 1-499 500-999 ESTIMATE TYPES OF TRANSFERS
(SUMMARY) LB. LBS. LBS. IN LBS. (SUMMARY)
FUGITIVE AIR EMISSION 0 DISCHARGE TO POTH
STACK/POINT AIR EMISSION 17,700 OTHER OFF-SITE LOCATIONS
DISCHARGE TO HATER 0
UNDERGROUND INJECTION 0
RELEASE TO LAND 0
11 TOTALS FOR RELEASES: 17,700 *« TOTALS FOR TRANSFERS:
11 TYPES OF ACTIVITY/USES **
MANUFACTURE : PRODUCE IMPORT ON-SITE USE SALE/DISTR BYPRODUCT
PROCESS : REACTANT FORMULATION ARTICLE REPACKAGING
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
RGN TRI-FACILITY-ID FACILITY NAME ADDRESS CITY / STATE
03 23231TTHCR4500S ATtT MICROELECTRONICS 4500 S. LABURNUM AVE. RICHMOND
RICHMOND WORKS VA
CAS NUMBER : 007782-50-5 SIC-CODE(S): 3672 3661 NA
CHEMICAL NAME: CHLORINE
TYPES OF RELEASES 00 1-499 500-999 ESTIMATE TYPES OF TRANSFERS
(SUMMARY) LB. LBS. LBS. IN LBS. (SUMMARY)
FUGITIVE AIR EMISSION 0 DISCHARGE TO POTH
STACK/POINT AIR EMISSION 151 OTHER OFF-SITE LOCATIONS
DISCHARGE TO HATER 0
UNDERGROUND INJECTION 0
RELEASE TO LAND 0
«* TOTALS FOR' RELEASES: ' 151 «* TOTALS FOR TRANSFERS:
«» TYPES OF ACTIVITY/USES «»
MANUFACTURE : PRODUCE IMPORT ON-SITE USE SALE/DISTR BYPRODUCT
PROCESS : REACTANT FORMULATION ARTICLE REPACKAGING
OTHERWISE USED: X PROCESS AID MANUFTR AID ANCILLARY
08/12/91
16:04:16
ZIP EPA-ID
23231 VAD066000993
DCN: 13-89-0351 1056-2-VA
00 1-499 500-999 ESTIMATE
LB. LBS. LBS. IN LBS.
59,500
0
59,500
IMPURITY
ZIP EPA-ID
23231 VAD066000993
DCN: 13-89-03511057-4-VA
00 1-499 500-999 ESTIMATE
LB. LBS LBS. 1. IBS.
0
0
0
IMPURITY
-1
3
Z~
Tl
3)
Si
H
31
m
3J
m
|
c
m
33
CO
o
6
m
-------
TRRCIIJP UNITED STATES EIIVIRONMENTAL 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: 23231 CITY: RICHrOND
«**lt»
5j
TOTAL FACILITIES - 10
TOTAL SUBMISSI3NS = 24
RELEASES TO ENVIRONMENT
FUGITIVE AI«= 383.690
STACK AIR = 318.188
HATER = 0
U UNDERGROUND = 0
°> LAND = 0
TOTAL = 701,878
TRANSFERS
TO POTH = 109.871
TO OFF SITE = 35.050
TOTAL = 144,921
CO
TJ
S
I
m
s
;!
g
3J
m
m
CO
m
CO
O
o
m
-------
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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
TABLE OF STATES AND
EPA REGIONS (STATES)
Alabama (AL)
Alaska (AK)
Arizona (AZ)
Arkansas (AR)
California (CA)
Colorado (CO)
Connecticut (CT)
Delaware (DE)
District of Columbia
Florida (FL)
Georgia (GA)
Hawaii (HI)
Idaho (ID)
Illinois (IL)
Indiana (IN)
Iowa (IA)
Kansas (KS)
Kentucky (KY)
4
10
9
6
9
8
1
3
(DC) 3
4
4
9
10
5
5
7
7
4
Listing of EPA Regional Offices by State
Louisiana (LA) 6
Maine (ME) 1
Maryland (MD) 3
Massachusetts (MA) 1
Michigan (MI) 5
Minnesota (MN) 5
Mississippi (MS) 4
Missouri (MO) 7
Montana (MT) 8
Nebraska (NE) 7
Nevada (NV) 9
New Hampshire (NH) 1
New Jersey (NJ) 2
New Mexico (MM) 6
New York (NY) 1
North Carolina (NC) 4
North Dakota (ND) 8
Ohio (OH) 5
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 (RI)
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 (IA)
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
Coluiado (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 (IL)
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
LJ
Important Tvpe or print read instructions before completing form )
Form Approved OMB No :070-0093
01/94 I I
Approval Expires .
Page 1 of 5
egp EP/X U S Environmental Protection Agency
TOXIC CHEMICAL RELEASE INVENTORY REPORTING FORM
Section 313 of the Emergency Planning and Community Rlght-to-Know Act of 1986.
also known as Title III of the Superfund Amendments and Reauthorlzation Act
(This space for your optional use )
EPA FORM PART L
_ FACILITY
D IDENTIFICATION
INFORMATION
i
1 1 Are you claiming the cnemical idonnty on page 3 trade secret?
L J Yes (Answor Question .2. 1 1 NO (Do not answer 1 2
Attacn suDstannation forms ) Go to Question 1 3 ]
PuDhc reooriing Durden for inn
collection of information is estimated to
vary from 30 to 34 hours per response
with an average of 32 hours oer
response including lime for reviewing
instructions searching existing data
sources gathering ana maintaining tne
data needed, ana completing and
reviewing the collection of information
Send comments regarding this burden
estimate or any other aspect of tnis
collection of information, including
sugo.Miton« for reducing this touroen, to
ChNrr. information Policy Branch
(PM-223) US EPA, 401 M St . SW
Washington. D C 20460 Attn TRI
Burden and to tne Office of (nlormatton
«nd rtoouJ.rt.yv Affairs. Cfltoe of
Manao.irn.jnl and Budget Paperwork
Reduction^ Project (2070-O093»
Washington D C 20603
12 IT "Yes" in i 1 is this copy
[ J Sanitized 1 J Uncanitlzed
1 3 Reporting Year
1Q
2 CERTIFICATION (Read and sign after completing all sections )
i nereov certify that I nave reviewed the attached documents and that to me oest of my knowledge and Deiiaf the submitted information is true and
complete ana that the amounts and values in this report are accurate based on reasonaole estimates using data available to tne rxeparars of mis report
Name and official title of owner /operator or senior management official
Signature
3 FACILITY IDENTIFICATION
3 1
3 2
3 3
3 )
3 5
3 6
Facility or EsiaDhsnmem Name
Street Address
City County
Stale Zip Cooe
TRl Facility identification Number
Date signed
WHERE TO SEND COMPLETED FORMS:
1 EPCRA REPORTING CENTER
P O BOX 23779
WASHINGTON. DC 20026-3779
ATTN- TOXIC CHEMICAL RELEASE INVENTORY
2. APPROPRIATE STATE OFFICE (See instructions
in Appendix G)
"us rcDOi-i con.dms miorr-aiior cr .Cnoc* O"i* cnoi r r i
a I -n entire acmiv D [ J aar' of a (acuity
Technical Contact
PuOhc Contact
5iC Code i« digit) j
^a i -ae
Degrees Vmu.es Seconas
1 3un i Braoslroal Numoerisl
37 la
3 a
3 9
3 10
3 11
= 3A identification Numoerisi (RCRA I D No i
a
F.PDES Permit Numoeris)
a
Receiving Sfeams or water Bodies tenter one na^e oer oo«l
i
c
Unoergrouno injection v\en Cooe (UiCi icentitication r-Jumoerisj
reloonon
l Numoor imc
lude area cooel
Teieonone Numoer (include area code)
" e '
2ec/oos *"
_cngi ude
nuies
Seconds
c
D
D
..
4 PARENT COMPANY INFORMATION
Name of Parent Comoany
paren( Cor-oanv 5 ^jn
& BraOStroot
Numoer
EPA Form 9350-1 (Rev 1-91) - Previous eaitions are oosoieie
07/31/91
D-3
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important Type or print, read instructions before completing form )
D
Page 2 of 5
D
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important Type or print, read instructions before completing form )
D
Page 3 of 5
EPA
EPA FORM R
PART III. CHEMICAL-SPECIFIC INFORMATION
(This space for your optional use )
1 CHEMICAL IDENTITYIDo not complete this section if you complete Section 2 )
1 1 [Reserved]
1 2
CAS Number (Enter only ono number exactly as it appear! on tne 313 list Enter NA il reporting a cnemical category )
1 3
Chemical or Cnemical Category Name (Enter only one name exactly as u appears on tne 313 list 1
Generic Chemical Name (Complete only if Part I Section t tic cnecxed " Yes Generic name must be structurally descriptive )
MIXTURE COMPONENT IDENTITY |Do not complete this section if you complete Section 1 |
Generic Chemical Name Provided Dy Supplier (Limit the name to a maximum of 70 characters (e g . numbers letters spaces punctuation) )
3 ACTIVITIES AND USES OF THE CHEMICAL AT THE FACILITY (Check all that apply I
3 1
Manulaciure the
chemical
all Produce
b [ J Import
If produce or import
f 1 For on-site
c I J use/processing
e[ J As a byproduct
. f I For sale/
d L J distribution
f [ J As an Impurity
3 2
Process me
chemical
a [ ] As a reactant
d [ \ Repackaging only
r 1 As a formulation
1 I J component
f 1 As an article
J component
3 3
Otherwise us*
the chemical
T 1 As a enemical f 1 f 1
a I J processing aid b I J As a manufacturing aid c L J Ancillary or other i
4 MAXIMUM AMOUNT OF THE CHEMICAL ON-SITE AT ANY TIME DURING THE CALENDAR YEAH
(enter coae)
5 RELEASES OF THE CHEMICAL TO THE ENVIRONMENT ON-SITE
You may report releases of less than
1 000 pounds by checking ranges under A 1
(Do not use Botn A 1 and A 2)
5 1 Fugitive or non-point air emissions
5 2 Stack or point air emissions
5 3 Discharges to receiving
streams or water bodies
,D
(Enter letter code from Part I I I
Section 3 10 for stream(s) in 532 I I
tne box provided )
533
5 4 Underground Injection
5 5 Releases to land
5 5 I On-sile landtm
552 Land treatment /application (arming
553 Surface impoundment
5 5 « Oinor disposal
5 23
5 3 la
5 3 2a
5 3 3a
5 4a
5 5 la
5 5 2a
5 5 3a
A Total Release
(pounds/year)
A 1
Reporting Ranges
iQ 'l-«99 500-9g9
A 2
Enter
Estimate
B Basis of
Estimate
(enter code)
S ib
S 2b
5 3 Ib
5 3 2b
5 3 3b
5 4b
5 5 1b
5 5 2b
D
5 5 3b
D
5 5 4b
D
[ l
(Check it additional information is provided on Part iv-Supplamentai information I
EPA Form 9350-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
D-5
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
n
(Important Type or print, read instructions before completing form )
PART III.
EPA FORNlR
CHEMICAL-SPECIFIC INFORMATION
(continued)
n
Page 4 of 5
(This space for your optional use I
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)
Ducnarge to POTW . . ,__,
(enter location numoer .11
6 1 1 from Pan n Section l ) | ' | |
Otner off-lite location . . , .
6- , (enter location numoer 1 ., 1 1
' 1 from Part n Section 2 } I * I (
Otner olf-ine location ._. __,
6- _ (enter location numoer 9
t Z from Part II Section 2)1 II
Otner off-cue location __. __
(enter location numoer 1 ~\ \
623 from Part II Section 2 I | * \ \
A Total Transfers
(pounds/yr)
A 1 A 2
Reporting Ranges Enter
1-10 11-«9B 500-999 Estimate
[][][]
[][][]
[][][]
[][][]
B Basis of Estimate
(enter code)
6 1 ib 1 1
6 2 1b 1 1
622bD
623bD
C Type of Treatment/
Disposal
^^Pi'^^^i^i
6 2 2c NTD
6 2 3c |M| I 1
[ ] (Check if additional information is provided on Part IV-Supplemental Information )
7 WASTE TREATMENT METHODS AND EFFICIENCY
DNot Apphcabl e (NA| - Check i, no on-site treatment is applied to any waste stream containing the cnemical or cnemical
category
A General
Wastestream
(enter code)
71. n
72a C]
7 3a Q
7 4a Q
7 5a Q
7 6a [ |
7 7a Q
7 8a [ )
7 9a | ]
7,0a Q
B Treatment
Method
(enter codel
7ib rm
72b rm
73b n~n
*« rm
75b rm
?6b rm
"- rm
78b rm
79b rm
7, ob rm
C Range of
Influent
Concentration
(enter codel
' ic n
7 2c 1 1
7 3c ( )
7 4c Q
75c n
7 6c | 1
77C Q
7 sc r^i
7 9c Q
7 lOc | |
D Sequential
Treatment9
(check if
applicable)
7 Id [ ]
7 2d [ ]
73d []
7 4d f ]
7 5d [ ]
7od [ ]
7 7d f ]
7 8d T ]
7 9d [ ]
7 lOd [ ]
E Treatment
Efficiency
Estimate
7 le %
7 2e %
7 3e %
7 4e %
7 5e %
7 6e Id
7 7e %
7 Be %
7 9e %
7 lOe %
F Based on
Operating
Data?
Yes No
7 " [ 1 [ 1
721 [ 1 [ 1
7 " [ 1 [ 1
741 [ 1 [ ]
75, [ ] [ ]
76' [ 1 [ 1
771 [ 1 [
78, [ ] [
79, [ ] (
7 ,0, [ ] [
[ ] (Check i, additional Information is provided on Part IV-Supplemental Information )
8 POLLUTION PREVENTION OPTIONAL INFORMATION ON WASTE MINIMIZATION
(Indicate actions taken to reduce the amount of the chemical being released from the facility See the instructions for coded
items and an explanation of what information to include I
A Type of B Quantity of the cnemical in Wastes
Modification Prior to Treatment or Disposal
(enter codel
C index
Current Prior Or percent change
reporting year (Check [»| or (-))
year Ipounds/vearl r~l
|~77| I ipounasiyearj p: ^_^
D Reason for Action
(enter code)
ED
EPA Form 9350-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
0-6
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
D
(Important Tvpe or print, read instructions before completing form
n
Page 5 of S
(This space for your optional use I
£L PDA EPA FORM R
*-rf+ 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 1
A Total Release B Ba
(pounds/yr) Es
At A 2 (enter
Reporting Ranges Enter m
1-10 11-499 soo-999 Estimate prov
SIS Of
imate
code
Box
ided)
S 3 Discharges to . .
receiving streams or CITIFI
water bodies S3 1 153 a 1 J 1 J 1 J S3 »l 1
(Enter letter cooe from Part i f~
Section 3 10 for itream(i) In c »
me oox oroviaeo ) 3 * *
J 5 3 a [][][] 53 bl
5 3 D 5 3 a [][][] 53 bD
C % From
Stormwater
5 3 c %
5 3 c %
53 c %
ADDITIONAL INFORMATION ON TRANSFERS OF THE CHEMICAL IN WASTE TO OFF-SITE LOCATIONS
(Part III Section 6)
You may report transfers
of less than 1 000 pounds bv checking
ranges under A 1 (Do not use
botn A 1 and A 2)
Dlicnarge to BOTW .__ __
6, tenter location numoer T|
1 from Part 0 Section 1 1 | ' | | |
Otner off-i'te location r , , ,
A 2 (enter location numoer 2
" ' from Part II Section 2 1 1 * 1 1 ]
Other off-nte location r i i 1
6 2 (enter location numaer 12
'rom Part n Section 2 I l__l l__l
Otner off-iite location r «. .
A 2 (enter location numoer 9
" ' from Part II Section 2 ] 1 * 1 I I
A Total Transfers B |a*J* °'
ipounds/yri Estimate
A 1 A 2 (enter code
Reporting Ranges Enter In box
1-10 H-.99 soo-999 Estimate provided)
[][][] 6, bD
[][][] 62_bD
[][][] S2_bD
C Type of Treatment/
Disposal
(enter code
In box
provided)
62_clM| J |
6 2
_e|Ml U
62 cHyvm
ADDITIONAL INFORMATION ON WASTE TREATMENT METHODS AND EFFICIENCY (Part III. Section
A General
Wastestream
(enter code
In box provided)
7 a Q
7 a rn
* '
7 a 1 1
' '
7 a 1 1
' -
7 a 1 1
1 J
7 a 1 1
|__J
7 a 1 1
' '
7 a 1 1
'
i aii
3 T-eatrrent
Method
(enter code
In box provided)
7 * rm
7 b rm
7 b rm
7 » rm
7 b rm
7 b MM
i i i i
7 b MM
I'll
7 b rm
o ' M '
* ° i ' i
C Range ol
Influent
Concentration
(enter code)
7 c ( |
7 c n
7 c n
7 c n
7 c n
7 = n
7 c 1 1
. . 1 1
0 Sec-eni'ai
Treatment?
(check If
applicable)
7 d[ ]
7 d[ 1
7 d [ ]
7 d [ 1
* J
7 d[ 1
7 0 [ ]
* J
7 d r i
7 d f 1
7 -r i
E Treatment
Efficiency
Estimate
7 . %
7 e %
7 e %
7 e *
7 e %
7 e *
7 e %
7 e %
e "4
F
7
7
7
7
7
7
7
7)
Sasea on
Operating
Data?
Yes No
'[ ][ 1
'[ ] [ ]
'[ ] [ ]
f [ ] [ 1
' I 1 1 1
1 [ } [ ]
'[ ] [ 1
7 ' [ ] [
7 'fir
EPA Form 93SO-1 (Rev 1-91) - Previous editions are obsolete
09/03/91
D-7
FORMR
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 D - 8 FORM R
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX E
MICRO-TO-MAINFRAME LINK
09/03/91 E - 1 MICRO-TO-MAINFRAME LINK
-------
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
ill
09/03/91 E - 4 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CONTENTS
INTRODUCTION 1
ASYNCHRONOUS FILE TRANSFERS 2
KERMIT PROTOCOL 2
MS-KERMIT 5
MAINFRAME TO PC 5
MS-KERMIT DOWNLOAD PROCEDURES 6
CROSSTALK DOWNLOAD PROCEDURES 7
UPLOADING DATA TO THE MAINFRAME VIA
CROSSTALK OR MS-KERMIT 7
KERMIT BINARY FILE TRANSFER 8
COAX FILE TRANSFERS 10
IRMA CARD AND FORTE CARD 10
UPLOADING USING IRMA OR FORTE 10
CXI CARD 13
UPLOADING USING THE CXI CARD 13
DOWNLOADING USING COAX CARDS 13
LAN SNA GATEWAY FILE TRANSFERS 16
UPLOADING USING THE LAN SNA GATEWAY 16
DOWNLOADING USING THE LAN SNA GATEWAY 19
09/03/91 E - 5 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CONTENTS
ARBITER FILE TRANSFERS 21
TWO METHODS TO USE WITH ARBITER 21
UPLOADING USING ARBITER 22
DOWNLOADING USING ARBITER 25
COMMAND LINE TRANSFERS 30
INDEX Index-1
VI
09/03/91 E - 6 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INTRODUCTION
Although there are many data file transfer needs
within the Environmental Protection Agency, this
portion of the Guide to NCC Services is limited to
transfers of text or binary data from MS DOS, IBM-
compatible microcomputers to any of the NCC-IBM
mainframe computers. It is assumed that you have
acquired a User-ID and account on at least one of the
NCC-IBM mainframes and are able to log on to TSO.
For more information on registration procedures and
for detailed logon instructions, refer to the section of
this guide entitled Getting Started.
File transfers can occur across any micro-to-main-
frame connection except the NCC's System Network
Architecture (SNA) protocol converter, also referred
to as the Terminal/Controller Processor (TCP). The
NCC supports transfer accesses in the following
categories:
Asynchronous: dialup, multiplexers, and DEC
terminal servers
Coaxial: IRMA, CXI, and FORTE
Local Area Network (LAN) SNA gateway
connections
Asynchronous connections are established through
modems such as HAYES 1200 or 2400 baud modems
or through direct wired connections. These direct
connections include multiplexer devices, often re-
ferred to as muxes, and DEC terminal servers.
09/03/91
E-7
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
ASYNCHRONOUS FILE TRANSFERS
HERMIT Hermit is a file transfer protocol which will ensure
PROTOCOL error free data transfer between two computers across
asynchronous communications connections. A Her-
mit file transfer requires that both computers in-
volved have Hermit software available. The Hermit
file transfer protocol was developed several years ago
by Columbia University for transferring data to and
from mainframes. Columbia placed Hermit in the
public domain, and it has been developed for many
different computer systems including IBM-compat-
ible PC's and IBM mainframes. The version on the
NCC-IBM mainframe is called TSO-Kermit; the ver-
sion for the IBM PC is called MS-Kermit.
Both Crosstalk and MS-Kermit may be used on the
PC to accomplish 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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
CROSSTALK - XVI
Crosstalk XVI ver 37b
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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
-CROSSTALK - XVI Status Screen-
Off line
NAtne Crosstalk default settings
NUmber 0700
LOaded STD
CApture Off
I Communications parameters"
SPeect 2400 PArity Even DUplej
DAta 7 Stop I EMulale
PDrt 1 MOde
filler settings"
DBjug OF LFauto
Full DEbug OF LFauto Off
VT-IOO TAb« Off BLankei Off
Call IMilter On OUtfiltr On
1
ATlen OS (1)
SWitch Home
Key settings
1 r~ SEnd oonirol set tings ~l
COrnmand ETX CC) CWait None
BReak End LTPait None
1) EMAIL
Available command files '
2) NEWUSER 3) SETUP 4} STD 5) ISO
Enter number far ftletouse( ! -1
Command files allowyou 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 Support.
09/03/91
E-10
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
MS-KERMIT
MAINFRAME
TO PC
READY
KERMIT
Note that if you add or delete a command file, num-
bering will change because Crosstalk arranges the
files alphabetically.
For convenience, the MS-Kermit version includes the
Kermit transfer protocol along with a terminal emu-
lation program to allow you to log on to the main-
frame and transfer data in the same program.
Every mainframe/PC transfer (either direction) must
begin with the mainframe because you are using the
PC as a way to enter commands.
Transferring data from a mainframe to a PC is
commonly referred to as downloading. To begin a
Kermit file transfer from the mainframe to your PC,
log on to the IBM and get to the TSO READY prompt.
Refer to the section of this guide entitled Getting
Started for logon details. Then enter the following
at the TSO READY prompt:
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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
f
Kermit-TSO»SEND data-set-narre
Delay in seconds before sending Is 20,
Escape to your local KERtllT and enter the RECEIVE command
1
At this point procedures differ depending on whether
you are using Crosstalk (version 3.6 or later) or MS-
Kermit (currently version 2.30).
If you are using MS-Kermit, press CTRL-] followed
by C to escape to the command mode on the PC. In
newer versions of MS-Kermit, Alt-X will function the
same way.
The Kermit-MS> prompt appears on the screen.
Enter RECEIVE in response to the prompt as shown
below:
MS-KERMIT
DOWNLOAD
PROCEDURES
Kermit-MS>RECEIVE
Kermit-MS: V2.30
File name:
KBytes transferred:
Receiving:
Number of packets:
Packet length:
Number of retries:
Last error:
Last varning:
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:
Enter KERMIT RECEIVE in response to the prompt.
The file transfer begins and continues 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:
UPLOADING
DATA TO THE
MAINFRAME VIA
CROSSTALK OR
MS-KERMIT
f
Kermit-TSO>REC
Entering receive moOe ...
Escape to your local KERMIT and enter the SEND command
III
.1
09/03/91
E-13
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Then escape from the terminal mode of MS-Kermit
or Crosstalk, (CTRL-] or Attn key as discussed be-
fore) and tell your PC to send the data you wish to
transmit. Crosstalk uses the following command at
the Command? prompt to send data to the TSO data
set:
KERMIT SEND filename
The command to do the same thing in MS-Kermit is
as follows:
SEND filename
An example follows:
Coaimand?SEND myfile.m
7
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. If you 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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
following command at the Kermit-TSO> prompt prior
to starting your SEND or RECEIVE of any data:
SET FILE BINARY
To reverse this and start text file transfers the com-
mand is SET FILE TEXT.
MS-Kermit requires no special commands to switch
to binary mode from text mode. It recognizes the
mainframe activities as binary activities and switches
accordingly.
However, Crosstalk must be told to switch to binary
mode before starting to send or receive data with the
following entered at the Command? prompt:
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.
09/03/91
E-15
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
COAX FILE TRANSFERS
Another method which is used within the EPA to
connect IBM-compatible PCs to the various IBM
mainframes uses coaxial cable (often referred to as
coax). This coax is connected to the PC by use of coax
adapters or interface cards installed inside the PC.
There are three major coax cards used within EPA
and supported by NCC User Support:
IRMA
FORTE
CXI (PCOX)
All three products can perform file transfers pro-
vided that you have the right software installed on
your PC As in any file transfer there must be
software on each computer capable of communicat-
ing with the other across the communications link.
The NCC supports one software package called
IND$FILE on the IBM mainframes which will com-
municate with any of the three interface cards men-
tioned.
IRMA CARD AND 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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
resident in the PC's memory for FT3270 to work. See
the IRMA or FORTE manuals for more information
on making the terminal software resident.
Access the IBM through the IRMA or FORTE connec-
tion (often just by selecting the software from the
AUTOMAX menu). Then log on to TSO and get to the
READY prompt. See the section of this guide called
Getting Started for logon details. At the READY
prompt, press the HOTKEY.
The HOTKEY is usually defined as pressing both
shift keys simultaneously to escape to the DOS
prompt. At the DOS prompt enter the following
command:
SEND d:\path\pctile.typ tso.dsnUmbnJ [.options]
Where the command elements are explained as fol-
lows:
d:\path\ represents the DOS path to the file to be
sent, such as C:\MAINV
pcfile.typ represents the DOS filename of the file to
be sent to the mainframe.
tso.dsn is the destination data set name in TSO fol-
lowed by an optional partitioned data set member
name if the target data set is a partitioned data set.
options at the end of the command may include any
of the following:
11
09/03/91 E-17 MICRO-TO-MAINFRAME LINK
-------
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:
C:VSEND A:\IRMATEXT.DOC 'ABCW123.IRMATEXT(MAY0189)'
RECFM(FB) LRECU80) BLKSIZE(6l60) SPACE(5.1) TRACKS ASCII CRLF
Since the DCB information is default values, the
command can be shortened to the following:
12
09/03y91
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)F 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 pnnt 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 soflwaie will communicate
with IND$FILE to transfer flies 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 appropriate 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\pcflle.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:
CA>RECEIVE A:\tnyirma.doc 'target-dsn(mbr)' 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 (%) 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 logon 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
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Data Control Block (DCB) information:
BLKSIZE (size of logical data blocks)
LRECL (length of logical data records)
RECFM (record format such as fixed or vari-
able)
SPACE (how much space to allow for the data
on the mainframe)
TRACKS or CYLINDERS to refer to the
SPACE option
ASCII (to translate from ASCII to EBCDIC)
CRLF (to define CRLF as end of logical rec-
ords)
APPEND (to add the new data to an existing
data set on the mainframe)
For example, to send a small text file called
PCOXTEXT.DOC from the PC's C: disk drive to a
data set in TSO called 'ABCW123.PCOXTEXT with
member MAY0189 using the A: window to be printed
from the IBM mainframe, the command would look
like the following:
C:\>SENDFILE C:\PCOXTEXT.DOC A:'ABCW123.PCOXTEXT(MAY0189)'
ASCII CRLF
18
09/03/91
E-24
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
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.
DOWNLOADING The SEND and RECEIVE command syntax for the
USING THE LAN CXI/PCOX LAN SNA Gateway product is the same
SNA GATEWAY 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)l
[options]
Where the command elements are explained as fol-
lows.
d:\path\ represents the DOS path to the file to be
created on the PC
w: refers to the window you wish to transfer the data
with, since the gateway software operates in a win-
dowed mode
pcfile.typ represents the DOS filename of the file to
be received from the mainframe.
19
09/03/91 E - 25 MICRO-TO-MAINFRAME LINK
-------
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
CXITEXT.DOC to the C: disk drive on the PC from
a data set in TSO called 'ABCW123.CXITEXT
member MAYO 189 through PCOX window A: to be
merged into a WordPerfect document on the PC, the
command would look like the following:
C:\>RECEIVE C:\CXITEXT.DOC A:'ABCW123.CXITEXT(MAY0189j'
ASCII CRLF
-T1
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,
merge, or print thf» 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 file transfers. This
section will cover the file transfer features of Arbiter.
Like MS-Kermit, Crosstalk, and IRMA, Arbiter can
transfer data between your PC and the NCC-IBM
mainframe. However, unlike all of the other meth-
ods available at the NCC, Arbiter is not specific to
any one connection type. It can attach IBM-compat-
ible PC's to the IBM mainframe using a variety of
connection methods. Arbiter supports almost all of
the NCC communications access methods. In addi-
tion, all features of Arbiter are available to you
regardless of the access method you choose to use.
The NCC purchases, installs, and maintains the
Arbiter mainframe products. The PC software com-
ponents and documentation are available at no charge
through PC Site Coordinators and Information
Centers at Washington and RTP Or Arbiter soft-
ware and documentation kits can be obtained from
NCC Production Control for a copy fee of $25.00 per
kit Contact Production Control at one of the tele-
phone numbers listed below and be sure to have a
valid IBM timeshare account number available for
billing purposes
(FTS) 629-3609
(919) 541-3609
After logging onto Arbiter, there are two ways to
transfer a file'
Full-Screen Panels. Full screen panels prompt you
through the process All field data is retained from
one transfer session to the next to allow for easy
editing of repeated transfers
21
09/03/91
E-27
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Extended commands. You can issue extended
commands on the DOS command line. This is useful
when automating file transfers using the DOS batch
functions.
UPLOADING To start a transfer of data from the PC to the main-
USING ARBITER 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 FiJe Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
Fl-Help F2-Msgs F3-Mam
Node
LUNAME
ESC-Qim \F2-1SRAF3-DOS
FlO-Selea AFlO-Terminate
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
Other
SELECT
DBXFER
SUBMIT
PC file --» Hosi
Host --» PC Pile
Remote Disk --'> Host
Host » Remote Disk
EFI Services
Predefined Extraction
Database Transfer
Submit Job to Host
Fl-Help F2-Msgs F3-Main ESC-Quit AF2-ISRAF3-DOS
FlO-Selecl
Next, highlight the SEND command and press F10.
The following screen appears:
23
09/03/91
E-29
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
PC » Host
From:
To:
'Arbiter
FUe Transfer
02-15-W
TEXT
Transfer Type
TEXT
F1XREC
BINARY
FilePath
1
HostDSN
Append
No
Member
( )
FI-Help F2-Msgs F3-Main F4-EFI FIO-Exec ESC-Quit AF2-ISR AF3-DOS
F5-T F6-i F9-VJew
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-13-30
Remote Disk Environment Services
External File Interface Services
Interactive Session Relay Terminal
Signoff from Host Arbiter
Vi.xx
Node
LUNAME
Fl-Help F2-Msgs F3-Mam ESC-Qun AF2-1SR AF3-DC6
. FiO-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
Other
SELECT
DBXFER
SUBMIT
PC file --»> Host
Host --» PCFUe
Remote Disk » Host
Host «» Remote Disk
EFI Services
Predefined Extraaion
DataBase Trans! er
Submit Job to Host
Fl-Help F2-Msgs F3-Mam ESC-Quit AF2-ISRAF3-DOS
FlO-Select
w
&
Next, select RECV using the highlighted bar and
P10. The following screen appears:
27
09/03/91
E-33
MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
r
> % ;
f "\
Host --» PC
'Arbiter **
File Transfer
02-15-90
The Host Data Set Name must be filled in
From:
HostDSN
To:
FilePath C.
Replace No
TEXT TEXT
Transfer Type filNAi
C
*y
Member
( )
FI-Help F2-\ls>>s F3-Vam F4-EFI F!0-Exec ESC-Qu'1
AF2-ISR AF3-DOS
s
\
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:
k
| Replace
FI-Help
^
No
Host » PC File Transfer
FILEECT 8192 2-15-90 3'28p
F2-Msgs F3-Main F-i-EFI FlO-Eiec ESC-Quii AF2-ISR AF3-DOS
_J
i
29
09/03/91
E-35
MICRO-TO-MAINFRAME LINK
-------
TRIS 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.\>
$SEND[devlfilepath /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
$ command 22
Account 1
Arbiter file transfer 21
Arbiter PC software 21
Asynchronous transfer 1
AUTOMAX menu 11
Binary file transfer 1, 8, 9, 24, 28
Binary file transfer, using Arbiter 24, 28
Binary file transfer, using Crosstalk 9
Binary file transfer, using Kermit 8
Coax cards 10
Coax file transfer 10
Coaxial cable 10
Coaxial transfer 1
Columbia University 2
Command line transfers, using Arbiter 30
Command mode, on the PC 6
Command prompt 7
Command, abbreviating 7
Command, extended for Arbiter 22
Commands, KERMIT SEND 8
Commands, RECEIVE 6, 14, 19
Commands, RECV 27
Commands, SEND 6, 8, 11, 16, 23
Commands, SENDFILE 16
Crosstalk 2,3
CXI (PCOX) card 10
CXI 1
CXI card 13
CXI, WINDOWED version 13
Data set, preallocated 25
DEC terminal server 1
Dialup connection 1
Index-1
09/03/91 E - 38 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
Digital Communications Associates 10
Direct wired connection 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
L LAN (Local Area Network) 1
LAN SNA gateway 1
LAN SNA gateway file transfer 16
Local Area Network 1
M Mainframe to PC 5
Modem 1
MS-Kermit 2,5
Multiplexer connection 1
N NCC Production Control 21
Novell workstation 16
p Preallocated data set 25
Production Control 21
Protocol converter 1
Protocol, file transfer 2
P 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
Q SEND command 6, 8, 11, 16, 23, 30
SEND command, LAN SNA gateway 16
SENDFILE command 16, 17
Sending, using Arbiter 22
Sending, using Crosstalk 7
Sending, using CXI 13
Sending, using FORTE 10
Index-3
09/03/91 E - 40 MICRO-TO-MAINFRAME LINK
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
INDEX
Sending, using IRMA 10
Sending, using LAN SNA gateway 16
Sending, using MS-Kermit 5
Shift keys (HOTKEY) 11
SNA (System Network Architecture) 1
SNA gateway 1
System Network Architecture (SNA) 1
Telephone numbers, Production Control 21
Terminal/Controller Processor (TCP) 1
Text file transfer 1, 24, 28
Text file transfer, command to set 9
Text transfer, compared to binary 8
Time Sharing Option 1
Token Ring card 16
Token Ring LAN 16
Translation, of text 8
TSO (Time Sharing Option) 1
TSO-Kermit 2
Uploading, using Arbiter 22
Uploading, using Crosstalk 7
Uploading, using CXI 13
Uploading, using FORTE 10
Uploading, using IRMA 10
Uploading, using LAN SNA gateway 16
Uploading, using MS-Kermit 7
User-ID 1
Workstation software 16
oU S Government P--irlin6 Of*-ce 9"0-~:S-5.~
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 the PF1 key are shown below:
Vendor PF Key Sequence
Memorex 2078 Model 82
Typewriter Keyboard Style A,
87 keys hardwired terminal
PROCOMM Plus Version 1.1B 1
MS-DOS communications software
CROSSTALK XVI Release 3.61 1
MS-DOS communications software
09/03/91 F - 3 KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
MAINFRAME TERMINAL
Keyboard Configuration
Enter data and take the next logical action
Moves the cursor to the input field below the current one
PF1 / PF13
i i
I i
thru
i i
i i
PF12 / 24
PF1 equivalent
PF12 equivalent
Moves the cursor to the next input field
Stays on until is pressed
Deletes one character
Moves the cursor to the first input field
Resets the terminal when a lock condition occurs
09/03/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.
Enter data and take the next logical action
New line. Moves the cursor to the input field below the current one
+ Return to PC (DOS)
+ 1
I I
I I
thru
i i
i i
+ 9
+ 0
+ '-'
+ '='
PF1 equivalent
PF9 equivalent
PF10 equivalent
PF11 equivalent
PF12 equivalent
Reset locked terminal or turn off insert mode
Stays on until or is pressed
Deletes one character
Move the cursor to the first input field
09/03/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.
Enter data and take the next logical action
New line. Moves the cursor to the input field below the current one
On the number keypad PF1
On the number keypad PF2
On the number keypad PF3
+ H
Takes the cursor to the first input field
+ V Insert. Stays on until is pressed
Deletes one character
+ R
Resets the terminal when a lock condition occurs
+ number + For any designated in TRIS. For example:
type + 1 + 0 +
type + 1 + 1 +
type + 1 + 2 +
09/03/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 CXI terminal emulation software.
+ R
+ B
+ P
+ 1 +
I
I
thru
i
i
+ 9 +
Transmits data and take the next logical action
Moves the cursor to the next input field
Delete a character
Take the cursor to the first input field
Resets the terminal
Clears the screen
Prints the current screen to a local printer
PF1 equivalent
I
I
thru
i
i
PF9 equivalent
+ 1 + 0 + PF10 equivalent
+ 1 + 1 + PF11 equivalent
+ 1 + 2 + PF12 equivalent
09/03/91
F-7
KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 F - 8 KEYBOARD MAPPINGS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
APPENDIX G
REGIONAL ACCOUNT MANAGERS
09/03/91 G - 1 REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
09/03/91 G 2 REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
Account Name
Region/Location
Account Manager
TNEI
NEIC/Denver, CO
TOSW
Office of Solid
Waste
TRID
SYCOM/Developers
TRIS
Headquarters
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-9419
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
Carolyn Thornton
EPA/OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-8620
(202) 260-8620
09/03/91
G-3
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TOAQ
Office of Air Quality
Planning & Standards
TRIP
EPCRA Center
TRI1
Region 1
TRI2
Region 2
TRI3
Region 3
Charles Isbell
EPA/NADB/MDAD-OA&R
Mutual Building
RTF, NC 27711
(FTS) 629-5448
(919) 541-5448
Doug Sellers
OTS/IMD/PDB
401 M Street, SW
Washington, DC 20460
(FTS) 260-3587
(202) 260-3587
Michael McDougall
EPA/Region 1
JFK Federal Bldg.
Boston, MA 02203
(FTS) 835-3377
(617) 565-3377
Robert Messina
EPA/Region 2
26 Federal Plaza
New York, NY 10278
(FTS) 264-9850
(212) 264-9850
Kim Woodall
EPA/Region 3
841 Chestnut Big.
Philadelphia, PA 19107
(FTS) 597-9358
(215) 597-9358
09/03/91
G-4
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
TRI4
Region 4
TRIS
Region 5
TRI6
Region 6
TRI7
Region 7
TRI8
Region 8
Jesse Dooley
EPA/Region 4
345 Courtland St. NE
Atlanta, GA 30365
(FTS) 257-2316
(404) 347-2316
Sandra Darden
EPA/Region 5
230 S. Dearborn Street
Chicago, EL 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
-------
THIS INFORMATION RETRIEVAL USERS GUIDE
TRI9
Region 9
TRIO
Region 10
Judy Quan
EPA/Region 9
P5-2
75 Hawthorne St.
San Francisco, CA 94105
(FTS) 484-1802
(415) 484-1802
August (Gus) Parlier
EPA/Region 10
1200 6th Avenue
Seattle, WA 98101
(FTS) 399-2988
(206) 442-2988
*U.S. GOVERNMENT PRINTING OFFICE- 1991 517-003/47033
09/03/91
G-6
REGIONAL ACCOUNT MANAGERS
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
COMMENTS AND SUGGESTIONS
Please assist us in improving this publication. Your comments about the content, format, and
use of this publication are an important part in the input used for revisions.
Forward your comments to:
TRIS USER SUPPORT
401 M Street, SW
Washington, DC 20460
Page Circle One: Incorrect Unclear Incomplete
Comments
Date:
Name:
Company:
Address:
Telephone Number:
09/03/91 COMMENT
-------
TRIS INFORMATION RETRIEVAL USERS GUIDE
THIS PAGE INTENTIONALLY LEFT BLANK
°9>°3/91 COMMENT
-------