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. Generated through expression: |
name_last_or_organization | text | No | Yes | - Generated through expression: |
name_first | text | No | Yes | - Generated through expression: |
name_middle | text | No | Yes | - Generated through expression: |
name_prefix | text | No | Yes | - Generated through expression: |
name_suffix | text | No | Yes | - Generated through expression: |
credential | text | No | Yes | One or more credentials supplied by the provider to show their skill and experience. Generated through expression: |
title_or_position | text | No | Yes | - Generated through expression: |
name_type | npi_name_type | No | No | - Generated through expression: |
first_seen_date | date | Yes | No | First date that the name was seen Generated through expression: |
last_seen_date | date | Yes | No | Most recent date that the name was seen Generated through expression: |
gender_or_sex | gender_or_sex_type | Yes | Yes | - Generated through expression: |
is_from_pecos | boolean | No | No | Set to true when the data was found in PECOS Generated through expression: |
is_from_nppes | boolean | No | No | Set to true when the data was found in NPPES Generated through expression: |
is_from_claims | boolean | No | No | Set to true when the data was found in claims Generated through expression: |