Formulary Entry SkFormulary SkFormulary Tier SkLoad Info SkMedication Code SkOrder Master SkRelationship Type Code SkTenant Sk
| Atomic Warehouse Model Data Model |
| Description | An association between a formulary, a formulary tier, an order master, and a medication. It is an entry from catalog of medications approved for use within the modeled facility. Pharmacy orders will reference the order master used in formulary entry when processing pharmacy order medications, dispenses, administrations, and gives. |
| Attributes | |
| Formulary Entry Sk |
|
| Formulary Sk |
|
| Formulary Tier Sk |
|
| Load Info Sk |
|
| Medication Code Sk |
|
| Order Master Sk |
|
| Relationship Type Code Sk |
|
| Tenant Sk |
|
| Relationship | |
 Formulary Entry_Formulary_FK |
|
| Formulary Entry_Order Master_FK |
|
| Formulary Entry_Medication_FK |
|
| Formulary Entry_Formulary Tier_FK |
|
| Primary Key | |
 Formulary Entry PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Formulary Entry Sk
| Description | Anchor surrogate key for the Formulary Entry data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | true |
Formulary Sk
| Description | Anchor surrogate key for the Formulary data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Formulary Tier Sk
| Description | Anchor surrogate key for the Formulary Tier data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Medication Code Sk
| Description | Identifier of the medication represented by this Formulary entry. It may be null if the Formulary entry is a compound. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Order Master Sk
| Description | Anchor surrogate key for the Orderable Item data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Relationship Type Code Sk
| Description | Identifies the type of the relationship as defined in the business data model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Formulary Entry_Formulary_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 |
| 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 |
Formulary Entry_Medication_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 | Medication |
| 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 |
| Primary Key Details |
Formulary Entry PK
| Key Attribute | Formulary Entry Sk |
| Atomic Warehouse Model Data Model |