npi_name
Names associated with a provider
Foreign Keys:npi=>npi_provider.npi
npi_name_npi_idx-npinpi_name_npi_last_name_first_name_middle_name_name_prefix_n_idx(Unique) -npi,last_name,first_name,middle_name,name_prefix,name_suffix,credential,title_or_position,organization_name,name_type
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | - |
last_name | text | No | Yes | - |
first_name | text | No | Yes | - |
middle_name | text | No | Yes | - |
name_prefix | text | No | Yes | - |
name_suffix | text | No | Yes | - |
credential | text | No | Yes | - |
title_or_position | text | No | Yes | - |
organization_name | text | No | Yes | - |
name_type | npi_name_type | No | Yes | - |
first_seen_date | date | No | No | - |
last_modified_date | date | No | No | - |