MEMORANDUM
TO:
304(
m)
Record
(
EPA
Docket
Number
OW­
2003­
0074)

FROM:
Molly
Merrifield,
ERG
DATE:
December
8,
2003
SUBJECT:
Explanation
of
the
Source
Data
Used
to
Create
TRI/
RSEI
Rankings
This
memorandum
describes
the
data
manipulation
performed
during
analysis
of
Toxics
Release
Inventory
(
TRI)
data
and
Risk
Screening
Environmental
Indicators
(
RSEI)
model
output
to
create
a
data
source
table
used
to
generate
various
industry
rankings.

RSEI
Output
Manipulation
EPA's
Office
of
Pollution
Prevention
&
Toxics
(
OPPT)
performed
RSEI
runs
(
using
RSEI
Model
version
2.1
­
Draft)
for
the
Office
of
Water
(
OW)
in
February
2003.
These
runs
filtered
TRI
data
based
on
the
reporting
year
equal
to
2000
and
releases
only
to
surface
water
or
publicly
owned
treatment
works
(
POTWs).
OPPT
created
two
sets
of
data:
one
data
set
included
all
reported
pollutants,
while
the
other
data
set
excluded
chromium
and
chromium
compounds
from
the
results.
These
two
data
sets
were
forwarded
to
OW.

OW
analyzed
the
full
set
of
pollutants
reported
to
TRI.
As
the
data
were
analyzed,
it
became
necessary
to
distinguish
between
releases
to
surface
water
and
transfers
to
POTWs.
ERG
re­
ran
the
RSEI
model,
applying
the
same
filters
described
above,
and
specified
that
media
information
should
be
included
in
the
output.
This
option
expanded
the
previous
data
set
and
provided
separate
quantities
of
release
estimates
and
risk
scores
for
releases
to
surface
water
and
transfers
to
POTWs.

The
RSEI
model
provides
several
output
values
that
can
be
used
to
analyze
the
data.
The
full
model
score
(
i.
e.,
RSEI
risk­
related
score)
takes
into
consideration
several
parameters,
including
POTW
removal
efficiencies.
By
including
removal
efficiencies,
treatment
performed
at
a
POTW
is
accounted
for
and
the
quantity
of
chemicals
discharged
to
a
water
body
is
more
accurately
reflected.

The
full
model
score,
however,
can
only
be
calculated
when
all
required
parameters
are
present
(
e.
g.,
population
exposure
information,
fate
and
transport
information,
etc.).
Therefore,
ERG
created
two
additional
values:
"
TRI
Pounds
Removed"
and
"
TRI
Pounds
Discharged."
"
TRI
Pounds
Removed"
was
calculated
by
multiplying
the
quantity
of
chemical
transferred
to
a
POTW
Memorandum
December
8,
2003
Page
2
1POTW
removal
rates
were
exported
from
the
RSEI
model
to
use
in
the
calculation.
by
the
RSEI
POTW
removal
rate
for
a
chemical1.
This
quantity
represents
the
amount
of
chemical
that
is
removed
by
the
POTW
prior
to
discharging
to
a
water
body.
This
quantity
was
set
equal
to
zero
for
discharges
reported
to
be
released
direct
to
surface
waters.
"
Total
TRI
Pounds
Discharged"
was
then
calculated
by
subtracting
"
TRI
Pounds
Removed"
from
"
TRI
Pounds"
(
i.
e.,
the
reported
release
or
transfer,
in
pounds).

ERG
also
created
two
additional
output
values
corresponding
to
the
values
described
above
that
factored
in
the
RSEI
toxicity
value
for
the
chemicals.
"
TRI
Pounds
Removed
ToxTox"
was
calculated
as
the
quantity
of
chemical
removed
by
the
POTW
prior
to
discharge
multiplied
by
the
RSEI
toxicity
value.
"
Total
TRI
Pounds
wToxTox"
was
then
calculated
as
the
quantity
of
chemical
discharged
to
a
receiving
stream
(
either
directly,
or
after
accounting
for
POTW
removals)
multiplied
by
the
RSEI
toxicity
weight.
In
cases
where
a
RSEI
toxicity
value
did
not
exist,
the
reported
releases
were
not
included
in
the
calculation.

