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.
7	SYN_SOURCE_RES_SYNOPTIC_ID	NUMERIC	No
	Pointer from an extracted synoptic result to the source synoptic result
8	SYN_EXTRACT_ST_C_NAME	VARCHAR	No
	The status of the synoptic result extraction request May contain organization-specific values: No Category Entries: Validation Only Submitted Received Results Applied Results Failed
9	SYN_RESULT_TYPE_C_NAME	VARCHAR	No
	The type of synoptic form result this record represents May contain organization-specific values: No Category Entries: Result AI