SPEC_ATTACHED_DOC
Description:
A table to store information relating to documents attached to a specimen.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier for the specimen 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 SPEC_ATTCHD_DCS_ID VARCHAR No
This item links to document records which are attached to the specimen.
4 SPEC_ATTACHED_CMTS VARCHAR No
This item stores comments associated with document records attached to the specimen.