[SO/URSA-CORE] Primary Care Providers

  • Published on Apr 10, 2026
  • 1 minute(s) read
Prev Next

Object Description

One record per primary care individual or organizational provider. Includes certain primary-care-focused facilities (such as Rural Health Clinics and FQHCs).

Metadata

  • Table Name: ursa.so_ursa_core_prov_001
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Single Stack
  • Temporal Class: Entity
  • Case ID: Provider ID
  • Primary Key: Provider ID

Published Fields

  • Data Model Keys

    • Provider ID -- The database identifier for a individual or organization provider. (See also [URSA-CORE] Provider)
    • Affiliated Provider Group Provider ID -- The provider group the individual provider is employed by or otherwise affiliated with. (See also [URSA-CORE] Provider Group)

  • Provider Fields

    • Provider NPI
    • Is Individual Provider -- Indicates that the provider is an individual, rather than an organization. (See also [URSA-CORE] Provider)
    • Is Provider Group -- A type of organizational provider that employs individual providers; in some cases, patients may be administratively assigned to a provider groups rather than individual providers.
    • Provider Description
    • Primary NUCC Provider Taxonomy Code -- The 10-character National Uniform Claim Committee (NUCC) provider taxonomy code designated as the primary scope of practice in the referenced provider's entry in the National Provider Identifier (NPI) registry. Typically identifies an individual provider's primary specialty, or an organizational provider's facility type.
    • Primary NUCC Provider Taxonomy Description -- The natural language description of the provider's Primary NUCC Provider Taxonomy Code. (See also [URSA-CORE] Primary NUCC Provider Taxonomy Code)
    • Practice Address State Abbreviation
    • Practice Address ZIP Code 5-Digit

  • Encounter Fields

    • Provider Fraction of Clinician Office Visits with Preventive Care
    • Provider Count of Clinician Office Visits
    • Provider Count of Preventive Care Clinician Office Visits

  • Validation Only Fields

    • Is Qualifying Designated Primary Care Provider
    • Is Qualifying Primary Care Provider Taxonomy Code
    • Is Qualifying Primary RHC Provider
    • Is Qualifying Provider Description
    • Is Qualifying History of Preventive Care Rendered
    • Is Qualifying Primary FQHC Provider

Foreign Keys

  • affiliated_prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id