Document ID: EPA-HQ-OW-2003-0074-0412
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-12-31T05:00Z

TRIReleases2000
Data
Dictionary
Prepared
for:

U.
S.
Environmental
Protection
Agency
Engineering
and
Analysis
Division
Office
of
Water
1200
Pennsylvania
Avenue
Washington
DC
20460
Prepared
by:

ERG,
Inc.
14555
Avion
Parkway
Suite
200
Chantilly,
VA
20151­
1102
12
December
2003
EPA
Contract
No.
68­
C02­
095
Work
Assignment
1­
05
i
TABLE
OF
CONTENTS
Page
1.0
INTRODUCTION
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
1
2.0
TABLE
DESCRIPTIONS
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
2
3.0
QUERY
DESCRIPTIONS
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
22
1
1.0
INTRODUCTION
This
data
element
dictionary
provides
documentation
of
the
data
contained
in
the
TRIReleases2000
Microsoft
AccessTM
database
used
for
the
analysis
of
Toxics
Release
Inventory
(
TRI)
data.
A
description
of
the
analysis,
as
well
as
a
summary
of
the
data,
is
provided
in
the
report
entitled
Evaluation
of
RSEI
Model
Runs,
dated
December
12,
2003.
A
copy
of
the
database
is
included
in
the
public
docket
(
DCN
00664,
Section
2.1.1).

In
TRI,
facilities
report
annual
loads
(
in
pounds
or
grams)
of
toxic
chemicals
or
chemical
categories
discharged
either
directly
to
a
receiving
stream
or
transferred
to
a
POTW.
For
facilities
discharging
directly
to
a
stream,
the
loads
were
taken
directly
from
the
reported
TRI
data
for
calendar
year
2000.
For
facilities
that
transfer
toxic
chemicals
to
POTWs,
EPA
first
adjusted
the
TRI
pollutant
loads
reported
to
be
transferred
to
POTWs
to
account
for
pollutant
removal
that
occurs
at
the
POTW
prior
to
discharge
to
the
receiving
stream.
This
adjustment
was
made
using
POTW
removal
efficiencies
from
EPA's
Risk
Screening
Environmental
Indicators
(
RSEI)
model
(
see
Section
2.1.1
of
the
docket
for
more
information
on
TRI
and
the
RSEI
model).
These
data
are
compiled
in
the
Microsoft
Access
 
database
entitled
TRIReleases2000.
As
further
study
was
conducted
on
the
TRI
data,
some
corrections
were
made.
A
summary
of
the
corrections
is
included
in
an
addendum
to
the
Evaluation
of
RSEI
Model
Runs
report.

Section
2.0
provides
a
listing
of
all
the
tables
in
the
TRIReleases2000
database,
as
well
as
field
names
and
field
descriptions
for
each
table.
Section
3.0
includes
a
listing
and
description
of
all
the
primary
queries
run
with
the
TRIReleases2000
database
as
part
of
EPA's
initial
screening­
level
analyses.
2
2.0
TABLE
DESCRIPTIONS
The
tables
included
in
the
TRIReleases2000
database
are
listed
below.
A
brief
description
of
the
table
is
followed
by
a
listing
of
the
field
names
and
field
descriptions.
Several
of
the
tables
include
data
extracted
from
the
2000
Public
Data
Release
of
TRI.
These
tables
are
"
TRI
Section
1
to
4"
and
"
TRI
Section
7A".
Further
explanation
of
TRI
variables
can
be
found
in
Toxic
Chemical
Release
Inventory
Reporting
Forms
and
Instruction,
located
on
the
EPA
website
(
http://
www.
epa.
gov/
tri/
report/
rfifinal2002603.
pdf).
The
remaining
tables
were
generated
for
use
in
screening
industrial
discharges
for
the
Clean
Water
Act
(
CWA)
preliminary
Effluent
Guidelines
Plan
for
2004/
2005.

40
CFR
Parts
and
SIC
Groups
This
table
relates
point
source
categories
to
regulations
listed
in
40
CFR
by
part
number.
In
the
case
where
SIC
codes
are
not
associated
with
a
regulation,
the
point
source
category
field
is
populated
with
a
2­
or
4­
digit
SIC
code
and
the
40
CFR
Part
field
is
populated
with
the
name
of
that
SIC
group.

Number
of
Records:
99
Field
Name
Field
Description
40
CFR
Part
40
Code
of
Federal
Regulations
Part,
2­
digit
SIC
grouping,
or
4­
digit
SIC
grouping
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Census
Counts
by
SIC
This
table
provides
the
number
of
facilities
that
were
reported
to
the
1997
US
Economic
Census
for
each
4­
digit
SIC
code.

Number
of
Records:
404
Field
Name
Field
Description
#
of
Facilities
97Census
The
number
of
facilities
reporting
a
specific
Standard
Industrial
Classification
code
in
"
Summary
Statistics
by
SIC"
in
the
1997
Economic
Census
Primary
SIC
Code
Primary
4­
digit
Standard
Industrial
Classification
Code
SIC
Description
Primary
4­
digit
Standard
Industrial
Classification
Description
3
Chem
Crosswalk
This
table
provides
a
list
of
chemicals
from
EPA's
RSEI
model,
whether
toxicity
data
are
available
in
RSEI,
the
source
of
the
toxicity
data,
and
Toxic
Weighting
Factors
(
TWFs)
for
each
chemical.
The
TWFs
were
assigned
by
EPA
Office
of
Water's
(
OW)
Engineering
and
Analysis
Division
(
EAD).
The
TWFs
measure
the
toxicity
of
the
pollutant
relative
to
copper,
and
take
into
account
chronic
freshwater
aquatic
criteria
as
well
as
human
health
criteria
based
on
fish
consumption.
For
the
30
TRI
chemical
compound
categories,
EPA
could
not
use
CAS
Numbers
to
identify
matching
compounds
to
assign
EAD
TWFs.
For
these
categories,
a
representative
chemical
was
chosen.
More
information
on
the
assignment
of
representative
chemicals
can
be
found
in
Evaluation
of
RSEI
Model
Runs
,
dated
December
12,
2003.

Number
of
Records:
612
Field
Name
Field
Description
CAS
Number
Chemical
Abstracts
Service
Number
from
TRI,
which
includes
TRI
group
numbers
for
TRI
chemical
groups
Chemical
Name
Chemical
Name
HasTox
Indication
of
whether
toxicity
information
is
available
in
RSEI
OW
Chemical
CASNO
Chemical
Abstracts
Service
number
for
TRI
chemicals
and
for
representative
chemicals
for
TRI
chemical
group.

OW
Chemical
Name
OW
Chemical
Name
OW
TWF
OW
EAD
Toxic
Weighting
Factor
Toxicity
Based
On
Source
of
toxicity
information
Count
Both
by
SIC
This
table
provides
a
count
of
the
number
of
TRI
facilities
that
reported
both
direct
and
indirect
discharges
for
reporting
year
2000.

Number
of
Records:
200
Field
Name
Field
Description
#
Both
Number
of
facilities
that
reported
both
direct
and
indirect
discharges
in
2000
SICCode1
Primary
4­
digit
Standard
Industrial
Classification
Code
4
Count
Directs
by
SIC
This
table
provides
a
count
of
the
number
of
TRI
facilities
that
reported
direct
discharges
in
reporting
year
2000.

Number
of
Records:
298
Field
Name
Field
Description
#
Directs
Number
of
facilities
that
reported
direct
discharges
in
2000
SICCode1
Primary
4­
digit
Standard
Industrial
Classification
Code
Count
Dischargers
by
SIC
This
table
provides
a
count
of
the
number
of
TRI
facilities
that
reported
either
direct
or
indirect
discharges
for
the
year
2000.

