RES_MICRO_CULTURE

Description:

This table contains information about microbiology culture 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	CULTURE_GENUS_C_NAME	VARCHAR	No
	The genus of an organism. This is a low-level taxonomic rank used in the biological classification of organisms May contain organization-specific values: Yes
4	CULTURE_REPORT_ORG_YN	VARCHAR	No
	Indicates whether or not an organism should be reported. Y indicates that the organism will be reported. A null value or an N indicates that the organism will not be reported. May contain organization-specific values: No Category Entries: No Yes
5	CULTURE_SPECIES_C_NAME	VARCHAR	No
	The species of an organism. Species are the basic taxonomic units of biological classification. May contain organization-specific values: Yes
6	CULTURE_QUANTITY_C_NAME	VARCHAR	No
	Quantity of bacteria found May contain organization-specific values: Yes
7	CULTURE_ORG_WRKCD_ID	VARCHAR	No
	The unique ID of the organism workcard.
8	CULTURE_CFU_QNTY	VARCHAR	No
	Enter the quantity of bacteria found
9	BACT_UNITS_C_NAME	VARCHAR	No
	The bacterial units category number for the isolate. May contain organization-specific values: Yes
10	CULTURE_ABNRML_C_NAME	VARCHAR	No
	Abnormality of the organism May contain organization-specific values: Yes Category Entries: Normal
11	CUR_ACTION_ID	NUMERIC	No
	The current workcard action for each isolate.
12	CUR_ACTION_ID_RECORD_NAME	VARCHAR	No
	The name of the node record.
13	CULT_ORG_ID	NUMERIC	No
	The unique record ID of the organism that was identified on this line of the result.
14	CULT_ORG_ID_NAME	VARCHAR	No
	The name of the organism.
15	CULT_RSLTD_INS_DTTM	DATETIME (Local)	No
	The isolate result instant received from an instrument interface or from manual result entry.
16	USR_OVRD_CUL_REP_ID	VARCHAR	No
	The unique ID associated with the user record responsible for overriding reportable flag of an organism. This column is frequently used to link to the CLARITY_EMP table.
17	USR_OVRD_CUL_REP_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
18	CULT_INSTR_PROF_IDENT	VARCHAR	No
	Stores the network concept identifier associated with the isolate's resulting method at the time of resulting or verification.