OVERRIDE_TIME_HX

Description: |
The OVERRIDE_TIME_HX table contains information about order override time history.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier 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 | IP_OVRD_TM_BY_ID | VARCHAR | No |
The unique ID of the user who adjusted the times or schedule. If the times or schedule are adjusted and then the order is verified, it will contain the ID of the user who verified the order.
4 | IP_OVRD_TM_BY_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | OVRD_UPD_AT_TM | DATETIME (Local) | No |
This is the instant at which the times for the order were set. If the times were adjusted and then the order was verified, the instant the order was verified will be stored.
6 | OVRD_TIMES | VARCHAR | No |
Stores the override scheduled times for the order if the order has a specified frequency.
7 | OVRD_INST_NS_TM | DATETIME (Local) | No |
Stores the override schedule time for orders with a non-specified frequency.
8 | OVRD_REASON_C_NAME | VARCHAR | No |
Stores the override reason for adjusting the medication administration times.
May contain organization-specific values: Yes
9 | IP_OVRDTM_SRCDEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
10 | MLSIG_PERIOD_AND_PART | VARCHAR | No |
Stores multiline sig period and part the override data came from