|
Name |
Type |
Discontinued? |
|
| 1 |
FINDING_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the finding record |
|
|
| 2 |
DENTAL_EAP_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
| The name of each procedure. |
|
|
| 3 |
DENTAL_COMP_INST_DTTM |
DATETIME (Attached) |
No |
|
|
|
| Date and time dental procedure was completed |
|
|
| 4 |
DENTAL_PROC_STAT_C_NAME |
VARCHAR |
No |
|
|
|
| Current status of the dental procedure |
| May contain organization-specific values: No |
| Category Entries: |
| Planned |
| Completed |
| Canceled |
| Planning |
| Discontinued |
|
|
| 5 |
DENTAL_PROC_ARCH_C_NAME |
VARCHAR |
No |
|
|
|
| Identifies which arch the dental procedure is for. |
| May contain organization-specific values: No |
| Category Entries: |
| Upper |
| Lower |
|
|
| 6 |
DENTAL_QUADRANT_C_NAME |
VARCHAR |
No |
|
|
|
| Identifies which quadrant the dental procedure is for. |
| May contain organization-specific values: No |
| Category Entries: |
| Upper Right |
| Upper Left |
| Lower Left |
| Lower Right |
|
|
| 7 |
DENTAL_PROC_VISIT_ID |
NUMERIC |
No |
|
|
|
| Identifies the visit in which a dental procedure is planned to be completed. |
|
|
| 8 |
DENTAL_COMP_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 |
DEN_PROC_EX_FLAG_YN |
VARCHAR |
No |
|
|
|
| Indicates whether a procedure existed as part of the patient's presenting condition. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 10 |
DENTAL_TOOTH_AREA_C_NAME |
VARCHAR |
No |
|
|
|
| This determines the part of the tooth that a procedure or finding affects. |
| May contain organization-specific values: No |
| Category Entries: |
| Root |
| Surface |
| Crown |
| Full Tooth |
|
|
| 11 |
DENT_PLAN_VISIT_NUM |
INTEGER |
No |
|
|
|
| Identifies the visit number that a procedure is being planned for. |
|
|
| 12 |
DENTAL_BILL_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. |
|
|
| 13 |
DENT_PLAN_PRL_ID |
NUMERIC |
No |
|
|
|
| Stores the treatment template that will be used when the user creates a treatment plan for the dental procedure |
|
|
| 14 |
DENT_PLAN_PRL_ID_PROTOCOL_NAME |
VARCHAR |
No |
|
|
|
| The SmartSet/Protocol record name. This is different from the display name, which is stored in CL_PRL_SS_OT.DISPLAY_NAME. |
|
|
| 15 |
DENT_PROC_BY_RULE_YN |
VARCHAR |
No |
|
|
|
| Indicates whether a procedure is added by auto-treatment planning rule. |
| The category values for this column were already listed for column: DEN_PROC_EX_FLAG_YN |
|
|
| 16 |
DENTAL_PROC_IMP_ID |
VARCHAR |
No |
|
|
|
| Stores implant record ID linked to a dental procedure. |
|
|
| 17 |
DENTAL_PROSTH_ID |
VARCHAR |
No |
|
|
|
| Stores the unique identifier for a multi-tooth prosthetic structure. This is only used in Finland. |
|
|
| 18 |
DENTAL_PROC_AREA_C_NAME |
VARCHAR |
No |
|
|
|
| Specifies the area of the oral cavity that a dental procedure is performed on. |
| May contain organization-specific values: No |
| Category Entries: |
| Entire oral cavity |
| Maxillary arch |
| Mandibular arch |
| Upper right quadrant |
| Upper left quadrant |
| Lower left quadrant |
| Lower right quadrant |
|
|
| 19 |
DENTAL_LNKED_ORD_ID |
NUMERIC |
No |
|
|
|
| This column contains the linked order record for a dental procedure. |
|
|
| 20 |
DENTAL_PROC_NOTE_ID |
VARCHAR |
No |
|
|
|
| ID of the note (HNO) record that serves as this dental procedure's Completion Details note |
|
|
| 21 |
DENTAL_TRIG_PROC_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
| The name of each procedure. |
|
|
| 22 |
DENT_PROC_SUBSTATUS_C_NAME |
VARCHAR |
No |
|
|
|
| Subcategorization of a dental procedure |
| May contain organization-specific values: Yes |
|
|
| 23 |
DENTAL_LINKED_BRIDGE_PROC |
NUMERIC |
No |
|
|
|
| The procedure (RES) ID that indicates which bridge this dental procedure forms a part of. All of the procedures that are in the same bridge have the same value for this column. |
|
|
| 24 |
DEN_SRC_PROTOCOL_ID |
NUMERIC |
No |
|
|
|
| The SmartSet this result came from |
|
|
| 25 |
DEN_SRC_PROTOCOL_ID_PROTOCOL_NAME |
VARCHAR |
No |
|
|
|
| The SmartSet/Protocol record name. This is different from the display name, which is stored in CL_PRL_SS_OT.DISPLAY_NAME. |
|
|
| 26 |
D_SS_PRL_SRC_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Result came from PRL OrderSet, PRL SmartSet, or PRL Template |
| May contain organization-specific values: No |
| Category Entries: |
| ORDER SET |
| SMARTSET |
| QUICK LIST |
| Dental Template |
|
|
| 27 |
DENT_SRC_PRL_DAT |
VARCHAR |
No |
|
|
|
| The DAT of the SmartSet as applied to the patient |
|
|
| 28 |
DENT_PROC_AREA_INACTIVE_YN |
VARCHAR |
No |
|
|
|
| Determines if a non-tooth level procedure should be considered active and displayed on tooth chart |
| The category values for this column were already listed for column: DEN_PROC_EX_FLAG_YN |
|
|
| 29 |
DENT_PRL_INST_DTTM |
DATETIME (Local) |
No |
|
|
|
| The Instant the Procedure was created from a PRL template |
|
|
| 30 |
DENT_REPL_PROSTH_YN |
VARCHAR |
No |
|
|
|
| Whether or not the dental procedure is a replacement prosthesis. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 31 |
DENT_REPL_PROSTH_DATE |
DATETIME |
No |
|
|
|
| The date of prior placement of a prosthesis procedure. |
|
|
