ORDER_REACTIVATION_HX

Description: |
Order reactivation details. Includes information regarding the discontinue (e.g. discontinue user, discontinue reason, etc).

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 | REACT_USER_ID | VARCHAR | No |
The unique identifier of the user that reactivated the order.
4 | REACT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | REACT_DTTM | DATETIME (UTC) | No |
The instant the order was reactivated.
6 | REACT_REASON_C_NAME | VARCHAR | No |
The reactivation reason category ID for the order.
May contain organization-specific values: Yes
7 | REACT_DC_USER_ID | VARCHAR | No |
The unique identifier for the user that discontinued the order.
8 | REACT_DC_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | REACT_DC_DTTM | DATETIME (UTC) | No |
The instant the order was discontinued.
10 | REACT_DC_REASON_C_NAME | VARCHAR | No |
The discontinue reason category ID for the order.
May contain organization-specific values: Yes
11 | REACT_DC_ENC | NUMERIC | No |
The patient encounter the order was discontinued in.
12 | REACT_COMMENTS | VARCHAR | No |
Comments entered when the order was reactivated.
13 | REACT_DC_END_DATE | DATETIME | No |
The end date specified when the order was discontinued.
14 | REACT_DC_END_TIME | DATETIME (Local) | No |
The end time specified when the order was discontinued.
15 | REACT_DC_CSN_ID | NUMERIC | No |
The unique contact serial number (CSN) of the discontinue encounter. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
16 | REACT_PHARMACY_ID | NUMERIC | No |
The unique identifier for the owning pharmacy of the order when it was reactivated.
17 | REACT_PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.