[NO/URSA-CORE] Providers

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

Object Description

One record per individual or organization provider; includes provider organization staff that are only indirectly involved in the provision of care to patients, such as receptionists, back office staff, and technology professionals. Includes active and inactive providers.

Metadata

  • Table Name: ursa.no_ursa_core_prov_001
  • Layer: NATURAL_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)
    • Affiliated Health System ID -- The health system ID for the parent health system the reference entity is affiliated with. (See also [URSA-CORE] Health System ID)
    • Practice Location ID -- The internal database identifier (used, e.g., for joins and primary keys) for the practice location. (See also [URSA-CORE] Practice Location)
    • Document ID -- The internal database identifier (used, e.g., for joins and primary keys) for the document. (See also [URSA-CORE] Document)
    • Source ID -- The identifier for the original source data system from which the current record originated.

  • Source Local Keys

    • Source Local Provider ID -- The original value in the source system for the current record's Provider ID. (See also [URSA-CORE] Provider ID)

  • Operations Support Fields

    • Provider Operational ID

  • Provider Fields

    • Provider NPI
    • Provider TIN -- A provider's own Tax Identification Number (TIN). Typically only applicable for organizational providers; for individual providers, Provider TIN should only be used if the TIN is also their SSN. (For individual providers billing under a dedicated organizational TIN, the Primary Billing TIN concept should be used to capture that value.)
    • Primary Billing TIN -- The Tax Identification Number (TIN) typically used by a provider for billing and related administrative purposes; in particular, the Primary Billing TIN need not be that provider's own TIN. (In contrast, an individual or organizational provider's own TIN would be considered their Provider TIN.)
    • Provider CCN
    • 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
    • Provider First Name
    • Provider Middle Name
    • Provider Middle Initial
    • Provider Last Name
    • Provider Name Suffix
    • Provider Credentials
    • Provider Date of Birth
    • Is Provider Sex Female
    • Is Provider Sex Male
    • 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)
    • Is Active Provider -- Indicates the provider is currently designated in the relevant administrative system as actively treating patients. Typically only used for individual providers, not organizational providers.
    • Is Designated Primary Care Provider -- Indicates that a provider, either an individual or an organization, has been administratively designated -- e.g., in a plan registry -- as a primary care provider.
    • Is Designated Specialty Care Provider -- Indicates that a provider, either an individual or an organization, has been administratively designated -- e.g., in a plan registry -- as a specialty care provider.
    • Affiliated Provider Group Description
    • Affiliated Provider Group NPI
    • Affiliated Provider Group TIN
    • Practice Address Line 1
    • Practice Address Line 2
    • Practice Address City
    • Practice Address State Abbreviation
    • Practice Address ZIP Code 5-Digit
    • Provider Phone
    • Provider Fax
    • Provider Email

  • Metadata Fields

    • Record Last Updated Datetime -- The date and time the current record was last updated in the original data source.
    • Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)
    • Random Integer 1 to 1000

  • Validation Only Fields

    • Is Invalid NPI Length
    • Is Potential Non-NPI Identifier
    • Is NPI Missing from NPPES Reference Data

Terms

  • Provider: An individual or organization involved in the provision of care to patients; includes provider organization staff that are only indirectly involved in the provision of care, such as receptionists, back office staff, and technology professionals.

Dedicated Precursors

  • [NO/URSA-CORE] Providers, Precursor 1 (All Source Records): One record per individual or organizational provider