Number
of
Records:
405
Field
Name
Field
Description
#
Dischargers
Number
of
facilities
that
reported
either
direct
or
indirect
discharges
in
2000
SICCode1
Primary
4­
digit
Standard
Industrial
Classification
Code
Count
Indirects
by
SIC
This
table
provides
a
count
of
the
number
of
TRI
facilities
that
reported
indirect
discharges
for
reporting
year
2000.

Number
of
Records:
368
Field
Name
Field
Description
#
Indirects
Number
of
facilities
that
reported
indirect
discharges
in
2000
SICCode1
Primary
4­
digit
Standard
Industrial
Classification
Code
5
Count
of
All
TRI
by
SIC,
Final
This
table
presents
the
sums
of
the
counts
from
the
"
Count
of
All
TRI,
Step1"
table
for
each
SIC
code
to
provide
a
total
number
of
TRI
Form
Rs
submitted
in
2000
associated
with
each
primary
4­
digit
SIC
code.

Number
of
Records:
507
Field
Name
Field
Description
#
TRI
Form
R's
Number
of
TRI
Form
R's
submitted
SIC
Code
Primary
4­
digit
Standard
Industrial
Classification
Code
Count
of
All
TRI,
Step
1
This
table
is
an
intermediate
step
for
the
"
Counts
of
All
TRI
by
SIC,
Final"
table.
This
table
provides
ungrouped
counts
of
the
number
of
TRI
Form
Rs
submitted
in
2000
associated
with
each
primary
4­
digit
SIC
code.

Number
of
Records:
876
Field
Name
Field
Description
CountOf#
TRI
Form
Rs
Count
of
the
number
of
TRI
Form
Rs
SIC
Code
Primary
4­
digit
Standard
Industrial
Classification
Code
Counts
of
Facilities
by
PSC
(
final)

This
table
provides
the
number
of
facilities
(
direct,
indirect,
both
direct
and
indirect,
total
dischargers
and
all
(
including
non
dischargers))
in
TRI
2000,
as
well
as
the
1997
Economic
Census
counts
for
each
point
source
category
or
SIC
code
grouping.
This
table
includes
the
40
CFR
Part
number
or
the
SIC
grouping.
This
table
is
created
by
query
"
Make
Counts
of
Facilities
by
PSC
07
(
final)"
from
table
"
Count
of
Facilities
by
PSC
(
Step
1)"
by
grouping
all
information
about
each
point
source
category.

Number
of
Records:
81
Field
Name
Field
Description
1997
Economic
Census
The
number
of
facilities
reporting
a
specific
Standard
Industrial
Classification
code
in
"
Summary
Statistics
by
SIC"
in
the
1997
Economic
Census
2000
TRI
All
Total
number
of
facilities
reporting
to
TRI
Field
Name
Field
Description
6
2000
TRI
Both
Number
of
facilities
reporting
both
direct
and
indirect
discharges
2000
TRI
Directs
Number
of
facilities
reporting
direct
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Indirects
Number
of
facilities
reporting
indirect
transfers
to
POTWs
to
TRI
in
calendar
year
2000
2000
TRI
Total
Dischargers
Total
number
of
facilities
reporting
discharges
to
TRI
in
calendar
year
2000
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
SIC
Description
Primary
4­
digit
Standard
Industrial
Classification
Description
Counts
of
Facilities
by
PSC
(
step
1)

This
table
is
an
intermediate
step
for
the
"
Counts
of
Facilities
by
PSC
(
final)"
table.
This
table
provides
the
number
of
TRI
indirect,
direct,
both
direct
and
indirect,
total
(
all
dischargers)
and
all
(
the
count
of
all
TRI
facilities
includes
facilities
that
do
not
discharge
wastewater)
facilities
for
the
year
2000
as
well
as
the
1997
Economic
Census
counts
for
each
point
source
category
or
SIC
grouping.
This
table
is
created
by
queries
"
Make
Counts
of
Facilities
by
PSC
01"
to
"
Make
Counts
of
Facilities
by
PSC
06."

Number
of
Records:
88
Field
Name
Field
Description
1997
Economic
Census
The
number
of
facilities
reporting
a
specific
Standard
Industrial
Classification
code
in
"
Summary
Statistics
by
SIC"
in
the
1997
Economic
Census
2000
TRI
All
Total
number
of
facilities
reporting
to
TRI
2000
TRI
Both
Number
of
facilities
reporting
both
direct
and
indirect
discharges
2000
TRI
Directs
Number
of
facilities
reporting
direct
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Indirects
Number
of
facilities
reporting
indirect
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Total
Dischargers
Total
number
of
facilities
reporting
discharges
to
TRI
in
calendar
year
2000
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
SIC
Description
Primary
4­
digit
Standard
Industrial
Classification
Description
7
Counts
of
Facilities
by
SIC
This
table
provides
the
number
of
TRI
facilities
(
direct,
indirect,
both
direct
and
indirect,
total
(
only
dischargers),
and
all
(
including
non­
dischargers))
for
each
4­
digit
SIC
code.
It
is
created
by
the
query
"
Make
Counts
of
Facilities
by
SIC
01."

Number
of
Records:
405
Field
Name
Field
Description
1997
Economic
Census
The
number
of
facilities
reporting
a
specific
Standard
Industrial
Classification
code
in
"
Summary
Statistics
by
SIC"
in
the
1997
Economic
Census
2000
TRI
All
Total
number
of
facilities
reporting
to
TRI
2000
TRI
Both
Number
of
facilities
reporting
both
direct
and
indirect
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Directs
Number
of
facilities
reporting
direct
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Indirects
Number
of
facilities
reporting
indirect
discharges
to
TRI
in
calendar
year
2000
2000
TRI
Total
Dischargers
Number
of
facilities
reporting
discharges
to
TRI
in
calendar
year
2000
Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category
Point
Source
3
The
third
Point
Source
Category
Point
Source
4
The
fourth
Point
Source
Category
SICCode1
4­
digit
Standard
Industrial
Classification
Code
New
MPM
Ranking
Values
This
table
is
created
by
query
"
Prerank
06
­
Make
New
MP&
M
Ranking
Values"
and
returns
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
all
chemicals
in
the
Metal
Products
and
Machinery
point
source
category.
8
Number
of
Records:
1
Field
Name
Field
Description
SumOfSumOfFullModel
The
risk­
related
score
computed
by
RSEI
for
chemicals,
for
which
all
required
model
input
parameters
are
present.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

SumOfSumOfModeledPoundsTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical
SumOfSumOfTotalTRIPounds_
Discharged
Quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)

SumOfSumOfTotalTRIPoundsWToxTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical
SumOfSumOfTWF
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs).
TWF
Hazard
is
the
product
of
the
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.

Point
Source
Rankings
w/
POTW
Removals
­
Step1
This
table
is
created
by
query
"
Rank
02
­
Make
Point
Source
Rankings
­
1"
and
is
updated
by
subsequent
queries
for
each
point
source
category.
The
query
provides
discharge
information
(
pounds
discharged,
toxic
weighted
pounds,
etc)
for
each
point
source
category
and
SIC
grouping.

Number
of
Records:
84
Field
Name
Field
Description
Full_
Model
The
risk­
related
score
computed
by
RSEI
for
chemicals,
for
which
all
required
model
input
parameters
are
present.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

ModeledPoundsTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical.

Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
TRI_
Pounds
The
quantity
of
chemical
discharged
in
pounds
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
Field
Name
Field
Description
9
TRI_
PoundsToxTox
Product
of
the
quantity
of
chemical
discharged
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical
TWF_
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs).
TWF
Hazard
is
the
product
of
the
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.

Type
of
Group
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4)

