The data fields associated with the tables in the e-Manifest Module are documented, by table, below. Click here to see the e-Manifest Module Structure Chart.
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the record. |
Manifest Tracking Number |
MANIFEST_TRACKING_NUMBER |
Unique identification number associated with the manifest. |
Created Date |
CREATED_DATE |
The date that the manifest was created. |
Last Updated Date |
UPDATED_DATE |
The date that the manifest was last updated. |
Shipped Date |
SHIPPED_DATE |
The date that the waste was picked up from the generator by the first transporter. |
Received Date |
RECEIVED_DATE |
The date that the waste was received by the designated facility. |
Certified Date | CERTIFIED_DATE | The date that the waste was signed and certified by the designated facility and placed on an invoice for billing purposes. |
Manifest Status |
STATUS |
The current status of the manifest. [see nationally-defined values] |
Submission Type |
SUBMISSION_TYPE |
Indicates what type of manifest was submitted. [see nationally-defined values] |
Origin Type |
ORIGIN_TYPE |
Indicates how the manifest data was provided. [see nationally-defined values] |
Emergency Phone Number |
EMERGENCY_PHONE_NUMBER |
The phone number in conjunction with the phone number extension for which emergency response information can be obtained in the event of an incident during transportation. |
Emergency Phone Number Extension |
EMERGENCY_PHONE_EXT |
The phone number extension in conjunction with the phone number for which emergency response information can be obtained in the event of an incident during transportation. |
Generator EPA ID |
GENERATOR_ID |
The U.S. EPA's twelve-digit identification number for the generator of the waste or the information provided if the generator site does not have an EPA identification number. |
Generator Name |
GENERATOR_NAME |
The legal name of the generator. |
Generator Mail Street Number |
GENERATOR_MAIL_STREET_NO |
The street number from the generator's primary business mailing address. |
Generator Mail Street 1 |
GENERATOR_MAIL_STREET1 |
First line of the street address (or the post office box number) for the generator's primary business mailing address. |
Generator Mail Street 2 |
GENERATOR_MAIL_STREET2 |
Second line of the street address (or the post office box number) for the generator's primary business mailing address. |
Generator Mail City |
GENERATOR_MAIL_CITY |
Name of the city or town of the generator's mailing address. |
Generator Mail Zip |
GENERATOR_MAIL_ZIP |
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. |
Generator Mail State |
GENERATOR_MAIL_STATE |
State code of the mailing address. [see nationally-defined values] |
Generator Location Street Number |
GENERATOR_LOCATION_STREET_NO |
Street number from the physical address of the primary site entrance of the generator. |
Generator Location Street 1 |
GENERATOR_LOCATION_STREET1 |
First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance of the generator. |
Generator Location Street 2 |
GENERATOR_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 of the generator. |
Generator Location City |
GENERATOR_LOCATION_CITY |
Name of the city or town in which the generator is physically located. |
Generator Location Zip |
GENERATOR_LOCATION_ZIP |
The zip code in which the generator 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. |
Generator Location State |
GENERATOR_LOCATION_STATE |
State code of the location address. [see nationally-defined values] |
Generator Contact Company Name |
GENERATOR_CONTACT_COMPANY_NAME |
The company name associated with the generator's contact person. |
Generator Contact First Name |
GENERATOR_CONTACT_FIRST_NAME |
The first name of the generator's contact person. |
Generator Contact Last Name |
GENERATOR_CONTACT_LAST_NAME |
The last name of the generator's contact person. |
Generator Contact Email |
GENERATOR_CONTACT_EMAIL |
The email address of the generator's contact person. |
Generator Contact Phone Number |
GENERATOR_CONTACT_PHONE_NUMBER |
The telephone number of the generator's contact person. |
Generator Contact Phone Number Extension |
GENERATOR_CONTACT_PHONE_EXT |
The telephone number extension of the generator's contact person. |
Is the Generator Registered |
GENERATOR_REGISTERED |
Indicates if the generator existed in RCRAInfo at the time the manifest was submitted. [Y - Yes; N - No] |
Was the Generator Modified |
GENERATOR_MODIFIED |
Indicates if the name, mailing address, or location address were modified. [Y - Yes; N - No] |
Designated Facility EPA ID |
DES_FACILITY_ID |
The U.S. EPA's twelve-digit identification number of the designated facility. |
Designated Facility Name |
DES_FACILITY_NAME |
The legal name of the designated facility. |
Designated Facility Mail Street Number |
DES_FAC_MAIL_STREET_NO |
The street number from the designated facility's primary business mailing address. |
Designated Facility Mail Street 1 |
DES_FAC_MAIL_STREET1 |
First line of the street address (or the post office box number) for the designated facility's primary business mailing address. |
Designated Facility Mail Street 2 |
DES_FAC_MAIL_STREET2 |
Second line of the street address (or the post office box number) for the designated facility's primary business mailing address. |
Designated Facility Mail City |
DES_FAC_MAIL_CITY |
Name of the city or town of the designated facility's mailing address. |
Designated Facility Mail Zip |
DES_FAC_MAIL_ZIP |
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. |
Designated Facility Mail State |
DES_FAC_MAIL_STATE |
State code of the mailing address. [see nationally-defined values] |
Designated Facility Location Street Number |
DES_FAC_LOCATION_STREET_NO |
Street number from the physical address of the primary site entrance of the designated facility. |
Designated Facility Location Street 1 |
DES_FAC_LOCATION_STREET1 |
First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance of the designated facility. |
Designated Facility Location Street 2 |
DES_FAC_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 of the designated facility. |
Designated Facility Location City |
DES_FAC_LOCATION_CITY |
Name of the city or town in which the designated facility is physically located. |
Designated Facility Location Zip |
DES_FAC_LOCATION_ZIP |
The zip code in which the designated facility 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. |
Designated Facility Location State |
DES_FAC_LOCATION_STATE |
State code of the location address. [see nationally-defined values] |
Designated Facility Contact Company Name |
DES_FAC_CONTACT_COMPANY_NAME |
The company name associated with the designated facility's contact person. |
Designated Facility Contact First Name |
DES_FAC_CONTACT_FIRST_NAME |
The first name of the designated facility's contact person. |
Designated Facility Contact Last Name |
DES_FAC_CONTACT_LAST_NAME |
The last name of the designated facility's contact person. |
Designated Facility Contact Email |
DES_FAC_CONTACT_EMAIL |
The email address of the designated facility's contact person. |
Designated Facility Contact Phone Number |
DES_FAC_CONTACT_PHONE_NUMBER |
The telephone number of the designated facility's contact person. |
Designated Facility Contact Phone Number Extension |
DES_FAC_CONTACT_PHONE_NO_EXT |
The telephone number extension of the designated facility's contact person. |
Is the Designated Facility Registered |
DES_FAC_REGISTERED |
Indicates if the designated facility existed in RCRAInfo at the time the manifest was submitted. [Y - Yes; N - No] |
Was the Designated Facility Modified |
DES_FAC_MODIFIED |
Indicates if the name, mailing address, or location address of the designated facility were modified. [Y - Yes; N - No] |
Generator Printed Name |
GENERATOR_PRINTED_NAME |
The name of the individual representing the generator that signed the manifest. |
Generator Signature Date |
GENERATOR_SIGNATURE_DATE |
The date the individual representing the generator signed the manifest. |
Generator Electronic Signature First Name |
GENERATOR_ESIG_FIRST_NAME |
The first name of the individual representing the generator that electronically signed the manifest. |
Generator Electronic Signature Last Name |
GENERATOR_ESIG_LAST_NAME |
The last name of the individual representing the generator that electronically signed the manifest. |
Generator Electronic Signature Date |
GENERATOR_ESIG_SIGNATURE_DATE |
The date the individual representing the generator electronically signed the manifest. |
Designated Facility Printed Name |
DES_FAC_PRINTED_NAME |
The name of the individual representing the designated facility that signed the manifest for initial receipt of the waste. |
Designated Facility Signature Date |
DES_FAC_SIGNATURE_DATE |
The date the individual representing the designated facility signed the manifest for initial receipt of the waste. |
Designated Facility Electronic Signature First Name |
DES_FAC_ESIG_FIRST_NAME |
The first name of the individual representing the designated facility that electronically signed the manifest and committed the manifest to an invoice. This signer may not always be the signer who received the waste. |
Designated Facility Electronic Signature Last Name |
DES_FAC_ESIG_LAST_NAME |
The last name of the individual representing the designated facility that electronically signed the manifest and committed the manifest to an invoice. This signer may not always be the signer who received the waste. |
Designated Facility Electronic Signature Date |
DES_FAC_ESIG_SIGNATURE_DATE |
The date the individual representing the designated facility electronically signed the manifest and committed the manifest to an invoice. |
Manifest Special Handling Instructions |
MANIFEST_HANDLING_INSTR |
Special handling or shipment-specific information pertaining to the manifest that is necessary for the proper management or tracking of the materials under the generator's or other handler's business processes, such as waste profile numbers, container codes, bar codes, or response guide numbers. This may also contain additional descriptive information about the wastes including chemical names, constituent percentages, or physical state. |
Rejection ID | REJECTION_ID | Unique identifier to the associated rejection information (i.e., foreign key to ID in MREJECTION). |
Import ID | IMPORT_ID | Unique identifier to the associated import information (i.e., foreign key to ID in MIMPORT). |
Date of Last Change | LAST_CHANGE | The date the manifest information was last changed. |
Rejection Indicator |
REJECTION |
Indicates if the shipment is a rejected load (i.e., rejected by the designated and/or alternate facility and is sent to an alternate facility or returned to the generator) or a regulated residue that cannot be removed from a container. |
Manifest Residue Indicator |
RESIDUE |
Indicates that the manifest had at least one waste that had container residues that exceeded the quantity limits for "empty" containers set forth in 40 CFR 261.7(b). [Y - Yes; N - No] |
Original Submission Type | ORIG_SUBMISSION_TYPE | Indicates what type of manifest was originally submitted. [see nationally-defined values] |
Broker EPA ID | BROKER_ID | The U.S. EPA's twelve-digit identification number of the broker facility. |
Total Acute Waste Quantity, in Kilograms | TOTAL_QUANTITY_ACUTE_KG | The total quantity of acute waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Acute Waste Quantity, in Tons | TOTAL_QUANTITY_ACUTE_TONS | The total quantity of acute waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Non-Acute Waste Quantity, in Kilograms | TOTAL_QUANTITY_NON_ACUTE_KG | The total quantity of non-acute waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Non-Acute Waste Quantity, in Tons | TOTAL_QUANTITY_NON_ACUTE_TONS | The total quantity of non-acute waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Hazardous Waste Quantity, in Kilograms | TOTAL_QUANTITY_HAZ_KG | The total quantity of hazardous waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Hazardous Waste Quantity, in Tons | TOTAL_QUANTITY_HAZ_TONS | The total quantity of hazardous waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Non-Hazardous Waste Quantity, in Kilograms | TOTAL_QUANTITY_NON_HAZ_KG | The total quantity of non-hazardous waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Non-Hazardous Waste Quantity, in Tons | TOTAL_QUANTITY_NON_HAZ_TONS | The total quantity of non-hazardous waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Waste Quantity, in Kilograms | TOTAL_QUANTITY_KG | The total quantity of waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Total Waste Quantity, in Tons | TOTAL_QUANTITY_TONS | The total quantity of waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Transporter EPA IDs | TRANSPORTER_IDS | A concatenation (in the order as they appeared on the manifest) of the U.S. EPA's twelve-digit identification number of the transporters of the waste. |
Transporter Names | TRANSPORTER_NAMES | A concatenation (in the order as they appeared on the manifest) of the legal name of the transporters. |
Previous Residue | PREVIOUS_RESIDUE | Indicates that the previous manifest had at least one waste that had container residues that exceeded the quantity limits for "empty" containers set forth in 40 CFR 261.7(b). |
New Manifest Destination | NEW_MANIFEST_DESTINATION | Indicates the entity (Generator, Transporter, Tsdf, etc.) where the waste reported on the new manifest will be taken. |
Original Manifest Tracking Numbers | ORIG_MANIFEST_TRACKING_NUMBERS | The original manifest tracking number or numbers associated with this manifest. |
Certified By User Id | CERTIFIED_BY_USER_ID | The user id that certified the manifest. |
Certified By First Name | CERTIFIED_BY_FIRST_NAME | The first name of the user that certified the manifest. |
Certified By Last Name | CERTIFIED_BY_LAST_NAME | The last name of the user that certified the manifest. |
Original Certified Date | ORIGINAL_CERTIFIED_DATE | The date the manifest was originally certified. |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the transporter information. |
Transporter Line Number |
TRANSPORTER_LINE_NUMBER |
Indicates the order in which the transporters are listed on the manifest. |
Transporter EPA ID |
TRANSPORTER_ID |
The U.S. EPA's twelve-digit identification number of the transporter of the waste. |
Transporter Name |
TRANSPORTER_NAME |
The legal name of the transporter. |
Transporter Printed Name |
TRANSPORTER_PRINTED_NAME |
The name of the individual representing the transporter that signed the manifest. |
Transporter Signature Date |
TRANSPORTER_SIGNATURE_DATE |
The date the individual representing the transporter signed the manifest. |
Transporter Electronic Signature First Name |
TRANSPORTER_ESIG_FIRST_NAME |
The first name of the individual representing the transporter that electronically signed the manifest. |
Transporter Electronic Signature Last Name |
TRANSPORTER_ESIG_LAST_NAME |
The last name of the individual representing the transporter that electronically signed the manifest. |
Transporter Electronic Signature Date |
TRANSPORTER_ESIG_SIGNATURE_DATE |
The date the individual representing the transporter electronically signed the manifest. |
Manifest ID |
MANIFEST_ID |
Unique identifier to the associated manifest information (i.e., foreign key to MANIFEST_ID in MMANIFEST). |
Registered Transporter Indicator | REGISTERED_TRANSPORTER | Indicates that the transporter was registered in the RCRAInfo system when the manifest was created. |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the import information. |
Port of Entry State |
PORT_OF_ENTRY_STATE |
The state postal code where an import shipment entered the United States. |
Port of Entry City |
PORT_OF_ENTRY_CITY |
The city where an import shipment entered the United States. |
Foreign Generator Name |
FOREIGN_GENERATOR_NAME |
The legal name of the foreign generator shipping waste to the United States. |
Foreign Generator Address |
FOREIGN_GENERATOR_ADDRESS |
The street address, route number or other specific identifier describing the physical address of the primary site entrance of the foreign generator. |
Foreign Generator City |
FOREIGN_GENERATOR_CITY |
Name of the city or town in which the foreign generator is physically located. |
Foreign Generator Postal Code |
FOREIGN_GENERATOR_POSTAL_CODE |
The postal code in which the foreign generator is physically located. |
Foreign Generator Province |
FOREIGN_GENERATOR_PROVINCE |
Name of the province or state in which the foreign generator is physically located. |
Foreign Generator Country Code |
FOREIGN_GENERATOR_COUNTRY_CODE |
The country code in which the foreign generator is physically located. [see nationally-defined values] |
Foreign Generator Country Name |
FOREIGN_GENERATOR_COUNTRY_NAME |
The country name in which the foreign generator is physically located. |
Manifest ID |
MANIFEST_ID |
Unique identifier to the associated manifest information (i.e., foreign key to MANIFEST_ID in MMANIFEST). |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the manifest reference information. |
Label |
LABEL |
Identifies the type of reference information that is being provided at the manifest level. |
Reference Description |
REFERENCE_DESCRIPTION |
Specific information related to the reference information being provided at the manifest level. |
Manifest ID |
MANIFEST_ID |
Unique identifier to the associated manifest information (i.e., foreign key to MANIFEST_ID in MMANIFEST). |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the import information. |
Article or Container ID |
ARICLE_CONTAINER ID |
Identifier of the article or container. Applicable for load types of Article in Container, Article not in Container, and Container. |
Bulk Identity |
BULK_IDENTITY |
The identity of the PCB waste associated with bulk waste. |
Date of Removal |
DATE_OF_REMOVAL |
The earliest date of removal from service for disposal. |
Load Type |
LOAD_TYPE_CODE |
The type of PCB waste offered for transportation [ArticleInContainer, ArticleNotInContainer, BulkWaste, and Container] |
Load Type Description |
LOAD_TYPE_DESCRIPTION |
Description of the type of PCB waste offered for transporation. |
Waste Type |
WASTE_TYPE |
Type of PCB waste (e.g., soil, debris, small capacitors). |
Weight |
WEIGHT |
The weight (in kilograms) of the PCB waste. |
Waste Line ID |
WASTE_LINE_ID |
Unique identifier to the associated waste line information (i.e., foreign key to ID in MWASTE_LINE). |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the rejection information. |
Rejection Type Indicator |
REJECTION_TYPE |
Indicates if the rejected load was a full or partial rejection. |
Rejection Transporter On-site Indicator |
REJECTION_TRANSPORTER_ONSITE |
Indicates if the transporter was still at the designated facility (or alternate facility) when the load was rejected. [Y - Yes; N - No] |
Alternate Destination Facility Type |
ALT_DES_FACILITY_TYPE |
Indicates if the rejected load was sent to an alternate facility or back to the generator. [Tsdf - Alternate Facility; Generator - Original Generator] |
Alternate Designated Facility EPA ID |
ALT_FACILITY_ID |
The U.S. EPA's twelve-digit identification number of the alternate designated facility. |
Alternate Designated Facility Name |
ALT_FACILITY_NAME |
The legal name of the alternate designated facility. |
Alternate Designated Facility Mail Street Number |
ALT_FAC_MAIL_STREET_NO |
The street number from the alternate designated facility's primary business mailing address. |
Alternate Designated Facility Mail Street 1 |
ALT_FAC_MAIL_STREET1 |
First line of the street address (or the post office box number) for the alternate designated facility's primary business mailing address. |
Alternate Designated Facility Mail Street 2 |
ALT_FAC_MAIL_STREET2 |
Second line of the street address (or the post office box number) for the alternate designated facility's primary business mailing address. |
Alternate Designated Facility Mail City |
ALT_FAC_MAIL_CITY |
Name of the city or town of the alternate designated facility's mailing address. |
Alternate Designated Facility Mail Zip |
ALT_FAC_MAIL_ZIP |
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. |
Alternate Designated Facility Mail State |
ALT_FAC_MAIL_STATE |
State code of the mailing address. [see nationally-defined values] |
Alternate Designated Facility Location Street Number |
ALT_FAC_LOCATION_STREET_NO |
Street number from the physical address of the primary site entrance of the alternate designated facility. |
Alternate Designated Facility Location Street 1 |
ALT_FAC_LOCATION_STREET1 |
First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance of the alternate designated facility. |
Alternate Designated Facility Location Street 2 |
ALT_FAC_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 of the alternate designated facility. |
Alternate Designated Facility Location City |
ALT_FAC_LOCATION_CITY |
Name of the city or town in which the alternate designated facility is physically located. |
Alternate Designated Facility Location Zip |
ALT_FAC_LOCATION_ZIP |
The zip code in which the alternate designated facility 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. |
Alternate Designated Facility Location State |
ALT_FAC_LOCATION_STATE |
State code of the location address. [see nationally-defined values] |
Alternate Designated Facility Contact Company Name |
ALT_FAC_CONTACT_COMPANY_NAME |
The company name associated with the alternate designated facility's contact person. |
Alternate Designated Facility Contact First Name |
ALT_FAC_CONTACT_FIRST_NAME |
The first name of the alternate designated facility's contact person. |
Alternate Designated Facility Contact Last Name |
ALT_FAC_CONTACT_LAST_NAME |
The last name of the alternate designated facility's contact person. |
Alternate Designated Facility Contact Email |
ALT_FAC_CONTACT_EMAIL |
The email address of the alternate designated facility's contact person. |
Alternate Designated Facility Contact Phone Number |
ALT_FAC_CONTACT_PHONE_NUMBER |
The telephone number of the alternate designated facility's contact person. |
Alternate Designated Facility Contact Phone Number Extension |
ALT_FAC_CONTACT_PHONE_NO_EXT |
The telephone number extension of the alternate designated facility's contact person. |
Is the Alternate Designated Facility Registered |
ALT_FAC_REGISTERED |
Indicates if the alternate designated facility existed in RCRAInfo at the time the manifest was submitted. [Y - Yes; N - No] |
Was the Alternate Designated Facility Modified |
ALT_FAC_MODIFIED |
Indicates if the name, mailing address, or location address of the alternate designated facility were modified. [Y - Yes; N - No] |
Manifest ID |
MANIFEST_ID |
Unique identifier to the associated manifest information (i.e., foreign key to MANIFEST_ID in MMANIFEST). |
Alternate Designated Facility Printed Name |
ALT_FAC_PRINTED_NAME |
The name of the individual representing the alternate designated facility that signed the manifest. |
Alternate Designated Facility Signature Date |
ALT_FAC_SIGNATURE_DATE |
The date the individual representing the alternate designated facility signed the manifest. |
Alternate Designated Facility Electronic Signature First Name |
ALT_FAC_ESIG_FIRST_NAME |
The first name of the individual representing the alternate designated facility that electronically signed the manifest. |
Alternate Designated Facility Electronic Signature Last Name |
ALT_FAC_ESIG_LAST_NAME |
The last name of the individual representing the alternate designated facility that electronically signed the manifest. |
Alternate Designated Facility Electronic Signature Date |
ALT_FAC_ESIG_SIGNATURE_DATE |
The date the individual representing the alternate designated facility electronically signed the manifest. |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the waste line information. |
Waste Line Number |
WASTE_LINE_NUMBER |
Indicates the line number of this waste on the manifest. |
U.S. DOT Hazardous Material Indicator |
DOT_HAZARDOUS |
Indicates that the waste information provided on this waste line is a DOT federally-regulated hazardous material. [Y - Yes; N - No] |
U.S. DOT ID Number |
DOT_ID_NUMBER |
The Department of Transportation identification number. |
U.S. DOT Description |
DOT_PRINTED_INFORMATION |
The Department of Transportation description including the proper shipping name, hazard class or division, and packing group. |
Non-Hazardous Waste Description |
NON_HAZ_WASTE_DESCRIPTION |
The description of the non-hazardous waste being manifested. |
Number of Containers |
CONTAINER_NUMBER |
The number of containers for each waste. |
Container Type Code |
CONTAINER_TYPE_CODE |
Code indicating the type of container the waste was transported in. [see nationally-defined values] |
Container Type Description |
CONTAINER_TYPE_DESCRIPTION |
A description of the container the waste was transported in. |
Waste Quantity |
QUANTITY |
The total quantity of waste. |
Quantity Unit of Measure Code |
QTY_UNIT_OF_MEASURE_CODE |
Code indicating the unit of measure associated with the quantity of waste reported. [see nationally-defined values] |
Quantity Unit of Measure Description |
QTY_UNIT_OF_MEASURE_DESC |
A description of the unit of measure associated with the quantity of waste reported. |
Waste Quantity, in Tons |
QUANTITY_TONS |
The total quantity of waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Acute Waste Quantity, in Tons |
QUANTITY_ACUTE_TONS |
The total quantity of acute waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Non-Acute Waste Quantity, in Tons |
QUANTITY_NON_ACUTE_TONS |
The total quantity of non-acute waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Hazardous Waste Quantity, in Tons | QUANTITY_HAZ_TONS | The total quantity of hazardous waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Non-Hazardous Waste Quantity, in Tons | QUANTITY_NON_HAZ_TONS | The total quantity of non-hazardous waste, in short tons. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Waste Quantity, in Kilograms |
QUANTITY_KG |
The total quantity of waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Acute Waste Quantity, in Kilograms |
QUANTITY_ACUTE_KG |
The total quantity of acute waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Non-Acute Waste Quantity, in Kilograms |
QUANTITY_NON_ACUTE_KG |
The total quantity of non-acute waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Hazardous Waste Quantity, in Kilograms | QUANTITY_HAZ_KG | The total quantity of hazardous waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Non-Hazardous Waste Quantity, in Kilograms | QUANTITY_NON_HAZ_KG | The total quantity of non-hazardous waste, in kilograms. Note: A value of 8.34 lbs/gal (the density of water) is used for volumetric wastes where no density was provided. |
Management Method Code |
MANAGEMENT_METHOD_CODE |
Code that best describes the way in which the waste is to be managed when received by the facility. [see nationally-defined values] |
Management Method Description |
MANAGEMENT_METHOD_DESCRIPTION |
A description of the management method that best describes the way in which the waste is to be managed when received by the facility. |
Waste Residue Indicator |
WASTE_RESIDUE |
Indicates that the waste had container residues that exceeded the quantity limits for "empty" containers set forth in 40 CFR 261.7(b). [Y - Yes; N - No] |
Waste Residue Comments |
WASTE_RESIDUE_COMMENTS |
Additional comments describing the residues associated with this waste. |
Quantity Discrepancy Indicator |
QUANTITY_DISCREPANCY |
Indicates if the discrepancy reported is a quantity discrepancy (i.e., there was a significant difference between the quantity of hazardous waste designated on the manifest and the quantity of hazardous waste a facility actually received). [Y - Yes; N - No] |
Waste Type Discrepancy Indicator |
WASTE_TYPE_DISCREPANCY |
Indicates if the discrepancy reports is a waste type discrepancy (i.e., there was a significant difference between the type of hazardous waste designated on the manifest and the type of hazardous waste a facility actually received). [Y - Yes; N - No] |
Discrepancy Comments |
DISCREPANCY_COMMENTS |
Additional comments describing the discrepancy. |
Waste Density |
BR_DENSITY |
Density of the waste. |
Waste Density Unit of Measure Code |
BR_DENSITY_UOM_CODE |
Code Indicating the unit of measure associated with the density of the waste. [see nationally-defined values] |
Waste Density Unit of Measure Description |
BR_DENSITY_UOM_DESCRIPTION |
A description of the unit of measure associated with the density of the waste. |
Form Code |
BR_FORM_CODE |
Code describing the physical form or chemical composition of a hazardous waste. Form codes indicate whether the waste is a specific type of lab pack, sludge, gas, solid, or liquid. [see nationally-defined values] |
Form Code Description |
BR_FORM_CODE_DESCRIPTION |
A description of the physical form or chemical composition of a hazardous waste. Form codes indicate whether the waste is a specific type of lab pack, sludge, gas, solid, or liquid. |
Source Code |
BR_SOURCE_CODE |
Code describing the industrial process that generated the waste. [see nationally-defined values] |
Source Code Description |
BR_SOURCE_CODE_DESCRIPTION |
A description of the industrial process that generated the waste. |
Waste Minimization Code |
BR_WASTE_MIN_CODE |
Code describing the type of waste minimization, recycling, or pollution prevention efforts used to reduce the volume and toxicity of the hazardous waste generated. [see nationally-defined values] |
Waste Minimization Code Description |
BR_WASTE_MIN_DESCRIPTION |
A description of the type of waste minimization, recycling, or pollution prevention efforts used to reduce the volume and toxicity of the hazardous waste generated. |
Consent Number |
CONSENT_NUMBER |
The consent number in EPA's import consent documentation that applies to this waste. |
Waste Line Special Handling Instructions |
WASTE_LINE_HANDLING_INSTR |
Special handling or shipment-specific information pertaining to this particular waste that is necessary for the proper management or tracking of the materials under the generator's or other handler's business processes, such as waste profile number, container code, bar code, or response guide numbers. This may also contain additional descriptive information about the waste including chemical names, constituent percentages, or physical state. |
Manifest ID |
MANIFEST_ID |
Unique identifier to the associated manifest information (i.e., foreign key to MANIFEST_ID in MMANIFEST). |
PCB Indicator |
PCB |
Indicates if the waste reported on the waste line contains PCBs (refer to 40 CFR 761.207). [Y - Yes; N - No] |
U.S. EPA Hazardous Waste Indicator |
EPA_WASTE |
Indicates that the waste information provided on this waste line is an EPA federally-regulated hazardous waste. [Y - Yes; N - No] |
Federal Waste Codes | FEDERAL_WASTE_CODES | A concatenation (in alphabetical order) of the Federal waste codes reported for this waste. |
State Waste Codes | STATE_WASTE_CODES | A concatenation (in alphabetical order by State Waste Code Owner and State Waste Code) of the State waste codes reported for this waste. |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the manifest federal waste code information. |
Federal Waste Code |
FEDERAL_WASTE_CODE |
Federal waste code reported for this waste. [see nationally-defined values] |
Waste Line ID |
WASTE_LINE_ID |
Unique identifier to the associated waste line information (i.e., foreign key to ID in MWASTE_LINE). |
COI Indicator |
COI_INDICATOR |
Indicates if the waste is a chemical of interest (coi). [Y - Yes; N - No] |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the manifest federal waste code information. |
State Waste Code Owner |
STATE_WASTE_CODE_OWNER |
Indicates the State that defined the state waste code. |
State Waste Code |
STATE_WASTE_CODE |
State waste code reported for this waste. |
Waste Line ID |
WASTE_LINE_ID |
Unique identifier to the associated waste line information (i.e., foreign key to ID in MWASTE_LINE). |
English Name | Oracle Name | Description |
ID |
ID |
Unique internal identifier (synthetic key) associated with the waste line reference information. |
Label |
LABEL |
Identifies the type of reference information that is being provided at the waste line level. |
Reference Description |
REFERENCE_DESCRIPTION |
Specific information related to the reference information being provided at the waste line level. |
Waste Line ID |
WASTE_LINE_ID |
Unique identifier to the associated waste line information (i.e., foreign key to ID in MWASTE_LINE). |