npi_provider
The details about a provider. There will always be exactly one npi_provider row per provider but there may be many locations etc.
Primary Key:| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | - |
entity_type | npi_entity_type | Yes | No | Indicates whether the provider is an individual or an organization (from NM102). |
gender_or_sex | gender_or_sex_type | Yes | No | - |
parent_organization_name | text | No | No | - |
group_type | npi_group_type | Yes | No | - |
is_sole_proprietor | boolean | No | No | - |
created_date | date | No | No | - |
last_modified_date | date | No | No | - |
deactivation_date | date | No | No | - |
reactivation_date | date | No | No | - |