npi_tax_identifier
Tax IDs associated with an NPI in claims or contract data.
Primary Key:Foreign Keys:npi=>npi_provider.npi
npi_tax_identifier_tax_identifier_idx-tax_identifier
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
npi | bigint | No | Yes | National Provider Identifier (NPI) assigned by CMS. Generated through expression: |
tax_identifier | 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: |