The different accuracies of birthday estimates.
The possible degrees of confidence in the recorded cause of death (the recorded BIOGRAPH.Dcause values), recorded disperse date (the recorded DISPERSEDATES.Dispersed), and recorded maternal group assignment (the recorded BIOGRAPH.Matgrpconfidence) values.
CONFIDENCES defines values for the Dcauseconfidence column of BIOGRAPH table, the Dispconfidence column of the DISPERSEDATES table, and the Matgrpconfidence column of the BIOGRAPH table.
The value 0
(not
applicable) has a special meaning to the system. This is
the only BIOGRAPH.Dcauseconfidence value allowed to be
associated with individuals having no cause of death, having
a Dcause of
0
.
The software packages used for genetic paternity analysis. In the general case this table lists the possible analysis bases so, in theory, if analysis is based on something other than software then DAD_SOFTWARE should contain a row for that sort of analysis.
Different versions of the same software product may be considered distinct pieces of software.
The version or versions of the software.
This is a textual column so while its content is expected to be short there is flexibility should the row represent a range of software versions of the same product, etc.
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 different causes of death.
See the note in the STATUSES: Special Values section for an explanation of what it means to be alive.[211]
Indicates the data source of demography notes.
DEMOG_REFERENCES defines values for the Reference column of DEMOG.
Indicates the different ways individuals enter the study population.
ENTRYTYPES defines values for the Entrytype column of BIOGRAPH.
The possible reasons why a behavior gap ended.
GAP_END_STATUSES defines values for the Gap_End_Status column of BEHAVE_GAPS.
The different meanings of various maturity marker date values.
MSTATUSES defines values for MATUREDATES.Matured and RANKDATES.Ranked columns.
May be O
(ON) or
B
(BY). O
indicates a known
date. B
indicates that we know
that the animal had reached that maturational marker BY
the given date but we have no information about the actual
date on which the marker was attained.
The different categories of rankings that order individuals by dominance within a group within a month. Each category of ranking is identified with a row of this table.
This table contains a “special” column, Query. The Query column is an SQL query which defines which individuals are eligible for inclusion in this category of ranking. The SQL statement determines which individuals are included in any given ranking. It must return distinct Snames of individuals to be ranked within a given group over a given time period. In general the query is a SELECT statement which uses the BIOGRAPH and MEMBERS tables to determine who is to be ranked within a group over a month. A number of “special symbols” may be, and will need to be, included in the SQL query. Each “special symbol” represents a value which changes depending on the month or group ranked. The “special symbols” are:
Notation | Mnemonic | Data type | Description of usage |
---|---|---|---|
%g | Group id | number | The Gid of the group being ranked. |
%s | Start date | date | (Should not be quoted in the SQL statement.) Date of the first day of the interval over which the individuals are ranked (inclusive.) |
%f | Finish date | date | (Should not be bracketed in the SQL statement. Date of the last day of the interval over which the individuals are ranked (inclusive.) Note that ages, maturation dates, and so forth are often computed using or compared to the Finish Date value. |
The different states of an individual, reflecting what sort of record keeping needs to be done on the individual in the future.
The value 0
(alive) has a
special meaning to the system. No other codes should be
created to indicate that the individual is alive.
“Alive” has a particular meaning to Babase. It does not mean “alive in real life”, a concept which itself is complicated when it is qualified by a time because there are not always recorded observations.
Alive in the context of Babase means “an individual on which data is continuing to be collected”. The foremost implication of this is that living individuals can have data added to Babase after the individuals' BIOGRAPH.Statdate and the BIOGRAPH.Statdates will automatically change. Babase will hold no data on an individual that postdates the individual's death. The only way the BIOGRAPH.Statdate of a dead individual changes is when the change is made manually.