Dimensional Warehouse Model Data Model

Entity

Entity Prescription Dispense Fact

Description

A healthcare event that results in the patient receiving the medication/treatment that was dispensed as requested by the pharmacy order. This type of information is captured for each instance of administration for an existing medication/treatment order.

Attributes
Action Cd
Action Code Sk
Actual Compound Preparation Tm
Actual Dosage Form Cd
Actual Dosage Form Code Sk
Administered Point Of Care Location Dk
Administered Point Of Care Location Sk
Administered Route Cd
Administered Route Code Sk
Administering Practitioner Dk
Administering Practitioner Sk
Administration Start Calendar Dk
Administration Stop Calendar Dk
AWM Load Info Sk
Base Unit Of Measure Cd
Base Unit Of Measure Code Sk
Body Site Cd
Body Site Code Sk
Compound Drug Ind
Compound Drug Preparation Minutes
Consecutive Medication Administration Days Cnt
Conversion Factor Rt
Current Ind
Dispensed Cnt
Dispensed Event Type Cd
Dispensed Event Type Code Sk
Dispensed Not Sold Cnt
Dispensed Point Of Care Location Dk
Dispensed Point Of Care Location Sk
Dispensed Product Calendar Dk
Dispensed Product Ts
Dispense Event Num
Dispense Sub Id Cnt
Dispense To Pharmacy Cd
Dispense To Pharmacy Code Sk
Dispense Type Cd
Dispense Type Code Sk
Dispensing Practitioner Dk
Dispensing Practitioner Sk
Dispensing Provider Dk
Dispensing Provider Sk
Document Dk
Document Sk
Drug Vehicle Cd
Drug Vehicle Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Encounter Dk
Encounter Provider Dk
Encounter Provider Sk
Encounter Sk
Formulary Dimension Dk
Formulary Ind
Generic Ind
Human Review Needed Ind
Initiating Location Cd
Initiating Location Code Sk
Input Unit Of Measure Cd
Input Unit Of Measure Code Sk
Maximum Dose Qty
Medication Cd
Medication Code Txt
Medication Dk
Multi Component Cd
Multi Component Code Sk
Negation Ind
Number Refills Remaining Cnt
Ordering Practitioner Dk
Ordering Practitioner Sk
Order Master Formulary Sk
Packaging Assembly Cd
Packaging Assembly Code Sk
Partial Fill Bill Type Cd
Partial Fill Bill Type Code Sk
Partial Fill Bill Type Descr
Patient Dk
Patient Sk
Pharmacy Dispense Dk
Pharmacy Dispense Sk
Pharmacy Order Detail Dk
Pharmacy Order Dispensed Sk
Pharmacy Order Dk
Pharmacy Order Sk
Pharmacy Order Type Cd
Pharmacy Order Type Code Sk
Plan Dispense Num
Prescription Num
Product Barcode Num
Product Dispensed Actual Qty
Product Dispensed Actual Strength Qty
Product Dispensed Actual Strength UOM Cd
Product Dispensed Actual Strength UOM Code Sk
Product Dispensed Actual Strength Volume Qty
Product Dispensed Actual Strength Volume UOM Cd
Product Dispensed Actual Strength Volume UOM Code Sk
Product Dispensed Actual UOM Cd
Product Dispensed Actual UOM Code Sk
Product Dispensed Calculated Actual Qty
Product Dispensed Calculated Actual Qty UOM Cd
Product Dispensed Calculated Actual Qty UOM Code Sk
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
Product Rate Txt
Product Substitution Status Cd
Product Substitution Status Code Sk
Quantity Left Cnt
Recent Dispensed Product Calendar Dk
Recent Dispensed Product Ts
Refills Dispensed Cnt
Reportable Sales Dt
Returned Dt
Returned To Stock Dt
Routing Instruction Txt
Sold Ts
Source Cd
Source Code Sk
Standard Administered Route Code Sk
Standard Medication Code Sk
Submit Dispense Fee Amt
Substance Refusal Reason Cd
Substance Refusal Reason Code Sk
Substitution Status Cd
Substitution Status Code Sk
System Entry Ts
Tax Amt
Tenant Sk
Timing Quantity Seq
Total Daily Dose Qty
Total Daily Dose UOM Cd
Total Daily Dose UOM Code Sk
Valid From Ts
Valid To Ts
Will Call Picked Up Ts

