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 procedure datecond_proc_dt

The calendar date on which a clinical procedure was performed in direct association with a patient's specific medical condition. Used in EHR and claims systems to link procedural services to their corresponding diagnoses, supporting accurate billing, outcomes tracking, and episode-of-care analysis.

condition pulsecond_pulse

Records the heart rate in beats per minute (BPM) associated with a diagnosed clinical condition at the time of assessment. Captured during patient encounters to monitor cardiovascular response to disease states such as sepsis, arrhythmia, or acute illness in clinical documentation.

condition quantitycond_qty

Captures the measurable count or volume associated with a specific clinical condition, such as lesion count, episode frequency, or specimen volume. Used in clinical documentation to quantify disease burden or occurrence metrics for treatment planning and outcomes tracking.

condition racecond_race

Records the patient's self-reported racial identity in the context of a diagnosed clinical condition. Used in population health analytics and clinical research to identify health disparities, disease prevalence patterns, and demographic risk factors across specific condition categories.

condition rangecond_rng

Defines the acceptable minimum and maximum boundary values for clinical measurements associated with a specific condition, such as acceptable glucose ranges for diabetes management. Used to flag abnormal readings and support clinical decision-making in disease monitoring workflows.

condition ratecond_rt

Represents the frequency or speed measurement associated with a clinical condition, such as disease progression rate, symptom recurrence rate, or physiological measurement rate. Used in clinical analytics to track condition trajectory and evaluate treatment effectiveness over time.

condition ratingcond_rtg

Captures a standardized severity or intensity score assigned to a clinical condition at the time of assessment, such as pain scales or functional status ratings. Supports clinical decision-making, care plan development, and longitudinal tracking of disease severity in patient records.

condition ratiocond_ratio

Stores a calculated proportional relationship between two clinical measurements associated with a condition, such as the ratio of affected to unaffected tissue or biomarker ratios. Used in diagnostic interpretation and disease monitoring to evaluate clinical progression and treatment response.

condition reasoncond_rsn

Documents the clinical justification or explanatory text describing why a specific condition was diagnosed, recorded, or updated in the patient record. Supports medical necessity documentation, care coordination, and audit trails for condition management decisions in clinical workflows.

condition received datecond_rcvd_dt

Records the date a condition report, referral, or clinical documentation related to a patient diagnosis was received by the treating facility or care team. Used to track care coordination timelines, referral response times, and condition management workflows in clinical systems.

condition referencecond_ref

Stores an external identifier or pointer linking a clinical condition record to a related document, external system record, or clinical guideline source. Used to cross-reference condition data across EHR systems, care settings, or clinical registries for continuity of care and reporting.

condition resolution datecond_resol_dt

Records the date on which a diagnosed clinical condition was resolved, cured, or determined to be inactive in the patient's medical record. Used to calculate condition duration, close active problem list entries, and support chronic versus acute disease classification in clinical documentation.

condition respirationcond_resp

Records the patient's respiratory rate in breaths per minute as documented in association with a specific clinical condition. Captured during clinical assessments to monitor pulmonary response to disease states such as pneumonia, COPD exacerbation, or respiratory distress in patient records.

condition resultcond_rslt

Captures the clinical outcome or measurement result associated with a specific condition assessment, diagnostic test, or treatment episode. Used to document findings such as lab values, imaging outcomes, or procedure results linked to a patient's active or historical diagnosis in clinical records.

condition review systemscond_ros

Documents the systematic clinical review of body systems performed in relation to a specific diagnosed condition, following standard Review of Systems (ROS) methodology. Used during clinical encounters to identify relevant symptoms and comorbidities supporting diagnosis and treatment planning.

condition revisioncond_rev

Tracks the version or iteration number of updates made to a clinical condition record, reflecting changes in diagnosis, severity classification, or clinical documentation. Supports audit trail maintenance, condition history tracking, and clinical record integrity in EHR and care management systems.

condition riskcond_rsk

Captures the assessed risk level associated with a patient's diagnosed clinical condition, including likelihood of complications, disease progression, or adverse outcomes. Used in care management, utilization review, and population health stratification to prioritize interventions and allocate clinical resources.

condition routecond_rte

Documents the anatomical or physiological pathway relevant to a clinical condition, such as the transmission route of an infectious disease or the anatomical route of disease spread. Used in clinical documentation to support treatment planning, infection control protocols, and disease classification.

condition scheduled datecond_sched_dt

Records the planned calendar date for a clinical appointment, procedure, or intervention associated with managing a specific patient condition. Used in care coordination and scheduling workflows to track upcoming condition-related encounters and ensure timely follow-up in clinical management systems.

condition scheduled timecond_sched_tm

Stores the planned clock time for a clinical appointment or intervention associated with a specific patient condition. Used alongside the scheduled date to coordinate care team availability, facility resources, and patient scheduling for condition-related encounters in clinical management systems.

PreviousPage 117 of 806Next