Business Data Model Data Model

Entity

Entity Pharmacy Order Give

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
Give Amount Maximum Qty
Give Amount Minimum Qty
Give Amount Unit Of Measure
Give Barcode Id
Give Calculated Amount Maximum Qty
Give Calculated Amount Minimum Qty
Give Calculated Amount Unit Of Measure
Give Calculated Units Unit Of Measure
Give Dosage Form
Give Per Time Unit Of Measure
Give Rate Amount Qty
Give Rate Unit Of Measure
Give Strength Qty
Give Strength Unit Of Measure
Give Strength Volume Qty
Give Strength Volume Unit Of Measure
Give Sub Identifier Cntr
Give Unit Of Measure
Give Units Qty
Human Review Needed Ind
Medication
Pharmacy Order Type
Substitution Status

Relationship
Pharmacy Order Give_Pharmacy Order_FK
Pharmacy Order Give_Organization_FK
Pharmacy Order Give_Organization_FK1
Pharmacy Order Give_Encounter_FK
Pharmacy Order Give_Patient_FK
Pharmacy Order Give_Plan Member_FK
Pharmacy Order Give_Pharmacy Order / Medication_FK
Pharmacy Order Give_Order Master_FK

Dependencies
NONE

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

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

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

Give Amount Unit Of Measure

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

Give Barcode Id

Description	A pharmacy system assigned bar code number for a give occurrence. For Intravenous orders, many pharmacy systems generate a bar code number to identify a specific bag or bottle of the order. This number can be an instance identifier, which is unique to the patient, drug combination and schedule instance or 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 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

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

Give Calculated Amount Unit Of Measure

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

Give Calculated Units Unit Of Measure

Description	Indicates the unit of measure (UOM) of the calculated quantity of the substance given.
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 Dosage Form

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

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

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

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

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

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

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

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

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

Relationship Details

Pharmacy Order Give_Pharmacy Order_FK

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

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

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

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

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

Is Identifying Relationship	false
Child Table	Pharmacy Order Give
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 Give_Pharmacy Order / Medication_FK

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

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