DENTAL_FINDING_HX

Description: |
This table contains the history of edits for a dental finding record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique identifier for the finding record
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | DENTAL_PATIENT_CSN | NUMERIC | No |
Stores the patient encounter in which a particular contact of the record was modified if it was available.
4 | DENTAL_MOD_USER_ID | VARCHAR | No |
Stores the user who modified a piece of dental data in the finding record.
5 | DENTAL_MOD_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | DENTAL_MOD_INSTANT_DTTM | DATETIME (Attached) | No |
Stores the date and time when a piece of dental data in the finding record was modified
7 | DEN_FIND_STAT_HIS_C_NAME | VARCHAR | No |
The history of the finding's status (unaddressed, resolved, removed, etc.)
May contain organization-specific values: No
Category Entries:
Addressed
Unaddressed
Resolved
Removed
Addressed Today
Auto Resolved Untoggled
8 | TOO_FIND_TYPE_H_C_NAME | VARCHAR | No |
Stores the history of the finding type of a tooth-level finding
May contain organization-specific values: No
Category Entries:
PARL
Needs Extraction
Caries
Fracture
Impacted
Monitor
Defective Restoration
Bleeding
Suppuration
Mobility
Furcation
Plaque
Calculus
Retained Root
Tooth Wear
Missing
Other
9 | DENT_CHRON_INSTANT_DTTM | DATETIME (Attached) | No |
This is the date and time the documentation was made for, such as when documenting past historical data.
10 | CARIES_CLASS_HIST_C_NAME | VARCHAR | No |
The history of the finding's caries classification
May contain organization-specific values: Yes
Category Entries:
I
II
III
IV
V
VI
E1
E2
D1
D2
D3
C1
C2
11 | CARIES_DEPTH_HIST | NUMERIC | No |
The history of the finding's caries depth
12 | DENT_FUR_CLASS_HX_C_NAME | VARCHAR | No |
This item stores the history of the severity of furcation documented on a tooth.
May contain organization-specific values: Yes
Category Entries:
Class I
Class II
Class III
Class IV
13 | DENT_MOB_CLASS_HX_C_NAME | VARCHAR | No |
This item stores the history of a tooth's mobility classification, which is its severity of mobility.
May contain organization-specific values: Yes
Category Entries:
Class I
Class II
Class III
14 | CARIES_INCIP_HX_C_NAME | VARCHAR | No |
The history of whether a caries finding is incipient
May contain organization-specific values: Yes
Category Entries:
Not Incipient
Incipient
15 | DENTAL_MOD_INST_DTTM | DATETIME (UTC) | No |
This item stores the instant when the dental RES record was modified.
16 | DENTAL_CLIN_INSTANT_DTTM | DATETIME (UTC) | No |
This is the date and time the documentation was made for, such as when documenting past historical data.
17 | DENT_PERIFIND_SEVERITY_C_NAME | VARCHAR | No |
This item tracks the history of the level of severity for a periodontal finding. It contains the periodontal finding severity category ID for the finding.
May contain organization-specific values: Yes
Category Entries:
Slight
Moderate
Severe