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

ward versionwrd_ver

The sequential version number assigned to a hospital ward record indicating the iteration of the data following updates or modifications, used to support change tracking, audit trails, and historical comparison of inpatient unit configurations in healthcare systems.

ward zipwrd_zip

The postal ZIP code associated with the physical location of a hospital ward or its parent facility, used for geographic classification, regulatory reporting, and facility-level demographic analysis within healthcare information and credentialing systems.

watermark timestampwtrmrk_ts

A timestamp value stored in a pipeline control table representing the maximum record creation or update timestamp from the most recent successful data extraction, used as the lower boundary for incremental data loads to ensure only new and changed records are processed in subsequent pipeline runs without reprocessing the full dataset.

wing addresswng_addr

The physical street address or internal location identifier for a specific building wing within a healthcare facility, used in facility management systems to direct patients, staff, and services to the correct structural section of a hospital campus.

wing agewng_age

The number of years since a specific building wing of a healthcare facility was constructed or last significantly renovated, used in facilities management and capital planning systems to assess infrastructure age and prioritize maintenance or replacement decisions.

wing allowed amountwng_alwd_amt

The maximum reimbursable dollar amount associated with services or costs attributed to a specific building wing within a healthcare facility, used in internal cost allocation and financial management reporting across hospital departments and facility billing systems.

wing amountwng_amt

The monetary value associated with a financial transaction, cost allocation, or budget line item attributed to a specific building wing within a healthcare facility, used in facility-level financial reporting and internal accounting systems for hospital operations.

wing approval statuswng_appr_sts

Indicates the current authorization or review state of a hospital wing or building section within a facility management system. Tracks whether the wing configuration, bed assignments, or operational changes have been reviewed and approved by the designated authority.

wing approved bywng_appr_by

Records the identifier or name of the staff member who authorized changes to a hospital wing or building section. Used in facility management workflows to maintain an audit trail of who approved updates to wing-level configurations, bed assignments, or operational policies.

wing arrival timewng_arrv_tm

Captures the time a patient physically arrived at a specific hospital wing or unit following admission or transfer. Used in inpatient tracking systems to measure transit time between admission events and unit placement, supporting bed management and throughput analysis.

wing arrived datewng_arrv_dt

Records the calendar date a patient arrived at a designated hospital wing or inpatient unit. Used alongside wing arrival time in bed management and census reporting systems to calculate length of stay by unit and evaluate patient flow efficiency across facility sections.

wing assessmentwng_asmt

Contains the clinical evaluation notes or findings documented by nursing or clinical staff specific to a hospital wing or unit. Used in inpatient EHR workflows to capture structured or free-text assessments tied to a patient's care episode within a particular wing or unit setting.

wing balancewng_bal

Represents the outstanding financial balance associated with services or charges attributed to a specific hospital wing or unit. Used in healthcare revenue cycle systems to track unpaid amounts at the wing level, supporting departmental billing reconciliation and financial reporting.

wing billed amountwng_bill_amt

Captures the total dollar amount billed for healthcare services rendered within a specific hospital wing or inpatient unit. Used in revenue cycle and claims management systems to attribute charges at the wing level for departmental cost accounting and payer billing reconciliation.

wing birth datewng_birth_dt

Records the date of birth of a patient associated with an encounter or record scoped to a specific hospital wing or unit. Used in inpatient registration and clinical systems to support patient identification, age-based clinical rules, and demographic verification at the wing encounter level.

wing blood pressurewng_bp

Stores the blood pressure measurement recorded for a patient during their stay in a specific hospital wing or inpatient unit. Used in clinical documentation and vital signs tracking systems to monitor cardiovascular status as part of ongoing nursing assessments within the unit.

wing cancelled datewng_cncl_dt

Records the date on which a scheduled activity, service, or patient placement associated with a hospital wing was cancelled. Used in inpatient scheduling and bed management systems to track cancellation events at the wing level for operational reporting and capacity planning.

wing categorywng_cat

Classifies a hospital wing or inpatient unit into a defined grouping such as medical, surgical, pediatric, or intensive care. Used in facility management and census reporting systems to organize wings by functional type, supporting resource allocation, staffing models, and regulatory compliance reporting.

wing charge amountwng_chrg_amt

Represents the monetary charge assessed for services, accommodations, or procedures associated with a specific hospital wing or inpatient unit. Used in healthcare revenue cycle systems to attribute service-level costs to a wing for departmental billing, payer submissions, and financial performance analysis.

wing chief complaintwng_cc

Captures the primary symptom or reason for care documented by clinical staff upon a patient's arrival or assessment within a specific hospital wing or unit. Used in inpatient clinical documentation to establish the presenting condition that drives care planning within that unit setting.

PreviousPage 305 of 325Next