Document ID: EPA-HQ-TRI-2004-0001-0061
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2005-07-06T04:00Z

ITS­
ESE
06/
06/
2005
TRI­
RCRA
Linkages
in
FRS
ITS­
ESE
Task
Order
No.:
015
Contract
No.:
68­
W­
04­
005
June
30,
2005
Developed
for:
United
States
Environmental
Protection
Agency
Office
of
Environmental
Information
1200
Pennsylvania
Avenue,
NW
Washington,
DC
20460
Developed
by:

National
Environmental
Information
Systems
Engineering
Center
(
NEISEC)
1010
N.
Glebe
Road
Arlington,
VA
22201
Doc.
No.:
015­
FRS­
RPT­
0048
Version:
2005­
0630
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
2
of
11
Table
of
Contents
1.0
PROBLEM
STATEMENT
.................................................................................................................
3
2.0
ANALYSIS......................................................................................................................................
4
3.0
CONCLUSION...............................................................................................................................
10
4.0
APPENDIX....................................................................................................................................
11
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
3
of
11
1.0
Problem
Statement
The
Toxic
Release
Inventory
(
TRI)
system
collects
and
maintains
the
identification
numbers
for
the
Resource
Conservation
and
Recovery
Act
Information
(
RCRAINFO),
Underground
Injection
Control
(
UIC)
and
the
National
Pollutant
Discharge
Elimination
System
(
NPDES)
Program
that
a
TRI
reporter
submits
on
their
Form
R
or
A
annual
report.
The
Facility
Registry
System
(
FRS)
also
contains
program
ids
that
are
associated
with
a
given
place
or
facility.
FRS
Analysts
examine
these
reported
Ids
from
TRI
against
records
extracted
from
other
national
and
state
programs
and
through
automated
and
manual
processes
establish
appropriate
linkages
to
avoid
duplicate
records
that
represent
a
unique
place
or
facility.
This
information
is
presented
to
the
public
as
part
of
the
Envirofacts
Web
site
applications.

The
TRI
Program
has
initiated
a
burden
reduction
rule
to
eliminate
the
need
for
TRI
reporters
to
report
facility
locational
data
and
the
program
id's
mentioned
above.
Facility
locational
Information
and
program
identification
numbers
are
maintained
by
the
FRS
system.
In
order
for
the
TRI
Program
to
accept
FRS
as
a
home­
of­
record
for
this
information,
the
TRI
Program
management
team
must
have
confidence
that
FRS
has
locational
information
for
all
TRI
facilities,
maintains
proper
linkages
to
other
program
ID's,
and
has
a
process
for
maintaining
quality
data.

Analysis
on
RCRA
Ids
from
the
TRI
Forms
and
FRS
Id
Linkages
An
analysis
was
conducted
on
the
quality
of
the
FRS
linkages
among
TRI
and
RCRA
records.
This
paper
describes
the
results
of
this
analysis
to
assure
the
TRI
Program
that
it
can
rely
on
FRS
for
provide
the
program
identification
numbers
that
are
associated
to
the
TRI
reporting
facilities.
This
analysis
was
done
to
explain
the
following
cases:

1.
According
to
the
TRI
Form
R,
some
TRI
facilities
have
RCRA
IDs
that
were
submitted
by
TRI
reporters.
When
compared
with
the
linkages
(
IDs)
maintained
in
FRS,
the
given
TRI
facilities
do
not
link
to
any
RCRA
IDs.
2.
According
to
the
TRI
Form
R,
some
TRI
facilities
have
RCRA
IDs
that
were
submitted
by
TRI
reporters.
When
compared
with
the
linkages
(
IDs)
maintained
in
FRS,
the
given
TRI
facilities
link
to
different
RCRA
IDs
than
was
reported.

Three
database
extracts
were
generated
into
worksheets
to
support
this
analysis
and
answer
the
above
questions.
The
analysis
was
conducted
on
23,848
from
a
TRI
2003
data
set.
The
three
worksheets
represented
in
15­
0050
TRI­
RCRA
Linkages
in
FRS
Attachment
20050606
along
with
this
report
list
IDs,
names
and
addresses
of
TRI,
RCRA
and
FRS,
as
applicable,
for
TRI­
reported
TRI­
RCRA
linkages
that
do
not
match
the
linkages
in
FRS.
The
worksheets
are
defined
as
follows:

