Group Membership and Life Events

BSTATUSES (Birth Accuracy Indicators)

The categories of accuracy of the birth date estimates.

Vocabulary For

BSTATUSES defines values for the Bstatus column of BIOGRAPH. Except for the "unknown" Bstatus (9.0), this column indicates the length in years of the estimated range of an individual's possible birth dates.

For example, a Bstatus 1 indicates that the individual is estimated to have been born within 1 year of the Birth date, or the Birth date plus or minus at most 6 months.

Key Name: Bstatus

Bstatus

Special Values

The value 9.0 (unknown) has a special meaning to the system. This is the only BIOGRAPH.Bstatus value that indicates that the individual's birth date is "unknown", i.e. not able to be estimated with any meaningful confidence. It is the only Bstatus value that allows an individual to have a NULL EarliestBirth and LatestBirth.

The value 9.0 (unknown) is also the only Bstatus value whose numeric value has no actual meaning as a number. All other numbers added to BSTATUSES are presumed to indicate a number of years of accuracy in a birth date estimate.

CONFIDENCES (death cause (nature and agent), dispersal, and matgrp Confidence levels)

The possible degrees of confidence in the nature and agent of 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.Matgrp) values.

The values in this table are used to indicate confidence in several different tables, so it is necessary to describe these values in general terms. Unfortunately, this intentional lack of specificity in description may cause an unintentional lack of clarity. For this reason, the textual column Usage is included, in which table-specific comments or clarifications may be added.

Vocabulary For

CONFIDENCES defines values for the DcauseNatureConfidence and DcauseAgentConfidence columns of the BIOGRAPH table, the Dispconfidence column of the DISPERSEDATES table, and the Matgrpconfidence column of the BIOGRAPH table.

Key Name: Confidence

Confidence

An integer.

Special Values

The value 0 (not applicable) has a special meaning to the system. This is the only BIOGRAPH.DcauseNatureConfidence and DcauseAgentConfidence value allowed to be associated with individuals having no cause of death, having a Dcause of 0.

The Usage Column

Table-specific notes or comments about how this confidence value is used, or what it means.

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.

DAD_SOFTWARE

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.

Note

Different versions of the same software product may be considered distinct pieces of software.

Vocabulary For

DAD_SOFTWARE defines values for DAD_DATA.Software.

Key Name: Software

Code for the software package. Limited to 10 characters of text.

Special Values

None.

Version

The version or versions of the software.

Note

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.

DCAUSES (Causes of Death)

The different causes of death, classified by Nature and Agent.

A Dcause's Nature describes in general terms the reason that the individual died, e.g. violence. A Dcause's Agent indicates the source or cause of the indicated nature, e.g. predator.

When an individual's Dcause is assigned, the assignment is often not certain, but is instead a CONFIDENCES-qualified inference based on available evidence at the time of the individual's death or disappearance. Because of this, an individual's Dcause should be read as "if Nature, then Agent".

The combination of Nature and Agent is unique.

See the note in the STATUSES: Special Values section for an explanation of what it means to be alive.[234]

Vocabulary For

DCAUSES defines values for the Dcause column of BIOGRAPH.

Key Name: Dcause

Dcause

An integer.

Special Values

The value 0 (no cause of death) has a special meaning to the system. This is the only Dcause allowed to be associated with living individuals.

The Nature Column

The DEATHNATURES.Nature of the cause of death.

This column may not be NULL.

The Agent Column

The origin, source, or cause of the indicated Nature.

This column may not be NULL.

DEMOG_REFERENCES (Demography Note References)

Indicates the data source of demography notes.

Vocabulary For

DEMOG_REFERENCES defines values for the Reference column of DEMOG.

Key Name: Reference

Reference

Special Values

None.

DEATHNATURES (Natures of Death Causes)

The different natures, or reasons, for death. See DCAUSES for more info about the difference between causes, natures, and agents of death.

Vocabulary For

DEATHNATURES defines values for the Nature column of DCAUSES.

Key Name: Nature

Nature

Special Values

None.

ENTRYTYPES (Categories of Entry to Study Population)

Indicates the different ways individuals enter the study population.

Vocabulary For

ENTRYTYPES defines values for the Entrytype column of BIOGRAPH.

Key Name: Entrytype

Entrytype

Special Values

The value of B (birth) has a special meaning to the system. No other value should be used in BIOGRAPH.Entrytype to indicate birth as the method for entry into the population.

GAP_END_STATUSES (Explanations for Behavior Gap Ends)

The possible reasons why a behavior gap ended.

Vocabulary For

GAP_END_STATUSES defines values for the Gap_End_Status column of BEHAVE_GAPS.

Key Name: Gap_End_Status

Gap_End_Status

An integer.

Special Values

None.

MSTATUSES (Maturity Marker Statuses)

The different meanings of various maturity marker date values.

Vocabulary For

MSTATUSES defines values for MATUREDATES.Matured and RANKDATES.Ranked columns.

Tip

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.

Key Name: Mstatus

Mstatus

Special Values

The value of O (attained On given date) has a special value to the system. No other code should be created to indicate that observations indicate a specific, known, date.

DAD_DATA_COMPLETENESS (Completeness Scores in Paternity Analyses)

This support table indicates the apparent completeness of a paternity assignment.

Vocabulary For

DAD_DATA_COMPLETENESS defines values for the Completeness column of DAD_DATA.

Key Name: Completeness

Completeness

Special Values

None.

DAD_DATA_MISMATCHES (Types of Genetic Mismatches)

This support table categorizes the type(s) of genetic mismatches that are observed in a paternity assignment.

Vocabulary For

DAD_DATA_MISMATCHES defines values for the Consensus_Mismatch column of DAD_DATA.

Key Name: Mismatch

Mismatch

Special Values

None.

RNKTYPES (Ranking Categories)

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.

Vocabulary For

RNKTYPES defines value for the Rnktype column of RANKS.

Key Name: Rnktype

Rnktype

Special Values

None.

The Query column

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:

Variables Substituted into Query
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.

STATUSES (Indicators of Record and Baboon Vividity)

The different states of an individual, reflecting what sort of record keeping needs to be done on the individual in the future.

Vocabulary For

STATUSES defines values for the Status column of BIOGRAPH.

Key Name: Status

Status

An integer.

Special Values

The value 0 (alive) has a special meaning to the system. No other codes should be created to indicate that the individual is alive.

Note

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.



[234] Silly you. You thought you knew already.


Page generated: 2021-09-17T11:16:36-04:00.