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_PROC_NAME | VARCHAR | No |
The name of each procedure.
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.