Crude Mortality RtMembers CntPopulation DescrPopulation Name
| Business Data Model Data Model |
| Description | A set of individuals that share common characteristics. For example: Patients of a similar age. Health plan members living in the same geographic location. Female Hispanics. |
| Attributes | |
| Crude Mortality Rt |
|
| Members Cnt |
|
| Population Descr |
|
| Population Name |
|
| Relationship | |
 Population_Population_FK |
|
| Case_Population_Study_FK |
|
| Population_Haplotype_FK |
|
| Control_Population_Study_FK |
|
| Population_Patient_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Crude Mortality Rt
| Description | The mortality rate from all causes within a given population during a given period of time (generally one year). May be calculated against the population at the middle of the time period or against the average population during the time period. For example: Total number of deaths / total population at midyear. Expressed as rate per thousand. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Members Cnt
| Description | The size of the population expressed as a count of its members. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Population Descr
| Description | The textual representation of the characteristics, including inclusion and exclusion criteria that describes the population. This would include all subgroups as well. |
| 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 |
Population Name
| Description | A name that is given to the population group. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Population_Population_FK
| Description | A relationships that connects a larger (source) population with one or many population segments (targets) derived from it based on a selection criteria. |
| Is Identifying Relationship | false |
| Child Table | Population |
| Child Role Name | target population |
| 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 | Population |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Case_Population_Study_FK
| Is Identifying Relationship | false |
| Child Table | Population |
| Child Role Name | case |
| 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 | Study |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Population_Haplotype_FK
| Is Identifying Relationship | false |
| Child Table | Population |
| 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 | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Control_Population_Study_FK
| Is Identifying Relationship | false |
| Child Table | Population |
| Child Role Name | control |
| 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 | Study |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Population_Patient_FK
| Is Identifying Relationship | false |
| Child Table | Population |
| 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 | Patient |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |