Toxics Release Inventory (TRI) Basic Plus Data Files Documentation File Type 3b: Details of Transfers to Publicly Owned Treatment Works (POTWS) for Reporting Years 1987-2011 Updated for RY 2017


TOXICS RELEASE INVENTORY
BASIC PLUS DATA FILES DOCUMENTATION
FILE TYPE 3B: DETAILS OF TRANSFERS TO PUBLICLY OWNED
TREATMENT WORKS (POTWs)
For Reporting Years 1987-2011
Updated for RY 2017
July 2018
JPIl rnn United States
Environmental Protection
M m Agency

-------
OVERVIEW OF TRI BASIC PLUS DATA FILES
The TRI "Basic Plus" data files include nine file types that collectively contain all the data fields from the TRI
Reporting Form R and Form A (except Form R Schedule 1). The nine file types are tab-delimited text (.txt) files
packaged into a .zip file.
File
Exarrmle
Descriotion of Contents
Form R/Form A Reference
Type
1
CA_l_2017.txt
Facility data, chemical
identification, chemical uses, on-
site releases and management, off-
site transfers, summary information
Part 1 (all), Part II (section 1, 3,
4, 5, 6.1.A, 6.2ABC,
7B, 7C, 8.2.B, 8.4.B, 8.6.
The Basic Plus Data Files are identified (named) by state, file type, and reporting year:
File Name = State + File Type + Reporting Year
For example, the file "CA_l_2017.txt" contains facility, chemical identification,
chemical use, on-site release and waste management, off-site transfer and summary information (File Type 1)
for all facilities located in California (CA) for reporting year 2017.
In addition to the set of data files for each state, there are two other Basic Plus file sets: Federal and National.
The Federal files (FED_l_2017.txt, FED_2A_2017.txt, etc.) contain TRI data for all government-owned-and-
operated federal sites. The National files (US_l_2017.txt, US_2A_2017.txt, etc.) contain TRI data for all U.S.
states and territories for a specific year.

-------
DESCRIPTION OF FILE TYPE 3B CONTENTS
File Type 3B contains data about transfers of wastewater containing TRI chemicals to Publicly Owned
Treatment Works (POTWs) for Reporting Years (RY) 1987 to 2011. In the years covered by this file, a
facility only had to report the total amount of a chemical transferred to aN POTWs, and a list of POTWs
the chemical was transferred to. Facilities weren't required to report how much of the chemical was
transferred to each POTW or how the chemical was managed once at the POTW. These details were
required for RY 2012 and later, however, and those data are available in Basic Plus File 3C.
The data in File 3B come from the TRI Reporting Form, as shown in the table below. Each record in File
Type 3B represents data from a single chemical reporting form (i.e., Form R) submitted by a facility.
Part
Section
Description
1
1
Reporting Year
1
1
Revision Codes
1
4
Facility Identification Information
1
5
Parent Company Information
1
1
Chemical Identification Data
II
6.1.A.1
Total Transfers (to POTWs)
II
6.1.A.2
Basis of Estimate
II
6.1.B
POTW Name and Address

-------
WHAT'S IN THIS DOCUMENT
The rest of this document is organized as a four-column data table. It describes what information you will
find when you download and open any of the "TRI Basic Plus Data: File Type 3B" files.
Column
Description
Number (No.)
The sequential number of the data element in the record
Field Name
The name of the data element (Note: these names correspond to the various
column headings in the data files themselves.)
Data Type
'C' for character data (alphanumeric)
'N' for numeric data
'D' for date
Description
A brief statement of what the data element represents, plus its TRI System
Source (in Table Name. Field Name format) and where on the TRI Reporting
Form R the data element is reported (i.e., reference). TRI System Source refers
to the data element's physical location within EPA's Envirofacts online data
warehouse.
When you open any of the Basic Plus data files, you'll see that the contents are delimited by tabs,
meaning a tab is placed between each data element. The first row of each file contains column headers,
which correspond to the "field names" in this document.
I
c
1 | REPORTING YEAR TRADE SECRET INDICATOR TRIFID
2 j2016 NO 37087TSHBM1420T
3 (2016 NO 2740WNVRNMS37TR
4 12016 NO 7585WS N DRS485HI
Example of the first four rows of a Basic Plus data file
FACILITY NAME
NOVAMET SPECIALTY PRODUCTS
ENVIRONMENTAL AIR SYSTEMS INC-TRIAD
SANDERSON FARMS OAKWOOD FEED MILL
REMINDER: Quantities of dioxin and dioxin-like compounds are in grams. Quantities of all other TRI chemicals
are reported in pounds. Facilities cannot use range codes to report quantities for dioxin and dioxin-like
compounds and other Persistent Bioaccumulative Toxics (PBTs). For a list of PBT chemicals see "Appendix C:
Persistent Bioaccumulative Toxics (PBTs)."
HELPFUL RESOURCES FOR USERS OF DOWNLOADABLE DATA FILES
When using any of the downloadable TRI data files, it will be helpful for users to refer to the TRI Reporting
Form R, the TRI Reporting Forms & Instructions document, and the Envirofacts TRI data model. The Reporting
Forms & Instructions document and sample reporting forms are available online in the GuideME application
at www.epa.gov/tri/guideme. The Envirofacts TRI data model is found at https://www.epa.gov/enviro/tri~
model. These resources provide useful context and have additional details about certain data elements.

-------
FILE TYPE 3B CONTENTS
No.
Field Name
Type
Description
1
TRIFD
C
Facility identification in the format zzzzznnnnnsssss, where usually
zzzzz = facility zip code, nnnnn = first five consonants of the name,
and sssss = first five non-specific characters in the street address.
The three sections of the format were separated by hyphens prior
to RY 2006.
NOTE: The content of this field is not changed to match facility
ownership, or zip code changes. Rather, the TRI Facility ID
identifies a specific geographical location which is also identified
by the latitude and longitude of that location.
Source: TRI_FACILITY.TRI_FACI LITYJD
Reference: Part 1, Section 4.1
2
DOCUMENT CONTROL NUMBER
C
Unique identification number assigned to each submission by EPA.
Format: TTYYMMMNNNNNC, where
TT = document type
YY = reporting year
MMM = document type
NNNNN= sequential number
C = check digit
Source: TRI_REPORTING_FORM.DOC_CTRL_NUM
Reference: NA (System-generated)
3
CAS NUMBER
C
Chemical Abstracts Service (CAS) Registry Number for unique
chemical, or category code (for compounds).
NOTE: CAS number 999999999 is for sanitized trade secret
submissions; CHEM_NAME displays the reported generic chemical
name.
Source: TRI_REPORTING_FORM.TRI_CHEM_ID
Reference: Part II, Section 1.1
4
CHEMICAL NAME

Name of the chemical (or generic name, if the chemical is claimed
as a trade secret).
Source: TRI_REPORTING_FORM.CAS_CHEM_NAME
Reference: Part II, Section 1.2 or Part II, Section 1.3
5
CLASSIFICATION
C
Indicates the classification of the chemical. Chemicals can be
classified as either a dioxin or dioxin-like compound, a Persistent,
Bioaccumulative and Toxic chemical, or a general EPCRA Section
313 chemical.
Values: {TRI, PBT, DIOXIN} where:
TRI = General EPCRA Section 313 chemical
PBT = Persistent, Bioaccumulative and Toxic
DIOXIN = Dioxin or dioxin-like compound
Source: TRI_CHEM_INFO.CLASSIFICATION
Reference: NONE
6
UNIT OF MEASURE
C
Indicates the unit of measure used to quantify the chemical.
Dioxin and dioxin-like compounds are measured in grams, while all
other TRI chemicals are measured and reported in pounds. Values:
{Pounds, Grams}

-------
No. Field Name Type Description



Source; TRI_CHEM_INFO. U N IT_0 F_M EASU RE
Reference: NONE
7
METALJND
C
Code indicating whether the is a metal or not.
Yes = Metal
No = Non-Metal
See "Appendix B - Chemical Classifications - Metals" for a list of
metals on the TRI chemical list.
Source: TRI CHEM INFO.Metal Ind
8
REVISION CODE 1
C
If the facility revised its original TRI reporting form for this
chemical, this code indicates the reason for the revision.
Values:
RR1 = New Monitoring Data
RR2 = New Emission Factors
RR3 = New Chemical Concentration Data
RR4 = Recalculation(s)
RR5 = Other Reason(s)
Source: TRI REPORTING FORM.Revision Code
9
REVISION CODE 2
C
If the facility revised its original TRI reporting form for this
chemical, this code indicates the reason for the revision.
Values:
RR1 = New Monitoring Data
RR2 = New Emission Factors
RR3 = New Chemical Concentration Data
RR4 = Recalculation(s)
RR5 = Other Reason(s)
Source: TRI REPORTING FORM.Revision Code
10
DIOXIN DISTRIBUTION 1
N
Indicates the percentage of 1,2,3,4,6,7,8
Heptachlorodibenzofuran (CAS # 67562-39-4) in the reported
dioxin or dioxin-like compound. Values are either 0 or a
number between 0 and 100 (inclusive). This data element
collected from RY 2000 through 2007. See Appendix D - Dioxin
and Dioxin-like Compound Data for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_l
Reference: Part II, Section 1.4
11
DIOXIN DISTRIBUTION 2
N
Indicates the percentage of 1,2,3,4,7,8,9
Heptachlorodibenzofuran (CAS # 55673-89-7) in the reported
dioxin or dioxin-like compound. Values are either 0 or a
number between 0 and 100 (inclusive). This data element
collected from RY 2000 through 2007. See Appendix D - Dioxin
and Dioxin-like Compound Data for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_2
Reference: Part II, Section 1.4
12
DIOXIN DISTRIBUTION 3
N
Indicates the percentage of 1,2,3,4,7,8 Hexachlorodibenzofuran
(CAS # 70648-26-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.

-------
No.
Field Name
Type
Description



Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_3
Reference: Part II, Section 1.4
13
DIOXIN DISTRIBUTION 4
N
Indicates the percentage of 1,2,3,6,7,8 Hexachlorodibenzofuran
(CAS # 57117-44-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data
for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_4
Reference: Part II, Section 1.4
14
DIOXIN DISTRIBUTION 5
N
Indicates the percentage of 1,2,3,7,8,9 Hexachlorodibenzofuran
(CAS # 72918-21-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data
for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_5
Reference: Part II, Section 1.4
15
DIOXIN DISTRIBUTION 6
N
Indicates the percentage of 2,3,4,6,7,8
Hexachlorodibenzofuran (CAS # 60851-34-5) in the
reported dioxin or dioxin-like compound. Values are
either 0 or a number between 0 and 100 (inclusive).
This data element collected from RY 2000 through 2007.
See Appendix D - Dioxin and Dioxin-like Compound Data
for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_6
Reference: Part II, Section 1.4
16
DIOXIN DISTRIBUTION 7
N
Indicates the percentage of 1,2,3,4,7,8 Hexachlorodibenzo-p-
dioxin (CAS # 39227-28-6) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_7
Reference: Part II, Section 1.4
17
DIOXIN DISTRIBUTION 8
N
Indicates the percentage of 1,2,3,6,7,8 Hexachlorodibenzo- p-
dioxin (CAS # 5765385-7) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0. and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_8
Reference: Part II, Section 1.4
18
DIOXIN DISTRIBUTION 9
N
Indicates the percentage of 1,2,3,7,8,9 Hexachlorodibenzo-p-
dioxin (CAS # 19408-74-3) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See "Appendix D - Dioxin and Dioxin-like Compound Data"

-------
No.
Field Name
Type
Description



for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_9
Reference: Part II, Section 1.4
19
DIOXIN DISTRIBUTION 10
N
Indicates the percentage of 1,2,3,4,6,7,8 Heptachlorodibenzo-p-
dioxin (CAS # 35822-46-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_10
Reference: Part II, Section 1.4
20
DIOXIN DISTRIBUTION 11
N
Indicates the percentage of 1,2,3,4,6,7,8,9
Octachlorodibenzofuran (CAS # 39001-02-0) in the reported
dioxin or dioxin-like compound. Values are either 0 or a number
between 0 and 100 (inclusive). This data element collected from
RY 2000 through 2007. See Appendix D - Dioxin and Dioxin-like
Compound Data for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_ll
Reference: Part II, Section 1.4
21
DIOXIN DISTRIBUTION 12
N
Indicates the percentage of 1,2,3,4,6,7,8,9 Octachlorodibenzo-p-
dioxin (CAS # 03268-87-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_12
Reference: Part II, Section 1.4
22
DIOXIN DISTRIBUTION 13
N
Indicates the percentage of 1,2,3,7,8
Pentachlorodibenzofuran (CAS # 57117-41-6) in the
reported dioxin or dioxin-like compound. Values are
either 0 or a number between 0 and 100 (inclusive).
This data element collected from RY 2000 through 2007.
See Appendix D - Dioxin and Dioxin-like Compound Data
for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_13
Reference: Part II, Section 1.4
23
DIOXIN DISTRIBUTION 14
N
Indicates the percentage of 2,3,4,7,8 Pentachlorodibenzofuran
(CAS # 57117-31-4) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_14
Reference: Part II, Section 1.4
24
DIOXIN DISTRIBUTION 15
N
Indicates the percentage of 1,2,3,7,8 Pentachlorodibenzo-p-dioxin
(CAS # 40321-76-4) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for

-------
No. Field Name Type Description



more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_15
Reference: Part II, Section 1.4
25
DIOXIN DISTRIBUTION 16
N
Indicates the percentage of 2,3,7,8 Tetrachlorodibenzofuran
(CAS # 51207-31-9) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data
for more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_16
Reference: Part II, Section 1.4
26
DIOXIN DISTRIBUTION 17
N
Indicates the percentage of 2,3,78 Tetrachlorodibenzo-p-dioxin
(CAS # 01746-01-6) in the reported dioxin or dioxin-like
compound. Values are either 0 or a number between 0 and 100
(inclusive). This data element collected from RY 2000 through
2007. See Appendix D - Dioxin and Dioxin-like Compound Data for
more information.
Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_17
Reference: Part II, Section 1.4
27
REPORTING YEAR

The calendar year in which the reported activities occurred.
Source: TRI_REPORTING_FORM.REPORTING_YEAR
Reference: Part 1, Section 1
28
TRADE SECRET INDICATOR
C
Indicates whether the reporting facility claims the identity of the
chemical or chemical category as a trade secret.
Yes = Checked (Trade Secret)
No = Not checked
Note: Only sanitized trade secret submissions are stored in the TRI
database.
Source: TRI_REPORTING_FORM.TRADE_SECRET_IND
Reference: Part 1, Section 2.1
29
FACILITY NAME
C
Name of the reporting facility.
Source: TRI_FACILITY.FACILITY_NAME
Reference: Part 1, Section 4.1
30
FACILITY STREET
C
Street address of the reporting facility.
Source: TRI_FACILITY.STREET_ADDRESS
Reference: Part 1, Section 4.1
31
FACILITY CITY
C
City in which the reporting facility is located.
Source: TRI_FACILITY.CITY_NAME
Reference: Part 1, Section 4.1
32
FACILITY COUNTY
C
County in which the reporting facility is located.
Source: TRI_FACILITY.COUNTY_NAME
Reference: Part 1, Section 4.1
33
FACILITY STATE
C
Two-letter state code of the reporting facility.
Source: TRI_FACILITY.STATE ABBR
Reference: Part 1, Section 4.1
34
FACILITY ZIP CODE
C
ZIP code of the reporting facility.
Source: TRI FACILITY.ZIP CODE

-------
No.
Field Name
Type
Description



Reference: Part 1, Section 4.1
35
ASSIGNED FED. FACILITY FLAG
C
Code indicating whether the Facility is federal or not.
Assigned by TRI.
Yes = Federal
No = Non-Federal
Source: TRI FACILITY.ASGN FEDERAL
36
BIA CODE
C
Three-letter Bureau of Indian Affairs (BIA) code indicating the
tribal land the facility is on.
Source: FACILITY.BIA TRIBAL CODE
37
TRIBE NAME
C
The name of the Tribe.
Source: V INDIAN COUNTRY.
38
ENTIRE FACILITY IND
C
Indicates whether the information covers an entire facility or part
of a facility.
Yes = entire
No = partial
Source: TRI_REPORTING_FORM.ENTIRE_FAC
Reference: Part 1, Section 4.2a
39
PARTIAL FACILITY IND
C
Indicates whether the information covers an entire facility or part
of a facility.
Yes = partial
No = entire
Source: TRI_REPORTING_FORM. PARTI ALFAC
Reference: Part 1, Section 4.2b
40
FEDERAL FACILITY IND
C
Code indicating whether a facility is a federal facility or not.
Reported by facility.
Yes = Federal
No = non-Federal Value
Source: TRI_REPORTING_FORM.FEDERAL_ FACJND
Reference: Part 1 Section 4.2c
41
GOCO FACILITY IND
C
Code indicating whether a facility is a GOCO (Government Owned,
Contractor-Operated) facility or not:
Yes = GOCO
No = non-GOCO
Source: TRI_REPORTING_FORM.GOCO_ FLAG
Reference: Part 1 Section 4.2d
42
PUBLIC CONTACT NAME
C
Name of the individual whom the public may contact if
clarification of data is needed.
Source: TRI_REPORTING_FORM.PUBLIC_ CONTACT_PERSON
Reference: Part 1, Section 4.4
43
PUBLIC CONTACT PHONE
C
Area code and telephone number of the public contact.
Source: TRI_REPORTING_FORM.PUBLIC_ CONTACT_PHONE
Reference: Part 1, Section 4.4
44
PUBLIC CONTACT PHONE EXT
C
Phone extension of the public contact.
Source: TRI_REPORTING_FORM.PUBLIC_PHONE_EXT
Reference: Part 1, Section 4.4
45
PUBLIC CONTACT EMAIL
C
Email address of the designated individual whom the public may

-------
No.
Field Name
Type
Description



contact if clarification of the facility's reported data is needed.
Source:
TRI_REPORTING_FORM.PUBLIC_CONTACT_PERSON_EMAIL
Reference: Part 1, Section 4.4
46
PRIMARY SIC CODE
C
Primary four-digit Standard Industrial Classification (SIC) code.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: primary_ind = >1'
Reference: Part 1, Section 4.5a
47
SIC CODE 2
C
Second four-digit Standard Industrial Classification (SIC) code
entered by facility.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num = >2'
Reference: Part 1, Section 4.5b
48
SIC CODE 3
C
Third four-digit Standard Industrial Classification (SIC) code
entered by facility.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num = >3'
Reference: Part 1, Section 4.5c
49
SIC CODE 4
C
Fourth four-digit Standard Industrial Classification (SIC) code
entered by facility.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num = >4'
Reference: Part 1, Section 4.5d
50
SIC CODE 5
C
Fifth four-digit Standard Industrial Classification (SIC) code
entered by facility.
Source: TRI_SUBMISSION_SIC. SIC_CODE
Where: sic_sequence_num = >5'
Reference: Part 1, Section 4.5e
51
SIC CODE 6
C
Sixth four-digit Standard Industrial Classification (SIC) code
entered by facility.
Source: TRI_SUBMISSION_SIC. SIC_CODE
Where: sic_sequence_num = >6'
Reference: Part 1, Section 4.5f
52
NAICS ORIGIN
C
Indicates whether NAICS codes were reported or assigned.
R = Reported
A = Assigned
53
PRIMARY NAICS CODE
C
Primary six-digit North American Standard Industry
Classification System (NAICS) code.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: primary_ind => 1
Reference: Part 1, Section 4.5a
54
NAICS CODE 2
C
Second six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 2
Reference: Part 1, Section 4.5b

-------
No.
Field Name
Type
Description
55
NAICS CODE 3
C
Third six-digit North American Standard Industry Classification
System (NAICS) code entered by facility.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 3
Reference: Part 1, Section 4.5b
56
NAICS CODE 4
C
Forth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 4
Reference: Part 1, Section 4.5b
57
NAICS CODE 5
C
Fifth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 5
Reference: Part 1, Section 4.5b
58
NAICS CODE 6
C
Sixth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 6
Reference: Part 1, Section 4.5b
59
LATITUDE
N
The latitude value that best represents the facility according to
EPA's Facility Registry System (FRS). In RY 2005, EPA stopped
collecting the latitude value and began obtaining it from FRS.
Format: signed 2-digit whole number, 6 digit decimal positions
(+nn.nnnnnn).
Source: EPA's Facility Registry System
60
LONGITUDE
N
The longitude value that best represents the facility according to
EPA's Facility Registry System (FRS). In 2005, TRI stopped
collecting the longitude value and began obtaining it from FRS.
Format: signed 3-digit whole number, 6-digit decimal positions
(+nnn.nnnnnn).
Source: EPA's Facility Registry System
61
D&B NR A
C
Unique identification number assigned by Dun and Bradstreet
to the reporting facility.
Source: TRI_FACILITY_DB.D B_N U M
Reference: Part 1, Section 4.7a
62
D&B NR B
C
Unique identification number assigned by Dun and Bradstreet
to the reporting facility.
Source: TRI_FACILITY_DB.DB_N U M
Reference: Part 1, Section 4.7b
63
RCRA NR A
C
Twelve-digit alphanumeric identifier assigned by EPA per the
Resource Conservation and Recovery Act (RCRA). In RY 2005, TRI
stopped collecting RCRA IDs and began obtaining them from EPA's
Facility Registry System (FRS).
Source: EPA's Facility Registry System
64
RCRA NR B
C
Twelve-digit alphanumeric identifier assigned by EPA per the

-------
No.
Field Name
Type
Description



Resource Conservation and Recovery Act (RCRA). In RY 2005, TRI
stopped collecting RCRA IDs and began obtaining them from EPA's
Facility Registry System (FRS).
Source: EPA's Facility Registry System
65
NPDES NR A
C
Nine-digit alphanumeric identifier assigned to a facility in EPA's
National Pollutant Discharge Elimination System (NPDES). In RY
2006, TRI stopped collecting NPDES IDs and began obtaining them
from EPA's Facility Registry System (FRS).
Source: EPA's Facility Registry System
66
NPDES NR B
C
Nine-digit alphanumeric identifier assigned to a facility in EPA's
National Pollutant Discharge Elimination System (NPDES). In RY
2006, TRI stopped collecting NPDES IDs and began obtaining them
from EPA's Facility Registry System (FRS).
Source: EPA's Facility Registry System
67
UIC NR A
C
Underground injection identification number, assigned by EPA or
the state, to a facility. In RY 2006, TRI stopped collecting UIC IDs
and began obtaining them from EPA's Facility Registry System
(FRS).
Source: EPA's Facility Registry System
68
UIC NR B
C
Underground injection identification number, assigned by EPA or
the state, to a facility. In RY 2006, TRI stopped collecting UIC IDs
and began obtaining them from EPA's Facility Registry System
(FRS).
Source: EPA's Facility Registry System
69
PARENT COMPANY NAME
C
Name of the corporation or other business entity that controls
the reporting facility.
Source: TRI_FACILITY.PARENT_CO_N AME
Reference: Part 1, Section 5.1
70
PARENT COMPANY D&B NR
C
Unique identification number assigned by Dun and Bradstreet to
the parent company of the reporting facility.
Source: TRI_FACILITY.PARENT_CO_DB_N UM
Reference: Part 1, Section 5.2
71
POTW TRANSFERS - TOTAL
N
Total quantity of the chemical contained in wastewater
transferred off site to a Publicly Owned Treatment Works
(POTW).
Source: TRI_TRANSFER_QTY.TRANSFER_TOTAL +
TRI_TRANSFER_QTY.TRANSFER_ RANGE_CODE
Reference: Part II, Section 6.1.A.1
72
POTW TRANSFERS - TOTAL -
BASIS OF ESTIMATE
C
A code indicating the principal method by which the total
POTW transfer estimate was calculated. The codes and
corresponding methods are:
C = mass balance calculations
E = published emission factors
El = published emission factors
E2 = on site-specific emission factors
M = monitoring data

-------
No. Field Name Type Description



Ml = continuous monitoring data
M2 = periodic/random monitoring data
NA = not applicable
0 = other
X = invalid data
Source: TRI_TRANSFER_QTY.TRANSFER_BASIS_ EST_CODE
Reference: Part II, Section 6.1.A.2
73
POTW TRANSFERS - RELEASE
N
Total quantity of the transfer that was released at the POTW.
Source: TRI_TRANSFER_QTY.TRANSFER_TOTAL +
TRI_TRANSFER_QTY.TRANSFER_ RANGE_CODE
Where: Chemical is a metal. See Appendix B for details.
Reference: Part II, Section 6.1.A.1
74
POTW TRANSFERS - TREATED
N
Total quantity of the transfer that was treated at the POTW.
Source: TRI_TRANSFER_QTY.TRANSFER_TOTAL +
TRI_TRANSFER_QTY.TRANSFER_ RANGE_CODE
Where: Chemical is a metal. See Appendix B for details.
Reference: Part II, Section 6.1.A.1
75
POTW A-NAME
C
Name of the Publicly Owned Treatment Works (POTW) location
to which the wastewater containing the chemical was sent.
Source: TRI_POTW_LOCATION. POTW_N AM E
Reference: Part II, Section 6.1.B.1
76
POTW A-ADDRESS
C
Street address of the POTW location to which the
chemical was sent.
Source: TRI_POTW_LOCATION.POTW_STREET
Reference: Part II, Section 6.1.B.1
77
POTW A - CITY
C
Name of the city in which the POTW site is located.
Source: TRI_POTW_LOCATION.CITY_NAME
Reference: Part II, Section 6.1.B.1
78
POTW A - STATE
C
The two-letter state abbreviation of the POTW site.
Source: TRI_POTW_LOCATION.STATE_ABBR
Reference: Part II, Section 6.1.B.1
79
POTW A-COUNTY
C
Name of the county in which the POTW site is located.
Source: TRI_POTW_LOCATION.COUNTY_NAME
Reference: Part II, Section 6.1.B.1
80
POTW A-ZIP
C
ZIP code used in the address of a POTW site.
Source: TRI_POTW_LOCATION.ZIP_CODE
Reference: Part II, Section 6.1.B.1
81
POTW B - NAME
C
Name of the Publicly Owned Treatment Works (POTW) location
to which the wastewater containing the chemical was sent.
Source: TRI_POTW_LOCATION. POTW_N AM E
Reference: Part II, Section 6.1.B.2
82
POTW B - ADDRESS
C
Street address of the POTW location to which the chemical was
sent.
Source: TRI_POTW_LOCATION.POTW_STREET
Reference: Part II, Section 6.1.B.2
83
POTW B - CITY
C
Name of the city in which the POTW site is located.

-------
No.
Field Name
Type
Description



Source: TRI_POTW_LOCATION.CITY_NAME
Reference: Part II, Section 6.1.B.2
84
POTW B - STATE
C
The two-letter state abbreviation of the POTW site.
Source: TRI_POTW_LOCATION.STATE_ABBR
Reference: Part II, Section 6.1.B.2
85
POTW B- COUNTY
C
Name of the county in which the POTW site is located.
Source: TRI_POTW_LOCATION.COUNTY_NAME
Reference: Part II, Section 6.1.B.2
86
POTW B-ZIP
C
ZIP code used in the address of a POTW site.
Source: TRI_POTW_LOCATION.ZIP_CODE
Reference: Part II, Section 6.1.B.1
87
POTW C-NAME
C
Name of the Publicly Owned Treatment Works (POTW) location
to which the wastewater containing the chemical was sent.
Source: TRI_POTW_LOCATION. POTW_N AM E
Reference: Part II, Section 6.1.C.2
88
POTW C - ADDRESS
C
Street address of the POTW location to which the chemical was
sent.
Source: TRI_POTW_LOCATION.POTW_STREET
Reference: Part II, Section 6.1.C.2
89
POTW C - CITY
C
Name of the city in which the POTW site is located.
Source: TRI_POTW_LOCATION.CITY_NAME
Reference: Part II, Section 6.1.C.2
90
POTW C - STATE
C
The two-letter state abbreviation of the POTW site.
Source: TRI_POTW_LOCATION.STATE_ABBR
Reference: Part II, Section 6.1.C.2
91
POTW C-COUNTY
C
Name of the county in which the POTW site is located.
Source: TRI_POTW_LOCATION.COUNTY_NAME
Reference: Part II, Section 6.1.C.2
92
POTW C-ZIP
C
ZIP code used in the address of a POTW site.
Source: TRI_POTW_LOCATION.ZIP_CODE
Reference: Part II, Section 6.1.C.1
93
POTW D - NAME
C
Name of the Publicly Owned Treatment Works (POTW) location
to which the wastewater containing the chemical was sent.
Source: TRI_POTW_LOCATION. POTW_N AM E
Reference: Part II, Section 6.1.D.2
94
POTW D - ADDRESS
C
Street address of the POTW location to which the chemical was
sent.
Source: TRI_POTW_LOCATION.POTW_STREET
Reference: Part II, Section 6.1.D.2
95
POTW D - CITY
C
Name of the city in which the POTW site is located.
Source: TRI_POTW_LOCATION.CITY_NAME
Reference: Part II, Section 6.1.D.2

-------
No.
Field Name
Type
Description
96
POTW D - STATE
C
The two-letter state abbreviation of the POTW site.
Source: TRI_POTW_LOCATION.STATE_ABBR
Reference: Part II, Section 6.1.D.2
97
POTWD-COUNTY
C
Name of the county in which the POTW site is located.
Source: TRI_POTW_LOCATION.COUNTY_NAME
Reference: Part II, Section 6.1.D.2
98
POTW D-ZIP
C
ZIP code used in the address of a POTW site.
Source: TRI_POTW_LOCATION.ZIP_CODE
Reference: Part II, Section 6.1.D.1
99
TOTAL POTW LOCATIONS
N
Total Number of POTW locations reported on the submission.
Source: TRI_POTW_LOCATION.POTW_LOC_NUM
Reference: Part II, Section 6.1
100
ADDITIONAL POTWS NOT
SHOWN
N
The number of POTW locations not shown. This file (3B) provides
a record layout that displays up to four POTW locations (POTW A
to POTW D). Out of 2 million Form R submissions received by EPA
for RY 1987 to 2011, only 75 have more than four POTWs listed as
off-site transfer locations. See "Appendix A - Accessing All POTW
Locations" for instructions on how to get information about all
locations.

-------
APPENDIX A - Accessing All POTW Locations
Not all the POTW locations reported are included in this file. The record layout for File Type 3B holds up to
four POTW locations. Of the approximately 2.1 million TRI submissions submitted in RY 1987 to 2011 (the
years covered by this file), roughly 75 submissions had more than four POTWs reported on them; facilities
could report a maximum of 21 POTW locations during these years.
The final field in the File 3B record layout, "Additional POTWs not Shown," indicates the number of POTWs
reported on the form but not displayed in the data file. To see all the POTW locations reported on the form,
use the "POTW Transfer Locations" report in the TRI EZ Search section of EPA's Envirofacts at:
https://iaspyb.epa.gov/etiviro/ez column v2.1ist?database type=TRl&table name=¥ TRI TRANS POTW LOC EZ
Here are the instructions:
1. Go to the "POTW Transfers Locations" report in "EZ Search" in the TRI Section of Envirofacts at:
https://iaspub.epa.eov/enviro/ez column v2.list?database type=TRI&table name V| J_ M J NS POT
W LOC EZ
2. Click the "check box" in front of any of the columns you'd like to display in the final report. Include the
field "Document_Control_Number" (field #2 from this file).
3. Scroll to the bottom of the page and click the button "Step3: Enter Search Criteria"
4. The "Step 3: Enter Search Criteria and Organize Ouptut" page appears.
5. Copy DOCUMENT_CONTROL_NUMBER from File 3B that you want to see all the POTW Locations for
into the search box for "Document_Control_Number" and/or put in any other search criteria needed.
6. Scroll to the bottom of the page and click the "Search Database" button.
7. The results will appear on the next page, listing all POTW locations.

-------
APPENDIX B - Chemical Classification - Metals
Category 1 Metals (Metaljnd ='1')
Chemical
CAS#
TRI Chemical ID
ANTIMONY
7440-36-0
007440360
ANTIMONY COMPOUNDS
N010
N010
ARSENIC
7440-38-2
007440382
ARSENIC COMPOUNDS
N020
N020
BERYLLIUM
7440-41-7
007440417
BERYLLIUM COMPOUNDS
N050
N050
CADMIUM
7440-43-9
007440439
CADMIUM COMPOUNDS
N078
N078
CHROMIUM
7440-47-3
007440473
CHROMIUM COMPOUNDS
(EXCEPT CHROMITE ORE MINED IN THE TRANSVAAL REGION)
N090
N090
COBALT
7440-48-4
007440484
COBALT COMPOUNDS
N096
N096
COPPER
7440-50-8
007440508
COPPER COMPOUNDS
N100
N100
LEAD
7439-92-1
007439921
LEAD COMPOUNDS
N420
N420
MANGANESE
7439-96-5
007439965
MANGANESE COMPOUNDS
N450
N450
MERCURY
7439-97-6
007439976
MERCURY COMPOUNDS
N458
N458
NICKEL
7440-02-0
007440020
NICKEL COMPOUNDS
N495
N495
SELENIUM
7782-49-2
007782492
SELENIUM COMPOUNDS
N725
N725
SILVER
7440-22-4
007440224
SILVER COMPOUNDS
N740
N740
THALLIUM
7440-28-0
007440280
THALLIUM COMPOUNDS
N760
N760
VANADIUM COMPOUNDS
N770
N770
ZINC COMPOUNDS
N982
N982

-------
APPENDIX B - Chemical Classification - Metals (cont.)
Category 2 Metals (Metaljnd = '2')
Chemical
CAS#
TRI Chemical ID
ALUMINUM OXIDE vfibrouc forms,
1344-28-1
001344281
ALUMINUM PHOSPHIDE
20859-73-8
020859738
ASBESTOS (FRIABLE)
1332-21-4
001332214
BIS(TRIBUTYLTIN) OXIDE
56-35-9
000056359
BORON TRICHLORIDE
10294-34-5
010294345
BORON TRIFLUORIDE
7637-07-2
007637072
C.I. DIRECT BLUE 218
28407-37-6
028407376
C.I. DIRECT BROWN 95
16071-86-6
016071866
FENBUTATIN OXIDE
13356-08-6
013356086
FERBAM
14484-64-1
014484641
IRON PENTACARBONYL
13463-40-6
013463406
LITHIUM CARBONATE
554-13-2
000554132
MANEB
12427-38-2
012427382
METIRAM
9006-42-2
009006422
MOLYBDENUM TRIOXIDE
1313-27-5
001313275
OSMIUM TETROXIDE
20816-12-0
020816120
POTASSIUM BROMATE
7758-01-2
007758012
SODIUM NITRITE
7632-00-0
007632000
THORIUM DIOXIDE
1314-20-1
001314201
TITANIUM TETRACHLORIDE
7550-45-0
007550450
TRIBUTYLTIN FLUORIDE
1983-10-4
001983104
TRIBUTYLTIN METHACRYLATE
2155-70-6
002155706
TRIPHENYLTIN CHLORIDE
639-58-7
000639587
TRIPHENYLTIN HYDROXIDE
76-87-9
000076879
ZINEB
12122-67-7
012122677
Category 3 Metals (Metaljnd = '3')
Chemical
CAS#
TRI Chemical ID
BARIUM
7440-39-3
007440393
BARIUM COMPOUNDS
N040
N040
Category 4 Metals (Metaljnd ='4')
Chemical
CAS#
TRI Chemical ID
ALUMINUM (FUME OR DUST)
7429-90-5
007429905
VANADIUM ( EXCEPT WHEN contained in AN ALLOY)
7440-62-2
007440622
ZINC (FUME OR DUST)
7440-66-6
007440666

-------
APPENDIX C - Persistent Bio-accumulative Toxics (PBTs)
Chemical
CAS#
TRI Chemical ID
ALDRIN
309-00-2
000309002
BENZO(G H l)PERYLENE
191-24-2
000191242
CHLORDANE
57-74-9
000057749
DIOXIN AND DIOXIN-LIKE COMPOUNDS
N150
N150
HEPTACHLOR
76-44-8
000076448
HEXABROMOCYCLODODECANE
N270
N270
HEXACHLOROBENZENE
118-74-1
000118741
ISODRIN
465-73-6
000465736
LEAD
7439-92-1
007439921
LEAD COMPOUNDS
N420
N420
MERCURY
7439-97-6
007439976
MERCURY COMPOUNDS
N458
N458
METHOXYCHLOR
72-43-5
000072435
OCTACHLOROSTYRENE
29082-74-4
029082744
PENDIMETHALIN
40487-42-1
040487421
PENTACHLOROBENZENE
608-93-5
000608935
POLYCHLORINATED BIPHENYLS
1336-36-3
001336363
POLYCYCLIC AROMATIC COMPOUNDS
N590
N590
TETRABROMOBISPHENOL A
79-94-7
000079947
TOXAPHENE
8001-35-2
008001352
TRIFLURALIN
1582-09-8
001582098

-------