|
Name |
Type |
Discontinued? |
|
| 1 |
TX_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the transaction record. |
|
|
| 2 |
TOOTH_NUM_C_NAME |
VARCHAR |
No |
|
|
|
| The tooth number category ID for the charge. |
| 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) |
|
|
| 3 |
ARCH_C_NAME |
VARCHAR |
No |
|
|
|
| Displays the dental arch used for the procedure. The value displayed will be either Upper or Lower. |
| May contain organization-specific values: No |
| Category Entries: |
| Lower |
| Upper |
|
|
| 4 |
QUADRANT_C_NAME |
VARCHAR |
No |
|
|
|
| Displays the dental quadrant used for the procedure. The value displayed could be one of several options, such as Lower Left or Maxillary Area. |
| 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 |
|
|
| 5 |
AREA |
VARCHAR |
No |
|
|
|
| Displays the dental area used for the procedure. The displayed value will be a range of teeth. For example 1-2,10-B, or A-B. |
|
|
| 6 |
SUPERNUMERARY_YN |
VARCHAR |
No |
|
|
|
| Indicates whether multiple teeth are present in the socket. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 7 |
FOLLOW_UP_MONTHS |
INTEGER |
No |
|
|
|
| The number of months after which this procedure requires follow-up. |
|
|
| 8 |
HYGIENIST_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
| The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
| 9 |
TREATMENT_PLAN_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the treatment plan used in this procedure. |
|
|
| 10 |
FOLLOW_UP_DATE |
DATETIME |
No |
|
|
|
| Displays the date the recall must be made by. |
|
|
| 11 |
DENTAL_CHG_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates what type of orthodontic or predetermination charge it is. |
| May contain organization-specific values: No |
| Category Entries: |
| Visit Charge |
| Periodic Charge |
| Initial Charge |
| Predetermination Charge |
| Banding Charge |
|
|
| 12 |
DENTAL_PREAUTH_AMT |
NUMERIC |
No |
|
|
|
| The amount that gets set on predetermination claims for the predetermination dental charge. |
|
|
| 13 |
DENTAL_PREAUTH_QTY |
INTEGER |
No |
|
|
|
| The quantity that gets set on predetermination claims for the predetermination dental charge. |
|
|
| 14 |
CHARGING_PLAN_LINE |
INTEGER |
No |
|
|
|
| The line of the dental charging plan that led to the charge being dropped. |
|
|
