Business Data Model Data Model

Entity

Entity Retail Pharmacy Order Dispense

Description

A healthcare event that results in the pharmacy order being filled by a retail pharmacy and delivered to a patient or guardian so that the medication/treatment can be administered.

Attributes
Actual Dosage Form
Dispensed As Written
Dispensed Not Sold Cnt
Dispensed Product Ts
Dispensed Sub Id Cntr
Dispense Event Num
Dispense To Pharmacy
Dispense Type
Drug Compound Ind
Formulary Ind
Generic Ind
Human Review Needed Ind
Initiating Location
Medication
Medication Batch Num
Number Refills Remaining Cnt
Packaging Assembly
Partial Fill Bill Type
Plan Dispense Num
Point Of Sale Overridden Net Paid Amt
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
Quantity Left Cnt
Refills Dispensed Cnt
Reportable Sales Dt
Returned Dt
Returned To Stock Dt
Routing Instruction Txt
Sold Ts
Submit Dispense Fee Amt
Tax Amt
Total Daily Dose Qty
Total Daily Dose Unit Of Measure
Will Call Picked Up Ts

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_Order Master_FK
Pharmacy Order Dispense_Plan Member_FK

Generalization
Generalization1

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

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 Not Sold Cnt

Description	The number of units dispensed from the pharmacy's inventory not yet recorded as sold.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensed 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 Event Num

Description	Alphanumeric identification of the dispense set by the pharmacy.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispense 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 pharmacy'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 filling the order needs to pay special attention to the text in the practitioner'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

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

Partial Fill Bill Type

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

Plan Dispense Num

Description	Alphanumeric Medication Dispense Number as assigned by the payer's health plan.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Of Sale Overridden Net Paid Amt

Description	Net amount of sale after overrides.
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

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

Quantity Left Cnt

Description	Amount of the prescription left unfilled.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Reportable Sales Dt

Description	The date upon which the dispense event can be reported by the retail pharmacy as a sale.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Returned Dt

Description	The date upon which the entire dispensed medication amount is returned to the pharmacy. It must be unopened to be returned to inventory.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Returned To Stock Dt

Description	The date upon which the entire dispensed amount is returned to inventory.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Routing Instruction Txt

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

Sold Ts

Description	The date and time the dispense is considered sold to the customer.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Submit Dispense Fee Amt

Description	The amount of the prescription sales that is a dispense fee.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tax Amt

Description	The amount of the prescription sales amount that is sales tax.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Will Call Picked Up Ts

Description	The date and time the patient or guardian picked up or called in a prescription.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Pharmacy 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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	Retail 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_Order Master_FK

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

Pharmacy Order Dispense_Plan Member_FK

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

Generalization Details

Generalization1

Supertype	Healthcare Event
Subtype	Retail Pharmacy Order Dispense
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model