Entity Sequence Variation Fact

DescriptionA location in the human genome where variations have been identified. A polymorphism such as an SNP, repetitive microsatellite, or other genomic variation.

Attributes
Alelle Frequency RtAlelle Frequency Rt
Allele CntAllele Cnt
Allele DkAllele Dk
Allele Frequency RtAllele Frequency Rt
Allele SkAllele Sk
Assay DkAssay Dk
Assay Performed DtAssay Performed Dt
Assay SkAssay Sk
AWM Load Info SkAWM Load Info Sk
Calendar DkCalendar Dk
Chromosome Hits CntChromosome Hits Cnt
Chromosome NumChromosome Num
Contiguous Hits CntContiguous Hits Cnt
Current IndCurrent Ind
DNA Sample DkDNA Sample Dk
DNA Sample SkDNA Sample Sk
DNA Sequence DkDNA Sequence Dk
DNA Sequence SkDNA Sequence Sk
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Experiment DtExperiment Dt
Gene DkGene Dk
Gene SkGene Sk
Genotype DkGenotype Dk
Genotype Experiment DkGenotype Experiment Dk
Genotype Experiment SkGenotype Experiment Sk
Genotype SkGenotype Sk
Haplotype DkHaplotype Dk
Haplotype Frequency RtHaplotype Frequency Rt
Haplotype SkHaplotype Sk
Heterozygosity RtHeterozygosity Rt
Linkage Analysis DkLinkage Analysis Dk
Linkage Analysis SkLinkage Analysis Sk
Map Weight CntMap Weight Cnt
NCBI Entrez dbSNP DkNCBI Entrez dbSNP Dk
NCBI Entrez dbSNP SkNCBI Entrez dbSNP Sk
NCBI Entrez Gene DkNCBI Entrez Gene Dk
NCBI Entrez Gene SkNCBI Entrez Gene Sk
NCBI Entrez Pubmed DkNCBI Entrez Pubmed Dk
NCBI Entrez Pubmed SkNCBI Entrez Pubmed Sk
Patient DkPatient Dk
Patient SkPatient Sk
Publication DtPublication Dt
Sequence Variation DkSequence Variation Dk
Sequence Variation Fact BkSequence Variation Fact Bk
Sequence Variation Fact DkSequence Variation Fact Dk
Sequence Variation Fact SkSequence Variation Fact Sk
Sequence Variation SkSequence Variation Sk
SNP Type NumSNP Type Num
Source CdSource Cd
Source Code SkSource Code Sk
Specimen Detail SkSpecimen Detail Sk
Specimen DkSpecimen Dk
Study Case DkStudy Case Dk
Study Case SkStudy Case Sk
Study DkStudy Dk
Study SkStudy Sk
Study Subject DkStudy Subject Dk
Study Subject SkStudy Subject Sk
Tenant SkTenant Sk
Total Samples NumTotal Samples Num
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Sequence Variation Fact_Allele Dimension_FKSequence Variation Fact_Allele Dimension_FK
Sequence Variation Fact_DNA Sequence Dimension_FKSequence Variation Fact_DNA Sequence Dimension_FK
Sequence Variation Fact_Genotype Dimension_FKSequence Variation Fact_Genotype Dimension_FK
Sequence Variation Fact_Haplotype Dimension_FKSequence Variation Fact_Haplotype Dimension_FK
Sequence Variation Fact_Genotype Experiment Dimension_FKSequence Variation Fact_Genotype Experiment Dimension_FK
Sequence Variation Fact_Gene Dimension_FKSequence Variation Fact_Gene Dimension_FK
Sequence Variation Fact_Linkage Analysis Dimension_FKSequence Variation Fact_Linkage Analysis Dimension_FK
Sequence Variation Fact_DNA Sample Dimension_FKSequence Variation Fact_DNA Sample Dimension_FK
Sequence Variation Fact_Assay Dimension_FKSequence Variation Fact_Assay Dimension_FK
Sequence Variation Fact_Patient Dimension_FKSequence Variation Fact_Patient Dimension_FK
Sequence Variation Fact_NCBI Entrez dbSNP Dimension_FKSequence Variation Fact_NCBI Entrez dbSNP Dimension_FK
Sequence Variation Fact_NCBI Entrez Gene Dimension_FKSequence Variation Fact_NCBI Entrez Gene Dimension_FK
Sequence Variation Fact_NCBI Entrez Pubmed Dimension_FKSequence Variation Fact_NCBI Entrez Pubmed Dimension_FK
Sequence Variation Fact_Study Case Dimension_FKSequence Variation Fact_Study Case Dimension_FK
Sequence Variation Fact_Study Subject Dimension_FKSequence Variation Fact_Study Subject Dimension_FK
Sequence Variation Fact_Study Dimension_FKSequence Variation Fact_Study Dimension_FK
Sequence Variation Fact_Sequence Variation Dimension_FKSequence Variation Fact_Sequence Variation Dimension_FK
Sequence Variation Fact_Calendar Dimension_FKSequence Variation Fact_Calendar Dimension_FK
Sequence Variation Fact_Specimen Dimension_FKSequence Variation Fact_Specimen Dimension_FK

Primary Key
Sequence Variation Fact PKSequence Variation Fact PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

 Alelle Frequency Rt
