SYNOPTIC_RESULT_MAIN

Description:

This table contains synoptic information for a patient or a requisition grouper.

Primary Key

Column Name	Ordinal Position
SYNOPTIC_ID	1

Column Information

	Name	Type	Discontinued?
1	SYNOPTIC_ID	NUMERIC	No
	The unique identifier for the synoptic result record.
2	SYNOPTIC_NAME	VARCHAR	No
	The name of the synoptic result record.
3	SPECIMEN_LIST	VARCHAR	No
	Stores a string of specimen names for this synoptic result record.
4	REC_STATUS_C_NAME	VARCHAR	No
	The deletion status category ID for the synoptic result. May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
5	SYN_EPT_PAT_ID	VARCHAR	No
	The patient associated with this synoptic result.
6	SYN_RQG_PAT_RECORD_ID	NUMERIC	No
	The requisition grouper associated with this synoptic result.