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 labelvst_lbl

A descriptive display tag assigned to a clinical visit to facilitate human-readable identification within scheduling, EHR, and reporting interfaces. Used to categorize or annotate encounters by visit type, care program, or workflow status for operational and clinical management purposes.

visit languagevst_lang

The patient's preferred spoken or written language as recorded at the time of the clinical visit. Used in EHR and care coordination systems to arrange interpreter services, deliver language-appropriate patient education, and meet CMS language access requirements for underserved populations.

visit last namevst_last_nm

The patient's family surname as documented at the time of the clinical encounter. Used in EHR and scheduling systems for patient identity verification, alphabetical record retrieval, and accurate linkage of visit records to the correct individual across multiple episodes of care.

visit legal namevst_legal_nm

The patient's full legally registered name as captured during the clinical visit, which may differ from preferred or chosen name. Used in medical records, consent documentation, insurance billing, and identity verification processes requiring official name matching against government-issued identification.

visit levelvst_lvl

Hierarchical classification in EHR and claims systems indicating the complexity or intensity of a patient encounter, such as E&M levels 1-5. Used by data engineers to map CPT evaluation and management codes, support reimbursement analysis, and validate billing hierarchies in claims data pipelines.

visit license numbervst_lic_nbr

The state-issued professional license number of the clinician who conducted the patient visit. Used in credentialing verification, claims submission, and regulatory compliance reporting to confirm that care was delivered by a licensed provider authorized to practice within the relevant jurisdiction.

visit marital statusvst_mar_sts

The patient's marital or domestic partnership status as recorded at the time of the clinical encounter. Used in EHR demographic data to support social determinants of health assessments, insurance coordination of benefits determinations, and population health stratification for care management programs.

visit master identifiervst_mstr_id

The enterprise-level master patient or encounter identifier that uniquely identifies a visit across all integrated clinical systems. Used in health information exchanges, data warehouses, and master patient index solutions to deduplicate records and link encounters across disparate EHR and billing platforms.

visit maximumvst_max

The upper threshold value for a clinical measurement or benefit limit recorded at the visit level, such as maximum allowable units of a service or the highest observed vital sign reading. Used in utilization management, prior authorization, and clinical decision support to flag values exceeding safe or covered limits.

visit middle namevst_mid_nm

The patient's middle name or initial as recorded at the time of the clinical encounter. Used alongside first and last name fields in EHR systems to improve patient identity matching accuracy, reduce duplicate record creation, and ensure correct attribution of visit documentation to the intended individual.

visit minimumvst_min

The lower threshold value for a clinical measurement or benefit floor recorded at the visit level, such as the minimum observed vital sign reading or lowest covered service units. Used in clinical decision support and utilization management to identify values below acceptable ranges requiring clinical review.

visit mobilevst_mob

The patient's mobile phone number captured at the time of the clinical visit. Used in patient engagement platforms, appointment reminder systems, and care coordination workflows to send SMS notifications, telehealth links, and follow-up communications to support continuity of care and reduce no-show rates.

visit modified byvst_mod_by

Identifies the user who last updated the visit record in the EHR or scheduling system. Captures the username or user ID of the clinician, scheduler, or administrator who made the most recent change to the appointment or encounter data.

visit modified datevst_mod_dt

Timestamp recorded in EHR and practice management systems capturing the most recent update to a patient encounter record, including edits to diagnosis codes, documentation, or billing status. Data engineers use this field for incremental data loads, change data capture pipelines, and audit trail maintenance.

visit modified timevst_mod_tm

Records the exact timestamp when a visit record was last updated in the clinical system. Used for audit tracking, data synchronization, and change history reviews across EHR and scheduling platforms to ensure record integrity and compliance with documentation standards.

visit namevst_nm

Human-readable label assigned to a patient encounter type in EHR scheduling and practice management systems, such as Annual Wellness Visit or Follow-Up Consultation. Data engineers use this field for encounter categorization, reporting display layers, and mapping to standardized visit taxonomies across source systems.

visit notevst_nt

Clinical annotation or free-text documentation attached to a patient encounter record in EHR systems, including SOAP notes, provider observations, or administrative comments. Data engineers process this field for NLP pipelines, clinical documentation analysis, and unstructured data extraction workflows in healthcare data lakes.

visit numbervst_nbr

Unique or sequential reference identifier assigned to a patient encounter in EHR, claims, and hospital information systems, often used as the primary encounter key. Data engineers rely on this field for record linkage, claims-to-encounter matching, and deduplication across source systems in healthcare data warehouses.

visit onset datevst_onset_dt

Captures the date when the patient's symptoms or condition first began, as documented during the clinical encounter. Used in disease surveillance, chronic condition tracking, and clinical coding workflows to establish the timeline between symptom emergence and care-seeking behavior.

visit oxygen saturationvst_o2sat

Records the patient's peripheral oxygen saturation (SpO2) percentage as measured during the clinical visit, typically via pulse oximetry. This vital sign is used to assess respiratory function, monitor chronic conditions like COPD, and guide clinical decision-making during acute or routine encounters.

PreviousPage 785 of 806Next