Ontario Ministry of the Environment, Conservation and Parks (MECP)
Hazardous Waste Public Information


USER GUIDE for MANIFEST AND GENERATOR REGISTRATION INFORMATION


INTRODUCTION:

The Hazardous Waste Public Information dataset contains information summarized by calendar year about the Generators, Carriers and Receivers of hazardous and liquid industrial waste as defined by Regulation 347 under the Ontario Environmental Protection Act.  The data extracted from the Hazardous Waste Information Network (HWIN) comes from:

a.  Generator registration process under Regulation 347.

b.  Ministry Environmental Compliance Approvals (ECAs) for waste management systems (Carriers) and waste disposal sites (Receivers).

c.  Manifests that have been submitted to the ministry to document the transfer of subject waste as defined under Regulation 347.


GENERAL CONTENTS:

This dataset contains the following information:

a.  GENERATOR_INFO – Lists generator contact and site information for generators that were registered in HWIN system during the calendar year
b.  GENERATOR_WASTE_INFO – Lists waste class codes, characterizations, and physical states of wastes registered by the generator during the calendar year.
c.  CARRIER_INFO – Lists contact and site information for carriers that had an active ECA that was registered in HWIN during the calendar year.
d.  CARRIER_WASTE_INFO – Lists waste class codes, as they appear on their ECA
e.  RECEIVER_INFO – Lists receiver contact and site information for receivers that had an active ECA that was registered in HWIN during the calendar year
f.  RECEIVER_WASTE_INFO – Lists waste class codes, as they appear on their ECA
g.  GENERATOR_MANIFEST – Lists quantity of waste shipped by a generator, grouped by: waste class code, characterization, receiver type, receiver district
h.  CARRIER_MANIFEST – Lists quantity of waste transported by the carrier and is grouped by waste class code. 
i.  RECEIVER_MANIFEST – Lists quantity of waste received at a receiver site grouped by, waste class code, characterization, generator district, and generator NAICS code 1.
j.  COUNTY_LOOKUP – County names matched to county codes found in other tables
k.  DISTRICT_LOOKUP – District names matched to the ministry district codes found in other tables
l.  RECEIVER_LOOKUP – Receiver type description matched to receiver type codes found in other tables
m.  REGION_LOOKUP – Ministry Region names matched to region codes found in other tables
n.  WASTE_CHARACTERISTIC_LOOKUP – Waste characterization name based on one letter code found in other tables
o.  WASTE_CODE_LOOKUP – Waste class name based on waste class codes found in other tables



DATA STRUCTURE & SYSTEM REQUIREMENTS:

All the data files are in MS Access structure and can be used directly by all database software that can open, read, or import MDB files.


DATA DISCLAIMER


Users of this dataset are notified of the following data issues that are particular to this dataset:  
•	All generator, carrier and receiver company information was provided by the generator, carrier or receiver  
•	Certain data (i.e. NAICS codes) is not complete for all companies, be sure to include nulls when creating any queries to retrieve a complete dataset  
•	Waste codes: generators may have duplicate waste codes for several reasons, including that some may be managed on-site while others may be disposed of off-site, and some may have different physical states;  
•	Generator waste represents wastes that were at one time active, and does not necessarily reflect active wastes during the year in which the datasets are published;
•	Waste physical state: the physical state of each generator waste code was provided by the generator and was not confirmed as being accurate by the ministry;  
•	Handling code: handling codes for generator waste codes were not included in this dataset;  
•	On-site waste management: data on waste managed on-site were not included in this dataset. This omission represents only a small fraction of the total waste generated.

Company and waste data are submitted by waste generators during the registration process and updated throughout the year as required. Waste movement data is entered throughout the year based on manifest documents submitted by generators and receivers.  All data originates from generators, carriers and receivers through online data entry or correspondence with HWIN administrative staff.  The data may be entered by the generators or HWIN administrative staff. Modification to the data is only performed at the request and consent of the companies involved, by generator registration, generator registration updates, manifests entry and manifest corrections submitted by companies.




DATA DICTIONARY


Table:  CARRIER_INFO

