Skip to main content

​
Overview

The Providers table contains information about healthcare provider organizations, including demographic and organizational details.

​
Table Columns

Each column in the Providers table is described below with examples of the data it contains.

​
Column Descriptions

Detailed descriptions and examples for each column will be provided below.

​
schedule_id

Type: string Unique identifier for each fee schedule in the system. Each schedule_id represents a specific payer’s fee schedule file. Example Values:

​
npi_number

Type: string National Provider Identifier (NPI), a unique 10-digit identification number issued to healthcare providers in the United States. Example Values:

​
tin_value

Type: string Tax Identification Number (TIN) associated with the provider or provider organization. This is typically an Employer Identification Number (EIN) used for billing purposes. Example Values:

​
tin_type

Type: string Indicates the type of Tax Identification Number provided in the tin_value field. This field has only two possible values representing the source of the tax identification. Possible Values:
  • ein - Employer Identification Number
  • npi - National Provider Identifier
Example Values:

​
business_name

Type: string The business or legal name of the provider or provider organization as reported in the payer’s fee schedule file. This can be an individual provider’s name or an organization name. Example Values:

​
network_name

Type: string The name of the insurance network or plan under which the provider participates. This identifies the specific network tier or plan type within a payer’s offerings. Each network name represents a distinct plan configuration or tier offered by the payers. Example Values:

​
imputed_ein

Type: string Employer Identification Number (EIN) that has been imputed or inferred for the provider organization. This is used to group providers that belong to the same organization when direct EIN information may not be available in the source data. Example Values:

​
imputed_ein_name

Type: string The organization name associated with the imputed_ein. This represents the business name of the organization that has been matched or inferred through the imputation process. Example Values:

​
imputed_ein_source

Type: string Indicates the method or source used to determine the imputed_ein value. This field has three possible values, each representing a different data matching methodology. Possible Values:
  • direct - EIN was directly available in the source data
  • npi1_crosswalk - EIN was matched using NPI Type 1 (individual provider) crosswalk
  • npi2_crosswalk - EIN was matched using NPI Type 2 (organization) crosswalk
Example Values:

​
npi_last_or_org_name

Type: string The last name of an individual provider or the organization name, as registered in the National Provider Identifier (NPI) registry. For individual providers, this is typically the last name; for organizational providers, this is the organization’s legal name. Example Values:

​
npi_first_name

Type: string The first name of an individual provider, as registered in the National Provider Identifier (NPI) registry. This field is only populated when the NPI represents an individual provider (Type 1 NPI), and will be null for organizational providers (Type 2 NPI). Example Values:

​
npi_taxonomy_code

Type: string The Healthcare Provider Taxonomy Code associated with the provider’s NPI. This is a unique 10-character alphanumeric code that classifies the provider’s type, classification, and area of specialization. Each taxonomy code represents a specific healthcare provider specialty or service type. Example Values:

​
npi_state

Type: string The state or location where the provider is registered in the NPI registry. This can include US states (both abbreviations and full names), US territories, Canadian provinces, and international locations. Example Values:

​
date_key

Type: string The date representing when the data was processed or loaded into the system. This field is used as a partition key for data organization and querying efficiency. Currently represents a single snapshot date for the available data set. Example Values:

​
network_slug

Type: string A standardized identifier for the insurance network. This slug is used for consistent referencing and filtering of network data across the system. The slug typically includes the payer identifier and network name. Each network slug represents a unique network configuration within the available payers. Example Values:

​
payer_slug

Type: string A standardized identifier for the insurance payer. This slug is used for consistent referencing and filtering of payer data across the system. Each slug represents one of the major insurance payers currently available in PriceMedic’s data set. Example Values: