TRI Explorer
Facility Profile Report
| Data Source: 2018 Updated Dataset (released October 2019) | See Note |
|
Instructions for printing wide reports
|
Exception -942 ORA-20000: select CASE WHEN SUM(TERRI.UNINJ_I) IS NULL and SUM(RCRA_C) IS NULL AND SUM(OTH_LANDF) IS NULL AND SUM(AIR_FUG) IS NULL AND SUM(AIR_STACK) IS NULL AND SUM(WATER) IS NULL AND SUM(UNINJ_IIV) IS NULL AND SUM(LAND_TREA) IS NULL AND SUM(SI_5_5_3A) IS NULL AND SUM(SI_5_5_3B) IS NULL AND SUM(OTH_DISP) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.UNINJ_I,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(RCRA_C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_LANDF,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(AIR_FUG,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(AIR_STACK,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(WATER,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(UNINJ_IIV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(LAND_TREA,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(SI_5_5_3A,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(SI_5_5_3B,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_DISP,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_ONSITE, CASE WHEN SUM(TERRI.OM81) IS NULL and SUM(TERRI.OM65) IS NULL AND SUM(TERRI.OM64) IS NULL AND SUM(TERRI.OM10) IS NULL AND SUM(TERRI.OM40M) IS NULL AND SUM(TERRI.OM41) IS NULL AND SUM(TERRI.OM61M) IS NULL AND SUM(TERRI.OM62) IS NULL and SUM(TERRI.P81D) IS NULL AND SUM(TERRI.OM82) IS NULL and SUM(TERRI.P81C) IS NULL AND SUM(TERRI.OM66) IS NULL and SUM(TERRI.OM67) IS NULL AND SUM(TERRI.OM73) IS NULL AND SUM(TERRI.OM79) IS NULL and SUM(TERRI.OM90) IS NULL AND SUM(TERRI.OM91) IS NULL AND SUM(TERRI.OM94) IS NULL and SUM(TERRI.OM99) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.OM81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_OFFSITE, CASE WHEN SUM(TERRI.UNINJ_I) IS NULL and SUM(TERRI.RCRA_C) IS NULL AND SUM(TERRI.OTH_LANDF) IS NULL AND SUM(TERRI.AIR_FUG) IS NULL AND SUM(TERRI.AIR_STACK) IS NULL AND SUM(TERRI.WATER) IS NULL AND SUM(TERRI.UNINJ_IIV) IS NULL AND SUM(TERRI.LAND_TREA) IS NULL AND SUM(TERRI.SI_5_5_3A) IS NULL AND SUM(TERRI.SI_5_5_3B) IS NULL AND SUM(TERRI.OTH_DISP) IS NULL AND SUM(TERRI.OM81) IS NULL and SUM(TERRI.OM65) IS NULL AND SUM(TERRI.OM64) IS NULL AND SUM(TERRI.OM10) IS NULL AND SUM(TERRI.OM40M) IS NULL AND SUM(TERRI.OM41) IS NULL AND SUM(TERRI.OM61M) IS NULL AND SUM(TERRI.OM62) IS NULL and SUM(TERRI.P81D) IS NULL AND SUM(TERRI.OM82) IS NULL AND SUM(TERRI.OM66) IS NULL and SUM(TERRI.OM67) IS NULL AND SUM(TERRI.OM73) IS NULL AND SUM(TERRI.OM79) IS NULL and SUM(TERRI.OM90) IS NULL AND SUM(TERRI.OM91) IS NULL AND SUM(TERRI.OM94) IS NULL and SUM(TERRI.OM99) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.UNINJ_I,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(RCRA_C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_LANDF,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.AIR_FUG,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.AIR_STACK,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.WATER,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.UNINJ_IIV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.LAND_TREA,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.SI_5_5_3A,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.SI_5_5_3B,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OTH_DISP,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_ONOFFSITE, CASE WHEN SUM(M20) IS NULL AND SUM(M24) IS NULL AND SUM(M26) IS NULL AND SUM(M28) IS NULL AND SUM(M93) IS NULL AND SUM(M56) IS NULL AND SUM(M92) IS NULL AND SUM(M40NOM) IS NULL AND SUM(M50) IS NULL AND SUM(M54) IS NULL AND SUM(M61NOM) IS NULL AND SUM(M69) IS NULL AND SUM(M95) IS NULL AND SUM(PTRT) IS NULL AND SUM(P81D) IS NULL AND SUM(INV) IS NULL AND SUM(M81) IS NULL AND SUM(M82) IS NULL AND SUM(M71) IS NULL AND SUM(M65) IS NULL AND SUM(M64) IS NULL AND SUM(M10) IS NULL AND SUM(M41M) IS NULL AND SUM(M40M) IS NULL AND SUM(M62M) IS NULL AND SUM(M61M) IS NULL AND SUM(M66) IS NULL AND SUM(M67) IS NULL AND SUM(M63) IS NULL AND SUM(M73) IS NULL AND SUM(M79) IS NULL AND SUM(M90) IS NULL AND SUM(M94) IS NULL AND SUM(M91) IS NULL AND SUM(M99) IS NULL THEN NULL ELSE SUM(NVL(M20,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M24,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M26,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M28,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M93,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M56,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M92,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M40NOM,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M50,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M54,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M61NOM,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M69,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M95,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(INV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M71,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M63,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(PTRT,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) end tot_tran_offsite from TRI_EX_RELEASE_REPORT_INFO TERRI where TERRI.TRI_FACILITY_ID = '65802MXXXX3211E' and TERRI.REPORTING_YEAR = '2005' and TERRI.TRI_CHEM_ID <> 'N150'