mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 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

The urgent status flag for a patient accommodation unit. Used to track the current state or condition of the bed. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

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 completion time value for a patient accommodation unit. Used to track temporal information related to bed end time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed entered bybed_ent_by

The data entry user for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed ethnicitybed_ethn

The cultural classification for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

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

The external system reference id for a patient accommodation unit. Used as a unique reference to identify and track the bed across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed faxbed_fax

The facsimile number for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed feebed_fee

The service charge for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed first namebed_first_nm

The given name for a patient accommodation unit. Used to display and describe the bed in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

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 dosing schedule for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed full namebed_full_nm

The complete name for a patient accommodation unit. Used to display and describe the bed in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed genderbed_gndr

The sex classification for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed glucosebed_gluc

The blood sugar level for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed group numberbed_grp_nbr

The insurance group identifier for a patient accommodation unit. Used as a unique reference to identify and track the bed across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed hemoglobinbed_hgb

The blood hemoglobin level for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

bed history present illnessbed_hpi

The current condition narrative for a patient accommodation unit. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for bed management and reporting.

PreviousPage 40 of 320Next