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 countrywrd_ctry

The country associated with a hospital ward's physical location, relevant in multinational health system networks or cross-border facility data exchanges. Used in facility master data management to ensure accurate geographic classification for regulatory compliance, reporting, and international patient transfer coordination.

ward created bywrd_crtd_by

The username or system identifier of the user who originally created the ward record in the hospital information system. Used for data governance, audit trail maintenance, and accountability tracking within clinical and administrative workflows to establish record ownership and support compliance reviews.

ward created datewrd_crtd_dt

The calendar date on which a ward record was initially entered into the hospital information system. Used in facility master data management and audit processes to establish record provenance, track system configuration history, and support data lineage analysis in clinical and administrative reporting environments.

ward created timewrd_crtd_tm

The timestamp indicating the exact time a ward record was first created in the hospital information system. Used alongside the created date for precise audit trail documentation, system event logging, and data integrity validation in inpatient clinical and facility management platforms.

ward creatininewrd_cr

The serum or urine creatinine value measured for a patient during a ward-level inpatient stay, used as a key indicator of renal function. Documented in inpatient clinical records to monitor kidney health, assess acute kidney injury risk, and guide medication dosing adjustments during hospitalization.

ward datewrd_dt

The specific calendar date associated with a ward-level event or record in an inpatient episode, such as a bed assignment, transfer, or clinical observation. Used in hospital information systems to establish temporal context for patient movement tracking, length-of-stay calculation, and inpatient care timeline reporting.

ward datetimewrd_dttm

The combined date and time value recorded for a specific hospital ward event or transaction, such as a patient admission, transfer, or discharge. Used in inpatient clinical systems to establish precise timestamps for ward-level activities and patient movement tracking.

ward dea numberwrd_dea_nbr

The Drug Enforcement Administration registration number associated with a hospital ward, authorizing the ward to handle controlled substances. Used in inpatient pharmacy and clinical systems to ensure regulatory compliance when dispensing or administering scheduled medications within that unit.

ward death datewrd_death_dt

The recorded calendar date on which a patient death occurred within a specific hospital ward. Used in inpatient clinical and administrative systems to support mortality reporting, discharge disposition coding, and compliance with vital statistics and regulatory documentation requirements.

ward deductible amountwrd_ded_amt

The patient insurance deductible amount applied to services rendered within a specific hospital ward during an inpatient stay. Used in hospital billing and revenue cycle systems to calculate patient financial responsibility and reconcile payments against adjudicated inpatient claims.

ward deleted datewrd_del_dt

The calendar date on which a hospital ward record was logically removed or deactivated within the healthcare information system. Used in inpatient facility management and data governance workflows to maintain audit trails and track the lifecycle of ward configuration records.

ward deleted indicatorwrd_del_ind

A flag designating whether a hospital ward record has been logically deleted or deactivated in the system without physical removal. Used in inpatient facility management systems to filter inactive wards from operational workflows while preserving historical data integrity for reporting and auditing purposes.

ward descriptionwrd_desc

The human-readable text label or narrative that identifies and describes a specific hospital ward, such as its clinical specialty, patient population, or physical location. Used in inpatient systems, bed management tools, and clinical documentation to clearly communicate ward identity to clinical and administrative staff.

ward detailwrd_dtl

Supplementary information associated with a specific hospital ward record, capturing granular attributes beyond standard identifiers such as unit capacity, clinical specialty designation, or operational notes. Used in inpatient facility management and clinical data systems to support detailed ward-level reporting and configuration.

ward due datewrd_due_dt

The date by which a specific ward-related obligation, task, or payment is expected to be completed or received. Used in hospital administrative and billing systems to track deadlines associated with inpatient ward transactions, including outstanding balances, documentation requirements, or scheduled reviews.

ward durationwrd_dur

The calculated length of time a patient occupied a specific hospital ward, typically measured in hours or days between admission and transfer or discharge from that unit. Used in inpatient utilization management, staffing analysis, and clinical reporting to assess ward-level patient flow and length of stay metrics.

ward effective datewrd_eff_dt

The calendar date on which a hospital ward record, configuration, or associated policy becomes active and operationally valid within the healthcare system. Used in inpatient facility management to control the activation of ward-level settings, staffing assignments, and billing parameters tied to specific time periods.

ward emailwrd_eml

The electronic mail address associated with a specific hospital ward unit, used for internal communications, care coordination, and administrative correspondence. Used in inpatient clinical and facility management systems to facilitate direct contact with ward staff for scheduling, referrals, and operational notifications.

ward emergency indicatorwrd_emerg_ind

A flag identifying whether a hospital ward is designated or currently operating under emergency status, such as surge capacity or disaster response conditions. Used in inpatient facility management and clinical operations systems to trigger special protocols, resource allocation adjustments, and compliance reporting.

ward end datewrd_end_dt

The calendar date marking the conclusion of a patient's stay in a specific hospital ward, or the deactivation date of the ward record itself. Used in inpatient clinical and administrative systems to define the closing boundary of ward-level episodes for billing, reporting, and patient movement tracking.

PreviousPage 299 of 325Next