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.