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 genderrm_gndr

The sex-based designation assigned to a specific room within a healthcare facility, indicating whether it is designated for male, female, or mixed-gender patient occupancy. Used in bed management systems to enforce patient placement policies and support privacy and safety requirements during inpatient assignments.

room glucoserm_gluc

A misapplied attribute label where glucose, a clinical blood sugar measurement, has been incorrectly associated with a physical room entity. This data element likely reflects a data modeling error; glucose values belong to patient clinical records, not facility room definitions within healthcare information systems.

room group numberrm_grp_nbr

A numeric identifier that associates a specific room with a logical grouping within a healthcare facility, such as a wing, pod, unit cluster, or care zone. Used in facility management and bed assignment systems to organize rooms for staffing, reporting, and patient flow operations.

room hemoglobinrm_hgb

A misapplied attribute label where hemoglobin, a clinical blood measurement, has been incorrectly associated with a physical room entity. This data element likely reflects a data modeling error; hemoglobin values belong to patient laboratory records, not facility room definitions within healthcare information systems.

room history present illnessrm_hpi

A misapplied attribute label where history of present illness, a clinical documentation component describing a patient's current condition, has been incorrectly associated with a physical room entity. This likely reflects a data modeling error; HPI data belongs to patient clinical encounter records, not room definitions.

room identifierrm_id

The unique alphanumeric key assigned to a specific patient room within a healthcare facility's EHR or bed management system. Used to link patient encounters, billing records, and facility data to a precise physical care location across inpatient data pipelines.

room indexrm_idx

A numeric position or sequence value assigned to a patient room within a facility's ordered data structure. Used in EHR and hospital operations systems to support sorting, navigation, and relational joins when processing room-level inpatient and census data.

room indicatorrm_ind

A boolean or coded value in EHR and facility management systems denoting the current operational status of a patient room, such as occupied, vacant, or on hold. Essential for real-time bed management, ADT processing, and inpatient capacity planning workflows.

room instructionrm_instr

Structured guidance text associated with a patient room in EHR and hospital facility systems, detailing care protocols, access restrictions, or equipment requirements. Used by clinical staff and data engineers to enforce room-specific rules in patient placement logic.

room keyrm_key

The primary surrogate or natural key value that uniquely identifies a specific room record within a healthcare facility's data system. Used as the core reference identifier in bed management, patient placement, and facility operations databases to link room attributes across related tables and systems.

room languagerm_lang

A misapplied attribute label where language preference, a patient or provider communication attribute, has been incorrectly associated with a physical room entity. This likely reflects a data modeling error; language designations belong to patient demographic or provider records, not room definitions in facility systems.

room last namerm_last_nm

A secondary label or suffix component assigned to a specific room within a healthcare facility for identification purposes. Used in bed management and facility operations systems to display or sort room designations, potentially representing a named room suffix such as a wing designation or unit identifier.

room legal namerm_legal_nm

The officially registered or formally designated name for a specific room or suite within a healthcare facility, as recorded in licensing, accreditation, or facility documentation. Used in compliance reporting and regulatory submissions where rooms must be referenced by their formally recognized designations.

room levelrm_lvl

The hierarchical position of a patient room within a facility's organizational structure, such as floor, wing, or unit level. Used in EHR and hospital management systems to support multi-level reporting, cost center allocation, and facility-based data aggregation.

room license numberrm_lic_nbr

The regulatory license or certification identifier assigned to a specific room or suite within a healthcare facility by a state or accrediting body. Applicable to specialized rooms such as operating suites, procedure rooms, or isolation units that require individual licensure under facility regulations.

room marital statusrm_mar_sts

A misapplied attribute label where marital status, a patient demographic attribute, has been incorrectly associated with a physical room entity. This likely reflects a data modeling error; marital status belongs to patient enrollment or demographic records, not room definitions within healthcare facility management systems.

room master identifierrm_mstr_id

The enterprise-level master identifier that uniquely distinguishes a specific room across all integrated systems within a healthcare organization. Used in facility management and patient placement platforms to maintain consistent room identification when data is shared across multiple EHR, ADT, and bed management systems.

room maximumrm_max

The maximum occupancy capacity or upper threshold value defined for a specific room within a healthcare facility. Used in bed management and facility operations systems to enforce patient placement limits, support census reporting, and ensure compliance with safety and regulatory capacity requirements.

room medical record numberrm_mrn

A misapplied attribute label where medical record number, a patient-specific identifier, has been incorrectly associated with a physical room entity. This likely reflects a data modeling error; MRN values belong to individual patient records and should not be stored as attributes of room definitions in facility systems.

room middle namerm_mid_nm

A secondary name component or intermediate label segment assigned to a specific room within a healthcare facility. Used in bed management or facility systems where room naming conventions include multi-part designations, such as combining building, unit, and room identifiers into a structured naming hierarchy.

PreviousPage 212 of 325Next