IP_FS_ORD_IX_ID

Description:

This table stores the orders associated with a flowsheet row in a multiple-response format for easier reporting.

Primary Key

Column Name	Ordinal Position
INPATIENT_DATA_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	INPATIENT_DATA_ID	VARCHAR	No
	The unique ID of the inpatient data record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated order ID stored in a flowsheet row in this inpatient data record. Together with INPATIENT_DATA_ID, this forms the foreign key to the IP_FLOWSHEET_ROWS table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple order IDs stored in a flowsheet row that is associated with the inpatient data record and the order ID from the IP_FLOWSHEET_ROWS table.
4	IX_FLOW_RW_ORD_ID	NUMERIC	No
	The unique IDs of the orders that are added to this patient's flowsheet row. This is a multiple-response item.