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:

• npi

Column	Data Type	Nullable	Indexed	Description
npi	bigint	No	Yes	National Provider Identifier (NPI) assigned by CMS. Generated through expression:
entity_type	npi_entity_type	Yes	No	Indicates whether the provider is an individual or an organization (from NM102). Generated through expression:
group_type	npi_group_type	Yes	No	- Generated through expression:
is_sole_proprietor	boolean	Yes	No	- Generated through expression:
created_date	date	Yes	No	- Generated through expression:
last_modified_date	date	Yes	No	- Generated through expression:
deactivation_date	date	Yes	No	- Generated through expression:
reactivation_date	date	Yes	No	- Generated through expression:
current_primary_practice_location	bigint	Yes	No	- Generated through expression:
current_secondary_practice_locations	bigint[]	Yes	No	- Generated through expression:
current_mailing_address	bigint	Yes	No	- Generated through expression: