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

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

Título del libro: 61st International Astronautical Congress 2010, Iac 2010
Título del capítulo: Academic aerospace programme at the UNAM

Autores UNAM:
CARLOS ROMO FUENTES; SAUL DANIEL SANTILLAN GUTIERREZ; JULIO CESAR RAMIREZ VELEZ; SAUL DE LA ROSA NIEVES;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2010

---

Palabras clave:

Academic program; Aerospace field; Future challenges; Integration process; Internal network; International partners; New satellites; Postgraduate programs; Research areas; Research groups; Research topics; Satellite platforms; Satellite technology; Scientific cooperation; Space projects; Space technologies; Working groups; College buildings; Design; Engineering research; Space optics; Students; Technology; Satellites

---

Resumen:

Universidad Nacional Autónoma de México (UNAM) has been working on space projects during years, however, there is a new push to develop more projects in the aerospace field. Amongst them are, the generation of academic programs, the foundation of an internal R&D network and the design of a new satellite platform. These projects would help to consolidate a group of researchers with expertise in the field and capabilities for proposing and executing R&D projects with international partners. The article describes the integration processes for the Mexican satellite platform, the development of academic programs and the foundation of the university network of space technology at the UNAM. Projects are supported by a group of specialists in different fields, including engineers, geophysics, geographers and other users of satellite technology. The design of satellite platforms has been the main focus for the group, nowadays is working on the project "CONDOR UNAM MAI". The process for developing components and systems for the satellite platform are contributing to establish research areas and promoting international academic and scientific cooperation in space technology projects. Researchers forming the group have begun the draft design of the satellite platform defining the tasks to be accomplished and components to be integrated. Academic programs have been set for students in both, undergraduate and postgraduate programs in engineering. The definition of the subsystems to integrate the platform is under way, with the vision to get specific working groups that will attack the future challenges as the projects develops. The work for establishing the internal network is running at the same time, in order to establish different research topics related to aerospace. A strong effort is dedicated on generating cooperation links or partnerships with different institutions or industries. Through these projects UNAM is strengthening the research in space technology and supporting the formation of specialized research group in the aerospace field. Copyright ©2010 by the International Astronautical Federation. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781617823688
Editorial:

Tipo de producto:
Conference Paper