CAR_NO:  Environmental Compliance Approval number and a unique identifier
CAR_NAME:  Carrier company name 
CAR_DIV:  Unique Carrier identifier supplied by the private entity
CAR_OP_DIV:  Unique Carrier identifier supplied by the private entity
SITE_BUILDING: (Refers to the base address of the Carrier and not where operations are carried out)
SITE_POBOX: post office box number (Refers to the base address of the Carrier and not where operations are carried out) 
SITE_ADDRESS1:  Address line one (Refers to the base address of the Carrier and not where operations are carried out)
SITE_ADDRESS2: Address line two (Refers to the base address of the Carrier and not where operations are carried out)
SITE_CITY:  City (Refers to the base address of the Carrier and not where operations are carried out)
SITE_PROVINCE_IN:  Province or state if within Canada or USA(Refers to the base address of the Carrier and not where operations are carried out)
SITE_PROVINCE_OUT:  Province or state if outside of Canada or USA (Refers to the base address of the Carrier and not where operations are carried out)
SITE_POSTAL:  Postal or Zip code (Refers to the base address of the Carrier and not where operations are carried out)
SITE_COUNTY_IN:  Carriers County if within Ontario (Refers to the base address of the Carrier and not where operations are carried out)  
SITE_COUNTY_OUT:  Carriers County if outside of Ontario (Refers to the base address of the Carrier and not where operations are carried out)
SITE_COUNTRY:  Country (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_BUILDING:  (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_POBOX:  post office box number (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_ADDRESS1:  Address line one (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_ADDRESS2:  Address line two (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_CITY:  (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_PROVINCE_IN:  Province or state if within Canada or USA(Refers to the base address of the Carrier and not where operations are carried out)
MAIL_PROVINCE_OUT:  Province or state if outside of Canada or USA (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_POSTAL:  Postal or Zip code (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_COUNTY_IN:  Carriers County if within Ontario (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_COUNTY_OUT:  Carriers County if outside of Ontario (Refers to the base address of the Carrier and not where operations are carried out)
MAIL_COUNTRY:  Country (Refers to the base address of the Carrier and not where operations are carried out)
CO_OFFICIAL:  Company official’s name 
CO_ADMIN:  Company’s HWIN Administrator’s name
CHOICE_OF_CONTACT:  Company’s preferred contact
PHONE_NO_OFFICIAL:  Company official’s phone number  
PHONE_NO_ADMIN:  Company HWIN Administrator’s phone number
DISTRICT:  Ministry District code for company’s base of operations.  
Refer to DISTRICT_LOOKUP table (Refers to the base address of the Carrier and not where operations are carried out)


Table:  CARRIER_WASTE

CAR_NO: Environmental Compliance Approval number and a unique identifier
WASTE_CODE:  Waste code(s) the Carrier is approved to transport.  Refer to WASTE_CODE_LOOKUP table


Table:  COUNTY_LOOKUP
COUNTY_CODE:  County code
COUNTY_NAME:  Name of County
MOE_DISTRICT_CODE:  County’s District code.  Refers to which ministry District the County lies in.  Refer to DISTRICT_LOOKUP table
MOE_REGION_CODE:  County’s Region code.  Refers to which ministry Region the County lies in. Refer to REGION_LOOKUP table


Table:  DISTRICT_LOOKUP

MOE_DISTRICT_CODE:  Ministry District code
OFFICE_NAME:  Name of District
MOE_REGION_CODE:  District’s Region code.  Refers to which ministry Region the District lies in. Refer to REGION_LOOKUP table


Table:  GENERATOR_INFO

GEN_NO:  Generator’s registration number or if out of Ontario, generator’s unique identifier from home jurisdiction
GEN_NAME:  Generator’s legal company name
GEN_DIV:  Generator’s legal division name 
GEN_OP_NAME:  Generator’s operating company name 
GEN_OP_DIV:  Generator’s operating division name 
SITE_BLDG: Generating site building name 
SITE_POBOX: Generating site post office box number
SITE_ADRS1:  Generating site address line one
SITE_ADRS2: Generating site address line two  
SITE_CITY:  Generating site city  
PROVINCE_IN:  Site province or state if within Canada or USA  
PROVINCE_OUT:  Site province or state if outside of Canada or USA  
SITE_COUNTRY:  Site country  
CO_OFFICIAL:  Company official’s name 
CO_ADMIN:  Company’s HWIN Administrator’s name
CHOICE_OF_CONTACT:  Company’s preferred contact
PHONE_NO_OFFICIAL:  Company official’s phone number  
PHONE_NO_ADMIN:  Company HWIN Administrator’s phone number
COUNTY_ONT:  Generating site’s county if within Ontario  
COUNTY_OUT:  Generating site’s county if outside of Ontario  
MHSW_FACILITY: Generating site is a Municipal Household Special Waste depot, yes or no
CONTAMINATED_FACILITY:  Waste generated from the site is a result of activities undertaken to remediate a contaminated facility, yes or no  
NAICS_CODE1:  Generator’s primary North American Industry Classification identifier
NAICS_CODE2:  Generator’s secondary North American Industry Classification identifier
NAICS_CODE3:  Generator’s tertiary North American Industry Classification identifier
DISTRICT:  Ministry District code for company’s base of operations. Refer to DISTRICT_LOOKUP table (Refers to the base address of the Carrier and not where operations are carried out)


Table:  GENERATOR_WASTE

GEN_NO:  Generator’s registration number or if out of Ontario, generator’s unique identifier from home jurisdiction
WASTE_CODE:  Waste code(s) the Generator has registered with the ministry as generated or generating.  Refer to WASTE_CODE_LOOKUP table
WASTE_CHARAC:  Waste characteristic(s) the Generator has used to describe/define the waste codes that are registered.  Refer to WASTE_CHAR_LOOKUP table
PHYSICAL_STATE:  Physical state of the registered waste code (solid, liquid, gas)


Table:  MANIFEST_CARRIER

CARRIER_NUMBER:  Environmental Compliance Approval number and a unique identifier
WASTE_CODE:  Waste code(s) the Carrier is approved to transport.  Refer to WASTE_CODE_LOOKUP table
WASTE_COUNT:  Number of times the waste code appears on a line on a manifest where the Carrier was referred to in Part B
QTY_RECEIVED:  Total quantity of waste with the same waste code where the Carrier was referred to in Part B received by a Receiver in kilograms.


Table:  MANIFEST_GENERATOR

GENERATOR_NUMBER:  Generator’s registration number or if out of Ontario,generator’s unique identifier from home jurisdiction
RECEIVER_DISTRICT:  Ministry District code for the waste receiver.  
Refer to DISTRICT_LOOKUP table (Refers to the base address of the Carrier and not where operations are carried out)
RECEIVER_TYPE: Type of receiver that received the waste. Refer to REC_TYPE_LOOKUP table
WASTE_CODE:  Waste code(s) the Carrier is approved to transport.  Refer to WASTE_CODE_LOOKUP table
WASTE_CHAR:  Waste characteristic(s) the Generator has used to describe/define the waste codes that are shipped.  Refer to WASTE_CHAR_LOOKUP table
WASTE_COUNT:  Number of times the waste code, with that waste characteristic, going to a receiver in that district, of that type appears on a line on a manifest where the Generator was referred to in Part A of the manifest
QTY_RECEIVED:  Total quantity of waste with the same waste code where the Generator was 
referred to in Part A of the manifest received by a Receiver in kilograms.


Table:  MANIFEST_RECEIVER

RECEIVER_NUMBER:  Environmental Compliance Approval number and a unique identifier
GENERATOR_DISTRICT:  Ministry District code for the waste
generator.  Refer to DISTRICT_LOOKUP table (Refers to the base address of the Carrier and not where operations are carried out)
GENERATOR_NAICS_CODE1:  Primary North American Industry Classification (NAICS) code supplied by the generator
WASTE_CODE:  Waste code(s) the Receiver is approved to transport.  Refer to WASTE_CODE_LOOKUP table
WASTE_CHAR:  Waste characteristic(s) the Generator has used to describe/define the waste codes that are shipped.  Refer to WASTE_CHAR_LOOKUP table
WASTE_COUNT:  Number of times the waste code, with that waste characteristic, coming from a generator with that specified NAICS in that specified district on a line on a manifest where the Receiver was referred to in Part C of the manifest
QTY_RECEIVED:  Total quantity of waste with the same waste code/waste characteristic where the Generator was from the same district and had the same NAICS code, received by a Receiver referred to in section C of a manifest in kilograms.


Table:  RECEIVER_INFO

RECEIVER_NO:  Receiver’s registration number or if out of Ontario, receiver’s unique identifier from home jurisdiction
REC_NAME:  Receiver’s legal company name 
REC_DIV:  Receiver’s legal division name
REC_OP_NAME:  Receiver’s operating company name 
REC_OP_DIV:  Receiver’s operating division name 
SITE_BLDG: Receiving site building name
SITE_POBOX: Receiving site post office box number
SITE_ADRS1:  Receiving site address line one
SITE_ADRS2: Receiving site address line two  
SITE_CITY:  Receiving site city  
PROVINCE_IN:  Site province or state if within Canada or USA  
PROVINCE_OUT:  Site province, or state if outside of Canada or USA
SITE_COUNTRY:  Site country  
POSTCODE:  Site postal code
CO_OFFICIAL:  Company official’s name 
CO_ADMIN:  Company’s HWIN Administrator’s name
CHOICE_OF_CONTACT:  Company’s preferred contact
PHONE_NO_OFFICIAL:  Company official’s phone number  
PHONE_NO_ADMIN:  Company HWIN Administrator’s phone number
COUNTY_ONT:  Receiving site’s county if within Ontario  
COUNTY_OUT:  Receiving site’s county if outside of Ontario  
DISTRICT:  Ministry District code for company’s base of operations. Refer to DISTRICT_09 table (Refers to the base address of the Carrier and not where operations are carried out)
RECEIVER_TYPE:  Type of receiver. Refer to REC_TYPE_LOOKUP table


Table:  RECEIVER_TYPE_LOOKUP

RECEIVER_TYPE:  Receiver type code
RECEIVER_TYPE_DESC:  Receiver type description


Table:  RECEIVER_WASTE

RECEIVER_NO: Environmental Compliance Approval number and a unique identifier
WASTE_CODE:  Waste code(s) the receiver is approved to receive.  Refer to WASTE_CODE_LOOKUP table


Table:  REGION_LOOKUP

MOE_REGION_CODE:  District’s Region code.  Refers to which ministry Region the District lies in
OFFICE_NAME:  Name of Region
 

Table: WASTE_CHARACTERISTIC_LOOKUP

WASTE_CHARAC:  Waste characteristic Identifier
WASTE_CHARAC_DESC:  Description of waste characteristic


Table:  WASTE_CODE_LOOKUP

WASTE_CODE:  Waste code number
WASTE_CLASS_NAME:  Description of waste code
 
