Dimensional Warehouse Model Data Model

Entity

Entity Pharmacy Order Medication Route Array

Description

The combinations of route, site, administration device and administration method that are prescribed for a pharmacy order.

Attributes
Administration Device Cd
Administration Device Code Sk
Administration Device Descr
Administration Method Cd
Administration Method Code Sk
Administration Method Descr
Administration Site Cd
Administration Site Code Sk
Administration Site Descr
Administration Site Modifier Cd
Administration Site Modifier Code Sk
Administration Site Modifier Descr
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Pharmacy Order Detail Dk
Pharmacy Order Detail Sk
Pharmacy Order Sk
Route Cd
Route Code Sk
Route Descr
Routing Instruction Txt
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Pharmacy Order Medication Route Array_Pharmacy Order Fact_FK

Primary Key
Pharmacy Order Medication Route Array PK

Dependencies

Reverse Dependencies

Attribute Details

Administration Device Cd

Description	Indicates the mechanical device used to aid in the administration of the drug or other treatment. For Example: IV Pump Metered Inhaler Nebulizer PCA Pump
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

Administration Device Code Sk

Description	Indicates the mechanical device used to aid in the administration of the drug or other treatment. For Example: IV Pump Metered Inhaler Nebulizer PCA Pump
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 Device Descr

Description	Indicates the mechanical device used to aid in the administration of the drug or other treatment. For Example: IV Pump Metered Inhaler Nebulizer PCA Pump
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

Administration Method Cd

Description	Identifies the specific method requested for the administration of the drug or treatment to the patient. For Example: Dissolve Chew Dust Insert
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

Administration Method Code Sk

Description	Identifies the specific method requested for the administration of the drug or treatment to the patient. For Example: Dissolve Chew Dust Insert
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 Method Descr

Description	Identifies the specific method requested for the administration of the drug or treatment to the patient. For Example: Dissolve Chew Dust Insert
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

Administration Site Cd

Description	Indicates the body site through which the drug is administered. For Example: Face Mouth Arm
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

Administration Site Code Sk

Description	Indicates the body site through which the drug is administered. For Example: Face Mouth Arm
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 Site Descr

Description	Indicates the body site through which the drug is administered. For Example: Face Mouth Arm
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

Administration Site Modifier Cd

Description	Identifies the modifier which modifies the meaning of the Administration Site.
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

Administration Site Modifier Code Sk

Description	Identifies the modifier which modifies the meaning of the Administration Site.
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 Site Modifier Descr

Description	Identifies the modifier which modifies the meaning of the Administration Site.
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

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

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

Pharmacy Order Detail 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 Order Detail 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

Pharmacy Order 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

Route Cd

Description	Identifies the route of administration. For Example: Apply Externally Inhalation 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	true
Is Derived	false
Is Surrogate Key	false

Route Code Sk

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

Route Descr

Description	Identifies the route of administration. For Example: Apply Externally Inhalation Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
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

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 Order Medication Route Array_Pharmacy Order Fact_FK

Is Identifying Relationship	true
Child Table	Pharmacy Order Medication Route Array
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 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 Order Medication Route Array PK

Key Attribute	Pharmacy Order Detail Dk
Key Attribute	Route Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model