Specimen Management Image Map
Legend

Specimen Management

Specimen

The main specimen table.

Field Name Description1º Key 2º Index Foreign KeyParadox Field Type
Section Section of Institution (Vertebrates, Plants etc.)
*
Alpha, 3 characters
SpecimenNo
*
Long Integer
LocPrefix
*
Locality Alpha, 2 characters
LocalityNo Locality where specimen was collected
*
LocalityLong Integer
AccessionNo Accession Long Integer
NoObjects Alpha, 10 characters
FieldNo Alpha, 15 characters
Type? Logical

Equivalent specimens

This table is used to track specimens which have either been assigned more than one UCMP specimen number, or original numbers from another institution (exchanges, casts).

Field Name Description1º Key 2º IndexForeign KeyParadox Field Type
Section Section of Institution (Vertebrates, Plants etc.)
*
Specimen Alpha, 3 characters
SpecimenNo
*
Specimen Long Integer
Acronym Other institution, UCMP if it has more than one UCMP number
*
Acronym Alpha, 15 characters
AltSpecNo Other institution specimen number
*
Alpha, 15 characters
Equivalency To indicate if part of the specimen has been given a separate number Alpha, 10 characters