[SO/URSA-PHARM] Medication Dispensing Providers

Object Description

One record per pharmacy provider or non-pharmacy dispensing provider, based on primary NUCC provider taxonomy code and/or including any provider listed as a filling provider on a pharmacy claim.

Metadata

• Table Name: ursa.so_ursa_pharm_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)

• Date Fields

  • Last Filled Date
  • First Filled Date

• Provider Fields

  • Provider NPI
  • Provider Description
  • Is Filling Provider Major Chain
  • Filling Provider Major Chain 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 Line 1
  • Practice Address Line 2
  • Practice Address City
  • Practice Address State Abbreviation
  • Practice Address ZIP Code 5-Digit

• Validation Only Fields

  • Provider Count Fills for Specialty Medication According to Plan

• Module Fields

  • Provider Count Fills
  • Is Specialty Pharmacy
  • Is Mail Order Pharmacy
  • Provider Fill Volume Percentile Rank
  • Provider Fill Volume Quintile Category

Foreign Keys

• prov_id → ursa.no_ursa_core_prov_001.prov_id