Darting

DART_SAMPLE_CATS (Darting Sample Categories)

Classifies samples collected during a darting into specific categories, e.g. blood, skin, etc.

Vocabulary For

DART_SAMPLE_CATS defines values for DART_SAMPLE_TYPES.DS_Cat. This column cannot be changed.

Key Name: DS_Cat

Code for the category of the sample.

Special Values

None.

DART_SAMPLE_TYPES (Sample Types)

The different types of samples that are collected during dartings.

This table contains data that are special values used by the DSAMPLES view. Because of this, only administrators are allowed to INSERT, UPDATE, or DELETE from this table.

Vocabulary For

DART_SAMPLE_TYPES defines values for DART_SAMPLES.DS_Type. This column cannot be changed.

Key Name: DS_Type

Code for the sample type.

Special Values

The values in DS_Type are used in the definition of the DSAMPLES view.

The DS_Cat column

The DART_SAMPLE_CATS.DS_Cat to which each sample type belongs.

The Sex Column

Some sample types may be sex-specific. Vaginal and cervical swabs, for example, can only be collected from females. If a sample type has any such specificity, the correct sex is indicated here.

This column may be NULL when the darting sample is not sex-specific.

The Minimum Column

The minimum number of samples of this type that can be collected. This column may not be NULL.

The Maximum Column

The maximum number of samples of this type that can be collected. This column may not be NULL..

DRUGS (darting anesthetics)

The different anesthetics used when darting.

Vocabulary For

DRUGS defines values for DARTINGS.Drug and ANESTHS.Drug.

Key Name: Drug

Code for the anesthetic.

Special Values

None.

LYMPHSTATES (Lymph node conditions)

The different conditions a lymph node can be found in when darting.

Vocabulary For

LYMPHSTATES defines values for DPHYS.Ringnode, DPHYS.Lingnode, DPHYS.Raxnode, DPHYS.Laxnode, DPHYS.Lsubmandnode, and DPHYS.Rsubmandnode.

Key Name: Lymphstate

Code for the state of the lymph node.

Special Values

None.

PARASITES (Parasites and their indicators)

The different kinds of parasites, kinds of parasites in varying developmental stages, or kinds of parasite indicators counted when darting.

Vocabulary For

PARASITES defines values for TICKS.Tickkind.

Key Name: Parasite

Code for the parasite, stage of a species of parasite, or parasite indicator.

Special Values

None.

TCONDITIONS (Tooth Conditions)

The different tooth conditions, degrees of wear, chipping, etc., observed when darting.

Caution

The condition of the tooth is a property distinct from the degree to which the tooth is present or absent. The latter property is described by the codes in the TSTATES table.

Vocabulary For

TCONDITIONS defines values for TEETH.Tcondition.

Key Name: Tcondition

Code for the tooth condition.

Special Values

None.

TICKSTATUSES (parasite count classifications)

The classifications of parasite count useful in analysis.

Vocabulary For

TICKSTATUSES defines values for TICKS.Tickstatus.

Key Name: Tickstatus

Code for the classification.

Special Values

The following special codes can only be altered by suitably privileged individuals. See Special Values.

Special TICKSTATUSES codes

0

A count was performed and no parasites were found. This code can only be used when the number of parasites counted is 0, in which case it must be used.

1

A count was performed and parasites were found. This code must be used when the number of parasites counted is any non-zero positive integer. The code may be used when parasites are found but were not counted (TICKS.Tickcount is NULL).

TOOTHCODES (kinds of teeth)

A set of codes describing the dentition of a baboon, one code for each tooth.

Note

Deciduous[241] teeth have different codes than, are considered different from, adult teeth.

Vocabulary For

TOOTHCODES defines values for TEETH.Tooth.

Key Name: Tooth

Code for the Tooth.

Special Values

Every toothcode value is special, although there are no restrictions placed upon making changes to these special values as there are on the special rows in other tables. Each of the TOOTHCODES.Tooth values are written into[242]the DENT_CODES and DENT_SITES views. Adding or deleting rows from TOOTHCODES requires re-writing the DENT_CODES and DENT_SITES views to ensure the alterations are present in the views.

The Canine Column

Boolean value indicating whether the tooth is a canine or not.

Note

Morphologically this column should be on TOOTHSITES, be associated with tooth location. Placement on this table allows control over whether canine data may be collected on decidious teeth -- control which is not needed at this time.

This column may not be NULL.

The Deciduous Column

Boolean value indicating whether the tooth is deciduous or adult. TRUE indicates the tooth is deciduous. FALSE indicates the tooth is adult.

This column may not be NULL.

I am inclined to make the name of this column be Adult rather than Deciduous for reasons of brevity, but I believe that Susan prefers it as-is. I would like feedback from the folks who are likely to be doing the typing. (KOP)

The Toothsite (Tooth Site) Column

The site of the tooth within the mouth. Legal values for this column are defined by the TOOTHSITES table.

This column may be used to correlate the locations of deciduous teeth with their adult counterparts.

This column may not be NULL.

I am inclined to make the name of this column be Site, but I believe that Susan prefers it as-is. I would like feedback from the folks who are likely to be doing the typing. (KOP)

TOOTHSITES (Locations of deciduous or adult teeth)

The locations of a baboon's teeth within the mouth. This table is used to correlate adult with deciduous teeth. Any given TOOTHSITES code cannot be used in two TOOTHCODES rows having the same TOOTHCODES.Deciduous value -- at most one adult and one deciduous tooth can have the same location within the mouth.

Vocabulary For

TOOTHSITES defines values for TOOTHCODES.Toothsite.

Key Name: Toothsite

Code for a tooth site.

Special Values

None.

TSTATES (State of Tooth existence)

Codes describing the degree to which a tooth is present or absent in the mouth.

Caution

The degree to which the tooth is present or absent is a property distinct from the condition of the tooth. The latter property is described by the codes in the TCONDITIONS table.

Vocabulary For

TSTATES defines values for TEETH.Tstate.

Key Name: Tstate

Code for a tooth site.

Special Values

The value M (missing) has a special meaning to the system. TEETH rows that describe missing teeth must have NULL TEETH.Tcondition values.



[241] baby

[242] Hardcoded into to use a term-of-art.


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