Dimensional Warehouse Model Data Model

Entity

Entity Heart And Vascular Disease Analysis Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to heart and vascular diseases.

Attributes
ACE Or ARB Prescribed At Discharge Ind
Admission Ts
AMI Diagnosis Ts
AMI Ind
Antiplatelet Therapy Ind
Antiplatelet Therapy Ts
Aspirin Given On Arrival Ind
Aspirin Prescribed At Discharge Ind
Betablockers Prescribed At Discharge Ind
BP Observation Ts
BP Value UOM Cd
CAD Diagnosis Ts
CAD Ind
Calendar Dk
Cardiac Rehab Program Referral Ind
Chest Pain Ind
Chest Pain Ts
Condition Dk
Coronary Artery Bypass Graft Ind
Coronary Artery Bypass Graft Ts
Diastolic BP Value Qty
Discharge Instructions Ind
Discharge Ts
ECG Ind
ECG Ts
ED Arrival Ts
ED Departure Ts
Fibrinolytic Therapy Ind
Fibrinolytic Therapy Ts
Geographic Area Dk
Heart Failure Diagnosis Ts
Heart Failure Ind
Hypertension Diagnosis Ts
Hypertension Ind
Inpatient Ind
IVD Diagnosis Ts
IVD Ind
LDLC Value Finding Ts
LDLC Value Qty
LDLC Value UOM Cd
Lipid Lowering Medication Prescribed At Discharge Ind
Load Info Sk
LVSD Evaluation Ts
LVSD Ind
Outpatient Ind
Patient Dk
PCI Procedure Ind
PCI Procedure Ts
Practitioner Dk
Provider Dk
Results For Evaluation Of Symptom And Activity Ind
Symptoms Management Ind
Systolic BP Value Qty
Tenant Sk
Tobacco Cessation Counselling Ind
Tobacco Cessation Counselling Ts
Tobacco Use Finding Ts
Tobacco Use Ind
Transfer To Other Facility Ind
Transfer To Other Facility Ts

Relationship
Heart And Vascular Disease Analysis Snapshot_Patient Dimension_FK
Heart And Vascular Disease Analysis Snapshot_Practitioner Dimension_FK
Heart And Vascular Disease Analysis Snapshot_Provider Dimension_FK
Heart And Vascular Disease Analysis Snapshot_Calendar Dimension_FK
Heart And Vascular Disease Analysis Snapshot_Condition Dimension_FK
Heart And Vascular Disease Analysis Snapshot_Geographic Area Dimension_FK

Primary Key
Heart And Vascular Disease Analysis Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

ACE Or ARB Prescribed At Discharge Ind

Description	Indicator to identify if the patient was prescribed ACEI (angiotensin-converting-enzyme inhibitor) or ARB (angiotensin receptor blockers) at hospital discharge or Departure.
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

Admission Ts

Description	The admit date/time. It is to be used if the event date/time is different than the admit date and time, i.e., a retroactive update. This field is also used to reflect the date/time of an out-patient/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

AMI Diagnosis Ts

Description	Acute myocardial infarction (AMI) Diagnosis Timestamp
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

AMI Ind

Description	Indicator to Show if a patient has been diagnosed with Acute myocardial infarction (AMI).
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

Antiplatelet Therapy Ind

Description	Indicator to identify if patients were prescribed aspirin or clopidogrel.
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

Antiplatelet Therapy Ts

Description	timestamp for prescription of aspirin or clopidogrel.
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

Aspirin Given On Arrival Ind

Description	Indicator to identify if the patient received Aspirin on Hospital arrival
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

Aspirin Prescribed At Discharge Ind

Description	Indicator to identify if the patient was prescribed Aspirin at Discharge or Departure
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

Betablockers Prescribed At Discharge Ind

Description	Indicator to identify if the patient was prescribed Betablockers at Discharge or Departure
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

BP Observation Ts

Description	Date and time when the patient had their blood pressure measured and recorded.
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

BP Value UOM Cd

Description	Blood Pressure Unit of Measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CAD Diagnosis Ts

Description	Coronary Artery Disease (CAD) Condition Diagnosis Timestamp
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

CAD Ind

Description	Indicator to identify if a patient has been diagnosed Coronary Artery Disease (CAD) 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

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

Cardiac Rehab Program Referral Ind

Description	Indicator to Identify if the patient has the been referred to an outpatient cardiac rehabilitation program
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

Chest Pain Ind

Description	The Indicator to identify if a patient is suffering from Chest pains.
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

Chest Pain Ts

Description	Chest Pain timestamp.
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

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

Coronary Artery Bypass Graft Ind

Description	Indicator to identify that a Coronary Artery Bypass Graft Procedure has been performed on 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

