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 NUMERIC No
The department that a treatment is created for.
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 VARCHAR No
Stores the provider that is considered the owner of the dental treatment. This is used for reporting and scheduling.
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
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