Tables [dbo].[Specimen]
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Indexes Nix_Specimen_ID, TWstat_Specimen_ID(2)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Specimen table
Cluster Key CIX_PK_Specimen_RequisitionID_SpecimenTypeDE: RequisitionID\SpecimenTypeDEForeign Keys FK_Specimen_RequisitionID_Requisition_ID: [dbo].[Requisition].RequisitionIDRequisitionID[dbo].[uniqueid]9NOT NULL(0)Requisition. Link to Requisition.ID
Cluster Key CIX_PK_Specimen_RequisitionID_SpecimenTypeDE: RequisitionID\SpecimenTypeDEIndexes TWstat_Specimen_SpecimenTypeDESpecimenTypeDE[dbo].[dict_id]5NOT NULL(0)Specimen Type. Link to Specimen_Type_DE.ID
Indexes TWstat_Specimen_SpecimenNumberExtSpecimenNumberExtvarchar(40)40NOT NULL('')External Specimen number
CurrentCollectedDTTMdatetime8NOT NULL('')Last updated Collection Date and Time
CurrentCollectedByID[dbo].[uniqueid]9NOT NULL(0)Last updated Collected by. Link to IDX_User.ID
ChargeID[dbo].[uniqueid]9NOT NULL(0)Collection Charge. Link to Charge.ID
ChargeOrderActivityHeaderID[dbo].[uniqueid]9NOT NULL(0)Order Charge was created under. Link to Order_Activity_Header.ID
Indexes Nix_Specimen_IDSpecimenIdentifiervarchar(255)255NOT NULL('')SpecimenIdentifier value from the Specimen Collection Dialog