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.
entity_type	npi_entity_type	Yes	No	Indicates whether the provider is an individual or an organization (from NM102).
group_type	npi_group_type	Yes	No	-
is_sole_proprietor	boolean	Yes	No	-
created_date	date	Yes	No	-
last_modified_date	date	Yes	No	-
deactivation_date	date	Yes	No	-
reactivation_date	date	Yes	No	-
current_primary_practice_location	bigint	Yes	No	-
current_secondary_practice_locations	bigint[]	Yes	No	-
current_mailing_address	bigint	Yes	No	-