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. Generated through expression: |
phone_id | bigint | No | Yes | Link to the phone record. Generated through expression: |
is_from_pecos | boolean | No | No | Identifies whether the data was found in PECOS Generated through expression: |
is_from_nppes | boolean | No | No | Identifies whether the data was found in NPPES Generated through expression: |
is_from_claims | boolean | No | No | Identifies whether the data was found in claims Generated through expression: |
first_seen_date | date | Yes | No | First date that the phone was seen Generated through expression: |
last_seen_date | date | Yes | No | Most recent date that the phone was seen Generated through expression: |