line_item_provider

Connects a line item to a provider

Primary Key:

• claim_id
• claim_line_item_index
• provider_index

Foreign Keys:

• claim_id => line_item.claim_id, claim_line_item_index => line_item.claim_line_item_index
• provider_chosen_by => login.login_id
• provider_npi_chosen => npi_provider.npi
• provider_seen_id => provider_seen.provider_seen_id

Indexes:

• line_item_provider_claim_id_claim_line_item_index_idx - claim_id, claim_line_item_index
• line_item_provider_provider_chosen_by_idx - provider_chosen_by
• line_item_provider_provider_npi_chosen_idx - provider_npi_chosen
• line_item_provider_provider_seen_id_idx - provider_seen_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
claim_line_item_index	smallint	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)
provider_npi_chosen	bigint	Yes	Yes	-
provider_chosen_at	date	Yes	No	-
provider_chosen_by	bigint	Yes	Yes	-