Worksheet
A:
102
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
do
exist
in
FRS,
but
FRS
did
not
link
or
associate
them
to
any
TRI
ID.

Worksheet
B:
215
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
do
not
exist
in
FRS.

Worksheet
C:
530
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
were
not
linked
to
the
same
TRI
IDs
in
FRS,
157
TRI
RCRA
IDs
are
in
FRS
but
linked
to
a
different
TRI
IDs
than
was
reported.
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
4
of
11
2.0
Analysis
Worksheet
A:
102
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
DO
exist
in
FRS,
but
FRS
did
not
link
or
associate
them
to
any
TRI
ID.

I
n
analyzing
the
TRI
2003
data
against
the
criteria
set
in
worksheet
A,
the
analysis
identified
that
102
records
in
FRS
(
See
15­
0050
TRI­
RCRA
Linkages
in
FRS
Attachment
20050606,
worksheet
A)
met
the
criteria.
Displayed
are
a
few
possible
reasons
for
these
two
program
ids
not
being
linked:

1.
TRI
Name
is
the
same
as
RCRA
Name,
but
the
Address
is
different.

Example:

Line
85:
TRI
Name:
Farrar
Corp
TRI
Address:
142
W
BURNS,
NORWICH,
KINGMAN,
KS,
671180008
FRS
ID
(
TRI):
110000446250
RCRA
Name:
Farrar
Corp
RCRA
Address:
118
MAIN,
NORWICH,
KINGMAN,
KS,
67118
FRS
ID
(
RCRA):
110003147924
Further
research
showed
that
according
to
D&
B
Small
Business
Solutions
(
http://
smallbusiness.
dnb.
com),
Farrar
Corp
has
multiple
addresses,
with
the
142
W
Burns
being
the
headquarters
and
118
Main
being
a
branch
location.
Therefore,
these
are
two
different
facilities
and
should
not
be
linked
since
the
Ids
represent
two
distinct
locations.

2.
TRI
Address
is
the
same
as
RCRA
Address,
but
the
Name
is
different.

Example:

Line
98:
TRI
Name:
Taytronics
TRI
Address:
430
RITT
STREET,
SAINT
PETER,
NICOLLET,
MN,
56082
FRS
ID
(
TRI):
110001447211
RCRA
Name:
GTO
Electronics
RCRA
Address:
430
RITT
ST,
ST
PETER,
NICOLLET,
MN,
56082
FRS
ID
(
RCRA):
110009398641
Further
research
was
done
by
looking
the
two
facilities
names
in
D&
B
Small
Business
Solutions.
According
to
D&
B,
both
of
these
names
showed
up
individually
and
did
not
indicate
that
they
are
the
same
company.
In
D&
B,
when
a
company
has
multiple
names,
it
will
list
these
names
as
aliases.
The
website
does
not
list
any
aliases
for
either
Taytronics
or
GTO
Electronics.
Furthermore,
the
main
website
for
Taytronics
(
http://
www.
taytronics.
com)
was
studied
and
did
not
indicate
any
evidence
that
the
company
also
trades
as
GTO
Electronics.
The
two
companies
also
have
different
contact
persons
and
phone
numbers
listed
in
FRS.
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
5
of
11
Given
these
findings,
it
was
concluded
that
these
are
two
different
companies
and
should
not
be
linked.

3.
Neither
TRI
Name
nor
Address
is
an
exact
match
to
RCRA
Name
or
Address,
and
it
cannot
be
concluded
that
they
are
the
same
facility.

Example:

Line
43:
TRI
Name:
AMERICAN
UNIBRASS
TRI
Address:
235
E.
MAIN
ST.,
THOMASTON,
LITCHFIELD,
CT,
06787
FRS
ID
(
TRI):
110012708891
RCRA
Name:
UNITED
OIL
RECOVERY
INC
RCRA
Address:
136
GRACEY
AVE,
MERIDEN,
NEW
HAVEN,
CT,
06451
FRS
ID
(
RCRA):
110000316248
According
to
D&
B
Small
Business
Solutions,
these
two
facilities
do
not
have
aliases,
and
are
listed
separately
as
individual
companies.
In
FRS,
different
contact
names
and
phone
numbers
are
listed
with
different
area
codes.
Given
these
findings,
it
was
concluded
that
these
two
different
companies
should
not
be
linked.

