SYN_SPECIMEN

Description:

This table stores the specimens associated with the synoptic result record.

Primary Key

Column Name	Ordinal Position
SYNOPTIC_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SYNOPTIC_ID	NUMERIC	No
	The unique identifier for the synoptic 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	SPECIMEN_ID	VARCHAR	No
	The unique identifier of the specimen record associated with this synoptic result.