One
last
output
value
was
calculated
for
use
in
rankings.
The
"
TWF
Hazard"
value
was
calculated
using
Toxic
Weighting
Factors
(
TWFs)
developed
by
OW's
Engineering
and
Analysis
Division
(
EAD).
EAD
TWFs
take
into
account
environmental
toxicity,
in
contrast
to
RSEI
toxicity
factors
which
only
account
for
chronic
human
health
hazard.
"
TWF
Hazard"
was
calculated
by
multiplying
"
Total
TRI
Pounds
Discharged"
by
the
associated
EAD
TWF.
In
cases
where
an
EAD
TWF
did
not
exist,
the
reported
releases
were
not
included
in
the
calculation.

TRI
Data
Manipulation
ERG
augmented
the
RSEI
model
output
with
additional
TRI
data
available
from
the
2000
Public
Data
Release
(
PDR),
a
static
data
set
made
available
on
May
23,
2002.
Due
to
a
discrepancy
that
ERG
identified
between
SICCode1
(
RSEI
primary
SIC
code)
and
the
primary
SIC
reported
to
TRI,
SIC
code
data
were
extracted
from
the
2000
PDR
in
May
2003.
These
TRI
primary
SIC
code
data
replaced
the
primary
SIC
code
data
output
by
RSEI
for
each
facility.

Any
other
general
information
about
a
facility
(
e.
g.,
name,
address,
etc.)
was
obtained
from
the
2000
TRI
PDR.
The
PDR
was
also
used
to
determine
how
many
facilities
reported
any
type
of
releases
(
i.
e.,
non­
water
releases)
to
TRI,
to
evaluate
the
type
of
treatment
used
on
site
at
certain
facilities,
and
to
evaluate
dioxin
congener
information.

Additional
facility­
specific
data
corrections
were
made
and
are
documented
in
an
addendum
to
the
Draft
Final
Report:
Evaluation
of
RSEI
Model
Runs.
These
refinements
are
based
on
additional
information
obtained
from
facilities
and
more
accurately
reflect
activities
occurring
at
a
facility.
Memorandum
December
8,
2003
Page
3
Final
TRI
Data
Output
The
final
TRI
data
set,
called
"
SourceForRankingsw/
POTWRemovals,"
comprises
all
values
used
to
generate
final
industry
rankings.
Attachment
A
to
this
memorandum
presents
a
graphical
representation
of
the
flow
and
interaction
among
the
data
sources
used
to
create
the
final
TRI
data
set.
The
following
data
elements
are
present
in
the
final
TRI
data
set:


CAS
number;


Chemical
name;


Facility
ID;


SIC
code;


Media
(
i.
e.,
direct
surface
water
or
POTW
transfer);


TRI
Pounds;


TRI
Pounds
Removed;


Total
TRI
Pounds
Discharged;


TRI
Pounds
wToxTox;


TRI
Pounds
Removed
ToxTox;


Total
TRI
Pounds
wToxTox;


Modeled
Pounds
Tox;


Full
Model
(
i.
e.,
RSEI
risk­
related
score);
and

TWF
Hazard.

