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 titleflr_ttl

Stores the formal name or designation assigned to a specific hospital floor or nursing unit, such as 'Medical-Surgical Unit 4B' or 'Cardiac Step-Down Floor.' Used in facility management, patient communication, and clinical systems to clearly identify inpatient care locations across administrative and operational workflows.

floor totalflr_tot

Represents the aggregate sum of charges, patient encounters, resource utilization, or other measurable values accumulated at the hospital floor or nursing unit level within a defined period. Used in inpatient financial and operational reporting to evaluate unit-level performance and support cost allocation processes.

floor total countflr_tot_cnt

Represents the total number of occurrences, patients, encounters, or items associated with a specific hospital floor or nursing unit within a reporting period. Used in inpatient capacity management and operational analytics to measure census volume, throughput, and service utilization at the unit level.

floor typeflr_typ

Classifies a hospital floor or nursing unit by its care category, such as intensive care, medical-surgical, obstetrics, or behavioral health. Used in facility management and clinical systems to route patients to appropriate inpatient settings, allocate staffing, and generate service-line utilization reports.

floor unitflr_unt

Identifies the specific nursing unit or care division within a hospital floor, representing the base organizational level for inpatient care delivery. Used in bed management, staffing, and clinical documentation systems to assign patients, allocate resources, and track care activities at the most granular facility level.

floor updated dateflr_upd_dt

Records the most recent date on which the configuration, attributes, or status of a hospital floor or nursing unit record was modified in the system of record. Used in data governance and audit processes to track changes to inpatient facility definitions and ensure data integrity across connected healthcare systems.

floor urgencyflr_urg

Indicates the time-sensitivity or clinical urgency level associated with a patient placement, transfer request, or care event at the hospital floor or nursing unit level. Used in bed management and patient flow systems to prioritize inpatient assignments and ensure patients with critical needs are placed promptly in appropriate care settings.

floor valueflr_val

Stores a measured or calculated data point associated with clinical, operational, or financial activity at the hospital floor or nursing unit level, such as a vital sign reading or a cost metric. Used across inpatient documentation and analytics systems to support performance monitoring and care quality reporting.

floor versionflr_ver

Tracks the version number of a hospital floor or nursing unit record, incrementing with each update to configuration, attributes, or status in the system. Used in data management and audit workflows to maintain a complete history of changes to inpatient unit definitions and support data lineage and compliance requirements.

floor zipflr_zip

The ZIP code associated with a specific floor-level designation within a hospital or healthcare facility. Used in facility management systems to geographically identify and route clinical workflows, staffing assignments, and patient placement to the correct physical unit or ward level.

form active indicatorfrm_actv_ind

A binary flag indicating whether a clinical or administrative data collection form is currently active and available for use. Controls form visibility and usability within EHR workflows, ensuring only current, approved versions are accessible to clinicians and administrative staff during patient encounters.

form active statusfrm_actv_sts

A coded value representing the operational lifecycle state of a clinical or administrative data collection form, such as active, inactive, or retired. Used in form management systems to control which form versions are presented to users during documentation and data capture workflows.

form addressfrm_addr

The physical or mailing location captured on standardized healthcare data collection forms, including UB-04 or CMS-1500 submissions. Used in EHR and claims systems to associate provider, facility, or member addresses with specific form transactions for routing and adjudication.

form agefrm_age

The calculated age of the patient or subject recorded at the time a clinical or administrative form was completed. Used to support age-specific clinical logic, eligibility rules, and reporting requirements within EHR documentation and population health workflows.

form allowed amountfrm_alwd_amt

The maximum dollar amount a payer will reimburse for services documented on a specific clinical or administrative form. Used in claims adjudication and financial reconciliation workflows to calculate patient liability, provider payment, and contractual adjustment amounts.

form amountfrm_amt

The monetary value field captured on standardized healthcare billing or data collection forms, representing billed charges, allowed amounts, or payment values. Used in claims adjudication systems, PBM platforms, and EHR billing modules to track financial transactions tied to specific form submissions.

form approval statusfrm_appr_sts

A coded value indicating the current authorization state of a clinical or administrative form, such as pending, approved, or rejected. Used in care management and quality workflows to enforce review processes before form data is finalized, acted upon, or submitted to downstream systems.

form approved byfrm_appr_by

The identifier or name of the clinician, supervisor, or administrative user who granted final authorization for a clinical or administrative form. Used in audit trails, compliance workflows, and quality management systems to establish accountability and document the chain of approval.

form arrival timefrm_arrv_tm

The recorded time at which a patient arrived for a clinical encounter documented on a specific form. Used in emergency department, outpatient, and inpatient workflows to calculate wait times, measure throughput metrics, and support operational and quality reporting requirements.

form arrived datefrm_arrv_dt

The calendar date on which a patient arrived for a clinical encounter associated with a specific form. Used in scheduling, care coordination, and utilization management systems to establish encounter timelines and support length-of-stay and access-to-care reporting.

PreviousPage 112 of 325Next