mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

problem feeprob_fee

The service charge associated with documenting, managing, or treating a specific active health condition in the patient problem list. Captures billing amounts tied to problem-based encounters, used in clinical and revenue cycle workflows to link diagnoses to costs.

problem first nameprob_first_nm

The given name of the patient or clinician associated with a documented health condition entry in the problem list. Used in EHR displays to identify the individual linked to the problem record within clinical documentation and patient history workflows.

problem flagprob_flg

A binary indicator field within EHR problem list or care management tables that marks an active health condition as requiring special attention, such as a sentinel diagnosis, quality measure gap, or care alert. Used by data engineers to filter priority conditions during risk stratification and clinical decision support processing.

problem frequencyprob_freq

The recurrence interval or episodic pattern of an active health condition as documented in the clinical problem list. Captures how often a condition manifests or is addressed, supporting chronic disease management, care planning, and longitudinal clinical tracking.

problem full nameprob_full_nm

The complete descriptive name of a documented health condition as it appears in the patient problem list, combining all name components into a single display value. Used in clinical documentation, reporting, and patient-facing health summaries across EHR systems.

problem genderprob_gndr

The sex or gender classification of the patient associated with a documented health condition in the clinical problem list. Used to contextualize diagnoses, apply gender-specific clinical guidelines, and support accurate population health analytics and care management.

problem glucoseprob_gluc

The blood glucose measurement recorded in association with an active health condition in the clinical problem list. Used to monitor metabolic conditions such as diabetes, track laboratory values linked to diagnoses, and inform treatment planning and disease management workflows.

problem group numberprob_grp_nbr

The insurance group identifier linked to the patient or encounter associated with an active health condition in the problem list. Used to correlate clinical problem documentation with coverage details, supporting billing reconciliation and payer-specific reporting workflows.

problem hemoglobinprob_hgb

The hemoglobin measurement recorded in connection with an active health condition in the clinical problem list. Used to monitor conditions such as anemia or chronic disease, linking laboratory results to diagnoses for ongoing disease management and clinical decision support.

problem history present illnessprob_hpi

The narrative description of a patient's current health condition as documented in the History of Present Illness section, linked to a specific problem list entry. Captures symptom onset, duration, and progression to provide clinical context supporting diagnosis and treatment decisions.

problem identifierprob_id

The unique surrogate or natural key assigned to an active health condition record within EHR, claims, or care management systems. Used by data engineers as the primary join key across problem list, encounter, and diagnosis tables to maintain referential integrity in clinical data warehouses and FHIR-based interoperability pipelines.

problem indexprob_idx

A sequential numeric position assigned to an active health condition within a patient's ordered problem list in EHR systems such as Epic or Cerner. Used by data engineers to preserve clinical prioritization order when transforming problem list data into analytical schemas or FHIR Condition resources for downstream consumption.

problem indicatorprob_ind

A Boolean or binary field signaling whether a specific clinical attribute or status is associated with an active health condition in EHR or claims systems. Commonly used in data pipelines to flag chronic conditions, sentinel diagnoses, or care gap presence for population health segmentation and quality reporting logic.

problem instructionprob_instr

Clinician-authored guidance text linked to an active health condition in EHR problem list or care plan records, detailing recommended monitoring, treatment, or follow-up actions. Used by data engineers to extract and parse free-text clinical directives for care management workflows, NLP pipelines, and structured data integration tasks.

problem keyprob_key

The unique surrogate or natural key value used to identify and retrieve a specific health condition record within the clinical problem list. Serves as the primary reference for linking problem list entries across EHR tables, data warehouses, and downstream clinical reporting systems.

problem labelprob_lbl

The human-readable display text assigned to an active health condition in the clinical problem list, representing the condition name or short descriptor shown in clinical interfaces. Used to present standardized or free-text problem descriptions consistently across EHR screens and reports.

problem languageprob_lang

The preferred communication language of the patient associated with a documented health condition in the clinical problem list. Used to ensure clinical documentation, patient education materials, and care communications related to the condition are delivered in the appropriate language.

problem last nameprob_last_nm

The family surname of the patient or clinician associated with a documented health condition in the clinical problem list. Used in EHR displays and reports to identify individuals linked to specific problem records within clinical documentation and patient history workflows.

problem legal nameprob_legal_nm

The officially registered legal name of the patient associated with a documented health condition in the clinical problem list. Used to ensure accurate patient identification in clinical records, regulatory reporting, and legal or administrative documentation tied to the problem entry.

problem levelprob_lvl

A hierarchical ranking value representing the clinical severity or organizational tier of an active health condition within EHR problem list or care management classification structures. Used by data engineers to apply condition prioritization logic, build parent-child diagnosis hierarchies, and support risk-adjusted population segmentation models.

PreviousPage 510 of 806Next