Atomic Warehouse Model Data Model

Entity

Entity Pharmacy Order Give Detail

Description

A set of details that relates to the drug/treatment to be given for administration. This can include information about a single scheduled drug administration for a drug or treatment or it maybe information about multiple drug administrations.

Attributes
Dispense Sub Identifier Cntr
Effective From Dt
Effective To Dt
Give Amount Maximum Qty
Give Amount Minimum Qty
Give Amount UOM Code Sk
Give Barcode Identifier Num
Give Calculated Amount Maximum Qty
Give Calculated Amount Minimum Qty
Give Calculated Amount UOM Code Sk
Give Calculated Units UOM Code Sk
Give Dosage Form Code Sk
Give Per Time Txt
Give Rate Amount Qty
Give Rate UOM Code Sk
Give Strength Qty
Give Strength UOM Code Sk
Give Strength Volume Qty
Give Strength Volume UOM Code Sk
Give Sub Identifier Cntr
Give Units Qty
Give Units UOM Code Sk
Human Review Needed Ind
Load Info Sk
Medication Code Sk
Medication Code Txt
Multi Component Code Sk
Pharmacy Order Give Sk
Pharmacy Order Type Code Sk
Source Code Sk
Substitution Status Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Pharmacy Order Give Detail_Pharmacy Order Give_FK

Primary Key
Pharmacy Order Give Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Dispense Sub Identifier Cntr

Description	A numeric value indicating the number of times a medication is delivered/dispensed for the order. Starts with 1 the first time the medication/treatment is dispensed for this order and increments by one with each additional dispense of the medication/treatment.
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

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

Give Amount Maximum Qty

Description	In a variable dose order, this is the maximum order amount. In a nonvarying 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

Give Amount Minimum Qty

Description	In a variable dose order, this is the minimum order amount. In a nonvarying 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

Give Amount 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

Give Barcode Identifier Num

Description	A pharmacy system's assigned barcode number for a give occurrence. For Intravenous orders, many pharmacy systems generate a barcode number to identify a specific bag/bottle of the order. This number can be an instance identifier; unique for the patient, drug combination, and schedule instance or it may be just a drug identifier.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Give Calculated Amount Maximum Qty

Description	In a variable dose order, this is the calculated maximum order amount. In a nonvarying 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

Give Calculated Amount Minimum Qty

Description	In a variable dose order, this is the calculated minimum order amount. In a nonvarying 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

Give Calculated Amount UOM Code Sk

Description	The units of measure in which the calculated give amount quantities are 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

Give Calculated Units UOM Code Sk

Description	The units of measure in which the calculated give amount quantities are 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

Give Dosage Form Code Sk

Description	Indicates the 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

Give Per Time Txt

Description	Identifies the time unit of measure (UOM) to be 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/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Give Rate Amount 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

Give Rate UOM Code Sk

Description	The units of measure in which the give rate amount 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

Give Strength Qty

Description	The numeric part of the strength used in combination with Give Strength Unit of Measure. For Example: Acetaminophen 500mgs. The give strength quantity is 500 and the give 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

Give Strength UOM Code Sk

Description	The unit of measure in which the give strength quantity is expressed. For Example: Acetaminophen 500mgs. The give strength quantity is 500 and the give 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

Give 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 give strength volume qty and mls is the give 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

Give Strength Volume UOM Code Sk

Description	The volumetric unit associated with Give Strength Volume Qty. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the give strength volume qty and mls is the give 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

Give Sub Identifier Cntr

Description	A numeric value indicating the number of times information related to the medication/treatment administration instructions is delivered. Starts with 1, the first time the medication/treatment administration instructions for the order are delivered. Increments by one with each additional delivery.
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

Give Units Qty

Description	The number of medication/treatment units to be given. For Example: 5 tablets 10 mls 1 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

Give Units UOM Code Sk

Description	The units of measure in which the give units quantity is expressed. This must be in simple units that reflect the actual quantity of the substance to be administered. 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

Human Review Needed Ind

Description	Indicates whether or not the person administering the drug or treatment needs to pay special attention to the text in the pharmacy/treatment supplier's special 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

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 Sk

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

Pharmacy Order Give Sk

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

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 Give Detail_Pharmacy Order Give_FK

Is Identifying Relationship	true
Child Table	Pharmacy Order Give Detail
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 Give
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 Give Detail PK

Key Attribute	Pharmacy Order Give Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model