Inactive IndInactive Intervention ReasonInactive TsIntervention Change StatusIntervention JustificationPharmacy Intervention StatusPharmacy Intervention TypePrimary Consult IndReview IndSecondary Consult Ind
| Business Data Model Data Model |
| Description | A change in drug therapy that a clinical pharmacist recommends to the physician. The physician can adhere to these recommendations or reject them. |
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Inactive Ind
| Description | Indicates if a pharmacy intervention is no longer active or applicable. For example, an intervention may have recommended a change to an alternative medication that has been rejected by the patient or their physician. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Inactive Intervention Reason
| Description | Indicates the reason why the pharmacy intervention is no longer active. For example: NPO TPN Fistula Outside cultures Allergy Procedure Mutual decision Other Patient Discharged Approved ID consult decision Discontinued Patient Expired Order Expired BMT Febrile neutropenia ICU patient |
| 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 |
Inactive Ts
| Description | The date and time that the intervention was set to inactive. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Intervention Change Status
| Description | Indicates the change status of the pharmacy intervention. For example: No Change No change - concur Recommendation accepted Different change made Different change made - concur Recommendation not accepted |
| 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 |
Intervention Justification
| Description | Indicates the reason for the intervention status. This might reflect the reason a recommendation has been accepted or rejected. For example: Change in patient condition Went for Surgery |
| 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 |
Pharmacy Intervention Status
| Description | Indicates the overall status of the intervention. For example: Open Closed |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Pharmacy Intervention Type
| Description | Indicates how a recommendation to change drug therapy was made. For example: Verbal Written Written & Verbal |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Primary Consult Ind
| Description | An indicator that shows that the pharmacist or physician to whom the pharmacist made the intervention, recommended a consultation for the patient involved. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Review Ind
| Description | An indicator that shows whether there is a need for a superior to review these interventions for some higher purpose. For example: High-cost invention or length of time spent on the intervention. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Secondary Consult Ind
| Description | Indicates if another Physician consult is needed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Pharmacy Intervention_Clinical Order _FK
| Description | This relationship identifies the related Clinical order (Laboratory Orders) raised during Pharmacy Intervention. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | relates to |
| 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 | Clinical Order |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Pharmacy Order_FK
| Description | This relationship identifies the related Pharmacy Orders raised during Pharmacy Intervention. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | relates to |
| 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 | Pharmacy Order |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Notification_FK
| Description | This relationship identifies the manually created Pharmacy Interventions based on the Business Rule Events 'Notifications'. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | is created manually due to |
| 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 | Notification |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Practitioner_FK
| Description | This relationship identifies the intervening pharmacist for the Pharmacy Intervention. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | intervening pharmacist |
| 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 | Practitioner |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Orderable Item_FK
| Description | This relationship identifies the Orderable Items (lab tests) suggested by the Pharmacist during Pharmacy Intervention. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | pharmacist recommends lab test |
| 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 | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Practitioner_FK1
| Description | This relationship identifies the assigned pharmacist for the Pharmacy Intervention. |
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| Child Role Name | assigned pharmacist |
| 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 | Practitioner |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Encounter_FK
| Description | This relationship identifies encounters happened during/for the Pharmacy Intervention. |
| Is Identifying Relationship | true |
| Child Table | Pharmacy Intervention |
| Child Role Name | relates to |
| 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 | Encounter |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Patient_FK
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| 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 | Patient |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Pharmacy Intervention_Plan Member_FK
| Is Identifying Relationship | false |
| Child Table | Pharmacy Intervention |
| 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 | Plan Member |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Healthcare Event |
| Subtype | Pharmacy Intervention |
| Transform As | TABLE |
| Business Data Model Data Model |