Atomic Warehouse Model Data Model

Entity

Entity Retail Pharmacy Order Dispense Detail

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 Code Sk
Days Supply Qty
Dispensed As Written Code Sk
Dispensed Not Sold Cnt
Dispensed Sub Identifier Cntr
Dispense Event Num
Dispense To Pharmacy Code Sk
Dispense Type Code Sk
Effective From Dt
Effective To Dt
Formulary Ind
Generic Ind
Human Review Needed Ind
Initiating Location Code Sk
Load Info Sk
Medication Code Txt
Multi Component Code Sk
Number Outpatient Refills Remaining Cnt
Packaging Assembly Code Sk
Partial Fill Bill Type Code Sk
Pharmacy Order Dispense Sk
Pharmacy Order Type Code Sk
Plan Dispense Num
Prescription Num
Product Dispensed Actual Qty
Product Dispensed Actual Strength Qty
Product Dispensed Actual Strength UOM Code Sk
Product Dispensed Actual Strength Volume Qty
Product Dispensed Actual Strength Volume UOM Code Sk
Product Dispensed Actual UOM Code Sk
Product Dispensed Calculated Actual Qty
Product Dispensed Calculated Actual Qty UOM Code Sk
Product Dispensed Method Code Sk
Product Dispensed Package Size Qty
Product Dispensed Package Size UOM Code Sk
Quantity Left Cnt
Reportable Sales Dt
Returned Dt
Returned To Stock Dt
Sold Ts
Source Code Sk
Submit Dispense Fee Amt
Substitution Status Code Sk
Tax Amt
Tenant Sk
Total Daily Dose Qty
Total Daily Dose UOM Code Sk
Valid From Ts
Valid To Ts
Will Call Picked Up Ts

Relationship
Pharmacy Order Dispensed Detail_Pharmacy Order Dispensed_FK

Primary Key
Retail Pharmacy Order Dispense Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Actual Dosage Form Code Sk

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

Days Supply Qty

Description	The number of days supply, typically of medication, that are represented on the claim line.
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

Dispensed As Written Code Sk

Description	Indicates that the dispense was filled exactly to the written order on the prescription.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispensed 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 Sub Identifier 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 Code Sk

Description	The dispensing retail pharmacy.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dispense Type Code Sk

Description	Identifies the type of dispensing event that occurred. For Example: Trial Quantity Balance Compassionate Fill New/Renew - Full Fill New/Renew - Part Fill Refill - Part Fill Refill - Full Fill Manufacturer Sample Trial Quantity Non-Prescription Fill
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Description	Identifies the pharmacy or other treatment dispensing service locations(for example, respiratory) that received the initial request. If Pharmacy A (the Intake/Receiving) receives a phone call from the patient requesting a medication refill, but stipulates that the prescription will be picked up in pharmacy B and in accordance with the business process the prescription will be packaged/assembled in Pharmacy C, then Pharmacy A is the Initiating Location.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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 dispensed by a retail pharmacy.
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 Outpatient 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.
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 Code Sk

Description	The pharmacy that packaged or assembled the pharmacy order/medication request.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Partial Fill Bill Type Code Sk

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

Pharmacy Order Dispense Sk

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

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

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 UOM Code Sk

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

Product Dispensed Actual Strength Volume Qty

Description	The volume measurement in which the drug strength concentration is contained for the dispensed medication/treatment. For example: Acetaminophen 120mg/5mls means that 120mg of the drug is in a solution with a volume of 5ml. 5 is the drug strength volume and mls is the actual strength volume unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Actual Strength Volume UOM Code Sk

Description	The volumetric unit of measure associated with Product Dispensed Actual Strength Volume. For example: Acetaminophen 120mg/5mls means that 120mg of the drug is in a solution with a volume of 5ml. 5 is the drug strength volume and mls is the actual strength volume unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Actual UOM Code Sk

Description	Indicates the unit of measure in which the product is dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Calculated Actual Qty

Description	The numerical value for the calculated actual quantity of the medication/treatment dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Calculated Actual Qty UOM Code Sk

Description	Identifies the unit of measure for the dispensed product calculated actual quantity. It does not include compound units. For Example: tablet mls suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dispensed Method Code Sk

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

Product Dispensed Package Size Qty

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

Product Dispensed Package Size UOM 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

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

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

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

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

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

Substitution Status Code Sk

Description	Identifies the status of the Product Substitution in the Pharmacy Order. For Example: No product selection indicated Substitution not allowed by prescriber Substitution allowed - patient requested product dispensed Substitution allowed - pharmacist selected product dispensed Substitution allowed - generic drug not in stock Substitution allowed - brand drug dispensed as a generic Substitution not allowed - brand drug mandated by law Substitution allowed - generic drug not available in marketplace A generic substitution was dispensed. No substitute was dispensed. This is equivalent to the default (null) value. A therapeutic substitution was dispensed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

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 being dispensed as expressed in terms of the actual dispense units. For Example: Erythromycin 250 mg 1 tablet 3 times a day means the total daily dose quantity amounts to 750mgs
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Daily Dose UOM Code Sk

Description	The unit of measure in which the total daily dose quantity is expressed. For example: mgs mls
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	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

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 Detail_Pharmacy Order Dispensed_FK

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

Primary Key Details

Retail Pharmacy Order Dispense Detail PK

Key Attribute	Pharmacy Order Dispense Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model