RES_MICRO_WORKUP

Description:

This table contains data for microbiology workup results.

Primary Key

Column Name	Ordinal Position
RESULT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RESULT_ID	VARCHAR	No
	The unique ID of 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	WORKUP_ISOLATE	NUMERIC	No
	Stores unique organism identifier (CUID) of the isolate for each line.
4	WORKUP_PLATE_C_NAME	VARCHAR	No
	Plate tested for each line. May contain organization-specific values: Yes
5	WORKUP_COMP_ID	NUMERIC	No
	Component tested for each line.
6	WORKUP_COMP_ID_NAME	VARCHAR	No
	The name of the component.