ORD_NESTED_OSQS

Description:

Contains nested panel information where each line represents one level of nesting.

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	NESTED_PANEL_ID	NUMERIC	No
	Stores a list of OSQ IDs representing the nested panels from which an order was placed.
4	NESTED_PANEL_CONTACT_DATE_REAL	NUMERIC	No
	Stores a list of grouped orders (OSQ) contact dates (DATs) corresponding to the nested (group within group) OSQ IDs.
5	NESTED_PANEL_UNIQ_KEY	VARCHAR	No
	Stores a list of "panel info"s corresponding to the OSQ IDs above, which uniquely identify identical nested OSQs placed in the same ordering session.
6	NESTED_GROUP_ID	NUMERIC	No
	For orders from clinical pathways (a method of placing many orders that are meant to take place over a period of time all at once), stores a list of TRG IDs representing the groups of orders which contain other groups of orders from which the order originated.
7	NESTED_GROUP_CSN	NUMERIC	No
	Stores a list of Patient Order Groups and Treatment Days (TRG) Contact Serial Numbers (CSN) associated with the above TRG IDs.