Provider

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 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.

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 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.

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.

The actual dollar amount remitted to a healthcare provider by a payer after claims adjudication, including contractual adjustments and coordination of benefits. Captured in claims payment data to reconcile remittance advice and provider payment records.

The date on which payment was issued to a healthcare provider by the payer following claims adjudication. Used in accounts payable and remittance tracking to monitor payment cycle times and confirm that claims have been settled within contractual terms.

A boolean indicator identifying whether a primary care provider patient panel is currently open and actively accepting new patients for enrollment. Panel open status is a critical network adequacy data element because health plans must demonstrate that a sufficient number of primary care providers with open panels exist within access standards for each member ZIP code in the service area. CMS and state regulators have increased scrutiny of panel open accuracy after finding widespread inaccuracies in health plan provider directories. Medicare Advantage plans must update panel status within 30 days of a change and attest to directory accuracy quarterly. Healthcare data teams implement systematic panel status verification processes including provider attestation portals, automated outreach for status updates, and directory audits that compare claimed open panel rates against actual new patient appointment availability to identify and correct inaccurate directory data.

A coded value indicating the current status of a primary care provider patient panel with respect to accepting new patients, reflecting panel capacity relative to the provider practice size and patient load. Common panel status values include open indicating the provider is actively accepting new patients, closed indicating no new patients are being accepted, and restricted indicating limited acceptance such as existing patients of the practice only or specific plan members only. Panel status is a critical network adequacy data element because health plans must demonstrate that sufficient open-panel primary care providers exist within access standards for each member ZIP code. Healthcare data teams maintain prvdr_pnl_sts with regular update timestamps in provider directory systems, monitor panel closure rates to identify developing network adequacy gaps, and report open panel availability to CMS in network adequacy filings.

Identifies the superior organizational or legal entity in a provider hierarchy within EHR, claims, and credentialing systems. Links individual practitioners or group practices to parent organizations for network management, contracting, and roll-up reporting in downstream analytics.

A boolean indicator identifying whether a healthcare provider has agreed to participate in a specific health insurance program or health plan network by accepting contracted reimbursement rates and program requirements. Participating providers accept the plan allowed amount as payment in full and may not balance bill members for the difference between their billed charges and the allowed amount. Non-participating providers retain the right to balance bill members in most circumstances except where prohibited by federal or state law. Medicare participation status determines whether providers accept Medicare assignment for all claims. Healthcare data teams use prvdr_part_ind in claims adjudication to determine whether balance billing protections apply, in provider directory systems to display participation status to members, and in network analytics to monitor participation rates across provider types and geographic areas.