Dimensional Warehouse Model Data Model

Entity

Entity Compound Drug Prescription Analysis

Description

The analysis of Compound Drug prescriptions to determine the amount and number of compounds prepared and dispensed.

Attributes
Actual Time to Prepare Compound Drugs
Calendar Dk
Compound Drug Dispensing Fee Amount
Compound Drug Number Of Days Supply
Compound Drug Prescription Lines Dispensed Amount
Compound Ingredient Dispensed Quantity
Compound Ingredient Drug Cost Paid
Compound Preparation Charge Amount
Compound Preparation Labor Cost
Cost Of Ingredient Drug Amount
Drug Vendor Rebate Amount
Geographic Area Dk
Group Dk
Ingredient Drug Vendor Rebate Amount
Ingredient Drug Volume
Ingredient Drug Weight
Medication Dk
Non-Professional Staff Time To Prepare Compounds
Number of Compound Drug Prescription Lines Dispensed
Number Of Compound Drugs Prepared Within 15 Minutes
Number Of Compound Drugs Prepared Within 30 Minutes
Number Of Compound Drugs Prepared Within 45 Minutes
Number Of Compound Drugs Prepared Within 60 Minutes
Number Of Prescription Lines Dispensed
Number of Refills
Percentage Compound Drug Lines Amount Dispensed
Percentage Compound Drug Lines Dispensed
Percentage Of Compound Drugs Prepared Within 15 Minutes
Percentage Of Compound Drugs Prepared Within 30 Minutes
Percentage Of Compound Drugs Prepared Within 45 Minutes
Percentage Of Compound Drugs Prepared Within 60 Minutes
Pharmacy Order Dispense Dk
Pharmacy Order Dk
Practitioner Dk
Prescription Lines Dispensed Amount
Provider Dk
Time to Prepare Compound Drugs

Relationship
Compound Drug Prescription Analysis_Geographic Area Dimension_FK
Compound Drug Prescription Analysis_Group Dimension_FK
Compound Drug Prescription Analysis_Medication Dimension_FK
Compound Drug Prescription Analysis_Pharmacy Order Dimension_FK
Compound Drug Prescription Analysis_Provider Dimension_FK
Compound Drug Prescription Analysis_Pharmacy Order Dispense Dimension_FK
Compound Drug Prescription Analysis_Calendar Dimension_FK
Compound Drug Prescription Analysis_Practitioner Dimension_FK

Primary Key
Compound Drug Prescription Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Actual Time to Prepare Compound Drugs

Description	The total time in minutes required to prepare compounded drugs.Total time includes the setup and cleanup time.
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

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

Compound Drug Dispensing Fee Amount

Description	The total dispensing fee amount charged, for dispensed compound prescriptions, during the period of analysis.
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

Compound Drug Number Of Days Supply

Description	The total of estimated number of days that prescriptions for compounded drug will last if taken according to prescriber instructions.
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

Compound Drug Prescription Lines Dispensed Amount

Description	The monetary value charged for of individual medications dispensed where the dispensed drug had to be prepared by the pharmacist by combining multiple ingredients.
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

Compound Ingredient Dispensed Quantity

Description	The total amount expressed in metric decimal units of the product included in the compound mixture.
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

Compound Ingredient Drug Cost Paid

Description	The total cost of the ingredients in the dispensed compound medication.
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

Compound Preparation Charge Amount

Description	The monetary value of charges issued to patients or payers relating to the preparation of compound drugs by the pharmacist.
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

Compound Preparation Labor Cost

Description	The monetary cost to the organization of the time spent preparing compound drugs by the pharmacist.
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

Cost Of Ingredient Drug Amount

Description	The cost of drugs used as ingredients in the preparation of a compound drug to be dispensed.
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

Drug Vendor Rebate Amount

Description	The monetary value of any vendor or manufacturer rebates related to the use of specific drugs. These are usually retrospective discounts applied to the use of drugs during a specified period above a certain weight or volume threshold.
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

Geographic Area 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

Group 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

Ingredient Drug Vendor Rebate Amount

Description	The monetary value of any vendor or manufacturer rebates related to the use of specific drugs in the preparation of compounds. These are usually retrospective discounts applied to the use of drugs during a specified period above a certain weight or volume threshold.
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

