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 taxonomy codebed_tax_cd

A standardized classification code that categorizes a hospital bed by care type or service level, such as acute care, psychiatric, rehabilitation, or long-term care. Used in facility licensing, regulatory reporting, and inpatient capacity management systems to classify bed inventory.

bed temperaturebed_temp

Records the ambient or monitored temperature associated with a specific patient bed environment, particularly relevant in neonatal ICU, isolation, or specialty care settings. Used in clinical monitoring systems to ensure patient safety and regulatory compliance for environmental standards.

bed termination datebed_term_dt

The date on which a specific hospital bed is decommissioned, taken out of service, or removed from available inventory. Captured in bed management and facility records to maintain accurate licensed bed counts, support regulatory reporting, and track capital asset lifecycles.

bed timebed_tm

Records the specific time of day associated with a bed-related event, such as bed request, assignment, or status change, within ADT and patient flow management systems. Used in EHR platforms to measure throughput metrics, boarding duration, and bed turnover efficiency.

bed timestampbed_ts

Captures the full date and time of a bed-related transaction or status change within ADT, EHR, and hospital census systems. Used by data engineers to build audit trails, calculate length-of-stay intervals, and support patient flow analytics and capacity reporting pipelines.

bed titlebed_ttl

The formal name or descriptive label assigned to a specific hospital bed or bed category within the facility's bed management system, such as 'ICU Bed 4A' or 'Isolation Room 210B'. Used to identify and reference beds consistently across clinical and administrative workflows.

bed totalbed_tot

Represents the aggregate count of bed units within a facility, unit, or ward as tracked by hospital census and capacity management systems. Used in EHR and operational reporting pipelines to monitor licensed, staffed, and available bed totals for regulatory and planning purposes.

bed total countbed_tot_cnt

The aggregate number of beds within a defined scope, such as a nursing unit, facility, or health system. Used in inpatient capacity management, regulatory licensure reporting, and strategic planning to quantify total available, occupied, and staffed bed inventory.

bed typebed_typ

Classifies a hospital bed according to its clinical designation, such as ICU, medical-surgical, telemetry, or psychiatric, within ADT and facility management systems. Used in EHR and claims data to support billing, capacity planning, and care setting identification across inpatient workflows.

bed unitbed_unt

Specifies the clinical unit or ward to which a bed belongs within hospital ADT and census management systems, such as ICU, NICU, or medical-surgical floors. Used in EHR platforms to associate patient encounters with physical care locations for reporting and capacity analytics.

bed updated datebed_upd_dt

The most recent date on which a hospital bed's record was modified in the bed management or hospital information system. Used for audit tracking, data quality monitoring, and ensuring that bed status, attributes, and assignment information reflect current facility conditions.

bed urgencybed_urg

Indicates the priority level or time-sensitivity assigned to filling or preparing a specific hospital bed, such as urgent admission, emergency placement, or routine scheduling. Used in bed management workflows to triage bed requests and coordinate rapid patient placement across inpatient units.

bed valuebed_val

Represents a specific measured or recorded data point associated with a bed entity in hospital ADT or census systems, such as occupancy rate, utilization score, or assignment priority. Used in EHR and operational analytics pipelines to evaluate bed performance and resource allocation.

bed versionbed_ver

Tracks the version number of a hospital bed's record within the bed management system, incrementing with each update or change to bed attributes. Used to maintain data lineage, support audit trails, and ensure that downstream reporting references the most current bed configuration.

bed zipbed_zip

The postal ZIP code of the facility location where a specific hospital bed resides. Used in multi-site health system bed management records to geographically identify bed inventory across different physical locations for reporting, regulatory, and capacity planning purposes.

benefit addressbnft_addr

Stores the physical or mailing address associated with a benefit record, such as a provider location or member correspondence address, within health plan enrollment and claims systems. Used in EHR and payer platforms to route benefit communications and validate provider network service locations.

benefit effective datebnft_eff_dt

The calendar date on which a specific insurance benefit becomes active for an enrolled member. Used in EHR, claims adjudication, and member enrollment systems to validate eligibility, authorize services, and ensure benefit coverage aligns with plan design during claims processing.

benefit scheduled datebnft_sched_dt

The calendar date on which a covered benefit service or item is planned to be rendered. Used in member benefit management to coordinate service delivery timing, track utilization against plan limits, and reconcile scheduled versus actual service dates in claims processing.

benefit scheduled timebnft_sched_tm

The clock time at which a covered benefit service or item is planned to occur. Used alongside the scheduled date in benefit management workflows to coordinate service delivery, manage provider availability, and support appointment-level tracking within health plan utilization systems.

benefit street addressbnft_st_addr

The physical street-level location where a covered benefit service or item is scheduled to be delivered. Used in benefit administration to identify the service site, validate in-network facility usage, and support geographic analysis of benefit utilization across health plan populations.

PreviousPage 45 of 325Next