ATTENDANCE¶
Each row represents a day during which a chimpanzee was observed at the feeding station.
An individual may not be recorded as being at the feeding station more than once on any given day. This means that for any given AnimID, for any given Date, that there may not be another ATTENDANCE row for the given individual.
The system will generate a warning when an ATTENDANCE row does not
have a ARRIVALS_A related row that records the presence of the
individual: does not have a related EVENTS row where the
Behavior code is AARR, and a ROLES row,
related to the event, where the ROLES.Participant has the
same value as the attendance record’s AnimID column.
The Date must be during a period when the arriving individual was under study. This means that the Date must be on or after the arriving individual’s BIOGRAPHY_DATA.EntryDate and on or before the arriving individual’s BIOGRAPHY_DATA.DepartDate.
The system will generate a warning if the n/a code
is assigned to a female, an individual with a BIOGRAPHY_DATA.Sex value of F.
The system will generate a warning if any code other than the
n/a code is assigned to an individual who is not a
female, an individual with a BIOGRAPHY_DATA.Sex
value that is not F.
Except for the unknown female individuals, those with a
BIOGRAPHY_DATA.AnimID of MGF,
or MGF2, or MGF3, the system
will generate a warning if the U code is
assigned to a female less than 5
years old or more than
14 years old.
Except for the unknown female individuals, those with a
BIOGRAPHY_DATA.AnimID of MGF,
or MGF2, or MGF3, the system
will generate a warning if a code that is not one of
n/a, U,
0, and MISS is assigned to a
female that is at least 8
years old and less than or equal to
48 years old.
AtID (Attendance 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.
AnimID (Animal IDentifier)¶
The BIOGRAPHY_DATA.AnimID identifying the
individual observed at the feeding station. This column may not be NULL.
Date¶
The date the individual was observed at the feeding station.
This date may not be before 1960-07-14.
This column may not be NULL.
CommID¶
A code for the community observed at the feeding station. A COMM_IDS.CommID value.
This value is not validated against the arriving individual’s record of community membership as recorded in other database content.
The value of this column cannot be changed. This column may not be NULL.
Page last generated: 2026-06-12 16:40:37 UTC