Entity Population Financial Selection Criterion

DescriptionA population selection criterion that is used to include or exclude individuals based on their monetary income or wealth.

For example:
People with no earnings
Individuals earning over USD 100,000 per year

Attributes
CurrencyCurrency
Maximum Total Charges AmtMaximum Total Charges Amt
Minimum Total Charges AmtMinimum Total Charges Amt

Relationship
Financial Criterion_Healthcare Insurer_FKFinancial Criterion_Healthcare Insurer_FK
Financial Criterion_Payor_FKFinancial Criterion_Payor_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Currency
DescriptionThe currency that is used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Maximum Total Charges Amt
DescriptionIndicates the maximum total amount charged.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Minimum Total Charges Amt
DescriptionIndicates the minimum total amount charged.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Financial Criterion_Healthcare Insurer_FK
Is Identifying Relationshipfalse
Child TablePopulation Financial Selection Criterion
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableHealthcare Insurer
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Financial Criterion_Payor_FK
Is Identifying Relationshipfalse
Child TablePopulation Financial Selection Criterion
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePayor
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypePopulation Selection Criterion
SubtypePopulation Financial Selection Criterion
Transform AsTABLE