DENTAL_PERIO_CMT_HX_RM
Description:
This table contains the historical information for dental periodontal comments.

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 mouth finding record. Together with FINDING_ID, this forms the foreign key to the DENTAL_PERIO_CMT_HX table.
3 VALUE_LINE INTEGER No
The line number of one of the multiple periodontal comments associated with the finding and historical instant from the DENTAL_PERIO_CMT_HX table
4 DENTAL_PCMNT_HISTOR VARCHAR No
Stores the revision history of the periodontal comment for a mouth record.