The
above
examples
demonstrate
the
process
FRS
analysts
use
to
determine
whether
two
records
are
duplicates
or
not.
The
FRS,
TRI,
and
RCRA
records
in
these
examples
are
not
linked
because
the
analysis
concluded
that
each
unique
ID
represents
a
distinct
facility.
They
are
not
the
same
place
or
a
duplicate
and
in
these
cases,
a
linkage
would
not
be
appropriate.
A
duplicate
record
may
involve
the
same
name
and
address,
same
address
but
different
name,
or
same
name
but
different
address.
In
order
to
conclude
that
records
are
duplicates,
the
following
must
be
proved:

 
Two
records
with
the
same
name
have
different
addresses
because
one
of
the
addresses
is
obsolete
or
incorrect.
 
Two
records
with
the
same
address
but
different
names
have
multiple
aliases
or
the
two
companies
have
linked
to
form
one.

The
102
records
from
RCRA
that
are
in
FRS
are
not
linked
to
the
TRI
ID's
because
the
research
did
not
prove
the
above
criteria.

In
cases
where
two
records
are
determined
to
not
be
duplicated,
it
may
be
because
a
business
has
multiple
addresses,
(
i.
e.
headquarters
and
subsequent
branches).
Other
times
multiple
businesses
share
one
facility,
and
therefore
multiple
businesses
are
listed
with
the
same
address.
Research
has
been
done
using
various
internet
reference
sites
including
but
not
limited
to:
D&
B
Small
Business
Solutions,
the
Yellow
Pages,
internet
search
engines,
and
FRS.
Information
presented
on
these
websites
help
to
determine
whether
such
facilities
with
these
instances
should
be
linked
or
not.
In
the
cases
of
this
spreadsheet,
it
was
determined
that
they
should
not
be
linked.

Worksheet
B:
215
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
DO
NOT
exist
in
current
FRS
table
that
contains
all
active
program
IDs.
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
6
of
11
The
analysis
identified
that
215
RCRA
IDs
reported
as
linkages
to
TRI
facilities
by
TRI
reporters
do
not
exist
in
the
FRS
active
table.
The
complete
list
can
be
found
in
15­
0050
TRI­
RCRA
Linkages
in
FRS
Attachment
20050606:
Worksheet
B.

15
out
of
215
RCRA
IDs
were
once
in
FRS
active
program
ID
table
but
are
now
archived
in
FRS'
program
ID
history
table.
Each
month,
FRS
extracts
data
from
EPA
national
systems
and
performs
and
Insert,
Update
and
Delete
function
to
program
records.
The
`
ACTIVE'
program
ID
table
in
FRS
contains
all
program
IDs
that
currently
are
valid
within
the
program
national
system
databases.
The
`
Delete'
operation
is
implemented
on
program
IDs
that
no
longer
exist
in
a
national
program
databases.
Rather
than
deleting
any
records
from
the
FRS
database,
FRS
instead
archives
the
records
in
its
history
tables.

200
RCRA
IDs,
in
exception
for
those
15
IDs
mentioned
above,
are
"
unknown"
to
FRS.

Worksheet
C:
530
RCRA
IDs
that
were
reported
as
linkages
to
TRI
by
TRI
reporters
were
not
linked
to
the
same
TRI
IDs
in
FRS,
157
TRI
RCRA
IDs
are
in
FRS
but
linked
to
a
different
TRI
IDs
than
was
reported.

The
TRI
records,
RCRA
records,
and
FRS
records
in
this
worksheet
are
compared
because
of
the
discrepancies
between
TRI­
RCRA
linkages
as
reported
by
TRI
reporters
and
TRI­
RCRA
linkages
as
maintained
in
FRS.

Out
of
the
total
of
530
mismatched
TRI­
RCRA
linkages,
373
RCRA
IDs
that
were
reported
by
TRI
reporters
are
not
currently
in
FRS
active
table.
Four
out
of
373,
however,
were
found
in
FRS
program
ID
history
table,
leaving
369
as
unknown
RCRA
IDs
to
FRS.

