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

floor glucoseflr_gluc

Records a minimum or threshold glucose measurement value associated with clinical protocols on a specific hospital floor unit. Used in inpatient clinical management systems to define unit-level glycemic monitoring parameters or alert thresholds for patient care workflows.

floor group numberflr_grp_nbr

A grouping identifier that associates a hospital floor unit with a defined cluster of units sharing common attributes, such as a service line, cost center, or administrative division. Used in facility management reporting and inpatient operational analytics systems.

floor hemoglobinflr_hgb

Records a minimum or threshold hemoglobin measurement value associated with clinical protocols on a specific hospital floor unit. Used in inpatient clinical management systems to define unit-level transfusion triggers or hematology monitoring parameters for patient care workflows.

floor history present illnessflr_hpi

A narrative field capturing the history of present illness documentation standards or clinical assessment requirements associated with a specific hospital floor unit. Used to define unit-level documentation expectations within inpatient clinical workflow and EHR configuration systems.

floor identifierflr_id

The unique system-generated or assigned value that distinctly identifies a hospital floor unit within facility management and clinical information systems. Serves as the primary key for linking floor-level records across inpatient operational, billing, and reporting databases.

floor indexflr_idx

A numeric position or ranking value assigned to a hospital floor unit within a structured list or hierarchy of units in a facility. Used in facility management systems to control display order, sequencing, and navigation across inpatient floor designations.

floor indicatorflr_ind

A boolean or coded value that signals a specific operational, clinical, or administrative condition for a hospital floor unit, such as isolation status, capacity constraints, or accreditation flags. Used in facility management and inpatient workflow systems to drive conditional logic.

floor instructionflr_instr

Descriptive guidance text associated with a hospital floor unit, providing operational, clinical, or administrative directions relevant to that unit. Used in facility management and EHR systems to communicate unit-specific protocols, visitor policies, or care delivery requirements to staff.

floor keyflr_key

A lookup or reference value used to retrieve hospital floor unit records from facility management databases. Functions as a join key across inpatient operational tables, linking floor-level attributes to patient assignments, staffing records, and unit-specific configuration data.

floor languageflr_lang

The primary or preferred communication language associated with a hospital floor unit, reflecting the dominant linguistic needs of its patient population. Used to support language-appropriate care delivery, staff assignments, and interpreter service planning within inpatient facility systems.

floor last nameflr_last_nm

The surname component of a named hospital floor unit within a facility's physical layout. Used in hospital information systems to identify and label nursing units or care floors by a person's name, such as a donor or founder, supporting wayfinding and census reporting.

floor legal nameflr_legal_nm

The officially registered name assigned to a specific hospital floor or nursing unit, as documented in facility records. Used in hospital administration systems to ensure consistent identification of care units across scheduling, staffing, and patient placement workflows.

floor levelflr_lvl

The numeric or alphanumeric designation indicating a floor's position within a hospital facility's vertical structure. Used in inpatient census systems and bed management platforms to organize units by physical location, supporting patient placement, transport, and facility navigation workflows.

floor license numberflr_lic_nbr

The regulatory license identifier assigned to a specific hospital floor or care unit by a state or accrediting body. Used to track compliance and operational authorization for specialized units such as ICUs or psychiatric floors within facility management and regulatory reporting systems.

floor marital statusflr_mar_sts

A data attribute erroneously mapped to a hospital floor entity, likely reflecting a data model template misapplication. In correct context, marital status is a patient demographic field captured during registration and used in member enrollment, eligibility, and coordination of benefits processing.

floor master identifierflr_mstr_id

The enterprise-wide unique identifier assigned to a specific hospital floor or nursing unit within a master facility registry. Used across hospital information systems, bed management platforms, and clinical data warehouses to consistently reference and track a floor unit without ambiguity.

floor maximumflr_max

The upper capacity threshold defined for a hospital floor, such as maximum licensed bed count or maximum patient census allowed. Used in bed management and capacity planning systems to enforce occupancy limits and trigger escalation workflows during high-census or surge conditions.

floor medical record numberflr_mrn

A data attribute erroneously mapped to a hospital floor entity, likely due to template misapplication. In correct context, a medical record number is the unique patient identifier assigned at registration and used across inpatient, outpatient, and ancillary systems to link clinical documentation to an individual patient.

floor middle nameflr_mid_nm

The middle name component of a hospital floor unit named after an individual, such as a benefactor or historical figure. Used in facility administration and wayfinding systems to store the complete formal name of a named care unit for display and documentation purposes.

floor minimumflr_min

The lower threshold value defined for a hospital floor, such as minimum staffing ratio or minimum occupied beds before a unit is activated. Used in capacity management and staffing systems to enforce operational baselines and support resource allocation decisions across the facility.

PreviousPage 108 of 325Next