Entity Pharmacy Coverage

DescriptionA coverage agreement covering medication prescribed by a physician or other authorized clinician.

Attributes
Branded Product Co-Payment AmtBranded Product Co-Payment Amt
Formulary Product Co-Payment AmtFormulary Product Co-Payment Amt
Generic Product Co-Payment AmtGeneric Product Co-Payment Amt
Non-Formulary Product Co-Payment AmtNon-Formulary Product Co-Payment Amt

Relationship
Pharmacy Network is involved in Pharmacy CoveragePharmacy Network is involved in Pharmacy Coverage
Pharmacy Coverage_Formulary_FKPharmacy Coverage_Formulary_FK

Generalization
Pharmacy Coverage_Coverage Agreement_GenPharmacy Coverage_Coverage Agreement_Gen

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Branded Product Co-Payment Amt
DescriptionThe amount of the co-pay for using a branded product under the terms of the pharmacy coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Formulary Product Co-Payment Amt
DescriptionThe amount of the co-pay for using a drug formulary product under the terms of the pharmacy coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Generic Product Co-Payment Amt
DescriptionThe amount of the co-pay for using a generic product under the terms of the pharmacy coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Non-Formulary Product Co-Payment Amt
DescriptionThe amount of the co-pay for using a product that is not a drug formulary product under the terms of the pharmacy coverage.
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

 Pharmacy Network is involved in Pharmacy Coverage
Is Identifying Relationshipfalse
Child TablePharmacy Coverage
Child Role Nameinvolves
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePharmacy Network
Parent Role Nameis involved in
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Pharmacy Coverage_Formulary_FK
Is Identifying Relationshipfalse
Child TablePharmacy Coverage
Child Role Nameis classified by
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFormulary
Parent Role Nameclassifies
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Pharmacy Coverage_Coverage Agreement_Gen
SupertypeCoverage Agreement
SubtypePharmacy Coverage
Transform AsTABLE