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 onset datefac_onset_dt

Date on which a condition, event, or status change associated with a facility encounter or record first began. In clinical data systems, this may capture when a patient's presenting condition started during a facility-based visit, supporting diagnosis coding, care planning, and quality measure calculations.

facility oxygen saturationfac_o2sat

Blood oxygen saturation percentage recorded at or attributed to a specific healthcare facility during a patient encounter. Used in clinical data warehouses to monitor respiratory status, support inpatient care decisions, and track vital sign trends for patients receiving facility-based care.

facility paid amountfac_pd_amt

The actual dollar amount disbursed to a hospital, clinic, or other institutional facility for services rendered on a claim. Used in claims adjudication to record net reimbursement after contractual adjustments, member cost-sharing, and coordination of benefits are applied.

facility paid datefac_pd_dt

The date on which payment was issued to a hospital, clinic, or institutional facility for an adjudicated claim. Used in claims payment reconciliation to track remittance timing, monitor payment cycle performance, and support accounts payable reporting for facility claims.

facility parentfac_prnt

Hierarchical reference linking a healthcare facility to its superior entity, such as a health system or hospital network, within provider master and EHR systems. Enables roll-up reporting, contract inheritance, and organizational hierarchy traversal in claims adjudication and analytics platforms.

facility percentagefac_pct

Numeric percentage value associated with a healthcare facility, used in contexts such as reimbursement rate calculations, risk-sharing arrangements, or capacity utilization reporting in claims, PBM, and payer systems. Supports contract analytics and financial modeling for facility-based care delivery.

facility periodfac_prd

Defined time span during which a healthcare facility is active, contracted, or operationally valid within EHR, payer, and provider master systems. Used to govern eligibility windows, contract effective dates, and facility-level reporting intervals in claims adjudication and enrollment workflows.

facility phonefac_ph

Primary telephone contact number for a healthcare facility as stored in provider directories, EHR systems, and member-facing portals. Used for care coordination, prior authorization routing, and claims follow-up across payer, PBM, and provider network management platforms.

facility planfac_pln

The insurance or benefit plan associated with a hospital, clinic, or institutional facility in member enrollment or claims records. Identifies which health plan product governs coverage terms, reimbursement rates, and network participation rules applicable to the facility claim.

facility policy numberfac_pol_nbr

The unique policy or contract number assigned to a hospital, clinic, or institutional facility under a health plan agreement. Used to link facility claims or enrollment records to the governing insurance contract, enabling benefit verification and claims adjudication processing.

facility preferred namefac_pref_nm

The preferred or doing-business-as name for a hospital, clinic, or institutional facility, as distinct from its legal entity name. Used in member-facing directories, claims displays, and provider network communications to present a recognizable and consistent facility name.

facility pricefac_prc

The negotiated or contractual rate established for services rendered by a hospital, clinic, or institutional facility. Used in claims pricing and reimbursement workflows to determine allowed amounts based on fee schedules, DRG rates, or per-diem arrangements specific to facility billing.

facility primary indicatorfac_prim_ind

A flag identifying whether a hospital, clinic, or institutional facility is the primary or principal location associated with a record, such as a member's primary care facility or a claim's principal billing facility. Used in network management and claims routing logic.

facility priorityfac_prty

Ranked importance value assigned to a healthcare facility within network management, referral routing, or care coordination systems. Determines preferred facility selection in EHR workflows, member cost-sharing tiers, and payer network logic for in-network versus out-of-network adjudication decisions.

facility pulsefac_pulse

The pulse rate, measured in beats per minute, recorded for a patient during a clinical encounter at a hospital, clinic, or institutional facility. Used as a vital sign data element in inpatient and outpatient clinical documentation to support patient monitoring and care assessment.

facility quantityfac_qty

Numeric count value associated with a healthcare facility, representing units such as licensed beds, procedure volumes, or resource allocations within EHR, claims, and operational reporting systems. Supports capacity planning, utilization management, and facility-level performance benchmarking in analytics pipelines.

facility racefac_race

The self-reported or recorded racial classification of a patient receiving care at a hospital, clinic, or institutional facility. Used in health equity analytics, population health reporting, and federally required demographic data collection to identify and address disparities in care access and outcomes.

facility rangefac_rng

Minimum and maximum value boundaries associated with a healthcare facility metric, such as acceptable reimbursement rates, patient volume thresholds, or geographic service radius in payer and provider systems. Used in contract validation, network adequacy assessments, and claims editing logic.

facility ratefac_rt

Unit price or reimbursement amount associated with services rendered at a healthcare facility, as defined in fee schedules, contract terms, or claims adjudication engines. Used by payer and PBM systems to calculate allowed amounts, apply DRG groupings, and determine facility cost-sharing obligations.

facility ratingfac_rtg

A quality or performance score assigned to a hospital, clinic, or institutional facility based on clinical outcomes, patient experience surveys, safety metrics, or accreditation criteria. Used in network tiering, value-based contracting, and member-facing quality transparency reporting.

PreviousPage 101 of 325Next