|
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 |
|
|