Therefore,
in
this
particular
data
set,
only
157
RCRA
IDs
reported
by
TRI
reporters
are
recognized
by
FRS.

I
n
examining
the
unknown
369
RCRA
IDs,
the
analysis
shows
as
follows:

1.
Invalid
RCRA
IDs
reported
by
TRI:
a.
The
RCRA_
ID_
BY_
FRS
almost
matches
the
RCRA_
ID
from
TRI,
except
for
some
common
mistyped
character.

Example
1
(
from
Worksheet
C):

Line
2:
TRI_
ID:
44827GGCMP900SW
RCRA_
ID
(
as
reported
by
TRI):
OHDO61020855
RCRA_
ID_
BY_
FRS:
OHD061020855
NOTE:
The
only
difference
in
these
two
ID's
is
the
fourth
character.
The
reported
TRI
RCRA_
ID,
it
is
a
character,
the
letter
"
O",
and
in
the
correct
RCRA_
ID_
BY_
FRS
form
the
national
system
RCRAInfo
it
is
a
number
zero,
"
0".

Example
2
(
from
Worksheet
C):

Line
2:
TRI_
ID:
02905HDSNT29TER
RCRA_
ID
(
as
reported
by
TRI):
RIC981894967
RCRA_
ID_
BY_
FRS:
RID981894967
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
7
of
11
NOTE:
The
only
difference
in
these
two
ID's
is
the
third
character.
In
the
reported
TRI
RCRA_
ID,
it
is
a
character,
"
C"
and
in
the
correct
RCRA_
ID_
BY_
FRS
from
the
national
system
RCRAInfo
it
is
a
character,
"
D."

Example
3
(
from
Worksheet
C):

Line
43:
50129WCLND601EC
RCRA_
ID
(
as
reported
by
TRI):
IAD0
RCRA_
ID_
BY_
FRS:
IAD047055140
NOTE:
In
the
TRI
RCRA_
ID,
the
first
four
characters
of
RCRA_
ID_
BY_
FRS
are
present.

2.
RCRA
IDs
that
are
recognized
by
FRS:
a.
The
RCRA
IDs
reported
by
TRI
are
not
linked
to
FRS
TRI­
RCRA
linkages
because
of
discrepancies
in
the
name
and
addresses
of
each
record.

Example
1
(
from
Worksheet
C):

Line
511:

From
TRI
2003
Form
R:
TRI
TRI_
ID:
35740BLNYL202JA
TRI_
NAME:
BEAULIEU
FIBERS
TRI_
ADDRESS:
202
JACOBS
AVE,
BRIDGEPORT,
JACKSON,
AL,
35740
RCRA
RCRA_
ID
(
as
reported
by
TRI):
ALD981865488
RCRA_
NAME
(
as
reported
in
RCRAInfoI
to
the
above
ID):
SOUTHERN
AIR
CONTROLS
INC
RCRA_
ADDRESS
(
as
reported
by
RCRAInfo):
149
MCCURDY,
RAINSVILLE,
DE
KALB,
AL,
35986
From
FRS:

FRS
REGISTRY
ID:
110000367852
FRS_
NAME:
BEAULIEU
FIBERS
FRS_
ADDRESS:
202
JACOBS
AVENUE,
BRIDGEPORT,
JACKSON,
AL,
35740
TRI
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
8
of
11
TRI_
ID:
35740BLNYL202JA
TRI_
NAME:
BEAULIEU
FIBERS
TRI_
ADDRESS:
202
JACOBS
AVE,
BRIDGEPORT,
JACKSON,
AL,
35740
RCRA
RCRA_
ID:
ALD983170259
RCRA_
NAME:
BEAULIEU
FIBERS
RCRA_
ADDRESS:
202
JACOBS
AVENUE,
BRIDGEPORT,
JACKSON,
AL,
35740
NOTE:
The
example
above
shows
that
TRI_
ID
35740BLNYL202JA
is
linked
to
RCRA_
ID
ALD983170259
in
FRS.
The
same
TRI_
ID
is
linked
to
RCRA_
ID
ALD981865488
in
the
TRI
Form
R.
While
the
linkage
in
FRS
between
the
TRI_
ID
and
RCRA_
ID
have
the
same
name
and
address,
the
linkage
on
TRI
Form
R
does
not.
This
appears
to
be
a
misreport
from
TRI,
therefore
TRI_
ID
35740BLNYL202JA
to
RCRA_
ID
ALD981865488
are
not
linked
in
FRS.

