Definition

The Patient data model provides a comprehensive, longitudinal record of individuals registered with healthcare organizations. It serves as the foundational dataset for patient-centric information, containing demographic details, registration status, and other key administrative data. This model is essential for accurately identifying and managing patient information across various healthcare services and systems.

Information

The Patient data model is a structured representation of all essential information related to an individual receiving healthcare services. It typically includes patient identifiers, demographic details, patient type, registration status, patient data preferences, access preferences and so on. This model ensures accurate, secure, and efficient management of patient data across healthcare systems.

Each patient record is uniquely identified by a combination of patient_id and organisation, ensuring a distinct entry for every individual within a specific healthcare organization.

Key Data Fields

Patient Identifiers

• patient_id: A unique identifier for the patient within the system.

Demographics

• date_of_birth: The patient’s date of birth.
• sex: The patient’s sex.
• date_of_death: The date of death, if applicable.

Overview

flowchart TB
    subgraph container["Patient Data"]
        n1["Demographics"]
        n2["Vital Status"]
    end

    n3["Patient Record"] --> container
    container --> n4["Patient Data Model"]

Examples

Basic Patient Query

from ehrql import Dataset
from ehrql.tables.core import patients

dataset = Dataset()
dataset.define_population(patients.exists_for_patient())

dataset.sex = patients.sex
dataset.date_of_birth = patients.date_of_birth