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 mobileflr_mob

The mobile or wireless contact number associated with a hospital floor's charge nurse station or mobile care team. Used in facility communication systems and clinical workflows to enable direct contact with floor staff for patient placement coordination, rapid response, and inter-unit communication.

floor modified byflr_mod_by

The user identifier of the individual who last updated the hospital floor's record within the facility management or hospital information system. Used in audit trail logging to track data stewardship, support compliance reviews, and identify who made changes to floor configuration or attributes.

floor modified dateflr_mod_dt

The calendar date on which a hospital floor's record was most recently updated in the facility management or hospital information system. Used in audit logging and data governance workflows to track the recency of configuration changes and support change management processes.

floor modified timeflr_mod_tm

The timestamp indicating the exact time a hospital floor's record was last updated within the facility management or hospital information system. Used alongside the modified date in audit trail records to provide precise chronological tracking of changes to floor-level configuration data.

floor nameflr_nm

The human-readable label assigned to a specific hospital floor or nursing unit, such as '4 North' or 'Cardiac Care Unit.' Used across inpatient census systems, bed management platforms, and clinical documentation tools to consistently identify and display the care unit in workflows and reports.

floor noteflr_nt

Free-text annotation field associated with a hospital floor record, used to capture operational details, special instructions, or contextual information about the unit. Referenced in facility management systems to communicate floor-specific considerations such as isolation protocols, renovation status, or unit specialization.

floor numberflr_nbr

The numeric identifier assigned to a specific hospital floor within the facility's physical structure. Used in bed management, patient transport, and environmental services systems to reference the exact floor location for room assignments, housekeeping dispatch, and inter-department coordination across the hospital campus.

floor onset dateflr_onset_dt

A data attribute erroneously mapped to a hospital floor entity, likely due to template misapplication. In correct clinical context, onset date records when a patient's condition or symptom first appeared, captured in clinical documentation and used in diagnosis coding, care planning, and chronic condition management workflows.

floor oxygen saturationflr_o2sat

A data attribute erroneously mapped to a hospital floor entity, likely due to template misapplication. In correct clinical context, oxygen saturation is a vital sign measurement representing the percentage of hemoglobin bound to oxygen, recorded in patient monitoring systems and used in respiratory and critical care clinical workflows.

floor paid amountflr_pd_amt

The total reimbursement or payment amount allocated to services rendered on a specific hospital floor, used in cost accounting and revenue cycle management. Supports financial reporting by associating inpatient charges with care unit locations to analyze floor-level profitability and payer reimbursement patterns.

floor paid dateflr_pd_dt

The date on which payment was processed for services rendered at a specific hospital floor unit. Used in inpatient claims processing to reconcile billing cycles, track reimbursement timelines, and audit payment accuracy against service delivery dates for facility-level charges.

floor parentflr_prnt

The hierarchical parent entity to which a hospital floor unit belongs within a facility's organizational structure. Used to link a floor to its parent wing, building, or department, enabling accurate cost center reporting, staffing allocation, and inpatient census management across multi-unit facilities.

floor percentageflr_pct

A ratio expressed as a percentage associated with a specific hospital floor unit, such as occupancy rate, reimbursement percentage, or contracted rate allocation. Used in facility billing and capacity management to calculate cost distribution, utilization metrics, and payer contract compliance at the floor level.

floor periodflr_prd

The defined time interval associated with a hospital floor unit's operational, billing, or reporting cycle. Used in inpatient facility management to bound claim adjudication windows, measure length-of-stay segments, and track floor-level utilization across discrete reporting periods.

floor phoneflr_ph

The direct telephone contact number assigned to a specific hospital floor unit, such as a nursing station or ward. Used in patient care coordination, care team communications, and facility directory records to enable rapid contact between clinical staff, patients, and ancillary departments during inpatient stays.

floor planflr_pln

The physical layout or operational configuration associated with a specific hospital floor unit, including bed arrangement, care zones, and department assignments. Used in facility management, infection control planning, and inpatient workflow design to support efficient patient placement and resource deployment across care areas.

floor policy numberflr_pol_nbr

The unique identifier assigned to an insurance policy or coverage agreement applicable to services provided on a specific hospital floor unit. Used in inpatient claims adjudication to link facility-level service charges to the correct payer contract, ensuring accurate billing and reimbursement processing.

floor preferred nameflr_pref_nm

The standardized or colloquially recognized display name assigned to a specific hospital floor unit, such as '4 North Telemetry' or 'Pediatric Step-Down.' Used in clinical workflows, patient communications, wayfinding systems, and reporting dashboards to present floor-level location data in a consistent, human-readable format.

floor priceflr_prc

The minimum or established cost value associated with services, procedures, or room charges billed at a specific hospital floor unit. Used in facility revenue cycle management to set baseline reimbursement thresholds, negotiate payer contracts, and ensure that inpatient floor-level charges meet cost-recovery benchmarks.

floor primary indicatorflr_prim_ind

A flag that designates whether a specific hospital floor unit is the primary location of record for a patient encounter or billing event. Used in inpatient facility data management to distinguish the principal care unit from secondary or transfer floors when attributing charges, outcomes, and staffing data across multi-floor stays.

PreviousPage 109 of 325Next