Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
(2) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Specimen table |
 ![Foreign Keys FK_Specimen_RequisitionID_Requisition_ID: [dbo].[Requisition].RequisitionID Foreign Keys FK_Specimen_RequisitionID_Requisition_ID: [dbo].[Requisition].RequisitionID](../../../../Images/fk.png) | RequisitionID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Requisition. Link to Requisition.ID |
  | SpecimenTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Specimen Type. Link to Specimen_Type_DE.ID |
 | SpecimenNumberExt | varchar(40) | 40 | NOT NULL | | ('') | External Specimen number |
| CurrentCollectedDTTM | datetime | 8 | NOT NULL | | ('') | Last updated Collection Date and Time |
| CurrentCollectedByID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Last updated Collected by. Link to IDX_User.ID |
| ChargeID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Collection Charge. Link to Charge.ID |
| ChargeOrderActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Order Charge was created under. Link to Order_Activity_Header.ID |
 | SpecimenIdentifier | varchar(255) | 255 | NOT NULL | | ('') | SpecimenIdentifier value from the Specimen Collection Dialog |