npi_license

Provider licensing data.

Primary Key:

• npi
• license_number
• state_code

Foreign Keys:

• npi => npi_provider.npi

Indexes:

• npi_license_license_number_idx - license_number

Column	Data Type	Nullable	Indexed	Description
npi	bigint	No	Yes	National Provider Identifier (NPI) assigned by CMS. Generated through expression:
license_number	text	No	Yes	License number assigned to the provider. Generated through expression:
state_code	text	No	Yes	2 character state code that the license number was issued in. Generated through expression:
first_seen_date	date	No	No	First date that the license was seen Generated through expression:
last_seen_date	date	No	No	Most recent date that the license was seen Generated through expression:
is_from_nppes	boolean	No	No	Identifies when the data was found in NPPES Generated through expression:
is_from_claims	boolean	No	No	Identifies when the data was found in claims Generated through expression: