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
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 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