LNO_LAB_RESULTS

Description:

This table contains lab result, test, order, and specimen information associated with result reports.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the LNO 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	RESULT_ID	VARCHAR	No
	The unique identifier of the result on the report.
4	TEST_ID_TEST_NAME	VARCHAR	No
	The name of the test record.
5	ORDER_ID	NUMERIC	No
	The unique ID of the order records that are associated with the report.
6	SPECIMEN_ID	VARCHAR	No
	These are the specimens on the report.
7	SUSC_PREF_LINE	INTEGER	No
	Stores the line in related group LNO 51266 that holds which susceptibility tests in the order were reported to the submitter recipient.