npi_tax_id
Tax IDs associated with an NPI in claims or contract data.
Primary Key:Foreign Keys:npi=>npi_provider.npi
npi_tax_id_tax_id_idx-tax_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. Generated through expression: |
tax_id | text | No | Yes | Employer Identification Number (EIN) or Social Security Number (SSN) assigned by the IRS. Generated through expression: |
is_from_transparency_data | boolean | No | No | Identifies when the data was found in Transparency in Coverage or Transparency in Pricing data Generated through expression: |
is_from_claims | boolean | No | No | Identifies when the data was found in claims Generated through expression: |
first_seen_date | date | No | No | First date that the tax ID was seen Generated through expression: |
last_seen_date | date | No | No | Most recent date that the tax ID was seen Generated through expression: |