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
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier Generated through expression: |
name_last | text | No | No | Last name Generated through expression: |
name_first | text | No | No | First / given name Generated through expression: |
address_id | bigint | No | No | Pointer to the address of the provider Generated through expression: |
specialty_type | text | No | No | Provider's primary specialty Generated through expression: |
effective_date | date | No | Yes | Begin date of opt out Generated through expression: |
end_date | date | No | No | End date of opt out Generated through expression: |