Archives Image Map
Legend

Archives

UCMP has a large amount of archival material, including field notes, photographs and correspondence. The Archive tables will be used to keep track of this material and the relationship of the source materials to UCMP localities, accessions and specimens.

Archive

The Archive table contains information about archived material. For digital archives, the files will use the ArchiveNo value as their file name.

Field Name Description1º Key Foreign KeyParadox Field
ArchiveNo
*
 Long Integer
ArchiveType Photo, field notes, image file
*
 Alpha, 15 characters
ArchiveNotes Memo, 20 characters displayed

Locality - Archive

This table tracks references in the archives to various localities.

Field Name Description1º Key Foreign KeyParadox Field Type
LocPrefix
*
Locality Alpha, 2 characters
LocalityNo
*
Locality Long Integer
ArchiveNo
*
Archive Long Integer
ArchiveType
*
Archive Alpha, 15 characters

Accession - Archive

This table tracks references in the archives to various accessions.

Field Name Description1º Key Foreign KeyParadox Field Type
AccessionNo Museum accession number
*
AccessionLong Integer
ArchiveNo Number assigned to archive
*
ArchiveLong Integer
ArchiveType Type of archival material (e.g. Letters, photographs)
*
Archive Alpha, 15 characters

Specimen Archive

This table tracks references in the archives to various specimens.

Field Name Description1º Key Foreign KeyParadox Field
Section Section of Institution (Vertebrates, Plants etc.)
*
SpecimenAlpha, 3 characters
SpecimenNo Specimen number
*
SpecimenLong Integer
ArchiveNo
*
Archive Long Integer
ArchiveType Archive Alpha, 15 characters

Field Numbers

This table tracks the relationship of field numbers to localities and archival material (field notes).

Field Name Description1º Key 2º IndexForeign KeyParadox Field
FieldNo
*
Alpha, 15 characters
ArchiveNo
*
Archive Long Integer
LocPrefix
*
Locality Alpha, 2 characters
LocalityNo
*
Locality Long Integer