HSC_SPEC_COMMENTS

Description:

Holds the specimen comments

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	This column holds the record ID of the specimen record to which the comments belong.
2	LINE	INTEGER	No
	This column holds the line number corresponding to the line of comment. (A comment may be split up into multiple lines depending on the length of the comment).
3	COMMENTS	VARCHAR	No
	This column stores the free text comments written for specimen collection.