DENT_EST_PROC_INFO
Description:
The DENT_EST_PROC_INFO table contains information about predetermination procedures for a billing plan.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID VARCHAR No
The unique identifier for the treatment plan 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 PROC_ID NUMERIC No
The unique ID of the procedure who is associated with the dental treatment plan. This column is frequently used to link to the CLARITY_EAP table.
4 PROC_DESC VARCHAR No
The name/description of the procedure which is associated with this dental treatment plan.
5 PROC_QTY INTEGER No
The quantity of the dental treatment procedure.
6 PROC_CHG_AMT NUMERIC No
The charge amount for the dental treatment procedure performed.
7 PROC_ENTRY_DATE DATETIME No
The date when the procedure entered into the system.
8 PROC_DELETED_YN VARCHAR No
Indicates whether a procedure is deleted for this dental treatment plan. Y indicates that the procedure is deleted. N or a null value indicates that procedure is not deleted.
May contain organization-specific values: No
Category Entries:
Yes
No
9 PROC_MODIFIER VARCHAR No
The procedure modifier used for the dental treatment procedure.
10 PROC_ENTRY_USER_ID VARCHAR No
The unique ID of the user record who entered the procedure. This column is frequently used to link to the CLARITY_EMP table.
11 PROC_ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 PROC_ENTRY_TIME DATETIME No
The time when the procedure entered into the system.
13 PROC_DEL_USER_ID VARCHAR No
The unique ID of the user record who deleted the procedure. This column is frequently used to link to the CLARITY_EMP table.
14 PROC_DEL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 PROC_DEL_DATE DATETIME No
The date when the procedure was deleted from the system.
16 PROC_DEL_TIME DATETIME No
The time when the procedure was deleted from the system.
17 PROC_TOOTH_NUM_C_NAME VARCHAR No
The number of the tooth on which procedure was performed.
May contain organization-specific values: No
Category Entries:
Tooth 1
Tooth 2
Tooth 3
Tooth 4
Tooth 5
Tooth 6
Tooth 7
Tooth 8
Tooth 9
Tooth 10
Tooth 11
Tooth 12
Tooth 13
Tooth 14
Tooth 15
Tooth 16
Tooth 17
Tooth 18
Tooth 19
Tooth 20
Tooth 21
Tooth 22
Tooth 23
Tooth 24
Tooth 25
Tooth 26
Tooth 27
Tooth 28
Tooth 29
Tooth 30
Tooth 31
Tooth 32
Tooth A
Tooth B
Tooth C
Tooth D
Tooth E
Tooth F
Tooth G
Tooth H
Tooth I
Tooth J
Tooth K
Tooth L
Tooth M
Tooth N
Tooth O
Tooth P
Tooth Q
Tooth R
Tooth S
Tooth T
Tooth 18 (FDI)
Tooth 17 (FDI)
Tooth 16 (FDI)
Tooth 15 (FDI)
Tooth 14 (FDI)
Tooth 13 (FDI)
Tooth 12 (FDI)
Tooth 11 (FDI)
Tooth 21 (FDI)
Tooth 22 (FDI)
Tooth 23 (FDI)
Tooth 24 (FDI)
Tooth 25 (FDI)
Tooth 26 (FDI)
Tooth 27 (FDI)
Tooth 28 (FDI)
Tooth 38 (FDI)
Tooth 37 (FDI)
Tooth 36 (FDI)
Tooth 35 (FDI)
Tooth 34 (FDI)
Tooth 33 (FDI)
Tooth 32 (FDI)
Tooth 31 (FDI)
Tooth 41 (FDI)
Tooth 42 (FDI)
Tooth 43 (FDI)
Tooth 44 (FDI)
Tooth 45 (FDI)
Tooth 46 (FDI)
Tooth 47 (FDI)
Tooth 48 (FDI)
Tooth 55 (FDI)
Tooth 54 (FDI)
Tooth 53 (FDI)
Tooth 52 (FDI)
Tooth 51 (FDI)
Tooth 61 (FDI)
Tooth 62 (FDI)
Tooth 63 (FDI)
Tooth 64 (FDI)
Tooth 65 (FDI)
Tooth 75 (FDI)
Tooth 74 (FDI)
Tooth 73 (FDI)
Tooth 72 (FDI)
Tooth 71 (FDI)
Tooth 81 (FDI)
Tooth 82 (FDI)
Tooth 83 (FDI)
Tooth 84 (FDI)
Tooth 85 (FDI)
Tooth UR8 (Palmer)
Tooth UR7 (Palmer)
Tooth UR6 (Palmer)
Tooth UR5 (Palmer)
Tooth UR4 (Palmer)
Tooth UR3 (Palmer)
Tooth UR2 (Palmer)
Tooth UR1 (Palmer)
Tooth UL1 (Palmer)
Tooth UL2 (Palmer)
Tooth UL3 (Palmer)
Tooth UL4 (Palmer)
Tooth UL5 (Palmer)
Tooth UL6 (Palmer)
Tooth UL7 (Palmer)
Tooth UL8 (Palmer)
Tooth LL8 (Palmer)
Tooth LL7 (Palmer)
Tooth LL6 (Palmer)
Tooth LL5 (Palmer)
Tooth LL4 (Palmer)
Tooth LL3 (Palmer)
Tooth LL2 (Palmer)
Tooth LL1 (Palmer)
Tooth LR1 (Palmer)
Tooth LR2 (Palmer)
Tooth LR3 (Palmer)
Tooth LR4 (Palmer)
Tooth LR5 (Palmer)
Tooth LR6 (Palmer)
Tooth LR7 (Palmer)
Tooth LR8 (Palmer)
Tooth URE (Palmer)
Tooth URD (Palmer)
Tooth URC (Palmer)
Tooth URB (Palmer)
Tooth URA (Palmer)
Tooth ULA (Palmer)
Tooth ULB (Palmer)
Tooth ULC (Palmer)
Tooth ULD (Palmer)
Tooth ULE (Palmer)
Tooth LLE (Palmer)
Tooth LLD (Palmer)
Tooth LLC (Palmer)
Tooth LLB (Palmer)
Tooth LLA (Palmer)
Tooth LRA (Palmer)
Tooth LRB (Palmer)
Tooth LRC (Palmer)
Tooth LRD (Palmer)
Tooth LRE (Palmer)
18 PROC_SURFACE VARCHAR No
The dental surface where the procedure was performed.
19 PROC_ARCH_C_NAME VARCHAR No
The dental surface category number for this procedure.
May contain organization-specific values: No
Category Entries:
Lower
Upper
20 PROC_QUADRANT_C_NAME VARCHAR No
The quadrant category number for this dental procedure.
May contain organization-specific values: No
Category Entries:
Lower Left
Lower Right
Upper Left
Upper Right
Whole Oral Cavity
Maxillary Area
Mandibular Area
Upper Right Sextant
Upper Anterior Sextant
Upper Left Sextant
Lower Left Sextant
Lower Anterior Sextant
Lower Right Sextant
21 PROC_AREA VARCHAR No
The dental area where the procedure was performed.
22 SUPERNUMRY_YN VARCHAR No
Indicates whether a dental procedure is supernumerary for this dental treatment plan. Y indicates that the procedure is supernumerary. N or a null value indicates that procedure is not supernumerary.
May contain organization-specific values: No
Category Entries:
Yes
No
23 PROC_FINDING_ID NUMERIC No
Links the dental treatment plan record to any corresponding dental procedure records that were pulled from to create it.