Dimensional Warehouse Model Data Model

Entity

Entity ACO - At Risk Population

Description

ACO Narrative Measure Specifications for the At-Risk Population Domain.

Including; Diabetes, Hypertension, Ischemic Vascular Disease, Heart Failure and Coronary Artery Disease.

Attributes
ACO 22 Diabetes Mellitus: Hemoglobin A1c Control (< 8%)
ACO 23 Diabetes Mellitus: Low Density Lipoprotein (LDL-C) Control in Diabetes Mellitus
ACO 24 Diabetes Mellitus: High Blood Pressure Control in Diabetes Mellitus
ACO 25 Diabetes Mellitus: Tobacco Non Use
ACO 26 Diabetes Mellitus: Daily Aspirin Use for Patients with Diabetes and Ischemic Vascular Disease
ACO 27 Diabetes Mellitus Hemoglobin A1c Poor Control in Diabetes Mellitus
ACO 28-d Number Of Members With Hypertension
ACO 28 Hypertension (HTN) Controlling High Blood Pressure
ACO 28-n Number Of Members Controlling High Blood Pressure
ACO 29 Ischemic Vascular Disease (IVD): Complete Lipid Profile and Low Density Lipoprotein (LDL-C) Control
ACO 30 Ischemic Vascular Disease (IVD): Use of Aspirin or Another Antithrombotic
ACO 31 Heart Failure: Beta-Blocker Therapy for Left Ventricular Systolic Dysfunction (LVSD)
ACO 32 Coronary Artery Disease (CAD): Lipid Control
ACO 33 Coronary Artery Disease: ACE Inhibitor or ARB Therapy for Patients with CAD and Diabetes and/or LVSD
Calendar Dk
Geographic Area Dk
Practitioner Dk
Provider Dk

Relationship
ACO - At Risk Population_Geographic Area Dimension_FK
ACO - At Risk Population_Provider Dimension_FK
ACO - At Risk Population_Practitioner Dimension_FK
ACO - At Risk Population_Calendar Dimension_FK

Primary Key
ACO - At Risk Population PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

ACO 22 Diabetes Mellitus: Hemoglobin A1c Control (< 8%)

Description	ACO 22 (ACO-DM-15) (NQF 0729): Diabetes Composite (All or Nothing Scoring): Diabetes Mellitus: Hemoglobin A1c Control ( 8%) Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 23 Diabetes Mellitus: Low Density Lipoprotein (LDL-C) Control in Diabetes Mellitus

Description	ACO 23 (ACO-DM-14) (NQF 0729): Diabetes Composite (All or Nothing Scoring): Diabetes Mellitus: Low Density Lipoprotein (LDL-C) Control in Diabetes Mellitus Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 24 Diabetes Mellitus: High Blood Pressure Control in Diabetes Mellitus

Description	ACO 24 (ACO-DM-13) (NQF 0729): Diabetes Composite (All or Nothing Scoring): Diabetes Mellitus: High Blood Pressure Control in Diabetes Mellitus Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 25 Diabetes Mellitus: Tobacco Non Use

Description	ACO 25 (ACO-DM-17) (NQF #0729): Diabetes Composite (All or Nothing Scoring): Diabetes Mellitus: Tobacco Non Use Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 26 Diabetes Mellitus: Daily Aspirin Use for Patients with Diabetes and Ischemic Vascular Disease

Description	ACO 26 (ACO-DM-16) (NQF 0729): Diabetes Composite (All or Nothing Scoring): Diabetes Mellitus: Daily Aspirin Use for Patients with Diabetes and Ischemic Vascular Disease Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 27 Diabetes Mellitus Hemoglobin A1c Poor Control in Diabetes Mellitus

Description	The number of members 18-75 years of age with diabetes (type 1 and type 2) who have poor HbA1c control (greater than 9.0%).
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

ACO 28-d Number Of Members With Hypertension

Description	The number of members 18-85 years of age who had a diagnosis of hypertension (HTN).
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

ACO 28 Hypertension (HTN) Controlling High Blood Pressure

Description	The percentage of members 18-85 years of age who had a diagnosis of hypertension (HTN) and whose BP was adequately controlled (140/90) during the measurement year. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. 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

ACO 28-n Number Of Members Controlling High Blood Pressure

Description	The number of members 18-85 years of age who had a diagnosis of hypertension (HTN) and whose BP was adequately controlled (140/90) during the measurement year.
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

ACO 29 Ischemic Vascular Disease (IVD): Complete Lipid Profile and Low Density Lipoprotein (LDL-C) Control

Description	ACO 29 (ACO-IVD-1) (NQF 0075): Ischemic Vascular Disease (IVD): Complete Lipid Profile and Low Density Lipoprotein (LDL-C) Control Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 30 Ischemic Vascular Disease (IVD): Use of Aspirin or Another Antithrombotic

Description	ACO 30 (ACO-IVD-2) (NQF 0068): Ischemic Vascular Disease (IVD): Use of Aspirin or Another Antithrombotic Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 31 Heart Failure: Beta-Blocker Therapy for Left Ventricular Systolic Dysfunction (LVSD)

Description	ACO 31 (ACO-HF-6) (NQF 0083): Heart Failure: Beta-Blocker Therapy for Left Ventricular Systolic Dysfunction (LVSD) Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 32 Coronary Artery Disease (CAD): Lipid Control

Description	ACO 32 (ACO-CAD-2) (NQF #0074): Coronary Artery Disease (CAD): Lipid Control Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

ACO 33 Coronary Artery Disease: ACE Inhibitor or ARB Therapy for Patients with CAD and Diabetes and/or LVSD

Description	ACO 33 (ACO-CAD-7) (NQF 0066): Coronary Artery Disease (CAD): Angiotensin-Converting Enzyme (ACE) Inhibitor or Angiotensin Receptor Blocker (ARB) Therapy for Patients with CAD and Diabetes and/or Left Ventricular Systolic Dysfunction (LVSD) Please visit the CMS website www.cms.gov for the definition of this measure and details of the measure steward and associated copyright.
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

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

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

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

Relationship Details

ACO - At Risk Population_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	ACO - At Risk Population
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

ACO - At Risk Population_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	ACO - At Risk Population
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

ACO - At Risk Population_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	ACO - At Risk Population
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

ACO - At Risk Population_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	ACO - At Risk Population
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

Primary Key Details

ACO - At Risk Population PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model