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 datetimediag_dttm

The combined date and time value capturing the precise moment a diagnosis was documented or confirmed within an EHR, ADT feed, or clinical event stream. Used in real-time data pipelines, HL7 message processing, and time-sensitive analytics such as sepsis detection and emergency department throughput reporting.

diagnosis dea numberdiag_dea_nbr

The Drug Enforcement Administration registration number associated with a diagnosing or treating provider when controlled substances are prescribed as part of the treatment plan for a diagnosed condition. Used to validate prescribing authority and ensure regulatory compliance in pharmacy and clinical records.

diagnosis death datediag_death_dt

The date of patient mortality attributed to or associated with a specific diagnosis, recorded in EHR, claims, or vital statistics systems. Used in mortality analytics, ICD cause-of-death coding workflows, and population health platforms to measure disease-specific outcome rates and support actuarial risk models.

diagnosis deductible amountdiag_ded_amt

The portion of diagnosis-related service costs applied toward a member's annual deductible before insurance benefits begin paying. Captured during claims adjudication to accurately track member accumulations against their benefit plan deductible threshold and calculate remaining patient financial responsibility.

diagnosis deleted datediag_del_dt

The date on which a diagnosis record was marked as deleted or removed from the active clinical or administrative dataset. Used in data governance and audit processes to maintain historical record integrity, track data corrections, and support compliance with medical record retention requirements.

diagnosis deleted indicatordiag_del_ind

A flag identifying whether a diagnosis record has been logically removed from active use in the clinical or claims system without physical deletion. Enables soft-delete functionality to preserve historical data integrity while excluding voided or erroneous diagnosis entries from current reporting and analytics.

diagnosis descriptiondiag_desc

Free-text description for diagnosis within Clinical processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

diagnosis detaildiag_dtl

Granular structured or semi-structured attributes supplementing a primary diagnosis code, such as laterality, severity, acuity, or episode type, within EHR and claims systems. Used by data engineers to enrich clinical data models, support ICD-10 specificity validation, and improve accuracy in risk adjustment and quality reporting pipelines.

diagnosis discharge datediag_dsch_dt

The date a patient is formally discharged from a facility encounter associated with a specific diagnosis, recorded in EHR, ADT, and claims systems. Used to calculate inpatient length of stay, close episode-of-care records, trigger post-discharge care management workflows, and finalize DRG-based reimbursement calculations.

diagnosis due datediag_due_dt

The date by which a diagnosis-related follow-up action, clinical review, reassessment, or care plan update is required to be completed. Used in care management workflows to trigger outreach activities, monitor compliance with treatment protocols, and support chronic condition management program tracking.

diagnosis durationdiag_dur

The length of time a patient has been experiencing or living with a diagnosed medical condition, measured from onset to the current date or resolution. Used in clinical documentation and risk stratification to differentiate acute from chronic conditions and inform appropriate care management interventions.

diagnosis effectivediag_eff

A boolean or status indicator denoting whether a diagnosis record is currently active and within its valid date range in EHR, care management, or payer systems. Used to filter active versus inactive diagnoses during claims adjudication, risk score calculations, care gap identification, and longitudinal member health record construction.

diagnosis effective datediag_eff_dt

The date on which a diagnosis becomes clinically or administratively active within an EHR, payer, or care management system, marking the start of its validity period. Used to enforce temporal business rules in claims adjudication, risk adjustment lookback logic, chronic condition tracking, and benefit authorization workflows.

diagnosis emaildiag_eml

An email address field associated with a diagnosis record in EHR or care management systems, typically used to route diagnostic notifications, referral confirmations, or condition-related alerts to providers or care coordinators managing the patient's treatment plan.

diagnosis emergency indicatordiag_emerg_ind

A flag identifying whether a diagnosis was rendered in the context of an emergency medical situation, such as an emergency department visit or urgent inpatient admission. Used in claims adjudication to apply appropriate benefit levels, prior authorization waivers, and cost-sharing rules under member benefit plans.

diagnosis end datediag_end_dt

The date a diagnosed condition is marked resolved, inactive, or no longer relevant in EHR problem lists or claims data. Used in longitudinal patient records, chronic condition tracking, and risk stratification models to define the active period of a diagnosis code.

diagnosis end timediag_end_tm

The precise timestamp indicating when a diagnostic encounter, clinical assessment session, or observation period associated with a diagnosis was concluded. Used in clinical documentation and encounter data to calculate service duration, support accurate billing, and establish the complete timeline of patient care events.

diagnosis enrollment statusdiag_enrl_sts

Indicates the enrollment or program participation status associated with a diagnosis record, such as whether the patient is actively enrolled in a disease management program tied to the identified medical condition. Used in care management and population health tracking.

diagnosis entered bydiag_ent_by

Identifies the specific user, clinician, or system that recorded the diagnosis entry into the clinical or administrative system. Used for audit trail purposes, data governance, and accountability tracking within EHR and clinical data warehouse environments.

diagnosis ethnicitydiag_ethn

Records the patient's ethnic background associated with a diagnosis record, supporting demographic analysis, health disparity reporting, and population health stratification. Used in clinical analytics to identify ethnicity-based prevalence patterns for specific medical conditions.

PreviousPage 162 of 806Next