Relationship
Pharmacy Dispense Fact_Encounter_FK
Pharmacy Dispense Fact_Medication_FK
Pharmacy Dispense Fact_Calendar_FK
Pharmacy Dispense_Practitioner_FK
Pharmacy Dispense Fact_Provider_FK
Pharmacy Order Admin Practitioner_FK
Pharmacy Dispense Fact_Patient_FK
Administered_Point Of Care Location_FK
Dispensed_Point Of Care Location_FK1
Pharmacy Dispense Fact_Pharmacy Order_FK
Medication Administration Fact_Calendar Dimension_FK
Medication Administration Fact_Calendar Dimension_FK1
Medication Administration Fact_Calendar Dimension_FK2
Pharmacy Dispense Fact_Practitioner Dimension_FK
Pharmacy Dispense Fact_Provider Dimension_FK
Pharmacy Dispense Fact_Document Dimension_FK
Retail Pharmacy Dispense Fact_Pharmacy Order Timing Quantity Array_FK
Pharmacy Dispense Fact_Order Master Formulary Dimension_FK

Primary Key
Prescription Dispense Fact PK

Dependencies

Reverse Dependencies

Attribute Details

Action Cd

Description	Status of record. The information in this field enables the use of the Medication Administration in the vaccine messages, where a method of correcting vaccination information transmitted with incorrect patient identifying information is needed. For example: Add Delete Update
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

Action Code Sk

Description	Status of record. The information in this field enables the use of the Medication Administration in the vaccine messages, where a method of correcting vaccination information transmitted with incorrect patient identifying information is needed. For example: Add Delete Update
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

Actual Compound Preparation Tm

Description	Time in minutes including the setup and cleanup time to compound the prescription.
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

Actual Dosage Form Cd

Description	Identifies the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets 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

Actual Dosage Form Code Sk

Description	Identifies the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets 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

Administered 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

Administered 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

Administered Route Cd

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

Administered Route Code Sk

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

Administering 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

Administering 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

Administration Start 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

Administration Stop 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

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

Base Unit Of Measure Cd

Description	The generated unique key from the Common Code table for the Standardized base for the input Unit Of Measure.
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

Base Unit Of Measure Code Sk

Description	The generated unique key from the Common Code table for the Standardized base for the input Unit Of Measure.
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

Body Site Cd

Description	The location of the body where the medication was administered.
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

Body Site Code Sk

Description	The location of the body where the medication was administered.
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

Compound Drug Ind

Description	Indicates whether this drug is a compound or not.
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

Compound Drug Preparation Minutes

Description	The time in minutes required to prepare 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

Consecutive Medication Administration Days Cnt

Description	A derived counter that shows the number of consecutive days, as complete 24-hour periods, that a patient has had a particular medication administered. The counter is set to 1 on the first administration and does not increment until the first administration occurring at least 24 hours after the first administration. If it has been 24 hours or longer since the last administration, then the counter resets to 1 on the next administration.
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

Conversion Factor Rt

Description	The rate used to convert the identified UOM to the desired Standard UOM.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	true
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

Dispensed Cnt

Description	Starts with 1 the first time that medication/treatment is delivered/dispensed for this order. Increments by one with each additional issuance.
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

Dispensed Event Type Cd

Description	Identifies the type of dispensing event that occurred. For Example: Trial Quantity Balance Compassionate Fill New/Renew - Full Fill New/Renew - Part Fill Refill - Part Fill Refill - Full Fill Manufacturer Sample Trial Quantity Non-Prescription Fill
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

Dispensed Event Type Code Sk

Description	Identifies the type of dispensing event that occurred. For Example: Trial Quantity Balance Compassionate Fill New/Renew - Full Fill New/Renew - Part Fill Refill - Part Fill Refill - Full Fill Manufacturer Sample Trial Quantity Non-Prescription Fill
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

