RTK NET Home Page

About the Data

Resources

Help

About RTK NET

General BRS Help

For general help with the BRS database, try the top section of the help associated with the search forms.

BRS was last updated on RTK NET with a set of EPA data made on December 15, 2016, and includes records from 1989 through 2015.

Delimited Reports

Delimited reports produce data that can be loaded into a database or spreadsheet program. (You can choose a delimited report by selecting "comma delimited" or "tab delimited" under Type of Report Output.) To use the output of a delimited report, first save it as a text file, either from your Web browser or your Email client. Depending on the program that you are loading it into, you may then need to edit it to remove everything above the line of column headers. (There should also be an "*END OF REPORT*" marker after the data, which you may or may not need to edit out.) Then you should be able to load the delimited data.

Note that some of the sets of data fields repeat. The column headers for these repeating sections will have numbers after them in parenthesis, e.g. (#1).

Data Dictionary

Facility-based reports

Section: Basic Facility Info

This section supplies basic information about the facility, such as its name, address, and industrial type.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015

Section: Mailing Address and Contact Info

This section gives the mailing address and contact information for the facility.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68All 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00All  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20All  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00All  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00All  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25All  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89All 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00All 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00All  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53All 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00All  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99All 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14All 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19All 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06All 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08All 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12All 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71All 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00All  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46All  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08All 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95All  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93All 2009-2015

Section: Basic Submission Info

This section supplies basic information about the data submission, such as the reporting year.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015

Section: Facility Waste Totals

This section gives total amounts of waste generated, managed, and received at the facility. Federal waste is Federally as opposed to state regulated.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Total Tons GeneratedTotal tons of both Federal and state-regulated waste generated by the facilitydecimal(14,3)4.02All  
Total Tons Generated, ManagedTotal tons of Federal and state waste generated by the facility, then managed onsite or sent offsite for management or storagedecimal(14,3)4.47All  
Total Tons Generated, ShippedTotal tons of Federal and state waste generated, then shipped off-site for management or storage. This amount is part of the total amount generated, then managed.decimal(14,3)5.12All  
Total Tons Received, ManagedTotal tons of Federal and state waste received from off-site, then manageddecimal(14,3)97.99All  
Total Tons Transfer StorageTotal tons of Federal and state waste received from offsite for transfer storagedecimal(14,3)98.19All  
Total Tons ImportedTotal tons of Federal and state waste received and managed as part of wastes imported from other U.S. statesdecimal(14,3)98.56All  
Total Tons ExportedTotal tons of Federal and state shipped off-site as part of waste exported to other U.S. statesdecimal(14,3)27.17All  
Total Tons ManagedTotal tons of both Federal and state-regulated waste managed by the facility, whether waste came from on-site generation or was received from off-sitedecimal(14,3)4.35All  
Fed. Tons GeneratedTotal tons of Federal waste generated by the facilitydecimal(14,3)5.48All  
Fed. Tons Generated, ManagedTotal tons of Federal waste generated, then managed onsite or sent off-site for management or storagedecimal(14,3)5.92All  
Fed. Tons Generated, ShippedTotal tons of Federal waste generated, then shipped off-site for management or storage. This amount is part of the total amount of Federal waste generated, then managed.decimal(14,3)6.58All  
Fed. Tons Received, ManagedTotal tons of Federal waste received from off-site, then manageddecimal(14,3)98.12All 1991-2015
Fed. Tons Transfer StorageTotal tons of Federal waste received from off-site for transfer storagedecimal(14,3)98.23All 1991-2015
Fed. Tons ImportedTotal tons of Federal waste received and managed as part of wastes imported from other U.S. statesdecimal(14,3)98.63All 1991-2015
Fed. Tons ExportedTotal tons of Federal waste shipped off-site as part of wastes exported to other U.S. statesdecimal(14,3)28.07All  
Fed. Tons ManagedTotal tons of Federal waste managed by the facility, whether waste came from on-site generation or was received from off-sitedecimal(14,3)5.82All  
Total Haz. Secondary Material TonsTotal actual tons of hazardous secondary material generated and managed on or offsite in the most recent odd-numbered year. Field added by RTK NET.decimal(14,3)99.84All 2009-2015

Section: National Report Totals

This section gives information on generated, managed, and received facility-level waste totals used in EPA's National Biennial Report.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
National Report Tons GeneratedTotal tons of Federal waste generated by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)5.32Complete only 1993-1997
National Report Tons ReceivedTotal tons of Federal waste received by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.09Complete only 1993-1997
National Report Tons ImportedTotal tons of Federal waste received by the facility from another (U.S.) state, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.93Complete only 1993-1997
National Report Tons ManagedTotal tons of Federal waste managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)96.14Complete only 1993-1997
National Report Tons Received and ManagedTotal tons of Federal waste received and managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)98.28Complete only 1993-1997
National Report Tons WastewaterTotal tons of Federal waste, as wastewater, managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.36Complete only 1993-1995
National Report Tons Non-wastewaterTotal tons of Federal waste, as non-wastewater, managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.03Complete only 1993-1995
National Report Tons ShippedTotal tons of Federal waste shipped by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)5.42Complete only 1993-1997
National Report Tons ExportedTotal tons of Federal waste shipped to another (U.S.) state by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)29.12Complete only 1993-1997

Section: Facility-based Record Counts

This section lists how many repeats there are in repeating data sections that describe facilities. It is used in delimited output in order to see whether all of the repeats were listed in the delimited data or not.

This section is only displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Number of Facility SICsThe number of SIC codes listed for the facilityint(11)9.35High through Complete 1991-1991
Number of TDR SystemsThe number of treatment, disposal, or recycling system records for the facilityint(11)83.03High through Complete 1989-1995
Number Add'l Univ. WastesThe number of additional (specified in comments) universal waste types indicated for the facilityint(11)96.48High through Complete 2001-2015
Number Facility EPA Waste CodesThe number of EPA waste codes indicated for the facilityint(11)21.27High through Complete 2001-2015
Number Facility State Waste CodesThe number of state waste codes indicated for the facilityint(11)90.76High through Complete 2001-2015
Number of Facility NAICSThe number of NAICS codes indicated for the facilityint(11)0.00High through Complete 2001-2015
Number Cert. RecordsThe number of certification records for the facilityint(11)0.19High through Complete  
Number State ActionsThe number of state action records for the facilityint(11)98.75High through Complete 2003-2015
Number Owner/OperatorsThe number of prior and current owner and operator records for the facility in the reporting yearint(11)5.82High through Complete 2001-2015
Number of Facility CommentsThe number of 60-character comment lines for this facilityint(11)40.19High through Complete 1991-2015
Number GM FormsThe number of GM form records (generated wastes) for this facilityint(11)3.72High through Complete  
Number WR FormsThe number of WR form records (received wastes) for this facilityint(11)96.98High through Complete  
Number Facility Total RecordsThe number of facility National Report Quantity total records for the facilityint(11)0.00High through Complete 1993-1997
Number WM FormsThe number of waste minimization (WM) forms for the facilityint(11)95.49High through Complete 1991-1995
Number of HSM RecordsThe number of HSM records. Field added by RTK NET.int(11)99.77High through Complete 2015-2015
Number of HSM ActivitiesThe number of HSM activity records. Field added by RTK NET.int(11)99.77High through Complete 2015-2015

Section: Facility NAICS Codes

This section lists NAICS (industrial type) codes for the facility.

This section can have more than one entry per record. The record with the most entries currently holds 10. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
NAICS CodeNorth American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00All 2001-2015

Section: Facility SIC Codes

This section lists SIC (industrial type) codes for the facility.

This section can have more than one entry per record. The record with the most entries currently holds 12. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
SIC CodeSIC Code for facilitychar(4)0.03All 1991-1991

Section: Facility Status

This section gives indications of the status of various types of activities (waste generation, management, etc.) at the facility.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00All  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00All 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00All 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00All 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00All 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01All 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01All 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53All 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00All 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00All 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00All 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00All 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015

Section: Owners and Operators

This section provides information on the owners and operators of the facility.

This section can have more than one entry per record. The record with the most entries currently holds 16. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Owner or Operator Ind.Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00High through Complete 2001-2015
Owner / Operator NameSite's legal owner or operatorvarchar(40)0.07High through Complete 2001-2015
Owner / Operator DateDate that an entity became owner or operator of the facilitydate1.57High through Complete 2001-2015
Owner / Operator TypeOwner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00High through Complete 2001-2015
Owner / Operator Street NumberThe street number of the owner or operatorvarchar(12)68.59High through Complete 2001-2015
Owner / Operator Street 1The first line of the street address of the owner or operatorvarchar(30)31.58High through Complete 2001-2015
Owner / Operator Street 2The second line of the street address of the owner or operatorvarchar(30)94.35High through Complete 2001-2015
Owner / Operator CityThe city in the address of the owner or operatorvarchar(25)31.01High through Complete 2001-2015
Owner / Operator StateThe state postal abbreviation in the address of the owner or operatorchar(2)32.13High through Complete 2001-2015
Owner / Operator Zipthe Zip Code in the address of the owner or operatorvarchar(14)31.05High through Complete 2001-2015
Owner / Operator Country CodeA code for the country in the address of the owner or operator.char(2)43.53High through Complete 2009-2015
Owner / Operator CountryThe country in the address of the owner or operatorvarchar(50)0.00High through Complete 2001-2007
Owner / Operator PhoneThe phone number of the owner or operatorvarchar(15)52.82High through Complete 2009-2015
Owner / Operator NotesNotes on the owner or operatorvarchar(240)75.82High through Complete 2001-2015

Section: Universal Waste

