ADV_EVT_SUPPLY_HISTORY

Description:

This table contains the history of this adverse event's related supplies. Together with ADV_EVT_SUPPLY_ATTR_HISTORY, these tables contain the history of an adverse event's supply attributions.

Primary Key

Column Name	Ordinal Position
ADVERSE_EVENT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	ADVERSE_EVENT_ID	NUMERIC	No
	The unique identifier for the adverse event record.
2	GROUP_LINE	INTEGER	No
	The line number of the adverse event history in the adverse event record. Together with ADVERSE_EVENT_ID, this forms the foreign key to the ADVERSE_EVENT_HISTORY table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple supply records that is related to the adverse event at the time the adverse event was documented.
4	HX_ITEM_ID	VARCHAR	No
	The unique ID of the supply record that is related to the adverse event at the time the adverse event was documented.
5	HX_ITEM_ID_SUPPLY_NAME	VARCHAR	No
	The name of the inventory item.