Dispensed Not Sold Cnt

Description	The number of units dispensed from the pharmacy's inventory not yet recorded as sold.
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

Dispensed 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

Dispensed 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

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

Dispensed Product Ts

Description	The date and time the medication/treatment is dispensed from the pharmacy or treatment supplier.
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

Dispense Event Num

Description	Alphanumeric identification of the dispense set by the pharmacy.
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

Dispense Sub Id Cnt

Description	A numeric value indicating the number of times a medication is delivered/dispensed for the order. Starts with 1 the first time the medication/treatment is dispensed for this order and increments by one with each additional dispense of the medication/treatment.
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

Dispense To Pharmacy Cd

Description	The dispensing pharmacy, typically a hospital's internal pharmacy or a retail pharmacy.
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

Dispense To Pharmacy Code Sk

Description	The dispensing pharmacy, typically a hospital's internal pharmacy or a retail pharmacy.
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

Dispense Type Cd

Description	Identifies the type of dispensing event that occurred. For Example: Trial Quantity Balance Compassionate Fill New/Renew - Full Fill New/Renew - Part Fill Refill - Part Fill Refill - Full Fill Manufacturer Sample Trial Quantity Non-Prescription Fill
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

Dispense Type Code Sk

Description	Identifies the type of dispensing event that occurred. For Example: Trial Quantity Balance Compassionate Fill New/Renew - Full Fill New/Renew - Part Fill Refill - Part Fill Refill - Full Fill Manufacturer Sample Trial Quantity Non-Prescription Fill
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

Dispensing 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

Dispensing 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

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

Drug Vehicle Cd

Description	The code for the means used to administer this medication.
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

Drug Vehicle Code Sk

Description	The code for the means used to administer this medication.
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

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

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 Ind

Description	Indicates if the medication is on or off the organization's formulary.
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

Generic Ind

Description	Indicates if the medication is generic or branded.
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

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

Initiating Location Cd

Description	Identifies the pharmacy or other treatment dispensing service locations(for example, respiratory) that received the initial request. If Pharmacy A (the Intake/Receiving) receives a phone call from the patient requesting a medication refill, but stipulates that the prescription will be picked up in pharmacy B and in accordance with the business process the prescription will be packaged/assembled in Pharmacy C, then Pharmacy A is the Initiating Location.
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

Initiating Location Code Sk

Description	Identifies the pharmacy or other treatment dispensing service locations(for example, respiratory) that received the initial request. If Pharmacy A (the Intake/Receiving) receives a phone call from the patient requesting a medication refill, but stipulates that the prescription will be picked up in pharmacy B and in accordance with the business process the prescription will be packaged/assembled in Pharmacy C, then Pharmacy A is the Initiating Location.
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

Input Unit Of Measure Cd

Description	The generated unique key from the Common Code table for the input Unit Of Measure.
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

Input Unit Of Measure Code Sk

Description	The generated unique key from the Common Code table for the input Unit Of Measure.
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

Maximum Dose Qty

Description	The maximum number of dosages of a prescribed medication for a patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medication Cd

Description	Indicates the medical substance or treatment that has been ordered, dispensed or given to a patient or the substance being tested for in a specimen.
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

Negation Ind

Description	Indicates if the medication was refused by the patient.
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

Number 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/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Packaging Assembly Cd

Description	The pharmacy that packaged or assembled the pharmacy order/medication request.
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

Packaging Assembly Code Sk

Description	The pharmacy that packaged or assembled the pharmacy order/medication request.
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

Partial Fill Bill Type Cd

Description	Indicates the billing type for any partial fill condition on the prescription.
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

Partial Fill Bill Type Code Sk

Description	Indicates the billing type for any partial fill condition on the prescription.
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

Partial Fill Bill Type Descr

Description	Indicates the billing type for any partial fill condition on the prescription.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
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	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

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

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

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

Pharmacy Order Type Cd

Description	Indicates whether the order is to be executed in an inpatient setting or an outpatient setting.
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