Ingredient Drug Volume

Description	The volume of drugs used in the preparation of compound drugs to be dispensed. This is used for ingredients that are measured by volume typically ml.
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

Ingredient Drug Weight

Description	The weight of drugs used in the preparation of compound drugs to be dispensed. This is used for ingredients that are measured by weight typically mg.
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

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

Non-Professional Staff Time To Prepare Compounds

Description	Time in minutes accounted for Non-professional activities such as setup-time or clean-up time during compound preparation. Formula: [A-B] (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	false
Is Surrogate Key	false

Number of Compound Drug Prescription Lines Dispensed

Description	The number of individual medications dispensed where the dispensed drug had to be prepared by the pharmacist by combining multiple ingredients.
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 Compound Drugs Prepared Within 15 Minutes

Description	The number of dispensed compound drugs prepared in 15 minutes or less. DUR/PPS Level of Effort Value for compound drugs prepared within 15 minutes is 11 according to NCPDP.
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 Compound Drugs Prepared Within 30 Minutes

Description	The number of dispensed compound drugs prepared in 30 minutes or less.DUR/PPS Level of Effort Value for compound drugs prepared within 30 minutes is 12 according to NCPDP.
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 Compound Drugs Prepared Within 45 Minutes

Description	The number of dispensed compound drugs prepared in 45 minutes or less. DUR/PPS Level of Effort Value for compound drugs prepared within 45 minutes is 13 according to NCPDP.
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 Compound Drugs Prepared Within 60 Minutes

Description	The number of dispensed compound drugs prepared in 60 minutes or less. DUR/PPS Level of Effort Value for compound drugs prepared within 60 minutes is 14 according to NCPDP.
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 Prescription Lines Dispensed

Description	The number of individual medications dispensed. This includes branded drugs, generic drugs and compounded drugs.
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 Refills

Description	The number of times the requested dispense amount can be given to the patient, subject to local regulation. Refers to outpatient only.
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

Percentage Compound Drug Lines Amount Dispensed

Description	The charged value of compound drugs dispensed expressed as a percentage of the total charged value of prescription lines dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Percentage Compound Drug Lines Dispensed

Description	The number of compound drugs dispensed expressed as a percentage of the total number of prescription lines dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Percentage Of Compound Drugs Prepared Within 15 Minutes

Description	The number of dispensed compound drugs prepared in 15 minutes or less expressed as percentage of the number of compound drugs dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Percentage Of Compound Drugs Prepared Within 30 Minutes

Description	The number of dispensed compound drugs prepared in 30 minutes or less expressed as percentage of the number of compound drugs dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Percentage Of Compound Drugs Prepared Within 45 Minutes

Description	The number of dispensed compound drugs prepared in 45 minutes or less expressed as percentage of the number of compound drugs dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Percentage Of Compound Drugs Prepared Within 60 Minutes

Description	The number of dispensed compound drugs prepared in 60 minutes or less expressed as percentage of the number of compound drugs dispensed. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
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

Pharmacy Order Dispense 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

Pharmacy Order 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

Prescription Lines Dispensed Amount

Description	The monetary value charged for individual medications dispensed. This includes branded drugs, generic drugs and compounded drugs.
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

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

Time to Prepare Compound Drugs

Description	The time in minutes required to prepare compounded drugs expressed in the equivalent level of effort times. For example a compound that takes 40 minutes to prepare is subject to a maximum chargeable level of effort equivalent to 30 minutes.
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

Relationship Details

Compound Drug Prescription Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Compound Drug Prescription Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Compound Drug Prescription Analysis_Medication Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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

Compound Drug Prescription Analysis_Pharmacy Order Dimension_FK

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

Compound Drug Prescription Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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

Compound Drug Prescription Analysis_Pharmacy Order Dispense Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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	Pharmacy Order Dispense Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Compound Drug Prescription Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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

Compound Drug Prescription Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Compound Drug Prescription 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

Compound Drug Prescription Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk
Key Attribute	Medication Dk
Key Attribute	Pharmacy Order Dk
Key Attribute	Pharmacy Order Dispense Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model