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

discharge valuedsch_val

Captures a specific measured data point associated with a hospital discharge event, such as a clinical observation, financial amount, or quality metric, used in EHR analytics, claims processing, and population health platforms to support episode-level performance evaluation.

discharge versiondsch_ver

The sequential version number assigned to a hospital discharge record to track revisions made after the initial submission or documentation. Used in inpatient data management and claims processing to distinguish between original and amended discharge records across system updates.

discharge zipdsch_zip

The five or nine-digit postal code corresponding to the patient's destination address or facility location at the time of hospital discharge. Used in inpatient records to support geographic analysis, post-acute care coordination, readmission risk stratification, and population health reporting.

disease account numberdis_acct_nbr

The unique account reference number assigned to a patient's disease episode or chronic condition record within a clinical or administrative system. Used in disease management programs to link condition-specific data to member records, care plans, and utilization history across health systems.

disease active indicatordis_actv_ind

A binary flag indicating whether a diagnosed disease or chronic condition is currently active for a patient. Used in clinical and member data systems to filter active conditions from historical records, support care management prioritization, and drive disease-specific outreach and intervention programs.

disease active statusdis_actv_sts

The current activity state of a patient's diagnosed condition, indicating whether it is active, inactive, resolved, or in remission. Used in clinical documentation and disease management platforms to track condition progression, guide treatment decisions, and support population health stratification.

disease addressdis_addr

The physical location associated with a disease registry entry, patient record, or reporting entity linked to a specific condition. Used in public health surveillance and disease management programs to support geographic tracking, outbreak analysis, and population-level condition mapping.

disease adjustment amountdis_adj_amt

The financial modification applied to a claim or payment associated with a disease episode, reflecting contract terms, risk adjustments, or coding corrections. Used in claims adjudication and disease-based payment models to accurately calculate reimbursement for condition-specific care.

disease admission datedis_admn_dt

The date on which a patient was admitted to a hospital or clinical facility due to a specific diagnosed disease or acute exacerbation of a chronic condition. Used in inpatient records and disease management data to calculate length of stay, track disease episodes, and measure utilization patterns.

disease agedis_age

The patient's age at the time of disease diagnosis or during an active disease episode. Used in clinical and epidemiological data analysis to stratify disease prevalence, assess age-related risk factors, and support targeted disease management interventions across defined population segments.

disease allowed amountdis_alwd_amt

The maximum dollar amount a health plan will reimburse for services related to a specific disease episode based on contract rates and benefit terms. Used in claims adjudication and disease cost analysis to calculate plan liability and member cost-sharing for condition-specific medical services.

disease amountdis_amt

The total monetary value associated with healthcare services rendered for a specific disease episode or condition-related claim. Used in claims data and disease cost management reporting to measure financial exposure, track condition-level spend, and support value-based care and population health analytics.

disease approval statusdis_appr_sts

Indicates the current workflow approval state of a disease record within a clinical data system, such as pending, approved, or rejected. Used in disease registry management to enforce clinical review processes before a diagnosis or condition record is finalized and made available for reporting or care coordination.

disease approved bydis_appr_by

Identifies the clinician, administrator, or system user who authorized and approved a disease record within a clinical registry or EHR workflow. Supports audit trail requirements by linking finalized disease entries to a responsible reviewer, ensuring accountability in diagnosis documentation and disease management processes.

disease arrival timedis_arrv_tm

Records the specific time a patient arrived at a clinical facility in the context of a disease-related encounter or episode of care. Used in infectious disease surveillance, emergency department tracking, and epidemiological studies to measure time-to-treatment and establish disease onset-to-care timelines.

disease arrived datedis_arrv_dt

Records the calendar date a patient presented at a healthcare facility associated with a specific disease-related encounter. Used in disease surveillance registries and epidemiological tracking to establish patient intake timelines, measure care delays, and support public health reporting for reportable condition management.

disease assessmentdis_asmt

Captures the clinician's structured or free-text clinical evaluation of a patient's disease status at a specific point in care. Includes findings from physical examination, diagnostic results, and clinical judgment. Used in disease management programs and chronic condition registries to document progression and guide treatment planning.

disease balancedis_bal

Represents the remaining financial obligation associated with healthcare services rendered for a specific disease episode or condition, after payments and adjustments have been applied. Used in healthcare billing systems to track outstanding patient or payer liability tied to disease-specific encounters or treatment programs.

disease billed amountdis_bill_amt

Represents the total charges submitted to a payer or patient for healthcare services associated with the treatment or management of a specific disease or condition. Used in claims processing and disease cost analysis to measure the gross financial value of care delivered for a given diagnosis or condition episode.

disease birth datedis_birth_dt

Records the date of birth of a patient associated with a disease registry entry or clinical condition record. Used in disease management and epidemiological systems to calculate patient age at diagnosis, determine age-related risk stratification, and support demographic analysis across disease cohorts and population health programs.

PreviousPage 183 of 806Next