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

bed master identifierbed_mstr_id

The enterprise-level master identifier assigned to a bed unit, enabling consistent cross-system identification across the facility's EHR, bed management, and data warehouse platforms. Used to uniquely resolve and match bed records across disparate healthcare information systems within a health network.

bed maximumbed_max

The upper threshold or capacity limit defined for a bed unit or bed group within a facility management system. Used in hospital capacity planning and operational reporting to set ceiling values for occupancy thresholds, staffing ratios, or patient load metrics associated with individual beds or care units.

bed medical record numberbed_mrn

The medical record number of the patient currently assigned to a specific bed unit, linking the physical accommodation to the patient's longitudinal health record. Used in inpatient facility systems to associate clinical documentation, orders, and care activities with the correct patient by bed location.

bed middle namebed_mid_nm

The middle name or initial component associated with a name string linked to a bed unit record in a facility management system. Typically carried from the assigned patient's identity record to support accurate patient identification, duplicate resolution, and census documentation in inpatient hospital settings.

bed minimumbed_min

The lower threshold or floor value defined for a bed unit or bed group within a facility management system. Used in hospital capacity planning and operational analytics to establish minimum occupancy requirements, staffing thresholds, or patient load baselines associated with individual beds or inpatient care units.

bed mobilebed_mob

The mobile or cellular contact number associated with a bed unit's current patient occupant, captured during inpatient admission or registration. Used in hospital information systems to support patient communication, discharge coordination, and follow-up scheduling workflows tied to the bed assignment during the inpatient stay.

bed modified bybed_mod_by

Identifies the user or system that last updated a bed record in the hospital bed management system. Captures the username or ID of the clinician, administrator, or automated process responsible for the most recent change to bed assignment, status, or occupancy data.

bed modified datebed_mod_dt

The timestamp of the most recent update to a patient accommodation unit record in EHR or hospital information systems. Used in ETL incremental load strategies, audit logging, and change data capture processes to identify records requiring refresh in clinical data warehouses, ensuring bed configuration and assignment data remains current across downstream analytics systems.

bed modified timebed_mod_tm

Records the exact timestamp when a bed record was last updated in the hospital bed management system. Used to maintain an audit trail of bed status changes, occupancy updates, or assignment modifications, supporting real-time census tracking and downstream reporting.

bed namebed_nm

The human-readable display label assigned to a specific patient accommodation unit within hospital facility management systems. Used in ADT (Admission, Discharge, Transfer) workflows across EHR platforms such as Epic and Cerner to uniquely identify beds within a room, unit, or ward for clinical and operational reporting.

bed notebed_nt

Free-text annotation associated with a specific patient accommodation unit, capturing operational or clinical context such as maintenance status, isolation requirements, or special equipment needs. Stored in EHR and bed management systems like Epic OpTime or Cerner Bed Management to support nursing and facilities workflows.

bed numberbed_nbr

The numeric or alphanumeric identifier assigned to a patient accommodation unit within a room or ward in hospital facility management and ADT systems. Used in EHR platforms including Epic and Cerner to reference specific beds during patient placement, census reporting, and occupancy tracking across inpatient units.

bed onset datebed_onset_dt

Captures the date a patient was first assigned to or began occupying a specific hospital bed. Used in inpatient census tracking to calculate length of stay at the bed level, supporting capacity planning, utilization reporting, and clinical documentation workflows.

bed oxygen saturationbed_o2sat

Records the peripheral blood oxygen saturation (SpO2) measurement captured at or associated with a patient's assigned hospital bed. Used in inpatient clinical monitoring to track respiratory status, support early warning scoring, and document vital sign trends during a patient's stay.

bed paid amountbed_pd_amt

Represents the dollar amount paid for inpatient accommodation charges associated with a specific bed assignment. Used in hospital billing and revenue cycle management to reconcile room and board payments against billed accommodation charges on inpatient claims or facility invoices.

bed paid datebed_pd_dt

Records the date on which payment was received or posted for inpatient accommodation charges tied to a specific bed assignment. Used in hospital revenue cycle management to track payment timelines, reconcile accounts receivable, and monitor reimbursement against billed room and board charges.

bed parentbed_prnt

The hierarchical superior entity — such as a room, ward, unit, or facility — to which a patient accommodation unit belongs within hospital bed management systems. Used in EHR and facility management platforms to establish location hierarchies for ADT processing, census aggregation, and capacity planning workflows.

bed percentagebed_pct

A ratio value representing occupancy, utilization, or capacity metrics for a patient accommodation unit or group of beds within hospital operations systems. Commonly calculated in analytics and reporting layers using ADT and census data from EHR platforms to support bed management efficiency and capacity planning decisions.

bed periodbed_prd

The defined time span during which a patient accommodation unit is assigned, occupied, reserved, or unavailable within hospital bed management and ADT systems. Used in EHR platforms such as Epic and Cerner to track bed lifecycle intervals, support occupancy reporting, and calculate length-of-stay metrics for inpatient encounters.

bed phonebed_ph

The telephone number associated with a specific patient accommodation unit within a hospital facility, stored in EHR and facility management systems to enable direct communication between clinical staff, patients, and families. Used in ADT and patient directory systems to route calls accurately across inpatient units and care settings.

PreviousPage 42 of 325Next