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 referencevst_ref

External identifier or cross-system pointer linking a patient encounter to related records in upstream or downstream systems such as referral platforms, payer portals, or HIE networks. Used in EHR and claims systems to enable encounter reconciliation and care coordination tracking.

visit resolution datevst_resol_dt

Records the date on which the condition, complaint, or issue addressed during the visit was documented as resolved. Used in chronic disease management, episode-of-care analysis, and outcomes reporting to measure time-to-resolution and evaluate treatment effectiveness across patient populations.

visit respirationvst_resp

Captures the patient's respiratory rate in breaths per minute as measured during the clinical encounter. This vital sign is used to assess pulmonary and systemic health, detect deterioration in acutely ill patients, and populate early warning scoring systems such as NEWS or MEWS in inpatient settings.

visit resultvst_rslt

Documented outcome or finding recorded for a patient encounter in EHR and care management systems, including diagnostic conclusions, test findings, or clinical disposition after the visit. Data engineers use this field for outcomes analysis, quality measure attribution, and clinical decision support datasets in healthcare analytics platforms.

visit revisionvst_rev

Tracks the version or iteration number of a visit record, incrementing each time the encounter documentation is amended or corrected. Used in audit trails and clinical documentation integrity workflows to maintain a complete history of changes made to encounter records after initial entry.

visit riskvst_rsk

Records a risk level or stratification score assigned to a patient during or prior to a clinical encounter, reflecting clinical, social, or financial risk factors. Used in care management programs, utilization review, and predictive analytics to prioritize high-risk patients for outreach and intervention.

visit routevst_rte

Specifies the pathway or access point through which a patient enters or is directed to care, such as referral, walk-in, emergency, or telehealth. Used in care coordination, utilization reporting, and network analysis to understand patient flow and measure the effectiveness of different care access channels.

visit scorevst_scr

Calculated numeric rating assigned to a patient encounter based on clinical, operational, or quality criteria such as acuity, HEDIS compliance, or risk stratification algorithms. Used in EHR analytics, care management platforms, and population health tools to prioritize interventions.

visit sequencevst_seq

Ordinal integer identifying the chronological or logical position of an encounter within a series of related visits, such as post-surgical follow-ups or chronic disease management episodes. Used in EHR and claims systems for longitudinal care pathway analysis and episode grouping.

visit severityvst_sev

Coded or scored indicator representing the clinical seriousness of a patient encounter, often derived from diagnosis codes, acuity scales, or triage classifications such as ESI levels. Used in EHR, claims, and utilization management systems to support resource allocation and risk adjustment.

visit sexvst_sex

Records the biological sex of the patient as documented at the time of the clinical visit. Used in demographic analysis, clinical decision support, and population health reporting to ensure sex-appropriate care protocols and screenings are applied during the encounter.

visit sourcevst_src

Coded value identifying the originating channel or referral pathway through which a patient encounter was initiated, such as self-referral, PCP referral, ED transfer, or telehealth platform. Captured in EHR scheduling and claims systems to support network analysis and care coordination reporting.

visit start datevst_start_dt

Calendar date marking the official beginning of a patient encounter, used to anchor episode timelines, apply authorization windows, and calculate length of stay or episode duration. Populated in EHR admission records, facility claims (UB-04), and professional claims (CMS-1500) for billing and analytics.

visit start timevst_start_tm

Captures the exact clock time when a patient encounter or appointment begins, typically recorded in HH:MM format. Used in scheduling systems and clinical operations to calculate visit duration, measure provider efficiency, and support patient flow analysis across care settings.

visit statevst_st

Records the U.S. state or Canadian province where the patient encounter took place or where the patient resides at the time of the visit. Used in geographic reporting, licensure compliance validation, and state-level public health surveillance across clinical and claims data systems.

visit statusvst_sts

Current lifecycle state of a patient encounter within a workflow, such as scheduled, checked-in, in-progress, completed, cancelled, or no-show. Tracked in EHR scheduling and practice management systems to support operational reporting, appointment utilization metrics, and claims submission readiness.

visit strengthvst_str

Captures the concentration or potency of a medication documented or administered during a clinical encounter, such as 500mg or 10mg/mL. Used in pharmacy reconciliation, medication management workflows, and clinical documentation to ensure accurate dosing records tied to specific visits.

visit subtotalvst_subtot

Represents the partial charge or cost amount for a clinical visit before adjustments, discounts, or additional fees are applied. Used in revenue cycle management and billing workflows to calculate intermediate financial totals prior to generating the final visit-level claim amount.

visit surgery datevst_surg_dt

Records the calendar date on which a surgical procedure was performed in association with a patient visit or admission. Used in operative documentation, perioperative care tracking, and outcomes reporting to link surgical events to the corresponding inpatient or outpatient encounter record.

visit targetvst_tgt

Reference identifier designating the intended destination, provider, facility, or care setting associated with a patient encounter, such as a referred-to specialist or receiving facility. Used in EHR referral management, care coordination platforms, and claims systems to track care transitions and network compliance.

PreviousPage 787 of 806Next