DENT_BLEED_SUPP_LOC_HX

Description:

This table contains the history of the location of documentation for bleeding and suppuration findings.

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 bleeding or suppuration finding record. Together with FINDING_ID, this forms the foreign key to the DENTAL_FINDING_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple locations associated with the finding and the historical instant from the DENTAL_FINDING_HX table
4	DENT_BL_SU_LOC_HX_C_NAME	VARCHAR	No
	Stores the historical values of the locations where bleeding or suppuration findings were noted. May contain organization-specific values: Yes Category Entries: Facial Distal Facial Facial Mesial Lingual Mesial Lingual Lingual Distal Facial Side Lingual Side