V_EHI_ELEM_VAL_PREV_CAPTION

Description:

This view contains the historical captions for SmartData element values.

Primary Key

Column Name	Ordinal Position
HLV_ID	1
UPDATE_NUM	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	HLV_ID	NUMERIC	No
	The unique identifier (.1 item) for the value record.
2	UPDATE_NUM	INTEGER	No
	This column groups together rows of data that were stored together. A higher UPDATE_NUM means a more recent update.
3	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
4	PREVIOUS_CAPTION	VARCHAR	No
	This column stores the previous captions for SmartData element values.