Dimensional Warehouse Model Data Model

Entity

Entity Pharmacy Order Fact

Description

An order that specifies the medications ordered for a patient. It includes any type of pharmacy order, including inpatient (unit dose and compound unit dose), outpatient, IVs, and hyperalimentation IVs (nutritional IVs), as well as other non-pharmacy treatments (respiratory therapy, oxygen and nursing treatments).

Attributes
Allow Substitution Code Sk
AWM Load Info Sk
Component Calculated Amount Qty
Component Calculated Amount UOM Cd
Component Calculated Amount UOM Code Sk
Controlled Substance Schedule Cd
Controlled Substance Schedule Code Sk
Current Ind
Dispense Interval Days Cnt
Dispensing Provider Dk
Dispensing Provider Sk
Document Dk
Document Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Encounter Dk
Encounter Provider Dk
Encounter Provider Sk
Encounter Sk
Entering Point Of Care Location Dk
Entering Point Of Care Location Sk
Entering Practitioner Dk
Entering Practitioner Sk
Formulary Dimension Dk
Formulary Status Cd
Formulary Status Code Sk
Give Per Time Txt
Human Review Needed Ind
Initial Dispense Amt Qty
Initial Dispense Amt UOM Cd
Initial Dispense Amt UOM Code Sk
Last Refill Provider Dk
Last Refill Provider Sk
Medication Cd
Medication Code Txt
Medication Dk
Multi Component Cd
Multi Component Code Sk
Number Outpatient Refills Dispensed Cnt
Number Outpatient Refills Remaining Cnt
Number Refills Qty
Number Refills UOM Cd
Number Refills UOM Code Sk
Order Discontinue Calendar Dk
Order Discontinue Ts
Ordering Practitioner Dk
Ordering Practitioner Sk
Order Master Formulary Sk
Organization Dk
Organization Sk
Original Order Calendar Dk
Original Order Ts
Patient Dk
Patient Point Of Care Location Dk
Patient Point Of Care Location Sk
Patient Sk
Permitted Number Refills Qty
Permitted Number Refills UOM Cd
Permitted Number Refills UOM Code Sk
Pharmacy Order Detail Bk
Pharmacy Order Detail Dk
Pharmacy Order Detail Sk
Pharmacy Order Dk
Pharmacy Order Sk
Prescription Num
Product Dispensed Method Cd
Product Dispensed Method Code Sk
Product Dispensed Package Size Qty
Product Dispensed Package Size UOM Cd
Product Dispensed Package Size UOM Code Sk
Recent Dispensed Product Calendar Dk
Recent Dispensed Product Ts
Requested Dispense Calculated UOM Cd
Requested Dispense Calculated UOM Code Sk
Requested Dispense Cd
Requested Dispense Code Sk
Requested Dispense Qty
Requested Dispense UOM Cd
Requested Dispense UOM Code Sk
Requested Dosage Form Cd
Requested Dosage Form Code Sk
Requested Give Per Time Unit Txt
Requested Product Calculated Maximum Qty
Requested Product Calculated Minimum Qty
Requested Product Calculated UOM Cd
Requested Product Calculated UOM Code Sk
Requested Product Dosage Range Txt
Requested Product Max Qty
Requested Product Min Qty
Requested Product Rate Qty
Requested Product Rate UOM Cd
Requested Product Rate UOM Code Sk
Requested Product Strength Qty
Requested Product Strength UOM Cd
Requested Product Strength UOM Code Sk
Requested Product Strength Volume Qty
Requested Product Strength Volume UOM Cd
Requested Product Strength Volume UOM Code Sk
Requested Product UOM Cd
Requested Product UOM Code Sk
Source Cd
Source Code Sk
Standard Medication Code Sk
Substitution Status Cd
Substitution Status Code Sk
Tenant Sk
Total Daily Dose Qty
Total Daily Dose Qty UOM Cd
Total Daily Dose Qty UOM Code Sk
Valid From Ts
Valid To Ts
Verifying Practitioner Dk
Verifying Practitioner Sk

Relationship
Pharmacy Order_Drug_FK
Pharmacy Order_Calendar_FK
Pharmacy Order_Location_FK
Verifying
Entering
Pharmacy Order_Patient_FK
Pharmacy Order_Encounter_FK
Pharmacy Order_Provider_FK
Pharmacy Order_Pharmacy Order Detail_FK
Pharmacy Order Fact_Calendar Dimension_FK
Pharmacy Order Fact_Practitioner Dimension_FK
Pharmacy Order Fact_Point Of Care Location Dimension_FK
Pharmacy Order Fact_Provider Dimension_FK
Pharmacy Order Fact_Provider Dimension_FK1
Pharmacy Order Fact_Calendar Dimension_FK1
Pharmacy Order Fact_Document Dimension_FK
Pharmacy Order Fact_Order Master Formulary Dimension_FK
Pharmacy Order Fact_Organization Dimension_FK

