ARRIVALS

Each row, taken together with the related EVENTS row, represents an arrival or departure of an individual from the observation conducted during a follow. The related EVENTS row must be an arrival event; it must have an EVENTS.Behavior value of ARR. This related EVENTS row supplies arrival and departure time values, and the ROLES role related to the event supplies information on the individual arriving and departing.

The system will generate a warning when there are 2 different arrival events for the same arriving individual, in the same follow, with the same EVENTS.Start time.

The system will generate a warning when there are 2 different arrival events for the same arriving individual, in the same follow, with the same EVENTS.Stop time.

The system will generate a warning when there are 2 different arrival events for the same arriving individual, in the same follow, with EVENTS.Start to EVENTS.Stop intervals that overlap, endpoints included.

For further information, including additional data integrity rules, see the documentation of the EVENTS table.

ArID (Arrival ID)

A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. This column may not be NULL.

EID (Event ID)

The EVENTS.EID identifying the arrival event that is related to the arrival or departure. The related event contains information on arrival and departure times.

This column may not be NULL.

Seq (Sequence)

An integer indicating the order in which an individual arrived, in the sequence of arrivals of a given individual, in a given follow.

This column records the ordering of the arrivals of a single individual, within a given follow. The values start with 1 and increase without gaps, each successive arrival of an individual incrementing by one the value of the previous arrival.

The order is determined by, first, the time the individual arrived in a given follow. Ties are broken by the time the individual left the follow. Ties remaining are broken by the time the row was inserted into the system, or, in the case of data imported from the old MS Access database, by that database’s FOLLOW_ARRIVAL.FA_seq_num column’s value.

The value of this column is automatically maintained by the system. Values inserted into this column must be NULL (or the column may be omitted from the INSERT statement). The value of this column cannot be changed. The value of this column is never NULL.

NestStart (in Nest at the Start time)

A boolean, whether or not the related participent, related through EVENTS and ROLES, was in a nest at the time of arrival. This column may not be NULL.

NestStart (in Nest at the Stop time)

A boolean, whether or not the related participent, related through EVENTS and ROLES, was in a nest at the time of departure. This column may not be NULL.

Cycle (Cycle state)

A CYCLE_STATES.Code value indicating the state of the arriving individual’s estrous cycle.

All indivdiuals, female or not, have a value in this column, to avoid tri-valued logic and therefore simplify querying. The value used for males and other non-cycling individuals is un-interesting.

This column may not be NULL.

DataSource (Data Source)

A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. This column may not be NULL.

Page last generated: 2025-11-01 22:22:26 UTC