Business Data Model Data Model

Entity

Entity Medication Administration

Description

A healthcare event that results in the patient receiving the medication/treatment that was dispensed as requested by the pharmacy order. This type of information is captured for each instance of administration for an existing medication/treatment order.

Attributes
Administered Action Code
Administered Drug Strength Volume Qty
Administered Drug Strength Volume Unit Of Measure
Administered Product Barcode Num
Administered Product Calculated Unit Of Measure
Administered Product Calculated Unit Qty
Administered Product Dosage Form
Administered Product Qty
Administered Product Rate
Administered Product Strength Qty
Administered Product Strength Unit Of Measure
Administered Product Unit Of Measure
Administered Status
Administration Cntr
Administration Start Ts
Administration Stop Ts
Body Site
Consecutive Medication Administration Days Cnt
Drug Vehicle Code
Give Sub Identifier Cntr
Maximum Dose Qty
Medication
Negation Ind
Route Type
Routing Instruction Txt
Substance Refusal Reason
System Entry Ts

Relationship
Medication Administration Administered Pharmacy Order
Medication Administration_Point Of Care Location_FK
Medication Administration_Practitioner_FK1
Medication Administration_Practitioner_FK2
Medication Administration_Practitioner_FK
Medication Administration_Point Of Care Location_FK1
Medication Administration_Patient_FK
Medication Administration_PerformedSubstanceAdministration (Med Admin)_FK
Medication Administration_Encounter_FK
Medication Administration_Point Of Care Device_FK
Medication Administration_Pharmacy Order / Medication_FK
Medication Administration_Order Master_FK

Generalization
Generalization1

Dependencies
NONE

Reverse Dependencies

Attribute Details

Administered Action Code

Description	Status of record. The information in this field enables the use of the Medication Administration in the vaccine messages, where a method of correcting vaccination information transmitted with incorrect patient identifying information is needed. For example: Add Delete Update
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

Administered Drug Strength Volume Qty

Description	Volume measurement in which the drug strength concentration is contained. For Example: Acetaminophen 120mg/5mls. This means 120mgs of acetaminophen is mixed in a solution of 5mls. 5 is the drug strength volume qty and mls is the drug 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

Administered Drug Strength Volume Unit Of Measure

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

Administered Product Barcode Num

Description	The pharmacy system assigned bar code number for the give occurrence that can be an instance identifier unique for the patient, drug combination and schedule instance, and plays a part in bedside medication verification.
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

Administered Product Calculated Unit Of Measure

Description	The unit of measure of the calculated quantity of the substance administered. It does not include compound units. For Example: A calculated amount may be based on a person's weight. A doctor orders 5 mg/kg of Bretylium IV to be administered to a patient which means for every kilogram of patient, give 5 mg of Bretylium. If the patient weighs 80kgs, then the calculated unit qty is 400 and the calculated unit of measure is mgs (400mgs of Bretylium IV).
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

Administered Product Calculated Unit Qty

Description	The calculated amount of the substance administered. For Example: A calculated amount may be based on a person's weight. A doctor orders 5 mg/kg of Bretylium IV to be administered to a patient which means for every kilogram of patient, give 5 mg of Bretylium. If the patient weighs 80kgs, then the calculated unit qty is 400 and the calculated unit of measure is mgs (400mgs of Bretylium IV).
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

Administered Product Dosage Form

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

Administered Product Qty

Description	The number of medication units/treatment products administered to the person. For Example: 2 Capsules
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

Administered Product Rate

Description	The rate at which this medication/treatment was administered. This is conditional because it is required when a treatment is administered continuously at a prescribed rate. For Example: IV Normal Saline at 120mls/hr
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

Administered Product Strength Qty

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

Administered Product Strength Unit Of Measure

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

Administered Product Unit Of Measure

Description	The unit of measure in which the administered product quantity is expressed. For Example: 2 Capsules
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

Administered Status

Description	Indicates the state of medication administration event. For Example: Complete Ongoing To be started
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

Administration Cntr

Description	The number of times the medication/treatment is administered for this order.
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

Administration Start Ts

Description	The date and time the medication administration starts or the date and time the rate for a continuous order (for example: IV Fluids) is changed after the administration has started.
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

Administration Stop Ts

Description	The date and time the medication administration is completed or stopped.
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

Body Site

Description	The location of the body where the medication was administered.
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

Consecutive Medication Administration Days Cnt

Description	A derived counter that shows the number of consecutive days, as complete 24-hour periods, that a patient has had a particular medication administered. The counter is set to 1 on the first administration and does not increment until the first administration occurring at least 24 hours after the first administration. If it has been 24 hours or longer since the last administration, then the counter resets to 1 on the next administration.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Drug Vehicle Code

Description	The code for the means used to administer this 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

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

Maximum Dose Qty

Description	The maximum number of dosages of a prescribed medication for a patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [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

Negation Ind

Description	Indicates if the medication was refused by the patient.
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

Route Type

Description	Identifies the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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

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

Substance Refusal Reason

Description	Describes the reason why the patient refuses the medical substance/treatment.
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

System Entry Ts

Description	The date and time the administration information was entered into the source system. This field is used to detect instances where treatment administration information is inadvertently entered multiple times by providing a unique identification field. Under usual circumstances, this field is provided automatically by the computer system rather than entered by a person.
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

Medication Administration Administered Pharmacy Order

Description	This relationship identifies the Pharmacy Order which are administered or under administration.
Is Identifying Relationship	false
Child Table	Medication Administration
Child Role Name	administered
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

Medication Administration_Point Of Care Location_FK

Is Identifying Relationship	false
Child Table	Medication Administration
Child Role Name	administered location
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	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Practitioner_FK1

Is Identifying Relationship	false
Child Table	Medication Administration
Child Role Name	administering
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_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Practitioner_FK2

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

Medication Administration_Practitioner_FK

Is Identifying Relationship	false
Child Table	Medication Administration
Child Role Name	administering
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_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Point Of Care Location_FK1

Is Identifying Relationship	false
Child Table	Medication Administration
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	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Patient_FK

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

Medication Administration_PerformedSubstanceAdministration (Med Admin)_FK

Is Identifying Relationship	false
Child Table	Medication Administration
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Substance Administration
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Encounter_FK

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

Medication Administration_Point Of Care Device_FK

Is Identifying Relationship	false
Child Table	Medication Administration
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	Point Of Care Device
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medication Administration_Pharmacy Order / Medication_FK

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

Medication Administration_Order Master_FK

Is Identifying Relationship	false
Child Table	Medication Administration
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	Medication Administration
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model