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-01 22:52:03 UTC