[Health record linkage: Andalusian health population database]. / Conexión de registros sanitarios: base poblacional de salud de Andalucía.
Gac Sanit
; 34(2): 105-113, 2020.
Article
in Es
| MEDLINE
| ID: mdl-31133300
ABSTRACT
OBJECTIVE:
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.METHOD:
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.RESULTS:
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.CONCLUSION:
The work has shown that the connection of health records opens new possibilities for data analysis.Key words
Almacenamiento de datos; Conexión de registros médicos; Data analysis; Data warehouse; Decision support systems; Electronic health records; Estadística; Health information systems; Historia clínica electrónica; Investigación; Medical record linkage; Organización y administración; Organization and administration; Research; Sistemas de ayuda a decisiones; Sistemas de información en salud
Full text:
1
Collection:
01-internacional
Database:
MEDLINE
Main subject:
Registries
/
Databases, Factual
/
Electronic Health Records
/
Health Information Management
Type of study:
Prognostic_studies
Limits:
Humans
Country/Region as subject:
Europa
Language:
Es
Journal:
Gac Sanit
Journal subject:
SAUDE PUBLICA
Year:
2020
Document type:
Article