RSLT_CULTURE_LEGACY

Description:

This table stores legacy information about microbiology culture identification results.

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	MEDIA_CONTAINER_TYPE_ID	VARCHAR	No
	The unique ID for the media plate container type associated with an observation on the culture identification.
4	MEDIA_CONTAINER_TYPE_ID_CONTAINER_TYPE_NAME	VARCHAR	No
	The name of the container type record.
5	DESCRIPTION	VARCHAR	No
	The description of an observation for the culture identification.
6	REPORT_YN	VARCHAR	No
	Indicates whether the culture identification will be reported to the patient's chart. 'Y' indicates that the culture identification will be reported. 'N' or NULL indicate that the culture identification will not be reported. May contain organization-specific values: No Category Entries: No Yes
7	CMT_MICRO_QUANTITY_C_NAME	VARCHAR	No
	The quantity category ID for the culture identification. May contain organization-specific values: Yes
8	MICRO_GENUS_C_NAME	VARCHAR	No
	The Genus category ID for the culture identification. May contain organization-specific values: Yes
9	MICRO_SPECIES_C_NAME	VARCHAR	No
	The Species category ID for the culture identification. May contain organization-specific values: Yes