LAB_CASE_SNOMED

Description:

The LAB_CASE_SNOMED table stores SNOMED related information for case (REQ) records.

Primary Key

Column Name	Ordinal Position
REQUISITION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REQUISITION_ID	NUMERIC	No
	The unique identifier for the case 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	SNOMED_CUI	VARCHAR	No
	The unique SNOMED SmartData Identifier (HLX-40) for the Lexicon master file that is stored on this case.
4	CODE_SEL_METHOD_C_NAME	VARCHAR	No
	The code selection method category number for the SNOMED code stored on the case. May contain organization-specific values: No Category Entries: Manual Synoptic Automatic Specimen Source Automatic Result Component Automatic
5	SNOMED_CODE	VARCHAR	No
	Stores the actual SNOMED code on the case for reporting purposes.
6	SOURCE_TEST	VARCHAR	No
	Holds the tests selected for the source result during automatic SNOMED code generation.