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 codeflr_cd

The standardized alphanumeric identifier assigned to a specific hospital inpatient floor unit within a facility's administrative or clinical system. Used to uniquely reference and track floor-level activity across bed management, billing, staffing, and clinical data systems within the hospital.

floor coinsurance amountflr_coins_amt

The portion of covered service costs that a patient is responsible for paying on a percentage basis for care received on a specific hospital inpatient floor unit. Applied after deductibles are met and used in facility billing and claims adjudication to calculate member cost-sharing obligations.

floor commentflr_cmt

Free-text narrative notes associated with a specific hospital inpatient floor unit, capturing operational, clinical, or administrative context not represented by structured fields. Used in inpatient documentation systems to record exceptions, special instructions, or floor-level observations relevant to patient care or unit management.

floor completed dateflr_cmpl_dt

The date on which a service, procedure, or clinical episode associated with a specific hospital inpatient floor unit was marked as completed. Captured in inpatient operational and clinical systems to support workflow closure, episode-of-care analysis, discharge processing, and facility billing finalization.

floor confidential indicatorflr_conf_ind

A flag indicating that records associated with a specific hospital inpatient floor unit or patient stay are subject to heightened privacy protections, such as behavioral health or substance use restrictions. Used to control data access and disclosure in compliance with HIPAA and 42 CFR Part 2 regulations.

floor copay amountflr_cpay_amt

The fixed dollar amount a patient is required to pay at the time of service for care received on a specific hospital inpatient floor unit. Applied per the patient's benefit plan terms and captured in facility billing and claims adjudication systems to determine member out-of-pocket cost responsibilities.

floor costflr_cst

The actual or allocated expense incurred in delivering care on a specific hospital inpatient floor unit, including labor, supplies, and overhead. Used in hospital cost accounting and financial reporting systems to evaluate floor-level operational efficiency, budget performance, and service line profitability.

floor countflr_cnt

The total number of occurrences, units, or records associated with a specific hospital inpatient floor unit within a defined reporting period. Used in hospital operational analytics, staffing models, utilization reports, and clinical data summaries to quantify floor-level activity and resource consumption.

floor countryflr_ctry

The country where the hospital inpatient floor unit is physically located. Captured in facility master data and administrative records to support international multi-site hospital reporting, regulatory compliance submissions, geographic analytics, and cross-border healthcare network directory maintenance.

floor created byflr_crtd_by

The username or system identifier of the individual or automated process that originally created the record for a specific hospital inpatient floor unit. Captured as an audit field in healthcare administrative and clinical systems to support data governance, change tracking, and accountability in floor-level record management.

floor created dateflr_crtd_dt

The date a hospital floor record was initially entered into the facility management system. Used to establish the audit trail for inpatient unit configurations, tracking when physical nursing unit or ward designations were first defined within the hospital's operational data.

floor created timeflr_crtd_tm

The timestamp indicating when a hospital floor record was first created in the facility management system. Captures the precise time of record entry for audit and data governance purposes, supporting accurate tracking of inpatient unit setup and administrative workflow sequencing.

floor creatinineflr_cr

The baseline or minimum creatinine lab value associated with a patient during their hospital floor stay. Used in inpatient clinical data to monitor kidney function trends, establish reference thresholds, and support clinical decision-making for patients on general medical or surgical units.

floor dateflr_dt

The calendar date associated with a patient's assignment or activity on a hospital inpatient floor unit. Used in inpatient encounter tracking to record key events tied to a specific nursing unit or ward, supporting length-of-stay analysis and utilization reporting.

floor datetimeflr_dttm

The combined date and time value capturing a specific event or transaction associated with a hospital floor unit assignment. Used in inpatient records to precisely timestamp patient movements, clinical activities, or administrative updates tied to a nursing unit or ward.

floor dea numberflr_dea_nbr

The Drug Enforcement Administration registration number assigned to a hospital floor unit or its associated prescribing authority. Used in controlled substance tracking and pharmacy management to ensure compliance with federal regulations for dispensing and administering scheduled medications on inpatient units.

floor death dateflr_death_dt

The date a patient expired while assigned to a hospital inpatient floor unit. Used in mortality reporting, discharge disposition coding, and clinical quality metrics to document patient outcomes at the unit level, supporting root cause analysis and facility benchmarking.

floor deductible amountflr_ded_amt

The minimum deductible threshold applied at the hospital floor or unit level within an insurance benefit structure. Used in healthcare billing and claims adjudication to determine patient cost-sharing obligations before insurance coverage begins for inpatient services rendered on a specific unit.

floor deleted dateflr_del_dt

The date a hospital floor or nursing unit record was marked as deleted or deactivated within the facility management system. Used to maintain a historical audit trail of inpatient unit changes, supporting data governance, compliance reviews, and retrospective reporting of unit configurations.

floor deleted indicatorflr_del_ind

A flag indicating whether a hospital floor or nursing unit record has been logically removed from active use in the facility management system. Used to filter deactivated unit records from operational reporting while preserving historical data integrity for audit and retrospective inpatient analysis.

PreviousPage 106 of 325Next