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 ratiofac_ratio

A calculated proportional measure associated with a hospital, clinic, or institutional facility, such as a staffing ratio, cost-to-charge ratio, or utilization rate. Used in financial analysis, operational benchmarking, and actuarial modeling to assess facility efficiency and cost performance.

facility reasonfac_rsn

Reason descriptor for facility within Eligibility processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

facility received datefac_rcvd_dt

The date on which a claim, authorization request, or document submitted by or on behalf of a hospital, clinic, or institutional facility was received by the health plan or claims processor. Used to establish timely filing compliance and initiate claims adjudication workflows.

facility referencefac_ref

External pointer or cross-system identifier linking a healthcare facility record to related entities in EHR, claims, or provider master systems. Used for data lineage tracking, interoperability mapping, and cross-platform reconciliation in payer, PBM, and health information exchange workflows.

facility resolution datefac_resol_dt

The date on which an outstanding issue, appeal, dispute, or pended claim associated with a hospital, clinic, or institutional facility was formally resolved. Used in claims dispute tracking, grievance management, and regulatory compliance reporting to measure resolution cycle times.

facility respirationfac_resp

The respiratory rate, measured in breaths per minute, recorded for a patient during a clinical encounter at a hospital, clinic, or institutional facility. Captured as a vital sign in inpatient and emergency care documentation to support clinical assessment and patient monitoring workflows.

facility resultfac_rslt

Outcome measurement recorded at the facility level within EHR, quality reporting, or claims systems. Represents clinical results, audit findings, or performance outcomes tied to a specific facility. Used in HEDIS reporting, value-based care analytics, and network performance dashboards for payer and provider platforms.

facility review systemsfac_ros

Documents the body systems reviewed during a clinical encounter at a specific healthcare facility location. Captures the review of systems (ROS) assessment tied to the facility where care was delivered, supporting clinical documentation, quality reporting, and accreditation compliance.

facility revisionfac_rev

A version or iteration number tracking updates made to a hospital, clinic, or institutional facility record, contract, or clinical document. Used in data governance and audit workflows to maintain a history of changes to facility-related records and ensure data integrity across systems.

facility riskfac_rsk

A risk classification or score assigned to a hospital, clinic, or institutional facility based on factors such as financial stability, quality performance, accreditation status, or compliance history. Used in network credentialing, value-based contracting, and health plan risk management decisions.

facility routefac_rte

The geographic or logistical routing pathway assigned to a hospital, clinic, or institutional facility for purposes such as claims submission routing, referral network direction, or emergency transport coordination. Used in network operations and care coordination workflows to connect members to appropriate facilities.

facility scheduled datefac_sched_dt

The date on which a procedure, admission, or service was planned to occur at a hospital, clinic, or institutional facility. Used in prior authorization, utilization management, and care coordination workflows to track scheduled care events and compare planned versus actual service dates.

facility scheduled timefac_sched_tm

The specific time at which a procedure, admission, or service was planned to begin at a hospital, clinic, or institutional facility. Used alongside the scheduled date in utilization management and care coordination systems to manage appointment logistics, resource allocation, and patient flow operations.

facility scorefac_scr

Calculated numeric rating assigned to a healthcare facility based on quality, performance, or risk metrics in payer, EHR, or analytics systems. Supports network tiering, value-based contract evaluations, CMS star ratings alignment, and provider performance reporting in downstream data pipelines.

facility sequencefac_seq

Ordinal number assigned to a healthcare facility record to define processing order or display rank within EHR, claims, or provider master systems. Used to manage multi-facility encounters, ordered billing hierarchies, and batch processing workflows in adjudication and reporting pipelines.

facility service datefac_svc_dt

Date on which a healthcare service was rendered at a specific facility, captured in claims, EHR, and encounter data systems. Critical for timely filing edits, coordination of benefits sequencing, episode of care attribution, and facility-level utilization reporting in payer and provider analytics.

facility severityfac_sev

Clinical or operational severity classification assigned to a condition or encounter associated with a healthcare facility, used in EHR, DRG grouping, and claims systems. Influences reimbursement levels, case mix index calculations, and risk-adjusted quality reporting for hospital and inpatient facility billing.

facility sexfac_sex

Records the biological sex designation associated with a patient encounter at a specific healthcare facility. Used in facility-level clinical reporting, demographic analysis, and population health tracking to support care delivery metrics, compliance reporting, and service utilization analysis.

facility sourcefac_src

Source system or channel for facility within Claims processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

facility start datefac_start_dt

Effective start date of a healthcare facility's operational, contractual, or enrollment period within provider master, payer, and EHR systems. Governs claims eligibility windows, network participation timelines, and credentialing validity in adjudication, reporting, and provider directory management workflows.

PreviousPage 102 of 325Next