DENT_TREAT_HX

Description: |
This table contains history items of changes in dental treatments.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TREATMENT_ID | 1 |
LINE | 2 |

Column Information

| 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
22 | DENTAL_MOD_INSTANT_DTTM | DATETIME (UTC) | No |
This item stores the instant when the dental TPL record was modified.
23 | DENTAL_CLIN_INSTANT_DTTM | DATETIME (UTC) | No |
This is the date and time the documentation was made for, such as when documenting past historical data.