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 middle namevtl_mid_nm

Patient's middle name or initial recorded alongside vital sign documentation for identity verification purposes. Supports accurate patient matching in clinical data systems, reducing misidentification risk when common first and last name combinations exist across the patient population.

vital minimumvtl_min

Lower boundary value defined for a specific vital sign measurement, representing the clinically acceptable or expected low threshold. Used in clinical decision support configurations and quality monitoring workflows to trigger alerts when patient readings fall below safe or normal ranges.

vital mobilevtl_mob

Patient's mobile phone number recorded during clinical intake in conjunction with vital sign documentation. Used to support follow-up communications, remote patient monitoring outreach, appointment reminders, and care coordination for patients with abnormal or concerning vital sign readings.

vital modified byvtl_mod_by

Username or system identifier of the user who last updated a vital signs record in the clinical data system. Captured for audit trail and data governance purposes, enabling tracking of documentation changes, corrections, and amendments to patient vital sign entries.

vital modified datevtl_mod_dt

Timestamp recording the most recent update to a vital sign record in EHR or clinical data warehouse systems such as Epic, Cerner, or HealthVault. Essential for data engineers implementing incremental ETL loads, change data capture pipelines, and audit trail compliance in clinical data integrations.

vital modified timevtl_mod_tm

Timestamp recording when a vital signs entry was last updated or amended in the clinical system. Used for audit trail management, data quality monitoring, and change history tracking to identify post-collection corrections or updates made to patient vital sign documentation.

vital namevtl_nm

Standardized display label identifying the type of vital sign measurement, such as systolic blood pressure, SpO2, or body temperature, within EHR flowsheets and clinical data warehouses. Data engineers use this field to map proprietary vital sign codes to standard terminologies like LOINC or SNOMED CT.

vital notevtl_nt

Free-text or structured annotation field appended to a vital sign observation in EHR systems, capturing clinician comments, measurement anomalies, patient state, or equipment notes. Data engineers must parse and cleanse this field when incorporating unstructured clinical context into NLP or analytics pipelines.

vital numbervtl_nbr

Numeric reference value assigned to a vital sign record or type within EHR and clinical data systems, used to distinguish and catalog measurement instances across encounters. Data engineers rely on this field for deduplication logic and referential integrity checks in clinical data warehouse builds.

vital onset datevtl_onset_dt

Date on which the patient's reported symptoms or clinical condition associated with an abnormal vital sign measurement first began. Captured during clinical assessment to establish disease timeline, guide differential diagnosis, and contextualize vital sign trends within the patient's care episode.

vital oxygen saturationvtl_o2sat

Peripheral oxygen saturation percentage measured via pulse oximetry, reflecting the proportion of hemoglobin carrying oxygen in the patient's blood. Routinely captured as a core vital sign to detect hypoxemia, monitor respiratory conditions, and guide clinical interventions during inpatient and outpatient encounters.

vital paid amountvtl_pd_amt

The dollar amount paid for a clinical encounter or service associated with a vital signs measurement record. Used in claims and billing systems to reconcile reimbursement tied to patient encounters where physiological measurements were documented and submitted.

vital paid datevtl_pd_dt

The date on which payment was issued for a clinical service associated with a vital signs measurement record. Used in claims processing workflows to track reimbursement timelines and reconcile payment cycles for encounters that included physiological data capture.

vital parentvtl_prnt

Foreign key or hierarchical reference linking a vital sign record to its parent observation group, encounter, or taxonomy node in EHR and clinical data warehouse systems. Data engineers use this field to reconstruct hierarchical vital sign structures and navigate parent-child relationships in flowsheet data models.

vital percentagevtl_pct

Ratio-based measurement value for vital signs expressed as a percentage, such as oxygen saturation (SpO2) or body fat percentage, within EHR and clinical analytics systems. Data engineers use this field to apply range validation rules and populate trending dashboards in population health platforms.

vital periodvtl_prd

Time span or duration associated with a vital sign measurement context in EHR and clinical monitoring systems, such as averaging interval for blood pressure or telemetry window. Data engineers use this field to align vital sign data with encounter timelines and longitudinal patient monitoring records.

vital phonevtl_ph

Telephone contact number associated with a vital sign monitoring service, remote patient monitoring vendor, or clinical contact linked to a vital sign record in EHR and care management systems. Data engineers use this field when integrating telehealth and remote monitoring data with core clinical records.

vital planvtl_pln

The documented clinical care plan associated with a patient's vital signs findings. Captures the clinician's intended course of action in response to measured physiological values such as blood pressure, heart rate, or temperature, recorded within EHR encounter notes.

vital policy numbervtl_pol_nbr

The insurance policy identifier associated with the patient at the time vital signs were recorded during a clinical encounter. Used in claims and eligibility systems to link physiological measurement records to the correct health plan coverage for billing and adjudication.

vital preferred namevtl_pref_nm

The clinician or patient-preferred display label assigned to a specific vital signs measurement type. Used in EHR interfaces and clinical reporting to present physiological metrics such as systolic blood pressure or oxygen saturation in a standardized, human-readable format.

PreviousPage 793 of 806Next