The SPEC_DERIVED_SPECIMENS table contains information related to the source specimen and other details relevant to the derived specimen. One line represents one source specimen of this derived specimen.
Primary Key
Column Name
Ordinal Position
SPECIMEN_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
SPECIMEN_ID
VARCHAR
No
The unique identifier (.1 item) 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
CM_PHY_OWNER_ID
VARCHAR
No
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.