DATA ELEMENT DICTIONARY - HANDLER MODULE

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. 

 

 

HBASIC

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.

HHANDLER5

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]

HOWNER_OPERATOR5

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

HNAICS5

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.

HOTHER_PERMIT5

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.

HWASTE_CODE5

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.

HUNIVERSAL_WASTE5

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.

HCERTIFICATION5

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.

HSTATE_ACTIVITY5

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.

HPART_A5

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

HOTHER_ID5

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.

HHSM_BASIC5

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.

HHSM_ACTIVITY5

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.

HHSM_WASTE_CODE5

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.

HHSM_RECYCLER

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.

HINACTIVATION

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.

HLQG_CLOSURE

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.

HLQG_CONSOLIDATION

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.

HEPISODIC_EVENT

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.

HEPISODIC_PROJECT

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.

HEPISODIC_WASTE

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.

HEPISODIC_WASTE_CODE

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.

 

HADDL_CONTACT

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]