NON_BREC_SIGHTING_SOURCES

There is a row for each chimpanzee, for each date sighted, for non-BRec related sightings. This table is used to make “manual”, that is, non-BRec related, changes to the per-day record of chimpanzee sightings found in the SIGHTINGS table.

The Date must be during a period when the sighted individual was under study, when the community is one that was under study. Otherwise, the Date may not be before the individual’s birthdate. This means that Date must be on or after the sighted individual’s – the AnimID’s – BIOGRAPHY_DATA.BirthDate, and, if the CommID is that of a COMM_IDS.CommID with a TRUE COMM_IDS.Studied value, must also be on or after the individual’s EntryDate. And, the Date must be on or before the sighted individual’s BIOGRAPHY_DATA.DepartDate.

ID (IDentifier)

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.

Source

Code indicating the Non-BRec record in which the sighting was recorded. A SIGHTING_RECORDS.Code value.

This column may not be NULL.

Date

The date the individual was sighted. This column may not be NULL.

AnimID (Animal IDentifier)

The BIOGRAPHY_DATA.AnimID of the individual sighted. This column may not be NULL.

CommID (Community IDentifier)

The COMM_IDS.CommID of the community to which the individual was assigned for the day. This column may not be NULL.

Notes

Textual notes related to the sighting. This column may not be NULL.

Page last generated: 2026-08-13 23:02:22 UTC