ELEM_VAL_PREV

Description:

Contains information about previous values and comments for a SmartData element value.

Primary Key

Column Name	Ordinal Position
HLV_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HLV_ID	NUMERIC	No
	The unique identifier (.1 item) for the value record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	PREV_INSTANT_DTTM	DATETIME (Local)	No
	Instant of edit of previous smartdata element value or comment
4	PREV_USERS	VARCHAR	No
	previous user to set value or comment
5	PREV_SRC_NOTE_ID	VARCHAR	No
	The unique ID of the note that the previous value is attached to.
6	PREV_NOTE_STATUS_C_NAME	VARCHAR	No
	The status of the previous note. May contain organization-specific values: Yes Category Entries: Incomplete Signed Addendum Deleted Revised Cosigned Finalized Unsigned Cosign Needed Incomplete Revision Cosign Needed Addendum Shared
7	PREV_UTC_DTTM	DATETIME (UTC)	No
	The previous UTC instants at which this SDE was documented
8	PREV_VALUE_INVLD_YN	VARCHAR	No
	Indicate a previous value to be invalid. May contain organization-specific values: No Category Entries: No Yes