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 approved bybed_appr_by

The identifier or name of the user, clinician, or administrator who authorized a specific bed assignment, bed request, or bed-related workflow action. Used in audit trails and bed management systems to maintain accountability for occupancy decisions within inpatient and care transition workflows.

bed arrival timebed_arrv_tm

The recorded timestamp indicating when a patient physically arrived at or was placed in a specific hospital bed. Used in bed management and patient flow systems to measure throughput, calculate bed turnaround intervals, and support operational efficiency reporting for inpatient units.

bed arrived datebed_arrv_dt

The calendar date on which a patient was placed in or arrived at a specific inpatient bed assignment. Used in bed management, patient flow analysis, and length-of-stay reporting to establish the start of occupancy for a given bed within the hospital's census tracking system.

bed assessmentbed_asmt

The clinical evaluation or structured assessment documented in association with a patient's specific bed assignment, such as a skin integrity check, fall risk evaluation, or safety assessment. Supports nursing documentation workflows and regulatory compliance for inpatient care quality monitoring.

bed balancebed_bal

The outstanding monetary amount remaining on a patient bed or accommodation charge after payments, adjustments, and contractual write-offs have been applied within hospital billing and accounts receivable systems. Data engineers reference this field in aging reports, denial management workflows, and revenue cycle dashboards to monitor unpaid facility balances.

bed billed amountbed_bill_amt

The total dollar amount charged by a facility for a patient's inpatient bed accommodation before payer adjustments or patient cost-sharing are applied. Represents the gross accommodation charge submitted on an institutional claim for room and board services rendered during an inpatient stay.

bed birth datebed_birth_dt

A date field within patient accommodation or ADT records that associates a date of birth value with a specific bed assignment, typically used to validate patient identity during bed placement or to support age-based clinical and billing rules in EHR and facility management systems. Used by data engineers for patient matching and demographic validation.

bed blood pressurebed_bp

The arterial blood pressure reading recorded for a patient at the time of or during their assignment to a specific inpatient bed. Captured as part of bedside vital sign documentation within the clinical record to support patient monitoring, triage prioritization, and nursing assessment workflows.

bed cancelled datebed_cncl_dt

The calendar date on which a scheduled bed assignment, bed reservation, or bed request was cancelled within the facility's bed management system. Used to track cancellation patterns, measure bed utilization efficiency, and support operational reporting on capacity planning and patient flow.

bed categorybed_cat

A classification field designating the type or functional grouping of a patient bed, such as medical-surgical, intensive care, or observation, within facility management and ADT systems. Data engineers use this field to segment census data, calculate occupancy metrics by care level, and support capacity planning and payer-specific billing rule applications.

bed charge amountbed_chrg_amt

The dollar amount charged for a patient's room and board accommodation for a specific bed during an inpatient stay. Represents the daily or total accommodation charge posted to the patient account before payer contractual adjustments, reflecting the facility's standard rate for that bed type.

bed chief complaintbed_cc

The primary symptom or clinical concern reported by or on behalf of a patient at the time they were assigned to a specific inpatient bed. Documented in the clinical record to support triage, nursing assessment, and care planning workflows associated with the patient's bed-level encounter.

bed childbed_chld

A hierarchical relationship field in facility management or ADT systems that identifies a subordinate bed record linked to a parent unit or room, enabling structured representation of nested bed configurations. Data engineers use this parent-child relationship to build bed hierarchy models supporting census reporting, capacity analytics, and facility layout data governance.

bed citybed_city

The city or municipality in which the hospital bed's facility or unit is located. Used in facility master data and administrative systems to support geographic reporting, regulatory filings, and multi-site health system management where bed inventory spans multiple physical locations.

bed classbed_cls

A tiered classification field distinguishing patient beds by care intensity or service level, such as acute, sub-acute, or skilled nursing, within hospital ADT and billing systems. Data engineers use bed class to apply appropriate billing rules, validate payer-specific accommodation codes, and segment inpatient utilization reporting by clinical care classification.

bed codebed_cd

A standardized alphanumeric code uniquely identifying a specific bed or accommodation type within facility management, ADT, and hospital billing systems. Data engineers use bed codes to join patient placement records with charge master entries, validate accommodation billing on UB-04 claims, and maintain referential integrity across inpatient and revenue cycle data pipelines.

bed coinsurance amountbed_coins_amt

The portion of inpatient bed accommodation charges that a patient is responsible for paying as coinsurance under their health plan benefit design. Calculated during claims adjudication by applying the member's coinsurance percentage to the allowed accommodation charge after deductible obligations are met.

bed commentbed_cmt

A free-text annotation field attached to a bed or accommodation record in EHR, ADT, or facility management systems, capturing operational notes such as maintenance status, isolation requirements, or special equipment needs. Data engineers must handle this unstructured field carefully during ETL processing, as it may contain clinically relevant or PII-adjacent information.

bed completed datebed_cmpl_dt

The calendar date on which a patient's inpatient bed assignment was formally completed or closed, typically corresponding to discharge, transfer, or bed release. Used in bed management and revenue cycle systems to calculate length of stay, close billing periods, and update real-time census records.

bed confidential indicatorbed_conf_ind

Flag indicating whether a specific hospital bed assignment or occupancy record is restricted from general staff viewing due to patient privacy requirements, such as VIP status, sensitive diagnosis, or legal protection under confidentiality policies within inpatient census management systems.

PreviousPage 38 of 320Next