OMOP CDM 5.4 for Beginners — Understand A to Z

Introducing the Series

OMOP CDM 5.4 for Beginners is the most comprehensive series in Vietnamese, helping you understand OMOP Common Data Model version 5.4 — the health data standard used by more than 400 organizations in 80 countries.

Problem

Medical data at each hospital is stored in its own way:

Bệnh viện A (HIS)          Bệnh viện B (EMR)          Bảo hiểm Y tế XH
├── patients               ├── nguoi_benh              ├── ho_so_kcb
├── diagnoses (ICD-10)     ├── chan_doan (ICD-10-VN)   ├── ma_benh
├── prescriptions           ├── don_thuoc               ├── thuoc_bh
└── lab_results            └── ket_qua_xn             └── xet_nghiem
    (khác format)              (khác format)               (khác format)

→ Cannot be compared, aggregated, or studied across hospitals.

Solution: OMOP CDM

                          OMOP Common Data Model 5.4
                    ┌─────────────────────────────────────┐
  Bệnh viện A ──→  │  PERSON                             │
  Bệnh viện B ──→  │  ├── VISIT_OCCURRENCE               │  ──→ Phân tích thống nhất
  BHYT        ──→  │  │   ├── CONDITION_OCCURRENCE        │  ──→ Nghiên cứu đa trung tâm
  Phòng khám  ──→  │  │   ├── DRUG_EXPOSURE               │  ──→ AI/ML trên dữ liệu y tế
                    │  │   ├── PROCEDURE_OCCURRENCE        │
                    │  │   ├── MEASUREMENT                 │
                    │  │   └── OBSERVATION                 │
                    │  ├── Standardized Vocabularies       │
                    │  └── Health System / Economics       │
                    └─────────────────────────────────────┘

What will you learn?

Part	Content	Article
1. Overview	OMOP CDM, architecture, Concept	Lesson 1-3
2. Person & Visit	PERSON, OBSERVATION_PERIOD, VISIT	Lesson 4-6
3. Clinical events	Condition, Drug, Procedure, Measurement	Lesson 7-10
4. Expansion Table	Observation, Device, Note, Death, Episode	Lesson 11-13
5. Vocabularies	Concept systems, Relationships, Mapping	Lesson 14-16
6. Systems & Economics	Location, Provider, Cost, Era tables	Lesson 17-19
7. Summary	Metadata, Cohort, roadmap	Lesson 20

Prerequisites

• Basic understanding of databases (know tables, columns, rows)
• Basic SQL (SELECT, JOIN, WHERE) — useful but not required
• No need for in-depth medical knowledge — every concept is explained

Different from OHDSI & OMOP CDM series

This series focuses 100% on the OMOP CDM 5.4 data structure — explaining each table, each field, with specific examples. If you want to learn more tools (ATLAS, WebAPI, ACHILLES, ETL), check out the series OHDSI & OMOP CDM — Comprehensive Healthcare Data Analysis.