TOXICS RELEASE INVENTORY (TRI) BASIC PLUS DATA FILES DOCUMENTATION FILE TYPE 4: FACILITY INFORMATION Updated for RY 2018 December 2019 rtk l-OA United Stales Environmental Protection IbbI I 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 4 CONTENTS The "Type 4" file contains the basic facility identification information for all facilities that have ever reported to the TRI Program. Most facilities submit several reporting forms each year, for many years. When the data are collected at the TRI Data Processing Center, differences in facility identification information between forms and across years are identified, researched and reconciled. File Type 4 contains this "reconciliation" of all the facility identification data the TRI Program has collected from each facility during its TRI reporting history. You'll notice that some facility-level data element names (e.g., those related to the facility's name and location) appear twice in this file, once as the data element name and once with "SUBMITTED" in front of the name (e.g., FACILITY NAME and SUBMITTED FACILITY NAME). The data elements labeled "SUBMITTED" display the data as they appeared on the most recent submission for the reporting year. If the data element does not have "SUBMITTED" in front of the name, it displays the last value of any submission for any reporting year. Consider the following example. In RY 2012, a facility reported its TRI data under the name "ABC Company." The facility continued to submit its TRI data as "ABC Company" for the next four years. In July 2017, after submitting its RY 2016 TRI reporting form, the facility sent in a revision for RY 2012 with the facility name of "XYZ Manufacturing." Reporting Year Type of Submission Date Reported Facility Name 2012 Original July 1, 2013 ABC Company 2013 Original July 1, 2014 ABC Company 2014 Original July 1, 2015 ABC Company 2015 Original July 1, 2016 ABC Company 2016 Original July 1, 2017 ABC Company 2012 Revision July 2, 2017 XYZ Manufacturing Following the facility's RY 2012 revision (submitted in July 2017), the TRI Program revises the 2012 Basic Plus data file. In the RY 2012 file, the SUBMITTED FACILITY NAME (field #17 in File Type 4) is now "XYZ Manufacturing" because is the most recent facility name that was reported for RY 2012. The SUBMITTED FACILITY NAME for all the other years' Basic Plus files (2013-2016), however, would be "ABC Company" because it is the most recent facility name for each of those reporting years. Following the RY 2012 revision, the "current" FACILITY NAME (field #5 in File Type 4) in the RY 2012 file is now "ABC Company" because it's the last facility name of ANY submission reported by the facility to TRI for any year. It is the most current name TRI has on file for the facility. The TRI Program defines or recognizes a facility as a physical location, and assigns it a TRI Facility ID number, or "TRIFID" for short (see field #4 in the record layout below) for identification purposes. Sometimes, a facility's address may change due to United States Postal Service updates, or there may be variations in how the facility reports its address from year to year (e.g., "1 East Main St." vs "One E. Main Street"). As EPA obtains more accurate latitude and longitude coordinates for facilities, those may change, as EPA is always striving to obtain better data. But, in general, the location of the facility should ------- remain constant. Some data elements that describe the facility will change from year to year; facilities frequently change ownership, names and contact personnel. However, the TRIFID and location should stay the same. Some of the data that appear in this file are not a result of facility reconciliation. The "Title of the Certifying Official," "Certifying Official's Name," "Entire Facility Ind," "Partial_Facility_lnd," "Federal Facility Ind," "GOCO Facility Ind" and the SIC codes are all taken from the last active and valid form the facility submitted. All other data are the result of the reconciliation process. All Type 4 files contain data from the following parts and sections of the Form R: Part Section Description 1 1 Reporting Year 1 4 Facility Identification Information 1 5 Parent Company Information 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 4 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 4 CONTENTS No. Field Name Type Description 1 REPORTING YEAR C The calendar year in which the reported activities occurred. Source: TRI_REPORTING_FORM.REPORTING_YEAR Reference: Part 1, Section 1 2 TITLE OF CERTIFYING OFFICIAL C The corporate title of the senior official certifying the accuracy and completeness of information on the most recent submission received from the facility. Source: TRI_REPORTING_FORM.CERTIF_OFFICIAL_TITLE Reference: Part 1, Section 3 3 NAME OF CERTIFYING OFFICIAL C The name of the senior official certifying the accuracy and completeness of the information on the most recent submission received from the facility. Source: TRI_REPORTING_FORM.CERTIF_NAME Reference: Part 1, Section 3 4 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 5 FACILITY NAME C The current name of the reporting facility. Source: TRI_FACILITY.FACILITY_NAME Reference: Part 1, Section 4.1 6 STREET C The current street address of the reporting facility. Source: TRI_FACILITY.STREET_ADDRESS Reference: Part 1, Section 4.1 7 CITY C The current city in which the reporting facility is located. Source: TRI_FACILITY.CITY_NAME Reference: Part 1, Section 4.1 8 COUNTY C The current county in which the reporting facility is located. Source: TRI_FACILITY.COUNTY_NAME Reference: Part 1, Section 4.1 9 STATE C The current two-letter state code of the reporting facility. Source: TRI_FACILITY.STATE_ABBR Reference: Part 1, Section 4.1 10 ZIP CODE C The current ZIP code of the reporting facility. Source: TRI_FACILITY.ZIP_CODE Reference: Part 1, Section 4.1 11 BIA CODE C The current three-letter Bureau of Indian Affairs (BIA) code indicating the tribal land the facility is on. Source: TRI FACILITY.BIA TRIBAL CODE 12 TRIBE NAME C The current name of the tribal land indicating where the facility is located. Source: TRI TRIBE DESC.TRIBE ------- No. Field Name Type Description 13 PARENT COMPANY NAME C The current 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 14 PARENT COMPANY D&B NR C The current 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 15 STANDARDIZED PARENT COMPANY NAME C The current standardized Parent Company Name assigned by TRI. Source: TRI_FACILITY.STANDARDIZED_PARENT_COMPANY 16 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 17 SUBMITTED FACILITY NAME C The name of the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.NAME Reference: Part 1, Section 4.1 18 SUBMITTED STREET C The street address of the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.ADDRESS Reference: Part 1, Section 4.1 19 SUBMITTED CITY C The city in which the reporting facility is located as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.CITY Reference: Part 1, Section 4.1 20 SUBMITTED COUNTY C The county in which the reporting facility is located as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.COUNTY Reference: Part 1, Section 4.1 21 SUBMITTED STATE C The two-letter state code of the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.STATE Reference: Part 1, Section 4.1 22 SUBMITTED ZIP CODE C The ZIP code of the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" ------- No. Field Name Type Description above for more information. Source: TRI FACILITY HISTORY 2.ZIPCODE Reference: Part 1, Section 4.1 23 SUBMITTED BIA CODE C The Three-letter Bureau of Indian Affairs (BIA) code indicating the tribal land the facility is on as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI FACILITY HISTORY 2.BIA TRIBE CODE 24 SUBMITTED TRIBE NAME C The name of the Tribe per the Submitted BIA Code. Source: TRI TRIBE DESC.TRIBE 25 SUBMITTED PARENT COMPANY NAME C The name of the corporation or other business entity that controls the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.PARENT_NAME Reference: Part 1, Section 5.1 26 SUBMITTED PARENT COMPANY D&B NR C The unique identification number assigned by Dun and Bradstreet to the parent company of the reporting facility as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI_FACILITY_HISTORY_2.PARENT_DB Reference: Part 1, Section 5.2 27 SUBMITTED STANDARDIZED PARENT COMPANY NAME C The Standardized Parent Company Name assigned by TRI as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI FACILITY HISTORY 2.EPA STANDARDIZED PARENT 28 SUBMITTED PRIMARY NAICS CODE C The Primary NAICS as it appeared for the reporting year for which the data is being downloaded (see description of file contents for more information). Source: TRI FACILITY HISTORY 2.PRIMARY NAICS 29 SUBMITTED INDUSTRY CODE C The industry code that corresponds to the Submitted Primary NAICS Code as it appeared on the most recent submission for the reporting year indicated in field #1 above. See "Description of File Type 4 Contents" above for more information. Source: TRI FACILITY HISTORY 2.PRIMARY NAICS 30 SUBMITTED INDUSTRY NAME C The industry name that corresponds to the assigned "Submitted Industry Code". See "Description of File Type 4 Contents" above for more information. Source: TRI_CODE_DESC.DESCRIPT Where: TABLE ID = '26' 31 MAILING NAME C The first and second lines of the most recently reported mailing name for thefacility (as of the most recent reporting year). Source: TRI FACILITY.MAIL NAME 32 MAILING STREET C Street address of the reporting facility's most recently reported mailing address (as of the most recent reporting ------- No. Field Name Type Description year). Source: TRI_FACILITY.MAIL_STREET_ADDRESS Reference: Part 1, Section 4.1 33 MAILING CITY C City name of the facility's most recently reported mailing address (as of the most recent reporting year). Source: TRI_FACILITY. MAI L CITY Reference: Part 1, Section 4.1 34 MAILING STATE C State of the reporting facility's most recently reported mailing address (as of the most recent reporting year). Source: TRI_FACILITY. MAI L_STATE_ABBR Reference: Part 1, Section 4.1 35 MAILING PROVINCE C Province of the reporting facility's most recently reported mailing address (as of the most recent reporting year). Source: TRI_FACILITY.MAIL_PROVINCE Reference: Part 1, Section 4.1 36 MAILING ZIP CODE C ZIP code of the reporting facility's current mailing address (as of the most recent reporting year). Source: TRI_FACILITY.MAIL_ZIP_CODE Reference: Part 1, Section 4.1 37 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 38 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 39 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 40 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 41 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 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 ------- No. Field Name Type Description 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 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. 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 47 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 48 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 49 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 50 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 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. 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 ------- No. Field Name Type Description 52 INDUSTRY CODE C The Industry code identifies what industry or sector a TRI facility belongs to. Industry sector codes are used to categorize and analyze TRI data. For a complete list of the Industry Codes and definitions, see "Appendix B - Industry Codes and Names." Source: TRI_SUBMISSION_NAICS.INDUSTRY_CODE Where: PRIMARYJND = "V Reference: Generated Value 53 INDUSTRY NAME C The name of the industry that the facility belongs to. For a complete list of the Industry Codes and definitions, see "Appendix B - Industry Codes and Names." Source: TRI_CODE_DESC.DESCRIPT Where: TABLE J D = '26' Reference: Look up value 54 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 = '1' Reference: Part 1, Section 4.5a 55 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 56 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.5b 57 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.5b 58 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.5b 59 NAICS CODE 6 C Sixth six-digit North American Standard Industry Classification System (NAICS) code entered by facility. NAICS codes reported ------- No. Field Name Type Description 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.5b 60 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 61 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 62 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 63 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 64 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 on the Reporting Form R. Source: EPA's Facility Registry System 65 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 66 RCRANR 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 67 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 68 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 69 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 on the Reporting Form R. Source: EPA's Facility Registry System 70 RCRA NRG 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 71 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 72 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 73 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 74 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 75 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 76 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 77 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 78 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 79 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 Reporting Form R. Source: EPA's Facility Registry System 80 NPDES NR G C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System ------- No. Field Name Type Description (NPDES). In RY 2005, TRI stopped collecting NPDES IDs on the Reporting Form R. Source: EPA's Facility Registry System 81 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 82 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 83 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 84 LAST YEAR THE FACILITY REPORTED C The last year the facility reported to the TRI Program. Source: TRI_REPORTING_FORM.REPORTING YEAR 85 FIRST YEAR THE FACILITY REPORTED C The first year the facility reported to the TRI Program. Source: TRI_REPORTING_FORM.REPORTING YEAR 86 NUMBER OF FORMS SUBMITTED C The number of chemical reporting forms (Form R or Form A) the facility submitted to the TRI Program for the reporting year shown in field #1. Source: calculated 87 TOTAL NUMBER OF FORMS SUBMITTED The number of chemical reporting forms (Form R and Form A) the facility has submitted to the TRI Program for all years. Source: calculated ------- 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 - Industry Codes and Names Industry Cede Industry Name 2121 Coal Mining 2122 Metal Mining 2211 Electric Utilities 311 Food 3121 Beverages 3122 Tobacco 313 Textiles 314 Textile Product 315 Apparel 316 Leather 321 Wood Products 322 Paper 323 Printing 324 Petroleum 325 Chemicals 326 Plastics and Rubber 327 Nonmetallic Mineral Product 331 Primary Metals 332 Fabricated Metals 333 Machinery 334 Computers and Electronic Products 335 Electrical Equipment 336 Transportation Equipment 337 Furniture 339 Miscellaneous Manufacturing 4246 Chemical Wholesalers 4247 Petroleum Bulk Terminals 511 Publishing 562 Hazardous Waste 999 Other MUL Multiple Industry Codes Submitted per Year ------- |