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 adjustment amountrm_adj_amt

The dollar value of a financial adjustment applied to room and board charges on a patient account, such as contractual write-offs, billing corrections, or payer-negotiated rate reductions. Used in hospital revenue cycle management to reconcile billed charges against actual reimbursement amounts.

room agerm_age

The elapsed time since a hospital room was last renovated, commissioned, or placed into service. Used in facility management and capital planning systems to assess infrastructure age, prioritize maintenance schedules, and support compliance with healthcare facility safety and accreditation standards.

room allowed amountrm_alwd_amt

The maximum dollar amount a payer will reimburse for room and board charges during an inpatient stay, based on contractual fee schedules or benefit plan limits. Used in claims adjudication to determine the payer's payment obligation and calculate patient cost-sharing responsibilities.

room amountrm_amt

Monetary value associated with a physical patient room or care space, typically representing the charge rate for room and board in hospital billing, claims, and revenue cycle systems. Data engineers use this field to validate UB-04 revenue code line items, reconcile room charges against contracted rates, and support inpatient cost analysis workflows.

room approval statusrm_appr_sts

The authorization state of a room assignment or room-related service request, indicating whether it has been approved, pending review, or denied by clinical or administrative staff. Used in bed management and utilization review workflows to ensure appropriate inpatient placement and resource allocation.

room approved byrm_appr_by

The name or identifier of the clinical or administrative staff member who authorized a room assignment, room-related service, or associated charge. Used in audit trails and approval workflows within hospital information systems to maintain accountability for inpatient bed placement and facility resource decisions.

room arrival timerm_arrv_tm

The recorded timestamp indicating when a patient physically arrived in or was transferred to a specific hospital room. Used in bed management, nursing workflows, and patient flow analytics to measure throughput efficiency, boarding time, and compliance with admission turnaround benchmarks.

room arrived daterm_arrv_dt

The calendar date on which a patient was admitted to or transferred into a specific hospital room during an inpatient or observation stay. Used in facility management and clinical documentation systems to establish room occupancy timelines, calculate length of stay, and support billing accuracy.

room assessmentrm_asmt

A clinical or environmental evaluation associated with a patient's room assignment, capturing infection control status, equipment readiness, or safety checks required prior to patient placement. Used in nursing workflows and facility management systems to ensure rooms meet clinical standards before and during patient occupancy.

room balancerm_bal

Outstanding financial amount remaining on a patient room or care space charge after payments and adjustments in hospital revenue cycle and billing systems. Data engineers use this field to monitor accounts receivable aging, identify underpaid room and board claims, and support financial reconciliation processes in inpatient billing data pipelines.

room billed amountrm_bill_amt

The total dollar amount charged to a patient or payer for room and board services during an inpatient stay before any adjustments, contractual write-offs, or payments are applied. Used in hospital revenue cycle systems as the gross charge basis for claims submission and accounts receivable tracking.

room birth daterm_birth_dt

Date of birth associated with a room entity record in hospital facility or bed management systems, potentially representing the room's initial activation or commissioning date. Data engineers use this field to calculate room age, track facility lifecycle events, and support capital planning analytics within healthcare facility management data systems.

room blood pressurerm_bp

The blood pressure measurement recorded for a patient at the time of or during their occupancy in a specific hospital room. Used in inpatient clinical documentation to monitor hemodynamic status, track vital sign trends, and support nursing assessments and physician decision-making during the stay.

room cancelled daterm_cncl_dt

The date on which a room reservation, assignment, or associated service request was cancelled prior to or during a patient encounter. Used in bed management and scheduling systems to track occupancy changes, free capacity for other patients, and reconcile room-based billing when admissions are voided.

room categoryrm_cat

Grouping classification identifying the functional type of a patient care space, such as ICU, step-down, medical-surgical, or isolation, in EHR, ADT, and bed management systems. Data engineers use this field to segment census data, calculate category-specific occupancy rates, and support staffing ratio analytics across inpatient facility reporting pipelines.

room charge amountrm_chrg_amt

The standard daily or per-service dollar amount charged for occupying a specific hospital room, reflecting room type, level of care, and facility fee schedules. Used in hospital billing systems to generate room and board line items on patient accounts and inpatient claims submitted to payers.

room chief complaintrm_cc

The primary symptom or reason for care documented at the time a patient is assigned to a hospital room, reflecting the initial clinical concern driving the inpatient or observation admission. Used in clinical documentation to establish the basis for the encounter and guide room-level care planning.

room childrm_chld

Subordinate relationship identifier linking a patient room record to a parent room, ward, or unit entity within hierarchical facility management and ADT systems. Data engineers use this field to traverse facility hierarchy structures, aggregate occupancy and charge data by parent unit, and maintain referential integrity across hospital bed management data models.

room cityrm_city

The city in which a hospital room's parent facility is located. Used in facility master data, provider directories, and geographic reporting to identify the physical location of inpatient services, support network adequacy analysis, and associate room-level care data with the correct facility address record.

room classrm_cls

Classification tier designating the service level or amenity level of a patient care space, such as private, semi-private, or ward, in EHR, billing, and bed management systems. Data engineers use this field to apply correct revenue codes in UB-04 claim generation, validate payer-specific room benefit limits, and support inpatient charge master analytics.

PreviousPage 209 of 325Next