Jump to main content.

EF/BR logo

Query Form User's Guide

The Biennial Reporting System (BRS) is the current mechanism utilized by EPA's Office of Solid Waste (OSW) to collect and report biennial data on hazardous waste generation and management. The information in BR is used to support the development of the National Biennial RCRA Hazardous Waste Report. Additionally, BR data are provided to the National Technical Information Service (NTIS). This allows NTIS to respond to requests from the public and industry for RCRIS or BR data. BR includes data on handler identification and certification, waste generation and management, waste receipt from off-site, waste treatment, disposal or recycling, and off-site installations and transporters.

This is a brief user's guide to the BR Query Form. Select between a variety of different query options and output options detailed below. Contact Us to send us additional queries or suggestions that you would find useful.

Select more than one query option at a time to speed up the query and make the retrieval more focused. Only those facilities matching all specified criteria will be retrieved.

Facility Identification Search Option

Handler Name

Enter the complete or partial handler name to retrieve all facilities with that name. Select the "Containing" option when entering a partial name for a better retrieval the first time you access the data. When an "Exact Match" option is specified for a handler name, do not specify another option; only one facility will be retrieved.

Handler ID

Enter the complete (12-character) or partial handler ID to retrieve all facilities with that ID. If it is more than 12 characters, an error message will appear. Select the "Containing" option when entering a partial ID for a better retrieval the first time you access the data. When an "Exact Match" option is specifed for a handler ID, do not specify another option; only one facility will be retrieved.

Geography Search Option

Select from five geographical search options: Location Address, State, City, County, and ZIP Code.

State

Enter a two-character state postal abbreviation. A list of the postal abbreviations and the state names is provided below:

AK = Alaska AL = Alabama AR = Arkansas
AS = American Samoa AZ = Arizona CA = California
CN = Canada CO = Colorado CT = Connecticut
DC = District of Columbia DE = Delaware FC = Other Foreign Countries
FL = Florida FM = Federated States of Micronesia GA = Georgia
GU = Guam HI = Hawaii IA = Iowa
ID = Idaho IL = Illinois IN = Indiana
IQ = Misc. U.S. Pacific Islands IT = All Indian Tribes KS = Kansas
KY = Kentucky LA = Louisiana MA = Massachusetts
MD = Maryland ME = Maine MH = Marshall Island
MI = Michigan MN = Minnesota MO = Missouri
MP = Northern Mariana Islands MQ = Midway Island MS = Mississippi
MT = Montana NC = North Carolina ND = North Dakota
NE = Nebraska NH = New Hampshire NJ = New Jersey
NM = New Mexico NV = Nevada NY = New York
OH = Ohio OK = Oklahoma OR = Oregon
PA = Pennsylvania PR = Puerto Rico PW = Palau, Republic of
RI = Rhode Island SC = South Carolina SD = South Dakota
TN = Tennessee TX = Texas UT = Utah
VA = Virginia VI = Virgin Islands VT = Vermont
WA = Washington WI = Wisconsin WQ = Wake Island
WV = West Virginia WY = Wyoming

Location Address

Enter a complete street addresss.

City

Enter a complete or partial city name and a two-character state postal abbreviation.

County

Enter a complete or partial county name and a two-character state postal abbreviation.

ZIP Code

The ZIP code entry can be five digits or fewer, or you may enter the five-digit ZIP Code plus the four-digit extension.

North American Industry Classification System (NAICS) Search Option

NAICS Description

Enter a complete or partial NAICS description to obtain a list of all NAICS codes that fit under the description. For example, entering "Accommodation" will retrieve all facilities with NAICS codes that have "Accommodation" somewhere in the NAICS description. Click on "Use RCRAInfo NACIS Code Values" to retrieve data from RCRAInfo or "Use Facility Identification NAICS Code Values" to retrieve data from the Facility Identification Tables.

NAICS Code

The NAICS Code entry can be five digits or fewer. If it is more than five digits, an error message will appear. Click on "Use RCRAInfo NAICS Code Values" to retrieve data from RCRAInfo.

Other Search Options

Reporting Year

Choose from the drop-box one of the years from which you want to generate a report. Data is available from reporting years 2001, 2003, 2005, and 2007. The default year is 2007.

Management Location

Enter the code for the major categories of waste handling and management. Click on the circle button next to either All, Offsite, Onsite, or Not Managed Onsite or Shipped Offsite. The default is "All".

Management Method

Enter a value for the Management Method. If you enter this criteria, the Management Location will default to "Onsite."

Waste Origin

Describes how the waste originated at the reporting site as either "Received" or "Generated". Click on the circle button next to either "Wastes generated onsite," "Wastes received from offsite facility," or "Both," which will retrieve data from both categories.

Waste Code

The EPA hazardous waste code and the hazardous waste sequence number for each waste reported at each site. You may enter up to three codes or sequence numbers in the spaces provided.

Form Code

The code, short name, and long description for the specific category of the physical form or chemical composition of the hazardous waste. You may enter codes for up to three categories.

Source Code

The code for the specific category of source process for the waste being reported.

BR Query Results

The BR Query Results provide a list of EPA-regulated facilities in Envirofacts that match the criteria you selected. Click on the hotlinked FACILITY ID for BR Reports. The information given for these facilities in the query results page includes:

  1. FACILITY ID
  2. HANDLER NAME
  3. The ADDRESS is a combination of the following individual attributes in BR:
  4. COUNTY NAME
  5. GENERATOR STATUS

BR Reports

The BR Reports include a BR Facility Summary Report and a BR Facility Waste Detail Report. The BR Facility Summary Report provides the following information:

  1. Facility Information:

  2. Mailing Information:

  3. Basic Waste Information:

The BR Facility Waste Detail Report provides the following information:

  1. Generated Waste Shipped to Offsite Facilities:

  2. Generated Waste Managed Onsite:

  3. Waste Received from Offsite Facilities:

Usage Constraints

Information in the BR database can be freely accessed through the use of this query. The complexity of the query is up to the user. Queries that return a large volume of data may terminate prematurely due to system limitations. The constraints established for the enviro user account (the query uses this to connect to the ORACLE database) are:

Develop queries that return small batches of data and terminate the session as soon as the queries have been executed, so that others can access the database.

Return to:

Local Navigation

Jump to main content.