Example
2
(
from
Worksheet
C):

Line
256:

From
TRI
2003
Form
R:

TRI
TRI_
ID:
80503HLXTC6450D
TRI_
NAME:
HELIX
TECHNOLOGY
CORP
­
COLORADO
OPERATIONS
TRI_
ADDRESS:
6450
DRY
CREEK
PKWY,
LONGMONT,
BOULDER,
CO,
80503
RCRA
RCRA_
ID
(
as
reported
by
TRI):
COR000009456
RCRA_
NAME
(
as
reported
by
RCRAInfo):
AET
ENVIRONMENTAL
RCRA_
ADDRESS
(
as
reported
by
RCRAInfo):
4301
JACKSON
ST,
DENVER,
DENVER,
CO,
80216
From
FRS:

FRS
REGISTRY
ID:
110003002991
FRS_
NAME:
HELIX
TECHNOLOGY
CORPORATION
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
9
of
11
FRS_
ADDRESS:
6450
DRY
CREEK
PARKWAY,
LONGMONT,
BOULDER,
CO,
805039501
TRI
TRI_
ID:
80503HLXTC6450D
TRI_
NAME:
HELIX
TECHNOLOGY
CORP
­
COLORADO
OPERATIONS
TRI_
ADDRESS:
6450
DRY
CREEK
PKWY,
LONGMONT,
BOULDER,
CO,
80503
RCRA
RCRA_
ID:
COR000016741
RCRA_
NAME:
HELIX
TECHNOLOGY
CORP
RCRA_
ADDRESS:
6450
DRY
CREEK
PARKWAY,
LONGMONT,
BOULDER,
CO,
805039501
NOTE:
The
example
above
shows
that
TRI_
ID
80503HLXTC6450D
is
linked
to
RCRA_
ID
COR000016741
in
FRS.
The
same
TRI_
ID
is
linked
to
RCRA_
ID
COR000009456
in
the
TRI
Form
R.
While
the
linkage
in
FRS
between
the
TRI_
ID
and
RCRA_
ID
have
the
same
name
and
address,
the
linkage
on
TRI
Form
R
do
not.
This
appears
to
be
a
misreport
from
TRI,
therefore
TRI_
ID
80503HLXTC6450D
to
RCRA_
ID
COR000009456
are
not
linked
in
FRS.
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
10
of
11
3.0
Conclusion
In
the
analysis
conducted
to
determine
how
well
FRS
has
maintained
the
linkages
among
TRI
and
RCRAINFO,
it
is
concluded
that
FRS
has
completed
sufficient
analysis
and
research
to
indicate
whether
or
not
two
program
IDs
and
program
records
should
be
linked.
Using
the
records
in
the
above
referenced
worksheets
it
has
been
explained
that
there
are
several
reasons
why
these
records
may
not
have
been
linked.

Despite
having
similar
data
such
as
the
same
name,
two
records
may
have
different
addresses.
Similarly,
two
records
might
instead
have
the
same
address
but
different
names
and
thus
research
is
needed
to
discover
that
the
same
location
has
separate
ownership
and
thus
are
operated
as
two
separate
facilities.
These
are
two
common
cases
in
which
further
research
should
be
conducted
to
determine
if
the
two
facilities
are
the
same
and
should
in
fact
be
linked
in
FRS.
Sometimes
the
research
shows
that
these
facilities
should
be
linked
because
of
mistyped
information,
an
incorrect
address,
or
because
one
company
was
bought
out
by
another.
There
are
also
instances
when
a
company
is
known
by
aliases.
Through
research,
analysts
discover
these
situations
and
link
the
records
as
appropriate.

Other
times,
research
indicates
that
two
apparently
similar
records
do
not
represent
the
same
entity
and
should
not
be
linked.
This
may
be
due
to
the
fact
that
a
business
has
multiple
addresses
or
because
multiple
businesses
share
the
same
address.
Therefore,
FRS
appropriately
does
not
link
these
records
to
TRI
reported
RCRA
data.