Coronary Artery Bypass Graft Ts

Description	Date and time when the Coronary Artery Bypass Graft procedure was performed.
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

Diastolic BP Value Qty

Description	Diastolic Blood Pressure (BP) value for a given period of analysis
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

Discharge Instructions Ind

Description	An indicator identifying if the patient has received written instructions or educational material at discharge
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

Discharge Ts

Description	The discharge date/time. It is to be used if the event date/time is different than the discharge date and time, that is, a retroactive update. This field is also used to reflect the date/time of an outpatient/emergency patient discharge.
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

ECG Ind

Description	Indicator to identify if a patient had electrocardiogram (ECG) test.
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

ECG Ts

Description	Date and time when the patient had the electrocardiogram (ECG) test.
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

ED Arrival Ts

Description	The date and time a patient first arrives at the emergency department (ED). This is not necessarily the same as the patients registration time or triage time. The purpose of this timestamp is to facilitate the recording of the amount of time a patient spends in the ED including any time spent waiting to register or to be seen.
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

ED Departure Ts

Description	The date and time a patient left the Emergency Department (ED) whether through admission, transfer or discharge.
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

Fibrinolytic Therapy Ind

Description	Indicator to show if the patients have received Fibrinolytic Therapy during hospital or ED stay
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

Fibrinolytic Therapy Ts

Description	The time when the patient recieved Fibrinolytic Therapy.
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

Heart Failure Diagnosis Ts

Description	Heart Failure (HF) Diagnosis Timestamp
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

Heart Failure Ind

Description	Indicator to identify if the patient is diagnosed with Heart Failure.
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

Hypertension Diagnosis Ts

Description	Hypertension Diagnosis Timestamp
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

Hypertension Ind

Description	Indicator to Identify if the patient is diagnosed with Hypertension (HTN) 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

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

IVD Diagnosis Ts

Description	ischemic vascular disease (IVD) condition diagnosis Timestamp
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

IVD Ind

Description	Indicator to identify if a patient has been diagnosed ischemic vascular disease (IVD) 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

LDLC Value Finding Ts

Description	Low-density lipoprotein (LDL) test results timestamp.
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

LDLC Value Qty

Description	This measurement may be specific to at least one, Low-Density Lipoprotein Cholesterol (LDL-C) measurement, during the period of analysis.
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

LDLC Value UOM Cd

Description	The unit of measure in which the low-density lipoprotein cholesterol (LDL-C) value quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Lipid Lowering Medication Prescribed At Discharge Ind

Description	Indicator to identify if the patient was given Lipid Lowering medication at Discharge
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

LVSD Evaluation Ts

Description	left ventricular systolic dysfunction (LVSD) Timestamp.
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

LVSD Ind

Description	Indicator identifying if the patient has left ventricular systolic dysfunction (LVSD).
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

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

PCI Procedure Ind

Description	Indicator that identifies if a Patient received a Percutaneous Coronary Intervention (PCI) Procedure.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

PCI Procedure Ts

Description	Time when the Patient received the Percutaneous Coronary Intervention (PCI) Procedure.
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

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

Results For Evaluation Of Symptom And Activity Ind

Description	Indicator to identify documented results of an evaluation of level of activity AND an evaluation of presence or absence of anginal symptoms in the medical record.
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

Symptoms Management Ind

Description	Indicator to identify the Plan of care to manage anginal symptoms if an evaluation of level of activity AND an evaluation of presence or absence of anginal symptoms in the medical record.
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

Systolic BP Value Qty

Description	Systolic Blood Pressure (BP) value for a given period of analysis
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

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

Tobacco Cessation Counselling Ind

Description	An indication of whether patient identified as tobacco users had received cessation intervention through discussion or recommendation of cessation methods and strategies by a qualified healthcare practitioner, during the period of analysis.
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

Tobacco Cessation Counselling Ts

Description	The date and time a patient was counselled on Tobacco Cessation.
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

Tobacco Use Finding Ts

Description	Time stamp for the Tobacco use indication for the patient.
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

Tobacco Use Ind

Description	An indication of whether the Tobacco is used.
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

Transfer To Other Facility Ind

Description	Indicator identifying if a patient has been transfered to another facility.
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

Transfer To Other Facility Ts

Description	Time when the patient is transfered to another facility.
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

Heart And Vascular Disease Analysis Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Heart And Vascular Disease Analysis Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Heart And Vascular Disease Analysis Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Heart And Vascular Disease Analysis Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Heart And Vascular Disease Analysis Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Heart And Vascular Disease Analysis Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Heart And Vascular Disease Analysis 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

Primary Key Details

Heart And Vascular Disease Analysis 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