RT Journal Article
T1 [Health record linkage: Andalusian health population database].
T2 Conexión de registros sanitarios: base poblacional de salud de Andalucía.
A1 Muñoyerro-Muñiz, Dolores
A1 Goicoechea-Salazar, Juan Antonio
A1 García-León, Francisco Javier
A1 Laguna-Téllez, Antonio
A1 Larrocha-Mata, Daniel
A1 Cardero-Rivas, Manuel
K1 Almacenamiento de datos
K1 Conexión de registros médicos
K1 Data analysis
K1 Data warehouse
K1 Decision support systems
K1 Electronic health records
K1 Estadística
K1 Health information systems
K1 Historia clínica electrónica
K1 Investigación
K1 Medical record linkage
K1 Organización y administración
K1 Organization and administration
K1 Research
K1 Sistemas de ayuda a decisiones
K1 Sistemas de información en salud
AB To describe the development of an information system that connects data from multiple health records to improve assistance to patients, health services administration, management, evaluation, and inspection, as well as public health and research. Deterministic connection of pseudonymized data from a population of 8.5 million inhabitants provided by: a users database, DIRAYA electronic medical records, minimum basic data sets (inpatients, outpatient mayor surgery, hospital emergencies and medical day hospital), mental health information systems, analytical and image tests, vaccines, renal patients, and pharmacy. An automatic coder was used to code clinical diagnoses and 80 chronic pathologies were identified to follow-up. The architecture of the information system consisted of three layers: data (Oracle Database 11g), applications (MicroStrategy BI) and presentation (MicroStrategy Web, JavaScript libraries, HTML 5 and CSS style sheets). Measures for the governance of the system were implemented. Data from 12.5 million health system users between 2001 and 2017 were gathered, including 435.5 million diagnoses, 88.7% of which were generated by the automatic coder. Data can be accessed through predefined reports or dynamic queries, both exportable to CSV files for processing outside the system. Expert analysts can directly access the databases and perform queries using SQL or directly treat the data with external tools. The work has shown that the connection of health records opens new possibilities for data analysis.
YR 2019
FD 2019-05-25
LK http://hdl.handle.net/10668/14026
UL http://hdl.handle.net/10668/14026
LA es
DS RISalud
RD Apr 19, 2025