The
above
reasoning
can
also
be
applied
in
cases
where
TRI
reports
a
different
RCRA
ID
than
FRS.
Many
of
these
ID's
may
be
different
by
one
character
or
number.
The
FRS
analysts
must
determine
if
this
was
most
likely
the
result
of
mistyped
information
or
using
a
number
not
provided
under
the
appropriate
federal
program.

In
conclusion,
based
on
careful
research
and
analysis,
FRS
maintains
appropriate
and
high
quality
linkages
among
TRI
and
RCRAINFO
records.
This
research
is
important
to
maintain
the
integrity
of
the
database
so
that
it
does
not
contain
duplicate
or
incorrectly
linked
information.
ITS­
ESE
06/
30/
05
Doc.
No.:
015­
FRS­
RPT­
0048
Page
11
of
11
4.0
Appendix
Worksheet
A:
TRI
ID's
that
REPORT
RCRA
ID's
that
are
in
FRS
but
in
FRS
the
RCRA
ID
is
not
linked
to
that
TRI
ID
(
102
records)
Worksheet
B:
TRI
ID's
that
REPORT
RCRA
ID's
that
are
not
in
FRS
(
215
records)
Worksheet
C:
530
TRI
IDs
that
reports
different
RCRA
IDs
than
FRS.

Worksheet
A:
Columns:

1.
TRI_
ID:
ID
reported
by
TRI
2.
TRI_
NAME:
Name
reported
by
TRI
3.
TRI_
ADDRESS:
Address
reported
by
TRI
4.
FRS_
TO_
TRI_
ID:
FRS
Registry
ID
assigned
the
given
to
TRI
ID
5.
FRS_
TO_
TRI_
NAME:
FRS
Name
that
has
TRI
ID
6.
FRS_
TO_
TRI_
ADDRESS:
FRS
address
that
has
TRI
ID
7.
RCRA_
BY_
TRI_
ID:
RCRA
ID
reported
by
TRI
8.
RCRA_
BY_
TRI_
NAME:
RCRA
name
reported
by
RCRA
9.
RCRA_
BY_
TRI_
ADDRESS:
RCRA
address
reported
by
RCRA
10.
FRS_
TO_
RCRA_
ID:
FRS
Registry
ID
assigned
to
RCRA
ID
(
That
is
reported
by
TRI).
11.
FRS_
TO_
RCRA_
NAME:
FRS
name
that
has
RCRA
ID
12.
FRS_
TO_
RCRA_
ADDRESS:
FRS
address
that
has
RCRA
ID
Worksheet
B:
Columns:

1.
TRI_
ID:
ID
reported
by
TRI
2.
TRI_
NAME:
Name
reported
by
TRI
3.
TRI_
ADDRESS:
Address
reported
by
TRI
4.
FRS_
TO_
TRI_
ID:
FRS
Registry
ID
assigned
the
given
to
TRI
ID
5.
FRS_
TO_
TRI_
NAME:
FRS
name
that
has
TRI
ID
6.
FRS_
TO_
TRI_
ADDRESS:
FRS
address
that
has
TRI
ID
7.
RCRA_
BY_
TRI_
ID:
RCRA
ID
reported
by
TRI
that
are
not
in
FRS
Worksheet
C:
Columns:
1.
TRI_
ID:
ID
reported
by
TRI
2.
TRI_
NAME:
Name
reported
by
TRI
3.
TRI_
ADDRESS:
Address
reported
by
TRI
4.
RCRA_
ID:
RCRA
ID
reported
by
TRI
5.
RCRA_
ID_
BY_
FRS:
RCRA
ID
reported
by
FRS
that
linked
to
the
same
TRI
ID
6.
RCRA_
BY_
FRS_
NAME:
RCRA
Name
reported
by
RCRA
7.
RCRA_
BY_
FRS_
ADDRESS:
RCRA
Address
reported
by
RCRA
8.
REGISTRY_
ID:
FRS
ID
assigned
to
TRI
ID
9.
FRS_
NAME:
Name
in
FRS
10.
FRS_
ADDRESS:
Address
in
FRS