line_item_provider

Connects a line item to a provider

Primary Key:

• line_item_id
• provider_index

Foreign Keys:

• line_item_id => line_item.line_item_id
• provider_seen_id => provider_seen.provider_seen_id

Indexes:

• line_item_provider_provider_seen_id_idx - provider_seen_id

Column	Data Type	Nullable	Indexed	Description
provider_index	smallint	No	Yes	Order of the providers found in the claim. Indexes are 0-based so the first provider in the claim will have an index of 0, second will have an index of 1 and so on. Generated through expression:
provider_seen_id	bigint	No	Yes	Snowflake ID assigned to provider seen. Generated through expression:
provider_type	entity_identifier_type	No	No	Identifies the type of entity for this record (From NM101) Generated through expression:
line_item_id	bigint	No	Yes	Link to the line item record. Generated through expression:
taxonomy	text	No	No	- Generated through expression: