npi_other_identifier
Other identifiers of a provider.
Primary Key:Foreign Keys:npi=>npi_provider.npi
npi_other_identifier_identifier_idx-identifier
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. |
identifier | text | No | Yes | An identifier assigned to a provider by some 3rd party. |
identifier_type | npi_identifier_type | No | Yes | - |
state_code | text | No | Yes | The 2-character state code where the identifier was issued. |
issuer | text | No | Yes | The name of the organization who issued the identifier. |
first_seen_date | date | No | No | First date that the other identifier was seen |
last_seen_date | date | No | No | Most recent date that the other identifier was seen |
is_from_nppes | boolean | No | No | Identifies when the data was found in NPPES |
is_from_claims | boolean | No | No | Identifies when the data was found in claims |