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.