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