Block Id TxtDbsnp Link TxtEffective From DtEffective To DtHap Id TxtHaplotype Frequency RtHaplotype SkHapSet Id TxtIndividual Population Code SkLoad Info SkMethod TxtSource Code SkTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A set of associated SNP alleles in a region of a chromosome that tend to be transmitted as a set. Haplotype is a set of genetic changes - usually a group of SNPs that tend to be inherited together. It could be called as a "gene neighborhood." Haplotype information is used to compare the genes of people affected by a disease with the genes of unaffected people. For example, this approach has revealed a genetic variation that substantially increases the risk of age-related macular degeneration, the leading cause of severe vision loss in older people. The information may be helpful in the future for disease screening and for the development of new therapies. |
| Relationship | |
 Haplotype Detail_Haplotype_FK |
|
| Primary Key | |
 Haplotype Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Block Id Txt
| Description | The block id for the haplotype block. Haplotypes are blocks of markers that are inherited together due to low recombination rates. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dbsnp Link Txt
| Description | A link to dbSNP web URL that contains reference information on the Haplotype. |
| 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 |
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 |
Hap Id Txt
| Description | The Hap ID from the HapMap project. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Haplotype Frequency Rt
| Description | The known haplotype frequency in the individual or general population. |
| 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 |
Haplotype Sk
| Description | The surrogate key for anchor Allele. |
| 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 | false |
HapSet Id Txt
| Description | The HapSet id from the HapMap project. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Individual Population Code Sk
| Description | Indicates whether the haplotype belongs to a patient who is a subject or a non-subject or population. |
| 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 |
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 |
Method Txt
| Description | The method used to determine haplotype. |
| 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 |
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 |
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 | true |
| 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 |
| Relationship Details |
Haplotype Detail_Haplotype_FK
| Is Identifying Relationship | true |
| Child Table | Haplotype Detail |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Haplotype |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Haplotype Detail PK
| Key Attribute | Haplotype Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |