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

room minimumrm_min

The minimum occupancy threshold or lower boundary value defined for a specific room within a healthcare facility. Used in bed management and facility operations systems to establish baseline staffing ratios, support census monitoring, and trigger alerts when room utilization falls below operationally required levels.

room mobilerm_mob

The mobile phone number associated with a specific inpatient room or patient care space, used to facilitate direct communication with staff assigned to that room. Supports care coordination and rapid response workflows in hospital facility management systems.

room modified byrm_mod_by

The unique identifier of the user who last updated the room record in the facility management or EHR system. Used for audit trail purposes to track changes to room attributes such as status, assignments, or configuration within inpatient care settings.

room modified daterm_mod_dt

The timestamp recording the most recent update to a patient room's record in an EHR or facility management system. Used by data engineers to track change history, support incremental data loads, and audit room configuration or status modifications over time.

room modified timerm_mod_tm

The exact timestamp recording when a room record was last updated in the facility or clinical information system. Supports audit logging, change tracking, and data governance for inpatient bed and room management workflows across hospital operations.

room namerm_nm

The human-readable label assigned to a patient room within an EHR or hospital facility system, such as a specialty designation or functional title. Used in reporting, patient placement interfaces, and data pipelines to display and identify care spaces alongside room identifiers.

room noterm_nt

Free-text or structured annotation attached to a patient room record in EHR and facility management systems, capturing special instructions, historical context, or operational alerts. Used by data engineers and clinical staff to surface room-specific details in workflows and reports.

room numberrm_nbr

The numeric or alphanumeric reference assigned to a patient room within a healthcare facility, used across EHR, ADT, and billing systems to identify care locations. Critical for linking inpatient encounters, room and board charges, and bed management records.

room onset daterm_onset_dt

The date on which a clinically relevant condition, issue, or status change was first recorded for a specific room or patient care space, such as an infection control flag or equipment failure. Used in facility and clinical operations tracking systems.

room oxygen saturationrm_o2sat

The recorded blood oxygen saturation (SpO2) measurement captured in association with a specific patient room, typically linked to bedside monitoring equipment. Supports clinical documentation of vital signs and continuous patient monitoring in inpatient care settings.

room paid amountrm_pd_amt

The total dollar amount received as payment for room and board charges associated with a specific inpatient room. Used in hospital billing and revenue cycle management to reconcile facility charges against insurance reimbursements and patient payments on claims.

room paid daterm_pd_dt

The date on which payment was received and applied to room and board charges for a specific inpatient room. Used in hospital revenue cycle and billing systems to track payment timelines and reconcile outstanding facility charges against claims adjudication records.

room parentrm_prnt

The superior organizational unit to which a patient room belongs within a facility hierarchy, such as a ward, unit, or floor. Used in EHR and hospital management systems to support hierarchical reporting, cost center rollups, and multi-level facility data modeling.

room percentagerm_pct

A ratio value representing a proportional measure associated with a patient room, such as occupancy rate or cost allocation percentage. Used in hospital operations and claims data systems to calculate utilization metrics, distribute shared costs, and support facility-level analytics.

room periodrm_prd

The defined time span during which a patient room is active, reserved, or assigned within an EHR or facility management system. Used in inpatient billing, occupancy reporting, and ADT workflows to calculate room and board charges and track patient stay durations.

room phonerm_ph

The direct telephone number assigned to a specific patient room within a healthcare facility. Stored in EHR and facility management systems to support patient communication, care coordination, and emergency contact routing tied to a precise physical inpatient location.

room planrm_pln

The documented clinical treatment plan or care strategy recorded in association with a specific inpatient room or patient space. Captures the attending clinician's intended course of action for the patient occupying the room, supporting care coordination and clinical documentation workflows.

room policy numberrm_pol_nbr

The insurance policy number associated with the coverage on file for the patient occupying a specific inpatient room. Used in hospital billing and facility management systems to link room and board charges to the correct payer policy during claims processing and revenue cycle workflows.

room preferred namerm_pref_nm

The preferred or commonly used display name assigned to a specific room or patient care space within a facility, such as a wing designation or named unit. Used in hospital facility management and EHR systems to present room identifiers in a human-readable format for staff and scheduling.

room pricerm_prc

The standard charge or cost assigned to a specific inpatient room or patient care space for a defined period, typically per diem. Used in hospital chargemaster and revenue cycle systems to establish room and board billing rates applied to patient accounts and facility claims submissions.

PreviousPage 213 of 325Next