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 gendervtl_gndr

Administrative or biological sex classification of the patient associated with a vital signs record. Used in clinical data systems to apply gender-specific reference ranges for measurements such as hemoglobin or creatinine, and to support demographic reporting and health equity analytics.

vital glucosevtl_gluc

Blood glucose concentration recorded as part of a patient vital signs or point-of-care assessment. Used to monitor glycemic status, detect hypoglycemia or hyperglycemia, and support diabetes management protocols in inpatient, outpatient, and emergency clinical data workflows.

vital group numbervtl_grp_nbr

Identifier linking a vital signs record to a specific encounter grouping or clinical episode. Used in clinical data systems to associate multiple vital measurements captured during the same visit, session, or monitoring period for longitudinal patient care tracking.

vital hemoglobinvtl_hgb

Recorded hemoglobin concentration measured in grams per deciliter from a patient blood sample. Captured during clinical encounters to assess oxygen-carrying capacity, screen for anemia, and monitor chronic conditions such as heart failure, kidney disease, or post-surgical recovery.

vital history present illnessvtl_hpi

Clinician-documented narrative describing the patient's current symptoms, onset, duration, and progression at the time of the encounter. Recorded as part of the clinical assessment to contextualize vital sign abnormalities and inform diagnosis and treatment planning.

vital identifiervtl_id

Unique alphanumeric key assigned to each vital sign observation record in EHR systems such as Epic or Cerner. Links vital measurements across clinical encounters, enabling data engineers to join patient biometric records across ADT, flowsheet, and clinical decision support tables.

vital indexvtl_idx

Sequential position number assigned to vital sign entries within a patient encounter or flowsheet series in EHR systems. Used by data engineers to order multiple vital sign observations chronologically within a single visit or monitoring session for accurate trend analysis.

vital indicatorvtl_ind

Boolean field in clinical EHR and health data warehouse systems denoting whether a specific vital sign condition is met, such as whether a reading falls outside normal range or triggers a clinical protocol. Critical for building alert logic and population health risk stratification models.

vital instructionvtl_instr

Structured or free-text guidance associated with a vital sign measurement in EHR systems, specifying collection method, patient positioning, device calibration, or special conditions. Data engineers use this field to contextualize measurement variance and support clinical data quality validation rules.

vital keyvtl_key

Unique surrogate or natural key assigned to a vital signs record within the clinical data warehouse or EHR system. Serves as the primary reference value for joining vital measurements to patient encounters, provider records, and downstream analytical or reporting datasets.

vital labelvtl_lbl

Human-readable display text associated with a specific vital sign type or measurement category, such as Systolic Blood Pressure or Resting Heart Rate. Used in clinical interfaces, reports, and dashboards to present vital data in a standardized, clinician-friendly format.

vital languagevtl_lang

Preferred spoken or written language of the patient recorded at the time vital signs are collected. Used in clinical settings to ensure appropriate communication during assessments, support interpreter services coordination, and meet health equity documentation requirements.

vital last namevtl_last_nm

Patient's family surname recorded in association with a vital signs measurement event. Used to confirm patient identity during clinical documentation, reconcile vital records across encounters, and support accurate patient matching in clinical data repositories.

vital legal namevtl_legal_nm

Patient's full legally registered name captured at the time of vital sign documentation. Used for identity verification during clinical encounters, ensuring vital sign records are correctly attributed to the right patient across EHR and health information exchange systems.

vital levelvtl_lvl

Hierarchy classification assigned to a vital sign within clinical taxonomy structures in EHR and health data warehouse systems, indicating severity tiers such as normal, borderline, or critical. Used by data engineers to build stratified reporting and risk-banding logic in population health platforms.

vital license numbervtl_lic_nbr

Professional license identifier of the clinician or healthcare practitioner who recorded or validated the vital signs measurement. Used to attribute clinical documentation to a licensed provider and support credentialing audits, compliance reporting, and care quality review.

vital marital statusvtl_mar_sts

Patient's reported marital or domestic relationship status captured during clinical intake alongside vital sign documentation. Used in population health analytics, social determinants of health assessments, and care coordination workflows to support holistic patient care planning.

vital master identifiervtl_mstr_id

Enterprise master patient index identifier linked to a vital signs record, enabling consistent patient identity resolution across multiple clinical systems and facilities. Supports accurate longitudinal vital sign tracking, data deduplication, and cross-system interoperability in health networks.

vital maximumvtl_max

Upper boundary value defined for a specific vital sign measurement, representing the clinically acceptable or expected high threshold. Used in clinical decision support rules, alert configurations, and quality monitoring to flag patient readings that exceed safe or normal ranges.

vital medical record numbervtl_mrn

Facility-assigned medical record number associated with the patient encounter during which vital signs were documented. Used to link vital measurements to the patient's longitudinal health record and reconcile clinical data across inpatient, outpatient, and ancillary care settings.

PreviousPage 792 of 806Next