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 scoreflr_scr

Calculated numeric rating derived from a clinical assessment tool applied during a patient's hospital floor stay, such as a pain scale, acuity score, or early warning score. Used in inpatient documentation to standardize clinical evaluation, monitor patient status trends, and guide escalation or intervention decisions.

floor sequenceflr_seq

Numeric ordering value that defines the position or rank of a clinical event, record, or entry within a series of floor-level data during a hospital inpatient stay. Used in inpatient data systems to maintain chronological order, support data processing logic, and ensure accurate display of sequential clinical information.

floor service dateflr_svc_dt

Date on which a specific clinical service, treatment, or care activity was delivered to a patient on a hospital inpatient floor unit. Used in inpatient billing, clinical documentation, and quality reporting to accurately timestamp care delivery events and support revenue cycle processing.

floor severityflr_sev

Coded or rated level of seriousness assigned to a patient's condition or clinical finding during a hospital floor stay. Used in inpatient documentation and coding workflows to capture disease complexity, support DRG assignment, inform clinical decision-making, and contribute to case mix and quality reporting.

floor sexflr_sex

Biological sex classification recorded for a patient in the context of their hospital inpatient floor stay data. Used in clinical documentation, inpatient reporting, and quality metrics to support sex-specific clinical protocols, ensure accurate patient identification, and enable demographic stratification in outcomes analysis.

floor sourceflr_src

Origin reference identifying the system, department, or data feed from which a floor-level clinical record or data element was generated or received. Used in inpatient data management to support data lineage tracking, reconciliation across clinical systems, and audit of information captured during a hospital floor stay.

floor start dateflr_start_dt

Date on which a patient was assigned to or began receiving care on a specific hospital inpatient floor unit. Used in inpatient bed management, clinical documentation, and length-of-stay analysis to establish the beginning of a floor-level stay segment within a broader hospital admission episode.

floor start timeflr_start_tm

Time of day at which a patient's care or assignment on a hospital inpatient floor unit began. Used alongside the floor start date in inpatient data systems to precisely timestamp the initiation of floor-level care, support staffing calculations, and enable accurate duration tracking within the admission episode.

floor stateflr_st

State or province associated with the hospital inpatient floor unit where care was delivered, typically tied to the facility's geographic location. Used in inpatient data systems for regulatory reporting, licensure compliance, geographic analysis of care delivery, and alignment with state-specific billing and quality reporting requirements.

floor statusflr_sts

Current operational or clinical state of a patient's hospital floor assignment, such as active, transferred, pending discharge, or closed. Used in inpatient bed management and clinical data systems to track real-time floor occupancy, support patient flow decisions, and maintain accurate records of floor-level care status throughout the admission.

floor street addressflr_st_addr

Records the physical street address associated with a specific hospital floor or nursing unit, used in facility management and patient routing systems. Supports accurate documentation of inpatient care locations within multi-building or multi-campus hospital environments.

floor strengthflr_str

Captures the concentration or dosage strength of a medication stocked or administered at the hospital floor level, such as a nursing unit medication room. Used in pharmacy dispensing systems and medication administration records to ensure accurate floor-level drug inventory and patient safety.

floor subtotalflr_subtot

Represents an intermediate or partial sum of charges, services, or resource utilization aggregated at the hospital floor or nursing unit level before final billing consolidation. Used in inpatient cost accounting and revenue cycle systems to support departmental financial reporting.

floor system identifierflr_sys_id

A system-generated unique identifier assigned to a specific hospital floor or nursing unit, enabling consistent tracking and reference across clinical, administrative, and billing systems. Used to link patient records, staffing assignments, and resource data to the correct inpatient care location.

floor targetflr_tgt

Identifies the designated destination floor or nursing unit for a patient transfer, admission, or care transition within a hospital facility. Used in bed management and patient flow systems to coordinate capacity planning and ensure timely placement of patients in appropriate inpatient care settings.

floor taxonomy codeflr_tax_cd

Stores the standardized taxonomy classification code associated with the clinical specialty or service type delivered on a specific hospital floor or nursing unit, such as surgical or intensive care. Used in facility credentialing and service-line reporting to categorize floor-level care capabilities.

floor temperatureflr_temp

Records a patient's body temperature measurement taken at the hospital floor or nursing unit level as part of routine vital sign monitoring. Captured in inpatient clinical documentation systems to track patient health status, detect fever or hypothermia, and inform treatment decisions during hospital stays.

floor termination dateflr_term_dt

Indicates the date on which a hospital floor or nursing unit designation was deactivated, closed, or discontinued within facility management systems. Used in inpatient operational records to maintain accurate historical data about the active periods of specific care units and support audit and compliance reporting.

floor timeflr_tm

Records the specific time of day associated with a clinical event, patient interaction, or administrative action occurring at the hospital floor or nursing unit level. Used in inpatient documentation and workflow systems to establish precise timelines for care delivery, shift handoffs, and regulatory compliance reporting.

floor timestampflr_ts

Captures the full date and time of a clinical or administrative event occurring at the hospital floor or nursing unit level, providing a precise audit trail. Used across inpatient EHR and health information systems to sequence care events, support charge capture timing, and meet documentation compliance requirements.

PreviousPage 111 of 325Next