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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

visit approval statusvst_appr_sts

Authorization state indicating whether a patient care visit has been approved, denied, pending, or requires additional review. Used in utilization management and prior authorization workflows to determine if a scheduled or completed visit meets payer criteria for coverage and reimbursement.

visit charge amountvst_chrg_amt

Total billed charge associated with a patient care visit before any contractual adjustments, co-pays, or payer reimbursements are applied. Captured in claims and hospital billing systems to initiate the revenue cycle and determine patient and payer financial responsibility.

visit effective datevst_eff_dt

The date on which a patient visit record becomes officially active or valid within a healthcare system, distinct from the service date or scheduled date. Used in EHR and claims platforms, vst_eff_dt is critical for temporal data joins, eligibility verification at time of service, and longitudinal patient record construction.

visit medical record numbervst_mrn

Unique Medical Record Number assigned to a patient and linked to a specific care visit, enabling consistent identification across clinical encounters, departments, and facilities. Used to aggregate visit history, support continuity of care, and reconcile claims with clinical documentation.

visit scheduled datevst_sched_dt

Calendar date on which a patient care visit is planned to take place, used in appointment scheduling, resource management, and care coordination systems. Supports utilization reporting, prior authorization timing, and no-show tracking within ambulatory and inpatient care settings.

visit scheduled timevst_sched_tm

The clock time at which a patient care appointment is planned to begin. Used in scheduling systems to coordinate clinical staff, facility resources, and patient flow. Enables tracking of appointment adherence, wait times, and operational throughput analysis.

visit street addressvst_st_addr

The physical street-level address where a patient care appointment is scheduled to occur. Captures the specific building or suite location for the visit site, supporting care coordination, patient notifications, provider directory accuracy, and claims-based place-of-service validation.

visit unitvst_unt

The standardized measurement unit associated with a patient visit record, such as the count of visit encounters, hours of service, or relative value units assigned to the visit. Used in EHR, claims, and scheduling systems, vst_unt enables utilization rate calculations, provider productivity reporting, and reimbursement validation workflows.

ward account numberwrd_acct_nbr

A unique numeric or alphanumeric identifier assigned to a specific hospital ward or inpatient unit for billing and administrative tracking purposes. Used in hospital information systems to link patient admissions, census data, and financial transactions to the correct inpatient care area.

ward active indicatorwrd_actv_ind

A binary flag indicating whether a hospital ward or inpatient unit is currently operational and available for patient admissions. Used in hospital census and bed management systems to filter active units from decommissioned or temporarily closed wards during reporting and capacity planning.

ward active statuswrd_actv_sts

A categorical value describing the current operational state of a hospital ward or inpatient unit, such as active, inactive, or pending. Used in facility management and clinical data systems to control ward availability for patient assignments, staffing allocation, and bed management reporting.

ward addresswrd_addr

The physical location details of a hospital ward or inpatient unit, including building, floor, or wing designation. Used in clinical and administrative systems to route patients, staff, and supplies accurately within a hospital facility and to support regulatory reporting requirements.

ward adjustment amountwrd_adj_amt

The dollar value of a financial adjustment applied to charges associated with a hospital ward stay, such as contractual write-offs, billing corrections, or payer-negotiated discounts. Used in hospital revenue cycle management to reconcile billed charges against actual reimbursement amounts.

ward agewrd_age

The age in years of a patient admitted to a specific hospital ward at the time of admission or assessment. Used in clinical analytics and inpatient reporting to stratify ward populations by age group, supporting acuity analysis, staffing ratios, and quality outcome measurement.

ward allowed amountwrd_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered during a patient's stay on a specific hospital ward, based on contracted rates or fee schedules. Used in hospital billing and claims adjudication to calculate patient liability and contractual adjustment amounts.

ward amountwrd_amt

The total monetary value associated with charges or costs incurred during a patient's stay on a specific hospital ward. Used in inpatient financial reporting and revenue cycle systems to aggregate ward-level billing data for cost analysis, payer reconciliation, and hospital budgeting.

ward approval statuswrd_appr_sts

The current authorization or review state of a hospital ward-related request or transaction, such as a bed assignment, transfer order, or financial adjustment. Used in clinical and administrative workflows to track whether ward-level actions have received required approvals before execution.

ward approved bywrd_appr_by

The identifier or name of the individual who authorized a ward-related clinical or administrative action, such as a patient transfer, care plan update, or financial adjustment. Used in audit trails and compliance reporting to ensure accountability for decisions made within inpatient ward management workflows.

ward arrival timewrd_arrv_tm

The clock time at which a patient physically arrived on a specific hospital ward following admission, transfer, or procedure. Used in inpatient throughput analysis and bed management systems to measure ward handoff efficiency, nurse workload distribution, and compliance with patient placement standards.

ward arrived datewrd_arrv_dt

The calendar date on which a patient arrived on a specific hospital ward following admission or transfer from another unit. Used in inpatient census reporting, length-of-stay calculations, and clinical data systems to establish the start of a patient's stay on a given ward.

PreviousPage 297 of 325Next