DENT_SDE_HLV_AUD_LN_RM

Description:

This table extracts the concept value audit line 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_AUDLN_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple concept value (HLV) audit lines associated with the finding, procedure, or tooth record and the historical instant from the DENT_SDE_HLV_AUDLN_HX table.
4	DENT_SDE_HLV_AUD_LN	INTEGER	No
	This column extracts the concept value audit line history for dental SmartData elements that link to this finding record.