Point
Source
Rankings
w/
POTW
Removals­
Final
This
table
is
updated
by
query
"
Rank
07
­
Make
Point
Source
Rankings
­
6"
from
the
table
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
for
all
non­
null
point
source
categories.
It
contains
discharge
information
for
each
point
source
category
and
SIC
grouping.
These
variables
are
total
model
scores
or
TWPE
for
all
chemicals
reported
in
a
point
source
category
or
SIC
grouping.

Number
of
Records:
80
Field
Name
Field
Description
40
CFR
Part
40
Code
of
Federal
Regulations
Part,
2­
digit
SIC
grouping,
or
4­
digit
SIC
grouping
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
SumOfFull_
Model
The
risk­
related
score
computed
by
RSEI
for
all
chemicals
in
the
point
source
category
or
SIC
grouping,
for
which
all
required
model
input
parameters
are
present.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

SumOfModeledPoundsTox
The
product
of
the
total
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical.

SumOfTRI_
Pounds
The
total
quantity
of
chemical
discharged
in
pounds
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)

SumOfTRI_
PoundsToxTox
The
product
of
the
total
quantity
of
chemical
discharged
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical
SumOfTWF_
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs).
TWF
Hazard
is
the
product
of
the
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.
Field
Name
Field
Description
10
Type
of
Group
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4).

Priority
Pollutants
This
table
contains
the
CAS
number
and
chemical
name
or
TRI
chemical
category
for
priority
pollutants.

Number
of
Records:
239
Field
Name
Field
Description
CASNo
Chemical
Abstract
Services
Number
Chemical
Chemical
Name
SIC
Rankings
with
POTW
Removals
This
table
is
created
by
query
"
Rank
01
­
Make
SIC
Rankings
with
POTW
Removals"
from
"
SourceForRankingsw/
POTWRemovals"
and
"
SIC/
PSC
Crosswalk"
tables.
It
lists
the
reported
TRI/
RSEI
discharges
by
primary
4­
digit
SIC
code.

Number
of
Records:
405
Field
Name
Field
Description
Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category
Point
Source
3
The
third
Point
Source
Category
Point
Source
4
The
fourth
Point
Source
Category
SICCode1
4­
digit
Standard
Industrial
Classification
Code
SIC
Description
4­
digit
Standard
Industrial
Classification
Description
SumOfFullModel
The
risk­
related
score
computed
by
RSEI
for
chemicals,
for
which
all
required
model
input
parameters
are
present.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

SumOfModeledPoundsTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical.
Field
Name
Field
Description
11
SumOfTotalTRIPounds_
Discharged
The
quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)

SumOfTotalTRIPoundsWToxTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical
SumOfTWF
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs).
TWF
Hazard
is
the
product
of
the
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.

TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4).

SIC­
Chemical­
Dest
Rankings
This
table
is
created
by
the
"
Prerank
05
­
Make
SIC­
Chemical­
Dest
Rankings"
query.
This
table
presents
the
discharge
information
from
the
"
SourceForRankingsw/
POTWRemovals"
table
summed
by
the
primary
4­
digit
SIC
code
and
chemical.

Number
of
Records:
6,407
Field
Name
Field
Description
CASNumber
Chemical
Abstracts
Service
Number
from
TRI,
which
includes
TRI
group
numbers
for
TRI
chemical
groups
Chemical
Chemical
Name
Media
Code
associated
with
the
media
and/
or
method
of
release
MediaText
Description
of
receiving
media
associated
with
Media
Codes
(
i.
e.,
direct
water
or
POTW
transfer)

Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category
Point
Source
3
The
third
Point
Source
Category
Point
Source
4
The
fourth
Point
Source
Category
SICCode1
4­
digit
Standard
Industrial
Classification
code
SIC
Description
Primary
4­
digit
Standard
Industrial
Classification
Description
Field
Name
Field
Description
12
SumOfFullModel
The
risk­
related
score
computed
by
RSEI
for
chemicals,
for
which
all
required
model
input
parameters
are
present,
summed
by
the
primary
SIC
code.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

SumOfModeledPoundsTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical,
summed
by
the
primary
SIC
code.

SumOfTotalTRIPoundsWToxTox
Quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
for
chemicals
with
RSEI
toxicity
data,
summed
by
the
primary
SIC
code.

SumOfTRIPounds
The
quantity
of
chemical
discharged
in
pounds
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW),
summed
by
the
primary
SIC
code.

SumOfTotalTRIPounds_
Discharge
d
The
quantity
of
chemical
discharged
(
either
quantity
discharged
directly
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW),
summed
by
the
primary
SIC
code.

SumOfTRIPounds_
Removed
The
quantity
of
chemical
removed
by
a
POTW
prior
to
discharge.
This
is
only
calculated
for
chemical
quantities
that
are
transferred
to
POTWs,
summed
by
the
primary
SIC
code.

SumOfTRIPounds_
RemovedTox
The
product
of
the
quantity
of
chemical
removed
by
POTW
prior
to
discharge
(
only
calculated
for
chemicals
transferred
to
POTWs)
and
the
RSEI
Toxicity
Value
of
the
chemical,
summed
by
the
primary
SIC
code.

SumOfTRIPoundsWToxTox
The
product
of
the
quantity
of
chemical
discharged
(
direct
or
indirect)
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical,
summed
by
the
primary
SIC
code.

SumOfTWF
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs),
and
is
the
product
of
the
sum
of
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.

TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4).

SIC/
PSC
Crosswalk
(
TRI
and
PCS
Combined)

This
table
relates
all
SIC
codes
to
point
source
categories
or
SIC
groupings.
13
Number
of
Records:
1,027
Field
Name
Field
Description
Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category
Point
Source
3
The
third
Point
Source
Category
Point
Source
4
The
fourth
Point
Source
Category
SIC
Code
4­
digit
Standard
Industrial
Classification
Code
SIC
Description
4­
digit
Standard
Industrial
Classification
Description
TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4).

SourceForRankingsw/
POTWRemovals
This
table
includes
a
complete
listing
of
all
TRI/
RSEI
discharge
information,
by
chemical
and
facility.
The
data
sources
and
elements
used
in
the
creation
of
this
table
are
described
in
the
Explanation
of
the
Source
Data
Used
to
Create
TRI/
RSEI
Rankings
memorandum,
dated
December
8,
2003.

Number
of
Records:
24,710
Field
Name
Field
Description
CASNumber
Chemical
Abstracts
Service
Number
from
TRI,
which
includes
placeholder
CAS
numbers
for
TRI
chemical
groups
Chemical
Chemical
Name
FacilityID
TRI
Facility
ID
from
RSEI
FacilityID_
PDR
TRI
Facility
ID
from
the
TRI
Public
Data
Release
FullModel
The
risk­
related
score
computed
by
RSEI
for
chemicals,
for
which
all
required
model
input
parameters
are
present.
The
score
is
the
product
of
the
surrogate
dose,
the
chemical's
RSEI
toxicity
weight,
and
the
exposed
population.

Media
The
code
associated
with
the
media
and/
or
method
of
release
MediaText
Descriptions
of
receiving
media
associated
with
Media
Codes
(
i.
e.,
direct
water
or
POTW
transfer)
Field
Name
Field
Description
14
ModeledPoundsTox
The
product
of
the
quantity
of
chemical
discharged
in
pounds
modeled
in
RSEI
(
all
required
input
parameters
required
to
calculate
a
risk­
related
result
must
be
present)
and
the
RSEI
Toxicity
Weight
of
the
chemical.

Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category
Point
Source
3
The
third
Point
Source
Category
Point
Source
4
The
fourth
Point
Source
Category
Priority?
Indicates
whether
the
chemical
is
a
priority
pollutant
SICCode1
Primary
4­
digit
Standard
Industrial
Classification
code
from
the
TRI
public
data
release
SICCode1_
OLD
Primary
4­
digit
Standard
Industrial
Classification
Code
from
RSEI
Model
TotalTRIPounds_
Discharged
The
quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)

