RES_COMPONENTS_SNOMED

Description:

This table stores the SNOMED code for the component value or antibiotic received from the external system.

Primary Key

Column Name	Ordinal Position
RESULT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	RESULT_ID	VARCHAR	No
	The unique identifier (.1 item) for the result record.
2	GROUP_LINE	INTEGER	No
	The line number of the result component in the result.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple SNOMED codes associated with the result and result component from the RES_COMPONENTS table.
4	SNOMED_CODE	VARCHAR	No
	The SNOMED code for the component value or antibiotic received from an external system.