DENT_SDE_HLV_HX_RM

Description:

This table extracts concept value history for dental SmartData elements that link to a finding, procedure or tooth record.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier for the finding record
2	GROUP_LINE	INTEGER	No
	The line number of the historical instant in the finding, procedure, or tooth record. Together with FINDING_ID, this forms the foreign key to the DENT_SDE_HLV_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple concept value (HLV) records associated with the finding, procedure, or tooth record and the historical instant from the DENT_SDE_HLV_HX table.
4	DENT_SDE_HLV_ID	NUMERIC	No
	This column extracts the concept value record ID for a SmartData element.