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.