SIGHTINGS

SIGHTINGS contains one row for each chimpanzee for every day the individual was observed. It records the community to which the individual was assigned on each day, as well as daily sexual swelling information. SIGHTINGS is typically used to assist with censoring calculations.

The SIGHTINGS table is automatically constructed by the system and cannot be manually maintained. The table’s rows are computed from the SokweDB tables’ content.

The NON_BREC_SIGHTING_SOURCES table is used to add additional “manual” sighting records to SIGHTINGS, when the other parts of SokweDB do not indicate that an individual was sighted on a particular day. There is no way to remove rows from SIGHTINGS when tables, other than the NON_BREC_SIGHTING_SOURCES table, indicate that an individual was sighted. But if the only reason a row appears in SIGHTINGS is due to rows in NON_BREC_SIGHTING_SOURCES, the row can be removed from SIGHTINGS by removing the NON_BREC_SIGHTING_SOURCES rows.

Rows may exist in NON_BREC_SIGHTING_SOURCES to record additional sightings of an individual on a given day when other tables in SokweDB also imply a sighting of the individual. In this case, the rows in NON_BREC_SIGHTING_SOURCES have no effect. However, should the SokweDB db’s content change in a way that indicates the individual was not sighted, the relevant rows in NON_BREC_SIGHTING_SOURCES will then cause the SIGHTINGS row to be retained – recording the individual as “sighted”.

When a row exists in SIGHTINGS only because of rows in NON_BREC_SIGHTING_SOURCES, the SIGHTING_RECORDS.Priority column is determines the value of the Source column. Whenever tables other than NON_BREC_SIGHTING_SOURCES indicate the sighting of an individual, the Source column contains the special value SOKWEDB. In other words, NON_BREC_SIGHTING_SOURCES only determines the Source value when no other tables in the database indicate a sighting occurred.

The SightDate must be during a period when the sighted individual was under study, on or after the individual’s BIOGRAPHY_DATA.EntryDate and on or before the individual’s BIOGRAPHY_DATA.DepartDate.

SightID (SIGHTings 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.

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.

Source

A code indicating the record-taking that is the source of the sighting information. A SIGHTING_RECORDS.Code value. See above for more information on how the value of this column is determined.

This column may not be NULL.

Page last generated: 2026-02-10 22:26:46 UTC