Entity Formulary Tier

DescriptionA classification system that groups medications within the formulary. Drug formularies are typically organized across a number of tiers or levels in order to classify drugs for example by level of expense.

Attributes
Formulary Tier DescriptionFormulary Tier Description
Formulary Tier LevelFormulary Tier Level
Formulary Tier NameFormulary Tier Name
Standard Formulary Tier Co-Payment AmtStandard Formulary Tier Co-Payment Amt
Standard Formulary Tier Co-Payment PctStandard Formulary Tier Co-Payment Pct

Relationship
Formulary Tier_Formulary_FKFormulary Tier_Formulary_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Formulary Tier Description
DescriptionDetailed information about the formulary tier.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Formulary Tier Level
DescriptionIdentifies the formulary tier level within the whole formulary.

For Example:
First Tier
Second Tier
Third Tier
Data TypeStandards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Formulary Tier Name
DescriptionThe word or phrase used to identify the formulary tier.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Standard Formulary Tier Co-Payment Amt
DescriptionThe specific co-payment amount applied to all medications in a formulary tier if not specified for the individual medications.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Standard Formulary Tier Co-Payment Pct
DescriptionThe specific co-payment percentage applied to all medications on a formulary tier if not specified for the individual medications.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Formulary Tier_Formulary_FK
Is Identifying Relationshipfalse
Child TableFormulary Tier
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFormulary
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE