UCMP Data Model -- Accessions

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 Description 1º Key Foreign Key Paradox Field Type

AccessionNo * Long Integer

Donor Person donating material Person Long 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 Person Long Integer

AccNotes Notes regarding the Accession Memo, 20 characters displayed

Accession Audit

This table tracks changes made to the Accesions table.

Field Name Description 1 ºKey Foreign Key Paradox 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 Description 1º Key Foreign Key Paradox 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 Description 1º Key Foreign Key Paradox 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 Description 1º Key Foreign Key Paradox Field Type

PermitNo UCMP internal number * Long Integer

Landowner Landowner Long Integer

OrigPermitNo Original number assigned by agency granting permit Alpha, 20 characters

PermitType Surface collection, excavation Alpha, 20 characters

PermitBegin Beginning of permit period Date

PermitEnd Permit expiry date Date

Field Name	Description	1º Key	Foreign Key	Paradox Field Type
AccessionNo		*		Long Integer
Donor	Person donating material		Person	Long 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		Person	Long Integer
AccNotes	Notes regarding the Accession			Memo, 20 characters displayed

Field Name	Description	1 ºKey	Foreign Key	Paradox Field Type
AccessionNo		*	Accession	Long Integer
DateChanged	Date edited	*		Date field
ChangedBy			Person	Long Integer