Dimensional Warehouse Model Data Model

Entity

Entity Medication Administration 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 Dosage Form Cd
Actual Dosage Form Code Sk
Administered Action Cd
Administered Action Code Sk
Administered Completion Status Cd
Administered Completion Status Code Sk
Administered Drug Strength Volume Qty
Administered Drug Strength Volume UOM Cd
Administered Drug Strength Volume UOM Code Sk
Administered Point Of Care Location Dk
Administered Point Of Care Location Sk
Administered Product Barcode Num
Administered Product Calculated Qty
Administered Product Calculated UOM Cd
Administered Product Calculated UOM Code Sk
Administered Product Qty
Administered Product Rate Cd
Administered Product Rate Code Sk
Administered Product Rate Txt
Administered Product Strength Qty
Administered Product Strength UOM Cd
Administered Product Strength UOM Code Sk
Administered Product UOM Cd
Administered Product UOM Code Sk
Administered Route Cd
Administered Route Code Sk
Administered Status Cd
Administered Status Code Sk
Administering Practitioner Dk
Administering Practitioner Sk
Administration Cnt
Administration Start Calendar Dk
Administration Start Ts
Administration Stop Calendar Dk
Administration Stop Ts
Administration Sub Id Cnt
AWM Load Info Sk
Base Unit Of Measure Cd
Base Unit Of Measure Code Sk
Body Site Cd
Body Site Code Sk
Consecutive Medication Administration Days Cnt
Conversion Factor Rt
Current Ind
Dispensed Cnt
Dispensed Event Type Cd
Dispensed Event Type Code Sk
Dispensed Point Of Care Location Dk
Dispensed Point Of Care Location Sk
Dispensed Product Calendar Dk
Dispensed Product Ts
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
Give Amount Maximum Qty
Give Amount Minimum Qty
Give Amount UOM Cd
Give Amount UOM Code Sk
Give Barcode Id
Give Calculated Amount Maximum Qty
Give Calculated Amount Minimum Qty
Give Calculated Amount UOM Cd
Give Calculated Amount UOM Code Sk
Give Cd
Give Cnt
Give Code Sk
Give Dosage Form Cd
Give Dosage Form Code Sk
Give Per Time Per Time Txt
Give Per Time Txt
Give Rate Qty
Give Rate UOM Cd
Give Rate UOM Code Sk
Give Strength Qty
Give Strength UOM Cd
Give Strength UOM Code Sk
Give Strength Volume Qty
Give Strength Volume UOM Cd
Give Strength Volume UOM Code Sk
Give Sub Id Cnt
Give Unit Qty
Give Unit UOM Cd
Give Unit UOM Code Sk
Healthcare Insurer Dk
Healthcare Insurer Sk
Health Plan Product Dk
Health Plan Product Sk
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 Administration Dk
Medication Administration Sk
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
Organization Dk
Organization Sk
Packaging Assembly Cd
Packaging Assembly Code Sk
Patient Dk
Patient Sk
Pharmacy Order Dispensed Sk
Pharmacy Order Dk
Pharmacy Order Sk
Pharmacy Order Type Cd
Pharmacy Order Type Code Sk
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
Recent Dispensed Product Calendar Dk
Recent Dispensed Product Ts
Refills Dispensed Cnt
Routing Instruction Txt
Source Cd
Source Code Sk
Standard Administered Route Code Sk
Standard Medication Code Sk
Substance Refusal Reason Cd
Substance Refusal Reason Code Sk
Substitution Status Cd
Substitution Status Code Sk
System Entry Ts
Tenant Sk
Total Daily Dose Qty
Total Daily Dose UOM Cd
Total Daily Dose UOM Code Sk
Valid From Ts
Valid To Ts

Relationship
Medication Administration_Encounter_FK
Medication Administration_Medication_FK
Medication Administration_Calendar_FK
Pharmacy Dispense_Practitioner_FK
Medication Administration_Provider_FK
Pharmacy Order Admin Practitioner_FK
Medication Administration_Patient_FK
Administered_Point Of Care Location_FK
Dispensed_Point Of Care Location_FK1
Medication Administration_Pharmacy Order_FK
Medication Administration Fact_Calendar Dimension_FK
Medication Administration Fact_Calendar Dimension_FK1
Medication Administration Fact_Calendar Dimension_FK2
Medication Administration Fact_Practitioner Dimension_FK
Medication Administration Fact_Provider Dimension_FK
Medication Administration Fact_Document Dimension_FK
Medication Administration Fact_Order Master Formulary Dimension_FK
Medication Administration Fact_Healthcare Insurer Dimension_FK
Medication Administration Fact_Health Plan Product Dimension_FK
Medication Administration Fact_Organization Dimension_FK

Primary Key
Medication Administration 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 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 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

Administered 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

Administered Completion Status Cd

Description	Indicates the state of medication administration event. For Example: Complete Ongoing To be started
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 Completion Status Code Sk

Description	Indicates the state of medication administration event. For Example: Complete Ongoing To be started
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 Drug Strength Volume Qty

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

Administered Drug Strength Volume UOM Cd

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

Administered Drug Strength Volume UOM Code Sk

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

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

Administered Product Calculated Qty

Description	The calculated amount of the substance administered. For Example: A calculated amount may be based on a person's weight. A doctor orders 5 mg/kg of Bretylium IV to be administered to a patient which means for every kilogram of patient, give 5 mg of Bretylium. If the patient weighs 80kgs, then the calculated unit qty is 400 and the calculated unit of measure is mgs (400mgs of Bretylium IV).
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

Administered Product Calculated UOM Cd

