RTK NET Home Page

About the Data

Resources

Help

About RTK NET

General RCRIS Help

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 December 13, 2016.

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

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).

Summary Reports

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 FieldDescriptionField Type
Handler NameThe name of the handler (facility) that this information was submitted forvarchar(40)
StateState postal abbreviation for state in which the handler is locatedchar(2)
Gen.Federal waste generation status of the handler. Use the "About the Data" button for meanings of the abbreviations used.varchar(25)
TSDIndicates whether the handler is an active TSD (treatment, storage, or disposal site)char(1)
Viol. (Yes/No)Whether there are violations listed for the handler since 1999integer

Low, Medium, High and Complete Detail Reports

Handler-based reports

Section: Basic Handler Info

This section gives basic information on the handler, such as its name and RCRA ID number.

Data FieldDescriptionField Type% blankLevel of Detail
Handler IDUnique 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.00All
EPA Facility IDEPA FINDS ID that is supposed to uniquely identify a facility across different EPA data systemsvarchar(12)93.88All
Handler NameThe 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(80)0.00All
EPA RegionThe two-digit code for the EPA Region in which the handler is locatedchar(2)0.00Complete only
StateThe state postal code for the state in which the handler is locatedchar(2)0.00All
First Info. Receipt DateThe first date on which information was received for this handlerdate0.15All
Last Info. Receipt DateThe last date on which information was received for this handlerdate0.15All
Maximum PenaltyThe maximum final penalty amount for a single penalty listed in this facility's penalty records.decimal(14,2)98.87All

Section: Handler-based Record Counts

This section 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 displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
Number of CA Area RecordsThe number of corrective action area records for this handlerint(11)99.03High through Complete
Number of CA EventsThe number of corrective action event records for this handlerint(11)99.03High through Complete
Number of CA AuthoritiesThe number of corrective action authority records for this handlerint(11)99.17High through Complete
Number of Information RecordsThe number of handler information (aka hhandler2) records for this handlerint(11)0.15High through Complete
Number of Current Information RecordsThe number of current information (aka report universe) records for this handlerint(11)0.44High through Complete
Number of Permit SeriesThe number of permit series records for this handlerint(11)98.81High through Complete
Number of Process UnitsThe number of process unit records for this handlerint(11)98.82High through Complete
Number of Violation / Enforcement RecordsThe number of violation / enforcement records for this handlerint(11)70.30High through Complete
Number of Other IDsThe number of other ID records for this handlerint(11)84.95High through Complete
Number of HSM Basic RecordsThe number of HSM basic records for this handler.int(11)99.98High through Complete
Number of GIS RecordsThe number of GIS data records for this handler.int(11)78.28High through Complete
Number of Citation RecordsThe number of citation records for this handlerint(11)94.07High through Complete

Section: Handler Locations and Activities

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 15. Only the first of these is displayed if comma or tab-delimited format is chosen.

Data FieldDescriptionField Type% blankLevel of Detail
Activity LocationThe location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00All
NAICS Code 1First NAICS industry code for the sitechar(6)51.80All
NAICS Code 2Second NAICS industry code for the sitevarchar(6)95.08High through Complete
NAICS Code 3Third NAICS industry code for the sitevarchar(6)98.43High through Complete
NAICS Code 4Fourth NAICS industry code for the sitevarchar(6)99.26High through Complete
Owner NameName of the current owner of the sitevarchar(40)20.76All
Operator NameName of the current operator of the sitevarchar(40)43.95High through Complete
Land TypeA code indicating the current ownership status of the land on which the facility is locatedchar(1)20.68All
Location Street NumberStreet number from the physical address of the primary site entrancevarchar(12)56.23All
Location Street 1First line of the street address from the physical address of the primary site entrancevarchar(30)0.00All
Location Street 2Second line of the street address from the physical address of the primary site entrancevarchar(30)95.59All
Location CityName of the city or town in which the handler is physically locatedvarchar(25)0.00All
Location StateThe state postal abbreviation for the U.S. State in which the handler is physically locatedchar(2)0.00All
Location Zip CodeThe ZIP code from the physical address of the primary site entrancevarchar(14)0.01All
County CodeCode for the county that the site is in (state postal abbreviation plus county FIPS code)char(5)0.01Complete only
Location CountyThe county in which the site is locatedvarchar(27)0.01Extended and Complete
Location CountryThe out-of-country location for transporters coming into the U.S.char(2)54.76All
State District Code OwnerThe agency that defined the state district code.char(2)46.94Complete only
State District CodeIndicates the state-designated legislative district(s) in which the site is locatedchar(10)46.94Complete only
State DistrictA combination of two codes intended to define a state-designated legislative district within which the site is located.varchar(12)46.94All
Mailing Street NumberThe street number from the primary business mailing address for the handlervarchar(12)62.65Extended and Complete
Mailing Street 1The first line of the street address for the primary mailing address for the handlervarchar(30)2.71Extended and Complete
Mailing Street 2The second line of the street address for the primary mailing address for the handlervarchar(30)94.91Extended and Complete
Mailing CityThe city or town from the primary mailing address for the handlervarchar(25)2.57Extended and Complete
Mailing StateThe psotal state abbreviation for the state in the primary mailing address for the handlerchar(2)2.49Extended and Complete
Mailing Zip CodeThe Zip code in the primary mailing address for the handlervarchar(14)2.62Extended and Complete
Mailing CountryThe country code in the primary mailing address for the handlerchar(2)25.62Extended and Complete
Contact NameThe name of the contact person for the handlervarchar(33)12.59High through Complete
Contact Street NumberThe street number from the address of the primary contact person for the sitevarchar(12)76.40All
Contact Street 1The first line of the street address of the contact person for the handlervarchar(30)17.58Extended and Complete
Contact Street 2The second line of the street address of the contact person for the handlervarchar(30)96.52Extended and Complete
Contact CityThe city or town from the address of the primary contact person for the sitevarchar(25)17.74Extended and Complete
Contact StateThe state postal abbreviation from the address of the primary contact person for the sitechar(2)17.70Extended and Complete
Contact Zip CodeThe Zip code from the address of the primary contact person for the sitevarchar(14)17.81Extended and Complete
Contact CountryThe country code from the address of the primary contact person for the sitechar(2)15.83Extended and Complete
Contact PhoneThe telephone number of the primary contact person for the sitevarchar(22)13.53Extended and Complete
Contact EmailThe Email address of the primary contact person for the sitevarchar(80)80.06All
Contact FaxThe fax number for the primary contact person for the sitevarchar(15)91.36All
Contact TitleThe title of the primary contact person for the sitevarchar(45)77.98All
Receive DateDate that the form of information was received from the handler by the appropraite authoritydate0.16High through Complete
Source TypeA code indicating the source of data for this information recordchar(1)0.00Extended and Complete
Sequence NumberA sequence number used to uniquely identify each information source recordint(6)0.16Complete only
Extract FlagAn X indicates that the data are available for extract for public usechar(1)0.00Complete only
EPA RegionThe two-digit code for the EPA Region in which the handler is locatedchar(2)0.00Complete only
Non-NotifierA 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 authoritychar(1)96.88High through Complete
Handler Not AccessibleCode the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator)char(1)99.96High through Complete
State Waste GenerationA 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)15.64All
Transporter Activity (Yes/No)Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or waterchar(1)0.18All
Operating TSDF UniverseIndicates whether handler has an operating Treatment, Storage, or Disposal unit. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment.varchar(6)0.00All
Full Enforcement UniverseIndicates whether handler is a TSDF that could potentially undergo a Compliance and Evaluation Inspection (CEI). Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment.varchar(6)0.00High through Complete
Radioactive Waste (Yes/No)Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product materialchar(1)0.18All
Recycler Activity (Yes/No)Indicates whether the handler recycles hazardous wastechar(1)0.18High through Complete
Underground Injection (Yes/No)Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface wellchar(1)0.18Extended and Complete
Importer Activity (Yes/No)Indicates whether the facility imports hazardous waste into the U.S. from a foreign countrychar(1)0.18Extended and Complete
Universal Waste Destination FacilityIndicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste.char(1)0.05Extended and Complete
Used Oil UniverseConcatenation of seven Yes/No data fields indicating used oil activityvarchar(7)0.02Extended and Complete
Permit Workload UniverseIndicates whether handler is a facility with units that are in the permit pipeline or that has units with active permits. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Extended and Complete
Post-Closure Workload UniverseIndicates 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(6)0.00Extended and Complete
Corrective Action Workload UniverseIndicates whether the handler has a unit undergoing corrective action acitvities.char(1)0.00Extended and Complete
GPRA Operating Permit UniverseIndicates 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, 1997char(1)0.02Complete only
Permit Progress UniverseIndicates whether the handler is a facility with units in the Permit, Closure, or Post-Closure Workload Universes. Separate characters indicates (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Complete only
Closure Workload UniverseIndicates whether the handler is a facility with units that are closing. Does not include units that are clean closed or post-closure. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Extended and Complete
Subject to CA UniverseIndicates whether the handler is potentially subject to corrective actionchar(1)0.00Complete only
TSDF Subject to CA UniverseIndicates whether the handler is a TSD facility that is potentially subject to corrective action under statutory section 3004(u)/(v)char(1)0.16Complete only
TSDF Subject CA DiscretionaryIndicates whether the handler is a TSD facility that is only subject to corrective action under discretionary authoritieschar(1)0.16Complete only
Non TSDF Under CAIndicates whether the handler is a non TSD facility where corrective action has been imposedchar(1)0.16Complete only
In Handler UniverseIndicates whether the site belongs to at least one of the handler universeschar(1)0.00Complete only
Generator Status UniverseContains a 3-letter translation of the Federal Waste Generation Status code (LQG, SQG, CEG, N, or blank)char(3)0.02Complete only
Burner Exemption (Yes/No)Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemptionchar(1)0.18Extended and Complete
Furnace Exemption (Yes/No)Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemptionchar(1)0.18Extended and Complete
Biennial Report YearThe year of the biennial reporting data from which this information record is takenvarchar(4)95.28Complete only
Date of Last ChangeDate of the last change in the handler information recordsdate0.17Complete only
Owner TypeA code describing the type of current ownerchar(1)20.11Complete only
Operator TypeA code describing the type of current operatorchar(1)41.05Complete only
Owner Sequence NumberThe sequence number of the current owner within the owner and operator data tableint(6)19.47Complete only
Operator Sequence NumberThe sequence number of the current operator within the owner and operator data tableint(6)40.49Complete only
In A UniverseIndicates that the site is in one of the universeschar(1)0.00Complete only
Federal Waste Gen. Code OwnerThe agency that determined the meaning of the Federal Waste Generator Code usedchar(2)1.23Complete only
Federal Waste Generator CodeA 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)1.24Complete only
Federal Waste GeneratorIndicates the kind of Federally regulated waste generation at the facility. This field has been regularized to 1,2,3, or N by RTK NET.char(1)0.00All
State Waste Gen. Code OwnerThe agency that determined the meaning of the State Waste Generator code usedchar(2)15.78Complete only
State Waste Generator CodeA 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)15.90Complete only
Short Term Generator ActivityIndicates whether the handler's generator status is determined from a short-term or one-time event and not from ongoing processes.char(1)0.05All
GPRA Renewals BaselineIndicates whether the facility is on the GPRA 2011 Permit Baseline.char(1)0.02All
Universal WasteIndicates whether the facility generates, receives, or accumulates universal waste, or sends universal waste to another facility. This excludes TDRs or transports of universal waste.char(1)0.16All
Institutional Control IndicatorIndicates whether institutional controls are in place.char(1)0.00All
Human Exposure Control IndicatorIndicates whether human exposure controls are in place.char(1)0.20All
Groundwater Control IndicatorIndicates whether groundwater controls are in place.char(1)0.20All
Unaddressed SNCIndicates whether the facility is an EPA unaddressed significant non-complier.char(1)0.00All
Addressed SNCIndicates whether the facility is an EPA addressed significant non-complier.char(1)0.00All
SNC Compliance ScheduleIndicates whether the facility is a significant non-complier with a compliance schedule.char(1)0.00All
Universal Waste DestinationIndicates whether the facility treats, disposes of, or recycles universal wastes on site.char(1)0.18All
Federal IndicatorIndicates whether the facility is owned or operated by a Federal entity. Multiple values can be L = land is Federally-owned, O = facility is Federally-owned, P = facility is Federally-operated.char(3)0.18All
HSM IndicatorIndicates whether the facility is currently, has stopped, or has never managed hazardous secondary material.char(1)0.16All
Subpart K IndicatorIndicates whether the facility manages laboratory wastes under Subpart K. C=college, H=hospital, N=nonprofit research institute, W=withdrawal.char(4)0.03All
Commercial TSD IndicatorIndicates whether the facility has any commercial TSD units.char(1)0.16All
TSD TypeIndicates the types of TSD activities at the facility. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(5)0.00All
Permit Renewal Workload UniverseIndicates whether handler is a facility with currently permitted units whose renewal applications have been received but have not been renewed. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00All
GPRA Corrective Action BaselineIndicates whether the facility is on the GPRA 2020 Corrective Action Baseline.char(1)0.02All
NCAPS Corrective Action Priority RankingIndicates the facilty's corrective action priority ranking -- (H)igh, (M)edium, (L)ow, or (N)o ranking.char(1)0.16All
Environmental Control IndicatorIndicates whether environmental controls are in place.char(1)0.00All
Financial Assurance RequiredIndicates whether financial assurance is required for the facility. Multiple values are: A=corrective action, C=closure, N=non-sudden third-party liability, P=post-closure care, S=sudden third-party liability.varchar(5)0.00All
Active Site IndicatorIndicates that the facility may be an active site. Separate characters for (H)andler, (P)ermitting, (A)=Corrective Action, (C)onverter, and (S)tate-specific activities.varchar(5)0.00All
Active Site Federally Regulated TSDFIndicates TSDfs subject to federal RCRA TSDF regulations, permits, and orders.varchar(6)0.00All
Active Site Converter TSDFIndicates former TSD units that have not yet clean closed as TSD units and for which the agency has accepted notification that the units no longer conduct activities that require a TSD permit.varchar(6)0.00All
Active Site State Regulated TSDFIndicates TSDFs regulated under state standards that are not considered part of the state authorized hazardous waste program, and threfore are not subject to federal RCRA permit requirements.varchar(9)0.00All
Federal Universal WasteIndicates whether the facility accumulates federally regulated universal waste on-site.char(1)0.16All
SNC UniverseHandler is in SNC (Significant Non-Compliance).char(1)0.00All

