Business Data Model Data Model

Entity

Entity Pharmacy Order / Medication

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 Drug Substitution Indicator
Controlled Substance Schedule
Dispense Interval Days Cnt
Dispensing Pharmacy
Formulary Status
Give Per Time Unit Of Measure
Human Review Needed Ind
Initial Dispense Amt Qty
Last Refill Pharmacy
Medication
Multi Component
Number Refills Cnt
Number Refills Remaining Cnt
Original Order Ts
Pharmacy Order Source
Pharmacy Order Type
Prescription Num
Product Dispensed Method
Product Dispensed Package Size Qty
Product Dispensed Package Size Unit Of Measure
Recent Dispensed Product Ts
Refills Dispensed Cnt
Requested Dispense Calculated Unit Of Measure
Requested Dispense Code
Requested Dispense Qty
Requested Dispense Unit Of Measure
Requested Dosage Form
Requested Product Calculated Maximum Qty
Requested Product Calculated Minimum Qty
Requested Product Calculated Unit Of Measure
Requested Product Dosage Range Txt
Requested Product Maximum Qty
Requested Product Minimum Qty
Requested Product Rate Qty
Requested Product Rate Unit Of Measure
Requested Product Strength Qty
Requested Product Strength Unit Of Measure
Requested Product Strength Volume Qty
Requested Product Strength Volume Unit Of Measure
Requested Product Unit Of Measure
Substitution Status
Total Daily Dose Qty

Relationship
Pharmacy Order Medication_Pharmacy Order_FK
Pharmacy Order / Medication_Address_FK
Pharmacy Order / Medication_Point Of Care Location_FK
Pharmacy Order / Medication_Organization_FK
Pharmacy Order / Medication_Address_FK1
Pharmacy Order / Medication_Organization_FK1
Pharmacy Order / Medication_Point Of Care Location_FK1
Pharmacy Order / Medication_Practitioner_FK
Pharmacy Order / Medication_Practitioner_FK1
Pharmacy Order / Medication_Order Master_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Allow Drug Substitution Indicator

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

Controlled Substance Schedule

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispense Interval Days Cnt

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

Dispensing Pharmacy

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

Formulary Status

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Give Per Time Unit Of Measure

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Human Review Needed Ind

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

Initial Dispense Amt Qty

Description	The quantity dispensed on the original fill (first fill) of a prescription when that amount is not the same as the quantity to be used in refills. For example: A new medication is prescribed and the prescriber wants to determine if the patient tolerates the medication. The prescriber indicates that the medication must be filled for an initial quantity 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

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

Medication

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Multi Component

Description	Indicates that additional components exist.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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 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

Pharmacy Order Source

Description	Identifies the origin of pharmacy order data.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharmacy Order Type

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/Enumeration [VARCHAR(20)]
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

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/Enumeration [VARCHAR(20)]
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 Unit Of Measure

Description	Identifies the unit of measure in which Product Dispense Package Size is denominated.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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

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

Requested Dispense Calculated Unit Of Measure

Description	Identifies the unit of measure for the requested dispense calculated quantity. It does not include compound units. For Example: tablet mls suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense Code

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/Enumeration [VARCHAR(20)]
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 Unit Of Measure

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dosage Form

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/Enumeration [VARCHAR(20)]
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 quantity is the calculated maximum order amount. In a non-varying dose order, this quantity is the calculated exact amount of the order. Calculated orders can be based on 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 quantity is the calculated minimum order amount. In a non-varying dose order, this quantity is the calculated exact amount of the order. Calculated orders can be based on 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 Unit Of Measure

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/Enumeration [VARCHAR(20)]
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 quantity is the maximum order amount. In a non-varying dose order, this quantity 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 quantity is the minimum order amount. In a non-varying dose order, this quantity 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 Unit Of Measure

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/Enumeration [VARCHAR(20)]
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 Unit Of Measure

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/Enumeration [VARCHAR(20)]
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 Unit Of Measure

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Product Unit Of Measure

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Substitution Status

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
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

Relationship Details

Pharmacy Order Medication_Pharmacy Order_FK

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

Pharmacy Order / Medication_Address_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order / Medication
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	Address
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Order / Medication_Point Of Care Location_FK

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

Pharmacy Order / Medication_Organization_FK

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

Pharmacy Order / Medication_Address_FK1

Is Identifying Relationship	false
Child Table	Pharmacy Order / Medication
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	Address
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Order / Medication_Organization_FK1

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

Pharmacy Order / Medication_Point Of Care Location_FK1

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

Pharmacy Order / Medication_Practitioner_FK

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

Pharmacy Order / Medication_Practitioner_FK1

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

Pharmacy Order / Medication_Order Master_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order / Medication
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	Order Master
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model