RSLT_ORDERS

Description:

This table contains information about orders associated with result records.

Primary Key

Column Name	Ordinal Position
RESULT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RESULT_ID	VARCHAR	No
	The unique identifier (.1 item) for the result 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	SOURCE_ORDER_ID	NUMERIC	No
	The unique ID of the source order for the result. For tests that have been redrawn or moved, this is the removed order. For tests that have not be redrawn or removed, this is an order that the current result for the test will file to. This is the culture order for susceptibility tests. Anatomic pathology results may have multiple source orders.