ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '518669' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '518669' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '518669' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '518669' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '518669']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '518669'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 518669 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 518669]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 518669 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 518669

Título del libro: Asme International Mechanical Engineering Congress And Exposition, Proceedings (imece)
Título del capítulo: Applying a design process to create a reduction platform of GHG in industries

Autores UNAM:
JAVIER NOE AVILA CEDILLO; VICENTE BORJA RAMIREZ; MARCELO LOPEZ PARRA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2010

---

Palabras clave:

Anthropogenic gas; Business schools; Carbon emissions; Carbon management; Environmental agency; Environmental organizations; New product development; University of California; Carbon; Climate change; Enterprise resource planning; Industry; International trade; Mechanical engineering; Sustainable development; Systems analysis; Teaching; Thermodynamics; Greenhouse gases

---

Resumen:

This paper describes the final results of a project aiming at addressing climate change by creating a GHG reduction platform for businesses with carbon management needs in global markets. The project was carried out during a New Product Development course in a bi-national program between The University of California at Berkeley (UCB) and the National University of Mexico (Universidad Nacional Autónoma de México, UNAM) in Mexico City. The program features collaboration between the Engineering and Design Schools at UNAM and Engineering and Business Schools at UCB and the College of Architecture CCA. The project, The Carbon Collaborative (TCC) is aimed at consolidating and managing the wide variety of policies and instruments created by governments and environmental organizations to mitigate climate change, and the anthropogenic gas emissions emitted by industry in particular in the US and Mexico. Based on a web platform TCC will provide companies with information on carbon legislation and a centralized location to find transparent and certified methodologies for carbon emission assessment. The differences between the US and Mexican markets lead to advantages for each part. The US market is full of developed consulting enterprises, which is not the case in the Mexican arena, giving to TCC the opportunity of being pioneers to regulate and manage large and small emitters, government environmental agencies and ERP (Enterprise Resource Planning) companies. Copyright © 2010 by ASME.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780791844298
Editorial:

Tipo de producto:
Conference Paper

DOI:
10.1115/IMECE2010-39382