TOXICS RELEASE INVENTORY (TRI) BASIC PLUS DATA FILES DOCUMENTATION FILE TYPE 5: ADDITIONAL INFORMATION ON DISPOSAL AND OTHER RELEASES, SOURCE REDUCTION, AND RECYCLING ACTIVITIES Updated for RY 2018 August 2019 United Stales Environmental Protection M * 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 Examole 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 5 CONTENTS The "Type 5" file contains information from Section 8.11 of the TRI Reporting Form R. Section 8.11 is an optional text section in which facilities may choose to provide more detail about activities taken to reduce releases of the TRI chemical being reported. Collection of Section 8.11 comment data began in reporting year 2005. Only Form R submissions that have this optional text are included in File Type 5. (Note: EPA has received ~10 comments for Section 8.11 from facilities that submitted Form R revisions for years prior to 2005.) All Type 5 files contain data from the following parts and sections of the Form R: Part Section Description 1 1 Reporting Year 1 1 Revision Codes 1 4 Facility Identification Information 1 5 Parent Company Information II 1 Chemical Identification Data II 8.11 Additional Information on Source Reduction, Recycling and Pollution Control 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 5 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. At A j I j C ' REPORTING YEAR TRADE SECRET INDICATOR TRIFID 2 2016 NO 37087TSHBM1420T 3 '2016 NO 2740WNVRNM837TR 4 2016 NO 7585WSNDRS4S5H1 EKomple of the first four row f of o Basic Phis data file FACILITY NAME I MOVAMET SPECIALTY PRODUCTS 1 ENVIRONMENTAL AIR SYSTEMS 1MC-TRSAD £ SANDERSON -ARMS OAKWOOD FEED MILL c 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). 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 5 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 REPORTING YEAR C The calendar year in which the reported activities occurred. Source: TRI_REPORTING_FORM.REPORTING_YEAR Reference: Part 1, Section 1 3 TRIFD C TRI 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 4 FACILITY NAME C Name of the reporting facility. Source: TRI_FACILITY.FACILITY_NAME Reference: Part 1, Section 4.1 5 FACILITY STREET C Street address of the reporting facility. Source: TRI_FACILITY.STREET_ADDRESS Reference: Part 1, Section 4.1 6 FACILITY CITY C City in which the reporting facility is located. Source: TRI_FACILITY.CITY_NAME Reference: Part 1, Section 4.1 7 FACILITY COUNTY C County in which the reporting facility is located. Source: TRI_FACILITY.COUNTY_NAME Reference: Part 1, Section 4.1 8 FACILITY STATE C Two-letter state code of the reporting facility. Source: TRI_FACILITY.STATE_ABBR Reference: Part 1, Section 4.1 9 FACILITY ZIP CODE C ZIP code of the reporting facility. Source: TRI_FACILITY.ZIP_CODE Reference: Part 1, Section 4.1 10 BIA CODE C Three-letter Bureau of Indian Affairs (BIA) code indicating the tribal land the facility is on. Source: TRI FACILITY.BIA TRIBAL CODE 11 TRIBE NAME C The name of the Tribe. Source: TRI_TRIBE_DESC. 12 MAILING NAME C The mailing name for the facility. Source: TRI_FACILITY. MAILJMAME ------- No. Field Name Type Description 13 MAILING STREET C Street address of the reporting facility's mailing address. Source: TRI_FACILITY.MAIL_STREET_ADDRESS Reference: Part 1, Section 4.1 14 MAILING CITY C City name of the facility's mailing address. Source: TRI_FACILITY. MAI L CITY Reference: Part 1, Section 4.1 15 MAILING STATE C State of the reporting facility's mailing address. Source: TRI_FACILITY. MAI L_STATE_ABBR Reference: Part 1, Section 4.1 16 MAILING PROVINCE C Province of the reporting facility's mailing address. Source: TRI_FACILITY.MAIL_PROVINCE Reference: Part 1, Section 4.1 17 MAILING ZIP CODE C ZIP code of the reporting facility's mailing address. Source: TRI_FACILITY.MAIL_ZIP_CODE Reference: Part 1, Section 4.1 18 ENTIRE FACILITY IND C Indicates whether the facility reported as an entire facility or reported in parts. If the facility reported in parts, all the data from the parts are disseminated together under the facility as a whole. Yes = entire No = partial Source: TRI_REPORTING_FORM.ENTIRE_FAC Reference: Part 1, Section 4.2a 19 PARTIAL FACILITY IND C Indicates whether the facility reported as an entire facility or reported in parts. If the facility reported in parts, all the data from the parts are disseminated together under the facility as a whole. Yes = partial No = entire Source: TRI_REPORTING_FORM.PARTIAL_FAC Reference: Part 1, Section 4.2b 20 FEDERAL FACILITY IND C Code indicating whether a facility is a federal facility or not. Reported by the facility. Yes = Federal No = non-Federal Value Source: TRI_REPORTING_FORM.FEDERAL_FAC_IND Reference: Part 1 Section 4.2c 21 GOCO FACILITY IND C Code indicating whether a facility is 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 ------- No. Field Name Type Description 22 ASSIGNED FED. FACILITY FLAG C Code indicating whether the facility is federally owned or not. Assigned by TRI. Yes = Federal No = Non-Federal Reference: TRI_FACILITY. ASGN_FEDERAL 23 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 24 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 25 PUBLIC CONTACT PHONE EXT C Phone extension of the public contact Source: TRI_REPORTING_FORM.PUBLIC_PHONE_EXT Reference: Part 1, Section 4.4 26 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 27 PRIMARY SIC CODE C Primary four-digit Standard Industrial Classification (SIC) code. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: primaryjnd = '1' Reference: Part 1, Section 4.5a 28 SIC CODE 2 C Second four-digit Standard Industrial Classification (SIC) code entered by facility. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: sic_sequence_num = '2' Reference: Part 1, Section 4.5b 29 SIC CODE 3 C Third four-digit Standard Industrial Classification (SIC) code entered by facility. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: sic_sequence_num = '3' Reference: Part 1, Section 4.5c 30 SIC CODE 4 C Fourth four-digit Standard Industrial Classification (SIC) code entered by facility. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: sic_sequence_num = '4' Reference: Part 1, Section 4.5d 31 SIC CODE 5 C Fifth four-digit Standard Industrial Classification (SIC) code entered by facility. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI SUBMISSION SIC.SIC CODE ------- No. Field Name Type Description Where: sic_sequence_num = '5' Reference: Part 1, Section 4.5e 32 SIC CODE 6 C Sixth four-digit Standard Industrial Classification (SIC) code entered by facility. SIC codes reported by facilities from RY 1987 through 2005. Source: TRI_SUBMISSION_SIC.SIC_CODE Where: sic_sequence_num = '6' Reference: Part 1, Section 4.5f 33 NAICS ORIGIN C Indicates whether North American Industry Classification System (NAICS) codes were reported or assigned. R = Reported A = Assigned 34 PRIMARY NAICS CODE C Primary six-digit North American Standard Industry Classification System (NAICS) code. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. See Appendix A - "NAICS Codes Assignments" for more details. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: primaryjnd = T Reference: Part 1, Section 4.5a 35 NAICS CODE 2 C Second six-digit North American Standard Industry Classification System (NAICS) code entered by facility. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = '2' Reference: Part 1, Section 4.5b 36 NAICS CODE 3 C Third six-digit North American Standard Industry Classification System (NAICS) code entered by facility. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = '3' Reference: Part 1, Section 4.5c 37 NAICS CODE 4 C Forth six-digit North American Standard Industry Classification System (NAICS) code entered by facility. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = '4' Reference: Part 1, Section 4.5d 38 NAICS CODE 5 C Fifth six-digit North American Standard Industry Classification System (NAICS) code entered by facility. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = '5' Reference: Part 1, Section 4.5e 39 NAICS CODE 6 C Sixth six-digit North American Standard Industry Classification ------- No. Field Name Type Description System (NAICS) code entered by facility. NAICS codes reported by facilities from RY 2006 to present. NAICS codes in prior years were assigned by EPA. Source: TRI_SUBMISSION_NAICS.NAICS_CODE Where: naics_sequence_num = '6' Reference: Part 1, Section 4.5f 40 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 41 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 42 D&B NR A C Unique identification number assigned by Dun and Bradstreet to the reporting facility. Source: TRI_FACILITY_DB.DB_NUM Reference: Part 1, Section 4.7a 43 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 44 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 on the Reporting Form R. Source: EPA's Facility Registry System 45 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 on the Reporting Form R. Source: EPA's Facility Registry System 46 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 on the Reporting Form R. Source: EPA's Facility Registry System 47 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 on the Reporting Form R. Source: EPA's Facility Registry System 48 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 on the Reporting Form R. Source: EPA's Facility Registry System 49 RCRA NR F 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 on the Reporting Form R. Source: EPA's Facility Registry System 50 RCRANRG C Twelve-digit alphanumeric identifier assigned by EPA per the Resource Conservation and Recovery Act (RCRA). In RY 2005, TRI stopped collecting RCRA IDs on the Reporting Form R. Source: EPA's Facility Registry System 51 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 on the Reporting Form R. Source: EPA's Facility Registry System 52 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 on the Reporting Form R. Source: EPA's Facility Registry System 53 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 on the Reporting Form R. Source: EPA's Facility Registry System 54 NPDES NR A 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 on the Reporting Form R. Source: EPA's Facility Registry System 55 NPDES NR 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 on the Reporting Form R. Source: EPA's Facility Registry System 56 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 on the Reporting Form R. Source: EPA's Facility Registry System 57 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 on the Reporting Form R. Source: EPA's Facility Registry System 58 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 on the Reporting Form R. Source: EPA's Facility Registry System 59 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 on the ------- No. Field Name Type Description Reporting Form R. Source: EPA's Facility Registry System 60 NPDES NR G 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 on the Reporting Form R. Source: EPA's Facility Registry System 61 NPDES NR 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 on the Reporting Form R. Source: EPA's Facility Registry System 62 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 on the Reporting Form R. Source: EPA's Facility Registry System 63 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 on the Reporting Form R. Source: EPA's Facility Registry System 64 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 65 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 66 STANDARDIZED PARENT COMPANY NAME C The standardized parent company name assigned by the TRI Program. To improve data quality, the TRI Program standardizes the parent company names submitted by facilities on their reporting forms. Source: TRI FACILITY.STANDARDIZED PARENT COMPANY 67 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 68 DOCUMENT CONTROL NUMBER C Unique identification number assigned to each TRI submission by EPA. Format: TTYYMMMNNNNNC, where TT = document type YY = reporting year MMM = document type ------- No. Field Name Type Description NNNNN= sequential number C = check digit Source: TRI_REPORTING_FORM.DOC_CTRL_NUM Reference: NA (System-generated) 69 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 70 CHEMICAL NAME C 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 71 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 = only metal compound reported Source: TRI_REPORTING_FORM.ELEMENTAL_METAL_INCLUDED Reference: Part II, Section 1.2 72 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 73 METALJND C Code indicating whether the chemical is a metal or not. Yes = Metal No = Non-Metal Source: TRI_CHEM_INFO.METAL_IND 74 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 75 REVISION CODE 2 C If the facility revised its original TRI reporting form for this chemical, this code indicates the reason for the revision. ------- No. Field Name Type Description 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 76 COMMENT SEQUENCE C This column shows the sequence in which the comments were reported. Source: TRI_TRIPS_COMMENT.COM MENTSEQ. 77 SECTION C The section of the Form R in which the comment was reported. This value will be "8.11" for all entries in this file because this file contains only comments from Section 8.11. Source: TRI TRIPS COMMENT.SECTION 78 COMMENT TYPE CODE C A code indicating what type of comment was reported. Source: TRI_TRIPS_COMMENT.COMMENT TYPE 79 COMMENT TYPE DESCRIPTION C The full description of the comment type. Source: TRI_CODE_DESC.DESCRIPT Where: Tablejd = '24' and Comment_Type = Code 80 COMMENT TEXT C The comment submitted by the facility in Section 8.11 of the Form R. Source: TRI_TRIPS_COMMENT.COMMENT TEXT 81 P2 CLASSIFICATION C For Section 8.11 comments related to pollution prevention activities, this data element indicates the subcategory of the comment. See Appendix B for a complete list of subcategories and descriptions. Source: TRI_TRIPS_COMMENT.P2_CLASSIFICATION APPENDIX A - NAICS Code Assignments Until RY 2006, the TRI Program used Standard Industrial Codes (SIC) to identify each reporting facility's industry sector. In RY 2006, the TRI Program began using North American Industry Classification System (NAICS) codes. To allow for analysis of data across years, the TRI Program assigned NAICS codes to each TRI submission from 1987 through 2005. The six methods used to assign NAICS codes and the number and percentages of assignments per method are shown in the table below. The "Order of Precedence" column indicates the order in which the methods were used to make an assignment. ------- Method Order of Precedence Number of NAICS codes Assigned via Method (in Thousands) Percentage Per Method Reported Data Used 1 821K 50% SIC to NAICS Crosswalk 2 478K 29% EPA Facility Registry System (FRS) 3 190K 11% Commercial Sources 4 113K 7% Statistics 5 51K 3% Other Methods 6 2K Less than 1 % Reported Data Used - In this method, the primary NAICS code reported by each facility in RY 2006 was used to make an assignment to chemical submissions (Form Rs and Form As) for years 1987 to 2005. This method was only used under the following conditions: 1. The RY 2006 chemical submitted had only one primary NAICS code reported 2. The prior year submission(s) for the same chemical had only one primary SIC code consistently reported 3. The SIC to NAICS Crosswalk (obtained for the U.S. Census Bureau) showed a one-to-one match between the reported SIC and NAICS codes This method was used to assign 50% of all NAICS codes. SIC to NAICS Crosswalk - In this method, the TRI Program used a crosswalk or lookup table that translated SIC codes into NAICS codes to assign a primary NAICS code to a pre-2006 TRI chemical submission. The primary SIC code reported on the TRI form was used to lookup the corresponding NAICS code. Not all SIC codes translated into only one NAICS code, so it was not possible to use this method to assign a NAICS code to each chemical submission. However, it was used to make 29% of all the assignments. EPA Facility Registry System (FRS) - In this method, the TRI Program used NAICS codes found in EPA's Facility Registry System (FRS) to assign a primary NAICS code to each TRI chemical submission. This method was only used if FRS listed only one primary NAICS code for a facility. 11% of all assignments were made using this method. Commercial Sources - This method involved using various commercial services to verify NAICS code assignments. 7% of all assignments were made using this method. Statistics - For 3% of NAICS code assignments, the TRI Program used various statistical methods based on past and present data. Other Methods - Manual research (e.g., using Internet searches and other government agencies' data) and personally contacting facilities helped the TRI Program assign NAICS codes to approximately 2,000 TRI submissions. ------- APPENDIX B - Pollution Prevention Comment Categories • Barriers to P2: Section 8.11 comments categorized as "Barriers to P2" describe barriers the reporting facility faced in implementing additional source reduction, recycling or pollution control activities during the reporting year. • Source Reduction: Section 8.11 comments categorized as "Source Reduction" relate to any practices that reduce the quantity of the TRI-reported chemical entering the waste stream or released into the environment, or that reduce the hazard to human health and environment of such releases. Examples include green chemistry and green engineering practices. • Miscellaneous: Section 8.11 comments categorized as "Miscellaneous" are not related to P2. ------- |