This section provides information on universal wastes -- such as batteries, lamps, etc. -- generated by or accumulated at the facility.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
LQG Batteries (Yes/No)Large Quantity Generator of Batteries (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Batteries (Yes/No)Large Quantity Accumulator of Batteries. As of 2007, changed to Managed Batteries.char(1)0.00Extended and Complete 2001-2007
LQG PesticidesLarge Quantity Generator of Pesticides (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Pesticides (Yes/No)Large Quantity Accumulator of Pesticides. As of 2007, changed to Managed Pesticides.char(1)0.00Extended and Complete 2001-2007
LQG Thermostats (Yes/No)Large Quantity Generator of Thermostats (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Thermostats (Yes/No)Large Quantity Accumulator of Thermostats. As of 2007, changed to Managed Mercury Containing Equipment.char(1)0.00Extended and Complete 2001-2007
LQG Lamps (Yes/No)Large Quantity Generator of Lamps (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Lamps (Yes/No)Large Quantity Accumulator of Lamps. As of 2007, changed to Managed Lamps.char(1)0.00Extended and Complete 2001-2007
Universal Waste DestinationDestination Facility for Universal Waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015

Section: Other Universal Wastes

This section provides information about universal wastes not specifically listed on the BRS reporting form.

This section can have more than one entry per record. The record with the most entries currently holds 10. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Universal Waste CodeIndicates a type of 'other' universal waste not listed on the formchar(1)0.00Complete only 2001-2015
Universal Waste Code OwnerIndicates which entity (usually Federal EPA or a state) defined the Universal Waste Code for this waste.char(2)0.00Complete only 2009-2015
Univ. Waste GeneratedGenerated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)8.66Complete only 2001-2015
Univ. Waste AccumulatedAccumulated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Complete only 2001-2015

Section: Used Oil

This section provides information on the facility's activities involving used oil.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Used Oil Transporter (Yes/No)Used Oil Transporter (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Transfer Fac. (Yes/No)Used Oil Transfer Facility (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Processor (Yes/No)Used Oil Processor (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Re-refiner (Yes/No)Used Oil Re-refiner (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Burner (Yes/No)Off-Specification Used Oil Burner (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Marketer, Type 1Used Oil Fuel Marketer Who Directs Shipment of Off-Specification Used Oil to Off-Specification Used Oil Burner (Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Marketer, Type 2Used Oil Fuel Marketer Who First Claims the Used Oil Meets the Specifications (Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015

Section: Reason for No Generation

This section provides information on why the facility did not generate a reportable amount of waste in the reporting year.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
No Gen.: Never Generated (Yes/No)Reason for not generating waste -- Never generated (Y/N)char(1)97.20Extended and Complete 1989-1999
No Gen.: Out of Business (Yes/No)Reason for not generating waste -- Out of business (Y/N)char(1)97.22Extended and Complete 1989-1999
No Gen.: Only Excluded Waste (Yes/No)Reason for not generating waste -- Only excluded or delisted waste (Y/N)char(1)97.29Extended and Complete 1989-1999
No Gen.: Only Non-haz. Waste (Yes/No)Reason for not generating waste -- Only non-hazardous waste (Y/N)char(1)97.12Extended and Complete 1989-1999
No Gen.: Occasional Generator (Yes/No)Reason for not generating waste -- Periodic or occasional generator (Y/N)char(1)96.76Extended and Complete 1989-1999
No Gen.: Waste Minimization (Yes/No)Reason for not generating waste -- Waste minimization activity (Y/N)char(1)97.15Extended and Complete 1989-1999
No Gen.: Other Reason (Yes/No)Reason for not generating waste -- Other (see comments) (Y/N)char(1)96.44Extended and Complete 1989-1999

Section: Source Reduction and Recycling

This section provides information on source reduction and recycling limits at the facility.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
New Source Reduction (Yes/No)Did site begin or expand source reduction in reporting period? (Y/N)char(1)0.00Extended and Complete 1989-1995
New Recycling (Yes/No)Did site begin or expand recycling during reporting period? (Y/N)char(1)0.00Extended and Complete 1989-1995
New Recyc./Source Red. InvestigatedDid site investigate opportunities for source reduction or recycling? (Y/N)char(1)0.00Extended and Complete 1989-1995
Recyc. Limit: Insufficent Capital (Yes/No)Insufficient capital for new recycling (Y/N)char(1)2.75Extended and Complete 1989-1995
Recyc. Limit: Need Tech Info (Yes/No)Lack of technical info on recycling applicable to this site (Y/N)char(1)3.08Extended and Complete 1989-1995
Recyc. Limit: Poor cost Savings (Yes/No)Cost savings from recycling will not recover investment (Y/N)char(1)3.05Extended and Complete 1989-1995
Recyc. Limit: Quality Decline (Yes/No)Concern that product quality will decline from recycling (Y/N)char(1)3.01Extended and Complete 1989-1995
Recyc. Limit: Manifest Requirements (Yes/No)Waste manifest requirements inhibit off-site recycling shipments (Y/N)char(1)3.05Extended and Complete 1989-1995
Recyc. Limit: Financial Liability (Yes/No)Financial liability provisions inhibit off-site recycling (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: Technical Limits Off-site (Yes/No)Technical limits of production inhibit off-site recycling (Y/N)char(1)3.15Extended and Complete 1989-1995
Recyc. Limit: Technical Limits On-site (Yes/No)Technical limits of production inhibit on-site recycling (Y/N)char(1)3.17Extended and Complete 1989-1995
Recyc. Limit: Permitting Burdens (Yes/No)Permitting burdens inhibit recycling (Y/N)char(1)3.08Extended and Complete 1989-1995
Recyc. Limit: Lack of Off-site Fac.s (Yes/No)Lack of permitted off-site recycling facilities (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: No Market (Yes/No)Unable to identify a market for recyclable materials (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: More Not Tech. Feasible (Yes/No)Recycling previously implemented -- additional recycling not technically feasible (Y/N)char(1)4.07Extended and Complete 1991-1995
Recyc. Limit: More Not Econ. Feasible (Yes/No)Recycling previously implemented -- additional recycling not economically feasible (Y/N)char(1)4.13Extended and Complete 1991-1995
Recyc. Limit: More Blocked By Permit (Yes/No)Recycling previously implemented -- additional impeded by permitting requirements (Y/N)char(1)4.17Extended and Complete 1991-1995
Recyc. Limit: Other Reason (Yes/No)Other limits on recycling (see comments) (Y/N)char(1)4.11Extended and Complete 1989-1995
Source Limit: Insufficient Capital (Yes/No)Insufficient capital for new source reduction (Y/N)char(1)2.82Extended and Complete 1989-1995
Source Limit: No Tech. Info. (Yes/No)Lack of technical information on source reduction (Y/N)char(1)2.91Extended and Complete 1989-1995
Source Limit: Poor Cost Savings (Yes/No)Cost savings from source reduction will not recover investment (Y/N)char(1)2.84Extended and Complete 1989-1995
Source Limit: Product Quality (Yes/No)Concern that product quality may decline from source reduction (Y/N)char(1)3.00Extended and Complete 1989-1995
Source Limit: Tech. Limitations (Yes/No)Technical limitations of production impede source reduction (Y/N)char(1)2.77Extended and Complete 1989-1995
Source Limit: Permitting Burdens (Yes/No)Permitting burdens impede source reduction (Y/N)char(1)2.84Extended and Complete 1989-1995
Source Limit: More Not Tech. Feasible (Yes/No)Source reduction previously implemented -- additional source red. not technically feasible (Y/Nchar(1)4.03Extended and Complete 1991-1995
Source Limit: More Not Econ. Feasible (Yes/No)Source reduction previously implemented -- additional not economically feasible (Y/N)char(1)3.94Extended and Complete 1991-1995
Source Limit: More Blocked Permits (Yes/No)Source reduction previously implemented -- additional impeded by permitting requirements (Y/N)char(1)4.08Extended and Complete 1991-1995
Source Limit: Other Reason (Yes/No)Other source reduction limitation (see comments) (Y/N)char(1)4.01Extended and Complete 1989-1995

Section: Certification(s)

This section lists one or more certification statements -- statements that the information submitted is correct -- from officials in charge of the facility.

This section can have more than one entry per record. The record with the most entries currently holds 16. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Cert. First NameFirst name of person certifying submitted informationvarchar(15)7.44Extended and Complete  
Cert. Middle Init.Middle initial of person certifying submitted informationchar(1)66.72Extended and Complete 2001-2015
Cert. Last NameLast name of person certifying submitted informationvarchar(15)7.42Extended and Complete  
Cert. TitleTitle of person certifying submitted informationvarchar(45)8.99Extended and Complete  
Certification DateDate certification was signeddate7.34Extended and Complete  

Section: EPA Waste Codes for Facility

This section lists EPA waste codes that classify types of hazardous waste handled by the facility.

This section can have more than one entry per record. The record with the most entries currently holds 595. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeAn EPA waste code for the waste(s) at this facilitychar(4)0.00Extended and Complete 2001-2015

Section: State Waste Codes for Facility

This section lists state waste codes that classify types of hazardous waste handled by the facility.

This section can have more than one entry per record. The record with the most entries currently holds 165. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeWaste Code for State-Regulated Hazardous Wastevarchar(6)0.00Extended and Complete 2001-2015

Section: Facility Comments

This section lists comments on the facility.

This section can have more than one entry per record. The record with the most entries currently holds 25. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Facility CommentsA line of comments describing the facilityvarchar(60)76.92Extended and Complete 1991-2015

Section: State Actions for Facility

This section lists certain state actions at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 4. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Activity TypeType of state activity.varchar(5)0.00Extended and Complete 2003-2015
State Activity NotesNotes on state activity.varchar(240)29.75Extended and Complete 2003-2007

Section: Generated Waste Basics

This section provides the basic information about each generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 45,955. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00High through Complete  
Waste DescriptionFree-form description of the generated wastevarchar(240)10.26High through Complete  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00High through Complete  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.96High through Complete  
Form of WasteCode describing the form of the generated wastevarchar(4)13.42Complete only  
Unit of MeasurementCode for the unit of measurement for waste generation quantitieschar(1)0.00Complete only  
Waste DensityDensity of waste (if density units were used)decimal(6,2)80.43Complete only  
Waste Density UnitsDensity units: 1=lbs/gallon, 2=specific gravitychar(1)61.58Complete only  
Waste Origin TypeCode describing the origin of the wastechar(1)17.05High through Complete 1989-1999
Waste Gen. TDR System TypeCode for the type of hazardous waste treatment, recycling, or disposal system that generated this hazardous waste. Only filled in for wastes generated by TDR systems.varchar(4)78.82High through Complete  
On-site TDR (Yes/No)Did site treat, dispose, or recycle waste on-site or use sewer/POTW? (Y/N)char(1)1.05Complete only 1989-1999
Off-site TDR (Yes/No)Was any of this waste shipped off-site in the reporting year? (Y/N)char(1)2.01Complete only 1989-1999
New Waste Minim. (Yes/No)Were there new waste minimization activities in the reporting year? (Y/N)char(1)1.06Complete only 1989-1995
Waste Measurement PointCode describing the point at which the waste was measuredchar(1)15.57High through Complete 1991-1999
Radioactive Waste (Yes/No)Equals 'Y' if RCRA waste was mixed with radioactive wastechar(1)10.13High through Complete 1991-2001
SIC CodeSIC code for the process that generated the wastevarchar(4)16.42High through Complete 1989-1999
Waste Source CategoryThe general category of waste source type (assigned by RTK NET).char(1)0.00High through Complete  
Waste Source Type (Regularized)A version of the waste source type code that has been regularized by RTK NET.char(3)9.43High through Complete  
Waste Source TypeCode describing the type of process that was the source of the wastechar(3)8.82Complete only  
Waste Minimization IndicatorIndicates waste minimization efforts for this waste.char(1)0.00High through Complete 2009-2015
Waste NotesNotes on this generated waste.varchar(240)66.86Complete only 2005-2015
Waste in TRI DatabaseCode describing if and how this waste appears in the TRI databasechar(1)49.70High through Complete 1989-1995
Amount Generated Prior YearQuantity of waste generated in the previous year (year before reporting year)decimal(12,2)68.60Complete only 1989-1995
Amount Generated Current YearQuantity of waste generated in the current (reporting) yeardecimal(17,6)10.43Complete only  
Waste Min. Increased Tox. (Yes/No)Equals "Y" if waste minimization increased the toxicity of waste or emissionschar(1)91.32Complete only 1989-1995
New Recycling Current YearQuantity recycled in current year due to new activitiesdecimal(12,2)99.35Complete only 1989-1995
Production IndexActivity or production index relating production in prior year to production in reporting yeardecimal(5,2)97.97High through Complete 1989-1995
Source Reduction Current YearQuantity reduced by source reduction in current yeardecimal(12,2)96.89Complete only 1989-1995
Tons Generated Prior YearTons of waste generated in the year before the reporting yeardecimal(14,3)69.69High through Complete 1989-1995
Tons Generated Current YearTons of waste generated in the current (reporting) yeardecimal(14,3)10.87High through Complete  
Tons ManagedTotal tons of this generated waste managed on-site or sent off-site for management or storage in the reporting yeardecimal(14,3)4.34High through Complete  
New Recycling TonsTons of waste recycled in reporting year from new activitiesdecimal(14,3)99.37High through Complete 1989-1995
Source Reduced TonsTons of waste source reduced in reporting yeardecimal(14,3)97.15High through Complete 1989-1995
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00High through Complete  
Tons Managed OnsiteTons of generated waste managed on-site in the reporting yeardecimal(14,3)94.57High through Complete  
Tons Managed OffsiteTons of generated waste sent offsite for management or storage in the reporting yeardecimal(14,3)8.53High through Complete  
Include in National ReportIndicates whether this waste's information should be included in the National Hazardous Waste Reportchar(1)0.00High through Complete 2001-2015
Onsite Waste Management (Yes/No)Indicates whether there are onsite waste management records for this waste.char(1)0.00Complete only 2003-2015
Offsite Waste Management (Yes/No)Indicates whether there are offsite waste shipment records for this waste.char(1)0.00Complete only 2003-2015

Section: EPA Waste Codes for Generated Waste

This section lists EPA waste codes that describe why a particular generated waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 583. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code describing a generated wastechar(4)0.00High through Complete  

Section: State Waste Codes for Generated Waste

This section lists state waste codes that describe why a particular generated waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 288. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeCode for a type of state-regulated wastevarchar(6)3.73High through Complete  

Section: Cas Numbers for Generated Waste

This section lists the CAS numbers for certain chemicals within a generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 8. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
CAS NumberCas number of a constituent of the listed wastechar(10)20.93Complete only 1989-1991

Section: Generated Waste Comments

This section provides comments about a generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 39. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Gen. Waste CommentA line of comments describing a generated wastevarchar(60)51.70Extended and Complete  

Section: Onsite Generated Waste Management

This section provides information about onsite waste management of the generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 53. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
System Type CategoryThe general category of onsite system, as assigned by RTK NET.char(1)0.00Extended and Complete  
On-site System Type (Regularized)The onsite system type code, as regularized by RTK NET.char(4)18.88Extended and Complete  
On-site System TypeCode for a type of on-site treatment, disposal, or recycling system at the facilitychar(4)18.33Complete only  
On-site System QuantityQuantity treated, stored, or recycled in onsite system in reporting yeardecimal(17,6)18.33Complete only  
Tons ManagedTons managed on-site in this system in the reporting yeardecimal(14,3)18.60Extended and Complete  

Section: Generated Waste Transfers Offsite

This section provides information about transfers of waste to off-site locations.

This section can have more than one entry per record. The record with the most entries currently holds 1,649. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Offsite System Type CategoryThe general category of offsite system type, as assigned by RTK NET.char(1)0.00Extended and Complete  
Offsite System Type (Regularized)The offsite system type code, as regularized by RTK NET.varchar(4)4.85Extended and Complete  
Offsite System TypeThe type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler IDThe EPA ID of the off-site destination of the wastevarchar(12)0.06Extended and Complete  
Amount of Waste ShippedThe quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64Extended and Complete 1991-1999
Tons of Waste ShippedQuantity shipped off-site for management or storage in tonsdecimal(14,3)0.46Extended and Complete  
Offsite Facility NameThe name of the facility that the offsite waste transfer was sent tovarchar(40)0.00Extended and Complete  
Offsite CityThe city that the offsite transfer was sent tovarchar(30)1.49Extended and Complete  
Offsite StateState that offsite transfer was sent tochar(2)1.38Extended and Complete  
Offsite Info. SourceSource of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  

Section: Waste Gen. Min. Activities

This section provides information on waste minimization activities on a generated waste form at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 12. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Waste Minimization ActionCode for a type of waste minimization action taken during the reporting yearchar(3)21.18Complete only 1989-1995

Section: Received Waste Basics

This section provides the basic information about each received waste.

This section can have more than one entry per record. The record with the most entries currently holds 183,153. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00High through Complete  
Sub-page NumberNumber used to partially identify this received wastesmallint(6)0.00High through Complete  
Waste DescriptionFree-form text description of received wastevarchar(240)10.14High through Complete  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00High through Complete  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.97High through Complete  
Form of WasteCode describing the form of this received wastevarchar(4)11.60Complete only  
Units of MeasurementCode for unit of measure of quantity of waste receivedchar(1)0.00Complete only  
Waste DensityDensity of waste received (if density units are used)decimal(5,2)78.78Complete only  
Density UnitsDensity units; 1=lbs/gallon, 2=specific gravitychar(1)60.97Complete only  
Radioactive Waste (Yes/No)Equals "Y" if RCRA waste was mixed with radioactive wastechar(1)12.77High through Complete 1991-2001
TDR System CategoryThe general category of TDR system, as assigned by RTK NET.char(1)0.00High through Complete  
TDR System Type (Regularized)The TDR system type code, as regularized by RTK NET.varchar(4)0.70High through Complete  
TDR System TypeCode describing the type of treatment, disposal, or recycling system used to manage this received wastevarchar(4)0.00Complete only  
Sending Facility IDThe EPA ID of the facility that sent waste to this receiving facilityvarchar(12)0.00High through Complete  
Waste NotesNotes on this generated waste.varchar(240)79.58Complete only 2005-2015
Amount ReceivedThe amount of waste received in the reporting yeardecimal(17,6)0.00Complete only  
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00High through Complete  
Tons ReceivedTons of waste received for management or storage in the reporting yeardecimal(14,3)0.58High through Complete  
Sending Facility NameName of the facility that sent the wastevarchar(40)0.00High through Complete  
Sending Facility CityCity that the waste shipment was sent fromvarchar(30)21.73High through Complete  
Sending Facility StateState postal abbreviation for the state that the waste shipment was sent fromchar(2)21.72High through Complete  
Sender Info. SourceSource of the sending facility name and address info from a lookup of its EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = not foundchar(1)21.72Complete only  
Include in National ReportInclude this received waste information in the National Hazardous Waste Report (Y/N)char(1)0.00High through Complete 2001-2015

Section: EPA Waste Codes for Received Waste

This section lists EPA waste codes that describe why a particular received waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 575. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code for this received wastechar(4)0.85High through Complete  

Section: State Waste Codes for Received Waste

This section lists state waste codes that describe why a particular received waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 132. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeCode for a type of state-regulated wastevarchar(6)1.78High through Complete  

Section: Received Waste Comments

This section provides comments about a received waste.

This section can have more than one entry per record. The record with the most entries currently holds 33. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Received Waste CommentsComment line describing a received wastevarchar(60)78.97Extended and Complete  

Section: Hazardous Secondary Materials

This section provides basic information about hazardous secondary materials at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 1. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Reason for NotificationIndicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00Extended and Complete 2015-2015
HSM Effective DateDate on which the facility either started or stopped managing hazardous secondary material.date80.30Extended and Complete 2015-2015
HSM Financial AssuranceIndicates whether facility has financial assurance pursuant to 40 CFR 261 subpart H. This is required for reclaimers and intermediate facilities.char(1)0.00Extended and Complete 2015-2015

Section: Hazardous Secondary Materials Tons

This section provides information about quantities of hazardous secondary materials at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 10. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
HSM Activity Sequence NumberSequence number showing the order of HSM activity lines.smallint(6)0.00High through Complete 2015-2015
HSM Activity Facility CodeCode that describes how a facility manages its hazardous secondary material and the type of activity that the facility performs in connection with it.char(2)0.00High through Complete 2015-2015
Estimated HSM Tons ManagedThe estimated tons of hazardous secondary material associated with this activity that the facility expects to manage annually.bigint(10)2.11High through Complete 2015-2015
Actual HSM Tons ManagedThe actual tons of hazardous secondary material associated with this activity that the facility managed in the most recent odd-numbered year.bigint(10)33.68High through Complete 2015-2015
HSM Activity Land-Based Unit CodeA code for the type of land-based unit used or that will be used to manage the hazardous secondary material in connection with this activity.char(2)0.00High through Complete 2015-2015
Number of EPA Waste CodesThe number of EPA waste codes associated with this hazardous secondary material activity. Field added by RTK NET.int(11)0.00High through Complete 2015-2015

Section: EPA Waste Codes for HSM

This section lists EPA waste codes that describe a particular hazardous secondary material.

This section can have more than one entry per record. The record with the most entries currently holds 9. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code for hazardous secondary material.char(4)0.00High through Complete 2015-2015

Section: TDR Systems

This section provides information on treatment, disposal, or recycling systems at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 71. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.03Extended and Complete 1989-1995
TDR System TypeCode describing the type of treatment, disposal, or recycling systemvarchar(4)0.58Extended and Complete 1989-1995
Regulatory StatusCode describing the regulatory status of the TDR systemchar(2)1.35Extended and Complete 1989-1995
Operational StatusCode describing the operational status of the TDR systemchar(2)7.93Extended and Complete 1989-1995
Amount Waste InfluentTotal waste quantity influent to TDR system in reporting yeardecimal(13,2)11.13Complete only 1989-1995
Amount RCRA Waste InfluentRCRA waste quantity influent to TDR system in reporting yeardecimal(13,2)25.73Complete only 1989-1995
Influent Unit of MeasureCode for unit of measure used for influent quantitieschar(1)6.14Complete only 1989-1995
Influent DensityDensity of influent waste (if density units are used)decimal(5,2)52.53Complete only 1989-1995
Influent Density UnitsInfluent density units; 1=lbs/gallon, 2=specific gravitychar(1)48.82Complete only 1989-1995
Max. Operational CapacityMaximum operational capacity for all waste (same units as influent)decimal(13,2)21.00Extended and Complete 1989-1995
Max. RCRA CapacityMaximum operational capacity for RCRA waste (same units as influent)decimal(13,2)34.16Extended and Complete 1989-1995
Liquid Effluent QuantityTotal liquid waste effluent quantity in reporting yeardecimal(13,2)35.36Complete only 1989-1995
RCRA Effluent QuantityRCRA liquid waste effluent quantity in reporting yeardecimal(13,2)80.40Complete only 1989-1995
Effluent Units of MeasurementCode for unit of measure used for effluent wastechar(1)29.78Complete only 1989-1995
Effluent DensityDensity of effluent waste (if density units are used)decimal(5,2)58.15Complete only 1989-1995
Effluent Density UnitsEffluent density units; 1=lbs/gallon, 2=specific gravitychar(1)53.98Complete only 1989-1995
Solid / Sludge QuantityTotal solid/sludge residual quantity in reporting yeardecimal(13,2)44.20Extended and Complete 1989-1995
RCRA Solid / Sludge QuantityRCRA solid/sludge residual quantity in reporting yeardecimal(13,2)59.73Extended and Complete 1989-1995
Solid / Sludge UnitsCode for unit of measure used for sludgechar(1)37.22Complete only 1989-1995
Solid / Sludge DensityDensity of sludge (if density units are used)decimal(5,2)86.33Complete only 1989-1995
Solid / Sludge Density UnitsSludge density units; 1=lbs/gallon, 2=specific gravitychar(1)79.23Complete only 1989-1995
Commercial Cap. AvailableCode describing whether commercial capacity is availablechar(1)10.01Extended and Complete 1989-1995
Percent Cap. AvailablePercent of capacity that is commercially availabledecimal(6,2)90.10Extended and Complete 1989-1995
Planned Cap. Change (Yes/No)Is there a planned change in maximum capacity? (Y/N)char(1)52.51Extended and Complete 1989-1995
New Max. CapacityNew total waste maximum operational capacitydecimal(13,2)97.38Extended and Complete 1989-1995
New RCRA Max. CapacityNew RCRA waste maximum operational capacitydecimal(13,2)97.81Extended and Complete 1989-1995
Max. Capacity UnitsCode for unit of measure of new maximum capacitieschar(1)91.87Extended and Complete 1989-1995
Cap. Change YearPlanned year in which capacity change will occurvarchar(4)34.92Extended and Complete 1989-1995
Future Cap. AvailableCode for future commercial capacity availabilitychar(1)91.50Extended and Complete 1989-1995
Percent Future Cap. Avail.Percent of future capacity which will be commercially availabledecimal(6,2)99.15Extended and Complete 1989-1995
Cap. Limit 1Code for 1st possible factor limiting maximum operational capacitychar(2)10.84Extended and Complete 1989-1995
Cap. Limit 2Code for 2nd possible factor limiting maximum operational capacitychar(2)49.73Extended and Complete 1989-1995
Cap. Limit 3Code for 3rd possible factor limiting maximum operational capacitychar(2)72.04Extended and Complete 1989-1995
TDR Unit Type 11st possible code for a type of unit in the TDR systemchar(2)9.09Extended and Complete 1989-1995
TDR Unit Type 22nd possible code for a type of unit in the TDR systemchar(2)87.59Extended and Complete 1989-1995
TDR Unit Type 33rd possible code for a type of unit in the TDR systemchar(2)99.06Extended and Complete 1989-1995
TDR Unit Type 44th possible code for a type of unit in the TDR systemchar(2)99.47Extended and Complete 1991-1995
TDR Unit Type 55th possible code for a type of unit in the TDR systemchar(2)99.76Extended and Complete 1991-1995
TDR Unit Type 66th possible code for a type of unit in the TDR systemchar(2)99.15Extended and Complete 1995-1995
TDR System Desc.Free-form text description of TDR systemvarchar(240)12.61Extended and Complete 1989-1995
Tons Influent WasteTons of total waste influent to system in reporting yeardecimal(13,2)14.38Extended and Complete 1989-1995
Tons RCRA Influent WasteTons of RCRA waste influent to system in reporting yeardecimal(13,2)28.16Extended and Complete 1989-1995
Tons Liquid Effluent WasteTons of liquid waste effluent to system in reporting yeardecimal(13,2)39.94Extended and Complete 1989-1995
Tons RCRA Liquid Effluent WasteTons of liquid RCRA waste effluent to system in reporting yeardecimal(13,2)81.92Extended and Complete 1989-1995
Tons Solid Effluent WasteTons of solid/sludge effluent to system in reporting yeardecimal(13,2)47.75Extended and Complete 1989-1995
Tons RCRA Solid Effluent WasteTons of RCRA solid/sludge effluent to system in reporting yeardecimal(13,2)61.93Extended and Complete 1989-1995
System RCRA Exempt (Yes/No)Code for whether TDR system is RCRA exempt or notchar(1)0.00Extended and Complete 1989-1995

Section: TDR System Comments

This section provides comments on a treatment, disposal, or recycling waste management system.

This section can have more than one entry per record. The record with the most entries currently holds 15. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
TDR System CommentsComment describing this treatment, disposal, or recycling systemvarchar(60)2.09Complete only 1991-1995

Section: TDR System Units

This section provides information on units comprising a treatment, disposal, or recycling system.

This section can have more than one entry per record. The record with the most entries currently holds 6. This section is not displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
On-site Unit TypeCode for type of on-site unit within TDR systemchar(2)0.62Extended and Complete 1989-1995

Section: Waste Minimization

This section provides the basic information on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 45. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number: part of unqiue record identificationint(11)0.00Complete only 1991-1995
Waste Form CodeA code describing the form of the wastechar(4)0.09Complete only 1991-1995
Waste Unit of MeasurementCode for unit of measurement of waste (e.g. lbs)char(1)0.00Complete only 1991-1995
Waste DensityDensity of the wastedecimal(5,2)53.27Complete only 1991-1995
Waste Density UnitsUnit of measurement of waste densitychar(1)57.56Complete only 1991-1995
Waste Origin TypeCode describing the origin of the wastechar(1)0.61Complete only 1991-1995
Waste TDR System TypeCode for the type of TDR system that generated this hazardous waste. Only filled in for wastes generated by TDR systems.char(4)53.25Complete only 1991-1995
SIC CodeSIC code (industry classification) associated with this wastechar(4)0.05Complete only 1991-1995
Waste SourceCode for the type of process that was the source of the wastechar(3)0.05Complete only 1991-1995
Waste in TRI DatabaseCode describing if and how this waste appears in the TRI databasechar(1)40.75Complete only 1991-1995
Amount Generated Prior YearQuantity of waste generated in the previous year (year before reporting year)decimal(12,2)15.86Complete only 1991-1995
Amount Generated Current YearQuantity of waste generated in the current (reporting) yeardecimal(12,2)9.55Complete only 1991-1995
Waste Min Increased Tox. (Yes/No)Equals "Y" if waste minimization increased the toxicity of waste or emissionschar(1)0.92Complete only 1991-1995
New Recycling Current YearQuantity recycled in current year due to new activitiesdecimal(12,2)79.99Complete only 1991-1995
Production IndexActivity or production index relating production in prior year to production in reporting yeardecimal(5,2)38.97Complete only 1991-1995
Source Reduction Current YearQuantity reduced by source reduction in current yeardecimal(12,2)23.61Complete only 1991-1995
Recycling Current Year (Yes/No)Equals "Y" if waste was recycled in the current yearchar(1)0.12Complete only 1991-1995
Quantity Recycled OnsiteThe amount of waste recycled onsite -- see unit and density fields for units of measurementdecimal(12,2)92.74Complete only 1991-1995
Quantity Recycled OffsiteThe amount of waste recycled offsite -- see unit and density fields for units of measurementdecimal(12,2)73.66Complete only 1991-1995
Waste Measurement PointCode describing the point at which the waste was measuredchar(1)0.02Complete only 1991-1995
Radioactive Waste (Yes/No)Equals "Y" if RCRA waste was mixed with radioactive wastechar(1)0.57Complete only 1991-1995
Number EPA Waste CodesThe number of Federal EPA waste codes for this wasteint(11)1.07Complete only 1991-1995
Number State Waste CodesThe number of state waste codes for this wasteint(11)69.01Complete only 1991-1995
Number CAS NumbersThe number of CAS numbers for this wasteint(11)60.45Complete only 1991-1991
Number Waste Desc LinesThe number of 60-character waste description lines for this wasteint(11)32.15Complete only 1991-1995
Number CommentsThe number of 60-character comment lines for this wasteint(11)58.32Complete only 1991-1995
Number Waste Min ActivitiesThe number of waste minimization activities for this wasteint(11)1.23Complete only 1991-1995

Section: Waste Min Activity

This section provides information on waste minimization activities as described on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 6. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Waste Min ActivityCodes describing types of waste minimization activity.char(3)0.03Complete only 1991-1995

Section: Waste Min EPA Waste Codes

This section provides Federal EPA waste codes for a waste on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 21. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code describing the wastechar(4)0.00Complete only 1991-1995

Section: Waste Min State Waste Codes

The section provides state waste codes for a waste on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 5. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeCode for a type of state-regulated wastechar(6)0.00Complete only 1991-1995

Section: Waste Min CAS

This section lists the CAS numbers associated with a waste on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 5. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
CAS NumberCAS number of a constituent of the listed wastechar(10)2.25Complete only 1991-1991

Section: Waste Min Waste Desc

This section provides a free text deescription of a waste on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 5. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Waste DescriptionA 60-character line of free-form text describing the wastechar(60)0.00Complete only 1991-1995

Section: Waste Min Comments

This section provides comments on a waste minimization form.

This section can have more than one entry per record. The record with the most entries currently holds 12. This section is not displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Waste Min CommentsA 60-character line of comments on the waste minimization formvarchar(60)0.01Complete only 1991-1995

Generated Waste-based reports

Section: Generated Waste Basics

This section provides the basic information about each generated waste.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00All  
Waste DescriptionFree-form description of the generated wastevarchar(240)10.26All  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00All  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.96All  
Form of WasteCode describing the form of the generated wastevarchar(4)13.42Complete only  
Unit of MeasurementCode for the unit of measurement for waste generation quantitieschar(1)0.00Complete only  
Waste DensityDensity of waste (if density units were used)decimal(6,2)80.43Complete only  
Waste Density UnitsDensity units: 1=lbs/gallon, 2=specific gravitychar(1)61.58Complete only  
Waste Origin TypeCode describing the origin of the wastechar(1)17.05All 1989-1999
Waste Gen. TDR System TypeCode for the type of hazardous waste treatment, recycling, or disposal system that generated this hazardous waste. Only filled in for wastes generated by TDR systems.varchar(4)78.82All  
On-site TDR (Yes/No)Did site treat, dispose, or recycle waste on-site or use sewer/POTW? (Y/N)char(1)1.05Complete only 1989-1999
Off-site TDR (Yes/No)Was any of this waste shipped off-site in the reporting year? (Y/N)char(1)2.01Complete only 1989-1999
New Waste Minim. (Yes/No)Were there new waste minimization activities in the reporting year? (Y/N)char(1)1.06Complete only 1989-1995
Waste Measurement PointCode describing the point at which the waste was measuredchar(1)15.57All 1991-1999
Radioactive Waste (Yes/No)Equals 'Y' if RCRA waste was mixed with radioactive wastechar(1)10.13All 1991-2001
SIC CodeSIC code for the process that generated the wastevarchar(4)16.42All 1989-1999
Waste Source CategoryThe general category of waste source type (assigned by RTK NET).char(1)0.00All  
Waste Source Type (Regularized)A version of the waste source type code that has been regularized by RTK NET.char(3)9.43All  
Waste Source TypeCode describing the type of process that was the source of the wastechar(3)8.82Complete only  
Waste NotesNotes on this generated waste.varchar(240)66.86Complete only 2005-2015
Waste Minimization IndicatorIndicates waste minimization efforts for this waste.char(1)0.00All 2009-2015
Waste in TRI DatabaseCode describing if and how this waste appears in the TRI databasechar(1)49.70All 1989-1995
Amount Generated Prior YearQuantity of waste generated in the previous year (year before reporting year)decimal(12,2)68.60Complete only 1989-1995
Amount Generated Current YearQuantity of waste generated in the current (reporting) yeardecimal(17,6)10.43Complete only  
Waste Min. Increased Tox. (Yes/No)Equals "Y" if waste minimization increased the toxicity of waste or emissionschar(1)91.32Complete only 1989-1995
New Recycling Current YearQuantity recycled in current year due to new activitiesdecimal(12,2)99.35Complete only 1989-1995
Production IndexActivity or production index relating production in prior year to production in reporting yeardecimal(5,2)97.97All 1989-1995
Source Reduction Current YearQuantity reduced by source reduction in current yeardecimal(12,2)96.89Complete only 1989-1995
Tons Generated Prior YearTons of waste generated in the year before the reporting yeardecimal(14,3)69.69All 1989-1995
Tons Generated Current YearTons of waste generated in the current (reporting) yeardecimal(14,3)10.87All  
Tons ManagedTotal tons of this generated waste managed on-site or sent off-site for management or storage in the reporting yeardecimal(14,3)4.34All  
New Recycling TonsTons of waste recycled in reporting year from new activitiesdecimal(14,3)99.37All 1989-1995
Source Reduced TonsTons of waste source reduced in reporting yeardecimal(14,3)97.15All 1989-1995
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00All  
Tons Managed OnsiteTons of generated waste managed on-site in the reporting yeardecimal(14,3)94.57All  
Tons Managed OffsiteTons of generated waste sent offsite for management or storage in the reporting yeardecimal(14,3)8.53All  
Include in National ReportIndicates whether this waste's information should be included in the National Hazardous Waste Reportchar(1)0.00All 2001-2015
Onsite Waste Management (Yes/No)Indicates whether there are onsite waste management records for this waste.char(1)0.00Complete only 2003-2015
Offsite Waste Management (Yes/No)Indicates whether there are offsite waste shipment records for this waste.char(1)0.00Complete only 2003-2015

Section: Generated Waste-based Record Counts

This section lists how many repeats there are in repeating data sections that describe generated wastes. It is used in delimited output in order to see whether all of the repeats were listed in the delimited data or not.

This section is only displayed if comma or tab-delimited format is chosen.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Number EPA Waste CodesNumber of EPA waste codes for this generated wasteint(11)2.98All  
Number Onsite SystemsThe number of on-site waste management system records for this generated wasteint(11)93.29All  
Number State Waste CodesThe number of state waste codes for this generated wasteint(11)86.29All  
Number of TransfersThe number of off-site transfer records for this generated wasteint(11)8.09All  
Number Waste Min.The number of waste minimization records for this generated wasteint(11)92.83All 1989-1995
Number of CAS NumbersThe number of CAS numbers for this generated wasteint(11)86.10All 1989-1991
Number Gen. CommentsThe number of 60-character comment lines for this generated wasteint(11)33.59All  

Section: Basic Facility Info

This section supplies basic information about the facility generating the waste, such as its name, address, and industrial type.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015

Section: Basic Submission Info

This section supplies basic information about the data submission, such as the reporting year.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015

Section: Cas Numbers for Generated Waste

This section lists the CAS numbers for certain chemicals within a generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 8. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
CAS NumberCas number of a constituent of the listed wastechar(10)20.93Complete only 1989-1991

Section: EPA Waste Codes for Generated Waste

This section lists EPA waste codes that describe why a generated waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 583. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code describing a generated wastechar(4)0.00All  

Section: State Waste Codes for Generated Waste

This section lists state waste codes that describe why a generated waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 288. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeCode for a type of state-regulated wastevarchar(6)3.73All  

Section: Facility NAICS Codes

This section lists NAICS (industrial type) codes for the generating facility.

This section can have more than one entry per record. The record with the most entries currently holds 10. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
NAICS CodeNorth American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00Extended and Complete 2001-2015

Section: Facility SIC Codes

This section lists SIC (industrial type) codes for the generating facility.

This section can have more than one entry per record. The record with the most entries currently holds 12. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
SIC CodeSIC Code for facilitychar(4)0.03Extended and Complete 1991-1991

Section: Facility Status

This section gives indications of the status of various types of activities (waste generation, management, etc.) at the generating facility.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00High through Complete  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00High through Complete 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00High through Complete 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00High through Complete 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00High through Complete 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01High through Complete 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01High through Complete 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53High through Complete 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00High through Complete 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00High through Complete 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015

Section: Generated Waste Comments

This section provides comments about a generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 39. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Gen. Waste CommentA line of comments describing a generated wastevarchar(60)51.70High through Complete  

Section: Generated Waste Transfers Offsite

This section provides information about transfers of waste to off-site locations.

This section can have more than one entry per record. The record with the most entries currently holds 1,649. Only the first 5 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Offsite System Type CategoryThe general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System TypeThe type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler IDThe EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste ShippedThe quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste ShippedQuantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility NameThe name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite CityThe city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite StateState that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. SourceSource of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  

Section: Mailing Address and Contact Info

This section gives the mailing address and contact information for the generating facility.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68Extended and Complete 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00Extended and Complete  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20Extended and Complete  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00Extended and Complete  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00Extended and Complete  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25Extended and Complete  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89Extended and Complete 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00Extended and Complete 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53Extended and Complete 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99Extended and Complete 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14Extended and Complete 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19Extended and Complete 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06Extended and Complete 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08Extended and Complete 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12Extended and Complete 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71Extended and Complete 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46Extended and Complete  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08Extended and Complete 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95Extended and Complete  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93Extended and Complete 2009-2015

Section: Onsite Generated Waste Management

This section provides information about onsite waste management of the generated waste.

This section can have more than one entry per record. The record with the most entries currently holds 53. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
System Type CategoryThe general category of onsite system, as assigned by RTK NET.char(1)0.00High through Complete  
On-site System Type (Regularized)The onsite system type code, as regularized by RTK NET.char(4)18.88High through Complete  
On-site System TypeCode for a type of on-site treatment, disposal, or recycling system at the facilitychar(4)18.33Complete only  
On-site System QuantityQuantity treated, stored, or recycled in onsite system in reporting yeardecimal(17,6)18.33Complete only  
Tons ManagedTons managed on-site in this system in the reporting yeardecimal(14,3)18.60High through Complete  

Section: Owners and Operators

This section provides information on the owners and operators of the generating facility.

This section can have more than one entry per record. The record with the most entries currently holds 16. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Owner or Operator Ind.Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator NameSite's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator DateDate that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator TypeOwner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street NumberThe street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator CityThe city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator StateThe state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zipthe Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country CodeA code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator CountryThe country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator PhoneThe phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator NotesNotes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015

Section: Waste Gen. Min. Activities

This section provides information on waste minimization activities on a generated waste form at the facility.

This section can have more than one entry per record. The record with the most entries currently holds 12. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is only displayed in Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Waste Minimization ActionCode for a type of waste minimization action taken during the reporting yearchar(3)21.18Complete only 1989-1995

Received Waste-based reports

Section: Received Waste Basics

This section provides the basic information about the received waste.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00All  
Sub-page NumberNumber used to partially identify this received wastesmallint(6)0.00All  
Waste DescriptionFree-form text description of received wastevarchar(240)10.14All  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00All  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.97All  
Form of WasteCode describing the form of this received wastevarchar(4)11.60Complete only  
Units of MeasurementCode for unit of measure of quantity of waste receivedchar(1)0.00Complete only  
Waste DensityDensity of waste received (if density units are used)decimal(5,2)78.78Complete only  
Density UnitsDensity units; 1=lbs/gallon, 2=specific gravitychar(1)60.97Complete only  
Radioactive Waste (Yes/No)Equals "Y" if RCRA waste was mixed with radioactive wastechar(1)12.77All 1991-2001
TDR System CategoryThe general category of TDR system, as assigned by RTK NET.char(1)0.00All  
TDR System Type (Regularized)The TDR system type code, as regularized by RTK NET.varchar(4)0.70All  
TDR System TypeCode describing the type of treatment, disposal, or recycling system used to manage this received wastevarchar(4)0.00Complete only  
Sending Facility IDThe EPA ID of the facility that sent waste to this receiving facilityvarchar(12)0.00All  
Waste NotesNotes on this generated waste.varchar(240)79.58Complete only 2005-2015
Amount ReceivedThe amount of waste received in the reporting yeardecimal(17,6)0.00Complete only  
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00All  
Tons ReceivedTons of waste received for management or storage in the reporting yeardecimal(14,3)0.58All  
Sending Facility NameName of the facility that sent the wastevarchar(40)0.00All  
Sending Facility CityCity that the waste shipment was sent fromvarchar(30)21.73All  
Sending Facility StateState postal abbreviation for the state that the waste shipment was sent fromchar(2)21.72All  
Sender Info. SourceSource of the sending facility name and address info from a lookup of its EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = not foundchar(1)21.72Complete only  
Include in National ReportInclude this received waste information in the National Hazardous Waste Report (Y/N)char(1)0.00All 2001-2015

Section: Received Waste-based Record Counts

This section lists how many repeats there are in repeating data sections that describe received wastes. It is used in delimited output in order to see whether all of the repeats were listed in the delimited data or not.

This section is only displayed if comma or tab-delimited format is chosen.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Number EPA Waste CodesNumber of EPA waste codes for this received wastesmallint(6)4.17All  
Number Rcv. CommentsThe number of 60-character comment lines for this received wastesmallint(6)31.74All  
Number State Waste CodesThe number of state waste codes for this received wastesmallint(6)87.24All  

Section: Basic Facility Info

This section supplies basic information about the facility receiving the waste, such as its name, address, and industrial type.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015

Section: Basic Submission Info

This section supplies basic information about the data submission, such as the reporting year.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015

Section: Facility Status

This section gives indications of the status of various types of activities (waste generation, management, etc.) at the receiving facility.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00High through Complete  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00High through Complete 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00High through Complete 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00High through Complete 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00High through Complete 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01High through Complete 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01High through Complete 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53High through Complete 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00High through Complete 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00High through Complete 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015

Section: Mailing Address and Contact Info

This section gives the mailing address and contact information for the receiving facility.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68Extended and Complete 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00Extended and Complete  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20Extended and Complete  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00Extended and Complete  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00Extended and Complete  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25Extended and Complete  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89Extended and Complete 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00Extended and Complete 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53Extended and Complete 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99Extended and Complete 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14Extended and Complete 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19Extended and Complete 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06Extended and Complete 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08Extended and Complete 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12Extended and Complete 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71Extended and Complete 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46Extended and Complete  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08Extended and Complete 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95Extended and Complete  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93Extended and Complete 2009-2015

Section: EPA Waste Codes for Received Waste

This section lists EPA waste codes that describe why a received waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 575. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
EPA Waste CodeA Federal EPA hazardous waste code for this received wastechar(4)0.85All  

Section: State Waste Codes for Received Waste

This section lists state waste codes that describe why a received waste is classified as hazardous.

This section can have more than one entry per record. The record with the most entries currently holds 132. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
State Waste CodeCode for a type of state-regulated wastevarchar(6)1.78All  

Section: Facility NAICS Codes

This section lists NAICS (industrial type) codes for the receiving facility.

This section can have more than one entry per record. The record with the most entries currently holds 10. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
NAICS CodeNorth American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00Extended and Complete 2001-2015

Section: Facility SIC Codes

This section lists SIC (industrial type) codes for the receiving facility.

This section can have more than one entry per record. The record with the most entries currently holds 12. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
SIC CodeSIC Code for facilitychar(4)0.03Extended and Complete 1991-1991

Section: Owners and Operators

This section provides information on the owners and operators of the receiving facility.

This section can have more than one entry per record. The record with the most entries currently holds 16. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Owner or Operator Ind.Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator NameSite's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator DateDate that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator TypeOwner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street NumberThe street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator CityThe city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator StateThe state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zipthe Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country CodeA code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator CountryThe country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator PhoneThe phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator NotesNotes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015

Section: Received Waste Comments

This section provides comments about a received waste.

This section can have more than one entry per record. The record with the most entries currently holds 33. If comma or tab-delimited format is chosen, all of the displayed data in this section are combined into a single field, with the multiple data elements within the field seperated by commas.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Received Waste CommentsComment line describing a received wastevarchar(60)78.97High through Complete  

Facility-based delimited data reports

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68All 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00All  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20All  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00All  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00All  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25All  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89All 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00All 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00All  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53All 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00All  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99All 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14All 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19All 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06All 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08All 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12All 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71All 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00All  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46All  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08All 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95All  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93All 2009-2015
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015
Total Tons GeneratedTotal tons of both Federal and state-regulated waste generated by the facilitydecimal(14,3)4.02All  
Total Tons Generated, ManagedTotal tons of Federal and state waste generated by the facility, then managed onsite or sent offsite for management or storagedecimal(14,3)4.47All  
Total Tons Generated, ShippedTotal tons of Federal and state waste generated, then shipped off-site for management or storage. This amount is part of the total amount generated, then managed.decimal(14,3)5.12All  
Total Tons Received, ManagedTotal tons of Federal and state waste received from off-site, then manageddecimal(14,3)97.99All  
Total Tons Transfer StorageTotal tons of Federal and state waste received from offsite for transfer storagedecimal(14,3)98.19All  
Total Tons ImportedTotal tons of Federal and state waste received and managed as part of wastes imported from other U.S. statesdecimal(14,3)98.56All  
Total Tons ExportedTotal tons of Federal and state shipped off-site as part of waste exported to other U.S. statesdecimal(14,3)27.17All  
Total Tons ManagedTotal tons of both Federal and state-regulated waste managed by the facility, whether waste came from on-site generation or was received from off-sitedecimal(14,3)4.35All  
Fed. Tons GeneratedTotal tons of Federal waste generated by the facilitydecimal(14,3)5.48All  
Fed. Tons Generated, ManagedTotal tons of Federal waste generated, then managed onsite or sent off-site for management or storagedecimal(14,3)5.92All  
Fed. Tons Generated, ShippedTotal tons of Federal waste generated, then shipped off-site for management or storage. This amount is part of the total amount of Federal waste generated, then managed.decimal(14,3)6.58All  
Fed. Tons Received, ManagedTotal tons of Federal waste received from off-site, then manageddecimal(14,3)98.12All 1991-2015
Fed. Tons Transfer StorageTotal tons of Federal waste received from off-site for transfer storagedecimal(14,3)98.23All 1991-2015
Fed. Tons ImportedTotal tons of Federal waste received and managed as part of wastes imported from other U.S. statesdecimal(14,3)98.63All 1991-2015
Fed. Tons ExportedTotal tons of Federal waste shipped off-site as part of wastes exported to other U.S. statesdecimal(14,3)28.07All  
Fed. Tons ManagedTotal tons of Federal waste managed by the facility, whether waste came from on-site generation or was received from off-sitedecimal(14,3)5.82All  
Total Haz. Secondary Material TonsTotal actual tons of hazardous secondary material generated and managed on or offsite in the most recent odd-numbered year. Field added by RTK NET.decimal(14,3)99.84All 2009-2015
National Report Tons GeneratedTotal tons of Federal waste generated by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)5.32Complete only 1993-1997
National Report Tons ReceivedTotal tons of Federal waste received by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.09Complete only 1993-1997
National Report Tons ImportedTotal tons of Federal waste received by the facility from another (U.S.) state, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.93Complete only 1993-1997
National Report Tons ManagedTotal tons of Federal waste managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)96.14Complete only 1993-1997
National Report Tons Received and ManagedTotal tons of Federal waste received and managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)98.28Complete only 1993-1997
National Report Tons WastewaterTotal tons of Federal waste, as wastewater, managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.36Complete only 1993-1995
National Report Tons Non-wastewaterTotal tons of Federal waste, as non-wastewater, managed by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)97.03Complete only 1993-1995
National Report Tons ShippedTotal tons of Federal waste shipped by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)5.42Complete only 1993-1997
National Report Tons ExportedTotal tons of Federal waste shipped to another (U.S.) state by the facility, as reported in EPA's National Report. This quantity may be less than the Federal waste total, since EPA removes some waste from consideration for a variety of reasons.decimal(13,3)29.12Complete only 1993-1997
Number of Facility SICsThe number of SIC codes listed for the facilityint(11)9.35High through Complete 1991-1991
Number of TDR SystemsThe number of treatment, disposal, or recycling system records for the facilityint(11)83.03High through Complete 1989-1995
Number Add'l Univ. WastesThe number of additional (specified in comments) universal waste types indicated for the facilityint(11)96.48High through Complete 2001-2015
Number Facility EPA Waste CodesThe number of EPA waste codes indicated for the facilityint(11)21.27High through Complete 2001-2015
Number Facility State Waste CodesThe number of state waste codes indicated for the facilityint(11)90.76High through Complete 2001-2015
Number of Facility NAICSThe number of NAICS codes indicated for the facilityint(11)0.00High through Complete 2001-2015
Number Cert. RecordsThe number of certification records for the facilityint(11)0.19High through Complete  
Number State ActionsThe number of state action records for the facilityint(11)98.75High through Complete 2003-2015
Number Owner/OperatorsThe number of prior and current owner and operator records for the facility in the reporting yearint(11)5.82High through Complete 2001-2015
Number of Facility CommentsThe number of 60-character comment lines for this facilityint(11)40.19High through Complete 1991-2015
Number GM FormsThe number of GM form records (generated wastes) for this facilityint(11)3.72High through Complete  
Number WR FormsThe number of WR form records (received wastes) for this facilityint(11)96.98High through Complete  
Number Facility Total RecordsThe number of facility National Report Quantity total records for the facilityint(11)0.00High through Complete 1993-1997
Number WM FormsThe number of waste minimization (WM) forms for the facilityint(11)95.49High through Complete 1991-1995
Number of HSM RecordsThe number of HSM records. Field added by RTK NET.int(11)99.77High through Complete 2015-2015
Number of HSM ActivitiesThe number of HSM activity records. Field added by RTK NET.int(11)99.77High through Complete 2015-2015
NAICS Code (multiple values)North American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00All 2001-2015
SIC Code (multiple values)SIC Code for facilitychar(4)0.03All 1991-1991
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00All  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00All 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00All 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00All 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00All 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00All 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01All 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01All 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53All 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00All 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00All 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00All 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00All 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00All 2009-2015
Owner or Operator Ind. (#1)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00High through Complete 2001-2015
Owner / Operator Name (#1)Site's legal owner or operatorvarchar(40)0.07High through Complete 2001-2015
Owner / Operator Date (#1)Date that an entity became owner or operator of the facilitydate1.57High through Complete 2001-2015
Owner / Operator Type (#1)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00High through Complete 2001-2015
Owner / Operator Street Number (#1)The street number of the owner or operatorvarchar(12)68.59High through Complete 2001-2015
Owner / Operator Street 1 (#1)The first line of the street address of the owner or operatorvarchar(30)31.58High through Complete 2001-2015
Owner / Operator Street 2 (#1)The second line of the street address of the owner or operatorvarchar(30)94.35High through Complete 2001-2015
Owner / Operator City (#1)The city in the address of the owner or operatorvarchar(25)31.01High through Complete 2001-2015
Owner / Operator State (#1)The state postal abbreviation in the address of the owner or operatorchar(2)32.13High through Complete 2001-2015
Owner / Operator Zip (#1)the Zip Code in the address of the owner or operatorvarchar(14)31.05High through Complete 2001-2015
Owner / Operator Country Code (#1)A code for the country in the address of the owner or operator.char(2)43.53High through Complete 2009-2015
Owner / Operator Country (#1)The country in the address of the owner or operatorvarchar(50)0.00High through Complete 2001-2007
Owner / Operator Phone (#1)The phone number of the owner or operatorvarchar(15)52.82High through Complete 2009-2015
Owner / Operator Notes (#1)Notes on the owner or operatorvarchar(240)75.82High through Complete 2001-2015
Owner or Operator Ind. (#2)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00High through Complete 2001-2015
Owner / Operator Name (#2)Site's legal owner or operatorvarchar(40)0.07High through Complete 2001-2015
Owner / Operator Date (#2)Date that an entity became owner or operator of the facilitydate1.57High through Complete 2001-2015
Owner / Operator Type (#2)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00High through Complete 2001-2015
Owner / Operator Street Number (#2)The street number of the owner or operatorvarchar(12)68.59High through Complete 2001-2015
Owner / Operator Street 1 (#2)The first line of the street address of the owner or operatorvarchar(30)31.58High through Complete 2001-2015
Owner / Operator Street 2 (#2)The second line of the street address of the owner or operatorvarchar(30)94.35High through Complete 2001-2015
Owner / Operator City (#2)The city in the address of the owner or operatorvarchar(25)31.01High through Complete 2001-2015
Owner / Operator State (#2)The state postal abbreviation in the address of the owner or operatorchar(2)32.13High through Complete 2001-2015
Owner / Operator Zip (#2)the Zip Code in the address of the owner or operatorvarchar(14)31.05High through Complete 2001-2015
Owner / Operator Country Code (#2)A code for the country in the address of the owner or operator.char(2)43.53High through Complete 2009-2015
Owner / Operator Country (#2)The country in the address of the owner or operatorvarchar(50)0.00High through Complete 2001-2007
Owner / Operator Phone (#2)The phone number of the owner or operatorvarchar(15)52.82High through Complete 2009-2015
Owner / Operator Notes (#2)Notes on the owner or operatorvarchar(240)75.82High through Complete 2001-2015
LQG Batteries (Yes/No)Large Quantity Generator of Batteries (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Batteries (Yes/No)Large Quantity Accumulator of Batteries. As of 2007, changed to Managed Batteries.char(1)0.00Extended and Complete 2001-2007
LQG PesticidesLarge Quantity Generator of Pesticides (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Pesticides (Yes/No)Large Quantity Accumulator of Pesticides. As of 2007, changed to Managed Pesticides.char(1)0.00Extended and Complete 2001-2007
LQG Thermostats (Yes/No)Large Quantity Generator of Thermostats (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Thermostats (Yes/No)Large Quantity Accumulator of Thermostats. As of 2007, changed to Managed Mercury Containing Equipment.char(1)0.00Extended and Complete 2001-2007
LQG Lamps (Yes/No)Large Quantity Generator of Lamps (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2003
LQA Lamps (Yes/No)Large Quantity Accumulator of Lamps. As of 2007, changed to Managed Lamps.char(1)0.00Extended and Complete 2001-2007
Universal Waste DestinationDestination Facility for Universal Waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Universal Waste Code (#1)Indicates a type of 'other' universal waste not listed on the formchar(1)0.00Complete only 2001-2015
Universal Waste Code Owner (#1)Indicates which entity (usually Federal EPA or a state) defined the Universal Waste Code for this waste.char(2)0.00Complete only 2009-2015
Univ. Waste Generated (#1)Generated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)8.66Complete only 2001-2015
Univ. Waste Accumulated (#1)Accumulated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Complete only 2001-2015
Universal Waste Code (#2)Indicates a type of 'other' universal waste not listed on the formchar(1)0.00Complete only 2001-2015
Universal Waste Code Owner (#2)Indicates which entity (usually Federal EPA or a state) defined the Universal Waste Code for this waste.char(2)0.00Complete only 2009-2015
Univ. Waste Generated (#2)Generated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)8.66Complete only 2001-2015
Univ. Waste Accumulated (#2)Accumulated Other Universal Waste Activities (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Complete only 2001-2015
Used Oil Transporter (Yes/No)Used Oil Transporter (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Transfer Fac. (Yes/No)Used Oil Transfer Facility (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Processor (Yes/No)Used Oil Processor (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Re-refiner (Yes/No)Used Oil Re-refiner (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Burner (Yes/No)Off-Specification Used Oil Burner (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Marketer, Type 1Used Oil Fuel Marketer Who Directs Shipment of Off-Specification Used Oil to Off-Specification Used Oil Burner (Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
Used Oil Marketer, Type 2Used Oil Fuel Marketer Who First Claims the Used Oil Meets the Specifications (Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked = 'N')char(1)0.00Extended and Complete 2001-2015
No Gen.: Never Generated (Yes/No)Reason for not generating waste -- Never generated (Y/N)char(1)97.20Extended and Complete 1989-1999
No Gen.: Out of Business (Yes/No)Reason for not generating waste -- Out of business (Y/N)char(1)97.22Extended and Complete 1989-1999
No Gen.: Only Excluded Waste (Yes/No)Reason for not generating waste -- Only excluded or delisted waste (Y/N)char(1)97.29Extended and Complete 1989-1999
No Gen.: Only Non-haz. Waste (Yes/No)Reason for not generating waste -- Only non-hazardous waste (Y/N)char(1)97.12Extended and Complete 1989-1999
No Gen.: Occasional Generator (Yes/No)Reason for not generating waste -- Periodic or occasional generator (Y/N)char(1)96.76Extended and Complete 1989-1999
No Gen.: Waste Minimization (Yes/No)Reason for not generating waste -- Waste minimization activity (Y/N)char(1)97.15Extended and Complete 1989-1999
No Gen.: Other Reason (Yes/No)Reason for not generating waste -- Other (see comments) (Y/N)char(1)96.44Extended and Complete 1989-1999
New Source Reduction (Yes/No)Did site begin or expand source reduction in reporting period? (Y/N)char(1)0.00Extended and Complete 1989-1995
New Recycling (Yes/No)Did site begin or expand recycling during reporting period? (Y/N)char(1)0.00Extended and Complete 1989-1995
New Recyc./Source Red. InvestigatedDid site investigate opportunities for source reduction or recycling? (Y/N)char(1)0.00Extended and Complete 1989-1995
Recyc. Limit: Insufficent Capital (Yes/No)Insufficient capital for new recycling (Y/N)char(1)2.75Extended and Complete 1989-1995
Recyc. Limit: Need Tech Info (Yes/No)Lack of technical info on recycling applicable to this site (Y/N)char(1)3.08Extended and Complete 1989-1995
Recyc. Limit: Poor cost Savings (Yes/No)Cost savings from recycling will not recover investment (Y/N)char(1)3.05Extended and Complete 1989-1995
Recyc. Limit: Quality Decline (Yes/No)Concern that product quality will decline from recycling (Y/N)char(1)3.01Extended and Complete 1989-1995
Recyc. Limit: Manifest Requirements (Yes/No)Waste manifest requirements inhibit off-site recycling shipments (Y/N)char(1)3.05Extended and Complete 1989-1995
Recyc. Limit: Financial Liability (Yes/No)Financial liability provisions inhibit off-site recycling (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: Technical Limits Off-site (Yes/No)Technical limits of production inhibit off-site recycling (Y/N)char(1)3.15Extended and Complete 1989-1995
Recyc. Limit: Technical Limits On-site (Yes/No)Technical limits of production inhibit on-site recycling (Y/N)char(1)3.17Extended and Complete 1989-1995
Recyc. Limit: Permitting Burdens (Yes/No)Permitting burdens inhibit recycling (Y/N)char(1)3.08Extended and Complete 1989-1995
Recyc. Limit: Lack of Off-site Fac.s (Yes/No)Lack of permitted off-site recycling facilities (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: No Market (Yes/No)Unable to identify a market for recyclable materials (Y/N)char(1)3.14Extended and Complete 1989-1995
Recyc. Limit: More Not Tech. Feasible (Yes/No)Recycling previously implemented -- additional recycling not technically feasible (Y/N)char(1)4.07Extended and Complete 1991-1995
Recyc. Limit: More Not Econ. Feasible (Yes/No)Recycling previously implemented -- additional recycling not economically feasible (Y/N)char(1)4.13Extended and Complete 1991-1995
Recyc. Limit: More Blocked By Permit (Yes/No)Recycling previously implemented -- additional impeded by permitting requirements (Y/N)char(1)4.17Extended and Complete 1991-1995
Recyc. Limit: Other Reason (Yes/No)Other limits on recycling (see comments) (Y/N)char(1)4.11Extended and Complete 1989-1995
Source Limit: Insufficient Capital (Yes/No)Insufficient capital for new source reduction (Y/N)char(1)2.82Extended and Complete 1989-1995
Source Limit: No Tech. Info. (Yes/No)Lack of technical information on source reduction (Y/N)char(1)2.91Extended and Complete 1989-1995
Source Limit: Poor Cost Savings (Yes/No)Cost savings from source reduction will not recover investment (Y/N)char(1)2.84Extended and Complete 1989-1995
Source Limit: Product Quality (Yes/No)Concern that product quality may decline from source reduction (Y/N)char(1)3.00Extended and Complete 1989-1995
Source Limit: Tech. Limitations (Yes/No)Technical limitations of production impede source reduction (Y/N)char(1)2.77Extended and Complete 1989-1995
Source Limit: Permitting Burdens (Yes/No)Permitting burdens impede source reduction (Y/N)char(1)2.84Extended and Complete 1989-1995
Source Limit: More Not Tech. Feasible (Yes/No)Source reduction previously implemented -- additional source red. not technically feasible (Y/Nchar(1)4.03Extended and Complete 1991-1995
Source Limit: More Not Econ. Feasible (Yes/No)Source reduction previously implemented -- additional not economically feasible (Y/N)char(1)3.94Extended and Complete 1991-1995
Source Limit: More Blocked Permits (Yes/No)Source reduction previously implemented -- additional impeded by permitting requirements (Y/N)char(1)4.08Extended and Complete 1991-1995
Source Limit: Other Reason (Yes/No)Other source reduction limitation (see comments) (Y/N)char(1)4.01Extended and Complete 1989-1995
Cert. First Name (#1)First name of person certifying submitted informationvarchar(15)7.44Extended and Complete  
Cert. Middle Init. (#1)Middle initial of person certifying submitted informationchar(1)66.72Extended and Complete 2001-2015
Cert. Last Name (#1)Last name of person certifying submitted informationvarchar(15)7.42Extended and Complete  
Cert. Title (#1)Title of person certifying submitted informationvarchar(45)8.99Extended and Complete  
Certification Date (#1)Date certification was signeddate7.34Extended and Complete  
Cert. First Name (#2)First name of person certifying submitted informationvarchar(15)7.44Extended and Complete  
Cert. Middle Init. (#2)Middle initial of person certifying submitted informationchar(1)66.72Extended and Complete 2001-2015
Cert. Last Name (#2)Last name of person certifying submitted informationvarchar(15)7.42Extended and Complete  
Cert. Title (#2)Title of person certifying submitted informationvarchar(45)8.99Extended and Complete  
Certification Date (#2)Date certification was signeddate7.34Extended and Complete  
EPA Waste Code (multiple values)An EPA waste code for the waste(s) at this facilitychar(4)0.00Extended and Complete 2001-2015
State Waste Code (multiple values)Waste Code for State-Regulated Hazardous Wastevarchar(6)0.00Extended and Complete 2001-2015
Facility Comments (multiple values)A line of comments describing the facilityvarchar(60)76.92Extended and Complete 1991-2015
Reason for Notification (#1)Indicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00Extended and Complete 2015-2015
HSM Effective Date (#1)Date on which the facility either started or stopped managing hazardous secondary material.date80.30Extended and Complete 2015-2015
HSM Financial Assurance (#1)Indicates whether facility has financial assurance pursuant to 40 CFR 261 subpart H. This is required for reclaimers and intermediate facilities.char(1)0.00Extended and Complete 2015-2015
Reason for Notification (#2)Indicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00Extended and Complete 2015-2015
HSM Effective Date (#2)Date on which the facility either started or stopped managing hazardous secondary material.date80.30Extended and Complete 2015-2015
HSM Financial Assurance (#2)Indicates whether facility has financial assurance pursuant to 40 CFR 261 subpart H. This is required for reclaimers and intermediate facilities.char(1)0.00Extended and Complete 2015-2015

Generated Waste-based delimited data reports

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00All  
Waste DescriptionFree-form description of the generated wastevarchar(240)10.26All  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00All  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.96All  
Form of WasteCode describing the form of the generated wastevarchar(4)13.42Complete only  
Unit of MeasurementCode for the unit of measurement for waste generation quantitieschar(1)0.00Complete only  
Waste DensityDensity of waste (if density units were used)decimal(6,2)80.43Complete only  
Waste Density UnitsDensity units: 1=lbs/gallon, 2=specific gravitychar(1)61.58Complete only  
Waste Origin TypeCode describing the origin of the wastechar(1)17.05All 1989-1999
Waste Gen. TDR System TypeCode for the type of hazardous waste treatment, recycling, or disposal system that generated this hazardous waste. Only filled in for wastes generated by TDR systems.varchar(4)78.82All  
On-site TDR (Yes/No)Did site treat, dispose, or recycle waste on-site or use sewer/POTW? (Y/N)char(1)1.05Complete only 1989-1999
Off-site TDR (Yes/No)Was any of this waste shipped off-site in the reporting year? (Y/N)char(1)2.01Complete only 1989-1999
New Waste Minim. (Yes/No)Were there new waste minimization activities in the reporting year? (Y/N)char(1)1.06Complete only 1989-1995
Waste Measurement PointCode describing the point at which the waste was measuredchar(1)15.57All 1991-1999
Radioactive Waste (Yes/No)Equals 'Y' if RCRA waste was mixed with radioactive wastechar(1)10.13All 1991-2001
SIC CodeSIC code for the process that generated the wastevarchar(4)16.42All 1989-1999
Waste Source CategoryThe general category of waste source type (assigned by RTK NET).char(1)0.00All  
Waste Source Type (Regularized)A version of the waste source type code that has been regularized by RTK NET.char(3)9.43All  
Waste Source TypeCode describing the type of process that was the source of the wastechar(3)8.82Complete only  
Waste NotesNotes on this generated waste.varchar(240)66.86Complete only 2005-2015
Waste Minimization IndicatorIndicates waste minimization efforts for this waste.char(1)0.00All 2009-2015
Waste in TRI DatabaseCode describing if and how this waste appears in the TRI databasechar(1)49.70All 1989-1995
Amount Generated Prior YearQuantity of waste generated in the previous year (year before reporting year)decimal(12,2)68.60Complete only 1989-1995
Amount Generated Current YearQuantity of waste generated in the current (reporting) yeardecimal(17,6)10.43Complete only  
Waste Min. Increased Tox. (Yes/No)Equals "Y" if waste minimization increased the toxicity of waste or emissionschar(1)91.32Complete only 1989-1995
New Recycling Current YearQuantity recycled in current year due to new activitiesdecimal(12,2)99.35Complete only 1989-1995
Production IndexActivity or production index relating production in prior year to production in reporting yeardecimal(5,2)97.97All 1989-1995
Source Reduction Current YearQuantity reduced by source reduction in current yeardecimal(12,2)96.89Complete only 1989-1995
Tons Generated Prior YearTons of waste generated in the year before the reporting yeardecimal(14,3)69.69All 1989-1995
Tons Generated Current YearTons of waste generated in the current (reporting) yeardecimal(14,3)10.87All  
Tons ManagedTotal tons of this generated waste managed on-site or sent off-site for management or storage in the reporting yeardecimal(14,3)4.34All  
New Recycling TonsTons of waste recycled in reporting year from new activitiesdecimal(14,3)99.37All 1989-1995
Source Reduced TonsTons of waste source reduced in reporting yeardecimal(14,3)97.15All 1989-1995
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00All  
Tons Managed OnsiteTons of generated waste managed on-site in the reporting yeardecimal(14,3)94.57All  
Tons Managed OffsiteTons of generated waste sent offsite for management or storage in the reporting yeardecimal(14,3)8.53All  
Include in National ReportIndicates whether this waste's information should be included in the National Hazardous Waste Reportchar(1)0.00All 2001-2015
Onsite Waste Management (Yes/No)Indicates whether there are onsite waste management records for this waste.char(1)0.00Complete only 2003-2015
Offsite Waste Management (Yes/No)Indicates whether there are offsite waste shipment records for this waste.char(1)0.00Complete only 2003-2015
Number EPA Waste CodesNumber of EPA waste codes for this generated wasteint(11)2.98All  
Number Onsite SystemsThe number of on-site waste management system records for this generated wasteint(11)93.29All  
Number State Waste CodesThe number of state waste codes for this generated wasteint(11)86.29All  
Number of TransfersThe number of off-site transfer records for this generated wasteint(11)8.09All  
Number Waste Min.The number of waste minimization records for this generated wasteint(11)92.83All 1989-1995
Number of CAS NumbersThe number of CAS numbers for this generated wasteint(11)86.10All 1989-1991
Number Gen. CommentsThe number of 60-character comment lines for this generated wasteint(11)33.59All  
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015
CAS Number (multiple values)Cas number of a constituent of the listed wastechar(10)20.93Complete only 1989-1991
EPA Waste Code (multiple values)A Federal EPA hazardous waste code describing a generated wastechar(4)0.00All  
State Waste Code (multiple values)Code for a type of state-regulated wastevarchar(6)3.73All  
NAICS Code (multiple values)North American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00Extended and Complete 2001-2015
SIC Code (multiple values)SIC Code for facilitychar(4)0.03Extended and Complete 1991-1991
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00High through Complete  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00High through Complete 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00High through Complete 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00High through Complete 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00High through Complete 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01High through Complete 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01High through Complete 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53High through Complete 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00High through Complete 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00High through Complete 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Gen. Waste Comment (multiple values)A line of comments describing a generated wastevarchar(60)51.70High through Complete  
Offsite System Type Category (#1)The general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized) (#1)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System Type (#1)The type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler ID (#1)The EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste Shipped (#1)The quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability (#1)1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste Shipped (#1)Quantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility Name (#1)The name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite City (#1)The city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite State (#1)State that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. Source (#1)Source of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  
Offsite System Type Category (#2)The general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized) (#2)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System Type (#2)The type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler ID (#2)The EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste Shipped (#2)The quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability (#2)1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste Shipped (#2)Quantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility Name (#2)The name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite City (#2)The city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite State (#2)State that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. Source (#2)Source of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  
Offsite System Type Category (#3)The general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized) (#3)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System Type (#3)The type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler ID (#3)The EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste Shipped (#3)The quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability (#3)1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste Shipped (#3)Quantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility Name (#3)The name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite City (#3)The city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite State (#3)State that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. Source (#3)Source of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  
Offsite System Type Category (#4)The general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized) (#4)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System Type (#4)The type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler ID (#4)The EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste Shipped (#4)The quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability (#4)1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste Shipped (#4)Quantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility Name (#4)The name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite City (#4)The city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite State (#4)State that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. Source (#4)Source of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  
Offsite System Type Category (#5)The general category of offsite system type, as assigned by RTK NET.char(1)0.00High through Complete  
Offsite System Type (Regularized) (#5)The offsite system type code, as regularized by RTK NET.varchar(4)4.85High through Complete  
Offsite System Type (#5)The type of treatment, disposal, or recycling system used at the off-site destination of the wastevarchar(4)3.59Complete only  
Offsite Handler ID (#5)The EPA ID of the off-site destination of the wastevarchar(12)0.06High through Complete  
Amount of Waste Shipped (#5)The quantity of waste shipped off-site (units as given in generated waste information)decimal(17,6)0.06Complete only  
Offsite Facility Availability (#5)1=commercial off-site facility; 2=facility available only to the same company that shipped this wastechar(1)17.64High through Complete 1991-1999
Tons of Waste Shipped (#5)Quantity shipped off-site for management or storage in tonsdecimal(14,3)0.46High through Complete  
Offsite Facility Name (#5)The name of the facility that the offsite waste transfer was sent tovarchar(40)0.00High through Complete  
Offsite City (#5)The city that the offsite transfer was sent tovarchar(30)1.49High through Complete  
Offsite State (#5)State that offsite transfer was sent tochar(2)1.38High through Complete  
Offsite Info. Source (#5)Source of offsite destination information from lookup of EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = EPA ID not foundchar(1)1.38Complete only  
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68Extended and Complete 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00Extended and Complete  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20Extended and Complete  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00Extended and Complete  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00Extended and Complete  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25Extended and Complete  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89Extended and Complete 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00Extended and Complete 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53Extended and Complete 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99Extended and Complete 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14Extended and Complete 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19Extended and Complete 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06Extended and Complete 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08Extended and Complete 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12Extended and Complete 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71Extended and Complete 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46Extended and Complete  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08Extended and Complete 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95Extended and Complete  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93Extended and Complete 2009-2015
System Type Category (#1)The general category of onsite system, as assigned by RTK NET.char(1)0.00High through Complete  
On-site System Type (Regularized) (#1)The onsite system type code, as regularized by RTK NET.char(4)18.88High through Complete  
On-site System Type (#1)Code for a type of on-site treatment, disposal, or recycling system at the facilitychar(4)18.33Complete only  
On-site System Quantity (#1)Quantity treated, stored, or recycled in onsite system in reporting yeardecimal(17,6)18.33Complete only  
Tons Managed (#1)Tons managed on-site in this system in the reporting yeardecimal(14,3)18.60High through Complete  
System Type Category (#2)The general category of onsite system, as assigned by RTK NET.char(1)0.00High through Complete  
On-site System Type (Regularized) (#2)The onsite system type code, as regularized by RTK NET.char(4)18.88High through Complete  
On-site System Type (#2)Code for a type of on-site treatment, disposal, or recycling system at the facilitychar(4)18.33Complete only  
On-site System Quantity (#2)Quantity treated, stored, or recycled in onsite system in reporting yeardecimal(17,6)18.33Complete only  
Tons Managed (#2)Tons managed on-site in this system in the reporting yeardecimal(14,3)18.60High through Complete  
Owner or Operator Ind. (#1)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator Name (#1)Site's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator Date (#1)Date that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator Type (#1)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street Number (#1)The street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1 (#1)The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2 (#1)The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator City (#1)The city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator State (#1)The state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zip (#1)the Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country Code (#1)A code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator Country (#1)The country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator Phone (#1)The phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator Notes (#1)Notes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015
Owner or Operator Ind. (#2)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator Name (#2)Site's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator Date (#2)Date that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator Type (#2)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street Number (#2)The street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1 (#2)The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2 (#2)The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator City (#2)The city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator State (#2)The state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zip (#2)the Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country Code (#2)A code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator Country (#2)The country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator Phone (#2)The phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator Notes (#2)Notes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015
Waste Minimization Action (#1)Code for a type of waste minimization action taken during the reporting yearchar(3)21.18Complete only 1989-1995

Received Waste-based delimited data reports

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Page NumberPage number; part of unique record identificationint(11)0.00All  
Sub-page NumberNumber used to partially identify this received wastesmallint(6)0.00All  
Waste DescriptionFree-form text description of received wastevarchar(240)10.14All  
Form of Waste CategoryThe general category of the form of the waste, as assigned by RTK NET.char(1)0.00All  
Form of Waste (Regularized)The waste form code, as regularized by RTK NET.varchar(4)16.97All  
Form of WasteCode describing the form of this received wastevarchar(4)11.60Complete only  
Units of MeasurementCode for unit of measure of quantity of waste receivedchar(1)0.00Complete only  
Waste DensityDensity of waste received (if density units are used)decimal(5,2)78.78Complete only  
Density UnitsDensity units; 1=lbs/gallon, 2=specific gravitychar(1)60.97Complete only  
Radioactive Waste (Yes/No)Equals "Y" if RCRA waste was mixed with radioactive wastechar(1)12.77All 1991-2001
TDR System CategoryThe general category of TDR system, as assigned by RTK NET.char(1)0.00All  
TDR System Type (Regularized)The TDR system type code, as regularized by RTK NET.varchar(4)0.70All  
TDR System TypeCode describing the type of treatment, disposal, or recycling system used to manage this received wastevarchar(4)0.00Complete only  
Sending Facility IDThe EPA ID of the facility that sent waste to this receiving facilityvarchar(12)0.00All  
Waste NotesNotes on this generated waste.varchar(240)79.58Complete only 2005-2015
Amount ReceivedThe amount of waste received in the reporting yeardecimal(17,6)0.00Complete only  
Federal Waste (Yes/No)Equals 'Y' if this is a Federal waste (if it has an EPA waste code)char(1)0.00All  
Tons ReceivedTons of waste received for management or storage in the reporting yeardecimal(14,3)0.58All  
Sending Facility NameName of the facility that sent the wastevarchar(40)0.00All  
Sending Facility CityCity that the waste shipment was sent fromvarchar(30)21.73All  
Sending Facility StateState postal abbreviation for the state that the waste shipment was sent fromchar(2)21.72All  
Sender Info. SourceSource of the sending facility name and address info from a lookup of its EPA ID: B=BRS, R=RCRIS, F=FINDS, C=CERCLIS, N or blank = not foundchar(1)21.72Complete only  
Include in National ReportInclude this received waste information in the National Hazardous Waste Report (Y/N)char(1)0.00All 2001-2015
Number EPA Waste CodesNumber of EPA waste codes for this received wastesmallint(6)4.17All  
Number Rcv. CommentsThe number of 60-character comment lines for this received wastesmallint(6)31.74All  
Number State Waste CodesThe number of state waste codes for this received wastesmallint(6)87.24All  
Handler IDEPA unique identifier for each facilityvarchar(12)0.00All  
Facility NameThe name of the facility that this information was submitted forvarchar(80)0.00All  
Street NumberStreet number that the facility is located atvarchar(12)49.77All 2001-2015
Address Line 1The 1st line of the street address for the facilityvarchar(30)0.00All  
Address Line 2The 2nd line of the street address for the facilityvarchar(30)94.88All  
CityCity in which the facility is locatedvarchar(25)0.00All  
StateState postal abbreviation for state in which the facility is locatedchar(2)0.00All  
Zip CodePostal Zip Code for the facility (up to 9 digits with no dashes)varchar(14)0.30All  
FIPS County CodeThe FIPS code for the county in which the facility is located.varchar(5)0.00All 2009-2015
CountyCounty in which the facility is located, corrected for pre-2001 records from FIPS code if invalidvarchar(25)4.68All 1989-2007
State ID NumberA state ID number for the facilityvarchar(12)74.63All 1989-1999
State / County FIPSThe state-county postal FIPS code for the county in which the facility residesvarchar(5)15.89All 1989-1999
Country CodeA code for the country in which the facility is located.char(2)25.28All 2009-2015
First SIC Code1st SIC code for the facilityvarchar(4)20.15All 1989-1991
First NAICS CodeThe first listed NAICS code for the facilityvarchar(6)0.00All 2001-2015
Current OwnerThe current owner of the facilityvarchar(40)6.16All 2001-2015
Site Land TypeSite land type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = ' ')char(1)0.00All 2001-2015
State DistrictThe district (subregion of a state) of a facility. Used in some states.varchar(10)72.49Complete only 2003-2015
Facility NotesFree-text notes on the facility.text99.11Complete only 2005-2015
Reporting YearThe reporting year of the submitted BRS formvarchar(4)0.00All  
Reason for SubmittalReason for submittal (As a component of the Hazardous Waste Report = 'R', As a component of the Hazardous Waste Report AND any other reason for submittal = 'B')char(1)0.00All 2001-2007
Facility in National ReportIndicates whether this facility's information should be included in the National Hazardous Waste report (in years before 2001, this was 'RCRA waste' status)char(1)0.00All 2001-2015
Receive DateThe date on which the Biennial Report from the facility was received.date0.00All 2009-2015
Generator StatusThe status of the facility with respect to its generation of hazardous wastechar(1)0.00High through Complete  
State Generator StatusThe hazardous waste generation status of the facility with respect to the U.S. state that it is located inchar(1)0.00High through Complete 2001-2015
Importer (Yes/No)Indicates whether the facility imports hazardous waste into the U.S.char(1)0.00High through Complete 2001-2015
Radioactive Waste (Yes/No)Indicates whether the facility generates mixed waste (both hazardous and radioactive)char(1)0.00High through Complete 2001-2015
Transporter (Yes/No)Transporter of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Treater/Storer/Disposer (Yes/No)Indicates whether facility is a treater, storer, or disposer of hazardous wastechar(1)0.00High through Complete 2001-2015
Recycler (Yes/No)Recycler of hazardous waste (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
SQG Onsite Burner ExemptionSmall Quantity On-Site Burner Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Smelting/Refining Furnace ExemptionSmelting, Melting, Refining Furnace Exemption (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Underground Injection (Yes/No)Underground Injection Control (If SUBMITTAL_REASON = 'R' Then Checked = 'Y', Unchecked and not implementer required = 'U', Unchecked and implementer required = 'N' If SUBMITTAL_REASON = 'B' Then Checked = 'Y', Unchecked = 'N')char(1)0.00High through Complete 2001-2015
Waste Storage StatusThe status of waste storage at the facilitychar(1)0.01High through Complete 1989-1999
RCRA TDR StatusCode for whether facility has a RCRA permitted treatment, disposal, or recycling systemchar(1)0.01High through Complete 1989-1997
RCRA Exempt TDR StatusCode for whether facility has a RCRA exempt treatment, disposal, or recycling systemchar(1)24.53High through Complete 1989-1999
Short Term GenerationIndicates whether reported hazardous waste generator status is from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete 2009-2015
Transfer FacilityIndicates whether the facility is a transfer facility (holds haz waste for 10 days of less while the waste is in transit).char(1)0.00High through Complete 2009-2015
Received Waste From OffsiteIndicates whether the facility received hazardous waste from another site.char(1)0.00High through Complete 2009-2015
Subpart K CollegeIndicates that the facility is a college or university that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K HospitalIndicates that the facility is a teaching hospital that has opted into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K NonprofitIndicates that the facility is a nonprofit affiliated with a college or university that has opted into Subpart K for management of haz wastes in laboratories.char(1)0.00High through Complete 2009-2015
Subpart K WithdrawalIndicates that the facility is withdrawing from an opt-in into Subpart K for management of hazardous wastes in laboratories.char(1)0.00High through Complete 2009-2015
Mailing Street NumberStreet number in the facility's mailing addressvarchar(12)55.68Extended and Complete 2001-2015
Mailing Address Line 1The 1st line of the mailing address of the facilityvarchar(30)0.00Extended and Complete  
Mailing Address Line 2The 2nd line of the mailing address of the facilityvarchar(30)88.20Extended and Complete  
Mailing CityThe city for the facility in its mailing addressvarchar(25)0.00Extended and Complete  
Mailing StateThe state (postal abbreviation) for the facility in its mailing addresschar(2)0.00Extended and Complete  
Mailing Zip CodeThe Zip code for the facility in its mailing addressvarchar(14)0.25Extended and Complete  
Mailing Country CodeA code for the country in the mailing address for the facility.char(2)24.89Extended and Complete 2009-2015
Mailing CountryCountry in the facility's mailing addressvarchar(50)0.00Extended and Complete 2001-2007
Contact First NameThe first name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Middle Init.Middle initial of a contact person for the facilitychar(1)56.53Extended and Complete 2001-2015
Contact Last NameThe last name of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Street NumberThe street number in the address of a contact person for the facility.varchar(12)36.99Extended and Complete 2009-2015
Contact Address Line 1The first line of the street address of a contact person for the facility.varchar(30)10.14Extended and Complete 2009-2015
Contact Address Line 2The second line of the street address of a contact person for the facility.varchar(30)88.19Extended and Complete 2009-2015
Contact CityThe city in the street address of a contact person for the facility.varchar(25)10.06Extended and Complete 2009-2015
Contact StateThe postal state abbreviation in the street address of a contact person for the facility.char(2)10.08Extended and Complete 2009-2015
Contact Zip CodeThe Zip code in the street address of a contact person for the facility.varchar(14)10.12Extended and Complete 2009-2015
Contact Country CodeA code for the country in the street address of a contact person for the facility.char(2)32.71Extended and Complete 2009-2015
Contact PhoneThe phone number of a contact person for the facilityvarchar(15)0.00Extended and Complete  
Contact Phone ExtensionThe phone extension of a contact person for the facilityvarchar(6)79.46Extended and Complete  
Contact EmailEmail address of a contact person for the facilityvarchar(240)33.08Extended and Complete 2001-2015
Contact TitleThe title of a contact person for the facilityvarchar(45)36.95Extended and Complete  
Contact FaxThe fax number of a contact person for the facility.varchar(15)49.93Extended and Complete 2009-2015
EPA Waste Code (multiple values)A Federal EPA hazardous waste code for this received wastechar(4)0.85All  
State Waste Code (multiple values)Code for a type of state-regulated wastevarchar(6)1.78All  
NAICS Code (multiple values)North American Industry Classification System Code, giving the type of industry that the facility is inchar(6)0.00Extended and Complete 2001-2015
SIC Code (multiple values)SIC Code for facilitychar(4)0.03Extended and Complete 1991-1991
Owner or Operator Ind. (#1)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator Name (#1)Site's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator Date (#1)Date that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator Type (#1)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street Number (#1)The street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1 (#1)The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2 (#1)The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator City (#1)The city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator State (#1)The state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zip (#1)the Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country Code (#1)A code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator Country (#1)The country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator Phone (#1)The phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator Notes (#1)Notes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015
Owner or Operator Ind. (#2)Indicates whether the record is for a current owner or operator (Current Owner = 'CO', Current Operator = 'CP')char(2)0.00Extended and Complete 2001-2015
Owner / Operator Name (#2)Site's legal owner or operatorvarchar(40)0.07Extended and Complete 2001-2015
Owner / Operator Date (#2)Date that an entity became owner or operator of the facilitydate1.57Extended and Complete 2001-2015
Owner / Operator Type (#2)Owner / Operator Type (Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian = 'I', Municipal = 'M', State = 'S', Other = 'O')char(1)0.00Extended and Complete 2001-2015
Owner / Operator Street Number (#2)The street number of the owner or operatorvarchar(12)68.59Extended and Complete 2001-2015
Owner / Operator Street 1 (#2)The first line of the street address of the owner or operatorvarchar(30)31.58Extended and Complete 2001-2015
Owner / Operator Street 2 (#2)The second line of the street address of the owner or operatorvarchar(30)94.35Extended and Complete 2001-2015
Owner / Operator City (#2)The city in the address of the owner or operatorvarchar(25)31.01Extended and Complete 2001-2015
Owner / Operator State (#2)The state postal abbreviation in the address of the owner or operatorchar(2)32.13Extended and Complete 2001-2015
Owner / Operator Zip (#2)the Zip Code in the address of the owner or operatorvarchar(14)31.05Extended and Complete 2001-2015
Owner / Operator Country Code (#2)A code for the country in the address of the owner or operator.char(2)43.53Extended and Complete 2009-2015
Owner / Operator Country (#2)The country in the address of the owner or operatorvarchar(50)0.00Extended and Complete 2001-2007
Owner / Operator Phone (#2)The phone number of the owner or operatorvarchar(15)52.82Extended and Complete 2009-2015
Owner / Operator Notes (#2)Notes on the owner or operatorvarchar(240)75.82Extended and Complete 2001-2015
Received Waste Comments (multiple values)Comment line describing a received wastevarchar(60)78.97High through Complete