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

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

Título del libro: Summer Computer Simulation Conference, Scsc 2010 - Proceedings Of The 2010 Summer Simulation Multiconference, Summersim 2010
Título del capítulo: Simulation and optimization of the pre-hospital care system of the national university of Mexico using travelling salesman problem algorithms

Autores UNAM:
ESTHER SEGURA PEREZ; LUIS ANTONIO ALTAMIRANO YEPEZ; IDALIA FLORES DE LA MOTA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2010

---

Palabras clave:

Emergency medical technicians; Health-care system; Heuristic techniques; Hospital care; Hybrid methodologies; Me-xico; Mexico City; Microsoft excel; Occurrence probability; Prehospital service; Security modules; Shortest path algorithms; Shorthest route; Simulation and optimization; Simulation technique; Travelling salesman problem; Algorithms; Ambulances; Computer simulation; Health care; Heuristic methods; Optimization; Traveling salesman problem; Visual BASIC; Hospitals

---

Resumen:

A hybrid methodology was developed in this project, using optimization and simulation techniques to analyze efficiency in a pre-hospital healthcare system offered by Emergency Medical Technicians (TUMs) or paramedics. This healthcare is offered in the North and South of Mexico City while students are sitting their exams for admission to the National Autonomous University of Mexico. This study presents an optimization of the routes of an ambulance in charge of serving 26 security modules installed at schools where students were attending their admission exams. This optimization is done on the basis based on algorithms used to solve the travelling-salesman problem (TSP) and simulation is used to determine the scenarios where calls for the ambulance happen with a greater occurrence probability. Furthermore, the patient's transfer route from the hospital care module is optimized with the shortest path algorithm. The prehospital healthcare system is formed by 11 paramedics and 5 properly equipped ambulances. Heuristic techniques were programmed with the Visual Basic 6 programming language and the simulation was executed using the Microsoft Excel.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781617387029
Editorial:

Tipo de producto:
Conference Paper