DENTAL_FINDING_NOADD
Description:
This table contains the items for dental finding records.

Primary Key
Column Name Ordinal Position
FINDING_ID 1

Column Information
Name Type Discontinued?
1 FINDING_ID NUMERIC No
The unique identifier for the finding record
2 DEN_TOO_FIND_TYPE_C_NAME VARCHAR No
Indicates the type of finding, such as caries, fracture, etc.
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
3 FINDING_STAT_NOAD_C_NAME VARCHAR No
The current status the finding's status (unaddressed, resolved, removed, etc.) of the dental finding
May contain organization-specific values: No
Category Entries:
Addressed
Unaddressed
Resolved
Removed
Addressed Today
Auto Resolved Untoggled
4 DENTAL_CARIES_CLS_C_NAME VARCHAR No
Stores the caries classification of a caries finding
May contain organization-specific values: Yes
Category Entries:
I
II
III
IV
V
VI
E1
E2
D1
D2
D3
C1
C2
5 DENTAL_CARIES_DEPTH NUMERIC No
Stores the caries depth of a caries finding
6 DENTAL_MOBI_CLASS_C_NAME VARCHAR No
Stores information about the severity of mobility documented on a tooth.
May contain organization-specific values: Yes
Category Entries:
Class I
Class II
Class III
7 DENTAL_FURC_CLASS_C_NAME VARCHAR No
Stores information about the severity of furcation documented on a tooth.
May contain organization-specific values: Yes
Category Entries:
Class I
Class II
Class III
Class IV
8 DENT_CARIES_INCIP_C_NAME VARCHAR No
This columns specifies the incipiency of a caries finding.
May contain organization-specific values: Yes
Category Entries:
Not Incipient
Incipient
9 DENT_FND_OVR_NAME VARCHAR No
This item specifies the display name that will be used when users document a finding. If populated, this will be used in place of the finding type (I RES 17407) to describe the finding.