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

vital temperaturevtl_temp

The numeric body temperature value recorded as part of a patient's vital signs assessment, typically measured in degrees Fahrenheit or Celsius. Captured during clinical encounters to detect fever, hypothermia, or thermoregulatory changes, and stored in EHR systems for trending, alerting, and clinical decision support.

vital termination datevtl_term_dt

The date on which a vital signs monitoring order, care protocol, or continuous measurement series was ended for a patient. Used in EHR and clinical data systems to define the active monitoring period, support audit trails, and calculate total duration of vital sign surveillance during an inpatient or outpatient episode.

vital timevtl_tm

The specific time of day at which a vital sign measurement was recorded in EHR and clinical documentation systems. Enables data engineers to perform time-based analysis, identify measurement frequency patterns, and join vital sign data with medication administration or procedure records within encounters.

vital timestampvtl_ts

The combined date and time value recording exactly when a vital sign was captured in EHR and clinical data systems. Used by data engineers for precise event sequencing, time-series analysis, and linking vital measurements to concurrent clinical events such as medication administration or procedure execution.

vital titlevtl_ttl

The formal label or descriptive name assigned to a vital signs measurement type, such as systolic blood pressure, oxygen saturation, or body mass index. Used in EHR and clinical data systems to provide standardized human-readable identification of vital sign observations for display, reporting, and clinical documentation purposes.

vital totalvtl_tot

An aggregated sum of vital sign measurements across a defined time period or encounter in EHR and clinical analytics systems. Used by data engineers to calculate cumulative metrics such as total fluid balance or aggregated early warning scores, supporting population health and inpatient outcome reporting.

vital total countvtl_tot_cnt

The total number of vital signs measurements recorded for a patient within a specified encounter, time period, or monitoring episode. Used in clinical analytics and quality reporting systems to assess measurement frequency, evaluate adherence to monitoring protocols, and support population health surveillance across care settings.

vital typevtl_typ

The category classification identifying which specific vital sign is recorded, such as heart rate, blood pressure, temperature, or oxygen saturation, in EHR and clinical data systems. Data engineers use this field to filter, pivot, and model vital sign datasets across encounter types and care settings.

vital unitvtl_unt

The standardized unit of measure associated with a vital sign value in EHR and clinical data systems, such as mmHg for blood pressure or beats per minute for heart rate. Data engineers rely on this field to normalize measurements across disparate source systems and ensure consistent unit handling in analytics pipelines.

vital updated datevtl_upd_dt

The date on which a vital signs record was most recently modified or amended in the clinical information system. Used to maintain data integrity and audit trails in EHR platforms, enabling identification of corrections, late entries, or updates to previously recorded vital measurements during patient care episodes.

vital urgencyvtl_urg

A classification indicating the clinical priority or time-sensitivity level assigned to a vital signs measurement order or result, such as routine, urgent, or critical. Used in EHR and clinical workflow systems to triage response actions, trigger alerts, and ensure timely clinician review of abnormal or life-threatening vital sign values.

vital valuevtl_val

The discrete numeric or coded data point recorded for a patient vital sign measurement in EHR and clinical data systems. Represents the actual observed measurement such as 98.6 for temperature or 120 for systolic blood pressure, serving as the primary field in vital sign trend analysis and clinical quality reporting.

vital versionvtl_ver

A numeric or alphanumeric indicator tracking the iteration of a vital signs record, used to manage amendments, corrections, or updates to previously documented measurements. Supports data versioning and audit trail requirements in EHR systems, ensuring traceability of changes to vital sign values throughout the patient record lifecycle.

vital zipvtl_zip

The postal ZIP code associated with the facility or care location where a patient's vital signs were recorded. Used in clinical and administrative data systems to support geographic reporting, population health stratification, and site-level analysis of vital sign data across distributed care settings and health system networks.

ward admission datewrd_admn_dt

The calendar date on which a patient was formally admitted to a specific hospital ward or inpatient care unit. Used in inpatient clinical and administrative systems to establish the start of ward-level care, calculate length of stay, support bed management workflows, and enable episode-level reporting across acute care facilities.

ward discharge datewrd_dsch_dt

The calendar date on which a patient was formally discharged from a specific hospital ward or inpatient care unit. Used in inpatient EHR and administrative systems to close ward-level episodes, calculate length of stay, trigger discharge planning workflows, and support hospital capacity management and outcomes reporting.

ward labelwrd_lbl

The human-readable display name assigned to a specific hospital ward or inpatient care unit, used in clinical systems to identify and distinguish patient areas such as medical, surgical, pediatric, or ICU wards within facility management and bed assignment workflows.

ward procedure datewrd_proc_dt

The calendar date on which a clinical procedure was performed on a patient during their stay in a specific hospital ward. Used in inpatient records to sequence care events, support clinical documentation, and enable outcome tracking tied to ward-level care delivery.

ward surgery datewrd_surg_dt

The calendar date on which a surgical intervention was performed on a patient assigned to a specific hospital ward. Captured in inpatient clinical records to support surgical scheduling, post-operative monitoring, and length-of-stay analysis at the ward level.

wing active indicatorwng_actv_ind

A binary flag indicating whether a specific hospital building wing is currently operational and available for patient care activities. Used in facility management systems to control bed availability, staff assignments, and resource allocation within that physical section of the hospital.

PreviousPage 796 of 806Next