pecos_opt_out
Information about providers who have chosen to opt out of Medicare
Primary Key:Foreign Keys:address_id=>address_seen.address_idnpi=>npi_provider.npispecialty_type=>pecos_specialty_type_lookup.specialty_type_code
pecos_opt_out_address_id_idx-address_idpecos_opt_out_specialty_type_idx-specialty_type
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier |
name_last | text | No | No | Last name |
name_first | text | No | No | First / given name |
address_id | bigint | No | Yes | Pointer to the address of the provider |
specialty_type | text | No | Yes | Provider's primary specialty |
effective_date | date | No | Yes | Begin date of opt out |
end_date | date | No | No | End date of opt out |