DENTAL_PROC_MODIFIERS_HX

Description:

This table extracts the history of changes to a dental procedure's modifiers.

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 (.1 item) for the finding record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated procedure modifier edit history in the dental procedure record. Together with FINDING_ID, this forms the foreign key to the DENTAL_PROCEDURE_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the procedure modifier histories associated with the dental procedure from the DENTAL_PROCEDURE_HX table.
4	DENTAL_PROC_HX_MODIFIER_ID	VARCHAR	No
	This item contains the history of procedure modifiers associated with a dental procedure. These procedure modifiers allow users to add additional details to their dental procedures.
5	DENTAL_PROC_HX_MODIFIER_ID_MODIFIER_NAME	VARCHAR	No
	The name of the modifier record.