|
|
For general help with the RCRIS database, try the top section of the help associated with the search forms.
RCRIS was last updated on RTK NET with a set of EPA data made on July 21, 2004.
If you have any questions, comments, or found any bugs in these reports please either send RTK NET mail to rtkhelp@rtknet.org or call us at 202-234-8494.
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).
The Summary level of detail produces minimal information for each incident. If you use text style output on the Web (as opposed to Email delivery), then the line for each incident will include a link to a High detail report on that incident, making the report output a "list of hits".
The fields in a Summary report for RCRIS are as follows:
| Data Field | Description | Field Type |
| Handler Name | The name of the handler (facility) that this information was submitted for | varchar(40) |
| State | State postal abbreviation for state in which the handler is located | char(2) |
| Gen. | Federal waste generation status of the handler. Use the "About the Data" button for meanings of the abbreviations used. | varchar(25) |
| TSD | Indicates whether the handler is an active TSD (treatment, storage, or disposal site) | char(1) |
| Current Viol. | The number of current violations for the handler | integer |
| All Penalties | The total dollar amount of all prior, current, and proposed penalties assessed to the handler | decimal(12) |
The section gives basic inforamtion on the handler, such as its name and RCRA ID number.
This section is displayed in Low, Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Handler ID | Unique EPA ID number assigned by a state or EPA Region to each RCRA site (i.e. each generator, transporter, or TSD). The first two characters are the postal code for the state in which the handler is located. | char(12) | 0 | All |
| EPA Facility ID | EPA FINDS ID that is supposed to uniquely identify a facility across different EPA data systems | varchar(12) | 95.12 | All |
| Handler Name | The official or legal name of the handler. A "handler" is like a facility, though it also includes transporters who transport waste from one place to another. | varchar(40) | 0 | All |
| EPA Region | The two-digit code for the EPA Region in which the handler is located | char(2) | 0 | Complete only |
| State | The state postal code for the state in which the handler is located | char(2) | 0 | All |
This section lists certain data fields created by RTK NET for each handler, such as pernalty totals, the number of current violations, and the dates of the first and last information submissions.
This section is displayed in Low, Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Number of Current Violations | The number of violation records that do not have a date on which the violation came into compliance | integer | 98.68 | All |
| Number of Violations | The number of violation records for this handler | integer | 86.85 | All |
| Proposed Penalty Total | The total dollar amount of proposed penalties for this handler | decimal(12) | 98.51 | All |
| Final Penalty Total | The total dollar amount of final assessed monetary penalties for this handler | decimal(12) | 98.05 | All |
| SEP Penalty Total | The total dollar amount of both costs and credits associated with SEPs (supplemental environmental projects) undertaken in liu of penalties | decimal(12) | 99.9 | All |
| Penalty Total | The total dollar amount of final monetary penalties, proposed monetary penalties, and SEP costs and credits | decimal(12) | 97.83 | All |
| First Info. Receipt Date | The first date on which information was received for this handler | date | 0.06817 | All |
| Last Info. Receipt Date | The last date on which information was received for this handler | date | 0.06817 | All |
This sections lists how many repeats there are in repeating data sections that describe each handler. They are used within delimited data output in order to see whether all data have been displayed or not.
This section is only displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Number of CA Area Records | The number of corrective action area records for this handler | integer | 98.87 | Medium, High or Complete |
| Number of CA Events | The number of corrective action event records for this handler | integer | 98.9 | Medium, High or Complete |
| Number of CA Authorities | The number of corrective action authority records for this handler | integer | 99.34 | Medium, High or Complete |
| Number of Evaluations | The number of compliance evaluation records for this handler | integer | 73.64 | Medium, High or Complete |
| Number of Enforcements | The number of enforcement records for this handler | integer | 88.2 | Medium, High or Complete |
| Number of Information Records | The number of handler information (aka hhandler2) records for this handler | integer | 0.06817 | Medium, High or Complete |
| Number of Previous IDs | The number of previous ID records for this handler | integer | 99.62 | Medium, High or Complete |
| Number of Current Information Records | The number of current information (aka report universe) records for this handler | integer | 0.002468 | Medium, High or Complete |
| Number of Permit Series | The number of permit series records for this handler | integer | 98.09 | Medium, High or Complete |
| Number of Process Units | The number of process unit records for this handler | integer | 98.42 | Medium, High or Complete |
Each record holds the most recent information for the handler's activities within a US state. If a handler is active in more than one state (i.e. if it is a transporter, or if it has cross-state enforcement issues) it can have more than one record.
This section can have more than one entry per record. The record with the most entries currently holds 13. Only the first of these is displayed if comma or tab-delimited format is chosen.
This section is displayed in Low, Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Activity Location | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | All |
| Site Name | the legal name of the site | varchar(40) | 0.0692 | All |
| NAICS Code 1 | First NAICS industry code for the site | char(6) | 71.24 | All |
| NAICS Code 2 | Second NAICS industry code for the site | varchar(6) | 96.12 | Medium, High or Complete |
| NAICS Code 3 | Third NAICS industry code for the site | varchar(6) | 98.86 | Medium, High or Complete |
| NAICS Code 4 | Fourth NAICS industry code for the site | varchar(6) | 99.61 | Medium, High or Complete |
| Owner Name | Name of the current owner of the site | varchar(40) | 16.65 | All |
| Operator Name | Name of the current operator of the site | varchar(40) | 65.89 | Medium, High or Complete |
| Location Street Number | Street number from the physical address of the primary site entrance | varchar(12) | 59.08 | All |
| Location Street 1 | First line of the street address from the physical address of the primary site entrance | varchar(30) | 0.0732 | All |
| Location Street 2 | Second line of the street address from the physical address of the primary site entrance | varchar(30) | 97 | All |
| Location City | Name of the city or town in which the handler is physically located | varchar(25) | 0.06981 | All |
| Location State | The state postal abbreviation for the U.S. State in which the handler is physically located | char(2) | 0.06935 | All |
| Location Zip Code | The ZIP code from the physical address of the primary site entrance | varchar(14) | 0.09042 | All |
| County Code | Code for the county that the site is in (state postal abbreviation plus county FIPS code) | char(5) | 0.2061 | Complete only |
| County | The county in which the site is located | varchar(27) | 0.227 | High or Complete only |
| Mailing Street Number | The street number from the primary business mailing address for the handler | varchar(12) | 65.84 | High or Complete only |
| Mailing Street 1 | The first line of the street address for the primary mailing address for the handler | varchar(30) | 0.4469 | High or Complete only |
| Mailing Street 2 | The second line of the street address for the primary mailing address for the handler | varchar(30) | 97.4 | High or Complete only |
| Mailing City | The city or town from the primary mailing address for the handler | varchar(25) | 0.4459 | High or Complete only |
| Mailing State | The psotal state abbreviation for the state in the primary mailing address for the handler | char(2) | 0.4523 | High or Complete only |
| Mailing Zip Code | The Zip code in the primary mailing address for the handler | varchar(14) | 0.5056 | High or Complete only |
| Mailing Country | The country code in the primary mailing address for the handler | char(2) | 78.8 | High or Complete only |
| Contact Name | The name of the contact person for the handler | varchar(33) | 15.63 | Medium, High or Complete |
| Contact Street 1 | The first line of the street address of the contact person for the handler | varchar(30) | 18.05 | High or Complete only |
| Contact Street 2 | The second line of the street address of the contact person for the handler | varchar(30) | 98.24 | High or Complete only |
| Contact City | The city or town from the address of the primary contact person for the site | varchar(25) | 18.05 | High or Complete only |
| Contact State | The state postal abbreviation from the address of the primary contact person for the site | char(2) | 18.02 | High or Complete only |
| Contact Zip Code | The Zip code from the address of the primary contact person for the site | varchar(14) | 18.05 | High or Complete only |
| Contact Country | The country code from the address of the primary contact person for the site | char(2) | 23.12 | High or Complete only |
| Contact Phone | The telephone number of the primary contact person for the site | varchar(22) | 16.37 | High or Complete only |
| Receive Date | Date that the form of information was received from the handler by the appropraite authority | date | 0.181 | Medium, High or Complete |
| Source Type | A code indicating the source of data for this information record | char(1) | 0.06812 | High or Complete only |
| Sequence Number | A sequence number used to uniquely identify each information source record | integer | 0.181 | Complete only |
| Extract Flag | An X indicates that the data are available for extract for public use | char(1) | 1.179 | Complete only |
| Latitude | The latititude of the site in decimal degrees | decimal(10,6) | 95.03 | Medium, High or Complete |
| Longitude | The longitude of the site in decimal degrees | decimal(11,6) | 95.03 | Medium, High or Complete |
| EPA Region | The two-digit code for the EPA Region in which the handler is located | char(2) | 0 | Complete only |
| State District | Indicates the state-designated legislative district(s) in which the site is located | char(10) | 47.6 | Complete only |
| Non-Notifier | A code indicating whether the handler is a non-notifier (i.e., the handler was identified without a Notification form and is suspected of carrying out RCRA regulated activities without proper authority | char(1) | 97.61 | Medium, High or Complete |
| Handler Not Accessible | Code the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator) | char(1) | 99.96 | Medium, High or Complete |
| Federal Waste Generation | A code for the type of Federally classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 3.951 | All |
| State Waste Generation | A code for the type of State classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 47.93 | All |
| Transporter Activity (Yes/No) | Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or water | char(1) | 0.181 | All |
| Operating TSDF Universe | Indicates whether handler has an operating Treatment, Storage, or Disposal unit. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment. | varchar(5) | 0.01092 | All |
| Full Enforcement Universe | Indicates whether handler is a TSDF that could potentially undergo a Compliance and Evaluation Inspection (CEI). Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment. | varchar(5) | 0.0123 | Medium, High or Complete |
| Radioactive Waste (Yes/No) | Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product material | char(1) | 8.682 | All |
| Recycler Activity (Yes/No) | Indicates whether the handler recycles hazardous waste | char(1) | 0.181 | Medium, High or Complete |
| Underground Injection (Yes/No) | Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface well | char(1) | 6.218 | High or Complete only |
| Importer Activity (Yes/No) | Indicates whether the facility imports hazardous waste into the U.S. from a foreign country | char(1) | 8.682 | High or Complete only |
| Universal Waste Destination (Yes/No) | Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste. | char(1) | 8.711 | High or Complete only |
| Used Oil Universe | Concatenation of seven Yes/No data fields indicating used oil activity | varchar(7) | 0.181 | High or Complete only |
| In SNC (Yes/No) | Indicates whether the handler is currently in Significant Non-Compliance (SNC) | char(1) | 0 | All |
| Beginning of Year SNC (Yes/No) | Indicates whether handler was in Significant Non-Compliance (SNC) at the beginning of the year | char(1) | 0.8395 | High or Complete only |
| Permit Workload Universe | Indicates whether handler is a facility with units that are in the permit pipeline or that has units with active permits. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.01107 | High or Complete only |
| Post-Closure Workload Universe | Indicates whether handler is a facility with closing land disposal units or storage units closing as landfills. Does not include clean closed units. The character L indicates that the facility is a member of the universe. | varchar(5) | 0.001999 | High or Complete only |
| Corrective Action Workload Universe | Indicates whether the handler has a unit undergoing corrective action acitvities. | char(1) | 0.01322 | High or Complete only |
| GPRA Operating Permit Universe | Indicates whether handler is a TSDF that had at least one unit that was operating or needed to obtain an operating permit as of October 1, 1997 | char(1) | 0.04905 | Complete only |
| GPRA Post-Closure Universe | Indicates whether handler is a Land Disposal facility that had at least one land disposal unit that ceased operating before October 1, 1997 and had not yet clean closed | char(1) | 0.04905 | Complete only |
| GPRA Corrective Action Universe | Indicates whether the handler is one of the 1997 baseline list of facilities that are the highest priority for the Corrective Action program | char(1) | 0.04905 | Complete only |
| GPRA CME Universe | Identifies facilities (TSD, LQG, and SQG) that are actively managing hazardous waste and are a priority for the Enforcement program. Updated at the beginning of each fiscal year. | char(1) | 0.8395 | Complete only |
| Permit Progress Universe | Indicates whether the handler is a facility with units in the Permit, Closure, or Post-Closure Workload Universes. Seperate characters indicates (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.01553 | Complete only |
| Closure Workload Universe | Indicates whether the handler is a facility with units that are closing. Does not include units that are clean closed or post-closure. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.002922 | High or Complete only |
| Subject to CA Universe | Indicates whether the handler is potentially subject to corrective action | char(1) | 0.01369 | Complete only |
| TSDF Subject to CA Universe | Indicates whether the handler is a TSD facility that is potentially subject to corrective action under statutory section 3004(u)/(v) | char(1) | 0.0123 | Complete only |
| TSDF Subject CA Discretionary | Indicates whether the handler is a TSD facility that is only subject to corrective action under discretionary authorities | char(1) | 0.0009226 | Complete only |
| Non TSDF Under CA | Indicates whether the handler is a non TSD facility where corrective action has been imposed | char(1) | 0.004921 | Complete only |
| In Handler Universe | Indicates whether the site belongs to at least one of the handler universes | char(1) | 0 | Complete only |
| Generator Status Universe | Contains a 3-letter translation of the Federal Waste Generation Status code (LQG, SQG, CEG, N, or blank) | char(3) | 0.181 | Complete only |
| Burner Exemption (Yes/No) | Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemption | char(1) | 5.041 | High or Complete only |
| Furnace Exemption (Yes/No) | Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemption | char(1) | 5.041 | High or Complete only |
| Second ID | A number that may be assigned by a state to identify a handler | varchar(12) | 88.22 | High or Complete only |
| Biennial Report Year | The year of the biennial reporting data from which this information record is taken | integer | 97.15 | Complete only |
| In CME Universes | Obsolete field, no longer used | char(1) | 100 | Complete only |
| Date of Last Change | Date of the last change in the handler information records | date | 0.181 | Complete only |
| Owner Type | A code describing the type of current owner | char(1) | 18.43 | Complete only |
| Operator Type | A code describing the type of current operator | char(1) | 67.49 | Complete only |
| Owner Sequence Number | The sequence number of the current owner within the owner and operator data table | integer | 16.59 | Complete only |
| Operator Sequence Number | The sequence number of the current operator within the owner and operator data table | integer | 65.91 | Complete only |
| Number of Owners | The number of owner records within the owner and operator data table | integer | 17.56 | Complete only |
| Number of Operators | The number of operator records within the owner and operator data table | integer | 70.19 | Complete only |
| Owner Operator Hierarchy | Contains the owner type, or the operator type if the owner type is null. Only one character long. | char(2) | 17.83 | Complete only |
| In A Universe | Indicates that the site is in one of the universes | char(1) | 0 | Complete only |
| Mixed Source (Yes/No) | Indicates that this data record was taken from more than one h_handler information record | char(1) | 0.001076 | Complete only |
| Mixed Source Type | The value of the source type code for the handler information record that was one of the two (probably the latest one) used to create this data record | char(1) | 97.7 | Complete only |
| Mixed Source Sequence Number | The sequence number of the handler information record that was one of the two (probably the latest one) used to create this data record | integer | 97.7 | Complete only |
| Federal Waste Gen. Code Owner | The agency that determined the meaning of the Federal Waste Generator Code used | char(2) | 7.414 | Complete only |
| Federal Waste Generator Code | A code for the type of Federally classified waste generation at the site. It is meaningless without also consulting the determining agency code owner field. | char(1) | 5.391 | Complete only |
| State Waste Gen. Code Owner | The agency that determined the meaning of the State Waste Generator code used | char(2) | 47.95 | Complete only |
| State Waste Generator Code | A code for the type of State classified waste generation at the site. It is meaningless without also consulting the determining agency code owner field. | char(1) | 49.41 | Complete only |
This section lists how each handler's TSD units are classified. A regulatory "universe" means that the handler is one of a group of handlers of interest to regulators looking for handlers with specific characteristics.
This section is only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Post-Closure Workload Land Disposal | Indicates whether the handler has a land disposal unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Incinerator | Indicates whether the handler has an incinerator unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the post-closure universe | char(1) | 0 | Complete only |
| Permit Progress Land Disposal | Indicates whether the handler has a land disposal unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Incinerator | Indicates whether the handler has an incinerator unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Storage | Indicates whether the handler has a hazardous waste storage unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Treatment | Indicates whether the handler has a hazardous waste treatment unit in the permit progress universe | char(1) | 0 | Complete only |
| Closure Workload Land Disposal | Indicates whether the handler has a land disposal unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Incinerator | Indicates whether the handler has an incinerator unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the closure universe | char(1) | 0 | Complete only |
| Permit Workload Land Disposal | Indicates whether the handler has a land disposal unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Incinerator | Indicates whether the handler has an incinerator unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the permit workload universe | char(1) | 0 | Complete only |
| Full Enforcement Land Disposal | Indicates whether the handler has a land disposal unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Incinerator | Indicates whether the handler has an incinerator unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Storage | Indicates whether the handler has a hazardous waste storage unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Treatment | Indicates whether the handler has a hazardous waste treatment unit in the full enforcement universe | char(1) | 0 | Complete only |
| Operating TSDF Land Disposal | Indicates whether the handler has a land disposal unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Incinerator | Indicates whether the handler has an incinerator unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Storage | Indicates whether the handler has a hazardous waste storage unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Treatment | Indicates whether the handler has a hazardous waste treatment unit in the operating TSD universe | char(1) | 0 | Complete only |
| Used Oil Transporter (Yes/No) | Indicates whether the site transports or collects and transports used oil | char(1) | 0.5915 | Complete only |
| Used Oil Transfer Facility (Yes/No) | Indicates whether the site acts as a transfer facility for used oil (holds used oil for shipment for more than 1 and less than 35 days) | char(1) | 0.5915 | Complete only |
| Used Oil Processor (Yes/No) | Indicates whether the site processes used oil | char(1) | 0.5915 | Complete only |
| Used Oil Refiner (Yes/No) | Indicates whether the site refines used oil | char(1) | 0.5915 | Complete only |
| Used Oil Fuel Burner (Yes/No) | Indicates whether the site burns off-specification used oil for energy recovery | char(1) | 7.015 | Complete only |
| Used Oil Marketer (Yes/No) | Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burners | char(1) | 7.015 | Complete only |
| Used Oil Specification Cert. (Yes/No) | Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specification | char(1) | 7.015 | Complete only |
This section gives information about compliance evaluations -- i.e., inspections -- of the handler.
This section can have more than one entry per record. The record with the most entries currently holds 1,245. Only the first 3 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Evaluation Activity Location | The location, in the form of a state postal code, of the agency conducting the evaluation | char(2) | 0 | Complete only |
| Evaluation Sequence Number | Name or number assigned to identify an evaluation | char(3) | 0 | Complete only |
| Evaluation Date | The first day of the evaluation (inspection or record review) | date | 0 | Medium, High or Complete |
| Evaluation Responsible Agency | The agency responsible for conducting the evaluation | char(1) | 0 | Medium, High or Complete |
| Evaluation Type Code Owner | The agency that determined the meaning of the evaluation type code used | char(2) | 0 | Complete only |
| Evaluation Type Code | Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0.5847 | Complete only |
| Evaluation Type | A code for the type of evaluation (combined with the determining agency code for a single code lookup) | char(5) | 0 | Medium, High or Complete |
| Number of Evaluation-Violation Links | The number of evaluation-violation links for this evaluation | integer | 61.87 | Medium, High or Complete |
| Number of Evaluation Areas | The number of evaluation areas for this evaluation | integer | 49.15 | Complete only |
This section gives information on which types of inspection took place during a compliance evaluation (e.g. which types of records were checked).
This section can have more than one entry per record. The record with the most entries currently holds 66. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Evaluation Area Code Owner | The agency that determined the meaning of the evaluation coverage area type code used | char(2) | 0 | Complete only |
| Evaluation Area Code | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Evaluation Area | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | High or Complete only |
| Area Status | Code indicating the status of an evaluation coverage area | char(2) | 1.658 | High or Complete only |
This section specifies which compliance evaluations are linked to which violations. Only the data fields that specify which violations are linked to a compliance evaluation are displayed.
This section can have more than one entry per record. The record with the most entries currently holds 103. This section is not displayed if comma or tab-delimited format is chosen.
This section is only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Violation Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation | The agency that actually determined the violation | char(1) | 0 | Complete only |
This section gives information on permit and compliance violations by the handler.
This section can have more than one entry per record. The record with the most entries currently holds 334. Only the first 10 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Low, Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Violation Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links | The number of enforcement-violation links for this violation | integer | 13.28 | All |
This section gives information on enforcement actions due to compliance violations by the handler.
This section can have more than one entry per record. The record with the most entries currently holds 152. Only the first 3 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Low, Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Enforcement Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Enforcement Sequence Number | Name or number assigned to uniquely identify an enforcement | char(3) | 0 | Complete only |
| Enforcement Action Date | The date on which the enforcement action was issued | date | 0 | All |
| Enforcement Responsible Agency | The agency responsible for issuing the enforcement action | char(1) | 0 | All |
| Enforcement Type Code Owner | The agency that determed the meaning of the enforcement type code used | char(2) | 0 | Complete only |
| Enforcement Type Code | A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Enforcement Type | A code for the type of enforcement action (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Proposed Penalty Amount | The total amount of proposed penalties for this enforcement action | decimal(12) | 92.98 | All |
| Final Penalty Amount | The total amount of assessed monetary penalties for this enforcement action | decimal(12) | 91 | All |
| SEP Penalty Amount | The total dollar equivalent of work done on SEPs (supplemental environmental projects), as costs or credits, in liu of penalties | decimal(12) | 99.65 | All |
| Number of Media Records | The number of multi-media enforcement records (air, FIFRA, etc.) associated with this enforcement action | integer | 99.51 | Complete only |
| Number of SEP or Milestone records | The number of SEP (supplemental environmental project) or enforcement milestone records associated with this enforcement action | integer | 99.45 | Complete only |
| Number of Penalties | The number of penalty records associated with this enforcement action | integer | 87.69 | All |
| Number of Enforcement-Violation Links | The number of enforcement-violation links for this enforcement action | integer | 2.022 | All |
This section describes which non-RCRA EPA media programs (air, water, etc.) were also involved in enforcement actions.
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 or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Multimedia Type Code Owner | The agency that determined the meanings of the multimedia program type code used | char(2) | 0 | Complete only |
| Multimedia Type | A code for the medium or porgram other than RCRA that participated in the enforcement action | char(3) | 0 | High or Complete only |
This section describes what types of Supplemental Environmental Project (SEP) activity were associated with an enforcement action.
This section can have more than one entry per record. The record with the most entries currently holds 19. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| SEP Sequence Number | A system-generated number to uniquely identify each SEP or enforcement milestone record | char(2) | 0 | Complete only |
| SEP Type Code Owner | The agency that determined the meaning of the SEP or enforcement milestone type code | char(2) | 0 | Complete only |
| SEP Type | A code for the type of SEP or enforcement milestone record | char(3) | 0 | High or Complete only |
This section specifies which enforcement actions are linked to which violations. It also has scheduled compliance dates. Only the data fields that specify which violations are linked to an enforcement action are displayed.
This section can have more than one entry per record. The record with the most entries currently holds 103. This section is not displayed if comma or tab-delimited format is chosen.
This section is only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Violation Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation | The agency that actually determined the violation | char(1) | 0 | Complete only |
| Scheduled Compliance Date | Date by which the handler is to subject documentation showing that the violation has been brought into compliance | date | 43.77 | Complete only |
This section gives information on penalties that have been imposed on a handler.
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 only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Penalty Type Code Owner | The agency that determined the meaning of the penalty type code used | char(2) | 0 | Complete only |
| Penalty Type | A code for the type of penalty | char(3) | 0 | Complete only |
| Penalty Amount | The amount, in dollars, of the penalty | decimal(12) | 1.168 | Complete only |
This section lists previously used RCRA IDs for a handler.
This section can have more than one entry per record. The record with the most entries currently holds 3. 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 or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Previous Handler ID | A previous EPA Handler ID for the handler | char(12) | 0 | High or Complete only |
This section gives the most basic information on RCRA permits for TSD facilities.
This section can have more than one entry per record. The record with the most entries currently holds 194. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Permit Series Sequence Number | System-generated number used to uniquely identify a permit series for a handler | char(4) | 0 | Complete only |
| Permit Series Name | Name or number assigned by an agency to identify a permit or permit application | varchar(12) | 0 | Medium, High or Complete |
| Number of Permit Events | The number of permit events associated with this permit series record | integer | 31.59 | Medium, High or Complete |
This section gives information on permit events (such as expiration) for a handler's RCRA permit.
This section can have more than one entry per record. The record with the most entries currently holds 139. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Event Sequence Number | System-generated number for uniquely identifying permit events | char(3) | 0 | Complete only |
| Activity Location | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | Complete only |
| Permit Event Code Owner | The agency responsible for determining the meaning of the permit event code used | char(2) | 0 | Complete only |
| Permit Event Code | Code for the type of permit event. It is meaningless without also consulting the determing agency code owner field. | char(7) | 0 | Complete only |
| Actual Date of Event | Date on which actual completion of a permitting or closure event occurs | date | 2.819 | Medium, High or Complete |
| Event Responsible Agency | Code indicating the agency responsible for conducting a permitting or closure program event | char(1) | 0 | Medium, High or Complete |
| Permit Event | A code for the type of permit event (combined with the determining agency code for a single code lookup) | char(9) | 0 | Medium, High or Complete |
| Number of Permit Event-Unit Links | The number of permit event-process unit links for this permit event | integer | 32.51 | Complete only |
This section specifies which permit events are linked to which process units. Only the data fields that specify which process units are linked to a permit event are displayed; the data fields that identify a permit event are not.
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 Field | Description | Field Type | % blank | Level of Detail |
| Activity Location | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | Complete only |
| Process Unit Sequence Number | System-generated number used to uniquely identify a process unit | char(4) | 0 | Complete only |
| Unit Detail Sequence Number | System-generated number to uniquely identify each process unit detail record | char(3) | 0 | Complete only |
This section lists waste process units for a handler. Each record might actually represent a group of process units if the units have the same process codes, measures, and activities.
This section can have more than one entry per record. The record with the most entries currently holds 619. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Process Unit Sequence Number | System-generated number used to uniquely identify a process unit | char(4) | 0 | Complete only |
| Process Unit Name | Name or number assigned by an agency to identify a process unit group | varchar(18) | 0 | Medium, High or Complete |
| Number of Process Unit Details | The number of process unti detail records associated with this process unit record | integer | 0.1368 | Medium, High or Complete |
| Number of Event-Unit Links | The number of permit event-process unit links for this process unit | integer | 61.72 | Medium, High or Complete |
This section gives details on waste process units.
This section can have more than one entry per record. The record with the most entries currently holds 24. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Unit Detail Sequence Number | System-generated number to uniquely identify each process unit detail record | char(3) | 0 | Complete only |
| Process Status Effective Date | Date specifying when the information in the process detail data record became effective | date | 0 | High or Complete only |
| Process Capacity | Amount of waste capacity | decimal(16) | 0.5533 | High or Complete only |
| Unit of Measure | The units of measurement of the process capacity | char(1) | 0 | High or Complete only |
| Number of Units in Group | The total number of units of the same process grouped together to form a single process unit group | integer | 0 | High or Complete only |
| Capacity Type Code Owner | The agency that determined the meaning of the capacity type code used | char(2) | 3.204 | Complete only |
| Capacity Type | A code giving the type of capacity referred to in the process capacity data field | char(1) | 29.34 | High or Complete only |
| Legal/Operating Status Code Owner | The agency responsible for determining the meaning of the legal/operating status code used | char(2) | 0 | Complete only |
| Legal / Operating Status | A code for the combined legal status and operating status of the process unit group | char(4) | 0 | High or Complete only |
| Unit of Measure Code Owner | The agency responsible for determining the meaning of the unit of measure code used | char(2) | 0 | Complete only |
| Process Type Code Owner | The agency that determined the meaning of the process type code used | char(2) | 0 | Complete only |
| Process Type Code | A code for the type of process. It is meaningless without also consulting the unit of measure code. | char(3) | 0 | Complete only |
| Process Type | A code for the type of process (combined with the unit of measure code for a single code lookup) | char(4) | 0 | High or Complete only |
This section has one record for each information submission by the handler, including both current and older information. There also may be submissions for activities in each U.S. state, if the handler is a transporter or has cross-state enforcement.
This section can have more than one entry per record. The record with the most entries currently holds 72. Only the first 2 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Activity Location | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | Medium, High or Complete |
| Source Type | A code indicating the source of data for this information record | char(1) | 0 | Medium, High or Complete |
| Sequence Number | A sequence number used to uniquely identify each information source record | integer | 0 | Complete only |
| Receive Date | Date that the form of information was received from the handler by the appropraite authority | date | 0 | Medium, High or Complete |
| Site Name | the legal name of the site | varchar(40) | 0.0001753 | Medium, High or Complete |
| Non-Notifier | A code indicating whether the handler is a non-notifier (i.e., the handler was identified without a Notification form and is suspected of carrying out RCRA regulated activities without proper authority | char(1) | 98.4 | Medium, High or Complete |
| Number of Employees | The number of people actively on the payroll at the site on a permanent or semi-permanent basis | decimal(9) | 99.95 | Medium, High or Complete |
| Include in Biennial Report (Yes/No) | Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Report | char(1) | 86.11 | Medium, High or Complete |
| CDX Transaction ID | The number assigned to the site ID form submitted via the CDX system | varchar(20) | 100 | Complete only |
| Location Street Number | Street number from the physical address of the primary site entrance | varchar(12) | 63.61 | Medium, High or Complete |
| Location Street 1 | First line of the street address from the physical address of the primary site entrance | varchar(30) | 0.002718 | Medium, High or Complete |
| Location Street 2 | Second line of the street address from the physical address of the primary site entrance | varchar(30) | 96.87 | Medium, High or Complete |
| Location City | Name of the city or town in which the handler is physically located | varchar(25) | 0.0006137 | Medium, High or Complete |
| Location State | The state postal abbreviation for the U.S. State in which the handler is physically located | char(2) | 0.000263 | Medium, High or Complete |
| Location Zip Code | The ZIP code from the physical address of the primary site entrance | varchar(14) | 0.0889 | Medium, High or Complete |
| Land Type | A code indicating the current ownership status of the land on which the facility is located | char(1) | 38.06 | Medium, High or Complete |
| State District | Indicates the state-designated legislative district(s) in which the site is located | varchar(10) | 46.43 | Medium, High or Complete |
| Mailing Street Number | The street number from the primary business mailing address for the handler | varchar(12) | 70.07 | Medium, High or Complete |
| Mailing Street 1 | The first line of the street address for the primary mailing address for the handler | varchar(30) | 2.346 | Medium, High or Complete |
| Mailing Street 2 | The second line of the street address for the primary mailing address for the handler | varchar(30) | 96.58 | Medium, High or Complete |
| Mailing City | The city or town from the primary mailing address for the handler | varchar(25) | 2.348 | Medium, High or Complete |
| Mailing State | The psotal state abbreviation for the state in the primary mailing address for the handler | char(2) | 2.354 | Medium, High or Complete |
| Mailing Zip Code | The Zip code in the primary mailing address for the handler | varchar(14) | 2.463 | Medium, High or Complete |
| Mailing Country | The country code in the primary mailing address for the handler | char(2) | 81.21 | Medium, High or Complete |
| Contact First Name | The first name of the primary contact person for the site | varchar(15) | 17.81 | Medium, High or Complete |
| Contact Middle Initial | The middle initial of the primary contact person for the site | char(1) | 97.14 | Medium, High or Complete |
| Contact Last Name | the last name of the primary contact person for the site | varchar(15) | 17.79 | Medium, High or Complete |
| Contact Street Number | The street number from the address of the primary contact person for the site | varchar(12) | 97 | Medium, High or Complete |
| Contact Street 1 | The first line of the street address for the primary contact person for the site | varchar(30) | 32.79 | Medium, High or Complete |
| Contact Street 2 | The second line of the street address for the primary contact person for the site | varchar(30) | 98.6 | Medium, High or Complete |
| Contact City | The city or town from the address of the primary contact person for the site | varchar(25) | 32.79 | Medium, High or Complete |
| Contact State | The state postal abbreviation from the address of the primary contact person for the site | char(2) | 32.77 | Medium, High or Complete |
| Contact Zip Code | The Zip code from the address of the primary contact person for the site | varchar(14) | 32.79 | Medium, High or Complete |
| Contact Country | The country code from the address of the primary contact person for the site | char(2) | 38.03 | Medium, High or Complete |
| Contact Phone | The telephone number of the primary contact person for the site | varchar(15) | 18.35 | Medium, High or Complete |
| Contact Phone Ext | The telephone number extension for the primary contact person for the site | varchar(6) | 96.27 | Medium, High or Complete |
| Contact Email | The Email address of the primary contact person for the site | varchar(50) | 98.33 | Medium, High or Complete |
| Permit Contact First Name | First name of a contact person familiar with the handler's hazardous waste permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Middle Initial | Middle initial of a contact person familiar with the handler's permit | char(1) | 100 | Medium, High or Complete |
| Permit Contact Last Name | Last name of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Street Number | The street number from the address of the permit contact person for the site | varchar(12) | 100 | Medium, High or Complete |
| Permit Contact Street 1 | First line of the street address of a contact person familiar with the handler's permit | varchar(30) | 99.99 | Medium, High or Complete |
| Permit Contact Street 2 | Second line of the street address of a contact person familiar with the handler's permit | varchar(30) | 100 | Medium, High or Complete |
| Permit Contact City | City or town in the address of a contact person familiar with the handler's permit | varchar(25) | 99.99 | Medium, High or Complete |
| Permit Contact State | State postal abbreviation in the address of a contact person familiar with the handler's permit | char(2) | 99.99 | Medium, High or Complete |
| Permit Contact Zip Code | Zip code in the address of a contact person familiar with the handler's permit | varchar(14) | 99.99 | Medium, High or Complete |
| Permit Contact Country | Country code in the address of a contact person familiar with the handler's permit | char(2) | 96.15 | Medium, High or Complete |
| Permit Contact Phone | Phone number of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Phone Ext | Phone number extension of a contact person familiar with the handler's permit | varchar(6) | 100 | Medium, High or Complete |
| Permit Contact Email | Email address of a contact person familiar with the handler's permit | varchar(50) | 100 | Medium, High or Complete |
| Acknowledge Date | Date on which information was received from the handler | date | 75.74 | Complete only |
| Acknowledge Flag | A flag used to mark the handler for having an acknowledgement of receipt sent | char(1) | 96.12 | Complete only |
| Geometric Type Code | Code that represents the type of geometric entity described by a lat-long point or set of points | char(3) | 100 | Complete only |
| Horizontal Accuracy Measure | The horizontal accuracy (in meters) of the lat/long coordinates | varchar(6) | 99.16 | Complete only |
| Horizontal Collection Method | A code for the method used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Horizontal Reference Datum | A code for the reference datum used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Latitude | The latitude of the site in decimal degrees | decimal(10,6) | 96.56 | Medium, High or Complete |
| Longitude | The longitude of the site in decimal degrees | decimal(11,6) | 96.56 | Medium, High or Complete |
| Reference Point | The code for the type of place for which lat/long coordinates were established | char(3) | 100 | Complete only |
| Source Map Scale | The scale of detail on the source map used to determine lat/long coordinates for the site | decimal(10) | 99.22 | Complete only |
| Importer Activity (Yes/No) | Indicates whether the facility imports hazardous waste into the U.S. from a foreign country | char(1) | 5.955 | Medium, High or Complete |
| Radioactive Waste (Yes/No) | Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product material | char(1) | 5.955 | Medium, High or Complete |
| Recycler Activity (Yes/No) | Indicates whether the handler recycles hazardous waste | char(1) | 0 | Medium, High or Complete |
| Transporter Activity (Yes/No) | Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or water | char(1) | 0 | Medium, High or Complete |
| TSD Activity (Yes/No) | Indicates whether the handler treats, stores, or disposes of hazardous waste | char(1) | 2.576 | Medium, High or Complete |
| Underground Injection (Yes/No) | Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface well | char(1) | 9.933 | Medium, High or Complete |
| Universal Waste Destination (Yes/No) | Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste. | char(1) | 67.29 | Medium, High or Complete |
| Transfer Facility (Yes/No) | Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc. | char(1) | 3.346 | Medium, High or Complete |
| Burner Exemption (Yes/No) | Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemption | char(1) | 3.378 | Medium, High or Complete |
| Furnace Exemption (Yes/No) | Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemption | char(1) | 3.378 | Medium, High or Complete |
| Used Oil Fuel Burner (Yes/No) | Indicates whether the site burns off-specification used oil for energy recovery | char(1) | 0 | Medium, High or Complete |
| Used Oil Processor (Yes/No) | Indicates whether the site processes used oil | char(1) | 2.576 | Medium, High or Complete |
| Used Oil Refiner (Yes/No) | Indicates whether the site refines used oil | char(1) | 0 | Medium, High or Complete |
| Used Oil Marketer (Yes/No) | Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burners | char(1) | 0 | Medium, High or Complete |
| Used Oil Specification Cert. (Yes/No) | Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specification | char(1) | 0 | Medium, High or Complete |
| Used Oil Transfer Facility (Yes/No) | Indicates whether the site acts as a transfer facility for used oil (holds used oil for shipment for more than 1 and less than 35 days) | char(1) | 2.576 | Medium, High or Complete |
| Used Oil Transporter (Yes/No) | Indicates whether the site transports or collects and transports used oil | char(1) | 2.576 | Medium, High or Complete |
| Second ID | A number that may be assigned by a state to identify a handler | varchar(12) | 90.01 | Medium, High or Complete |
| TSD Date | The date on which operation of a TSD facility commenced, construction commenced, or on which operation is expected to begin | date | 84.08 | Medium, High or Complete |
| Off-site Waste Receipt | A code that indicates whether the handler accepts hazardous waste from another site | char(1) | 26.51 | Medium, High or Complete |
| Handler Not Accessible | Code the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator) | char(1) | 99.94 | Medium, High or Complete |
| Biennial Report Year | The year of the biennial reporting data from which this information record is taken | integer | 86.11 | Medium, High or Complete |
| County Code Owner | The agency that determined the meaning of the county code used | char(2) | 1.201 | Complete only |
| County Code | Code for the county in which the handler is located (state postal abbreviation plus county FIPS code) | char(5) | 1.189 | Medium, High or Complete |
| Federal Waste Gen. Code Owner | The agency that determined the meaning of the Federal Waste Generator Code used | char(2) | 4.379 | Complete only |
| Federal Waste Generator Code | A code for the type of Federally classified waste generation at the site. It is meaningless without also consulting the determining agency code owner field. | char(1) | 4.463 | Complete only |
| Federal Waste Generation | A code for the type of Federally classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 1.941 | Medium, High or Complete |
| State Waste Gen. Code Owner | The agency that determined the meaning of the State Waste Generator code used | char(2) | 55.38 | Complete only |
| State Waste Generator Code | A code for the type of State classified waste generation at the site. It is meaningless without also consulting the determining agency code owner field. | char(1) | 57.94 | Complete only |
| State Waste Generation | A code for the type of State classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 55.36 | Medium, High or Complete |
| Number of Waste Codes | The number of Federal and State hazardous waste codes associated with this handler information record | integer | 52.91 | Complete only |
This section lists the NAICS (industry) codes given on an information submission for a handler.
This section can have more than one entry per record. The record with the most entries currently holds 300. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| NAICS Sequence Number | Sequence number for uniquely identifying NAICS codes for a handler | integer | 0 | Complete only |
| NAICS Code Owner | The agency that determined the meaning of the NAICS code used | char(2) | 8.708 | Complete only |
| NAICS Code | The NAICS code for a type of industry | char(6) | 0 | Medium, High or Complete |
This section gives information on other (non-RCRA) environmental permits issued to the handler.
This section can have more than one entry per record. The record with the most entries currently holds 362. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Other Permit Type Code Owner | The agency that determined the meaning of the Other Permit Type code used | char(2) | 0 | Complete only |
| Other Permit Type | A code for the type of other (non-RCRA) permit issued to the handler | char(1) | 0 | High or Complete only |
| Other Permit Number | ID number of a permit issued to the handler, or the number of an application for which a permit has not yet been issued | varchar(13) | 0.002877 | High or Complete only |
| Other Permit Description | Description of any permit type indicated as Other in the Permit Type data field | varchar(20) | 93.63 | High or Complete only |
This section gives information on the owners and / or operators of a handler.
This section can have more than one entry per record. The record with the most entries currently holds 22. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Owner Operator equence Number | Sequence number to uniquely identify each owner or operator for a handler | integer | 0 | Complete only |
| Owner Operator Ind. | A code for whether the record is for an owner or an operator, and whether they are current or previous | char(2) | 0.03942 | Medium, High or Complete |
| Owner Operator Name | The name of the owner or operator of a facility | varchar(40) | 0.05731 | Medium, High or Complete |
| Owner Operator Type | A code for the type of owner or operator | char(1) | 2.56 | Medium, High or Complete |
| Date Became Current | Date indicating when the owner or operator became current | date | 54.24 | Medium, High or Complete |
| Date Ended Current | Date indicating when the owner or operator changed to a different owner or operator | date | 97.37 | Medium, High or Complete |
| Owner Operator Street Number | The street number from the address of the owner or operator | varchar(12) | 95.05 | Medium, High or Complete |
| Owner Operator Street 1 | The first line of the street address of the owner or operator | varchar(30) | 13.26 | Medium, High or Complete |
| Owner Operator Street 2 | The second line of the street address of the owner or operator | varchar(30) | 98.83 | Medium, High or Complete |
| Owner Operator City | The city or town from the address of the owner or operator | varchar(25) | 13.35 | Medium, High or Complete |
| Owner Operator State | The postal state abbreviation from the address of the owner or operator | char(2) | 13.31 | Medium, High or Complete |
| Owner Operator Country | The country code from the address of the owner or operator | char(2) | 75.22 | Medium, High or Complete |
| Owner Operator Zip | The Zip code from the address of the owner or operator | varchar(14) | 13.32 | Medium, High or Complete |
| Owner Operator Phone | The phone number of the owner or operator | varchar(15) | 17.3 | Medium, High or Complete |
| Owner Operator Duns | The Dun & Bradstreet number for the owner or operator | varchar(10) | 100 | Medium, High or Complete |
This section gives information on people who have certified that information submissions to regulatory agencies are accurate.
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 High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Certification Sequence Number | Sequence number assigned to uniquely identify each certification record | integer | 0 | Complete only |
| Certfication Signed Date | Date on which the handler information was certified by the reporting site | date | 7.952 | High or Complete only |
| Certification Title | Title of the person who certified the handler information | varchar(45) | 33.18 | High or Complete only |
| Certification First Name | First name of the person who certified the handler information | varchar(15) | 25.93 | High or Complete only |
| Certification Middle Initial | Middle initial of the name of the person who certified the handler information | char(1) | 87.88 | High or Complete only |
| Certification Last Name | Last name of the person who certified the handler information | varchar(15) | 8.621 | High or Complete only |
This section describes types of waste handling activities that the handler undertakes that are regulated by individual U.S. states.
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 displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| State Activity Code Owner | The agency that determined the meaning of the state activity type code used | char(2) | 0 | Complete only |
| State Activity Code | A code for the type of state waste activity. It is meaningless without also consulting the determing agency code owner field. | char(5) | 0 | Complete only |
| State Activity Type | A code for the type of state waste activity (combined with the determining agency code for a single code lookup) | char(7) | 0 | High or Complete only |
This section describes types of universal wastes that the handler handles, and whether they are accumulated or generated.
This section can have more than one entry per record. The record with the most entries currently holds 7. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Universal Waste Type Code Owner | The agency that determined the meaning of the universal waste type code used | char(2) | 0 | Complete only |
| Universal Waste Type | A code describing a type of universal waste (batteries, thermometers, etc.) | char(1) | 0 | Medium, High or Complete |
| Accumulation (Yes/No) | Indicates whether the handler is engaged in accumulating universal waste on site | char(1) | 0 | Medium, High or Complete |
| Generation (Yes/No) | Indicates whether the handler is engaged in generating universal waste on site | char(1) | 0 | Medium, High or Complete |
This section lists Federal and state waste codes that describe constituents or characteristics of the handler's hazardous waste. This information is generally taken from the Biennial Reports for the handler.
This section can have more than one entry per record. The record with the most entries currently holds 602. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in High or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Waste Type Code Owner | The agency that determined the meaning of the waste code used | char(2) | 0 | Complete only |
| Waste Type Code | Code for a type of waste constituent -- generally taken from Biennial Reports. It is meaningless without also consulting the determining agency code owner field. | char(6) | 0 | Complete only |
| Waste Type | Code for a type of waste constituent -- generally taken from Biennial Reports (combined with determining agency code for a single code lookup) | char(8) | 0 | High or Complete only |
This section lists which areas of a facility are affected by a corrective action.
This section can have more than one entry per record. The record with the most entries currently holds 358. Only the first 3 of these are displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Area Sequence Number | Code used to uniquely designate a corrective action area | char(4) | 0 | Complete only |
| Corrective Action Area | Name or number assigned to identify a corrective action area | varchar(40) | 0 | Medium, High or Complete |
| Facility-wide Corrective Action (Yes/No) | Indicates whether the corrective action applies to the entire facility | char(1) | 0 | Medium, High or Complete |
| Regulated Unit (Yes/No) | Indicates whether the corrective action applies to a regulated unit at the handler | char(1) | 84.86 | Medium, High or Complete |
| Number of Area-Event Links | The number of area-event links for this corrective action area | integer | 22.43 | Medium, High or Complete |
This section specifies which corrective action areas are linked to which corrective action events. Only the data fields that specify which events are linked to an area are displayed; the data fields that identify the areas are not.
This section can have more than one entry per record. The record with the most entries currently holds 89. This section is not displayed if comma or tab-delimited format is chosen.
This section is displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Event Type Code Owner | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Event Type | A code for the type of corrective action event | char(7) | 0 | Medium, High or Complete |
| Event Sequence Number | ID number used to identify a corrective action event | char(3) | 0 | Medium, High or Complete |
| Event Responsible Agency | The agency responsible for overseeing a corrective action event | char(1) | 0 | Medium, High or Complete |
| Event Activity Location | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
This section lists specific events for a corrective action.
This section can have more than one entry per record. The record with the most entries currently holds 254. Only the first 5 of these are displayed if comma or tab-delimited format is chosen.
This section is only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Event Sequence Number | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
This section specifies which corrective action events are linked to which corrective action authorities. Only the data fields that specify which authorities are linked to an event are displayed; the data fields that identify the events are not.
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 only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Authority Type Code Owner | The agency that determined the meaning of the authority type code used | char(2) | 0 | Complete only |
| Authority Type | A code for the type of authority | char(1) | 0 | Complete only |
| Effective Date | Date on which a permit modification, unilateral order, consent decree, or appeal becomes effective | date | 0 | Complete only |
| Authority Responsible Agency | Code for the agency that originated and oversees a permit, permit modification, or order | char(1) | 0 | Complete only |
| Authority Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
This section lists the legal authorities under which a corrective action is undertaken.
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 displayed in Medium, High, or Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Effective Date | Date on which a permit modification, unilateral order, consent decree, or appeal becomes effective | date | 0 | Medium, High or Complete |
| Authority Responsible Agency | Code for the agency that originated and oversees a permit, permit modification, or order | char(1) | 0 | Medium, High or Complete |
| Issuance Date | The date on which an agency official signs the order, permit, or permit modification | date | 34.99 | Medium, High or Complete |
| Revokation Date | The date on which the corrective action authority is revoked | date | 89.63 | Medium, High or Complete |
| Repository Status | Code giving the status of an information repository near the facility for the purpose of making documents available | char(1) | 89.43 | Medium, High or Complete |
| Authority Activity Location | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Medium, High or Complete |
| Authority Type Code Owner | The agency that determined the meaning of the authority type code used | char(2) | 0 | Complete only |
| Authority Type | A code for the type of authority | char(1) | 0 | Medium, High or Complete |
| Number of Event-Authority Links | The number of event-authority links for this authority | integer | 10.52 | Medium, High or Complete |