Toxics Release Inventory (TRI)
National File Documentation for RY 1997
Prepared for:
^tos%
(Mi)
Environmental Protection Agency
Office of Pollution Prevention and Toxics
Contract 68-W-98-045
By:
CBST
Computer Based Systems, Inc.
Date: March 23, 1999
Computer Based Systems, Inc.
2750 Prosperity Avenue, Suite 300
Fairfax, VA 22031-4312
-------
WELCOME TO THE EPA TRI NATIONAL FILE
FOR REPORTING YEAR 1997
The TRI National File has several features designed to make it easier for you to obtain TRI
information.
• Facility mailing address information, including the street address, city, state, and nine-digit
zip code
NOTE: Two 30-character mailing name fields and a 30-character mailing street
continuation (that appear in TRI, but are most often empty) were left out of the
National File to save space
• Facility Dun and Bradstreet (DUNS) number
• Expanded geographic location information fields added to TRI by EPA (these include the
"preferred" latitude and longitude expressed in decimal degrees, a location accuracy value
expressed in meters, and the method used to determine the latitude and longitude)
• A compressed file format to reduce the overall size of the database
• Reports filed by federal facilities, whether the facility is operated by a contractor or an
agency (these reports, which have been submitted to the EPA, are available on a separate,
nationwide, federal facility diskette, in dBase format)
These features are described in this guide.
-------
TRI National File Documentation
Table of Contents
1.0 Facts About the Toxics Release Inventory 1-1
1.1 About the RY97 TRI National File 1-3
1.2 Source Reduction and Recycling Activities 1-4
1.3 Conventions in this Document 1-6
2.0 Field Description 2-1
3.0 Hardware and Software Requirements 3-1
3.1 Instructions for using TRI with Popular Software Packages 3-1
3.2 Loading TRI (.DBF) Files into Excel 3-1
3.3 Loading TRI (.DBF) files into dBASE IV using the dBASE IV Assist Menu 3-2
March 23, 1999
i
Table of Contents
-------
TRI National File Documentation
1.0 Facts About the Toxics Release Inventory
Section §313 of the Emergency Planning and Community Right-to-Know Act (also known as Title III) of
the Superfund Amendments and Reauthorization Act (SARA) of 1986 (Public Law 99-499) requires EPA
to establish an inventory of toxic chemical emissions from certain facilities. The purpose of §313 is to
inform the public of the presence of chemicals in their communities and releases of these chemicals into the
environment. States and communities, working with industrial facilities required to comply with this law,
will be better able to protect public health and the environment.
Facilities subject to this reporting requirement must complete a Toxic Chemical Release Form R or Form A
(Certification Form) if certain criteria are met for specified chemicals. The appropriate form must be
submitted to EPA and those state officials designated by the governor. The report for any calendar year
must be submitted on or before July 1 of the following year. The first reporting period under this law was
calendar year 1987.
The purpose of this reporting requirement is to compile information to provide to the public and
government officials about routine releases of toxic chemicals into the environment. It is intended to
facilitate research and development of regulations, guidelines, standards, and pollution prevention.
The reporting requirement applies to owners and operators of facilities that:
1) Have 10 or more full-time employees,
2) Are in Standard Industrial Classification (SIC) codes 20 through 39 (i.e., manufacturing facilities),
and
3) Manufacture, import, process, or otherwise use a listed toxic chemical in excess of specified
threshold quantities.
Beginning with the 1991 reports, facilities also are required to provide information about pollution
prevention and source reduction activities. Data elements include quantities of the listed chemical recycled
and used for energy recovery on-site, quantities transferred off-site for recycling and energy recovery,
source reduction activities, and methods used to identify those activities. Availability of these data will
provide a more complete picture of total waste generation and management by facilities and will increase
the ability to track progress in moving towards less waste generation and safer management alternatives.
Companies must also provide a production activity ratio that will help relate changes in reported emissions
to changes in production.
The toxic chemicals subject to reporting initially consisted of chemicals listed for similar reporting
purposes by the States of New Jersey and Maryland. Now there are over 600 chemicals and categories on
these lists. Through rule making and petition, EPA can modify this combined list. These lists of toxic
chemicals and SIC codes are available in the Toxic Chemical Release Inventory Reporting Forms and
Instructions booklet.
March 23, 1999
1-1
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
The Toxics Release Inventory (TRI) is available from the US Government Printing Office (GPO) on both
CD-ROM and diskette, or from the National Technical Information Service (NTIS) on CD-ROM only.
TRI is also available on the GPO Bulletin Board and is accessible by GPO account holders. For more
information, call GPO at (202) 512-1800 (sales) or (202) 512-1530, or write GPO, 710 North Capitol
Street, N.W., Washington, DC 20401. To contact NTIS, call (703) 605-6000 or toll free at (800) 553-
6847 or write NTIS, 5285 Port Royal Road, Springfield, VA 22161. The NTIS Internet Website Address
is http://www.ntis.gov.
For information about online access to the TRI, call the National Library of Medicine (NLM) at (301) 496-
6531, or write TRI Representative, Specialized Information Services, NLM, 8600 Rockville Pike,
Bethesda, MD 20894.
The RTK NET (Right-to-Know Network), operated by the Unison Institute and OMB Watch (a non-profit
organization that monitors the actions and policies of the Office of Management and Budget), offers TRI
data online. For information, call RTK-Net at (202)797-7200, or write RTK-Net, 1742 Connecticut
Avenue, NW, Washington, DC 20009-1146.
March 23, 1999
1-2
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
1.1 About the RY97 TRI National File
The RY97 TRI National File contains release and transfer information, as well as source reduction and
recycling information. The data are presented in one consolidated file which contains releases and
transfers, source reduction and recycling activities, and source reduction and recycling activities methods.
The Toxic Release Inventory database is regularly updated to incorporate new submissions, revisions, and
deletions. The RY97 TRI National File contains only the information in the database at the time that the
official RY97 "snapshot" was created.
NOTE: We strongly recommend that you copy your original files before attempting to import
files. This action provides a backup copy of your data.
To save disk space, the TRI National data are stored in a compressed format that will decompress when
loaded on your computer. The naming conventions of the file are as follows: the first eight characters of
the file name is the word "NATIONAL" and the next three characters are the file type extension .EXE. In
its decompressed form, the name of the file is NATIONAL.DBF. The decompressed file will require at
least 20 times the space occupied by the compressed files. Section 2.0 contains the current record structure.
March 23, 1999
1-3
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
1.2 Source Reduction and Recycling Activities
Beginning with Reporting Year 1991, facilities are required to report their source reduction and recycling
activities. The amount (in pounds) of the chemical released, used for energy recovery, recycled, or treated
must be reported for a four year period: for the year prior to the reporting year, for the reporting year and
for the two years following the reporting year. These amounts are reported in Sections 8.1 through 8.7 on
the Form R.
The following abbreviations are used in the National file records to indicate the year and the type of
reduction and recycling reported. For example, the field named "PRV RCYON" would contain the
information reported by the facility for the previous year's recycling on-site activity for the subject
chemical.
Energy Recovery
On-site
Off-site
Energy Recycled
On-site
Off-site
Release Treatment
On-site
Off-site
Column Totals
Year 96
Years 96-97
Year 97
Year 98
Year 99
Previous
% Change
Reporting
Next
Future
(PRV)
(PCT)
(CUR)
(NXT)
(FUT)
PRV ENRON
PCT ENRON
CUR ENRON
NXT ENRON
FUT ENRON
PRV ENROFF
PCT ENROFF
CUR ENROFF
NXT ENROFF
FUT ENROFF
PRV RCYON
PCT RCYON
CUR RYCON
NXT RYCON
FUT RYCON
PRV RCYOFF
PCT RCYOFF
CUR RCYOFF
NXT RCYOFF
FUT RCYOFF
PRV REL
PCT REL
CUR REL
NXT REL
FUT REL
PRV TRTON
PCT TRTON
CUR TRTON
NXT TRTON
FUT TRTON
PRV TRTOFF
PCT TRTOFF
CUR TRTOFF
NXT TRTOFF
FUT TRTOFF
TOT PRVQTY
TOT CURQTY
TOT NXTQTY
TOT FUTQTY
PRV = PREVIOUS
FUT = FUTURE
REL = RELEASE
OFF = OFF-SITE
CUR = CURRENT
ENR = ENERGY
TRT = TREATED
QTY = QUANTITY
NXT = NEXT
RCY = RECYCLED
ON = ON-SITE
TOT = TOTAL
Facilities are required to indicate the actions taken to reduce the amount of the reported toxic chemical
released, used for energy recovery, recycled, or treated. These activities appear in Section 8.10 of the Form
R and in the National File records..
The following abbreviations are used in the National file records to indicate the source reduction activities
and the methods to identify the activities.
March 23, 1999
1-4
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
Source Reduction
Source Reduction
Source Reduction
Source Reduction
and Recycling
and Recycling
and Recycling
and Recycling
Activity Code
Activity Method
Activity Method
Activity Method
/and Activity Code
Code 1/ and Method
Code 2/ and Method
Code 3/ and Method
Description
Code 1 Description
Code 2 Description
Code 3 Description
Codes 1
S R A 001
SR_M 1 001
SR_M2_001
SR \I3 oo 1
Descriptions 1
SR Al) oo|
SR MID 001
SR M2D 001
SR \I3I) oo 1
Codes 2
SR_A_002
SR_M 1 002
SR_M2_002
SR_M3_002
Descriptions 2
SR AD 002
SR MID 002
SR M2D 002
SR \I3I) oo:
Codes 3
SR_A_003
SR_M 1 003
SR_M2_003
SR_M3_003
Descriptions 3
SR AD 003
SR MID 003
SR M2D 003
SR M3D 003
Codes 4
SR A 004
SR_M 1 004
SR_M2_004
SR \I3 oo4
Description 4
SR AD 004
SR MID 004
SR M2D 004
SR M3D 004
SR
= SOURCE REDUCTION
A
= ACTIVITY
AD
= ACTIVITY DESCRIPTION
Ml
= METHOD 1
MID
= METHOD 1 DESCRIPTION
001
= all fields associated with SOURCE REDUCTION ACTIVITY CODE 1
002
= all fields associated with SOURCE REDUCTION ACTIVITY CODE 2
003
= all fields associated with SOURCE REDUCTION ACTIVITY CODE 3
004
= all fields associated with SOURCE REDUCTION ACTIVITY CODE 4
March 23, 1999
1-5
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
1.3 Conventions in this Document
This document uses conventions for user understanding, consistency, and efficiency. They include
formatting for keystroke entry.
Keystroke entry refers to any character typed by the user. The types of keystroke entry include function
key, user input, and actual input. All keystrokes are set apart from the text by the greater than and less
than symbols, < >.
a. Action keys are preceded by the word "press" and are displayed in bold, uppercase letters
(e.g., press ).
1. Function keys that are pressed simultaneously are written with a forward slash, "/,"
separating them (e.g., /).
2. Function keys that are pressed sequentially are written with a space separating them
(e g , < >).
b. User input keystrokes are varied (e.g., a user password). The word "type" precedes these
keystrokes. In addition, these keystrokes are displayed in bold, italics, and small caps
(e.g., "Type the ").
c. Actual input keystrokes are exact characters that must be input (e.g., the letter Y for a yes
entry). The word "type" usually precedes these keystrokes. In addition, these keystrokes
are displayed in bold, italics, and all small capital letters (e.g., type for "Yes").
March 23, 1999
1-6
Facts About the Toxics Release Inventory
-------
TRI National File Documentation
2.0 Field Description
The record structure for the National File of TRI Environmental Releases and Transfers and Source
Reduction and Recycling Activities is provided. The codes and definitions used in the following records are
listed in the Toxic Release Inventory Reporting Forms and Instructions booklet. Under the column named
Type, C = character and N = numeric.
Field Name
TRI ID
FACILITY
FACIL ADD
CITY
COUNTY
ST
ZIP C
ZIP4
LINK FID
MSTREETl
M CITY
MSTATE
M ZIP
FAC TYPE
Length Type Description
15 C Facility identification in the format
zzzzznnnnnsssss where usually zzzzz =
facility zip code, nnnnn = first five
consonants of the name, and sssss = first five
non-special characters in the street address.
NOTE: The TRI ID is not changed to
match facility ownership, or zip code
changes.
30 C Name of the reporting facility.
30 C Street address of the reporting facility.
25 C City in which the reporting facility is located.
25 C County in which the reporting facility is
located.
2 C Two-letter state code of the reporting facility.
5 C Five-digit ZIP of the reporting facility.
4 C Last four digits where a nine-digit ZIP has
been reported by the facility.
15 C Federal Facility TRIFID associated with a
Government Owned Contractor Operated
(GOCO) Facility.
30 C Street of the reporting facility's mailing
address.
25 C City of the reporting facility's mailing
address.
2 C State of the reporting facility's mailing
address.
9 C Zip code of the reporting facility's mailing
address.
1 C Code indicating whether a facility is Federal
(F), Commercial (C), or Government Owned
Contractor Operated (G) .
March 23, 1999
2-1
Field Descriptions
-------
TRI National File Documentation
Field Name
PUBLIC CON
TELEPHONE
PARENT
PAR DUN
DUNS_NUM
EPA ID
NPDES
UIC ID
SIC
LAT
LONG
PREFER LAT
Length Type Description
45 C Name of the individual whom the public may
contact if clarification of data is needed.
10 C Area code and telephone number of the
public contact.
45 C Name of the corporation or other business
entity that owns or controls the reporting
facility.
9 C Unique identification number assigned by
Dun and Bradstreet to the parent company of
the reporting facility.
9 C Unique identification number assigned by
Dun and Bradstreet to the reporting facility.
12 C Twelve-digit alphanumeric identifier assigned
by EPA under the Resource Conservation
and Recovery Act.
9 C Nine-digit alphanumeric identifier assigned to
a facility under EPA's National Pollutant
Discharge Elimination System.
12 C Underground injection identification number,
assigned by EPA or the state, to a facility
which injects chemical waste into class 1
deep wells.
4 C Four-digit Standard Industrial Classification
(SIC) Code.
10 C Reported latitude of the reporting facility
converted into decimal degrees (Format:
signed 2 digit whole number, 6 digit decimal
positions +nn.nnnnnn).
11 C Reported longitude of the reporting facility
converted into decimal degrees. (Format:
signed 2 digit whole number, 6 digit decimal
positions +nn.nnnnnn).
10 N EPA assigned preferred latitude of the
reporting facility in decimal degrees (Format:
signed 2 digit whole number, 6 digit decimal
positions +nn.nnnnnn). This may be the
FormR submitted data, or another value if the
FormR data was found to be suspect, or zero
(if zero, use the submitted value).
March 23, 1999
2-2
Field Descriptions
-------
TRI National File Documentation
Field Name Length Type
PREFER LON 11 N
PREFER AC 9 N
PREFER CM 2 N
PREFER DC 2 C
Description
EPA assigned preferred longitude of the
reporting facility in decimal degrees (Format:
signed 3 digit whole number, 6 digit decimal
positions +nnn nnnnnn) This may be the
FormR submitted data, or another value if the
FormR data was found to be suspect, or zero
(if zero, use the submitted value).
Value is a range (+/-) in meters of the latitude
and longitude accuracy. (Format: signed 5
digit whole number, 2 digit decimal positions
+nnnnn.nn)
Method used to determine the latitude and
longitude. Collection method code for the
preferred coordinate (as specified in MAD
code)
A1 ADDRESS MATCHINGZHOUSE
NUMBER
A2 ADDRESS MATCHINGZBLOCK
FACE
C2 CENSUS BLOCK/GROUP-1990-
CENTROID
C3 CENSUS BLOCK TRACT-1990-
CENTROID
G3 GPS CODE MEASUREMENTS
(PSEUDO RANGE) DIFFERENTIAL
(DGPS)
G4 GPS CODE MEASUREMENTS
(PSEUDO RANGE) PRECISE
POSITIONING SERVICE
11 INTERPOLATION-MAP
12 INTERPOLATION-PHOTO
OT OTHER
Z1 ZIPCODE-CENTROID
UN UNKNOWN
EPA's preferred geographic coordinate
description category. Describes the category
of feature referenced by the latitude and
longitude. Description category of the
preferred coordinate (as specified in MAD
code)
PG PLANT ENTRANCE (GENERAL)
FC FACILITY CENTROID
CE CENTER OF FACILITY
OT OTHER (Describe or name in
description comments)
UN UNKNOWN
March 23, 1999
2-3
Field Descriptions
-------
TRI National File Documentation
Field Name Length Type
PREFER HD 1 C
PREFER SS 1 C
PREFER QA 4 C
Description
EPA's preferred geographic coordinate
horizontal datum. Reference datum of the
latitude and longitude. Horizontal datum of
the preferred coordinate (as specified in
MAD code)
1 NAD27
2 NAD83
O OTHER
U UNKNOWN
EPA's preferred geographic coordinate source
map scale. Scale of the source used to
determine the latitude and longitude. Source
map scale of the preferred coordinate (as
specified in MAD code)
E 1:24,000
J 1:100,000
Results of four quality assurance tests. It
follows the current format for PREFERRED-
QA-CODE in TRIS-PREFERRED-
LOCATION, except for the fourth position.
First position: Point location was checked
against ZIP code polygon of zip in address
field or TRI facility ID (approximated by a
rectangle with an additional 2 km buffer
surrounding it):
0 Test was not performed
1 Test was performed and coordinates
passed
2 Test was performed and coordinates
failed
Second position: Point location was checked
against 25 km radius of ZIP code centroid of
zip in address field or TRI facility ID
(generally performed only if zip polygon test
was not possible or likely to yield erroneous
results, e.g. for rural zip codes):
0 Test was not performed
1 Test was performed and coordinates
passed
2 Test was performed and coordinates
failed
March 23, 1999
2-4
Field Descriptions
-------
TRI National File Documentation
Field Name
Length Type Description
FIPS
RY
CHEM NAME
4
70
Third position: Point location was compared
to an alternate coordinate of known accuracy
(e.g. below about 600m). If alternate
coordinates were located within a 2 km buffer
of submitted coordinates, the latter were
accepted and assigned the estimated accuracy
of the alternate coordinates. If the alternate
coordinates were outside the buffer, the
alternates were selected. If an alternate
coordinate was selected as preferred, it
should always have a value of 1 (while the
corresponding submitted coordinates would
have a value of 2).
0 Test was not performed
1 Test was performed and coordinates
passed
2 Test was performed and coordinates
failed
The fourth position contains one of the
following five values:
0 No manual verification was done
V Manual verification was done
1 Manual verification was done, and no
preferred coordinate could be selected
A Manual verification was done, and its
result agrees with the preferred
coordinate generated by the automated
selection process
D Verification was done, and its result
disagrees with the preferred coordinate
generated by the automated selection
process (manually verified coordinate
was selected as the preferred value)
C Five-digit FIPS code with the format ssccc,
where ss is the state code and ccc is the
county code. The source is the Federal
Information Processing Standards, FIPS PUB
6-4.
C Calendar year in which the reported activities
occurred.
C Name of the chemical or generic name if the
chemical is claimed as a trade secret.
March 23, 1999
2-5
Field Descriptions
-------
TRI National File Documentation
Field Name Length Type
TRICHM ID 9 C
DCN 15 C
Description
Chemical Abstracts Service (CAS) Registry
Number for that unique chemical, or category
code (for compounds).
NOTE: CAS number 999999999 is for
sanitized trade secret submissions;
CHEM NAME displays the reported generic
chemical name.
Unique identification number assigned to
each submission by EPA. Format:
TTYYNNNNNNNNCSS, where
TT = document type
YY = reporting year
NNNNNNNN= sequential number
C = a check digit
SS = state code.
FORM TYPE 1 N
FUGITIVEA 12 N
STACK AIR 12 N
WATER 12 N
UI1 12 N
An indicator identifying whether Form R or
Certification Statement was submitted.
R = Form R
C = Certification Statement.
Sum reported in pounds of total releases to
the air that is not released through stacks,
vents, ducts, pipes, or any other confined air
stream.
Sum reported in pounds of total releases to
the air through stacks, vents, ducts, pipes, or
any other confined air stream.
Sum reported in pounds of total releases to
all receiving streams.
Sum reported in pounds of total releases by
Underground Injection on-site in Class I
wells.
UI2
12 N Sum reported in pounds of total releases by
Underground Injection on-site in Class II-V
wells.
C LANDFILL
12 N Sum reported in pounds of total releases to
RCRA Subtitle C landfills.
0 LANDFILL
12 N Sum reported in pounds of total releases to
other landfills.
March 23, 1999
2-6
Field Descriptions
-------
TRI National File Documentation
Field Name
FARM TRMTC
SURF COMPX
Length Type Description
12 N Sum reported in pounds of total releases to
land treatment/application/farming
12 N Sum reported in pounds of total releases to
surface impoundment.
OTHERLANDF
POTW
OTHER OFF
OTHER DISP
OTHER ENER
OTHER RECY
OTHER TRMT
CUR RELS
CUR ENRON
CUR ENROFF
CUR RCYON
12 N Sum reported in pounds of total releases to
other disposal means.
12 N Sum reported in pounds of total of transfers
off-site to publicly owned treatment works.
12 N Sum reported in pounds of total of toxic
chemicals, including those without valid
waste management codes, transferred by
reporting facility to off-site locations for the
purposes of waste treatment, disposal,
recycling, and energy recovery.
12 N Sum reported in pounds of toxic chemicals
transferred by reporting facility to off-site
location(s) for disposal.
12 N Sum of toxic chemicals transferred by
reporting facility to off-site location(s) for
energy recovery.
12 N Sum reported in pounds of toxic chemicals
transferred by reporting facility to off-site
location(s) for recycling.
12 N Sum reported in pounds of toxic chemicals
transferred by reporting facility to off-site
location(s) for treatment.
14 N Sum reported in pounds of total quantity of
toxic chemical released (including off-site
disposal) during reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical used on-site for energy
recovery during reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical sent off-site for energy
recovery during the reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical recycled on-site during
reporting year.
March 23, 1999
2-7
Field Descriptions
-------
TRI National File Documentation
CUR RCYOFF
CUR TRTON
CUR TRTOFF
PRY RELS
PRY ENRON
PRY ENROFF
PRY RCYON
PRY RCYOFF
PRY TRTON
PRY TRTOFF
NXT RELS
NXT ENRON
NXT ENROFF
14 N Sum reported in pounds of total quantity of
toxic chemical sent off-site for recycling
during reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical treated on-site during the
reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical sent off-site for treatment
(including transfers to POTWs) during the
reporting year.
14 N Sum reported in pounds of total quantity of
the toxic chemical released (including off-site
disposal) during previous year.
14 N Sum reported in pounds of total quantity of
toxic chemical used on-site for energy
recovery during the previous year.
14 N Sum reported in pounds of total quantity of
toxic chemical sent off-site for energy
recovery during previous year.
14 N Sum reported in pounds of total quantity of
toxic chemical recycled on-site during the
previous year.
14 N Sum reported in pounds of total quantity of
toxic chemical sent off-site for recycling
during the previous year.
14 N Sum reported in pounds of total quantity of
toxic chemical treated on-site during the
previous year.
14 N Sum reported in pounds of total quantity of
the toxic chemical treated off-site during the
previous reporting year.
14 N Sum reported in pounds of total quantity of
the toxic chemical projected to be released
(including off-site disposal) in the first year
following the reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical projected to be used on-site
for energy recovery in first year following
reporting year.
14 N Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
energy recovery in first year following
reporting year.
March 23, 1999
2-8
Field Descriptions
-------
TRI National File Documentation
NXTRCYON 14 N
NXT RCYOFF 14 N
NXT TRTON 14 N
NXT TRTOFF 14 N
FUT RELS 14 N
FUT ENRON 14 N
FUT ENROFF 14 N
FUT RCYON 14 N
FUT RCYOFF 14 N
FUT TRTON 14 N
FUT TRTOFF 14 N
Sum reported in pounds of total quantity of
toxic chemical projected to be recycled on-
site in first year following reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
recycling in first year following reporting
year.
Sum reported in pounds of total quantity of
toxic chemical projected to be treated on-site
in the first year following the reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
treatment (including transfer to POTWs) in
the first year following the reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be released
(including off-site disposal) in second year
following reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be used on-site
for energy recovery in second year following
reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
energy recovery in second year following
reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be recycled on-
site in second year following reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
energy recovery in second year following
reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be treated on-site
in second year following reporting year.
Sum reported in pounds of total quantity of
toxic chemical projected to be sent off-site for
treatment (including transfers to POTWs) in
second year following reporting year.
March 23, 1999
2-9
Field Descriptions
-------
TRI National File Documentation
ACCIDT REL 14 N
PROD RATIO 8 N
PCTRELSf 12 N
PCT ENRONf 12 N
PCTENROFFf 12 N
PCT RCYONf 12 N
PCT RCYOFFf 12 N
PCT TRTONf 12 N
Sum reported in pounds of total quantity of
toxic chemical released to the environment or
transferred off-site due to events not
associated with routine production processes.
Reported as pounds.
Ratio of production or activity in the
reporting year divided by production or
activity in the previous year. Field length is
in the format of +nnnn.nn.
Percent change in quantity of toxic chemical
released (including off-site disposal) from
previous to reporting year. Field length of 12
= 8 whole digits plus 2 decimal places, one
decimal point and one sign, in the format
+nnnnnnnn .NN.
Percent change in quantity of toxic chemical
used on-site for energy recovery comparing
previous and reporting year quantities. Field
length of 12 = 8 whole digits plus 2 decimal
places, one decimal point and one sign, in the
format +nnnnnnnn.NN.
Percent change in quantity of toxic chemical
sent off-site for energy recovery comparing
reporting and previous year quantities. Field
length of 12 = 8 whole digits plus 2 decimal
places, one decimal point and one sign, in the
format +nnnnnnnn.NN..
Percent change in quantity of toxic chemical
used on-site for recycling purposes
comparing previous and reporting year
quantities. Field length of 12 = 8 whole digits
plus 2 decimal places, one decimal point and
one sign, in the format +nnnnnnnn.NN.
Percent change in quantity of toxic chemical
sent off-site for recycling purposes
comparing previous and reporting year
quantities. Field length of 12 = 8 whole
digits plus 2 decimal places, one decimal
point and one sign in the format
+nnnnnnnn .NN.
Percent change in quantity of toxic chemical
treated on-site comparing previous and
reporting year quantities. Field length of 12
= 8 whole digits plus 2 decimal places, one
decimal point and one sign, in the format
+nnnnnnnn .NN.
March 23, 1999
2-10
Field Descriptions
-------
TRI National File Documentation
PCTTRTOFFf 12 N Percent change in quantity of toxic chemical
treated off-site comparing previous and
reporting year quantities. Field length of 12
= 8 whole digits plus 2 decimal places, one
decimal point and one sign, in the format
+nnnnnnnn .NN.
f This percentage increase field reads 0.0 if a quantity has been given for the current reporting year, but
no quantity exists for the corresponding previous reporting year field.
TOT CURQTY 16 N
TOT PRVQTY 16 N
TOT NXTQTY 16 N
TOT FUTQTY 16 N
Sum reported in pounds of the quantities of the
toxic chemical released (including off-site
disposal), treated, used for energy recovery, or
recycled in the reporting year.
Sum reported in pounds of the quantities of the
toxic chemical released (including off-site
disposal), treated, used for energy recovery, or
recycled in the year prior to the reporting year.
Sum reported in pounds of the quantities of the
toxic chemical projected to be released
(including off-site disposal), treated, used for
energy recovery, or recycled in the first year
following the reporting year.
Sum reported in pounds of the quantities of the
toxic chemical projected to be released
(including off-site disposal), treated, used for
energy recovery, or recycled in the first year
following the reporting year.
SR_A_001 3 C Activity code indicating the action taken to
reduce the amount of the reported toxic
chemical released, used for energy recovery,
recycled, or treated.
SR_AD_001 80 C Description of the preceding source reduction
activity code.
SR_M1_001 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M1D_001 80 C Description of the preceding source reduction
activity method code.
March 23, 1999
2-11
Field Descriptions
-------
TRI National File Documentation
SR_M2_001 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M2D_001 80 C Description of the preceding source reduction
activity method code.
SR_M3_001 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M3D_001 80 C Description of the preceding source reduction
activity method code.
SR_A_002 3 C Activity code indicating the action taken to
reduce the amount of the reported toxic
chemical released, used for energy recovery,
recycled, or treated.
SR_AD_002 80 C Description of the preceding source reduction
activity code.
SR_M1_002 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M1D_002 80 C Description of the preceding source reduction
activity method code.
SR_M2_002 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M2D_002 80 C Description of the preceding source reduction
activity method code.
SR_M3_002 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M3D_002 80 C Description of the preceding source reduction
activity method code.
SR_A_003 3 C Activity code indicating the action taken to
reduce the amount of the reported toxic
chemical released, used for energy recovery,
recycled, or treated.
SR_AD_003 80 C Description of the preceding source reduction
activity code.
March 23, 1999
2-12
Field Descriptions
-------
TRI National File Documentation
SR_M1_003 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M1D_003 80 C Description of the preceding source reduction
activity method code.
SR_M2_003 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M2D_003 80 C Description of the preceding source reduction
activity method code.
SR_M3_003 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M3D_003 80 C Description of the preceding source reduction
activity method code.
SR_A_004 3 C Activity code indicating the action taken to
reduce the amount of the reported toxic
chemical released, used for energy recovery,
recycled, or treated.
SR_AD_004 80 C Description of the preceding source reduction
activity code.
SR_M1_004 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M1D_004 80 C Description of the preceding source reduction
activity method code.
SR_M2_004 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M2D_004 80 C Description of the preceding source reduction
activity method code.
SR_M3_004 3 C Code corresponding to the internal or external
method (or the information sources) used to
identify the source reduction activity
implementation at a facility.
SR_M3D_004 80 C Description of the preceding source reduction
activity method code.
March 23, 1999
2-13
Field Descriptions
-------
TRI National File Documentation
Total record length is 2620
March 23, 1999
2-14
Field Descriptions
-------
TRI National File Documentation
3.0 Hardware and Software Requirements
The Hardware and Software Requirements section contains information concerning hardware and software
requirements for using RY97 TRI National File data. The RY97 TRI National File data are available in a
self-extracting file format (.EXE) that contains the compressed dBASE files. The user types the name of
the .EXE file and the system will extract the data files and decompress them.
The following are the minimum IBM-compatible hardware specifications:
• 512K conventional memory,
DOS 3.0 or higher, and
Hard disk drive or dual floppy drives.
The following types of software may be used (depending on your hardware):
• dBASE III+, dBASE IV, or higher; or
• Excel version 2.1 or higher; or
• Foxbase version 2.0 or higher; or
any other software package running under DOS or Microsoft Windows (e.g., Paradox,
Microsoft Access, QuattroPro, Microsoft Excel) that can read/access .DBF formats.
NOTE: For Help, call ATRS(Automated TRI Reporting Software) Technical Support at
(703) 816-4434.
3.1 Instructions for using TRI with Popular Software Packages
The following pages contain instructions for loading TRI data into several of the more popular software
packages. In order to prevent damage to your files or loss of data while loading or using the TRI data, it is
recommended that you create a backup copy and put the original diskettes away for safekeeping before
proceeding.
3.2 Loading TRI (.DBF) Files into Excel
The following procedure contains instructions for loading TRI files into an Excel spreadsheet after
decompressing the files as instructed in the READXX file.
NOTE: This assumes any compressed files have been expanded into a DBF file. Do not use the
original TRI file(s) in case of damage to file or loss of data. Copy the original TRI
file(s) onto diskettes or into the EXCEI directory on your hard disk drive. Copying
files is not mandatory for creating a database, but is recommended to prevent loss of
original data.
1. Insert the diskette (duplicate copy) if you are using diskettes.
March 23 1999
3-1
Hardware & Software Requirements
-------
TRI National File Documentation
2. After Excel is accessed, select File, then select Open.
3. Under File name, select the name of the file you wish to open. If it is not listed, type the
file name including the disk drive and direction in which the file resides.
4. Under Files of type, select dBase Files (X.DBF).
5. Select Open.
NOTE: For Help, callATRS Technical Support at (703) 816-4434.
3.3 Loading TRI (.DBF) files into dBASE IV using the dBASE IV Assist
Menu
The following procedure contains instructions for loading TRI (.DBF) files into the dBASE IV spreadsheet
using the dBASE IV Assist Menu.
NOTE: Do not use the original TRIfile(s) in case of damage to file or loss of data. Copy the
original TRIfile(s) onto diskettes or into the dBASE directory on your hard disk drive.
Copying files is not mandatory for creating a database, but is recommended to prevent
loss of original data.
1. Insert the diskette (duplicate copy) if you are using diskettes.
2. After dBASE IV is accessed, select the CATALOG option (press the and
keys simultaneously).
3. Press < > to highlight the ADD A FILE TO CATALOG option. Then press .
4. Press (to change default drive of files location).
5. Press < > to highlight the corresponding DISK DRIVE where the TRI file is located.
Then press .
6. Press < > to highlight the TRI FILENAME. Then press .
7. Either: (1) type a description of your .DBF file being used; or,
(2) press for no description of your .DBF file.
NOTE:
For Help, callATRS Technical Support at (703) 816-4434.
March 23 1999
3-2
Hardware & Software Requirements
------- |