TotalTRIPoundsWToxTox
The
product
of
the
quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
and
the
RSEI
Toxicity
Value
of
the
chemical.

TRIPounds
Quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
in
pounds
TRIPounds_
Removed
The
quantity
of
chemical
removed
by
a
POTW
prior
to
discharge.
This
is
only
calculated
for
chemical
quantities
that
are
transferred
to
POTWs
TRIPounds_
RemovedToxTox
The
product
of
the
quantity
of
chemical
removed
by
POTW
prior
to
discharge
(
only
calculated
for
chemicals
transferred
to
POTWs)
and
the
RSEI
Toxicity
Value
of
the
chemical
TRIPoundsWToxTox
The
product
of
the
quantity
of
chemical
discharged
(
either
quantity
discharged
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
in
pounds
and
the
RSEI
Toxicity
Weight
of
the
chemical
TWF
Hazard
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
Toxic
Weighting
Factors
(
TWFs).
TWF
Hazard
is
the
product
of
the
total
TRI
pounds
discharged
and
the
EAD
TWF
of
the
chemical.

TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4).
15
TRI
Chemicals
with
MP&
M
y/
n
This
table
returns
a
list
of
chemicals
regulated
by
Metal
Product
and
Machinery
(
MP&
M)
point
source
category
effluent
guidelines.

Number
of
Records:
612
Field
Name
Field
Description
CASNumber
Chemical
Abstracts
Service
Number
from
TRI,
which
includes
TRI
group
numbers
for
TRI
chemical
groups
FullChemicalName
Chemical
Name
MP&
M
Chemical?
Indicates
whether
the
chemical
is
regulated
by
the
MP&
M
effluent
guidelines
TRI
Section
7A
This
table
provides
treatment
information
for
TRI
facilities.
The
data
are
from
the
TRI
Form
"
R"
reports,
Sections
7A.
The
description
field
indicates
which
TRI
Form
"
R"
section
the
data
element
is
from.
More
information
about
the
data
elements
and
TRI
Form
"
R"
sections
can
be
found
in
Toxic
Chemical
Release
Inventory
Reporting
Forms
and
Instruction,
located
on
the
EPA
website.

Number
of
Records:
91,513
Field
Name
Field
Description
CAS
NUMBER
Chemical
Abstracts
Service
Number
from
TRI,
which
includes
placeholder
CAS
numbers
for
TRI
chemical
groups
DOCUMENT
CONTROL
NA
­
Assigned
by
EPA
STREAM
1
­
BASED
ON
OPERATING
DATA?
Indicates
whether
waste
treatment
efficiency
estimate
is
based
on
actual
operating
data
STREAM
2
­
BASED
ON
OPERATING
DATA?
Indicates
whether
waste
treatment
efficiency
estimate
is
based
on
actual
operating
data
STREAM
3
­
BASED
ON
OPERATING
DATA?
Indicates
whether
waste
treatment
efficiency
estimate
is
based
on
actual
operating
data
STREAM
4
­
BASED
ON
OPERATING
DATA?
Indicates
whether
waste
treatment
efficiency
estimate
is
based
on
actual
operating
data
STREAM
5
­
BASED
ON
OPERATING
DATA?
Indicates
whether
waste
treatment
efficiency
estimate
is
based
on
actual
operating
data
STREAM
1
­
RANGE
INFLUENT
CONCENT
A
code
number,
which
corresponds
to
an
influent
concentration
range
for
an
EPCRA
section
313
chemical
Field
Name
Field
Description
16
STREAM
2
­
RANGE
INFLUENT
CONCENT
A
code
number,
which
corresponds
to
an
influent
concentration
range
for
an
EPCRA
section
313
chemical
STREAM
3
­
RANGE
INFLUENT
CONCENT
A
code
number,
which
corresponds
to
an
influent
concentration
range
for
an
EPCRA
section
313
chemical
STREAM
4
­
RANGE
INFLUENT
CONCENT
A
code
number,
which
corresponds
to
an
influent
concentration
range
for
an
EPCRA
section
313
chemical
STREAM
5
­
RANGE
INFLUENT
CONCENT
A
code
number,
which
corresponds
to
an
influent
concentration
range
for
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
EFFICIENCY
EST
The
waste
treatment
efficiency
expressed
as
percent
removal
of
the
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
EFFICIENCY
EST
The
waste
treatment
efficiency
expressed
as
percent
removal
of
the
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
EFFICIENCY
EST
The
waste
treatment
efficiency
expressed
as
percent
removal
of
the
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
EFFICIENCY
EST
The
waste
treatment
efficiency
expressed
as
percent
removal
of
the
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
EFFICIENCY
EST
The
waste
treatment
efficiency
expressed
as
percent
removal
of
the
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
1
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
2
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
3
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
4
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
5
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
6
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
Field
Name
Field
Description
17
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
7
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
TRTMT
METHOD
­
SEQUENCE
8
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
1
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
2
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
3
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
4
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
5
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
6
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
7
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
2
­
TRTMT
METHOD
­
SEQUENCE
8
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
1
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
2
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
3
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
Field
Name
Field
Description
18
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
4
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
5
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
6
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
7
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
3
­
TRTMT
METHOD
­
SEQUENCE
8
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
1
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
2
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
3
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
4
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
5
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
6
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
7
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
4
­
TRTMT
METHOD
­
SEQUENCE
8
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
Field
Name
Field
Description
19
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
1
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
2
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
3
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
4
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
5
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
6
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
7
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
5
­
TRTMT
METHOD
­
SEQUENCE
8
Waste
treatment
code
that
corresponds
to
an
on­
site
waste
treatment
method
used
on
a
waste
stream
containing
an
EPCRA
section
313
chemical
STREAM
1
­
WASTE
STREAM
CODE
Letter
code
that
corresponds
to
a
general
waste
stream
type
(
i.
e.,
gaseous,
wastewater,
liquid,
or
solid)

STREAM
2
­
WASTE
STREAM
CODE
Letter
code
that
corresponds
to
a
general
waste
stream
type
(
i.
e.,
gaseous,
wastewater,
liquid,
or
solid)

STREAM
3
­
WASTE
STREAM
CODE
Letter
code
that
corresponds
to
a
general
waste
stream
type
(
i.
e.,
gaseous,
wastewater,
liquid,
or
solid)

STREAM
4
­
WASTE
STREAM
CODE
Letter
code
that
corresponds
to
a
general
waste
stream
type
(
i.
e.,
gaseous,
wastewater,
liquid,
or
solid)

STREAM
5
­
WASTE
STREAM
CODE
Letter
code
that
corresponds
to
a
general
waste
stream
type
(
i.
e.,
gaseous,
wastewater,
liquid,
or
solid)

TRIFID
Toxic
Release
Inventory
Facility
Identification
Number
20
TRI
Sections
1
to
4
This
table
provides
detailed
facility
information
for
all
TRI
facilities.
The
data
are
from
the
TRI
Form
"
R"
reports,
Sections
1­
4.
The
description
field
indicates
which
TRI
Form
"
R"
section
the
data
element
is
from.
More
information
about
the
data
elements
and
TRI
Form
"
R"
sections
can
be
found
in
Toxic
Chemical
Release
Inventory
Reporting
Forms
and
Instruction,
located
on
the
EPA
website.

