Specimens
From Species File Help
tblSpecimens contains information about specimens.
SpecimenID, integer, 4 bytes, identifier for specimen TaxonNameID, integer, 4 bytes, = tblTaxon.TaxonNameID of a valid or unnamed taxon that is the current identification (may be higher level taxon if not identified further) DepoID, integer, 2 bytes, = tblDepos.DepoID, identifier for depository or collection that owns the specimen, a negative value means that the depository is not certain DepoCatNo, text, 30 bytes maximum, catalogue number of the depository or collection PreparationCode, integer, 1 byte, 0 = unspecified, 1 = pin, 2 = vial, 3 = jar, 4 = alcohol (vial or jar not specified), 5 = microscope slide dropped in version 4.0 MaleCount, integer, 2 bytes, number of adult males (-1 means "many", -2 means "more than 1") dropped in version 4.0 FemaleCount, integer, 2 bytes, number of adult females (-1 means "many", -2 means "more than 1") dropped in version 4.0 UnsexedAdultCount, integer, 2 bytes, number of unsexed adults (-1 means "many", -2 means "more than 1") dropped in version 4.0 ImmatureCount, integer, 2 bytes, number of juveniles (-1 means "many", -2 means "more than 1") dropped in version 4.0 SpecimenStatusID, integer, 1 byte, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.) LocalityID, integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality CollectEventID, integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event DataFlags, integer, 1 byte, bit flags for kinds of data available 1 = ecological relationship 2 = character data, not yet implemented 4 = image 8 = sound 16 = include specimen locality in maps, implemented in version 3.5 SourceID, integer, 2 bytes, = tblSources.SourceID, source for the data in this table Note, text, 300 bytes maximum, condition of specimen or any other information AccessCode, integer, 2 bytes LastUpdate, smalldatetime, date and time of last update ModifiedBy, integer, 2 bytes, UserID of the signon that made the change PreparationType, text, 300 byte maximum, text field replacing PreparationCode, added in version 4.0 BasisOfRecord, integer, 4 bytes, added in version 4.0 0 = 'Not specified' 1 = 'Preserved specimen' 2 = 'Fossil specimen' 3 = 'Image (still or video)' 4 = 'Audio recording' 5 = 'Checklist/Literature/Map' 6 = 'Personal observation'