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.