Provider

Stores a calculated numeric rating assigned to a provider based on quality, performance, cost efficiency, or risk metrics within value-based care and analytics platforms. Used in network tiering decisions, pay-for-performance models, and provider benchmarking dashboards in managed care systems.

Assigns an ordinal position to a provider record within a set of related records in claims, referral, or care team data structures, such as ordering attending physicians or billing providers on a claim. Used in ETL pipelines to correctly parse and load multi-provider claim records.

The defined geographic region within which a healthcare provider or provider organization delivers clinical services to patients, used in network adequacy analysis and health plan service area compliance. Provider service areas may be defined by ZIP codes, counties, metropolitan statistical areas, or custom geographic boundaries. For health plans, the service area defines where the plan is approved to market and enroll members. Matching member ZIP codes to provider service areas is fundamental to network adequacy measurement. Healthcare data teams build provider service area tables that map provider NPI to geographic coverage zones, use service area data in GIS-based network adequacy models to calculate member access rates, and produce CMS-required service area filings demonstrating adequate provider access within the plan approved geographic footprint.

Records the specific calendar date on which a healthcare provider rendered a clinical service, as captured in EHR encounter records and claims data. Used as a primary date key in claims adjudication, encounter-level analytics, and longitudinal patient timeline construction pipelines.

Indicates the seriousness or acuity level associated with a provider's recorded clinical condition, case, or patient population in EHR and risk stratification systems. Used in care management prioritization models, clinical decision support workflows, and risk adjustment analytics pipelines.

The biological sex of a licensed healthcare provider as recorded in credentialing and provider master files. Used in provider directory management, patient-provider matching workflows, and demographic reporting to support care coordination and network adequacy assessments.

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

The medical or clinical specialty area in which a healthcare provider has training, expertise, and typically board certification, defining the scope of clinical services the provider delivers. Provider specialty encompasses both primary care specialties such as family medicine, internal medicine, and pediatrics and subspecialties such as cardiology, oncology, orthopedic surgery, and psychiatry. Specialty data drives network adequacy analysis ensuring health plans maintain sufficient specialist access for members, prior authorization rules requiring specialist referrals, and claims adjudication validating that billed procedure codes are consistent with the rendering provider specialty. Healthcare data teams maintain prvdr_spclty using NUCC Health Care Provider Taxonomy codes as the standard and link specialty data to claims, credentialing, and provider directory records.

The standardized alphanumeric code identifying a healthcare provider specialty using the NUCC Health Care Provider Taxonomy code set maintained by the National Uniform Claim Committee. Taxonomy codes are ten-character alphanumeric identifiers organized in a hierarchical structure by provider type, classification, and specialization. For example, 207R00000X identifies Internal Medicine and 207RC0000X identifies Cardiovascular Disease as a subspecialty. Providers report taxonomy codes in the NPI registry and on claims forms to communicate their specialty to payers. Healthcare data teams use prvdr_spclty_cd as the primary specialty identifier in provider master data, joining to NUCC taxonomy reference tables for specialty descriptions, and applying specialty-based claims editing rules that validate procedure code and specialty combinations for payment integrity.

A summary quality rating displayed in health plan provider directories and consumer-facing tools representing a healthcare provider overall performance on quality, patient experience, and efficiency measures, typically expressed as a one to five star scale. Provider star ratings are derived from composite quality scores and are increasingly used by health plans to implement tiered network benefit designs where members pay lower cost sharing for high-rated providers. CMS publishes hospital star ratings based on Hospital Compare quality measures and Medicare Advantage plan star ratings based on HEDIS and CAHPS measures. Healthcare data teams build provider star rating calculation pipelines that normalize quality scores across multiple measure domains, apply weighting methodologies, produce final star ratings, and integrate ratings into provider directory systems and member-facing applications to support informed provider selection decisions.

Records the effective begin date of a provider's contract, network participation, credentialing status, or care relationship in payer and EHR systems. Used by data engineers to apply SCD Type 2 logic, validate enrollment windows, and filter active provider records in claims and directory datasets.

The clock time at which a healthcare provider began rendering a service, procedure, or clinical encounter. Used in claims adjudication, scheduling systems, and encounter records to document service duration, support billing accuracy, and track provider utilization patterns.

The U.S. state or territory where a healthcare provider's practice location is physically situated or where they hold licensure. Used in claims processing, provider directory maintenance, network management, and geographic analysis of healthcare service delivery and access.

The two-character USPS state abbreviation identifying the state in which a healthcare provider primary practice location is situated and where the provider holds an active state professional license. Provider state code determines which state licensing board has jurisdiction over the provider, which state-specific scope of practice laws apply, and which state network adequacy regulations govern health plan contracting requirements. Providers practicing across state lines must hold licenses in each state of practice. Healthcare data teams use prvdr_state_cd in network adequacy analysis to segment provider supply by state, in credentialing workflows to validate state license status through primary source verification, and in claims adjudication to apply correct state-specific fee schedules and coverage rules for services rendered across state boundaries.

Indicates the current operational or credentialing state of a provider in payer, EHR, and provider directory systems, such as active, inactive, suspended, or pending. Used to filter eligible providers in claims routing, network directories, and member-facing plan data validations.

The physical street-level address of a healthcare provider's practice location or service site. Used in provider directory systems, claims processing, and network management to verify service locations, support member access reporting, and ensure accurate provider demographic records.

The drug concentration or dosage strength associated with a medication prescribed or administered by a healthcare provider. Used in pharmacy and clinical systems to document prescribing specifics, support medication reconciliation, and ensure accurate dispensing and claims adjudication.

A partial aggregated dollar amount representing a subset of charges or reimbursements associated with a specific healthcare provider within a claim, remittance, or financial report. Used in claims processing and revenue cycle management to reconcile provider-level payment components.

The National Provider Identifier of the physician or qualified practitioner who oversees the services delivered by a supervised provider such as a resident physician, student, or non-physician practitioner operating under physician supervision requirements. Medicare incident-to billing rules require direct physician supervision for services billed under the supervising physician NPI in office settings. Teaching physician rules govern supervision requirements for resident services in academic medical centers. Supervising provider identification is critical for claims compliance because incorrect use of supervising physician NPIs to bill for unsupervised services is a significant Medicare audit risk. Healthcare data teams use prvdr_supv_npi in claims editing to validate that incident-to and teaching physician supervision requirements are met, in compliance analytics to identify potentially improper supervising physician billing patterns, and in academic medical center billing workflows that require teaching physician attestation documentation.

The calendar date on which a healthcare provider performed a surgical procedure on a patient. Used in claims adjudication, surgical scheduling systems, and clinical records to document operative timelines, support utilization review, and validate procedure-related billing submissions.