Description	The unit of measure of the calculated quantity of the substance administered. It does not include compound units. For Example: A calculated amount may be based on a person's weight. A doctor orders 5 mg/kg of Bretylium IV to be administered to a patient which means for every kilogram of patient, give 5 mg of Bretylium. If the patient weighs 80kgs, then the calculated unit qty is 400 and the calculated unit of measure is mgs (400mgs of Bretylium IV).
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 Product Calculated UOM Code Sk

Description	The unit of measure of the calculated quantity of the substance administered. It does not include compound units. For Example: A calculated amount may be based on a person's weight. A doctor orders 5 mg/kg of Bretylium IV to be administered to a patient which means for every kilogram of patient, give 5 mg of Bretylium. If the patient weighs 80kgs, then the calculated unit qty is 400 and the calculated unit of measure is mgs (400mgs of Bretylium IV).
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 Product Qty

Description	The number of medication units/treatment products administered to the person. For Example: 2 Capsules
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

Administered Product Rate Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Administered Product Rate Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Administered 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

Administered Product Strength Qty

Description	The numeric part of the strength used in combination with Administered Product Strength Unit of Measure. For Example: Acetaminophen 500mgs. The administered product strength quantity is 500 and the administered product strength unit of measure is mgs.
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

Administered Product Strength UOM Cd

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

Administered Product Strength UOM Code Sk

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

Administered Product UOM Cd

Description	The unit of measure in which the administered product quantity is expressed. For Example: 2 Capsules
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 Product UOM Code Sk

Description	The unit of measure in which the administered product quantity is expressed. For Example: 2 Capsules
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 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

Administered Status Cd

Description	Indicates the state of medication administration event. For Example: Complete Ongoing To be started
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 Status Code Sk

Description	Indicates the state of medication administration event. For Example: Complete Ongoing To be started
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 Cnt

Description	Used to count fact rows. Always set to 1.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Default Value	1
Is Part Of PrimaryKey	false
Is Required	false
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 Start Ts

Description	The date and time the medication administration starts or the date and time the rate for a continuous order (for example: IV Fluids) is changed after the administration has started.
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

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

Administration Stop Ts

Description	The date and time the medication administration is completed or stopped.
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

Administration Sub Id Cnt

Description	The number of times the medication/treatment is administered for this 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

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

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

Give Amount Maximum Qty

Description	In a variable dose order, this is the maximum order amount. In a nonvarying 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

Give Amount Minimum Qty

Description	In a variable dose order, this is the minimum order amount. In a nonvarying 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

Give Amount 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

Give Amount 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

Give Barcode Id

Description	A pharmacy system's assigned barcode number for a give occurrence. For Intravenous orders, many pharmacy systems generate a barcode number to identify a specific bag/bottle of the order. This number can be an instance identifier; unique for the patient, drug combination, and schedule instance or it may be just a drug identifier.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Give Calculated Amount Maximum Qty

Description	In a variable dose order, this is the calculated maximum order amount. In a nonvarying 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

Give Calculated Amount Minimum Qty

Description	In a variable dose order, this is the calculated minimum order amount. In a nonvarying 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

Give Calculated Amount UOM Cd

Description	The units of measure in which the calculated give amount quantities are 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

Give Calculated Amount UOM Code Sk

Description	The units of measure in which the calculated give amount quantities are 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

Give Cd

Description	Anchor surrogate key for the Pharmacy Order Medication data.
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

Give Cnt

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

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

Give Dosage Form Cd

Description	Indicates the 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

Give Dosage Form Code Sk

Description	Indicates the 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

Give Per Time Per Time Txt

Description	Identifies the time unit of measure (UOM) to be 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

Give Per Time Txt

Description	Identifies the time unit of measure (UOM) to be 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

Give 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 Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Give Rate UOM Cd

Description	The units of measure in which the give rate amount 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

Give Rate UOM Code Sk

Description	The units of measure in which the give rate amount 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

Give Strength Qty

Description	The numeric part of the strength used in combination with Give Strength Unit of Measure. For Example: Acetaminophen 500mgs. The give strength quantity is 500 and the give strength unit of measure is mgs.
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

Give Strength UOM Cd

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

Give Strength UOM Code Sk

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

Give 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 give strength volume qty and mls is the give 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

Give Strength Volume UOM Cd

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

Give Strength Volume UOM Code Sk

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

Give Sub Id Cnt

Description	A numeric value indicating the number of times information related to the medication/treatment administration instructions is delivered. Starts with 1, the first time the medication/treatment administration instructions for the order are delivered. Increments by one with each additional delivery.
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

Give Unit Qty

Description	The number of medication/treatment units to be given. For Example: 5 tablets 10 mls 1 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

Give Unit UOM Cd

Description	The units of measure in which the give units quantity is expressed. This must be in simple units that reflect the actual quantity of the substance to be administered. 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

Give Unit UOM Code Sk

Description	The units of measure in which the give units quantity is expressed. This must be in simple units that reflect the actual quantity of the substance to be administered. 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

Healthcare Insurer 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

Healthcare Insurer 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

Health Plan Product 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

Health Plan Product 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

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

Medication Administration 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	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	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/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

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

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

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

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

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

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

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

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

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

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

Relationship Details

Medication Administration_Encounter_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration_Medication_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration_Calendar_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Medication Administration 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

Medication Administration_Provider_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Medication Administration 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

Medication Administration_Patient_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Medication Administration 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	Medication Administration 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

Medication Administration_Pharmacy Order_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Medication Administration 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	Medication Administration 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	Medication Administration 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

Medication Administration Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration Fact_Provider Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration Fact_Document Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration Fact_Order Master Formulary Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration Fact_Healthcare Insurer Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Healthcare Insurer 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_Health Plan Product Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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	Health Plan Product 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_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Medication Administration 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

Medication Administration Fact PK

Key Attribute

Medication Administration Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model