| Business Data Model Data Model |
| Description | A 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 Description |
|
Formulary Tier Level |
|
Formulary Tier Name |
|
Standard Formulary Tier Co-Payment Amt |
|
Standard Formulary Tier Co-Payment Pct |
|
| Relationship | |
Formulary Tier_Formulary_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Formulary Tier Description
| Description | Detailed information about the formulary tier. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Tier Level
| Description | Identifies the formulary tier level within the whole formulary. For Example: First Tier Second Tier Third Tier |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Tier Name
| Description | The word or phrase used to identify the formulary tier. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Standard Formulary Tier Co-Payment Amt
| Description | The specific co-payment amount applied to all medications in a formulary tier if not specified for the individual medications. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Standard Formulary Tier Co-Payment Pct
| Description | The specific co-payment percentage applied to all medications on a formulary tier if not specified for the individual medications. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Formulary Tier_Formulary_FK
| Is Identifying Relationship | false |
| Child Table | Formulary Tier |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Formulary |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |