provider_seen_match
The list of providers that may be a match with the information in the provider_seen row
Primary Key:Foreign Keys:npi=>npi_provider.npiprovider_seen_id=>provider_seen.provider_seen_id
provider_seen_match_npi_idx-npiprovider_seen_match_provider_seen_id_idx-provider_seen_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
provider_seen_id | bigint | No | Yes | Link to the provider seen record. |
npi | bigint | No | Yes | The National Provider Indentifier 10 digit code. |
match_percent | numeric | Yes | No | Percent of match to provider information. |
match_metadata | jsonb | Yes | No | Information about what matches between provider and provider_seen record |