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

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.

bed planbed_pln

Documents the clinical care plan or treatment strategy associated with a patient's inpatient bed assignment. Captures planned interventions, discharge goals, or nursing care instructions linked to a specific bed location, supporting coordinated care delivery and interdisciplinary communication during hospitalization.

bed policy numberbed_pol_nbr

Stores the insurance policy number associated with coverage for a patient's inpatient bed accommodation. Used in hospital billing workflows to link room and board charges to the correct health plan policy, ensuring accurate claim submission and payer adjudication for inpatient stays.

bed preferred namebed_pref_nm

Stores the preferred or display name assigned to a hospital bed within the bed management system. Used to identify beds by a human-readable label such as a unit designation or room alias, supporting clear communication in census boards, nursing assignments, and facility reporting workflows.

bed pricebed_prc

Represents the standard charge or rate assigned to a hospital bed for a given accommodation category, such as medical-surgical, ICU, or telemetry. Used in hospital charge description master (CDM) management and inpatient billing to calculate room and board charges applied to a patient's account.

bed primary indicatorbed_prim_ind

A flag designating whether a hospital bed is the primary or principal accommodation assigned to a patient during an inpatient encounter. Used in census management and billing systems to distinguish the main bed from secondary or overflow assignments when a patient occupies multiple bed locations during a stay.

bed prioritybed_prty

A ranking value that determines the order or urgency with which a patient accommodation unit is assigned during bed placement workflows in hospital bed management systems. Used in EHR platforms such as Epic Bed Management to prioritize bed assignments based on patient acuity, unit type, isolation requirements, or operational rules.

bed pulsebed_pulse

Records the pulse rate in beats per minute measured at or associated with a patient's assigned hospital bed. Captured as part of routine vital sign documentation in inpatient clinical systems, used to monitor cardiovascular status and support early warning scoring and clinical decision-making during a patient's stay.

bed quantitybed_qty

The total count of patient accommodation units available, occupied, or reserved within a facility, unit, or ward as tracked in hospital capacity management systems. Used in EHR and analytics platforms to support census reporting, staffing calculations, regulatory compliance submissions, and capacity planning for inpatient and observation settings.

bed racebed_race

Records the self-reported racial identification of the patient occupying a hospital bed. Captured during inpatient registration and linked to the bed assignment record to support health equity reporting, demographic analysis of inpatient populations, and compliance with federal and accreditation data collection requirements.

PreviousPage 42 of 320Next