DENTAL_PERIO_LOCATION_HX

Description: |
This table contains information about the location of documentation for past periodontal data.

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