npi_match_hash

Text hash used for finding possible providers for matching.

Primary Key:

• hash
• npi

Foreign Keys:

• npi => npi_provider.npi

Indexes:

• npi_match_hash_hash_idx - hash
• npi_match_hash_npi_idx - npi

Column	Data Type	Nullable	Indexed	Description
npi	bigint	No	Yes	National Provider Identifier (NPI) assigned by CMS. Generated through expression:
hash	text	No	Yes	A text key used for fuzzy matching with other providers. Generated through expression: