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

wing active statuswng_actv_sts

A coded value representing the current operational state of a hospital building wing, such as active, inactive, or under renovation. Used in facility and capacity management systems to reflect real-time availability for patient admissions, clinical services, and staffing assignments.

wing admission datewng_admn_dt

The calendar date on which a patient was admitted to or transferred into a specific hospital building wing. Used in inpatient census and facility management records to track patient movement, measure wing-level occupancy patterns, and support bed utilization reporting.

wing discharge datewng_dsch_dt

The calendar date on which a patient was discharged from or transferred out of a specific hospital building wing. Used in inpatient records and facility management systems to calculate wing-level length of stay, bed turnover rates, and capacity planning metrics.

wing durationwng_dur

The total elapsed time a patient spent in a specific hospital building wing, calculated from admission to discharge or transfer. Used in inpatient analytics to measure wing-level occupancy, evaluate care efficiency, and support resource allocation and staffing decisions.

wing emergency indicatorwng_emerg_ind

A binary flag designating whether a patient encounter or admission within a specific hospital wing was classified as an emergency. Used in inpatient and facility records to differentiate emergency from elective cases, support triage workflows, and enable wing-level emergency volume reporting.

wing history present illnesswng_hpi

The clinical narrative documenting the onset, progression, and nature of a patient's current condition as recorded during their stay in a specific hospital wing. Captured in inpatient clinical documentation to provide context for care decisions made within that wing's clinical team.

wing instructionwng_instr

Operational or clinical guidance text associated with a specific hospital building wing, such as isolation protocols, visitor policies, or care pathway directives. Used in facility management and clinical systems to communicate wing-specific rules and procedures to staff and care teams.

wing labelwng_lbl

The human-readable display name assigned to a specific hospital building wing, used in facility management and clinical systems to identify and differentiate physical sections of the hospital such as North Wing, Oncology Wing, or Maternity Wing for navigation and assignment purposes.

wing notewng_nt

Free-text annotation associated with a specific hospital building wing, capturing operational observations, temporary conditions, or administrative comments. Used in facility management systems to document wing-level details that do not fit into structured fields, supporting staff communication and audit trails.

wing procedure datewng_proc_dt

The calendar date on which a clinical procedure was performed on a patient located in a specific hospital building wing. Used in inpatient records to associate procedural events with the physical care location, supporting wing-level utilization analysis and clinical outcome reporting.

wing rangewng_rng

The defined span of rooms, beds, or patient care areas encompassed within a specific hospital building wing. Used in facility management and bed assignment systems to establish physical boundaries of a wing, supporting census tracking, staff assignments, and capacity planning.

wing resultwng_rslt

The recorded outcome of a clinical assessment, diagnostic test, or care intervention performed within a specific hospital building wing. Used in inpatient clinical records to associate test or treatment results with the wing-level care setting, enabling location-based outcome analysis.

wing routewng_rte

The designated physical or logical pathway used for patient transport, medication delivery, or care coordination within a specific hospital building wing. Used in facility management and clinical operations to define logistics workflows, support care transitions, and optimize movement within the wing.

wing surgery datewng_surg_dt

The calendar date on which a surgical procedure was performed on a patient assigned to a specific hospital building wing. Recorded in inpatient clinical and facility management records to track surgical activity by location, support post-operative care planning, and enable wing-level surgical volume reporting.

workflow active indicatorwf_actv_ind

A binary flag indicating whether a specific clinical or administrative workflow is currently enabled and in use within a healthcare information system. Used to control process routing, task generation, and system behavior, ensuring only approved workflows are executed during care delivery or administrative operations.

workflow active statuswf_actv_sts

A coded value representing the current operational state of a clinical or administrative workflow, such as active, suspended, or retired. Used in healthcare information systems to manage process lifecycle, control task assignments, and ensure that only valid, approved workflows are available for execution in care or operational settings.

workflow admission datewf_admn_dt

Records the date a patient encounter or clinical task entered an active workflow queue in the healthcare information system. Used to measure workflow initiation timing, track processing delays, and calculate turnaround metrics for care coordination and operational reporting.

workflow discharge datewf_dsch_dt

Records the date a patient encounter or clinical task was completed and closed within the workflow management system. Used alongside admission date to calculate total workflow cycle time, identify bottlenecks, and support operational efficiency reporting across care settings.

workflow durationwf_dur

Captures the elapsed time between workflow initiation and completion for a clinical or administrative process sequence. Measured in hours or days, this metric supports performance benchmarking, SLA compliance monitoring, and identification of inefficiencies in care delivery or revenue cycle operations.

workflow emergency indicatorwf_emerg_ind

A binary flag identifying whether a clinical or administrative workflow task has been escalated to emergency or urgent priority status. Drives automated routing rules, staffing alerts, and queue prioritization logic within care coordination and patient flow management systems.

PreviousPage 797 of 806Next