[SO/URSA-CORE] Primary Care Providers

Object Description

One record per primary care provider or provider group.

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)
  • 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 Fraction of Clinician Office Visits with Preventive Care
  • Is Primary Care Specialty Code
  • Is Provider Description Specific to Primary Care

Foreign Keys

• affiliated_prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id