DATA ELEMENT DICTIONARY - E-MANIFEST MODULE

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. 

 

   

 

MMANIFEST

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.

MTRANSPORTER

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.

MIMPORT

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

MMANIFEST_REFERENCE

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

MPCB_INFO

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

MREJECTION

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.

MWASTE_LINE

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.

MFEDERAL_WASTE_CODE

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]

MSTATE_WASTE_CODE

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

MWASTE_LINE_REFERENCE

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