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

disease statedis_st

The current clinical phase or progression stage of a diagnosed condition, such as acute, chronic, remission, or relapse. Used in disease management programs and longitudinal patient records to track how a condition evolves over time and inform appropriate treatment pathways.

disease statusdis_sts

Indicates the active, resolved, inactive, or recurring state of a diagnosed condition within a patient's health record. Used in chronic disease registries and care management platforms to determine whether a condition requires ongoing monitoring, treatment adjustment, or can be closed.

disease street addressdis_st_addr

Street address associated with the location where a disease case was reported, diagnosed, or treated. Used in public health surveillance, epidemiological mapping, and outbreak tracking to identify geographic clustering of conditions and support communicable disease reporting requirements.

disease strengthdis_str

The concentration or dosage strength of a medication prescribed or administered in the treatment of a specific diagnosed condition. Used in pharmacy and medication management records to document therapeutic regimens and support clinical decision-making for condition-specific drug therapy.

disease subtotaldis_subtot

Intermediate aggregate value calculated across a subset of disease-related records, such as cost, encounter count, or risk scores grouped by condition. Used in financial reporting and population health analytics to summarize disease burden across defined patient cohorts or time periods.

disease surgery datedis_surg_dt

The calendar date on which a surgical procedure was performed in relation to a specific diagnosed condition. Used in surgical registries, episode-of-care records, and clinical outcomes tracking to link operative interventions to the underlying diagnosis driving the procedure.

disease system identifierdis_sys_id

Unique system-generated key assigned to a disease or diagnosis record within a healthcare data platform. Used to consistently identify, link, and track a specific condition across clinical, claims, and administrative systems, enabling accurate longitudinal reporting and data integrity management.

disease targetdis_tgt

Specifies the clinical goal, benchmark, or outcome target associated with managing a diagnosed condition, such as a target HbA1c level for diabetes. Used in disease management programs and quality reporting to measure treatment effectiveness and track patient progress toward defined health outcomes.

disease taxonomy codedis_tax_cd

Standardized classification code used to categorize a disease within a recognized clinical or administrative coding system, such as ICD or SNOMED. Used in clinical data warehouses and analytics platforms to group diagnoses into disease families for population health reporting and epidemiological analysis.

disease temperaturedis_temp

Recorded body temperature measurement documented in association with a diagnosed condition, expressed in Fahrenheit or Celsius. Used in clinical encounter records and remote patient monitoring to track fever or hypothermia as a symptom indicator, particularly for infectious disease and sepsis surveillance.

disease termination datedis_term_dt

The calendar date on which a diagnosed condition was resolved, closed, or determined to be no longer active in a patient's record. Used in chronic disease management and longitudinal health records to calculate condition duration, measure outcomes, and update patient problem lists accurately.

disease timedis_tm

The specific time of day associated with a disease event, diagnosis documentation, or clinical observation. Used in inpatient and emergency care records to establish precise event sequencing, support clinical audit trails, and enable time-sensitive analysis of condition onset or treatment initiation.

disease timestampdis_ts

The precise date and time a disease record was created, modified, or a clinical event occurred. Used in clinical data systems to establish chronological sequencing of disease onset, progression, diagnosis confirmation, or status changes for longitudinal patient health tracking.

disease titledis_ttl

The formal clinical name assigned to a diagnosed disease condition, often aligned with standardized terminology such as ICD-10 or SNOMED CT. Used in clinical documentation to ensure consistent disease identification across care settings, registries, and population health reporting systems.

disease totaldis_tot

An aggregated numeric value associated with a disease condition, such as total episodes, cumulative costs, or combined severity scores. Used in population health analytics and clinical reporting to summarize disease burden across patient cohorts or defined time periods.

disease total countdis_tot_cnt

The cumulative number of recorded occurrences of a specific disease condition within a defined patient population or time period. Used in epidemiological tracking, quality reporting, and chronic disease management programs to measure disease prevalence and incidence trends.

disease typedis_typ

A categorical classification that identifies the nature or grouping of a disease condition, such as infectious, chronic, autoimmune, or neoplastic. Used in clinical data systems to organize diagnoses into meaningful categories for population health stratification and disease management workflows.

disease unitdis_unt

The unit of measure associated with a disease-related metric or clinical observation, such as mg/dL for lab values or days for episode duration. Used in clinical data systems to standardize measurement interpretation and ensure accurate comparisons across disease monitoring and reporting workflows.

disease updated datedis_upd_dt

The most recent date on which a disease record was modified, including updates to diagnosis status, severity classification, or treatment response. Used in clinical data systems to maintain accurate audit trails and ensure care teams are working with current disease information during patient management.

disease urgencydis_urg

A coded indicator reflecting the clinical urgency or time-sensitivity level associated with a disease condition, such as emergent, urgent, or routine. Used in care management and clinical triage workflows to prioritize patient interventions and allocate resources based on disease acuity and risk severity.

PreviousPage 190 of 806Next