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 descriptionflr_desc

A human-readable text label describing a specific hospital floor or nursing unit, such as its clinical specialty, physical location, or functional designation. Used in facility management systems and inpatient reporting to identify and distinguish units like medical-surgical, telemetry, or intensive care floors.

floor detailflr_dtl

Granular information associated with a specific hospital floor or nursing unit record, capturing supplementary attributes beyond standard identifiers. Used in inpatient facility management systems to document unit-specific characteristics such as bed configuration, staffing model, or clinical service line designation.

floor due dateflr_due_dt

The deadline date associated with a payment obligation, task, or administrative action tied to a hospital floor or inpatient unit. Used in healthcare billing, facility management, or compliance workflows to track time-sensitive financial or operational requirements at the unit level.

floor durationflr_dur

The length of time a patient remained assigned to a specific hospital floor or nursing unit during an inpatient encounter. Used in utilization management and capacity planning to measure unit-level occupancy patterns, inform staffing decisions, and support length-of-stay benchmarking across inpatient care settings.

floor effective dateflr_eff_dt

The date on which a hospital floor or nursing unit record becomes operationally active within the facility management system. Used to define the start of a unit's valid period for patient assignment, billing, and reporting, supporting accurate tracking of unit availability and configuration changes over time.

floor emailflr_eml

The electronic mail address associated with a hospital floor or nursing unit, used for administrative communication and coordination. Stored in facility management systems to facilitate contact with unit staff, charge nurses, or unit coordinators for operational, scheduling, or clinical communication purposes.

floor emergency indicatorflr_emerg_ind

A flag designating whether a hospital floor or nursing unit is classified or activated for emergency-level patient care. Used in facility management and inpatient systems to identify units handling urgent or emergent admissions, supporting triage workflows, resource allocation, and emergency capacity reporting.

floor end dateflr_end_dt

The date on which a patient's assignment to a specific hospital floor or nursing unit concluded, or the date a unit's active operational period expired. Used in inpatient encounter records and facility management systems to define unit-level stay boundaries and support discharge and transfer reporting.

floor end timeflr_end_tm

The time at which a patient's stay on a specific hospital floor or nursing unit ended, or when a unit-level activity was completed. Used alongside floor end date in inpatient records to precisely capture unit departure timestamps, supporting transfer tracking, bed management, and capacity utilization analysis.

floor entered byflr_ent_by

The identifier of the user or system that initially entered or created a hospital floor or nursing unit record in the facility management system. Used in audit logging and data governance to establish accountability for record creation, supporting compliance reviews and data quality management for inpatient unit data.

floor ethnicityflr_ethn

Records the predominant ethnic population or cultural designation associated with a specific hospital floor unit, supporting demographic analysis, culturally competent care planning, and compliance reporting within inpatient facility management systems.

floor expiration dateflr_exp_dt

The date on which a hospital floor unit's operational designation, certification, or configuration record becomes invalid. Used in facility management systems to track the active period of a floor's defined attributes, staffing model, or service line classification.

floor external identifierflr_ext_id

A reference code assigned to a hospital floor unit by an external system, such as a facility management platform, accreditation body, or health information exchange. Enables cross-system reconciliation and interoperability when sharing floor-level operational data.

floor faxflr_fax

The facsimile telephone number associated with a specific hospital floor unit. Used in facility directories and clinical communication workflows to route medical records, orders, and correspondence directly to the correct inpatient unit within the facility.

floor feeflr_fee

The service charge or cost associated with a hospital floor unit's operations, such as a per-diem room rate or unit-level service fee. Used in hospital billing, cost accounting, and revenue cycle management to attribute charges to specific inpatient floor designations.

floor first nameflr_first_nm

The primary or informal given name used to identify a hospital floor unit in clinical and operational workflows. May represent a commonly used shorthand name for the unit, distinct from the full official floor designation stored in facility management systems.

floor flagflr_flg

A binary indicator used to mark a specific status or condition for a hospital floor unit, such as whether the floor is currently active, under renovation, on diversion, or subject to an infection control alert within facility management systems.

floor frequencyflr_freq

Indicates how often a specific activity, assessment, or operational process is scheduled to occur on a hospital floor unit, such as rounding intervals, cleaning cycles, or safety checks. Used in inpatient facility operations and clinical workflow scheduling systems.

floor full nameflr_full_nm

The complete official name of a hospital floor unit as recorded in facility management and health information systems. Used for display in clinical documentation, patient communications, staff assignments, and regulatory reporting to uniquely identify the inpatient unit.

floor genderflr_gndr

Indicates the gender designation or patient population classification of a hospital floor unit, such as a gender-specific unit or mixed-gender ward. Supports facility management, patient placement decisions, and compliance tracking within inpatient operational systems.

PreviousPage 107 of 325Next