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

organization numberorg_nbr

A system-assigned or externally defined numeric identifier for a healthcare entity, used to uniquely reference hospitals, clinics, health plans, or other entities within administrative systems for claims routing, enrollment processing, and contract management purposes.

organization onset dateorg_onset_dt

The date on which a specific status, condition, or operational attribute became effective for a healthcare entity, such as the start of a network participation agreement, accreditation status, or sanctioned status. Used in credentialing, contract management, and compliance tracking systems.

organization oxygen saturationorg_o2sat

A clinical vital sign field applied at the organizational level in aggregate or facility-level reporting contexts, reflecting mean or threshold oxygen saturation metrics for a patient population or care setting. Used in quality reporting, population health, and outcomes analytics systems.

organization paid amountorg_pd_amt

The total dollar amount disbursed to a healthcare entity such as a health plan, hospital system, or administrative body for services, contracts, or settlements. Captured in financial and claims systems to reconcile organizational-level payments and support accounts payable reporting.

organization paid dateorg_pd_dt

The calendar date on which payment was issued to a healthcare entity such as a health plan, hospital system, or administrative body. Used in financial and claims processing systems to track payment timelines, reconcile disbursements, and support accounts payable audit trails.

organization parentorg_prnt

The identifier or name of the higher-level entity in a corporate or administrative hierarchy to which a healthcare organization belongs. Used in enrollment and network management systems to establish ownership relationships between subsidiaries, affiliates, and parent health systems or payer entities.

organization percentorg_pct

A calculated ratio representing a specific metric as a proportion of the total organizational value, used in healthcare analytics platforms to benchmark performance across departments, facilities, or provider groups within EHR and claims data systems.

organization periodorg_prd

The defined date range during which a healthcare entity such as a health plan, network, or administrative body is considered active or relevant. Used in enrollment, contracting, and reporting systems to establish effective and termination dates governing the organization's participation or operational scope.

organization phoneorg_ph

The primary telephone contact number associated with a healthcare entity such as a health plan, hospital system, or administrative body. Stored in enrollment, network management, and member services systems to facilitate outreach, coordination of benefits inquiries, and administrative communications.

organization planorg_pln

The specific health benefit plan or product offered or administered by a healthcare entity such as an insurer or managed care organization. Used in member enrollment and claims systems to associate coverage terms, benefit structures, and cost-sharing rules with the administering organization.

organization policy numberorg_pol_nbr

The unique identifier assigned to an insurance policy or coverage agreement held or administered by a healthcare entity such as a health plan or employer group. Used in claims, enrollment, and billing systems to reference specific contract terms and link members to their coverage.

organization preferred nameorg_pref_nm

The designated display name by which a healthcare entity such as a health plan, hospital system, or administrative body prefers to be identified in communications and systems. Used in member-facing materials, provider directories, and administrative databases to ensure consistent branding and identification.

organization previousorg_prev

The prior organizational entity or affiliation associated with a provider, member, or facility record in EHR and enrollment systems, used to track historical organizational relationships during mergers, network changes, or provider transitions in healthcare data pipelines.

organization priceorg_prc

The contracted or listed dollar amount associated with services, products, or administrative functions provided by or to a healthcare entity. Used in financial, contracting, and claims systems to establish reimbursement expectations and support cost analysis at the organizational level.

organization primary indicatororg_prim_ind

A flag denoting whether a healthcare entity such as a health plan or administrative body holds primary status in a given context, such as primary payer designation in coordination of benefits. Used in claims and enrollment systems to determine payment ordering and coverage responsibility.

organization priorityorg_prty

A ranking value that determines the order or precedence assigned to a healthcare entity in a given operational context, such as payer sequencing in coordination of benefits or network tier assignment. Used in claims and enrollment systems to manage processing rules and coverage hierarchies.

organization pulseorg_pulse

A performance or activity metric used to monitor the operational health or engagement level of a healthcare entity, such as claims submission frequency or network utilization rate. Used in administrative analytics and reporting systems to assess organizational activity trends over defined intervals.

organization quantityorg_qty

A numeric count or volume measure associated with a healthcare entity's operational activity, such as the number of covered members, contracted providers, submitted claims, or administered plans. Used in enrollment, network management, and financial reporting systems to support capacity and utilization analysis.

organization raceorg_race

A demographic classification capturing the predominant racial composition or population characteristics of members served by a healthcare entity. Used in population health, quality reporting, and health equity analytics to assess disparities in care access and outcomes across organizational segments.

organization rangeorg_rng

The defined minimum and maximum boundaries for a measurable attribute associated with a healthcare entity, such as allowable reimbursement amounts, member age bands, or geographic service area distances. Used in contracting, claims, and network management systems to enforce business rules and eligibility thresholds.

PreviousPage 164 of 325Next