Primary Key
Pharmacy Order Fact PK

Dependencies

Reverse Dependencies

Attribute Details

Allow Substitution Code Sk

Description	Indicates if drug substitutions are allowed for the Pharmacy Order.
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

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Component Calculated Amount Qty

Description	The calculated number of units for the component amount.
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

Component Calculated Amount UOM Cd

Description	Indicates the calculated unit of measure (UOM) component of the specification of strength.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Component Calculated Amount UOM Code Sk

Description	Indicates the calculated unit of measure (UOM) component of the specification of strength.
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

Controlled Substance Schedule Cd

Description	Indicates whether or not the medication/treatment is a regulated drug. For Example: Morphine is considered a controlled substance
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Controlled Substance Schedule Code Sk

Description	Indicates whether or not the medication/treatment is a regulated drug. For Example: Morphine is considered a controlled substance
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
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

Dispense Interval Days Cnt

Description	Minimum number of days that must occur between dispensing events.
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

Dispensing 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensing Provider Sk

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

Document 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Document Sk

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

DWM 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

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter Provider Sk

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

Encounter Sk

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

Entering 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Entering Point Of Care Location Sk

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

Entering 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Entering Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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 Dimension 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Formulary Status Cd

Description	Specifies whether or not the medication/pharmaceutical substance is part of the local formulary. For Example: Pharmaceutical substance is in the formulary Pharmaceutical substance is NOT in the formulary Pharmaceutical substance is in the formulary, but restrictions apply Pharmaceutical substance is in the formulary, but guidelines apply
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Status Code Sk

Description	Specifies whether or not the medication/pharmaceutical substance is part of the local formulary. For Example: Pharmaceutical substance is in the formulary Pharmaceutical substance is NOT in the formulary Pharmaceutical substance is in the formulary, but restrictions apply Pharmaceutical substance is in the formulary, but guidelines apply
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

Give Per Time Txt

Description	Identifies the time unit of measure (UOM) used to calculate the rate at which the pharmaceutical/treatment is to be administered. This field is defined as conditional because it is required when the ordered substance is to be administered continuously at a prescribed rate (for example, certain IVs). For example, if the "give amount/units" are 300 ml and the "give per" time unit is hours, the rate is 300ml/hr and the duration of this dose is 1 hour. Thus the give amount and give per time unit define the duration of the service. For Example: Seconds Minutes Hours Days Weeks Months Indefinitely
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Human Review Needed Ind

Description	Indicates whether or not the pharmacist or non-pharmacist treatment supplier filling the order needs to pay special attention to the text in the provider's pharmacy/treatment instructions. It indicates whether a warning is present.
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

Initial Dispense Amt Qty

Description	The quantity dispensed on the original fill (first fill) of a prescription when that amount is not the same as the quantity to be used in refills. For example, a new medication is being prescribed and the prescriber wants to determine if the patient will tolerate the medication. The prescriber indicates that the medication should be filled for an initial amount of 30 tablets and, if tolerated, refilled using a quantity of 100 tablets.
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

Initial Dispense Amt UOM Cd

Description	The quantity dispensed on the original fill (first fill) of a prescription when that amount is not the same as the quantity to be used in refills. For example, a new medication is being prescribed and the prescriber wants to determine if the patient will tolerate the medication. The prescriber indicates that the medication should be filled for an initial amount of 30 tablets and, if tolerated, refilled using a quantity of 100 tablets.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initial Dispense Amt UOM Code Sk

Description	The quantity dispensed on the original fill (first fill) of a prescription when that amount is not the same as the quantity to be used in refills. For example, a new medication is being prescribed and the prescriber wants to determine if the patient will tolerate the medication. The prescriber indicates that the medication should be filled for an initial amount of 30 tablets and, if tolerated, refilled using a quantity of 100 tablets.
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

Last Refill 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Last Refill Provider Sk

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

Description	The drug or treatment that has been ordered by a healthcare practitioner.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Medication Code Txt

Description	The code for this Pharmacy Drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Multi Component Cd

Description	Indicates that additional components exist.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Multi Component Code Sk

Description	Indicates that additional components exist.
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

Number Outpatient Refills Dispensed Cnt

Description	The number of refills dispensed for a pharmacy order.
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 Outpatient Refills Remaining Cnt

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
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 Refills Qty

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Refills UOM Cd

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Refills UOM Code Sk

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
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 Discontinue 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order Discontinue Ts

Description	The date and time an order was stopped or discontinued.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Ordering 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Ordering Practitioner Sk

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

Order Master Formulary Sk

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

Organization 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Organization Sk

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

Original Order 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Original Order Ts

Description	The date and time when a medication was ordered for the first time by a healthcare practitioner.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Patient 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Patient Point Of Care Location Sk

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

