|
Name |
Type |
Discontinued? |
|
| 1 |
TREATMENT_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the treatment plan record |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
TPL_MOD_INSTANT_DTTM |
DATETIME (Local) |
No |
|
|
|
| Stores date and time for when the dental treatment was modified. |
|
|
| 4 |
TPL_MOD_USER_ID |
VARCHAR |
No |
|
|
|
| User who modifies data in a treatment record |
|
|
| 5 |
TPL_MOD_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 6 |
TR_LINKED_CSN |
NUMERIC |
No |
|
|
|
| Stores the patient encounter in which a particular piece of the treatment record was modified if it was available. |
|
|
| 7 |
TR_COMP_INST_HIST_DTTM |
DATETIME (Local) |
No |
|
|
|
| Stores the revision history for the completed date and time of a treatment |
|
|
| 8 |
TR_STATUS_HX_C_NAME |
VARCHAR |
No |
|
|
|
| stores the revision history of treatment status |
| May contain organization-specific values: No |
| Category Entries: |
| Planned |
| Completed |
| Canceled |
| Draft |
| Discontinued |
|
|
| 9 |
TR_START_DATE_HIST_DT |
DATETIME |
No |
|
|
|
| stores the revision history for start date for a treatment |
|
|
| 10 |
TR_ORDER_NUM_HX |
INTEGER |
No |
|
|
|
| stores revision history of sequence number of a treatment |
|
|
| 11 |
DENT_SER_HX_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. |
|
|
| 12 |
TREAT_CHRON_INSTANT_DTTM |
DATETIME (Attached) |
No |
|
|
|
| This column records the date and time of a documentation change to the dental treatment. |
|
|
| 13 |
DENT_OPT_STAT_HX_C_NAME |
VARCHAR |
No |
|
|
|
| The history of changes to the status of a treatment option within a dental treatment. |
| May contain organization-specific values: No |
| Category Entries: |
| Selected |
| Unselected |
| Removed |
|
|
| 14 |
DENT_HB_ESTIMATE_YN |
VARCHAR |
No |
|
|
|
| This flag indicates whether the an estimate was calculated for the dental treatment option at a given time. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 15 |
DENT_HB_GUARANTOR_ID |
NUMERIC |
No |
|
|
|
| The guarantor used when calculating estimates for the dental treatment option. This only applies to Hospital Billing (HB) estimates. |
|
|
| 16 |
DENT_HB_PRIMARY_CVG_ID |
NUMERIC |
No |
|
|
|
| The primary coverage used when calculating the dental treatment option's estimate. This only applies to Hospital Billing (HB) estimates. |
|
|
| 17 |
TR_APRV_DTTM_HX_DTTM |
DATETIME (Attached) |
No |
|
|
|
| The revision history for the date and time when the treatment was approved. |
|
|
| 18 |
TR_APRV_USER_HX_ID |
VARCHAR |
No |
|
|
|
| The revision history containing the unique ID for the user who approved the treatment. |
|
|
| 19 |
TR_APRV_USER_HX_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 20 |
TR_APRV_STATUS_HX_C_NAME |
VARCHAR |
No |
|
|
|
| The revision history of the approval status category ID for the treatment. |
| May contain organization-specific values: No |
| Category Entries: |
| Unapproved |
| Submitted |
| Approved |
| Rescinded |
| Modified after Approval |
|
|
| 21 |
TR_RSCND_RSN_HX_C_NAME |
VARCHAR |
No |
|
|
|
| The revision history for the rescind reason category ID for the treatment. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Approved in Error |
| Change in Patient Condition |
|
|
