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 = '267378' 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 = '267378' 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 = '267378']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 267378 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= 267378]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 27th European Modeling And Simulation Symposium, Emss 2015 Título del capítulo: Ambulance location using linear programming: The case of the National Autonomous University of Mexico (UNAM)
Heuristic algorithms; Hospitals; Linear programming; Location; Coverage models; First aids; High school; Higher education; Me-xico; P-median; Pre-hospital cares; Set coverings; Ambulances
Resumen:
Every Year the Universidad Nacional Autónoma de Mexico Holds Four Entry Exams for Higher Education and High School. For Which the Candidates Do A Written Exam in Any One of 25 Schools in the Metropol. Area of the Valley of Mex. That the UNAM Uses to Hold Its Entry Exams. A Med. Serv. Module Manned by A Doctor and Nurse with An Equipped First-aid Kit Is Installed in Each Sch.. Moreover, Five Properly Equipped Ambulances Are Available and Distributed Around the Metropol. Area to Reinforce This Med. Attention As Regards the Treatm. and Transf. of Patients. at the Present Time the Five Ambulances Are Located Empirically Based on the Experience of the Emergency Med. Technicians so That the Distance between the Current Location of the Ambulance and the Modules or Schools Is What They Believe to Be the Shortest. This Stud. Proposes A Three-step Methodol. for Optimizing the Location of Five Ambulances Based on the Location Set Covering Prob. Model and the P-median Model. the Solution Compares These Two Models, Allowing Us to Shorten the Response Time of the Pre-Hosp. Care Serv. by Locating the Five Ambulances Better, Considering A Var. of Speeds and Coverage Times. This Enables Us to Lower the Rate of Patient Mortality and Morbidity.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9788897999485 Editorial: Dime University of Genoa
