Formulary BarcodeFormulary Entry Compound IndFormulary Entry Co-Payment AmtFormulary Entry Co-Payment PctFormulary Entry Effective Date and TimeFormulary Entry Fee AmtProduct Dosage FormRoute TypeStrength QtyStrength Volume Unit Of Measure
| Business Data Model Data Model |
| Description | A collection of information that describes the addition of a medication or substance to the approved formulary. |
| Relationship | |
 Formulary_Formulary_FK |
|
| Formulary_Formulary_FK1 |
|
| Formulary Entry_Formulary Tier_FK |
|
| Formulary Entry_Order Master_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Formulary Barcode
| Description | The unique bar code for the formulary drug. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Entry Compound Ind
| Description | Indicates if the Formulary entry is a compound of other Formulary entries. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Entry Co-Payment Amt
| Description | The standard specific co-payment amount applied to a drug on this Formulary. |
| 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 |
Formulary Entry Co-Payment Pct
| Description | The standard specific co-payment percentage applied to a drug on this Formulary. |
| 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 |
Formulary Entry Effective Date and Time
| Description | Establishes a period where the set of attributes are true according to the business. The receiving system shall assume that any values that come across under this Formulary ID are now under the new formulary after this date and take appropriate steps to distinguish the old from the new entries. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Entry Fee Amt
| Description | The standard amount charged for the given drug on this Formulary. |
| 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 |
Product Dosage Form
| Description | Indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets Capsules Suppositories |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Route Type
| Description | Identifies the route of administration. For Example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Strength Qty
| Description | The numeric part of the strength used in combination with Strength Unit of Measure. For Example: Acetaminophen 500mgs. The strength quantity is 500. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Strength Volume Unit Of Measure
| Description | Identifies the units in which the volume of the medication is expressed. For example: Acetaminophen 500mgs. The unit of measure is mgs. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Formulary_Formulary_FK
| Label | compound |
| Is Identifying Relationship | false |
| Child Table | Formulary Entry |
| Child Role Name | compound |
| 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 Entry |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Formulary_Formulary_FK1
| Is Identifying Relationship | false |
| Child Table | Formulary Entry |
| Child Role Name | therapeutic interchange |
| 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 Entry |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Formulary Entry_Formulary Tier_FK
| Is Identifying Relationship | false |
| Child Table | Formulary Entry |
| 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 Tier |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Formulary Entry_Order Master_FK
| Is Identifying Relationship | false |
| Child Table | Formulary Entry |
| 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 | Order Master |
| 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 |