[NO/URSA-CORE] Providers

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
  • Affiliated Health System ID
  • Practice Location ID
  • Document ID
  • 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
  • Primary Billing TIN
  • Provider CCN
  • Is Individual Provider
  • Is Provider Group
  • 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
  • Primary NUCC Provider Taxonomy Description
  • Is Active Provider
  • Is Designated Primary Care Provider
  • Is Designated 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