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

value labelval_lbl

The human-readable text label assigned to a specific discrete data value within a clinical or claims dataset. Used in reporting, user interfaces, and data governance documentation to provide meaningful descriptions for coded or numeric values, improving interpretability across health data systems.

value procedure dateval_proc_dt

The discrete date value representing when a clinical procedure was performed, as stored in a claims or clinical record. Used in claims adjudication, prior authorization matching, and clinical analytics to confirm procedure timing relative to coverage periods, referrals, and episode-of-care boundaries.

value rangeval_rng

The discrete minimum and maximum boundary values associated with a clinical or administrative data element. Used in data quality management and clinical decision support to define acceptable limits for measurements such as lab results, vital signs, or reimbursement amounts within a specific context or population.

value resultval_rslt

The discrete outcome or measurement value recorded for a clinical observation, lab test, or administrative data check. Used in clinical analytics, quality measure reporting, and claims processing to capture quantitative or categorical findings such as test results, scores, or adjudication outcomes.

value surgery dateval_surg_dt

The discrete date value representing when a surgical procedure was performed, as stored in a clinical or claims record. Used in surgical claims adjudication, operative report reconciliation, and post-operative care coordination to establish the timing of surgical services relative to authorization and billing periods.

verification admission dateverif_admn_dt

The confirmed inpatient admission date validated against clinical documentation or payer records during a utilization review or prior authorization process. Used in concurrent review workflows to ensure the authorized stay aligns with actual hospital admission.

verification discharge dateverif_dsch_dt

The confirmed inpatient discharge date validated against clinical documentation or payer records during utilization review. Used in retrospective or concurrent review to reconcile the authorized length of stay with the actual date the patient was released from the facility.

verification emergency indicatorverif_emerg_ind

A flag identifying whether a verified inpatient admission or procedure was classified as an emergency, bypassing standard prior authorization requirements. Impacts claims adjudication and retrospective review rules applied by the payer during the verification process.

verification history present illnessverif_hpi

The clinical narrative describing the patient's current condition as documented during the verification or prior authorization review process. Captures the presenting symptoms and timeline submitted to the payer to support medical necessity determination for the requested service.

verification labelverif_lbl

The descriptive display name assigned to a specific verification or prior authorization record, used to identify the type or category of clinical review in payer and utilization management systems. Supports workflow routing, reporting, and user interface display across authorization platforms.

verification procedure dateverif_proc_dt

The confirmed date on which a clinical procedure was performed, validated during the prior authorization or utilization review process. Used to ensure the procedure occurred within the authorized service window and to support accurate claims adjudication against the verified authorization record.

verification rangeverif_rng

The acceptable value span or date window associated with a prior authorization or clinical verification record, defining the boundaries within which a service, result, or admission is considered valid. Used in utilization management to enforce payer-defined limits on authorized services or clinical thresholds.

verification resultverif_rslt

The outcome of a prior authorization, utilization review, or clinical verification process, indicating whether the requested service was approved, denied, pended, or modified. Drives downstream claims adjudication and member or provider notification workflows within payer and care management systems.

verification surgery dateverif_surg_dt

The confirmed date on which a surgical procedure was performed, validated during the prior authorization or utilization review process. Used to reconcile the authorized surgery date against actual performance, ensuring claims adjudication is applied within the approved authorization window.

visit active indicatorvst_actv_ind

A binary flag indicating whether a patient visit record is currently active and open in the clinical or administrative system. Used to filter records in scheduling, billing, and care management workflows, distinguishing encounters in progress from those that have been completed, cancelled, or voided.

visit active statusvst_actv_sts

A coded or descriptive value representing the current operational state of a patient visit within clinical or administrative systems, such as scheduled, in-progress, completed, or cancelled. Used to manage encounter workflows, support reporting, and drive downstream billing and care coordination processes.

visit admission datevst_admn_dt

Date and timestamp marking the official start of a patient encounter or appointment, stored in EHR scheduling, ADT, and claims systems. Used as the primary encounter anchor for linking clinical events, calculating length of stay, driving claims adjudication logic, and aligning member eligibility verification in payer and provider data systems.

visit agevst_age

The calculated age of the patient at the time of the clinical visit, typically derived from the patient's date of birth and the visit date. Used in clinical documentation, quality measure reporting, and risk stratification workflows where age-specific criteria determine appropriate screening or treatment protocols.

visit allowed amountvst_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered during a patient visit, as determined by the contracted fee schedule or benefit plan. Used in claims adjudication and remittance processing to calculate member cost-sharing responsibilities and provider payment amounts.

visit amountvst_amt

Total gross charge or billed amount associated with a patient encounter, stored in practice management, EHR, and claims systems. Used by data engineers to reconcile billed charges against allowed amounts, contractual adjustments, and remittance data; critical for revenue cycle analytics, payer contract performance, and financial reporting workflows.

PreviousPage 781 of 806Next