Provider

The lower limit value associated with a provider attribute, such as the minimum reimbursable fee, minimum required service units, or minimum panel size threshold. Used in fee schedule management and contract administration to enforce floor thresholds during claims adjudication and network compliance reviews.

The mobile or cellular phone number associated with a licensed healthcare provider. Used in provider communication workflows, on-call scheduling systems, and care coordination platforms to enable direct contact with providers outside of office settings for urgent clinical or administrative communications.

The user ID or username of the individual who last updated a provider record in the system. Used in audit trails and data governance processes to track accountability for changes made to provider profiles, credentialing records, or network participation data across administrative systems.

Timestamp recording the most recent update to a provider's record within EHR, credentialing, or provider master systems. Data engineers use this field to drive incremental ETL loads, detect changed records for SCD Type 1 or Type 2 processing, and audit data lineage across provider data pipelines.

The timestamp recording when a provider record was most recently updated in the system. Used in data governance, audit logging, and downstream data synchronization processes to track the currency of provider profile changes across credentialing, claims, and network management systems.

Standardized display name for a healthcare provider as maintained in EHR, claims, and provider master systems. Used by data engineers for label rendering, report generation, and provider lookups when a full parsed name is unavailable. Often derived from first, middle, and last name fields during ETL transformation.

The defined set of healthcare providers who have contracted with a health plan to deliver covered services to members at negotiated reimbursement rates. Provider networks are a core component of managed care, defining where members can receive in-network benefits and driving network adequacy compliance. Networks are organized by product type — HMO networks require exclusive in-network care while PPO networks offer out-of-network access at higher cost sharing. Health plans maintain multiple networks for different product lines and geographic markets. Healthcare data teams build provider network tables that track which providers are contracted in which networks, effective and termination dates for network participation, network tier assignments for tiered benefit designs, and network adequacy metrics used in CMS and state regulatory filings.

The legal agreement between a health plan and a healthcare provider or provider organization establishing the terms and conditions of network participation including reimbursement rates, billing and claims submission requirements, utilization management compliance obligations, quality program participation requirements, credentialing standards, and dispute resolution procedures.

The strategic and operational activities focused on building, maintaining, and optimizing a health plan contracted provider network to ensure sufficient provider access for enrolled members while managing network costs and quality. Network development includes provider recruitment, contract negotiation, geographic coverage analysis, specialty gap identification, and network adequacy filing with regulators.

The date on which a healthcare provider network participation agreement becomes active, establishing the start of the contracted relationship between the provider and health plan. The network effective date determines when claims for services rendered by the provider are eligible for in-network benefit levels and contracted reimbursement rates. Retroactive network effective dates may be applied during credentialing delays to ensure members who received care during the credentialing period are not penalized with out-of-network cost sharing. Healthcare data teams use prvdr_ntwk_eff_dt as the start boundary in point-in-time network status queries, joining service dates against network effective and termination dates to determine the correct network participation status at the time of care for accurate claims adjudication and member cost-sharing calculation.

A coded value indicating the current participation status of a healthcare provider within a specific health plan network, reflecting whether the provider is actively contracted, pending credentialing, suspended, or terminated. Common network status values include active indicating current contracted participation, pending for providers in the credentialing and contracting process, suspended for providers with temporary holds due to quality or compliance issues, and terminated for providers whose contracts have ended. Network status drives claims adjudication to apply correct in-network or out-of-network benefit levels and cost-sharing rules. Healthcare data teams maintain prvdr_ntwk_sts with effective dates in provider network tables, use status transitions in network adequacy gap analysis, and surface current status in provider directory systems to ensure member-facing directory accuracy.

The date on which a healthcare provider network participation agreement ends, marking the close of the contracted relationship between the provider and health plan. Network termination may occur voluntarily when a provider chooses to leave the network, involuntarily when a plan terminates a provider contract for cause, or through mutual agreement at contract expiration. CMS and state regulations require health plans to provide advance notice to members when their provider is leaving the network, typically 30 to 60 days before the termination date. Healthcare data teams use prvdr_ntwk_term_dt as the end boundary in point-in-time network status queries and in network continuity of care workflows to identify members in active treatment with terminating providers who qualify for transition of care protections.

A classification of in-network healthcare providers into performance-based tiers used in tiered network health plan designs where member cost-sharing varies by provider tier, with lower cost-sharing for preferred tier 1 providers who meet quality and cost-efficiency thresholds and higher cost-sharing for standard tier 2 providers. Tiered network designs create financial incentives for members to select high-value providers.

Free-text annotation or structured comment associated with a provider record in EHR, credentialing, and payer systems, capturing supplemental information outside standard coded fields. Data engineers store and index this field to support provider record auditing, operational workflows, and contextual data enrichment in provider master tables.

The National Provider Identifier assigned by CMS under HIPAA to uniquely identify a licensed healthcare provider in standard electronic transactions. Required on all HIPAA-compliant claims submissions and used across payers, clearinghouses, and health systems to standardize provider identification nationally.

Externally or operationally assigned numeric identifier for a healthcare provider used in billing, claims submission, and network management systems. Distinct from internal surrogate keys, this field supports legacy system joins, clearinghouse transactions, and payer-specific provider referencing in claims and remittance data pipelines.

The end-to-end process of enrolling a new healthcare provider into a health plan network, encompassing application submission, credentialing verification, contract negotiation and execution, system configuration for claims adjudication, provider directory listing, and provider orientation to plan processes and tools. Provider onboarding cycle time is a key operational metric for health plan network management.

The date on which a patient's condition or illness first appeared, as documented by the treating provider on a claim or clinical record. Used in claims adjudication and utilization review to establish medical necessity and chronology of care.

The National Provider Identifier of the healthcare provider who ordered a diagnostic test, laboratory service, durable medical equipment, home health service, or prescription medication for a patient. CMS requires ordering provider NPI on Medicare claims for laboratory, imaging, DME, and home health services to establish medical necessity accountability and support program integrity audits. The ordering provider is responsible for the medical necessity determination underlying the ordered service and may be subject to audit if ordering patterns suggest inappropriate utilization. Healthcare data teams use prvdr_ordr_npi in claims analytics to calculate ordering provider-level test ordering rates, identify outliers with significantly elevated diagnostic testing volumes, detect potentially inappropriate ordering patterns for DME and laboratory services in fraud detection workflows, and measure adherence to evidence-based diagnostic testing guidelines.

The legal or operating name of a healthcare organization registered in the CMS National Plan and Provider Enumeration System and used on claims, credentialing applications, and provider directory listings. Provider organization name applies to hospitals, medical groups, clinics, health systems, skilled nursing facilities, and other institutional providers that bill under a group or facility NPI rather than an individual practitioner NPI. Organization names must match the legal entity registered with the IRS for the provider TIN to ensure consistent identity across claims, credentialing, and payment records. Healthcare data teams use prvdr_org_nm in provider master data management to standardize name variations across source systems, in provider directory maintenance for member-facing plan websites, and in network adequacy reporting for CMS and state regulatory submissions.