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 = '503249' 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 = '503249' 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 = '503249' 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 = '503249' 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 = '503249']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '503249'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 503249 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= 503249]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 503249 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= 503249

Título del libro: Proceedings Of The Asme International Mechanical Engineering Congress And Exposition, 2014, Vol 11
Título del capítulo: Sustainability assessment of products: A comparative study of sustainability assessment tools

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

---

Autores externos:

---

Idioma:

---

Año de publicación:
2015

---

Palabras clave:

INTEROPERABILITY

---

Resumen:

The number of existing tools, principles and approaches to assess sustainability in products is growing to meet industry and society needs. For those related to design and development in universities, research institutes and companies it is a fundamental issue to recognize features and details of the sustainability assessment tools in order to select the one that best fits their particular needs. This paper describes the outcomes of a product sustainability assessment carried out at Universidad Nacional Autonoma de Mexico, UNAM. The approach followed by the authors in this assessment was aimed at comparing the results provided by a set of software tools and a previous sustainability integrated-criteria tool developed by the research group. The main contribution of this paper is the insight on the software tools used and on the results of the assessment since the design point of view. The results of the assessment included metrics such as: carbon footprint, energy use, end of life potential, toxicity, eco-toxicity, human toxicity, recyclability, and others. In the first part of the paper, an introduction of the criteria and the software based tools for sustainability assessment used by the authors is presented. Then a justification of the tools used and an explanation on how the comparison was achieved are given. The product used as a case study and the results of its sustainability assessment are presented. The case study part is a home appliance subsystem. In the end of the paper conclusions, insights and further work are given.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780791849606
Editorial:
AMER SOC MECHANICAL ENGINEERS

Tipo de producto:
Proceedings Paper