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

diagnosis languagediag_lang

Records the preferred or primary language of the patient associated with a diagnosis record. Used in care coordination and patient communication workflows to ensure clinical documentation, discharge instructions, and follow-up materials are delivered in the patient's preferred language.

diagnosis last namediag_last_nm

Captures the family surname of the patient linked to a diagnosis record. Used for patient identification, record matching, and demographic display within clinical and administrative systems where patient identity information accompanies medical condition documentation.

diagnosis legal namediag_legal_nm

Stores the official legal name of the patient associated with a diagnosis record, as used in formal medical and legal documentation. Ensures accurate patient identity verification in clinical records, insurance submissions, and regulatory reporting contexts where legal name accuracy is required.

diagnosis leveldiag_lvl

Hierarchical classification tier assigned to a diagnosis within member-facing healthcare data processes, such as chronic condition stratification or risk adjustment levels. Used in population health, care management, and member enrollment analytics for segmentation and reporting.

diagnosis license numberdiag_lic_nbr

Records the professional license number of the clinician or practitioner who documented or confirmed the diagnosis. Used in credentialing validation, audit trails, and claims submission processes to verify that diagnoses are recorded by appropriately licensed healthcare professionals.

diagnosis marital statusdiag_mar_sts

Records the marital status of the patient at the time of diagnosis documentation. Captured in clinical and administrative records to support social determinants of health assessments, care coordination, and population health analytics linked to specific ICD-coded conditions.

diagnosis master identifierdiag_mstr_id

The enterprise-wide unique identifier assigned to a diagnosis record, enabling consistent cross-system linkage across EHR, claims, and clinical data warehouse platforms. Used to deduplicate and reconcile diagnosis entries when data is aggregated from multiple clinical sources or encounters.

diagnosis maximumdiag_max

Defines the upper boundary value associated with a diagnosis-related measurement or threshold, such as a lab reference range or clinical scoring limit. Used in clinical decision support rules and quality measure calculations to flag values exceeding acceptable diagnostic parameters.

diagnosis medical record numberdiag_mrn

The patient-specific medical record number associated with a diagnosis entry, linking the condition to a unique patient identity within a facility or health system. Used to trace diagnosis history across encounters and reconcile records during care transitions or data integration workflows.

diagnosis middle namediag_mid_nm

Stores the middle name or initial of the patient associated with a diagnosis record, supporting accurate patient identity matching and deduplication. Used during record reconciliation processes where full legal name verification is required to confirm the correct patient attribution of a clinical diagnosis.

diagnosis minimumdiag_min

Defines the lower boundary value for a diagnosis-related measurement or threshold, such as a minimum acceptable lab result or clinical score. Used in clinical decision support and quality reporting to identify values falling below established diagnostic criteria or treatment intervention thresholds.

diagnosis mobilediag_mob

Captures the mobile phone number of the patient associated with a diagnosis record, supporting outreach, care management follow-up, and patient engagement activities. Used by care coordinators to contact patients regarding chronic condition management, appointment reminders, or post-diagnosis care instructions.

diagnosis modified bydiag_mod_by

Identifies the user or system that last updated a diagnosis record, providing an audit trail for clinical documentation changes. Critical for compliance, data integrity reviews, and tracking clinician accountability when diagnosis codes or supporting clinical details are amended after initial entry.

diagnosis modified datediag_mod_dt

Timestamp recording the most recent update to a diagnosis record in EHR, claims, or billing systems. Critical for incremental data loads, audit trails, and change-data-capture pipelines ensuring downstream data warehouses reflect current coding and clinical documentation.

diagnosis modified timediag_mod_tm

Records the exact timestamp when a diagnosis record was last updated or amended in the clinical system. Supports audit logging, version control of clinical documentation, and downstream data reconciliation processes that require detection of changes to diagnosis records after initial creation.

diagnosis namediag_nm

Human-readable display label corresponding to an ICD-10 or proprietary diagnosis code within EHR, claims, and billing systems. Used in reporting interfaces, provider portals, and member communications to present clinical condition descriptions without requiring code lookup.

diagnosis notediag_nt

Free-text or structured annotation attached to a diagnosis record in EHR or claims systems, capturing coder clarifications, clinical context, or payer-specific documentation. Used in audit, compliance, and clinical data integration workflows to supplement coded diagnosis data.

diagnosis numberdiag_nbr

System-assigned or payer-defined reference number associated with a diagnosis within pharmacy and billing processes, used to track drug-diagnosis linkage for prior authorization, formulary adjudication, and clinical reporting in PBM and claims systems.

diagnosis onset datediag_onset_dt

Captures the date when symptoms or clinical findings associated with a diagnosis first appeared or were identified by the patient or clinician. Used in chronic disease tracking, episode-of-care analysis, and risk stratification models to determine disease duration and progression patterns.

diagnosis oxygen saturationdiag_o2sat

Records the peripheral blood oxygen saturation percentage measured at or near the time of diagnosis documentation. Used as a clinical vital sign indicator to assess respiratory and cardiovascular status, support diagnosis of conditions such as hypoxia or COPD, and monitor disease severity over time.

PreviousPage 164 of 806Next