|
|
For general help with the RCRIS database, try the top section of the help associated with the search forms.
RCRIS was last updated on RTK NET with a set of EPA data made on July 21, 2004.
If you have any questions, comments, or found any bugs in these reports please either send RTK NET mail to rtkhelp@rtknet.org or call us at 202-234-8494.
Delimited reports produce data that can be loaded into a database or spreadsheet program. (You can choose a delimited report by selecting "comma delimited" or "tab delimited" under Type of Report Output.) To use the output of a delimited report, first save it as a text file, either from your Web browser or your Email client. Depending on the program that you are loading it into, you may then need to edit it to remove everything above the line of column headers. (There should also be an "*END OF REPORT*" marker after the data, which you may or may not need to edit out.) Then you should be able to load the delimited data.
Note that some of the sets of data fields repeat. The column headers for these repeating sections will have numbers after them in parenthesis, e.g. (#1).
The Summary level of detail produces minimal information for each incident. If you use text style output on the Web (as opposed to Email delivery), then the line for each incident will include a link to a High detail report on that incident, making the report output a "list of hits".
The fields in a Summary report for RCRIS are as follows:
| Data Field | Description | Field Type |
| Handler Name | The name of the handler (facility) that this information was submitted for | varchar(40) |
| State | State postal abbreviation for state in which the handler is located | char(2) |
| Gen. | Federal waste generation status of the handler. Use the "About the Data" button for meanings of the abbreviations used. | varchar(25) |
| TSD | Indicates whether the handler is an active TSD (treatment, storage, or disposal site) | char(1) |
| Current Viol. | The number of current violations for the handler | integer |
| All Penalties | The total dollar amount of all prior, current, and proposed penalties assessed to the handler | decimal(12) |
| Data Field | Description | Field Type | % blank | Level of Detail |
| Handler ID | Unique EPA ID number assigned by a state or EPA Region to each RCRA site (i.e. each generator, transporter, or TSD). The first two characters are the postal code for the state in which the handler is located. | char(12) | 0 | All |
| EPA Facility ID | EPA FINDS ID that is supposed to uniquely identify a facility across different EPA data systems | varchar(12) | 95.12 | All |
| Handler Name | The official or legal name of the handler. A "handler" is like a facility, though it also includes transporters who transport waste from one place to another. | varchar(40) | 0 | All |
| EPA Region | The two-digit code for the EPA Region in which the handler is located | char(2) | 0 | Complete only |
| State | The state postal code for the state in which the handler is located | char(2) | 0 | All |
| Number of Current Violations | The number of violation records that do not have a date on which the violation came into compliance | integer | 98.68 | All |
| Number of Violations | The number of violation records for this handler | integer | 86.85 | All |
| Proposed Penalty Total | The total dollar amount of proposed penalties for this handler | decimal(12) | 98.51 | All |
| Final Penalty Total | The total dollar amount of final assessed monetary penalties for this handler | decimal(12) | 98.05 | All |
| SEP Penalty Total | The total dollar amount of both costs and credits associated with SEPs (supplemental environmental projects) undertaken in liu of penalties | decimal(12) | 99.9 | All |
| Penalty Total | The total dollar amount of final monetary penalties, proposed monetary penalties, and SEP costs and credits | decimal(12) | 97.83 | All |
| First Info. Receipt Date | The first date on which information was received for this handler | date | 0.06817 | All |
| Last Info. Receipt Date | The last date on which information was received for this handler | date | 0.06817 | All |
| Number of CA Area Records | The number of corrective action area records for this handler | integer | 98.87 | Medium, High or Complete |
| Number of CA Events | The number of corrective action event records for this handler | integer | 98.9 | Medium, High or Complete |
| Number of CA Authorities | The number of corrective action authority records for this handler | integer | 99.34 | Medium, High or Complete |
| Number of Evaluations | The number of compliance evaluation records for this handler | integer | 73.64 | Medium, High or Complete |
| Number of Enforcements | The number of enforcement records for this handler | integer | 88.2 | Medium, High or Complete |
| Number of Information Records | The number of handler information (aka hhandler2) records for this handler | integer | 0.06817 | Medium, High or Complete |
| Number of Previous IDs | The number of previous ID records for this handler | integer | 99.62 | Medium, High or Complete |
| Number of Current Information Records | The number of current information (aka report universe) records for this handler | integer | 0.002468 | Medium, High or Complete |
| Number of Permit Series | The number of permit series records for this handler | integer | 98.09 | Medium, High or Complete |
| Number of Process Units | The number of process unit records for this handler | integer | 98.42 | Medium, High or Complete |
| Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | All |
| Site Name (#1) | the legal name of the site | varchar(40) | 0.0692 | All |
| NAICS Code 1 (#1) | First NAICS industry code for the site | char(6) | 71.24 | All |
| NAICS Code 2 (#1) | Second NAICS industry code for the site | varchar(6) | 96.12 | Medium, High or Complete |
| NAICS Code 3 (#1) | Third NAICS industry code for the site | varchar(6) | 98.86 | Medium, High or Complete |
| NAICS Code 4 (#1) | Fourth NAICS industry code for the site | varchar(6) | 99.61 | Medium, High or Complete |
| Owner Name (#1) | Name of the current owner of the site | varchar(40) | 16.65 | All |
| Operator Name (#1) | Name of the current operator of the site | varchar(40) | 65.89 | Medium, High or Complete |
| Location Street Number (#1) | Street number from the physical address of the primary site entrance | varchar(12) | 59.08 | All |
| Location Street 1 (#1) | First line of the street address from the physical address of the primary site entrance | varchar(30) | 0.0732 | All |
| Location Street 2 (#1) | Second line of the street address from the physical address of the primary site entrance | varchar(30) | 97 | All |
| Location City (#1) | Name of the city or town in which the handler is physically located | varchar(25) | 0.06981 | All |
| Location State (#1) | The state postal abbreviation for the U.S. State in which the handler is physically located | char(2) | 0.06935 | All |
| Location Zip Code (#1) | The ZIP code from the physical address of the primary site entrance | varchar(14) | 0.09042 | All |
| County Code (#1) | Code for the county that the site is in (state postal abbreviation plus county FIPS code) | char(5) | 0.2061 | Complete only |
| County (#1) | The county in which the site is located | varchar(27) | 0.227 | High or Complete only |
| Mailing Street Number (#1) | The street number from the primary business mailing address for the handler | varchar(12) | 65.84 | High or Complete only |
| Mailing Street 1 (#1) | The first line of the street address for the primary mailing address for the handler | varchar(30) | 0.4469 | High or Complete only |
| Mailing Street 2 (#1) | The second line of the street address for the primary mailing address for the handler | varchar(30) | 97.4 | High or Complete only |
| Mailing City (#1) | The city or town from the primary mailing address for the handler | varchar(25) | 0.4459 | High or Complete only |
| Mailing State (#1) | The psotal state abbreviation for the state in the primary mailing address for the handler | char(2) | 0.4523 | High or Complete only |
| Mailing Zip Code (#1) | The Zip code in the primary mailing address for the handler | varchar(14) | 0.5056 | High or Complete only |
| Mailing Country (#1) | The country code in the primary mailing address for the handler | char(2) | 78.8 | High or Complete only |
| Contact Name (#1) | The name of the contact person for the handler | varchar(33) | 15.63 | Medium, High or Complete |
| Contact Street 1 (#1) | The first line of the street address of the contact person for the handler | varchar(30) | 18.05 | High or Complete only |
| Contact Street 2 (#1) | The second line of the street address of the contact person for the handler | varchar(30) | 98.24 | High or Complete only |
| Contact City (#1) | The city or town from the address of the primary contact person for the site | varchar(25) | 18.05 | High or Complete only |
| Contact State (#1) | The state postal abbreviation from the address of the primary contact person for the site | char(2) | 18.02 | High or Complete only |
| Contact Zip Code (#1) | The Zip code from the address of the primary contact person for the site | varchar(14) | 18.05 | High or Complete only |
| Contact Country (#1) | The country code from the address of the primary contact person for the site | char(2) | 23.12 | High or Complete only |
| Contact Phone (#1) | The telephone number of the primary contact person for the site | varchar(22) | 16.37 | High or Complete only |
| Receive Date (#1) | Date that the form of information was received from the handler by the appropraite authority | date | 0.181 | Medium, High or Complete |
| Source Type (#1) | A code indicating the source of data for this information record | char(1) | 0.06812 | High or Complete only |
| Sequence Number (#1) | A sequence number used to uniquely identify each information source record | integer | 0.181 | Complete only |
| Extract Flag (#1) | An X indicates that the data are available for extract for public use | char(1) | 1.179 | Complete only |
| Latitude (#1) | The latititude of the site in decimal degrees | decimal(10,6) | 95.03 | Medium, High or Complete |
| Longitude (#1) | The longitude of the site in decimal degrees | decimal(11,6) | 95.03 | Medium, High or Complete |
| EPA Region (#1) | The two-digit code for the EPA Region in which the handler is located | char(2) | 0 | Complete only |
| State District (#1) | Indicates the state-designated legislative district(s) in which the site is located | char(10) | 47.6 | Complete 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 authority | char(1) | 97.61 | Medium, High or 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.96 | Medium, High or Complete |
| Federal Waste Generation (#1) | A code for the type of Federally classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 3.951 | All |
| State Waste Generation (#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) | 47.93 | All |
| Transporter Activity (Yes/No) (#1) | Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or water | char(1) | 0.181 | All |
| Operating TSDF Universe (#1) | Indicates whether handler has an operating Treatment, Storage, or Disposal unit. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment. | varchar(5) | 0.01092 | All |
| Full Enforcement Universe (#1) | Indicates whether handler is a TSDF that could potentially undergo a Compliance and Evaluation Inspection (CEI). Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, and (T)reatment. | varchar(5) | 0.0123 | Medium, High or Complete |
| Radioactive Waste (Yes/No) (#1) | Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product material | char(1) | 8.682 | All |
| Recycler Activity (Yes/No) (#1) | Indicates whether the handler recycles hazardous waste | char(1) | 0.181 | Medium, High or Complete |
| Underground Injection (Yes/No) (#1) | Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface well | char(1) | 6.218 | High or Complete only |
| Importer Activity (Yes/No) (#1) | Indicates whether the facility imports hazardous waste into the U.S. from a foreign country | char(1) | 8.682 | High or Complete only |
| Universal Waste Destination (Yes/No) (#1) | Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste. | char(1) | 8.711 | High or Complete only |
| Used Oil Universe (#1) | Concatenation of seven Yes/No data fields indicating used oil activity | varchar(7) | 0.181 | High or Complete only |
| In SNC (Yes/No) (#1) | Indicates whether the handler is currently in Significant Non-Compliance (SNC) | char(1) | 0 | All |
| Beginning of Year SNC (Yes/No) (#1) | Indicates whether handler was in Significant Non-Compliance (SNC) at the beginning of the year | char(1) | 0.8395 | High or Complete only |
| Permit Workload Universe (#1) | Indicates whether handler is a facility with units that are in the permit pipeline or that has units with active permits. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.01107 | High or Complete only |
| Post-Closure Workload Universe (#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(5) | 0.001999 | High or Complete only |
| Corrective Action Workload Universe (#1) | Indicates whether the handler has a unit undergoing corrective action acitvities. | char(1) | 0.01322 | High or Complete only |
| 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, 1997 | char(1) | 0.04905 | Complete only |
| GPRA Post-Closure Universe (#1) | Indicates whether handler is a Land Disposal facility that had at least one land disposal unit that ceased operating before October 1, 1997 and had not yet clean closed | char(1) | 0.04905 | Complete only |
| GPRA Corrective Action Universe (#1) | Indicates whether the handler is one of the 1997 baseline list of facilities that are the highest priority for the Corrective Action program | char(1) | 0.04905 | Complete only |
| GPRA CME Universe (#1) | Identifies facilities (TSD, LQG, and SQG) that are actively managing hazardous waste and are a priority for the Enforcement program. Updated at the beginning of each fiscal year. | char(1) | 0.8395 | Complete only |
| Permit Progress Universe (#1) | Indicates whether the handler is a facility with units in the Permit, Closure, or Post-Closure Workload Universes. Seperate characters indicates (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.01553 | Complete only |
| Closure Workload Universe (#1) | Indicates whether the handler is a facility with units that are closing. Does not include units that are clean closed or post-closure. Seperate characters indicate (L)and Disposal, (I)ncineration, (B)IF, (S)torage, or (T)reatment. | varchar(5) | 0.002922 | High or Complete only |
| Subject to CA Universe (#1) | Indicates whether the handler is potentially subject to corrective action | char(1) | 0.01369 | Complete 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.0123 | Complete only |
| TSDF Subject CA Discretionary (#1) | Indicates whether the handler is a TSD facility that is only subject to corrective action under discretionary authorities | char(1) | 0.0009226 | Complete only |
| Non TSDF Under CA (#1) | Indicates whether the handler is a non TSD facility where corrective action has been imposed | char(1) | 0.004921 | Complete only |
| In Handler Universe (#1) | Indicates whether the site belongs to at least one of the handler universes | char(1) | 0 | Complete 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.181 | Complete only |
| Burner Exemption (Yes/No) (#1) | Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemption | char(1) | 5.041 | High or Complete only |
| Furnace Exemption (Yes/No) (#1) | Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemption | char(1) | 5.041 | High or Complete only |
| Second ID (#1) | A number that may be assigned by a state to identify a handler | varchar(12) | 88.22 | High or Complete only |
| Biennial Report Year (#1) | The year of the biennial reporting data from which this information record is taken | integer | 97.15 | Complete only |
| In CME Universes (#1) | Obsolete field, no longer used | char(1) | 100 | Complete only |
| Date of Last Change (#1) | Date of the last change in the handler information records | date | 0.181 | Complete only |
| Owner Type (#1) | A code describing the type of current owner | char(1) | 18.43 | Complete only |
| Operator Type (#1) | A code describing the type of current operator | char(1) | 67.49 | Complete only |
| Owner Sequence Number (#1) | The sequence number of the current owner within the owner and operator data table | integer | 16.59 | Complete only |
| Operator Sequence Number (#1) | The sequence number of the current operator within the owner and operator data table | integer | 65.91 | Complete only |
| Number of Owners (#1) | The number of owner records within the owner and operator data table | integer | 17.56 | Complete only |
| Number of Operators (#1) | The number of operator records within the owner and operator data table | integer | 70.19 | Complete only |
| Owner Operator Hierarchy (#1) | Contains the owner type, or the operator type if the owner type is null. Only one character long. | char(2) | 17.83 | Complete only |
| In A Universe (#1) | Indicates that the site is in one of the universes | char(1) | 0 | Complete only |
| Mixed Source (Yes/No) (#1) | Indicates that this data record was taken from more than one h_handler information record | char(1) | 0.001076 | Complete only |
| Mixed Source Type (#1) | The value of the source type code for the handler information record that was one of the two (probably the latest one) used to create this data record | char(1) | 97.7 | Complete only |
| Mixed Source Sequence Number (#1) | The sequence number of the handler information record that was one of the two (probably the latest one) used to create this data record | integer | 97.7 | Complete only |
| Federal Waste Gen. Code Owner (#1) | The agency that determined the meaning of the Federal Waste Generator Code used | char(2) | 7.414 | Complete 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) | 5.391 | Complete only |
| State Waste Gen. Code Owner (#1) | The agency that determined the meaning of the State Waste Generator code used | char(2) | 47.95 | Complete 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) | 49.41 | Complete only |
| Post-Closure Workload Land Disposal | Indicates whether the handler has a land disposal unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Incinerator | Indicates whether the handler has an incinerator unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the post-closure universe | char(1) | 0 | Complete only |
| Post-Closure Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the post-closure universe | char(1) | 0 | Complete only |
| Permit Progress Land Disposal | Indicates whether the handler has a land disposal unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Incinerator | Indicates whether the handler has an incinerator unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Storage | Indicates whether the handler has a hazardous waste storage unit in the permit progress universe | char(1) | 0 | Complete only |
| Permit Progress Treatment | Indicates whether the handler has a hazardous waste treatment unit in the permit progress universe | char(1) | 0 | Complete only |
| Closure Workload Land Disposal | Indicates whether the handler has a land disposal unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Incinerator | Indicates whether the handler has an incinerator unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the closure universe | char(1) | 0 | Complete only |
| Closure Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the closure universe | char(1) | 0 | Complete only |
| Permit Workload Land Disposal | Indicates whether the handler has a land disposal unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Incinerator | Indicates whether the handler has an incinerator unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Storage | Indicates whether the handler has a hazardous waste storage unit in the permit workload universe | char(1) | 0 | Complete only |
| Permit Workload Treatment | Indicates whether the handler has a hazardous waste treatment unit in the permit workload universe | char(1) | 0 | Complete only |
| Full Enforcement Land Disposal | Indicates whether the handler has a land disposal unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Incinerator | Indicates whether the handler has an incinerator unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Storage | Indicates whether the handler has a hazardous waste storage unit in the full enforcement universe | char(1) | 0 | Complete only |
| Full Enforcement Treatment | Indicates whether the handler has a hazardous waste treatment unit in the full enforcement universe | char(1) | 0 | Complete only |
| Operating TSDF Land Disposal | Indicates whether the handler has a land disposal unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Incinerator | Indicates whether the handler has an incinerator unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF BIF | Indicates whether the handler has a boiler or industrial furnace (BIF) unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Storage | Indicates whether the handler has a hazardous waste storage unit in the operating TSD universe | char(1) | 0 | Complete only |
| Operating TSDF Treatment | Indicates whether the handler has a hazardous waste treatment unit in the operating TSD universe | char(1) | 0 | Complete only |
| Used Oil Transporter (Yes/No) | Indicates whether the site transports or collects and transports used oil | char(1) | 0.5915 | Complete only |
| Used Oil Transfer Facility (Yes/No) | Indicates whether the site acts as a transfer facility for used oil (holds used oil for shipment for more than 1 and less than 35 days) | char(1) | 0.5915 | Complete only |
| Used Oil Processor (Yes/No) | Indicates whether the site processes used oil | char(1) | 0.5915 | Complete only |
| Used Oil Refiner (Yes/No) | Indicates whether the site refines used oil | char(1) | 0.5915 | Complete only |
| Used Oil Fuel Burner (Yes/No) | Indicates whether the site burns off-specification used oil for energy recovery | char(1) | 7.015 | Complete only |
| Used Oil Marketer (Yes/No) | Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burners | char(1) | 7.015 | Complete only |
| Used Oil Specification Cert. (Yes/No) | Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specification | char(1) | 7.015 | Complete only |
| Evaluation Activity Location (#1) | The location, in the form of a state postal code, of the agency conducting the evaluation | char(2) | 0 | Complete only |
| Evaluation Sequence Number (#1) | Name or number assigned to identify an evaluation | char(3) | 0 | Complete only |
| Evaluation Date (#1) | The first day of the evaluation (inspection or record review) | date | 0 | Medium, High or Complete |
| Evaluation Responsible Agency (#1) | The agency responsible for conducting the evaluation | char(1) | 0 | Medium, High or Complete |
| Evaluation Type Code Owner (#1) | The agency that determined the meaning of the evaluation type code used | char(2) | 0 | Complete only |
| 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.5847 | Complete only |
| Evaluation Type (#1) | A code for the type of evaluation (combined with the determining agency code for a single code lookup) | char(5) | 0 | Medium, High or Complete |
| Number of Evaluation-Violation Links (#1) | The number of evaluation-violation links for this evaluation | integer | 61.87 | Medium, High or Complete |
| Number of Evaluation Areas (#1) | The number of evaluation areas for this evaluation | integer | 49.15 | Complete only |
| Evaluation Activity Location (#2) | The location, in the form of a state postal code, of the agency conducting the evaluation | char(2) | 0 | Complete only |
| Evaluation Sequence Number (#2) | Name or number assigned to identify an evaluation | char(3) | 0 | Complete only |
| Evaluation Date (#2) | The first day of the evaluation (inspection or record review) | date | 0 | Medium, High or Complete |
| Evaluation Responsible Agency (#2) | The agency responsible for conducting the evaluation | char(1) | 0 | Medium, High or Complete |
| Evaluation Type Code Owner (#2) | The agency that determined the meaning of the evaluation type code used | char(2) | 0 | Complete only |
| 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.5847 | Complete only |
| Evaluation Type (#2) | A code for the type of evaluation (combined with the determining agency code for a single code lookup) | char(5) | 0 | Medium, High or Complete |
| Number of Evaluation-Violation Links (#2) | The number of evaluation-violation links for this evaluation | integer | 61.87 | Medium, High or Complete |
| Number of Evaluation Areas (#2) | The number of evaluation areas for this evaluation | integer | 49.15 | Complete only |
| Evaluation Activity Location (#3) | The location, in the form of a state postal code, of the agency conducting the evaluation | char(2) | 0 | Complete only |
| Evaluation Sequence Number (#3) | Name or number assigned to identify an evaluation | char(3) | 0 | Complete only |
| Evaluation Date (#3) | The first day of the evaluation (inspection or record review) | date | 0 | Medium, High or Complete |
| Evaluation Responsible Agency (#3) | The agency responsible for conducting the evaluation | char(1) | 0 | Medium, High or Complete |
| Evaluation Type Code Owner (#3) | The agency that determined the meaning of the evaluation type code used | char(2) | 0 | Complete only |
| 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.5847 | Complete only |
| Evaluation Type (#3) | A code for the type of evaluation (combined with the determining agency code for a single code lookup) | char(5) | 0 | Medium, High or Complete |
| Number of Evaluation-Violation Links (#3) | The number of evaluation-violation links for this evaluation | integer | 61.87 | Medium, High or Complete |
| Number of Evaluation Areas (#3) | The number of evaluation areas for this evaluation | integer | 49.15 | Complete only |
| Violation Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#1) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#1) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#1) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#1) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#1) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#1) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#1) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#1) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#1) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#1) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#1) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#2) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#2) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#2) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#2) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#2) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#2) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#2) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#2) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#2) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#2) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#2) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#2) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#3) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#3) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#3) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#3) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#3) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#3) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#3) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#3) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#3) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#3) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#3) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#3) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#4) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#4) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#4) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#4) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#4) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#4) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#4) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#4) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#4) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#4) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#4) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#4) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#5) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#5) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#5) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#5) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#5) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#5) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#5) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#5) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#5) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#5) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#5) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#5) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#6) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#6) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#6) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#6) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#6) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#6) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#6) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#6) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#6) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#6) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#6) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#6) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#7) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#7) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#7) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#7) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#7) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#7) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#7) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#7) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#7) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#7) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#7) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#7) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#8) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#8) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#8) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#8) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#8) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#8) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#8) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#8) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#8) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#8) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#8) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#8) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#9) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#9) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#9) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#9) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#9) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#9) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#9) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#9) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#9) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#9) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#9) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#9) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Violation Activity Location (#10) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Violation Sequence Number (#10) | Unique number used to identify each violation | char(4) | 0 | Complete only |
| Agency Which Determined Violation (#10) | The agency that actually determined the violation | char(1) | 0 | All |
| Date Violation Determined (#10) | The date on which a determination was made that the violation exists | date | 0 | All |
| Violation Area (#10) | A code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Citation (#10) | Citation from Federal or state regulations or statutes that specifies a violation or pending violation | varchar(30) | 35.52 | All |
| Compliance Date (#10) | The date on which the agency determines that the handler has demonstrated full physical compliance | date | 7.238 | All |
| Violation Responsible Agency (#10) | The agency responsible for determining the violation | char(1) | 0 | Complete only |
| Violation Area Code Owner (#10) | The agency that determined the meaning of the violation area code used | char(2) | 0 | Complete only |
| Violation Area Code (#10) | Code to indicate the specific monitoring requirements area of a handler that is in violation of RCRA regulations or statutes. It is meaningless without also consulting the determining agency code owner field. | char(3) | 0 | Complete only |
| Number of Evaluation-Violation Links (#10) | The number of evaluation-violation links for this violation | integer | 0.1133 | Complete only |
| Number of Enforcement-Violation Links (#10) | The number of enforcement-violation links for this violation | integer | 13.28 | All |
| Enforcement Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Enforcement Sequence Number (#1) | Name or number assigned to uniquely identify an enforcement | char(3) | 0 | Complete only |
| Enforcement Action Date (#1) | The date on which the enforcement action was issued | date | 0 | All |
| Enforcement Responsible Agency (#1) | The agency responsible for issuing the enforcement action | char(1) | 0 | All |
| Enforcement Type Code Owner (#1) | The agency that determed the meaning of the enforcement type code used | char(2) | 0 | Complete only |
| 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) | 0 | Complete only |
| Enforcement Type (#1) | A code for the type of enforcement action (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Proposed Penalty Amount (#1) | The total amount of proposed penalties for this enforcement action | decimal(12) | 92.98 | All |
| Final Penalty Amount (#1) | The total amount of assessed monetary penalties for this enforcement action | decimal(12) | 91 | All |
| SEP Penalty Amount (#1) | The total dollar equivalent of work done on SEPs (supplemental environmental projects), as costs or credits, in liu of penalties | decimal(12) | 99.65 | All |
| Number of Media Records (#1) | The number of multi-media enforcement records (air, FIFRA, etc.) associated with this enforcement action | integer | 99.51 | Complete only |
| Number of SEP or Milestone records (#1) | The number of SEP (supplemental environmental project) or enforcement milestone records associated with this enforcement action | integer | 99.45 | Complete only |
| Number of Penalties (#1) | The number of penalty records associated with this enforcement action | integer | 87.69 | All |
| Number of Enforcement-Violation Links (#1) | The number of enforcement-violation links for this enforcement action | integer | 2.022 | All |
| Enforcement Activity Location (#2) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Enforcement Sequence Number (#2) | Name or number assigned to uniquely identify an enforcement | char(3) | 0 | Complete only |
| Enforcement Action Date (#2) | The date on which the enforcement action was issued | date | 0 | All |
| Enforcement Responsible Agency (#2) | The agency responsible for issuing the enforcement action | char(1) | 0 | All |
| Enforcement Type Code Owner (#2) | The agency that determed the meaning of the enforcement type code used | char(2) | 0 | Complete only |
| 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) | 0 | Complete only |
| Enforcement Type (#2) | A code for the type of enforcement action (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Proposed Penalty Amount (#2) | The total amount of proposed penalties for this enforcement action | decimal(12) | 92.98 | All |
| Final Penalty Amount (#2) | The total amount of assessed monetary penalties for this enforcement action | decimal(12) | 91 | All |
| SEP Penalty Amount (#2) | The total dollar equivalent of work done on SEPs (supplemental environmental projects), as costs or credits, in liu of penalties | decimal(12) | 99.65 | All |
| Number of Media Records (#2) | The number of multi-media enforcement records (air, FIFRA, etc.) associated with this enforcement action | integer | 99.51 | Complete only |
| Number of SEP or Milestone records (#2) | The number of SEP (supplemental environmental project) or enforcement milestone records associated with this enforcement action | integer | 99.45 | Complete only |
| Number of Penalties (#2) | The number of penalty records associated with this enforcement action | integer | 87.69 | All |
| Number of Enforcement-Violation Links (#2) | The number of enforcement-violation links for this enforcement action | integer | 2.022 | All |
| Enforcement Activity Location (#3) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Complete only |
| Enforcement Sequence Number (#3) | Name or number assigned to uniquely identify an enforcement | char(3) | 0 | Complete only |
| Enforcement Action Date (#3) | The date on which the enforcement action was issued | date | 0 | All |
| Enforcement Responsible Agency (#3) | The agency responsible for issuing the enforcement action | char(1) | 0 | All |
| Enforcement Type Code Owner (#3) | The agency that determed the meaning of the enforcement type code used | char(2) | 0 | Complete only |
| 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) | 0 | Complete only |
| Enforcement Type (#3) | A code for the type of enforcement action (combined with the determining agency code for a single code lookup) | char(5) | 0 | All |
| Proposed Penalty Amount (#3) | The total amount of proposed penalties for this enforcement action | decimal(12) | 92.98 | All |
| Final Penalty Amount (#3) | The total amount of assessed monetary penalties for this enforcement action | decimal(12) | 91 | All |
| SEP Penalty Amount (#3) | The total dollar equivalent of work done on SEPs (supplemental environmental projects), as costs or credits, in liu of penalties | decimal(12) | 99.65 | All |
| Number of Media Records (#3) | The number of multi-media enforcement records (air, FIFRA, etc.) associated with this enforcement action | integer | 99.51 | Complete only |
| Number of SEP or Milestone records (#3) | The number of SEP (supplemental environmental project) or enforcement milestone records associated with this enforcement action | integer | 99.45 | Complete only |
| Number of Penalties (#3) | The number of penalty records associated with this enforcement action | integer | 87.69 | All |
| Number of Enforcement-Violation Links (#3) | The number of enforcement-violation links for this enforcement action | integer | 2.022 | All |
| Previous Handler ID (multiple values) | A previous EPA Handler ID for the handler | char(12) | 0 | High or Complete only |
| Permit Series Sequence Number (#1) | System-generated number used to uniquely identify a permit series for a handler | char(4) | 0 | Complete only |
| Permit Series Name (#1) | Name or number assigned by an agency to identify a permit or permit application | varchar(12) | 0 | Medium, High or Complete |
| Number of Permit Events (#1) | The number of permit events associated with this permit series record | integer | 31.59 | Medium, High or Complete |
| Permit Series Sequence Number (#2) | System-generated number used to uniquely identify a permit series for a handler | char(4) | 0 | Complete only |
| Permit Series Name (#2) | Name or number assigned by an agency to identify a permit or permit application | varchar(12) | 0 | Medium, High or Complete |
| Number of Permit Events (#2) | The number of permit events associated with this permit series record | integer | 31.59 | Medium, High or Complete |
| Process Unit Sequence Number (#1) | System-generated number used to uniquely identify a process unit | char(4) | 0 | Complete only |
| Process Unit Name (#1) | Name or number assigned by an agency to identify a process unit group | varchar(18) | 0 | Medium, High or Complete |
| Number of Process Unit Details (#1) | The number of process unti detail records associated with this process unit record | integer | 0.1368 | Medium, High or Complete |
| Number of Event-Unit Links (#1) | The number of permit event-process unit links for this process unit | integer | 61.72 | Medium, High or Complete |
| Process Unit Sequence Number (#2) | System-generated number used to uniquely identify a process unit | char(4) | 0 | Complete only |
| Process Unit Name (#2) | Name or number assigned by an agency to identify a process unit group | varchar(18) | 0 | Medium, High or Complete |
| Number of Process Unit Details (#2) | The number of process unti detail records associated with this process unit record | integer | 0.1368 | Medium, High or Complete |
| Number of Event-Unit Links (#2) | The number of permit event-process unit links for this process unit | integer | 61.72 | Medium, High or Complete |
| Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | Medium, High or Complete |
| Source Type (#1) | A code indicating the source of data for this information record | char(1) | 0 | Medium, High or Complete |
| Sequence Number (#1) | A sequence number used to uniquely identify each information source record | integer | 0 | Complete only |
| Receive Date (#1) | Date that the form of information was received from the handler by the appropraite authority | date | 0 | Medium, High or Complete |
| Site Name (#1) | the legal name of the site | varchar(40) | 0.0001753 | Medium, High or 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 authority | char(1) | 98.4 | Medium, High or Complete |
| Number of Employees (#1) | The number of people actively on the payroll at the site on a permanent or semi-permanent basis | decimal(9) | 99.95 | Medium, High or Complete |
| Include in Biennial Report (Yes/No) (#1) | Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Report | char(1) | 86.11 | Medium, High or Complete |
| CDX Transaction ID (#1) | The number assigned to the site ID form submitted via the CDX system | varchar(20) | 100 | Complete only |
| Location Street Number (#1) | Street number from the physical address of the primary site entrance | varchar(12) | 63.61 | Medium, High or Complete |
| Location Street 1 (#1) | First line of the street address from the physical address of the primary site entrance | varchar(30) | 0.002718 | Medium, High or Complete |
| Location Street 2 (#1) | Second line of the street address from the physical address of the primary site entrance | varchar(30) | 96.87 | Medium, High or Complete |
| Location City (#1) | Name of the city or town in which the handler is physically located | varchar(25) | 0.0006137 | Medium, High or Complete |
| Location State (#1) | The state postal abbreviation for the U.S. State in which the handler is physically located | char(2) | 0.000263 | Medium, High or Complete |
| Location Zip Code (#1) | The ZIP code from the physical address of the primary site entrance | varchar(14) | 0.0889 | Medium, High or Complete |
| Land Type (#1) | A code indicating the current ownership status of the land on which the facility is located | char(1) | 38.06 | Medium, High or Complete |
| State District (#1) | Indicates the state-designated legislative district(s) in which the site is located | varchar(10) | 46.43 | Medium, High or Complete |
| Mailing Street Number (#1) | The street number from the primary business mailing address for the handler | varchar(12) | 70.07 | Medium, High or Complete |
| Mailing Street 1 (#1) | The first line of the street address for the primary mailing address for the handler | varchar(30) | 2.346 | Medium, High or Complete |
| Mailing Street 2 (#1) | The second line of the street address for the primary mailing address for the handler | varchar(30) | 96.58 | Medium, High or Complete |
| Mailing City (#1) | The city or town from the primary mailing address for the handler | varchar(25) | 2.348 | Medium, High or Complete |
| Mailing State (#1) | The psotal state abbreviation for the state in the primary mailing address for the handler | char(2) | 2.354 | Medium, High or Complete |
| Mailing Zip Code (#1) | The Zip code in the primary mailing address for the handler | varchar(14) | 2.463 | Medium, High or Complete |
| Mailing Country (#1) | The country code in the primary mailing address for the handler | char(2) | 81.21 | Medium, High or Complete |
| Contact First Name (#1) | The first name of the primary contact person for the site | varchar(15) | 17.81 | Medium, High or Complete |
| Contact Middle Initial (#1) | The middle initial of the primary contact person for the site | char(1) | 97.14 | Medium, High or Complete |
| Contact Last Name (#1) | the last name of the primary contact person for the site | varchar(15) | 17.79 | Medium, High or Complete |
| Contact Street Number (#1) | The street number from the address of the primary contact person for the site | varchar(12) | 97 | Medium, High or Complete |
| Contact Street 1 (#1) | The first line of the street address for the primary contact person for the site | varchar(30) | 32.79 | Medium, High or Complete |
| Contact Street 2 (#1) | The second line of the street address for the primary contact person for the site | varchar(30) | 98.6 | Medium, High or Complete |
| Contact City (#1) | The city or town from the address of the primary contact person for the site | varchar(25) | 32.79 | Medium, High or Complete |
| Contact State (#1) | The state postal abbreviation from the address of the primary contact person for the site | char(2) | 32.77 | Medium, High or Complete |
| Contact Zip Code (#1) | The Zip code from the address of the primary contact person for the site | varchar(14) | 32.79 | Medium, High or Complete |
| Contact Country (#1) | The country code from the address of the primary contact person for the site | char(2) | 38.03 | Medium, High or Complete |
| Contact Phone (#1) | The telephone number of the primary contact person for the site | varchar(15) | 18.35 | Medium, High or Complete |
| Contact Phone Ext (#1) | The telephone number extension for the primary contact person for the site | varchar(6) | 96.27 | Medium, High or Complete |
| Contact Email (#1) | The Email address of the primary contact person for the site | varchar(50) | 98.33 | Medium, High or Complete |
| Permit Contact First Name (#1) | First name of a contact person familiar with the handler's hazardous waste permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Middle Initial (#1) | Middle initial of a contact person familiar with the handler's permit | char(1) | 100 | Medium, High or Complete |
| Permit Contact Last Name (#1) | Last name of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Street Number (#1) | The street number from the address of the permit contact person for the site | varchar(12) | 100 | Medium, High or Complete |
| Permit Contact Street 1 (#1) | First line of the street address of a contact person familiar with the handler's permit | varchar(30) | 99.99 | Medium, High or Complete |
| Permit Contact Street 2 (#1) | Second line of the street address of a contact person familiar with the handler's permit | varchar(30) | 100 | Medium, High or Complete |
| Permit Contact City (#1) | City or town in the address of a contact person familiar with the handler's permit | varchar(25) | 99.99 | Medium, High or Complete |
| Permit Contact State (#1) | State postal abbreviation in the address of a contact person familiar with the handler's permit | char(2) | 99.99 | Medium, High or Complete |
| Permit Contact Zip Code (#1) | Zip code in the address of a contact person familiar with the handler's permit | varchar(14) | 99.99 | Medium, High or Complete |
| Permit Contact Country (#1) | Country code in the address of a contact person familiar with the handler's permit | char(2) | 96.15 | Medium, High or Complete |
| Permit Contact Phone (#1) | Phone number of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Phone Ext (#1) | Phone number extension of a contact person familiar with the handler's permit | varchar(6) | 100 | Medium, High or Complete |
| Permit Contact Email (#1) | Email address of a contact person familiar with the handler's permit | varchar(50) | 100 | Medium, High or Complete |
| Acknowledge Date (#1) | Date on which information was received from the handler | date | 75.74 | Complete only |
| Acknowledge Flag (#1) | A flag used to mark the handler for having an acknowledgement of receipt sent | char(1) | 96.12 | Complete only |
| Geometric Type Code (#1) | Code that represents the type of geometric entity described by a lat-long point or set of points | char(3) | 100 | Complete only |
| Horizontal Accuracy Measure (#1) | The horizontal accuracy (in meters) of the lat/long coordinates | varchar(6) | 99.16 | Complete only |
| Horizontal Collection Method (#1) | A code for the method used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Horizontal Reference Datum (#1) | A code for the reference datum used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Latitude (#1) | The latitude of the site in decimal degrees | decimal(10,6) | 96.56 | Medium, High or Complete |
| Longitude (#1) | The longitude of the site in decimal degrees | decimal(11,6) | 96.56 | Medium, High or Complete |
| Reference Point (#1) | The code for the type of place for which lat/long coordinates were established | char(3) | 100 | Complete only |
| Source Map Scale (#1) | The scale of detail on the source map used to determine lat/long coordinates for the site | decimal(10) | 99.22 | Complete only |
| Importer Activity (Yes/No) (#1) | Indicates whether the facility imports hazardous waste into the U.S. from a foreign country | char(1) | 5.955 | Medium, High or Complete |
| Radioactive Waste (Yes/No) (#1) | Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product material | char(1) | 5.955 | Medium, High or Complete |
| Recycler Activity (Yes/No) (#1) | Indicates whether the handler recycles hazardous waste | char(1) | 0 | Medium, High or Complete |
| Transporter Activity (Yes/No) (#1) | Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or water | char(1) | 0 | Medium, High or Complete |
| TSD Activity (Yes/No) (#1) | Indicates whether the handler treats, stores, or disposes of hazardous waste | char(1) | 2.576 | Medium, High or Complete |
| Underground Injection (Yes/No) (#1) | Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface well | char(1) | 9.933 | Medium, High or Complete |
| Universal Waste Destination (Yes/No) (#1) | Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste. | char(1) | 67.29 | Medium, High or Complete |
| Transfer Facility (Yes/No) (#1) | Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc. | char(1) | 3.346 | Medium, High or Complete |
| Burner Exemption (Yes/No) (#1) | Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemption | char(1) | 3.378 | Medium, High or Complete |
| Furnace Exemption (Yes/No) (#1) | Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemption | char(1) | 3.378 | Medium, High or Complete |
| Used Oil Fuel Burner (Yes/No) (#1) | Indicates whether the site burns off-specification used oil for energy recovery | char(1) | 0 | Medium, High or Complete |
| Used Oil Processor (Yes/No) (#1) | Indicates whether the site processes used oil | char(1) | 2.576 | Medium, High or Complete |
| Used Oil Refiner (Yes/No) (#1) | Indicates whether the site refines used oil | char(1) | 0 | Medium, High or Complete |
| Used Oil Marketer (Yes/No) (#1) | Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burners | char(1) | 0 | Medium, High or Complete |
| Used Oil Specification Cert. (Yes/No) (#1) | Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specification | char(1) | 0 | Medium, High or Complete |
| Used Oil Transfer Facility (Yes/No) (#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) | 2.576 | Medium, High or Complete |
| Used Oil Transporter (Yes/No) (#1) | Indicates whether the site transports or collects and transports used oil | char(1) | 2.576 | Medium, High or Complete |
| Second ID (#1) | A number that may be assigned by a state to identify a handler | varchar(12) | 90.01 | Medium, High or Complete |
| TSD Date (#1) | The date on which operation of a TSD facility commenced, construction commenced, or on which operation is expected to begin | date | 84.08 | Medium, High or Complete |
| Off-site Waste Receipt (#1) | A code that indicates whether the handler accepts hazardous waste from another site | char(1) | 26.51 | Medium, High or 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.94 | Medium, High or Complete |
| Biennial Report Year (#1) | The year of the biennial reporting data from which this information record is taken | integer | 86.11 | Medium, High or Complete |
| County Code Owner (#1) | The agency that determined the meaning of the county code used | char(2) | 1.201 | Complete only |
| County Code (#1) | Code for the county in which the handler is located (state postal abbreviation plus county FIPS code) | char(5) | 1.189 | Medium, High or Complete |
| Federal Waste Gen. Code Owner (#1) | The agency that determined the meaning of the Federal Waste Generator Code used | char(2) | 4.379 | Complete 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) | 4.463 | Complete only |
| Federal Waste Generation (#1) | A code for the type of Federally classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 1.941 | Medium, High or Complete |
| State Waste Gen. Code Owner (#1) | The agency that determined the meaning of the State Waste Generator code used | char(2) | 55.38 | Complete 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) | 57.94 | Complete 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) | 55.36 | Medium, High or Complete |
| Number of Waste Codes (#1) | The number of Federal and State hazardous waste codes associated with this handler information record | integer | 52.91 | Complete only |
| Activity Location (#2) | The location, in the form of a state postal code, of the agency regulating the handler | char(2) | 0 | Medium, High or Complete |
| Source Type (#2) | A code indicating the source of data for this information record | char(1) | 0 | Medium, High or Complete |
| Sequence Number (#2) | A sequence number used to uniquely identify each information source record | integer | 0 | Complete only |
| Receive Date (#2) | Date that the form of information was received from the handler by the appropraite authority | date | 0 | Medium, High or Complete |
| Site Name (#2) | the legal name of the site | varchar(40) | 0.0001753 | Medium, High or 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 authority | char(1) | 98.4 | Medium, High or Complete |
| Number of Employees (#2) | The number of people actively on the payroll at the site on a permanent or semi-permanent basis | decimal(9) | 99.95 | Medium, High or Complete |
| Include in Biennial Report (Yes/No) (#2) | Indicates whether the handler should be included in the National Biennial RCRA Hazardous Waste Report | char(1) | 86.11 | Medium, High or Complete |
| CDX Transaction ID (#2) | The number assigned to the site ID form submitted via the CDX system | varchar(20) | 100 | Complete only |
| Location Street Number (#2) | Street number from the physical address of the primary site entrance | varchar(12) | 63.61 | Medium, High or Complete |
| Location Street 1 (#2) | First line of the street address from the physical address of the primary site entrance | varchar(30) | 0.002718 | Medium, High or Complete |
| Location Street 2 (#2) | Second line of the street address from the physical address of the primary site entrance | varchar(30) | 96.87 | Medium, High or Complete |
| Location City (#2) | Name of the city or town in which the handler is physically located | varchar(25) | 0.0006137 | Medium, High or Complete |
| Location State (#2) | The state postal abbreviation for the U.S. State in which the handler is physically located | char(2) | 0.000263 | Medium, High or Complete |
| Location Zip Code (#2) | The ZIP code from the physical address of the primary site entrance | varchar(14) | 0.0889 | Medium, High or Complete |
| Land Type (#2) | A code indicating the current ownership status of the land on which the facility is located | char(1) | 38.06 | Medium, High or Complete |
| State District (#2) | Indicates the state-designated legislative district(s) in which the site is located | varchar(10) | 46.43 | Medium, High or Complete |
| Mailing Street Number (#2) | The street number from the primary business mailing address for the handler | varchar(12) | 70.07 | Medium, High or Complete |
| Mailing Street 1 (#2) | The first line of the street address for the primary mailing address for the handler | varchar(30) | 2.346 | Medium, High or Complete |
| Mailing Street 2 (#2) | The second line of the street address for the primary mailing address for the handler | varchar(30) | 96.58 | Medium, High or Complete |
| Mailing City (#2) | The city or town from the primary mailing address for the handler | varchar(25) | 2.348 | Medium, High or Complete |
| Mailing State (#2) | The psotal state abbreviation for the state in the primary mailing address for the handler | char(2) | 2.354 | Medium, High or Complete |
| Mailing Zip Code (#2) | The Zip code in the primary mailing address for the handler | varchar(14) | 2.463 | Medium, High or Complete |
| Mailing Country (#2) | The country code in the primary mailing address for the handler | char(2) | 81.21 | Medium, High or Complete |
| Contact First Name (#2) | The first name of the primary contact person for the site | varchar(15) | 17.81 | Medium, High or Complete |
| Contact Middle Initial (#2) | The middle initial of the primary contact person for the site | char(1) | 97.14 | Medium, High or Complete |
| Contact Last Name (#2) | the last name of the primary contact person for the site | varchar(15) | 17.79 | Medium, High or Complete |
| Contact Street Number (#2) | The street number from the address of the primary contact person for the site | varchar(12) | 97 | Medium, High or Complete |
| Contact Street 1 (#2) | The first line of the street address for the primary contact person for the site | varchar(30) | 32.79 | Medium, High or Complete |
| Contact Street 2 (#2) | The second line of the street address for the primary contact person for the site | varchar(30) | 98.6 | Medium, High or Complete |
| Contact City (#2) | The city or town from the address of the primary contact person for the site | varchar(25) | 32.79 | Medium, High or Complete |
| Contact State (#2) | The state postal abbreviation from the address of the primary contact person for the site | char(2) | 32.77 | Medium, High or Complete |
| Contact Zip Code (#2) | The Zip code from the address of the primary contact person for the site | varchar(14) | 32.79 | Medium, High or Complete |
| Contact Country (#2) | The country code from the address of the primary contact person for the site | char(2) | 38.03 | Medium, High or Complete |
| Contact Phone (#2) | The telephone number of the primary contact person for the site | varchar(15) | 18.35 | Medium, High or Complete |
| Contact Phone Ext (#2) | The telephone number extension for the primary contact person for the site | varchar(6) | 96.27 | Medium, High or Complete |
| Contact Email (#2) | The Email address of the primary contact person for the site | varchar(50) | 98.33 | Medium, High or Complete |
| Permit Contact First Name (#2) | First name of a contact person familiar with the handler's hazardous waste permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Middle Initial (#2) | Middle initial of a contact person familiar with the handler's permit | char(1) | 100 | Medium, High or Complete |
| Permit Contact Last Name (#2) | Last name of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Street Number (#2) | The street number from the address of the permit contact person for the site | varchar(12) | 100 | Medium, High or Complete |
| Permit Contact Street 1 (#2) | First line of the street address of a contact person familiar with the handler's permit | varchar(30) | 99.99 | Medium, High or Complete |
| Permit Contact Street 2 (#2) | Second line of the street address of a contact person familiar with the handler's permit | varchar(30) | 100 | Medium, High or Complete |
| Permit Contact City (#2) | City or town in the address of a contact person familiar with the handler's permit | varchar(25) | 99.99 | Medium, High or Complete |
| Permit Contact State (#2) | State postal abbreviation in the address of a contact person familiar with the handler's permit | char(2) | 99.99 | Medium, High or Complete |
| Permit Contact Zip Code (#2) | Zip code in the address of a contact person familiar with the handler's permit | varchar(14) | 99.99 | Medium, High or Complete |
| Permit Contact Country (#2) | Country code in the address of a contact person familiar with the handler's permit | char(2) | 96.15 | Medium, High or Complete |
| Permit Contact Phone (#2) | Phone number of a contact person familiar with the handler's permit | varchar(15) | 99.99 | Medium, High or Complete |
| Permit Contact Phone Ext (#2) | Phone number extension of a contact person familiar with the handler's permit | varchar(6) | 100 | Medium, High or Complete |
| Permit Contact Email (#2) | Email address of a contact person familiar with the handler's permit | varchar(50) | 100 | Medium, High or Complete |
| Acknowledge Date (#2) | Date on which information was received from the handler | date | 75.74 | Complete only |
| Acknowledge Flag (#2) | A flag used to mark the handler for having an acknowledgement of receipt sent | char(1) | 96.12 | Complete only |
| Geometric Type Code (#2) | Code that represents the type of geometric entity described by a lat-long point or set of points | char(3) | 100 | Complete only |
| Horizontal Accuracy Measure (#2) | The horizontal accuracy (in meters) of the lat/long coordinates | varchar(6) | 99.16 | Complete only |
| Horizontal Collection Method (#2) | A code for the method used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Horizontal Reference Datum (#2) | A code for the reference datum used to determine the lat/long coordinates for the site | char(3) | 100 | Complete only |
| Latitude (#2) | The latitude of the site in decimal degrees | decimal(10,6) | 96.56 | Medium, High or Complete |
| Longitude (#2) | The longitude of the site in decimal degrees | decimal(11,6) | 96.56 | Medium, High or Complete |
| Reference Point (#2) | The code for the type of place for which lat/long coordinates were established | char(3) | 100 | Complete only |
| Source Map Scale (#2) | The scale of detail on the source map used to determine lat/long coordinates for the site | decimal(10) | 99.22 | Complete only |
| Importer Activity (Yes/No) (#2) | Indicates whether the facility imports hazardous waste into the U.S. from a foreign country | char(1) | 5.955 | Medium, High or Complete |
| Radioactive Waste (Yes/No) (#2) | Indicates whether the handler handles hazardous waste mixed with nuclear source, special nuclear, or by-product material | char(1) | 5.955 | Medium, High or Complete |
| Recycler Activity (Yes/No) (#2) | Indicates whether the handler recycles hazardous waste | char(1) | 0 | Medium, High or Complete |
| Transporter Activity (Yes/No) (#2) | Indicates whether the handler transports hazardous waste off-site by air. rail, highway, or water | char(1) | 0 | Medium, High or Complete |
| TSD Activity (Yes/No) (#2) | Indicates whether the handler treats, stores, or disposes of hazardous waste | char(1) | 2.576 | Medium, High or Complete |
| Underground Injection (Yes/No) (#2) | Indicates whether the handler carries out underground injection of hazardous waste into a deep or surface well | char(1) | 9.933 | Medium, High or Complete |
| Universal Waste Destination (Yes/No) (#2) | Indicates whether the handler generates, accumulates, receives, or ships universal waste. Excludes TSDs or transporters of universal waste. | char(1) | 67.29 | Medium, High or Complete |
| Transfer Facility (Yes/No) (#2) | Indicates whether the facility is a transportation-related facility that includes loading docks, storage areas etc. | char(1) | 3.346 | Medium, High or Complete |
| Burner Exemption (Yes/No) (#2) | Indicates whether the site qualifies for the Small Quantity Onsite Burner Exemption | char(1) | 3.378 | Medium, High or Complete |
| Furnace Exemption (Yes/No) (#2) | Indicates whether the handler qualifies for the Smelting, Melting, and Refining Furnace Exemption | char(1) | 3.378 | Medium, High or Complete |
| Used Oil Fuel Burner (Yes/No) (#2) | Indicates whether the site burns off-specification used oil for energy recovery | char(1) | 0 | Medium, High or Complete |
| Used Oil Processor (Yes/No) (#2) | Indicates whether the site processes used oil | char(1) | 2.576 | Medium, High or Complete |
| Used Oil Refiner (Yes/No) (#2) | Indicates whether the site refines used oil | char(1) | 0 | Medium, High or Complete |
| Used Oil Marketer (Yes/No) (#2) | Indicates whether the site directs shipments of off-specification used oil from the facility to used oil burners | char(1) | 0 | Medium, High or Complete |
| Used Oil Specification Cert. (Yes/No) (#2) | Indicates whether the handler claims that used oil targeted for energy recovery meets used fuel oil specification | char(1) | 0 | Medium, High or Complete |
| Used Oil Transfer Facility (Yes/No) (#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) | 2.576 | Medium, High or Complete |
| Used Oil Transporter (Yes/No) (#2) | Indicates whether the site transports or collects and transports used oil | char(1) | 2.576 | Medium, High or Complete |
| Second ID (#2) | A number that may be assigned by a state to identify a handler | varchar(12) | 90.01 | Medium, High or Complete |
| TSD Date (#2) | The date on which operation of a TSD facility commenced, construction commenced, or on which operation is expected to begin | date | 84.08 | Medium, High or Complete |
| Off-site Waste Receipt (#2) | A code that indicates whether the handler accepts hazardous waste from another site | char(1) | 26.51 | Medium, High or 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.94 | Medium, High or Complete |
| Biennial Report Year (#2) | The year of the biennial reporting data from which this information record is taken | integer | 86.11 | Medium, High or Complete |
| County Code Owner (#2) | The agency that determined the meaning of the county code used | char(2) | 1.201 | Complete only |
| County Code (#2) | Code for the county in which the handler is located (state postal abbreviation plus county FIPS code) | char(5) | 1.189 | Medium, High or Complete |
| Federal Waste Gen. Code Owner (#2) | The agency that determined the meaning of the Federal Waste Generator Code used | char(2) | 4.379 | Complete 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) | 4.463 | Complete only |
| Federal Waste Generation (#2) | A code for the type of Federally classified waste generation at the site (combined with the determining agency code for a single code lookup) | char(3) | 1.941 | Medium, High or Complete |
| State Waste Gen. Code Owner (#2) | The agency that determined the meaning of the State Waste Generator code used | char(2) | 55.38 | Complete 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) | 57.94 | Complete 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) | 55.36 | Medium, High or Complete |
| Number of Waste Codes (#2) | The number of Federal and State hazardous waste codes associated with this handler information record | integer | 52.91 | Complete only |
| Area Sequence Number (#1) | Code used to uniquely designate a corrective action area | char(4) | 0 | Complete only |
| Corrective Action Area (#1) | Name or number assigned to identify a corrective action area | varchar(40) | 0 | Medium, High or Complete |
| Facility-wide Corrective Action (Yes/No) (#1) | Indicates whether the corrective action applies to the entire facility | char(1) | 0 | Medium, High or Complete |
| Regulated Unit (Yes/No) (#1) | Indicates whether the corrective action applies to a regulated unit at the handler | char(1) | 84.86 | Medium, High or Complete |
| Number of Area-Event Links (#1) | The number of area-event links for this corrective action area | integer | 22.43 | Medium, High or Complete |
| Area Sequence Number (#2) | Code used to uniquely designate a corrective action area | char(4) | 0 | Complete only |
| Corrective Action Area (#2) | Name or number assigned to identify a corrective action area | varchar(40) | 0 | Medium, High or Complete |
| Facility-wide Corrective Action (Yes/No) (#2) | Indicates whether the corrective action applies to the entire facility | char(1) | 0 | Medium, High or Complete |
| Regulated Unit (Yes/No) (#2) | Indicates whether the corrective action applies to a regulated unit at the handler | char(1) | 84.86 | Medium, High or Complete |
| Number of Area-Event Links (#2) | The number of area-event links for this corrective action area | integer | 22.43 | Medium, High or Complete |
| Area Sequence Number (#3) | Code used to uniquely designate a corrective action area | char(4) | 0 | Complete only |
| Corrective Action Area (#3) | Name or number assigned to identify a corrective action area | varchar(40) | 0 | Medium, High or Complete |
| Facility-wide Corrective Action (Yes/No) (#3) | Indicates whether the corrective action applies to the entire facility | char(1) | 0 | Medium, High or Complete |
| Regulated Unit (Yes/No) (#3) | Indicates whether the corrective action applies to a regulated unit at the handler | char(1) | 84.86 | Medium, High or Complete |
| Number of Area-Event Links (#3) | The number of area-event links for this corrective action area | integer | 22.43 | Medium, High or Complete |
| Event Sequence Number (#1) | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date (#1) | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency (#1) | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type (#1) | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner (#1) | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links (#1) | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links (#1) | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
| Event Sequence Number (#2) | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location (#2) | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date (#2) | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency (#2) | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type (#2) | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner (#2) | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links (#2) | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links (#2) | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
| Event Sequence Number (#3) | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location (#3) | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date (#3) | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency (#3) | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type (#3) | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner (#3) | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links (#3) | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links (#3) | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
| Event Sequence Number (#4) | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location (#4) | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date (#4) | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency (#4) | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type (#4) | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner (#4) | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links (#4) | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links (#4) | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
| Event Sequence Number (#5) | ID number used to identify a corrective action event | char(3) | 0 | Complete only |
| Event Activity Location (#5) | The location, in the form of a state postal code, of the agency regulating the corrective action event | char(2) | 0 | Complete only |
| Actual Event Date (#5) | The date on which actual completion of a corrective action event occured | date | 3.439 | Complete only |
| Event Responsible Agency (#5) | The agency responsible for overseeing a corrective action event | char(1) | 0 | Complete only |
| Event Type (#5) | A code for the type of corrective action event | char(7) | 0 | Complete only |
| Event Type Code Owner (#5) | The agency that determined the meaning of the event code used | char(2) | 0 | Complete only |
| Number of Area-Event Links (#5) | The number of area-event links for this corrective action event | integer | 3.007 | Complete only |
| Number of Event-Authority Links (#5) | The number of event-authority links for this corrective action event | integer | 32.1 | Complete only |
| Effective Date (#1) | Date on which a permit modification, unilateral order, consent decree, or appeal becomes effective | date | 0 | Medium, High or Complete |
| Authority Responsible Agency (#1) | Code for the agency that originated and oversees a permit, permit modification, or order | char(1) | 0 | Medium, High or Complete |
| Issuance Date (#1) | The date on which an agency official signs the order, permit, or permit modification | date | 34.99 | Medium, High or Complete |
| Revokation Date (#1) | The date on which the corrective action authority is revoked | date | 89.63 | Medium, High or Complete |
| Repository Status (#1) | Code giving the status of an information repository near the facility for the purpose of making documents available | char(1) | 89.43 | Medium, High or Complete |
| Authority Activity Location (#1) | The location, in the form of a state postal code, of the agency regulating the activity | char(2) | 0 | Medium, High or Complete |
| Authority Type Code Owner (#1) | The agency that determined the meaning of the authority type code used | char(2) | 0 | Complete only |
| Authority Type (#1) | A code for the type of authority | char(1) | 0 | Medium, High or Complete |
| Number of Event-Authority Links (#1) | The number of event-authority links for this authority | integer | 10.52 | Medium, High or Complete |