In
order
to
arrive
at
point
source
category
rankings,
data
contained
within
this
data
set
were
further
aggregated.
Rankings
were
established
by
first
aggregating
data
at
the
SIC
code
level,
followed
by
point
source
category.
ATTACHMENT
A
DATA
SOURCE
FLOW
AND
INTERACTION
SIC/
Point
Source
Category
Crosswalk
EAD
Toxic
Weight
Factor
Chemical
Name
CAS
Number
EAD
TWF
Chemical
CAS
Number
Other
Data
Percent
of
chemical
removed
from
the
wastewater
by
the
POTW
POTW
Partition
Removal
First
facility
4­
digit
SIC
code
reported
on
Form
R
(
As
Reported)
SICCode1
Value
is
the
product
of
the
surrogate
dose
(
estimated
usingexposure
models),
the
chemical's
toxicity
weight,
and
the
population
FullModel
Value
is
modeled
pounds
multiplied
by
the
toxicity
weight
of
thechemical
appropriate
for
the
exposure
pathway
selected
Modeled
PoundsTox
Value
is
TRI
pounds
multiplied
by
the
toxicity
weight
of
the
chemical
appropriate
for
the
exposure
pathway
selected
TRIPounds
WToxTox
Total
number
of
pounds
released
or
transferred
reported
to
TRI
for
the
exposure
pathway
being
considered
Descriptions
of
receiving
media
associated
with
Media
Codes
(
i.
e.,
direct
water
or
POTW
transfer)
Code
associated
with
the
media
and/
or
methodof
release
Facility
ID
Chemical
Name
CAS
Number
TRIPounds
MediaText
Media
FacilityID
Chemical
CAS
Number
RSEI
Model
Output
Note
that
TRI
SIC
code
replaced
RSEI
SIC
code
SIC
Group
or
Point
Source
Category
TypeofGroup
Total
number
of
pounds
released
or
transferred
reported
to
TRI
for
the
exposure
pathway
being
considered
TRIPounds
Primary
SIC
Code
from
RSEI
SICCode1_
OLD
Priority
pollutant
indicator
Priority?
Fourth
Point
Source
Category
SIC
code
is
a
part
of,
if
applicable
Point
Source
4
Primary
SIC
Code
from
the
TRI
Public
Data
SICCode1
Value
is
modeled
pounds
multiplied
by
the
toxicity
weight
of
the
chemical
appropriate
for
the
exposure
pathway
selected
ModeledPoundsTox
Value
is
the
product
of
the
surrogate
dose
(
estimated
using
exposure
models),
the
chemical's
toxicity
weight,
and
the
population
FullModel
Facility
ID
from
the
TRI
Public
Data
Release
FacilityID_
PDR
This
value
is
calculated
for
TRI
chemicals
that
have
EAD
TWFs.
TWF
Hazard
is
calculated
by
multiplying
total
TRI
pounds
discharged
[
TotalTRIPounds_
Discharged]
by
the
EAD
TWF
of
the
chemical
TWF
Hazard
Quantity
of
chemical
released
in
pounds
[
TRIPounds]
multiplied
by
RSEI
Toxicity
Weight
TRIPoundsWToxTox
Quantity
of
chemical
removed
by
POTW
prior
to
discharge
(
only
calculated
for
chemicals
transferred
to
POTWs)
[
TotalTRIPounds_
Discharged]
multiplied
by
RSEI
Toxicity
Value
TRIPounds_
RemovedToxTox
Quantity
of
chemical
removed
by
POTW
prior
to
discharge,
only
calculated
for
chemicals
quantities
transferred
to
POTWs
TRIPounds_
Removed
Quantity
of
chemical
discharged
(
either
quantity
released
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
[
TotalTRIPounds_
Discharged]
multiplied
by
RSEI
Toxicity
Value
TotalTRIPoundsWToxTox
Quantity
of
chemical
discharged
(
either
quantity
released
or
quantity
transferred
to
POTW
minus
quantity
removed
by
POTW)
TotalTRIPounds_
Discharged
Total
number
of
pounds
released
or
transferred
reported
to
TRI
for
the
exposure
pathway
being
considered
Third
Point
Source
Category
SIC
code
is
a
part
of,
if
applicable
Second
Point
Source
Category
SIC
code
is
a
part
of,
if
applicable
First
Point
Source
Category
SIC
code
is
a
part
of.
Note
that
if
TypeofGroup=
SIC,
then
this
field
is
populated
with
the
high
level
SIC
description.
Descriptions
of
receiving
media
associated
with
Media
Codes
(
i.
e.,
direct
water
or
POTW
transfer)
Code
associated
with
the
media
and/
or
method
of
release
Facility
ID
from
RSEI
Chemical
Name
CAS
Number
TRIPounds
Point
Source
3
Point
Source
2
Point
Source
1
MediaText
Media
FacilityID
Chemical
CASNumber
Final
TRI
Data
Output
("
SourceForRankingsw/
POTWRemovals")
First
facility
4­
digit
SIC
code
reported
on
Form
R
PrimarySIC
Facility
Zip
Code
Facility
Zip
Code
Facility
State
Facility
State
Facility
City
Facility
City
Facility
Street
Address
Facility
Name
Code
associated
with
the
media
and/
or
method
of
release
Form
R
or
Form
A
Indicator
(
Only
Form
R
Data
used)
Facility
ID
Chemical
Name
CAS
Number
Facility
Street
Facility
Name
Form
Type
FacilityID
Chemical
CAS
Number
2000
TRI
Public
Data
Release
