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 keywrd_key

A surrogate or natural key value used to uniquely reference a hospital ward record within a database or data warehouse. Serves as the primary lookup value for joining ward-related data across clinical, administrative, and reporting tables in healthcare information and analytics systems.

ward languagewrd_lang

The primary language used for communication and clinical documentation within a specific hospital ward, often reflecting the predominant patient population served. Used to guide interpreter services, patient education material selection, and staff communication protocols within that inpatient unit.

ward last namewrd_last_nm

The secondary or surname-equivalent component of a hospital ward's name, used in systems that parse ward names into structured fields. Supports consistent display, sorting, and searching of ward records within hospital information systems managing inpatient unit directories and bed management workflows.

ward legal namewrd_legal_nm

The officially registered or formally designated name of a hospital ward as recognized in facility licensing, regulatory filings, or accreditation documentation. Used in compliance reporting, facility audits, and official communications where the unit must be referenced by its authorized name rather than an operational alias.

ward levelwrd_lvl

A classification indicating a hospital ward's position within the facility's organizational or care complexity hierarchy, such as general medical, step-down, or intensive care. Used in bed management and utilization reporting to distinguish inpatient units by acuity, staffing requirements, and resource allocation tiers.

ward license numberwrd_lic_nbr

The regulatory license or certification number assigned to a specific hospital ward or inpatient unit by a governing health authority. Used in compliance documentation and facility reporting to verify that the ward is authorized to operate and provide the level of care designated for that unit type.

ward marital statuswrd_mar_sts

The recorded marital status of a patient assigned to a specific hospital ward, captured during admission or registration. Used in clinical and administrative workflows to support next-of-kin identification, insurance coordination, and demographic reporting across inpatient care settings.

ward master identifierwrd_mstr_id

The enterprise-level unique identifier assigned to a specific hospital ward within the facility's master location registry. Used to consistently reference and link ward records across clinical, administrative, and billing systems, ensuring accurate patient placement tracking and bed management reporting.

ward maximumwrd_max

The upper threshold or capacity limit defined for a specific hospital ward, such as maximum bed count, patient census, or a clinical measurement ceiling. Used in bed management, resource planning, and capacity reporting to ensure ward operations remain within defined operational and safety parameters.

ward medical record numberwrd_mrn

The medical record number of the patient currently associated with a specific hospital ward assignment. Links the patient's longitudinal health record to their inpatient ward placement, enabling clinical documentation, care coordination, and audit trail tracking across the hospital information system.

ward middle namewrd_mid_nm

The middle name or initial of a patient or ward-associated individual recorded within the hospital ward management system. Used to support accurate patient identity matching, reduce duplicate record creation, and fulfill full legal name requirements in clinical and administrative documentation.

ward minimumwrd_min

The lower threshold or minimum value defined for a specific hospital ward, such as minimum staffing level, bed requirement, or a clinical measurement floor. Used in capacity planning, compliance monitoring, and operational reporting to ensure ward resources meet defined safety and service standards.

ward mobilewrd_mob

The mobile phone number associated with a patient or contact person linked to a specific hospital ward record. Used to facilitate direct communication for care coordination, discharge planning, appointment follow-up, and emergency notification within inpatient and ward management workflows.

ward modified bywrd_mod_by

The identifier of the user or system that last updated a hospital ward record within the healthcare information system. Provides an audit trail for data governance, change tracking, and accountability purposes, recording who made the most recent modification to ward configuration or patient placement data.

ward modified datewrd_mod_dt

The calendar date on which a hospital ward record was most recently updated within the healthcare information system. Used to maintain an audit trail of data changes, support compliance reporting, and ensure data currency in bed management, clinical, and administrative ward workflows.

ward modified timewrd_mod_tm

The precise time at which a hospital ward record was most recently updated within the healthcare information system. Combined with the modified date, it provides a complete timestamp for audit trail purposes, supporting change tracking, data governance, and real-time bed management monitoring.

ward namewrd_nm

The human-readable label assigned to a specific hospital ward, such as Cardiology Unit, Pediatric Ward, or Surgical Recovery. Used in clinical documentation, patient placement workflows, staff scheduling, wayfinding, and facility reporting to identify and distinguish ward locations across the hospital.

ward notewrd_nt

Free-text annotation or comment associated with a hospital ward record, capturing operational details, special instructions, or clinical observations relevant to that ward. Used by clinical and administrative staff to communicate context-specific information that does not fit within structured data fields.

ward numberwrd_nbr

The alphanumeric reference number assigned to a specific hospital ward for identification and tracking purposes. Used in patient placement, bed management, transfer workflows, and facility reporting to uniquely distinguish wards within a hospital unit structure independent of the ward name.

ward onset datewrd_onset_dt

The date on which a clinical condition, symptom, or episode of care first began for a patient assigned to a hospital ward. Used in inpatient clinical documentation to establish disease timeline, support diagnosis coding, track infection surveillance, and inform treatment planning decisions.

PreviousPage 301 of 325Next