line_item_compound_ingredient

Lists ingredients used in a compound drug mixture.

Primary Key:

• line_item_id
• ingredient_index

Foreign Keys:

• line_item_id => line_item.line_item_id

Indexes:

• line_item_compound_ingredient_uq (Unique) - line_item_id, product_service_code

Column	Data Type	Nullable	Indexed	Description
line_item_id	bigint	No	Yes	Links to the line item record Generated through expression:
ingredient_index	smallint	No	Yes	Defines the order of ingredients found in the claim (from NCPDP 447-EC) Generated through expression:
product_service_code_qualifier	product_service_code_type	No	No	Indicates the type of code used to identify the product included in the compound mixture (from NCPDP 488-RE) Generated through expression:
product_service_code	text	No	Yes	Identifies the product included in the compound mixture (from NCPDP 489-TE) Generated through expression:
ingredient_quantity	numeric	No	No	Amount of the product included in the compound mixture (from NCPDP 448-ED) Generated through expression:
ingredient_cost	numeric	Yes	No	Cost of the product included in the compound mixture (from NCPDP 449-EE) Generated through expression:
ingredient_cost_basis	rx_ingredient_cost_basis_type	Yes	No	Method by which the cost of the ingredient was calculated (from NCPDP 490-UE) Generated through expression:
ingredient_modifier_codes	text[]	No	No	Codes indicating special circumstances related to dispensing or paying for the product (up to 10) (from NCPDP 363-2H) Generated through expression: