npi_phone
Phone number(s) associated with a provider
Primary Key:Foreign Keys:npi=>npi_provider.npiphone_id=>phone.phone_id
npi_phone_phone_id_idx-phone_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. |
phone_id | bigint | No | Yes | Link to the phone record. |
is_from_pecos | boolean | No | No | Identifies whether the data was found in PECOS |
is_from_nppes | boolean | No | No | Identifies whether the data was found in NPPES |
is_from_claims | boolean | No | No | Identifies whether the data was found in claims |
first_seen_date | date | Yes | No | First date that the phone was seen |
last_seen_date | date | Yes | No | Most recent date that the phone was seen |