Atomic Warehouse Model Data Model

Entity

Entity Pharmacy Order Medication Detail

Description

An association between a pharmacy order and a medication which include details of a medication included in a pharmacy order.

For example:
Total daily dose quantity
Dosage form

Attributes
Allow Substitution Code Sk
Controlled Substance Schedule Code Sk
Dispense Interval Minimum Days Cnt
Dispensing Pharmacy Code Sk
Effective From Dt
Effective To Dt
Formulary Status Code Sk
Human Review Needed Ind
Initial Dispense Qty
Last Refill Pharmacy Code Sk
Load Info Sk
Medication Code Txt
Multi Component Code Sk
Number Refills Cnt
Number Refills Remaining Cnt
Original Order Ts
Outpatient Refills Cnt
Pharmacy Order Medication Sk
Pharmacy Order Type Code Sk
Prescription Num
Product Dispensed Method Code Sk
Product Dispensed Package Size Qty
Product Dispensed Package Size UOM Code Sk
Recent Dispensed Product Ts
Requested Dispense Code Sk
Requested Dispense Qty
Requested Dispense UOM Code Sk
Requested Dosage Form Code Sk
Requested Give Per Time Unit Txt
Requested Product Calculated Maximum Qty
Requested Product Calculated Minimum Qty
Requested Product Calculated UOM Code Sk
Requested Product Dosage Range Txt
Requested Product Maximum Qty
Requested Product Minimum Qty
Requested Product Rate Qty
Requested Product Rate UOM Code Sk
Requested Product Strength Qty
Requested Product Strength UOM Code Sk
Requested Product Strength Volume Qty
Requested Product Strength Volume UOM Code Sk
Requested Product UOM Code Sk
Source Code Sk
Substitution Status Code Sk
Tenant Sk
Total Daily Dose Qty
Total Daily Dose Qty UOM Code Sk
Vaccine Ind
Valid From Ts
Valid To Ts

Relationship
Pharmacy Order Medication Detail_Pharmacy Order Medication _FK

Primary Key
Pharmacy Order Medication Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Allow Substitution Code Sk

Description	Indicates if drug substitutions are allowed for the Pharmacy Order.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Controlled Substance Schedule Code Sk

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

Dispense Interval Minimum Days Cnt

Description	Minimum number of days that must occur between dispensing events.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensing Pharmacy Code Sk

Description	Identifies the pharmacy responsible for dispensing the last medication order.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Formulary Status Code Sk

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

Human Review Needed Ind

Description	Indicates whether or not the pharmacist or non-pharmacist treatment supplier filling the order needs to pay special attention to the text in the provider's pharmacy/treatment instructions. It indicates whether a warning is present.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initial Dispense Qty

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

Last Refill Pharmacy Code Sk

Description	Identifies the pharmacy responsible for fulfilling the last medication order.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Medication Code Txt

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

Multi Component Code Sk

Description	Indicates that additional components exist.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Refills Cnt

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

Number Refills Remaining Cnt

Description	Number of times the Requested Dispense Quantity can be given to the patient. Refers to outpatient only.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Original Order Ts

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

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

Pharmacy Order Medication Sk

Description	Anchor surrogate key for the Pharmacy Order Medication data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Pharmacy Order Type Code Sk

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/Surrogate Key [INTEGER]
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 Dispensed Method Code Sk

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

Product Dispensed Package Size Qty

Description	The size of package to be dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Package Size UOM Code Sk

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

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

Requested Dispense Code Sk

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

Requested Dispense Qty

Description	The number of medication/treatment units to be dispensed to fulfill the medication order. For Example: 20 tablets 40 mls 4 suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense UOM Code Sk

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

Requested Dosage Form Code Sk

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

Requested Give Per Time Unit Txt

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

Requested Product Calculated Maximum Qty

Description	In a variable dose order, this is the calculated maximum order amount. In a non varying dose order, this is the calculated exact amount of the order. Calculated orders may be based a person's weight or laboratory results.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Calculated Minimum Qty

Description	In a variable dose order, this is the calculated minimum order amount. In a non varying dose order, this is the calculated exact amount of the order. Calculated orders may be based a person's weight or laboratory results.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Calculated UOM Code Sk

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

Requested Product Dosage Range Txt

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

Requested Product Maximum Qty

Description	In a variable dose order, this is the maximum order amount. In a non varying dose order, this is the exact amount of the order. Variable dose orders are for medications that require variable dosing based on laboratory test results.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Minimum Qty

Description	In a variable dose order, this is the minimum order amount. In a non varying dose order, this is the exact amount of the order. Variable dose orders are for medications that require variable dosing based on laboratory test results.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Rate Qty

Description	The rate at which the prescribed treatment/medication is to be administered. For Example: 150 mls/hr 4 liters/min
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Rate UOM Code Sk

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

Requested Product Strength Qty

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

Requested Product Strength UOM Code Sk

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

Requested Product Strength Volume Qty

Description	Volume measurement in which the product strength concentration is contained. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the requested product strength volume qty and mls is the requested product strength volume unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Strength Volume UOM Code Sk

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

Requested Product UOM Code Sk

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

Source 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

Substitution Status Code Sk

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

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Total Daily Dose Qty

Description	Total daily dose for this particular pharmaceutical as expressed in terms of actual dispense units.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Daily Dose Qty UOM 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

Vaccine Ind

Description	An indicator to identify if a pharmacy order medication is for an immunization vaccination medication.
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

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

Pharmacy Order Medication Detail_Pharmacy Order Medication _FK

Is Identifying Relationship	true
Child Table	Pharmacy Order Medication Detail
Child Role Name	for
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 Medication
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Pharmacy Order Medication Detail PK

Key Attribute	Pharmacy Order Medication Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model