TOXICS RELEASE INVENTORY BASIC PLUS DATA FILES DOCUMENTATION FILE TYPE 3B: DETAILS OF TRANSFERS TO PUBLICLY OWNED TREATMENT WORKS (POTWs) For Reporting Years 1987-2010 Updated for RY 2018 December 2019 wmmmyai United States Environmental Protection Lwl Agency ------- OVERVIEW OF TRI BASIC PLUS DATA FILES The TRI "Basic Plus" data files include 10 file types that collectively contain all the data fields from the TRI Reporting Form R and Form A (except Form R Schedule 1). The 10 file types are tab-delimited text (.txt) files packaged into a .zip file. File Exarrmle Descriotion of Contents Form R/Form A Reference Type 1A CA_lA_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_lA_2017.txt" contains facility, chemical identification, chemical use, on-site release and waste management, off-site transfer and summary information (File Type 1A) 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_lA_2017.txt, FED_2A_2017.txt, etc.) contain TRI data for all government-owned-and- operated federal sites. The National files (US_lA_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 2010. In the years covered by this file, a facility only had to report the total amount of a chemical transferred to all 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 2011 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 Note: In 2005, the TRI Program stopped collecting underground injection control (UIC) identification numbers from facilities on the TRI reporting forms. UIC IDs identify facilities that received permits from state governments to dispose of or release chemical waste into Class I through Class V underground injection wells. The TRI Program does have some historical UIC IDs that were collected prior to 2005. Many of these, however, are outdated and inaccurate. The TRI Program is also missing UIC IDs for facilities that began reporting to TRI in or after 2005. EPA does not store nor have access to current UIC IDs. Because of this lack of current, accurate and complete data, the TRI Program removed the UIC ID data fields from the TRI Basic Data Files in 2019. To learn more about UIC permits and underground injection wells see the "Protecting Underground Source of Drinking Water from Underground Injection (UIC)" website at https://www.epa.gov/uic ------- 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. ¦Si A i B i c , f 1 |rEPORTING YEAR TRADE SECRET INDICATOR TRIFID FACILITY NAME I 2 12016 NO 37087TSHBM1420T NOVAMET SPECIALTY PRODUCTS ! 3 12016 NO 2740WNVRNM837TR ENVIRONMENTAL AIR SYSTEMS INC-TRIAD I 4 12016 NO 7585WSNDRS4S5HI SANDERSON FARMS OAKWOOD FEED MILL *¦ Example of the first four rows of a Basic Plus data file 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 FORM TYPE C Indicates whether the Reporting Form R or Form A Certification Statement was submitted. R = Form R A = Form A Certification Statement Source: TRI_REPORTING_FORM.FORM_TYPE_IND Reference: Type of Form Used 2 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_FACILITY_ID Reference: Part 1, Section 4.1 3 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) 4 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 5 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 6 ELEMENTAL METAL INCLUDED C Indicates whether the facility submitted a combined reporting form for a metal compound and the corresponding elemental metal. This data element collected beginning with RY 2018. VALUES: YES = combined reporting form submitted for both an elemental metal and a metal compound containing the same elemental metal; NO = no combined form submitted Source: TRI_REPORTING_FORM.ELEMENTAL_METAL_INCLUDED Reference: Part II, Section 1.2 ------- No. Field Name Type Description 7 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 8 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} Source: TRI_CHEM_INFO.UNIT_0F_MEASURE Reference: NONE 9 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 10 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 11 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 12 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 ------- No. Field Name Type Description 13 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 14 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. Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_3 Reference: Part II, Section 1.4 15 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 16 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 17 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 ------- No. Field Name Type Description 18 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 19 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 20 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" for more information. Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_9 Reference: Part II, Section 1.4 21 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 22 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 23 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 24 DIOXIN DISTRIBUTION 13 N Indicates the percentage of 1,2,3,7,8 ------- No. Field Name Type Description 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 25 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 26 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 more information. Source: TRI_REPORTING_FORM.DIOXIN_DISTRIBUTION_15 Reference: Part II, Section 1.4 27 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 28 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 29 REPORTING YEAR The calendar year in which the reported activities occurred. Source: TRI_REPORTING_FORM.REPORTING_YEAR Reference: Part 1, Section 1 30 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. ------- No. Field Name Type Description Source: TRI_REPORTING_FORM.TRADE_SECRET_IND Reference: Part 1, Section 2.1 31 FACILITY NAME C Name of the reporting facility. Source: TRI_FACILITY.FACILITY_NAME Reference: Part 1, Section 4.1 32 FACILITY STREET C Street address of the reporting facility. Source: TRI_FACILITY.STREET_ADDRESS Reference: Part 1, Section 4.1 33 FACILITY CITY C City in which the reporting facility is located. Source: TRI_FACIUTY.CITY_NAME Reference: Part 1, Section 4.1 34 FACILITY COUNTY C County in which the reporting facility is located. Source: TRI_FACILITY.COUNTY_NAME Reference: Part 1, Section 4.1 35 FACILITY STATE C Two-letter state code of the reporting facility. Source: TRI_FACIUTY.STATE_ABBR Reference: Part 1, Section 4.1 36 FACILITY ZIP CODE C ZIP code of the reporting facility. Source: TRI_FACILITY.ZIP_CODE Reference: Part 1, Section 4.1 37 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 38 BIA CODE C Three-letter Bureau of Indian Affairs (BIA) code indicating the tribal land the facility is on. Source: FACILITY.BIA TRIBAL CODE 39 TRIBE NAME C The name of the Tribe. Source: V INDIAN COUNTRY. 40 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 41 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.PARTIAL_FAC Reference: Part 1, Section 4.2b 42 FEDERAL FACILITY IND C Code indicating whether a facility is a federal facility or not. Reported by facility. Yes = Federal No = non-Federal Value ------- No. Field Name Type Description Source: TRI_REPORTING_FORM.FEDERAL_ FACJND Reference: Part 1 Section 4.2c 43 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 44 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 45 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 46 PUBLIC CONTACT PHONE EXT C Phone extension of the public contact. Source: TRI_REPORTING_FORM.PUBLIC_PHONE_EXT Reference: Part 1, Section 4.4 47 PUBLIC CONTACT EMAIL C Email address of the designated individual whom the public may 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 48 PRIMARY SIC CODE C Primary four-digit Standard Industrial Classification (SIC) code. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: primaryjnd = >1' Reference: Part 1, Section 4.5a 49 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 50 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 51 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 52 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' ------- No. Field Name Type Description Reference: Part 1, Section 4.5e 53 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 54 NAICS ORIGIN C Indicates whether NAICS codes were reported or assigned. R = Reported A = Assigned 55 PRIMARY NAICS CODE C Primary six-digit North American Standard Industry Classification System (NAICS) code. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: primaryjnd => 1 Reference: Part 1, Section 4.5a 56 NAICS CODE 2 C Second six-digit North American Standard Industry Classification System (NAICS) code entered by facility Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = 2 Reference: Part 1, Section 4.5b 57 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 58 NAICS CODE 4 C Forth six-digit North American Standard Industry Classification System (NAICS) code entered by facility Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = 4 Reference: Part 1, Section 4.5b 59 NAICS CODE 5 C Fifth six-digit North American Standard Industry Classification System (NAICS) code entered by facility Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = 5 Reference: Part 1, Section 4.5b 60 NAICS CODE 6 C Sixth six-digit North American Standard Industry Classification System (NAICS) code entered by facility Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = 6 Reference: Part 1, Section 4.5b 61 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 62 LONGITUDE N The longitude value that best represents the facility according to ------- No. Field Name Type Description 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 63 D&B NR A C Unique identification number assigned by Dun and Bradstreet to the reporting facility. Source: TRI_FACILITY_DB.DB_N UM Reference: Part 1, Section 4.7a 64 D&B NR B C Unique identification number assigned by Dun and Bradstreet to the reporting facility. Source: TRI_FACILITY_DB.DB_NUM Reference: Part 1, Section 4.7b 65 RCRANR 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 66 RCRA NR B 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 67 RCRA NR C 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 68 RCRA NR D 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 69 RCRA NR E 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 70 RCRA NR F 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 71 RCRA NR G 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 ------- No. Field Name Type Description Facility Registry System (FRS). Source: EPA's Facility Registry System 72 RCRA NR H 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 73 RCRA NR 1 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 74 RCRA NR J 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 75 NPDESNRA C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 76 NPDESNR B C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 77 NPDES NR C C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 78 NPDES NR D C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 79 NPDES NR E C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 80 NPDES NR F C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). ------- No. Field Name Type Description Source: EPA's Facility Registry System 81 NPDES NRG C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 82 NPDESNR H C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 83 NPDES NR 1 C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 84 NPDES NR J C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). In RY 2005, TRI stopped collecting NPDES IDs and began obtaining them from EPA's Facility Registry System (FRS). Source: EPA's Facility Registry System 85 PARENT COMPANY NAME C Name of the corporation or other business entity that controls the reporting facility. Source: TRI_FACILITY.PARENT_CO_NAME Reference: Part 1, Section 5.1 86 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 87 STANDARDIZED PARENT COMPANY NAME C Standardized Parent Company Name assigned by TRI. Source: TRI FACILITY.STANDARDIZED PARENT COMPANY 88 FRS FACILITY ID C Indicates the Facility Registry Service (FRS) ID for the TRI facility. The FRS is a centrally managed EPA database that identifies facilities, sites or places subject to environmental regulations or of environmental interest. Using the FRS ID, data users can link data from different EPA programs together. Source: TRI FACILITY.EPA REGISTRY ID 89 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 90 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 ------- No. Field Name Type Description corresponding methods are: C = mass balance calculations E = published emission factors El = published emission factors E2 = on site-specific emission factors M = monitoring data 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 91 POTW RELEASES-8.1C N The total quantity of the chemical transferred to publicly-owned treatment works (POTWs) that is disposed of or released to Class 1 Underground Injection Wells, RCRA C Landfills and/or Other (Non RCRA C) Landfills. This amount is one of the quantities added into Section 8.1C: "Total Off-site Disposal to Class 1 Underground Injection Wells, RCRA Subtitle C Landfills and other Landfills." Source: TRI_FORM_TOTALS. POTW_R E LEAS E_81C Reference: Part II, Section 6.1 92 POTW RELEASES-8.1D N The total quantity of the chemical transferred to publicly-owned treatment works (POTWs) that is disposed of or released to media other than Class 1 Underground Injection Wells, RCRA C Landfills and/or Other (Non RCRA C) Landfills. This amount is one of the quantities added into Section 8.ID: "Total Other Off-site Disposal or Other Releases." Source: TRI_FORM_TOTALS. POTW_R E LE AS E_81D Reference: Part II, Section 6.1 93 POTW TRANSFERS - RELEASE N Total quantity of the transfer that was released at the POTW. This is the sum of POTW RELEASES - 8.1C (#74) + POTW RELEASES-81D (#75). Source: TRI_FORM_TOTALS.POTW_RELEASE Reference: Part II, Section 6.1.A.1 94 POTW TRANSFERS - TREATED N Total quantity of the transfer that was treated at the POTW. Source: TRI_FORM_TOTALS.POTW_TREATED Reference: Part II, Section 6.1.A.1 95 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_NAME Reference: Part II, Section 6.1.B.1 96 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 97 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 ------- No. Field Name Type Description 98 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 99 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 100 POTW A-ZIP C ZIP code used in the address of a POTW site. Source: TRI_POTW_LOCATION.ZlP_CODE Reference: Part II, Section 6.1.B.1 101 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_NAME Reference: Part II, Section 6.1.B.2 102 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 103 POTW B - 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.2 104 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 105 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 106 POTW B-ZIP C ZIP code used in the address of a POTW site. Source: TRI_POTW_LOCATI ON .Zl P_CO D E Reference: Part II, Section 6.1.B.1 107 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_NAME Reference: Part II, Section 6.1.C.2 108 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 109 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 110 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 ------- No. Field Name Type Description Ill POTWC- 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 112 POTW C - ZIP C ZIP code used in the address of a POTW site. Source: TRI_POTW_LOCATION.ZlP_CODE Reference: Part II, Section 6.1.C.1 113 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_NAME Reference: Part II, Section 6.1.D.2 114 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 115 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 116 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 117 POTW D-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 118 POTW D-ZIP C ZIP code used in the address of a POTW site. Source: TRI_POTW_LOCATI ON .Zl P_CO D E Reference: Part II, Section 6.1.D.1 119 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 120 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 2010, 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 2010 (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://iaspub.epa.gov/enviro/ez column v2.list?database tvpe=TRl&table name=V 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.gov/enviro/ez column v2.iist?database type=TRl&table name=V TRI TRANS POT W LQC 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 OPERYLENE 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 ------- |