SpecimenCounts

tblSpecimenCounts contains counts for various specimen categories added in version 4.0.

SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen SpmnCategoryID, integer, 2 bytes, identifier for the category Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1") LastUpdate, smalldatetime, date and time of last update ModifiedBy, integer, 2 bytes, UserID of the signon that made the change