Dimensional Warehouse Model Data Model

Entity

Entity Pharmacy Intervention Recommendation Array

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
AWM Load Info Sk
Current Ind
Dosage Form Cd
Dosage Form Code Sk
Dosage Form Descr
Dose Qty
Dose Quantity UOM Cd
Dose Quantity UOM Code Sk
Dose Quantity UOM Descr
Dose Strength Qty
Dose Strength UOM Cd
Dose Strength UOM Code Sk
Dose Strength UOM Descr
Drug Strength Vol
Drug Strength Volume UOM Cd
Drug Strength Volume UOM Code Sk
Drug Strength Volume UOM Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Medication Dk
Medication Sk
Pharmacy Intervention Dk
Pharmacy Intervention Sk
Recommendation Annotation Seq
Route Cd
Route Code Sk
Route Descr
Service Condition Txt
Service Conjunction Cd
Service Conjunction Code Sk
Service Conjunction Descr
Service Duration Qty
Service Duration UOM Cd
Service Duration UOM Code Sk
Service Duration UOM Descr
Service Explicit Tm
Service Instruction Txt
Service Occurrence Duration Qty
Service Occurrence Duration UOM Cd
Service Occurrence Duration UOM Code Sk
Service Occurrence Duration UOM Descr
Service Priority Cd
Service Priority Code Sk
Service Priority Descr
Service Relative Time Qty
Service Relative Time UOM Cd
Service Relative Time UOM Code Sk
Service Relative Time UOM Descr
Service Repeat Frequency Cd
Service Repeat Frequency Code Sk
Service Repeat Frequency Descr
Service Requested Start Ts
Service Requested Stop Ts
Service Total Occurrence Cnt
Source Code Sk
Standard Medication Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Pharmacy Intervention Recommendation_Medication_FK
Pharmacy Intervention Recommendation_Pharmacy Intervention_FK

Primary Key
Pharmacy Intervention Recommendation Array PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dosage Form Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Dosage Form Descr

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/Description [VARCHAR(250)]
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 Cd

Description	Identifies the units in which the dose quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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 Quantity UOM Descr

Description	Identifies the units in which the dose quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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 Cd

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/Tenant Common Code [VARCHAR(80)]
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

Dose Strength UOM Descr

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/Description [VARCHAR(250)]
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 Cd

Description	Indicates the volumetric unit associated with the drug strength volume.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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

Drug Strength Volume UOM Descr

Description	Indicates the volumetric unit associated with the drug strength volume.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

DWM 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

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

Medication Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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 Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Pharmacy Intervention Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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 Intervention Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

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 Cd

Description	Indicates the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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

Route Descr

Description	Indicates the route of administration. For example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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 Cd

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/Tenant Common Code [VARCHAR(80)]
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 Conjunction Descr

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/Description [VARCHAR(250)]
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 Cd

Description	Indicate the units in which the service duration quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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 Duration UOM Descr

Description	Indicate the units in which the service duration quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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 Cd

Description	The units in which the service occurrence duration quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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 Occurrence Duration UOM Descr

Description	The units in which the service occurrence duration quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Priority Cd

Description	Describes the urgency of the request. For example: Route Stat Urgent
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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 Priority Descr

Description	Describes the urgency of the request. For example: Route Stat Urgent
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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 Cd

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/Tenant Common Code [VARCHAR(80)]
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 Relative Time UOM Descr

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

Service Repeat Frequency Cd

Description	The repeating frequency with which the treatment is to be administered.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
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 Repeat Frequency Descr

Description	The repeating frequency with which the treatment is to be administered.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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/Number Integer [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

Standard Medication Code Sk

Description	A numeric surrogate key used to uniquely identify entities in the Atomic model.
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_Medication_FK

Is Identifying Relationship	false
Child Table	Pharmacy Intervention Recommendation Array
Child Role Name	contains
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Pharmacy Intervention Recommendation_Pharmacy Intervention_FK

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

Key Attribute	Pharmacy Intervention Dk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model