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 dea numberbed_dea_nbr

The Drug Enforcement Administration registration number linked to a bed record, typically associated with controlled substance administration protocols at a specific care unit or bed location. Used in inpatient pharmacy and compliance systems to track prescribing authority and controlled medication dispensing by bed assignment.

bed death datebed_death_dt

The recorded date of patient death associated with a specific accommodation unit in EHR and ADT systems. Used in mortality reporting, clinical outcomes analysis, and facility-level death event tracking, linking the physical bed location to vital status changes for infection control, compliance, and quality improvement workflows.

bed deductible amountbed_ded_amt

The portion of inpatient bed accommodation charges applied toward a patient's annual insurance deductible before plan coverage activates. Captured in hospital billing and claims adjudication systems to accurately calculate patient financial responsibility for room and board during an inpatient admission episode.

bed deleted datebed_del_dt

The calendar date on which a bed record was logically removed or decommissioned from the active bed inventory within a hospital information system. Used in bed management and capacity planning to maintain historical records of bed availability changes while preserving data integrity for retrospective reporting.

bed deleted indicatorbed_del_ind

A boolean flag that marks a bed record as logically removed from active inventory in the hospital information system without physically purging the data. Enables soft-delete functionality so decommissioned or retired bed records are excluded from operational census counts while remaining accessible for historical audit and reporting.

bed descriptionbed_desc

The free-text or standardized textual label providing human-readable details about a patient accommodation unit in EHR and hospital information systems. Typically includes bed type, specialty designation, or physical characteristics, supporting clinical staff workflows, bed board displays, and facility configuration management in ADT systems.

bed detailbed_dtl

Granular attribute information associated with a patient accommodation unit in hospital information or ADT systems. May include physical specifications, equipment capabilities, isolation status, or care level designations used by data engineers to populate bed management tables and support clinical decision support and staffing optimization queries.

bed due datebed_due_dt

The date by which a payment obligation related to inpatient bed accommodation charges is expected to be received, either from the patient or their insurer. Used in hospital accounts receivable and revenue cycle management systems to track outstanding balances and trigger follow-up billing actions.

bed durationbed_dur

The total length of time a patient occupies or is assigned to a specific inpatient bed, measured from admission or assignment start to discharge or transfer. Used in hospital bed management and utilization reporting to analyze length-of-stay patterns, optimize bed turnover, and support capacity planning decisions.

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.

PreviousPage 40 of 325Next