DENTAL_PROC_ALTS_HX
Description:
The history of procedure alternatives for a dental procedure.

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 alternative 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 historical edits to procedure alternatives associated with the dental procedure from the DENTAL_PROCEDURE_HX table.
4 DENT_ALT_HX_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.