npi_address
A provider's address.
Primary Key:Checks:npi_address_check-(is_unknown_address_type = (NOT (is_primary_practice_location OR is_secondary_practice_location OR is_mailing_address)))
address_id=>address_seen.address_idnpi=>npi_provider.npi
npi_address_address_id_idx-address_idnpi_address_npi_idx-npi
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | - Generated through expression: |
address_id | bigint | No | Yes | - Generated through expression: |
is_mailing_address | boolean | No | No | Identifies whether the address is a mailing address Generated through expression: |
is_primary_practice_location | boolean | No | No | Identifies whether the address is a primary practice location Generated through expression: |
is_secondary_practice_location | boolean | No | No | Identifies whether the address is a secondary practice location Generated through expression: |
is_unknown_address_type | boolean | No | No | Indicates we do not know the address type. Used for addresses seen only in Doctors and Clinicians data, where address types are not provided. 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 | - Generated through expression: |
last_seen_date | date | Yes | No | - Generated through expression: |