Entity Population Demographic Selection Criterion

DescriptionA population selection criterion that is used to include or exclude individuals based on characteristics such as age, gender and ethnicity.

Attributes
Birth Day NumBirth Day Num
Birth Month NumBirth Month Num
Birth Year NumBirth Year Num
Maximum Age NumMaximum Age Num
Minimum Age NumMinimum Age Num
Population GenderPopulation Gender

Relationship
Demographic Criterion_Geographic Area_FKDemographic Criterion_Geographic Area_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Birth Day Num
DescriptionIndicates the day of birth for the selected members.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth Month Num
DescriptionIndicates the month of birth for the selected members.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth Year Num
DescriptionIndicates the year of birth for the selected members.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Maximum Age Num
DescriptionIndicates the maximum age of the selected members.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Minimum Age Num
DescriptionIndicates the minimum age of the selected members.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Population Gender
DescriptionIdentifies the gender restriction for this population segment.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Demographic Criterion_Geographic Area_FK
Is Identifying Relationshipfalse
Child TablePopulation Demographic Selection Criterion
Child Role Nameresidence
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypePopulation Selection Criterion
SubtypePopulation Demographic Selection Criterion
Transform AsTABLE