Entity Fee Schedule / Formulary Tier

DescriptionAn association between a fee schedule and formulary tier.

Attributes
Fee Schedule Formulary Tier Co-Payment AmtFee Schedule Formulary Tier Co-Payment Amt
Fee Schedule Formulary Tier Co-Payment PctFee Schedule Formulary Tier Co-Payment Pct

Relationship
Fee Schedule / Formulary Tier_Formulary Tier_FKFee Schedule / Formulary Tier_Formulary Tier_FK
Fee Schedule / Formulary Tier_Fee Schedule_FKFee Schedule / Formulary Tier_Fee Schedule_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Fee Schedule Formulary Tier Co-Payment Amt
DescriptionThe specific co-payment amount applying to all medications from the Formulary Tier associated with given Fee Schedule under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fee Schedule Formulary Tier Co-Payment Pct
DescriptionThe specific co-payment percentage applying to all medications from the Formulary Tier associated with given Fee Schedule under the terms of the given agreement.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Fee Schedule / Formulary Tier_Formulary Tier_FK
Is Identifying Relationshiptrue
Child TableFee Schedule / Formulary Tier
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFormulary Tier
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Fee Schedule / Formulary Tier_Fee Schedule_FK
Is Identifying Relationshiptrue
Child TableFee Schedule / Formulary Tier
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFee Schedule
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE