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

condition modified bycond_mod_by

Identifier of the user, clinician, or system process that last updated a condition record within the clinical or administrative system. Used for audit trail purposes to track accountability and changes to condition status, coding, or documentation across EHR and data warehouse environments.

condition modified datecond_mod_dt

The calendar date when a patient's condition record was last updated in the clinical system. Captures the most recent modification to diagnostic details, status, severity, or clinical notes, supporting audit trails and longitudinal tracking of disease progression in EHR systems.

condition modified timecond_mod_tm

The timestamp recording when a patient's condition record was last updated within the clinical system. Used alongside the modified date to provide precise audit trail information for changes to diagnosis status, severity ratings, or clinical documentation in EHR environments.

condition namecond_nm

The human-readable label assigned to a patient's diagnosed medical condition or disease state. Used for clinical documentation, patient communication, and reporting workflows where coded values such as ICD-10 codes require a corresponding plain-language description for display purposes.

condition notecond_nt

Free-text clinical annotation associated with a patient's recorded medical condition. Captures supplementary provider observations, treatment context, or clarifying details that fall outside structured data fields, supporting comprehensive longitudinal documentation in EHR and care management systems.

condition numbercond_nbr

A system-assigned numeric identifier uniquely referencing a specific instance of a patient's recorded medical condition. Enables consistent cross-system tracking of the condition across clinical encounters, care management workflows, and health information exchange transactions.

condition onset datecond_onset_dt

The calendar date when a patient's medical condition or disease symptoms first appeared or were clinically recognized. Critical for establishing disease chronology, determining pre-existing condition status in insurance contexts, and supporting longitudinal clinical analysis in EHR and claims systems.

condition oxygen saturationcond_o2sat

The measured peripheral oxygen saturation percentage recorded in association with a patient's clinical condition. Captured as a vital sign observation to monitor respiratory status, assess disease severity, and guide treatment decisions for conditions such as COPD, pneumonia, or heart failure.

condition paid amountcond_pd_amt

The monetary amount reimbursed by a payer for services rendered in connection with a specific patient condition. Recorded in claims processing systems to track financial settlements associated with condition-based care episodes, supporting cost analysis and disease-specific expenditure reporting.

condition paid datecond_pd_dt

The calendar date on which payment was issued by a payer for healthcare services associated with a specific patient condition. Used in claims adjudication workflows to confirm reimbursement timing and support accounts receivable reconciliation and condition-level financial reporting.

condition parentcond_prnt

The higher-level condition or diagnostic category to which a specific condition record is hierarchically linked. Used in clinical terminology systems and condition registries to organize related diagnoses under broader disease groupings, supporting hierarchical reporting and population health stratification.

condition percentagecond_pct

A numeric percentage value associated with a medical condition, such as disability rating, disease severity score, or benefit coverage proportion. Used in workers' compensation, disability management, and clinical assessment workflows to quantify the extent or impact of a patient's condition.

condition periodcond_prd

The defined time interval during which a patient's medical condition is considered active, monitored, or clinically relevant. Used in care management, chronic disease programs, and insurance benefit processing to establish episode boundaries and align condition-specific interventions with coverage periods.

condition phonecond_ph

The telephone contact number associated with a condition-related record, such as a disease management program hotline, specialist referral contact, or clinical registry support line. Used to facilitate outreach and coordination of care for patients enrolled in condition-specific management programs.

condition plancond_pln

The documented clinical treatment strategy or care plan established for managing a patient's specific medical condition. Captures intended interventions, medication regimens, follow-up schedules, and therapeutic goals, supporting coordinated care delivery and compliance tracking in EHR and care management platforms.

condition policy numbercond_pol_nbr

The insurance policy identifier linked to coverage applicable to a patient's specific medical condition. Used in claims processing and benefit eligibility systems to associate condition-related services with the correct insurance contract, enabling accurate adjudication and coverage determination.

condition preferred namecond_pref_nm

The clinically preferred or standardized display name designated for a medical condition, distinguishing it from synonyms or alternate terminology. Used in patient-facing documentation, clinical interfaces, and reporting systems to ensure consistent, standardized labeling of diagnoses across care settings.

condition pricecond_prc

The defined monetary cost associated with treating or managing a specific medical condition, reflecting negotiated rates, standard charges, or bundled episode pricing. Used in healthcare financial systems to support condition-based cost benchmarking, episode payment models, and population health cost analysis.

condition primary indicatorcond_prim_ind

A flag designating whether a recorded condition is the primary diagnosis driving a clinical encounter, episode of care, or claims submission. Used in coding workflows and claims adjudication to identify the principal diagnosis for reimbursement, case mix grouping, and quality reporting purposes.

condition prioritycond_prty

A ranking value indicating the relative clinical urgency or treatment priority assigned to a patient's recorded condition. Used in care management and chronic disease programs to sequence interventions, allocate care coordination resources, and guide clinical decision-making based on condition severity and acuity.

PreviousPage 116 of 806Next