Dimensional Warehouse Model Data Model

Entity

Entity Quality Of Care - Heart And Vascular Disease Analysis

Description

The Analytical Requirement includes Inpatient and Outpatient Quality of Care measures developed by Centers for Medicare & Medicaid Services (CMS).

Dimensions (and sample axes of analysis):
- Calendar (Reporting Year)
- Geographic Area (Region, State)
- Plan Member (Plan, Line of Business(Medicare, Medicaid, Commercial))
- Patient (Age, Gender, Smoker Status, BMI)
- Condition (Acute myocardial Infarction (AMI),Congestive Heart Failure (CHF),Coronary Artery Disease (CAD),Hypertension (HTN)
- Practitioner
- Provider

Attributes
Calendar Dk
Condition Dk
Geographic Area Dk
Mean Time For AMI Outpatients From ED Arrival To ECG
Mean Time To Transfer AMI Outpatients From ED Arrival To Another Facility
Number Of AMI Inpatients Given Aspirin On Arrival
Number Of AMI Inpatients Prescribed ACE/ARB For LVSD At Discharge
Number Of AMI Inpatients Prescribed Aspirin At Discharge
Number Of AMI Inpatients Prescribed Betablockers At Discharge
Number Of AMI Inpatients Prescribed Lipid Lowering Medication At Discharge
Number Of AMI Inpatients Who Received Fibrinolytic Therapy
Number Of AMI Inpatients who Received Fibrinolytic Therapy Within 30 Min Of Hospital Arrival
Number Of AMI Inpatients Who Received PCI After Arrival
Number Of AMI Inpatients Who Received PCI Within 90 Mins Of Arrival
Number Of AMI Outpatients Given Aspirin On Arrival
Number Of AMI Outpatients Who Received ECG Test
Number Of AMI Outpatients Who Received Fibrinolytic Therapy
Number Of AMI Outpatients Who Received Fibrinolytic Therapy Within 30 Min Of Hospital Arrival
Number Of AMI Outpatient Transfers From ED To Another Facility
Number Of CAD Patients Prescribed ACE/ARB Therapy
Number Of CAD Patients Prescribed Antiplatelet Therapy
Number Of CAD Patients Prescribed Betablockers
Number Of CAD Patients With BP Control
Number Of CAD Patients With Evaluation Of Symptoms And Activity
Number Of CAD Patients With Lipid Control
Number Of CAD Patients With Symptom Management
Number Of HF Patients Evaluated For LVS Function
Number Of HF Patients Prescribed ACE/ARB For LVSD at Discharge
Number Of HF Patients Who Received Discharge Instructions
Number Of HTN Patients With BP Control
Number Of Inpatients With AMI Condition
Number Of Outpatients Referred To Cardiac Rehabilitation Program
Number Of Outpatients With AMI Condition
Number Of Patients Coronary Artery Disease (CAD) Condition
Number Of Patients Identified As Tobacco Users
Number Of Patients Screened For Tobacco Use
Number Of Patients With AMI Condition
Number Of Patients With Heart Failure (HF) Condition
Number Of Patients With Hypertension (HTN) Condition
Number Of Tobacco Users Who Received Tobacco-Cessation Counseling
Patient Dk
Percentage Of AMI Inpatients Given Aspirin On Arrival
Percentage Of AMI Inpatients Prescribed ACE/ARB For LVSD At Discharge
Percentage Of AMI Inpatients Prescribed Aspirin At Discharge
Percentage Of AMI Inpatients Prescribed Beta Blockers At Discharge
Percentage Of AMI Inpatients Prescribed Lipid Lowering Medication At Discharge
Percentage Of AMI Inpatients Who Received Fibrinolytic Therapy Within 30 Mins Of Hospital Arrival
Percentage Of AMI Inpatients Who Received PCI Within 90 Mins Of Hospital Arrival
Percentage Of AMI Outpatients Given Aspirin On Arrival
Percentage Of AMI Outpatients Who Received Fibrinolytic Therapy Within 30 Mins Of Hospital Arrival
Percentage Of CAD Patients Prescribed ACE/ARB Therapy
Percentage Of CAD Patients Prescribed Antiplatelet Therapy
Percentage Of CAD Patients Prescribed Betablockers
Percentage Of CAD Patients With BP Control
Percentage Of CAD Patients With Evaluation Of Symptoms And Activity
Percentage Of CAD Patients With Lipid Control
Percentage Of CAD Patients With Symptom Management
Percentage Of HF Patients Evaluated For LVS Function
Percentage Of HF Patients Prescribed ACE/ARB For LVSD At Discharge
Percentage Of HF Patients Who Received Discharge Instructions
Percentage Of HTN Patients With BP Control
Percentage Of Patients Referred To An Outpatient Cardiac Rehabilitation Program
Percentage Of Patients Screened For Tobacco Use
Percentage Of Patients Who Received Tobacco Cessation Counseling
Plan Member Dk
Practitioner Dk
Provider Dk
Total Time For AMI Outpatients To Receive ECG Test After Arrival
Total Time To Transfer AMI Outpatients From ED Arrival To Another Facility

Relationship
Quality Of Care - Heart And Vascular Disease Analysis_Patient Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Provider Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Geographic Area Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Plan Member Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Condition Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Calendar Dimension_FK
Quality Of Care - Heart And Vascular Disease Analysis_Practitioner Dimension_FK

Primary Key
Quality Of Care - Heart And Vascular Disease Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

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

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

Mean Time For AMI Outpatients From ED Arrival To ECG

Description	Average Time (in minutes) from emergency department (ED) arrival to electrocardiogram (ECG) (performed in the ED prior to transfer) for patients with acute myocardial infarction (AMI) or chest pain. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

Mean Time To Transfer AMI Outpatients From ED Arrival To Another Facility

Description	Average time (in minutes) from emergency department (ED) arrival to time of transfer to another facility for acute coronary intervention in acute myocardial infarction (AMI) patients. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

Number Of AMI Inpatients Given Aspirin On Arrival

Description	Total Number of Inpatients with Acute myocardial infarction (AMI) Condition Given Aspirin on Arrival
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

Number Of AMI Inpatients Prescribed ACE/ARB For LVSD At Discharge

Description	Total Number of Acute myocardial infarction (AMI) Inpatients with left ventricular systolic dysfunction (LVSD) who were prescribed an ACEI (angiotensin-converting-enzyme inhibitor) or ARB (angiotensin receptor blockers) at hospital discharge.
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

Number Of AMI Inpatients Prescribed Aspirin At Discharge

Description	Total Number of Inpatients with Acute myocardial infarction (AMI) Condition Prescribed Aspirin at Discharge
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

Number Of AMI Inpatients Prescribed Betablockers At Discharge

Description	Total Number of Inpatients with Acute myocardial infarction (AMI) Condition Prescribed Betablockers at Hospital Discharge
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

Number Of AMI Inpatients Prescribed Lipid Lowering Medication At Discharge

Description	Total number of Acute myocardial infarction (AMI) patients with elevated low-density lipoprotein cholesterol (LDL-c  100 mg/dL or narrative equivalent) who are prescribed a lipid-lowering medication at hospital discharge
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

Number Of AMI Inpatients Who Received Fibrinolytic Therapy

Description	Total Number of Acute myocardial infarction (AMI) Inpatients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the hospital stay.
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

Number Of AMI Inpatients who Received Fibrinolytic Therapy Within 30 Min Of Hospital Arrival

Description	Total Number of Acute myocardial infarction (AMI) Inpatients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the hospital stay and having a time from hospital arrival to fibrinolysis of 30 minutes or less.
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

Number Of AMI Inpatients Who Received PCI After Arrival

Description	Total Number Inpatients with Acute myocardial infarction (AMI) Condition who received Percutaneous Coronary Intervention (PCI) after Hospital arrival.
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

Number Of AMI Inpatients Who Received PCI Within 90 Mins Of Arrival

Description	Total Number of Inpatients with Acute myocardial infarction (AMI) Condition who received Percutaneous Coronary Intervention (PCI) within 90 Mins of Hospital Arrival
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

Number Of AMI Outpatients Given Aspirin On Arrival

Description	Total Number of Emergency Department patients with Acute myocardial infarction (AMI) Condition Given Aspirin on Arrival
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

Number Of AMI Outpatients Who Received ECG Test

Description	Number of Emergency Department acute myocardial infarction (AMI) patients who Received an ECG Test
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

Number Of AMI Outpatients Who Received Fibrinolytic Therapy

Description	Total Number of Emergency Department acute myocardial infarction (AMI) patients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the ED stay
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

Number Of AMI Outpatients Who Received Fibrinolytic Therapy Within 30 Min Of Hospital Arrival

Description	Total Number of Emergency Department acute myocardial infarction (AMI) patients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the ED stay and having a time from ED arrival to fibrinolysis of 30 minutes or less.
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

Number Of AMI Outpatient Transfers From ED To Another Facility

Description	Total Number of Acute myocardial infarction (AMI) Patients transfered from emergency department (ED) to another facility.
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

Number Of CAD Patients Prescribed ACE/ARB Therapy

Description	Total Number of patients with a diagnosis of CAD who also have diabetes mellitus and/or LVSD (LVEF 40%) who were prescribed ACE inhibitor or ARB therapy
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

Number Of CAD Patients Prescribed Antiplatelet Therapy

Description	Total Number of patients with a condition of coronary artery disease seen within a 12 month period who were prescribed aspirin or clopidogrel.
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

Number Of CAD Patients Prescribed Betablockers

Description	Total Number of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12 month period who also have a prior MI or a current or prior LVEF 40% who were prescribed beta-blocker therapy.
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

Number Of CAD Patients With BP Control

Description	Total Number of patients with coronary artery disease from 12 months prior to the measurement period during the measurement year and whose most recent blood pressure is in control (140/90 mmHg).
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

Number Of CAD Patients With Evaluation Of Symptoms And Activity

Description	Total Number of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12 month period for whom there are 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of CAD Patients With Lipid Control

Description	Total Number of patients with a diagnosis of coronary artery disease seen within a 12 month period who have a LDL-C result 100 mg/dL OR patients who have a LDL-C result =100 mg/dL and have a documented plan of care to achieve LDL-C 100mg/dL, including at a minimum the prescription of a statin.
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

Number Of CAD Patients With Symptom Management

Description	Total Number of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12-month period and with results of an evaluation of level of activity AND an assessment for the presence or absence of anginal symptoms, with a plan of care to manage anginal symptoms, if present
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

Number Of HF Patients Evaluated For LVS Function

Description	Total Number of heart failure patients with documentation in the hospital record that left ventricular systolic (LVS) function was evaluated before arrival, during hospitalization, or is planned for after discharge.
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

Number Of HF Patients Prescribed ACE/ARB For LVSD at Discharge

Description	Total Number of Heart failure patients with left ventricular systolic dysfunction (LVSD) who are prescribed an ACEI or ARB at hospital discharge.
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

Number Of HF Patients Who Received Discharge Instructions

Description	Total Number of Heart failure patients discharged home with written instructions or educational material given to patient or caregiver at discharge or during the hospital stay addressing all of the following: activity level, diet, discharge medications, follow-up appointment, weight monitoring, and what to do if symptoms worsen.
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

Number Of HTN Patients With BP Control

Description	Total Number of patients aged 18 years with a diagnosis of hypertension seen within a 12-month period who have a blood pressure 140/90 mm Hg, OR who have a blood pressure 140/90 mm Hg and were prescribed 2 antihypertensive medications during their most recent office visit.
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

Number Of Inpatients With AMI Condition

Description	Total Number of Patients who had Acute myocardial infarction (AMI) Condition and who were admitted to the hospital.
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

Number Of Outpatients Referred To Cardiac Rehabilitation Program

Description	Number of patients evaluated in an outpatient setting who in the previous 12 months have experienced an acute myocardial infarction or chronic stable angina or who have undergone coronary artery bypass (CABG) surgery, a percutaneous coronary intervention (PCI), cardiac valve surgery (CVS), or cardiac transplantation, who have not already participated in an early outpatient cardiac rehabilitation/secondary prevention program for the qualifying event, and who are referred to an outpatient cardiac rehabilitation/secondary prevention program.
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

Number Of Outpatients With AMI Condition

Description	Total Number of Emergency Department Patients who had Acute myocardial infarction (AMI) Condition.
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

Number Of Patients Coronary Artery Disease (CAD) Condition

Description	Total Number of Patients with Coronary Artery Disease (CAD) Condition
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

Number Of Patients Identified As Tobacco Users

Description	The Number of Patients with Acute myocardial infarction (AMI) or Heart Failure (HF) or coronary artery disease (CAD) or Hypertension (HTN) identified as Tobacco Users.
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

Number Of Patients Screened For Tobacco Use

Description	The Number of Patients with Acute myocardial infarction (AMI) or Heart Failure (HF) or coronary artery disease (CAD) or Hypertension (HTN) screened for Tobacco Use.
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

Number Of Patients With AMI Condition

Description	Total Number of Patients with Acute myocardial infarction (AMI) Condition
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

Number Of Patients With Heart Failure (HF) Condition

Description	Total Number of Patients with Heart Failure (HF) Condition
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

Number Of Patients With Hypertension (HTN) Condition

Description	Total Number of Patients with Hypertension Condition
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

Number Of Tobacco Users Who Received Tobacco-Cessation Counseling

Description	The Number of Patients with Acute myocardial infarction (AMI) or Heart Failure (HF) or coronary artery disease (CAD) or Hypertension (HTN) identified as Tobacco Users who have received tobacco-cessation advice.
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

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

Percentage Of AMI Inpatients Given Aspirin On Arrival

Description	Percentage of Acute myocardial infarction (AMI) Inpatients who received aspirin within 24 hours before or after hospital arrival. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Prescribed ACE/ARB For LVSD At Discharge

Description	Percent of Acute myocardial infarction (AMI) Inpatients with left ventricular systolic dysfunction (LVSD) who were prescribed an ACEI (angiotensin-converting-enzyme inhibitor) or ARB (angiotensin receptor blockers) at hospital discharge. For purposes of this measure, LVSD is defined as chart documentation of a left ventricular ejection fraction (LVEF) less than 40% or a narrative description of left ventricular systolic (LVS) function consistent with moderate or severe systolic dysfunction. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Prescribed Aspirin At Discharge

Description	Percentage of Acute myocardial infarction (AMI) Inpatients who were prescribed aspirin at hospital discharge. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Prescribed Beta Blockers At Discharge

Description	Percentage of Acute myocardial infarction (AMI) Inpatients who were prescribed a beta-blocker at hospital discharge Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Prescribed Lipid Lowering Medication At Discharge

Description	Percentage of Acute myocardial infarction (AMI) patients with elevated low-density lipoprotein cholesterol (LDL-c  100 mg/dL or narrative equivalent) who are prescribed a lipid-lowering medication at hospital discharge Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Who Received Fibrinolytic Therapy Within 30 Mins Of Hospital Arrival

Description	Percentage of Acute myocardial infarction (AMI) Inpatients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the hospital stay and having a time from hospital arrival to fibrinolysis of 30 minutes or less. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Inpatients Who Received PCI Within 90 Mins Of Hospital Arrival

Description	Percentage of Acute myocardial infarction (AMI) Inpatients with ST-segment elevation or LBBB(Left bundle branch block) on the ECG(Electrocardiography) closest to arrival time receiving primary PCI during the hospital stay with a time from hospital arrival to PCI of 90 minutes or less Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Outpatients Given Aspirin On Arrival

Description	Percentage of Emergency Department acute myocardial infarction (AMI) patients or chest pain patients (with Probable Cardiac Chest Pain) who received aspirin within 24 hours before ED arrival or prior to transfer. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of AMI Outpatients Who Received Fibrinolytic Therapy Within 30 Mins Of Hospital Arrival

Description	Percentage of Emergency Department acute myocardial infarction (AMI) patients with ST-segment elevation or LBBB on the ECG closest to arrival time receiving Fibrinolytic therapy during the ED stay and having a time from ED arrival to fibrinolysis of 30 minutes or less. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients Prescribed ACE/ARB Therapy

Description	Percentage of patients with a diagnosis of CAD who also have diabetes mellitus and/or LVSD (LVEF 40%) who were prescribed ACE inhibitor or ARB therapy Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients Prescribed Antiplatelet Therapy

Description	Percentage of patients with a condition of coronary artery disease seen within a 12 month period who were prescribed aspirin or clopidogrel. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients Prescribed Betablockers

Description	Percentage of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12 month period who also have a prior MI or a current or prior LVEF 40% who were prescribed beta-blocker therapy. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients With BP Control

Description	Percentage of patients with coronary artery disease from 12 months prior to the measurement period during the measurement year and whose most recent blood pressure is in control (140/90 mmHg). Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients With Evaluation Of Symptoms And Activity

Description	Percentage of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12 month period for whom there are documented results of an evaluation of level of activity AND an evaluation of presence or absence of anginal symptoms in the medical record. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients With Lipid Control

Description	Percentage of patients with a diagnosis of coronary artery disease seen within a 12 month period who have a LDL-C result 100 mg/dL OR patients who have a LDL-C result =100 mg/dL and have a documented plan of care to achieve LDL-C 100mg/dL, including at a minimum the prescription of a statin. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of CAD Patients With Symptom Management

Description	Percentage of patients aged 18 years and older with a diagnosis of coronary artery disease seen within a 12-month period and with results of an evaluation of level of activity AND an assessment for the presence or absence of anginal symptoms, with a plan of care to manage anginal symptoms, if present Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of HF Patients Evaluated For LVS Function

Description	The percent of heart failure patients with documentation in the hospital record that left ventricular systolic (LVS) function was evaluated before arrival, during hospitalization, or is planned for after discharge. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of HF Patients Prescribed ACE/ARB For LVSD At Discharge

Description	Percentage of Heart failure patients with left ventricular systolic dysfunction (LVSD) who are prescribed an ACEI or ARB at hospital discharge. For purposes of this measure, LVSD is defined as chart documentation of a left ventricular ejection fraction (LVEF) less than 40% or a narrative description of left ventricular systolic (LVS) function consistent with moderate or severe systolic dysfunction. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of HF Patients Who Received Discharge Instructions

Description	Percentage of Heart failure patients discharged home with written instructions or educational material given to patient or caregiver at discharge or during the hospital stay addressing all of the following: activity level, diet, discharge medications, follow-up appointment, weight monitoring, and what to do if symptoms worsen. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of HTN Patients With BP Control

Description	Percentage of patients aged 18 years with a diagnosis of hypertension seen within a 12-month period who have a blood pressure 140/90 mm Hg, OR who have a blood pressure 140/90 mm Hg and were prescribed 2 antihypertensive medications during their most recent office visit. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Patients Referred To An Outpatient Cardiac Rehabilitation Program

Description	Percentage of patients evaluated in an outpatient setting who in the previous 12 months have experienced an acute myocardial infarction or chronic stable angina or who have undergone coronary artery bypass (CABG) surgery, a percutaneous coronary intervention (PCI), cardiac valve surgery (CVS), or cardiac transplantation, who have not already participated in an early outpatient cardiac rehabilitation/secondary prevention program for the qualifying event, and who are referred to an outpatient cardiac rehabilitation/secondary prevention program. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Patients Screened For Tobacco Use

Description	The percentage of Patients with Acute myocardial infarction (AMI) or Heart Failure (HF) or coronary artery disease (CAD) or Hypertension (HTN) screened for Tobacco Use. Formula: [A/(B+C+D+E) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Patients Who Received Tobacco Cessation Counseling

Description	Percentage of Patients identified as Tobacco users who have received tobacco-cessation counseling. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Plan Member 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

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

Total Time For AMI Outpatients To Receive ECG Test After Arrival

Description	Total time (in minutes) from emergency department (ED) arrival to ECG for all acute myocardial infarction (AMI) patients.
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

Total Time To Transfer AMI Outpatients From ED Arrival To Another Facility

Description	Total time (in minutes) from emergency department (ED) arrival to time of transfer to another facility for all acute myocardial infarction (AMI) patients.
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

Relationship Details

Quality Of Care - Heart And Vascular Disease Analysis_Patient Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis_Provider Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis_Geographic Area Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Quality Of Care - Heart And Vascular Disease Analysis
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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Quality Of Care - Heart And Vascular Disease Analysis_Condition Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis_Calendar Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis_Practitioner Dimension_FK

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

Quality Of Care - Heart And Vascular Disease Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model