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

visit taxonomy codevst_tax_cd

Stores the Health Care Provider Taxonomy Code identifying the clinical specialty or provider type responsible for delivering care during the visit. Used in claims adjudication, credentialing verification, and network management to classify services rendered by specialty designation at the encounter level.

visit temperaturevst_temp

Records the patient's body temperature measured in degrees Fahrenheit or Celsius during a clinical encounter. Captured as part of the vital signs assessment, this value supports triage decisions, infection detection, and longitudinal monitoring of patient physiological status across visits.

visit termination datevst_term_dt

Captures the date on which a patient visit, episode of care, or visit-linked enrollment record officially ended or was closed. Used in care management systems and clinical data warehouses to define the boundaries of an encounter period for reporting, billing, and outcomes analysis.

visit timevst_tm

Time-of-day value recording when a patient encounter began or was scheduled, expressed in HH:MM format. Captured in EHR scheduling and practice management systems to support appointment slot management, provider utilization analysis, and after-hours care classification in claims analytics.

visit timestampvst_ts

Combined date and time value precisely recording when a patient encounter event occurred, typically stored in ISO 8601 or epoch format. Used in EHR audit logs, HL7 FHIR encounter resources, and claims adjudication systems for sequencing events, detecting duplicates, and supporting compliance reporting.

visit titlevst_ttl

Stores the formal name or label assigned to a patient visit type or encounter category, such as Annual Wellness Visit or Initial Consultation. Used in scheduling platforms and clinical documentation systems to standardize visit classification and support reporting across care settings.

visit totalvst_tot

Aggregate numeric value representing the sum of charges, units, services, or other countable elements associated with a patient encounter. Referenced in claims billing systems, EHR charge capture modules, and remittance data to reconcile provider charges against adjudicated payments and EOB line items.

visit total countvst_tot_cnt

Represents the cumulative number of patient encounters recorded within a defined period or for a specific patient, provider, or care program. Used in utilization management, population health analytics, and quality reporting to quantify care access patterns and service volume metrics.

visit typevst_typ

Standardized classification categorizing the nature of a patient encounter, such as office visit, telehealth, inpatient, outpatient, urgent care, or preventive visit. Mapped to place-of-service codes and revenue codes in claims systems, and used in EHR reporting to segment utilization and quality measure populations.

visit updated datevst_upd_dt

Records the most recent date on which a visit record was modified in the clinical or administrative system. Used in data governance, audit trail management, and ETL processes to identify changed records, ensure data currency, and support incremental data refresh workflows across health information systems.

visit urgencyvst_urg

Classifies the clinical urgency or acuity level assigned to a patient encounter, such as routine, urgent, or emergent. Used in triage workflows, scheduling prioritization, and ED operations reporting to ensure patients are seen within clinically appropriate timeframes based on their presenting condition.

visit versionvst_ver

Tracks the iteration number of a visit record to identify updates, corrections, or amendments made after the initial encounter documentation was created. Used in clinical data auditing, version control workflows, and longitudinal record management to distinguish current from prior versions of an encounter record.

visit zipvst_zip

Stores the five-digit or nine-digit U.S. postal ZIP code associated with the patient's residence or the care delivery site at the time of the visit. Used in geographic analysis, social determinants of health research, and population health stratification across claims and clinical data systems.

vital account numbervtl_acct_nbr

The unique account identifier linking a vital signs record to a specific patient account or encounter in the clinical or revenue cycle system. Used to associate physiological measurements with the correct billing account, ensuring vital signs data can be traced to the appropriate visit and patient financial record.

vital active indicatorvtl_actv_ind

A binary flag indicating whether a vital signs record is currently active and clinically valid within the patient's health record. Used in clinical data management to distinguish current physiological measurements from voided, superseded, or historical vital signs entries that should be excluded from active care workflows.

vital active statusvtl_actv_sts

Indicates the current operational state of a vital signs record, such as active, inactive, or archived, within the clinical information system. Used in data lifecycle management to control which physiological measurements are surfaced in clinical views and included in quality reporting and analytics workflows.

vital addressvtl_addr

Physical location information associated with a vital signs measurement record in EHR and remote patient monitoring systems, identifying where the measurement was captured such as a clinic, home device, or hospital ward. Data engineers use this field for geospatial analysis, care setting classification, and monitoring source attribution in clinical data pipelines.

vital adjustment amountvtl_adj_amt

Records a corrective numeric value applied to a previously captured vital signs measurement to account for documentation errors or calibration corrections. Used in clinical data quality workflows to maintain accurate physiological baselines and ensure adjusted values are reflected in patient monitoring and trending analyses.

vital admission datevtl_admn_dt

Date on which a patient was admitted to a facility concurrent with vital signs measurement capture in EHR and hospital information systems, linking biometric data to inpatient encounter timelines. Data engineers use this field to align vital signs records with admission episodes for longitudinal clinical analysis and inpatient data modeling.

vital agevtl_age

Records the patient's age in years at the time a vital signs measurement was captured during a clinical encounter. Used in clinical decision support, pediatric and geriatric care protocols, and population health analytics to apply age-appropriate reference ranges when interpreting physiological measurements such as blood pressure or heart rate.

PreviousPage 788 of 806Next