Section: Regulatory Universes

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 FieldDescriptionField Type% blankLevel of Detail
Post-Closure Workload Land DisposalIndicates whether the handler has a land disposal unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload IncineratorIndicates whether the handler has an incinerator unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload StorageIndicates whether the handler has a hazardous waste storage unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the post-closure universechar(1)0.00Complete only
Permit Progress Land DisposalIndicates whether the handler has a land disposal unit in the permit progress universechar(1)0.00Complete only
Permit Progress IncineratorIndicates whether the handler has an incinerator unit in the permit progress universechar(1)0.00Complete only
Permit Progress BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit progress universechar(1)0.00Complete only
Permit Progress StorageIndicates whether the handler has a hazardous waste storage unit in the permit progress universechar(1)0.00Complete only
Permit Progress TreatmentIndicates whether the handler has a hazardous waste treatment unit in the permit progress universechar(1)0.00Complete only
Permit Progress Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit progress universechar(1)0.00Complete only
Closure Workload Land DisposalIndicates whether the handler has a land disposal unit in the closure universechar(1)0.00Complete only
Closure Workload IncineratorIndicates whether the handler has an incinerator unit in the closure universechar(1)0.00Complete only
Closure Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the closure universechar(1)0.00Complete only
Closure Workload StorageIndicates whether the handler has a hazardous waste storage unit in the closure universechar(1)0.00Complete only
Closure Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the closure universechar(1)0.00Complete only
Closure Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the closure universechar(1)0.00Complete only
Permit Workload Land DisposalIndicates whether the handler has a land disposal unit in the permit workload universechar(1)0.00Complete only
Permit Workload IncineratorIndicates whether the handler has an incinerator unit in the permit workload universechar(1)0.00Complete only
Permit Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit workload universechar(1)0.00Complete only
Permit Workload StorageIndicates whether the handler has a hazardous waste storage unit in the permit workload universechar(1)0.00Complete only
Permit Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the permit workload universechar(1)0.00Complete only
Permit Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit workload universechar(1)0.00Complete only
Permit Renewal Workload Land DisposalFlag indicating whether the facility is in the Permit Renewal Workload universe as a Land Disposal facility.char(1)0.00Complete only
Permit Renewal Workload IncineratorFlag indicating whether the facility is in the Permit Renewal Workload universe as an Incinerator.char(1)0.00Complete only
Permit Renewal Workload BIFFlag indicating whether the facility is in the Permit Renewal Workload universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Permit Renewal Workload StorageFlag indicating whether the facility is in the Permit Renewal Workload universe as a Storage facility.char(1)0.00Complete only
Permit Renewal Workload TreatmentFlag indicating whether the facility is in the Permit Renewal Workload universe as a Treatment facility.char(1)0.00Complete only
Permit Renewal Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit renewal universechar(1)0.00Complete only
Full Enforcement Land DisposalIndicates whether the handler has a land disposal unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement IncineratorIndicates whether the handler has an incinerator unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement StorageIndicates whether the handler has a hazardous waste storage unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement TreatmentIndicates whether the handler has a hazardous waste treatment unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the full enforcement universechar(1)0.00Complete only
Operating TSDF Land DisposalIndicates whether the handler has a land disposal unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF IncineratorIndicates whether the handler has an incinerator unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF StorageIndicates whether the handler has a hazardous waste storage unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF TreatmentIndicates whether the handler has a hazardous waste treatment unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the operating TSD universechar(1)0.00Complete only
Used Oil Transporter (Yes/No)Indicates whether the site transports or collects and transports used oilchar(1)0.00Complete 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.00Complete only
Used Oil Processor (Yes/No)Indicates whether the site processes used oilchar(1)0.00Complete only
Used Oil Refiner (Yes/No)Indicates whether the site refines used oilchar(1)0.00Complete only
Used Oil Fuel Burner (Yes/No)Indicates whether the site burns off-specification used oil for energy recoverychar(1)0.00Complete only
Used Oil Marketer (Yes/No)Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burnerschar(1)0.00Complete only
Used Oil Specification Cert. (Yes/No)Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specificationchar(1)0.00Complete only
Active Site Handler ActivitiesFlag indicating whether the facility is in the Active Site universe because it is in a Handler universe.char(1)0.00Complete only
Active Site Federally Regulated TSDFFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe.char(1)0.00Complete only
Active Site Corrective Action WorkloadFlag indicating whether the facility is in the Active Site universe because it is in the Corrective Action Workload universe.char(1)0.00Complete only
Active Site ConverterFlag indicating whether the facility is in the Active Site Converter universe.char(1)0.00Complete only
Active Site State ActivitiesFlag indicating whether the facility is in the Active Site universe because it has a State Activity which indicates that the site is active.char(1)0.00Complete only
Active Site Federally Regulated LAnd DisposalFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Land Disposal facility.char(1)0.00Complete only
Active Site Federally Regulated IncineratorFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as an Incinerator.char(1)0.00Complete only
Active Site Federally Regulated BIFFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site Federally Regulated StorageFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Storage facility.char(1)0.00Complete only
Active Site Federally Regulated TreatmentFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Treatment facility.char(1)0.00Complete only
Active Site Federally Regulated Solid WasteIndicates whether the hand;er has a solid waste management unit in the active site Federally regulated universechar(1)0.00Complete only
Active Site State Regulated Land DisposalFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Land Disposal facility.char(1)0.00Complete only
Active Site State Regulated IncineratorFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as an Incinerator.char(1)0.00Complete only
Active Site State Regulated BIFFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site State Regulated StorageFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Storage facility.char(1)0.00Complete only
Active Site State Regulated TreatmentFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Treatment facility.char(1)0.00Complete only
Active Site State Regulated Solid WasteIndicates whether the handler has a solid waste management unit in the active site state regulated universechar(1)0.00Complete only
Active Site State Regulated Waste GeneratorFlag indicating whether the facility is in the Active Site State Regulated Waste Generator universe.char(1)0.00Complete only
Active Site State Regulated Universal WasteFlag indicating whether the facility is in the Active Site State Universal Waste universe.char(1)0.00Complete only
Active Site State Regulated TSDF ACtivityFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe.char(1)0.00Complete only
Active Site Converter Land DisposalFlag indicating whether the facility is in the Active Site Converter universe as a Land Disposal facility.char(1)0.00Complete only
Active Site Converter IncineratorFlag indicating whether the facility is in the Active Site Converter universe as an incinerator.char(1)0.00Complete only
Active Site Converter BIFFlag indicating whether the facility is in the Active Site Converter universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site Converter StorageFlag indicating whether the facility is in the Active Site Converter universe as a Storage facility.char(1)0.00Complete only
Active Site Converter TreatmentFlag indicating whether the facility is in the Active Site Converter universe as a Treatment facility.char(1)0.00Complete only
Active Site Converter Solid WasteIndicates whether the handler has a solid waste management unit in the active site converter universechar(1)0.00Complete only

Section: GIS Data

This section gives information on geographic data for a handler or a site owned by a handler.

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

Data FieldDescriptionField Type% blankLevel of Detail
GIS Data OwnerIndicates the location of the agency (EPA HQ, EPA region, or state) that owns the GIS data.char(2)0.00All
GIS Sequence NumberA sequence number used to uniquely identify GIS data records.char(4)0.00All
Area Sequence NumberCode used to uniquely designate a corrective action areachar(4)99.83Complete only
Source Map ScaleThe scale of detail on the source map used to determine lat/long coordinates for the sitebigint(20)69.84Complete only
Process Unit Sequence NumberSystem-generated number used to uniquely identify a process unitchar(4)99.99All
Area AcreageThe number of acres associated with the handler or area.decimal(12,2)96.47All
Area Source Code OwnerIndicates the agency that defined the Area Source Code.char(2)96.47Complete only
Area Source CodeCode for the source of the information used to determine the number of acres associated with the handler or area.char(4)96.47All
Area Source DateThe date on which information about the area of the handler or area was collected.date96.47All
Data Collection DateThe date on which the GIS information referred to in this record was collected.date0.00All
Horizontal Accuracy MeasureThe measure of the accuracy (in meters) of the lat/long coordinates.int(11)28.99All
Coordinate Data Code OwnerThe agency that defined the coordinate data code.char(2)66.19Complete only
Coordinate Data CodeCode that represents the party responsible for collecting or otherwise providing geographic coordinates.char(3)66.19All
Geo Reference Point Code OwnerThe agency that defined the geographic reference point code.char(2)57.33Complete only
Geographic Reference Point CodeCode that represents the place for which geographic coordinates were established.char(3)57.33All
Geometric Code OwnerThe agency that defined the geometric code.char(2)25.98Complete only
Geometric CodeCode that represents the geometric entity described by one point or a sequence of lat/long points.char(3)25.98All
Horizontal Collection Code OwnerThe agency that defined the horizontal collection code.char(2)27.17Complete only
Horizontal Collection CodeCode that represents the method used to determine the lat/long coordinates for the site location.char(3)27.17All
Horizontal Reference Code OwnerThe agency that defined the horizontal reference code.char(2)15.43Complete only
Horizontal Reference CodeCode that represents the reference datum used in determining the lat/long coordinates for the site location.char(3)15.43All
Verification Method Code OwnerThe agency that defined the verification method code.char(2)62.09Complete only
Verification Method CodeCode for the method used to verify the lat/long coordinates.char(3)62.09All
Number of Lat/Long RecordsThe number of lat/long records for this GIS record.int(11)0.69All

Section: GIS Lat/Long

This section holds lat/long coordinates associated with a handler or a site owned by a handler.

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

Data FieldDescriptionField Type% blankLevel of Detail
LatitudeThe latititude of the site in decimal degreesdecimal(11,6)0.00High through Complete
LongitudeThe longitude of the site in decimal degreesdecimal(12,6)0.09High through Complete
Lat/Long Sequence NumberA unique number used to identify lat/long coordinate records.char(4)0.00All

Section: Citations

This section lists citations for a handler. Some of this information may be repeated in the Violation / Enforcement Records section.

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

Data FieldDescriptionField Type% blankLevel of Detail
CitationCitation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation TypeCode indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type CodeCode indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined ViolationThe agency that actually determined the violationchar(1)0.00All
Citation Sequence NumberA number used to uniquely identify each citation record.char(6)0.00All
Citation OwnerThe agency that defined the citationchar(2)0.00All
Violation Type OwnerA code for the agency that defined the violation type code.char(2)0.00All
Violation Activity LocationThe location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence NumberUnique number used to identify each violationchar(4)0.00All

Section: Violation / Enforcement Records

This section lists combined evaluation, violation, and enforcement records for the handler. Because of the way the records have been "flattened" by EPA, penalties may be listed more than once, and the number of records is not meaningful.

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

Data FieldDescriptionField Type% blankLevel of Detail
Evaluation Activity LocationThe location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence NumberName or number assigned to identify an evaluationchar(3)0.00All
Evaluation DateThe first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible AgencyThe agency responsible for conducting the evaluationchar(1)0.00All
Found ViolationAn indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen ComplaintIndicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia IndicatorIndicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling IndicatorIndicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C IndicatorFor an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type CodeCode for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution TypeThe type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area CodeCode to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus AreaThe subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person IDCode indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation SuborganizationCode indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence NumberA system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request DateThe date that a 3007 information request was submitted.date99.86All
Response Received DateThe date that 3007 information is received.date99.93All
Request AgencyCode indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity LocationIndicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity LocationThe location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence NumberUnique number used to identify each violationchar(4)27.93All
Agency Which Determined ViolationThe agency that actually determined the violationchar(1)27.93All
Violation Type CodeCode indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation TypeThe specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
CitationCitation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation DeterminedThe date on which a determination was made that the violation existsdate27.93All
Compliance DateThe date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance QualifierIndicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible AgencyThe agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance DateDate by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity LocationThe location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence NumberName or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action DateThe date on which the enforcement action was issueddate33.95All
Enforcement Responsible AgencyThe agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket NumberThe relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement AttorneyIdentifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action ComponentIndicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated DateThe date that the appeal was initiated.date99.94All
Appeal Resolution DateThe date the appeal was resolved.date99.96All
Disposition Status DateDate that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status CodeCode that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition StatusIndicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence NumberA system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent NameName of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead AgencyThe lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type CodeA code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement ActionIdentifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person IDCode indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement SuborganizationCode indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence NumberA system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure AmountThe actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion DateDate set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual DateThe actual date of a SEP expenditure.date99.13All
SEP Defaulted DateThe date a site defaulted on a SEP.date100.00All
SEP Type CodeA code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP TypeIndicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty AmountThe amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty AmountThe amount of final penalties for a violation.decimal(14,2)91.98All
Paid AmountThe amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final CountCount of the number of penalties for an enforcement action.int(4)91.93Complete only
Final AmountThe amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record NumberRTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only

Section: Other IDs

This section lists other IDs for the handler.

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

Data FieldDescriptionField Type% blankLevel of Detail
Other IDAdditional ID for this handler.char(12)0.00All
Same FacilityIndicates whether the other ID refers to the same facility as the handler ID.char(1)0.00All
Relationship Code OwnerThe agency that detemined the meaning of the relationship code.char(2)0.00Complete only
Relationship CodeCode for the type of relationship between this additional ID and the handler.char(1)0.01Complete only
RelationshipThe type of relationship between this additional ID and the handler.varchar(3)0.00All

Section: Permit Series

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 255. 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
Permit Series Sequence NumberSystem-generated number used to uniquely identify a permit series for a handlerchar(4)0.00Complete only
Permit Series NameName or number assigned by an agency to identify a permit or permit applicationvarchar(40)0.00Extended and Complete
Number of Permit EventsThe number of permit events associated with this permit series recordint(11)0.67Extended and Complete

Section: Permit Events

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 1,011. 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
Event Sequence NumberSystem-generated number for uniquely identifying permit eventschar(3)0.00Complete only
Activity LocationThe location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00Complete only
Permit Event Code OwnerThe agency responsible for determining the meaning of the permit event code usedchar(2)0.00Complete only
Permit Event CodeCode for the type of permit event. It is meaningless without also consulting the determing agency code owner field.char(7)0.00Complete only
Actual Date of EventDate on which actual completion of a permitting or closure event occursdate2.79Extended and Complete
Event Responsible AgencyCode indicating the agency responsible for conducting a permitting or closure program eventchar(1)0.00Extended and Complete
Permit EventA code for the type of permit event (combined with the determining agency code for a single code lookup)varchar(9)0.00Extended and Complete
Number of Permit Event-Unit LinksThe number of permit event-process unit links for this permit eventint(11)5.54Complete only
Original Scheduled Event DateThe original scheduled completion date for an event. This date cannot be changed once entered.date90.26Extended and Complete
New Scheduled Event DateRevised date on which completion of a permitting/closure event is scheduled or projected to occur, used for tracking changes to Original Scheduled Event Date.date93.56Extended and Complete
Best Event DateThe best date for determining the occurrence of the actual completion of the permitting/closure event.date0.00Extended and Complete
State Suborganization ID OwnerThe agency that determined the meaning of the suborganization ID.char(2)81.79Extended and Complete
State SuborganizationName or abbreviation of a state division/section (suborganization).varchar(10)81.79Extended and Complete
Event Responsible Person ID OwnerThe agency that determined the meaning of the Event Responsible Person ID.char(2)28.49Extended and Complete
Event Responsible Person IDThe ID of the person currently responsible for the event.varchar(5)28.49Extended and Complete
Event Responsible Person ID OwnerThe agency that determined the meaning of the Event Responsible Person ID.char(2)34.17Extended and Complete

Section: Permit Event - Process Unit Links

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 203. 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
Activity LocationThe location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00Complete only
Process Unit Sequence NumberSystem-generated number used to uniquely identify a process unitchar(4)0.00Complete only
Unit Detail Sequence NumberSystem-generated number to uniquely identify each process unit detail recordchar(3)0.00Complete only
Unit Handler IDShould be a copy of the handler ID.char(12)0.00Complete only

Section: Process Units

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 614. 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
Process Unit Sequence NumberSystem-generated number used to uniquely identify a process unitchar(4)0.00Complete only
Process Unit NameName or number assigned by an agency to identify a process unit groupvarchar(40)0.00High through Complete
Number of Process Unit DetailsThe number of process unti detail records associated with this process unit recordint(11)0.15High through Complete
Number of Event-Unit LinksThe number of permit event-process unit links for this process unitint(11)1.43High through Complete

Section: Process Unit Details

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 58. 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
Unit Detail Sequence NumberSystem-generated number to uniquely identify each process unit detail recordchar(3)0.00Complete only
Process Status Effective DateDate specifying when the information in the process detail data record became effectivedate0.01Extended and Complete
Process CapacityAmount of waste capacitydouble2.38Extended and Complete
Unit of MeasureThe units of measurement of the process capacitychar(1)0.00Extended and Complete
Number of Units in GroupThe total number of units of the same process grouped together to form a single process unit groupint(7)0.18Extended and Complete
Capacity TypeA code giving the type of capacity referred to in the process capacity data fieldchar(1)32.02Extended and Complete
Legal/Operating Status Code OwnerThe agency responsible for determining the meaning of the legal/operating status code usedchar(2)0.00Complete only
Legal / Operating StatusA code for the combined legal status and operating status of the process unit groupchar(4)0.00Extended and Complete
Unit of Measure Code OwnerThe agency responsible for determining the meaning of the unit of measure code usedchar(2)0.00Complete only
Process Type Code OwnerThe agency that determined the meaning of the process type code usedchar(2)0.00Complete only
Process Type CodeA code for the type of process. It is meaningless without also consulting the unit of measure code.char(3)0.00Complete only
Commercial StatusCode indicating that the facility, whether public or private, accepts hazardous waste for the process unit group from a third party.char(1)0.16Extended and Complete
Process Code CombinationRTK NET combined process code.varchar(5)0.00Extended and Complete
Standardized Permit IndicatorIndicates whether the unit detail is permitted under a standardized permit.char(1)0.00Extended and Complete
Number of Waste CodesThe number of waste code records for this unit detail record.int(11)99.68Extended and Complete

Section: Process Unit Detail Waste Codes

This section lists waste codes that describe constituents or characteristics of the hazardous waste associated with a process unit detail.

