DENTAL_REFERRAL_HX

Description: |
The DENTAL_REFERRAL_HX table contains the audit history of the dental referral status (Referred, Completed, Removed) of a specified dental referral order over time, also noting the encounter and timestamp of the change.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier (.1 item) for the order 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 | DENTAL_REFERRAL_DAT | VARCHAR | No |
This item stores the patient encounter DAT in which the dental order associated with a referral was modified.
4 | DENTAL_RFL_MOD_INST_UTC_DTTM | DATETIME (UTC) | No |
This item stores the instant when the status of an order associated with a dental referral was modified.
5 | DENT_REFERRAL_STATUS_HX_C_NAME | VARCHAR | No |
This item keeps track of how the status of a dental referral changes over time.
May contain organization-specific values: No
Category Entries:
Referred
Completed
Removed