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

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

Título del libro: Digital Transformation And Innovation In Organizations: A Latin American Perspective
Título del capítulo: Value of Data in Organizations: An Approach Through Enterprise Architecture

Autores UNAM:
ANA LAURA GUERRERO MORALES; MARIA GUADALUPE CALDERON MARTINEZ; LORENZO ALEJANDRO MENDEZ RODRIGUEZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2025

---

Palabras clave:

Architecture; Behavioral research; Computation theory; Data handling; Data quality; Decision making; Information management; Information systems; Information use; Metadata; System theory; Age data; Daily activity; Data and information; Datapoints; Enterprise Architecture; Information age; Information data; Information ecosystems; Information information; Processing time; Decision support systems

---

Resumen:

People have always been viewed as organizations? most valued assets. However, in the information age, data and information have begun to rival humans. Daily activities and decisions are now based on having information available at the right time. Yet having millions of data points only a click away is insufficient. Data are only valuable if they are transformed into information and used to create value in an organization. This study explores the development and implementation of an information ecosystem that supports data-driven decision-making within the context of Industry 5.0 and digital transformation. By integrating concepts from General Systems Theory (GST), Enterprise Architecture (EA), and human-centric design, the study proposes a novel model for transforming raw data into actionable insights. A case study in the insurance sector demonstrates the model's practical utility, showcasing improvements in data processing time, data quality, and decision support. Statistical analysis confirms the operational benefits, with significant reductions in processing time and error rates. This study contributes to theory, practice, and industry by offering a conceptual framework, practical guidance, and a vision for human-centric information ecosystems in Industry 5.0. © 2025 The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783031907944
Editorial:
Springer Science+Business Media

Tipo de producto:
Book chapter

DOI:
10.1007/978-3-031-90794-4_5