This section can have more than one entry per record. The record with the most entries currently holds 2. 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
Unit Detail Sequence NumberSystem-generated number to uniquely identify each process unit detail recordchar(3)0.00Complete only
Waste Type Code OwnerThe agency that determined the meaning of the waste code usedchar(2)0.00Complete only
Waste Type CodeCode for a type of waste constituent -- generally taken from Biennial Reports. It is meaningless without also consulting the determining agency code owner field.varchar(6)0.00Complete only
Waste TypeCode for a type of waste constituent -- generally taken from Biennial Reports (combined with determining agency code for a single code lookup)varchar(8)0.00Extended and Complete

Section: Advanced Handler-based Record Counts

This section 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 displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
Number of NAICS CodesThe number of NAICS codes for this handler information recordint(11)45.24High through Complete
Number of Other PermitsThe number of other permit records associated with this handler information recordint(11)99.73High through Complete
Number of Owners / OperatorsThe number of owner or operator records associated with this handler information recordint(11)23.74High through Complete
Number of CertificationsThe number of certification records associated with this handler information recordint(11)38.10High through Complete
Number of State ActivitiesThe number of state activity records associated with this handler information recordint(11)93.57High through Complete
Number of Universal WastesThe number of universal waste records associated with this handler information recordint(11)97.75High through Complete
Number of Waste CodesThe number of Federal and State hazardous waste codes associated with this handler information recordint(11)42.38High through Complete
Number of Current Information RecordsThe number of current information (aka report universe) records for this handlerint(11)63.29High through Complete
Number of Part A Permit RecordsThe number of Part A perit records associated with this handler information recordint(11)99.91High through Complete

Section: Handler Information

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 166. 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
Activity LocationThe location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00High through Complete
Source TypeA code indicating the source of data for this information recordchar(1)0.00High through Complete
Sequence NumberA sequence number used to uniquely identify each information source recordint(6)0.00Complete only
Receive DateDate that the form of information was received from the handler by the appropraite authoritydate0.00High through Complete
Site Namethe legal name of the sitevarchar(80)0.00High through Complete
Non-NotifierA 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 authoritychar(1)98.21High through Complete
Include in Biennial Report (Yes/No)Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Reportchar(1)85.92High through Complete
CDX Transaction IDThe number assigned to the site ID form submitted via the CDX systemvarchar(20)99.92Complete only
Location Street NumberStreet number from the physical address of the primary site entrancevarchar(12)56.41High through Complete
Location Street 1First line of the street address from the physical address of the primary site entrancevarchar(30)0.00High through Complete
Location Street 2Second line of the street address from the physical address of the primary site entrancevarchar(30)95.35High through Complete
Location CityName of the city or town in which the handler is physically locatedvarchar(25)0.00High through Complete
Location StateThe state postal abbreviation for the U.S. State in which the handler is physically locatedchar(2)0.00High through Complete
Location Zip CodeThe ZIP code from the physical address of the primary site entrancevarchar(14)0.04High through Complete
Land TypeA code indicating the current ownership status of the land on which the facility is locatedchar(1)23.28High through Complete
State District CodeIndicates the state-designated legislative district(s) in which the site is locatedvarchar(10)48.99High through Complete
Mailing Street NumberThe street number from the primary business mailing address for the handlervarchar(12)63.82High through Complete
Mailing Street 1The first line of the street address for the primary mailing address for the handlervarchar(30)2.28High through Complete
Mailing Street 2The second line of the street address for the primary mailing address for the handlervarchar(30)94.47High through Complete
Mailing CityThe city or town from the primary mailing address for the handlervarchar(25)1.20High through Complete
Mailing StateThe psotal state abbreviation for the state in the primary mailing address for the handlerchar(2)2.11High through Complete
Mailing Zip CodeThe Zip code in the primary mailing address for the handlervarchar(14)2.21High through Complete
Mailing CountryThe country code in the primary mailing address for the handlerchar(2)11.00High through Complete
Contact First NameThe first name of the primary contact person for the sitevarchar(15)11.67High through Complete
Contact Middle InitialThe middle initial of the primary contact person for the sitechar(1)86.63High through Complete
Contact Last Namethe last name of the primary contact person for the sitevarchar(15)11.69High through Complete
Contact Street NumberThe street number from the address of the primary contact person for the sitevarchar(12)78.81High through Complete
Contact Street 1The first line of the street address for the primary contact person for the sitevarchar(30)25.77High through Complete
Contact Street 2The second line of the street address for the primary contact person for the sitevarchar(30)97.05High through Complete
Contact CityThe city or town from the address of the primary contact person for the sitevarchar(25)25.49High through Complete
Contact StateThe state postal abbreviation from the address of the primary contact person for the sitechar(2)25.88High through Complete
Contact Zip CodeThe Zip code from the address of the primary contact person for the sitevarchar(14)25.96High through Complete
Contact CountryThe country code from the address of the primary contact person for the sitechar(2)10.58High through Complete
Contact PhoneThe telephone number of the primary contact person for the sitevarchar(15)11.98High through Complete
Contact Phone ExtThe telephone number extension for the primary contact person for the sitevarchar(6)94.52High through Complete
Contact EmailThe Email address of the primary contact person for the sitevarchar(80)77.39High through Complete
Contact FaxThe fax number for the primary contact person for the sitevarchar(15)92.88High through Complete
Contact TitleThe title of the primary contact person for the sitevarchar(45)81.60High through Complete
Acknowledge DateDate on which information was received from the handlerdate83.19Complete only
Acknowledge FlagA flag used to mark the handler for having an acknowledgement of receipt sentchar(1)93.07Complete only
Importer Activity (Yes/No)Indicates whether the facility imports hazardous waste into the U.S. from a foreign countrychar(1)0.00High through Complete
Radioactive Waste (Yes/No)Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product materialchar(1)0.00High through Complete
Recycler Activity (Yes/No)Indicates whether the handler recycles hazardous wastechar(1)0.00High through Complete
Transporter Activity (Yes/No)Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or waterchar(1)0.00High through Complete
TSD Activity (Yes/No)Indicates whether the handler treats, stores, or disposes of hazardous wastechar(1)0.00High through Complete
Underground Injection (Yes/No)Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface wellchar(1)0.00High through 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)0.00High through Complete
Transfer Facility (Yes/No)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.00High through Complete
Burner Exemption (Yes/No)Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemptionchar(1)0.00High through Complete
Furnace Exemption (Yes/No)Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemptionchar(1)0.00High through Complete
Used Oil Fuel Burner (Yes/No)Indicates whether the site burns off-specification used oil for energy recoverychar(1)0.00High through Complete
Used Oil Processor (Yes/No)Indicates whether the site processes used oilchar(1)0.00High through Complete
Used Oil Refiner (Yes/No)Indicates whether the site refines used oilchar(1)0.00High through Complete
Used Oil Marketer (Yes/No)Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burnerschar(1)0.00High through Complete
Used Oil Specification Cert. (Yes/No)Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specificationchar(1)0.01High through 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)0.00High through Complete
Used Oil Transporter (Yes/No)Indicates whether the site transports or collects and transports used oilchar(1)0.00High through Complete
Off-site Waste ReceiptA code that indicates whether the handler accepts hazardous waste from another sitechar(1)0.00High through Complete
Handler Not AccessibleCode the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator)char(1)99.96High through Complete
Biennial Report YearThe year of the biennial reporting data from which this information record is takenvarchar(4)85.95High through Complete
County CodeCode for the county in which the handler is located (state postal abbreviation plus county FIPS code)char(5)0.57High through Complete
Federal Waste Gen. Code OwnerThe agency that determined the meaning of the Federal Waste Generator Code usedchar(2)0.75Complete only
Federal Waste Generator CodeA 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)0.75Complete only
State Waste Gen. Code OwnerThe agency that determined the meaning of the State Waste Generator code usedchar(2)20.28Complete only
State Waste Generator CodeA 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)23.31Complete only
State Waste GenerationA 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)20.28High through Complete
Short Term Generator ActivityIndicates whether the handler's generator status is determined from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete
Subpart K CollegeIndicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible college or university.char(1)74.17High through Complete
Subpart K HospitalIndicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible teaching hospital.char(1)74.17High through Complete
Subpart K NonprofitIndicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible nonprofit research institute.char(1)74.17High through Complete
Subpart K WithdrawalIndicates whether the handler is withdrawing from managing laboratory hazardous waste under 40 CFR 262 Subpart K.char(1)74.17High through Complete
Permit Contact First NameFirst name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.35High through Complete
Permit Contact Middle InitialMiddle initial of the person who is familiar with the handler's Hazardous Waste Permit informationchar(1)89.76High through Complete
Permit Contact Last NameLast name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.39High through Complete
Permit Contact Street NumberThe street number from the permit contact street address.varchar(12)89.26High through Complete
Permit Contact Street 1First line of the street address (or the post office box number) for the permit contact.varchar(30)78.66High through Complete
Permit Contact Street 2Second line (as needed) of the street address for the permit contact.varchar(30)98.65High through Complete
Permit Contact CityThe city or town of the permit contact address.varchar(25)78.52High through Complete
Permit Contact StateState code of the permit contact address.char(2)78.47High through Complete
Permit Contact Zip CodeZip code of the permit contact address.varchar(14)78.52High through Complete
Permit Contact CountryCountry code of the permit contact address.char(2)54.92High through Complete
Permit Contact PhoneTelephone number associated with the permit contact.varchar(15)77.44High through Complete
Permit Contact Phone ExtensionTelephone number extension associated with the permit contact.varchar(6)97.56High through Complete
Permit Contact EmailEmail address associated with the permit contactvarchar(80)88.36High through Complete
Permit Contact TitleTitle of the permit contact personvarchar(45)26.90High through Complete
Transfer Facility (Yes/No)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.05High through Complete

Section: NAICS Codes

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 High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
NAICS Sequence NumberSequence number for uniquely identifying NAICS codes for a handlerint(4)0.00Complete only
NAICS Code OwnerThe agency that determined the meaning of the NAICS code usedchar(2)0.00Complete only
NAICS CodeThe NAICS code for a type of industrychar(6)0.00High through Complete

Section: Other Permits

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 Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
Other Permit TypeA code for the type of other (non-RCRA) permit issued to the handlerchar(1)0.00Extended and Complete
Other Permit NumberID number of a permit issued to the handler, or the number of an application for which a permit has not yet been issuedvarchar(13)0.01Extended and Complete
Other Permit DescriptionDescription of any permit type indicated as Other in the Permit Type data fieldvarchar(20)1.01Extended and Complete
Other Permit Type Code OwnerThe agency that determined the meaning of the other permit type code.char(2)0.00Complete only

Section: Owners and Operators

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 26. 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
Owner Operator equence NumberSequence number to uniquely identify each owner or operator for a handlerint(4)0.00Complete only
Owner Operator Ind.A code for whether the record is for an owner or an operator, and whether they are current or previouschar(2)0.00High through Complete
Owner Operator NameThe name of the owner or operator of a facilityvarchar(40)0.02High through Complete
Owner Operator TypeA code for the type of owner or operatorchar(1)0.67High through Complete
Date Became CurrentDate indicating when the owner or operator became currentdate29.35High through Complete
Date Ended CurrentDate indicating when the owner or operator changed to a different owner or operatordate97.48High through Complete
Owner Operator Street NumberThe street number from the address of the owner or operatorvarchar(12)85.37High through Complete
Owner Operator Street 1The first line of the street address of the owner or operatorvarchar(30)21.38High through Complete
Owner Operator Street 2The second line of the street address of the owner or operatorvarchar(30)97.35High through Complete
Owner Operator CityThe city or town from the address of the owner or operatorvarchar(25)21.37High through Complete
Owner Operator StateThe postal state abbreviation from the address of the owner or operatorchar(2)21.06High through Complete
Owner Operator CountryThe country code from the address of the owner or operatorchar(2)40.02High through Complete
Owner Operator ZipThe Zip code from the address of the owner or operatorvarchar(14)21.51High through Complete
Owner Operator PhoneThe phone number of the owner or operatorvarchar(15)37.82High through Complete

Section: Certifications

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 54. 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
Certification Sequence NumberSequence number assigned to uniquely identify each certification recordint(8)0.00Complete only
Certfication Signed DateDate on which the handler information was certified by the reporting sitedate0.15Extended and Complete
Certification TitleTitle of the person who certified the handler informationvarchar(45)0.09Extended and Complete
Certification First NameFirst name of the person who certified the handler informationvarchar(15)0.07Extended and Complete
Certification Middle InitialMiddle initial of the name of the person who certified the handler informationchar(1)85.33Extended and Complete
Certification Last NameLast name of the person who certified the handler informationvarchar(15)0.07Extended and Complete

Section: State Activity

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 Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
State Activity Code OwnerThe agency that determined the meaning of the state activity type code usedchar(2)0.00Complete only
State Activity CodeA code for the type of state waste activity. It is meaningless without also consulting the determing agency code owner field.char(5)0.00Complete only
State Activity TypeA code for the type of state waste activity (combined with the determining agency code for a single code lookup)varchar(7)0.00Extended and Complete

Section: Universal Wastes

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 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
Universal Waste Type Code OwnerThe agency that determined the meaning of the universal waste type code usedchar(2)0.00Complete only
Universal Waste Type CodeA code describing a type of universal waste (batteries, thermometers, etc.)char(1)0.00High through Complete
Accumulation (Yes/No)Indicates whether the handler is engaged in accumulating universal waste on sitechar(1)0.82High through Complete
Generation (Yes/No)Indicates whether the handler is engaged in generating universal waste on sitechar(1)57.51High through Complete
Universal Waste TypeThe type of universal waste (batteries, thermometers, etc.)varchar(3)0.00High through Complete

Section: Waste Codes

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 737. 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
Waste Type Code OwnerThe agency that determined the meaning of the waste code usedchar(2)0.00Complete only
Waste Type CodeCode 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.00Complete only
Waste TypeCode for a type of waste constituent -- generally taken from Biennial Reports (combined with determining agency code for a single code lookup)varchar(8)0.00Extended and Complete

Section: Hazardous Secondary Material

This section gives basic information on a hazardous secondary material managed by the handler.

This section can have more than one entry per record. The record with the most entries currently holds 166. 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
Reason for NotificationIndicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00High through Complete
HSM Effective DateDate on which the facility either started or stopped managing hazardous secondary material.varchar(8)0.00High through Complete
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)32.42High through Complete
Number of HSM Activity RecordsThe number of HSM activity records for this HSM basic record.int(11)0.55High through Complete

Section: HSM Activity

This section gives quantity and other information associated with an activity taking place on a hazardous secondary material at the handler.

This section can have more than one entry per record. The record with the most entries currently holds 13. 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
HSM Waste Sequence NumberA sequnece number used to uniquely idenitfy each HSM waste code record.smallint(2)0.00High through Complete
HSM Activity Facility Code OwnerAlways equal to HQ.char(2)0.00High through Complete
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
Estimated HSM Tons ManagedThe estimated tons of hazardous secondary material associated with this activity that the facility expects to manage annually.bigint(10)3.41High through Complete
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)48.86High through Complete
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
Number of HSM Waste CodesThe number of HSM waste code records for this HSM activty record.int(11)0.00High through Complete

Section: HSM Waste Codes

This section provides hazardous waste codes associated with a hazardous secondary material activity.

This section can have more than one entry per record. The record with the most entries currently holds 43. 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
HSM Waste Sequence NumberA sequnece number used to uniquely idenitfy each HSM waste code record.smallint(2)0.00Complete only
Waste Type Code OwnerThe agency that determined the meaning of the waste code usedchar(2)0.00Complete only
Waste Type CodeCode for a type of waste constituent -- generally taken from Biennial Reports. It is meaningless without also consulting the determining agency code owner field.varchar(6)0.00Complete only
Waste TypeCode for a type of waste constituent -- generally taken from Biennial Reports (combined with determining agency code for a single code lookup)varchar(8)0.00High through Complete

