RES_MICRO_SUSC

Description:

This table contains susceptibility results, including antibiotics and interpretations. RES_MICRO_CULTURE can be linked to this table by linking RES_MICRO_SUSC.CULTURE_ID to RES_MICRO_CULTURE.RESULT_ID and RES_MICRO_SUSC.UNIQUE_ORGANISM_ID to RES_MICRO_CULTURE.LINE.

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	SUSC_ANTIBIOTIC_ID	NUMERIC	No
	The component being tested
4	SUSC_ANTIBIOTIC_ID_NAME	VARCHAR	No
	The name of the component.
5	SUSC_VALUE	VARCHAR	No
	The value for this component
6	SUSC_ANTI_UNITS_C_NAME	VARCHAR	No
	Stores the antibiotic unit May contain organization-specific values: Yes
7	SUSC_INTERPRETATN_C_NAME	VARCHAR	No
	Holds the antibiotic's susceptibility interpretation. May contain organization-specific values: Yes
8	SUSC_TEST_METH_ID	VARCHAR	No
	The testing method for this component
9	SUSC_TEST_METH_ID_METHOD_NAME	VARCHAR	No
	The name of the instrument interface, method, method grouper, or middle tier interface record.
10	SUSC_ANTI_CMT_C_NAME	VARCHAR	No
	Item to store category-based antibiotic comments. This data is moved to Component multiline user comment pointer (OVR-51202) and Multiline user comment storage (OVR-52202). May contain organization-specific values: Yes
11	SUSC_REPORTED_C_NAME	VARCHAR	No
	The category number that indicates whether the component is reported for this result. May contain organization-specific values: No Category Entries: No Yes Value Interpretation
12	UNIQUE_ORGANISM_ID	INTEGER	No
	A number used to uniquely identify the organism this susceptibility test is for. To retrieve information about the associated organism, join RES_MICRO_SUSC.UNIQUE_ORGANISM_ID with RES_MICRO_CULTURE.LINE and RES_MICRO_SUSC.CULTURE_ID with RES_MICRO_CULTURE.RESULT_ID.
13	CULTURE_ID	VARCHAR	No
	The unique ID of the associated culture test's current result record.
14	SUSC_MTD_LNC_ID	NUMERIC	No
	The unique ID of the LOINC record for the susceptibility method on the result that is reported by the external resulting agency.
15	COMP_ACCREDITED_YN	VARCHAR	No
	This item determines the accreditation status of the corresponding component. If set to Y-Yes, the corresponding component is accredited. If set to N-No, the corresponding component is not accredited. If null, no evaluation was performed on the component to determine if it is accredited or not. May contain organization-specific values: No Category Entries: No Yes