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

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

Título del libro:
Título del capítulo: Simulation Applied to a Consulting Team Assignment Problem

Autores UNAM:
ESTHER SEGURA PEREZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2024

---

Palabras clave:

Information management; Assignment problems; Hexagonal tessellation; Multi-criteria; Multi-criteria assignment; Multi-Criterion; Process-oriented simulations; Service program; Social service; Student teams; Team assignment; Students

---

Resumen:

There are intermediary entities that improve the administration of human resources, adapting agents? profiles with companies? requests. This paper presents a university social service program that requires student teams to give consultancies to companies? groups but has a desertion problem derived from an assignment with long distances and incompatibility between schedules and requirements. We use process-oriented simulation to analyze some proposed methodologies and variants of the classic assignment problem as possible solutions while uncovering the need for a flexible method that enables continuous modification and maintains easy user data management. We define our human resources case with multiple attributes (distance, requirements, and schedules) as a multi-criteria assignment model with quadratic (QAP) and qualified semi-assignment characteristics. To solve it, we use a tessellation to facilitate the inclusion and reduction of distances between agents and tasks while evaluating the qualified association of the requirement and schedules as categorical variables. We integrate a modular method based on hexagonal tessellation, reducing the dedicated time from 5 days to 90 min and a total distance of 585 km between students and companies while improving the schedules and requirements compatibility, solving the real problem in its context. We hope this will contribute to other assignment problems with a similar structure or goals. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.

---

Entidades citadas de la UNAM:

---

Fuente:



ISBN:
9783031684371
Editorial:
Springer Science and Business Media Deutschland GmbH

Tipo de producto:
Conference Paper

DOI:
10.1007/978-3-031-68438-8_14