DENT_TREATMENT
Description:
This contains dental treatment plan information which is not expected to change over time.

Primary Key
Column Name Ordinal Position
TREATMENT_ID 1

Column Information
Name Type Discontinued?
1 TREATMENT_ID NUMERIC No
The unique identifier for the treatment plan record
2 DENTAL_TYPE_C_NAME VARCHAR No
Type of dental treatment
May contain organization-specific values: No
Category Entries:
Treatment
Procedure-Only
Subtemplate
Treatment Trigger
Procedure-Only Trigger
3 COMPLETED_DTTM_DTTM DATETIME (Local) No
Date and time the dental treatment was completed
4 TR_STATUS_NOADD_C_NAME VARCHAR No
This keeps track of the latest status of a treatment.
May contain organization-specific values: No
Category Entries:
Planned
Completed
Canceled
Draft
Discontinued
5 DENTAL_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
6 TR_SUG_START_DATE DATETIME No
The suggested start date for a treatment.
7 TR_SEQUENCE_NUM INTEGER No
Keep track of relative orders for a treatment within a treatment plan
8 DENTAL_TREAT_SER_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 DENT_PARENT_TRMT_ID NUMERIC No
This points to the parent treatment of which this treatment is part.
10 DENT_OPTION_STAT_C_NAME VARCHAR No
The status of an option for treatment within a dental treatment.
May contain organization-specific values: No
Category Entries:
Selected
Unselected
Removed
11 DENTAL_ESTIMATE_ID NUMERIC No
The linked patient estimate record detailing cost information for the procedures in this treatment.
12 TR_APRV_DTTM DATETIME (Attached) No
The date and time when the dental treatment was last approved.
13 TR_APRV_USER_ID VARCHAR No
The user who last approved the treatment.
14 TR_APRV_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 TR_APRV_STATUS_C_NAME VARCHAR No
The approval status category ID for the treatment.
May contain organization-specific values: No
Category Entries:
Unapproved
Submitted
Approved
Rescinded
Modified after Approval
16 TR_RESCIND_RSN_C_NAME VARCHAR No
The rescind reason category ID for the treatment.
May contain organization-specific values: Yes
Category Entries:
Approved in Error
Change in Patient Condition