DescriptionThe frequency of the allele in this cohort group.
The allele frequency represents the incidence of a gene variant in a population.
An allele frequency is calculated by dividing the number of times the allele of interest is observed in a population by the total number of copies of all the alleles at that particular genetic locus in the population.
Allele frequencies can be represented as a decimal, a percentage, or a fraction.
In a population, allele frequencies are a reflection of genetic diversity. Changes in allele frequencies over time can indicate that genetic drift is occurring or that new mutations have been introduced into the population.
Data TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Allele Cnt
DescriptionA particular microsatellite value (or count) identified at a sequence variation position.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Allele Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Allele Frequency Rt
DescriptionThe frequency that the allele has been found in individual or general populations.
An allele frequency is calculated by dividing the number of times the allele of interest is observed in an individual or population by the total number of copies of all the alleles at that particular genetic locus in the individual or population.
Allele frequencies can be represented as a decimal, a percentage, or a fraction.
Data TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Allele Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Performed Dt
DescriptionThe date upon which the assay was performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Chromosome Hits Cnt
DescriptionNumber of hits associated to the SNP aligning to multiple chromosomes.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Chromosome Num
DescriptionThe mapped chromosome number.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contiguous Hits Cnt
DescriptionNumber of hits that the SNP aligns with different contigs.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DNA Sample Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DNA Sample Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DNA Sequence Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DNA Sequence Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Experiment Dt
DescriptionThe date upon which the experimental characteristics were defined and recorded.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Gene Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Gene Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Genotype Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Genotype Experiment Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Genotype Experiment Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Genotype Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Haplotype Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Haplotype Frequency Rt
DescriptionThe known haplotype frequency in the individual or general population.
Data TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Haplotype Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Heterozygosity Rt
DescriptionThe heterozygosity or genetic diversity associated with the know Cohort samples. A measure of genetic variation in a population.

For example:
If an individual carries the gene for black hair and the gene for blond hair, we would say that individual is heterozygous for hair color. Heterozygosity may also refer to the percentage of locations on a chromosome that are heterozygous in an individual.
Heterozygosity may also refer to the percentage of locations on a chromosome that are heterozygous in an individual. These locations are called loci (the singular form is locus) and may contain more than one gene. The concept of heterozygosity is frequently extended from an individual to a population in the study of population genetics.
Heterozygosity in a population is calculated as follows:
1) Let pi be the frequency p of the allele that has an index number of i for a given locus. The value of pi may therefore range from 0 to 1.
2) Calculate the predicted heterozygosity for a single locus. This is given by the equation 1 - Σpi^2. Since the sum of the terms pi^2 is less than 1, the heterozygosity is a value between 0 and 1. Heterozygosity may therefore be expressed as a percentage.
3) Interpret the significance for the predicted heterozygosity at a single locus. The equation the equation 1 - Σpi^2 shows that the maximum heterozygosity occurs when the alleles for that locus are equally common. For example, for two equally common alleles, the heterozygosity is 1 - Σpi^2 = 1 - (1/2)^2 - (1/2)^2 = 1/2.
4) Calculate the predicted heterozygosity for multiple loci. In this case, we wish to find the average of the sum of the squares of the allele frequencies and subtract it from 1. Thus, the heterozygosity for multiple loci is 1 - 1/mΣΣpi^2.
5) Evaluate the observed heterozygosity of a population for a single locus. We have Ho = Σxi/n where Ho is the observed heterozygosity, n is the population and xi is 0 if the alleles in the individual with index i are equal and 1 if they are different.
Data TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Linkage Analysis Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Linkage Analysis Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Map Weight Cnt
DescriptionThe number of times a SNP map to the genome contig (range 1-10).

For example:
1 = snp aligns at exactly one locus
2 = snp aligns at two locus on same chromosome
3 = snp aligns at less than 10 locus
10= snp aligns at more than 10 locations
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez dbSNP Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez dbSNP Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez Gene Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez Gene Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez Pubmed Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 NCBI Entrez Pubmed Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Publication Dt
DescriptionThe date upon which the Single Nucleotide Polymorphism (SNP) is published.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sequence Variation Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Sequence Variation Fact Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sequence Variation Fact Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Sequence Variation Fact Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sequence Variation Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 SNP Type Num
DescriptionThe type of SNP i.e. Type, i.e. 1, 2 or 3
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Specimen Detail Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Specimen Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Case Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Case Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Subject Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Study Subject Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Total Samples Num
DescriptionThe number of samples analyzed to create these statistics.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Sequence Variation Fact_Allele Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAllele Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_DNA Sequence Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDNA Sequence Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Genotype Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGenotype Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Haplotype Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableHaplotype Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Genotype Experiment Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGenotype Experiment Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Gene Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGene Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Linkage Analysis Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLinkage Analysis Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_DNA Sample Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDNA Sample Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Assay Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAssay Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Patient Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_NCBI Entrez dbSNP Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableNCBI Entrez dbSNP Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_NCBI Entrez Gene Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableNCBI Entrez Gene Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_NCBI Entrez Pubmed Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableNCBI Entrez Pubmed Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Study Case Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStudy Case Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Study Subject Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStudy Subject Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Study Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStudy Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Sequence Variation Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSequence Variation Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Calendar Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Sequence Variation Fact_Specimen Dimension_FK
Is Identifying Relationshipfalse
Child TableSequence Variation Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSpecimen Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Sequence Variation Fact PK
Key AttributeSequence Variation Fact Dk