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

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

Título del libro: 2012 Proceedings Of Portland International Center For Management Of Engineering And Technology: Technology Management For Emerging Technologies, Picmet'12
Título del capítulo: Patenting in the UNAM's Research Centers considering its knowledge profile

Autores UNAM:
LEONEL CORONA TREVIÑO;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2012

---

Palabras clave:

Applied science; Conversion process; Entrepreneurial attitude; Functional activities; IS technologies; Me-xico; Research center; Scientific knowledge; Scientific researches; Technical service; Technology development; Industrial management; Research; Technology transfer; Patents and inventions

---

Resumen:

One important actor in the conversion process of scientific knowledge into Technology are Universities Research Centers, RC, which are engaged in scientific research (Sc), technology development (Tech), technical services (S), and teaching activities (t). The products of these activities are the publication of "papers", graduation of people, -mainly masters and PhDs-, services and patents which are part of Technology Development and Technology Transfer to industry. The mix of those functional activities and products defines the RC's profile. The paper's focuses on how patents are related with the Mexico National University (UNAM) RCs profile. The statistical analysis shows no direct effect of technology intensity with patenting. There is no sustained increase in UNAM patenting for the period 1975-2007, but two maximum peaks of applications appeared in 1989 and in 2002 which are triggered by a variety of internal and external events. One explanation of this pattern is Technology Transfer Offices at the UNAM which have moved forward and backwards from centralized agency into a more flexible and diverse organization at research centers, showing a lack of a proactive university policy on patenting and technology transfer. An overlapping policy of the disciplinary UNAM's RCs structure with entrepreneurial attitudes could provide a better dynamic for applied science and technology, and will give a positive impact on technology transfer. © 2012 IEEE.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
1890843261
Editorial:

Tipo de producto:
Conference Paper