Collections Image Map
Legend

Collection Bay Number

These tables are section specific. They are used to track the location of material within the collection for ease of retrieval. Macrofossil material is organized by locality. Microfossil material is organized by specimen number, and keyed to the Specimen table. Recent comparative material is organized by taxon, and keyed to the Taxon table.

Macrofossil Collection Bay Number

Field Name Description1º Key Foreign KeyParadox Field Type
RackNo
*
 Alpha, 3 characters
BayNo
*
 Short Integer
TrayNo Plant section only
*
Short Integer
LocPrefix Locality Alpha, 2 characters
LocalityNo Locality Long Integer

Microfossil Collection Bay Number

TR>
Field Name Description1º Key Foreign KeyParadox Field Type
RackNo
*
 Alpha, 3 characters
BayNo
*
 Short Integer
Section of Institution (Micropaleontology) Specimen Alpha, 3 characters
SpecimenNo Specimen Long Integer

Recent Collection Bay Number

Field Name Description1º Key Foreign KeyParadox Field Type
RackNo
*
 Alpha, 3 characters
BayNo
*
 Short Integer
TaxonNo Taxon Long Integer