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

wing identifierwng_id

The unique system-assigned value used to identify a specific wing or section within a healthcare facility across clinical and administrative data systems. Serves as the primary key for linking patient assignments, staffing records, and operational data to the correct physical location.

wing indexwng_idx

The sequential or positional number assigned to a wing or section within a healthcare facility's organizational hierarchy. Used in facility management systems to order, rank, or reference wings within a building structure for navigation, reporting, and data processing purposes.

wing indicatorwng_ind

A coded value used to denote a specific condition, status, or characteristic of a wing or section within a healthcare facility. Used in clinical and facility management systems to flag wings with attributes such as isolation status, specialty designation, or operational restrictions.

wing keywng_key

The reference value used to look up and retrieve data associated with a specific wing or section of a healthcare facility within a database or information system. Functions as a relational key linking facility structure records to clinical, operational, and administrative datasets.

wing languagewng_lang

The primary language associated with staff or patient populations within a specific wing or section of a healthcare facility. Used in facility management and patient communication systems to support language-appropriate care delivery, signage, and documentation in multilingual hospital environments.

wing last namewng_last_nm

The secondary or surname component of a name designation used to identify a wing or section within a healthcare facility. Used in facility management systems where naming conventions mirror person-based structures, supporting sorting, display, and cross-referencing of wing records.

wing legal namewng_legal_nm

The officially registered or legally recognized name of a wing or section within a healthcare facility, as documented in licensing, accreditation, or regulatory records. Used in compliance reporting, facility credentialing, and official communications to ensure accurate identification of the unit.

wing levelwng_lvl

Numeric or coded value indicating a hospital wing's position within the facility hierarchy, used in bed management, patient placement, and capacity planning systems to organize and route care delivery across inpatient units and floors.

wing license numberwng_lic_nbr

Regulatory license identifier assigned to a specific hospital wing or inpatient unit, used in facility management systems to track compliance with state health department licensing requirements for distinct care areas operating under separate certifications.

wing marital statuswng_mar_sts

Data quality artifact resulting from template misapplication. This field likely captures operational status or designation of a hospital wing, such as active, inactive, or under renovation, within facility management and bed assignment tracking systems.

wing master identifierwng_mstr_id

Enterprise-level unique identifier assigned to a specific hospital wing within the master facility index, enabling consistent cross-system reference across bed management, patient placement, staffing, and clinical documentation platforms throughout the health system.

wing maximumwng_max

Upper threshold value associated with a hospital wing, representing the maximum licensed bed capacity, patient census limit, or staffing ceiling used in capacity management, regulatory reporting, and operational planning for inpatient unit administration.

wing medical record numberwng_mrn

Data quality artifact resulting from template misapplication. This field likely captures an internal reference number assigned to a hospital wing within the facility management system for tracking bed assignments, transfers, and unit-level patient census records.

wing middle namewng_mid_nm

Data quality artifact resulting from template misapplication. This field likely captures a secondary name component or alternate label for a hospital wing, such as a unit designation or informal name used alongside the official wing identifier in facility systems.

wing minimumwng_min

Lower threshold value associated with a hospital wing, representing the minimum staffing requirement, bed availability floor, or census baseline used in inpatient capacity management, regulatory compliance tracking, and operational planning for facility units.

wing mobilewng_mob

Mobile or portable contact number associated with the nursing station or charge desk of a specific hospital wing, used in facility communication directories to enable direct contact between staff, care coordinators, and patient logistics teams for unit-level coordination.

wing modified bywng_mod_by

User identifier of the individual who last updated a hospital wing record in the facility management system, captured for audit trail purposes to support data governance, change tracking, and accountability in inpatient unit configuration and bed management platforms.

wing modified datewng_mod_dt

Calendar date on which a hospital wing record was most recently updated in the facility management system, used for audit trail maintenance, data governance reporting, and tracking configuration changes to inpatient unit attributes such as capacity or operational status.

wing modified timewng_mod_tm

Timestamp indicating the exact time a hospital wing record was last updated in the facility management system, used alongside the modified date for precise audit trail tracking, data lineage documentation, and change history in inpatient unit administration systems.

wing namewng_nm

Human-readable label assigned to a specific hospital wing or inpatient unit, such as East Wing or Cardiac Care Unit, used across bed management, patient placement, staff scheduling, signage, and clinical documentation systems to identify the physical care area.

PreviousPage 308 of 325Next