Related Experiment Video
Updated: May 24, 2026

Methodology for Establishing a Community-Wide Life Laboratory for Capturing Unobtrusive and Continuous Remote Activity and Health Data
Published on: July 27, 2018
From Spreadsheets to FHIR and Research Databases: Digitizing Medication Data in Elderly Care Within the RM4Health
Vinícius Lima1, Rute Almeida1, Izabela Calvi1
1RISE-Health, MEDCIDS, Faculty of Medicine, University of Porto, Portugal.
This study introduces a structured datasheet for medication management in long-term care, improving data accuracy and enabling digital integration. The approach facilitates automated data exchange between systems, enhancing clinical and research capabilities.
Area of Science:
- Health Informatics
- Digital Health
- Long-Term Care Technology
Background:
- Medication management in long-term care is predominantly paper-based, leading to data fragmentation and errors.
- Limited data reusability hinders clinical decision-making and research in long-term care settings.
- The RM4Health project aimed to improve medication data management in Portuguese long-term care facilities.
Purpose of the Study:
- To implement a structured datasheet template for single-point medication data entry.
- To develop services for converting data into HL7 FHIR MedicationStatement resources and REDCap.
- To demonstrate bidirectional data flow between REDCap and FHIR resources.
Main Methods:
- Adoption of a structured datasheet with embedded validations for medication data entry.
- Development of services to convert XLS data to HL7 FHIR and CSV formats.
- Implementation of bidirectional data conversion between REDCap and FHIR.
Main Results:
- The structured datasheet template proved easy to adopt in the Portuguese use case.
- Automated conversion services facilitated data integration into clinical and research systems.
- Bidirectional data flow between REDCap and FHIR resources was demonstrated as feasible.
Conclusions:
- Low-friction changes at the data entry point can significantly improve data flows in long-term care.
- The use of open standards like HL7 FHIR supports seamless integration of medication data.
- This approach enhances data accuracy, reusability, and interoperability in long-term care settings.
Related Concept Videos
Documentation in Long-Term and Home Healthcare Setting
Long-Term Care Facilities
Drug Dosing: Geriatric Patients
Health Information Technology and Healthcare Information System
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Flow Sheet
Here's a closer look at the examples of flowsheets commonly used by nurses:
Graphic Sheet Documentation:
Purpose of Health Records II
Methods of Documentation VII: EMR
