Accessions

These tables contain information about UCMP accessions, land owners, land managers and permits. UCMP tracks the landowner when the locality is first established, and for any subsequent permitted collecting, but does not track land ownership changes in other cases.

Accession

This is the main table for accession information.

Field Name Description1º Key Foreign KeyParadox Field Type
AccessionNo
*
 Long Integer
Donor Person donating material PersonLong Integer
Procurement How specimen was acquired (e.g. purchase, donation) Alpha, 20 characters
DateCollected Date material was collected Alpha, 10 characters
EntryDate Date record entered into system Date
EnteredBy Data entry personnel PersonLong Integer
AccNotes Notes regarding the Accession Memo, 20 characters displayed

Accession Audit

This table tracks changes made to the Accessions table.

Field Name Description1 ºKey Foreign KeyParadox Field Type
AccessionNo
*
Accession Long Integer
DateChanged Date edited
*
Date field
ChangedBy Person Long Integer

Landowner

The Landowner table is used to maintain records of land ownership at the time of first collection of a locality or at time of permit issuance.

Field Name Description1º Key Foreign KeyParadox Field Type
LandownerNo
*
Long Integer
Landowner Property owner
Alpha, 40 characters
LandNotes Notes Memo, 20 characters displayed

Locality Accession

This table is used to link localities to material accessioned.

Field Name Description1º Key Foreign KeyParadox Field Type
LocPrefix
*
Locality Alpha, 2 characters
LocalityNo
*
Locality Long Integer
AccessionNo
*
Accession Long Integer
PermitNo
*
Permit Long Integer

Permit

This table is used to maintain records of federal and state permits under which UCMP collects material.

Field Name Description1º Key Foreign KeyParadox Field Type
PermitNo UCMP internal number
*
 Long Integer
LandownerNo Landowner Long Integer
OrigPermitNo Original number assigned by agency granting permit Alpha, 20 characters
PermitType Surface collection, excavationAlpha, 20 characters
PermitBegin Beginning of permit periodDate
PermitEnd Permit expiry dateDate