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 Name | Type | Description |
|---|---|---|---|
| 1 | schedule_id | string | Unique identifier for each fee schedule |
| 2 | npi_number | string | National Provider Identifier |
| 3 | tin_value | string | Tax Identification Number |
| 4 | tin_type | string | Type of TIN (EIN or NPI) |
| 5 | business_name | string | Provider or organization business name |
| 6 | network_name | string | Insurance network name |
| 7 | imputed_ein | string | Inferred organization EIN |
| 8 | imputed_ein_name | string | Organization name for imputed EIN |
| 9 | imputed_ein_source | string | Method used to determine imputed EIN |
| 10 | npi_last_or_org_name | string | Provider last name or organization name from NPI registry |
| 11 | npi_first_name | string | Provider first name from NPI registry |
| 12 | npi_taxonomy_code | string | Healthcare provider taxonomy classification |
| 13 | npi_state | string | Provider location state |
| 14 | date_key | string | Data snapshot date (Partition key) |
| 15 | network_slug | string | Standardized network identifier (Partition key) |
| 16 | payer_slug | string | Standardized payer identifier (Partition key) |
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 Numbernpi- National Provider Identifier
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 datanpi1_crosswalk- EIN was matched using NPI Type 1 (individual provider) crosswalknpi2_crosswalk- EIN was matched using NPI Type 2 (organization) crosswalk