Number
of
Records:
91,513
Field
Name
Field
Description
CERTIFYING
OFFICIALS
Senior
management
official
who
certifies
the
accuracy
and
completeness
of
the
information
reported
to
TRI
DATE
SIGNED
The
date
when
the
certification
statement
was
signed
D&
B
NR
A
A
9­
digit
number
assigned
by
Dun
&
Bradstreet
to
each
facility
for
financial
purposes
D&
B
NR
B
A
9­
digit
number
assigned
by
Dun
&
Bradstreet
to
each
facility
for
financial
purposes
FACILITY
CITY
City
where
facility
is
located
FACILITY
COUNTY
County
where
facility
is
located
FACILITY
NAME
Full
name
of
facility
FACILITY
STATE
State
where
facility
is
located
FACILITY
STREET
Street
address
of
facility
FEDERAL
FACILITY
IND
Indicates
whether
the
facility
is
a
government
owned
facility
FORM
TYPE
Indicates
whether
report
is
a
Form
R
or
Form
A
GOCO
FACILITY
IND
Indicates
whether
report
is
being
submitted
independently
of
the
federal
facility
by
a
contractor
LATITUDE
Latitude
coordinate
of
reporting
facility
LONGITUDE
Longitude
coordinate
of
reporting
facility
MAILING
CITY
City
on
facility's
mailing
address
MAILING
NAME
Name
of
facility
on
mailing
address
MAILING
STATE
State
on
facility's
mailing
address
MAILING
ZIP
CODE
Zip
code
on
facility's
mailing
address
NAME
OF
CERTIFYING
Name
of
the
person
signing
the
certification
statement
Field
Name
Field
Description
21
NEW
PRIMARY
SIC
CODE
Primary
Standard
Industrial
Classification
code
obtained
from
the
"
Facility
Rankings
w
POTW
table
NPDES
NR
A
A
9­
character
permit
number
for
permits
held
by
the
facility
under
the
National
Pollutant
Discharge
Elimination
System
(
NPDES)

OLD
PRIMARY
SIC
CODE
The
primary
4­
digit
Standard
Industrial
Classification
Code
reported
by
the
facility
in
Section
4.5a
PARTIAL
FACILITY
IND
Indicated
whether
the
report
is
for
the
entire
covered
facility
as
a
whole
or
for
part
of
a
covered
facility
PUBLIC
CONTACT
NAME
Name
of
person
who
can
respond
to
questions
from
the
public
about
the
report
PUBLIC
CONTACT
PHONE
Phone
number
of
the
person
who
can
respond
to
questions
from
the
public
about
the
report
RCRA
NR
A
A
12­
character
identification
number
assigned
to
facilities
covered
by
hazardous
waste
regulations
under
the
Resource
Conservation
and
Recovery
Act
(
RCRA)

RCRA
NR
B
A
12­
character
identification
number
assigned
to
facilities
covered
by
hazardous
waste
regulations
under
the
Resource
Conservation
and
Recovery
Act
(
RCRA)

REPORTING
YEAR
The
calendar
year
to
which
the
reported
information
applies
SANITIZED
INDICATOR
Indicates
whether
the
report
is
the
public
version
and
contains
a
generic
name
for
the
trade
secret
chemical
(
sanitized)

SIC
CODE
2
The
second
applicable
Standard
Industrial
Classification
code
SIC
CODE
3
The
third
applicable
Standard
Industrial
Classification
code
SIC
CODE
4
The
fourth
applicable
Standard
Industrial
Classification
code
SIC
CODE
5
The
fifth
applicable
Standard
Industrial
Classification
code
SIC
CODE
6
The
sixth
applicable
Standard
Industrial
Classification
code
TITLE
OF
CERTIFYING
Title
of
the
person
who
signs
the
certification
statement
TRADE
SECRET
INDICATOR
Indicates
whether
the
facility
is
claiming
the
EPCRA
section
313
chemical
as
a
trade
secret
TRIFID_
w/
o_
Dash
Toxic
Release
Inventory
Facility
Identification
Number
22
3.0
QUERY
DESCRIPTIONS
The
queries
included
in
TRIReleases2000
are
listed
below.
Included
in
the
query
listing
is
a
brief
description
of
the
purpose
of
each
query.

Directs
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
reporting
direct
discharges
to
TRI.

Indirects
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
reporting
indirect
discharges
(
i.
e.,
transfers
to
POTWs)
to
TRI.

Make
Counts
of
Facilities
by
PSC
01
(
empty)
The
purpose
of
this
query
is
to
create
the
"
Counts
of
Facilities
by
PSC
(
step
1)"
table.

Make
Counts
of
Facilities
by
PSC
02
(
psc
1)
The
purpose
of
this
query
is
to
append
the
number
of
direct
facilities,
indirect
facilities,
and
both
direct
and
indirect
facilities
reporting
to
TRI,
as
well
as
total
number
of
dischargers
in
TRI
and
the
1997
Economic
Census
counts,
from
"
Counts
of
Facilities
by
SIC"
to
"
Counts
of
Facilities
by
PSC
(
step
1)"
for
each
point
source
category
1.

Make
Counts
of
Facilities
by
PSC
03
(
psc
2)
The
purpose
of
this
query
is
to
append
the
number
of
direct
facilities,
indirect
facilities,
and
both
direct
and
indirect
facilities
reporting
to
TRI,
as
well
as
total
number
of
dischargers
in
TRI
and
the
1997
Economic
Census
counts,
from
"
Counts
of
Facilities
by
SIC"
to
"
Counts
of
Facilities
by
PSC
(
step
1)"
for
each
point
source
category
2.

Make
Counts
of
Facilities
by
PSC
04
(
psc
3)
The
purpose
of
this
query
is
to
append
the
number
of
direct
facilities,
indirect
facilities,
and
both
direct
and
indirect
facilities
reporting
to
TRI,
as
well
as
total
number
of
dischargers
in
TRI
and
the
1997
Economic
Census
counts,
from
"
Counts
of
Facilities
by
SIC"
to
"
Counts
of
Facilities
by
PSC
(
step
1)"
for
each
point
source
category
3.

Make
Counts
of
Facilities
by
PSC
05
(
psc
4)
The
purpose
of
this
query
is
to
append
the
number
of
direct
facilities,
indirect
facilities,
and
both
direct
and
indirect
facilities
reporting
to
TRI,
as
well
as
total
number
of
dischargers
in
TRI
and
the
1997
Economic
Census
counts,
from
"
Counts
of
Facilities
by
SIC"
to
"
Counts
of
Facilities
by
PSC
(
step
1)"
for
each
point
source
category
4.
23
Make
Counts
of
Facilities
by
PSC
06
(
no
psc)
The
purpose
of
this
query
is
to
append
the
number
of
direct
facilities,
indirect
facilities,
and
both
direct
and
indirect
facilities
reporting
to
TRI,
as
well
as
total
number
of
dischargers
in
TRI
and
the
1997
Economic
Census
counts,
from
"
Counts
of
Facilities
by
SIC"
to
"
Counts
of
Facilities
by
PSC
(
step
1)"
where
no
point
source
category
is
listed.

Make
Counts
of
Facilities
by
PSC
07
(
final)
The
purpose
of
this
query
is
to
create
the
"
Counts
of
Facilities
by
PSC
(
final)"
table
by
grouping
all
information
about
each
point
source
category
in
"
Counts
of
Facilities
by
PSC
(
step
1)."

Make
Counts
of
Facilities
by
SIC
01
The
purpose
of
this
query
is
to
create
the
"
Counts
of
Facilities
by
SIC"
table,
which
returns
information
about
each
SIC
code.

Make
Counts
of
Facilities
by
SIC
02
(
D
and
I)
The
purpose
of
this
query
is
to
return
the
method
of
release
and
SIC
code
for
each
facility.

Make
Counts
of
Facilities
by
SIC
03
(
get
D)
The
purpose
of
this
query
is
to
create
the
"
Count
Directs
by
SIC"
table,
which
contains
a
listing
of
all
direct
dischargers.

Make
Counts
of
Facilities
by
SIC
04
(
upd
D)
The
purpose
of
this
query
is
to
update
the
number
of
direct
dischargers
in
"
Counts
of
Facilities
by
SIC."

Make
Counts
of
Facilities
by
SIC
05
(
get
I)
The
purpose
of
this
query
is
to
create
the
"
Count
Indirects
by
SIC"
table,
which
contains
a
listing
of
all
indirect
dischargers.

Make
Counts
of
Facilities
by
SIC
06
(
upd
I)
The
purpose
of
this
query
is
to
update
the
number
of
indirect
dischargers
in
"
Counts
of
Facilities
by
SIC."

Make
Counts
of
Facilities
by
SIC
07
(
get
Both
1)
The
purpose
of
this
query
is
to
return
a
list
of
facilities
that
have
both
direct
and
indirect
discharges.

Make
Counts
of
Facilities
by
SIC
08
(
get
Both
2)
The
purpose
of
this
query
is
to
count
the
number
of
facilities
that
have
both
direct
and
indirect
discharges.
24
Make
Counts
of
Facilities
by
SIC
09
(
upd
Both)
The
purpose
of
this
query
is
to
update
the
number
of
facilities
that
have
both
direct
and
indirect
discharges
in
"
Counts
of
Facilities
by
SIC."

Make
Counts
of
Facilities
by
SIC
10
(
get
disch
1)
The
purpose
of
this
query
is
to
list
all
the
dischargers
in
"
Make
Counts
of
Facilities
by
SIC
02
(
D
and
I)"
by
facility
name
and
SIC
code.

Make
Counts
of
Facilities
by
SIC
11
(
get
disch
2)
The
purpose
of
this
query
is
to
create
the
"
Count
Dischargers
by
SIC"
table,
which
counts
the
number
of
dischargers
for
each
SIC
code.

Make
Counts
of
Facilities
by
SIC
12
(
upd
disch)
The
purpose
of
this
query
is
to
update
the
"#
Dischargers"
field
in
the
"
Counts
of
Facilities
by
SIC"
table
using
2000
TRI
data
found
in
the
table
"
Counts
of
Facilities
by
SIC."

Make
Counts
of
Facilities
by
SIC
13
(
upd
census)
The
purpose
of
this
query
is
to
update
the
"#
of
Facilities
97
Census"
field
in
the
"
Census
Counts
by
SIC"
table
using
1997
Economic
Census
data
found
in
the
table
"
Counts
of
Facilities
by
SIC."

Make
Counts
of
Facilities
by
SIC
14
(
get
all
1)
The
purpose
of
this
query
is
to
select
all
facilities
from
the
"
TRI
Sections
1
to
4"
table
that
have
form
type
R
and
an
SIC
code
listed
in
the
OLD
PRIMARY
SIC
CODE
field
but
no
SIC
code
listed
in
the
NEW
PRIMARY
SIC
CODE
field.
The
OLD
PRIMARY
SIC
CODE
field
is
the
SIC
code
reported
to
the
TRI
public
data
release.
However,
in
some
instances,
a
facility
reported
different
primary
SIC
codes
for
different
Form
R
chemicals,
resulting
in
multiple
primary
SIC
codes
for
one
facility.
The
NEW
PRIMARY
SIC
CODE
field
was
created
to
represent
the
one
primary
SIC
code
associated
with
water
discharges
in
the
year
2000.

Make
Counts
of
Facilities
by
SIC
15
(
get
all
2)
The
purpose
of
this
query
is
to
count
the
number
of
facilities
with
form
type
R
and
create
a
table
named
"
Count
of
All
TRI,
Step
1."

Make
Counts
of
Facilities
by
SIC
16
(
get
all
3)
The
purpose
of
this
query
is
to
select
all
facilities
that
have
form
type
R
and
the
NEW
PRIMARY
SIC
CODE
field.
This
field
contains
the
primary
SIC
code
assigned
to
each
water­
discharging
facility
during
the
analysis
of
TRI
water
discharges
in
the
year
2000.
The
field
came
from
the
"
SourceforRankingsw/
POTWRemovals"
table,
which
only
lists
facilities
reporting
aqueous
discharges
in
the
year
2000.
25
Make
Counts
of
Facilities
by
SIC
17
(
get
all
4)
The
purpose
of
this
query
is
to
append
the
list
of
facilities
found
in
"
Make
Counts
of
Facilities
by
SIC
16
(
get
all
3)"
to
"
Count
of
All
TRI,
Step
1."

Make
Counts
of
Facilities
by
SIC
18
(
get
all
5)
The
purpose
of
this
query
is
to
count
the
number
of
facilities
for
each
SIC
code
in
"
Count
of
All
TRI,
Step
1"
and
create
"
Count
of
All
TRI
by
SIC,
Final."

Make
Counts
of
Facilities
by
SIC
19
(
upd
all)
The
purpose
of
this
query
is
to
update
"
Counts
of
Facilities
by
SIC"
data
using
"
Count
of
All
TRI
by
SIC,
Final"
data.

Make
Counts
of
Facilities
by
SIC
20
(
null
to
0)
The
purpose
of
this
query
is
to
change
all
null
"
1997
Economic
Census"
fields
in
"
Counts
of
Facilities
by
SIC"
to
zero.

Prerank
04
­
Add
categories
to
Source
table
The
purpose
of
this
query
is
to
add
point
source
categories
to
the
"
Source
for
Ranking"
table.

Prerank
05
­
Make
SIC­
Chemical­
Dest
Rankings
The
purpose
of
this
query
is
to
create
the
"
SIC­
Chemical­
Dest
Rankings"
table
and
find
the
total
sum
of
all
discharge
information
for
the
chemicals
in
each
SIC
code
group.

Prerank
06
­
Make
New
MP&
M
Ranking
Values
The
purpose
of
this
query
is
to
create
"
New
MPM
Ranking
Values,"
which
returns
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
all
chemicals
in
the
Metal
Products
&
Machinery
and
Metal
Finishing
point
source
categories.

Rank
01
­
Make
SIC
Rankings
with
POTW
Removals
The
purpose
of
this
query
is
to
create
the
"
SIC
Rankings
with
POTW
Removals"
table
from
the
"
SourceForRankingsw/
POTWRemovals"
and
"
SIC/
PSC
Crosswalk"
tables.
It
includes
a
grouping
of
SIC
codes
along
with
total
discharge
information
for
each
SIC
code.

Rank
02
­
Make
Point
Source
Rankings
­
1
The
purpose
of
this
query
is
to
create
the
table
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1."

Rank
03
­
Delete
Point
Source
Rankings
The
purpose
of
this
query
is
to
delete
all
entries
from
the
table
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1."
before
updating
it
with
the
subsequent
queries.
26
Rank
03
­
Make
Point
Source
Rankings
­
2
The
purpose
of
this
query
is
to
append
all
discharge
information
from
"
SIC
Rankings
with
POTW
Removals"
to
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
for
facilities
having
a
non­
zero
Point
Source
Category
1
value.

Rank
04
­
Make
Point
Source
Rankings
­
3
The
purpose
of
this
query
is
to
append
all
discharge
information
from
"
SIC
Rankings
with
POTW
Removals"
to
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
for
facilities
having
a
non­
zero
Point
Source
Category
2
value.

Rank
05
­
Make
Point
Source
Rankings
­
4
The
purpose
of
this
query
is
to
append
all
discharge
information
from
"
SIC
Rankings
with
POTW
Removals"
to
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
for
facilities
having
a
non­
zero
Point
Source
Category
3
value.

Rank
06
­
Make
Point
Source
Rankings
­
5
The
purpose
of
this
query
is
to
append
all
discharge
information
from
"
SIC
Rankings
with
POTW
Removals"
to
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
for
facilities
having
a
non­
zero
Point
Source
Category
4
value.

