Back to search

provider out of network

prvdr_oot_ntwk_ind
provider·Updated Jun 23, 2026

Definition

ISO-11179 Definition

A boolean indicator identifying that a healthcare provider is not contracted with a specific health plan network at the time of a member service or claims transaction. Out-of-network services typically subject members to significantly higher cost sharing including separate out-of-network deductibles, higher coinsurance percentages, and balance billing from providers who have not agreed to accept the plan allowed amount as payment in full. For HMO and EPO plan types, out-of-network services are generally not covered except in emergency situations.

The No Surprises Act of 2022 introduced federal protections limiting surprise out-of-network billing in emergency and certain non-emergency situations. Healthcare data teams use prvdr_oot_ntwk_ind in claims adjudication to trigger out-of-network benefit rules, generate member cost-sharing estimates, and produce network leakage analytics identifying members frequently using out-of-network services.

Standard Abbreviation

prvdr_oot_ntwk_ind

Category

provider

Production DDL — DIM_PROVIDER

DIM_PROVIDER.sql
CREATE OR REPLACE TABLE DIM_PROVIDER (
    prvdr_key           INTEGER        NOT NULL  -- surrogate key,
    prvdr_npi           VARCHAR(10)              -- NPI number,
    prvdr_tin           VARCHAR(10)              -- tax ID number,
    prvdr_first_nm      VARCHAR(100)             -- first name,
    prvdr_last_nm       VARCHAR(100)             -- last name,
    prvdr_org_nm        VARCHAR(255)             -- organization name,
    prvdr_typ_cd        VARCHAR(20)              -- provider type code,
    prvdr_spclty_cd     VARCHAR(10)              -- specialty code,
    prvdr_tax           VARCHAR(10)              -- taxonomy code,
    prvdr_state_cd      CHAR(2)                  -- state code,
    prvdr_zip_cd        VARCHAR(10)              -- zip code,
    prvdr_ntwk_sts      VARCHAR(10)              -- network status,
    prvdr_accpt_pt_ind  CHAR(1)                  -- accepting patients,
    prvdr_excl_ind      CHAR(1)                  -- exclusion indicator,
    load_dt             TIMESTAMP_NTZ  NOT NULL  -- load timestamp
);

Standard Snowflake DDL for the canonical provider table. Convert to BigQuery or Databricks →

Why This Term Matters

Provider data management is one of the most operationally complex data domains in healthcare because providers move, merge, and update their credentials continuously. A data engineer who understands provider terminology can build NPI validation, credentialing, and network adequacy pipelines that keep provider directories accurate and prevent claim rejections. Stale or incorrect provider data is a leading cause of prior authorization delays and CMS compliance findings.

Related Content

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms