SMRTDTA_ELEM_HISTORY

Description:

This table is a bridge between history context SmartData element values and the source patient history contacts.

Primary Key

Column Name	Ordinal Position
HLV_ID	1

Column Information

	Name	Type	Discontinued?
1	HLV_ID	NUMERIC	No
	The unique identifier (.1 item) for the value record.
2	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for the patient encounter contact that is associated with the SmartData element value. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
3	PAT_ID	VARCHAR	No
	The unique ID of the linked patient record that is associated with the SmartData element value.
4	ELEMENT_ID	VARCHAR	No
	The SmartData identifier (SDI) for this row.