FOLLOW_ARRIVALS

Each row represents a period of time during which an individual is under observation in the follow. The system will generate a warning when there is no row for the follow’s focal (FOLLOWS.Focal) in FOLLOW_ARRIVALS. When an individual can no longer be observed and after a period of time is again observed, a situation which may occur multiple times, there is a FOLLOW_ARRIVALS row for each time period during which an individual is under observation.

The Start time cannot be after the End time. The system will generate a warning when Start is equal to End.

When there is more than one FOLLOW_ARRIVALS row for a given individual (for a given AnimID), for a given follow (for a given FOLLOW_ARRIVALS.FID), and either of the row’s FOLLOW_ARRIVALS.Certainty value is 1, then the Start and End values cannot overlap, endpoints included. The system will generate a warning when there is more than one FOLLOW_ARRIVALS row for a given individual, for a given follow, and the Start of one row overlaps, endpoints included, with the End of the other row.

The n/a CYCLE_STATES.Code is the only value that can be used in the Cycle column when the AnimID identifies a non-female; the only value that can be used when the related BIOGRAPHY_DATA.Sex column is either M or U, the unknown sex.

The U CYCLE_STATES.Code can only be used in the Cycle column when the AnimID identifies an adolescent female, can only be used when the related BIOGRAPHY_DATA.Sex column is F and the individual’s age on the FOLLOWS.Date is at least 6 years old and not more than 9 years old.

FAID (Follow Arrivals 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.

FID (Follow IDentifier)

The FOLLOWS.FID that identifies the follow during which the individual identified by the AnimID was under observation. This column may not be NULL.

AnimID (Animal ID)

The BIOGRAPHY_DATA.AnimID identifying the individual, focal or non-focal, who was under observation during the follow. This column may not be NULL.

Seq (Sequence Number)

An automatically generated integer, starting with 1 and increasing by one without gaps, which indicates the timewise ordering of a given individual’s presence, a given AnimID’s presence, in the follow. So, the Seq increments each time an individual (re)joins the follow. The value of this column cannot be changed. This column may not be NULL.

Start

The time the individual was first observed, in the given contiguous time period during which they were considered present in the follow. This column must contain values that fall on one minute intervals; it may not contain values having seconds or fractions of seconds. This column may not be NULL.

End

The time the individual was last observed, in the given contiguous time period during which they were considered present in the follow. This column must contain values that fall on one minute intervals; it may not contain values having seconds or fractions of seconds. This column may not be NULL.

Certainty

A FA_CERTAINTIES.Certainty code designating the certainty of the identification of the individual; the certainty of the AnimID value. This column may not be NULL.

NestStart

Whether the individual was first observed in a nest. An integer, either 1 when the individual was first observed in a nest, or 0 when the individual was not first observed in a nest. This column may not be NULL.

NestEnd

Whether the individual was last observed in a nest. An integer, either 1 when the individual was first observed in a nest, or 0 when the individual was not first observed in a nest. This column may not be NULL.

Cycle

A code indicating the estrous state of the individual; a CYCLE_STATES.Code value. This column may not be NULL.

DataSource

Code indicating the source of the row’s data; a DATA_SOURCES.Source value. This column may not be NULL.

Page last generated: 2025-04-12 18:47:18 UTC