Dimensional Warehouse Model Data Model

Entity

Entity Pharmacy Utilization Analysis

Description

Pharmacists review drug utilization by specific order and/or administration to determine which patients or units within their facility have received specific medications. They may also monitor overall drug utilization using the DDD/DOT report to determine utilization trends and to decrease specific drug utilization such as high cost medications or antibiotics with an associated resistance trend. Pharmacy interventions are clinical recommendations used by pharmacists to track their interactions with other healthcare professionals regarding drug therapy.

Attributes
Aggregate Defined Daily Dose
Calendar Dk
Days Of Therapy Per 1000 Patient Days
Defined Daily Dose Per 1000 Patient Days
Dispensed But Not Administered
Encounter Dk
Lab Test Dk
Medication Dk
Number Of Alerts
Number Of Closed Interventions
Number Of Days Therapy
Number Of Events Associated With Interventions
Number Of Interventions
Number Of Open Interventions
Number Of Patient Days
Number Of Substitutions Dispensed
Ordered But Not Dispensed
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Ratio Of DDD To DOT
Ratio Of Interventions To Alerts
Specimen Dk
Total Dosage

Relationship
Pharmacy Utilization Analysis_Medication_FK
Pharmacy Utilization Analysis_Lab Test_FK
Pharmacy Utilization Analysis_Calendar_FK
Pharmacy Utilization Analysis_Point Of Care Location_FK
Pharmacy Utilization Analysis_Specimen_FK
Pharmacy Utilization Analysis_Provider_FK
Pharmacy Utilization Analysis_Patient_FK
Pharmacy Utilization Analysis_Encounter_FK
Pharmacy Utilization Analysis_Practitioner_FK

Primary Key
Pharmacy Utilization Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Aggregate Defined Daily Dose

Description	An aggregate total of the recommended adult daily dosages of a drug, as defined by the World Health Organization (WHO), for the days of drug treatment.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Days Of Therapy Per 1000 Patient Days

Description	A statistic based on a calculated count of days that patients received drug therapy for every 1000 patient days. Formula: [(A/B)*1000] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Defined Daily Dose Per 1000 Patient Days

Description	A statistic based on a calculated daily dosage of drug therapy for every 1000 patient days. Formula: [(A/B)*1000] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Dispensed But Not Administered

Description	A count of medications that were dispensed but were not subsequently administered to the patient as expected. This could be due to a change in the patient's condition including patient death, a new diagnosis or because the medications were ordered to be given to the patient in defined circumstances that did not, in fact, arise.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Lab Test Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Medication Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Number Of Alerts

Description	A count of alerts generated by the business rules defined or adopted by the healthcare organization. These can include test results outside expected ranges, patient vital signs, and unusual or conflicting drug therapy.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Closed Interventions

Description	A count of pharmacy interventions that have been resolved with no further action deemed necessary. A pharmacy intervention, where a pharmacist, queries or challenges a change to a patient's drug regimen, may be resolved by further changes to therapy, a reversal of the proposed therapy decision or by the intervention being overruled by the patient's physician.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Days Therapy

Description	A count of full days that patient was administered the medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Events Associated With Interventions

Description	A count of events, identified by the business rules defined or adopted by the healthcare organization, that relate to unusual or conflicting drug therapy leading to a pharmacy intervention.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Interventions

Description	A count of pharmacy interventions where a pharmacist, queries or challenges a change to a patient's drug regimen. Such interventions are typically on the grounds of potential harmful drug interactions, dosages or conflicting prescriptions from multiple physicians.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Open Interventions

Description	A count of pharmacy interventions that have not yet been resolved and require further review by the patients or their physicians.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Number Of Patient Days

Description	An aggregate count of patients in care each day during the reporting period. If a patient was in care for 6 days during the period that equates to 6 patient days. Therefore a 10 bed unit fully occupied during a 28 day reporting period would result in 280 patient days. Patient days are generally based on a patient count or census carried out at the same time each day, typically midnight in an inpatient setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Substitutions Dispensed

Description	A count of drugs dispensed where the medication actually dispensed was not the initially prescribed medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ordered But Not Dispensed

Description	A count of medications ordered but not dispensed. These could be medications that were not dispensed at all or where a smaller quantity was dispensed for any reason.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Point Of Care Location Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Ratio Of DDD To DOT

Description	A calculated ratio of the aggregate defined daily dose to the number of days of drug therapy. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Ratio Of Interventions To Alerts

Description	A calculated ratio of pharmacy interventions to alerts generated by the business rule defined or adopted by the healthcare organization. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Specimen Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	false

Total Dosage

Description	The aggregate amount of all medication administrations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Relationship Details

Pharmacy Utilization Analysis_Medication_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Lab Test_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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	Lab Test Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Calendar_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Point Of Care Location_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Specimen_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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	Specimen Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Provider_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Patient_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Encounter_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Utilization Analysis_Practitioner_FK

Is Identifying Relationship	true
Child Table	Pharmacy Utilization Analysis
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Pharmacy Utilization Analysis PK

Key Attribute	Provider Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Practitioner Dk
Key Attribute	Medication Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Calendar Dk
Key Attribute	Lab Test Dk
Key Attribute	Specimen Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model