The data fields associated with the tables in the Handler Module are documented, by table, below. Click here to see the Handler Module Structure Chart.
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. | |
Handler Name | HANDLER_NAME | The legal name of the site. | |
EPA Facility Identification Code | FACILITY_IDENTIFIER | Computer-generated primary facility-level key in the EPA FINDS data system used as an identifier to cross-reference entities regulated under different environmental programs. Note: This field is no longer generated or used. | |
Region | REGION | The two-digit code for the region in which the site is located. [see nationally-defined values] | |
State | STATE | State postal code for the state in which the site is located. [see nationally-defined values] | |
Extract Flag |
EXTRACT_FLAG | HD2-035 | Designates that data is available to extract for public use. [X - Yes; null - No] |
Tribal ID | TRIBAL_ID | Indicates the tribe where this site is located. [see nationally-defined values] | |
User Id of Last Change | USERID | Records the user identification of the last person to change the handler basic data. | |
Date of Last Change | LAST_CHANGE | Records the date that the handler basic data was last changed. | |
Internal Notes |
NOTES | Additional information regarding the site. Note: These notes are not released to the public. |
English Name | Oracle Name | Edit Rules | Description |
EPA Handler ID | HANDLER_ID | HD2-010, HD2-015 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | The location (i.e. State) where the activity took place. [see nationally-defined values] | |
Source Type | SOURCE_TYPE | HD2-020, HD2-750, HD2-760 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD2-030 | Assigned number to uniquely identify a handler source record. |
Receive Date | RECEIVE_DATE | HD2-040 | Date that the form (indicated by the associated Source) was received from the site by the appropriate authority, or for "I" sources, the date at which the information was considered current. |
Handler Name | HANDLER_NAME | HD2-050 | The legal name of the site. |
Non-Notifier | NON_NOTIFIER | HD2-060 | Flag indicating that the handler has been identified through a source other than Notification and is suspected of conducting RCRA-regulated activities without proper authority. [see nationally-defined values] |
Acknowledge Flag Date | ACKNOWLEDGE_DATE | Date acknowledgement of receipt of information is sent to sites. Acknowledge Flag Date is used in conjunction with Acknowledge Flag for generating an acknowledgement. | |
Acknowledge Flag | ACKNOWLEDGE_FLAG | A flag used to mark the site for having an acknowledgement of receipt sent. | |
Accessibility | ACCESSIBILITY | HD2-070 | Code indicating the reason why the handler is not accessible for normal RCRA tracking and processing. [see nationally-defined values] |
Location Street Number | LOCATION_STREET_NO | Street number from the physical address of the primary site entrance. | |
Location Street 1 | LOCATION_STREET1 | HD2-080 | First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance. |
Location Street 2 | LOCATION_STREET2 | Second line of the street address (or the post office box number), route number, or other specific identifier describing the physical address of the primary site entrance. | |
Location City | LOCATION_CITY | HD2-090 | Name of the city or town in which the handler is physically located. |
Location State | LOCATION_STATE | HD2-100, HD2-110 | State code of the location address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Location Zip Code | LOCATION_ZIP | HD2-120, HD2-125 | The zip code in which the site is physically located. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
Location Country | LOCATION_COUNTRY | HD2-100, HD2-110, HD2-125, HD2-140, HD2-650, HD2-660 | The out-of-country location for transporters coming into the United States. [see nationally-defined values] |
County Code | COUNTY_CODE | HD2-130 | The Federal Information Processing Standard (FIPS) code for the county in which the site is located. [see nationally-defined values] |
Location Latitude Measure | LOCATION_LATITUDE | HD2-142, HD2-146 |
Latitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between 0 and 90 unless the Handler ID starts with AS then the value must be between -15 and 90] Note: Valid latitude example: 69.288268 |
Location Longitude Measure |
LOCATION_LONGITUDE | HD2-144, HD2-146 |
Longitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between -180 and -60 unless the Handler ID starts with AK, AS, GU, MP, TT, XI, or XJ then the value must be between -180 and 180] Note: Valid longitude example: -147.650167 |
Location GIS Primary Indicator |
LOCATION_GIS_PRIMARY | HD2-075, HD2-080, HD2-090, HD2-100, HD2-120, HD2-130, HD2-142, HD2-144 |
Indicates if the Location Latitude / Longitude is the primary address for the site. [Y - Yes; N - No] |
Location GIS Origin |
LOCATION_GIS_ORIGIN |
Indicates how the Location Latitude / Longitude was ascertained. [UC - User Confirmed; AG - Automatically Geo-coded] |
|
Location Address Standardized | LOCATION_ADDR_STANDARDIZED | Indicates that the location address was standardized using the standardization candidates provided. Note: This only applies to addresses entered via the user interface (i.e., myRCRAid, the Biennial Report RCRAInfo Industry Application, or Handler module). [Y - Yes; N - No; null - No] | |
State District Owner |
STATE_DISTRICT_OWNER |
HD2-150, HD2-160 |
Indicates the agency that defined the State District. |
State District | STATE_DISTRICT | HD2-160, HD2-170 | Code indicating the State-designated legislative district(s) in which the site is located. |
Land Type | LAND_TYPE | HD2-240 | Code indicating the current ownership status of the land on which the site is located. [see nationally-defined values] |
Mailing Street Number | MAIL_STREET_NO | The street number from the primary business mailing address. | |
Mailing Street 1 | MAIL_STREET1 | HD2-180 | First line of the street address (or the post office box number) for primary business mailing purposes. |
Mailing Street 2 | MAIL_STREET2 | Second line of the street address (or the post office box number) for primary business mailing purposes. | |
Mailing City | MAIL_CITY | HD2-190 | Name of the city or town of the site's mailing address. |
Mailing State | MAIL_STATE | HD2-200, HD2-210 | State code of the mailing address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Mailing Zip Code | MAIL_ZIP | HD2-220, HD2-225 | Zip code of the primary business mailing address. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
Mailing Country | MAIL_COUNTRY | HD2-200, HD2-210, HD2-225, HD2-230 | Country code of the mailing address. [see nationally-defined values] |
Contact First Name | CONTACT_FIRST_NAME | HD2-250 | First name of the primary contact person for the site location who should be reasonably expected to be available at all times and fully aware of the regulated activities being performed at the site. |
Contact Middle Initial | CONTACT_MIDDLE_INITIAL | Middle initial of the primary contact person for the site location who should be reasonably expected to be available at all times and fully aware of the regulated activities being performed at the site. | |
Contact Last Name | CONTACT_LAST_NAME | HD2-260 | Last name of the primary contact person for the site location who should be reasonably expected to be available at all times and fully aware of the regulated activities being performed at the site. |
Contact Street Number | CONTACT_STREET_NO | The street number from the contact street address. | |
Contact Street 1 | CONTACT_STREET1 | First line of the street address (or the post office box number) for the contact. | |
Contact Street 2 | CONTACT_STREET2 | Second line (as needed) of the street address for the contact. | |
Contact City | CONTACT_CITY | The city or town of the contact address. | |
Contact State | CONTACT_STATE | HD2-280, HD2-290 | State code of the contact address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Contact Zip Code | CONTACT_ZIP | HD2-275 | Zip code of the contact address. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
Contact Country | CONTACT_COUNTRY | HD2-273, HD2-274, HD2-275, HD2-280, HD2-290, HD2-300 | Country code of the contact address. [see nationally-defined values] |
Contact Telephone Number | CONTACT_PHONE | HD2-270, HD2-273 | Telephone number at which the site contact may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Contact Telephone Extension | CONTACT_PHONE_EXT | Telephone number extension associated with the contact. | |
Contact Facsimile Number | CONTACT_FAX | HD2-274 | Facsimile number at which the site contact may be reached. Note: Fax numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Contact Email Address | CONTACT_EMAIL_ADDRESS | HD2-305 | Email address associated with the contact. |
Contact Title | CONTACT_TITLE | Title of the site contact person. | |
Contact Preferred Language | CONTACT_LANGUAGE | HD2-970 | The preferred language of the site contact person. If the preferred language is not provided, a value of 'EN' will be assumed. [see nationally-defined values] |
Federal Waste Generator Code Owner | FED_WASTE_GENERATOR_OWNER | HD2-310, HD2-320 | Indicates the agency that defined the Federal Waste Generator Code. [HQ - Headquarters] |
Federal Waste Generator Code | FED_WASTE_GENERATOR | HD2-320, HD2-330, HD2-640, HD2-660, HD2-680, HD2-700, HD2-750, HD2-820, HDL-040 | Indicates the regulatory category of the site with respect to the Federal rules to which it is subject as determined by the quantity and/or toxicity of hazardous wastes generated, stored, or accumulated over a specified period of time. [see nationally-defined values] |
State Waste Generator Code Owner | STATE_WASTE_GENERATOR_OWNER | HD2-340, HD2-350 | Indicates the agency that defined the State Waste Generator Code. |
State Waste Generator Code | STATE_WASTE_GENERATOR | HD2-350, HD2-360, HD2-750 | Indicates the regulatory category of the site in view of the implementing State's "broader in scope" or "more stringent than" rules. Although such an implementing State might use terms that differ for their generators (e.g., "Fully Regulated Generator"), these terms would be translated to match the Federal regulatory term (i.e., LQG, SQG, or VSQG) that best represents the way that the State regulates the generator. |
Short-Term Generator Activity | SHORT_TERM_GENERATOR | HD2-370, HD2-375, HD2-660, HD2-690, HD2-700, HD2-830 | Indicates whether the site's generator category is determined from a short-term or one-time event and not from on-going processes. [Y - Yes; N - No. For Sources I,R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Importer Activity | IMPORTER_ACTIVITY | HD2-380, HD2-660, HD2-750 | Indicates whether the site is engaged in importing hazardous waste into the United States from a foreign country. Importers are required to obtain an EPA identification number prior to engaging in import activities. Refer to 40 CFR 262.10(e) and 40 CFR 262.84 for additional information. [Y - Yes; N - No. For Sources I,R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Mixed Waste Generator | MIXED_WASTE_GENERATOR | HD2-390, HD2-660, HD2-680, HD2-750 | Indicates whether the site is a generator or TSDF that handlers waste mixed with nuclear source, special nuclear, or by-product material subject to the Atomic Energy Act (AEA), RCRA Section 1004(41), 42 U.S.C. 6903. [Y - Yes; N - No. For Sources I,R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] Note: Beginning on August 21, 2019, this data element is no longer being collected. |
Transporter Activity | TRANSPORTER | HD2-400, HD2-750 | Indicates whether the site is engaged in the off-site transportation of hazardous waste by air, rail, highway, or water. Refer to 40 CFR 263 for additional information. [Y - Yes; N - No. For Sources I,R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Transfer Facility Activity | TRANSFER_FACILITY | HD2-410, HD2-660, HD2-750 | Indicates whether the site holds manifested hazardous waste at the site for a period of ten days or less while the waste is in transit. Refer to 40 CFR 263,12 for additional information. [Y - Yes; N - No. For Sources with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
TSD Activity | TSD_ACTIVITY | HD2-420, HD2-660, HD2-750 | Indicates whether the site is engaged in the treatment, storage, or disposal of hazardous waste which requires a RCRA hazardous waste permit. Refer to 40 CFR 264, 265, 266, and 270 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Recycler Activity with Storage | RECYCLER_ACTIVITY | HD2-430, HD2-660, HD2-750, HD2-950 | Indicates whether the site is engaged in the recycling of hazardous waste received from off-site through activities such as use or reuse as ingredients in industrial processes to make product provided that the materials are not being reclaimed, used, or reused as effective substitutes for commercial products, returned to the original process from which they are generated without first being reclaimed. Refer to 40 CFR 261.6 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Small Quantity On-site Burner Exemption | ONSITE_BURNER_EXEMPTION | HD2-440, HD2-660, HD2-750 | Indicates whether the site qualifies for the small quantity on-site burner exemption. Refer to 40 CFR 266.108 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Smelting, Melting, and Refining Furnace Exemption | FURNACE_EXEMPTION | HD2-450, HD2-660, HD2-750 | Indicates that the site qualifies for the smelting, melting, and refining furnace exemption. Refer to 40 CFR 266.100(d), 266.100(g), and 266.100(h) for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Underground Injection Control | UNDERGROUND_INJECTION_ACTIVITY | HD2-460, HD2-750 | Indicates whether the site is engaged in the management of hazardous wastes by subsurface emplacement of fluids through a bored, drilled, or driven well, or a dug well where the depth of the dug well is greater than its largest surface dimension. Refer to 40 CFR 148 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Off-site Waste Receipt | OFF_SITE_RECEIPT | HD2-470, HD2-750 | Indicates that the handler, whether public or private, currently accepts hazardous waste from another site (i.e., a site identified by a different EPA identification number). [Y - Yes; N - No. For Sources with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Universal Waste Destination Facility | UNIVERSAL_WASTE_DEST_FACILITY | HD2-480, HD2-660, HD2-750 | Indicates whether the site treats, disposes of, or recycles universal wastes on-site. Refer to 40 CFR 261.9 and 40 CFR 273 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Used Oil Transporter | USED_OIL TRANSPORTER | HD2-490, HD2-750 | Indicates whether the site transports or collects and transports used oil from more than one generator. The transporter may aggregate loads for the purposes of transportation but may not process the oil with the exception of incidental processing, such as oil/water separation, that may occur during transportation. Refer to 40 CFR 279.40-47 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Used Oil Transfer Facility | USED_OIL_TRANSFER_FACILITY | HD2-500, HD2-660, HD2-750 | Indicates that the site owns or operates a used oil transfer facility. Refer to 40 CFR 279.40-47 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Used Oil Processor | USED_OIL_PROCESSOR | HD2-510, HD2-660, HD2-750 | Indicates whether the site processes used oil. Processing means chemical or physical operations that are designed to produce or make amenable for the production of fuels, oils, lubricants, or other oil-derived products through activities such as blending, filtration, separation, and distillation. Refer to 40 CFR 279.50-59 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Used Oil Refiner | USED_OIL_REFINER | HD2-520, HD2-660, HD2-750 | Indicates whether the site re-refines used oil. Refer to 40 CFR 279.50-59 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Off-specification Used Oil Burner | USED_OIL_BURNER | HD2-530, HD2-660, HD2-750 | Indicates whether the site burns off-specification used oil for energy recovery in devices or processes such as: 1) Industrial furnaces, boilers for sites engaged in manufacturing processes, 2) Boilers for the production of electric power, steam heater or cooled air or other gases or fluids for sale, 3) Used oil space heaters provided that the used oil originates from the owner/operator or from do-it-yourself used oil generation, or 4) Hazardous waste incineration. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Marketer Who Directs Shipment of Off-specification Used Oil to Off-specification Used Oil Burner | USED_OIL_MARKET_BURNER | HD2-540, HD2-660, HD2-750 | Indicates whether the site directs shipments of off-specification used oil from the site to used oil burners. Refer to 40 CFR 279.70-75 for additional information. [Y - Yes; N - No. For Sources I,R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Marketer Who First Claims the Used Oil Meets the Specifications | USED_OIL_SPEC_MARKETER | HD2-550, HD2-660, HD2-750 | Indicates whether the site first claims that used oil targeted for energy recovery meets used fuel oil specifications. Refer to 40 CFR 279.11 for additional information. [Y - Yes; N - No. For Sources I, R, E, or T with a Receive Date prior to 4/1/2010, N indicates No or Unknown] |
Subpart K - College or University | SUBPART_K_COLLEGE | HD2-560, HD2-660, HD2-750 | Indicates if the site is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible college or university. [Y - Yes; N - No] |
Subpart K - Teaching Hospital | SUBPART_K_HOSPITAL | HD2-570, HD2-660, HD2-750 | Indicates if the site is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible teaching hospital. [Y - Yes; N - No] |
Subpart K - Non-profit Research Institute | SUBPART_K_NONPROFIT | HD2-580, HD2-660, HD2-750 | Indicates if the site is managing laboratory hazardous waste under 40 CFR 262 Subpart K as an eligible non-profit research institute. [Y - Yes; N - No] |
Subpart K - Withdrawal | SUBPART_K_WITHDRAWAL | HD2-590, HD2-600, HD2-660, HD2-750 | Indicates if the site is withdrawing from managing laboratory hazardous waste under 40 CFR 262 Subpart K. [Y - Yes; N - No] |
Include in National Report | INCLUDE_IN_NATIONAL_REPORT | Indicates if the site should be included in the National Biennial RCRA Hazardous Waste Report. [Y - Yes; N - No; U - Unknown]. Note: Include in National Report has been set to U for BR cycles prior to 2001. | |
Biennial Report Cycle | REPORT_CYCLE | The year for which Biennial Report data was collected. | |
Biennial Report Exempt | BR_EXEMPT | Indicates that the site no longer meets the requirements to submit a Biennial Report, regardless of their current federal generator category. [Y - Yes; N - No. For records with a Report Cycle prior to 2021, null indicates Unknown] Note: This indicator was first collected for the 2021 BR cycle and was intended to provide a mechanism by which the site could communicate to the regulator that they were purposefully not providing GM, WR, and/or OI Forms with their BR submission. However, sites may continue to provide only a Site ID form with their submission WITHOUT indicating that they are exempt from submitting a Biennial Report. Therefore, this field has very limited use for reporting purposes. | |
CDX Transaction ID |
CDX_TRANSACTION_ID | Number assigned to the Site Identification Form submitted via the myRCRAId submission. | |
User Id of Last Change | USERID | Records the user identification of the last person to change the data. | |
Date of Last Change | LAST_CHANGE | Records the date that the data was last changed. | |
Internal Notes | NOTES | HD2-375 | Additional information regarding the site. Note: These notes are not released to the public. |
Public Notes | PUBLIC_NOTES | Additional information regarding the site. Note: These notes may be released to the public. | |
Short-term Generator Notes | SHORT_TERM_GENERATOR_NOTES | HD2-375 | Explanation of the short-term event that caused this site to become a generator. Note: These notes may be released to the public. |
Large Quantity Handler of Universal Waste | LQHUW | Calculated field that indicates that the site reported on this source record that they accumulated / managed at least one nationally-defined universal waste. [Y - Yes; N - No] | |
Origin of Data | DATA_ORIGIN | Computer-generated field that indicates they method by which the source record was created. [see nationally-defined values] | |
User Id of Source Record Creation | CREATED_BY_USERID | Records the user identification of the person who created the source record. | |
Date of Source Record Creation | CREATED_DATE | Records the date that the source record was created. | |
Recognized Trader Importer | RECOGNIZED_TRADER_IMPORTER | HD2-660, HD2-710, HD2-750 | Indicates if the site is domiciled in the United States and arranges and/or facilitates the import of wastes destined for recovery or disposal operations, either by purchasing from and subsequently selling to the United States and foreign facilities, or by acting under arrangements with a United States waste facility to arrange for the import of the wastes. Refer to 40 CFR 260.10 for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 12/20/2016, N indicates No or Unknown] |
Recognized Trader Exporter | RECOGNIZED_TRADER_EXPORTER | HD2-660, HD2-720, HD2-750 | Indicates if the site is domiciled in the United States and arranges and/or facilitates the export of wastes destined for recovery or disposal operations, either by purchasing from and subsequently selling to the United States and foreign facilities, or by acting under arrangements with a United States waste facility to arrange for the export of the wastes. Refer to 40 CFR 260.10 for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 12/20/2016, N indicates No or Unknown] |
Spent Lead Acid Battery Importer | SLAB_IMPORTER | HD2-660, HD2-730, HD2-750 | Indicates if the site is an importer of spent lead acid batteries (SLAB). Refer to 40 CFR 266 Subpart G and 40 CFR 266.80(a)(6), (8)-(10) for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 12/20/2016, N indicates No or Unknown] |
Spent Lead Acid Battery Exporter | SLAB_EXPORTER | HD2-660, HD2-740, HD2-750 | Indicates if the site is an exporter of spent lead acid batteries (SLAB). Refer to 40 CFR 266 Subpart G and 40 CFR 266.80(a)(6), (8)-(10) for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 12/20/2016, N indicates No or Unknown] |
Current Record | CURRENT_RECORD | Calculated field that indicates if the source record is the most recent source record for a site. [Y - Yes; N - No] | |
Non-storage Recycler Activity | RECYCLER_ACTIVITY_NONSTORAGE | HD2-660, HD2-750, HD2-960 | Indicates whether the site recycles regulated hazardous wastes received from off-site without storage prior to recycling. Refer to 40 CFR 261.6 for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 6/1/2017, N indicates No or Unknown] |
Electronic Manifest Broker | MANIFEST BROKER | HD2-800, HD2-805 | Indicates that the site creates and brokers manifest transactions for handlers of hazardous waste. Refer to 40 CFR 260.10 for additional information. [Y - Yes; N - No. For records with a Receive Date prior to 6/1/2017, N indicates No or Unknown] |
Subpart P - Healthcare Facility | SUBPART_P_HEALTHCARE | HD2-640, HD2-660, HD2-750, HD2-890, HD2-920, HD2-940 | Indicates that the site is managing hazardous waste pharmaceuticals under 40 CFR 266 Subpart P as a healthcare facility. [Y - Yes; N - No. For records with a Receive Date prior to 8/21/2019, N indicates No or Unknown] |
Subpart P - Reverse Distributor | SUBPART_P_REVERSE_DISTRIBUTOR | HD2-640, HD2-660, HD2-750, HD2-900, HD2-930, HD2-940 | Indicates that the site is managing hazardous waste pharmaceuticals under 40 CFR 266 Subpart P as a reverse distributor. [Y - Yes; N - No. For records with a Receive Date prior to 8/21/2019, N indicates No or Unknown] |
Subpart P - Withdrawal | SUBPART_P_WITHDRAWAL | HD2-660, HD2-910, HD2-940 | Indicates that the site has withdrawn from managing hazardous waste pharmaceuticals under 40 CFR 266 Subpart P as a healthcare facility or reverse distributor. [Y - Yes; N - No] |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD3-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD3-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD3-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD3-010 | Assigned number to uniquely identify a handler source record. |
Owner/Operator Sequence Number | OWNER_OPERATOR_SEQ | HD3-020 | Sequential number used to order multiple occurrences of owners and operators. |
Owner/Operator Indicator | OWNER_OPERATOR_INDICATOR | HD3-030 | Indicates whether the data is associated with a current or previous owner or operator. Multiple current owners and/or operators is allowed. [see nationally-defined values] |
Owner/Operator Type | OWNER_OPERATOR_TYPE | HD3-050 | Owner Type: Indicates the type of entity that legally owns the site. Operator Type: Indicates the type of entity that is responsible for the overall operation of the site. [see nationally-defined values] |
Owner/Operator Name | OWNER_OPERATOR_NAME | HD3-040 | Owner Name: The name of the entity (individual, agency, or corporation) having legal ownership of the physical operation. The owner name may or may not be the same as the actual site name or the operator name. Operator Name: The name of the entity (individual, agency, or corporation) that is responsible for the overall operation of the site. The operator name may or may not be the same as the actual site name or the owner name. |
Date Became Current | DATE_BECAME_CURRENT | HD3-060, HD3-080 | Date indicating when the owner/operator became the current owner/operator. |
Date Ended Current | DATE_ENDED_CURRENT | HD3-070, HD3-080 | Date indicating when the owner/operator changed to a different owner/operator. Note: Beginning with V6, this data is no longer collected. |
Owner/Operator Street Number | STREET_NO | The street number from the address of the site owner or operator. | |
Owner/Operator Street 1 | STREET1 | HD3-150 | First line of the street address (or the post office box number) for the site owner or operator. |
Owner/Operator Street 2 | STREET2 | Second line (as needed) of the street address for the site owner or operator. | |
Owner/Operator City | CITY | HD3-160 | The city or town in the address of the site owner or operator. |
Owner/Operator State | STATE | HD3-090 | State code in the address of the site owner or operator. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Owner/Operator Zip Code | ZIP | HD3-170 | Zip code in the address of the site owner or operator. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
Owner/Operator Country | COUNTRY | HD3-100, HD3-110 | Country code in the address of the site owner or operator. [see nationally-defined values] |
Owner/Operator Telephone Number | PHONE | HD3-190 | Telephone number at which the site owner or operator may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Owner/Operator Telephone Extension | PHONE_EXT | Telephone number extension associated with the site owner or operator. | |
Owner/Operator Facsimile Number | FAX | Facsimile number associated with the site owner or operator. Note: Fax numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. | |
Owner/Operator Email Address | HD3-180 | Email address associated with the site owner or operator. | |
User Id of Last Change | USERID | Records the user identification of the last person to change the owner/operator data. | |
Date of Last Change | LAST_CHANGE | Records the date that the owner/operator data was last changed. | |
Internal Notes | NOTES | Additional information regarding the owner or operator. Note: These notes are not released to the public. | |
Public Notes | PUBLIC_NOTES | Additional information regarding the owner or operator. Note: These notes may be released to the public. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD4-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD4-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD4-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD4-010 | Assigned number to uniquely identify a handler source record. |
NAICS Sequence Number | NAICS_SEQ | HD4-020 | Sequential number used to order multiple occurrences of NAICS. Note: The primary NAICS is indicated with a sequence of 1. |
NAICS Owner | NAICS_OWNER | HD4-040 | Indicates the agency that defined the NAICS code. |
NAICS Code | NAICS_CODE | HD4-030, HD4-050 | The industrial activity of the site as defined by the North American Industry Classification System. [see nationally-defined values] |
User Id of Last Change | USERID | Records the user identification of the last person to change the NAICS data. | |
Date of Last Change | LAST_CHANGE | Records the date that the NAICS data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD5-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD5-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD5-010, HD5-020 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD5-010 | Assigned number to uniquely identify a handler source record. |
Other Permit Number | OTHER_PERMIT_NUMBER | HD5-030 | Identification number of an effective environmental permit issued to the site, or the number of a filed application for which an environmental permit has not yet been issued. |
Other Permit Type Owner | OTHER_PERMIT_OWNER | HD5-050 | Indicates that agency that defined the Other Permit Type. |
Other Permit Type | OTHER_PERMIT_TYPE | HD5-040 | Indicates the environmental program and/or jurisdictional authority under which: 1) an environmental permit was issued to the site, or 2) an application has been filed for which a permit has not yet been issued. [see nationally-defined values] |
Other Permit Description |
OTHER_PERMIT_DESC | HD5-060 | Additional information identifying or describing the permit. |
User Id of Last Change | USERID | Records the user identification of the last person to change the other permit data. | |
Date of Last Change | LAST_CHANGE | Records the date that the other permit data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD6-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD6-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD6-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD6-010 | Assigned number to uniquely identify a handler source record. |
Hazardous Waste Code Owner | WASTE_CODE_OWNER | HD6-030 | Indicates the agency that defined the Waste Code. |
Hazardous Waste Code | WASTE_CODE | HD6-020 | State or Federal codes corresponding to the hazardous waste generated by a site. These codes are listed in 40 CFR Part 261, Subparts C and D, or are assigned by States for wastes that are either: 1) regulated and defined as hazardous by the State but are not regulated as RCRA hazardous waste, or 2) State equivalent waste codes for RCRA regulated hazardous wastes. [see nationally-defined values] |
User Id of Last Change | USERID | Records the user identification of the last person to change the waste code data. | |
Date of Last Change | LAST_CHANGE | Records the date that the waste code data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD7-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD7-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD7-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD7-010 | Assigned number to uniquely identify a handler source record. |
Universal Waste Type Owner | UNIVERSAL_WASTE_OWNER | HD7-015 | Indicates the agency that defined the Universal Waste Type. |
Universal Waste Type | UNIVERSAL_WASTE_TYPE | HD7-020 | Indicates the type of universal waste. |
Accumulated / Managed Universal Waste | ACCUMULATED | HD7-030, HD7-050, HD7-060 | Indicates that the site is engaged in managing and/or accumulating universal waste on-site. [Y - Yes; N - No] |
Generated Universal Waste | GENERATED | HD7-040, HD7-050, HD7-060 | Indicates that the site is engaged in generating universal waste on-site. Note: Generated universal waste does not apply to nationally-defined universal waste types. [Y - Yes; N - No] |
User Id of Last Change | USERID | Records the user identification of the last person to change the universal waste data. | |
Date of Last Change | LAST_CHANGE | Records the date that the universal waste data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD8-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD8-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD8-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD8-010 | Assigned number to uniquely identify a handler source record. |
Certification Sequence Number | CERT_SEQ | HD8-020 | Sequential number used to uniquely identify multiple certifications for a source record. |
Certification First Name | CERT_FIRST_NAME | HD8-050 | First name of the person who certified the site information reported to the authorizing agency. |
Certification Middle Initial | CERT_MIDDLE_INITIAL | Middle initial of the person who certified the site information reports to the authorizing agency. | |
Certification Last Name | CERT_LAST_NAME | HD8-060 | Last name of the person who certified the site information reported to the authorizing agency. |
Certification Title | CERT_TITLE | HD8-040 | Title of the person who certified the site information reported to the authorizing agency. |
Certification Signed Date | CERT_SIGNED_DATE | HD8-030 | Date on which the site information was certified by the reporting site. |
Certification Email Address | CERT_EMAIL | Email of the person who certified the site information reported to the authorizing agency. | |
User Id of Last Change | USERID | Records the user identification of the last person to change the certification data. | |
Date of Last Change | LAST_CHANGE | Records the date that the certification data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HD9-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HD9-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HD9-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HD9-010 | Assigned number to uniquely identify a handler source record. |
State Activity Type Owner | STATE_ACTIVITY_OWNER | HD9-030 | Indicates the agency that defined the State Activity Type. |
State Activity Type | STATE_ACTIVITY_TYPE | HD9-020 | Indicates the type of state activity. |
User Id of Last Change | USERID | Records the user identification of the last person to change the state activity data. | |
Date of Last Change | LAST_CHANGE | Records the date that the state activity data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDA-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDA-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDA-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDA-010 | Assigned number to uniquely identify a handler source record. |
Permit Contact First Name | PCONTACT_FIRST_NAME |
HDA-030 |
First name of the person who is familiar with the site's hazardous waste permit information. |
Permit Contact Middle Initial | PCONTACT_MIDDLE_INITIAL | Middle initial of the person who is familiar with the site's hazardous waste permit information. | |
Permit Contact Last Name | PCONTACT_LAST_NAME | HDA-040, HDA-100 | Last name of the person who is familiar with the site's hazardous waste permit information. |
Permit Contact Street Number | PCONTACT_STREET_NO | The street number from the permit contact street address. | |
Permit Contact Street 1 |
PCONTACT_STREET1 |
First line of the street address (or the post office box number) for the permit contact. | |
Permit Contact Street 2 | PCONTACT_STREET2 | Second line (as needed) of the street address for the permit contact. | |
Permit Contact City | PCONTACT_CITY | The city or town of the permit contact address. | |
Permit Contact State | PCONTACT_STATE | HDA-060, HDA-070 | State code of the permit contact address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Permit Contact Zip | PCONTACT_ZIP | Zip code of the permit contact address. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. | |
Permit Contact Country | PCONTACT_COUNTRY | HDA-060, HDA-070, HDA-080 | Country code of the permit contact address. [see nationally-defined values] |
Permit Contact Telephone Number | PCONTACT_PHONE | HDA-050, HDA-100 | Telephone number at which the permit contact may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Permit Contact Telephone Extension | PCONTACT_PHONE_EXT | Telephone number extension associated with the contact. | |
Permit Contact Email Address | PCONTACT_EMAIL_ADDRESS | Email address associated with the permit contact. | |
Permit Contact Title | PCONTACT_TITLE | Title of the permit contact person. | |
TSD Date | TSD_DATE | HDA-090, HDA-100 | The date that operation of the site commenced, the date construction on the site commenced, or the date that operation is expected to begin. |
User Id of Last Change | USERID | Records the user identification of the last person to change the hazardous waste permit data. | |
Date of Last Change | LAST_CHANGE | Records the date that the hazardous waste permit data was last changed. | |
Nature of Business | NATURE_OF_BUSINESS_NOTES | Describes the nature of the site's business (e.g., products produced or services provided). |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDB-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | The location (i.e. State) where the activity took place. [see nationally-defined values] | |
Other Identification Number | OTHER_ID | HDB-020 | An additional identification number for the site. |
Relationship Type Owner | RELATIONSHIP_OWNER | HDB-030 | Indicates the agency that defined the Relationship Type |
Relationship Type | RELATIONSHIP | HDB-040 | The relationship between the other id and the site id. [see nationally-defined values] |
Same Facility | SAME_FACILITY | HDB-050 | Indicates if the other id refers to the same facility as the site id. [Y - Yes; N - No; U - Unknown] |
User Id of Last Change | USERID | Records the user identification of the last person to change the other id data. | |
Date of Last Change | LAST_CHANGE | Records the date that the other id data was last changed. | |
Internal Notes | NOTES | Additional information regarding the other id for this site. Note: These notes are not released to the public. | |
Public Notes | PUBLIC_NOTES | Additional information regarding the other id for this site. Note: These notes may be released to the public. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDC-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDC-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDC-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDC-010 | Assigned number to uniquely identify a handler source record. |
Reason for Notification | REASON_FOR_NOTIFICATION | HDC-030, HDC-040, HDC-060 | Indicates the reason that you are notifying of your hazardous secondary material management activity. [see nationally-defined values] |
Hazardous Secondary Material Effective Date | HSM_EFFECTIVE_DATE | HDC-040 | The date that you will begin managing hazardous secondary material or the date that you stopped managing hazardous secondary material. |
Hazardous Secondary Material Financial Assurance Indicator | HSM_FA | HDC-050 | Indicates if the site has financial assurance. Note: Beginning with V6, this data is no longer collected. [Y - Yes; N - No] |
Managed Indicator | MANAGED_INDICATOR | Indicates if this site is notifying under 40 CFR 260.42 that they will begin managing, are managing, or will stop managing hazardous secondary material under 40 CFR 261.2(a)(ii), 40 CFR 261.4(a)(23), (24), or (25) [Y - Yes; null - No] Note: For translation, this field will be set to 'Y' if HSM data is provided. | |
User Id of Last Change | USERID | Records the user identification of the last person to change the HSM basic data. | |
Date of Last Change | LAST_CHANGE | Records the date that the HSM basic data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDD-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDD-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDD-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDD-010 | Assigned number to uniquely identify a handler source record. |
Hazardous Secondary Material Sequence Number | HSM_SEQ_NUMBER | HDD-020 | Sequential number used to uniquely identify multiple HSM activities. |
Facility Code Owner |
FACILITY_CODE_OWNER | HDD-035 | Indicates the agency that defined the Facility Code. |
Facility Code | FACILITY_CODE | HDD-030 | Describes the specific regulation a site uses to manage its hazardous secondary material and the type of activity the site performs under that regulation. [see nationally-defined values] |
Estimated Hazardous Secondary Material Managed | ESTIMATE_SHORT_TONS | HDD-040, HDD-050 | Estimated short tons of hazardous secondary material to be managed annually. |
Actual Hazardous Secondary Material Managed | ACTUAL_SHORT_TONS | HDD-060, HDD-070, HDD-080 | Actual short tons of hazardous secondary material managed during the most recent odd-numbered year. |
Land-based Unit | LAND_BASED_UNIT | HDD-090 | Code that best describes the land-based unit the facility uses or will use to manage hazardous secondary material. [see nationally-defined values] |
User Id of Last Change | USERID | Records the user identification of the last person to change the HSM activity data. | |
Date of Last Change | LAST_CHANGE | Records the date that the HSM activity data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDE-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDE-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDE-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDE-010 | Assigned number to uniquely identify a handler source record. |
Hazardous Secondary Material Sequence Number | HSM_SEQ_NUMBER | HDE-010 | Sequential number used to uniquely identify multiple HSM activities. |
Hazardous Secondary Material Waste Code Owner | WASTE_CODE_OWNER | HDE-020 | Indicates the agency that defined the Waste Code. |
Hazardous Secondary Material Waste Code | WASTE_CODE | HDE-030 | Four-character hazardous waste code that would apply to your hazardous secondary material if you managed it as hazardous waste. These codes are listed in 40 CFR Part 261, Subparts C and D. [see nationally-defined values] |
User Id of Last Change | USERID | Records the user identification of the last person to change the HSM waste code data. | |
Date of Last Change | LAST_CHANGE | Records the date that the HSM waste code data was last changed. |
Note: Beginning August 21, 2019, data for this table is no longer being collected.
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDF-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDF-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDF-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDF-010 | Assigned number to uniquely identify a handler source record. |
Recycler Indicator |
RECYCLER_INDICATOR | HDF-020 | Indicates if you are notifying under 40 CFR 260.43(a)(4)(iii) that the product of your recycling process has levels of hazardous constituents that are not comparable to or unable to be compared to a legitimate product or intermediate but that the recycling is still legitimate. [Y - Yes; N - No] |
Recycler Notes | RECYCLER_NOTES | Additional information regarding the HSM recycling process. | |
User Id of Last Change | USERID | Records the user identification of the last person to change the HSM recycler data. | |
Date of Last Change | LAST_CHANGE | Records the date that the HSM recycler data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDG-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDG-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDG-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDG-010 | Assigned number to uniquely identify a handler source record. |
Inactivation Reason | INACTIVATION_REASON | HDG-020, HDG-030 | Indicates the reason why the site no longer has any RCRA Subtitle C activities. [see nationally-defined values] |
Inactiviation Notes | INACTIViATION_NOTES | HDG-030 | Additional information regarding why the site no longer has any RCRA Subtitle C activities. |
User Id of Last Change | USERID | Records the user identification of the last person to change the inactivation data. | |
Date of Last Change | LAST_CHANGE | Records the date that the inactivation data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDH-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDH-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDH-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDH-010 | Assigned number to uniquely identify a handler source record. |
Closure Type | CLOSURE_TYPE | HDH-020 | Indicates if the closure information provided is for the entire facility or a central accumulation area. [see nationally-defined values] |
Expected Closure Date | EXPECTED_CLOSURE_DATE | HDH-030, HDH-040, HDH-050 | The date that the entire facility or central accumulation area is expected to close. |
New Closure Date | NEW_CLOSURE_DATE | HDH-030, HDH-050 | The revised closure date if the site is unable to complete the closure of the facility or central accumulation area within 90 days of starting the closure process. |
Date Closed | DATE_CLOSED | HDH-030, HDH-040, HDH-060, HDH-070 | The date that the entire facility or central accumulation area was closed. |
Closed In Compliance | IN_COMPLIANCE | HDH-060, HDH-070 | Indicates if the site or central accumulation area was closed in compliance with the closure performance standards in 40 CFR 262.17(a)(8). [Y - Yes; N -No; null - Not Applicable] |
User Id of Last Change | USERID | Records the user identification of the last person to change the LQG closure data. | |
Date of Last Change | LAST_CHANGE | Records the date that the LQG closure data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDI-010, HDI-150 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDI-005, HDI-010, HDI-150 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDI-010, HDI-150 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDI-010, HDI-150 | Assigned number to uniquely identify a handler source record. |
Consolidation Sequence Number | CONSOLIDATION_SEQ_NUMBER | HDI-020 | Assigned number to uniquely identify an LQG consolidation record. |
VSQG Handler ID | VSQG_HANDLER_ID | HDI-130, HDI-140, HDI-150 | The EPA Identification Number for the VSQG whose waste is being consolidated. |
VSQG Handler Name | VSQG_HANDLER_NAME | HDI-030 | The legal name of the VSQG. |
VSQG Street Number | VSQG_STREET_NO | The street number from the site (physical) address of the VSQG. | |
VSQG Street 1 | VSQG_STREET1 | HDI-040 | First line of the site (physical) street address for the VSQG. |
VSQG Street 2 | VSQG_STREET2 | Second line (as needed) of the site (physical) street address for the VSQG. | |
VSQG City | VSQG_CITY | HDI-050 | The city or town in the site (physical) address of the VSQG. |
VSQG State | VSQG_STATE | HDI-060 | State code in the site (physical) address of the VSQG. [see nationally-defined values] |
VSQG Zip Code | VSQG_ZIP | HDI-070, HDI-080 | Zip code in the site (physical) address of the VSQG. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
VSQG Contact Telephone Number | VSQG_PHONE | HDI-090, HDI-100 | Telephone number at which the VSQG contact may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
VSQG Contact Telephone Extension | VSQG_PHONE_EXT | Telephone number extension associated with the VSQG contact. | |
VSQG Contact Email Address | VSQG_EMAIL_ADDRESS | HDI-110 | Email address of the VSQG contact. |
VSQG Contact First Name | VSQG_CONTACT_FIRST_NAME | HDI-110 | First name of the individual who should be contacted for information about the VSQG. |
VSQG Contact Middle Initial | VSQG_CONTACT_MIDDLE_INITIAL | Middle initial of the individual who should be contacted for information about the VSQG. | |
VSQG Contact Last Name | VSQG_CONTACT_LAST_NAME | HDI-120 | Last name of the individual who should be contacted for information about the VSQG. |
User Id of Last Change | USERID | Records the user identification of the last person to change the LQG consolidation data. | |
Date of Last Change | LAST_CHANGE | Records the date that the LQG consolidation data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDJ-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDJ-005, HDJ-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDJ-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDJ-010 | Assigned number to uniquely identify a handler source record. |
Episodic Event Type Owner | EPISODIC_EVENT_OWNER | HDJ-015 | Indicates the agency that defined the Episodic Event Type. [HQ-Headquarters] |
Episodic Event Type | EPISODIC_EVENT_TYPE | HDJ-020, HDJ-030, HDJ-040 | Indicates whether the event being conducted in planned or unplanned. [see nationally-defined values] |
Emergency Contact Telephone Number | EMERGENCY_CONTACT_PHONE | HDJ-070, HDJ-080 | The emergency phone number of the individual who should be contacted for information about the episodic event. |
Emergency Contact Telephone Extension | EMERGENCY_CONTACT_PHONE_EXT | The emergency phone number extension of the individual who should be contacted for information about the episodic event. | |
Emergency Contact First Name | EMERGENCY_CONTACT_FIRST_NAME | HDJ-090 | The first name of the individual who should be contacted for information about the episodic event. |
Emergency Contact Middle Initial | EMERGENCY_CONTACT_MIDDLE_INITIAL | The middle initial of the individual who should be contacted for information about the episodic event. | |
Emergency Contact Last Name | EMERGENCY_CONTACT_LAST NAME | HDJ-100 | The last name of the individual who should be contacted for information about the episodic event. |
Emergency Contact Email | EMERGENCY_CONTACT_EMAIL | The email of the individual who should be contacted for information about the episodic event. | |
Event Start Date | START_DATE | HDJ-030, HDJ-040, HDJ-110, HDJ-130 | The estimated start date of the episodic event. |
Event End Date | END_DATE | HDJ-120, HDJ-130 | The estimated end date of the episodic event. The event must be completed with sixty (60) days of the start date. |
User Id of Last Change | USERID | Records the user identification of the last person to change the episodic event data. | |
Date of Last Change | LAST_CHANGE | Records the date that the episodic event data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDM-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDM-005, HDM-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDM-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDM-010 | Assigned number to uniquely identify a handler source record. |
Project Code Owner | PROJECT_CODE_OWNER | HDM-020 | Indicates the agency that defined the Project Code. [HQ - Headquarters] |
Project Code | PROJECT_CODE | HDM-030 | Indicates the reason or project that occurred during the event. [see nationally-defined values] |
Other Project Description | OTHER_PROJECT_DESC | HDM-040, HDM-050 | A description of the project, if the reason was "other" (either planned or unplanned). |
User Id of Last Change | USERID | Records the user identification of the last person to change the episodic project data. | |
Date of Last Change | LAST_CHANGE | Records the date that the episodic project data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDK-010, HDK-050 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDK-005, HDK-010, HDK-050 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDK-010, HDK-050 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDK-010, HDK-050 | Assigned number to uniquely identify a handler source record. |
Waste Sequence Number | WASTE_SEQ_NUMBER | HDK-020, HDK-050 | Assigned number to uniquely identify a waste record. |
Waste Description | WASTE_DESCRIPTION | HDK-030 | A description of the waste generated as a result of the episodic event. |
Estimated Quantity (in pounds) | ESTIMATED_QUANTITY | HDK-040 | The estimated quantity (in pounds) of the hazardous waste to be generated as a result of the episodic event. |
User Id of Last Change | USERID | Records the user identification of the last person to change the episodic waste data. | |
Date of Last Change | LAST_CHANGE | Records the date that the episodic waste data was last changed. |
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | HDL-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDL-005, HDL-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDL-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDL-010 | Assigned number to uniquely identify a handler source record. |
Waste Sequence Number | WASTE_SEQ_NUMBER | HDL-010 | Assigned number to uniquely identify a waste record. |
Waste Code Owner | WASTE_CODE_OWNER | HDL-030, HDL-040 | Indicates the agency that defined the Waste Code. |
Waste Code | WASTE_CODE | HDL-020 | State or Federal codes corresponding to the hazardous waste generated by a site. These codes are listed in 40 CFR Part 261, Subparts C and D, or are assigned by States for wastes that are either: 1) regulated and defined as hazardous by the State but are not regulated as RCRA hazardous waste, or 2) State equivalent waste codes for RCRA regulated hazardous wastes. [see nationally-defined values] |
User Id of Last Change | USERID | Records the user identification of the last person to change the episodic waste code data. | |
Date of Last Change | LAST_CHANGE | Records the date that the episodic waste code data was last changed. |
English Name | Oracle Name | Edit Rules | Description |
EPA Handler ID | HANDLER_ID | HDN-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
Activity Location | ACTIVITY_LOCATION | HDN-010 | The location (i.e. State) where the activity took place. [see nationally-defined values] |
Source Type | SOURCE_TYPE | HDN-010 | Code indicating the source of information for the associated data (activity, wastes, etc.). [see nationally-defined values] |
Sequence Number | SEQ_NUMBER | HDN-010 | Assigned number to uniquely identify a handler source record. |
Additional Contact Sequence Number | ADDL_CONTACT_SEQ | HDN-020 | Assigned number to uniquely identify an additional contact record. |
Additional Contact Type Owner | ADDL_CONTACT_TYPE_OWNER | HDN-025 | Indicates the agency that defined the additional contact. |
Additional Contact Type | ADDL_CONTACT_TYPE | HDN-030 | Code indicating the type of additional contact being reported. [see nationally-defined values] |
Additional Contact First Name | ADDL_CONTACT_FIRST_NAME | HDN-040 | First name of the additional contact person. |
Additional Contact Middle Initial | ADDL_CONTACT_MIDDLE_INITIAL | Middle initial of the additional contact person. | |
Additional Contact Last Name | ADDL_CONTACT_LAST_NAME | HDN-050 | Last name of the additional contact person. |
Additional Contact Street Number | ADDL_CONTACT_STREET_NO | The street number from the additional contact street address. | |
Additional Contact Street 1 | ADDL_CONTACT_STREET1 | First line of the street address (or the post office box number) for the additional contact. | |
Additional Contact Street 2 | ADDL_CONTACT_STREET2 | Second line (as needed) of the street address for the additional contact. | |
Additional Contact City | ADDL_CONTACT_CITY | The city or town of the additional contact address. | |
Additional Contact State | ADDL_CONTACT_STATE | HDN-100, HDN-110 | State code of the additional contact address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
Additional Contact Zip Code | ADDL_CONTACT_ZIP | HDN-090 | Zip code of the additional contact address. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
Additional Contact Country | ADDL_CONTACT_COUNTRY | HDN-070, HDN-080, HDN-090, HDN-100, HDN-110, HDN-120 | Country code of the additional contact address. [see nationally-defined values] |
Additional Contact Telephone Number | ADDL_CONTACT_PHONE | HDN-060, HDN-070 | Telephone number at which the additional site contact may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Additional Contact Telephone Extension | ADDL_CONTACT_PHONE_EXT | Telephone number extension associated with the additional contact. | |
Additional Contact Facsimile Number | ADDL_CONTACT_FAX | HDN-080 | Facsimile number at which the additional site contact may be reached. Note: Fax numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
Additional Contact Email Address | ADDL_CONTACT_EMAIL_ADDRESS | HDN-130 | Email address associated with the additional contact. |
Additional Contact Title | ADDL_CONTACT_TITLE | Title of the additional site contact person. | |
Additional Contact Preferred Language | ADDL_CONTACT_LANGUAGE | HDN-140 | The preferred language of the additional site contact person. If the preferred language is not provided, a value of 'EN' will be assumed. [see nationally-defined values] |