Rank
07
­
Delete
Point
Source
Ranking
The
purpose
of
this
query
is
to
delete
all
entries
in
the
table
"
Point
Source
Rankings
w/
POTW
Removals­
Final"
so
new
data
can
be
appended.

Rank
07
­
Make
Point
Source
Rankings
­
6
The
purpose
of
this
query
is
to
append
"
Point
Source
Rankings
w/
POTW
Removals
­
Step1"
to
"
Point
Source
Rankings
w/
POTW
Removals­
Final"
for
all
non­
null
point
source
categories.

Rank
08
­
Make
Point
Source
Rankings
­
7
The
purpose
of
this
query
is
to
update
"
New
MPM
Ranking
Values"
from
"
Point
Source
Rankings
w/
POTW
Removals­
Final"
for
the
Metal
Products
&
Machinery
point
source
category.

Rank
09
­
Make
Point
Source
Rankings
­
8
The
purpose
of
this
query
is
to
update
the
"
New
MPM
Ranking
Values"
from
"
Point
Source
Rankings
w/
POTW
Removals­
Final"
for
the
Metal
Finishing
point
source
category.

Rank
10
­
Make
Point
Source
Rankings
­
9
The
purpose
of
this
query
is
to
update
the
40
CFR
Part
values
in
"
New
MPM
Ranking
Values"
with
the
values
from
"
Point
Source
Rankings
w/
POTW
Removals­
Final."
27
TRI_
Chemical_
CFPR_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Chemical
Formulating,
Packaging,
and
Repackaging
facility.

TRI_
Chemical_
CFPR_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
CFPR_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
Fertilizer_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Fertilizer
Manufacturing
facility.

TRI_
Chemical_
Fertilizer_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
Fertilizer_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
Inorganics_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Inorganic
Chemicals
Manufacturing
facility.

TRI_
Chemical_
Inorganic_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
Inorganic_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
NonferrousMetalsManufacturing_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Nonferrous
Metals
Manufacturing
facility.

TRI_
Chemical_
NonferrousMetalsManufacturing_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
NFMM_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
OCPSF_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facility.
28
TRI_
Chemical_
OCPSF_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
OCPSF_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
OreMining_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Ore
Mining
and
Dressing
facility.

TRI_
Chemical_
OreMining_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
OreMining_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
PBST_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Petroleum
Bulk
Station
or
Terminal.

TRI_
Chemical_
PBST_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
PBST_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
Phosphate_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Phosphate
Manufacturing
facility.

TRI_
Chemical_
Phosphate_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
Phosphate_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
PR_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Petroleum
Refining
facility.

TRI_
Chemical_
PR_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
PR_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.
29
TRI_
Chemical_
PulpAndPaperPhaseI_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Pulp,
Paper,
and
Paperboard
Phase
I
facility.

TRI_
Chemical_
PulpAndPaperPhaseI_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
PulpAndPaperPhaseI_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
PulpAndPaperPhaseII_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Pulp,
Paper,
and
Paperboard
Phase
II
facility.

TRI_
Chemical_
PulpAndPaperPhaseII_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
PulpAndPaperPhaseII_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
PulpAndPaperPhaseIII_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Pulp,
Paper,
and
Paperboard
Phase
III
facility.

TRI_
Chemical_
PulpAndPaperPhaseIII_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
PulpAndPaperPhaseIII_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
SteamElectric_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Steam
Electric
Power
Generation
facility.

TRI_
Chemical_
SteamElectric_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
SteamElectric_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
Textile_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Textile
Mill.
30
TRI_
Chemical_
Textile_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
Textile_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
Chemical_
Timber_
Step1
The
purpose
of
this
query
is
to
return
the
pounds
of
chemical
discharged
by
each
Timber
Products
Processing
facility.

TRI_
Chemical_
Timber_
Step2
The
purpose
of
this
query
is
to
group
all
identical
chemicals
from
"
TRI_
Chemical_
Timber_
Step1",
calculate
each
chemical's
total
pounds
discharged
and
total
TWPE,
and
provide
a
count
of
the
total
number
of
facilities
that
report
each
chemical.

TRI_
FACS_
CFPR_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
list
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Chemical
Formulating,
Packaging,
and
Repackaging
facility.

TRI_
FACS_
CFPR_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Chemical
Formulating,
Packaging,
and
Repackaging
facility
that
reports
direct
discharges.

TRI_
FACS_
CFPR_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Chemical
Forming,
Packaging,
and
Repackaging
facility
that
reports
indirect
discharges.

TRI_
FACS_
CFPR_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
CFPR_
indirect"
query.

TRI_
FACS_
CFPR_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
CFPR_
direct"
query.
31
TRI_
FACS_
CFPR_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
CFPR_
Step1"
and
"
TRI_
FACS_
CFPR_
Step2"
to
create
a
list
of
all
Chemical
Formulating,
Packaging,
and
Repackaging
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
FERTILIZER_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Fertilizer
Manufacturing
facility.

TRI_
Facs_
FERTILIZER_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Fertilizer
Manufacturing
facility
that
reports
direct
discharges.

TRI_
FACS_
FERTILIZER_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Fertilizer
Manufacturing
facility
that
reports
indirect
discharges.

TRI_
FACS_
FERTILIZER_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
FERTILIZER_
indirect"
query.

TRI_
FACS_
FERTILIZER_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
Facs_
FERTILIZER_
direct"
query.

TRI_
FACS_
FERTILIZER_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
FERTILIZER_
Step1"
and
"
TRI_
FACS_
FERTILIZER_
Step2"
to
create
a
list
of
all
Fertilizer
Manufacturing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
Inorganics_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Inorganic
Chemicals
Manufacturing
facility.

TRI_
FACS_
Inorganics_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Inorganic
Chemicals
Manufacturing
facility
that
reports
direct
discharges.
32
TRI_
FACS_
Inorganics_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Inorganic
Chemicals
Manufacturing
facility
that
reports
indirect
discharges.

TRI_
FACS_
Inorganics_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
Inorganics_
indirect"
query.

TRI_
Facs_
Inorganics_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
Inorganics_
direct"
query.

TRI_
FACS_
Inorganics_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
Inorganics_
Step1"
and
"
TRI_
FACS_
Inorganics_
Step2"
to
create
a
list
of
all
Inorganic
Chemicals
Manufacturing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
NFMM_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Nonferrous
Metals
Manufacturing
facility
that
reports
direct
discharges.

TRI_
FACS_
NFMM_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Nonferrous
Metals
Manufacturing
facility
that
reports
indirect
discharges.

TRI_
FACS_
NFMM_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
NFMM_
indirect"
query.

TRI_
FACS_
NFMM_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
NFMM_
direct"
query.
33
TRI_
FACS_
NFMM_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
NFMM_
Step1"
and
"
TRI_
FACS_
NFMM_
Step2"
to
create
a
list
of
all
Nonferrous
Metals
Manufacturing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
OCPSF_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facility.

TRI_
FACS_
OCPSF_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facility
that
reports
direct
discharges.

TRI_
FACS_
OCPSF_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facility
that
reports
indirect
discharges.

TRI_
FACS_
OCPSF_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
OCPSF_
indirect"
query.

TRI_
FACS_
OCPSF_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
OCPSF_
direct"
query.

TRI_
FACS_
OCPSF_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
OCPSF_
Step1"
and
"
TRI_
FACS_
OCPSF_
Step2"
to
create
a
list
of
all
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
OREMINING_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Ore
Mining
and
Dressing
facility.

TRI_
FACS_
OREMINING_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Ore
Mining
and
Dressing
facility
that
reports
direct
discharges.
34
TRI_
FACS_
OREMINING_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Ore
Mining
and
Dressing
facility
that
reports
indirect
discharges.