Patient Sk

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

Permitted Number Refills Qty

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permitted Number Refills UOM Cd

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permitted Number Refills UOM Code Sk

Description	The number of remaining refills on the Pharmacy Order. This field is required when a prescription is dispensed to an outpatient. It is not relevant to inpatient treatment orders.
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

Pharmacy Order Detail Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

Pharmacy Order Detail Sk

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

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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Pharmacy Order Sk

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

Prescription Num

Description	A number that identifies the prescription. This field is equivalent in uniqueness to the pharmacy/treatment supplier filler order number. At some sites, this may be the pharmacy/treatment supplier (internal) sequential form. At other sites, this may be an external number.
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

Product Dispensed Method Cd

Description	Identifies the method by which treatment is dispensed. For Example: Traditional Unit Dose Floor Stock Automatic Dispensing
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Method Code Sk

Description	Identifies the method by which treatment is dispensed. For Example: Traditional Unit Dose Floor Stock Automatic Dispensing
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

Product Dispensed Package Size Qty

Description	The size of package to be dispensed.
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

Product Dispensed Package Size UOM Cd

Description	Identifies the unit of measure in which Product Dispense Package Size is denominated.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Package Size UOM Code Sk

Description	Identifies the unit of measure in which Product Dispense Package Size is denominated.
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

Recent Dispensed Product 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Recent Dispensed Product Ts

Description	The date and time of the most recent refill or dose dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Requested Dispense Calculated UOM Cd

Description	The units of measure in which the requested calculated product quantity is expressed. For Example: mls mgs
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense Calculated UOM Code Sk

Description	The units of measure in which the requested calculated product quantity is expressed. For Example: mls mgs
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

Requested Dispense Cd

Description	Indicates what is to be/was dispensed. It may be present in the order or not, depending on the application. It may be present in the order or not, depending on the application. If not present, and values are given for requested dispense amount and requested dispense units, the requested give code is assumed. If the requested dispense code does not include the dosage form, use the requested dosage form.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense Code Sk

Description	Indicates what is to be/was dispensed. It may be present in the order or not, depending on the application. It may be present in the order or not, depending on the application. If not present, and values are given for requested dispense amount and requested dispense units, the requested give code is assumed. If the requested dispense code does not include the dosage form, use the requested dosage form.
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

Requested Dispense Qty

Description	The number of medication/treatment units to be dispensed to fulfill the medication order. For Example: 20 tablets 40 mls 4 suppositories
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

Requested Dispense UOM Cd

Description	The units of measure in which the requested dispense qty is expressed. This must be in simple units that reflect the actual quantity of the substance to be dispensed. For Example: tablet mls suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense UOM Code Sk

Description	The units of measure in which the requested dispense qty is expressed. This must be in simple units that reflect the actual quantity of the substance to be dispensed. For Example: tablet mls suppositories
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

Requested Dosage Form Cd

Description	Identifies the dosage form. It indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablet Capsules Suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dosage Form Code Sk

Description	Identifies the dosage form. It indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablet Capsules Suppositories
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

Requested Give Per Time Unit Txt

Description	Identifies the time unit of measure (UOM) used to calculate the rate at which the pharmaceutical/treatment is to be administered. This field is defined as conditional because it is required when the ordered substance is to be administered continuously at a prescribed rate (for example, certain IVs). For example, if the "give amount/units" are 300 ml and the "give per" time unit is hours, the rate is 300ml/hr and the duration of this dose is 1 hour. Thus the give amount and give per time unit define the duration of the service. For Example: Seconds Minutes Hours Days Weeks Months Indefinitely
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Calculated Maximum Qty

Description	In a variable dose order, this is the calculated maximum order amount. In a non varying dose order, this is the calculated exact amount of the order. Calculated orders may be based a person's weight or laboratory results.
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

Requested Product Calculated Minimum Qty

Description	In a variable dose order, this is the calculated minimum order amount. In a non varying dose order, this is the calculated exact amount of the order. Calculated orders may be based a person's weight or laboratory results.
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

Requested Product Calculated UOM Cd

Description	The units of measure in which the requested calculated product quantity is expressed. For Example: mls mgs
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Calculated UOM Code Sk

Description	The units of measure in which the requested calculated product quantity is expressed. For Example: mls mgs
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

Requested Product Dosage Range Txt

Description	Identifies the range of the product dose. This field is used if a range is provided instead of discrete minimum and maximum quantities. Dose range orders are those in which the medication dose for each medication administration service may vary over a prescribed range depending on the patient's status.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Max Qty

Description	In a variable dose order, this is the maximum order amount. In a non varying dose order, this is the exact amount of the order. Variable dose orders are for medications that require variable dosing based on laboratory test results.
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

Requested Product Min Qty

