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 = '688368' 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 = '688368' 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 = '688368']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 688368 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= 688368]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 2023 Mexican International Conference On Computer Science, Enc 2023 Título del capítulo: Enhancing Hospital Efficiency Through Web-Deployed Object Detection: A YOLOv8-Based Approach for Automating Healthcare Operations
Autores UNAM: JOSE ANTONIO NEME CASTILLO;
Autores externos: Idioma: Año de publicación: 2024Palabras clave:
YOLOv8 model; Web applications; Deep learning model; Detection and recognition; Hospital operation efficiency; Healthcare sector; Hospital management systems; Computers; Smartphones
Resumen:
Hospital operation efficiency plays a crucial role in health- care delivery and patient outcomes. Traditional hospital sys- tems, often managed manually, are subject to human error and inefficiencies. There is a pressing need to automate certain tasks to improve speed, accuracy, and resource utilization. This research paper presents an innovative approach towards hospital automation using a You Only Look Once version 8 (YOLOv8) deep learning model. We propose training the YOLOv8 model to detect and recognize several classes per- tinent to hospital operations including Ambulances, Beds, Wheelchairs, Stethoscopes, Medical equipment, Stretchers, Band-aids, and Towels. This model is planned to be deployed in web applications using React.js and TensorFlow.js, enabling its use on various platforms including computers, smartphones, and tablets. By integrating this technology with hospital management systems, we aim to assist hospital personnel in their tasks and improve operational efficiency. This could potentially increase the precision and speed of routine tasks, improve resource tracking, and enable healthcare workers to concentrate more on patient care
Entidades citadas de la UNAM:
Fuente:
ISBN: 9798350393156 Editorial: Institute of Electrical and Electronics Engineers Inc.
