Dimensional Warehouse Model Data Model

Entity

Entity Medication Management Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to the management of patients' medications in general and medications in relation to certain conditions in particular.

Attributes
ACE Or ARB Medication Prescription Ind
ACE Or ARB Medication Prescription Ts
Admission Ts
Anticonvulsant Medication Prescription Ind
Anticonvulsant Medication Prescription Ts
Calendar Dk
Chronic Renal Failure Diagnosis Ts
Chronic Renal Failure Ind
Condition Dk
Contraindicated Medication Prescription For CRF Ind
Contraindicated Medication Prescription For CRF Ts
Contraindicated Medication Prescription For Dementia Ind
Contraindicated Medication Prescription For Dementia Ts
Contraindicated Medication Prescription For Patient With Falls History Ind
Contraindicated Medication Prescription For Patient With Falls History Ts
Dementia Diagnosis Ts
Dementia Ind
Digoxin Medication Prescription Ind
Digoxin Medication Prescription Ts
Discharge Ts
Diuretic Medication Prescription Ind
Diuretic Medication Prescription Ts
Geographic Area Dk
High Risk Medication Prescription Ind
High Risk Medication Prescription Ts
Inpatient Ind
Load Info Sk
Medication Reconciliation Visit Ind
Medication Reconciliation Visit Ts
Multiple High Risk Medication Prescription Ind
Multiple High Risk Medication Prescription Ts
Outpatient Ind
Patient Dk
Patient Falls Ind
Practitioner Dk
Provider Dk
Tenant Sk
Therapeutic Monitoring Ind
Therapeutic Monitoring Ts

Relationship
Medication Management Snapshot_Patient Dimension_FK
Medication Management Snapshot_Provider Dimension_FK
Medication Management Snapshot_Geographic Area Dimension_FK
Medication Management Snapshot_Calendar Dimension_FK
Medication Management Snapshot_Condition Dimension_FK
Medication Management Snapshot_Practitioner Dimension_FK

Primary Key
Medication Management Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

ACE Or ARB Medication Prescription Ind

Description	Indicator to show whether the patient was prescribed ACEI (angiotensin-converting-enzyme inhibitor) or ARB (angiotensin receptor blockers) medication.
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

ACE Or ARB Medication Prescription Ts

Description	Date and time then the patient was prescribed ACEI (angiotensin-converting-enzyme inhibitor) or ARB (angiotensin receptor blockers) medication.
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

Admission Ts

Description	The date and time a patient was admitted to a healthcare facility, usually as an inpatient. It may also be used to reflect the date and time of an out-patient or emergency patient registration.
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

Anticonvulsant Medication Prescription Ind

Description	Indicator to show whether the patient was prescribed an anticonvulsant medication.
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

Anticonvulsant Medication Prescription Ts

Description	Date and time then the patient was prescribed an anticonvulsant medication.
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

Calendar 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

Chronic Renal Failure Diagnosis Ts

Description	Date and time when the patient was diagnosed with Chronic Renal Failure (CRF).
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

Chronic Renal Failure Ind

Description	Indicator to identify if a patient has been diagnosed with Chronic Renal Failure (CRF).
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

Condition 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

Contraindicated Medication Prescription For CRF Ind

Description	Indicator to identify that a patient who has Chronic Renal Failure (CRF) and who was dispensed an ambulatory prescription for a contraindicated medication such as nonaspirin NSAIDs or Cox-2 Selective NSAIDs.
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

Contraindicated Medication Prescription For CRF Ts

Description	Date and time that the patient was most recently prescribed a medication contraindicated for Chronic Renal Failure (CRF).
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

Contraindicated Medication Prescription For Dementia Ind

Description	Indicator to identify that a patient who has Dementia and who was dispensed an ambulatory prescription for a contraindicated medication such as tricyclic antidepressants or anticholinergic agents.
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

Contraindicated Medication Prescription For Dementia Ts

Description	Date and time that the patient was most recently prescribed a medication contraindicated for dementia.
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

Contraindicated Medication Prescription For Patient With Falls History Ind

Description	Indicator to identify that a patient who has history of falls and who was dispensed an ambulatory prescription for a contraindicated medication such as tricyclic antidepressants or anticholinergic agents.
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

Contraindicated Medication Prescription For Patient With Falls History Ts

Description	Date and time that the patient was most recently prescribed a medication contraindicated for history of falls.
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

Dementia Diagnosis Ts

Description	Date and time when the patient was diagnosed with dementia.
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

Dementia Ind

Description	Indicator to identify if a patient has been diagnosed with dementia.
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

Digoxin Medication Prescription Ind

Description	Indicator to show whether the patient was prescribed Digoxin medication.
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

Digoxin Medication Prescription Ts

Description	Date and time then the patient was prescribed Digoxin medication.
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

Discharge Ts

Description	The date and time a patient was released or discharged from a healthcare facility following an admission.
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

Diuretic Medication Prescription Ind

Description	Indicator to show whether the patient was prescribed a diuretic medication.
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

Diuretic Medication Prescription Ts

Description	Date and time then the patient was prescribed a diuretic medication.
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

Geographic Area 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

High Risk Medication Prescription Ind

Description	Indicator to show whether the patient has recieved at least one high-risk medication.
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

High Risk Medication Prescription Ts

Description	Date and time then the patient was most recently prescribed high risk medications.
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

Inpatient Ind

Description	An Indicator to Identify an Inpatient. Inpatient is a type of encounter in which the patient visits the healthcare facility and stays overnight and is assigned a bed. An encounter groups a number of healthcare events, typically commencing with an admission or transfer into the healthcare facility and ends with a discharge or transfer out.
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

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 Reconciliation Visit Ind

Description	Indicator to identify the patient had a reconciliation visit where their medication was discussed and verified against their current condition.
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

Medication Reconciliation Visit Ts

Description	The date and time of the patient's latest medication reconciliation visit.
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

Multiple High Risk Medication Prescription Ind

Description	Indicator to show whether the patient has recieved more than one high-risk medication.
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

Multiple High Risk Medication Prescription Ts

Description	Date and time then the patient was most recently prescribed multiple high risk medications.
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

Outpatient Ind

Description	An indicator to identify and Outpatient. Outpatient is a type of encounter that takes place when the patient visits the healthcare facility but does not stay overnight and it is not assigned a bed.
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

Patient 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

Patient Falls Ind

Description	Indicator to identify if the patient has an history of falls.
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

Practitioner 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

Provider 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

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

Therapeutic Monitoring Ind

Description	Indicator to identify a patient who is on persistent theapetic medication had at least one therapeutic monitoring event for the therapeutic agent in the measurement year.
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

Therapeutic Monitoring Ts

Description	The date and time of the patient's latest therapeutic monitoring event.
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 Management Snapshot_Patient Dimension_FK

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

Medication Management Snapshot_Provider Dimension_FK

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

Medication Management Snapshot_Geographic Area Dimension_FK

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

Medication Management Snapshot_Calendar Dimension_FK

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

Medication Management Snapshot_Condition Dimension_FK

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

Medication Management Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Medication Management Snapshot
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 Dimension
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 Management Snapshot PK

Key Attribute	Geographic Area Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Condition Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model