Atomic Warehouse Model Data Model

Entity

Entity Pharmacy Intervention Medication Recommendation Detail

Description

The detailed recommendations that a clinical pharmacist makes in respect of a patient medication. The recommendation details include medication, route of the medication, dosage and frequency. The physician can adhere to these recommendations or reject them.

Attributes
Dosage Form Code Sk
Dose Qty
Dose Quantity UOM Code Sk
Dose Strength Qty
Dose Strength UOM Code Sk
Drug Strength Vol
Drug Strength Volume UOM Code Sk
Effective From Dt
Effective To Dt
Load Info Sk
Medication Code Sk
Pharmacy Intervention Sk
Recommendation Annotation Seq
Route Code Sk
Service Condition Txt
Service Conjunction Code Sk
Service Duration Qty
Service Duration UOM Code Sk
Service Explicit Tm
Service Instruction Txt
Service Occurrence Duration Qty
Service Occurrence Duration UOM Code Sk
Service Priority Code Sk
Service Relative Time Qty
Service Relative Time UOM Code Sk
Service Repeat Frequency Code Sk
Service Requested Start Ts
Service Requested Stop Ts
Service Total Occurrence Cnt
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Pharmacy Intervention Recommendation Detail_Pharmacy Intervention_FK

Primary Key
Pharmacy Intervention Medication Recommendation Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Dosage Form Code Sk

Description	Indicates the manner in which the 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

Dose Qty

Description	Specifies the number of doses to be given at each administration. For example, if two 75mg aspirin are to be given every 6 hours, the quantity would be 2 or if one Ampicillin 500 mg is to be given 4 times per day, the quantity would be 1.
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

Dose Quantity UOM Code Sk

Description	Identifies the units in which the dose quantity is expressed.
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

Dose Strength Qty

Description	The requested strength of the medication, for example, Ampicillin 500 mg four times a day. In this case the dose strength qty would be 500 and the units would be milligrams.
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

Dose Strength UOM Code Sk

Description	Indicates the units in which the dose strength quantity is expressed. These units can be a "compound quantity;" that is, the units may express a quantity per unit of time.
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 Strength Vol

Description	The volume measurement in which the drug strength concentration is contained. For example, Acetaminophen 120 MG/5ML Elixir means that 120 MG of the drug is in a solution with a volume of 5 ML.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Strength Volume UOM Code Sk

Description	Indicates the volumetric unit associated with the drug strength volume.
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

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	The tenant common code sk for the medication code used on the pharmacy intervention recommendation.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Pharmacy Intervention Sk

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

Recommendation Annotation Seq

Description	Relative order of this row for the Annotation information.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Route Code Sk

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

Service Condition Txt

Description	A textual description of the conditions under which the drug is to be given. For example, PRN pain, or to keep blood pressure below 110. This descriptive text indicates that human review is needed to determine how and when this drug should be given.
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

Service Conjunction Code Sk

Description	Indicates how the service should be delivered in relation to any other current service request. For example: Synchronous Asynchronous Actuation Time
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

Service Duration Qty

Description	The period of time over which the service is requested.
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

Service Duration UOM Code Sk

Description	Indicate the units in which the service duration quantity is expressed.
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

Service Explicit Tm

Description	The actual time or times referenced by the service repeat frequency. This is used to clarify the service repeat frequency in cases where the actual administration times vary within an institution. If the service request spans more than a single day, use of this time is only practical if the same times of administration occur for each day of the service request.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Instruction Txt

Description	A textual description of the service instruction.
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

Service Occurrence Duration Qty

Description	The period of time for which a single performance of a service is requested. For example an instruction to deliver inhaled medication using a nebulizer for 5 minutes.
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

Service Occurrence Duration UOM Code Sk

Description	The units in which the service occurrence duration quantity is expressed.
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

Service Priority Code Sk

Description	Describes the urgency of the request. For example: Route Stat Urgent
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

Service Relative Time Qty

Description	The interval between schedules for service request or bottle records. When used, this overrides any value in the explicit time instruction.
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

Service Relative Time UOM Code Sk

Description	The units of measure in which the service relative time is expressed. For example: Minutes Hours
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

Service Repeat Frequency Code Sk

Description	The repeating frequency with which the treatment is to be 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

Service Requested Start Ts

Description	The earliest date and time, specified by the requester, that the services should be started. In many cases, however, the start date and time will be implied or will be defined by other information in the service request record (for example, urgency - STAT).
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

Service Requested Stop Ts

Description	The latest date and time, specified by the requester, that the service should be performed. If it has not been performed by this specified time, it should not be performed at all.
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

Service Total Occurrence Cnt

Description	The total number of times a service such as a drug administration should occur as a result of this service request. If both the end date/time and the total occurrences are specified for the service the occurrences would extend beyond the end date/time, then the end date/time takes precedence. Otherwise the number of occurrences takes precedence.
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

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

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 Intervention Recommendation Detail_Pharmacy Intervention_FK

Is Identifying Relationship	true
Child Table	Pharmacy Intervention Medication Recommendation Detail
Child Role Name	suggested by pharmacist on
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 Intervention
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 Intervention Medication Recommendation Detail PK

Key Attribute	Pharmacy Intervention Sk
Key Attribute	Medication Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model