Business Data Model Data Model

Entity

Entity Pharmacy Order Dispense

Description

A healthcare event that results in the pharmacy order being filled and delivered to the dispensing unit/nursing station/patient location or directly to the patient so that the medication/treatment can be administered.

Attributes
Actual Compound Preparation Time
Actual Dosage Form
Completeness Ind
Compound Drug Ind
Compound Drug Preparation Minutes
Dispensed Alternative Drug Differential Amt
Dispensed Alternative Drug Reason Ind
Dispensed As Written
Dispensed Different Cost Drug Ind
Dispensed Product Ts
Dispensed Sub Id Cntr
Dispense To Pharmacy
Dispense Type
Drug Compound Ind
Formulary Ind
Generic Ind
Human Review Needed Ind
Incentive Amount Available
Ingredient Cost Basis
Ingredient Cost Paid
Initiating Location
Medication
Medication Batch Num
Number Refills Remaining Cnt
Packaging Assembly
Prescription Num
Product Dispensed Actual Qty
Product Dispensed Actual Strength Qty
Product Dispensed Actual Strength Unit Of Measure
Product Dispensed Actual Strength Vol
Product Dispensed Actual Strength Volume Unit Of Measure
Product Dispensed Actual Unit Of Measure
Product Dispensed Calculated Actual Qty
Product Dispensed Calculated Actual Qty Unit Of Measure
Product Dispensed Method
Product Dispensed Package Size Qty
Product Dispensed Package Size Unit Of Measure
Product Substitution Status
Rebate Amt
Refills Dispensed Cnt
Routing Instruction Txt
Total Daily Dose Qty
Total Daily Dose Unit Of Measure

Relationship
Pharmacy Order Dispensed_Address_FK
Pharmacy Order Dispensed For Pharmacy Order
Pharmacy Order Dispense_Medication Administration_FK
Pharmacy Order Dispensed Dispensing Provider
Pharmacy Order Dispense_Organization_FK
Pharmacy Order Dispense_Address_FK
Pharmacy Order Dispense_Practitioner_FK
Pharmacy Order Dispense_Organization_FK1
Pharmacy Order Dispense_Patient_FK
Pharmacy Order Dispense_Encounter_FK
Pharmacy Order Dispense_Plan Member_FK
Pharmacy Order Dispense_Pharmacy Order / Medication_FK
Pharmacy Order Dispense_Order Master_FK

Generalization
Generalization1

Dependencies
NONE

Reverse Dependencies

Attribute Details

Actual Compound Preparation Time

Description	Time in minutes including the setup and cleanup time to compound the prescription.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Dosage Form

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

Completeness Ind

Description	Code indicating whether the quantity dispensed is a partial fill or the completion of a partial fill. Used if inventory shortage does not allow the full quantity to be dispensed. For example: Completion Of Partial Fill Not Specified Partial Fill
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Compound Drug Ind

Description	Indicates whether this drug is a compound or not.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Compound Drug Preparation Minutes

Description	The time in minutes required to prepare compounded drugs.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensed Alternative Drug Differential Amt

Description	The cost differential of the medication substituted for the initially prescribed medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensed Alternative Drug Reason Ind

Description	Indicates the reason the pharmacy dispensed a substitute for the prescribed medication. For example: Generic substitution Lower price Out of stock
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensed As Written

Description	Indicates that the dispense was filled exactly to the written order on the prescription.
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

Dispensed Different Cost Drug Ind

Description	Indicates that the pharmacy substituted a medication at a different price than the initially prescribed medication. For example: Higher Price Lower Price Similar to prescribed
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
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	false
Is Derived	false
Is Surrogate Key	false

Dispensed Sub Id Cntr

Description	Sequence number of the issuance. The initial value is 1 for the first medication dispense or treatment delivery and is incremented 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

Dispense To Pharmacy

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

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

Drug Compound Ind

Description	Indicates either 'Base' or 'Additive' for the compound drug or an IV solution. Formulary drugs are called Compounded Drugs and this indicator should be used where the compounded Drug is made up of multiple individual drug codes (most acute care centers do use one codification for a compound drug).
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

Formulary Ind

Description	Indicates if the medication is on or off the organization's formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Generic Ind

Description	Indicates if the medication is generic or branded.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Human Review Needed Ind

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

Incentive Amount Available

Description	Amount of pharmacy incentive available for substitution of a preferred medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ingredient Cost Basis

Description	Indicates the method of calculation used for the cost of ingredients in the relevant medication.
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

Ingredient Cost Paid

Description	The cost due to the ingredients in the medication dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initiating Location

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

Medication Batch Num

Description	The manufacturer's lot number for the dispensed medication/treatment. For Example: Vaccine lot number used in immunization
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

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

Packaging Assembly

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

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

Product Dispensed Actual Strength Vol

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

Product Dispensed Actual Strength Volume Unit Of Measure

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

Product Dispensed Actual Unit Of Measure

Description	Indicates the unit of measure in which the product is dispensed.
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 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 Unit Of Measure

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

Product Dispensed Method

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

Product Substitution Status

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

Rebate Amt

Description	Manufacturer rebate on the dispensed medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Routing Instruction Txt

Description	Instructions for administration routing, especially in cases where more than one route of administration is possible. For example: Designating which IV line must 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

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 Unit Of Measure

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

Relationship Details

Pharmacy Order Dispensed_Address_FK

Description	This field specifies the address of the dispensing facility or the patient's location where the dispensing will occur.
Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
Child Role Name	dispensing pharmacy address
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	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Order Dispensed For Pharmacy Order

Description	It identifies the Pharmacy Orders which are dispensed.
Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Order Dispense_Medication Administration_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
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 Administration
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 Dispensed Dispensing Provider

Description	This field contains the provider ID of the person dispensing the pharmaceutical.
Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
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
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 Dispense_Organization_FK

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

Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
Child Role Name	dispensing pharmacy address
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 Dispense_Practitioner_FK

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

Pharmacy Order Dispense_Organization_FK1

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

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

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

Is Identifying Relationship	false
Child Table	Pharmacy Order Dispense
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	Plan Member
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 Dispense_Pharmacy Order / Medication_FK

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

Pharmacy Order Dispense_Order Master_FK

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

Generalization Details

Generalization1

Supertype	Healthcare Event
Subtype	Pharmacy Order Dispense
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model