Section: Corrective Action Areas

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 High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail
Area Sequence NumberCode used to uniquely designate a corrective action areachar(4)0.00Complete only
Corrective Action AreaName or number assigned to identify a corrective action areavarchar(40)0.00High through Complete
Facility-wide Corrective Action (Yes/No)Indicates whether the corrective action applies to the entire facilitychar(1)0.00High through Complete
Regulated Unit (Yes/No)Indicates whether the corrective action applies to a regulated unit at the handlerchar(1)82.70High through Complete
Air Release IndicatorIndicates that there has been a release to air (either within or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas.char(1)89.86High through Complete
Groundwater Release IndicatorIndicates that there has been a release to groundwater from the unit/area.char(1)67.71High through Complete
Soil Release IndicatorIndicates that there has been a release to soil (either within or beyond the facility boundary) from the unit/area. This may include subsoil contamination beneath the unit/area.char(1)59.05High through Complete
Surface Water Release IndicatorIndicates that there has been a release to surface water (either within or beyond the facility boundary) from the unit/area.char(1)84.62High through Complete
EPA Responsible Person ID OwnerThe EPA region that determined the meaning of the EPA person ID code used.char(2)93.37High through Complete
EPA Responsible Person IDThe EPA person currently responsible for overseeing the corrective action area.varchar(5)93.37High through Complete
State Responsible Person ID OwnerThe state that determined the meaning of the state person ID code used.char(2)73.11High through Complete
State Responsible Person IDThe state person currently responsible for overseeing the corrective action area.varchar(5)73.11High through Complete
Number of Area-Event LinksThe number of area-event links for this corrective action areaint(11)10.39Complete only

Section: Corrective Action Area - Event Links

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 215. 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
Event Type Code OwnerThe agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type CodeA code for the type of corrective action eventchar(7)0.00Complete only
Event Sequence NumberID number used to identify a corrective action eventchar(3)0.00Complete only
Event Responsible AgencyThe agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Activity LocationThe location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Event TypeA code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only

Section: Corrective Action Events

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 1,314. 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 FieldDescriptionField Type% blankLevel of Detail
Event Sequence NumberID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity LocationThe location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event DateThe date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible AgencyThe agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code OwnerThe agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event TypeA code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event DateThe original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event DateRevised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event DateThe best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID OwnerThe agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person IDAn ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code OwnerThe agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State SuborganizationName or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event TypeA code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event LinksThe number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority LinksThe number of event-authority links for this corrective action eventint(11)11.51Complete only

Section: Corrective Action Authorities

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 18. Only the first of these is 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
Effective DateDate on which a permit modification, unilateral order, consent decree, or appeal becomes effectivedate0.00High through Complete
Authority Responsible AgencyCode for the agency that originated and oversees a permit, permit modification, or orderchar(1)0.00High through Complete
Issuance DateThe date on which an agency official signs the order, permit, or permit modificationdate38.35High through Complete
Revokation DateThe date on which the corrective action authority is revokeddate97.37High through Complete
Repository StatusCode giving the status of an information repository near the facility for the purpose of making documents availablechar(1)91.98High through Complete
Authority Activity LocationThe location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00High through Complete
Authority Type Code OwnerThe agency that determined the meaning of the authority type code usedchar(2)0.00Complete only
Authority TypeA code for the type of authoritychar(1)0.00High through Complete
Responsible Person ID OwnerThe agency that determined the meaning of the responsible person ID used.char(2)29.49Complete only
Responsible Person IDID for the person responsible for overseeing the activities undertaken by the authority.varchar(5)29.50High through Complete
State Suborganization OwnerThe agency that detemined the meaning of the state suborganization code.char(2)62.02Complete only
State SuborganizationName or abbreviation of a state division/section (suborganization).varchar(10)62.02High through Complete
Number of Citation RecordsThe number of citation records for this authority.int(11)0.84Complete only
Number of Event-Authority LinksThe number of event-authority links for this authorityint(11)4.66Complete only
Event Responsible Person IDThe ID of the person currently responsible for the event.char(5)34.19High through Complete

Section: Corrective Action Citations

This section shows citations for each legal authority 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 7. 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
Statutory Citation Code OwnerThe agency that determined the meaning of the statutory citation code.char(2)0.00Complete only
Statutory CitationA code for the statutory citation.char(1)0.00High through Complete

Section: Corrective Action Event - Authority Links

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 1,085. 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
Authority Type Code OwnerThe agency that determined the meaning of the authority type code usedchar(2)0.00Complete only
Authority TypeA code for the type of authoritychar(1)0.00Complete only
Effective DateDate on which a permit modification, unilateral order, consent decree, or appeal becomes effectivedate0.00Complete only
Authority Responsible AgencyCode for the agency that originated and oversees a permit, permit modification, or orderchar(1)0.00Complete only
Authority Activity LocationThe location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00Complete only
Auth EPA HAndler IDShould be a copy of the handler ID.char(12)0.00Complete only
Event TypeA code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only

Handler-based delimited data reports

Data FieldDescriptionField Type% blankLevel of Detail
Handler IDUnique 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.00All
EPA Facility IDEPA FINDS ID that is supposed to uniquely identify a facility across different EPA data systemsvarchar(12)93.88All
Handler NameThe 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(80)0.00All
EPA RegionThe two-digit code for the EPA Region in which the handler is locatedchar(2)0.00Complete only
StateThe state postal code for the state in which the handler is locatedchar(2)0.00All
First Info. Receipt DateThe first date on which information was received for this handlerdate0.15All
Last Info. Receipt DateThe last date on which information was received for this handlerdate0.15All
Maximum PenaltyThe maximum final penalty amount for a single penalty listed in this facility's penalty records.decimal(14,2)98.87All
Number of CA Area RecordsThe number of corrective action area records for this handlerint(11)99.03High through Complete
Number of CA EventsThe number of corrective action event records for this handlerint(11)99.03High through Complete
Number of CA AuthoritiesThe number of corrective action authority records for this handlerint(11)99.17High through Complete
Number of Information RecordsThe number of handler information (aka hhandler2) records for this handlerint(11)0.15High through Complete
Number of Current Information RecordsThe number of current information (aka report universe) records for this handlerint(11)0.44High through Complete
Number of Permit SeriesThe number of permit series records for this handlerint(11)98.81High through Complete
Number of Process UnitsThe number of process unit records for this handlerint(11)98.82High through Complete
Number of Violation / Enforcement RecordsThe number of violation / enforcement records for this handlerint(11)70.30High through Complete
Number of Other IDsThe number of other ID records for this handlerint(11)84.95High through Complete
Number of HSM Basic RecordsThe number of HSM basic records for this handler.int(11)99.98High through Complete
Number of GIS RecordsThe number of GIS data records for this handler.int(11)78.28High through Complete
Number of Citation RecordsThe number of citation records for this handlerint(11)94.07High through Complete
Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00All
NAICS Code 1 (#1)First NAICS industry code for the sitechar(6)51.80All
NAICS Code 2 (#1)Second NAICS industry code for the sitevarchar(6)95.08High through Complete
NAICS Code 3 (#1)Third NAICS industry code for the sitevarchar(6)98.43High through Complete
NAICS Code 4 (#1)Fourth NAICS industry code for the sitevarchar(6)99.26High through Complete
Owner Name (#1)Name of the current owner of the sitevarchar(40)20.76All
Operator Name (#1)Name of the current operator of the sitevarchar(40)43.95High through Complete
Land Type (#1)A code indicating the current ownership status of the land on which the facility is locatedchar(1)20.68All
Location Street Number (#1)Street number from the physical address of the primary site entrancevarchar(12)56.23All
Location Street 1 (#1)First line of the street address from the physical address of the primary site entrancevarchar(30)0.00All
Location Street 2 (#1)Second line of the street address from the physical address of the primary site entrancevarchar(30)95.59All
Location City (#1)Name of the city or town in which the handler is physically locatedvarchar(25)0.00All
Location State (#1)The state postal abbreviation for the U.S. State in which the handler is physically locatedchar(2)0.00All
Location Zip Code (#1)The ZIP code from the physical address of the primary site entrancevarchar(14)0.01All
County Code (#1)Code for the county that the site is in (state postal abbreviation plus county FIPS code)char(5)0.01Complete only
Location County (#1)The county in which the site is locatedvarchar(27)0.01Extended and Complete
Location Country (#1)The out-of-country location for transporters coming into the U.S.char(2)54.76All
State District Code Owner (#1)The agency that defined the state district code.char(2)46.94Complete only
State District Code (#1)Indicates the state-designated legislative district(s) in which the site is locatedchar(10)46.94Complete only
State District (#1)A combination of two codes intended to define a state-designated legislative district within which the site is located.varchar(12)46.94All
Mailing Street Number (#1)The street number from the primary business mailing address for the handlervarchar(12)62.65Extended and Complete
Mailing Street 1 (#1)The first line of the street address for the primary mailing address for the handlervarchar(30)2.71Extended and Complete
Mailing Street 2 (#1)The second line of the street address for the primary mailing address for the handlervarchar(30)94.91Extended and Complete
Mailing City (#1)The city or town from the primary mailing address for the handlervarchar(25)2.57Extended and Complete
Mailing State (#1)The psotal state abbreviation for the state in the primary mailing address for the handlerchar(2)2.49Extended and Complete
Mailing Zip Code (#1)The Zip code in the primary mailing address for the handlervarchar(14)2.62Extended and Complete
Mailing Country (#1)The country code in the primary mailing address for the handlerchar(2)25.62Extended and Complete
Contact Name (#1)The name of the contact person for the handlervarchar(33)12.59High through Complete
Contact Street Number (#1)The street number from the address of the primary contact person for the sitevarchar(12)76.40All
Contact Street 1 (#1)The first line of the street address of the contact person for the handlervarchar(30)17.58Extended and Complete
Contact Street 2 (#1)The second line of the street address of the contact person for the handlervarchar(30)96.52Extended and Complete
Contact City (#1)The city or town from the address of the primary contact person for the sitevarchar(25)17.74Extended and Complete
Contact State (#1)The state postal abbreviation from the address of the primary contact person for the sitechar(2)17.70Extended and Complete
Contact Zip Code (#1)The Zip code from the address of the primary contact person for the sitevarchar(14)17.81Extended and Complete
Contact Country (#1)The country code from the address of the primary contact person for the sitechar(2)15.83Extended and Complete
Contact Phone (#1)The telephone number of the primary contact person for the sitevarchar(22)13.53Extended and Complete
Contact Email (#1)The Email address of the primary contact person for the sitevarchar(80)80.06All
Contact Fax (#1)The fax number for the primary contact person for the sitevarchar(15)91.36All
Contact Title (#1)The title of the primary contact person for the sitevarchar(45)77.98All
Receive Date (#1)Date that the form of information was received from the handler by the appropraite authoritydate0.16High through Complete
Source Type (#1)A code indicating the source of data for this information recordchar(1)0.00Extended and Complete
Sequence Number (#1)A sequence number used to uniquely identify each information source recordint(6)0.16Complete only
Extract Flag (#1)An X indicates that the data are available for extract for public usechar(1)0.00Complete only
EPA Region (#1)The two-digit code for the EPA Region in which the handler is locatedchar(2)0.00Complete only
Non-Notifier (#1)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 authoritychar(1)96.88High through Complete
Handler Not Accessible (#1)Code the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator)char(1)99.96High through Complete
State Waste Generation (#1)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)15.64All
Transporter Activity (Yes/No) (#1)Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or waterchar(1)0.18All
Operating TSDF Universe (#1)Indicates whether handler has an operating Treatment, Storage, or Disposal unit. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment.varchar(6)0.00All
Full Enforcement Universe (#1)Indicates whether handler is a TSDF that could potentially undergo a Compliance and Evaluation Inspection (CEI). Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment.varchar(6)0.00High through Complete
Radioactive Waste (Yes/No) (#1)Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product materialchar(1)0.18All
Recycler Activity (Yes/No) (#1)Indicates whether the handler recycles hazardous wastechar(1)0.18High through Complete
Underground Injection (Yes/No) (#1)Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface wellchar(1)0.18Extended and Complete
Importer Activity (Yes/No) (#1)Indicates whether the facility imports hazardous waste into the U.S. from a foreign countrychar(1)0.18Extended and Complete
Universal Waste Destination Facility (#1)Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste.char(1)0.05Extended and Complete
Used Oil Universe (#1)Concatenation of seven Yes/No data fields indicating used oil activityvarchar(7)0.02Extended and Complete
Permit Workload Universe (#1)Indicates whether handler is a facility with units that are in the permit pipeline or that has units with active permits. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Extended and Complete
Post-Closure Workload Universe (#1)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(6)0.00Extended and Complete
Corrective Action Workload Universe (#1)Indicates whether the handler has a unit undergoing corrective action acitvities.char(1)0.00Extended and Complete
GPRA Operating Permit Universe (#1)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, 1997char(1)0.02Complete only
Permit Progress Universe (#1)Indicates whether the handler is a facility with units in the Permit, Closure, or Post-Closure Workload Universes. Separate characters indicates (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Complete only
Closure Workload Universe (#1)Indicates whether the handler is a facility with units that are closing. Does not include units that are clean closed or post-closure. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00Extended and Complete
Subject to CA Universe (#1)Indicates whether the handler is potentially subject to corrective actionchar(1)0.00Complete only
TSDF Subject to CA Universe (#1)Indicates whether the handler is a TSD facility that is potentially subject to corrective action under statutory section 3004(u)/(v)char(1)0.16Complete only
TSDF Subject CA Discretionary (#1)Indicates whether the handler is a TSD facility that is only subject to corrective action under discretionary authoritieschar(1)0.16Complete only
Non TSDF Under CA (#1)Indicates whether the handler is a non TSD facility where corrective action has been imposedchar(1)0.16Complete only
In Handler Universe (#1)Indicates whether the site belongs to at least one of the handler universeschar(1)0.00Complete only
Generator Status Universe (#1)Contains a 3-letter translation of the Federal Waste Generation Status code (LQG, SQG, CEG, N, or blank)char(3)0.02Complete only
Burner Exemption (Yes/No) (#1)Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemptionchar(1)0.18Extended and Complete
Furnace Exemption (Yes/No) (#1)Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemptionchar(1)0.18Extended and Complete
Biennial Report Year (#1)The year of the biennial reporting data from which this information record is takenvarchar(4)95.28Complete only
Date of Last Change (#1)Date of the last change in the handler information recordsdate0.17Complete only
Owner Type (#1)A code describing the type of current ownerchar(1)20.11Complete only
Operator Type (#1)A code describing the type of current operatorchar(1)41.05Complete only
Owner Sequence Number (#1)The sequence number of the current owner within the owner and operator data tableint(6)19.47Complete only
Operator Sequence Number (#1)The sequence number of the current operator within the owner and operator data tableint(6)40.49Complete only
In A Universe (#1)Indicates that the site is in one of the universeschar(1)0.00Complete only
Federal Waste Gen. Code Owner (#1)The agency that determined the meaning of the Federal Waste Generator Code usedchar(2)1.23Complete only
Federal Waste Generator Code (#1)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)1.24Complete only
Federal Waste Generator (#1)Indicates the kind of Federally regulated waste generation at the facility. This field has been regularized to 1,2,3, or N by RTK NET.char(1)0.00All
State Waste Gen. Code Owner (#1)The agency that determined the meaning of the State Waste Generator code usedchar(2)15.78Complete only
State Waste Generator Code (#1)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)15.90Complete only
Short Term Generator Activity (#1)Indicates whether the handler's generator status is determined from a short-term or one-time event and not from ongoing processes.char(1)0.05All
GPRA Renewals Baseline (#1)Indicates whether the facility is on the GPRA 2011 Permit Baseline.char(1)0.02All
Universal Waste (#1)Indicates whether the facility generates, receives, or accumulates universal waste, or sends universal waste to another facility. This excludes TDRs or transports of universal waste.char(1)0.16All
Institutional Control Indicator (#1)Indicates whether institutional controls are in place.char(1)0.00All
Human Exposure Control Indicator (#1)Indicates whether human exposure controls are in place.char(1)0.20All
Groundwater Control Indicator (#1)Indicates whether groundwater controls are in place.char(1)0.20All
Unaddressed SNC (#1)Indicates whether the facility is an EPA unaddressed significant non-complier.char(1)0.00All
Addressed SNC (#1)Indicates whether the facility is an EPA addressed significant non-complier.char(1)0.00All
SNC Compliance Schedule (#1)Indicates whether the facility is a significant non-complier with a compliance schedule.char(1)0.00All
Universal Waste Destination (#1)Indicates whether the facility treats, disposes of, or recycles universal wastes on site.char(1)0.18All
Federal Indicator (#1)Indicates whether the facility is owned or operated by a Federal entity. Multiple values can be L = land is Federally-owned, O = facility is Federally-owned, P = facility is Federally-operated.char(3)0.18All
HSM Indicator (#1)Indicates whether the facility is currently, has stopped, or has never managed hazardous secondary material.char(1)0.16All
Subpart K Indicator (#1)Indicates whether the facility manages laboratory wastes under Subpart K. C=college, H=hospital, N=nonprofit research institute, W=withdrawal.char(4)0.03All
Commercial TSD Indicator (#1)Indicates whether the facility has any commercial TSD units.char(1)0.16All
TSD Type (#1)Indicates the types of TSD activities at the facility. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(5)0.00All
Permit Renewal Workload Universe (#1)Indicates whether handler is a facility with currently permitted units whose renewal applications have been received but have not been renewed. Separate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment.varchar(6)0.00All
GPRA Corrective Action Baseline (#1)Indicates whether the facility is on the GPRA 2020 Corrective Action Baseline.char(1)0.02All
NCAPS Corrective Action Priority Ranking (#1)Indicates the facilty's corrective action priority ranking -- (H)igh, (M)edium, (L)ow, or (N)o ranking.char(1)0.16All
Environmental Control Indicator (#1)Indicates whether environmental controls are in place.char(1)0.00All
Financial Assurance Required (#1)Indicates whether financial assurance is required for the facility. Multiple values are: A=corrective action, C=closure, N=non-sudden third-party liability, P=post-closure care, S=sudden third-party liability.varchar(5)0.00All
Active Site Indicator (#1)Indicates that the facility may be an active site. Separate characters for (H)andler, (P)ermitting, (A)=Corrective Action, (C)onverter, and (S)tate-specific activities.varchar(5)0.00All
Active Site Federally Regulated TSDF (#1)Indicates TSDfs subject to federal RCRA TSDF regulations, permits, and orders.varchar(6)0.00All
Active Site Converter TSDF (#1)Indicates former TSD units that have not yet clean closed as TSD units and for which the agency has accepted notification that the units no longer conduct activities that require a TSD permit.varchar(6)0.00All
Active Site State Regulated TSDF (#1)Indicates TSDFs regulated under state standards that are not considered part of the state authorized hazardous waste program, and threfore are not subject to federal RCRA permit requirements.varchar(9)0.00All
Federal Universal Waste (#1)Indicates whether the facility accumulates federally regulated universal waste on-site.char(1)0.16All
SNC Universe (#1)Handler is in SNC (Significant Non-Compliance).char(1)0.00All
Post-Closure Workload Land DisposalIndicates whether the handler has a land disposal unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload IncineratorIndicates whether the handler has an incinerator unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload StorageIndicates whether the handler has a hazardous waste storage unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the post-closure universechar(1)0.00Complete only
Post-Closure Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the post-closure universechar(1)0.00Complete only
Permit Progress Land DisposalIndicates whether the handler has a land disposal unit in the permit progress universechar(1)0.00Complete only
Permit Progress IncineratorIndicates whether the handler has an incinerator unit in the permit progress universechar(1)0.00Complete only
Permit Progress BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit progress universechar(1)0.00Complete only
Permit Progress StorageIndicates whether the handler has a hazardous waste storage unit in the permit progress universechar(1)0.00Complete only
Permit Progress TreatmentIndicates whether the handler has a hazardous waste treatment unit in the permit progress universechar(1)0.00Complete only
Permit Progress Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit progress universechar(1)0.00Complete only
Closure Workload Land DisposalIndicates whether the handler has a land disposal unit in the closure universechar(1)0.00Complete only
Closure Workload IncineratorIndicates whether the handler has an incinerator unit in the closure universechar(1)0.00Complete only
Closure Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the closure universechar(1)0.00Complete only
Closure Workload StorageIndicates whether the handler has a hazardous waste storage unit in the closure universechar(1)0.00Complete only
Closure Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the closure universechar(1)0.00Complete only
Closure Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the closure universechar(1)0.00Complete only
Permit Workload Land DisposalIndicates whether the handler has a land disposal unit in the permit workload universechar(1)0.00Complete only
Permit Workload IncineratorIndicates whether the handler has an incinerator unit in the permit workload universechar(1)0.00Complete only
Permit Workload BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit workload universechar(1)0.00Complete only
Permit Workload StorageIndicates whether the handler has a hazardous waste storage unit in the permit workload universechar(1)0.00Complete only
Permit Workload TreatmentIndicates whether the handler has a hazardous waste treatment unit in the permit workload universechar(1)0.00Complete only
Permit Workload Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit workload universechar(1)0.00Complete only
Permit Renewal Workload Land DisposalFlag indicating whether the facility is in the Permit Renewal Workload universe as a Land Disposal facility.char(1)0.00Complete only
Permit Renewal Workload IncineratorFlag indicating whether the facility is in the Permit Renewal Workload universe as an Incinerator.char(1)0.00Complete only
Permit Renewal Workload BIFFlag indicating whether the facility is in the Permit Renewal Workload universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Permit Renewal Workload StorageFlag indicating whether the facility is in the Permit Renewal Workload universe as a Storage facility.char(1)0.00Complete only
Permit Renewal Workload TreatmentFlag indicating whether the facility is in the Permit Renewal Workload universe as a Treatment facility.char(1)0.00Complete only
Permit Renewal Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the permit renewal universechar(1)0.00Complete only
Full Enforcement Land DisposalIndicates whether the handler has a land disposal unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement IncineratorIndicates whether the handler has an incinerator unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement StorageIndicates whether the handler has a hazardous waste storage unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement TreatmentIndicates whether the handler has a hazardous waste treatment unit in the full enforcement universechar(1)0.00Complete only
Full Enforcement Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the full enforcement universechar(1)0.00Complete only
Operating TSDF Land DisposalIndicates whether the handler has a land disposal unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF IncineratorIndicates whether the handler has an incinerator unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF BIFIndicates whether the handler has a boiler or industrial furnace (BIF) unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF StorageIndicates whether the handler has a hazardous waste storage unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF TreatmentIndicates whether the handler has a hazardous waste treatment unit in the operating TSD universechar(1)0.00Complete only
Operating TSDF Solid Waste ManagementIndicates whether the handler has a solid waste management unit in the operating TSD universechar(1)0.00Complete only
Used Oil Transporter (Yes/No)Indicates whether the site transports or collects and transports used oilchar(1)0.00Complete 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.00Complete only
Used Oil Processor (Yes/No)Indicates whether the site processes used oilchar(1)0.00Complete only
Used Oil Refiner (Yes/No)Indicates whether the site refines used oilchar(1)0.00Complete only
Used Oil Fuel Burner (Yes/No)Indicates whether the site burns off-specification used oil for energy recoverychar(1)0.00Complete only
Used Oil Marketer (Yes/No)Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burnerschar(1)0.00Complete only
Used Oil Specification Cert. (Yes/No)Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specificationchar(1)0.00Complete only
Active Site Handler ActivitiesFlag indicating whether the facility is in the Active Site universe because it is in a Handler universe.char(1)0.00Complete only
Active Site Federally Regulated TSDFFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe.char(1)0.00Complete only
Active Site Corrective Action WorkloadFlag indicating whether the facility is in the Active Site universe because it is in the Corrective Action Workload universe.char(1)0.00Complete only
Active Site ConverterFlag indicating whether the facility is in the Active Site Converter universe.char(1)0.00Complete only
Active Site State ActivitiesFlag indicating whether the facility is in the Active Site universe because it has a State Activity which indicates that the site is active.char(1)0.00Complete only
Active Site Federally Regulated LAnd DisposalFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Land Disposal facility.char(1)0.00Complete only
Active Site Federally Regulated IncineratorFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as an Incinerator.char(1)0.00Complete only
Active Site Federally Regulated BIFFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site Federally Regulated StorageFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Storage facility.char(1)0.00Complete only
Active Site Federally Regulated TreatmentFlag indicating whether the facility is in the Active Site Federally Regulated Treatment, Storage, and Disposal Facility universe as a Treatment facility.char(1)0.00Complete only
Active Site Federally Regulated Solid WasteIndicates whether the hand;er has a solid waste management unit in the active site Federally regulated universechar(1)0.00Complete only
Active Site State Regulated Land DisposalFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Land Disposal facility.char(1)0.00Complete only
Active Site State Regulated IncineratorFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as an Incinerator.char(1)0.00Complete only
Active Site State Regulated BIFFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site State Regulated StorageFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Storage facility.char(1)0.00Complete only
Active Site State Regulated TreatmentFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe as a Treatment facility.char(1)0.00Complete only
Active Site State Regulated Solid WasteIndicates whether the handler has a solid waste management unit in the active site state regulated universechar(1)0.00Complete only
Active Site State Regulated Waste GeneratorFlag indicating whether the facility is in the Active Site State Regulated Waste Generator universe.char(1)0.00Complete only
Active Site State Regulated Universal WasteFlag indicating whether the facility is in the Active Site State Universal Waste universe.char(1)0.00Complete only
Active Site State Regulated TSDF ACtivityFlag indicating whether the facility is in the Active Site State Regulated Treatment, Storage, and Disposal Facility universe.char(1)0.00Complete only
Active Site Converter Land DisposalFlag indicating whether the facility is in the Active Site Converter universe as a Land Disposal facility.char(1)0.00Complete only
Active Site Converter IncineratorFlag indicating whether the facility is in the Active Site Converter universe as an incinerator.char(1)0.00Complete only
Active Site Converter BIFFlag indicating whether the facility is in the Active Site Converter universe as a Boiler and/or Industrial Furnace.char(1)0.00Complete only
Active Site Converter StorageFlag indicating whether the facility is in the Active Site Converter universe as a Storage facility.char(1)0.00Complete only
Active Site Converter TreatmentFlag indicating whether the facility is in the Active Site Converter universe as a Treatment facility.char(1)0.00Complete only
Active Site Converter Solid WasteIndicates whether the handler has a solid waste management unit in the active site converter universechar(1)0.00Complete only
GIS Data Owner (#1)Indicates the location of the agency (EPA HQ, EPA region, or state) that owns the GIS data.char(2)0.00All
GIS Sequence Number (#1)A sequence number used to uniquely identify GIS data records.char(4)0.00All
Area Sequence Number (#1)Code used to uniquely designate a corrective action areachar(4)99.83Complete only
Source Map Scale (#1)The scale of detail on the source map used to determine lat/long coordinates for the sitebigint(20)69.84Complete only
Process Unit Sequence Number (#1)System-generated number used to uniquely identify a process unitchar(4)99.99All
Area Acreage (#1)The number of acres associated with the handler or area.decimal(12,2)96.47All
Area Source Code Owner (#1)Indicates the agency that defined the Area Source Code.char(2)96.47Complete only
Area Source Code (#1)Code for the source of the information used to determine the number of acres associated with the handler or area.char(4)96.47All
Area Source Date (#1)The date on which information about the area of the handler or area was collected.date96.47All
Data Collection Date (#1)The date on which the GIS information referred to in this record was collected.date0.00All
Horizontal Accuracy Measure (#1)The measure of the accuracy (in meters) of the lat/long coordinates.int(11)28.99All
Coordinate Data Code Owner (#1)The agency that defined the coordinate data code.char(2)66.19Complete only
Coordinate Data Code (#1)Code that represents the party responsible for collecting or otherwise providing geographic coordinates.char(3)66.19All
Geo Reference Point Code Owner (#1)The agency that defined the geographic reference point code.char(2)57.33Complete only
Geographic Reference Point Code (#1)Code that represents the place for which geographic coordinates were established.char(3)57.33All
Geometric Code Owner (#1)The agency that defined the geometric code.char(2)25.98Complete only
Geometric Code (#1)Code that represents the geometric entity described by one point or a sequence of lat/long points.char(3)25.98All
Horizontal Collection Code Owner (#1)The agency that defined the horizontal collection code.char(2)27.17Complete only
Horizontal Collection Code (#1)Code that represents the method used to determine the lat/long coordinates for the site location.char(3)27.17All
Horizontal Reference Code Owner (#1)The agency that defined the horizontal reference code.char(2)15.43Complete only
Horizontal Reference Code (#1)Code that represents the reference datum used in determining the lat/long coordinates for the site location.char(3)15.43All
Verification Method Code Owner (#1)The agency that defined the verification method code.char(2)62.09Complete only
Verification Method Code (#1)Code for the method used to verify the lat/long coordinates.char(3)62.09All
Number of Lat/Long Records (#1)The number of lat/long records for this GIS record.int(11)0.69All
Latitude (#1)The latititude of the site in decimal degreesdecimal(11,6)0.00High through Complete
Longitude (#1)The longitude of the site in decimal degreesdecimal(12,6)0.09High through Complete
Lat/Long Sequence Number (#1)A unique number used to identify lat/long coordinate records.char(4)0.00All
Citation (#1)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation Type (#1)Code indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type Code (#1)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined Violation (#1)The agency that actually determined the violationchar(1)0.00All
Citation Sequence Number (#1)A number used to uniquely identify each citation record.char(6)0.00All
Citation Owner (#1)The agency that defined the citationchar(2)0.00All
Violation Type Owner (#1)A code for the agency that defined the violation type code.char(2)0.00All
Violation Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence Number (#1)Unique number used to identify each violationchar(4)0.00All
Citation (#2)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation Type (#2)Code indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type Code (#2)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined Violation (#2)The agency that actually determined the violationchar(1)0.00All
Citation Sequence Number (#2)A number used to uniquely identify each citation record.char(6)0.00All
Citation Owner (#2)The agency that defined the citationchar(2)0.00All
Violation Type Owner (#2)A code for the agency that defined the violation type code.char(2)0.00All
Violation Activity Location (#2)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence Number (#2)Unique number used to identify each violationchar(4)0.00All
Citation (#3)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation Type (#3)Code indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type Code (#3)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined Violation (#3)The agency that actually determined the violationchar(1)0.00All
Citation Sequence Number (#3)A number used to uniquely identify each citation record.char(6)0.00All
Citation Owner (#3)The agency that defined the citationchar(2)0.00All
Violation Type Owner (#3)A code for the agency that defined the violation type code.char(2)0.00All
Violation Activity Location (#3)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence Number (#3)Unique number used to identify each violationchar(4)0.00All
Citation (#4)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation Type (#4)Code indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type Code (#4)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined Violation (#4)The agency that actually determined the violationchar(1)0.00All
Citation Sequence Number (#4)A number used to uniquely identify each citation record.char(6)0.00All
Citation Owner (#4)The agency that defined the citationchar(2)0.00All
Violation Type Owner (#4)A code for the agency that defined the violation type code.char(2)0.00All
Violation Activity Location (#4)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence Number (#4)Unique number used to identify each violationchar(4)0.00All
Citation (#5)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)0.00All
Citation Type (#5)Code indicating the origin of the citation listed in regulation violated.char(2)0.00All
Violation Type Code (#5)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)0.00All
Agency Which Determined Violation (#5)The agency that actually determined the violationchar(1)0.00All
Citation Sequence Number (#5)A number used to uniquely identify each citation record.char(6)0.00All
Citation Owner (#5)The agency that defined the citationchar(2)0.00All
Violation Type Owner (#5)A code for the agency that defined the violation type code.char(2)0.00All
Violation Activity Location (#5)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00All
Violation Sequence Number (#5)Unique number used to identify each violationchar(4)0.00All
Evaluation Activity Location (#1)The location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence Number (#1)Name or number assigned to identify an evaluationchar(3)0.00All
Evaluation Date (#1)The first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible Agency (#1)The agency responsible for conducting the evaluationchar(1)0.00All
Found Violation (#1)An indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen Complaint (#1)Indicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia Indicator (#1)Indicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling Indicator (#1)Indicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C Indicator (#1)For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type Code (#1)Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution Type (#1)The type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area Code (#1)Code to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus Area (#1)The subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person ID (#1)Code indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation Suborganization (#1)Code indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence Number (#1)A system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request Date (#1)The date that a 3007 information request was submitted.date99.86All
Response Received Date (#1)The date that 3007 information is received.date99.93All
Request Agency (#1)Code indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity Location (#1)Indicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence Number (#1)Unique number used to identify each violationchar(4)27.93All
Agency Which Determined Violation (#1)The agency that actually determined the violationchar(1)27.93All
Violation Type Code (#1)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation Type (#1)The specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
Citation (#1)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation Determined (#1)The date on which a determination was made that the violation existsdate27.93All
Compliance Date (#1)The date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance Qualifier (#1)Indicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible Agency (#1)The agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance Date (#1)Date by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence Number (#1)Name or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action Date (#1)The date on which the enforcement action was issueddate33.95All
Enforcement Responsible Agency (#1)The agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket Number (#1)The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement Attorney (#1)Identifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action Component (#1)Indicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated Date (#1)The date that the appeal was initiated.date99.94All
Appeal Resolution Date (#1)The date the appeal was resolved.date99.96All
Disposition Status Date (#1)Date that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status Code (#1)Code that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition Status (#1)Indicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence Number (#1)A system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent Name (#1)Name of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead Agency (#1)The lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type Code (#1)A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement Action (#1)Identifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person ID (#1)Code indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement Suborganization (#1)Code indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence Number (#1)A system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure Amount (#1)The actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion Date (#1)Date set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual Date (#1)The actual date of a SEP expenditure.date99.13All
SEP Defaulted Date (#1)The date a site defaulted on a SEP.date100.00All
SEP Type Code (#1)A code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP Type (#1)Indicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty Amount (#1)The amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty Amount (#1)The amount of final penalties for a violation.decimal(14,2)91.98All
Paid Amount (#1)The amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final Count (#1)Count of the number of penalties for an enforcement action.int(4)91.93Complete only
Final Amount (#1)The amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record Number (#1)RTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only
Evaluation Activity Location (#2)The location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence Number (#2)Name or number assigned to identify an evaluationchar(3)0.00All
Evaluation Date (#2)The first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible Agency (#2)The agency responsible for conducting the evaluationchar(1)0.00All
Found Violation (#2)An indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen Complaint (#2)Indicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia Indicator (#2)Indicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling Indicator (#2)Indicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C Indicator (#2)For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type Code (#2)Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution Type (#2)The type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area Code (#2)Code to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus Area (#2)The subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person ID (#2)Code indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation Suborganization (#2)Code indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence Number (#2)A system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request Date (#2)The date that a 3007 information request was submitted.date99.86All
Response Received Date (#2)The date that 3007 information is received.date99.93All
Request Agency (#2)Code indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity Location (#2)Indicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity Location (#2)The location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence Number (#2)Unique number used to identify each violationchar(4)27.93All
Agency Which Determined Violation (#2)The agency that actually determined the violationchar(1)27.93All
Violation Type Code (#2)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation Type (#2)The specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
Citation (#2)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation Determined (#2)The date on which a determination was made that the violation existsdate27.93All
Compliance Date (#2)The date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance Qualifier (#2)Indicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible Agency (#2)The agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance Date (#2)Date by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity Location (#2)The location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence Number (#2)Name or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action Date (#2)The date on which the enforcement action was issueddate33.95All
Enforcement Responsible Agency (#2)The agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket Number (#2)The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement Attorney (#2)Identifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action Component (#2)Indicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated Date (#2)The date that the appeal was initiated.date99.94All
Appeal Resolution Date (#2)The date the appeal was resolved.date99.96All
Disposition Status Date (#2)Date that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status Code (#2)Code that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition Status (#2)Indicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence Number (#2)A system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent Name (#2)Name of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead Agency (#2)The lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type Code (#2)A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement Action (#2)Identifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person ID (#2)Code indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement Suborganization (#2)Code indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence Number (#2)A system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure Amount (#2)The actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion Date (#2)Date set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual Date (#2)The actual date of a SEP expenditure.date99.13All
SEP Defaulted Date (#2)The date a site defaulted on a SEP.date100.00All
SEP Type Code (#2)A code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP Type (#2)Indicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty Amount (#2)The amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty Amount (#2)The amount of final penalties for a violation.decimal(14,2)91.98All
Paid Amount (#2)The amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final Count (#2)Count of the number of penalties for an enforcement action.int(4)91.93Complete only
Final Amount (#2)The amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record Number (#2)RTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only
Evaluation Activity Location (#3)The location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence Number (#3)Name or number assigned to identify an evaluationchar(3)0.00All
Evaluation Date (#3)The first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible Agency (#3)The agency responsible for conducting the evaluationchar(1)0.00All
Found Violation (#3)An indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen Complaint (#3)Indicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia Indicator (#3)Indicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling Indicator (#3)Indicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C Indicator (#3)For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type Code (#3)Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution Type (#3)The type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area Code (#3)Code to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus Area (#3)The subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person ID (#3)Code indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation Suborganization (#3)Code indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence Number (#3)A system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request Date (#3)The date that a 3007 information request was submitted.date99.86All
Response Received Date (#3)The date that 3007 information is received.date99.93All
Request Agency (#3)Code indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity Location (#3)Indicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity Location (#3)The location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence Number (#3)Unique number used to identify each violationchar(4)27.93All
Agency Which Determined Violation (#3)The agency that actually determined the violationchar(1)27.93All
Violation Type Code (#3)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation Type (#3)The specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
Citation (#3)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation Determined (#3)The date on which a determination was made that the violation existsdate27.93All
Compliance Date (#3)The date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance Qualifier (#3)Indicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible Agency (#3)The agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance Date (#3)Date by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity Location (#3)The location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence Number (#3)Name or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action Date (#3)The date on which the enforcement action was issueddate33.95All
Enforcement Responsible Agency (#3)The agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket Number (#3)The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement Attorney (#3)Identifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action Component (#3)Indicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated Date (#3)The date that the appeal was initiated.date99.94All
Appeal Resolution Date (#3)The date the appeal was resolved.date99.96All
Disposition Status Date (#3)Date that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status Code (#3)Code that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition Status (#3)Indicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence Number (#3)A system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent Name (#3)Name of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead Agency (#3)The lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type Code (#3)A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement Action (#3)Identifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person ID (#3)Code indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement Suborganization (#3)Code indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence Number (#3)A system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure Amount (#3)The actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion Date (#3)Date set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual Date (#3)The actual date of a SEP expenditure.date99.13All
SEP Defaulted Date (#3)The date a site defaulted on a SEP.date100.00All
SEP Type Code (#3)A code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP Type (#3)Indicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty Amount (#3)The amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty Amount (#3)The amount of final penalties for a violation.decimal(14,2)91.98All
Paid Amount (#3)The amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final Count (#3)Count of the number of penalties for an enforcement action.int(4)91.93Complete only
Final Amount (#3)The amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record Number (#3)RTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only
Evaluation Activity Location (#4)The location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence Number (#4)Name or number assigned to identify an evaluationchar(3)0.00All
Evaluation Date (#4)The first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible Agency (#4)The agency responsible for conducting the evaluationchar(1)0.00All
Found Violation (#4)An indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen Complaint (#4)Indicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia Indicator (#4)Indicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling Indicator (#4)Indicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C Indicator (#4)For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type Code (#4)Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution Type (#4)The type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area Code (#4)Code to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus Area (#4)The subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person ID (#4)Code indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation Suborganization (#4)Code indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence Number (#4)A system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request Date (#4)The date that a 3007 information request was submitted.date99.86All
Response Received Date (#4)The date that 3007 information is received.date99.93All
Request Agency (#4)Code indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity Location (#4)Indicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity Location (#4)The location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence Number (#4)Unique number used to identify each violationchar(4)27.93All
Agency Which Determined Violation (#4)The agency that actually determined the violationchar(1)27.93All
Violation Type Code (#4)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation Type (#4)The specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
Citation (#4)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation Determined (#4)The date on which a determination was made that the violation existsdate27.93All
Compliance Date (#4)The date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance Qualifier (#4)Indicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible Agency (#4)The agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance Date (#4)Date by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity Location (#4)The location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence Number (#4)Name or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action Date (#4)The date on which the enforcement action was issueddate33.95All
Enforcement Responsible Agency (#4)The agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket Number (#4)The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement Attorney (#4)Identifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action Component (#4)Indicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated Date (#4)The date that the appeal was initiated.date99.94All
Appeal Resolution Date (#4)The date the appeal was resolved.date99.96All
Disposition Status Date (#4)Date that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status Code (#4)Code that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition Status (#4)Indicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence Number (#4)A system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent Name (#4)Name of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead Agency (#4)The lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type Code (#4)A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement Action (#4)Identifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person ID (#4)Code indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement Suborganization (#4)Code indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence Number (#4)A system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure Amount (#4)The actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion Date (#4)Date set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual Date (#4)The actual date of a SEP expenditure.date99.13All
SEP Defaulted Date (#4)The date a site defaulted on a SEP.date100.00All
SEP Type Code (#4)A code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP Type (#4)Indicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty Amount (#4)The amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty Amount (#4)The amount of final penalties for a violation.decimal(14,2)91.98All
Paid Amount (#4)The amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final Count (#4)Count of the number of penalties for an enforcement action.int(4)91.93Complete only
Final Amount (#4)The amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record Number (#4)RTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only
Evaluation Activity Location (#5)The location, in the form of a state postal code, of the agency conducting the evaluationchar(2)0.00All
Evaluation Sequence Number (#5)Name or number assigned to identify an evaluationchar(3)0.00All
Evaluation Date (#5)The first day of the evaluation (inspection or record review)date0.00All
Evaluation Responsible Agency (#5)The agency responsible for conducting the evaluationchar(1)0.00All
Found Violation (#5)An indicator as to whether an evaluation discovered any violations at the facility. For CAV evaluations, the found violation indicator shows whether the evaluation found any discrepancies at the facility.char(1)0.00All
Citizen Complaint (#5)Indicates whether the evaluation was initiated because of a tip/complaint.char(1)0.00All
Multimedia Indicator (#5)Indicates whether the evaluation was part of a multimedia inspection activity.char(1)0.00All
Sampling Indicator (#5)Indicates whether the evaluation conducted included the collection of samples.char(1)0.00All
Not Subtitle C Indicator (#5)For an inspection that was conducted pursuant to RCRA 3007 or State equivalent, indicates whether the site is not a Subtitle C facility.char(1)0.00All
Evaluation Type Code (#5)Code for the type of evaluation. It is meaningless without also consulting the determining agency code owner field.char(3)0.00Complete only
Evalution Type (#5)The type of evaluation conducted at the handler.varchar(50)0.00All
Focus Area Code (#5)Code to identify the subject of a Focused Compliance Inspection.char(3)92.00Complete only
Focus Area (#5)The subject of a Focused Compliance Inspection.varchar(80)92.83All
Evaluation Responsible Person ID (#5)Code indicating the person within the agency that is responsible for conducting the evaluation.varchar(5)14.51All
Evaluation Suborganization (#5)Code indicating the branch/district within the agency that is responsible for conducting the evaluation.varchar(10)31.71All
Request Sequence Number (#5)A system-generated sequence number to uniquely identify 3007 information requests for a given site.int(6)99.86Complete only
Request Date (#5)The date that a 3007 information request was submitted.date99.86All
Response Received Date (#5)The date that 3007 information is received.date99.93All
Request Agency (#5)Code indicating the agency responsible for submitting the 3007 information request.char(1)99.86All
Request Activity Location (#5)Indicates the location of the agency requesting the 3007 information.char(2)99.86All
Violation Activity Location (#5)The location, in the form of a state postal code, of the agency regulating the activitychar(2)27.93Complete only
Violation Sequence Number (#5)Unique number used to identify each violationchar(4)27.93All
Agency Which Determined Violation (#5)The agency that actually determined the violationchar(1)27.93All
Violation Type Code (#5)Code indicating the specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(10)27.93Complete only
Violation Type (#5)The specific area of the RCRA portions of the Federal Code of Regulations covered by the evaluation and/or found to be in violation with RCRA regulations or statutes.varchar(80)27.93All
Citation (#5)Citation from Federal or state regulations or statutes that specifies a violation or pending violationvarchar(35)66.75All
Date Violation Determined (#5)The date on which a determination was made that the violation existsdate27.93All
Compliance Date (#5)The date on which the agency determines that the handler has demonstrated full physical compliancedate31.18All
Return to Compliance Qualifier (#5)Indicates the conditions under which actual compliance was observed.char(1)31.25All
Violation Responsible Agency (#5)The agency responsible for determining the violationchar(1)28.40All
Scheduled Compliance Date (#5)Date by which the handler is to subject documentation showing that the violation has been brought into compliancedate78.23All
Enforcement Activity Location (#5)The location, in the form of a state postal code, of the agency regulating the activitychar(2)33.95Complete only
Enforcement Sequence Number (#5)Name or number assigned to uniquely identify an enforcementchar(3)33.95All
Enforcement Action Date (#5)The date on which the enforcement action was issueddate33.95All
Enforcement Responsible Agency (#5)The agency responsible for issuing the enforcement actionchar(1)33.95All
Enforcement Docket Number (#5)The relevant docket number that enforcement staff have assigned for tracking of enforcement actions.varchar(15)91.60All
Enforcement Attorney (#5)Identifies the attorney within the agency that is responsible for issuing the enforcement action.varchar(5)81.56All
Corrective Action Component (#5)Indicates whether the enforcement action contains a corrective action component.char(1)33.95All
Appeal Initiated Date (#5)The date that the appeal was initiated.date99.94All
Appeal Resolution Date (#5)The date the appeal was resolved.date99.96All
Disposition Status Date (#5)Date that the enforcement action was closed, terminated, or discontinued.date96.59All
Disposition Status Code (#5)Code that indicates how an enforcement action was closed, terminated, or discontinued.char(2)96.59Complete only
Disposition Status (#5)Indicates how an enforcement action was closed, terminated, or discontinued.varchar(30)96.59All
CAFO Sequence Number (#5)A system-generated sequence number to uniquely identify Consent Agreement / Final Order (CA/FO) instances.int(6)99.98All
CAFO Respondent Name (#5)Name of the respondent associated with the Consent Agreement / Final Order (CA/FO).varchar(180)99.98All
CAFO Lead Agency (#5)The lead agency that is responsible for defining the Consent Agreement / Final Order (CA/FO).char(2)99.98All
Enforcement Type Code (#5)A code for the type of enforcement action. It is meaningless without also consulting the determining agency code owner field.char(3)33.95Complete only
Enforcement Action (#5)Identifies the type of enforcement action being taken against a site.varchar(80)38.27All
Enforcement Responsible Person ID (#5)Code indicating the person within the agency responsible for the enforcement action.varchar(5)44.43All
Enforcement Suborganization (#5)Code indicating the branch/district within the agency that is responsible for the enforcement action.varchar(10)52.86All
SEP Sequence Number (#5)A system-generated number to uniquely identify each SEP or enforcement milestone recordchar(2)98.70All
SEP Expenditure Amount (#5)The actual amount of the SEP expenditure.decimal(13,2)99.06All
SEP Scheduled Completion Date (#5)Date set by an enforcement action for the full or partial expenditure of funds for a SEP project.date98.96All
SEP Actual Date (#5)The actual date of a SEP expenditure.date99.13All
SEP Defaulted Date (#5)The date a site defaulted on a SEP.date100.00All
SEP Type Code (#5)A code for the type of SEP or enforcement milestone recordchar(3)98.70Complete only
SEP Type (#5)Indicates the type of Supplemental Environmental Project associated with the enforcement action.varchar(80)98.73All
Proposed Penalty Amount (#5)The amount in proposed penalties for a violation.decimal(14,2)96.45All
Final Penalty Amount (#5)The amount of final penalties for a violation.decimal(14,2)91.98All
Paid Amount (#5)The amount of penalties for a violation that were actually paid.decimal(14,2)94.45All
Final Count (#5)Count of the number of penalties for an enforcement action.int(4)91.93Complete only
Final Amount (#5)The amount of penalties whose penalty type was FMP or SCR.decimal(14,2)91.87Complete only
Violation / Enforcement Record Number (#5)RTK NET assigned unique ID for each violation / enforcement record.bigint(20) unsigned0.00Complete only
Other ID (#1)Additional ID for this handler.char(12)0.00All
Same Facility (#1)Indicates whether the other ID refers to the same facility as the handler ID.char(1)0.00All
Relationship Code Owner (#1)The agency that detemined the meaning of the relationship code.char(2)0.00Complete only
Relationship Code (#1)Code for the type of relationship between this additional ID and the handler.char(1)0.01Complete only
Relationship (#1)The type of relationship between this additional ID and the handler.varchar(3)0.00All
Other ID (#2)Additional ID for this handler.char(12)0.00All
Same Facility (#2)Indicates whether the other ID refers to the same facility as the handler ID.char(1)0.00All
Relationship Code Owner (#2)The agency that detemined the meaning of the relationship code.char(2)0.00Complete only
Relationship Code (#2)Code for the type of relationship between this additional ID and the handler.char(1)0.01Complete only
Relationship (#2)The type of relationship between this additional ID and the handler.varchar(3)0.00All
Other ID (#3)Additional ID for this handler.char(12)0.00All
Same Facility (#3)Indicates whether the other ID refers to the same facility as the handler ID.char(1)0.00All
Relationship Code Owner (#3)The agency that detemined the meaning of the relationship code.char(2)0.00Complete only
Relationship Code (#3)Code for the type of relationship between this additional ID and the handler.char(1)0.01Complete only
Relationship (#3)The type of relationship between this additional ID and the handler.varchar(3)0.00All
Permit Series Sequence Number (#1)System-generated number used to uniquely identify a permit series for a handlerchar(4)0.00Complete only
Permit Series Name (#1)Name or number assigned by an agency to identify a permit or permit applicationvarchar(40)0.00Extended and Complete
Number of Permit Events (#1)The number of permit events associated with this permit series recordint(11)0.67Extended and Complete
Permit Series Sequence Number (#2)System-generated number used to uniquely identify a permit series for a handlerchar(4)0.00Complete only
Permit Series Name (#2)Name or number assigned by an agency to identify a permit or permit applicationvarchar(40)0.00Extended and Complete
Number of Permit Events (#2)The number of permit events associated with this permit series recordint(11)0.67Extended and Complete
Process Unit Sequence Number (#1)System-generated number used to uniquely identify a process unitchar(4)0.00Complete only
Process Unit Name (#1)Name or number assigned by an agency to identify a process unit groupvarchar(40)0.00High through Complete
Number of Process Unit Details (#1)The number of process unti detail records associated with this process unit recordint(11)0.15High through Complete
Number of Event-Unit Links (#1)The number of permit event-process unit links for this process unitint(11)1.43High through Complete
Process Unit Sequence Number (#2)System-generated number used to uniquely identify a process unitchar(4)0.00Complete only
Process Unit Name (#2)Name or number assigned by an agency to identify a process unit groupvarchar(40)0.00High through Complete
Number of Process Unit Details (#2)The number of process unti detail records associated with this process unit recordint(11)0.15High through Complete
Number of Event-Unit Links (#2)The number of permit event-process unit links for this process unitint(11)1.43High through Complete
Number of NAICS CodesThe number of NAICS codes for this handler information recordint(11)45.24High through Complete
Number of Other PermitsThe number of other permit records associated with this handler information recordint(11)99.73High through Complete
Number of Owners / OperatorsThe number of owner or operator records associated with this handler information recordint(11)23.74High through Complete
Number of CertificationsThe number of certification records associated with this handler information recordint(11)38.10High through Complete
Number of State ActivitiesThe number of state activity records associated with this handler information recordint(11)93.57High through Complete
Number of Universal WastesThe number of universal waste records associated with this handler information recordint(11)97.75High through Complete
Number of Waste CodesThe number of Federal and State hazardous waste codes associated with this handler information recordint(11)42.38High through Complete
Number of Current Information RecordsThe number of current information (aka report universe) records for this handlerint(11)63.29High through Complete
Number of Part A Permit RecordsThe number of Part A perit records associated with this handler information recordint(11)99.91High through Complete
Number of NAICS CodesThe number of NAICS codes for this handler information recordint(11)45.24High through Complete
Number of Other PermitsThe number of other permit records associated with this handler information recordint(11)99.73High through Complete
Number of Owners / OperatorsThe number of owner or operator records associated with this handler information recordint(11)23.74High through Complete
Number of CertificationsThe number of certification records associated with this handler information recordint(11)38.10High through Complete
Number of State ActivitiesThe number of state activity records associated with this handler information recordint(11)93.57High through Complete
Number of Universal WastesThe number of universal waste records associated with this handler information recordint(11)97.75High through Complete
Number of Waste CodesThe number of Federal and State hazardous waste codes associated with this handler information recordint(11)42.38High through Complete
Number of Current Information RecordsThe number of current information (aka report universe) records for this handlerint(11)63.29High through Complete
Number of Part A Permit RecordsThe number of Part A perit records associated with this handler information recordint(11)99.91High through Complete
Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00High through Complete
Source Type (#1)A code indicating the source of data for this information recordchar(1)0.00High through Complete
Sequence Number (#1)A sequence number used to uniquely identify each information source recordint(6)0.00Complete only
Receive Date (#1)Date that the form of information was received from the handler by the appropraite authoritydate0.00High through Complete
Site Name (#1)the legal name of the sitevarchar(80)0.00High through Complete
Non-Notifier (#1)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 authoritychar(1)98.21High through Complete
Include in Biennial Report (Yes/No) (#1)Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Reportchar(1)85.92High through Complete
CDX Transaction ID (#1)The number assigned to the site ID form submitted via the CDX systemvarchar(20)99.92Complete only
Location Street Number (#1)Street number from the physical address of the primary site entrancevarchar(12)56.41High through Complete
Location Street 1 (#1)First line of the street address from the physical address of the primary site entrancevarchar(30)0.00High through Complete
Location Street 2 (#1)Second line of the street address from the physical address of the primary site entrancevarchar(30)95.35High through Complete
Location City (#1)Name of the city or town in which the handler is physically locatedvarchar(25)0.00High through Complete
Location State (#1)The state postal abbreviation for the U.S. State in which the handler is physically locatedchar(2)0.00High through Complete
Location Zip Code (#1)The ZIP code from the physical address of the primary site entrancevarchar(14)0.04High through Complete
Land Type (#1)A code indicating the current ownership status of the land on which the facility is locatedchar(1)23.28High through Complete
State District Code (#1)Indicates the state-designated legislative district(s) in which the site is locatedvarchar(10)48.99High through Complete
Mailing Street Number (#1)The street number from the primary business mailing address for the handlervarchar(12)63.82High through Complete
Mailing Street 1 (#1)The first line of the street address for the primary mailing address for the handlervarchar(30)2.28High through Complete
Mailing Street 2 (#1)The second line of the street address for the primary mailing address for the handlervarchar(30)94.47High through Complete
Mailing City (#1)The city or town from the primary mailing address for the handlervarchar(25)1.20High through Complete
Mailing State (#1)The psotal state abbreviation for the state in the primary mailing address for the handlerchar(2)2.11High through Complete
Mailing Zip Code (#1)The Zip code in the primary mailing address for the handlervarchar(14)2.21High through Complete
Mailing Country (#1)The country code in the primary mailing address for the handlerchar(2)11.00High through Complete
Contact First Name (#1)The first name of the primary contact person for the sitevarchar(15)11.67High through Complete
Contact Middle Initial (#1)The middle initial of the primary contact person for the sitechar(1)86.63High through Complete
Contact Last Name (#1)the last name of the primary contact person for the sitevarchar(15)11.69High through Complete
Contact Street Number (#1)The street number from the address of the primary contact person for the sitevarchar(12)78.81High through Complete
Contact Street 1 (#1)The first line of the street address for the primary contact person for the sitevarchar(30)25.77High through Complete
Contact Street 2 (#1)The second line of the street address for the primary contact person for the sitevarchar(30)97.05High through Complete
Contact City (#1)The city or town from the address of the primary contact person for the sitevarchar(25)25.49High through Complete
Contact State (#1)The state postal abbreviation from the address of the primary contact person for the sitechar(2)25.88High through Complete
Contact Zip Code (#1)The Zip code from the address of the primary contact person for the sitevarchar(14)25.96High through Complete
Contact Country (#1)The country code from the address of the primary contact person for the sitechar(2)10.58High through Complete
Contact Phone (#1)The telephone number of the primary contact person for the sitevarchar(15)11.98High through Complete
Contact Phone Ext (#1)The telephone number extension for the primary contact person for the sitevarchar(6)94.52High through Complete
Contact Email (#1)The Email address of the primary contact person for the sitevarchar(80)77.39High through Complete
Contact Fax (#1)The fax number for the primary contact person for the sitevarchar(15)92.88High through Complete
Contact Title (#1)The title of the primary contact person for the sitevarchar(45)81.60High through Complete
Acknowledge Date (#1)Date on which information was received from the handlerdate83.19Complete only
Acknowledge Flag (#1)A flag used to mark the handler for having an acknowledgement of receipt sentchar(1)93.07Complete only
Importer Activity (Yes/No) (#1)Indicates whether the facility imports hazardous waste into the U.S. from a foreign countrychar(1)0.00High through Complete
Radioactive Waste (Yes/No) (#1)Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product materialchar(1)0.00High through Complete
Recycler Activity (Yes/No) (#1)Indicates whether the handler recycles hazardous wastechar(1)0.00High through Complete
Transporter Activity (Yes/No) (#1)Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or waterchar(1)0.00High through Complete
TSD Activity (Yes/No) (#1)Indicates whether the handler treats, stores, or disposes of hazardous wastechar(1)0.00High through Complete
Underground Injection (Yes/No) (#1)Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface wellchar(1)0.00High through Complete
Universal Waste Destination (Yes/No) (#1)Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste.char(1)0.00High through Complete
Transfer Facility (Yes/No) (#1)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.00High through Complete
Burner Exemption (Yes/No) (#1)Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemptionchar(1)0.00High through Complete
Furnace Exemption (Yes/No) (#1)Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemptionchar(1)0.00High through Complete
Used Oil Fuel Burner (Yes/No) (#1)Indicates whether the site burns off-specification used oil for energy recoverychar(1)0.00High through Complete
Used Oil Processor (Yes/No) (#1)Indicates whether the site processes used oilchar(1)0.00High through Complete
Used Oil Refiner (Yes/No) (#1)Indicates whether the site refines used oilchar(1)0.00High through Complete
Used Oil Marketer (Yes/No) (#1)Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burnerschar(1)0.00High through Complete
Used Oil Specification Cert. (Yes/No) (#1)Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specificationchar(1)0.01High through Complete
Used Oil Transfer Facility (Yes/No) (#1)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.00High through Complete
Used Oil Transporter (Yes/No) (#1)Indicates whether the site transports or collects and transports used oilchar(1)0.00High through Complete
Off-site Waste Receipt (#1)A code that indicates whether the handler accepts hazardous waste from another sitechar(1)0.00High through Complete
Handler Not Accessible (#1)Code the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator)char(1)99.96High through Complete
Biennial Report Year (#1)The year of the biennial reporting data from which this information record is takenvarchar(4)85.95High through Complete
County Code (#1)Code for the county in which the handler is located (state postal abbreviation plus county FIPS code)char(5)0.57High through Complete
Federal Waste Gen. Code Owner (#1)The agency that determined the meaning of the Federal Waste Generator Code usedchar(2)0.75Complete only
Federal Waste Generator Code (#1)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)0.75Complete only
State Waste Gen. Code Owner (#1)The agency that determined the meaning of the State Waste Generator code usedchar(2)20.28Complete only
State Waste Generator Code (#1)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)23.31Complete only
State Waste Generation (#1)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)20.28High through Complete
Short Term Generator Activity (#1)Indicates whether the handler's generator status is determined from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete
Subpart K College (#1)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible college or university.char(1)74.17High through Complete
Subpart K Hospital (#1)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible teaching hospital.char(1)74.17High through Complete
Subpart K Nonprofit (#1)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible nonprofit research institute.char(1)74.17High through Complete
Subpart K Withdrawal (#1)Indicates whether the handler is withdrawing from managing laboratory hazardous waste under 40 CFR 262 Subpart K.char(1)74.17High through Complete
Permit Contact First Name (#1)First name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.35High through Complete
Permit Contact Middle Initial (#1)Middle initial of the person who is familiar with the handler's Hazardous Waste Permit informationchar(1)89.76High through Complete
Permit Contact Last Name (#1)Last name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.39High through Complete
Permit Contact Street Number (#1)The street number from the permit contact street address.varchar(12)89.26High through Complete
Permit Contact Street 1 (#1)First line of the street address (or the post office box number) for the permit contact.varchar(30)78.66High through Complete
Permit Contact Street 2 (#1)Second line (as needed) of the street address for the permit contact.varchar(30)98.65High through Complete
Permit Contact City (#1)The city or town of the permit contact address.varchar(25)78.52High through Complete
Permit Contact State (#1)State code of the permit contact address.char(2)78.47High through Complete
Permit Contact Zip Code (#1)Zip code of the permit contact address.varchar(14)78.52High through Complete
Permit Contact Country (#1)Country code of the permit contact address.char(2)54.92High through Complete
Permit Contact Phone (#1)Telephone number associated with the permit contact.varchar(15)77.44High through Complete
Permit Contact Phone Extension (#1)Telephone number extension associated with the permit contact.varchar(6)97.56High through Complete
Permit Contact Email (#1)Email address associated with the permit contactvarchar(80)88.36High through Complete
Permit Contact Title (#1)Title of the permit contact personvarchar(45)26.90High through Complete
Transfer Facility (Yes/No) (#1)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.05High through Complete
Activity Location (#2)The location, in the form of a state postal code, of the agency regulating the handlerchar(2)0.00High through Complete
Source Type (#2)A code indicating the source of data for this information recordchar(1)0.00High through Complete
Sequence Number (#2)A sequence number used to uniquely identify each information source recordint(6)0.00Complete only
Receive Date (#2)Date that the form of information was received from the handler by the appropraite authoritydate0.00High through Complete
Site Name (#2)the legal name of the sitevarchar(80)0.00High through Complete
Non-Notifier (#2)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 authoritychar(1)98.21High through Complete
Include in Biennial Report (Yes/No) (#2)Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Reportchar(1)85.92High through Complete
CDX Transaction ID (#2)The number assigned to the site ID form submitted via the CDX systemvarchar(20)99.92Complete only
Location Street Number (#2)Street number from the physical address of the primary site entrancevarchar(12)56.41High through Complete
Location Street 1 (#2)First line of the street address from the physical address of the primary site entrancevarchar(30)0.00High through Complete
Location Street 2 (#2)Second line of the street address from the physical address of the primary site entrancevarchar(30)95.35High through Complete
Location City (#2)Name of the city or town in which the handler is physically locatedvarchar(25)0.00High through Complete
Location State (#2)The state postal abbreviation for the U.S. State in which the handler is physically locatedchar(2)0.00High through Complete
Location Zip Code (#2)The ZIP code from the physical address of the primary site entrancevarchar(14)0.04High through Complete
Land Type (#2)A code indicating the current ownership status of the land on which the facility is locatedchar(1)23.28High through Complete
State District Code (#2)Indicates the state-designated legislative district(s) in which the site is locatedvarchar(10)48.99High through Complete
Mailing Street Number (#2)The street number from the primary business mailing address for the handlervarchar(12)63.82High through Complete
Mailing Street 1 (#2)The first line of the street address for the primary mailing address for the handlervarchar(30)2.28High through Complete
Mailing Street 2 (#2)The second line of the street address for the primary mailing address for the handlervarchar(30)94.47High through Complete
Mailing City (#2)The city or town from the primary mailing address for the handlervarchar(25)1.20High through Complete
Mailing State (#2)The psotal state abbreviation for the state in the primary mailing address for the handlerchar(2)2.11High through Complete
Mailing Zip Code (#2)The Zip code in the primary mailing address for the handlervarchar(14)2.21High through Complete
Mailing Country (#2)The country code in the primary mailing address for the handlerchar(2)11.00High through Complete
Contact First Name (#2)The first name of the primary contact person for the sitevarchar(15)11.67High through Complete
Contact Middle Initial (#2)The middle initial of the primary contact person for the sitechar(1)86.63High through Complete
Contact Last Name (#2)the last name of the primary contact person for the sitevarchar(15)11.69High through Complete
Contact Street Number (#2)The street number from the address of the primary contact person for the sitevarchar(12)78.81High through Complete
Contact Street 1 (#2)The first line of the street address for the primary contact person for the sitevarchar(30)25.77High through Complete
Contact Street 2 (#2)The second line of the street address for the primary contact person for the sitevarchar(30)97.05High through Complete
Contact City (#2)The city or town from the address of the primary contact person for the sitevarchar(25)25.49High through Complete
Contact State (#2)The state postal abbreviation from the address of the primary contact person for the sitechar(2)25.88High through Complete
Contact Zip Code (#2)The Zip code from the address of the primary contact person for the sitevarchar(14)25.96High through Complete
Contact Country (#2)The country code from the address of the primary contact person for the sitechar(2)10.58High through Complete
Contact Phone (#2)The telephone number of the primary contact person for the sitevarchar(15)11.98High through Complete
Contact Phone Ext (#2)The telephone number extension for the primary contact person for the sitevarchar(6)94.52High through Complete
Contact Email (#2)The Email address of the primary contact person for the sitevarchar(80)77.39High through Complete
Contact Fax (#2)The fax number for the primary contact person for the sitevarchar(15)92.88High through Complete
Contact Title (#2)The title of the primary contact person for the sitevarchar(45)81.60High through Complete
Acknowledge Date (#2)Date on which information was received from the handlerdate83.19Complete only
Acknowledge Flag (#2)A flag used to mark the handler for having an acknowledgement of receipt sentchar(1)93.07Complete only
Importer Activity (Yes/No) (#2)Indicates whether the facility imports hazardous waste into the U.S. from a foreign countrychar(1)0.00High through Complete
Radioactive Waste (Yes/No) (#2)Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product materialchar(1)0.00High through Complete
Recycler Activity (Yes/No) (#2)Indicates whether the handler recycles hazardous wastechar(1)0.00High through Complete
Transporter Activity (Yes/No) (#2)Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or waterchar(1)0.00High through Complete
TSD Activity (Yes/No) (#2)Indicates whether the handler treats, stores, or disposes of hazardous wastechar(1)0.00High through Complete
Underground Injection (Yes/No) (#2)Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface wellchar(1)0.00High through Complete
Universal Waste Destination (Yes/No) (#2)Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste.char(1)0.00High through Complete
Transfer Facility (Yes/No) (#2)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.00High through Complete
Burner Exemption (Yes/No) (#2)Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemptionchar(1)0.00High through Complete
Furnace Exemption (Yes/No) (#2)Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemptionchar(1)0.00High through Complete
Used Oil Fuel Burner (Yes/No) (#2)Indicates whether the site burns off-specification used oil for energy recoverychar(1)0.00High through Complete
Used Oil Processor (Yes/No) (#2)Indicates whether the site processes used oilchar(1)0.00High through Complete
Used Oil Refiner (Yes/No) (#2)Indicates whether the site refines used oilchar(1)0.00High through Complete
Used Oil Marketer (Yes/No) (#2)Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burnerschar(1)0.00High through Complete
Used Oil Specification Cert. (Yes/No) (#2)Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specificationchar(1)0.01High through Complete
Used Oil Transfer Facility (Yes/No) (#2)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.00High through Complete
Used Oil Transporter (Yes/No) (#2)Indicates whether the site transports or collects and transports used oilchar(1)0.00High through Complete
Off-site Waste Receipt (#2)A code that indicates whether the handler accepts hazardous waste from another sitechar(1)0.00High through Complete
Handler Not Accessible (#2)Code the describes why the handler is not accessible for normal RCRA tracking (formerly known as Bankrupt Indicator)char(1)99.96High through Complete
Biennial Report Year (#2)The year of the biennial reporting data from which this information record is takenvarchar(4)85.95High through Complete
County Code (#2)Code for the county in which the handler is located (state postal abbreviation plus county FIPS code)char(5)0.57High through Complete
Federal Waste Gen. Code Owner (#2)The agency that determined the meaning of the Federal Waste Generator Code usedchar(2)0.75Complete only
Federal Waste Generator Code (#2)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)0.75Complete only
State Waste Gen. Code Owner (#2)The agency that determined the meaning of the State Waste Generator code usedchar(2)20.28Complete only
State Waste Generator Code (#2)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)23.31Complete only
State Waste Generation (#2)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)20.28High through Complete
Short Term Generator Activity (#2)Indicates whether the handler's generator status is determined from a short-term or one-time event and not from ongoing processes.char(1)0.00High through Complete
Subpart K College (#2)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible college or university.char(1)74.17High through Complete
Subpart K Hospital (#2)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible teaching hospital.char(1)74.17High through Complete
Subpart K Nonprofit (#2)Indicates whether the handler is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible nonprofit research institute.char(1)74.17High through Complete
Subpart K Withdrawal (#2)Indicates whether the handler is withdrawing from managing laboratory hazardous waste under 40 CFR 262 Subpart K.char(1)74.17High through Complete
Permit Contact First Name (#2)First name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.35High through Complete
Permit Contact Middle Initial (#2)Middle initial of the person who is familiar with the handler's Hazardous Waste Permit informationchar(1)89.76High through Complete
Permit Contact Last Name (#2)Last name of the person who is familiar with the handler's Hazardous Waste Permit informationvarchar(15)77.39High through Complete
Permit Contact Street Number (#2)The street number from the permit contact street address.varchar(12)89.26High through Complete
Permit Contact Street 1 (#2)First line of the street address (or the post office box number) for the permit contact.varchar(30)78.66High through Complete
Permit Contact Street 2 (#2)Second line (as needed) of the street address for the permit contact.varchar(30)98.65High through Complete
Permit Contact City (#2)The city or town of the permit contact address.varchar(25)78.52High through Complete
Permit Contact State (#2)State code of the permit contact address.char(2)78.47High through Complete
Permit Contact Zip Code (#2)Zip code of the permit contact address.varchar(14)78.52High through Complete
Permit Contact Country (#2)Country code of the permit contact address.char(2)54.92High through Complete
Permit Contact Phone (#2)Telephone number associated with the permit contact.varchar(15)77.44High through Complete
Permit Contact Phone Extension (#2)Telephone number extension associated with the permit contact.varchar(6)97.56High through Complete
Permit Contact Email (#2)Email address associated with the permit contactvarchar(80)88.36High through Complete
Permit Contact Title (#2)Title of the permit contact personvarchar(45)26.90High through Complete
Transfer Facility (Yes/No) (#2)Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc.char(1)0.05High through Complete
Reason for Notification (#1)Indicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00High through Complete
HSM Effective Date (#1)Date on which the facility either started or stopped managing hazardous secondary material.varchar(8)0.00High through Complete
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)32.42High through Complete
Number of HSM Activity Records (#1)The number of HSM activity records for this HSM basic record.int(11)0.55High through Complete
Reason for Notification (#2)Indicates whether the facility will begin, is still managing, or has stopped managing hazardous secondary material.char(1)0.00High through Complete
HSM Effective Date (#2)Date on which the facility either started or stopped managing hazardous secondary material.varchar(8)0.00High through Complete
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)32.42High through Complete
Number of HSM Activity Records (#2)The number of HSM activity records for this HSM basic record.int(11)0.55High through Complete
Area Sequence Number (#1)Code used to uniquely designate a corrective action areachar(4)0.00Complete only
Corrective Action Area (#1)Name or number assigned to identify a corrective action areavarchar(40)0.00High through Complete
Facility-wide Corrective Action (Yes/No) (#1)Indicates whether the corrective action applies to the entire facilitychar(1)0.00High through Complete
Regulated Unit (Yes/No) (#1)Indicates whether the corrective action applies to a regulated unit at the handlerchar(1)82.70High through Complete
Air Release Indicator (#1)Indicates that there has been a release to air (either within or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas.char(1)89.86High through Complete
Groundwater Release Indicator (#1)Indicates that there has been a release to groundwater from the unit/area.char(1)67.71High through Complete
Soil Release Indicator (#1)Indicates that there has been a release to soil (either within or beyond the facility boundary) from the unit/area. This may include subsoil contamination beneath the unit/area.char(1)59.05High through Complete
Surface Water Release Indicator (#1)Indicates that there has been a release to surface water (either within or beyond the facility boundary) from the unit/area.char(1)84.62High through Complete
EPA Responsible Person ID Owner (#1)The EPA region that determined the meaning of the EPA person ID code used.char(2)93.37High through Complete
EPA Responsible Person ID (#1)The EPA person currently responsible for overseeing the corrective action area.varchar(5)93.37High through Complete
State Responsible Person ID Owner (#1)The state that determined the meaning of the state person ID code used.char(2)73.11High through Complete
State Responsible Person ID (#1)The state person currently responsible for overseeing the corrective action area.varchar(5)73.11High through Complete
Number of Area-Event Links (#1)The number of area-event links for this corrective action areaint(11)10.39Complete only
Area Sequence Number (#2)Code used to uniquely designate a corrective action areachar(4)0.00Complete only
Corrective Action Area (#2)Name or number assigned to identify a corrective action areavarchar(40)0.00High through Complete
Facility-wide Corrective Action (Yes/No) (#2)Indicates whether the corrective action applies to the entire facilitychar(1)0.00High through Complete
Regulated Unit (Yes/No) (#2)Indicates whether the corrective action applies to a regulated unit at the handlerchar(1)82.70High through Complete
Air Release Indicator (#2)Indicates that there has been a release to air (either within or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas.char(1)89.86High through Complete
Groundwater Release Indicator (#2)Indicates that there has been a release to groundwater from the unit/area.char(1)67.71High through Complete
Soil Release Indicator (#2)Indicates that there has been a release to soil (either within or beyond the facility boundary) from the unit/area. This may include subsoil contamination beneath the unit/area.char(1)59.05High through Complete
Surface Water Release Indicator (#2)Indicates that there has been a release to surface water (either within or beyond the facility boundary) from the unit/area.char(1)84.62High through Complete
EPA Responsible Person ID Owner (#2)The EPA region that determined the meaning of the EPA person ID code used.char(2)93.37High through Complete
EPA Responsible Person ID (#2)The EPA person currently responsible for overseeing the corrective action area.varchar(5)93.37High through Complete
State Responsible Person ID Owner (#2)The state that determined the meaning of the state person ID code used.char(2)73.11High through Complete
State Responsible Person ID (#2)The state person currently responsible for overseeing the corrective action area.varchar(5)73.11High through Complete
Number of Area-Event Links (#2)The number of area-event links for this corrective action areaint(11)10.39Complete only
Area Sequence Number (#3)Code used to uniquely designate a corrective action areachar(4)0.00Complete only
Corrective Action Area (#3)Name or number assigned to identify a corrective action areavarchar(40)0.00High through Complete
Facility-wide Corrective Action (Yes/No) (#3)Indicates whether the corrective action applies to the entire facilitychar(1)0.00High through Complete
Regulated Unit (Yes/No) (#3)Indicates whether the corrective action applies to a regulated unit at the handlerchar(1)82.70High through Complete
Air Release Indicator (#3)Indicates that there has been a release to air (either within or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas.char(1)89.86High through Complete
Groundwater Release Indicator (#3)Indicates that there has been a release to groundwater from the unit/area.char(1)67.71High through Complete
Soil Release Indicator (#3)Indicates that there has been a release to soil (either within or beyond the facility boundary) from the unit/area. This may include subsoil contamination beneath the unit/area.char(1)59.05High through Complete
Surface Water Release Indicator (#3)Indicates that there has been a release to surface water (either within or beyond the facility boundary) from the unit/area.char(1)84.62High through Complete
EPA Responsible Person ID Owner (#3)The EPA region that determined the meaning of the EPA person ID code used.char(2)93.37High through Complete
EPA Responsible Person ID (#3)The EPA person currently responsible for overseeing the corrective action area.varchar(5)93.37High through Complete
State Responsible Person ID Owner (#3)The state that determined the meaning of the state person ID code used.char(2)73.11High through Complete
State Responsible Person ID (#3)The state person currently responsible for overseeing the corrective action area.varchar(5)73.11High through Complete
Number of Area-Event Links (#3)The number of area-event links for this corrective action areaint(11)10.39Complete only
Event Sequence Number (#1)ID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event Date (#1)The date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible Agency (#1)The agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code Owner (#1)The agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type (#1)A code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event Date (#1)The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event Date (#1)Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event Date (#1)The best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID Owner (#1)The agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person ID (#1)An ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code Owner (#1)The agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State Suborganization (#1)Name or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event Type (#1)A code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event Links (#1)The number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority Links (#1)The number of event-authority links for this corrective action eventint(11)11.51Complete only
Event Sequence Number (#2)ID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity Location (#2)The location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event Date (#2)The date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible Agency (#2)The agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code Owner (#2)The agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type (#2)A code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event Date (#2)The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event Date (#2)Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event Date (#2)The best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID Owner (#2)The agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person ID (#2)An ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code Owner (#2)The agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State Suborganization (#2)Name or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event Type (#2)A code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event Links (#2)The number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority Links (#2)The number of event-authority links for this corrective action eventint(11)11.51Complete only
Event Sequence Number (#3)ID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity Location (#3)The location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event Date (#3)The date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible Agency (#3)The agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code Owner (#3)The agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type (#3)A code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event Date (#3)The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event Date (#3)Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event Date (#3)The best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID Owner (#3)The agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person ID (#3)An ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code Owner (#3)The agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State Suborganization (#3)Name or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event Type (#3)A code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event Links (#3)The number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority Links (#3)The number of event-authority links for this corrective action eventint(11)11.51Complete only
Event Sequence Number (#4)ID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity Location (#4)The location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event Date (#4)The date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible Agency (#4)The agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code Owner (#4)The agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type (#4)A code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event Date (#4)The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event Date (#4)Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event Date (#4)The best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID Owner (#4)The agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person ID (#4)An ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code Owner (#4)The agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State Suborganization (#4)Name or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event Type (#4)A code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event Links (#4)The number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority Links (#4)The number of event-authority links for this corrective action eventint(11)11.51Complete only
Event Sequence Number (#5)ID number used to identify a corrective action eventchar(3)0.00Complete only
Event Activity Location (#5)The location, in the form of a state postal code, of the agency regulating the corrective action eventchar(2)0.00Complete only
Actual Event Date (#5)The date on which actual completion of a corrective action event occureddate2.07Complete only
Event Responsible Agency (#5)The agency responsible for overseeing a corrective action eventchar(1)0.00Complete only
Event Type Code Owner (#5)The agency that determined the meaning of the event code usedchar(2)0.00Complete only
Event Type (#5)A code for the type of corrective action eventchar(7)0.00Complete only
Original Scheduled Event Date (#5)The original scheduled completion date for an event. This date cannot be changed once entered. Slippage of the scheduled completion date is recorded in the New Scheduled Event Date field.date90.13Complete only
New Scheduled Event Date (#5)Revised scheduled completion date of the corrective action event. This date is used in conjunction with the Original Scheduled Event Date to allow tracking scheduled date slippage.date99.57Complete only
Best Event Date (#5)The best date for determining the occurrence of the actual completion of the corrective action event.date0.03Complete only
Event Responsible Person ID Owner (#5)The agency that determined the meaning of the responsible person ID.char(2)20.09Complete only
Event Responsible Person ID (#5)An ID for the responsible person for the event.varchar(5)20.09Complete only
State Suborganization Code Owner (#5)The agency that determined the meaning of the state suborganization code.char(2)33.22Complete only
State Suborganization (#5)Name or abbreviation of a state division/section (suborganization).varchar(10)100.00Complete only
Event Type (#5)A code for the type of corrective action event (code combined with code owner).varchar(9)0.00Complete only
Number of Area-Event Links (#5)The number of area-event links for this corrective action eventint(11)3.70Complete only
Number of Event-Authority Links (#5)The number of event-authority links for this corrective action eventint(11)11.51Complete only
Effective Date (#1)Date on which a permit modification, unilateral order, consent decree, or appeal becomes effectivedate0.00High through Complete
Authority Responsible Agency (#1)Code for the agency that originated and oversees a permit, permit modification, or orderchar(1)0.00High through Complete
Issuance Date (#1)The date on which an agency official signs the order, permit, or permit modificationdate38.35High through Complete
Revokation Date (#1)The date on which the corrective action authority is revokeddate97.37High through Complete
Repository Status (#1)Code giving the status of an information repository near the facility for the purpose of making documents availablechar(1)91.98High through Complete
Authority Activity Location (#1)The location, in the form of a state postal code, of the agency regulating the activitychar(2)0.00High through Complete
Authority Type Code Owner (#1)The agency that determined the meaning of the authority type code usedchar(2)0.00Complete only
Authority Type (#1)A code for the type of authoritychar(1)0.00High through Complete
Responsible Person ID Owner (#1)The agency that determined the meaning of the responsible person ID used.char(2)29.49Complete only
Responsible Person ID (#1)ID for the person responsible for overseeing the activities undertaken by the authority.varchar(5)29.50High through Complete
State Suborganization Owner (#1)The agency that detemined the meaning of the state suborganization code.char(2)62.02Complete only
State Suborganization (#1)Name or abbreviation of a state division/section (suborganization).varchar(10)62.02High through Complete
Number of Citation Records (#1)The number of citation records for this authority.int(11)0.84Complete only
Number of Event-Authority Links (#1)The number of event-authority links for this authorityint(11)4.66Complete only
Event Responsible Person ID (#1)The ID of the person currently responsible for the event.char(5)34.19High through Complete