Warning This Web page has been archived on the Web.

Archived Content

Information identified as archived on the Web is for reference, research or recordkeeping purposes. It has not been altered or updated after the date of archiving. Web pages that are archived on the Web are not subject to the Government of Canada Web Standards. As per the Communications Policy of the Government of Canada, you can request alternate formats on the Contact Us page.

NAI2 Code
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
NAICS_CODEText5List of 2 digit North American Industrial Classification System Codes identifying the types of businesses and industries.1998
NAICS_EText50English Description1998
NAICS_FText50French Description1998

 

NAI3 Code
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
NAICS_CODEText5List of 3 digit North American Industrial Classification System Codes identifying the types of businesses and industries. 
NAICS_EText50English Description 
NAICS_FText50French Description 

 

NAI4 Code
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
NAICS_CODEText4List of 4 digit North American Industrial Classification System Codes identifying the types of businesses and industries.1998
NAICS_EText50English Description1998
NAICS_FText50French Description1998

 

NAI6 Code
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
NAICS_CODEText6List of 2 digit North American Industrial Classification System Codes identifying the types of businesses and industries.1998
NAICS_EText50English Description1998
NAICS_FText50French Description1998

 

 

Other_ID
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
REPORTIDNumber10Internal Report Tracking Number2011
REP_PERIODText9The NPRI reporting period 
NPRI_IDText10An assigned unique 10 digit number 
IDENTIFICATION OF OTHER REGULATIONS or PERMITS
ID_NUMBERText15Identification Number or Permit Number 
PROGRAMText120Government Department, Agency, or Program Name 

 

ProvCode
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
PROV_CODEText2List of 2 character Province Codes 
PROV_NAMEEText30English Description 
PROV_NAMEFText30French Description 

 

SDPeriod
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
REPORTIDNumber10Internal Report Tracking Number2011
REP_PERIODText9The NPRI reporting period2002
NPRI_IDText10A unique facility identification number2002
START_DATEText10Start date of shutdown period2002
END_DATEText10End date of shutdown period2002

 

Stacks
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
REP_PERIODText9The NPRI reporting period2002
NPRI_IDText10A unique facility identification number2002
STAC_CODEText5A unique stack identification number (links with SPEC_Code in the Subs_DFs table and SPEC_TYPE in the Subs_VOCs table)2002
NAMEText60How stack is identified at facility2002
HEIGHTNumber6, 2Height of stack above grade (m)2002
DIAMETERNumber5, 2Equivalent diameter of stack (m)2002
EXIT_VELONumber5, 1Average exit velocity (m/s)2002
EXIT_TEMPNumber4Average exit temperature (°C)2002
LATI_DEC
Number
3 , 4
Latitude of stack in decimal degree (optional) 
LONG_DEC
Number
3 , 4
Longitude of stack in decimal degree  (optional) 
LATITUDEText6Latitude of stack (optional)2002
LONGITUDEText7Longitude of stack (optional)2002

 

StatCode
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
STAT_CODEText2List of 2 character State Codes 
STAT_NAMEEText30English Description 
STAT_NAMEFText30French Description 

 

 
 SubsD_Fs (new table for 2007)
Field NameTypeWidthField DescriptionFirst year new fields were added to the Reporting Software
REPORTIDNumber10Internal Report Tracking Number2011
REP_PERIOD
Text
9
The NPRI reporting period
-
NPRI_ID
Text
10
A unique facility identification number
-
SPEC_TYPE
Text
4
Type of Release, Disposal or Recycling:
(Same Codes as the Tran_Type field in the SubsTran table)
2008
Speciated Releases to Air:
 

AFug = Fugitive emissions to Air

ASta = Stack Releases to Air

ASto =Air release from Storage/handling

 
Speciated Releases to Surface Water Bodies (note these are actually releases and not transfers):
 

"WatD" = Direct Discharge to a water body

"WatS" = Spill to a water body

"WatL" = Leak to a water body

 
Speciated Releases to Land:
 

"LanS" = Spill to Land

"LanL" = Leak to Land

"LanO" = Other releases to Land

 
Disposals On-site:
 

"Olan" = Containment (landfill)

"Ofar" = Land treatment (Farm)

"Ound" = Underground injection

"Otai" = Tailings

"Owas" = Waste Rock

These 5 codes have no off-sites and therefore will not appear in this table
Disposal Offsite:
 

"Land" = Containment (landfill)

"Farm" = Land treatment (Farm)

"Unde" = Underground injection

"Stor" = Containment (storage)

"Tail" = Tailings

"Wast" = Waste Rock

 
Disposals Treatment:
 

"Phys" = Physical treatment

"Chem" = Chemical treatment

"Biol" = Biological treatment

"Inci" = Incineration/thermal

"MSTP" = Municipal Sewage Treatment Plants

 
Recycling:
 

"Ener" = Energy Recovery

"Solv" = Recovery of Solvents

"Orga" = Recovery of organic substances (not solvents)

"Meta" = Recovery of metals and metal compounds

"Inor" = Recovery of inorganic materials (not metals)

"Acid" = Recovery of acids or bases

"Cata" = Recovery of catalysts

"Abat" = Recovery of pollution abatement residues

"Uoil" = Refining or re-use of used oil

"Othe" = Other

 
Spec_Code
Text
5

A unique stack identification number (this code is equivalent to the Stac_Code in the Stacks table)
OR
A unique surface water body identification number (this code is equivalent to the Wate_Code in the Streams table)
AND
For 2000: A unique 5-digit code identifying the Off-site facility (this code is equivalent to the OffS_Code in the OffSites table)
OR
For 1995 - 1999: A 2-digit code is assigned for each off-site which is specific for each individual NPRI ID (i.e. the same code is used for more than one off-site but not for the same NPRI ID)
(this code is equivalent to the Addr_Code in the Address table)

  • Stack Code = "00999" or
  • Other Stacks/Points Code = "88888"or
  • Other Air Sources  Code = "88888" or
  • Surface Water Body Code = "00999"   or
  • Disposal On-site   Code = "88888"or
  • Disposal Off-site  Code = "10999"or
  • Disposal Treatment Code = "10999"or
  • Recycling Off-site Code = "10999"

NOTE: An "88888" number means a release/disposal/recycle without a destination code.

2008
SPEC_CAS
Text
11
Chemical Abstracts Service Registry Number of the identified Dioxin or Furan
-
SPEC_VALUE
Number
Double
Amount released, disposed of or transferred in gTEQ, calculated  by Environment Canada
2008
SPEC_GRAMS
Number
Double
Reported amount released, disposed of or transferred (in grams)
2008
UNITS_EDIT
Text
9
Quantities were entered in gram(me)s
 
UNIT_STOR
Text
9
All quantities may be normalized to tonnes