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,390 operations terms

bed effective datebed_eff_dt

The date on which a patient accommodation unit record or status becomes active and operationally valid within EHR, ADT, or facility management systems. Used in slowly changing dimension modeling to track bed configuration changes, designations, or availability windows for historical census and capacity planning analytics.

bed emailbed_eml

The electronic mail address associated with a patient accommodation unit or its responsible contact in hospital information systems. Typically used for automated clinical alert routing, housekeeping notifications, or bed management communications, linking the physical bed entity to a contactable endpoint within facility workflow and notification systems.

bed emergency indicatorbed_emerg_ind

A flag designating that a specific bed is assigned or reserved for emergency admission cases, or that the current bed occupancy originated from an emergency department encounter. Used in inpatient census and capacity management systems to prioritize bed allocation, track emergency throughput, and support regulatory reporting requirements.

bed end datebed_end_dt

The date marking the conclusion of a patient accommodation unit record's active period or assignment in EHR and ADT systems. Used in slowly changing dimension type 2 models to close historical bed configuration records, support occupancy window calculations, and define the boundaries of a patient's stay at a specific bed location.

bed end timebed_end_tm

The exact timestamp recording when a patient's occupancy of a specific inpatient bed concluded, whether due to discharge, transfer, or death. Used in hospital bed management systems to calculate bed availability, measure bed turnover intervals, and support accurate inpatient census and utilization reporting.

bed entered bybed_ent_by

The identifier of the staff member or system process responsible for manually inputting a bed assignment, availability update, or configuration record into the hospital information system. Stored for audit trail purposes to support data governance, error resolution, and accountability tracking within inpatient bed management workflows.

bed ethnicitybed_ethn

The recorded ethnicity of the patient currently assigned to a specific inpatient bed, captured during admission registration. Used in hospital clinical and administrative systems to support demographic reporting, health equity analytics, and compliance with federal and state mandated race and ethnicity data collection standards.

bed expiration datebed_exp_dt

The date after which a patient accommodation unit record, designation, or status is no longer considered valid in EHR or facility management systems. Used in SCD type 2 modeling and ADT configuration audits to flag outdated bed assignments, decommissioned units, or lapsed specialty designations requiring refresh in clinical data pipelines.

bed external identifierbed_ext_id

A reference identifier assigned by an external system, such as an interfacing EHR, regional health information exchange, or third-party bed management platform, used to uniquely identify a bed record across organizational boundaries. Supports interoperability and data reconciliation between internal hospital systems and external healthcare partners.

bed faxbed_fax

The facsimile telephone number associated with a specific nursing unit, care area, or bed location within a hospital facility. Used in hospital directory and communication systems to route clinical documentation, referral orders, and patient transfer paperwork to the correct inpatient unit managing the bed assignment.

bed feebed_fee

The standard charge assessed for inpatient bed accommodation services, representing the room and board component of a hospital bill. Used in hospital chargemaster and revenue cycle systems to establish the base billing rate for overnight bed occupancy, which is then adjusted based on payer contracts and patient insurance plan terms.

bed first namebed_first_nm

The primary label or given name assigned to a specific bed unit within a facility's bed management system. Used to identify individual beds within a room or ward, supporting patient placement, census tracking, and bed board displays in hospital information systems.

bed flagbed_flg

A binary or coded status marker associated with a patient accommodation unit in EHR, ADT, or hospital information systems. Indicates specific conditions such as isolation precautions, equipment availability, out-of-service status, or specialty designation, enabling filtered queries in bed board systems and clinical data warehouse capacity reporting.

bed frequencybed_freq

The rate or interval at which a bed unit is tracked, reported, or cycled through occupancy statuses within facility management workflows. Captures how often bed availability, turnover, or utilization metrics are recorded in hospital capacity management and operational reporting systems.

bed full namebed_full_nm

The complete descriptive name assigned to a bed unit, typically combining ward, room, and bed identifiers into a single human-readable label. Used in hospital information systems for bed board displays, patient assignment workflows, and facility capacity reporting across inpatient settings.

bed genderbed_gndr

The sex-based designation or restriction assigned to a bed unit, indicating whether the bed is allocated for male, female, or mixed-gender patient use. Used in inpatient bed management systems to support appropriate patient placement and comply with same-sex accommodation policies.

bed glucosebed_gluc

A clinical measurement attribute associated with a bed unit, capturing blood glucose monitoring data linked to the bed's current occupant. Used in inpatient clinical data systems to track point-of-care glucose readings by bed location for nursing workflow and clinical documentation purposes.

bed group numberbed_grp_nbr

A numeric identifier that associates a bed unit with a logical grouping within a facility, such as a pod, wing, or care zone. Used in hospital bed management systems to organize beds into operational clusters for staffing assignments, capacity planning, and census reporting workflows.

bed hemoglobinbed_hgb

A clinical measurement attribute linked to a bed unit, recording hemoglobin lab values associated with the patient currently occupying that bed. Used in inpatient clinical data systems to correlate laboratory results with bed location for nursing documentation and clinical decision support workflows.

bed history present illnessbed_hpi

A clinical documentation attribute associated with a bed unit, capturing the narrative description of the current patient's presenting condition and symptom progression. Linked to the occupied bed in inpatient EHR systems to support clinical documentation, handoff communication, and care coordination workflows.

PreviousPage 40 of 320Next