Inventory

INSTITUTIONS

The possible locales where tissue and nucleic acid samples can be stored or used.

Vocabulary For

INSTITUTIONS defines values for the Institution column in LOCATIONS, NUCACID_DATA, NUCACID_LOCAL_IDS, TISSUE_DATA, and TISSUE_LOCAL_IDS.

Key Name: Institution

An integer.

Special Values

The value 1 has special meaning to the system. It is used in the TISSUES, NUCACIDS, and NUCACIDS_W_CONC views to help populate each view's respective LocalId_1 column.

The value 2 has special meaning to the system. It is used in the TISSUES, NUCACIDS, and NUCACIDS_W_CONC views to help populate each view's respective LocalId_2 column.

MISID_STATUSES (MISIDentification STATUSES)

The possible levels of confidence in the identity of a tissue sample.

Vocabulary For

MISID_STATUSES defines values for TISSUE_DATA.Misid_Status.

Key Name: Misid_Status

An integer.

Special Values

None.

NUCACID_CONC_METHODS (NUCleic ACID CONCentration quantification METHODS)

The possible methods for quantifying nucleic acid concentrations.

Vocabulary For

NUCACID_CONC_METHODS defines values for NUCACID_CONC_DATA.Conc_Method.

Key Name: Conc_Method

An integer.

Special Values

The value 1 has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that indicates quantification by quantitative PCR ("qPCR"). Also, this value is used in the definition of the NUCACIDS_W_CONC view.

The value 2 has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that indicates quantification with a Nanodrop spectrophotometer. Also, this value is used in the definition of the NUCACIDS_W_CONC view.

The value 3 has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that indicates quantification with a Qubit fluorometer. Also, this value is used in the definition of the NUCACIDS_W_CONC view.

The value 4 has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that indicates quantification with a Bioanalyzer assay. Also, this value is used in the definition of the NUCACIDS_W_CONC view.

The value 5 has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that indicates quantification with a Quant-iT assay. Also, this value is used in the definition of the NUCACIDS_W_CONC view.

NUCACID_CREATION_METHODS (NUCleic ACID CREATION METHODS)

The possible methods for creating nucleic acid samples.

Vocabulary For

NUCACID_CREATION_METHODS defines values for NUCACID_DATA.Creation_Method.

Key Name: Creation_Method

An integer.

Special Values

None.

NUCACID_TYPES (NUCleic ACID TYPES)

The possible nucleic acid sample types.

Vocabulary For

NUCACID_TYPES defines values for NUCACID_DATA.NucAcid_Type.

Key Name: NucAcid_Type

This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.

Special Values

None.

STORAGE_MEDIA

The possible media used for storage/archiving of tissue samples.

Vocabulary For

STORAGE_MEDIA defines values for TISSUE_DATA.Storage_Medium.

Key Name: Storage_Medium

This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.

Special Values

None.

TISSUE_TYPES

The possible tissue sample types.

Some types of tissues, e.g. blood, cannot plausibly be collected after an individual has died or disappeared. Other tissue types may be collected during regular observation or sometime afterward, e.g. "skin" could be a puncture from a live animal or a patch of dry flesh from a found corpse. To validate the TISSUE_DATA.Collection_Date against the source individual's BIOGRAPH.Statdate, but also allow the flexibility to set different rules for different tissue types, this table includes the Max_After_Statdate column.

When the Max_After_Statdate column is not NULL, all TISSUE_DATA rows that have this row's Tissue_Type and that came from an individual in the main population cannot have a Collection_Date that is more than Max_After_Statdate days after the individual's Statdate. That is, tissue samples cannot be collected more than Max_After_Statdate days after the individual's death/disappearance.

Vocabulary For

TISSUE_TYPES defines values for TISSUE_DATA.Tissue_Type.

Key Name: Tissue_Type

Tissue_Type

Special Values

None.

The Max_After_Statdate Column

A non-negative integer, indicating the maximum number of days that the Collection_Date of a TISSUE_DATA row with this Tissue_Type is allowed to exceed the source individual's BIOGRAPH.Statdate, if any.

This column may be NULL, indicating that the row's Tissue_Type can be collected any number of days after the Statdate.


Page generated: 2024-03-06T15:02:30-05:00.