claim_provider

Connects a claim to one or more providers

Primary Key:

• claim_id
• provider_index

Foreign Keys:

• claim_id => claim.claim_id
• provider_chosen_by => login.login_id
• provider_npi_chosen => npi_provider.npi
• provider_seen_id => provider_seen.provider_seen_id

Indexes:

• claim_provider_claim_id_idx - claim_id
• claim_provider_provider_chosen_by_idx - provider_chosen_by
• claim_provider_provider_npi_chosen_idx - provider_npi_chosen
• claim_provider_provider_seen_id_idx - provider_seen_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
provider_index	smallint	No	Yes	-
provider_seen_id	bigint	No	Yes	-
provider_type	entity_identifier_type	No	No	Identifies the type of entity for this record (From NM101)
tpa_tax_id_suffix	text	No	No	-
tpa_provider_type	text	No	No	-
tpa_specialty_code	text	No	No	-
taxonomy	text	No	No	-
foreign_currency	text	No	No	-
provider_npi_chosen	bigint	Yes	Yes	-
provider_chosen_at	date	Yes	No	-
provider_chosen_by	bigint	Yes	Yes	-