ROLES

Each row represents a participant in an event that occurred during a follow, whether involving the focal or not. Events may have zero or more participants involved; rows on EVENTS may have zero or more related rows on ROLES. Usually, there will be at least one participant. But this is not true of events that are no more than a record of the presence of other species sighted during a follow.

The participant in the event must be under study on the date of the follow; the related FOLLOWS.Date must be between the Participant’s BIOGRAPHY_DATA.BIOGRAPHY_DATA.EntryDate and the|BIOGRAPHY_DATA|.BIOGRAPHY_DATA.DepartDate, inclusive of endpoints.

For further information on the required, and expected, relationship between ROLES, EVENTS, and other tables see the documentation of the EVENTS table.

PID (Participant ID)

The EVENTS.EID that identifies the event in which the Participant played a role. The value of this column cannot be changed. This column may not be NULL.

EID (Event ID)

The EVENTS.EID that identifies the event in which the Participant played a role. The value of this column cannot be changed. This column may not be NULL.

Role

A code indicating the role played by the Participant in the event; a ROLES.|ROLES.Role| value. The role code broadly describes the participants role in a behavioral event. For further detail the EVENTS.|EVENTS.Behavior| column must be examined. Depending on the behavior, there may be additional information found in other tables related to the event.

This column may not be NULL.

Participant

A AnimID identifying the individual participating in the event. This column may not be NULL.

Page last generated: 2025-10-24 02:43:12 UTC