Pharmacy Order Type Code Sk

Description	Identifies the general category of pharmacy order which may be used to determine the processing path the order will take. For Example: Medication Form (Tablet, Capsule, Powder) IV Large Volume Solution (Total Parental Nutrition), Admixture, Solution, Drip
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

Plan Dispense Num

Description	Alphanumeric Medication Dispense Number as assigned by the payer's health plan.
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

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 Barcode Num

Description	This is the pharmacy system's assigned barcode number for the give occurrence. This number can be an instance identifier unique for the patient, drug combination, and schedule instance and plays a part in bedside medication verification.
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 Actual Qty

Description	Indicates the amount 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 Actual Strength Qty

Description	The numeric part of the strength of a single dosage unit of the dispensed product used in combination with Product Dispensed Actual Strength 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

Product Dispensed Actual Strength UOM Cd

Description	The unit of measure in which the product dispensed actual strength 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

Product Dispensed Actual Strength UOM Code Sk

Description	The unit of measure in which the product dispensed actual strength 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

Product Dispensed Actual Strength Volume Qty

Description	The volume measurement in which the drug strength concentration is contained for the dispensed medication/treatment. For example: Acetaminophen 120mg/5mls means that 120mg of the drug is in a solution with a volume of 5ml. 5 is the drug strength volume and mls is the actual strength volume unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Actual Strength Volume UOM Cd

Description	The volumetric unit of measure associated with Product Dispensed Actual Strength Volume. For example: Acetaminophen 120mg/5mls means that 120mg of the drug is in a solution with a volume of 5ml. 5 is the drug strength volume and mls is the actual 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

Product Dispensed Actual Strength Volume UOM Code Sk

Description	The volumetric unit of measure associated with Product Dispensed Actual Strength Volume. For example: Acetaminophen 120mg/5mls means that 120mg of the drug is in a solution with a volume of 5ml. 5 is the drug strength volume and mls is the actual 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

Product Dispensed Actual UOM Cd

Description	Indicates the unit of measure in which the product is dispensed.
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 Actual UOM Code Sk

Description	Indicates the unit of measure in which the product is dispensed.
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 Calculated Actual Qty

Description	The numerical value for the calculated actual quantity of the medication/treatment 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 Calculated Actual Qty UOM Cd

Description	Identifies the unit of measure for the dispensed product calculated actual quantity. It does not include compound units. 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

Product Dispensed Calculated Actual Qty UOM Code Sk

Description	Identifies the unit of measure for the dispensed product calculated actual quantity. It does not include compound units. 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

Product Dispensed Method Cd

Description	Identifies the method by which medication/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 medication/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

Product Rate Txt

Description	The rate at which this medication/treatment was administered. This is conditional because it is required when a treatment is administered continuously at a prescribed rate. For Example: IV Normal Saline at 120mls/hr
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

Product Substitution Status Cd

Description	Identifies the status of the Product Substitution in the Pharmacy Order. For Example: No product selection indicated Substitution not allowed by prescriber Substitution allowed - patient requested product dispensed Substitution allowed - pharmacist selected product dispensed Substitution allowed - generic drug not in stock Substitution allowed - brand drug dispensed as a generic Substitution not allowed - brand drug mandated by law Substitution allowed - generic drug not available in marketplace A generic substitution was dispensed. No substitute was dispensed. This is equivalent to the default (null) value. A therapeutic substitution was dispensed.
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 Substitution Status Code Sk

Description	Identifies the status of the Product Substitution in the Pharmacy Order. For Example: No product selection indicated Substitution not allowed by prescriber Substitution allowed - patient requested product dispensed Substitution allowed - pharmacist selected product dispensed Substitution allowed - generic drug not in stock Substitution allowed - brand drug dispensed as a generic Substitution not allowed - brand drug mandated by law Substitution allowed - generic drug not available in marketplace A generic substitution was dispensed. No substitute was dispensed. This is equivalent to the default (null) value. A therapeutic substitution was dispensed.
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

Quantity Left Cnt

Description	Amount of the prescription left unfilled.
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

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

