ORDER_RPTD_SIG_INSTR

Description:

For each row in ORDER_RPTD_SIG_HX, this table contains the free-text instructions that were entered, if any.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	GROUP_LINE	INTEGER	No
	The line number for the information associated with the instructions for this medication.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple values associated with a specific group of instructions within this record.
4	INSTRUCTIONS	VARCHAR	No
	The additional instructions included with the medication instructions.
5	MED_USE_IDENT	VARCHAR	No
	This item stores the MGB ID for MP9.
6	MED_USE_UTC_DTTM	DATETIME (UTC)	No
	This is the effective instant of the medication use.
7	MED_USE_PERIOD	INTEGER	No
	This stores the period (amount of time in seconds) of a medication use.