npi_name
Names associated with a provider
Foreign Keys:npi=>npi_provider.npi
npi_name_name_last_or_organization_idx-name_last_or_organizationnpi_name_uq(Unique) -npi,name_last_or_organization,name_first,name_middle,name_prefix,name_suffix,gender_or_sex,title_or_position,credential
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. |
name_last_or_organization | text | No | Yes | - |
name_first | text | No | Yes | - |
name_middle | text | No | Yes | - |
name_prefix | text | No | Yes | - |
name_suffix | text | No | Yes | - |
credential | text | No | Yes | One or more credentials supplied by the provider to show their skill and experience. |
title_or_position | text | No | Yes | - |
name_type | npi_name_type | No | No | - |
first_seen_date | date | Yes | No | First date that the name was seen |
last_seen_date | date | Yes | No | Most recent date that the name was seen |
gender_or_sex | gender_or_sex_type | Yes | Yes | - |
is_from_pecos | boolean | No | No | Set to true when the data was found in PECOS |
is_from_nppes | boolean | No | No | Set to true when the data was found in NPPES |
is_from_claims | boolean | No | No | Set to true when the data was found in claims |