Atomic Warehouse Model Data Model

Entity

Entity Medication Administration Detail

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 Sk
Administered Completion Status Code Sk
Administered Drug Strength Volume Qty
Administered Drug Strength Volume UOM Code Sk
Administered Product Barcode Num
Administered Product Calculated Unit Qty
Administered Product Calculated UOM Code Sk
Administered Product Dosage Form Code Sk
Administered Product Rate Txt
Administered Product Strength Qty
Administered Product Strength UOM Code Sk
Administered Product Unit Qty
Administered Product Unit UOM Code Sk
Administered Qty
Administered UOM Code Sk
Administration Stop Ts
Administration Sub Identifier Cntr
Body Site Code Sk
Drug Vehicle Code Sk
Effective From Dt
Effective To Dt
Give Sub Identifier Cntr
Load Info Sk
Maximum Dose Qty
Medication Administration Sk
Medication Code Sk
Medication Code Txt
Negation Ind
Pharmacy Order Type Code Sk
Route Code Sk
Routing Instruction Txt
Source Code Sk
Substance Refusal Reason Code Sk
System Entry Ts
Tenant Sk
Vaccine Ind
Valid From Ts
Valid To Ts

Relationship
Medication Administration Detail_Medication Administration_FK

Primary Key
Medication Administration Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Administered Action Code Sk

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

Administered Completion Status Code Sk

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

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

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

Administered Product Barcode Num

Description	This is the pharmacy system's assigned barcode number for the give occurrence. This number 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 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 Calculated UOM Code Sk

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

Administered Product Dosage Form Code Sk

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

Administered Product Rate Txt

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/Text Medium [VARCHAR(255)]
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 UOM Code Sk

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

Administered Product Unit 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/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Administered Product Unit UOM Code Sk

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

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

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/Surrogate Key [INTEGER]
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

Administration Sub Identifier 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

Body Site Code Sk

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

Drug Vehicle Code Sk

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

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

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

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

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

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	true
Is Derived	false
Is Surrogate Key	false

Medication Code Txt

Description	The drug substance or treatment that has been given to a patient.
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

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

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

Route Code Sk

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

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

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

Substance Refusal Reason Code Sk

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

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 would be provided automatically by the computer system rather than being 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

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

Vaccine Ind

Description	Indicator to identify if a medication administration is for an immunization vaccination medication. Dependent on Medication Administration Detail Medication Code Sk.
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

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

Medication Administration Detail_Medication Administration_FK

Is Identifying Relationship	true
Child Table	Medication Administration 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	Medication Administration
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Medication Administration Detail PK

Key Attribute	Medication Administration Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model