These support tables are used throughout Babase.
Contains one row for each person who records information, or at least information that we tag with a record of who recorded it. This table may include people who assist the data collection process, whether in our out of the field and whether or not their initials appear in those database columns for which the OBSERVERS table provides a validation vocabulary because the initials of all these people may appear in paper or unvalidated electronic records.
OBSERVERS is unusual in that, in some sense, it has two key columns: Initials and OldGPSInititals. Which key is used in the field depends upon the data collection protocols. When entered into Babase all OldGPSInititals values are translated into their respective Initials values, so it is the Initials values that Babase always uses to reference the individual.
Only the Babase administrator can create OBSERVERS rows with Initials values that the SWERB_UPLOAD view cannot reliably distinguish. See the portion of the SWERB_UPLOAD documentation which describes the ability of the view to distinguish one observer from another. Unless it can be assured that such indistinguishable observers will never simultaneously collect SWERB data then creating such Initials is not recommended.
OBSERVERS defines vocabulary for INTERACT_DATA.Observer, SAMPLES.Observer, WREADINGS.WRperson, RGSETUPS.RGSPerson, CROWNRUMPS.CRobserver, CHESTS.Chobserver, ULNAS.Ulobserver, HUMERUSES.Huobserver, and SWERB_OBSERVERS.Observer.
Initials
The initials of the person. This is used to uniquely identify the person, so may not be the person's actual initials if there is ever a conflict with a pre-existing value.
This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.
The initials, or notes regarding the initials, used to identify the person when recording GPS data.
This column exists because of a historical inconsistency between the initials used in the collection of GPS data and the initials used in the collection of other data. It is strongly recommended that new observers use the same initials when collecting either sort of data.
This column may be NULL.
This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
The person's real name.
This column may not be NULL.
This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
Textual remarks regarding when the observer was recording Babase data. Usually a date range.
This column may be NULL.
This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
Any notes you may wish to make on the person. For example you may wish to record that the person is John Smith the graduate student, not John Smith the, for example, President of Kenya who asked to be able to collect data and actually did so for a day.
This column may be NULL.
This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
The role the person has filled in regards to data collection. Must be a value on the OBSERVER_ROLES table.
This column must not be NULL.
The SWERB_OBSERVERS.Role value to use when the observer is identified in the first line of SWERB data supplied to the SWERB_UPLOAD view. Must be a value on the OBSERVER_ROLES table.
This column must not be NULL.
The SWERB_OBSERVERS.Role value to use when the observer is identified in the second line of SWERB data supplied to the SWERB_UPLOAD view. Must be a value on the OBSERVER_ROLES table.
This column must not be NULL.
One row for every role a person may have in data collection.
OBSERVER_ROLES defines vocabulary for OBSERVERS.Role and SWERB_OBSERVERS.Role..
The different reasons why a focal individual's neighbor is unable to be identified during focal point sampling or the code(s) used to identify lone males when recording SWERB other group observations.
A Unksname value must not appear as a BIOGRAPH.Sname value.
UNKSNAMES defines vocabulary for the Unksname column of the NEIGHBORS table. It is also used by the SWERB_UPLOAD view to identify unknown lone males.
A boolean. When TRUE the Unksname value is used to indicate
that an unknown lone male was observed during a SWERB other
group observation; FALSE
otherwise.
This column may not be NULL.