TOXICS RELEASE INVENTORY (TRI) BASIC PLUS DATA FILES DOCUMENTATION FILE TYPE 4: FACILITY INFORMATION Updated for RY 2017 July 2018 ifll United States Environmental Protection lal m\ Agency ------- OVERVIEW OF TRI BASIC PLUS DATA FILES The TRI "Basic Plus" data files include nine file types that collectively contain all the data fields from the TRI Reporting Form R and Form A (except Form R Schedule 1). The nine file types are tab-delimited text (.txt) files packaged into a .zip file. File Exarrmle Descriotion of Contents Form R/Form A Reference Type 1 CA_l_2017.txt Facility data, chemical identification, chemical uses, on- site releases and management, off- site transfers, summary information Part 1 (all), Part II (section 1, 3, 4, 5, 6.1.A, 6.2ABC, 7B, 7C, 8.2.B, 8.4.B, 8.6. The Basic Plus Data Files are identified (named) by state, file type, and reporting year: File Name = State + File Type + Reporting Year For example, the file "CA_l_2017.txt" contains facility, chemical identification, chemical use, on-site release and waste management, off-site transfer and summary information (File Type 1) for all facilities located in California (CA) for reporting year 2017. In addition to the set of data files for each state, there are two other Basic Plus file sets: Federal and National. The Federal files (FED_l_2017.txt, FED_2A_2017.txt, etc.) contain TRI data for all government-owned-and- operated federal sites. The National files (US_l_2017.txt, US_2A_2017.txt, etc.) contain TRI data for all U.S. states and territories for a specific year. ------- DESCRIPTION OF FILE TYPE 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 #16 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 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. -v. A i B £ C I D 1 | REPORTING YEAR TRADE SECRET INDICATOR TRIFID 2 J 2016 NO 37087TSHBM1420T 3 J2016 NO 2740WNVRNM837TR 4 j2016 NO 75S5WSNDR54&5H1 Example of the first four rows of a Basic Plus data file FACILITY NAME I NDVAMET SPECIALTY PRODUCTS I ENVIRONMENTAL AIR SYSTEMS INC-TRIAD I SANDERSON FARMS OAKWOOD FEED MILL < ------- REMINDER: Quantities of dioxin and dioxin-like compounds are in grams. Quantities of all other TRI chemicals are reported in pounds. Facilities cannot use range codes to report quantities for dioxin and dioxin-like compounds and other Persistent Bioaccumulative Toxics (PBTs). 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.eov/tri/guideme. The Envirofacts TRI data model is found at https://www.epa.gov/enviro/tri~rnodeL 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_FACI LITYJD 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 FACI LITY. 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_N AME 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 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 17 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 18 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 19 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 20 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 21 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" above for more information. Source: TRI_FACILITY_HISTORY_2.ZIPCODE Reference: Part 1, Section 4.1 22 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. ------- No. Field Name Type Description Source: TRI FACILITY HISTORY 2.BIA TRIBE CODE 23 SUBMITTED TRIBE NAME C The name of the Tribe per the Submitted BIA Code. Source: TRI TRIBE DESC.TRIBE 24 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 25 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 26 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 27 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 28 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 29 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' 30 MAILING NAME C The first and second lines of the most recently reported mailing name for the facility (as of the most recent reporting year). Source: TRI FACILITY.MAIL NAME 31 MAILING STREET C Street address of the reporting facility's most recently reported mailing address (as of the most recent reporting year). Source: TRI_FACILITY.MAIL_STREET_ADDRESS Reference: Part 1, Section 4.1 32 MAILING CITY C City name of the facility's most recently reported mailing address (as of the most recent reporting year). Source: TRI_FACILITY.MAlL CITY Reference: Part 1, Section 4.1 33 MAILING STATE C State of the reporting facility's most recently reported mailing ------- No. Field Name Type Description address (as of the most recent reporting year). Source: TRI FACILITY.MAIL STATE ABBR Reference: Part 1, Section 4.1 34 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 35 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 36 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 37 PARTIAL FACILITY IND C Indicates whether the information covers an entire facility or part of a facility. Yes = partial No = entire Source: TRI_REPORTING_FORM. PARTI ALFAC Reference: Part 1, Section 4.2b 38 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 39 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 40 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 41 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 42 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 43 PUBLIC CONTACT PHONE EXT C Phone extension of the public contact Source: TRI_REPORTING_FORM.PUBLIC_PHONE_EXT Reference: Part 1, Section 4.4 44 PUBLIC CONTACT EMAIL C Email address of the designated individual whom the public may contact if clarification of the facility's reported data is ------- No. Field Name Type Description needed. Source: TRI_REPORTING_FORM.PUBLIC_CONTACT_PERSON_EMAIL Reference: Part 1, Section 4.4 45 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: primary_ind = '1' Reference: Part 1, Section 4.5a 46 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 47 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 48 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 49 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 50 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 51 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 = T Reference: Generated Value 52 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 ------- No. Field Name Type Description Where: TABLE J D = '26' Reference: Look up value 53 NAICS ORIGIN C Indicates whether North American Industry Classification System (NAICS) codes were reported or assigned. R = Reported A = Assigned 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: primary_ind = 'V Reference: Part 1, Section 4.5a 55 NAICS CODE 2 C Second six-digit North American Standard Industry Classification System (NAICS) code entered byfacility. 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 = 'T Reference: Part 1, Section 4.5b 56 NAICS CODE 3 C Third six-digit North American Standard Industry Classification System (NAICS) code entered byfacility. 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 byfacility. 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 byfacility. 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 byfacility. 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.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. ------- No. Field Name Type Description 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_N U M 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_N U M Reference: Part 1, Section 4.7b 64 RCRA NR A C Twelve-digit alphanumeric identifier assigned by EPA per the Resource Conservation and Recovery Act (RCRA). 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). Source: EPA's Facility Registry System 66 NPDESNRA C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). Source: EPA's Facility Registry System 67 NPDESNR B C Nine-digit alphanumeric identifier assigned to a facility in EPA's National Pollutant Discharge Elimination System (NPDES). Source: EPA's Facility Registry System 68 UIC NR A C Underground injection identification number, assigned by EPA or the state, to a facility. Source: EPA's Facility Registry System 69 UICNRB C Underground injection identification number, assigned by EPA or the state, to a facility. Source: EPA's Facility Registry System 70 LAST YEAR THE FACILITY REPORTED C The last year the facility reported to the TRI Program. Source: TRI REPORTING FORM.REPORTING YEAR 71 FIRST YEAR THE FACILITY REPORTED C The first year the facility reported to the TRI Program. Source: TRI_REPORTING_FORM.REPORTING YEAR 72 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 73 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 Indur-try Cook- 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 ------- |