Description	In a variable dose order, this is the minimum order amount. In a non varying dose order, this is the exact amount of the order. Variable dose orders are for medications that require variable dosing based on laboratory test results.
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

Requested Product Rate Qty

Description	The rate at which the prescribed treatment/medication is to be administered. For Example: 150 mls/hr 4 liters/min
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

Requested Product Rate UOM Cd

Description	The units of measure in which the requested product rate qty is expressed. For Example: mls/hr liters/min
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Rate UOM Code Sk

Description	The units of measure in which the requested product rate qty is expressed. For Example: mls/hr liters/min
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

Requested Product Strength Qty

Description	The numeric part of the strength used in combination with Requested Product Strength Unit of Measure. For Example: Acetaminophen 500mgs. The requested product strength quantity is 500 and the requested product strength unit of measure is mgs.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Strength UOM Cd

Description	The unit of measure in which the requested product strength quantity is expressed. For Example: Acetaminophen 500mgs. The requested product strength quantity is 500 and the requested product strength unit of measure is mgs.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Strength UOM Code Sk

Description	The unit of measure in which the requested product strength quantity is expressed. For Example: Acetaminophen 500mgs. The requested product strength quantity is 500 and the requested product strength unit of measure is mgs.
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

Requested Product Strength Volume Qty

Description	Volume measurement in which the product strength concentration is contained. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the requested product strength volume qty and mls is the requested product strength volume unit of measure.
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

Requested Product Strength Volume UOM Cd

Description	The volumetric unit associated with Requested Product Strength Volume Qty. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the requested product strength volume qty and mls is the requested product strength volume unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Strength Volume UOM Code Sk

Description	The volumetric unit associated with Requested Product Strength Volume Qty. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the requested product strength volume qty and mls is the requested product strength volume unit of measure.
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

Requested Product UOM Cd

Description	The units of measure in which the requested product quantity is expressed. For Example: mls mgs
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product UOM Code Sk

Description	The units of measure in which the requested product quantity is expressed. For Example: mls mgs
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

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
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

Standard Medication Code Sk

Description	The drug or treatment that has been ordered by a healthcare practitioner.
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

Substitution Status Cd

Description	Indicates whether substitutions are allowed for the medication/treatment. For Example: Substitutions are not authorized Allow generic substitutions Allow therapeutic substitutions
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Substitution Status Code Sk

Description	Indicates whether substitutions are allowed for the medication/treatment. For Example: Substitutions are not authorized Allow generic substitutions Allow therapeutic substitutions
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

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

Total Daily Dose Qty

Description	The total daily dose being ordered or dispensed as expressed in terms of the actual dispense units. For example: Erythromycin 250 mg 1 tablet 3 times a day means the total daily dose quantity amounts to 750mgs
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

Total Daily Dose Qty UOM Cd

Description	Identifies the time unit of measure (UOM) used to calculate the rate at which the pharmaceutical/treatment is to be administered. This field is defined as conditional because it is required when the ordered substance is to be administered continuously at a prescribed rate (for example, certain IVs). For example, if the "give amount/units" are 300 ml and the "give per" time unit is hours, the rate is 300ml/hr and the duration of this dose is 1 hour. Thus the give amount and give per time unit define the duration of the service. For Example: Seconds Minutes Hours Days Weeks Months Indefinitely
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Daily Dose Qty UOM Code Sk

Description	Identifies the time unit of measure (UOM) used to calculate the rate at which the pharmaceutical/treatment is to be administered. This field is defined as conditional because it is required when the ordered substance is to be administered continuously at a prescribed rate (for example, certain IVs). For example, if the "give amount/units" are 300 ml and the "give per" time unit is hours, the rate is 300ml/hr and the duration of this dose is 1 hour. Thus the give amount and give per time unit define the duration of the service. For Example: Seconds Minutes Hours Days Weeks Months Indefinitely
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

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
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

Verifying 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Verifying Practitioner Sk

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

Pharmacy Order_Drug_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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 Order_Calendar_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	discontinued
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 Order_Location_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	entering
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

Verifying

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	verifying
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

Entering

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	entering
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

Pharmacy Order_Patient_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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 Order_Encounter_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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 Order_Provider_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	last refill
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 Order_Pharmacy Order Detail_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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

Pharmacy Order Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	dispensed
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 Order Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	ordering
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

Pharmacy Order Fact_Point Of Care Location Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	patient
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 Order Fact_Provider Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	encounter
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 Order Fact_Provider Dimension_FK1

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	dispensing
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 Order Fact_Calendar Dimension_FK1

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
Child Role Name	orignal
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 Order Fact_Document Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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	Document Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Order Fact_Order Master Formulary Dimension_FK

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

Pharmacy Order Fact_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Fact
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	Organization 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 Order Fact PK

Key Attribute

Pharmacy Order Detail Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model