ORD_MED_USER_ADMIN

Description:

This table contains user-entered administration instructions. This information is already contained as a part of the table ORD_MED_ADMININSTR so this table does not have to be extracted.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for order (ORD) master file records in this table and cannot be used to link to CLARITY_MEDICATION.rd.
2	LINE	INTEGER	No
	The line number for each user-entered administration instruction line.
3	MED_USER_ADMN_INSTR	VARCHAR	No
	User-entered admin instructions converted to plain text. This item (I ORD 7226) replaces the functionality of I ORD 7220 for entering/changing admin instructions. I ORD 7220 is still used for displaying the admin instructions and is updated automatically from this item.
4	ORDERING_DATE	DATETIME	No
	The date the order was placed in calendar format.