PEND_DISCON_ORD_HX

Description:

This table contains history of information about pending discontinued orders.

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	PEND_DISC_ACTION_C_NAME	VARCHAR	No
	The category number for the pending discontinue action for the order. - 1 means the order is still pending discontinued. May contain organization-specific values: No Category Entries: D/C Accepted Pending D/C D/C Rejected
4	PEND_DISCON_USER_ID	VARCHAR	No
	The user who entered pend discontinue for the order.
5	PEND_DISCON_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	PEND_DISC_REASON_C_NAME	VARCHAR	No
	The category number for the reason for discontinue entered by the user who pend discontinued the order. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID). May contain organization-specific values: Yes
7	PEND_DISC_INST_DTTM	DATETIME (Local)	No
	Instant at which order was marked as pending discontinued.
8	PEND_DISC_VERBAL_LN	INTEGER	No
	This column stores the line index for the Verbal Order Type Flag item in the order record(SI ORD 34800). It tells which line of data in the Verbal Order Type Flag corresponds to the lines of data in the Pending Discontinue Action item (SI ORD 34892). (SIGNED_TYPE_C column in tables ORDER_SIGNED_MED and PRDER_SIGNED_PROC).
9	PEND_DC_RES_USER_ID	VARCHAR	No
	User who took action, i.e., verified or rejected the pending discontinued order.
10	PEND_DC_RES_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
11	PENDDC_RES_INS_DTTM	DATETIME (Local)	No
	Instant at which an the pending discontinued order was accepted or rejected.