npi_affiliate
Information about NPI's that are related to another NPI in some way.
Primary Key:Foreign Keys:npi=>npi_provider.npinpi=>npi_provider.npi
npi_affiliate_npi_idx-npi
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. |
affiliate_npi | bigint | No | Yes | Affiliate NPI. |
affiliate_type | npi_affiliate_type | No | No | - |
affiliation_documentation | text | No | No | Documentation for how the npi and affiliate_npi are related. This can include a URL, document a phone call, etc. |
is_from_pecos | boolean | No | No | Identifies when the data was found in PECOS |
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 |
first_seen_date | date | No | No | - |
last_seen_date | date | No | No | - |