TRI_
FACS_
OREMINING_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
OREMINING_
indirect"
query.

TRI_
FACS_
OREMINING_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
OREMINING_
direct"
query.

TRI_
FACS_
OREMINING_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
OREMINING_
Step1"
and
"
TRI_
FACS_
OREMINING_
Step2"
to
create
a
list
of
all
Ore
Mining
and
Dressing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PBST_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Petroleum
Bulk
Station
and
Terminal.

TRI_
FACS_
PBST_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Petroleum
Bulk
Station
and
Terminal
that
reports
direct
discharges.

TRI_
FACS_
PBST_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Petroleum
Bulk
Station
and
Terminal
that
reports
indirect
discharges.

TRI_
FACS_
PBST_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PBST_
indirect"
query.
35
TRI_
FACS_
PBST_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PBST_
direct"
query.

TRI_
FACS_
PBST_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PBST_
Step1"
and
"
TRI_
FACS_
PBST_
Step2"
to
create
a
list
of
all
Petroleum
Bulk
Stations
and
Terminals
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PHOSPHATE_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Phosphate
Manufacturing
facility.

TRI_
FACS_
PHOSPHATE_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Phosphate
Manufacturing
facility
that
reports
direct
discharges.

TRI_
FACS_
PHOSPHATE_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Phosphate
Manufacturing
facility
that
reports
indirect
discharges.

TRI_
FACS_
PHOSPHATE_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PHOSPHATE_
indirect"
query.

TRI_
FACS_
PHOSPHATE_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PHOSPHATE_
direct"
query.

TRI_
FACS_
PHOSPHATE_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PHOSPHATE_
Step1"
and
"
TRI_
FACS_
PHOSPHATE_
Step2"
to
create
a
list
of
all
Phosphate
Manufacturing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PR_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Petroleum
Refining
facility.
36
TRI_
Facs_
PR_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Petroleum
Refining
facility
that
reports
direct
discharges.

TRI_
FACS_
PR_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Petroleum
Refining
facility
that
reports
indirect
discharges.

TRI_
FACS_
PR_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PR_
indirect"
query.

TRI_
FACS_
PR_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PR_
direct"
query.

TRI_
FACS_
PR_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PR_
Step1"
and
"
TRI_
FACS_
PR_
Step2"
to
create
a
list
of
all
Petroleum
Refining
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PULP1_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
I
facility.

TRI_
Facs_
PULP1_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
I
facility
that
reports
direct
discharges.

TRI_
FACS_
PULP1_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
I
facility
that
reports
indirect
discharges.

TRI_
FACS_
PULP1_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP1_
indirect"
query.
37
TRI_
FACS_
PULP1_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP1_
direct"
query.

TRI_
FACS_
PULP1_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PULP1_
Step1"
and
"
TRI_
FACS_
PULP1_
Step2"
to
create
a
list
of
all
Pulp,
Paper,
and
Paperboard
Phase
I
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PULP2_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
II
facility.

TRI_
Facs_
PULP2_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
II
facility
that
reports
direct
discharges.

TRI_
FACS_
PULP2_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
II
facility
that
reports
indirect
discharges.

TRI_
FACS_
PULP2_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP2_
indirect"
query.

TRI_
FACS_
PULP2_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP2_
direct"
query.

TRI_
FACS_
PULP2_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PULP2_
Step1"
and
"
TRI_
FACS_
PULP2_
Step2"
to
create
a
list
of
all
Pulp,
Paper,
and
Paperboard
Phase
II
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
PULP3_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
III
facility.
38
TRI_
Facs_
PULP3_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
III
facility
that
reports
direct
discharges.

TRI_
FACS_
PULP3_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Pulp,
Paper,
and
Paperboard
Phase
III
facility
that
reports
indirect
discharges.

TRI_
FACS_
PULP3_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP3_
indirect"
query.

TRI_
FACS_
PULP3_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
PULP3_
direct"
query.

TRI_
FACS_
PULP3_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
PULP3_
Step1"
and
"
TRI_
FACS_
PULP3_
Step2"
to
create
a
list
of
all
Pulp,
Paper,
and
Paperboard
Phase
III
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
SteamElectric_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Steam
Electric
Power
Generating
facility.

TRI_
Facs_
SteamElectric_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Steam
Electric
Power
Generating
facility
that
reports
direct
discharges.

TRI_
FACS_
SteamElectric_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Steam
Electric
Power
Generating
facility
that
reports
indirect
discharges.

TRI_
FACS_
SteamElectric_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
SteamElectric_
indirect"
query.
39
TRI_
FACS_
SteamElectric_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
SteamElectric_
direct"
query.

TRI_
FACS_
SteamElectric_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
SteamElectric_
Step1"
and
"
TRI_
FACS_
SteamElectric_
Step2"
to
create
a
list
of
all
Steam
Electric
Power
Generating
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
TEXTILE_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Textile
Mill.

TRI_
Facs_
TEXTILE_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Textile
Mill
that
reports
direct
discharges.

TRI_
FACS_
TEXTILE_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Textile
Mill
that
reports
indirect
discharges.

TRI_
FACS_
TEXTILE_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
TEXTILE_
indirect"
query.

TRI_
FACS_
TEXTILE_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
TEXTILE_
direct"
query.

TRI_
FACS_
TEXTILE_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
TEXTILE_
Step1"
and
"
TRI_
FACS_
TEXTILE_
Step2"
to
create
a
list
of
all
Textile
Mills
with
their
direct
and
indirect
discharge
information.

TRI_
FACS_
TIMBER_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Timber
Products
Processing
facility.
40
TRI_
Facs_
TIMBER_
direct
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Timber
Products
Processing
facility
that
reports
direct
discharges.

TRI_
FACS_
TIMBER_
indirect
The
purpose
of
this
query
is
to
return
the
total
pounds
of
chemical
discharged
and
total
TWPE
for
every
Timber
Products
Processing
facility
that
reports
indirect
discharges.

TRI_
FACS_
TIMBER_
Step1
The
purpose
of
this
query
is
to
list
all
indirect
discharges,
plus
any
direct
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
1
returns
indirect
and
direct
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
TIMBER_
indirect"
query.

TRI_
FACS_
TIMBER_
Step2
The
purpose
of
this
query
is
to
list
all
direct
discharges,
plus
any
indirect
discharges
from
facilities
that
have
both
direct
and
indirect
discharge.
Step
2
returns
direct
and
indirect
discharge
information
for
every
facility
listed
in
the
"
TRI_
FACS_
TIMBER_
direct"
query.

TRI_
FACS_
TIMBER_
Step3
The
purpose
of
this
union
query
is
to
combine
"
TRI_
FACS_
TIMBER_
Step1"
and
"
TRI_
FACS_
TIMBER_
Step2"
to
create
a
list
of
all
Timber
Products
Processing
facilities
with
their
direct
and
indirect
discharge
information.

TRI_
NFMM_
FACS_
and_
TWPES
The
purpose
of
this
query
is
to
return
a
listing
of
all
chemicals,
their
pounds
discharged,
and
TWPE
for
every
Nonferrous
Metals
Manufacturing
facility.

TRI_
NFMM_
TWPE_
SUM
This
query
finds
the
total
TWPE
for
all
NFMM
facilities
combined
for
each
SIC
code.

Unique_
TRI_
Section1_
to_
4
The
purpose
of
this
query
is
to
create
a
list
of
all
TRI
facilities
from
the
"
TRI
Sections
1
to
4"
table.

Update
Priority
in
SourceForRankings
The
purpose
of
this
query
is
to
update
the
"
SourceForRankingsw/
POTWRemovals"
table
to
identify
priority
pollutants.