Record Event

Record Events link Events to Records. These are also known as specimen-events.

Table specimen_event

specimen_event_id

Primary key. When exposed publicly as specimenEventID it is formatted as https://arctos.database.museum/guid/UAM:Herp:12?seid=673238.

collection_object_id

Non-NULL foreign key to catalog_record.

collecting_event_id

Non-NULL foreign key to collecting_event

assigned_by_agent_id

Agent asserting that the Record has Event Type relationship to an event (including locality, geography, geology, etc.).

Caution

This person has determined coordinates and error, dates, higher geography, and everything else in the place and time stack

assigned_date

The date (datatype timestamp) on which the Event was assigned to the Record.

specimen_event_type

The action during the Event that affected the Record.

Select from values in Object Event: Types.

verificationstatus

The opinion of the verifier of the veracity and completeness of the coordinates included in the Event.

Select from values in Object Event: Verification Status Values

verified_by_agent_id

Agent asserting the Verification Status.

verified_date

Date (datatype ISO8601) on which Verification Status was asserted.

collecting_method

Describe methods employed at the event as they relate specifically to the record. Examples:

Pro Tip

Method may be better placed in the event method event attribute if the method corresponds to all records that may have participated in the event.

collecting_source

A broad categorization of how the record came to be at the event.

Select from Event: Source Values.

habitat

Describe the habitat at the place and time of the event as it relates specifically to the record. Examples:

specimen_event_remark

Use only for data which pertains to the relationship between the record and the event and which is not appropriate for any more-specific fields.