Refills Dispensed Cnt

Description	The number of refills dispensed for a pharmacy order. This 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/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Reportable Sales Dt

Description	The date upon which the dispense event can be reported by the retail pharmacy as a sale.
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

Returned Dt

Description	The date upon which the entire dispensed medication amount is returned to the pharmacy. It must be unopened to be returned to inventory.
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

Returned To Stock Dt

Description	The date upon which the entire dispensed amount is returned to inventory.
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

Routing Instruction Txt

Description	Details on administration routing, especially in cases where more than one route of administration is possible. A typical case would be designating which IV line should be used when more than one IV line is a possible route for injection.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Sold Ts

Description	The date and time the dispense is considered sold to the customer.
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

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 Administered Route Code Sk

Description	Identifies the specific method requested for the administration of the drug or treatment to the patient. For Example: Dissolve Chew Dust Insert
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

Standard Medication Code Sk

Description	Indicates the medical substance or treatment that has been ordered, dispensed or given to a patient or the substance being tested for in a specimen.
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

Submit Dispense Fee Amt

Description	The amount of the prescription sales that is a dispense fee.
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

Substance Refusal Reason Cd

Description	Describes the reason why the patient refuses the medical substance/treatment.
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

Substance Refusal Reason Code Sk

Description	Describes the reason why the patient refuses the medical substance/treatment.
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

Substitution Status Cd

Description	Identifies the status of the Product Substitution in the Pharmacy Order. For Example: No product selection indicated Substitution not allowed by prescriber Substitution allowed - patient requested product dispensed Substitution allowed - pharmacist selected product dispensed Substitution allowed - generic drug not in stock Substitution allowed - brand drug dispensed as a generic Substitution not allowed - brand drug mandated by law Substitution allowed - generic drug not available in marketplace A generic substitution was dispensed. No substitute was dispensed. This is equivalent to the default (null) value. A therapeutic substitution was dispensed.
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

System Entry Ts

Description	The date and time the administration information was entered into the source system. This field is used to detect instances where treatment administration information is inadvertently entered multiple times by providing a unique identification field. Under usual circumstances, this field would be provided automatically by the computer system rather than being entered by a person.
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

Tax Amt

Description	The amount of the prescription sales amount that is sales tax.
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

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

Timing Quantity Seq

Description	For the first timing specification transmitted, the sequence number shall be 1; for the second timing specification, it shall be 2; and so on.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [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 UOM Cd

Description	The unit of measure in which the total daily dose quantity is expressed. For Example: mgs mls
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 UOM Code Sk

Description	The unit of measure in which the total daily dose quantity is expressed. For Example: mgs mls
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

Will Call Picked Up Ts

Description	The date and time the patient or guardian picked up or called in a prescription.
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

Relationship Details

Pharmacy Dispense Fact_Encounter_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Dispense Fact_Medication_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Dispense Fact_Calendar_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	administration start
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 Dispense_Practitioner_FK

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

Pharmacy Dispense Fact_Provider_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Admin Practitioner_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	administering
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 Dispense Fact_Patient_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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

Administered_Point Of Care Location_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	administered
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

Dispensed_Point Of Care Location_FK1

Is Identifying Relationship	false
Child Table	Prescription Dispense 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	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 Dispense Fact_Pharmacy Order_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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

Medication Administration Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	administration stop
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

Medication Administration Fact_Calendar Dimension_FK1

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	dispensed product
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

Medication Administration Fact_Calendar Dimension_FK2

Is Identifying Relationship	false
Child Table	Prescription Dispense Fact
Child Role Name	recently 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 Dispense Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Dispense Fact_Provider Dimension_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Dispense Fact_Document Dimension_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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

Retail Pharmacy Dispense Fact_Pharmacy Order Timing Quantity Array_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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 Timing Quantity Array
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Dispense Fact_Order Master Formulary Dimension_FK

Is Identifying Relationship	false
Child Table	Prescription Dispense 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

Primary Key Details

Prescription Dispense Fact PK

Key Attribute

Pharmacy Dispense Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model