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

facility urgencyfac_urg

Indicates the clinical urgency or time-sensitivity level assigned to a service, admission, or procedure at a specific healthcare facility. Used in utilization management, prior authorization, and claims processing to distinguish between emergent, urgent, and elective care for appropriate reimbursement and resource allocation.

facility valuefac_val

A discrete measured data point captured for a healthcare service location, such as a charge amount, quality metric, or operational indicator, within EHR or claims systems. Used in downstream analytics and reporting pipelines to evaluate facility performance, benchmark costs, and support value-based care contract assessments.

facility versionfac_ver

Tracks the version number of a healthcare facility's record within a data management system, incrementing each time the record is updated. Used in audit logging, data governance, and change management workflows to maintain a history of modifications and ensure the most current facility information is applied.

facility zipfac_zip

Stores the five or nine-digit U.S. postal ZIP code for a healthcare facility's physical location. Used in geographic analysis, provider network mapping, claims adjudication, and regulatory reporting to identify service areas, determine in-network status, and support population health and access-to-care analytics.

fee schedule amountfee_sched_amt

The contracted payment amount for a specific procedure or service code under a payer provider agreement, used as the benchmark for expected reimbursement in payment variance analysis. Comparing actual payments received against fee schedule amounts identifies underpayments requiring follow-up and systematic payer payment accuracy issues warranting contract audit.

financial assistance eligibility flagfin_asst_elig_flg

A flag indicating that a patient has been determined eligible for charity care, financial assistance, or a reduced payment plan based on income screening relative to federal poverty guidelines, used in revenue cycle analytics to track financial assistance program utilization, compliance with 501(c)(3) community benefit requirements, and uncompensated care cost reporting.

finding addressfndg_addr

Records the physical location or address context associated with a specific clinical finding documented during a patient encounter. Used in clinical documentation and care coordination to link assessment results to the site where observations were made, supporting longitudinal patient records and referral management.

finding approval statusfndg_appr_sts

Indicates the current authorization or review state of a clinical finding, such as pending, approved, or rejected, within a clinical workflow. Used in quality management, utilization review, and care management systems to track whether a documented finding has been validated or acted upon by a clinician or reviewer.

finding charge amountfndg_chrg_amt

Captures the monetary charge associated with diagnosing or documenting a specific clinical finding during a patient encounter. Used in facility and professional billing, claims processing, and revenue cycle management to link clinical assessment results to associated service costs for accurate reimbursement and financial reporting.

finding effective datefndg_eff_dt

Records the date on which a specific clinical finding became active or clinically relevant for a patient. Used in longitudinal patient records, care management, and quality reporting to establish the onset timeline of identified conditions or observations, supporting clinical decision-making and accurate diagnosis coding.

finding group numberfndg_grp_nbr

The insurance group identifier associated with a clinical finding or assessment result, linking the finding to a specific health plan group. Used to attribute clinical observations to the correct payer group for population health reporting, care management workflows, and claims adjudication reconciliation.

finding medical record numberfndg_mrn

The unique patient medical record number linked to a specific clinical finding or assessment result. Enables consistent identification of the patient across clinical systems, ensuring the finding is accurately attributed to the correct individual within EHR, lab, imaging, and clinical data warehouse environments.

finding scheduled datefndg_sched_dt

The calendar date on which a clinical assessment, diagnostic test, or procedure related to a finding is planned to occur. Used to coordinate care delivery timelines, track appointment adherence, and monitor how scheduled dates align with actual encounter dates in clinical workflows and quality reporting.

finding scheduled timefndg_sched_tm

The specific time of day at which a clinical assessment, diagnostic procedure, or care event related to a finding is planned to occur. Used alongside the scheduled date to manage appointment sequencing, care coordination, and clinical staff resource allocation within scheduling and EHR systems.

finding street addressfndg_st_addr

The street-level physical address associated with the location where a clinical finding was recorded, observed, or where follow-up care is to be delivered. Used to support care coordination, patient outreach, and geographic analysis of clinical findings across healthcare delivery sites and community health programs.

finding unitfndg_unt

The unit of measure associated with a clinical finding or assessment result, such as mg/dL, mmHg, or beats per minute. Critical for accurate interpretation of diagnostic values, enabling clinical decision support systems, quality measures, and population health analytics to correctly evaluate and compare patient findings.

floor account numberflr_acct_nbr

The unique account identifier associated with a specific hospital floor or inpatient unit, used to attribute patient charges, services, and resource utilization to the correct nursing unit or care area. Supports cost center reporting, hospital billing workflows, and inpatient financial reconciliation across revenue cycle systems.

floor active indicatorflr_actv_ind

A binary flag indicating whether a specific hospital floor or inpatient nursing unit is currently active and available for patient assignments. Used by hospital administration and bed management systems to control unit visibility, ensure accurate census reporting, and prevent assignment of patients to decommissioned or temporarily closed units.

floor active statusflr_actv_sts

The current operational status of a hospital floor or inpatient nursing unit, indicating whether the unit is open, closed, or temporarily suspended. Used by hospital facility management, bed management, and staffing systems to coordinate patient placement decisions and maintain accurate unit availability records.

floor addressflr_addr

The physical location details for a specific hospital floor or inpatient nursing unit, including building, wing, and level information. Used to direct patients, staff, and emergency responders to the correct care area, and to support facility management, wayfinding systems, and regulatory compliance documentation.

PreviousPage 104 of 325Next