Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Documentation in Long-Term and Home Healthcare Setting01:29

Documentation in Long-Term and Home Healthcare Setting

Documentation in long-term care facilities and home healthcare settings is crucial for ensuring continuous, coordinated, and comprehensive care for patients. Each setting has its specific documentation processes and tools:
Long-Term Care Facilities
Methods of Documentation VII: EMR01:30

Methods of Documentation VII: EMR

Electronic Medical Records (EMRs) primarily center around electronically documenting patients' health information within a single healthcare organization or practice. They contain essential clinical data related to a patient's medical history, diagnoses, medications, treatment plans, lab results, and other pertinent information relevant to the specific encounter or episode of care. EMRs are designed to streamline documentation and workflow processes within individual healthcare settings,...
Methods of Documentation II: POMR01:26

Methods of Documentation II: POMR

The Problem-Oriented Medical Record (POMR) revolutionized medical record-keeping by introducing a systematic approach focusing on the patient's problems rather than merely listing symptoms. Dr. Lawrence Weed's introduction of this method in the 1960s marked a significant advancement in medical documentation. The POMR framework consists of four key components: the database, problem list, plan of care, and progress notes.

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Prediction of appropriate implantable cardioverter-defibrillator therapy using machine learning and routinely available clinical data.

European heart journal. Digital health·2026
Same author

The German National Strategy for Gene- and Cell-Based Therapies: Generating Impact by Employing a Novel Multi-Stakeholder Approach.

Human gene therapy·2026
Same author

From Idea to Data: An Agentic Architecture for the Clinical Trial Life Cycle.

Studies in health technology and informatics·2026
Same author

KoRob: A Berlin-Brandenburg Research Network for Social Robotics and Health Informatics in Transition Societies.

Studies in health technology and informatics·2026
Same author

[Revisiting Risk Classification in the German Maternity Record: First Results from the FeMaR Study].

Zeitschrift fur Geburtshilfe und Neonatologie·2026
Same author

Digital technologies for healthy longevity: A policy agenda from the Einstein circle on inclusive, data-driven ageing societies.

Ageing research reviews·2026

Related Experiment Video

Updated: Jul 4, 2026

A Data Integration Workflow to Identify Drug Combinations Targeting Synthetic Lethal Interactions
07:40

A Data Integration Workflow to Identify Drug Combinations Targeting Synthetic Lethal Interactions

Published on: May 27, 2021

LLM-Assisted Clinical Data Harmonization: Combining Automated ETL Generation with Semantic Vocabulary Mapping for

Falk Meyer-Eschenbach1,2,3, Martin Vogel3, Philipp Jacob3

  • 1Institute of Medical Informatics, Charité - Universitätsmedizin Berlin, Berlin, Germany.

Studies in Health Technology and Informatics
|July 3, 2026
PubMed
Summary

Large Language Models (LLMs) streamline clinical data transformation into the Observational Medical Outcomes Partnership (OMOP) Common Data Model. LLMs automate structural mapping and semantic harmonization, reducing manual effort while requiring expert validation.

Keywords:
Clinical Data HarmonizationETLLarge Language ModelsOMOP Common Data ModelVocabulary Mapping

More Related Videos

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts
07:50

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts

Published on: September 20, 2018

Related Experiment Videos

Last Updated: Jul 4, 2026

A Data Integration Workflow to Identify Drug Combinations Targeting Synthetic Lethal Interactions
07:40

A Data Integration Workflow to Identify Drug Combinations Targeting Synthetic Lethal Interactions

Published on: May 27, 2021

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts
07:50

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts

Published on: September 20, 2018

Area of Science:

  • Clinical Informatics
  • Artificial Intelligence in Healthcare
  • Data Standardization

Background:

  • Transforming diverse clinical data into the OMOP Common Data Model (CDM) is complex, requiring significant technical and clinical expertise for schema mapping and vocabulary harmonization.
  • Existing methods for OMOP CDM transformation are often labor-intensive and time-consuming, hindering efficient data utilization for research and clinical decision-making.

Purpose of the Study:

  • To investigate the efficacy of Large Language Models (LLMs) in automating structural schema mapping and semantic vocabulary harmonization for OMOP CDM transformation.
  • To evaluate the performance of LLM-guided approaches using the eICU Collaborative Research Database and validate results with clinical experts.

Main Methods:

  • Structural transformation: Utilized context-enriched prompting with White Rabbit profiling reports to guide Gemini 2.5 Pro in generating PostgreSQL Extract-Transform-Load (ETL) scripts for populating OMOP core tables.
  • Semantic mapping: Implemented a hybrid approach combining vector similarity search with LLM refinement to map clinical terms to Logical Observation Identifiers Names and Codes (LOINC) and Anatomical Therapeutic Chemical (ATC) codes.
  • Validation: Clinical experts from Charité - Universitätsmedizin Berlin validated the semantic mapping results.

Main Results:

  • LLM-generated ETL scripts successfully populated eight OMOP core tables after five debugging iterations for structural transformation.
  • The hybrid semantic mapping approach achieved high precision: 93.9% for medications (n=148) and 78.5-96.8% for laboratory terms (n=158).
  • LLM refinement significantly improved precision, raising medication mapping from 60.8% to 93.9% and laboratory term mapping from 62.0-88.6% to 78.5-96.8%.

Conclusions:

  • LLMs show significant potential in automating both structural and semantic aspects of OMOP CDM transformation, substantially reducing manual effort across clinical domains.
  • A hybrid approach combining LLM capabilities with expert validation ensures accuracy and reliability in clinical data standardization.
  • Expert supervision remains crucial for ensuring the quality and clinical validity of the transformed OMOP CDM data.