| Dimensional Warehouse Model Data Model |
| Description | Contains linkage, linkage disequilibrium, and association data on Cohorts of Subjects. |
| Primary Key | |
 Linkage Analysis Dimension PK |
|
| Dependencies | |
 |
|
| |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Algorithm Txt
| Description | The algorithm use to define results. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
AWM Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Chi Square Rt
| Description | A statistical value. A measurement of how expectations compare to results. Chi Square is employed to test the difference between an actual sample and another hypothetical or previously established distribution such as that which may be expected due to chance or probability. Chi Square can also be used to test differences between two or more actual samples. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Current Ind
| Description | Set to 'Y' if this is the most recent row of a group having the same Surrogate Key. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Distance Qty
| Description | A statistical value. Physical distance between two loci |
| Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Distance UOM Cd
| Description | It is a unit of measure type for Physical distance between two loci. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Distance UOM Code Sk
| Description | It is a unit of measure type for Physical distance between two loci. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Distance UOM Descr
| Description | It is a unit of measure type for Physical distance between two loci. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
D Prime Rt
| Description | A statistical value. The amount of Linkage disequilibrium (LD) between the Quantitative Trait Locus (QTL) Analysis and the marker is specified as D-prime (0 d 1). A value of 0 indicates that the two loci are in complete equilibrium, whereas 1 represents the highest amount of disequilibrium possible is present (this amount depends of the relative allele frequencies of QTL and marker - i.e. complete disequilibrium could never be observed if the allele frequencies are different at QTL and marker). D-prime is related to other common measures of LD, such as R-squared (the square root of D-prime -- see the above mentioned article for further detail). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
DWM Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Linkage Analysis Bk
| Description | Concatenated values of a set of business attributes that uniquely identify the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Linkage Analysis Dk
| Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | true |
Linkage Analysis Sk
| Description | A numeric surrogate key used to uniquely identify entities in the atomic model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
LOD Score Rt
| Description | A statistical value. (logodds). The LOD score (logarithm (base 10) of odds), developed by Newton E. Morton, is a statistical test often used for linkage analysis in human, animal, and plant populations. The LOD score compares the likelihood of obtaining the test data if the two loci are linked, to the likelihood of observing the same data purely by chance. Positive LOD scores favor the presence of linkage, whereas negative LOD scores indicate that linkage is less likely. Computerized LOD score analysis is a simple way to analyze complex family pedigrees in order to determine the linkage between Mendelian traits (or between a trait and a marker, or two markers). By convention, a LOD score greater than 3.0 is considered evidence for linkage. A LOD score of +3 indicates 1000 to 1 odds that the linkage being observed did not occur by chance. On the other hand, a LOD score less than -2.0 is considered evidence to exclude linkage. Although it is very unlikely that a LOD score of 3 would be obtained from a single pedigree, the mathematical properties of the test allow data from a number of pedigrees to be combined by summing the LOD scores. It is important to keep in mind that this traditional cutoff of LOD+3 is an arbitrary one and that the difference between certain types of linkage studies, particularly analyses of complex genetic traits with hundreds of markers, these criteria should probably be modified to a somewhat higher cutoff. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Parameter Txt
| Description | The parameters used in the linkage analysis. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
P Value Rt
| Description | A statistical value. Measure of Statistical significance: P-value. It indicates the probability of obtaining results. That is whether the marker was not associated with variation for the trait. The lower the P-value, the higher the probability that a Quantitative Trait Locus (QTL) truly exists in the region of marker. Generally confidence in QTL is not fixed unless the P-value of the linked marker is less than 0.01. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Source Cd
| Description | The code that corresponds to the Source Code Sk. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Descr
| Description | The description that corresponds to the Source Type Cd. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Theta Rt
| Description | A statistical value. Theta is the recombinant fraction, it is equal to R / (NR + R) NR denotes the number of non-recombinant offspring, and R denotes the number of recombinant offspring. The reason 0.5 is used in the denominator is that any alleles that are completely unlinked (for example, alleles on separate chromosomes) have a 50% chance of recombination, due to independent assortment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes 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 Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Z mean Rt
| Description | A statistical value. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Primary Key Details |
Linkage Analysis Dimension PK
| Key Attribute | Linkage Analysis Dk |
| Dimensional Warehouse Model Data Model |