Description:
A hazardous waste generator's hazardous waste manifests.
Search parameters:
One or more of the following search parameters need to be specified in order to retrieve data:
| activityId |
Yes |
The hazardous waste generator's Identification Number.
|
| shipDateAfter |
|
Only select data that was shipped on or after this date (in "yyyy-mm-dd" or "dd-mon-yyyy" format).
|
| shipDateBefore |
|
Only select data that was shipped on or before this date (in "yyyy-mm-dd" or "dd-mon-yyyy" format).
|
Additional parameters:
The following, optional, parameters may be specified:
| format |
The desired return format. Valid formats are: {json, jsonp, text, csv, xls, ods, and tab}. The default is json. |
| callback |
The JSONP callback function name (Note that format needs to be "jsonp"). |
| fields |
The comma-separated-list of the field names to return from the query. The default is to return all available fields. |
| nullValue |
Value to substitute in place of null values. The default is to return null values as "null" (per JSON.org). |
| limit |
The number of records to limit the result set to. Behaves like the SQL standard LIMIT clause. |
| offset |
Used with Limit-- the record number to start retrieving from. Behaves like the SQL standard OFFSET clause. |
Result Set Definitions:
| activityId |
The hazardous waste generator's Identification Number. |
| discrepancyCode |
Identifies changes made to the manifest. |
| discrepancyDefn |
Describes changes made to the manifest. (this should be all null - process prevents entering into system) (remove) |
| discrepancyUpdtDate |
Date a change was made to the manifest in the MCPA's database. |
| disposalId |
The hazardous waste disposal facilities' Identification Number. |
| docReceivedDateDisposal |
The date that the manifest document, signed by the disposal facility, was received by the MPCA. |
| docReceivedDateGenerator |
The date the manifest document is received by the MPCA |
| fedDocNumber |
The federal manifest identification number used on the shipping document. |
| haulerId1 |
The hazardous waste hauler's Identification Number. |
| haulerId2 |
The hazardous waste hauler's Identification Number. |
| manifestId |
MPCA identification number for the manifest document. |
| pickupDate |
The date the hazardous waste shipment is picked up from the generator by the hauler. |
| receivedDate |
The date the hazardous waste shipment was dropped off at the disposal facility. |
| shipDate |
The date hazardous waste was shipped from the generator. |
| streetState |
The state the waste was generated in. |
| transferDate |
The date the hazardous waste shipment is picked up from the first hauler by a second hauler. |
Example Queries: