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

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

Título del libro: Towards Sustainable Technologies And Innovation - Proceedings Of The 27th Annual Conference Of The International Association For Management Of Technology, Iamot 2018
Título del capítulo: Technology foresight at a University Research Center in Mexico: Design and first results

Autores UNAM:
EUGENIO MARIO LOPEZ Y ORTEGA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2018

---

Palabras clave:

Industrial management; Knowledge management; Strategic planning; Corporate foresight; Me-xico; Research and development; Strategic decisions; Structural reliability; Technology foresight; University research; University research and development; Engineering research

---

Resumen:

Technology and corporate foresight has gained recognition as an instrument to aid the identification, construction and support of technological strategic decisions in organizations. Research and Development Centers (RDC)-a part of the National System of Science Technology and Innovation (SNCTI) in Mexico-could benefit from the results of a foresight process. One of the aims of technology foresight is to "identify areas of strategic research" (Martin, 1995). The main purpose of this paper is to present the progress and preliminary results of the application of a technology foresight process in a university research and development center in Mexico. The technology foresight process was designed based on a literature review-foresight, strategic planning and knowledge management- and is being applied in the Engineering Institute of the National Autonomous University of Mexico (IIUNAM), one of the main research centers in the country. A systems thinking approach is being used in order to identify the mayor stakeholders involved in the strategic planning of the IIUNAM. Research topics of interest (TI) for the IIUNAM were identified to guide the foresight process. For each TI selected, specific research topic (ST) were stablished which will be used to guide the scenario analysis in a next stage of the work. The methodology applied and first results of the technology foresight process is shown. The TI analysed is called: Natural Hazards in Civil Engineering and the ST corresponds to Structural Reliability. © 2018 Towards Sustainable Technologies and Innovation - Proceedings of the 27th Annual Conference of the International Association for Management of Technology, IAMOT 2018. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781854494535
Editorial:
Aston Business School, Aston University

Tipo de producto:
Conference Paper