ORDER_RX_RPT_HX

Description:

This table is used to extract history of report information for each order. From the table, you could find out when the label is printed.

Primary Key

Column Name	Ordinal Position
ORDER_MED_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_MED_ID	NUMERIC	No
	The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION.
2	LINE	INTEGER	No
	The line number for each report printed for the order.
3	REPORT_USER_ID	VARCHAR	No
	The unique identifier of the unique action user.
4	REPORT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.