DENT_TREAT_FIND_HIST_RM

Description:

This table extracts the dental treatment historical findings.

Primary Key

Column Name	Ordinal Position
TREATMENT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	TREATMENT_ID	NUMERIC	No
	The unique identifier for the treatment plan record
2	GROUP_LINE	INTEGER	No
	The line number of the historical instant in the treatment record. Together with TREATMENT_ID, this forms the foreign key to the DENTAL_TPL_HX table.
3	VALUE_LINE	INTEGER	No
	The line number for one of the multiple findings associated with the treatment and the historical instant from the DENTAL_TPL_HX table
4	TR_FINDINGS_HX_ID	NUMERIC	No
	stores revision history of findings within a treatment